YNU_JEUS/app_home/himed/xpapps/lis/plgystatsmngtxp/xp/SMLPS01400_검사별보고시간.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMLPS01400" position="absolute 0 0 1197 761" titletext="검사별보고시간" oninit="SMLPS01400_oninit" onload="SMLPS01400_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="검사별 보고시간(일기준)" onclick="grp_tle_caption6_onclick" class="tit_1" position="absolute 0 0 180 25"/>
        <Button id="button13" taborder="1" text="EXCEL저장" class="btn7" position="absolute 1103 71 1195 93" onclick="button13_onclick" anchor="top right"/>
        <Static id="caption4" text="검사별 보고시간 목록" class="tit_2" position="absolute 1 84 156 100" anchor="left top"/>
        <Shape id="line1" linetype="horizontal" class="line_1" position="absolute 0 100 1194 106" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
        <Grid id="grd_testreptlist" class="datagrid2" taborder="2" binddataset="ds_grd_testreptlist" useinputpanel="false" position="absolute 0 104 1194 757" autofittype="col" autosizingtype="row" cellsizingtype="both" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="40"/>
                <Column size="50"/>
                <Column size="73"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="30"/>
                <Column size="69"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="명칭"/>
                <Cell col="2" text="검사명"/>
                <Cell col="3" text="01"/>
                <Cell col="4" text="02"/>
                <Cell col="5" text="03"/>
                <Cell col="6" text="04"/>
                <Cell col="7" text="05"/>
                <Cell col="8" text="06"/>
                <Cell col="9" text="07"/>
                <Cell col="10" text="08"/>
                <Cell col="11" text="09"/>
                <Cell col="12" text="10"/>
                <Cell col="13" text="11"/>
                <Cell col="14" text="12"/>
                <Cell col="15" text="13"/>
                <Cell col="16" text="14"/>
                <Cell col="17" text="15"/>
                <Cell col="18" text="16"/>
                <Cell col="19" text="17"/>
                <Cell col="20" text="18"/>
                <Cell col="21" text="19"/>
                <Cell col="22" text="20"/>
                <Cell col="23" text="21"/>
                <Cell col="24" text="22"/>
                <Cell col="25" text="23"/>
                <Cell col="26" text="24"/>
                <Cell col="27" text="25"/>
                <Cell col="28" text="26"/>
                <Cell col="29" text="27"/>
                <Cell col="30" text="28"/>
                <Cell col="31" text="29"/>
                <Cell col="32" text="30"/>
                <Cell col="33" text="31"/>
                <Cell col="34" text="총계"/>
                <Cell col="35" text="평균일수"/>
              </Band>
              <Band id="body">
                <Cell text="expr:currow+1"/>
                <Cell col="1" text="bind:reptnm"/>
                <Cell col="2" style="padding:5 5 5 5;" text="bind:testnm" wordwrap="char" autosizerow="limitmin"/>
                <Cell col="3" class="text_right" text="bind:day01"/>
                <Cell col="4" class="text_right" text="bind:day02"/>
                <Cell col="5" class="text_right" text="bind:day03"/>
                <Cell col="6" class="text_right" text="bind:day04"/>
                <Cell col="7" class="text_right" text="bind:day05"/>
                <Cell col="8" class="text_right" text="bind:day06"/>
                <Cell col="9" class="text_right" text="bind:day07"/>
                <Cell col="10" class="text_right" text="bind:day08"/>
                <Cell col="11" class="text_right" text="bind:day09"/>
                <Cell col="12" class="text_right" text="bind:day10"/>
                <Cell col="13" class="text_right" text="bind:day11"/>
                <Cell col="14" class="text_right" text="bind:day12"/>
                <Cell col="15" class="text_right" text="bind:day13"/>
                <Cell col="16" class="text_right" text="bind:day14"/>
                <Cell col="17" class="text_right" text="bind:day15"/>
                <Cell col="18" class="text_right" text="bind:day16"/>
                <Cell col="19" class="text_right" text="bind:day17"/>
                <Cell col="20" class="text_right" text="bind:day18"/>
                <Cell col="21" class="text_right" text="bind:day19"/>
                <Cell col="22" class="text_right" text="bind:day20"/>
                <Cell col="23" class="text_right" text="bind:day21"/>
                <Cell col="24" class="text_right" text="bind:day22"/>
                <Cell col="25" class="text_right" text="bind:day23"/>
                <Cell col="26" class="text_right" text="bind:day24"/>
                <Cell col="27" class="text_right" text="bind:day25"/>
                <Cell col="28" class="text_right" text="bind:day26"/>
                <Cell col="29" class="text_right" text="bind:day27"/>
                <Cell col="30" class="text_right" text="bind:day28"/>
                <Cell col="31" class="text_right" text="bind:day29"/>
                <Cell col="32" class="text_right" text="bind:day30"/>
                <Cell col="33" class="text_right" text="bind:day31"/>
                <Cell col="34" class="text_right" text="bind:daytot"/>
                <Cell col="35" class="text_right" text="bind:avgtm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Div id="grp_sea" taborder="3" position="absolute 0 25 1195 60" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1105 7 1111 29" anchor="top right"/>
              <Static id="caption2" text="보고일자 :" class="search_name" position="absolute 15 9 101 26" anchor="left top"/>
              <Static id="caption5" text="~" class="search_no_b" position="absolute 207 8 219 25" anchor="left top"/>
              <Button id="btn_sea" taborder="3" text="조회" class="btn1" position="absolute 1123 7 1179 29" anchor="top right" onclick="grp_sea_btn_sea_onclick"/>
              <Calendar id="ipt_reptfromdd" taborder="4" class="input_s_essential" position="absolute 104 8 204 27" mask="yyyy-mm-dd" anchor="left top"/>
              <Calendar id="ipt_repttodd" taborder="5" class="input_s_essential" position="absolute 223 8 323 27" mask="yyyy-mm-dd" anchor="left top" onkeyup="grp_sea_ipt_repttodd_onkeyup"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grd_testreptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reptnm" type="STRING"/>
          <Column id="testnm" type="STRING"/>
          <Column id="day01" type="STRING"/>
          <Column id="day02" type="STRING"/>
          <Column id="day03" type="STRING"/>
          <Column id="day04" type="STRING"/>
          <Column id="day05" type="STRING"/>
          <Column id="day06" type="STRING"/>
          <Column id="day07" type="STRING"/>
          <Column id="day08" type="STRING"/>
          <Column id="day09" type="STRING"/>
          <Column id="day10" type="STRING"/>
          <Column id="day11" type="STRING"/>
          <Column id="day12" type="STRING"/>
          <Column id="day13" type="STRING"/>
          <Column id="day14" type="STRING"/>
          <Column id="day15" type="STRING"/>
          <Column id="day16" type="STRING"/>
          <Column id="day17" type="STRING"/>
          <Column id="day18" type="STRING"/>
          <Column id="day19" type="STRING"/>
          <Column id="day20" type="STRING"/>
          <Column id="day21" type="STRING"/>
          <Column id="day22" type="STRING"/>
          <Column id="day23" type="STRING"/>
          <Column id="day24" type="STRING"/>
          <Column id="day25" type="STRING"/>
          <Column id="day26" type="STRING"/>
          <Column id="day27" type="STRING"/>
          <Column id="day28" type="STRING"/>
          <Column id="day29" type="STRING"/>
          <Column id="day30" type="STRING"/>
          <Column id="day31" type="STRING"/>
          <Column id="daytot" type="STRING"/>
          <Column id="avgtm" type="STRING"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="avgtm">2345.78</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reptfromdd" type="STRING" size="256"/>
          <Column id="repttodd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_data_sysdtinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sysdd" type="STRING" size="256"/>
          <Column id="systm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_reptfromdd" propid="value" datasetid="ds_hidden" columnid="reptfromdd"/>
      <BindItem id="item1" compid="grp_sea.ipt_repttodd" propid="value" datasetid="ds_hidden" columnid="repttodd"/>
    </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 SMLPS01400_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMLPS01400_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_testreptlist);
	fExeInitialize();
}

