YNU_JEUS/app_home/himed/xpapps/ast/dietstatsxp/xp/SMANS01000_식수통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANS01000" position="absolute 0 0 1199 716" titletext="식수통계" oninit="SMANS01000_oninit" onload="SMANS01000_onload">
    <Layouts>
      <Layout>
        <Static text="월별 소속 구분별 식수 리스트" position="absolute 2 64 202 80" id="caption1" class="tit_2"/>
        <Shape position="absolute 0 81 1183 87" linetype="horizontal" id="line1" class="line_10"/>
        <Div position="absolute 0 25 1195 55" align="align:center top;" id="grp_sea" class="div_SA">
          <Layouts>
            <Layout>
              <Static text="조회기간 :" position="absolute 15 7 101 24" id="caption2" class="search_name"/>
              <Shape position="absolute 1107 4 1113 26" linetype="vertical" id="line13" class="line_4"/>
              <Button position="absolute 1120 4 1176 26" id="btn_sea" class="btn1" taborder="4" text="조회" onclick="grp_sea_btn_sea_onclick"/>
              <Calendar position="absolute 207 6 292 25" id="ipt_todd" class="input_default" taborder="2" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_sea_ipt_todd_onchanged"/>
              <Static text="~" position="absolute 192 7 204 24" id="caption5" class="search_no_b"/>
              <Calendar position="absolute 106 6 191 25" id="ipt_fromdd" class="input_default" taborder="1" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_sea_ipt_fromdd_onchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Button position="absolute 1120 60 1184 79" id="btn_excsave" class="btn2" text="엑셀저장" onclick="btn_excsave_onclick"/>
        <Grid position="absolute 0 86 1183 710" id="grd_sicksulist" class="datagrid2" binddataset="ds_main_list_item">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="100"/>
                <Column size="70"/>
                <Column size="100"/>
                <Column size="300"/>
                <Column size="300"/>
                <Column size="100"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <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="총금액"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow + 1"/>
                <Cell col="1" style="background:expr:utlf_isNull(instnm) ? '#ccffff' : '';background2:expr:utlf_isNull(instnm) ? '#ccffff' : '';font:expr:utlf_isNull(instnm) ? 'arial,9,bold' : '';" text="bind:instnm" expr="expr:utlf_isNull(instnm) ? '소계' : instnm" suppress="1" suppressalign="middle,over" enable="false"/>
                <Cell col="2" style="background:expr:utlf_isNull(instnm) ? '#ccffff' : '';background2:expr:utlf_isNull(instnm) ? '#ccffff' : '';" text="bind:emplno" enable="false"/>
                <Cell col="3" style="background:expr:utlf_isNull(instnm) ? '#ccffff' : '';background2:expr:utlf_isNull(instnm) ? '#ccffff' : '';" text="bind:name" enable="false"/>
                <Cell col="4" style="align:left top;padding:5 2 1 2;background:expr:utlf_isNull(instnm) ? '#ccffff' : '';background2:expr:utlf_isNull(instnm) ? '#ccffff' : '';" text="bind:dutplcedeptnm" wordwrap="word" enable="false"/>
                <Cell col="5" style="align:left top;padding:5 2 1 2;background:expr:utlf_isNull(instnm) ? '#ccffff' : '';background2:expr:utlf_isNull(instnm) ? '#ccffff' : '';" text="bind:deptnm" wordwrap="word" enable="false"/>
                <Cell col="6" displaytype="number" style="background:expr:utlf_isNull(instnm) ? '#ccffff' : '';background2:expr:utlf_isNull(instnm) ? '#ccffff' : '';font:expr:utlf_isNull(instnm) ? 'arial,9,bold' : '';" text="bind:count" enable="false"/>
                <Cell col="7" displaytype="number" style="background:expr:utlf_isNull(instnm) ? '#ccffff' : '';background2:expr:utlf_isNull(instnm) ? '#ccffff' : '';font:expr:utlf_isNull(instnm) ? 'arial,9,bold' : '';" text="bind:amount" enable="false"/>
              </Band>
              <Band id="summary">
                <Cell/>
                <Cell col="1" style="font:arial,9,bold;" text="총계"/>
                <Cell col="2"/>
                <Cell col="3"/>
                <Cell col="4"/>
                <Cell col="5"/>
                <Cell col="6" displaytype="number" style="font:arial,9,bold;" text="expr:getSum(&quot;count&quot;)"/>
                <Cell col="7" displaytype="number" style="font:arial,9,bold;" text="expr:getSum(&quot;amount&quot;)"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button position="absolute 1027 29 1104 51" id="btn_prt" class="btn2" text="PDF 저장" onclick="btn_prt_onclick"/>
        <Static id="caption6" text="본원,칠곡 소속 구분별 식수 통계" class="tit_1" position="absolute 0 0 219 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="dutplcedeptnm" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="instnm" type="STRING" size="256"/>
          <Column id="count" type="STRING" size="256"/>
          <Column id="amount" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="emplno"/>
            <Col id="name"/>
            <Col id="dutplcedeptnm"/>
            <Col id="deptnm"/>
            <Col id="instnm"/>
            <Col id="count"/>
            <Col id="amount"/>
          </Row>
        </Rows>
      </Dataset>
      <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"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_export" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_sea.ipt_todd" propid="value" datasetid="ds_send" 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 SMANS01000_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
	grdf_initGrid(grd_sicksulist);
}

