SMRAD00500_일월계표.xfdl 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRAD00500" position="absolute 0 0 1201 801" titletext="일/월계표" oninit="SMRAD00500_oninit" onload="SMRAD00500_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 40 1195 790" id="group3" scrollbars="autoboth">
  8. <Layouts>
  9. <Layout>
  10. <Div position="absolute 0 10 1195 45" align="align:center top;" id="grp_sea" class="div_SA" anchor="default">
  11. <Layouts>
  12. <Layout>
  13. <Button position="absolute 1123 8 1179 30" align="align:left middle;" id="btn_search" class="btn1" taborder="4" text="조회" anchor="default" onclick="group3_grp_sea_btn_search_onclick"/>
  14. <Shape position="absolute 1104 8 1110 30" linetype="vertical" id="line5" class="line_4" anchor="default"/>
  15. <Static text="출력구분 :" position="absolute 354 10 450 27" id="caption1" class="search_name" anchor="default"/>
  16. <Radio position="absolute 915 8 1090 28" align="align:center middle;" id="rdo_acntclsflag" class="radio_search" columncount="-1" innerdataset="@ds_init_acntclsflag" datacolumn="nm" codecolumn="cd" anchor="default" rowcount="-1"/>
  17. <Static text="구 분 :" position="absolute 825 9 911 26" id="cap_8" class="search_name" anchor="default"/>
  18. <Radio position="absolute 450 8 625 28" align="align:center middle;" id="rdo_prntflag" class="radio_search" columncount="-1" innerdataset="@ds_init_prntflag" datacolumn="nm" codecolumn="cd" anchor="default" rowcount="-1"/>
  19. </Layout>
  20. </Layouts>
  21. </Div>
  22. <Tabpage text="" id="case2">
  23. <Layouts>
  24. <Layout>
  25. <Static text="caption2" position="absolute 130 95 230 115" align="align:center middle;" id="caption2" anchor="default"/>
  26. </Layout>
  27. </Layouts>
  28. </Tabpage>
  29. <Tab position="absolute 0 49 1195 750" id="sw_grid" class="sw_box" anchor="default" onchanged="group3_sw_grid_onchanged">
  30. <Tabpages>
  31. <Tabpage text="일계표" id="case_dayrept">
  32. <Layouts>
  33. <Layout>
  34. <Static text="일계표" position="absolute 1 9 132 27" id="caption21" class="tit_2" anchor="default"/>
  35. <Grid position="absolute 0 30 1193 667" id="grd_dayrept" binddataset="ds_main_day_dayrept" anchor="default">
  36. <Formats>
  37. <Format id="default">
  38. <Columns>
  39. <Column size="24"/>
  40. <Column size="147"/>
  41. <Column size="147"/>
  42. <Column size="147"/>
  43. <Column size="260"/>
  44. <Column size="147"/>
  45. <Column size="147"/>
  46. <Column size="147"/>
  47. <Column size="0"/>
  48. <Column size="0"/>
  49. <Column size="0"/>
  50. </Columns>
  51. <Rows>
  52. <Row size="24" band="head"/>
  53. <Row size="24" band="head"/>
  54. <Row size="24"/>
  55. </Rows>
  56. <Band id="head">
  57. <Cell rowspan="2" taborder="undefined"/>
  58. <Cell col="1" colspan="3" text="차변" taborder="undefined"/>
  59. <Cell col="4" rowspan="2" text="계정과목" taborder="undefined"/>
  60. <Cell col="5" colspan="3" text="대변" taborder="undefined"/>
  61. <Cell col="8"/>
  62. <Cell col="9"/>
  63. <Cell col="10"/>
  64. <Cell row="1" col="1" text="계"/>
  65. <Cell row="1" col="2" text="대체"/>
  66. <Cell row="1" col="3" text="현금"/>
  67. <Cell row="1" col="5" text="현금"/>
  68. <Cell row="1" col="6" text="대체"/>
  69. <Cell row="1" col="7" text="계"/>
  70. <Cell row="1" col="8"/>
  71. <Cell row="1" col="9"/>
  72. <Cell row="1" col="10"/>
  73. </Band>
  74. <Band id="body">
  75. <Cell celltype="head" expr="expr:currow + 1"/>
  76. <Cell col="1" displaytype="number" text="bind:dtotal"/>
  77. <Cell col="2" displaytype="number" text="bind:rdramt"/>
  78. <Cell col="3" displaytype="number" text="bind:cdramt"/>
  79. <Cell col="4" text="bind:abbrnm"/>
  80. <Cell col="5" displaytype="number" text="bind:ccramt"/>
  81. <Cell col="6" displaytype="number" text="bind:rcramt"/>
  82. <Cell col="7" displaytype="number" text="bind:ctotal"/>
  83. <Cell col="8" text="bind:upaccd"/>
  84. <Cell col="9" text="bind:acntgb"/>
  85. <Cell col="10" text="bind:sumgbn"/>
  86. </Band>
  87. </Format>
  88. </Formats>
  89. </Grid>
  90. <Shape position="absolute 0 25 1193 31" linetype="horizontal" id="line3" class="line_10" anchor="default"/>
  91. <Button position="absolute 1127 4 1191 23" align="align:left middle;" id="btn_excel" class="btn2" text="엑셀출력" anchor="default" onclick="group3_sw_grid_case_dayrept_btn_excel_onclick"/>
  92. </Layout>
  93. </Layouts>
  94. </Tabpage>
  95. <Tabpage text="월계표" id="case_monthrept">
  96. <Layouts>
  97. <Layout>
  98. <Static text="월계표" position="absolute 5 10 136 24" id="caption8" class="tit_2" anchor="default"/>
  99. <Grid position="absolute 0 30 1193 667" id="grd_monthrept" binddataset="ds_main_month_monthrept" anchor="default">
  100. <Formats>
  101. <Format id="default">
  102. <Columns>
  103. <Column size="24"/>
  104. <Column size="147"/>
  105. <Column size="147"/>
  106. <Column size="147"/>
  107. <Column size="260"/>
  108. <Column size="147"/>
  109. <Column size="147"/>
  110. <Column size="147"/>
  111. <Column size="0"/>
  112. <Column size="0"/>
  113. <Column size="0"/>
  114. </Columns>
  115. <Rows>
  116. <Row size="24" band="head"/>
  117. <Row size="24" band="head"/>
  118. <Row size="24"/>
  119. </Rows>
  120. <Band id="head">
  121. <Cell rowspan="2" taborder="undefined"/>
  122. <Cell col="1" colspan="3" text="차변" taborder="undefined"/>
  123. <Cell col="4" rowspan="2" text="계정과목" taborder="undefined"/>
  124. <Cell col="5" colspan="3" text="대변" taborder="undefined"/>
  125. <Cell col="8"/>
  126. <Cell col="9"/>
  127. <Cell col="10"/>
  128. <Cell row="1" col="1" text="계"/>
  129. <Cell row="1" col="2" text="대체"/>
  130. <Cell row="1" col="3" text="현금"/>
  131. <Cell row="1" col="5" text="현금"/>
  132. <Cell row="1" col="6" text="대체"/>
  133. <Cell row="1" col="7" text="계"/>
  134. <Cell row="1" col="8"/>
  135. <Cell row="1" col="9"/>
  136. <Cell row="1" col="10"/>
  137. </Band>
  138. <Band id="body">
  139. <Cell celltype="head" expr="expr:currow + 1"/>
  140. <Cell col="1" displaytype="number" text="bind:dtotal"/>
  141. <Cell col="2" displaytype="number" text="bind:rdramt"/>
  142. <Cell col="3" displaytype="number" text="bind:cdramt"/>
  143. <Cell col="4" style="align:left middle;padding:1 2 1 2;" text="bind:abbrnm"/>
  144. <Cell col="5" displaytype="number" text="bind:ccramt"/>
  145. <Cell col="6" displaytype="number" text="bind:rcramt"/>
  146. <Cell col="7" displaytype="number" text="bind:ctotal"/>
  147. <Cell col="8" text="bind:upaccd"/>
  148. <Cell col="9" text="bind:acntgb"/>
  149. <Cell col="10" text="bind:sumgbn"/>
  150. </Band>
  151. </Format>
  152. </Formats>
  153. </Grid>
  154. <Shape position="absolute 0 25 1193 31" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
  155. <Button position="absolute 1126 4 1190 23" align="align:left middle;" id="btn_excel2" class="btn2" text="엑셀출력" anchor="default" onclick="group3_sw_grid_case_monthrept_btn_excel2_onclick"/>
  156. </Layout>
  157. </Layouts>
  158. </Tabpage>
  159. </Tabpages>
  160. </Tab>
  161. </Layout>
  162. </Layouts>
  163. </Div>
  164. <Static id="caption6" text="일/월계표" class="tit_1" position="absolute 0 0 93 25"/>
  165. <Button id="btn_print" taborder="1" text="출력" class="btn6" position="absolute 0 26 56 48" onclick="btn_print_onclick"/>
  166. <Tab id="sw_params" taborder="2" tabindex="0" class="tab_Normal" position="absolute 4 41 325 87">
  167. <Tabpages>
  168. <Tabpage id="cs_dayrept">
  169. <Layouts>
  170. <Layout>
  171. <Static id="caption2" text="기 간 :" class="search_name" position="absolute 12 5 98 22"/>
  172. <Static id="caption3" text="~" position="absolute 203 6 218 26"/>
  173. <Calendar id="ipt_frdate1" taborder="1" class="input_essential" position="absolute 102 5 202 24"/>
  174. <Calendar id="ipt_todate1" taborder="2" class="input_essential" position="absolute 214 5 314 24"/>
  175. </Layout>
  176. </Layouts>
  177. </Tabpage>
  178. <Tabpage id="cs_monthrept">
  179. <Layouts>
  180. <Layout>
  181. <Static id="caption5" text="기 간 :" class="search_name" position="absolute 12 5 98 22"/>
  182. <Static id="caption7" text="~" position="absolute 203 6 218 26"/>
  183. <Calendar id="ipt_frdate2" taborder="1" class="input_essential" position="absolute 102 5 202 24" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  184. <Calendar id="ipt_todate2" taborder="2" class="input_essential" position="absolute 214 5 314 24" mask="yyyy-mm" dateformat="yyyy-MM" editformat="yyyy-MM"/>
  185. </Layout>
  186. </Layouts>
  187. </Tabpage>
  188. </Tabpages>
  189. </Tab>
  190. </Layout>
  191. </Layouts>
  192. <Objects>
  193. <Dataset id="ds_main_month" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  194. <ColumnInfo>
  195. <Column id="monthrept" type="STRING" size="256"/>
  196. </ColumnInfo>
  197. <Rows>
  198. <Row>
  199. <Col id="monthrept"/>
  200. </Row>
  201. </Rows>
  202. </Dataset>
  203. <Dataset id="ds_main_date_daydate" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  204. <ColumnInfo>
  205. <Column id="frdate" type="STRING" size="256"/>
  206. <Column id="todate" type="STRING" size="256"/>
  207. </ColumnInfo>
  208. <Rows>
  209. <Row>
  210. <Col id="frdate"/>
  211. <Col id="todate"/>
  212. </Row>
  213. </Rows>
  214. </Dataset>
  215. <Dataset id="ds_main_date_month" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  216. <ColumnInfo>
  217. <Column id="frdate" type="STRING" size="256"/>
  218. <Column id="todate" type="STRING" size="256"/>
  219. </ColumnInfo>
  220. <Rows>
  221. <Row>
  222. <Col id="frdate"/>
  223. <Col id="todate"/>
  224. </Row>
  225. </Rows>
  226. </Dataset>
  227. <Dataset id="ds_main_apln" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  228. <ColumnInfo>
  229. <Column id="approval11" type="STRING" size="256"/>
  230. <Column id="approval12" type="STRING" size="256"/>
  231. <Column id="approval13" type="STRING" size="256"/>
  232. <Column id="approval14" type="STRING" size="256"/>
  233. <Column id="approval15" type="STRING" size="256"/>
  234. <Column id="approval16" type="STRING" size="256"/>
  235. <Column id="approval21" type="STRING" size="256"/>
  236. <Column id="approval22" type="STRING" size="256"/>
  237. <Column id="approval23" type="STRING" size="256"/>
  238. <Column id="approval24" type="STRING" size="256"/>
  239. <Column id="approval25" type="STRING" size="256"/>
  240. <Column id="approval26" type="STRING" size="256"/>
  241. <Column id="arbitrary1" type="STRING" size="256"/>
  242. <Column id="arbitrary2" type="STRING" size="256"/>
  243. <Column id="arbitrary3" type="STRING" size="256"/>
  244. <Column id="arbitrary4" type="STRING" size="256"/>
  245. <Column id="arbitrary5" type="STRING" size="256"/>
  246. <Column id="arbitrary6" type="STRING" size="256"/>
  247. <Column id="iudflag" type="STRING" size="256"/>
  248. <Column id="instcd" type="STRING" size="256"/>
  249. <Column id="deptcd" type="STRING" size="256"/>
  250. <Column id="expansion" type="STRING" size="256"/>
  251. </ColumnInfo>
  252. <Rows>
  253. <Row>
  254. <Col id="approval11"/>
  255. <Col id="approval12"/>
  256. <Col id="approval13"/>
  257. <Col id="approval14"/>
  258. <Col id="approval15"/>
  259. <Col id="approval16"/>
  260. <Col id="approval21"/>
  261. <Col id="approval22"/>
  262. <Col id="approval23"/>
  263. <Col id="approval24"/>
  264. <Col id="approval25"/>
  265. <Col id="approval26"/>
  266. <Col id="arbitrary1"/>
  267. <Col id="arbitrary2"/>
  268. <Col id="arbitrary3"/>
  269. <Col id="arbitrary4"/>
  270. <Col id="arbitrary5"/>
  271. <Col id="arbitrary6"/>
  272. <Col id="iudflag"/>
  273. <Col id="instcd"/>
  274. <Col id="deptcd"/>
  275. <Col id="expansion"/>
  276. </Row>
  277. </Rows>
  278. </Dataset>
  279. <Dataset id="ds_send_params" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  280. <ColumnInfo>
  281. <Column id="frdate" type="STRING" size="256"/>
  282. <Column id="todate" type="STRING" size="256"/>
  283. <Column id="prntflag" type="STRING" size="256"/>
  284. <Column id="cashacntcd" type="STRING" size="256"/>
  285. <Column id="acntclsflag" type="STRING" size="256"/>
  286. <Column id="termflag" type="STRING" size="256"/>
  287. </ColumnInfo>
  288. <Rows>
  289. <Row>
  290. <Col id="frdate"/>
  291. <Col id="todate"/>
  292. <Col id="prntflag"/>
  293. <Col id="cashacntcd"/>
  294. <Col id="acntclsflag"/>
  295. <Col id="termflag">day</Col>
  296. </Row>
  297. </Rows>
  298. </Dataset>
  299. <Dataset id="ds_send_retrmngt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  300. <ColumnInfo>
  301. <Column id="mngtcd" type="STRING" size="256"/>
  302. <Column id="instcd" type="STRING" size="256"/>
  303. </ColumnInfo>
  304. <Rows>
  305. <Row>
  306. <Col id="mngtcd">cashcd</Col>
  307. <Col id="instcd"/>
  308. </Row>
  309. </Rows>
  310. </Dataset>
  311. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  312. <ColumnInfo>
  313. <Column id="test" type="STRING" size="256"/>
  314. </ColumnInfo>
  315. <Rows>
  316. <Row>
  317. <Col id="test"/>
  318. </Row>
  319. </Rows>
  320. </Dataset>
  321. <Dataset id="ds_send_retrparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  322. <ColumnInfo>
  323. <Column id="instnm" type="STRING" size="256"/>
  324. <Column id="selectedIndex" type="STRING" size="256"/>
  325. <Column id="frdate" type="STRING" size="256"/>
  326. <Column id="todate" type="STRING" size="256"/>
  327. <Column id="usernm" type="STRING" size="256"/>
  328. <Column id="approval21" type="STRING" size="256"/>
  329. <Column id="approval22" type="STRING" size="256"/>
  330. <Column id="approval23" type="STRING" size="256"/>
  331. <Column id="approval24" type="STRING" size="256"/>
  332. <Column id="approval25" type="STRING" size="256"/>
  333. <Column id="approval26" type="STRING" size="256"/>
  334. <Column id="arbitrary1" type="STRING" size="256"/>
  335. <Column id="arbitrary2" type="STRING" size="256"/>
  336. <Column id="arbitrary3" type="STRING" size="256"/>
  337. <Column id="arbitrary4" type="STRING" size="256"/>
  338. <Column id="arbitrary5" type="STRING" size="256"/>
  339. <Column id="arbitrary6" type="STRING" size="256"/>
  340. <Column id="expansion" type="STRING" size="256"/>
  341. </ColumnInfo>
  342. <Rows>
  343. <Row>
  344. <Col id="instnm"/>
  345. <Col id="selectedIndex"/>
  346. <Col id="frdate"/>
  347. <Col id="todate"/>
  348. <Col id="usernm"/>
  349. <Col id="approval21"/>
  350. <Col id="approval22"/>
  351. <Col id="approval23"/>
  352. <Col id="approval24"/>
  353. <Col id="approval25"/>
  354. <Col id="approval26"/>
  355. <Col id="arbitrary1"/>
  356. <Col id="arbitrary2"/>
  357. <Col id="arbitrary3"/>
  358. <Col id="arbitrary4"/>
  359. <Col id="arbitrary5"/>
  360. <Col id="arbitrary6"/>
  361. <Col id="expansion"/>
  362. </Row>
  363. </Rows>
  364. </Dataset>
  365. <Dataset id="ds_send_prntlist_gridlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  366. <Dataset id="ds_send_retrparam" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  367. <ColumnInfo>
  368. <Column id="instcd" type="STRING" size="256"/>
  369. <Column id="deptcd" type="STRING" size="256"/>
  370. <Column id="aplnflag" type="STRING" size="256"/>
  371. </ColumnInfo>
  372. <Rows>
  373. <Row>
  374. <Col id="instcd"/>
  375. <Col id="deptcd"/>
  376. <Col id="aplnflag">1</Col>
  377. </Row>
  378. </Rows>
  379. </Dataset>
  380. <Dataset id="ds_init_acntclsflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  381. <ColumnInfo>
  382. <Column id="cd" type="STRING" size="256"/>
  383. <Column id="nm" type="STRING" size="256"/>
  384. </ColumnInfo>
  385. <Rows>
  386. <Row>
  387. <Col id="cd">1</Col>
  388. <Col id="nm">목 단위</Col>
  389. </Row>
  390. <Row>
  391. <Col id="cd">0</Col>
  392. <Col id="nm">세목 단위</Col>
  393. </Row>
  394. </Rows>
  395. </Dataset>
  396. <Dataset id="ds_code_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  397. <Dataset id="ds_main_day_dayrept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  398. <Dataset id="ds_main_month_monthrept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  399. <Dataset id="ds_init_prntflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  400. <ColumnInfo>
  401. <Column id="cd" type="STRING" size="256"/>
  402. <Column id="nm" type="STRING" size="256"/>
  403. </ColumnInfo>
  404. <Rows>
  405. <Row>
  406. <Col id="cd">Y</Col>
  407. <Col id="nm">전체</Col>
  408. </Row>
  409. <Row>
  410. <Col id="cd">N</Col>
  411. <Col id="nm">지정</Col>
  412. </Row>
  413. </Rows>
  414. </Dataset>
  415. </Objects>
  416. <Bind>
  417. <BindItem id="item0" compid="sw_params.cs_monthrept.ipt_frdate2" propid="value" datasetid="ds_main_date_month" columnid="frdate"/>
  418. <BindItem id="item1" compid="sw_params.cs_monthrept.ipt_todate2" propid="value" datasetid="ds_main_date_month" columnid="todate"/>
  419. <BindItem id="item2" compid="sw_params.cs_dayrept.ipt_frdate1" propid="value" datasetid="ds_main_date_daydate" columnid="frdate"/>
  420. <BindItem id="item3" compid="sw_params.cs_dayrept.ipt_todate1" propid="value" datasetid="ds_main_date_daydate" columnid="todate"/>
  421. <BindItem id="item4" compid="group3.grp_sea.rdo_prntflag" propid="value" datasetid="ds_send_params" columnid="prntflag"/>
  422. <BindItem id="item5" compid="group3.grp_sea.rdo_acntclsflag" propid="value" datasetid="ds_send_params" columnid="acntclsflag"/>
  423. </Bind>
  424. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  425. * System Name :
  426. * Job Name :
  427. * Creator :
  428. * Make Date : 2017-06-19
  429. * Description :
  430. *---------------------------------------------------------------------------------------
  431. * Modify Date Modifier Modify Description
  432. *---------------------------------------------------------------------------------------
  433. * 2017-06-19 Live Converter TF->XP
  434. *
  435. *---------------------------------------------------------------------------------------
  436. ****************************************************************************************/
  437. include "com_commonxp::comm_main.xjs";
  438. include "mis_miscommonxp::MIS.xjs";
  439. include "mis_miscommonxp::PIC002.xjs";
  440. include "mis_miscommonxp::RAC001.xjs";
  441. include "mis_miscommonxp::RBC001.xjs";
  442. include "mis_miscommonxp::RSZ001.xjs";
  443. include "mis_acntcommonxp::RAD001.xjs";
  444. var arErrorCode = new HashArray();
  445. function SMRAD00500_oninit(obj:Form, e:InitEventInfo)
  446. {
  447. frmf_initForm(obj); //폼 초기화
  448. }
  449. function SMRAD00500_onload(obj:Form, e:LoadEventInfo)
  450. {
  451. ds_send_retrmngt.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  452. ds_main_day_dayrept.clearData();
  453. ds_main_month_monthrept.clearData();
  454. fSetDayMonthDate();
  455. group3.grp_sea.rdo_acntclsflag.value = '0';
  456. group3.grp_sea.rdo_prntflag.value = 'Y';
  457. //submit("TRRAZ00001");
  458. var oParam = {};
  459. oParam.id = "TRRAZ00001";
  460. oParam.service = "acntcommonapp.AcntCommon";
  461. oParam.method = "reqGetAcntMngtCodeList";
  462. oParam.inds = "req=ds_send_retrmngt";
  463. oParam.outds = "ds_code_codelist=codelist";
  464. oParam.async = false;
  465. tranf_submit(oParam);
  466. ds_send_params.setColumn(0, "cashacntcd", ds_code_codelist.getColumn(0, "cdid"));
  467. group3.sw_grid.tabindex = 0;
  468. group3_sw_grid_onchanged();
  469. //misfMsterDetailSet(grd_dayrept, null, "TRRAD00501", "N");
  470. ds_send_retrmngt.setColumn(0, "usernm", sysf_getUserInfo("usernm"));
  471. ds_send_retrmngt.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  472. ds_send_retrmngt.setColumn(0, "deptcd", sysf_getUserInfo("dutplcecd"));
  473. //submit("TRRAD00151");
  474. dsf_setDefaultVal(ds_send_retrmngt, "aplnflag:1");
  475. var oParam = {};
  476. oParam.id = "TRRAD00151";
  477. oParam.service = "slipapp.Slip";
  478. oParam.method = "reqGetAplnByDeptcd";
  479. oParam.inds = "req=ds_send_retrmngt";
  480. oParam.outds = "ds_main_apln=apln";
  481. oParam.async = false;
  482. tranf_submit(oParam);
  483. ds_send_retrmngt.setColumn(0, "approval21", ds_main_apln.getColumn(0, "approval21"));
  484. ds_send_retrmngt.setColumn(0, "approval22", ds_main_apln.getColumn(0, "approval22"));
  485. ds_send_retrmngt.setColumn(0, "approval23", ds_main_apln.getColumn(0, "approval23"));
  486. ds_send_retrmngt.setColumn(0, "approval24", ds_main_apln.getColumn(0, "approval24"));
  487. ds_send_retrmngt.setColumn(0, "approval25", ds_main_apln.getColumn(0, "approval25"));
  488. ds_send_retrmngt.setColumn(0, "approval26", ds_main_apln.getColumn(0, "approval26"));
  489. ds_send_retrmngt.setColumn(0, "arbitrary1", ds_main_apln.getColumn(0, "arbitrary1"));
  490. ds_send_retrmngt.setColumn(0, "arbitrary2", ds_main_apln.getColumn(0, "arbitrary2"));
  491. ds_send_retrmngt.setColumn(0, "arbitrary3", ds_main_apln.getColumn(0, "arbitrary3"));
  492. ds_send_retrmngt.setColumn(0, "arbitrary4", ds_main_apln.getColumn(0, "arbitrary4"));
  493. ds_send_retrmngt.setColumn(0, "arbitrary5", ds_main_apln.getColumn(0, "arbitrary5"));
  494. ds_send_retrmngt.setColumn(0, "arbitrary6", ds_main_apln.getColumn(0, "arbitrary6"));
  495. var expansion = radfCheckInstMngt(sysf_getUserInfo("dutplceinstcd"), 'condition3');
  496. ds_send_retrmngt.setColumn(0, "expansion", expansion);
  497. }
  498. function fSetDayMonthDate()
  499. {
  500. sw_params.cs_dayrept.ipt_frdate1.value = utlf_getCurrentDate();
  501. sw_params.cs_dayrept.ipt_todate1.value = utlf_getCurrentDate();
  502. sw_params.cs_monthrept.ipt_frdate2.value = utlf_getCurrentDate().substr(0, 6);
  503. sw_params.cs_monthrept.ipt_todate2.value = utlf_getCurrentDate().substr(0, 6);
  504. }
  505. function group3_sw_grid_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
  506. {
  507. if(group3.sw_grid.tabindex == 0){
  508. sw_params.tabindex = 0;
  509. ds_send_params.setColumn(0, "termflag", "day");
  510. }else if(group3.sw_grid.tabindex == 1){
  511. sw_params.tabindex = 1;
  512. ds_send_params.setColumn(0, "termflag", "month");
  513. }
  514. }
  515. function group3_grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
  516. {
  517. fSetDayMonthReptParams();
  518. if(group3.sw_grid.tabindex == 0)
  519. {
  520. //submit("TRRAD00501");
  521. var oParam = {};
  522. oParam.id = "TRRAD00501";
  523. oParam.service = "slipapp.AccBook";
  524. oParam.method = "reqGetDayRept";
  525. oParam.inds = "req=ds_send_params";
  526. oParam.outds = "ds_main_day_dayrept=dayrept";
  527. oParam.async = false;
  528. tranf_submit(oParam);
  529. }
  530. else if(group3.sw_grid.tabindex == 1)
  531. {
  532. //submit("TRRAD00502");
  533. var oParam = {};
  534. oParam.id = "TRRAD00501";
  535. oParam.service = "slipapp.AccBook";
  536. oParam.method = "reqGetMonthRept";
  537. oParam.inds = "req=ds_send_params";
  538. oParam.outds = "ds_main_month_monthrept=monthrept";
  539. oParam.async = false;
  540. tranf_submit(oParam);
  541. }
  542. }
  543. function fSetDayMonthReptParams()
  544. {
  545. if(group3.sw_grid.tabindex == 0)
  546. {
  547. if(utlf_isNull(sw_params.cs_dayrept.ipt_todate1.value))
  548. {
  549. sw_params.cs_dayrept.ipt_todate1.value = sw_params.cs_dayrept.ipt_frdate1.value;
  550. }
  551. ds_send_params.setColumn(0, "frdate", ds_main_date_daydate.getColumn(0, "frdate"));
  552. ds_send_params.setColumn(0, "todate", ds_main_date_daydate.getColumn(0, "todate"));
  553. }
  554. else if(group3.sw_grid.tabindex == 1)
  555. {
  556. if(utlf_isNull(sw_params.cs_monthrept.ipt_todate2.value))
  557. {
  558. sw_params.cs_monthrept.ipt_todate2.value = sw_params.cs_monthrept.ipt_frdate2.value;
  559. }
  560. var dt = new Date(utlf_transNullToEmpty(ds_main_date_month.getColumn(0, "todate")).substr(0, 4), utlf_transNullToEmpty(ds_main_date_month.getColumn(0, "todate")).substr(4, 2), 0);
  561. ds_send_params.setColumn(0, "frdate", ds_main_date_month.getColumn(0, "frdate").substr(0, 6) + "01");
  562. ds_send_params.setColumn(0, "todate", ds_main_date_month.getColumn(0, "todate").substr(0, 6) + dt.getDate());
  563. }
  564. }
  565. function group3_sw_grid_case_monthrept_btn_excel2_onclick(obj:Button, e:ClickEventInfo)
  566. {
  567. misfSaveExcel(group3.sw_grid.case_monthrept.grd_monthrept);
  568. }
  569. function group3_sw_grid_case_dayrept_btn_excel_onclick(obj:Button, e:ClickEventInfo)
  570. {
  571. misfSaveExcel(group3.sw_grid.case_dayrept.grd_dayrept);
  572. }
  573. function btn_print_onclick(obj:Button, e:ClickEventInfo)
  574. {
  575. if(sw_grid.selectedIndex == 0)
  576. {
  577. if(ds_main_day_dayrept.rowcount == 0)
  578. {
  579. sysf_messageBox("출력할 내용이" ,"I004");
  580. return;
  581. }
  582. ds_send_retrmngt.setColumn(0, "frdate", sw_params.cs_dayrept.ipt_frdate1.value);
  583. ds_send_retrmngt.setColumn(0, "todate", sw_params.cs_dayrept.ipt_todate1.value);
  584. ds_send_prntlist_gridlist.copyData(ds_main_day_dayrept);
  585. //ds_send_prntlist_gridlist.clearData();
  586. // for(var i = 0; i < ds_main_day_dayrept.rowcount; i++)
  587. // {
  588. // model.makeNode("/root/send/prntlist/gridlist[" + i + "]");
  589. // model.copyNode("/root/send/prntlist/gridlist[" + i + "]", "/root/main/day/dayrept[" + i + "]");
  590. // }
  591. }
  592. else
  593. {
  594. if(ds_main_month_monthrept.rowcount == 0)
  595. {
  596. sysf_messageBox("출력할 내용이" ,"I004");
  597. return;
  598. }
  599. ds_send_retrmngt.setColumn(0, "frdate", sw_params.cs_monthrept.ipt_frdate2.value);
  600. ds_send_retrmngt.setColumn(0, "todate", sw_params.cs_monthrept.ipt_todate2.value);
  601. ds_send_prntlist_gridlist.copyData(ds_main_month_monthrept);
  602. }
  603. ds_send_retrmngt.setColumn(0, "instnm", sysf_getUserInfo("dutplceinstnm"));
  604. ds_send_retrmngt.setColumn(0, "selectedIndex", group3.sw_grid.tabindex);
  605. var objDOM = rptf_createDOM();
  606. rptf_setNodeListToDOM(objDOM, "root/send/prntlist/gridlist", ds_send_prntlist_gridlist); // 데이터셋 1
  607. var objParam = new Object();
  608. objParam.xml_data_XML1 = objDOM.documentElement.source; // 최상의노드 XML 스트링 추출
  609. var option = "open=1;save=1;directprint=0;print=1;zoom=0;";
  610. rptf_exeReportPreview30(["RPRAD00501"],[objParam], option);
  611. ds_send_prntlist_gridlist.clearData();
  612. }
  613. ]]></Script>
  614. </Form>
  615. </FDL>