SMAES00600_당일검사현황.xfdl 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMAES00600" position="absolute 0 0 1196 765" titletext="당일검사현황(예약검사)" onload="SMAES00600_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption6" text="당일검사현황(예약검사)" class="tit_1" position="absolute 0 0 200 25"/>
  8. <Div id="grp_sea" taborder="1" style="align: top;" position="absolute 0 25 1195 65" class="div_SA" anchor="left top right">
  9. <Layouts>
  10. <Layout>
  11. <Static id="caption2" text="조회기간 :" class="search_name" position="absolute 15 12 101 29" anchor="default"/>
  12. <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1110 10 1113 30" anchor="top right"/>
  13. <Button id="btn_sea" taborder="1" text="조회" onclick="grp_sea_btn_sea_onclick" class="btn1" position="absolute 1126 9 1182 31" anchor="top right"/>
  14. <Combo id="cmb_srchdd" taborder="2" innerdataset="ds_init_com_srchdate_item" codecolumn="value" datacolumn="label" onitemchanged="grp_sea_cmb_srchdd_onitemchanged" position="absolute 107 11 180 30" columncount="-1" rowcount="-1" anchor="default"/>
  15. <Combo id="cmb_srchmm" taborder="3" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="grp_sea_cmb_srchmm_onitemchanged" position="absolute 183 11 256 30" columncount="-1" rowcount="-1" anchor="default">
  16. <Dataset id="innerdataset">
  17. <ColumnInfo>
  18. <Column id="codecolumn"/>
  19. <Column id="datacolumn"/>
  20. </ColumnInfo>
  21. <Rows>
  22. <Row>
  23. <Col id="codecolumn">01</Col>
  24. <Col id="datacolumn">1월</Col>
  25. </Row>
  26. <Row>
  27. <Col id="codecolumn">02</Col>
  28. <Col id="datacolumn">2월</Col>
  29. </Row>
  30. <Row>
  31. <Col id="codecolumn">03</Col>
  32. <Col id="datacolumn">3월</Col>
  33. </Row>
  34. <Row>
  35. <Col id="codecolumn">04</Col>
  36. <Col id="datacolumn">4월</Col>
  37. </Row>
  38. <Row>
  39. <Col id="codecolumn">05</Col>
  40. <Col id="datacolumn">5월</Col>
  41. </Row>
  42. <Row>
  43. <Col id="codecolumn">06</Col>
  44. <Col id="datacolumn">6월</Col>
  45. </Row>
  46. <Row>
  47. <Col id="codecolumn">07</Col>
  48. <Col id="datacolumn">7월</Col>
  49. </Row>
  50. <Row>
  51. <Col id="codecolumn">08</Col>
  52. <Col id="datacolumn">8월</Col>
  53. </Row>
  54. <Row>
  55. <Col id="codecolumn">09</Col>
  56. <Col id="datacolumn">9월</Col>
  57. </Row>
  58. <Row>
  59. <Col id="codecolumn">10</Col>
  60. <Col id="datacolumn">10월</Col>
  61. </Row>
  62. <Row>
  63. <Col id="codecolumn">11</Col>
  64. <Col id="datacolumn">11월</Col>
  65. </Row>
  66. <Row>
  67. <Col id="codecolumn">12</Col>
  68. <Col id="datacolumn">12월</Col>
  69. </Row>
  70. </Rows>
  71. </Dataset>
  72. </Combo>
  73. </Layout>
  74. </Layouts>
  75. </Div>
  76. <Static id="caption1" text="당일검사현황(예약검사)" class="tit_2" position="absolute 0 73 200 90"/>
  77. <Shape id="line1" class="line_10" position="absolute 0 89 1195 95" anchor="left top right"/>
  78. <Grid id="grd_list" taborder="2" binddataset="ds_main_list_item" useinputpanel="false" position="absolute 0 94 1195 764" selecttype="multirow" autofittype="col" extendsizetype="row" autosizingtype="row" anchor="all">
  79. <Formats>
  80. <Format id="default">
  81. <Columns>
  82. <Column size="25" band="left"/>
  83. <Column size="75"/>
  84. <Column size="110"/>
  85. <Column size="30"/>
  86. <Column size="30"/>
  87. <Column size="30"/>
  88. <Column size="30"/>
  89. <Column size="30"/>
  90. <Column size="30"/>
  91. <Column size="30"/>
  92. <Column size="30"/>
  93. <Column size="30"/>
  94. <Column size="30"/>
  95. <Column size="30"/>
  96. <Column size="30"/>
  97. <Column size="30"/>
  98. <Column size="30"/>
  99. <Column size="30"/>
  100. <Column size="30"/>
  101. <Column size="30"/>
  102. <Column size="30"/>
  103. <Column size="30"/>
  104. <Column size="30"/>
  105. <Column size="30"/>
  106. <Column size="30"/>
  107. <Column size="30"/>
  108. <Column size="30"/>
  109. <Column size="30"/>
  110. <Column size="30"/>
  111. <Column size="30"/>
  112. <Column size="30"/>
  113. <Column size="30"/>
  114. <Column size="30"/>
  115. <Column size="30"/>
  116. <Column size="50"/>
  117. </Columns>
  118. <Rows>
  119. <Row size="24" band="head"/>
  120. <Row size="24" band="head"/>
  121. <Row size="24"/>
  122. <Row size="24" band="summ"/>
  123. </Rows>
  124. <Band id="head">
  125. <Cell rowspan="2" taborder="undefined"/>
  126. <Cell col="1" rowspan="2" text="구분" taborder="undefined"/>
  127. <Cell col="2" rowspan="2" text="검사실명" taborder="undefined"/>
  128. <Cell col="3" text="1"/>
  129. <Cell col="4" text="2"/>
  130. <Cell col="5" text="3"/>
  131. <Cell col="6" text="4"/>
  132. <Cell col="7" text="5"/>
  133. <Cell col="8" text="6"/>
  134. <Cell col="9" text="7"/>
  135. <Cell col="10" text="8"/>
  136. <Cell col="11" text="9"/>
  137. <Cell col="12" text="10"/>
  138. <Cell col="13" text="11"/>
  139. <Cell col="14" text="12"/>
  140. <Cell col="15" text="13"/>
  141. <Cell col="16" text="14"/>
  142. <Cell col="17" text="15"/>
  143. <Cell col="18" text="16"/>
  144. <Cell col="19" text="17"/>
  145. <Cell col="20" text="18"/>
  146. <Cell col="21" text="19"/>
  147. <Cell col="22" text="20"/>
  148. <Cell col="23" text="21"/>
  149. <Cell col="24" text="22"/>
  150. <Cell col="25" text="23"/>
  151. <Cell col="26" text="24"/>
  152. <Cell col="27" text="25"/>
  153. <Cell col="28" text="26"/>
  154. <Cell col="29" text="27"/>
  155. <Cell col="30" text="28"/>
  156. <Cell col="31" text="29"/>
  157. <Cell col="32" text="30"/>
  158. <Cell col="33" text="31"/>
  159. <Cell col="34" rowspan="2" text="합계" taborder="undefined"/>
  160. <Cell col="35" text="구분"/>
  161. <Cell col="36" text="검사실명"/>
  162. <Cell col="37" text="일"/>
  163. <Cell col="38" text="월"/>
  164. <Cell col="39" text="화"/>
  165. <Cell col="40" text="수"/>
  166. <Cell col="41" text="목"/>
  167. <Cell col="42" text="금"/>
  168. <Cell col="43" text="토"/>
  169. <Cell col="44" text="일"/>
  170. <Cell col="45" text="월"/>
  171. <Cell col="46" text="화"/>
  172. <Cell col="47" text="수"/>
  173. <Cell col="48" text="목"/>
  174. <Cell col="49" text="금"/>
  175. <Cell col="50" text="토"/>
  176. <Cell col="51" text="일"/>
  177. <Cell col="52" text="월"/>
  178. <Cell col="53" text="화"/>
  179. <Cell col="54" text="수"/>
  180. <Cell col="55" text="목"/>
  181. <Cell col="56" text="금"/>
  182. <Cell col="57" text="토"/>
  183. <Cell col="58" text="일"/>
  184. <Cell col="59" text="월"/>
  185. <Cell col="60" text="화"/>
  186. <Cell col="61" text="수"/>
  187. <Cell col="62" text="목"/>
  188. <Cell col="63" text="금"/>
  189. <Cell col="64" text="토"/>
  190. <Cell col="65" text="일"/>
  191. <Cell col="66" text="월"/>
  192. <Cell col="67" text="화"/>
  193. <Cell col="68" text="합계"/>
  194. <Cell row="1" col="3" text="일"/>
  195. <Cell row="1" col="4" text="월"/>
  196. <Cell row="1" col="5" text="화"/>
  197. <Cell row="1" col="6" text="수"/>
  198. <Cell row="1" col="7" text="목"/>
  199. <Cell row="1" col="8" text="금"/>
  200. <Cell row="1" col="9" text="토"/>
  201. <Cell row="1" col="10" text="일"/>
  202. <Cell row="1" col="11" text="월"/>
  203. <Cell row="1" col="12" text="화"/>
  204. <Cell row="1" col="13" text="수"/>
  205. <Cell row="1" col="14" text="목"/>
  206. <Cell row="1" col="15" text="금"/>
  207. <Cell row="1" col="16" text="토"/>
  208. <Cell row="1" col="17" text="일"/>
  209. <Cell row="1" col="18" text="월"/>
  210. <Cell row="1" col="19" text="화"/>
  211. <Cell row="1" col="20" text="수"/>
  212. <Cell row="1" col="21" text="목"/>
  213. <Cell row="1" col="22" text="금"/>
  214. <Cell row="1" col="23" text="토"/>
  215. <Cell row="1" col="24" text="일"/>
  216. <Cell row="1" col="25" text="월"/>
  217. <Cell row="1" col="26" text="화"/>
  218. <Cell row="1" col="27" text="수"/>
  219. <Cell row="1" col="28" text="목"/>
  220. <Cell row="1" col="29" text="금"/>
  221. <Cell row="1" col="30" text="토"/>
  222. <Cell row="1" col="31" text="일"/>
  223. <Cell row="1" col="32" text="월"/>
  224. <Cell row="1" col="33" text="화"/>
  225. </Band>
  226. <Band id="body">
  227. <Cell celltype="head" text="expr:currow+1"/>
  228. <Cell col="1" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:testnm" wordwrap="char" suppress="1" suppressalign="middle,over" autosizerow="limitmin"/>
  229. <Cell col="2" displaytype="text" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:testroom" wordwrap="char" suppress="2" suppressalign="middle,over" autosizerow="limitmin"/>
  230. <Cell col="3" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day01"/>
  231. <Cell col="4" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day02"/>
  232. <Cell col="5" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day03"/>
  233. <Cell col="6" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day04"/>
  234. <Cell col="7" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day05"/>
  235. <Cell col="8" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day06"/>
  236. <Cell col="9" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day07"/>
  237. <Cell col="10" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day08"/>
  238. <Cell col="11" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day09"/>
  239. <Cell col="12" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day10"/>
  240. <Cell col="13" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day11"/>
  241. <Cell col="14" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day12"/>
  242. <Cell col="15" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day13"/>
  243. <Cell col="16" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day14"/>
  244. <Cell col="17" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day15"/>
  245. <Cell col="18" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day16"/>
  246. <Cell col="19" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day17"/>
  247. <Cell col="20" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day18"/>
  248. <Cell col="21" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day19"/>
  249. <Cell col="22" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day20"/>
  250. <Cell col="23" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day21"/>
  251. <Cell col="24" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day22"/>
  252. <Cell col="25" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day23"/>
  253. <Cell col="26" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day24"/>
  254. <Cell col="27" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day25"/>
  255. <Cell col="28" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day26"/>
  256. <Cell col="29" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day27"/>
  257. <Cell col="30" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day28"/>
  258. <Cell col="31" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day29"/>
  259. <Cell col="32" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day30"/>
  260. <Cell col="33" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_day31"/>
  261. <Cell col="34" displaytype="number" style="background:#ffffffff;background2:#ffffffff;color:#000000ff;color2:#000000ff;" text="bind:p_daysum"/>
  262. </Band>
  263. <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
  264. <Cell/>
  265. <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
  266. <Cell col="3" displaytype="number" text="expr:getSum('p_day01')"/>
  267. <Cell col="4" displaytype="number" text="expr:getSum('p_day02')"/>
  268. <Cell col="5" displaytype="number" text="expr:getSum('p_day03')"/>
  269. <Cell col="6" displaytype="number" text="expr:getSum('p_day04')"/>
  270. <Cell col="7" displaytype="number" text="expr:getSum('p_day05')"/>
  271. <Cell col="8" displaytype="number" text="expr:getSum('p_day06')"/>
  272. <Cell col="9" displaytype="number" text="expr:getSum('p_day07')"/>
  273. <Cell col="10" displaytype="number" text="expr:getSum('p_day08')"/>
  274. <Cell col="11" displaytype="number" text="expr:getSum('p_day09')"/>
  275. <Cell col="12" displaytype="number" text="expr:getSum('p_day10')"/>
  276. <Cell col="13" displaytype="number" text="expr:getSum('p_day11')"/>
  277. <Cell col="14" displaytype="number" text="expr:getSum('p_day12')"/>
  278. <Cell col="15" displaytype="number" text="expr:getSum('p_day13')"/>
  279. <Cell col="16" displaytype="number" text="expr:getSum('p_day14')"/>
  280. <Cell col="17" displaytype="number" text="expr:getSum('p_day15')"/>
  281. <Cell col="18" displaytype="number" text="expr:getSum('p_day16')"/>
  282. <Cell col="19" displaytype="number" text="expr:getSum('p_day17')"/>
  283. <Cell col="20" displaytype="number" text="expr:getSum('p_day18')"/>
  284. <Cell col="21" displaytype="number" text="expr:getSum('p_day19')"/>
  285. <Cell col="22" displaytype="number" text="expr:getSum('p_day20')"/>
  286. <Cell col="23" displaytype="number" text="expr:getSum('p_day21')"/>
  287. <Cell col="24" displaytype="number" text="expr:getSum('p_day22')"/>
  288. <Cell col="25" displaytype="number" text="expr:getSum('p_day23')"/>
  289. <Cell col="26" displaytype="number" text="expr:getSum('p_day24')"/>
  290. <Cell col="27" displaytype="number" text="expr:getSum('p_day25')"/>
  291. <Cell col="28" displaytype="number" text="expr:getSum('p_day26')"/>
  292. <Cell col="29" displaytype="number" text="expr:getSum('p_day27')"/>
  293. <Cell col="30" displaytype="number" text="expr:getSum('p_day28')"/>
  294. <Cell col="31" displaytype="number" text="expr:getSum('p_day29')"/>
  295. <Cell col="32" displaytype="number" text="expr:getSum('p_day30')"/>
  296. <Cell col="33" displaytype="number" text="expr:getSum('p_day31')"/>
  297. <Cell col="34" displaytype="number" text="expr:getSum('p_daysum')"/>
  298. </Band>
  299. </Format>
  300. </Formats>
  301. </Grid>
  302. <Button id="btn_excsave" taborder="3" text="엑셀저장" onclick="btn_excsave_onclick" class="btn7" position="absolute 1119 67 1195 89" anchor="top right"/>
  303. </Layout>
  304. </Layouts>
  305. <Objects>
  306. <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  307. <ColumnInfo>
  308. <Column id="testnm" type="STRING" size="256"/>
  309. <Column id="testroom" type="STRING" size="256"/>
  310. <Column id="p_day01" type="STRING" size="256"/>
  311. <Column id="p_day02" type="STRING" size="256"/>
  312. <Column id="p_day03" type="STRING" size="256"/>
  313. <Column id="p_day04" type="STRING" size="256"/>
  314. <Column id="p_day05" type="STRING" size="256"/>
  315. <Column id="p_day06" type="STRING" size="256"/>
  316. <Column id="p_day07" type="STRING" size="256"/>
  317. <Column id="p_day08" type="STRING" size="256"/>
  318. <Column id="p_day09" type="STRING" size="256"/>
  319. <Column id="p_day10" type="STRING" size="256"/>
  320. <Column id="p_day11" type="STRING" size="256"/>
  321. <Column id="p_day12" type="STRING" size="256"/>
  322. <Column id="p_day13" type="STRING" size="256"/>
  323. <Column id="p_day14" type="STRING" size="256"/>
  324. <Column id="p_day15" type="STRING" size="256"/>
  325. <Column id="p_day16" type="STRING" size="256"/>
  326. <Column id="p_day17" type="STRING" size="256"/>
  327. <Column id="p_day18" type="STRING" size="256"/>
  328. <Column id="p_day19" type="STRING" size="256"/>
  329. <Column id="p_day20" type="STRING" size="256"/>
  330. <Column id="p_day21" type="STRING" size="256"/>
  331. <Column id="p_day22" type="STRING" size="256"/>
  332. <Column id="p_day23" type="STRING" size="256"/>
  333. <Column id="p_day24" type="STRING" size="256"/>
  334. <Column id="p_day25" type="STRING" size="256"/>
  335. <Column id="p_day26" type="STRING" size="256"/>
  336. <Column id="p_day27" type="STRING" size="256"/>
  337. <Column id="p_day28" type="STRING" size="256"/>
  338. <Column id="p_day29" type="STRING" size="256"/>
  339. <Column id="p_day30" type="STRING" size="256"/>
  340. <Column id="p_day31" type="STRING" size="256"/>
  341. <Column id="p_daysum" type="STRING" size="256"/>
  342. </ColumnInfo>
  343. <Rows>
  344. <Row>
  345. <Col id="testnm"/>
  346. <Col id="testroom"/>
  347. <Col id="p_day01"/>
  348. <Col id="p_day02"/>
  349. <Col id="p_day03"/>
  350. <Col id="p_day04"/>
  351. <Col id="p_day05"/>
  352. <Col id="p_day06"/>
  353. <Col id="p_day07"/>
  354. <Col id="p_day08"/>
  355. <Col id="p_day09"/>
  356. <Col id="p_day10"/>
  357. <Col id="p_day11"/>
  358. <Col id="p_day12"/>
  359. <Col id="p_day13"/>
  360. <Col id="p_day14"/>
  361. <Col id="p_day15"/>
  362. <Col id="p_day16"/>
  363. <Col id="p_day17"/>
  364. <Col id="p_day18"/>
  365. <Col id="p_day19"/>
  366. <Col id="p_day20"/>
  367. <Col id="p_day21"/>
  368. <Col id="p_day22"/>
  369. <Col id="p_day23"/>
  370. <Col id="p_day24"/>
  371. <Col id="p_day25"/>
  372. <Col id="p_day26"/>
  373. <Col id="p_day27"/>
  374. <Col id="p_day28"/>
  375. <Col id="p_day29"/>
  376. <Col id="p_day30"/>
  377. <Col id="p_day31"/>
  378. <Col id="p_daysum"/>
  379. </Row>
  380. </Rows>
  381. </Dataset>
  382. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  383. <ColumnInfo>
  384. <Column id="srchdate" type="STRING" size="256"/>
  385. <Column id="suppdeptcd" type="STRING" size="256"/>
  386. <Column id="execfromdd" type="STRING" size="256"/>
  387. <Column id="execfromyy" type="STRING" size="256"/>
  388. <Column id="srchyy" type="STRING" size="256"/>
  389. <Column id="srchmm" type="STRING" size="256"/>
  390. </ColumnInfo>
  391. <Rows>
  392. <Row>
  393. <Col id="srchdate"/>
  394. </Row>
  395. </Rows>
  396. </Dataset>
  397. <Dataset id="ds_send_globalinstance" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  398. <ColumnInfo>
  399. <Column id="instance1" type="STRING" size="256"/>
  400. </ColumnInfo>
  401. <Rows>
  402. <Row>
  403. <Col id="instance1"/>
  404. </Row>
  405. </Rows>
  406. </Dataset>
  407. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  408. <ColumnInfo>
  409. <Column id="hidden" type="STRING" size="256"/>
  410. </ColumnInfo>
  411. </Dataset>
  412. <Dataset id="ds_init_com_srchdate_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  413. <ColumnInfo>
  414. <Column id="value" type="STRING" size="256"/>
  415. <Column id="label" type="STRING" size="256"/>
  416. </ColumnInfo>
  417. </Dataset>
  418. </Objects>
  419. <Bind>
  420. <BindItem id="item0" compid="grp_sea.cmb_srchdd" propid="value" datasetid="ds_send" columnid="srchyy"/>
  421. <BindItem id="item1" compid="grp_sea.cmb_srchmm" propid="value" datasetid="ds_send" columnid="srchmm"/>
  422. </Bind>
  423. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  424. * System Name :
  425. * Job Name :
  426. * Creator :
  427. * Make Date : 2017-12-04
  428. * Description :
  429. *---------------------------------------------------------------------------------------
  430. * Modify Date Modifier Modify Description
  431. *---------------------------------------------------------------------------------------
  432. * 2017-06-19 Live Converter TF->XP
  433. *
  434. *---------------------------------------------------------------------------------------
  435. ****************************************************************************************/
  436. //=======================================================================================
  437. // Lib Include
  438. //---------------------------------------------------------------------------------------
  439. include "com_commonxp::comm_main.xjs";
  440. include "ast_examcurexp::AEZ0001.xjs";
  441. //=======================================================================================
  442. // Global Form Variable
  443. //---------------------------------------------------------------------------------------
  444. var arErrorCode = new HashArray();
  445. //=======================================================================================
  446. // Function
  447. //---------------------------------------------------------------------------------------
  448. /*-**************************************************************************************
  449. * Argument : N/A
  450. * Description : 캡션 요일 설정
  451. ****************************************************************************************/
  452. function fSetDay() {
  453. var toyy = ds_send.getColumn(0, "srchyy");
  454. var tomm = ds_send.getColumn(0, "srchmm");
  455. var sToDate = toyy + tomm + "01";
  456. var m = sToDate.toDate().getMonth();
  457. setWeek(toyy, m);
  458. }
  459. function setWeek(toyy, m) {
  460. var str = "일,월,화,수,목,금,토";
  461. var endM = new Array(31,28,31,30,31,30,31,31,30,31,30,31);
  462. var days = new Array("일","월","화","수","목","금","토");
  463. var week = str.split(",");
  464. var setCap = "";
  465. var cnt = timeCalculate(toyy, m);
  466. for(var i=1; i<=31; i++) {
  467. setCap = setCap+"^"+days[cnt];
  468. cnt++;
  469. if(cnt > 6) {
  470. cnt = 0;
  471. }
  472. }
  473. setCapArr = setCap.split("^");
  474. for(var i = 69 ; i <= 99 ; i++) {
  475. grd_list.setCellProperty("Head", i, "text", setCapArr[i-68]);
  476. }
  477. if(endM[m] > 30) {
  478. grdf_colHidden(grd_list, "p_day29,p_day30,p_day31", "N,N,N");
  479. }else if(endM[m] < 30) {
  480. grdf_colHidden(grd_list, "p_day29,p_day30,p_day31", "Y,Y,Y");
  481. }else {
  482. grdf_colHidden(grd_list, "p_day29,p_day30,p_day31", "N,N,Y");
  483. }
  484. }
  485. function timeCalculate(toyy, m) {
  486. var c = new Date(toyy,m,"1");
  487. var weeknm = c.getDay();
  488. var dayOfWeek = parseInt(weeknm)-2;
  489. return weeknm;
  490. }
  491. /*-**************************************************************************************
  492. * Argument : N/A
  493. * Description : 조회기간 년도 설정
  494. ****************************************************************************************/
  495. function mkDate(){
  496. var startyy = "";
  497. for(var i=8; 0 <= i; i--) {
  498. startyy = utlf_getCurrentDate().toDate().getAddDate(-i,"Y").getDateFormat().substr(0,4);
  499. frmf_addComboItem("grp_sea.cmb_srchdd",startyy +"년",startyy,"above");
  500. }
  501. grp_sea.cmb_srchdd.value = utlf_getCurrentDate().substr(0,4);
  502. grp_sea.cmb_srchmm.value = utlf_getCurrentDate().substr(4,2);
  503. }
  504. //=======================================================================================
  505. // Event
  506. //---------------------------------------------------------------------------------------
  507. /****************************************************************************************
  508. * Components : Form
  509. * Description : 화면 처음 초기화시 폼초기화
  510. ****************************************************************************************/
  511. function SMAES00600_onload(obj:Form, e:LoadEventInfo) {
  512. frmf_initForm(obj);
  513. //grdf_initGrid(grd_XXX);
  514. //grdf_setGridSort(grd_XXX);
  515. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  516. lf_aezfSetSuppDeptcd(); //AEZ0001.xjs
  517. ds_send_globalinstance.setColumn(0, "instance1", frmf_getParameter("AST_DEPTCD"));
  518. ds_main_list_item.clearData();
  519. ds_send.setColumn( 0, "suppdeptcd", ds_send_globalinstance.getColumn(0, "instance1"));
  520. mkDate();
  521. fSetDay();
  522. }
  523. /****************************************************************************************
  524. * Components : Button
  525. * Description : 조회
  526. ****************************************************************************************/
  527. function grp_sea_btn_sea_onclick(obj:Button, e:ClickEventInfo) {
  528. var srchyy = ds_send.getColumn(0, "srchyy");
  529. var srchmm = ds_send.getColumn(0, "srchmm");
  530. ds_send.setColumn( 0, "execfromdd", srchyy + srchmm);
  531. ds_main_list_item.clearData();
  532. var oParam = {};
  533. oParam.id = "TRAES00601";
  534. oParam.service = "examcurestatsapp.RsrvSysts";
  535. oParam.method = "reqGetRsrvSystsDDtList";
  536. oParam.inds = "req=ds_send";
  537. oParam.outds = "ds_main_list_item=item";
  538. oParam.async = false;
  539. oParam.callback = "cf_TRAES00601";
  540. tranf_submit(oParam);
  541. if (arErrorCode.pop("TRAES00601") > -1) {
  542. ds_main_list_item.keystring = "S:testnm";
  543. }
  544. }
  545. function cf_TRAES00601(sSvcId, nErrorCode, sErrorMsg) {
  546. arErrorCode.push(sSvcId, nErrorCode);
  547. }
  548. /****************************************************************************************
  549. * Components : Combo
  550. * Description : 년월변경
  551. ****************************************************************************************/
  552. function grp_sea_cmb_srchdd_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  553. fSetDay();
  554. }
  555. function grp_sea_cmb_srchmm_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  556. fSetDay();
  557. }
  558. /****************************************************************************************
  559. * Components : Button
  560. * Description : 엑셀저장
  561. ****************************************************************************************/
  562. function btn_excsave_onclick(obj:Button, e:ClickEventInfo) {
  563. if( ds_main_list_item.rowcount > 0 ){
  564. grdf_exportExcel(grd_list, "Excel", "Sheet1", false, "", "user", false);
  565. } else {
  566. sysf_messageBox("조회된 데이터가 ", "I004");
  567. }
  568. }
  569. ]]></Script>
  570. </Form>
  571. </FDL>