SMMNG04900_물품별안전재고조회.xfdl 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMMNG04900" position="absolute 0 0 1200 777" titletext="물품별 부서별 안전재고조회" oninit="SMMNG04900_oninit" onload="SMMNG04900_onload">
  5. <Layouts>
  6. <Layout>
  7. <Grid id="grd_safestoclist" taborder="5" binddataset="ds_main_safestocinfo_safestoclist" useinputpanel="false" position="absolute 0 96 1193 771" cellsizingtype="both" extendsizetype="row" oncellclick="grd_safestoclist_oncellclick" autosizingtype="row">
  8. <Formats>
  9. <Format id="default">
  10. <Columns>
  11. <Column size="61" band="left"/>
  12. <Column size="75" band="left"/>
  13. <Column size="149" band="left"/>
  14. <Column size="111" band="left"/>
  15. <Column size="95" band="left"/>
  16. <Column size="35" band="left"/>
  17. <Column size="70"/>
  18. <Column size="70"/>
  19. <Column size="70"/>
  20. <Column size="70"/>
  21. </Columns>
  22. <Rows>
  23. <Row size="24" band="head"/>
  24. <Row size="24" band="head"/>
  25. <Row size="24" band="head"/>
  26. <Row size="24"/>
  27. </Rows>
  28. <Band id="head">
  29. <Cell rowspan="3" text="구분" taborder="undefined"/>
  30. <Cell col="1" rowspan="3" text="물품코드" taborder="undefined"/>
  31. <Cell col="2" rowspan="3" text="물품명" taborder="undefined"/>
  32. <Cell col="3" rowspan="3" text="상세규격" taborder="undefined"/>
  33. <Cell col="4" rowspan="3" text="모델" taborder="undefined"/>
  34. <Cell col="5" rowspan="3" text="단위" taborder="undefined"/>
  35. <Cell col="6" colspan="2" text="합계" taborder="undefined"/>
  36. <Cell col="8" colspan="2" text="test" taborder="undefined"/>
  37. <Cell row="1" col="6" text="1_1" taborder="undefined"/>
  38. <Cell row="1" col="7" text="1_2" taborder="undefined"/>
  39. <Cell row="1" col="8" text="3_1"/>
  40. <Cell row="1" col="9" text="3_2"/>
  41. <Cell row="2" col="6" text="2_1" taborder="undefined"/>
  42. <Cell row="2" col="7" text="2_2" taborder="undefined"/>
  43. <Cell row="2" col="8" text="4_1"/>
  44. <Cell row="2" col="9" text="4_2"/>
  45. </Band>
  46. <Band id="body">
  47. <Cell displaytype="combo" edittype="combo" style="align:center middle;" text="bind:reqdetlflag" combodataset="ds_cmb_reqdetlflag" combocodecol="value" combodatacol="label"/>
  48. <Cell col="1" style="align:left middle;" text="bind:goodcd"/>
  49. <Cell col="2" style="align:left middle;" text="bind:csrgoodnm" wordwrap="word" autosizerow="limitmin"/>
  50. <Cell col="3" text="bind:csrgoodspec"/>
  51. <Cell col="4" text="bind:csrgoodmodel"/>
  52. <Cell col="5" text="bind:csrrequnit"/>
  53. <Cell col="6" displaytype="number" style="align:center middle;" text="bind:total2"/>
  54. <Cell col="7" displaytype="number" style="align:center middle;" text="bind:total"/>
  55. <Cell col="8"/>
  56. <Cell col="9"/>
  57. </Band>
  58. </Format>
  59. </Formats>
  60. </Grid>
  61. <Static id="cap_title" text="물품별 부서별 안전재고 조회" class="tit_1" position="absolute 0 0 252 25"/>
  62. <Static id="caption1" text="안전재고현황" class="tit_2" position="absolute 0 75 100 98"/>
  63. <Radio id="rdo_reqdetlflag" taborder="1" columncount="-1" rowcount="-1" innerdataset="@ds_init_codeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" position="absolute 115 69 612 92" onitemchanged="rdo_reqdetlflag_onitemchanged"/>
  64. <Shape id="line1" class="line_10" position="absolute 0 91 1193 97" anchor="left top right"/>
  65. <Div id="grp_sea" taborder="3" class="div_SA" position="absolute 0 25 1194 65" anchor="left top right">
  66. <Layouts>
  67. <Layout>
  68. <Button id="btn_search" taborder="8" text="조회" class="btn1" position="absolute 1070 11 1126 33" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
  69. <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1057 11 1063 31" anchor="top right"/>
  70. <Button id="button5" taborder="9" text="엑셀" class="btn7" position="absolute 1130 11 1186 33" anchor="top right" onclick="grp_sea_button5_onclick"/>
  71. <Static id="cap_instcd" text="업무일자 :" class="search_name" position="absolute 13 12 103 29" anchor="default"/>
  72. <Calendar id="ipt_workdd" taborder="10" class="ipt_workdd" position="absolute 103 11 206 30" anchor="default" autoselect="true" autoskip="true"/>
  73. <Static id="caption2" text="부 서 명 :" class="search_name" position="absolute 233 12 313 29" anchor="default"/>
  74. <Combo id="cmb_deptcd" taborder="11" innerdataset="@ds_init_csrdeptlist" codecolumn="deptcd" datacolumn="deptnm" position="absolute 311 11 411 30" anchor="default" onitemchanged="grp_sea_cmb_deptcd_onitemchanged"/>
  75. <Static id="caption3" text="물품조회구분 :" class="search_name" position="absolute 428 13 536 30" anchor="default"/>
  76. <Radio id="radio1" taborder="12" columncount="2" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 539 10 682 31" anchor="default">
  77. <Dataset id="innerdataset">
  78. <ColumnInfo>
  79. <Column id="codecolumn"/>
  80. <Column id="datacolumn"/>
  81. </ColumnInfo>
  82. <Rows>
  83. <Row>
  84. <Col id="codecolumn">1</Col>
  85. <Col id="datacolumn">물품코드</Col>
  86. </Row>
  87. <Row>
  88. <Col id="codecolumn">2</Col>
  89. <Col id="datacolumn">물품명</Col>
  90. </Row>
  91. </Rows>
  92. </Dataset>
  93. </Radio>
  94. <Edit id="ipt_srchnm" taborder="13" autoselect="true" autoskip="true" position="absolute 682 11 897 30" anchor="default" onkeydown="grp_sea_ipt_srchnm_onkeydown"/>
  95. </Layout>
  96. </Layouts>
  97. </Div>
  98. </Layout>
  99. </Layouts>
  100. <Objects>
  101. <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  102. <ColumnInfo>
  103. <Column id="workdd" type="STRING" size="256"/>
  104. <Column id="deptcd" type="STRING" size="256"/>
  105. <Column id="reqdetlflag" type="STRING" size="256"/>
  106. <Column id="flag" type="STRING" size="256"/>
  107. <Column id="srchnm" type="STRING" size="256"/>
  108. </ColumnInfo>
  109. <Rows>
  110. <Row>
  111. <Col id="workdd"/>
  112. <Col id="deptcd"/>
  113. <Col id="reqdetlflag"/>
  114. <Col id="flag">1</Col>
  115. <Col id="srchnm"/>
  116. </Row>
  117. </Rows>
  118. </Dataset>
  119. <Dataset id="ds_main_safestocinfo_safestoclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  120. <ColumnInfo>
  121. <Column id="reqdetlflag" type="STRING" size="256" sumtext="구분"/>
  122. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드"/>
  123. <Column id="csrgoodnm" type="STRING" size="256" sumtext="물품명"/>
  124. <Column id="csrgoodspec" type="STRING" size="256" sumtext="물품규격"/>
  125. <Column id="csrgoodmodel" type="STRING" size="256" sumtext="물품모델"/>
  126. <Column id="csrrequnit" type="STRING" size="256" sumtext="물품모델"/>
  127. <Column id="depthngnm1" type="STRING" size="256" sumtext="부서1"/>
  128. <Column id="depthngnm2" type="STRING" size="256" sumtext="부서2"/>
  129. <Column id="depthngnm3" type="STRING" size="256" sumtext="부서3"/>
  130. <Column id="depthngnm4" type="STRING" size="256" sumtext="부서4"/>
  131. <Column id="depthngnm5" type="STRING" size="256" sumtext="부서5"/>
  132. <Column id="depthngnm6" type="STRING" size="256" sumtext="부서6"/>
  133. <Column id="depthngnm7" type="STRING" size="256" sumtext="부서7"/>
  134. <Column id="depthngnm8" type="STRING" size="256" sumtext="부서8"/>
  135. <Column id="depthngnm9" type="STRING" size="256" sumtext="부서9"/>
  136. <Column id="depthngnm10" type="STRING" size="256" sumtext="부서10"/>
  137. <Column id="depthngnm11" type="STRING" size="256" sumtext="부서11"/>
  138. <Column id="depthngnm12" type="STRING" size="256" sumtext="부서12"/>
  139. <Column id="depthngnm13" type="STRING" size="256" sumtext="부서13"/>
  140. <Column id="depthngnm14" type="STRING" size="256" sumtext="부서14"/>
  141. <Column id="depthngnm15" type="STRING" size="256" sumtext="부서15"/>
  142. <Column id="depthngnm16" type="STRING" size="256" sumtext="부서16"/>
  143. <Column id="depthngnm17" type="STRING" size="256" sumtext="부서17"/>
  144. <Column id="depthngnm18" type="STRING" size="256" sumtext="부서18"/>
  145. <Column id="depthngnm19" type="STRING" size="256" sumtext="부서19"/>
  146. <Column id="depthngnm20" type="STRING" size="256" sumtext="부서20"/>
  147. <Column id="depthngnm21" type="STRING" size="256" sumtext="부서21"/>
  148. <Column id="depthngnm22" type="STRING" size="256" sumtext="부서22"/>
  149. <Column id="depthngnm23" type="STRING" size="256" sumtext="부서23"/>
  150. <Column id="depthngnm24" type="STRING" size="256" sumtext="부서24"/>
  151. <Column id="depthngnm25" type="STRING" size="256" sumtext="부서25"/>
  152. <Column id="depthngnm26" type="STRING" size="256" sumtext="부서26"/>
  153. <Column id="depthngnm27" type="STRING" size="256" sumtext="부서27"/>
  154. <Column id="depthngnm28" type="STRING" size="256" sumtext="부서28"/>
  155. <Column id="depthngnm29" type="STRING" size="256" sumtext="부서29"/>
  156. <Column id="depthngnm30" type="STRING" size="256" sumtext="부서30"/>
  157. <Column id="depthngnm31" type="STRING" size="256" sumtext="부서31"/>
  158. <Column id="depthngnm32" type="STRING" size="256" sumtext="부서32"/>
  159. <Column id="depthngnm33" type="STRING" size="256" sumtext="부서33"/>
  160. <Column id="depthngnm34" type="STRING" size="256" sumtext="부서34"/>
  161. <Column id="depthngnm35" type="STRING" size="256" sumtext="부서35"/>
  162. <Column id="depthngnm36" type="STRING" size="256" sumtext="부서36"/>
  163. <Column id="depthngnm37" type="STRING" size="256" sumtext="부서37"/>
  164. <Column id="depthngnm38" type="STRING" size="256" sumtext="부서38"/>
  165. <Column id="depthngnm39" type="STRING" size="256" sumtext="부서39"/>
  166. <Column id="depthngnm40" type="STRING" size="256" sumtext="부서40"/>
  167. <Column id="depthngnm41" type="STRING" size="256" sumtext="부서41"/>
  168. <Column id="depthngnm42" type="STRING" size="256" sumtext="부서42"/>
  169. <Column id="depthngnm43" type="STRING" size="256" sumtext="부서43"/>
  170. <Column id="depthngnm44" type="STRING" size="256" sumtext="부서44"/>
  171. <Column id="depthngnm45" type="STRING" size="256" sumtext="부서45"/>
  172. <Column id="depthngnm46" type="STRING" size="256" sumtext="부서46"/>
  173. <Column id="depthngnm47" type="STRING" size="256" sumtext="부서47"/>
  174. <Column id="depthngnm48" type="STRING" size="256" sumtext="부서48"/>
  175. <Column id="depthngnm49" type="STRING" size="256" sumtext="부서49"/>
  176. <Column id="depthngnm50" type="STRING" size="256" sumtext="부서50"/>
  177. <Column id="depthngnm51" type="STRING" size="256" sumtext="부서51"/>
  178. <Column id="depthngnm52" type="STRING" size="256" sumtext="부서52"/>
  179. <Column id="depthngnm53" type="STRING" size="256" sumtext="부서53"/>
  180. <Column id="depthngnm54" type="STRING" size="256" sumtext="부서54"/>
  181. <Column id="depthngnm55" type="STRING" size="256" sumtext="부서55"/>
  182. <Column id="depthngnm56" type="STRING" size="256" sumtext="부서56"/>
  183. <Column id="depthngnm57" type="STRING" size="256" sumtext="부서57"/>
  184. <Column id="depthngnm58" type="STRING" size="256" sumtext="부서58"/>
  185. <Column id="depthngnm59" type="STRING" size="256" sumtext="부서59"/>
  186. <Column id="depthngnm60" type="STRING" size="256" sumtext="부서60"/>
  187. <Column id="depthngnm61" type="STRING" size="256" sumtext="부서61"/>
  188. <Column id="depthngnm62" type="STRING" size="256" sumtext="부서62"/>
  189. <Column id="depthngnm63" type="STRING" size="256" sumtext="부서63"/>
  190. <Column id="depthngnm64" type="STRING" size="256" sumtext="부서64"/>
  191. <Column id="depthngnm65" type="STRING" size="256" sumtext="부서65"/>
  192. <Column id="depthngnm66" type="STRING" size="256" sumtext="부서66"/>
  193. <Column id="depthngnm67" type="STRING" size="256" sumtext="부서67"/>
  194. <Column id="depthngnm68" type="STRING" size="256" sumtext="부서68"/>
  195. <Column id="depthngnm69" type="STRING" size="256" sumtext="부서69"/>
  196. <Column id="depthngnm70" type="STRING" size="256" sumtext="부서70"/>
  197. <Column id="depthngnm71" type="STRING" size="256" sumtext="부서71"/>
  198. <Column id="depthngnm72" type="STRING" size="256" sumtext="부서72"/>
  199. <Column id="depthngnm73" type="STRING" size="256" sumtext="부서73"/>
  200. <Column id="depthngnm74" type="STRING" size="256" sumtext="부서74"/>
  201. <Column id="depthngnm75" type="STRING" size="256" sumtext="부서75"/>
  202. <Column id="depthngnm76" type="STRING" size="256" sumtext="부서76"/>
  203. <Column id="depthngnm77" type="STRING" size="256" sumtext="부서77"/>
  204. <Column id="depthngnm78" type="STRING" size="256" sumtext="부서78"/>
  205. <Column id="depthngnm79" type="STRING" size="256" sumtext="부서79"/>
  206. <Column id="depthngnm80" type="STRING" size="256" sumtext="부서80"/>
  207. <Column id="depthngnm81" type="STRING" size="256" sumtext="부서81"/>
  208. <Column id="depthngnm82" type="STRING" size="256" sumtext="부서82"/>
  209. <Column id="depthngnm83" type="STRING" size="256" sumtext="부서83"/>
  210. <Column id="depthngnm84" type="STRING" size="256" sumtext="부서84"/>
  211. <Column id="depthngnm85" type="STRING" size="256" sumtext="부서85"/>
  212. <Column id="depthngnm86" type="STRING" size="256" sumtext="부서86"/>
  213. <Column id="depthngnm87" type="STRING" size="256" sumtext="부서87"/>
  214. <Column id="depthngnm88" type="STRING" size="256" sumtext="부서88"/>
  215. <Column id="depthngnm89" type="STRING" size="256" sumtext="부서89"/>
  216. <Column id="depthngnm90" type="STRING" size="256" sumtext="부서90"/>
  217. <Column id="depthngnm91" type="STRING" size="256" sumtext="부서91"/>
  218. <Column id="depthngnm92" type="STRING" size="256" sumtext="부서92"/>
  219. <Column id="depthngnm93" type="STRING" size="256" sumtext="부서93"/>
  220. <Column id="depthngnm94" type="STRING" size="256" sumtext="부서94"/>
  221. <Column id="depthngnm95" type="STRING" size="256" sumtext="부서95"/>
  222. <Column id="depthngnm96" type="STRING" size="256" sumtext="부서96"/>
  223. <Column id="depthngnm97" type="STRING" size="256" sumtext="부서97"/>
  224. <Column id="depthngnm98" type="STRING" size="256" sumtext="부서98"/>
  225. <Column id="depthngnm99" type="STRING" size="256" sumtext="부서99"/>
  226. <Column id="depthngnm100" type="STRING" size="256" sumtext="부서100"/>
  227. <Column id="total" type="STRING" size="256" sumtext="합계"/>
  228. <Column id="deptlnsfcnt1" type="STRING" size="256" sumtext="부서1"/>
  229. <Column id="deptlnsfcnt2" type="STRING" size="256" sumtext="부서2"/>
  230. <Column id="deptlnsfcnt3" type="STRING" size="256" sumtext="부서3"/>
  231. <Column id="deptlnsfcnt4" type="STRING" size="256" sumtext="부서4"/>
  232. <Column id="deptlnsfcnt5" type="STRING" size="256" sumtext="부서5"/>
  233. <Column id="deptlnsfcnt6" type="STRING" size="256" sumtext="부서6"/>
  234. <Column id="deptlnsfcnt7" type="STRING" size="256" sumtext="부서7"/>
  235. <Column id="deptlnsfcnt8" type="STRING" size="256" sumtext="부서8"/>
  236. <Column id="deptlnsfcnt9" type="STRING" size="256" sumtext="부서9"/>
  237. <Column id="deptlnsfcnt10" type="STRING" size="256" sumtext="부서10"/>
  238. <Column id="deptlnsfcnt11" type="STRING" size="256" sumtext="부서11"/>
  239. <Column id="deptlnsfcnt12" type="STRING" size="256" sumtext="부서12"/>
  240. <Column id="deptlnsfcnt13" type="STRING" size="256" sumtext="부서13"/>
  241. <Column id="deptlnsfcnt14" type="STRING" size="256" sumtext="부서14"/>
  242. <Column id="deptlnsfcnt15" type="STRING" size="256" sumtext="부서15"/>
  243. <Column id="deptlnsfcnt16" type="STRING" size="256" sumtext="부서16"/>
  244. <Column id="deptlnsfcnt17" type="STRING" size="256" sumtext="부서17"/>
  245. <Column id="deptlnsfcnt18" type="STRING" size="256" sumtext="부서18"/>
  246. <Column id="deptlnsfcnt19" type="STRING" size="256" sumtext="부서19"/>
  247. <Column id="deptlnsfcnt20" type="STRING" size="256" sumtext="부서20"/>
  248. <Column id="deptlnsfcnt21" type="STRING" size="256" sumtext="부서21"/>
  249. <Column id="deptlnsfcnt22" type="STRING" size="256" sumtext="부서22"/>
  250. <Column id="deptlnsfcnt23" type="STRING" size="256" sumtext="부서23"/>
  251. <Column id="deptlnsfcnt24" type="STRING" size="256" sumtext="부서24"/>
  252. <Column id="deptlnsfcnt25" type="STRING" size="256" sumtext="부서25"/>
  253. <Column id="deptlnsfcnt26" type="STRING" size="256" sumtext="부서26"/>
  254. <Column id="deptlnsfcnt27" type="STRING" size="256" sumtext="부서27"/>
  255. <Column id="deptlnsfcnt28" type="STRING" size="256" sumtext="부서28"/>
  256. <Column id="deptlnsfcnt29" type="STRING" size="256" sumtext="부서29"/>
  257. <Column id="deptlnsfcnt30" type="STRING" size="256" sumtext="부서30"/>
  258. <Column id="deptlnsfcnt31" type="STRING" size="256" sumtext="부서31"/>
  259. <Column id="deptlnsfcnt32" type="STRING" size="256" sumtext="부서32"/>
  260. <Column id="deptlnsfcnt33" type="STRING" size="256" sumtext="부서33"/>
  261. <Column id="deptlnsfcnt34" type="STRING" size="256" sumtext="부서34"/>
  262. <Column id="deptlnsfcnt35" type="STRING" size="256" sumtext="부서35"/>
  263. <Column id="deptlnsfcnt36" type="STRING" size="256" sumtext="부서36"/>
  264. <Column id="deptlnsfcnt37" type="STRING" size="256" sumtext="부서37"/>
  265. <Column id="deptlnsfcnt38" type="STRING" size="256" sumtext="부서38"/>
  266. <Column id="deptlnsfcnt39" type="STRING" size="256" sumtext="부서39"/>
  267. <Column id="deptlnsfcnt40" type="STRING" size="256" sumtext="부서40"/>
  268. <Column id="deptlnsfcnt41" type="STRING" size="256" sumtext="부서41"/>
  269. <Column id="deptlnsfcnt42" type="STRING" size="256" sumtext="부서42"/>
  270. <Column id="deptlnsfcnt43" type="STRING" size="256" sumtext="부서43"/>
  271. <Column id="deptlnsfcnt44" type="STRING" size="256" sumtext="부서44"/>
  272. <Column id="deptlnsfcnt45" type="STRING" size="256" sumtext="부서45"/>
  273. <Column id="deptlnsfcnt46" type="STRING" size="256" sumtext="부서46"/>
  274. <Column id="depthngnm47" type="STRING" size="256" sumtext="부서47"/>
  275. <Column id="depthngnm48" type="STRING" size="256" sumtext="부서48"/>
  276. <Column id="depthngnm49" type="STRING" size="256" sumtext="부서49"/>
  277. <Column id="depthngnm50" type="STRING" size="256" sumtext="부서50"/>
  278. <Column id="depthngnm51" type="STRING" size="256" sumtext="부서51"/>
  279. <Column id="depthngnm52" type="STRING" size="256" sumtext="부서52"/>
  280. <Column id="depthngnm53" type="STRING" size="256" sumtext="부서53"/>
  281. <Column id="depthngnm54" type="STRING" size="256" sumtext="부서54"/>
  282. <Column id="depthngnm55" type="STRING" size="256" sumtext="부서55"/>
  283. <Column id="depthngnm56" type="STRING" size="256" sumtext="부서56"/>
  284. <Column id="depthngnm57" type="STRING" size="256" sumtext="부서57"/>
  285. <Column id="depthngnm58" type="STRING" size="256" sumtext="부서58"/>
  286. <Column id="depthngnm59" type="STRING" size="256" sumtext="부서59"/>
  287. <Column id="depthngnm60" type="STRING" size="256" sumtext="부서60"/>
  288. <Column id="depthngnm61" type="STRING" size="256" sumtext="부서61"/>
  289. <Column id="depthngnm62" type="STRING" size="256" sumtext="부서62"/>
  290. <Column id="depthngnm63" type="STRING" size="256" sumtext="부서63"/>
  291. <Column id="depthngnm64" type="STRING" size="256" sumtext="부서64"/>
  292. <Column id="depthngnm65" type="STRING" size="256" sumtext="부서65"/>
  293. <Column id="depthngnm66" type="STRING" size="256" sumtext="부서66"/>
  294. <Column id="depthngnm67" type="STRING" size="256" sumtext="부서67"/>
  295. <Column id="depthngnm68" type="STRING" size="256" sumtext="부서68"/>
  296. <Column id="depthngnm69" type="STRING" size="256" sumtext="부서69"/>
  297. <Column id="depthngnm70" type="STRING" size="256" sumtext="부서70"/>
  298. <Column id="depthngnm71" type="STRING" size="256" sumtext="부서71"/>
  299. <Column id="depthngnm72" type="STRING" size="256" sumtext="부서72"/>
  300. <Column id="depthngnm73" type="STRING" size="256" sumtext="부서73"/>
  301. <Column id="depthngnm74" type="STRING" size="256" sumtext="부서74"/>
  302. <Column id="depthngnm75" type="STRING" size="256" sumtext="부서75"/>
  303. <Column id="depthngnm76" type="STRING" size="256" sumtext="부서76"/>
  304. <Column id="depthngnm77" type="STRING" size="256" sumtext="부서77"/>
  305. <Column id="depthngnm78" type="STRING" size="256" sumtext="부서78"/>
  306. <Column id="depthngnm79" type="STRING" size="256" sumtext="부서79"/>
  307. <Column id="depthngnm80" type="STRING" size="256" sumtext="부서80"/>
  308. <Column id="depthngnm81" type="STRING" size="256" sumtext="부서81"/>
  309. <Column id="depthngnm82" type="STRING" size="256" sumtext="부서82"/>
  310. <Column id="depthngnm83" type="STRING" size="256" sumtext="부서83"/>
  311. <Column id="depthngnm84" type="STRING" size="256" sumtext="부서84"/>
  312. <Column id="depthngnm85" type="STRING" size="256" sumtext="부서85"/>
  313. <Column id="depthngnm86" type="STRING" size="256" sumtext="부서86"/>
  314. <Column id="depthngnm87" type="STRING" size="256" sumtext="부서87"/>
  315. <Column id="depthngnm88" type="STRING" size="256" sumtext="부서88"/>
  316. <Column id="depthngnm89" type="STRING" size="256" sumtext="부서89"/>
  317. <Column id="depthngnm90" type="STRING" size="256" sumtext="부서90"/>
  318. <Column id="depthngnm91" type="STRING" size="256" sumtext="부서91"/>
  319. <Column id="depthngnm92" type="STRING" size="256" sumtext="부서92"/>
  320. <Column id="depthngnm93" type="STRING" size="256" sumtext="부서93"/>
  321. <Column id="depthngnm94" type="STRING" size="256" sumtext="부서94"/>
  322. <Column id="depthngnm95" type="STRING" size="256" sumtext="부서95"/>
  323. <Column id="depthngnm96" type="STRING" size="256" sumtext="부서96"/>
  324. <Column id="depthngnm97" type="STRING" size="256" sumtext="부서97"/>
  325. <Column id="depthngnm98" type="STRING" size="256" sumtext="부서98"/>
  326. <Column id="depthngnm99" type="STRING" size="256" sumtext="부서99"/>
  327. <Column id="depthngnm100" type="STRING" size="256" sumtext="부서100"/>
  328. <Column id="total2" type="STRING" size="256" sumtext="합계"/>
  329. </ColumnInfo>
  330. </Dataset>
  331. <Dataset id="ds_init_csrdeptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  332. <ColumnInfo>
  333. <Column id="deptnm" type="STRING" size="256"/>
  334. <Column id="deptcd" type="STRING" size="256"/>
  335. </ColumnInfo>
  336. </Dataset>
  337. <Dataset id="ds_init_codeinfo_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  338. <ColumnInfo>
  339. <Column id="cdnm" type="STRING" size="256"/>
  340. <Column id="cdid" type="STRING" size="256"/>
  341. </ColumnInfo>
  342. </Dataset>
  343. <Dataset id="ds_cmb_reqdetlflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  344. <ColumnInfo>
  345. <Column id="label" type="STRING" size="256"/>
  346. <Column id="value" type="STRING" size="256"/>
  347. </ColumnInfo>
  348. <Rows>
  349. <Row>
  350. <Col id="label">기구</Col>
  351. <Col id="value">1</Col>
  352. </Row>
  353. <Row>
  354. <Col id="label">진료재료</Col>
  355. <Col id="value">2</Col>
  356. </Row>
  357. <Row>
  358. <Col id="label">린넨</Col>
  359. <Col id="value">3</Col>
  360. </Row>
  361. <Row>
  362. <Col id="label">멸균방포</Col>
  363. <Col id="value">4</Col>
  364. </Row>
  365. <Row>
  366. <Col id="label">기타</Col>
  367. <Col id="value">9</Col>
  368. </Row>
  369. </Rows>
  370. </Dataset>
  371. <Dataset id="ds_main_safestocinfo_paramlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  372. <ColumnInfo>
  373. <Column id="title" type="STRING" size="256" sumtext="타이틀"/>
  374. <Column id="cnt" type="STRING" size="256" sumtext="갯수"/>
  375. </ColumnInfo>
  376. </Dataset>
  377. <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  378. <ColumnInfo>
  379. <Column id="cdgrupid" type="STRING" size="256" sumtext="코드그룹ID"/>
  380. <Column id="srchdd" type="STRING" size="256" sumtext="조회기준일자"/>
  381. <Column id="flag" type="STRING" size="256" sumtext="조회기준일자"/>
  382. <Column id="allflag" type="STRING" size="256" sumtext="모두조회여부"/>
  383. </ColumnInfo>
  384. </Dataset>
  385. </Objects>
  386. <Bind>
  387. <BindItem id="item0" compid="grp_sea.ipt_workdd" propid="value" datasetid="ds_main_cond" columnid="workdd"/>
  388. <BindItem id="item1" compid="grp_sea.cmb_deptcd" propid="value" datasetid="ds_main_cond" columnid="deptcd"/>
  389. <BindItem id="item2" compid="grp_sea.radio1" propid="value" datasetid="ds_main_cond" columnid="flag"/>
  390. <BindItem id="item3" compid="grp_sea.ipt_srchnm" propid="value" datasetid="ds_main_cond" columnid="srchnm"/>
  391. <BindItem id="item4" compid="rdo_reqdetlflag" propid="value" datasetid="ds_main_cond" columnid="reqdetlflag"/>
  392. </Bind>
  393. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  394. * System Name :
  395. * Job Name :
  396. * Creator :
  397. * Make Date : 2017-07-11
  398. * Description :
  399. *---------------------------------------------------------------------------------------
  400. * Modify Date Modifier Modify Description
  401. *---------------------------------------------------------------------------------------
  402. * 2017-07-11 Live Converter TF->XP
  403. *
  404. *---------------------------------------------------------------------------------------
  405. ****************************************************************************************/
  406. include "com_commonxp::comm_main.xjs";
  407. function SMMNG04900_oninit(obj:Form, e:InitEventInfo)
  408. {
  409. frmf_initForm(obj);
  410. }
  411. function SMMNG04900_onload(obj:Form, e:LoadEventInfo)
  412. {
  413. //grdf_initGrid(grd_safestoclist);
  414. fInitialize();
  415. }
  416. function fInitialize()
  417. {
  418. ds_main_cond.setColumn(0, "workdd", utlf_getCurrentDate());
  419. var oParam = {};
  420. oParam.id = "TRMNG00402";
  421. oParam.service = "csrapp.CsrMngt";
  422. oParam.method = "getCsrDeptList";
  423. oParam.inds = "req=ds_main_cond";
  424. oParam.outds = "ds_init_csrdeptlist=csrdeptlist";
  425. oParam.async = false;
  426. //oParam.callback = "cf_TRMNG00402";
  427. tranf_submit(oParam);
  428. frmf_addComboItem("grp_sea.cmb_deptcd","전체","","above");
  429. var cdgrupid = "'T95'"
  430. dsf_makeValue(ds_send_reqdata, "cdgrupid", "string", cdgrupid, 0);
  431. dsf_makeValue(ds_send_reqdata, "srchdd", "string", utlf_getCurrentDate(), 0);
  432. var oParam = {};
  433. oParam.id = "TRMNW00001";
  434. oParam.service = "wardcareapp.WardCareMngt";
  435. oParam.method = "reqGetNursHardCdInfo";
  436. oParam.inds = "req=ds_send_reqdata";
  437. oParam.outds = "ds_init_codeinfo_codelist=codelist";
  438. oParam.async = false;
  439. //oParam.callback = "cf_TRMNW00001";
  440. tranf_submit(oParam);
  441. frmf_addComboItem("rdo_reqdetlflag","전체","","above");
  442. ds_init_codeinfo_codelist.filterstr = "cdgrupid == 'T95' || utlf_isNull(cdid)";
  443. fSearch();
  444. }
  445. function fSearch()
  446. {
  447. var oParam = {};
  448. oParam.id = "TRMNG04901";
  449. oParam.service = "csrapp.CsrMngt";
  450. oParam.method = "reqGetSafeStoclist";
  451. oParam.inds = "req=ds_main_cond";
  452. oParam.outds = "ds_main_safestocinfo_safestoclist=safestoclist ds_main_safestocinfo_paramlist=paramlist";
  453. oParam.async = false;
  454. //oParam.callback = "cf_TRMNG04901";
  455. tranf_submit(oParam);
  456. var cnt = ds_main_safestocinfo_paramlist.getColumn(0, "cnt");
  457. var caption = ds_main_safestocinfo_paramlist.getColumn(0, "title");
  458. caption = caption.split("^");
  459. var strS = "";
  460. var strE = "";
  461. var j = 0;
  462. var sColumnInfo = "";
  463. var sRowInfo = "";
  464. var sHeadInfo = "";
  465. var sHeadInfo2 = "";
  466. var sHeadInfo3 = "";
  467. var sBodyInfo = "";
  468. var sFormatInfo = "";
  469. sColumnInfo += '<Columns size="61" band="left"/> \r\n';
  470. sColumnInfo += '<Columns size="75" band="left"/> \r\n';
  471. sColumnInfo += '<Columns size="149" band="left"/> \r\n';
  472. sColumnInfo += '<Columns size="111" band="left"/> \r\n';
  473. sColumnInfo += '<Columns size="95" band="left"/> \r\n';
  474. sColumnInfo += '<Columns size="35" band="left"/> \r\n';
  475. sRowInfo += '<Row size="24" band="head" /> \r\n';
  476. sRowInfo += '<Row size="24" band="head" /> \r\n';
  477. sRowInfo += '<Row size="24" band="head" /> \r\n';
  478. sRowInfo += '<Row size="24" /> \r\n';
  479. sHeadInfo = '<Cell rowspan="3" text="구분" taborder="undefined"/> \r\n';
  480. sHeadInfo += '<Cell col="1" rowspan="3" text="물품코드" taborder="undefined"/> \r\n';
  481. sHeadInfo += '<Cell col="2" rowspan="3" text="물품명" taborder="undefined"/> \r\n';
  482. sHeadInfo += '<Cell col="3" rowspan="3" text="상세규격" taborder="undefined"/> \r\n';
  483. sHeadInfo += '<Cell col="4" rowspan="3" text="모델" taborder="undefined"/> \r\n';
  484. sHeadInfo += '<Cell col="5" rowspan="3" text="단위" taborder="undefined"/> \r\n';
  485. sBodyInfo += '<Cell autosizerow="limitmin" displaytype="combo" edittype="combo" style="align:center&#32;middle;" text="bind:reqdetlflag" combodataset="ds_cmb_reqdetlflag" combocodecol="value" combodatacol="label"/> \r\n';
  486. sBodyInfo += '<Cell autosizerow="limitmin" col="1" style="align:left&#32;middle;" text="bind:goodcd"/> \r\n';
  487. sBodyInfo += '<Cell col="2" style="align:left&#32;middle;" text="bind:csrgoodnm" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
  488. sBodyInfo += '<Cell col="3" style="align:left&#32;middle;" text="bind:csrgoodspec" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
  489. sBodyInfo += '<Cell col="4" style="align:left&#32;middle;" text="bind:csrgoodmodel" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
  490. sBodyInfo += '<Cell col="5" text="bind:csrrequnit" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
  491. var gubun = false;
  492. var row = "1";
  493. var strS = "";
  494. var strE = "";
  495. var k = 6;
  496. var row1Gubun = false;
  497. var row2Gubun = false;
  498. var total = 0;
  499. for(var i = 6; i < caption.length; i++)
  500. {
  501. if(utlf_isNull(caption[i]) || caption[i] == "null"){
  502. break;
  503. }
  504. strS = caption[i];
  505. if(strS != strE){
  506. sHeadInfo += '<Cell autosizerow="limitmin" col="' + k + '" colspan="2" text="'+ caption[i] +'"/> \r\n';
  507. sBodyInfo += '<Cell autosizerow="limitmin" col="' + k + '" displaytype="number" style="align:center&#32;middle;" text="bind:deptlnsfcnt'+(eval(k/2)-2)+'"/> \r\n';
  508. sBodyInfo += '<Cell autosizerow="limitmin" col="' + eval(k + 1) + '" displaytype="number" style="align:center&#32;middle;" text="bind:depthngnm'+(eval(k/2)-2)+'"/> \r\n';
  509. }
  510. strE = strS;
  511. if(k % 2 == 0){
  512. sHeadInfo2 += '<Cell row="1" col="' + k + '" text="운용"/> \r\n';
  513. }else{
  514. sHeadInfo2 += '<Cell row="1" col="' + k + '" text="물품보관실"/> \r\n';
  515. }
  516. sHeadInfo3 += '<Cell row="2" col="' + k + '" text="안전재고"/> \r\n';
  517. sColumnInfo += '<Columns size="70" /> \r\n';
  518. k++;
  519. }
  520. sHeadInfo += '<Cell col="' + k + '" colspan="2" text="합계"/> \r\n';
  521. sHeadInfo2 += '<Cell row="1" col="' + k + '" text="운용"/> \r\n';
  522. sHeadInfo2 += '<Cell row="1" col="' + (eval(k) + 1)+ '" text="물품보관실"/> \r\n';
  523. sHeadInfo3 += '<Cell row="2" col="' + k + '" text="안전재고"/> \r\n';
  524. sHeadInfo3 += '<Cell row="2" col="' + (eval(k) + 1) + '" text="안전재고"/> \r\n';
  525. sColumnInfo += '<Columns size="70" /> \r\n';
  526. sColumnInfo += '<Columns size="70" /> \r\n';
  527. sBodyInfo += '<Cell col="' + k + '" displaytype="number" style="align:center&#32;middle;" text="bind:total2"/> \r\n';
  528. sBodyInfo += '<Cell col="' + (eval(k) + 1) + '" displaytype="number" style="align:center&#32;middle;" text="bind:total"/> \r\n';
  529. sHeadInfo = sHeadInfo + sHeadInfo2 + sHeadInfo3;
  530. sColumnInfo = '<Columns> \r\n' + sColumnInfo + '</Columns> \r\n' ;
  531. sRowInfo = '<Rows> \r\n' + sRowInfo + '</Rows> \r\n';
  532. sHeadInfo = '<Band id="head"> \r\n' + sHeadInfo + '</Band> \r\n';
  533. sBodyInfo = '<Band id="body"> \r\n' + sBodyInfo + '</Band> \r\n';
  534. sFormatInfo = '<Formats> \r\n';
  535. sFormatInfo += '<Format id="default"> \r\n';
  536. sFormatInfo += sColumnInfo + sRowInfo + sHeadInfo + sBodyInfo;
  537. sFormatInfo += '</Format> \r\n';
  538. sFormatInfo += '</Formats>';
  539. grd_safestoclist.enableredraw = false;
  540. grd_safestoclist.formats = sFormatInfo;
  541. grd_safestoclist.enableredraw = true;
  542. grd_safestoclist.binddataset = "ds_main_safestocinfo_safestoclist";
  543. grd_safestoclist.updateToDataset();
  544. }
  545. function grp_sea_button5_onclick(obj:Button, e:ClickEventInfo)
  546. {
  547. grdf_exportExcel(grd_safestoclist, ds_main_cond.getColumn(0, "workdd")+"물품별안전재고", "sheet1", "true", "", "");
  548. }
  549. function rdo_reqdetlflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
  550. {
  551. grp_sea.btn_search.click();
  552. }
  553. function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
  554. {
  555. fSearch();
  556. }
  557. function grp_sea_cmb_deptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  558. {
  559. grp_sea_btn_search_onclick();
  560. }
  561. function grp_sea_ipt_srchnm_onkeydown(obj:Edit, e:KeyEventInfo)
  562. {
  563. if(e.keycode == 13) {
  564. obj.updateToDataset();
  565. //setInputNodeCurText();
  566. grp_sea_btn_search_onclick();
  567. grp_sea.ipt_srchnm.value = "";
  568. }
  569. }
  570. ]]></Script>
  571. </Form>
  572. </FDL>