YNU_JEUS/app_home/himed/xpapps/pam/pamcomnxp/xp/SMPMO00998_감사자료조회(과별).xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPMO00998" position="absolute 0 0 1280 1024" titletext="자료조회" onload="SMPMO00998_onload">
    <Layouts>
      <Layout>
        <Div id="group1" position="absolute 0 0 1195 25" style="">
          <Layouts>
            <Layout>
              <Static id="caption6" class="tit_1" position="absolute 0 0 189 23" style="" text="자료조회"/>
              <Static id="caption4" class="patient_text_black" position="absolute 922 0 1194 13" style=""/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group5" position="absolute 0 23 1195 68" style="align: top;" class="div_SA">
          <Layouts>
            <Layout>
              <Shape id="line13" class="line_4" linetype="vertical" position="absolute 1056 7 1059 40" style="border: solid #ffe4bb #ffe4bb;" anchor="default"/>
              <Static id="caption21" class="search_name" position="absolute 16 13 102 30" style="" text="조회일자 :"/>
              <Button id="btn_search" class="btn2_letter2" position="absolute 1062 12 1118 34" style="" text="조회" onclick="group5_btn_search_onclick"/>
              <Static id="caption1" class="search_name" position="absolute 331 14 417 31" style="" text="진료과 :"/>
              <Combo innerdataset="ds_init_pam_init_orddeptcd" datacolumn="nm" codecolumn="cd" columncount="-1" rowcount="-1" id="cmb_orddeptcd" position="absolute 405 12 575 31" style="align:center middle;"/>
              <Static id="caption2" class="search_name" position="absolute 586 13 672 30" style="" text="수진구분:"/>
              <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="combo3" position="absolute 670 11 770 30" style="align:center middle;">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">O</Col>
                      <Col id="datacolumn">외래</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">I</Col>
                      <Col id="datacolumn">입원</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption3" position="absolute 205 12 220 32" style="" text="~"/>
              <Calendar id="ipt_fromdd" class="input_s_essential" position="absolute 100 12 192 31" style="" anchor="default"/>
              <Calendar id="ipt_todd" class="input_s_essential" position="absolute 225 12 317 31" style="" anchor="default"/>
              <Button id="button1" class="btn2_letter4" position="absolute 1119 12 1183 34" style="" text="엑셀저장" onclick="group5_button1_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line1" class="line_1" linetype="horizontal" position="absolute 0 65 1195 68" style="" anchor="default"/>
        <Grid id="grd_deptsum" binddataset="ds_main_masterdata" position="absolute 0 68 1195 778" style="">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="150"/>
                <Column size="161"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </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" text="총급여액(변경금액)"/>
                <Cell col="12" text="공단부담금(변경금액)"/>
                <Cell col="13" text="본인부담금(변경금액)"/>
                <Cell col="14" text="비보험액(변경금액)"/>
                <Cell col="15" text="비급여액(변경금액)"/>
                <Cell col="16" text="선택진료비(변경금액)"/>
                <Cell col="17" text="감면액(변경금액)"/>
                <Cell col="18" text="미수액(변경금액)"/>
              </Band>
              <Band id="body">
                <Cell expr="currow + 1"/>
                <Cell col="1" style="align:left middle;" text="bind:depthngnm"/>
                <Cell col="2" displaytype="number" text="bind:minus_payamt" mask="#,##0"/>
                <Cell col="3" displaytype="number" text="bind:org_payamt" mask="#,##0"/>
                <Cell col="4" displaytype="number" text="bind:org_payinsubamt" mask="#,##0"/>
                <Cell col="5" displaytype="number" text="bind:org_payownbamt" mask="#,##0"/>
                <Cell col="6" displaytype="number" text="bind:org_allownbamt" mask="#,##0"/>
                <Cell col="7" displaytype="number" text="bind:org_nopyamt" mask="#,##0"/>
                <Cell col="8" displaytype="number" text="bind:org_specamt" mask="#,##0"/>
                <Cell col="9" displaytype="number" text="bind:org_discamt" mask="#,##0"/>
                <Cell col="10" displaytype="number" text="bind:org_uncoamt" mask="#,##0"/>
                <Cell col="11" displaytype="number" text="bind:payamt" mask="#,##0"/>
                <Cell col="12" displaytype="number" text="bind:payinsubamt" mask="#,##0"/>
                <Cell col="13" displaytype="number" text="bind:payownbamt" mask="#,##0"/>
                <Cell col="14" displaytype="number" text="bind:allownbamt" mask="#,##0"/>
                <Cell col="15" displaytype="number" text="bind:nopyamt" mask="#,##0"/>
                <Cell col="16" displaytype="number" text="bind:specamt" mask="#,##0"/>
                <Cell col="17" displaytype="number" text="bind:discamt" mask="#,##0"/>
                <Cell col="18" displaytype="number" text="bind:uncoamt" mask="#,##0"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_masterdata" 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="minus_payamt" type="STRING" size="256"/>
          <Column id="org_payamt" type="STRING" size="256"/>
          <Column id="org_payinsubamt" type="STRING" size="256"/>
          <Column id="org_payownbamt" type="STRING" size="256"/>
          <Column id="org_allownbamt" type="STRING" size="256"/>
          <Column id="org_nopyamt" type="STRING" size="256"/>
          <Column id="org_specamt" type="STRING" size="256"/>
          <Column id="org_discamt" type="STRING" size="256"/>
          <Column id="org_uncoamt" type="STRING" size="256"/>
          <Column id="payamt" type="STRING" size="256"/>
          <Column id="payinsubamt" type="STRING" size="256"/>
          <Column id="payownbamt" type="STRING" size="256"/>
          <Column id="allownbamt" type="STRING" size="256"/>
          <Column id="nopyamt" type="STRING" size="256"/>
          <Column id="specamt" type="STRING" size="256"/>
          <Column id="discamt" type="STRING" size="256"/>
          <Column id="uncoamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="depthngnm"/>
            <Col id="minus_payamt"/>
            <Col id="org_payamt"/>
            <Col id="org_payinsubamt"/>
            <Col id="org_payownbamt"/>
            <Col id="org_allownbamt"/>
            <Col id="org_nopyamt"/>
            <Col id="org_specamt"/>
            <Col id="org_discamt"/>
            <Col id="org_uncoamt"/>
            <Col id="payamt"/>
            <Col id="payinsubamt"/>
            <Col id="payownbamt"/>
            <Col id="allownbamt"/>
            <Col id="nopyamt"/>
            <Col id="specamt"/>
            <Col id="discamt"/>
            <Col id="uncoamt"/>
          </Row>
        </Rows>
      </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_init_pam" 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_init" 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>
        <Rows>
          <Row>
            <Col id="init"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="orddeptcd" type="STRING" size="256"/>
          <Column id="ordtype" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="orddeptcd"/>
            <Col id="ordtype"/>
            <Col id="fromdd"/>
            <Col id="todd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group5.cmb_orddeptcd" propid="value" datasetid="ds_send_reqdata" columnid="orddeptcd"/>
      <BindItem id="item1" compid="group5.combo3" propid="value" datasetid="ds_send_reqdata" columnid="ordtype"/>
      <BindItem id="item2" compid="group5.ipt_fromdd" propid="value" datasetid="ds_send_reqdata" columnid="fromdd"/>
      <BindItem id="item3" compid="group5.ipt_todd" propid="value" datasetid="ds_send_reqdata" columnid="todd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include "com_commonxp::comm_main.xjs"
