YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SMPAS00600_토요진료실적.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPAS00600" position="absolute 0 0 1211 784" titletext="토요진료실적" onload="SMPAS00600_onload">
    <Layouts>
      <Layout>
        <Div id="group3" position="absolute 0 0 1211 25" style="">
          <Layouts>
            <Layout>
              <Static id="caption60" class="tit_1" position="absolute 0 0 183 23" style="align:left middle;font:Dotum,9,bold;" text="토요진료실적"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group2" position="absolute 0 23 1195 63" style="" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption2" class="search_name" position="absolute 10 12 75 29" style="" text="기간 :" anchor="default"/>
              <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1119 10 1122 32" style="border: solid #ffe4bb #ffe4bb;" anchor="top right"/>
              <Button id="btn_search" class="btn1" position="absolute 1126 10 1182 32" style="" text="조회" onclick="group2_btn_search_onclick" anchor="top right"/>
              <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="combo1" visible="false" position="absolute 760 11 860 30" style="" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">ALL</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">IN</Col>
                      <Col id="datacolumn">입원</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">OUT</Col>
                      <Col id="datacolumn">외래</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Button id="button1" class="btn6" visible="false" position="absolute 967 10 1023 32" style="" text="출력" onclick="group2_button1_onclick" anchor="top right"/>
              <Shape id="line3" class="line_4" linetype="vertical" position="absolute 1027 10 1030 32" style="border: solid #ffe4bb #ffe4bb;" anchor="top right"/>
              <Button id="button2" class="btn7" position="absolute 1033 10 1113 32" style="" text="엑셀저장" onclick="group2_button2_onclick" anchor="top right"/>
              <Static id="caption1" class="search_name" position="absolute 665 13 755 30" style="" text="진료구분 :" visible="false" anchor="default"/>
              <Calendar id="ipt_fromdd" class="input_default" taborder="7" position="absolute 75 11 170 30" style="align:center ;" anchor="default" onkeydown="group2_ipt_fromdd_onkeydown" dateformat="yyyy-MM-dd" value="null" autoselect="true" autoskip="true"/>
              <Calendar id="ipt_todd" class="input_default" taborder="7" position="absolute 195 11 295 30" style="align:center ;" anchor="default" onkeydown="group2_ipt_todd_onkeydown" dateformat="yyyy-MM-dd" autoselect="true"/>
              <Static id="caption3" position="absolute 173 14 193 29" style="align:center ;" text="~" anchor="default"/>
              <Static id="caption4" class="search_name" position="absolute 345 12 425 29" style="" text="진료과 :" anchor="default"/>
              <Combo innerdataset="ds_hidden_init_orddeptcd" datacolumn="nm" codecolumn="cd" columncount="-1" rowcount="-1" id="cmb_orddeptcd" position="absolute 425 11 570 30" style="" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="datagrid1" binddataset="ds_main_h_opmi_opmi" position="absolute 0 78 1195 778" style="" ontextchanged="datagrid1_ontextchanged" autoenter="none" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="35"/>
                <Column size="80"/>
                <Column size="120"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="130"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="130"/>
                <Column size="130"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="진료일자"/>
                <Cell col="2" text="진료과"/>
                <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"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+ 1"/>
                <Cell col="1" displaytype="expr:getRowLevel(currow) == 1 ? 'TEXT' : 'date'" style="background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:orddd" subsumtext="합계" mask="expr:getRowLevel(currow) == 1 ? '' : 'yyyy-MM-dd'" suppress="0" suppressalign="first" calendardisplaynulltype="nulltext"/>
                <Cell col="2" style="align:left middle;background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:orddeptcdnm"/>
                <Cell col="3" style="align:left middle;background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:orddridnm"/>
                <Cell col="4" style="align:left middle;background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:jobposcd"/>
                <Cell col="5" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:cnt"/>
                <Cell col="6" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:rcptamt"/>
                <Cell col="7" style="background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:satord"/>
                <Cell col="8" displaytype="number" edittype="masknumber" style="background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:apply"/>
                <Cell col="9" displaytype="number" edittype="masknumber" style="background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:costamt"/>
                <Cell col="10" displaytype="number" edittype="masknumber" style="background:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#ccffcc' : 'white');font:EXPR(getRowLevel(currow)==1 ? 'arial,9,bold' : '');" text="bind:payment"/>
              </Band>
              <Band id="summary">
                <Cell style="background:#99ccffff;background2:#99ccffff;"/>
                <Cell col="1" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="총합계"/>
                <Cell col="2" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;"/>
                <Cell col="3" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;"/>
                <Cell col="4" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;"/>
                <Cell col="5" displaytype="number" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" expr="getSum('cnt')"/>
                <Cell col="6" displaytype="number" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" expr="getSum('rcptamt')"/>
                <Cell col="7" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;"/>
                <Cell col="8" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;"/>
                <Cell col="9" displaytype="number" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" expr="getSum('costamt')"/>
                <Cell col="10" displaytype="number" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" expr="getSum('payment')"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_h_opmi" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <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_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
          <Column id="orddeptcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="ioflag"/>
            <Col id="orddeptcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="init" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_h_opmi_opmi" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="orddd" type="STRING" size="256" prop="TEXT" sumtext="합계"/>
          <Column id="orddeptcdnm" type="STRING" size="256"/>
          <Column id="orddridnm" type="STRING" size="256"/>
          <Column id="jobposcd" type="STRING" size="256"/>
          <Column id="cnt" type="BIGDECIMAL" size="256" prop="SUM"/>
          <Column id="rcptamt" type="BIGDECIMAL" size="256" prop="SUM"/>
          <Column id="satord" type="STRING" size="256"/>
          <Column id="apply" type="STRING" size="256"/>
          <Column id="costamt" type="BIGDECIMAL" size="256" prop="SUM"/>
          <Column id="payment" type="BIGDECIMAL" size="256" prop="SUM"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="orddd"/>
            <Col id="orddeptcdnm"/>
            <Col id="orddridnm"/>
            <Col id="jobposcd"/>
            <Col id="cnt"/>
            <Col id="rcptamt"/>
            <Col id="satord"/>
            <Col id="apply"/>
            <Col id="costamt"/>
            <Col id="payment"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_init_orddeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_orddeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init" 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.combo1" propid="value" datasetid="ds_send" columnid="ioflag"/>
      <BindItem id="item1" compid="group2.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item2" compid="group2.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item3" compid="group2.cmb_orddeptcd" propid="value" datasetid="ds_send" columnid="orddeptcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include 'com_commonxp::comm_main.xjs';
