YNU_JEUS/app_home/himed/xpapps/lis/plgystatsmngtxp/xp/SMLPS01300_판독의별검사보고시간.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMLPS01300" position="absolute 0 0 1197 758" titletext="판독의별 검사건수/보고시간" oninit="SMLPS01300_oninit" onload="SMLPS01300_onload">
    <Layouts>
      <Layout>
        <Button id="button13" taborder="1" text="EXCEL저장" class="btn7" position="absolute 1103 68 1195 90" onclick="button13_onclick" anchor="top right"/>
        <Static id="caption6" text="판독의별 검사건수/보고시간(시간기준)" class="tit_1" position="absolute 0 0 263 25" anchor="left top"/>
        <Static id="caption4" text="접수검사목록" class="tit_2" position="absolute 1 82 103 98" anchor="left top"/>
        <Shape id="line1" linetype="horizontal" class="line_1" position="absolute 0 98 1194 104" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
        <Grid id="grd_statsinfolist" class="datagrid2" taborder="2" binddataset="ds_grd_statsinfolist" useinputpanel="false" position="absolute 0 102 1194 755" autofittype="col" anchor="all" autosizingtype="row" cellsizingtype="row" cellmovingtype="col" extendsizetype="row">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="0"/>
                <Column size="28"/>
                <Column size="70"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="31"/>
                <Column size="60"/>
                <Column size="40"/>
                <Column size="31"/>
                <Column size="31"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="기관코드"/>
                <Cell col="1"/>
                <Cell col="2" text="판독의"/>
                <Cell col="3" text="검사코드"/>
                <Cell col="4" text="검사명"/>
                <Cell col="5" text="01"/>
                <Cell col="6" text="02"/>
                <Cell col="7" text="03"/>
                <Cell col="8" text="04"/>
                <Cell col="9" text="05"/>
                <Cell col="10" text="06"/>
                <Cell col="11" text="07"/>
                <Cell col="12" text="08"/>
                <Cell col="13" text="09"/>
                <Cell col="14" text="10"/>
                <Cell col="15" text="11"/>
                <Cell col="16" text="12"/>
                <Cell col="17" text="13"/>
                <Cell col="18" text="14"/>
                <Cell col="19" text="15"/>
                <Cell col="20" text="16"/>
                <Cell col="21" text="17"/>
                <Cell col="22" text="18"/>
                <Cell col="23" text="19"/>
                <Cell col="24" text="20"/>
                <Cell col="25" text="21"/>
                <Cell col="26" text="22"/>
                <Cell col="27" text="23"/>
                <Cell col="28" text="24"/>
                <Cell col="29" text="25"/>
                <Cell col="30" text="26"/>
                <Cell col="31" text="27"/>
                <Cell col="32" text="28"/>
                <Cell col="33" text="29"/>
                <Cell col="34" text="30"/>
                <Cell col="35" text="31"/>
                <Cell col="36" text="총&#10;시간"/>
                <Cell col="37" text="총&#10;일자"/>
                <Cell col="38" text="평균&#10;시간"/>
                <Cell col="39" text="평균&#10;일자"/>
              </Band>
              <Band id="body">
                <Cell text="bind:instcd"/>
                <Cell col="1" text="expr:currow + 1"/>
                <Cell col="2" text="bind:readnm"/>
                <Cell col="3" class="text_center" text="bind:testcd"/>
                <Cell col="4" style="align:left middle;padding:5 5 5 5;" class="text_center" text="bind:testnm" wordwrap="char" autosizerow="limitmin"/>
                <Cell col="5" class="text_right" text="bind:day01"/>
                <Cell col="6" class="text_right" text="bind:day02"/>
                <Cell col="7" class="text_right" text="bind:day03"/>
                <Cell col="8" class="text_right" text="bind:day04"/>
                <Cell col="9" class="text_right" text="bind:day05"/>
                <Cell col="10" class="text_right" text="bind:day06"/>
                <Cell col="11" class="text_right" text="bind:day07"/>
                <Cell col="12" class="text_right" text="bind:day08"/>
                <Cell col="13" class="text_right" text="bind:day09"/>
                <Cell col="14" class="text_right" text="bind:day10"/>
                <Cell col="15" class="text_right" text="bind:day11"/>
                <Cell col="16" class="text_right" text="bind:day12"/>
                <Cell col="17" class="text_right" text="bind:day13"/>
                <Cell col="18" class="text_right" text="bind:day14"/>
                <Cell col="19" class="text_right" text="bind:day15"/>
                <Cell col="20" class="text_right" text="bind:day16"/>
                <Cell col="21" class="text_right" text="bind:day17"/>
                <Cell col="22" class="text_right" text="bind:day18"/>
                <Cell col="23" class="text_right" text="bind:day19"/>
                <Cell col="24" class="text_right" text="bind:day20"/>
                <Cell col="25" class="text_right" text="bind:day21"/>
                <Cell col="26" class="text_right" text="bind:day22"/>
                <Cell col="27" class="text_right" text="bind:day23"/>
                <Cell col="28" class="text_right" text="bind:day24"/>
                <Cell col="29" class="text_right" text="bind:day25"/>
                <Cell col="30" class="text_right" text="bind:day26"/>
                <Cell col="31" class="text_right" text="bind:day27"/>
                <Cell col="32" class="text_right" text="bind:day28"/>
                <Cell col="33" class="text_right" text="bind:day29"/>
                <Cell col="34" class="text_right" text="bind:day30"/>
                <Cell col="35" class="text_right" text="bind:day31"/>
                <Cell col="36" class="text_right" text="bind:daytot"/>
                <Cell col="37" class="text_right" text="bind:daytotdd"/>
                <Cell col="38" class="text_right" text="bind:dayavg"/>
                <Cell col="39" class="text_right" text="bind:dayavgdd"/>
              </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 88 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="6" text="조회" class="btn1" position="absolute 1123 7 1179 29" anchor="top right" onclick="grp_sea_btn_sea_onclick"/>
              <Calendar id="ipt_cnclfromdd" taborder="7" class="input_s_essential" position="absolute 104 8 204 27" mask="yyyy-mm-dd" anchor="left top"/>
              <Calendar id="ipt_cncltodd" taborder="8" class="input_s_essential" position="absolute 223 8 323 27" mask="yyyy-mm-dd" anchor="left top"/>
              <Static id="caption1" text="검색방법 :" class="search_name" position="absolute 391 9 466 27" anchor="left top"/>
              <Combo id="cbo_refmthdcd" taborder="9" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 466 9 538 28" anchor="left top" onitemchanged="grp_sea_cbo_refmthdcd_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">0</Col>
                      <Col id="datacolumn">일별</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">월별</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption8" text="통계구분 :" class="search_name" position="absolute 856 9 929 26" anchor="top right"/>
              <Combo id="cbo_statsflagcd" taborder="10" innerdataset="ds_init_cbo_statsflagcd" codecolumn="resncd" datacolumn="resncnts" position="absolute 945 8 1093 27" anchor="top right"/>
              <Combo id="combo1" taborder="11" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 705 8 800 27" anchor="top right" onitemchanged="grp_sea_combo1_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">0</Col>
                      <Col id="datacolumn">검사건수</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">보고시간</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption3" text="검색구분 :" class="search_name" position="absolute 616 9 687 26" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grd_statsinfolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING"/>
          <Column id="readnm" type="STRING"/>
          <Column id="testcd" 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="daytotdd" type="STRING"/>
          <Column id="dayavg" type="STRING"/>
          <Column id="dayavgdd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_cbo_statsflagcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="resncnts" type="STRING"/>
          <Column id="resncd" type="STRING"/>
        </ColumnInfo>
      </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>
      <Dataset id="ds_mdlcdinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="choi" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="baseflagcd" type="STRING" size="256"/>
          <Column id="resncd" type="STRING" size="256"/>
          <Column id="resncnts" type="STRING" size="256"/>
          <Column id="mdlflagcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="mdlflagcd"/>
            <Col id="baseflagcd">84</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sysdt" type="STRING" size="256"/>
          <Column id="resncd" type="STRING" size="256"/>
          <Column id="statsfromdd" type="STRING" size="256"/>
          <Column id="statstodd" type="STRING" size="256"/>
          <Column id="refmthdcd" type="STRING" size="256"/>
          <Column id="statsworkflagcd" type="STRING" size="256"/>
          <Column id="refflagcd" type="STRING" size="256"/>
          <Column id="mdlcdlist" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_cnclfromdd" propid="value" datasetid="ds_init" columnid="statsfromdd"/>
      <BindItem id="item1" compid="grp_sea.ipt_cncltodd" propid="value" datasetid="ds_init" columnid="statstodd"/>
      <BindItem id="item2" compid="grp_sea.cbo_refmthdcd" propid="value" datasetid="ds_init" columnid="refmthdcd"/>
      <BindItem id="item3" compid="grp_sea.combo1" propid="value" datasetid="ds_init" columnid="refflagcd"/>
      <BindItem id="item4" compid="grp_sea.cbo_statsflagcd" propid="value" datasetid="ds_init" columnid="statsworkflagcd"/>
    </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 SMLPS01300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMLPS01300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_statsinfolist);
	fExeInitialize();
}

