YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS01300_사업장실시인원.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS01300" position="absolute 0 0 1196 780" titletext="건진일평균인원현황" oninit="SMAHS01300_oninit" onload="SMAHS01300_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 25 1195 65" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape position="absolute 1122 10 1128 32" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
              <Button position="absolute 1132 10 1188 32" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Button position="absolute 969 10 1049 32" id="btn_excelsave" class="btn7" visible="true" text="엑셀저장" anchor="top right" onclick="group2_btn_excelsave_onclick"/>
              <Button position="absolute 1063 10 1119 32" id="btn_prt" class="btn6" text="출력" anchor="top right" onclick="group2_btn_prt_onclick"/>
              <Shape position="absolute 1053 10 1059 32" linetype="vertical" id="line3" class="line_4" visible="false" anchor="top right"/>
              <Static text="연도 :" position="absolute 15 12 88 29" id="caption2" class="search_name"/>
              <Combo position="absolute 80 11 180 30" id="cmb_year" innerdataset="@ds_init_baseinfo_yearlst_P0167" datacolumn="cdnm" codecolumn="cdid" onitemchanged="group2_cmb_year_onitemchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid position="absolute 0 70 1195 779" align="align:center middle;" id="grd_cmpylst" binddataset="ds_main_cmpylst_item" autoenter="select" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="21" band="left"/>
                <Column size="150"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
              </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" rowspan="2" text="담당자" taborder="undefined"/>
                <Cell col="7" colspan="12" text="실 시 기 간" taborder="undefined"/>
                <Cell row="1" col="7" text="1월"/>
                <Cell row="1" col="8" text="2월"/>
                <Cell row="1" col="9" text="3월"/>
                <Cell row="1" col="10" text="4월"/>
                <Cell row="1" col="11" text="5월"/>
                <Cell row="1" col="12" text="6월"/>
                <Cell row="1" col="13" text="7월"/>
                <Cell row="1" col="14" text="8월"/>
                <Cell row="1" col="15" text="9월"/>
                <Cell row="1" col="16" text="10월"/>
                <Cell row="1" col="17" text="11월"/>
                <Cell row="1" col="18" text="12월"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" style="align:left middle;padding:0 0 0 3;font:arial,9,bold;" text="bind:cmpynm"/>
                <Cell col="2" text="bind:pkgnm" wordwrap="word"/>
                <Cell col="3" text="bind:condd"/>
                <Cell col="4" displaytype="number" text="bind:cmpyamt"/>
                <Cell col="5" displaytype="number" text="bind:cmpycnt"/>
                <Cell col="6" text="bind:chrgnm"/>
                <Cell col="7" displaytype="number" text="bind:mon1"/>
                <Cell col="8" displaytype="number" text="bind:mon2"/>
                <Cell col="9" displaytype="number" text="bind:mon3"/>
                <Cell col="10" displaytype="number" text="bind:mon4"/>
                <Cell col="11" displaytype="number" text="bind:mon5"/>
                <Cell col="12" displaytype="number" text="bind:mon6"/>
                <Cell col="13" displaytype="number" text="bind:mon7"/>
                <Cell col="14" displaytype="number" text="bind:mon8"/>
                <Cell col="15" displaytype="number" text="bind:mon9"/>
                <Cell col="16" displaytype="number" text="bind:mon10"/>
                <Cell col="17" displaytype="number" text="bind:mon11"/>
                <Cell col="18" displaytype="number" text="bind:mon12"/>
              </Band>
              <Band id="summary">
                <Cell style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;"/>
                <Cell col="1" style="align:left middle;padding:0 0 0 3;background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="합계"/>
                <Cell col="2" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;"/>
                <Cell col="3" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;"/>
                <Cell col="4" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('cmpyamt')"/>
                <Cell col="5" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('cmpycnt')"/>
                <Cell col="6" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;"/>
                <Cell col="7" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon1')"/>
                <Cell col="8" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon2')"/>
                <Cell col="9" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon3')"/>
                <Cell col="10" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon4')"/>
                <Cell col="11" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon5')"/>
                <Cell col="12" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon6')"/>
                <Cell col="13" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon7')"/>
                <Cell col="14" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon8')"/>
                <Cell col="15" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon9')"/>
                <Cell col="16" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon10')"/>
                <Cell col="17" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon11')"/>
                <Cell col="18" displaytype="number" style="background:#808080ff;background2:#808080ff;color:white;color2:white;font:arial,9,bold;" text="expr:getSum('mon12')"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption60" text="사업장실시인원" class="tit_1" position="absolute 0 0 183 25"/>
        <Shape id="line1" class="line_10" position="absolute 0 65 1195 71" anchor="left top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_srch" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_cmpylst_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cmpynm" type="STRING" size="256" sumtext="사업장명"/>
          <Column id="pkgnm" type="STRING" size="256" sumtext="계약항목"/>
          <Column id="condd" type="STRING" size="256" sumtext="계약일자"/>
          <Column id="cmpyamt" type="INT" size="256" sumtext="실시금액"/>
          <Column id="cmpycnt" type="INT" size="256" sumtext="실시인원"/>
          <Column id="chrgnm" type="STRING" size="256" sumtext="담당자"/>
          <Column id="mon1" type="INT" size="256" sumtext="1월"/>
          <Column id="mon2" type="INT" size="256" sumtext="2월"/>
          <Column id="mon3" type="INT" size="256" sumtext="3월"/>
          <Column id="mon4" type="INT" size="256" sumtext="4월"/>
          <Column id="mon5" type="INT" size="256" sumtext="5월"/>
          <Column id="mon6" type="INT" size="256" sumtext="6월"/>
          <Column id="mon7" type="INT" size="256" sumtext="7월"/>
          <Column id="mon8" type="INT" size="256" sumtext="8월"/>
          <Column id="mon9" type="INT" size="256" sumtext="9월"/>
          <Column id="mon10" type="INT" size="256" sumtext="10월"/>
          <Column id="mon11" type="INT" size="256" sumtext="11월"/>
          <Column id="mon12" type="INT" size="256" sumtext="12월"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_baseinfo_yearlst_P0167" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="srchinstcd" type="STRING" size="256"/>
          <Column id="srchfromdd" type="STRING" size="256"/>
          <Column id="srchtodd" type="STRING" size="256"/>
          <Column id="srchyear" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchinstcd"/>
            <Col id="srchfromdd"/>
            <Col id="srchtodd"/>
            <Col id="srchyear"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_year" propid="value" datasetid="ds_init_srch" columnid="year"/>
    </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";
