YNU_JEUS/app_home/himed/xpapps/ast/dietstatsxp/xp/SMANS00400_직원급식관리현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANS00400" position="absolute 0 0 1192 783" titletext="직원급식관리현황" oninit="SMANS00400_oninit" onload="SMANS00400_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 1 25 1181 60" align="align:center top;" id="group1" class="div_SA">
          <Layouts>
            <Layout>
              <Static text="조회년월 :" position="absolute 25 11 115 28" id="caption3" class="search_name"/>
              <Shape position="absolute 1092 7 1098 29" linetype="vertical" id="line14" class="line_4"/>
              <MaskEdit position="absolute 115 9 190 28" align="align:center middle;" id="ipt_fromdd" mask="####-##" type="string" maskchar=" " style="align:center middle;" autoselect="true"/>
              <MaskEdit position="absolute 210 9 285 28" align="align:center middle;" id="ipt_todd" mask="####-##" maskchar=" " type="string" style="align:center middle;" autoselect="true"/>
              <Static text="~" position="absolute 195 9 207 26" id="caption11" class="search_n_b"/>
              <Button position="absolute 1110 7 1166 29" id="btn_search" class="btn1" taborder="4" text="조회" onclick="group1_btn_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape position="absolute 1 65 1181 71" linetype="horizontal" id="line2" class="line_10"/>
        <Grid position="absolute 1 70 1181 775" align="align:center middle;" id="grd_data" visible="false" taborder="5" binddataset="ds_main_data">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <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" taborder="undefined"/>
                <Cell col="1" rowspan="2" colspan="2" text="구분" taborder="undefined"/>
                <Cell col="3" rowspan="2" text="caption1" taborder="undefined"/>
                <Cell col="4" rowspan="2" text="caption2" taborder="undefined"/>
                <Cell col="5" rowspan="2" text="caption3" taborder="undefined"/>
                <Cell col="6" rowspan="2" text="caption4" taborder="undefined"/>
                <Cell col="7" rowspan="2" text="caption5" taborder="undefined"/>
                <Cell col="8" rowspan="2" text="caption6" taborder="undefined"/>
                <Cell col="9" rowspan="2" text="caption7" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="caption8" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="caption9" taborder="undefined"/>
                <Cell col="12" rowspan="2" text="caption10" taborder="undefined"/>
                <Cell col="13" rowspan="2" text="caption11" taborder="undefined"/>
                <Cell col="14" rowspan="2" text="caption12" taborder="undefined"/>
                <Cell col="15" rowspan="2" text="계" taborder="undefined"/>
                <Cell col="16" colspan="2" text="비고" taborder="undefined"/>
                <Cell row="1" col="16" text="caption"/>
                <Cell row="1" col="17" text="증감비(%)"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow + 1"/>
                <Cell col="1" text="bind:title"/>
                <Cell col="2" text="bind:cdnm"/>
                <Cell col="3" text="bind:mm1"/>
                <Cell col="4" text="bind:mm2"/>
                <Cell col="5" text="bind:mm3"/>
                <Cell col="6" text="bind:mm4"/>
                <Cell col="7" text="bind:mm5"/>
                <Cell col="8" text="bind:mm6"/>
                <Cell col="9" text="bind:mm7"/>
                <Cell col="10" text="bind:mm8"/>
                <Cell col="11" text="bind:mm9"/>
                <Cell col="12" text="bind:mm10"/>
                <Cell col="13" text="bind:mm11"/>
                <Cell col="14" text="bind:mm12"/>
                <Cell col="15" text="bind:mmsum"/>
                <Cell col="16" text="bind:lastsum"/>
                <Cell col="17" text="bind:difrate"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption6" text="직원급식관리현황" class="tit_1" position="absolute 0 0 200 25"/>
        <Div id="grp_biz" taborder="6" scrollbars="none" position="absolute 5 65 1182 767"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="title" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="mm1" type="STRING" size="256"/>
          <Column id="mm2" type="STRING" size="256"/>
          <Column id="mm3" type="STRING" size="256"/>
          <Column id="mm4" type="STRING" size="256"/>
          <Column id="mm5" type="STRING" size="256"/>
          <Column id="mm6" type="STRING" size="256"/>
          <Column id="mm7" type="STRING" size="256"/>
          <Column id="mm8" type="STRING" size="256"/>
          <Column id="mm9" type="STRING" size="256"/>
          <Column id="mm10" type="STRING" size="256"/>
          <Column id="mm11" type="STRING" size="256"/>
          <Column id="mm12" type="STRING" size="256"/>
          <Column id="mmsum" type="STRING" size="256"/>
          <Column id="lastsum" type="STRING" size="256"/>
          <Column id="difrate" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="title"/>
            <Col id="cdnm"/>
            <Col id="mm1"/>
            <Col id="mm2"/>
            <Col id="mm3"/>
            <Col id="mm4"/>
            <Col id="mm5"/>
            <Col id="mm6"/>
            <Col id="mm7"/>
            <Col id="mm8"/>
            <Col id="mm9"/>
            <Col id="mm10"/>
            <Col id="mm11"/>
            <Col id="mm12"/>
            <Col id="mmsum"/>
            <Col id="lastsum"/>
            <Col id="difrate"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_data" 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="lastfromdd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="lastfromdd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_gridcaption" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="mm1" type="STRING" size="256"/>
          <Column id="mm2" type="STRING" size="256"/>
          <Column id="mm3" type="STRING" size="256"/>
          <Column id="mm4" type="STRING" size="256"/>
          <Column id="mm5" type="STRING" size="256"/>
          <Column id="mm6" type="STRING" size="256"/>
          <Column id="mm7" type="STRING" size="256"/>
          <Column id="mm8" type="STRING" size="256"/>
          <Column id="mm9" type="STRING" size="256"/>
          <Column id="mm10" type="STRING" size="256"/>
          <Column id="mm11" type="STRING" size="256"/>
          <Column id="mm12" type="STRING" size="256"/>
          <Column id="lastyy" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="mm1"/>
            <Col id="mm2"/>
            <Col id="mm3"/>
            <Col id="mm4"/>
            <Col id="mm5"/>
            <Col id="mm6"/>
            <Col id="mm7"/>
            <Col id="mm8"/>
            <Col id="mm9"/>
            <Col id="mm10"/>
            <Col id="mm11"/>
            <Col id="mm12"/>
            <Col id="lastyy"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group1.ipt_fromdd" propid="value" datasetid="ds_send_data" columnid="fromdd"/>
      <BindItem id="item1" compid="group1.ipt_todd" propid="value" datasetid="ds_send_data" columnid="todd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