function fExeInitialize()
{					
	var iNodeCnt = 0;	
	
	ds_grd_statsinfolist.clearData();
	
	// 시스템일자 조회
	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);
		
	dsf_createDsRow("ds_send", [{col : "instcd",      val : sysf_getUserInfo("dutplceinstcd")}
							   ,{col : "delflagcd",   val :  "0"}
							   ,{col : "baseflagcd",  val : "ZA"}
							   ,{col : "resncd",      val : "02"}]);

	var oParam = {};
		oParam.id          = "TRLPC02802";
		oParam.service     = "plgybaseinfomngtapp.BaseFlagCode";
		oParam.method      = "reqGetMdlCdList";
		oParam.inds        = "refData=ds_send";
		oParam.outds       = "ds_init_cbo_statsflagcd=baseflagcdinfo";
		oParam.async       = false;
		//oParam.callback    = "cf_TRLPC02802";
	tranf_submit(oParam);
	
	// 전체조회용 Instance생성
	iNodeCnt = ds_init_cbo_statsflagcd.addRow();
	ds_init_cbo_statsflagcd.setColumn(iNodeCnt, "resncd", "ZZZZ");
	ds_init_cbo_statsflagcd.setColumn(iNodeCnt, "resncnts", "전체");
	ds_init_cbo_statsflagcd.setColumn(iNodeCnt, "baseflagcd", "ZA");
	
	ds_init.setColumn(0, "statsfromdd", utlf_getCurrentDate()); 							
	ds_init.setColumn(0, "statstodd",   utlf_getCurrentDate());	
	ds_init.setColumn(0, "refmthdcd",   "0"); 		
	ds_init.setColumn(0, "refflagcd",   "0"); 					
	ds_init.setColumn(0, "statsworkflagcd", "ZZZZ"); 
	
	fExeRadioChange();
}

