YNU_JEUS/app_home/himed/xpapps/ast/examcurestatsxp/xp/SMAES00700_검사통합예약현황.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAES00700" position="absolute 0 0 1196 765" titletext="검사통합예약현황" onload="SMAES00700_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="검사통합예약현황" class="tit_1" position="absolute 0 0 140 25"/>
        <Grid id="grd_list" taborder="1" binddataset="ds_main_list_item" useinputpanel="false" position="absolute 0 94 1195 764" autofittype="col" selecttype="multirow" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="183"/>
                <Column size="183"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="65"/>
                <Column size="65"/>
                <Column size="75"/>
                <Column size="65"/>
                <Column size="65"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="구분" taborder="undefined"/>
                <Cell col="2" rowspan="2" text="검사실명" taborder="undefined"/>
                <Cell col="3" rowspan="2" text="총처방건수" taborder="undefined"/>
                <Cell col="4" rowspan="2" text="수납건수" taborder="undefined"/>
                <Cell col="5" rowspan="2" text="미수납건수" taborder="undefined"/>
                <Cell col="6" colspan="2" text="미예약건수" taborder="undefined"/>
                <Cell col="8" rowspan="2" text="전화&#10;예약건수" taborder="undefined"/>
                <Cell col="9" colspan="2" text="통합예약건수" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="검사실&#10;예약건수" taborder="undefined"/>
                <Cell col="12" rowspan="2" text="예약실&#10;변경건수" taborder="undefined"/>
                <Cell col="13" rowspan="2" text="검사실&#10;변경건수" taborder="undefined"/>
                <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="전화&#10;예약건수"/>
                <Cell col="22" text="미수납"/>
                <Cell col="23" text="수납"/>
                <Cell col="24" text="검사실&#10;예약건수"/>
                <Cell col="25" text="예약실&#10;변경건수"/>
                <Cell col="26" text="검사실&#10;변경건수"/>
                <Cell row="1" col="6" text="미수납"/>
                <Cell row="1" col="7" text="수납"/>
                <Cell row="1" col="9" text="미수납"/>
                <Cell row="1" col="10" text="수납"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow+1"/>
                <Cell col="1" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:testnm" wordwrap="char" suppress="1" suppressalign="middle,over"/>
                <Cell col="2" displaytype="text" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:testroom" suppress="2" suppressalign="middle,over"/>
                <Cell col="3" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:outprcpcnt"/>
                <Cell col="4" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:rcptcnt"/>
                <Cell col="5" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:unrcptcnt"/>
                <Cell col="6" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:unrcptunrsrvcnt"/>
                <Cell col="7" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:rcptunrsrvcnt"/>
                <Cell col="8" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:telrsrvcnt"/>
                <Cell col="9" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:sytsrsrvunrcptcnt"/>
                <Cell col="10" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:sytsrsrvrcptcnt"/>
                <Cell col="11" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:excuroomrsrvcnt"/>
                <Cell col="12" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:rsrvroomupdtvcnt"/>
                <Cell col="13" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:excuroomupdtcnt"/>
              </Band>
              <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
                <Cell/>
                <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
                <Cell col="3" displaytype="number" text="expr:getSum('outprcpcnt')"/>
                <Cell col="4" displaytype="number" text="expr:getSum('rcptcnt')"/>
                <Cell col="5" displaytype="number" text="expr:getSum('unrcptcnt')"/>
                <Cell col="6" displaytype="number" text="expr:getSum('unrcptunrsrvcnt')"/>
                <Cell col="7" displaytype="number" text="expr:getSum('rcptunrsrvcnt')"/>
                <Cell col="8" displaytype="number" text="expr:getSum('telrsrvcnt')"/>
                <Cell col="9" displaytype="number" text="expr:getSum('sytsrsrvunrcptcnt')"/>
                <Cell col="10" displaytype="number" text="expr:getSum('sytsrsrvrcptcnt')"/>
                <Cell col="11" displaytype="number" text="expr:getSum('excuroomrsrvcnt')"/>
                <Cell col="12" displaytype="number" text="expr:getSum('rsrvroomupdtvcnt')"/>
                <Cell col="13" displaytype="number" text="expr:getSum('excuroomupdtcnt')"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excsave" taborder="2" text="엑셀저장" onclick="btn_excsave_onclick" class="btn7" position="absolute 1119 67 1195 89" anchor="top right"/>
        <Shape id="line1" class="line_10" position="absolute 0 89 1195 95" anchor="left top right"/>
        <Div id="grp_sea" anchor="left top right" taborder="3" style="align: top;" class="div_SA" position="absolute 0 25 1195 65">
          <Layouts>
            <Layout>
              <Static id="caption2" text="조회기간 :" class="search_name" position="absolute 15 12 101 29"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1110 10 1113 30" anchor="top right"/>
              <Button id="btn_sea" taborder="6" text="조회" onclick="grp_sea_btn_sea_onclick" class="btn1" position="absolute 1126 9 1182 31" anchor="top right"/>
              <Calendar id="ipt_fromdd" taborder="0" class="input_default" position="absolute 109 11 217 30" autoselect="true"/>
              <Calendar id="ipt_todd" taborder="1" class="input_default" position="absolute 235 11 343 30" autoselect="true"/>
              <Static id="caption5" text="~" class="search_no_b" position="absolute 220 11 232 28"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption1" text="검사통합예약현황" class="tit_2" position="absolute 0 73 200 90"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="testnm" type="STRING" size="256"/>
          <Column id="testroom" type="STRING" size="256"/>
          <Column id="outprcpcnt" type="STRING" size="256"/>
          <Column id="rcptcnt" type="STRING" size="256"/>
          <Column id="unrcptcnt" type="STRING" size="256"/>
          <Column id="unrsrvcnt" type="STRING" size="256"/>
          <Column id="telrsrvcnt" type="STRING" size="256"/>
          <Column id="sytsrsrvcnt" type="STRING" size="256"/>
          <Column id="itslfcnt" type="STRING" size="256"/>
          <Column id="inrsrvcnt" type="STRING" size="256"/>
          <Column id="totrsrvcnt" type="STRING" size="256"/>
          <Column id="outrsrvcnt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="testnm"/>
            <Col id="testroom"/>
            <Col id="outprcpcnt"/>
            <Col id="rcptcnt"/>
            <Col id="unrcptcnt"/>
            <Col id="unrsrvcnt"/>
            <Col id="telrsrvcnt"/>
            <Col id="sytsrsrvcnt"/>
            <Col id="itslfcnt"/>
            <Col id="inrsrvcnt"/>
            <Col id="totrsrvcnt"/>
            <Col id="outrsrvcnt"/>
          </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="execfromdd" type="STRING" size="256"/>
          <Column id="exectodd" type="STRING" size="256"/>
          <Column id="comparefromdd" type="STRING" size="256"/>
          <Column id="comparetodd" type="STRING" size="256"/>
          <Column id="orddeptcd" type="STRING" size="256"/>
          <Column id="orddrid" type="STRING" size="256"/>
          <Column id="execdeptcd" type="STRING" size="256"/>
          <Column id="execdrid" type="STRING" size="256"/>
          <Column id="suppdeptcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="execfromdd"/>
            <Col id="exectodd"/>
            <Col id="comparefromdd"/>
            <Col id="comparetodd"/>
            <Col id="orddeptcd"/>
            <Col id="orddrid"/>
            <Col id="execdeptcd"/>
            <Col id="execdrid"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_globalinstance" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="instance1" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instance1"/>
          </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="hidden" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="execfromdd"/>
      <BindItem id="item1" compid="grp_sea.ipt_todd" propid="value" datasetid="ds_send" columnid="exectodd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-12-04
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "ast_examcurexp::AEZ0001.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/*-**************************************************************************************
 * Argument			: N/A
 * Description		: 
 ****************************************************************************************/

