YNU_JEUS/app_home/himed/xpapps/sts/stspamxp/xp/SMSTP01500_진료예약통계.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMSTP01500" position="absolute 0 0 1199 783" titletext="진료예약 월별 통계" onload="SMSTP01500_onload" oninit="SMSTP01500_oninit">
    <Layouts>
      <Layout>
        <Div id="group4" position="absolute 0 25 1195 65" style="" class="div_SA">
          <Layouts>
            <Layout>
              <Button id="btn_search" class="btn1_letter2" position="absolute 1053 10 1109 32" style="border: solid transparent transparent;color:transparent;background:_gradation URL(../../.._com_commonweb_images_btn1_letter2.gif) ;" text="조회" onclick="group4_btn_search_onclick" anchor="top right"/>
              <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1038 7 1041 33" style="border: solid #ffe4bb #ffe4bb;" anchor="top right"/>
              <Static id="caption1" class="search_name" position="absolute 10 12 108 29" style="" text="조회기간" anchor="default"/>
              <Static id="caption3" class="search_name" position="absolute 338 12 424 29" style="" text="조회구분" anchor="default"/>
              <Static id="caption2" position="absolute 195 11 215 31" style="" text="~" anchor="default"/>
              <Calendar id="ipt_fromdd" class="input_search" mask="yyyy-mm-dd" position="absolute 89 10 187 29" style="align:center ;" anchor="default" onkillfocus="group4_ipt_fromdd_onkillfocus" autoskip="true" autoselect="true"/>
              <Calendar id="ipt_todd" class="input_search" mask="yyyy-mm-dd" position="absolute 211 11 309 30" style="align:center ;" anchor="default" onkillfocus="group4_ipt_todd_onkillfocus"/>
              <Radio id="rdo_dataflag" taborder="1" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 425 10 640 30" style="align: middle;" anchor="default" columncount="-1" rowcount="-1">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">진료과별</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">진료의사별</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="grd_monthlist" binddataset="ds_main_month_monthlist" class="datagrid4" position="absolute 0 93 1195 775" style="" autoenter="select" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="진료과" 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" rowspan="2" text="합계" taborder="undefined"/>
                <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 row="1" col="7" text="부도율"/>
                <Cell row="1" col="8"/>
                <Cell row="1" col="9"/>
                <Cell row="1" col="10"/>
                <Cell row="1" col="11"/>
                <Cell row="1" col="12"/>
                <Cell row="1" col="13"/>
                <Cell row="1" col="14"/>
              </Band>
              <Band id="body">
                <Cell style="align:center middle;" text="bind:orddeptnm" wordwrap="word" suppress="1" suppressalign="middle,over"/>
                <Cell col="1" text="bind:orddrnm" suppress="2" suppressalign="middle,over"/>
                <Cell col="2" text="bind:lrgitem"/>
                <Cell col="3" displaytype="number" text="bind:new_cnt"/>
                <Cell col="4" displaytype="number" text="bind:first_cnt"/>
                <Cell col="5" displaytype="number" text="bind:re_cnt"/>
                <Cell col="6" displaytype="number" text="bind:tot_cnt"/>
                <Cell col="7" displaytype="number" text="bind:rsrv_rat"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line3" class="line_10" linetype="horizontal" position="absolute 0 81 1195 101" style="" anchor="left top right"/>
        <Static id="caption46" class="tit_2" position="absolute 0 72 151 94" style="" text="진료예약 월별 통계"/>
        <Static id="caption6" text="진료예약 월별 통계" class="tit_1" position="absolute 0 0 216 25"/>
        <Button id="btn_search" taborder="1" text="조회" onclick="group4_button2_onclick" class="btn1" position="absolute 1051 35 1107 56" anchor="top right"/>
        <Button id="btn_excel" taborder="2" text="엑셀저장" onclick="btn_excel_onclick" class="btn7" position="absolute 1112 35 1192 56" anchor="top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="dataflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="dataflag">1</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_month_monthlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="orddeptnm" type="STRING" size="256" sumtext="진료과"/>
          <Column id="orddrnm" type="STRING" size="256" sumtext="진료의사"/>
          <Column id="lrgitem" type="STRING" size="256" sumtext="대분류"/>
          <Column id="new_cnt" type="STRING" size="256" sumtext="28일 오후 환자수"/>
          <Column id="first_cnt" type="STRING" size="256" sumtext="29일 오전 환자수"/>
          <Column id="re_cnt" type="STRING" size="256" sumtext="29일 오후 환자수"/>
          <Column id="tot_cnt" type="STRING" size="256" sumtext="30일 오전 환자수"/>
          <Column id="rsrv_rat" type="STRING" size="256" sumtext="30일 오후 환자수"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.rdo_dataflag" propid="value" datasetid="ds_send" columnid="dataflag"/>
      <BindItem id="item1" compid="group4.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item2" compid="group4.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-05-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

function SMSTP01500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMSTP01500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_monthlist);
	
	ds_send.setColumn(0, "fromdd", utlf_getCurrentDate());
	ds_send.setColumn(0, "todd", utlf_getCurrentDate());
}

function group4_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRSTP01501";
		oParam.service     = "stspamapp.StsPam";
		oParam.method      = "reqGetMonthRsrvSTS";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_month_monthlist=monthlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRSTP01501";

	tranf_submit(oParam);
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	var xlsTitle = "진료예약 월별통계_" + group4.rdo_dataflag.text+"("+group4.ipt_fromdd.text+ "~" +group4.ipt_todd.text+")";
	grdf_exportExcel(grd_monthlist, xlsTitle, xlsTitle, "true", "", "");
}
]]></Script>
  </Form>
</FDL>