function SMAHS01300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAHS01300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_cmpylst);
	
	ds_send.setColumn(0, "srchinstcd" , sysf_getUserInfo("posinstcd"));
	
	var arrParam = [ {dsNm: "ds_init_baseinfo_yearlst_P0167", cdGrpId: "P0167"}];
	appf_getCodeList(arrParam);
	
	ds_init_srch.setColumn(0, "year", String(utlf_getCurrentDate()).substr(0,4));
	
	frmf_inputEnterKey("group2.cmb_year", "onitemchanged", new ItemChangeEventInfo); 
}

function group2_cmb_year_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fDate(obj.value);
}

function fDate(vYear) 
{
	var dd = new Date(vYear , 14 , 0 );
	ds_send.setColumn(0, "srchfromdd" , vYear + "0101");
	ds_send.setColumn(0, "srchtodd" , vYear + "1231");
	ds_send.setColumn(0, "srchyear" , vYear);
}	

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRAHS01301";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetCmpyExeList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_cmpylst_item=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS01301";

	tranf_submit(oParam);
}

function group2_btn_prt_onclick(obj:Button,  e:ClickEventInfo)
{
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/cmpylst/item", ds_main_cmpylst_item);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
		objParam.srchfromdd = ds_send.getColumn(0, "srchfromdd").toDate().getDateFormat("YYYY/MM/DD");
		objParam.srchtodd = ds_send.getColumn(0, "srchtodd").toDate().getDateFormat("YYYY/MM/DD");
		objParam.srchyear = ds_send.getColumn(0, "srchyear");
		
	var option = ""; 
	rptf_exeReportPreview30(["RPAHS01301"],[objParam], option);
}

function group2_btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_cmpylst, "excel", "SheetName", "true", "", "");
}
]]></Script>
  </Form>
</FDL>