include 'com_basiccodexp::ZBC001.xjs';
include 'com_zipcodexp::ZBP001.xjs';

function SMPAS00600_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	grdf_initGrid(this.datagrid1); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 
	
	
	dsf_makeValue(ds_init, "sess_posinstcd", "string", sysf_getUserInfo("dutplceinstcd"));
	
	var oParam = {};
	oParam.id          = "TRPAMCOM01";
	oParam.service     = "pamcomnapp.PamComn";
	oParam.method      = "reqGetComCD";
	oParam.inds        = "req=ds_init";
	oParam.outds       = "ds_init_disccd=disccd ds_init_insukind=insukind ds_init_suppkind=suppkind ds_init_orddeptcd=orddeptcd ds_init_orddrid=orddrid ds_init_reducd=reducd ds_init_uncocd=uncocd ds_init_proccd=proccd ds_init_subjno=subjno ds_init_rcptflag=rcptflag";
	oParam.async       = false;
	//oParam.callback    = "cf_TRPAMCOM01";
	
	tranf_submit(oParam);
	
	ds_hidden_init_orddeptcd.copyData(ds_init_orddeptcd);
	

	frmf_addComboItem("group2.cmb_orddeptcd","전체","%","above");

	ds_send.setColumn( 0, "orddeptcd"  , "%");

	ds_send.setColumn( 0, "fromdd"  , utlf_getCurrentDate());
	ds_send.setColumn( 0, "todd"     , utlf_getCurrentDate());
	//ds_send.setColumn( 0, "fromdd"  , "20090720");
	//ds_send.setColumn( 0, "todd"     , "20090720");						

	//model.refresh();

}

