YNU_JEUS/app_home/himed/xpapps/pam/planteamstatsxp/xp/SMPAS01330_의사별지정진료수익내역.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml" />
  <Form id="SMPAS01330" position="absolute 0 0 1211 784" titletext="의사별지정진료수익내역" onload="SMPAS01330_onload">
    <Layouts>
      <Layout>
        <Div id="group3" position="absolute 0 0 1211 13" style="">
          <Layouts>
            <Layout>
              <Static id="caption60" class="tit_1" position="absolute 0 0 190 14" style="font:돋움,,돋움;align: middle;" text="의사별지정진료수익내역" />
            </Layout>
          </Layouts>
        </Div>
        <Div id="group2" position="absolute 4 22 1207 57" style="">
          <Layouts>
            <Layout>
              <Shape id="roundrect1" anchor="default" class="roundrect_search" type="roundrectangle" position="absolute 0 0 1202 35" style="border: solid #ffd799 #ffd799;background:#fffbf2  ;" />
              <Static id="caption2" class="search_name" position="absolute 15 9 213 26" style="" text="기간                           ~" />
              <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1130 7 1133 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default" />
              <Button id="btn_search" class="btn1_letter2" position="absolute 1139 7 1195 29" style="" text="조회" onclick="group2_btn_search_onclick" />
              <Calendar id="input7" class="input_default" taborder="7" position="absolute 70 9 190 28" style="" anchor="default" onkeydown="group2_input7_onkeydown" />
              <Calendar id="input1" class="input_default" taborder="7" position="absolute 215 9 335 28" style="" anchor="default" onkeydown="group2_input1_onkeydown" />
              <Radio datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="radio1" position="absolute 595 9 755 28" style="">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" />
                    <Column id="datacolumn" />
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">ALL</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">S</Col>
                      <Col id="datacolumn">특진</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">C</Col>
                      <Col id="datacolumn">일반</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption5" position="absolute 535 11 589 25" style="font:,,bold;" text="선택진료" />
              <Button id="button95" class="btn6_letter4" visible="true" position="absolute 971 7 1051 29" style="" text="액셀저장" onclick="group2_button95_onclick" />
              <Shape id="line1" class="line_4" linetype="vertical" position="absolute 1058 7 1061 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default" />
              <Button id="btn_print" class="btn6_letter2" position="absolute 1070 7 1126 29" style="" text="출력" onclick="group2_btn_print_onclick" />
              <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="combo1" position="absolute 411 9 511 28" style="">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" />
                    <Column id="datacolumn" />
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">Per</Col>
                      <Col id="datacolumn">개인별</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">Par</Col>
                      <Col id="datacolumn">과별</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption1" position="absolute 349 11 403 25" style="font:,,bold;" text="검색조건" />
            </Layout>
          </Layouts>
        </Div>
        <Grid id="datagrid1" binddataset="ds_main_medicalexamamtlist_medicalexamamtstats" position="absolute 5 85 1205 766" style="">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="120" />
                <Column size="85" />
                <Column size="85" />
                <Column size="90" />
                <Column size="100" />
                <Column size="100" />
                <Column size="100" />
                <Column size="100" />
                <Column size="100" />
                <Column size="100" />
                <Column size="100" />
                <Column size="100" />
              </Columns>
              <Rows>
                <Row size="24" band="head" />
                <Row size="24" />
              </Rows>
              <Band id="head">
                <Cell text="진료과" />
                <Cell col="1" text="직위" />
                <Cell col="2" text="의사ID" />
                <Cell col="3" text="의사명" />
                <Cell col="4" text="외래수익" />
                <Cell col="5" text="외래수익" />
                <Cell col="6" text="외래환자수" />
                <Cell col="7" text="외래환자수" />
                <Cell col="8" text="입원수익" />
                <Cell col="9" text="입원수익" />
                <Cell col="10" text="입원환자수" />
                <Cell col="11" text="입원환자수|진료과" />
                <Cell col="12" text="직위" />
                <Cell col="13" text="의사ID" />
                <Cell col="14" text="의사명" />
                <Cell col="15" text="지정진료수익" />
                <Cell col="16" text="의료수익" />
                <Cell col="17" text="특진환자" />
                <Cell col="18" text="일반환자" />
                <Cell col="19" text="지정진료수익" />
                <Cell col="20" text="의료수익" />
                <Cell col="21" text="특진환자" />
                <Cell col="22" text="일반환자" />
              </Band>
              <Band id="body">
                <Cell text="bind:depthngnm" />
                <Cell col="1" text="bind:cdnm" />
                <Cell col="2" text="bind:orddrid" />
                <Cell col="3" text="bind:usernm" />
                <Cell col="4" text="bind:otspecamt" />
                <Cell col="5" text="bind:otordamt" />
                <Cell col="6" text="bind:otspecps" />
                <Cell col="7" text="bind:otnomlps" />
                <Cell col="8" text="bind:inspecamt" />
                <Cell col="9" text="bind:inordamt" />
                <Cell col="10" text="bind:inspecps" />
                <Cell col="11" text="bind:innomlps" />
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption6" position="absolute 7 70 102 90" style="" text="가톨릭대학교  :" />
        <Edit id="output1" position="absolute 100 70 200 89" style="font:,,bold;" anchor="default" readonly="true" />
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_userinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo />
      </Dataset>
      <Dataset id="ds_main_medicalexamamtlist_medicalexamamtstats" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="depthngnm" type="STRING" size="256" />
          <Column id="cdnm" type="STRING" size="256" />
          <Column id="orddrid" type="STRING" size="256" />
          <Column id="usernm" type="STRING" size="256" />
          <Column id="otspecamt" type="STRING" size="256" />
          <Column id="otordamt" type="STRING" size="256" />
          <Column id="otspecps" type="STRING" size="256" />
          <Column id="otnomlps" type="STRING" size="256" />
          <Column id="inspecamt" type="STRING" size="256" />
          <Column id="inordamt" type="STRING" size="256" />
          <Column id="inspecps" type="STRING" size="256" />
          <Column id="innomlps" type="STRING" size="256" />
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="depthngnm"></Col>
            <Col id="cdnm"></Col>
            <Col id="orddrid"></Col>
            <Col id="usernm"></Col>
            <Col id="otspecamt"></Col>
            <Col id="otordamt"></Col>
            <Col id="otspecps"></Col>
            <Col id="otnomlps"></Col>
            <Col id="inspecamt"></Col>
            <Col id="inordamt"></Col>
            <Col id="inspecps"></Col>
            <Col id="innomlps"></Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_medicalexamamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo />
      </Dataset>
      <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="fromdata" type="STRING" size="256" />
          <Column id="todata" type="STRING" size="256" />
          <Column id="datagubun" type="STRING" size="256" />
          <Column id="erdata" type="STRING" size="256" />
          <Column id="dcgubun" type="STRING" size="256" />
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdata"></Col>
            <Col id="todata"></Col>
            <Col id="datagubun">Per</Col>
            <Col id="erdata">1</Col>
            <Col id="dcgubun">A</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="fromdata" type="STRING" size="256" />
          <Column id="todata" type="STRING" size="256" />
          <Column id="datagubun" type="STRING" size="256" />
          <Column id="erdata" type="STRING" size="256" />
          <Column id="dcgubun" type="STRING" size="256" />
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo />
      </Dataset>
      <Dataset id="ds_main_medicalsumlist_medicalsumstats" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="depthngnm" type="STRING" size="256" />
          <Column id="cdnm" type="STRING" size="256" />
          <Column id="orddrid" type="STRING" size="256" />
          <Column id="usernm" type="STRING" size="256" />
          <Column id="otspecamt" type="STRING" size="256" />
          <Column id="otordamt" type="STRING" size="256" />
          <Column id="otspecps" type="STRING" size="256" />
          <Column id="otnomlps" type="STRING" size="256" />
          <Column id="inspecamt" type="STRING" size="256" />
          <Column id="inordamt" type="STRING" size="256" />
          <Column id="inspecps" type="STRING" size="256" />
          <Column id="innomlps" type="STRING" size="256" />
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="depthngnm">총계</Col>
            <Col id="cdnm"></Col>
            <Col id="orddrid"></Col>
            <Col id="usernm"></Col>
            <Col id="otspecamt"></Col>
            <Col id="otordamt"></Col>
            <Col id="otspecps"></Col>
            <Col id="otnomlps"></Col>
            <Col id="inspecamt"></Col>
            <Col id="inordamt"></Col>
            <Col id="inspecps"></Col>
            <Col id="innomlps"></Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_userinfo_info" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="user" type="STRING" size="256" />
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="user"></Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_medicalsumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo />
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.input7" propid="value" datasetid="ds_main_search" columnid="fromdata" />
      <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_main_search" columnid="todata" />
      <BindItem id="item2" compid="group2.radio1" propid="value" datasetid="ds_main_search" columnid="dcgubun" />
      <BindItem id="item3" compid="group2.combo1" propid="value" datasetid="ds_main_search" columnid="datagubun" />
      <BindItem id="item4" compid="output1" propid="value" datasetid="ds_main_hospitalname_codename" columnid="cenm" />
    </Bind>
    <Script type="xscript4.0"><![CDATA[function SMPAS01330_onload(obj:Form, e:LoadEventInfo) {

//				submit("TRPAS00001");



				var vToday = new Date();
				var tmpYear = vToday.getYear();
				var tmpMonth = vToday.getMonth()+1;
				var tmpDate = vToday.getDate();

				if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
				if (tmpDate < 10) { tmpDate = "0"+tmpDate; }
				ds_main_search.setColumn( 0, "fromdata", tmpYear+""+tmpMonth+""+tmpDate);
				ds_main_search.setColumn( 0, "todata", tmpYear+""+tmpMonth+""+tmpDate);

				//Rexport에 출력날자를 보여주기위한 데이터 저장
				dsf_makeValue( ds_main_tmp_print, "date", "string", "" );
				ds_main_tmp_print_date.copyData(ds_main_search_fromdata); 
				ds_main_tmp_print.setColumn( 0, "date", ds_main_search.getColumn(0, "fromdata"));

//group2.input7.refresh();

//group2.input1.refresh();

//				submit("TRPAS01332");
var oParam = {};
    oParam.id          = "TRPAS01332";
    oParam.service     = "planteamstatsapp.planTeamOrdStats";
    oParam.method      = "reqGetInterRecDusList";
    oParam.inds        = "req=ds_";
    oParam.outds       = "ds_=codename";
    oParam.async       = false;
    oParam.callback    = "cf_TRPAS01332";

tranf_submit(oParam);
/*
function cf_TRPAS01332(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
}
function cf_TRPAS01332(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}
arErrorCode.pop("TRPAS01332") > -1
arErrorCode.pop("TRPAS01332") < 0
*/


				ds_main_hospitalname_codename.setColumn( 0, "cenm",ds_main_hospitalname_codename.getColumn(0, "cenm"));

//model.refresh();

				//데이터 Sorting 소계 (문제로 인해수 지음)
				//datagrid1.explorerbar = "sort";

}

include '../../.._com_commonweb_js_common.js'
include '../../.._com_commonweb_js_utilHelper.js'
include '../../.._com_commonweb_js_tfHelper.js'
include '../../.._com_commonweb_js_dateHelper.js'
include '../../.._com_commonweb_js_numericHelper.js'
include '../../.._com_commonweb_js_stringHelper.js'
include '../../.._com_basiccodeweb_js_ZBC001.js'
include '../../.._com_zipcodeweb_js_ZBP001.js'

function group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {

						var  fromdata =  ds_main_search.getColumn(0, "fromdata");
						var  todata     =  ds_main_search.getColumn(0, "todata");
						if(fromdata==""||fromdata==null){
							sysf_messageBox("시작일을 입력","E007");
							group2.input7.setFocus();
							return false;
						}
						if(todata==""|| todata==null){
							sysf_messageBox("끝일을 입력","E007");
							group2.input1.setFocus();
							return false;
						}
						if(fromdata > todata){
							sysf_messageBox("시작일이 끝일자보다 클수 ", "C001")
							return false;
						}else{
							ds_send.setColumn( 0, "fromdata",ds_main_search.getColumn(0, "fromdata"));	
							ds_send.setColumn( 0, "todata",ds_main_search.getColumn(0, "todata"));			
							ds_send.setColumn( 0, "datagubun",ds_main_search.getColumn(0, "datagubun"));			
							ds_send.setColumn( 0, "erdata",ds_main_search.getColumn(0, "erdata"));
							ds_send.setColumn( 0, "dcgubun",ds_main_search.getColumn(0, "dcgubun"));			

							//로드값이 있을때  엑셀저장여부 버튼 생성여부
							var nodelist = bind1.nodeset;
							if(nodelist.length>0){
								group2.line1.visible  =true;
								group2.button95.visible = true;
							}else{
								group2.line1.visible  =false;
								group2.button95.visible = false;	
							}

							ds_main_medicalexamamtlist.clearData(); ds_main_medicalexamamtlist.addRow();
							ds_main_medicalexamamtlist.clearData();
							dsf_makeValue( ds_main, "medicalexamamtlist", "string", "" );

//							submit("TRPAS01331");
var oParam = {};
    oParam.id          = "TRPAS013301";
    oParam.service     = "planteamstatsapp.planTeamOrdStats";
    oParam.method      = "reqGetDocSpecList";
    oParam.inds        = "req=ds_";
    oParam.outds       = "ds_=medicalexamamtstats";
    oParam.async       = false;
    oParam.callback    = "cf_TRPAS013301";

tranf_submit(oParam);
/*
function cf_TRPAS013301(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
}
function cf_TRPAS013301(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}
arErrorCode.pop("TRPAS013301") > -1
arErrorCode.pop("TRPAS013301") < 0
*/



							//서브토탈 소계값 출력그리드 위치 (“above:상단에 삽입  “below: 하단에 삽입)
							datagrid1.subtotalposition="below"; 

							//데이터그리드 컬럼개수구하기
							var cols = datagrid1.cols-datagrid1.fixedCols;

							//서브토탈  초기화 subtotal("clear":초기화)
							datagrid1.subtotal("clear", 0, i, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 0, "소계", true); 

							//총계합
							ds_main_medicalexamamtlist_medicalexamamtstats.copyData(ds_main_medicalsumlist_medicalsumstats); 	

							//서브미션2회이상 할때 데이터 그리그 초기화  * 단 rebuild 했을경우 서브토탈이 Node에 없기때문에 나오지 않음
							datagrid1.rebuild();

							//서브토탈 subtotal("sum":합계    0:기준열  i:합계위치) **기타 인자값은 help참조 
							var datagubn = ds_main_search.getColumn(0, "datagubun");

							if (datagubn == 'Per') {
								for( var i = 4; i < cols; i++ ) {
									datagrid1.subtotal("sum", 0, i, "format:#,###; roundmode:round; roundpostion:2", "background-color:#daecfd; color:#333333; font-weight:soild; ", 0, "소계", true);
								}
							}

							//소계 및 통계 datagrid의 cell에서 merge 
							var rows = datagrid1.rows-datagrid1.fixedRows;
							for(var i=0;i<=rows;i++){
								var value = datagrid1.valueMatrix(i+1,0);
								if(value =="소계" || value=="총계"){
									datagrid1.mergeByFree(i+1,0,i+1,3);	
								}else{
								}
							}
							//subtotal()함수를 쓰면 맨 밑에 총계의 소계가 또 나오는데 그걸 삭제 해주는 함수
							if (datagubn == 'Per') datagrid1.removeRow(false)
							//datagrid 재 생성

//datagrid1.refresh();

						}	

}

function group2_input7_onkeydown(obj:Calendar, e:KeyEventInfo) {

								if( event.keyCode == 13 ) {
									var pCurTargetObj = event.ptarget.parent;

									if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
										event.keyCode = 9;
										pCurTargetObj.dispatch("onkeydown");
									}
									else {
										event.keyCode = 9;	
									}
								}
								event.stopPropagation();							

}

function group2_input1_onkeydown(obj:Calendar, e:KeyEventInfo) {

								if( event.keyCode == 13 ) {

									var pCurTargetObj = event.ptarget.parent;

									if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
										event.keyCode = 9;
										pCurTargetObj.dispatch("onkeydown");
									}
									else {
										event.keyCode = 9;	
									}
								}
								event.stopPropagation();							

}