include "com_basiccodexp::ZBC001.xjs"
include "pam_pamcomnxp::PAM.xjs"
include "emr_prcpmngtxp::MMO001.xjs"

function SMPMO00998_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	grdf_initGrid(this.grd_deptsum); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 


	//addComboInstance("ds_init_pam_init_orddeptcd"  , "cd^nm", "-^전체", ""); 
	frmf_addComboItem("group5.cmb_orddeptcd","전체", "-", "above");

	dsf_makeValue( ds_send_reqdata, "fromdd", "string",  utlf_getCurrentDate());
	dsf_makeValue( ds_send_reqdata, "todd", "string",  utlf_getCurrentDate());

	dsf_makeValue( ds_send_reqdata, "orddeptcd", "string",  "-");
	dsf_makeValue( ds_send_reqdata, "ordtype", "string",  "O");

	//model.refresh();

}

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

	//if(submit("TRPAO05002")){
	var oParam = {};
		oParam.id          = "TRPAO05002";
		oParam.service     = "pamcomnapp.GamSa";
		oParam.method      = "reqGetMasterDeptSum";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_masterdata=item";
		oParam.async       = false;
		oParam.callback    = "cf_TRPAO05002";

	tranf_submit(oParam);

	if(arErrorCode.pop("TRPAO05002") > -1) {
		//model.refresh();
	}

}

function cf_TRPAO05002(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}


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

// 	var fileName = window.fileDialog("save", ",", false, "과별합계", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");	
// 	grd_deptsum.saveExcel(fileName, "sheet1");	
	
	grdf_exportExcel(this.grd_deptsum, "Sheet1", "과별합계", false, "" , 'user' , true);
	
	
	

}

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