function fSubTotal() {

	//datagrid1.rebuild();
	
	// 이후에 추가 해야 함.
// 	datagrid1.subtotalposition = "below";
// 	datagrid1.multitotals = true;
//getRowLevel(currow)==1 ? '#ccffcc' : 'white'
// 	datagrid1.subtotal("sum", 1, 5  , "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#ccffcc; color:#0000; font-weight:bold; ", 1, "합계 ", false);
// 	datagrid1.subtotal("sum", 1, 6  , "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#ccffcc; color:#0000; font-weight:bold; ", 1, "합계 ", false);
// 	datagrid1.subtotal("sum", 1, 9  , "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#ccffcc; color:#0000; font-weight:bold; ", 1, "합계 ", false);
// 	datagrid1.subtotal("sum", 1, 10, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#ccffcc; color:#0000; font-weight:bold; ", 1, "합계 ", false);
// 
// 	datagrid1.subtotal("sum", -1, 5  , "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; color:#0000; font-weight:bold; ", 1, "총합계 ", false);
// 	datagrid1.subtotal("sum", -1, 6  , "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; color:#0000; font-weight:bold; ", 1, "총합계 ", false);
// 	datagrid1.subtotal("sum", -1, 9  , "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; color:#0000; font-weight:bold; ", 1, "총합계 ", false);
// 	datagrid1.subtotal("sum", -1, 10, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; color:#0000; font-weight:bold; ", 1, "총합계 ", false);

}		

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

	var fromdd = ds_send.getColumn(0, "fromdd");
	var todd     = ds_send.getColumn(0, "todd");

	var tempdd = todd.toDate().getAddDate(-62,"D").getDateFormat("YYYYMMDD");

	if(fromdd < tempdd) {
		sysf_messageBox("60일 이내만 조회 가능합니다.","I999","");	
		return;
	}					

	//submit("TRPAS00600");
	var oParam = {};
	oParam.id          = "TRPAS00600";
	oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
	oParam.method      = "reqGetSatDayEarn";
	oParam.inds        = "req=ds_send";
	oParam.outds       = "ds_main_h_opmi_opmi=opmi";
	oParam.async       = false;

	tranf_submit(oParam);
	
	
	ds_main_h_opmi_opmi.keystring = "G:orddd";
	ds_main_h_opmi_opmi.reversesubsum = "false"; 
	

	fSubTotal();

}

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

}

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

// 	var fileName = window.fileDialog("save", ",", false, "토요진료실적" + utlf_getCurrentDate(), "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
// 	datagrid1.saveExcel(fileName, "sheet");		
// 	window.exec(fileName);	
				
	grdf_exportExcel(datagrid1, "토요진료실적" + utlf_getCurrentDate(),"Sheet1",  true, "" , 'user' , true);

}

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

}

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

}

function datagrid1_ontextchanged(obj:Grid, e:GridEditTextChangedEventInfo) {

	var payment = 0;

	var cnt =  datagrid1.rows -1;

	for(var a=1; a < datagrid1.rows; a++) {

	payment = parseInt(ds_main_h_opmi_opmi.getColumn(a, "apply")) * parseInt(ds_main_h_opmi_opmi.getColumn(a, "costamt")) ;

	if(ds_main_h_opmi_opmi.getColumn(a, "orddd") =="") continue;

	ds_main_h_opmi.setColumn( a , "payment" , payment);
	}
	fSubTotal();

}

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