var arErrorCode 	= new HashArray();

function SMANS00400_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

function SMANS00400_onload(obj:Form, e:LoadEventInfo)
{
	group1.ipt_fromdd.value = utlf_getCurrentDate().substr(0, 6);
	group1.ipt_todd.value = utlf_getCurrentDate().substr(0, 6);
}

function group1_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if (utlf_isNull(ds_send_data.getColumn(0, "fromdd"))){
		sysf_messageBox("조회시작년월은", "I003");		
		group1.ipt_fromdd.setFocus();
		return;
	}
	if (utlf_isNull(ds_send_data.getColumn(0, "todd"))){
		sysf_messageBox("조회종료년월은", "I003");		
		group1.ipt_todd.setFocus();
		return;
	}
	if (utlf_isValidDateTime(ds_send_data.getColumn(0, "fromdd"), "YYYYMM") == false){
		sysf_messageBox("조회 시작년월의 형식이", "E016");		
		group1.ipt_fromdd.setFocus();
		return;
	}
	if (utlf_isValidDateTime(ds_send_data.getColumn(0, "todd"), "YYYYMM") == false){
		sysf_messageBox("조회 종료년월의 형식이", "E016");		
		group1.ipt_todd.setFocus();
		return;
	}
	if (ds_send_data.getColumn(0, "fromdd") > ds_send_data.getColumn(0, "todd")){
		sysf_messageBox("조회 시작년월은 종료년월 보다 클 수", "I004");		
		group1.ipt_fromdd.setFocus();
		return;
	}
	
	var fromdd = ds_send_data.getColumn(0, "fromdd");
	var fromdd2 = fromdd + "01";
	fromdd2 = fromdd2.toDate().getAddDate(-1,"Y").getDateFormat("YYYYMM");
	ds_send_data.setColumn(0, "lastfromdd", fromdd2);
	
	var oParam = {};
		oParam.id          = "TRANS00401";
		oParam.service     = "dietstatsapp.DietStats";
		oParam.method      = "reqGetEmplDietYMStats";
		oParam.inds        = "req=ds_send_data";
		oParam.outds       = "ds_main_data=ret";
		oParam.async       = false;		

	tranf_submit(oParam);
	
	ds_main_data.updateColID("mm01", "mm1");
	ds_main_data.updateColID("mm02", "mm2");
	ds_main_data.updateColID("mm03", "mm3");
	ds_main_data.updateColID("mm04", "mm4");
	ds_main_data.updateColID("mm05", "mm5");
	ds_main_data.updateColID("mm06", "mm6");
	ds_main_data.updateColID("mm07", "mm7");
	ds_main_data.updateColID("mm08", "mm8");
	ds_main_data.updateColID("mm09", "mm9");
	
	//그리드의 caption을 조회년월에 따라 가변적으로 바꿔주기	
	ds_send_gridcaption.clearData();
	ds_send_gridcaption.addRow();
	
	var sdate = ds_send_data.getColumn(0, "fromdd");
	var sdate1 = parseInt(sdate.substr(0, 4))-1;
	var sdate2 = sdate + "01";
	
	//출력물의 caption setting
	var todd = ds_send_data.getColumn(0, "todd");
	for (var i = 1; i <= 12; i++) {
		if (sdate2.toDate().getAddDate(+(i-1),"M").getDateFormat("YYYYMM") <= todd) {
			ds_send_gridcaption.setColumn(0, "mm" + i, sdate2.toDate().getAddDate(+(i-1),"M").getDateFormat("YYYY/MM"));
		}
	}
	ds_send_gridcaption.setColumn(0, "lastyy", sdate1);
	
	var objDOM = rptf_createDOM();														
	rptf_setNodeListToDOM(objDOM, "root/main/data", ds_main_data);								
	rptf_setNodeListToDOM(objDOM, "root/send/gridcaption", ds_send_gridcaption);		
	rptf_setNodeListToDOM(objDOM, "root/send/data", ds_send_data);

	var objParam = new Object();
	objParam.xml_data_XML1 = objDOM.documentElement.source;

	var option = "open=1;save=1;directprint=0;print=0;zoom=0;";	
	rptf_exeReportPreview30(["RPANS00401"],[objParam], option, "", "grp_biz");
}
]]></Script>
  </Form>
</FDL>