SMRST03200_거래처별입고금액(약국).xfdl 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRST03200" position="absolute 0 0 1256 805" titletext="거래처별 입고금액 현황(약품)" oninit="SMRST03200_oninit" onload="SMRST03200_onload">
  5. <Layouts>
  6. <Layout>
  7. <Shape position="absolute 0 48 1195 109" id="roundrect1" type="roundrectangle"/>
  8. <Shape position="absolute 0 133 1190 139" linetype="horizontal" id="line1" class="line_10"/>
  9. <Grid position="absolute 0 138 1190 393" id="grd_winsuplplcecdamtlist" binddataset="ds_main_winsuplplcecdamtlist" oncelldblclick="grd_winsuplplcecdamtlist_oncelldblclick">
  10. <Formats>
  11. <Format id="default">
  12. <Columns>
  13. <Column size="24"/>
  14. <Column size="98"/>
  15. <Column size="150"/>
  16. <Column size="30"/>
  17. <Column size="152"/>
  18. <Column size="109"/>
  19. <Column size="173"/>
  20. <Column size="85"/>
  21. <Column size="126"/>
  22. <Column size="70"/>
  23. <Column size="70"/>
  24. <Column size="80"/>
  25. <Column size="0"/>
  26. </Columns>
  27. <Rows>
  28. <Row size="24" band="head"/>
  29. <Row size="24"/>
  30. <Row size="24" band="summ"/>
  31. </Rows>
  32. <Band id="head">
  33. <Cell/>
  34. <Cell col="1" colspan="2" text="입고부서" taborder="undefined"/>
  35. <Cell col="3" colspan="2" text="대분류" taborder="undefined"/>
  36. <Cell col="5" text="거래처코드"/>
  37. <Cell col="6" text="거래처명칭"/>
  38. <Cell col="7" text="입고수량"/>
  39. <Cell col="8" text="입고금액"/>
  40. <Cell col="9" colspan="2" text="입고자" taborder="undefined"/>
  41. <Cell col="11" text="비고"/>
  42. <Cell col="12"/>
  43. </Band>
  44. <Band id="body">
  45. <Cell celltype="head" expr="currow + 1"/>
  46. <Cell col="1" text="bind:windeptcd"/>
  47. <Cell col="2" text="bind:windeptcdnm"/>
  48. <Cell col="3" text="bind:lrgcd"/>
  49. <Cell col="4" text="bind:lrgcdnm"/>
  50. <Cell col="5" text="bind:suplplcecd" mask="###-##-#####" maskchar=" "/>
  51. <Cell col="6" style="align:left;" text="bind:suplplcenm"/>
  52. <Cell col="7" displaytype="number" style="align:right middle;" text="bind:winqty" mask="#,###"/>
  53. <Cell col="8" displaytype="number" style="align:right middle;" text="bind:winamt" mask="#,###"/>
  54. <Cell col="9" text="bind:winpsn"/>
  55. <Cell col="10" text="bind:winpsnnm"/>
  56. <Cell col="11"/>
  57. <Cell col="12" text="bind:instcd"/>
  58. </Band>
  59. <Band id="summary">
  60. <Cell/>
  61. <Cell col="1"/>
  62. <Cell col="2"/>
  63. <Cell col="3"/>
  64. <Cell col="4"/>
  65. <Cell col="5" text="- 총계"/>
  66. <Cell col="6"/>
  67. <Cell col="7" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;winqty&quot;)"/>
  68. <Cell col="8" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;winamt&quot;)"/>
  69. <Cell col="9"/>
  70. <Cell col="10"/>
  71. <Cell col="11"/>
  72. <Cell col="12"/>
  73. </Band>
  74. </Format>
  75. </Formats>
  76. </Grid>
  77. <Static text="거래처별 입고금액 리스트" position="absolute 1 117 184 134" id="caption3" class="tit_2"/>
  78. <Button position="absolute 1125 67 1181 89" id="btn_search" class="btn1" text="조회" onclick="btn_search_onclick"/>
  79. <Shape position="absolute 1107 54 1113 99" linetype="vertical" id="line13" class="line_4"/>
  80. <Static text="기관코드 :" position="absolute 15 57 101 74" id="cap_instcd" class="search_name"/>
  81. <Static text="입고일자 :" position="absolute 15 83 116 100" id="cap_winfrdd" class="search_name"/>
  82. <Static text="부 서 :" position="absolute 416 84 515 101" id="cap_stocdeptcd" class="search_name"/>
  83. <Combo position="absolute 502 84 655 103" id="cmb_stocdeptcd" class="combo_essential"/>
  84. <Edit readonly="true" position="absolute 100 56 250 75" id="opt_instcdnm" class="output"/>
  85. <Edit readonly="true" position="absolute 254 57 274 76" id="opt_instcd" visible="false" class="output"/>
  86. <Calendar position="absolute 238 84 352 103" id="ipt_wintodd" class="input_essential" autoselect="true"/>
  87. <Calendar position="absolute 100 84 214 103" id="ipt_winfrdd" class="input_essential" autoselect="true"/>
  88. <Static text="~" position="absolute 220 85 235 105" align="align:center middle;" id="caption22"/>
  89. <Edit readonly="true" position="absolute 1085 53 1105 72" id="opt_goodflag" visible="false"/>
  90. <Combo position="absolute 502 57 655 76" id="cmb_lrgcd" class="combo_essential"/>
  91. <Static text="대 분 류 :" position="absolute 416 58 505 75" id="caption40" class="search_name"/>
  92. <Button position="absolute 1139 113 1189 132" id="btn_excel" class="btn7" text="엑셀" onclick="btn_excel_onclick"/>
  93. <Radio position="absolute 805 83 1085 103" id="rdo_prtflag" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1">
  94. <Dataset id="innerdataset">
  95. <ColumnInfo>
  96. <Column id="codecolumn"/>
  97. <Column id="datacolumn"/>
  98. </ColumnInfo>
  99. <Rows>
  100. <Row>
  101. <Col id="codecolumn">
  102. </Col>
  103. <Col id="datacolumn">전체</Col>
  104. </Row>
  105. <Row>
  106. <Col id="codecolumn">2158155746</Col>
  107. <Col id="datacolumn">보나에스거래</Col>
  108. </Row>
  109. <Row>
  110. <Col id="codecolumn">O</Col>
  111. <Col id="datacolumn">기타거래</Col>
  112. </Row>
  113. </Rows>
  114. </Dataset>
  115. </Radio>
  116. <Static text="조회구분 :" position="absolute 692 82 785 99" id="cap_prtflag" class="search_name"/>
  117. <CheckBox position="absolute 581 113 666 133" id="ckb_winpsnyn" text="입고자" truevalue="Y" onclick="ckb_winpsnyn_onclick"/>
  118. <Static text="LIST 포함조건 :" position="absolute 295 113 416 130" id="caption10" class="search_name"/>
  119. <CheckBox position="absolute 505 113 575 133" id="ckb_lrgcdyn" text="대분류" truevalue="Y" onclick="ckb_lrgcdyn_onclick"/>
  120. <CheckBox position="absolute 420 113 495 133" id="ckb_windeptcdyn" text="입고부서" truevalue="Y" onclick="ckb_windeptcdyn_onclick"/>
  121. <Div position="absolute 0 403 1190 779" id="group2">
  122. <Layouts>
  123. <Layout>
  124. <Grid position="absolute 0 40 1187 369" id="grd_goodwin" binddataset="ds_main_list_goodwin_goodwinlist">
  125. <Formats>
  126. <Format id="default">
  127. <Columns>
  128. <Column size="24"/>
  129. <Column size="82"/>
  130. <Column size="81"/>
  131. <Column size="49"/>
  132. <Column size="83"/>
  133. <Column size="74"/>
  134. <Column size="84"/>
  135. <Column size="280"/>
  136. <Column size="0"/>
  137. <Column size="0"/>
  138. <Column size="64"/>
  139. <Column size="64"/>
  140. <Column size="65"/>
  141. <Column size="85"/>
  142. <Column size="100"/>
  143. <Column size="0"/>
  144. <Column size="0"/>
  145. <Column size="93"/>
  146. <Column size="130"/>
  147. <Column size="0"/>
  148. <Column size="0"/>
  149. <Column size="0"/>
  150. <Column size="0"/>
  151. <Column size="0"/>
  152. <Column size="0"/>
  153. <Column size="0"/>
  154. <Column size="0"/>
  155. <Column size="0"/>
  156. <Column size="0"/>
  157. <Column size="0"/>
  158. <Column size="0"/>
  159. <Column size="0"/>
  160. <Column size="0"/>
  161. <Column size="0"/>
  162. <Column size="0"/>
  163. <Column size="0"/>
  164. <Column size="0"/>
  165. <Column size="0"/>
  166. <Column size="0"/>
  167. <Column size="0"/>
  168. <Column size="0"/>
  169. <Column size="0"/>
  170. <Column size="0"/>
  171. <Column size="0"/>
  172. <Column size="0"/>
  173. <Column size="0"/>
  174. <Column size="0"/>
  175. <Column size="0"/>
  176. <Column size="0"/>
  177. <Column size="0"/>
  178. <Column size="0"/>
  179. <Column size="0"/>
  180. <Column size="0"/>
  181. <Column size="0"/>
  182. <Column size="0"/>
  183. <Column size="0"/>
  184. <Column size="0"/>
  185. <Column size="0"/>
  186. <Column size="0"/>
  187. </Columns>
  188. <Rows>
  189. <Row size="24" band="head"/>
  190. <Row size="24" band="head"/>
  191. <Row size="24"/>
  192. </Rows>
  193. <Band id="head">
  194. <Cell rowspan="2" taborder="undefined"/>
  195. <Cell col="1" rowspan="2" text="입고일자" taborder="undefined"/>
  196. <Cell col="2" rowspan="2" text="입고부서" taborder="undefined"/>
  197. <Cell col="3" rowspan="2" text="순번" taborder="undefined"/>
  198. <Cell col="4" rowspan="2" text="주거래처" taborder="undefined"/>
  199. <Cell col="5" rowspan="2" text="입고유형" taborder="undefined"/>
  200. <Cell col="6" rowspan="2" text="약품코드" taborder="undefined"/>
  201. <Cell col="7" rowspan="2" text="약품명" taborder="undefined"/>
  202. <Cell col="8" text="함량"/>
  203. <Cell col="9" text="제조회사"/>
  204. <Cell col="10" colspan="2" text="낱개" taborder="undefined"/>
  205. <Cell col="12" colspan="2" text="포장" taborder="undefined"/>
  206. <Cell col="14" rowspan="2" text="입고금액" taborder="undefined"/>
  207. <Cell col="15" text="입고번호"/>
  208. <Cell col="16" text="발주번호"/>
  209. <Cell col="17" rowspan="2" text="입고자" taborder="undefined"/>
  210. <Cell col="18" rowspan="2" text="입고정보" taborder="undefined"/>
  211. <Cell col="19"/>
  212. <Cell col="20"/>
  213. <Cell col="21"/>
  214. <Cell col="22"/>
  215. <Cell col="23"/>
  216. <Cell col="24"/>
  217. <Cell col="25"/>
  218. <Cell col="26"/>
  219. <Cell col="27"/>
  220. <Cell col="28"/>
  221. <Cell col="29"/>
  222. <Cell col="30"/>
  223. <Cell col="31"/>
  224. <Cell col="32"/>
  225. <Cell col="33"/>
  226. <Cell col="34"/>
  227. <Cell col="35"/>
  228. <Cell col="36"/>
  229. <Cell col="37"/>
  230. <Cell col="38"/>
  231. <Cell col="39"/>
  232. <Cell col="40"/>
  233. <Cell col="41"/>
  234. <Cell col="42"/>
  235. <Cell col="43"/>
  236. <Cell col="44"/>
  237. <Cell col="45"/>
  238. <Cell col="46"/>
  239. <Cell col="47"/>
  240. <Cell col="48"/>
  241. <Cell col="49"/>
  242. <Cell col="50"/>
  243. <Cell col="51"/>
  244. <Cell col="52"/>
  245. <Cell col="53"/>
  246. <Cell col="54"/>
  247. <Cell col="55"/>
  248. <Cell col="56"/>
  249. <Cell col="57"/>
  250. <Cell col="58"/>
  251. <Cell row="1" col="8" text="함량"/>
  252. <Cell row="1" col="9" text="제조회사"/>
  253. <Cell row="1" col="10" text="수량"/>
  254. <Cell row="1" col="11" text="단가"/>
  255. <Cell row="1" col="12" text="수량"/>
  256. <Cell row="1" col="13" text="구입가"/>
  257. <Cell row="1" col="15" text="입고번호"/>
  258. <Cell row="1" col="16" text="발주번호"/>
  259. <Cell row="1" col="19"/>
  260. <Cell row="1" col="20"/>
  261. <Cell row="1" col="21"/>
  262. <Cell row="1" col="22"/>
  263. <Cell row="1" col="23"/>
  264. <Cell row="1" col="24"/>
  265. <Cell row="1" col="25"/>
  266. <Cell row="1" col="26"/>
  267. <Cell row="1" col="27"/>
  268. <Cell row="1" col="28"/>
  269. <Cell row="1" col="29"/>
  270. <Cell row="1" col="30"/>
  271. <Cell row="1" col="31"/>
  272. <Cell row="1" col="32"/>
  273. <Cell row="1" col="33"/>
  274. <Cell row="1" col="34"/>
  275. <Cell row="1" col="35"/>
  276. <Cell row="1" col="36"/>
  277. <Cell row="1" col="37"/>
  278. <Cell row="1" col="38"/>
  279. <Cell row="1" col="39"/>
  280. <Cell row="1" col="40"/>
  281. <Cell row="1" col="41"/>
  282. <Cell row="1" col="42"/>
  283. <Cell row="1" col="43"/>
  284. <Cell row="1" col="44"/>
  285. <Cell row="1" col="45"/>
  286. <Cell row="1" col="46"/>
  287. <Cell row="1" col="47"/>
  288. <Cell row="1" col="48"/>
  289. <Cell row="1" col="49"/>
  290. <Cell row="1" col="50"/>
  291. <Cell row="1" col="51"/>
  292. <Cell row="1" col="52"/>
  293. <Cell row="1" col="53"/>
  294. <Cell row="1" col="54"/>
  295. <Cell row="1" col="55"/>
  296. <Cell row="1" col="56"/>
  297. <Cell row="1" col="57"/>
  298. <Cell row="1" col="58"/>
  299. </Band>
  300. <Band id="body">
  301. <Cell celltype="head" expr="currow + 1"/>
  302. <Cell col="1" displaytype="date" text="bind:windd" calendardisplaynulltype="none"/>
  303. <Cell col="2" text="bind:windeptnm"/>
  304. <Cell col="3" text="bind:winseqno"/>
  305. <Cell col="4" text="bind:suplplcenm"/>
  306. <Cell col="5" text="bind:iokindnm"/>
  307. <Cell col="6" text="bind:goodcd"/>
  308. <Cell col="7" style="align:left top;padding:5 2 1 2;" text="bind:goodnm" wordwrap="word"/>
  309. <Cell col="8" text="bind:goodspec"/>
  310. <Cell col="9" text="bind:prodcmpynm"/>
  311. <Cell col="10" displaytype="number" style="align:right middle;" text="bind:winqty" mask="#,###"/>
  312. <Cell col="11" displaytype="number" style="align:right middle;" text="bind:winunitcost" mask="#,###"/>
  313. <Cell col="12" displaytype="number" style="align:right middle;" text="bind:winpackqty" mask="#,###"/>
  314. <Cell col="13" displaytype="number" style="align:right middle;" text="bind:goodpurccost" mask="#,###"/>
  315. <Cell col="14" displaytype="number" style="align:right middle;" text="bind:winamt" mask="#,###"/>
  316. <Cell col="15" text="bind:winno"/>
  317. <Cell col="16" text="bind:deliveno"/>
  318. <Cell col="17" text="bind:winpsnnm"/>
  319. <Cell col="18" text="bind:winputno"/>
  320. <Cell col="19" text="bind:goodmodel"/>
  321. <Cell col="20" text="bind:winpackunit"/>
  322. <Cell col="21" text="bind:winpackcntperunit" mask="#,###"/>
  323. <Cell col="22" text="bind:winunit"/>
  324. <Cell col="23" text="bind:delivedeptqty" mask="#,###"/>
  325. <Cell col="24" text="bind:stocqty" mask="#,###"/>
  326. <Cell col="25" text="bind:instcd"/>
  327. <Cell col="26" text="bind:goodflag"/>
  328. <Cell col="27" text="bind:winpsn"/>
  329. <Cell col="28" text="bind:windeptcd"/>
  330. <Cell col="29" text="bind:installplcecd"/>
  331. <Cell col="30" text="bind:paycond"/>
  332. <Cell col="31" text="bind:temppay"/>
  333. <Cell col="32" text="bind:calcdocukind"/>
  334. <Cell col="33" text="bind:elctstmntyn"/>
  335. <Cell col="34" text="bind:iokind"/>
  336. <Cell col="35" text="bind:suplplcecd"/>
  337. <Cell col="36" text="bind:purcdmnddd"/>
  338. <Cell col="37" text="bind:purcdmndno"/>
  339. <Cell col="38" text="bind:purcdmndseq"/>
  340. <Cell col="39" text="bind:deliveseqno"/>
  341. <Cell col="40" text="bind:bnscd"/>
  342. <Cell col="41" text="bind:calcdocudd"/>
  343. <Cell col="42" text="bind:profno"/>
  344. <Cell col="43" text="bind:acntcd"/>
  345. <Cell col="44" text="bind:reqdd"/>
  346. <Cell col="45" text="bind:reqno"/>
  347. <Cell col="46" text="bind:reqseqno"/>
  348. <Cell col="47" text="bind:valiterm"/>
  349. <Cell col="48" text="bind:stocynindx"/>
  350. <Cell col="49" text="bind:chkdd"/>
  351. <Cell col="50" text="bind:chkpsn"/>
  352. <Cell col="51" text="bind:chkyn"/>
  353. <Cell col="52" text="bind:slipdd"/>
  354. <Cell col="53" text="bind:slipno"/>
  355. <Cell col="54" text="bind:suppcustcd"/>
  356. <Cell col="55" text="bind:cmt"/>
  357. <Cell col="56" text="bind:prewinqty"/>
  358. <Cell col="57" text="bind:minexch"/>
  359. <Cell col="58" text="bind:suppcustnm"/>
  360. </Band>
  361. </Format>
  362. </Formats>
  363. </Grid>
  364. <Shape position="absolute 0 35 1187 41" linetype="horizontal" id="line15" class="line_10"/>
  365. <Static text="입고내역" position="absolute 0 19 95 36" id="caption35" class="tit_2"/>
  366. <Button position="absolute 1136 14 1186 33" id="button1" class="btn7" text="엑셀" onclick="group2_button1_onclick"/>
  367. </Layout>
  368. </Layouts>
  369. </Div>
  370. <Static id="caption6" text="거래처별 입고금액 현황(약품)" class="tit_1" position="absolute 0 0 243 25"/>
  371. <Button id="btn_print" taborder="1" text="리스트출력" class="btn6" visible="false" position="absolute 0 26 92 48"/>
  372. <Button id="btn_init" taborder="2" text="초기화" class="btn4" position="absolute 1127 26 1195 48" onclick="btn_init_onclick"/>
  373. </Layout>
  374. </Layouts>
  375. <Objects>
  376. <Dataset id="ds_main_winsuplplcecdamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  377. <Dataset id="ds_main_list_goodwin_goodwinlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  378. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  379. <ColumnInfo>
  380. <Column id="instcd" type="STRING" size="256"/>
  381. <Column id="goodflag" type="STRING" size="256"/>
  382. <Column id="winfrdd" type="STRING" size="256"/>
  383. <Column id="stocdeptcd" type="STRING" size="256"/>
  384. <Column id="lrgcd" type="STRING" size="256"/>
  385. <Column id="instcdnm" type="STRING" size="256"/>
  386. <Column id="wintodd" type="STRING" size="256"/>
  387. <Column id="bnscd" type="STRING" size="256"/>
  388. <Column id="windeptcdyn" type="STRING" size="256"/>
  389. <Column id="lrgcdyn" type="STRING" size="256"/>
  390. <Column id="winpsnyn" type="STRING" size="256"/>
  391. </ColumnInfo>
  392. <Rows>
  393. <Row>
  394. <Col id="instcd"/>
  395. <Col id="goodflag"/>
  396. <Col id="winfrdd"/>
  397. <Col id="stocdeptcd"/>
  398. <Col id="lrgcd"/>
  399. <Col id="instcdnm"/>
  400. <Col id="wintodd"/>
  401. <Col id="bnscd"/>
  402. <Col id="windeptcdyn">Y</Col>
  403. <Col id="lrgcdyn">Y</Col>
  404. <Col id="winpsnyn">Y</Col>
  405. </Row>
  406. </Rows>
  407. </Dataset>
  408. <Dataset id="ds_main_list_goodwin_goodmaxwinno" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  409. <Dataset id="ds_send_goodwin" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  410. <ColumnInfo>
  411. <Column id="instcd" type="STRING" size="256" sumtext="기관코드 "/>
  412. <Column id="goodflag" type="STRING" size="256" sumtext="물품구분 "/>
  413. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드 "/>
  414. <Column id="windeptcd" type="STRING" size="256" sumtext="입고부서 "/>
  415. <Column id="winfrdd" type="STRING" size="256" sumtext="입고시작일자 "/>
  416. <Column id="wintodd" type="STRING" size="256" sumtext="입고종료일자 "/>
  417. <Column id="purcflag" type="STRING" size="256" sumtext="구매구분 "/>
  418. <Column id="suplplcecd" type="STRING" size="256" sumtext="주거래처 "/>
  419. <Column id="windd" type="STRING" size="256" sumtext="입고일자 "/>
  420. <Column id="winno" type="STRING" size="256" sumtext="입고번호 "/>
  421. <Column id="iokind" type="STRING" size="256" sumtext="입출유형 "/>
  422. <Column id="winpsn" type="STRING" size="256" sumtext="입고자 "/>
  423. <Column id="chkyn" type="STRING" size="256" sumtext="검수유무 "/>
  424. <Column id="retrmaxwinnoyn" type="STRING" size="256" sumtext="최대입고번호조회여부"/>
  425. <Column id="suplplcecd" type="STRING" size="256" sumtext="주거래처코드 "/>
  426. <Column id="suppcustcd" type="STRING" size="256" sumtext="보조거래처코드 "/>
  427. <Column id="gawinviewyn" type="STRING" size="256" sumtext="수탁가입고조회여부 "/>
  428. <Column id="paycond" type="STRING" size="256" sumtext="지불필여부 "/>
  429. <Column id="mngtcls" type="STRING" size="256" sumtext="관리분류(약품) "/>
  430. </ColumnInfo>
  431. <Rows>
  432. <Row>
  433. <Col id="instcd"/>
  434. <Col id="goodflag"/>
  435. <Col id="goodcd"/>
  436. <Col id="windeptcd"/>
  437. <Col id="winfrdd"/>
  438. <Col id="wintodd"/>
  439. <Col id="purcflag"/>
  440. <Col id="suplplcecd"></Col>
  441. <Col id="windd"/>
  442. <Col id="winno"/>
  443. <Col id="iokind"/>
  444. <Col id="winpsn"/>
  445. <Col id="chkyn"/>
  446. <Col id="retrmaxwinnoyn"/>
  447. <Col id="suppcustcd"/>
  448. <Col id="gawinviewyn"/>
  449. <Col id="paycond"/>
  450. <Col id="mngtcls"/>
  451. </Row>
  452. </Rows>
  453. </Dataset>
  454. </Objects>
  455. <Bind>
  456. <BindItem id="item0" compid="opt_instcdnm" propid="value" datasetid="ds_send" columnid="instcdnm"/>
  457. <BindItem id="item1" compid="opt_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
  458. <BindItem id="item2" compid="cmb_lrgcd" propid="value" datasetid="ds_send" columnid="lrgcd"/>
  459. <BindItem id="item3" compid="opt_goodflag" propid="value" datasetid="ds_send" columnid="goodflag"/>
  460. <BindItem id="item4" compid="ipt_winfrdd" propid="value" datasetid="ds_send" columnid="winfrdd"/>
  461. <BindItem id="item5" compid="ipt_wintodd" propid="value" datasetid="ds_send" columnid="wintodd"/>
  462. <BindItem id="item6" compid="cmb_stocdeptcd" propid="value" datasetid="ds_send" columnid="stocdeptcd"/>
  463. <BindItem id="item7" compid="rdo_prtflag" propid="value" datasetid="ds_send" columnid="bnscd"/>
  464. <BindItem id="item8" compid="ckb_windeptcdyn" propid="value" datasetid="ds_send" columnid="windeptcdyn"/>
  465. <BindItem id="item9" compid="ckb_lrgcdyn" propid="value" datasetid="ds_send" columnid="lrgcdyn"/>
  466. <BindItem id="item10" compid="ckb_winpsnyn" propid="value" datasetid="ds_send" columnid="winpsnyn"/>
  467. </Bind>
  468. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  469. * System Name :
  470. * Job Name :
  471. * Creator :
  472. * Make Date : 2017-06-19
  473. * Description :
  474. *---------------------------------------------------------------------------------------
  475. * Modify Date Modifier Modify Description
  476. *---------------------------------------------------------------------------------------
  477. * 2017-06-19 Live Converter TF->XP
  478. *
  479. *---------------------------------------------------------------------------------------
  480. ****************************************************************************************/
  481. include "com_commonxp::comm_main.xjs";
  482. include "mis_miscommonxp::MIS.xjs";
  483. include "mis_miscommonxp::PIC002.xjs";
  484. include "mis_miscommonxp::RAC001.xjs";
  485. include "mis_miscommonxp::RBC001.xjs";
  486. include "mis_miscommonxp::RSZ001.xjs";
  487. var arErrorCode = new HashArray();
  488. function SMRST03200_oninit(obj:Form, e:InitEventInfo)
  489. {
  490. frmf_initForm(obj); //폼 초기화
  491. grdf_initGrid(group2.grd_goodwin);
  492. grdf_initGrid(grd_winsuplplcecdamtlist);
  493. }
  494. function SMRST03200_onload(obj:Form, e:LoadEventInfo)
  495. {
  496. //화면 Control을 초기화한다
  497. fInitialize();
  498. }
  499. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  500. function fInitialize()
  501. {
  502. ds_send.clearData();
  503. ds_send.addRow();
  504. misfGridInit(group2.grd_goodwin);
  505. misfGridInit(grd_winsuplplcecdamtlist);
  506. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  507. rszfComboStockArthDeptcdList("cmb_stocdeptcd", sysf_getUserInfo("dutplceinstcd"),"PH","Y" );
  508. //misfMsterDetailSet(grd_winsuplplcecdamtlist, null, "TRRST03201", "N");
  509. opt_instcd.value = sysf_getUserInfo("dutplceinstcd");
  510. opt_instcdnm.value = sysf_getUserInfo("dutplceinstnm");
  511. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  512. opt_goodflag.value = "PH";
  513. var curdd = utlf_getCurrentDate();
  514. ipt_winfrdd.value = utlf_getCurrentDate();
  515. ipt_wintodd.value = utlf_getCurrentDate();
  516. ckb_windeptcdyn.value = "Y"; // 입고부서여부
  517. ckb_lrgcdyn.value = "Y"; // 대분류여부
  518. ckb_winpsnyn.value = "Y"; // 입고자여부
  519. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  520. rszfGridComboLrgcdList("PH", "cmb_lrgcd", "lrgcd","Y");
  521. cmb_lrgcd.value = "";
  522. cmb_stocdeptcd.value = "";
  523. rdo_prtflag.value = "";
  524. }
  525. function grd_winsuplplcecdamtlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  526. {
  527. var sPath:Dataset;
  528. sPath = ds_send;
  529. var tPath:Dataset;
  530. tPath = ds_send_goodwin;
  531. vSuplplcecd = ds_main_winsuplplcecdamtlist.getColumn(ds_main_winsuplplcecdamtlist.rowposition, "suplplcecd");
  532. if (utlf_isNull(vSuplplcecd)) return;
  533. tPath.setColumn(0, "instcd", sPath.getColumn(0, "instcd" ));
  534. tPath.setColumn(0, "goodflag", sPath.getColumn(0, "goodflag" ));
  535. tPath.setColumn(0, "winfrdd", sPath.getColumn(0, "winfrdd" ));
  536. tPath.setColumn(0, "wintodd", sPath.getColumn(0, "wintodd" ));
  537. tPath.setColumn(0, "windeptcd", sPath.getColumn(0, "stocdeptcd"));
  538. tPath.setColumn(0, "lrgcd", sPath.getColumn(0, "lrgcd" ));
  539. tPath.setColumn(0, "suplplcecd", vSuplplcecd);
  540. misfGridInit(group2.grd_goodwin);
  541. var oParam = {};
  542. oParam.id = "TRRSI00401";
  543. oParam.service = "winapp.WinMngt";
  544. oParam.method = "reqGetGoodWinByCond";
  545. oParam.inds = "req=ds_send_goodwin";
  546. oParam.outds = "ds_main_list_goodwin_goodwinlist=goodwinlist ds_main_list_goodwin_goodmaxwinno=goodmaxwinno";
  547. oParam.async = false;
  548. tranf_submit(oParam);
  549. }
  550. function btn_search_onclick(obj:Button, e:ClickEventInfo)
  551. {
  552. misfGridInit(grd_winsuplplcecdamtlist);
  553. if(fCheckRetrieveData(false) == false)return;
  554. var oParam = {};
  555. oParam.id = "TRRST01701";
  556. oParam.service = "stocsumapp.StocSumMngt";
  557. oParam.method = "reqGetWinSuplplcecdAmtList";
  558. oParam.inds = "req=ds_send";
  559. oParam.outds = "ds_main_winsuplplcecdamtlist=winsuplplcecdamtlist";
  560. oParam.async = false;
  561. tranf_submit(oParam);
  562. }
  563. function fCheckRetrieveData()
  564. {
  565. if(!frmf_isRequiredControls("opt_instcd") )return false; // 물품구분
  566. if(!frmf_isRequiredControls("opt_goodflag") )return false; // 물품구분
  567. if(!frmf_isRequiredControls("ipt_winfrdd") )return false; // 작업년월
  568. if(!frmf_isRequiredControls("ipt_wintodd") )return false; // 작업년월
  569. //if(!isRequiredControls("cmb_stocdeptcd") )return false; // 부서코드
  570. }
  571. function btn_excel_onclick(obj:Button, e:ClickEventInfo)
  572. {
  573. misfSaveExcel(grd_winsuplplcecdamtlist);
  574. }
  575. function ckb_winpsnyn_onclick(obj:CheckBox, e:ClickEventInfo)
  576. {
  577. if(ckb_winpsnyn.value =="Y"){
  578. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "winpsn"),"size", 70);
  579. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "winpsnnm"),"size", 70);
  580. }else{
  581. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "winpsn"),"size", 0);
  582. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "winpsnnm"),"size", 0);
  583. }
  584. }
  585. function ckb_lrgcdyn_onclick(obj:CheckBox, e:ClickEventInfo)
  586. {
  587. if(ckb_lrgcdyn.value =="Y"){
  588. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "lrgcd"),"size", 30);
  589. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "lrgcdnm"),"size", 152);
  590. }else{
  591. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "lrgcd"),"size", 0);
  592. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "lrgcdnm"),"size", 0);
  593. }
  594. }
  595. function ckb_windeptcdyn_onclick(obj:CheckBox, e:ClickEventInfo)
  596. {
  597. if(ckb_windeptcdyn.value =="Y"){
  598. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "windeptcd"),"size", 98);
  599. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "windeptcdnm"),"size", 150);
  600. }else{
  601. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "windeptcd"),"size", 0);
  602. grd_winsuplplcecdamtlist.setFormatColProperty(grd_winsuplplcecdamtlist.getBindCellIndex("body", "windeptcdnm"),"size", 0);
  603. }
  604. }
  605. function group2_button1_onclick(obj:Button, e:ClickEventInfo)
  606. {
  607. misfSaveExcel(group2.grd_goodwin);
  608. }
  609. function btn_init_onclick(obj:Button, e:ClickEventInfo)
  610. {
  611. fInitialize();
  612. }
  613. ]]></Script>
  614. </Form>
  615. </FDL>