function fExeInitialize()
{					
	// 시스템일자 조회
	dsf_createDsRow("ds_send", [{col: "instcd", val: sysf_getUserInfo("dutplceinstcd")}]);
	
	var oParam = {};
		oParam.id          = "TRLPZ00102";
		oParam.service     = "plgycomnusemngtapp.BaseInfoCode";
		oParam.method      = "reqGetSystemDateTimeInformation";
		oParam.inds        = "refData=ds_send";
		oParam.outds       = "ds_data_sysdtinfo=sysdtinfo";
		oParam.async       = false;
		//oParam.callback    = "cf_TRLPZ00102";

		tranf_submit(oParam);
	//------------
	// 초기값 설정
	ds_hidden.setColumn(0, "reptfromdd", utlf_getCurrentDate());
	ds_hidden.setColumn(0, "repttodd",   utlf_getCurrentDate()); 
	
			
}

//조회
function fGetTestReptTmList()
{
	dsf_createDsRow("ds_send", [{col: "instcd",      	   val : sysf_getUserInfo("dutplceinstcd")}
							   ,{col: "reptfromdd",  	   val : ds_hidden.getColumn(0, "reptfromdd")}
						       ,{col: "repttodd",	 	   val : ds_hidden.getColumn(0, "repttodd")}]);
	var oParam = {};
		oParam.id          = "TRLPS01401";
		oParam.service     = "plgystatsmngtapp.StatsMngtRef";
		oParam.method      = "reqGetTestReptTmList";
		oParam.inds        = "refData=ds_send";
		oParam.outds       = "ds_grd_testreptlist=testrepttmlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRLPS01401";

	tranf_submit(oParam);

		
}


//조회
function grp_sea_btn_sea_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetTestReptTmList();
}

//엑셀저장
function button13_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_testreptlist, "검사별 보고시간 목록", "sheet1", false);
}

function grp_sea_ipt_repttodd_onkeyup(obj:Calendar, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		fGetTestReptTmList();
	}
}
]]></Script>
  </Form>
</FDL>