YNU_JEUS/app_home/himed/xpapps/ast/dietstatsxp/xp/SMANS00300_직원식통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANS00300" position="absolute 0 0 1184 805" titletext="직원식통계" oninit="SMANS00300_oninit" onload="SMANS00300_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 10 115 27" id="caption3" class="search_name"/>
              <Shape position="absolute 1092 7 1098 29" linetype="vertical" id="line14" class="line_4"/>
              <MaskEdit position="absolute 115 8 190 27" align="align:center middle;" id="ipt_yyyymm" mask="####-##" maskchar=" " type="string" style="align:center middle;"/>
              <Button position="absolute 193 10 206 25" id="btn_before" class="icon_pre" text="" onclick="group1_btn_before_onclick"/>
              <Button position="absolute 208 10 221 25" id="btn_next" class="icon_next" text="" onclick="group1_btn_next_onclick"/>
              <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 62 1181 68" linetype="vertical" id="line2" class="line_1"/>
        <Grid position="absolute 1 70 801 745" id="grd_data" visible="false" binddataset="ds_grd_data">
          <Formats>
            <Format id="default">
              <Columns>
                <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="70"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="일자"/>
                <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 row="1" text="일자"/>
                <Cell row="1" col="1" text="ID카드"/>
                <Cell row="1" col="2" text="현금"/>
                <Cell row="1" col="3" text="공용"/>
                <Cell row="1" col="4" text="소계"/>
                <Cell row="1" col="5" text="성의"/>
                <Cell row="1" col="6" text="성모"/>
                <Cell row="1" col="7" text="의정부"/>
                <Cell row="1" col="8" text="부천"/>
                <Cell row="1" col="9" text="기타"/>
                <Cell row="1" col="10" text="소계"/>
                <Cell row="1" col="11" text="총계"/>
              </Band>
              <Band id="body">
                <Cell text="bind:appdd"/>
                <Cell col="1" text="bind:psnno1"/>
                <Cell col="2" text="bind:psnno2"/>
                <Cell col="3" text="bind:psnno3"/>
                <Cell col="4" text="bind:insum"/>
                <Cell col="5" text="bind:psnno4"/>
                <Cell col="6" text="bind:psnno5"/>
                <Cell col="7" text="bind:psnno6"/>
                <Cell col="8" text="bind:psnno7"/>
                <Cell col="9" text="bind:psnno8"/>
                <Cell col="10" text="bind:outsum"/>
                <Cell col="11" text="bind:totalsum"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption6" text="직원식통계" class="tit_1" position="absolute 0 0 200 25"/>
        <Div id="grp_biz" taborder="1" scrollbars="none" position="absolute 5 65 1178 791"/>
      </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="appdd" type="STRING" size="256"/>
          <Column id="psnno1" type="STRING" size="256"/>
          <Column id="psnno2" type="STRING" size="256"/>
          <Column id="psnno3" type="STRING" size="256"/>
          <Column id="insum" type="STRING" size="256"/>
          <Column id="psnno4" type="STRING" size="256"/>
          <Column id="psnno5" type="STRING" size="256"/>
          <Column id="psnno6" type="STRING" size="256"/>
          <Column id="psnno7" type="STRING" size="256"/>
          <Column id="psnno8" type="STRING" size="256"/>
          <Column id="outsum" type="STRING" size="256"/>
          <Column id="totalsum" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="appdd"/>
            <Col id="psnno1"/>
            <Col id="psnno2"/>
            <Col id="psnno3"/>
            <Col id="insum"/>
            <Col id="psnno4"/>
            <Col id="psnno5"/>
            <Col id="psnno6"/>
            <Col id="psnno7"/>
            <Col id="psnno8"/>
            <Col id="outsum"/>
            <Col id="totalsum"/>
          </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="yyyymm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="yyyymm"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group1.ipt_yyyymm" propid="value" datasetid="ds_send_data" columnid="yyyymm"/>
    </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 SMANS00300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

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

function group1_btn_before_onclick(obj:Button,  e:ClickEventInfo)
{
	var dd = ds_send_data.getColumn(0, "yyyymm") + "01";
	dd = dd.toDate().getAddDate(-1, "M");
	dd = dd.getDateFormat("YYYYMM");
	ds_send_data.setColumn(0, "yyyymm", dd);
}

function group1_btn_next_onclick(obj:Button,  e:ClickEventInfo)
{
	var dd = ds_send_data.getColumn(0, "yyyymm") + "01";
	dd = dd.toDate().getAddDate(1, "M");
	dd = dd.getDateFormat("YYYYMM");
	ds_send_data.setColumn(0, "yyyymm", dd);
}

function group1_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if (utlf_isNull(ds_send_data.getColumn(0, "yyyymm"))){
		sysf_messageBox("조회년월은", "I003");		
		group1.ipt_yyyymm.setFocus();
		return;
	}
	if (utlf_isValidDateTime(ds_send_data.getColumn(0, "yyyymm"), "YYYYMM") == false){
		sysf_messageBox("조회년월의 형식이", "E016");		
		group1.ipt_yyyymm.setFocus();		
		return;
	}
	
	var oParam = {};
		oParam.id          = "TRANS00301";
		oParam.service     = "dietstatsapp.DietStats";
		oParam.method      = "reqGetEmplDietStats";
		oParam.inds        = "req=ds_send_data";
		oParam.outds       = "ds_main_data=ret";
		oParam.async       = false;		

	tranf_submit(oParam);
	
	ds_main_data.addColumn("insum", "string");
	ds_main_data.addColumn("outsum", "string");
	ds_main_data.addColumn("totalsum", "string");
	
 	fSum();     //계,소계,총계 구하기

	var objDOM = rptf_createDOM();														
	rptf_setNodeListToDOM(objDOM, "root/main/data", ds_main_data);									
	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(["RPANS00301"],[objParam], option, "", "grp_biz");	
}

function fSum() {				
	ds_main_data.setColumn(ds_main_data.rowcount - 2, "appdd", "계");
	ds_main_data.setColumn(ds_main_data.rowcount - 1, "appdd", "전월");

	//월계 구하기
	var val = 0;
	var temp = 0;
	for (var k = 1; k <= 8; k++) {
		for (var i = 0; i < ds_main_data.rowcount - 2; i++) {
			val = ds_main_data.getColumn(i, "psnno" + k);
			if (val > 0) {
				temp = parseInt(temp) + parseInt(val);
			}
		}
		ds_main_data.setColumn(ds_main_data.rowcount - 2, "psnno" + k, temp);   //당월 계
		temp = 0;
	}
	
	//일별 소계,총계 구하기
	var val = 0;
	var temp = 0;
	var sum = 0;
	for (var i = 0; i < ds_main_data.rowcount; i++) {
		for (var k = 1; k <= 8; k++) {
			val = ds_main_data.getColumn(i, "psnno" + k);
			if (!utlf_isNull(val)) {
				temp = parseInt(temp) + parseInt(val);
			}
			if (k == 3) {
				ds_main_data.setColumn(i, "insum", temp);
				sum = parseInt(sum) + parseInt(temp);
				temp = 0;
			} else if (k == 8) {
				ds_main_data.setColumn(i, "outsum", temp);
				ds_main_data.setColumn(i, "totalsum", parseInt(sum) + parseInt(temp));
				temp = 0;
				sum = 0;
			}
		}
	}
}]]></Script>
  </Form>
</FDL>