function fExeRadioChange()
{	
	for(var i = 17; i <= 35; i++)
	{
		grd_statsinfolist.setFormatColProperty(i, "size", 31);
	}
	
	var iFromNo = 0;
	var iToNo   = 0;
	var iWidth  = 0;
	var bState  = false;
	
	var k = 0;
	var iYear   = 0;
	var sFromDD = grp_sea.ipt_cnclfromdd.value;
		sFromDD_d = sFromDD.toFormatString("%Y%m%d");
	var sToDD   = grp_sea.ipt_cnclfromdd.value;
		sToDD_d   = sToDD.toFormatString("%Y%m%d");
		
	if(grp_sea.cbo_refmthdcd.value == "0")
	{
		iFromNo = 5;
		iToNo = ds_grd_statsinfolist.colcount;
		iWidth  = 31;
		bState  = false;
		
		if(grp_sea.combo1.value == "0")
		{
			sText = "기관코드^판독의^검사코드^검사명^01^02^03^04^05^06^07^08^09^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^총\n건수^";
			for(var i = 1; i <= 31; i++)
			{
		
				grd_statsinfolist.setCellProperty("head", 4+i, "text", i);
			}
			if(i>31)
			{
				grd_statsinfolist.setCellProperty("head", 4+i, "text", "총\n건수");
				for(i = 37; i<=39; i++)
				{
					grd_statsinfolist.setFormatColProperty(i, "size", 0);
				}
			}
		}
		else
		{
			sText = "기관코드^판독의^검사코드^검사명^01^02^03^04^05^06^07^08^09^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^총\n시간^총\n일자^평균\n시간^평균\n일자";
			grd_statsinfolist.setCellProperty("head", 4+i, "text", "총\n시간");
			for(var i = 37; i <= 39; i++)
			{
				grd_statsinfolist.setFormatColProperty(i, "size", 31);
			}
		}
	}
	else if(grp_sea.cbo_refmthdcd.value == "1")
	{
		iFromNo = 17;
		iToNo   = 35;
		iWidth  = 75;
		bState  = true;
		
		if(grp_sea.combo1.value == "0")
		{
			sText = "기관코드^판독의^검사코드^검사명^01^02^03^04^05^06^07^08^09^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^총\n건수^";
			for(var i = 1; i <= 31; i++)
			{
				grd_statsinfolist.setCellProperty("head", 4+i, "text", i);
			}
			if(i>12)
			{
				for(i=17; i <= 39; i++)
				{
					grd_statsinfolist.setFormatColProperty(i, "size", 0);
				}
				grd_statsinfolist.setFormatColProperty(36, "size", 60);
				grd_statsinfolist.setCellProperty("head", 36, "text", "총\n건수");
			}
		}
		else
		{
			for(i=17; i <= 39; i++)
			{
				grd_statsinfolist.setFormatColProperty(i, "size", 0);
			}
			grd_statsinfolist.setCellProperty("head", 36, "text", "총\n시간");
			for(i=37; i <= 39; i++)
			{
				grd_statsinfolist.setFormatColProperty(i, "size", 31);
			}
		}
	}
	ds_grd_statsinfolist.clearData();
}