function SMANS01000_onload(obj:Form, e:LoadEventInfo)
{
	var fromdd = utlf_getCurrentDate().substring(0, 6) + '00';		// 적용일자 현재일자 셋팅
	var todd = utlf_getCurrentDate().substring(0, 6) + '99';		// 적용일자 현재일자 셋팅
		
	ds_main_list_item.clearData();
	ds_send.setColumn(0, "fromdd", fromdd);
	ds_send.setColumn(0, "todd", todd);
}

/*
* 소속에 따른 소계 및 총계를 생성한다.
*/
function fSetSicksuSum() {
	// 그리드 merge 및 합계 초기화
// 	grd_sicksulist.autoMerge = false;
// 	grd_sicksulist.mergeCells = "bycolrec";
// 	
// 	grd_sicksulist.subtotalPosition = "below";						
// 	grd_sicksulist.multiTotals = true;
// 	
// 	grd_sicksulist.subtotal("clear", 0, 0);
// 	for(var i =0; i < grd_sicksulist.cols ; i++) {
// 		
// 		// 소계
// 		if(i >= grd_sicksulist.colRef("count") && i <= grd_sicksulist.colRef("amount")) {										
// 			grd_sicksulist.subtotal("sum", grd_sicksulist.colRef("instnm") , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold", grd_sicksulist.colRef("instnm"), "소계" );
// 			grd_sicksulist.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#33cccc; font-weight:bold", grd_sicksulist.colRef("instnm") , "총계" );
// 		}							
// 		// 화면 merge														
// 		if( i ==  grd_sicksulist.colRef("instnm")) {
// 			grd_sicksulist.mergeCol(i) = true;
// 		}else{
// 			grd_sicksulist.mergeCol(i) = false;
// 		}	
// 	}
// 	grd_sicksulist.merge();		
															
	ds_main_list_item.keystring = "G:+instnm";
}



function grp_sea_btn_sea_onclick(obj:Button,  e:ClickEventInfo)
{
	if (utlf_isNull(ds_send.getColumn(0, "fromdd"))){
		sysf_messageBox("조회시작일자는", "I003");		
		grp_sea.ipt_fromdd.setFocus();
		return;
	}
	if (utlf_isNull(ds_send.getColumn(0, "todd"))){
		sysf_messageBox("조회종료일자는", "I003");		
		grp_sea.ipt_todd.setFocus();
		return;
	}
	if (ds_send.getColumn(0, "fromdd") > ds_send.getColumn(0, "todd")){
		sysf_messageBox("조회 시작일자는 종료일자 보다 클 수", "I004");		
		grp_sea.ipt_fromdd.setFocus();
		return;
	}
	
	var fromdd = ds_send.getColumn(0, "fromdd")+ '00';		// 적용일자 현재일자 셋팅
	var todd = ds_send.getColumn(0, "todd") + '99';		// 적용일자 현재일자 셋팅

	ds_send.setColumn(0, "fromdd", fromdd);
	ds_send.setColumn(0, "todd", todd);							
	
	var oParam = {};
		oParam.id          = "TRANS01001";
		oParam.service     = "dietstatsapp.DietStats";
		oParam.method      = "reqGetSicsuList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_item=ret";
		oParam.async       = false;
		oParam.callback    = "cf_TRANS01001";

	tranf_submit(oParam);
		
	if(arErrorCode.pop("TRANS01001") > -1) {
		fSetSicksuSum();				
	}	
}

function cf_TRANS01001(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_sicksulist, "식수통계" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
}

function btn_prt_onclick(obj:Button,  e:ClickEventInfo)
{
	//인쇄 화면이 없음 -> 주석처리
	dsf_makeValue(ds_main_export, "weeknm", "string", utlf_transNullToEmpty(ds_send.getColumn(0, "srchdd")).toDate("YYYYMMDD").getDayOfWeek("k"));
	dsf_makeValue(ds_main_export, "srchdd", "string", utlf_transNullToEmpty(ds_send.getColumn(0, "srchdd")).toDate("YYYYMMDD").getDateFormat("YYYY/MM/DD"));
	
	
	ds_main_list_item.keystring = "S:+instnm";
// 	exeReportPreview("RPANS01001", "XMLSTR" , ""                , ""          , ""    , ""            , "pdf"     , "식수통계"    , "true"           , "true"    ,""         ,""               ,""                  ,""                ,""               ,""             ,""             ,"" );

	var objDOM = rptf_createDOM();			
	rptf_setNodeListToDOM(objDOM, "root/send"	, ds_send);		// 데이터셋 2
	rptf_setNodeListToDOM(objDOM, "root/main/list/item", ds_main_list_item);	// 데이터셋 1	

	var objParam = new Object();
	objParam.xml_data_XML1 = objDOM.documentElement.source;														// 최상의노드 XML 스트링 추출
	
	var userHomeDir = system.convertRealPath("%MYDOCUMENT%");
	tmpFileName = userHomeDir + "식수통계" + ".pdf";
	var option = "open=1;save=1;directprint=0;print=1;zoom=0;export=1;exportdialog=1;exportfilename="+tmpFileName+";";
	rptf_exeReportPreview30(["RPANS01001"],[objParam], option);

	ds_main_list_item.keystring = "G:+instnm";
}

function grp_sea_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send.setColumn(0, "fromdd", utlf_transNullToEmpty(e.postvalue+"").substr(0, 6));
}

function grp_sea_ipt_todd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send.setColumn(0, "todd", utlf_transNullToEmpty(e.postvalue+"").substr(0, 6));
}
]]></Script>
  </Form>
</FDL>