123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMMNG03300" position="absolute 0 0 1187 741" titletext="세탁물 창고수불 관리" oninit="SMMNG03300_oninit" onload="SMMNG03300_onload">
- <Layouts>
- <Layout>
- <Div position="absolute 0 65 1185 730" id="grp_biz" scrollbars="autoboth">
- <Layouts>
- <Layout>
- <Static text="세탁물 창고수불 관리" position="absolute 2 9 182 25" id="caption12" class="tit_2" anchor="default"/>
- <Shape position="absolute 0 25 1180 31" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
- <Grid position="absolute 0 30 1180 665" id="grd_whiostatelist" visible="true" binddataset="ds_main_whioinfo_whiostatelist" anchor="default" onkeydown="grp_biz_grd_whiostatelist_onkeydown" cellsizebandtype="allband" cellsizingtype="col">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="24"/>
- <Column size="94"/>
- <Column size="205"/>
- <Column size="198"/>
- <Column size="73"/>
- <Column size="0"/>
- <Column size="71"/>
- <Column size="73"/>
- <Column size="74"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- </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="규격"/>
- <Cell col="4" text="전월재고"/>
- <Cell col="5" text="전재고일자"/>
- <Cell col="6" text="입고"/>
- <Cell col="7" text="출고"/>
- <Cell col="8" text="현재고"/>
- <Cell col="9" text="현재고일자"/>
- <Cell col="10" text="비고"/>
- <Cell col="11" text="관리자"/>
- <Cell col="12" text="ioflag"/>
- <Cell col="13" text="일자"/>
- <Cell col="14" text="순번"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" displaytype="normal" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:goodcd" wordwrap="char"/>
- <Cell col="2" displaytype="normal" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:goodnm" wordwrap="char"/>
- <Cell col="3" displaytype="normal" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:goodspec" wordwrap="char"/>
- <Cell col="4" displaytype="number" edittype="none" text="bind:bfstockcnt"/>
- <Cell col="5" displaytype="none" edittype="none" text="bind:bfstockdd" mask="yyyy-mm-dd"/>
- <Cell col="6" displaytype="number" edittype="text" text="bind:incnt"/>
- <Cell col="7" displaytype="number" edittype="text" text="bind:outcnt"/>
- <Cell col="8" displaytype="number" edittype="none" text="bind:nowstockcnt"/>
- <Cell col="9" text="bind:nowstockdd" mask="yyyy-mm-dd"/>
- <Cell col="10" displaytype="text" edittype="text" text="bind:remark1"/>
- <Cell col="11" displaytype="none" edittype="none" text="bind:lastupdtrid"/>
- <Cell col="12" text="bind:ioflag"/>
- <Cell col="13" text="bind:ioseq"/>
- <Cell col="14" text="bind:iodd"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Radio position="absolute 220 5 610 20" id="rdo_gubuncd" enable="false" visible="false" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1" anchor="default">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">01</Col>
- <Col id="datacolumn">물품마스터</Col>
- </Row>
- <Row>
- <Col id="codecolumn">02</Col>
- <Col id="datacolumn">창고마스터</Col>
- </Row>
- </Rows>
- </Dataset>
- </Radio>
- <Button position="absolute 1137 3 1179 22" id="btn_sav" class="btn5" text="저장" anchor="default" onclick="grp_biz_btn_sav_onclick"/>
- </Layout>
- </Layouts>
- </Div>
- <Shape position="absolute 0 25 1185 60" id="roundrect1" class="roundrect_search" type="roundrectangle"/>
- <Button position="absolute 1005 33 1061 55" id="btn_search" class="btn1" taborder="2" text="조회" onclick="btn_search_onclick"/>
- <Shape position="absolute 992 32 998 57" linetype="vertical" id="line2" class="line_4"/>
- <Static text="일자:" position="absolute 285 35 366 52" id="cap_csrreqdeptcd" class="search_name"/>
- <Calendar position="absolute 345 33 430 52" id="ipt_iodd" class="input_default" mask="yyyy-mm-dd" oncloseup="ipt_iodd_oncloseup"/>
- <Static text="기관코드 :" position="absolute 10 35 96 52" id="cap_instcd" class="search_name"/>
- <Edit readonly="true" position="absolute 100 33 275 52" align="align:center middle;" id="opt_instcdnm" class="output"/>
- <Radio position="absolute 525 33 700 53" id="rdo_selyymmdd" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1" onitemchanged="rdo_selyymmdd_onitemchanged">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">DD</Col>
- <Col id="datacolumn">일자별</Col>
- </Row>
- <Row>
- <Col id="codecolumn">MM</Col>
- <Col id="datacolumn">월별</Col>
- </Row>
- <Row>
- <Col id="codecolumn">DATE</Col>
- <Col id="datacolumn">기간별</Col>
- </Row>
- </Rows>
- </Dataset>
- </Radio>
- <Button position="absolute 1064 33 1120 55" id="button3" class="btn7" text="엑셀" onclick="button3_onclick"/>
- <Button position="absolute 1122 33 1178 55" id="btn_prt" class="btn6" text="출력" onclick="btn_prt_onclick"/>
- <Static text="구분일자:" position="absolute 440 35 521 52" id="caption1" class="search_name"/>
- <Calendar position="absolute 795 33 880 52" id="ipt_siodd" class="input_default" visible="false" mask="yyyy-mm-dd" oncloseup="ipt_siodd_oncloseup"/>
- <Calendar position="absolute 900 33 985 52" id="ipt_eiodd" class="input_default" visible="false" mask="yyyy-mm-dd" oncloseup="ipt_eiodd_oncloseup"/>
- <Static text="~" position="absolute 885 38 900 52" id="caption2" visible="false"/>
- <Static text="조회기간:" position="absolute 710 35 791 52" id="caption3" class="search_name" visible="false"/>
- <Static id="caption6" text="세탁물 창고수불 관리" class="tit_1" position="absolute 0 0 186 25"/>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="instcdnm" type="STRING" size="256"/>
- <Column id="iodd" type="STRING" size="256"/>
- <Column id="nowdd" type="STRING" size="256"/>
- <Column id="report" type="STRING" size="256"/>
- <Column id="selyymmdd" type="STRING" size="256"/>
- <Column id="gubuncd" type="STRING" size="256"/>
- <Column id="siodd" type="STRING" size="256"/>
- <Column id="eiodd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcdnm"/>
- <Col id="iodd"/>
- <Col id="nowdd"/>
- <Col id="report"/>
- <Col id="selyymmdd"/>
- <Col id="gubuncd">02</Col>
- <Col id="siodd"/>
- <Col id="eiodd"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="iodd" type="STRING" size="256"/>
- <Column id="selyymmdd" type="STRING" size="256"/>
- <Column id="siodd" type="STRING" size="256"/>
- <Column id="eiodd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="iodd"/>
- <Col id="selyymmdd">MM</Col>
- <Col id="siodd"/>
- <Col id="eiodd"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_whioinfo_whiostatelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_send_savedata_whiolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_send_report_porqrexlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="opt_instcdnm" propid="value" datasetid="ds_send" columnid="instcdnm"/>
- <BindItem id="item1" compid="ipt_iodd" propid="value" datasetid="ds_cond" columnid="iodd"/>
- <BindItem id="item2" compid="rdo_selyymmdd" propid="value" datasetid="ds_cond" columnid="selyymmdd"/>
- <BindItem id="item3" compid="ipt_siodd" propid="value" datasetid="ds_cond" columnid="siodd"/>
- <BindItem id="item4" compid="ipt_eiodd" propid="value" datasetid="ds_cond" columnid="eiodd"/>
- <BindItem id="item5" compid="grp_biz.rdo_gubuncd" propid="value" datasetid="ds_send" columnid="gubuncd"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-07-11
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-07-11 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- var arErrorCode = new HashArray();
- function SMMNG03300_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj); //폼 초기화
- grdf_setRowTypeIcon(grp_biz.grd_whiostatelist, 0);
- }
- function SMMNG03300_onload(obj:Form, e:LoadEventInfo)
- {
- fInitialize();
- }
- // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
- function fInitialize()
- {
- opt_instcdnm.value = sysf_getUserInfo("dutplceinstnm");//기관코드
-
- ipt_iodd.value = utlf_getCurrentDate();
- ipt_siodd.value = utlf_getCurrentDate();
- ipt_eiodd.value = utlf_getCurrentDate();
-
- fSearch();
- }
- function fSearch() {
- var iodd = ipt_iodd.value;
- var siodd = ipt_siodd.value;
- var eiodd = ipt_eiodd.value;
-
- if (rdo_selyymmdd.value == 'MM' ) {
- iodd = utlf_transNullToEmpty(String(iodd)).substr(0,6) ;
- } else if (rdo_selyymmdd.value == 'DD' ) {
- }
-
- ds_send.setColumn(0, "iodd", iodd);
- ds_send.setColumn(0, "siodd", siodd);
- ds_send.setColumn(0, "eiodd", eiodd);
- ds_send.setColumn(0, "nowdd", ipt_iodd.value);
- ds_send.setColumn(0, "selyymmdd", rdo_selyymmdd.value);
- ds_send.setColumn(0, "gubuncd", grp_biz.rdo_gubuncd.value);
-
- var nScrollPos = grp_biz.grd_whiostatelist.vscrollbar.pos;
-
- var oParam = {};
- oParam.id = "TRMNG03301";
- oParam.service = "csrapp.CsrDryMngt";
- oParam.method = "reqGetWhioStateList";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_whioinfo_whiostatelist=whiostatelist";
- oParam.async = false;
- tranf_submit(oParam);
-
- grp_biz.grd_whiostatelist.vscrollbar.pos = nScrollPos;
-
- //ds_main_whioinfo_whiostatelist.addColumn("incntedit", "string");
- //ds_main_whioinfo_whiostatelist.addColumn("outcntedit", "string");
-
- var ioflag;
- for(var i = 0; i < ds_main_whioinfo_whiostatelist.rowcount; i++) {
- ioflag = ds_main_whioinfo_whiostatelist.getColumn(i, "ioflag");
- if(ioflag == "N" || ioflag == "0") {
- ds_main_whioinfo_whiostatelist.enableevent = false;
- ds_main_whioinfo_whiostatelist.updatecontrol = false;
- ds_main_whioinfo_whiostatelist.setRowType(i, 2);
- ds_main_whioinfo_whiostatelist.updatecontrol = true;
- ds_main_whioinfo_whiostatelist.enableevent = true;
- }
- }
-
- if (rdo_selyymmdd.value == 'MM' ) {
- grp_biz.grd_whiostatelist.setCellProperty("head", grp_biz.grd_whiostatelist.getBindCellIndex("body", "bfstockcnt"), "text", "전월재고");
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1"), "size", 0);
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "nowstockdd"), "size", 0);
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "lastupdtrid"), "size", 0);
-
- grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt"), "edittype", "none");
- grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt"), "edittype", "none");
-
-
- caption2.visible = false;
- caption3.visible = false;
- ipt_siodd.visible = false;
- ipt_eiodd.visible = false;
- grp_biz.btn_sav.enable = false;
- } else if (rdo_selyymmdd.value == 'DATE' ){
- grp_biz.grd_whiostatelist.setCellProperty("head", grp_biz.grd_whiostatelist.getBindCellIndex("body", "bfstockcnt"), "text", "전월재고");
-
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1"), "size", 0);
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "nowstockdd"), "size", 0);
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "lastupdtrid"), "size", 0);
-
- grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt"), "edittype", "none");
- grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt"), "edittype", "none");
-
- caption2.visible = false;
- caption3.visible = false;
-
- ipt_siodd.visible = true;
- ipt_eiodd.visible = true;
- grp_biz.btn_sav.enable = false;
- } else if (rdo_selyymmdd.value == 'DD' ) {
- grp_biz.grd_whiostatelist.setCellProperty("head", grp_biz.grd_whiostatelist.getBindCellIndex("body", "bfstockcnt"), "text", "전월재고");
-
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1"), "size", 100);
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "nowstockdd"), "size", 0);
- grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "lastupdtrid"), "size", 0);
-
- grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt"), "edittype", "text");
- grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt"), "edittype", "text");
-
- caption2.visible = false;
- caption3.visible = false;
-
- ipt_siodd.visible = false;
- ipt_eiodd.visible = false;
- grp_biz.btn_sav.enable = true;
- }
- }
- function ipt_iodd_oncloseup(obj:Calendar, e:CalendarCloseUpEventInfo)
- {
- fSearch();
- }
- function rdo_selyymmdd_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
- {
- fSearch();
- }
- function ipt_siodd_oncloseup(obj:Calendar, e:CalendarCloseUpEventInfo)
- {
- fSearch();
- }
- function ipt_eiodd_oncloseup(obj:Calendar, e:CalendarCloseUpEventInfo)
- {
- fSearch();
- }
- function btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- fSearch();
- }
- function button3_onclick(obj:Button, e:ClickEventInfo)
- {
- grdf_exportExcel(grd_list, "세탁물창고재고현황" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
- }
- function btn_prt_onclick(obj:Button, e:ClickEventInfo)
- {
- fPrintRex();
- }
- function fPrintRex() {
- dsf_createDs("ds_send_report_porqrexlist");
-
- ds_send_report_porqrexlist.copyData(ds_main_whioinfo_whiostatelist);
-
- //미리보기출력
- var objDOM = rptf_createDOM();
- rptf_setNodeListToDOM(objDOM, "root/main/whioinfo/whiostatelist", ds_send_report_porqrexlist); // 데이터셋 1
-
- var objParam = new Object();
- objParam.xml_data_XML1 = objDOM.documentElement.source; // 최상의노드 XML 스트링 추출
-
- var option = "open=1;save=1;directprint=0;print=1;zoom=0;";
- rptf_exeReportPreview30(["RPMNG03300"],[objParam], option);
- }
- function grp_biz_btn_sav_onclick(obj:Button, e:ClickEventInfo)
- {
- var updateData = grdf_getGridUpdateData(grp_biz.grd_whiostatelist);
- grdf_setStatusColumn(updateData, "status");
- ds_send_savedata_whiolist.copyData(updateData);
- var oParam = {};
- oParam.id = "TXMNG03201";
- oParam.service = "csrapp.CsrDryMngt";
- oParam.method = "reqExeWhioList";
- oParam.inds = "req=ds_send_savedata_whiolist";
- oParam.outds = "";
- oParam.async = false;
- tranf_submit(oParam);
-
- fSearch();
- }
- function grp_biz_grd_whiostatelist_onkeydown(obj:Grid, e:KeyEventInfo)
- {
- var row = ds_main_whioinfo_whiostatelist.rowposition;
- if (e.keycode == 13) { // Enter 쳤을 경우 아래 수량으로
- if (grp_biz.grd_whiostatelist.currentcol == grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt") ||
- grp_biz.grd_whiostatelist.currentcol == grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt") ||
- grp_biz.grd_whiostatelist.currentcol == grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1")) { //불출수량이나 미불출수량 엔터시
- if (ds_main_whioinfo_whiostatelist.rowposition + 1 < ds_main_whioinfo_whiostatelist.rowcount) {
- ds_main_whioinfo_whiostatelist.rowposition = row + 1;
- }
- }
- }
- }
- ]]></Script>
- </Form>
- </FDL>
|