SMRST02800_품목별 입출고현황 출력.xfdl 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRST02800" position="absolute 0 0 1200 790" titletext="품목별 입출고현황 출력" oninit="SMRST02800_oninit" onload="SMRST02800_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 0 1195 23" id="group1">
  8. <Layouts>
  9. <Layout>
  10. <Static text="품목별 입출고현황 출력" position="absolute 0 0 174 24" id="caption6" class="tit_1" anchor="default"/>
  11. </Layout>
  12. </Layouts>
  13. </Div>
  14. <Div position="absolute 0 38 1195 782" id="group5" scrollbars="autoboth">
  15. <Layouts>
  16. <Layout>
  17. <Static text="품목별 입출고현황" position="absolute 0 82 216 98" id="caption21" class="tit_2"/>
  18. <Div position="absolute 0 13 1195 74" align="align:center top;" id="group6" class="div_SA">
  19. <Layouts>
  20. <Layout>
  21. <Static text="기관코드 :" position="absolute 15 9 88 26" id="cap_instcd" class="search_name"/>
  22. <Static text="기 준 월 :" position="absolute 323 9 396 26" id="cap_stocym" class="search_name"/>
  23. <Static text="조회구분 :" position="absolute 595 9 672 26" id="cap_prtflag" class="search_name"/>
  24. <Combo position="absolute 90 8 231 27" align="align:center middle;" id="cmb_instcd" class="combo_essential" enable="false" innerdataset="@ds_init_instcd" datacolumn="cdnm" codecolumn="cdid"/>
  25. <Calendar position="absolute 396 8 501 27" id="ipt_stocym" class="input_essential" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  26. <Radio position="absolute 673 8 880 28" id="rdo_prtflag" columncount="2" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="group5_group6_rdo_prtflag_onitemchanged">
  27. <Dataset id="innerdataset">
  28. <ColumnInfo>
  29. <Column id="codecolumn"/>
  30. <Column id="datacolumn"/>
  31. </ColumnInfo>
  32. <Rows>
  33. <Row>
  34. <Col id="codecolumn">A</Col>
  35. <Col id="datacolumn">불출부서별</Col>
  36. </Row>
  37. <Row>
  38. <Col id="codecolumn">B</Col>
  39. <Col id="datacolumn">약품코드별</Col>
  40. </Row>
  41. </Rows>
  42. </Dataset>
  43. </Radio>
  44. <Button position="absolute 870 35 886 51" id="button3" class="icon_search" visible="false" text="" onclick="group5_group6_button3_onclick"/>
  45. <Edit position="absolute 790 35 868 54" id="ipt_stocdeptcd" class="input_essential" visible="false" autoselect="true"/>
  46. <Edit position="absolute 895 35 1022 54" id="ipt_stocdeptnm" class="input_essential" visible="false" autoselect="true"/>
  47. <Static text="부 서 :" position="absolute 710 35 790 52" id="caption1" class="search_name" visible="false"/>
  48. <Static text="물품구분 :" position="absolute 520 35 593 52" id="cap_goodflag" class="search_name" visible="false"/>
  49. <Combo position="absolute 595 34 736 53" id="cmb_goodflag" class="combo_essential" visible="false" innerdataset="@ds_init_goodflag" datacolumn="cdnm" codecolumn="cdid"/>
  50. <Button position="absolute 1125 20 1181 42" align="align:left middle;" id="button4" class="btn1" taborder="8" text="조회" onclick="group5_group6_button4_onclick"/>
  51. <Shape position="absolute 1107 9 1113 52" linetype="vertical" id="line14" class="line_4"/>
  52. <Edit position="absolute 224 34 439 53" id="ipt_goodnm" class="input_fix" autoselect="true" onkeydown="group5_group6_ipt_goodnm_onkeydown"/>
  53. <Button position="absolute 205 35 221 51" id="btn_searchgoodcd" class="icon_search" text="" onclick="group5_group6_btn_searchgoodcd_onclick"/>
  54. <Edit position="absolute 90 34 201 53" id="ipt_goodcd" class="input_essential" autoselect="true" onkeydown="group5_group6_ipt_goodcd_onkeydown"/>
  55. <Static text="약품코드 :" position="absolute 15 35 90 52" id="caption2" class="search_name"/>
  56. </Layout>
  57. </Layouts>
  58. </Div>
  59. <Shape position="absolute 0 98 1195 104" linetype="horizontal" id="line15" class="line_10"/>
  60. <Grid position="absolute 0 103 1195 734" id="grd_goodinoutlist" binddataset="ds_main_goodinoutinfo_goodinoutlist">
  61. <Formats>
  62. <Format id="default">
  63. <Columns>
  64. <Column size="20" band="left"/>
  65. <Column size="115"/>
  66. <Column size="91"/>
  67. <Column size="314"/>
  68. <Column size="56"/>
  69. <Column size="102"/>
  70. <Column size="60"/>
  71. <Column size="72"/>
  72. <Column size="60"/>
  73. <Column size="62"/>
  74. <Column size="60"/>
  75. <Column size="64"/>
  76. <Column size="60"/>
  77. <Column size="78"/>
  78. </Columns>
  79. <Rows>
  80. <Row size="24" band="head"/>
  81. <Row size="24" band="head"/>
  82. <Row size="24"/>
  83. </Rows>
  84. <Band id="head">
  85. <Cell rowspan="2" taborder="undefined"/>
  86. <Cell col="1" rowspan="2" text="불출부서" taborder="undefined"/>
  87. <Cell col="2" rowspan="2" text="물품코드" taborder="undefined"/>
  88. <Cell col="3" rowspan="2" text="품명 및 규격" taborder="undefined"/>
  89. <Cell col="4" rowspan="2" text="단 위" taborder="undefined"/>
  90. <Cell col="5" rowspan="2" text="단 가" taborder="undefined"/>
  91. <Cell col="6" colspan="2" text="전월재고" taborder="undefined"/>
  92. <Cell col="8" colspan="2" text="입고량" taborder="undefined"/>
  93. <Cell col="10" colspan="2" text="출고량" taborder="undefined"/>
  94. <Cell col="12" colspan="2" text="재고량" taborder="undefined"/>
  95. <Cell row="1" col="6" text="수량"/>
  96. <Cell row="1" col="7" text="금액"/>
  97. <Cell row="1" col="8" text="수량"/>
  98. <Cell row="1" col="9" text="금액"/>
  99. <Cell row="1" col="10" text="수량"/>
  100. <Cell row="1" col="11" text="금액"/>
  101. <Cell row="1" col="12" text="수량"/>
  102. <Cell row="1" col="13" text="금액"/>
  103. </Band>
  104. <Band id="body">
  105. <Cell celltype="head" expr="expr:currow + 1"/>
  106. <Cell col="1" style="align:left;" text="bind:stkdeptnm"/>
  107. <Cell col="2" style="align:left;" text="bind:goodcd"/>
  108. <Cell col="3" style="align:left;" text="bind:goodnm"/>
  109. <Cell col="4" style="align:right;" text="bind:purcunit"/>
  110. <Cell col="5" displaytype="number" text="bind:unitcost" mask="#,###.##"/>
  111. <Cell col="6" style="align:right;" text="bind:beftotqty"/>
  112. <Cell col="7" displaytype="number" text="bind:beftotamt" mask="#,##0.##"/>
  113. <Cell col="8" style="align:right;" text="bind:winqty"/>
  114. <Cell col="9" displaytype="number" text="bind:winamt" mask="#,##0.##"/>
  115. <Cell col="10" style="align:right;" text="bind:outqty"/>
  116. <Cell col="11" displaytype="number" text="bind:outamt" mask="#,##0.##"/>
  117. <Cell col="12" style="align:right;" text="bind:stocqty"/>
  118. <Cell col="13" displaytype="number" text="bind:stocamt" mask="#,##0.##"/>
  119. </Band>
  120. </Format>
  121. </Formats>
  122. </Grid>
  123. <Button position="absolute 1108 77 1194 96" id="button1" class="btn2" text="엑셀파일저장" onclick="group5_button1_onclick"/>
  124. <Button position="absolute 1020 77 1106 96" id="button2" class="btn2" visible="false" text="엑셀파일열기"/>
  125. <Div position="absolute 55 75 470 240" id="group2" visible="false">
  126. <Layouts>
  127. <Layout>
  128. <Grid position="absolute 0 25 410 164" id="grd_goodlist" visible="true" binddataset="ds_init_main_goodlist" oncelldblclick="group5_group2_grd_goodlist_oncelldblclick">
  129. <Formats>
  130. <Format id="default">
  131. <Columns>
  132. <Column size="20" band="left"/>
  133. <Column size="102"/>
  134. <Column size="270"/>
  135. <Column size="0"/>
  136. <Column size="0"/>
  137. </Columns>
  138. <Rows>
  139. <Row size="24" band="head"/>
  140. <Row size="24"/>
  141. </Rows>
  142. <Band id="head">
  143. <Cell/>
  144. <Cell col="1" text="약품코드"/>
  145. <Cell col="2" text="약품명"/>
  146. <Cell col="3" text="기관코드"/>
  147. <Cell col="4" text="물품구분"/>
  148. </Band>
  149. <Band id="body">
  150. <Cell celltype="head"/>
  151. <Cell col="1" edittype="none" style="align:left;" text="bind:goodcd"/>
  152. <Cell col="2" edittype="none" style="align:left;" text="bind:goodnm"/>
  153. <Cell col="3" text="bind:instcd"/>
  154. <Cell col="4" text="bind:goodflag"/>
  155. </Band>
  156. </Format>
  157. </Formats>
  158. </Grid>
  159. <Button position="absolute 340 4 393 23" id="button5" class="btn2" text="숨기기" onclick="group5_group2_button5_onclick"/>
  160. </Layout>
  161. </Layouts>
  162. </Div>
  163. </Layout>
  164. </Layouts>
  165. </Div>
  166. <Div position="absolute 0 22 1195 50" id="group4" scrollbars="autoboth">
  167. <Layouts>
  168. <Layout>
  169. <Button position="absolute 0 2 56 24" id="button46" class="btn6" visible="false" text="출력" anchor="default"/>
  170. <Shape position="absolute 0 22 1195 28" linetype="horizontal" id="line1" class="line_6" anchor="default"/>
  171. <Button position="absolute 1127 2 1195 24" id="btn_init" class="btn4" text="초기화" anchor="default" onclick="group4_btn_init_onclick"/>
  172. </Layout>
  173. </Layouts>
  174. </Div>
  175. </Layout>
  176. </Layouts>
  177. <Objects>
  178. <Dataset id="ds_init_instcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  179. <ColumnInfo>
  180. <Column id="cdnm" type="STRING"/>
  181. <Column id="cdid" type="STRING"/>
  182. </ColumnInfo>
  183. </Dataset>
  184. <Dataset id="ds_init_goodflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  185. <ColumnInfo>
  186. <Column id="cdnm" type="STRING"/>
  187. <Column id="cdid" type="STRING"/>
  188. </ColumnInfo>
  189. </Dataset>
  190. <Dataset id="ds_send_goodiolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  191. <ColumnInfo>
  192. <Column id="refcond" type="STRING" size="256" sumtext="조회조건 "/>
  193. <Column id="instcd" type="STRING" size="256" sumtext="기관코드 "/>
  194. <Column id="goodflag" type="STRING" size="256" sumtext="물품구분 "/>
  195. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드 "/>
  196. <Column id="goodnm" type="STRING" size="256" sumtext="물품명 "/>
  197. </ColumnInfo>
  198. <Rows>
  199. <Row/>
  200. </Rows>
  201. </Dataset>
  202. <Dataset id="ds_init_main_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  203. <ColumnInfo>
  204. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드 "/>
  205. <Column id="goodnm" type="STRING" size="256" sumtext="goodnm "/>
  206. <Column id="goodspec" type="STRING" size="256" sumtext="물품규격 "/>
  207. <Column id="userqty" type="STRING" size="256" sumtext="사용자입력수량 "/>
  208. <Column id="deliveunit" type="STRING" size="256" sumtext="수불단위 "/>
  209. <Column id="estmamt" type="BIGDECIMAL" size="256" sumtext="견적가 "/>
  210. <Column id="goodmodel" type="STRING" size="256" sumtext="모델 "/>
  211. <Column id="prodcmpynm" type="STRING" size="256" sumtext="제조회사명 "/>
  212. <Column id="prodcmpycd" type="STRING" size="256" sumtext="제조회사코드 "/>
  213. <Column id="todd" type="STRING" size="256" sumtext="todd "/>
  214. <Column id="instcd" type="STRING" size="256" sumtext="기관코드 "/>
  215. <Column id="useyn" type="STRING" size="256" sumtext="사용여부 "/>
  216. <Column id="fromdd" type="STRING" size="256" sumtext="fromdd "/>
  217. <Column id="goodflag" type="STRING" size="256" sumtext="물품구분(r0025) "/>
  218. <Column id="goodhngnm" type="STRING" size="256" sumtext="영문명 "/>
  219. <Column id="goodengnm" type="STRING" size="256" sumtext="물품명 "/>
  220. <Column id="lrgcd" type="STRING" size="256" sumtext="대분류코드 "/>
  221. <Column id="lrgnm" type="STRING" size="256" sumtext="대분류명 "/>
  222. <Column id="mdlcd" type="STRING" size="256" sumtext="중분류코드 "/>
  223. <Column id="mdlnm" type="STRING" size="256" sumtext="중분류명 "/>
  224. <Column id="smlcd" type="STRING" size="256" sumtext="소분류코드 "/>
  225. <Column id="smlnm" type="STRING" size="256" sumtext="소분류 "/>
  226. <Column id="winacnt" type="STRING" size="256" sumtext="계정코드 "/>
  227. <Column id="winacntnm" type="STRING" size="256" sumtext="계정코드명 "/>
  228. <Column id="amtacnt" type="STRING" size="256" sumtext="비용계정 "/>
  229. <Column id="amtacntnm" type="STRING" size="256" sumtext="비용계정명 "/>
  230. <Column id="mainmngtdeptcd" type="STRING" size="256" sumtext="주관리부서코드 "/>
  231. <Column id="mainmngtdeptnm" type="STRING" size="256" sumtext="주관리부서명 "/>
  232. <Column id="stocmngtflag" type="STRING" size="256" sumtext="재고관리기준 "/>
  233. <Column id="purcunit" type="STRING" size="256" sumtext="입고단위 "/>
  234. <Column id="purcunitnm" type="STRING" size="256" sumtext="입고단위 "/>
  235. <Column id="deliveunitnm" type="STRING" size="256" sumtext="수불단위 "/>
  236. <Column id="exchqty" type="BIGDECIMAL" size="256" sumtext="환산배수 "/>
  237. <Column id="minexch" type="BIGDECIMAL" size="256" sumtext="최소환산수량 "/>
  238. <Column id="divusenvalqty" type="STRING" size="256" sumtext="분할사용수치 "/>
  239. <Column id="edicd" type="STRING" size="256" sumtext="edi코드 "/>
  240. <Column id="reqflag" type="STRING" size="256" sumtext="청구기준 "/>
  241. <Column id="reqflagnm" type="STRING" size="256" sumtext="청구기준명 "/>
  242. <Column id="reqmthd" type="STRING" size="256" sumtext="청구방법 "/>
  243. <Column id="reqprid" type="STRING" size="256" sumtext="청구주기 "/>
  244. <Column id="prodplce" type="STRING" size="256" sumtext="제조국 "/>
  245. <Column id="prodplcenm" type="STRING" size="256" sumtext="제조국명 "/>
  246. <Column id="maincustlastsuplplce" type="STRING" size="256" sumtext="최종공급처 "/>
  247. <Column id="maincustlastsuplplcenm" type="STRING" size="256" sumtext="최종공급처 "/>
  248. <Column id="suppcustcd" type="STRING" size="256" sumtext="보조거래처코드 "/>
  249. <Column id="suppcustnm" type="STRING" size="256" sumtext="보조거래처명 "/>
  250. <Column id="forgncurncyunitcost" type="BIGDECIMAL" size="256" sumtext="외화단가 "/>
  251. <Column id="curncyunit" type="STRING" size="256" sumtext="화폐단위 "/>
  252. <Column id="curncyunitnm" type="STRING" size="256" sumtext="화폐단위 "/>
  253. <Column id="goodunitcost" type="BIGDECIMAL" size="256" sumtext="제품단가 "/>
  254. <Column id="purcflag" type="STRING" size="256" sumtext="구매구분 "/>
  255. <Column id="safestocqty" type="BIGDECIMAL" size="256" sumtext="안전재고량 "/>
  256. <Column id="ddavguseqty" type="BIGDECIMAL" size="256" sumtext="일평균사용량 "/>
  257. <Column id="mmavgusescheqty" type="BIGDECIMAL" size="256" sumtext="월평균사용예정량 "/>
  258. <Column id="mmavguseqty" type="BIGDECIMAL" size="256" sumtext="월평균사용량 "/>
  259. <Column id="prprtystocpossndayno" type="BIGDECIMAL" size="256" sumtext="적정재고보유일수 "/>
  260. <Column id="stocqty" type="STRING" size="256" sumtext="재고량 "/>
  261. <Column id="curemealstocqty" type="STRING" size="256" sumtext="치료식현재고수량 "/>
  262. <Column id="empmealstocqty" type="STRING" size="256" sumtext="직원식현재고수량 "/>
  263. <Column id="empnigtmealstocqty" type="STRING" size="256" sumtext="직원야식현재고수량 "/>
  264. <Column id="curemealstocqty" type="STRING" size="256" sumtext="영양팀치료식 "/>
  265. <Column id="empmealstocqty" type="STRING" size="256" sumtext="영양팀직원식 "/>
  266. <Column id="empnigtmealstocqty" type="STRING" size="256" sumtext="영양팀직원야식 "/>
  267. <Column id="allsizeyn" type="STRING" size="256" sumtext="allsize여부 "/>
  268. <Column id="orgloc" type="STRING" size="256" sumtext="원산지 "/>
  269. <Column id="select" type="STRING" size="256" sumtext=" "/>
  270. <Column id="bnscd" type="STRING" size="256" sumtext=" "/>
  271. <Column id="oldcd" type="STRING" size="256" sumtext="구코드 "/>
  272. <Column id="goodpurccost" type="STRING" size="256" sumtext="납품가 "/>
  273. <Column id="reqpridnm" type="STRING" size="256" sumtext="청구주기명 "/>
  274. <Column id="allsizespecid" type="STRING" size="256" sumtext="allsize코드 "/>
  275. <Column id="reqfnldeptcd" type="STRING" size="256" sumtext="출고부서 "/>
  276. <Column id="delivedeptcd" type="STRING" size="256" sumtext="출고부서 "/>
  277. <Column id="setunit" type="STRING" size="256" sumtext="포장구성단위 "/>
  278. <Column id="constunit" type="STRING" size="256" sumtext="포장구성단위 "/>
  279. </ColumnInfo>
  280. </Dataset>
  281. <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_cond_oncolumnchanged">
  282. <ColumnInfo>
  283. <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
  284. <Column id="goodflag" type="STRING" size="256" sumtext="물품구분"/>
  285. <Column id="stocdeptcd" type="STRING" size="256" sumtext="재고부서"/>
  286. <Column id="stocym" type="STRING" size="256" sumtext="재고년월"/>
  287. <Column id="prtflag" type="STRING" size="256" sumtext="조회구분(A:불출부서별,B:약품코드별)"/>
  288. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드"/>
  289. <Column id="goodnm" type="STRING" size="256" sumtext="물품명"/>
  290. </ColumnInfo>
  291. <Rows>
  292. <Row/>
  293. </Rows>
  294. </Dataset>
  295. <Dataset id="ds_main_goodinoutinfo_goodinoutlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  296. <ColumnInfo>
  297. <Column id="stkdeptnm" type="STRING" size="256" sumtext="불출부서명"/>
  298. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드 "/>
  299. <Column id="goodnm" type="STRING" size="256" sumtext="물품명 "/>
  300. <Column id="purcunit" type="STRING" size="256" sumtext="물품단위 "/>
  301. <Column id="unitcost" type="STRING" size="256" sumtext="단가 "/>
  302. <Column id="beftotqty" type="STRING" size="256" sumtext="이월수량 "/>
  303. <Column id="beftotamt" type="STRING" size="256" sumtext="이월금액 "/>
  304. <Column id="winqty" type="STRING" size="256" sumtext="입고수량 "/>
  305. <Column id="winamt" type="STRING" size="256" sumtext="입고금액 "/>
  306. <Column id="outqty" type="STRING" size="256" sumtext="출고수량 "/>
  307. <Column id="outamt" type="STRING" size="256" sumtext="출고금액 "/>
  308. <Column id="stocqty" type="STRING" size="256" sumtext="재고수량 "/>
  309. <Column id="stocamt" type="STRING" size="256" sumtext="재고금액 "/>
  310. </ColumnInfo>
  311. </Dataset>
  312. </Objects>
  313. <Bind>
  314. <BindItem id="item0" compid="group5.group6.cmb_instcd" propid="value" datasetid="ds_cond" columnid="instcd"/>
  315. <BindItem id="item1" compid="group5.group6.ipt_goodcd" propid="value" datasetid="ds_cond" columnid="goodcd"/>
  316. <BindItem id="item2" compid="group5.group6.ipt_goodnm" propid="value" datasetid="ds_cond" columnid="goodnm"/>
  317. <BindItem id="item3" compid="group5.group6.ipt_stocym" propid="value" datasetid="ds_cond" columnid="stocym"/>
  318. <BindItem id="item4" compid="group5.group6.rdo_prtflag" propid="value" datasetid="ds_cond" columnid="prtflag"/>
  319. <BindItem id="item5" compid="group5.group6.cmb_goodflag" propid="value" datasetid="ds_cond" columnid="goodflag"/>
  320. <BindItem id="item6" compid="group5.group6.ipt_stocdeptcd" propid="value" datasetid="ds_cond" columnid="stocdeptcd"/>
  321. <BindItem id="item7" compid="group5.group6.ipt_stocdeptnm" propid="value" datasetid="ds_cond" columnid="stocdeptnm"/>
  322. </Bind>
  323. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  324. * System Name : 경대 의료정보시스템
  325. * Job Name : mis_stocsumxp -> SMRST02800
  326. * Creator : yjh
  327. * Make Date : 2018-01-08
  328. * Description :
  329. *---------------------------------------------------------------------------------------
  330. * Modify Date Modifier Modify Description
  331. *---------------------------------------------------------------------------------------
  332. * 2018-01-08 yjh TF->XP
  333. *
  334. *---------------------------------------------------------------------------------------
  335. ****************************************************************************************/
  336. //=======================================================================================
  337. // Lib Include
  338. //---------------------------------------------------------------------------------------
  339. include "com_commonxp::comm_main.xjs";
  340. include "mis_miscommonxp::MIS.xjs";
  341. include "mis_miscommonxp::RSZ001.xjs";
  342. //=======================================================================================
  343. // Global Form Variable
  344. //---------------------------------------------------------------------------------------
  345. var arErrorCode = new HashArray();
  346. //=======================================================================================
  347. // Function
  348. //---------------------------------------------------------------------------------------
  349. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  350. function fInitialize() {
  351. rszfUserInstList(group5.group6.cmb_instcd,sysf_getUserInfo("userid"));
  352. ds_cond.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  353. var curdate = utlf_getCurrentDate().substring(0,6);
  354. ds_cond.setColumn(0, "stocym", curdate);
  355. group5.grd_goodinoutlist.setFormatColProperty(1, "size", 0);
  356. misfGridInit(group5.grd_goodinoutlist);
  357. }
  358. //필수항목 체크하는 메소드
  359. function fCheckRetrieveData()
  360. {
  361. if(!isRequiredControls("cmb_instcd") )return false; // 기관코드 , commonweb/js/tfHelper.js
  362. if(!isRequiredControls("cmb_goodflag") )return false; // 물품구분
  363. if(!isRequiredControls("ipt_stocym") )return false; // 기준년월
  364. //if(!isRequiredControls("ipt_delivetodd") )return false; // 출고종료일자
  365. //if(!isRequiredControls("cmb_stocdeptcd") )return false; // 부서코드
  366. }
  367. //=======================================================================================
  368. // Event
  369. //---------------------------------------------------------------------------------------
  370. /****************************************************************************************
  371. * Components : Form
  372. * Components ID : SMRST02800
  373. * Event : oninit
  374. * Argument : 01.obj : Object Event has occurred
  375. * : 02.e : Event Object
  376. * Description : 화면 처음 초기화시
  377. ****************************************************************************************/
  378. function SMRST02800_oninit(obj:Form, e:InitEventInfo)
  379. {
  380. frmf_initForm(obj); //폼 초기화
  381. }
  382. /****************************************************************************************
  383. * Components : Form
  384. * Components ID : SMRST02800
  385. * Event : onload
  386. * Argument : 01.obj : Object Event has occurred
  387. * : 02.e : Event Object
  388. * Description : 화면 로딩 완료시
  389. ****************************************************************************************/
  390. function SMRST02800_onload(obj:Form, e:LoadEventInfo)
  391. {
  392. grdf_setRowTypeIcon(group5.group2.grd_goodlist, 0);
  393. ds_cond.setColumn(0, "prtflag", "B");
  394. //화면 Control을 초기화한다
  395. fInitialize();
  396. }
  397. /****************************************************************************************
  398. * Components : Radio
  399. * Components ID : rdo_prtflag
  400. * Event : onitemchanged
  401. * Argument : 01.obj : Object Event has occurred
  402. * : 02.e : Event Object
  403. * Description : 라디오 값 변경시
  404. ****************************************************************************************/
  405. function group5_group6_rdo_prtflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
  406. {
  407. var vPrtFlag = ds_cond.getColumn(0, "prtflag");
  408. if(vPrtFlag =="A"){
  409. group5.grd_goodinoutlist.setFormatColProperty(1, "size", 115);
  410. group5.grd_goodinoutlist.setFormatColProperty(2, "size", 0);
  411. group5.grd_goodinoutlist.setFormatColProperty(3, "size", 0);
  412. group5.grd_goodinoutlist.setFormatColProperty(4, "size", 0);
  413. group5.grd_goodinoutlist.setFormatColProperty(5, "size", 0);
  414. group5.group6.ipt_goodcd.enable = false;
  415. group5.group6.btn_searchgoodcd.enable =false;
  416. group5.group6.ipt_goodnm.enable = false;
  417. }else if(vPrtFlag =="B"){
  418. group5.grd_goodinoutlist.setFormatColProperty(1, "size", 0);
  419. group5.grd_goodinoutlist.setFormatColProperty(2, "size", 91);
  420. group5.grd_goodinoutlist.setFormatColProperty(3, "size", 314);
  421. group5.grd_goodinoutlist.setFormatColProperty(4, "size", 56);
  422. group5.grd_goodinoutlist.setFormatColProperty(5, "size", 102);
  423. group5.group6.ipt_goodcd.enable = true;
  424. group5.group6.btn_searchgoodcd.enable =true;
  425. group5.group6.ipt_goodnm.enable = true;
  426. }
  427. }
  428. /****************************************************************************************
  429. * Components : Button
  430. * Components ID : button3
  431. * Event : onclick
  432. * Argument : 01.obj : Object Event has occurred
  433. * : 02.e : Event Object
  434. * Description : 돋보기버튼 클릭시
  435. ****************************************************************************************/
  436. function group5_group6_button3_onclick(obj:Button, e:ClickEventInfo)
  437. {
  438. var recv_list = "stocdeptcd,stocdeptnm";
  439. misfOpenPopUpList("02", group5.group6.ipt_stocdeptcd,"", recv_list) ;
  440. }
  441. function ds_cond_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  442. {
  443. switch( e.columnid ){
  444. case "stocdeptcd" :
  445. misfValidationCheck("02", "", "stocdeptcd,stocdeptnm" );
  446. break;
  447. case "goodnm" :
  448. if(utlf_transNullToEmpty(group5.group6.ipt_goodnm.value).length == 0)
  449. {
  450. group5.group6.ipt_goodcd.value = "";
  451. }
  452. else {
  453. ds_cond.setColumn(0, "goodcd", "")
  454. group5.group6.btn_searchgoodcd.click();
  455. }
  456. break;
  457. case "goodcd" :
  458. if(utlf_transNullToEmpty(group5.group6.ipt_goodcd.value).length == 0)
  459. {
  460. group5.group6.ipt_goodnm.value = "";
  461. }
  462. else {
  463. ds_cond.setColumn(0, "goodnm", "")
  464. group5.group6.btn_searchgoodcd.click();
  465. }
  466. break;
  467. case "stocym" :
  468. obj.setColumn(e.row, e.columnid, utlf_transNullToEmpty(e.newvalue+"").substr(0, 6));
  469. break;
  470. default :
  471. break;
  472. }
  473. }
  474. /****************************************************************************************
  475. * Components : Button
  476. * Components ID : button4
  477. * Event : onclick
  478. * Argument : 01.obj : Object Event has occurred
  479. * : 02.e : Event Object
  480. * Description : 조회버튼 클릭시
  481. ****************************************************************************************/
  482. function group5_group6_button4_onclick(obj:Button, e:ClickEventInfo)
  483. {
  484. var oParam = {};
  485. oParam.id = "TRRST02802";
  486. oParam.service = "stocsumapp.StocSumMngt";
  487. oParam.method = "reqGetGoodInOutList";
  488. oParam.inds = "cond=ds_cond";
  489. oParam.outds = "ds_main_goodinoutinfo_goodinoutlist=goodinoutlist";
  490. oParam.async = false;
  491. //oParam.callback = "cf_TRRST02802";
  492. tranf_submit(oParam);
  493. }
  494. /****************************************************************************************
  495. * Components : Edit
  496. * Components ID : ipt_goodnm
  497. * Event : onkeydown
  498. * Argument : 01.obj : Object Event has occurred
  499. * : 02.e : Event Object
  500. * Description : 에디터 키 입력시
  501. ****************************************************************************************/
  502. function group5_group6_ipt_goodnm_onkeydown(obj:Edit, e:KeyEventInfo)
  503. {
  504. if (e.keycode == 13)
  505. {
  506. obj.updateToDataset();
  507. }
  508. }
  509. /****************************************************************************************
  510. * Components : Button
  511. * Components ID : btn_searchgoodcd
  512. * Event : onclick
  513. * Argument : 01.obj : Object Event has occurred
  514. * : 02.e : Event Object
  515. * Description : 돋보기버튼 클릭시
  516. ****************************************************************************************/
  517. function group5_group6_btn_searchgoodcd_onclick(obj:Button, e:ClickEventInfo)
  518. {
  519. ds_send_goodiolist.setColumn(0, "instcd" ,ds_cond.getColumn(0, "instcd"));
  520. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  521. ds_send_goodiolist.setColumn(0, "goodflag","PH");
  522. ds_send_goodiolist.setColumn(0, "goodcd" ,ds_cond.getColumn(0, "goodcd"));
  523. ds_send_goodiolist.setColumn(0, "goodnm" ,ds_cond.getColumn(0, "goodnm"));
  524. var oParam = {};
  525. oParam.id = "TRRSD00192";
  526. oParam.service = "purccommonapp.PurcCommon";
  527. oParam.method = "reqGetPhamGoodListByCond";
  528. oParam.inds = "req=ds_send_goodiolist";
  529. oParam.outds = "ds_init_main_goodlist=goodlist";
  530. oParam.async = false;
  531. oParam.callback = "cf_TRRSD00192";
  532. tranf_submit(oParam);
  533. if (arErrorCode.pop("TRRSD00192") > -1) {
  534. var nodecnts = ds_init_main_goodlist.rowcount;
  535. if (nodecnts >= "2") {
  536. group5.group2.visible = true;
  537. } else if (nodecnts == "1") {
  538. var goodcd = ds_init_main_goodlist.getColumn(0, "goodcd");
  539. var goodnm = ds_init_main_goodlist.getColumn(0, "goodnm");
  540. ds_cond.setColumn(0, "goodcd" , goodcd);
  541. ds_cond.setColumn(0, "goodnm" , goodnm);
  542. } else {
  543. sysf_messageBox("검색된 코드가 없습니다.", "I");
  544. }
  545. }
  546. }
  547. function cf_TRRSD00192(sSvcId, nErrorCode, sErrorMsg) {
  548. arErrorCode.push(sSvcId, nErrorCode);
  549. }
  550. /****************************************************************************************
  551. * Components : Edit
  552. * Components ID : ipt_goodcd
  553. * Event : onkeydown
  554. * Argument : 01.obj : Object Event has occurred
  555. * : 02.e : Event Object
  556. * Description : 에디터 키 입력시
  557. ****************************************************************************************/
  558. function group5_group6_ipt_goodcd_onkeydown(obj:Edit, e:KeyEventInfo)
  559. {
  560. if (e.keycode == 13)
  561. {
  562. obj.updateToDataset();
  563. }
  564. }
  565. /****************************************************************************************
  566. * Components : Button
  567. * Components ID : button1
  568. * Event : onclick
  569. * Argument : 01.obj : Object Event has occurred
  570. * : 02.e : Event Object
  571. * Description : 엑셀파일저장버튼 클릭시
  572. ****************************************************************************************/
  573. function group5_button1_onclick(obj:Button, e:ClickEventInfo)
  574. {
  575. misfSaveExcel(group5.grd_goodinoutlist , "품목별입출고현황출력");
  576. }
  577. /****************************************************************************************
  578. * Components : Grid
  579. * Components ID : grd_goodlist
  580. * Event : oncelldblclick
  581. * Argument : 01.obj : Object Event has occurred
  582. * : 02.e : Event Object
  583. * Description : 그리드 셀 더블클릭시
  584. ****************************************************************************************/
  585. function group5_group2_grd_goodlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  586. {
  587. var goodcd = ds_init_main_goodlist.getColumn(ds_init_main_goodlist.rowposition, "goodcd");
  588. var goodnm = ds_init_main_goodlist.getColumn(ds_init_main_goodlist.rowposition, "goodnm");
  589. ds_cond.enableevent = false;
  590. ds_cond.updatecontrol = false;
  591. ds_cond.setColumn(0, "goodcd" , goodcd);
  592. ds_cond.setColumn(0, "goodnm" , goodnm);
  593. ds_cond.updatecontrol = true;
  594. ds_cond.enableevent = true;
  595. group5.group2.visible = false;
  596. }
  597. /****************************************************************************************
  598. * Components : Button
  599. * Components ID : button5
  600. * Event : onclick
  601. * Argument : 01.obj : Object Event has occurred
  602. * : 02.e : Event Object
  603. * Description : 숨기기버튼 클릭시
  604. ****************************************************************************************/
  605. function group5_group2_button5_onclick(obj:Button, e:ClickEventInfo)
  606. {
  607. group5.group2.visible = false
  608. }
  609. /****************************************************************************************
  610. * Components : Button
  611. * Components ID : btn_init
  612. * Event : onclick
  613. * Argument : 01.obj : Object Event has occurred
  614. * : 02.e : Event Object
  615. * Description : 초기화버튼 클릭시
  616. ****************************************************************************************/
  617. function group4_btn_init_onclick(obj:Button, e:ClickEventInfo)
  618. {
  619. fInitialize();
  620. }
  621. ]]></Script>
  622. </Form>
  623. </FDL>