//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SMAES00700_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	grdf_setGridSort(grd_list); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	lf_aezfSetSuppDeptcd();	//AEZ0001.xjs
	ds_send_globalinstance.setColumn(0, "instance1", frmf_getParameter("AST_DEPTCD"));

	ds_main_list_item.clearData();

	ds_send.setColumn( 0, "suppdeptcd", ds_send_globalinstance.getColumn(0, "instance1"));
	ds_send.setColumn( 0, "execfromdd", utlf_getCurrentDate().toDate().getAddDate(-1, "D").getDateFormat("YYYYMMDD"));
	ds_send.setColumn( 0, "exectodd", utlf_getCurrentDate().toDate().getAddDate(-1, "D").getDateFormat("YYYYMMDD"));
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function grp_sea_btn_sea_onclick(obj:Button, e:ClickEventInfo) {
	ds_main_list_item.clearData();
	var oParam = {};
		oParam.id          = "TRAES00701";
		oParam.service     = "examcurestatsapp.RsrvSysts";
		oParam.method      = "reqGetRsrvSystsCntList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_item=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAES00701";

	tranf_submit(oParam);

	if(arErrorCode.pop("TRAES00701") > -1) {
		ds_main_list_item.keystring = "S:testnm"
	}
}
function cf_TRAES00701(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}

/****************************************************************************************
 * Components		: Button
 * Description		: 엑셀저장
 ****************************************************************************************/
function btn_excsave_onclick(obj:Button, e:ClickEventInfo) {
	if( ds_main_list_item.rowcount > 0 ){
		grdf_exportExcel(grd_list, "Excel", "Sheet1", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}

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