123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMLLS00800" position="absolute 0 0 1256 805" titletext="장비별검사건수" onload="SMLLS00800_onload" oninit="SMLLS00800_oninit">
- <Layouts>
- <Layout>
- <Tab id="swt_statflag" class="sw_box" position="absolute 0 77 1256 805" anchor="all" positiontype="position" onchanged="swt_statflag_onchanged">
- <Tabpages>
- <Tabpage id="dd" text="일별 통계">
- <Layouts>
- <Layout>
- <Grid id="grd_dd" position="absolute 0 0 1256 701" style="align:right middle;" anchor="all" positiontype="position" binddataset="ds_grid_grd_dd">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="30" band="left"/>
- <Column size="150" band="left"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="60"/>
- </Columns>
- <Rows>
- <Row size="22" band="head"/>
- <Row size="20"/>
- </Rows>
- <Band id="head">
- <Cell text="No."/>
- <Cell col="1" text="검사항목"/>
- <Cell col="2" text="01"/>
- <Cell col="3" text="02"/>
- <Cell col="4" text="03"/>
- <Cell col="5" text="04"/>
- <Cell col="6" text="05"/>
- <Cell col="7" text="06"/>
- <Cell col="8" text="07"/>
- <Cell col="9" text="08"/>
- <Cell col="10" text="09"/>
- <Cell col="11" text="10"/>
- <Cell col="12" text="11"/>
- <Cell col="13" text="12"/>
- <Cell col="14" text="13"/>
- <Cell col="15" text="14"/>
- <Cell col="16" text="15"/>
- <Cell col="17" text="16"/>
- <Cell col="18" text="17"/>
- <Cell col="19" text="18"/>
- <Cell col="20" text="19"/>
- <Cell col="21" text="20"/>
- <Cell col="22" text="21"/>
- <Cell col="23" text="22"/>
- <Cell col="24" text="23"/>
- <Cell col="25" text="24"/>
- <Cell col="26" text="25"/>
- <Cell col="27" text="26"/>
- <Cell col="28" text="27"/>
- <Cell col="29" text="28"/>
- <Cell col="30" text="29"/>
- <Cell col="31" text="30"/>
- <Cell col="32" text="31"/>
- <Cell col="33" text="Total"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" displaytype="normal" expr="expr:currow+1"/>
- <Cell col="1" style="align:left middle;" text="bind:tclsscrnnm"/>
- <Cell col="2" displaytype="number" style="align:right;" text="bind:d01"/>
- <Cell col="3" displaytype="number" style="align:right;" text="bind:d02"/>
- <Cell col="4" displaytype="number" style="align:right;" text="bind:d03"/>
- <Cell col="5" displaytype="normal" style="align:right;" text="bind:d04"/>
- <Cell col="6" displaytype="number" style="align:right;" text="bind:d05"/>
- <Cell col="7" displaytype="number" style="align:right;" text="bind:d06"/>
- <Cell col="8" displaytype="number" style="align:right;" text="bind:d07"/>
- <Cell col="9" displaytype="number" style="align:right;" text="bind:d08"/>
- <Cell col="10" displaytype="number" style="align:right;" text="bind:d09"/>
- <Cell col="11" displaytype="number" style="align:right;" text="bind:d10"/>
- <Cell col="12" displaytype="number" style="align:right;" text="bind:d11"/>
- <Cell col="13" displaytype="number" style="align:right;" text="bind:d12"/>
- <Cell col="14" displaytype="number" style="align:right;" text="bind:d13"/>
- <Cell col="15" displaytype="number" style="align:right;" text="bind:d14"/>
- <Cell col="16" displaytype="number" style="align:right;" text="bind:d15"/>
- <Cell col="17" displaytype="number" style="align:right;" text="bind:d16"/>
- <Cell col="18" displaytype="number" style="align:right;" text="bind:d17"/>
- <Cell col="19" displaytype="number" style="align:right;" text="bind:d18"/>
- <Cell col="20" displaytype="number" style="align:right;" text="bind:d19"/>
- <Cell col="21" displaytype="number" style="align:right;" text="bind:d20"/>
- <Cell col="22" displaytype="number" style="align:right;" text="bind:d21"/>
- <Cell col="23" displaytype="number" style="align:right;" text="bind:d22"/>
- <Cell col="24" displaytype="number" style="align:right;" text="bind:d23"/>
- <Cell col="25" displaytype="number" style="align:right;" text="bind:d24"/>
- <Cell col="26" displaytype="number" style="align:right;" text="bind:d25"/>
- <Cell col="27" displaytype="number" style="align:right;" text="bind:d26"/>
- <Cell col="28" displaytype="number" style="align:right;" text="bind:d27"/>
- <Cell col="29" displaytype="number" style="align:right;" text="bind:d28"/>
- <Cell col="30" displaytype="number" style="align:right;" text="bind:d29"/>
- <Cell col="31" displaytype="number" style="align:right;" text="bind:d30"/>
- <Cell col="32" displaytype="number" style="align:right;" text="bind:d31"/>
- <Cell col="33" displaytype="number" style="align:right;" text="bind:total"/>
- <Cell col="34"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="mm" text="월별 통계">
- <Layouts>
- <Layout>
- <Grid id="grd_mm" position="absolute 0 0 1256 701" style="align:right middle;" anchor="all" positiontype="position" autofittype="col" binddataset="ds_grid_grd_mm">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="30"/>
- <Column size="315"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- </Columns>
- <Rows>
- <Row size="22" band="head"/>
- <Row size="20"/>
- </Rows>
- <Band id="head">
- <Cell text="No."/>
- <Cell col="1" text="검사항목"/>
- <Cell col="2" text="01"/>
- <Cell col="3" text="02"/>
- <Cell col="4" text="03"/>
- <Cell col="5" text="04"/>
- <Cell col="6" text="05"/>
- <Cell col="7" text="06"/>
- <Cell col="8" text="07"/>
- <Cell col="9" text="08"/>
- <Cell col="10" text="09"/>
- <Cell col="11" text="10"/>
- <Cell col="12" text="11"/>
- <Cell col="13" text="12"/>
- <Cell col="14" text="Total"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" expr="expr:currow+1"/>
- <Cell col="1" style="align:left middle;" text="bind:tclsscrnnm"/>
- <Cell col="2" displaytype="number" style="align:right;" text="bind:d01"/>
- <Cell col="3" displaytype="number" style="align:right;" text="bind:d02"/>
- <Cell col="4" displaytype="number" style="align:right;" text="bind:d03"/>
- <Cell col="5" displaytype="number" style="align:right;" text="bind:d04"/>
- <Cell col="6" displaytype="number" style="align:right;" text="bind:d05"/>
- <Cell col="7" displaytype="number" style="align:right;" text="bind:d06"/>
- <Cell col="8" displaytype="number" style="align:right;" text="bind:d07"/>
- <Cell col="9" displaytype="number" style="align:right;" text="bind:d08"/>
- <Cell col="10" displaytype="number" style="align:right;" text="bind:d09"/>
- <Cell col="11" displaytype="number" style="align:right;" text="bind:d10"/>
- <Cell col="12" displaytype="number" style="align:right;" text="bind:d11"/>
- <Cell col="13" displaytype="number" style="align:right;" text="bind:d12"/>
- <Cell col="14" displaytype="number" style="align:right;" text="bind:total"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="yy" text="연별 통계">
- <Layouts>
- <Layout>
- <Grid id="grd_yy" position="absolute 0 0 1256 701" style="align:center middle;" anchor="all" positiontype="position">
- <Formats>
- <Format id="default"/>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- </Tabpages>
- </Tab>
- <Static id="caption6" class="tit_1" position="absolute 2 2 147 27" anchor="default" positiontype="position" text="장비별 검사 건수"/>
- <Button id="btn_print" class="btn6" visible="false" position="absolute 1200 0 1256 20" anchor="top right" positiontype="position" text="출력" onlbuttonup="btn_print_onlbuttonup"/>
- <Button id="btn_excel" class="btn7" position="absolute 1154 0 1256 20" anchor="top right" positiontype="position" text="EXCEL저장" onclick="btn_excel_onclick"/>
- <Div id="grp_sea" anchor="left top right" taborder="6" style="align:center top;" class="div_SA2" position="absolute 0 28 1256 70">
- <Layouts>
- <Layout width="1256" height="42">
- <Static id="caption4" text="통계 희망일" class="search_name" position="absolute 8 10 118 30" anchor="default"/>
- <Calendar id="ipt_workfromdd" taborder="1" class="input_search" position="absolute 99 10 189 30" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
- <Static id="caption9" text="~" position="absolute 189 10 205 30" anchor="default" style="align:center middle;"/>
- <Calendar id="ipt_worktodd" taborder="2" class="input_search" position="absolute 205 10 295 30" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
- <Static id="caption1" text="검사시행부서" class="search_name" position="absolute 319 10 432 30" anchor="default"/>
- <Combo id="combo1" taborder="3" position="absolute 418 10 520 30" anchor="default" innerdataset="@ds_init_lb0111" codecolumn="cd" datacolumn="nm" onitemchanged="grp_sea_combo1_onitemchanged"/>
- <Static id="caption5" text="장비" class="search_name" position="absolute 544 10 605 30" anchor="default"/>
- <Combo id="cmb_rtnabnflag" taborder="4" position="absolute 591 10 758 30" anchor="default" innerdataset="@ds_init_lb1111" codecolumn="cd" datacolumn="nm"/>
- <Button id="btn_ref" taborder="5" text="조회" onlbuttonup="btn_ref_onlbuttonup" class="btn1" position="absolute 1189 10 1245 30" anchor="top right"/>
- </Layout>
- </Layouts>
- </Div>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_init_lb0111" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_lb1111" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_grid_grd_dd" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged">
- <ColumnInfo>
- <column id="tclsscrnnm" type="STRING" size="256"/>
- <column id="tclsprntnm" type="STRING" size="256"/>
- <column id="d01" type="STRING" size="256"/>
- <column id="d02" type="STRING" size="256"/>
- <column id="d03" type="STRING" size="256"/>
- <column id="d04" type="STRING" size="256"/>
- <column id="d05" type="STRING" size="256"/>
- <column id="d06" type="STRING" size="256"/>
- <column id="d07" type="STRING" size="256"/>
- <column id="d08" type="STRING" size="256"/>
- <column id="d09" type="STRING" size="256"/>
- <column id="d10" type="STRING" size="256"/>
- <column id="d11" type="STRING" size="256"/>
- <column id="d12" type="STRING" size="256"/>
- <column id="d13" type="STRING" size="256"/>
- <column id="d14" type="STRING" size="256"/>
- <column id="d15" type="STRING" size="256"/>
- <column id="d16" type="STRING" size="256"/>
- <column id="d17" type="STRING" size="256"/>
- <column id="d18" type="STRING" size="256"/>
- <column id="d19" type="STRING" size="256"/>
- <column id="d20" type="STRING" size="256"/>
- <column id="d21" type="STRING" size="256"/>
- <column id="d22" type="STRING" size="256"/>
- <column id="d23" type="STRING" size="256"/>
- <column id="d24" type="STRING" size="256"/>
- <column id="d25" type="STRING" size="256"/>
- <column id="d26" type="STRING" size="256"/>
- <column id="d27" type="STRING" size="256"/>
- <column id="d28" type="STRING" size="256"/>
- <column id="d29" type="STRING" size="256"/>
- <column id="d30" type="STRING" size="256"/>
- <column id="d31" type="STRING" size="256"/>
- <column id="total" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_grid_grd_mm" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged">
- <ColumnInfo>
- <column id="tclsscrnnm" type="STRING" size="256"/>
- <column id="tclsprntnm" type="STRING" size="256"/>
- <column id="d01" type="STRING" size="256"/>
- <column id="d02" type="STRING" size="256"/>
- <column id="d03" type="STRING" size="256"/>
- <column id="d04" type="STRING" size="256"/>
- <column id="d05" type="STRING" size="256"/>
- <column id="d06" type="STRING" size="256"/>
- <column id="d07" type="STRING" size="256"/>
- <column id="d08" type="STRING" size="256"/>
- <column id="d09" type="STRING" size="256"/>
- <column id="d10" type="STRING" size="256"/>
- <column id="d11" type="STRING" size="256"/>
- <column id="d12" type="STRING" size="256"/>
- <Column id="total" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_temp_header" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged">
- <ColumnInfo>
- <Column id="colref" type="STRING" size="256"/>
- <Column id="caption" type="STRING" size="256"/>
- <Column id="type" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_temp_row" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged"/>
- <Dataset id="ds_data_yystats" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged">
- <ColumnInfo>
- <Column id="tclsscrnnm" type="STRING" size="255"/>
- <Column id="tclsprntnm" type="STRING" size="255"/>
- <Column id="rsltdispseq" type="STRING" size="255"/>
- <Column id="instcd" type="STRING" size="255"/>
- <Column id="lastreptdt" type="STRING" size="255"/>
- <Column id="stats" type="STRING" size="255"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_grid_grd_yy" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged"/>
- </Objects>
- <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";
- include "lis_commonxp::LZZ001.xjs";
- include "lis_commonxp::LLZ001.xjs";
- function SMLLS00800_oninit(obj:Form, e:InitEventInfo)
- {
- //폼 초기화 함수
- frmf_initForm(obj);
- }
- function SMLLS00800_onload(obj:Form, e:LoadEventInfo)
- {
- lf_getDbDeptcd("0111|1111|","cbf_SMLLS00800");
- lf_setInit(obj, e); //초기화 함수 호출
- }
- //초기화 함수
- function lf_setInit(obj, e) {
-
-
- }
- //통계희망일, 검사시행부서, 장비, 조회구분(일,월,연) 에 따른 조회
- function lf_getStats() {
-
- var refflag = "";
- var sDsName = "";
- if(swt_statflag.tabindex == 0) {
- refflag = "d";
- sDsName = "ds_grid_grd_dd";
- } else if(swt_statflag.tabindex == 1) {
- refflag = "m";
- sDsName = "ds_grid_grd_mm";
- } else if(swt_statflag.tabindex == 2) {
- lf_getYYStats();
- return;
- }
-
- var sectcd = grp_sea.combo1.value; // 계코드
- var testeqmtcd = grp_sea.cmb_rtnabnflag.value; // 장비코드
- var statshopefromdd = grp_sea.ipt_workfromdd.value; // 통계희망시작일
- var statshopetodd = grp_sea.ipt_worktodd.value; // 통계희망종료일
- var sInDsName = dsf_createDsRow("ds_temp_search"
- , [{col: "sectcd", val:sectcd }
- , {col: "testeqmtcd", val:testeqmtcd }
- , {col: "statshopefromdd", val:statshopefromdd }
- , {col: "statshopetodd", val:statshopetodd }
- , {col: "refflag", val:refflag }
- ]);
- var oParam = {};
- oParam.id = "TRLLS00801";
- oParam.service = "statsmngtapp.GeneralTestStatsRefMngt";
- oParam.method = "reqGetEqmtTestStats";
- oParam.inds = "cond="+sInDsName;
- oParam.outds = sDsName + "=getEqmtTestStats";
- oParam.async = false;
- oParam.callback = "cbf_SMLLS00800";
- tranf_submit(oParam);
- }
- //연별 통계 조회
- function lf_getYYStats() {
- ds_grid_grd_yy.clearData(); // 연별그리드 초기화
- var sectcd = grp_sea.combo1.value; // 계코드
- var testeqmtcd = grp_sea.cmb_rtnabnflag.value; // 장비코드
- var statshopefromdd = grp_sea.ipt_workfromdd.value; // 통계희망시작일
- var statshopetodd = grp_sea.ipt_worktodd.value; // 통계희망종료일
- var sInDsName = dsf_createDsRow("ds_temp_search"
- , [{col: "sectcd", val:sectcd }
- , {col: "testeqmtcd", val:testeqmtcd }
- , {col: "statshopefromdd", val:statshopefromdd }
- , {col: "statshopetodd", val:statshopetodd }
- ]);
- ds_temp_header.clearData();
- ds_data_yystats.clearData();
- var oParam = {};
- oParam.id = "TRLLS00802";
- oParam.service = "statsmngtapp.GeneralTestStatsRefMngt";
- oParam.method = "reqGetEqmtTestYYStats";
- oParam.inds = "cond="+sInDsName;
- oParam.outds = "ds_temp_header=header ds_grid_grd_yy=row ds_data_yystats=getEqmtTestYYStats";
- oParam.async = false;
- oParam.callback = "cbf_SMLLS00800";
- tranf_submit(oParam);
- }
- //연도별 통계 Total계산
- function lf_getTotal() {
- var r=0;
- var i=0;
- //Column 합계
- var colsum = 0;
- var rowsum = 0;
-
- for(r = 0; r < ds_grid_grd_yy.rowcount; r++) {
- colsum = 0;
- for(i = 0; i < ds_grid_grd_yy.colcount; i++) {
- if(utlf_isDigit(ds_grid_grd_yy.getColumn(r, i))) {
- colsum += toNumber(ds_grid_grd_yy.getColumn(r, i));
- }
- }
-
- ds_grid_grd_yy.setColumn(r, "total", colsum);
- }
- //Row 합계
- var addRw = ds_grid_grd_yy.addRow();
-
- for(i = 0; i <= ds_grid_grd_yy.colcount; i++) {
- rowsum = 0;
- for(r = 0; r < ds_grid_grd_yy.rowcount-1; r++) {
- if(!utlf_isNull(ds_grid_grd_yy.getColumn(r, i))) {
- rowsum += toNumber(ds_grid_grd_yy.getColumn(r, i));
- }
- }
-
- if(utlf_isNull(rowsum)){
- ds_grid_grd_yy.setColumn(addRw, i, "Total");
- } else {
- ds_grid_grd_yy.setColumn(addRw, i, rowsum);
- }
- }
-
- swt_statflag.yy.grd_yy.redraw();
- }
- // 엑셀 저장
- function lf_exeSaveToExcel() {
-
- var pGridId = "";
- var pGridNm = "";
- if(swt_statflag.tabindex == 0){
- pGridId = swt_statflag.dd.grd_dd;
- pGridNm = "일별통계";
- }else if(swt_statflag.tabindex == 1){
- pGridId = swt_statflag.mm.grd_mm;
- pGridNm = "월별통계";
- }else{
- pGridId = swt_statflag.yy.grd_yy;
- pGridNm = "연별통계";
- }
- grdf_exportExcel(pGridId, lf_lisGetTitle(this) + "_" + pGridNm, "sheet1", false);
- }
- // callback 함수
- function cbf_SMLLS00800(strSvcID, nErrorCode, strErrorMag) {
-
- if(nErrorCode != 0) {
- sysf_messageBox("ID: "+ strSvcID + " Error: " + strErrorMag, "E009", "");
- }else{
- switch(strSvcID){
- case "TRLZZ00101":
- var toDay = utlf_getCurrentDate();
- grp_sea.ipt_workfromdd.value = toDay; // 통계희망시작일 = 현재일자
- grp_sea.ipt_worktodd.value = toDay; // 통계희망종료일 = 현재일자
- grp_sea.combo1.value = "00"; // 계코드를 '전체'로 지정
- grp_sea.cmb_rtnabnflag.value = "00"; // 장비코드를 '전체'로 지정
- swt_statflag.tabindex = 0; // 초기시 일별그리드 표시
- break;
- case "TRLLS00801":
- break;
- case "TRLLS00802":
- //caption 정보
- var gridCaption = ds_temp_header.getColumn(0, "caption");
- if(utlf_isNull(gridCaption)) return;
- var gridColCapArray = gridCaption.split("^");
-
- //ref(Column) 정보
- var gridColRef = ds_temp_header.getColumn(0, "colref");
- var gridColRefArray = gridColRef.split("^");
-
- //type 정보
- var gridColType = ds_temp_header.getColumn(0, "type");
- var gridColTypeArray = gridColType.split("^");
-
- swt_statflag.yy.grd_yy.binddataset = "";
- swt_statflag.yy.grd_yy.deleteContentsRow("head",0);
- swt_statflag.yy.grd_yy.deleteContentsRow("body",0);
- swt_statflag.yy.grd_yy.appendContentsRow("head");
- swt_statflag.yy.grd_yy.appendContentsRow("body");
- swt_statflag.yy.grd_yy.binddataset = "ds_grid_grd_yy";
-
- swt_statflag.yy.grd_yy.setCellProperty("Head",0,"text", "No.");
- swt_statflag.yy.grd_yy.setCellProperty("body",0,"expr","expr:currow+1");
- swt_statflag.yy.grd_yy.setCellProperty("body",0,"celltype","head");
- swt_statflag.yy.grd_yy.setCellProperty("body",i,"align","center");
-
- for( var i = 1; i <= gridColRefArray.length; i++ ) {
- if(i == 1) {
- ds_grid_grd_yy.addColumn(gridColRefArray[i-1], "STRING", 150); // Grid 속성 지정
- swt_statflag.yy.grd_yy.appendContentsCol();
- swt_statflag.yy.grd_yy.setCellProperty("Head", i , "text", gridColCapArray[i-1]);
- swt_statflag.yy.grd_yy.setCellProperty("body",i,"text","bind:"+gridColRefArray[i-1]);
- swt_statflag.yy.grd_yy.setCellProperty("body",i,"align","left");
- } else {
- ds_grid_grd_yy.addColumn(gridColRefArray[i-1], "STRING", 60);
- swt_statflag.yy.grd_yy.appendContentsCol();
- swt_statflag.yy.grd_yy.setCellProperty("Head", i , "text", gridColCapArray[i-1]);
- swt_statflag.yy.grd_yy.setCellProperty("body",i,"text","bind:"+gridColRefArray[i-1]);
- swt_statflag.yy.grd_yy.setCellProperty("body",i,"displaytype","number");
- }
- }
-
- for(var i=0; i<swt_statflag.yy.grd_yy.getFormatColCount(); i++){
-
- if(i==0) {
- swt_statflag.yy.grd_yy.setFormatColProperty(0, "No.", 30);
- } else if(i==1){
- swt_statflag.yy.grd_yy.setFormatColProperty(i, "size", 200);
- }else{
- swt_statflag.yy.grd_yy.setFormatColProperty(i, "size", 60);
- swt_statflag.yy.grd_yy.setFormatColProperty(i, "displaytype", "number");
- }
- }
-
- lf_getTotal(); //연도별 Total 계산
-
- break;
- default:
- break;
- }
- }
- }
- function btn_ref_onlbuttonup(obj:Button, e:MouseEventInfo)
- {
- lf_getStats();
- }
- // btn_ddstats_onlbuttonup, btn_mmstats_onlbuttonup, btn_yystats_onlbuttonup 통합
- function swt_statflag_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
- {
- lf_gridInit();
- }
- function btn_print_onlbuttonup(obj:Button, e:MouseEventInfo)
- {
-
- }
- function btn_excel_onclick(obj:Button, e:ClickEventInfo)
- {
- lf_exeSaveToExcel();
- }
- function grp_sea_combo1_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- lf_setEqmtcd();
- }
- function lf_setEqmtcd(){
- var sectcd = grp_sea.combo1.value;
- //물질
- var sFilter = "cd =='00' || etc01 =='" + sectcd + "'";
- if(sectcd != "00"){
- ds_init_lb1111.filter(sFilter);
- }else{
- ds_init_lb1111.filter("");
- }
- grp_sea.cmb_rtnabnflag.index = 0;
- }
- ]]></Script>
- </Form>
- </FDL>
|