function group2_button95_onclick(obj:Button, e:ClickEventInfo) {

					var vToday = new Date();
					var tmpYear = vToday.getYear();
					var tmpMonth = vToday.getMonth()+1;
					var tmpDate = vToday.getDate();

//					 ds_documenttitle.setColumn( 0, "title",document.title);
//                                   
//model.refresh();

//					 var  subjectTitle = ds_documenttitle.getColumn(0, "title");

					//엑셀저장 여부(타이틀별)
					//강제 이름을 지정해야 서버에서 제대로 보입니다.
					var fileName = window.fileDialog("save", "", false, "의사별지정진료수익내역"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");

						if (fileName != "")
						{
							datagrid1.saveExcel(fileName, "의사별지정진료수익내역"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
						}

}

function group2_btn_print_onclick(obj:Button, e:ClickEventInfo) {

						//보고서 출력 exeReportPreview("RTPAS00160" : 보고서ID값 , "XMLSTR" :보고서출력방법(xml형태)) 
    var objDOM = rptf_createDOM();
    var objParam = new Object();
    rptf_setNodeListToDOM(objDOM, "/root/XXX" , ds_XXX);
    objParam.xml_data_XML1 	= objDOM.documentElement.source;
    var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
    rptf_exeReportPreview30(["RPPAS01331"],[objParam], option);	

}

]]></Script>
  </Form>
</FDL>