//조회
function fGetStatsInfoList()
{
	dsf_createDsRow("ds_send", [{col: "instcd",      	   val : sysf_getUserInfo("dutplceinstcd")}
							   ,{col: "statsfromdd",  	   val : ds_init.getColumn(0, "statsfromdd")}
							   ,{col: "statstodd",	 	   val : ds_init.getColumn(0, "statstodd")}
							   ,{col: "refmthdcd",   	   val : ds_init.getColumn(0, "refmthdcd")}
							   ,{col: "refflagcd",   	   val : ds_init.getColumn(0, "refflagcd")}
							   ,{col: "statsworkflagcd",   val : ds_init.getColumn(0, "statsworkflagcd")}]);
	//submit("TRLPS01301");
	var oParam = {};
		oParam.id          = "TRLPS01301";
		oParam.service     = "plgystatsmngtapp.StatsMngtRef";
		oParam.method      = "reqGetReadDRReadTMStats";
		oParam.inds        = "refData=ds_send";
		oParam.outds       = "ds_grd_statsinfolist=reflist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRLPS01301";

	tranf_submit(oParam);
}

//엑셀저장
function fExeSaveToExcel()
{	
	var sTitle = "판독의별 ";
	
	if(ds_init.getColumn(0, "refflagcd") == "0")
	{
		switch (ds_init.getColumn(0,"refmthdcd"))
		{
			case "0" : sTitle += "검사건수(일별)";
					   break;
			case "1" : sTitle += "검사건수(월별)";
					   break;
		}
	} 
	else 
	{	
		switch (ds_init.getColumn(0,"refmthdcd"))
		{
			case "0" : sTitle += "보고시간(일별)";
					   break;
			case "1" : sTitle += "보고시간(월별)";
					   break;
		}
	}
	grdf_exportExcel(grd_statsinfolist, sTitle, "sheet1", false);
}
	
function grp_sea_cbo_refmthdcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fExeRadioChange();
}

function grp_sea_combo1_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fExeRadioChange();
}

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

//엑셀저장
function button13_onclick(obj:Button,  e:ClickEventInfo)
{
	 fExeSaveToExcel();
}
]]></Script>
  </Form>
</FDL>