SMMNG03300_세탁물창고수불현황.xfdl 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMMNG03300" position="absolute 0 0 1187 741" titletext="세탁물 창고수불 관리" oninit="SMMNG03300_oninit" onload="SMMNG03300_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 65 1185 730" id="grp_biz" scrollbars="autoboth">
  8. <Layouts>
  9. <Layout>
  10. <Static text="세탁물 창고수불 관리" position="absolute 2 9 182 25" id="caption12" class="tit_2" anchor="default"/>
  11. <Shape position="absolute 0 25 1180 31" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
  12. <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">
  13. <Formats>
  14. <Format id="default">
  15. <Columns>
  16. <Column size="24"/>
  17. <Column size="94"/>
  18. <Column size="205"/>
  19. <Column size="198"/>
  20. <Column size="73"/>
  21. <Column size="0"/>
  22. <Column size="71"/>
  23. <Column size="73"/>
  24. <Column size="74"/>
  25. <Column size="0"/>
  26. <Column size="0"/>
  27. <Column size="0"/>
  28. <Column size="0"/>
  29. <Column size="0"/>
  30. <Column size="0"/>
  31. </Columns>
  32. <Rows>
  33. <Row size="24" band="head"/>
  34. <Row size="24"/>
  35. </Rows>
  36. <Band id="head">
  37. <Cell/>
  38. <Cell col="1" text="물품코드"/>
  39. <Cell col="2" text="물품명"/>
  40. <Cell col="3" text="규격"/>
  41. <Cell col="4" text="전월재고"/>
  42. <Cell col="5" text="전재고일자"/>
  43. <Cell col="6" text="입고"/>
  44. <Cell col="7" text="출고"/>
  45. <Cell col="8" text="현재고"/>
  46. <Cell col="9" text="현재고일자"/>
  47. <Cell col="10" text="비고"/>
  48. <Cell col="11" text="관리자"/>
  49. <Cell col="12" text="ioflag"/>
  50. <Cell col="13" text="일자"/>
  51. <Cell col="14" text="순번"/>
  52. </Band>
  53. <Band id="body">
  54. <Cell celltype="head"/>
  55. <Cell col="1" displaytype="normal" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:goodcd" wordwrap="char"/>
  56. <Cell col="2" displaytype="normal" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:goodnm" wordwrap="char"/>
  57. <Cell col="3" displaytype="normal" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:goodspec" wordwrap="char"/>
  58. <Cell col="4" displaytype="number" edittype="none" text="bind:bfstockcnt"/>
  59. <Cell col="5" displaytype="none" edittype="none" text="bind:bfstockdd" mask="yyyy-mm-dd"/>
  60. <Cell col="6" displaytype="number" edittype="text" text="bind:incnt"/>
  61. <Cell col="7" displaytype="number" edittype="text" text="bind:outcnt"/>
  62. <Cell col="8" displaytype="number" edittype="none" text="bind:nowstockcnt"/>
  63. <Cell col="9" text="bind:nowstockdd" mask="yyyy-mm-dd"/>
  64. <Cell col="10" displaytype="text" edittype="text" text="bind:remark1"/>
  65. <Cell col="11" displaytype="none" edittype="none" text="bind:lastupdtrid"/>
  66. <Cell col="12" text="bind:ioflag"/>
  67. <Cell col="13" text="bind:ioseq"/>
  68. <Cell col="14" text="bind:iodd"/>
  69. </Band>
  70. </Format>
  71. </Formats>
  72. </Grid>
  73. <Radio position="absolute 220 5 610 20" id="rdo_gubuncd" enable="false" visible="false" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1" anchor="default">
  74. <Dataset id="innerdataset">
  75. <ColumnInfo>
  76. <Column id="codecolumn"/>
  77. <Column id="datacolumn"/>
  78. </ColumnInfo>
  79. <Rows>
  80. <Row>
  81. <Col id="codecolumn">01</Col>
  82. <Col id="datacolumn">물품마스터</Col>
  83. </Row>
  84. <Row>
  85. <Col id="codecolumn">02</Col>
  86. <Col id="datacolumn">창고마스터</Col>
  87. </Row>
  88. </Rows>
  89. </Dataset>
  90. </Radio>
  91. <Button position="absolute 1137 3 1179 22" id="btn_sav" class="btn5" text="저장" anchor="default" onclick="grp_biz_btn_sav_onclick"/>
  92. </Layout>
  93. </Layouts>
  94. </Div>
  95. <Shape position="absolute 0 25 1185 60" id="roundrect1" class="roundrect_search" type="roundrectangle"/>
  96. <Button position="absolute 1005 33 1061 55" id="btn_search" class="btn1" taborder="2" text="조회" onclick="btn_search_onclick"/>
  97. <Shape position="absolute 992 32 998 57" linetype="vertical" id="line2" class="line_4"/>
  98. <Static text="일자:" position="absolute 285 35 366 52" id="cap_csrreqdeptcd" class="search_name"/>
  99. <Calendar position="absolute 345 33 430 52" id="ipt_iodd" class="input_default" mask="yyyy-mm-dd" oncloseup="ipt_iodd_oncloseup"/>
  100. <Static text="기관코드 :" position="absolute 10 35 96 52" id="cap_instcd" class="search_name"/>
  101. <Edit readonly="true" position="absolute 100 33 275 52" align="align:center middle;" id="opt_instcdnm" class="output"/>
  102. <Radio position="absolute 525 33 700 53" id="rdo_selyymmdd" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1" onitemchanged="rdo_selyymmdd_onitemchanged">
  103. <Dataset id="innerdataset">
  104. <ColumnInfo>
  105. <Column id="codecolumn"/>
  106. <Column id="datacolumn"/>
  107. </ColumnInfo>
  108. <Rows>
  109. <Row>
  110. <Col id="codecolumn">DD</Col>
  111. <Col id="datacolumn">일자별</Col>
  112. </Row>
  113. <Row>
  114. <Col id="codecolumn">MM</Col>
  115. <Col id="datacolumn">월별</Col>
  116. </Row>
  117. <Row>
  118. <Col id="codecolumn">DATE</Col>
  119. <Col id="datacolumn">기간별</Col>
  120. </Row>
  121. </Rows>
  122. </Dataset>
  123. </Radio>
  124. <Button position="absolute 1064 33 1120 55" id="button3" class="btn7" text="엑셀" onclick="button3_onclick"/>
  125. <Button position="absolute 1122 33 1178 55" id="btn_prt" class="btn6" text="출력" onclick="btn_prt_onclick"/>
  126. <Static text="구분일자:" position="absolute 440 35 521 52" id="caption1" class="search_name"/>
  127. <Calendar position="absolute 795 33 880 52" id="ipt_siodd" class="input_default" visible="false" mask="yyyy-mm-dd" oncloseup="ipt_siodd_oncloseup"/>
  128. <Calendar position="absolute 900 33 985 52" id="ipt_eiodd" class="input_default" visible="false" mask="yyyy-mm-dd" oncloseup="ipt_eiodd_oncloseup"/>
  129. <Static text="~" position="absolute 885 38 900 52" id="caption2" visible="false"/>
  130. <Static text="조회기간:" position="absolute 710 35 791 52" id="caption3" class="search_name" visible="false"/>
  131. <Static id="caption6" text="세탁물 창고수불 관리" class="tit_1" position="absolute 0 0 186 25"/>
  132. </Layout>
  133. </Layouts>
  134. <Objects>
  135. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  136. <ColumnInfo>
  137. <Column id="instcdnm" type="STRING" size="256"/>
  138. <Column id="iodd" type="STRING" size="256"/>
  139. <Column id="nowdd" type="STRING" size="256"/>
  140. <Column id="report" type="STRING" size="256"/>
  141. <Column id="selyymmdd" type="STRING" size="256"/>
  142. <Column id="gubuncd" type="STRING" size="256"/>
  143. <Column id="siodd" type="STRING" size="256"/>
  144. <Column id="eiodd" type="STRING" size="256"/>
  145. </ColumnInfo>
  146. <Rows>
  147. <Row>
  148. <Col id="instcdnm"/>
  149. <Col id="iodd"/>
  150. <Col id="nowdd"/>
  151. <Col id="report"/>
  152. <Col id="selyymmdd"/>
  153. <Col id="gubuncd">02</Col>
  154. <Col id="siodd"/>
  155. <Col id="eiodd"/>
  156. </Row>
  157. </Rows>
  158. </Dataset>
  159. <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  160. <ColumnInfo>
  161. <Column id="iodd" type="STRING" size="256"/>
  162. <Column id="selyymmdd" type="STRING" size="256"/>
  163. <Column id="siodd" type="STRING" size="256"/>
  164. <Column id="eiodd" type="STRING" size="256"/>
  165. </ColumnInfo>
  166. <Rows>
  167. <Row>
  168. <Col id="iodd"/>
  169. <Col id="selyymmdd">MM</Col>
  170. <Col id="siodd"/>
  171. <Col id="eiodd"/>
  172. </Row>
  173. </Rows>
  174. </Dataset>
  175. <Dataset id="ds_main_whioinfo_whiostatelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  176. <Dataset id="ds_send_savedata_whiolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  177. <Dataset id="ds_send_report_porqrexlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  178. </Objects>
  179. <Bind>
  180. <BindItem id="item0" compid="opt_instcdnm" propid="value" datasetid="ds_send" columnid="instcdnm"/>
  181. <BindItem id="item1" compid="ipt_iodd" propid="value" datasetid="ds_cond" columnid="iodd"/>
  182. <BindItem id="item2" compid="rdo_selyymmdd" propid="value" datasetid="ds_cond" columnid="selyymmdd"/>
  183. <BindItem id="item3" compid="ipt_siodd" propid="value" datasetid="ds_cond" columnid="siodd"/>
  184. <BindItem id="item4" compid="ipt_eiodd" propid="value" datasetid="ds_cond" columnid="eiodd"/>
  185. <BindItem id="item5" compid="grp_biz.rdo_gubuncd" propid="value" datasetid="ds_send" columnid="gubuncd"/>
  186. </Bind>
  187. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  188. * System Name :
  189. * Job Name :
  190. * Creator :
  191. * Make Date : 2017-07-11
  192. * Description :
  193. *---------------------------------------------------------------------------------------
  194. * Modify Date Modifier Modify Description
  195. *---------------------------------------------------------------------------------------
  196. * 2017-07-11 Live Converter TF->XP
  197. *
  198. *---------------------------------------------------------------------------------------
  199. ****************************************************************************************/
  200. include "com_commonxp::comm_main.xjs";
  201. var arErrorCode = new HashArray();
  202. function SMMNG03300_oninit(obj:Form, e:InitEventInfo)
  203. {
  204. frmf_initForm(obj); //폼 초기화
  205. grdf_setRowTypeIcon(grp_biz.grd_whiostatelist, 0);
  206. }
  207. function SMMNG03300_onload(obj:Form, e:LoadEventInfo)
  208. {
  209. fInitialize();
  210. }
  211. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  212. function fInitialize()
  213. {
  214. opt_instcdnm.value = sysf_getUserInfo("dutplceinstnm");//기관코드
  215. ipt_iodd.value = utlf_getCurrentDate();
  216. ipt_siodd.value = utlf_getCurrentDate();
  217. ipt_eiodd.value = utlf_getCurrentDate();
  218. fSearch();
  219. }
  220. function fSearch() {
  221. var iodd = ipt_iodd.value;
  222. var siodd = ipt_siodd.value;
  223. var eiodd = ipt_eiodd.value;
  224. if (rdo_selyymmdd.value == 'MM' ) {
  225. iodd = utlf_transNullToEmpty(String(iodd)).substr(0,6) ;
  226. } else if (rdo_selyymmdd.value == 'DD' ) {
  227. }
  228. ds_send.setColumn(0, "iodd", iodd);
  229. ds_send.setColumn(0, "siodd", siodd);
  230. ds_send.setColumn(0, "eiodd", eiodd);
  231. ds_send.setColumn(0, "nowdd", ipt_iodd.value);
  232. ds_send.setColumn(0, "selyymmdd", rdo_selyymmdd.value);
  233. ds_send.setColumn(0, "gubuncd", grp_biz.rdo_gubuncd.value);
  234. var nScrollPos = grp_biz.grd_whiostatelist.vscrollbar.pos;
  235. var oParam = {};
  236. oParam.id = "TRMNG03301";
  237. oParam.service = "csrapp.CsrDryMngt";
  238. oParam.method = "reqGetWhioStateList";
  239. oParam.inds = "req=ds_send";
  240. oParam.outds = "ds_main_whioinfo_whiostatelist=whiostatelist";
  241. oParam.async = false;
  242. tranf_submit(oParam);
  243. grp_biz.grd_whiostatelist.vscrollbar.pos = nScrollPos;
  244. //ds_main_whioinfo_whiostatelist.addColumn("incntedit", "string");
  245. //ds_main_whioinfo_whiostatelist.addColumn("outcntedit", "string");
  246. var ioflag;
  247. for(var i = 0; i < ds_main_whioinfo_whiostatelist.rowcount; i++) {
  248. ioflag = ds_main_whioinfo_whiostatelist.getColumn(i, "ioflag");
  249. if(ioflag == "N" || ioflag == "0") {
  250. ds_main_whioinfo_whiostatelist.enableevent = false;
  251. ds_main_whioinfo_whiostatelist.updatecontrol = false;
  252. ds_main_whioinfo_whiostatelist.setRowType(i, 2);
  253. ds_main_whioinfo_whiostatelist.updatecontrol = true;
  254. ds_main_whioinfo_whiostatelist.enableevent = true;
  255. }
  256. }
  257. if (rdo_selyymmdd.value == 'MM' ) {
  258. grp_biz.grd_whiostatelist.setCellProperty("head", grp_biz.grd_whiostatelist.getBindCellIndex("body", "bfstockcnt"), "text", "전월재고");
  259. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1"), "size", 0);
  260. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "nowstockdd"), "size", 0);
  261. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "lastupdtrid"), "size", 0);
  262. grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt"), "edittype", "none");
  263. grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt"), "edittype", "none");
  264. caption2.visible = false;
  265. caption3.visible = false;
  266. ipt_siodd.visible = false;
  267. ipt_eiodd.visible = false;
  268. grp_biz.btn_sav.enable = false;
  269. } else if (rdo_selyymmdd.value == 'DATE' ){
  270. grp_biz.grd_whiostatelist.setCellProperty("head", grp_biz.grd_whiostatelist.getBindCellIndex("body", "bfstockcnt"), "text", "전월재고");
  271. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1"), "size", 0);
  272. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "nowstockdd"), "size", 0);
  273. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "lastupdtrid"), "size", 0);
  274. grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt"), "edittype", "none");
  275. grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt"), "edittype", "none");
  276. caption2.visible = false;
  277. caption3.visible = false;
  278. ipt_siodd.visible = true;
  279. ipt_eiodd.visible = true;
  280. grp_biz.btn_sav.enable = false;
  281. } else if (rdo_selyymmdd.value == 'DD' ) {
  282. grp_biz.grd_whiostatelist.setCellProperty("head", grp_biz.grd_whiostatelist.getBindCellIndex("body", "bfstockcnt"), "text", "전월재고");
  283. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1"), "size", 100);
  284. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "nowstockdd"), "size", 0);
  285. grp_biz.grd_whiostatelist.setFormatColProperty(grp_biz.grd_whiostatelist.getBindCellIndex("body", "lastupdtrid"), "size", 0);
  286. grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt"), "edittype", "text");
  287. grp_biz.grd_whiostatelist.setCellProperty("body", grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt"), "edittype", "text");
  288. caption2.visible = false;
  289. caption3.visible = false;
  290. ipt_siodd.visible = false;
  291. ipt_eiodd.visible = false;
  292. grp_biz.btn_sav.enable = true;
  293. }
  294. }
  295. function ipt_iodd_oncloseup(obj:Calendar, e:CalendarCloseUpEventInfo)
  296. {
  297. fSearch();
  298. }
  299. function rdo_selyymmdd_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
  300. {
  301. fSearch();
  302. }
  303. function ipt_siodd_oncloseup(obj:Calendar, e:CalendarCloseUpEventInfo)
  304. {
  305. fSearch();
  306. }
  307. function ipt_eiodd_oncloseup(obj:Calendar, e:CalendarCloseUpEventInfo)
  308. {
  309. fSearch();
  310. }
  311. function btn_search_onclick(obj:Button, e:ClickEventInfo)
  312. {
  313. fSearch();
  314. }
  315. function button3_onclick(obj:Button, e:ClickEventInfo)
  316. {
  317. grdf_exportExcel(grd_list, "세탁물창고재고현황" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
  318. }
  319. function btn_prt_onclick(obj:Button, e:ClickEventInfo)
  320. {
  321. fPrintRex();
  322. }
  323. function fPrintRex() {
  324. dsf_createDs("ds_send_report_porqrexlist");
  325. ds_send_report_porqrexlist.copyData(ds_main_whioinfo_whiostatelist);
  326. //미리보기출력
  327. var objDOM = rptf_createDOM();
  328. rptf_setNodeListToDOM(objDOM, "root/main/whioinfo/whiostatelist", ds_send_report_porqrexlist); // 데이터셋 1
  329. var objParam = new Object();
  330. objParam.xml_data_XML1 = objDOM.documentElement.source; // 최상의노드 XML 스트링 추출
  331. var option = "open=1;save=1;directprint=0;print=1;zoom=0;";
  332. rptf_exeReportPreview30(["RPMNG03300"],[objParam], option);
  333. }
  334. function grp_biz_btn_sav_onclick(obj:Button, e:ClickEventInfo)
  335. {
  336. var updateData = grdf_getGridUpdateData(grp_biz.grd_whiostatelist);
  337. grdf_setStatusColumn(updateData, "status");
  338. ds_send_savedata_whiolist.copyData(updateData);
  339. var oParam = {};
  340. oParam.id = "TXMNG03201";
  341. oParam.service = "csrapp.CsrDryMngt";
  342. oParam.method = "reqExeWhioList";
  343. oParam.inds = "req=ds_send_savedata_whiolist";
  344. oParam.outds = "";
  345. oParam.async = false;
  346. tranf_submit(oParam);
  347. fSearch();
  348. }
  349. function grp_biz_grd_whiostatelist_onkeydown(obj:Grid, e:KeyEventInfo)
  350. {
  351. var row = ds_main_whioinfo_whiostatelist.rowposition;
  352. if (e.keycode == 13) { // Enter 쳤을 경우 아래 수량으로
  353. if (grp_biz.grd_whiostatelist.currentcol == grp_biz.grd_whiostatelist.getBindCellIndex("body", "incnt") ||
  354. grp_biz.grd_whiostatelist.currentcol == grp_biz.grd_whiostatelist.getBindCellIndex("body", "outcnt") ||
  355. grp_biz.grd_whiostatelist.currentcol == grp_biz.grd_whiostatelist.getBindCellIndex("body", "remark1")) { //불출수량이나 미불출수량 엔터시
  356. if (ds_main_whioinfo_whiostatelist.rowposition + 1 < ds_main_whioinfo_whiostatelist.rowcount) {
  357. ds_main_whioinfo_whiostatelist.rowposition = row + 1;
  358. }
  359. }
  360. }
  361. }
  362. ]]></Script>
  363. </Form>
  364. </FDL>