SMPAS00520_외래수입통계.xfdl 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml" />
  4. <Form id="SMPAS00520" position="absolute 0 0 1211 784" titletext="외래수입통계" onload="SMPAS00520_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div id="group3" position="absolute 0 0 1211 13" style="">
  8. <Layouts>
  9. <Layout>
  10. <Static id="caption60" class="tit_1" position="absolute 0 0 215 14" style="font:돋움,,돋움;align: middle;" text="외래수입통계" />
  11. </Layout>
  12. </Layouts>
  13. </Div>
  14. <Div id="group2" position="absolute 4 23 1207 58" style="">
  15. <Layouts>
  16. <Layout>
  17. <Shape id="roundrect1" anchor="default" class="roundrect_search" type="roundrectangle" position="absolute 0 0 1202 35" style="border: solid #ffd799 #ffd799;background:#fffbf2 ;" />
  18. <Static id="caption2" class="search_name" position="absolute 10 9 80 26" style="" text="일자:" />
  19. <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1132 7 1135 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default" />
  20. <Button id="btn_search" class="btn1_letter2" position="absolute 1139 7 1195 29" style="" text="조회" onclick="group2_btn_search_onclick" />
  21. <Calendar id="input7" class="input_default" taborder="7" position="absolute 75 8 160 27" style="align:center ;" anchor="default" />
  22. <Button id="button95" class="btn6_letter4" position="absolute 976 7 1056 29" style="" text="액셀저장" onclick="group2_button95_onclick" />
  23. <Shape id="line1" class="line_4" linetype="vertical" position="absolute 1063 7 1066 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default" />
  24. <Button id="btn_print" class="btn6_letter2" position="absolute 1070 7 1126 29" style="" text="출력" onclick="group2_btn_print_onclick" />
  25. <MaskEdit id="input1" mask="hh:nn" position="absolute 170 8 224 27" style="align:center ;" anchor="default" />
  26. <MaskEdit id="input15" mask="hh:nn" position="absolute 245 8 299 27" style="align:center ;" anchor="default" />
  27. <Static id="caption25" position="absolute 222 10 247 24" style="align:center ;" text="~" />
  28. <Edit id="input2" visible="false" position="absolute 384 8 470 27" style="" anchor="default" />
  29. <Static id="caption1" position="absolute 311 9 375 29" style="font:,,bold;" text="수납자ID :" />
  30. </Layout>
  31. </Layouts>
  32. </Div>
  33. <Div id="grp_btn" scrollbars="autoboth" position="absolute 19 757 1199 784" style="" />
  34. <Button id="btn_init" class="btn4_letter3" position="absolute 1129 760 1197 782" style="" text="초기화" onclick="btn_init_onclick" />
  35. <Tab id="switch1" position="absolute 5 87 1205 742" style="" anchor="default">
  36. <Tabpages>
  37. <Tabpage id="case1" anchor="default" text="1.전체 외래 수입통계">
  38. <Layouts>
  39. <Layout>
  40. <Grid id="grd_rcpt" binddataset="ds_main_h_rcpt_rcpt" position="absolute 5 5 1190 640" style="" oncelldblclick="switch1_case1_grd_rcpt_oncelldblclick">
  41. <Formats>
  42. <Format id="default">
  43. <Columns>
  44. <Column size="80" />
  45. <Column size="43" />
  46. <Column size="100" />
  47. <Column size="46" />
  48. <Column size="100" />
  49. <Column size="40" />
  50. <Column size="100" />
  51. <Column size="80" />
  52. <Column size="80" />
  53. <Column size="80" />
  54. <Column size="80" />
  55. <Column size="80" />
  56. <Column size="75" />
  57. <Column size="75" />
  58. <Column size="122" />
  59. </Columns>
  60. <Rows>
  61. <Row size="24" band="head" />
  62. <Row size="24" />
  63. </Rows>
  64. <Band id="head">
  65. <Cell text="수납자" />
  66. <Cell col="1" text="접수" />
  67. <Cell col="2" text="접수" />
  68. <Cell col="3" text="예약" />
  69. <Cell col="4" text="예약" />
  70. <Cell col="5" text="수납" />
  71. <Cell col="6" text="수납" />
  72. <Cell col="7" text="선수금" />
  73. <Cell col="8" text="선수금대체" />
  74. <Cell col="9" text="선수금반환" />
  75. <Cell col="10" text="미수금" />
  76. <Cell col="11" text="미수입금" />
  77. <Cell col="12" text="차상위" />
  78. <Cell col="13" text="희귀난치" />
  79. <Cell col="14" text="총계|수납자" />
  80. <Cell col="15" text="건수" />
  81. <Cell col="16" text="금액" />
  82. <Cell col="17" text="건수" />
  83. <Cell col="18" text="금액" />
  84. <Cell col="19" text="건수" />
  85. <Cell col="20" text="금액" />
  86. <Cell col="21" text="선수금" />
  87. <Cell col="22" text="선수금대체" />
  88. <Cell col="23" text="선수금반환" />
  89. <Cell col="24" text="미수금" />
  90. <Cell col="25" text="미수입금" />
  91. <Cell col="26" text="차상위" />
  92. <Cell col="27" text="희귀난치" />
  93. <Cell col="28" text="총계" />
  94. </Band>
  95. <Band id="body">
  96. <Cell text="bind:rcpt_rcptrnm" />
  97. <Cell col="1" text="bind:rcpt_ojamt_cnt" />
  98. <Cell col="2" text="bind:rcpt_ojamt" />
  99. <Cell col="3" text="bind:rcpt_rsrv_cnt" />
  100. <Cell col="4" text="bind:rcpt_rsrv" />
  101. <Cell col="5" text="bind:rcpt_rcptamt_cnt" />
  102. <Cell col="6" text="bind:rcpt_rcptamt" />
  103. <Cell col="7" text="bind:rcpt_bogjamt" />
  104. <Cell col="8" text="bind:rcpt_bogjaltamt" />
  105. <Cell col="9" text="bind:rcpt_bogjrtnamt" />
  106. <Cell col="10" text="bind:rcpt_unco" />
  107. <Cell col="11" text="bind:rcpt_uncr" />
  108. <Cell col="12" text="bind:rcpt_rareobstamt" />
  109. <Cell col="13" text="bind:rcpt_suppamt" />
  110. <Cell col="14" text="bind:rcpt_sum" />
  111. </Band>
  112. </Format>
  113. </Formats>
  114. </Grid>
  115. </Layout>
  116. </Layouts>
  117. </Tabpage>
  118. <Tabpage id="case2" selected="true" anchor="default" text="2.수납자별 외래 수입통계">
  119. <Layouts>
  120. <Layout>
  121. <Grid id="grd_rcpt1" binddataset="ds_main_h_rcpt2_rcpt2" position="absolute 5 7 295 648" style="" ontextchanged="switch1_case2_grd_rcpt1_ontextchanged" oncelldblclick="switch1_case2_grd_rcpt1_oncelldblclick">
  122. <Formats>
  123. <Format id="default">
  124. <Columns>
  125. <Column size="109" />
  126. <Column size="60" />
  127. <Column size="117" />
  128. </Columns>
  129. <Rows>
  130. <Row size="24" band="head" />
  131. <Row size="24" />
  132. </Rows>
  133. <Band id="head">
  134. <Cell text="항목" />
  135. <Cell col="1" text="건수" />
  136. <Cell col="2" text="금액" />
  137. </Band>
  138. <Band id="body">
  139. <Cell text="bind:col1" />
  140. <Cell col="1" text="bind:col2" />
  141. <Cell col="2" text="bind:col3" />
  142. </Band>
  143. </Format>
  144. </Formats>
  145. </Grid>
  146. </Layout>
  147. </Layouts>
  148. </Tabpage>
  149. <Tabpage id="case3" anchor="default" text="3.무인수납 사용 현황3" />
  150. </Tabpages>
  151. </Tab>
  152. <Button id="button3" class="btn_sw" enable="False" position="absolute 325 65 485 87" style="" text="3.무인수납 사용 현황3" onclick="button3_onclick" />
  153. <Button id="btn_rcptid" class="btn_sw" position="absolute 165 65 325 87" style="" text="2.수납자별 외래 수입통계" onclick="btn_rcptid_onclick" />
  154. <Button id="btn_all" class="btn_sw" position="absolute 5 65 165 87" style="" text="1.전체 외래 수입통계" onclick="btn_all_onclick" />
  155. </Layout>
  156. </Layouts>
  157. <Objects>
  158. <Dataset id="ds_main_h_rcpt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  159. <ColumnInfo />
  160. </Dataset>
  161. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  162. <ColumnInfo />
  163. </Dataset>
  164. <Dataset id="ds_main_h_rcpt2_rcpt2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  165. <ColumnInfo>
  166. <Column id="col1" type="STRING" size="256" />
  167. <Column id="col2" type="STRING" size="256" />
  168. <Column id="col3" type="STRING" size="256" />
  169. </ColumnInfo>
  170. <Rows>
  171. <Row>
  172. <Col id="col1"></Col>
  173. <Col id="col2"></Col>
  174. <Col id="col3"></Col>
  175. </Row>
  176. </Rows>
  177. </Dataset>
  178. <Dataset id="ds_main_h_rcpt2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  179. <ColumnInfo />
  180. </Dataset>
  181. <Dataset id="ds_main_h_rcpt_rcpt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  182. <ColumnInfo>
  183. <Column id="rcpt_rcptrid" type="STRING" size="256" />
  184. <Column id="rcpt_rcptrnm" type="STRING" size="256" />
  185. <Column id="rcpt_ojamt_cnt" type="STRING" size="256" />
  186. <Column id="rcpt_ojamt" type="STRING" size="256" />
  187. <Column id="rcpt_rsrv_cnt" type="STRING" size="256" />
  188. <Column id="rcpt_rsrv" type="STRING" size="256" />
  189. <Column id="rcpt_rcptamt_cnt" type="STRING" size="256" />
  190. <Column id="rcpt_rcptamt" type="STRING" size="256" />
  191. <Column id="rcpt_bogjamt" type="STRING" size="256" />
  192. <Column id="rcpt_bogjaltamt" type="STRING" size="256" />
  193. <Column id="rcpt_bogjrtnamt" type="STRING" size="256" />
  194. <Column id="rcpt_unco" type="STRING" size="256" />
  195. <Column id="rcpt_uncr" type="STRING" size="256" />
  196. <Column id="rcpt_rareobstamt" type="STRING" size="256" />
  197. <Column id="rcpt_suppamt" type="STRING" size="256" />
  198. <Column id="rcpt_sum" type="STRING" size="256" />
  199. </ColumnInfo>
  200. <Rows>
  201. <Row>
  202. <Col id="rcpt_rcptrid"></Col>
  203. <Col id="rcpt_rcptrnm"></Col>
  204. <Col id="rcpt_ojamt_cnt"></Col>
  205. <Col id="rcpt_ojamt"></Col>
  206. <Col id="rcpt_rsrv_cnt"></Col>
  207. <Col id="rcpt_rsrv"></Col>
  208. <Col id="rcpt_rcptamt_cnt"></Col>
  209. <Col id="rcpt_rcptamt"></Col>
  210. <Col id="rcpt_bogjamt"></Col>
  211. <Col id="rcpt_bogjaltamt"></Col>
  212. <Col id="rcpt_bogjrtnamt"></Col>
  213. <Col id="rcpt_unco"></Col>
  214. <Col id="rcpt_uncr"></Col>
  215. <Col id="rcpt_rareobstamt"></Col>
  216. <Col id="rcpt_suppamt"></Col>
  217. <Col id="rcpt_sum"></Col>
  218. </Row>
  219. </Rows>
  220. </Dataset>
  221. <Dataset id="ds_send_data1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  222. <ColumnInfo>
  223. <Column id="fromdd" type="STRING" size="256" />
  224. <Column id="tm_from" type="STRING" size="256" />
  225. <Column id="tm_to" type="STRING" size="256" />
  226. <Column id="rcpt_id" type="STRING" size="256" />
  227. <Column id="rcpt_flag" type="STRING" size="256" />
  228. <Column id="ordtype" type="STRING" size="256" />
  229. </ColumnInfo>
  230. <Rows>
  231. <Row>
  232. <Col id="fromdd"></Col>
  233. <Col id="tm_from"></Col>
  234. <Col id="tm_to"></Col>
  235. <Col id="rcpt_id"></Col>
  236. <Col id="rcpt_flag"></Col>
  237. <Col id="ordtype"></Col>
  238. </Row>
  239. </Rows>
  240. </Dataset>
  241. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  242. <ColumnInfo />
  243. </Dataset>
  244. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  245. <ColumnInfo />
  246. </Dataset>
  247. <Dataset id="ds_hidden_session" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  248. <ColumnInfo>
  249. <Column id="userid" type="STRING" size="256" />
  250. <Column id="usernm" type="STRING" size="256" />
  251. <Column id="posinstcd" type="STRING" size="256" />
  252. <Column id="posinstnm" type="STRING" size="256" />
  253. <Column id="dutplcecd" type="STRING" size="256" />
  254. <Column id="dutplcenm" type="STRING" size="256" />
  255. <Column id="dutinstnm" type="STRING" size="256" />
  256. </ColumnInfo>
  257. </Dataset>
  258. </Objects>
  259. <Bind>
  260. <BindItem id="item0" compid="group2.input7" propid="value" datasetid="ds_send_data1" columnid="fromdd" />
  261. <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_send_data1" columnid="tm_from" />
  262. <BindItem id="item2" compid="group2.input15" propid="value" datasetid="ds_send_data1" columnid="tm_to" />
  263. <BindItem id="item3" compid="group2.input2" propid="value" datasetid="ds_send_data1" columnid="rcpt_id" />
  264. </Bind>
  265. <Script type="xscript4.0"><![CDATA[function SMPAS00520_onload(obj:Form, e:LoadEventInfo) {
  266. frmf_initForm(obj);
  267. //grdf_initGrid(grd_XXX);
  268. //grdf_setGridSort(grd_XXX);
  269. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  270. makeReportPreview(300,0,893,648,"switch1.case2");
  271. fInitialize();
  272. fGetUserInfo2();
  273. btn_all.selected = "true"; //외래전체수익통계로 기본세팅
  274. model.toggle("switch1.case1");
  275. //exeReportPreview("RPPAS01692", "XMLSTR", "", "", "false", "", "", "", "", "","", "switch1.case2", "", "", "", "1", "75");
  276. }
  277. include '../../.._com_commonweb_js_common.js'
  278. include '../../.._com_commonweb_js_utilHelper.js'
  279. include '../../.._com_commonweb_js_tfHelper.js'
  280. include '../../.._com_commonweb_js_dateHelper.js'
  281. include '../../.._com_commonweb_js_numericHelper.js'
  282. include '../../.._com_commonweb_js_stringHelper.js'
  283. include '../../.._com_basiccodeweb_js_ZBC001.js'
  284. include '../../.._com_zipcodeweb_js_ZBP001.js'
  285. var cash = 0;
  286. //로그인한 사용자 정보조회
  287. function fGetUserInfo2(){
  288. var sUserInfosS = getUserInfos();
  289. sUserInfosS = sUserInfosS + "|";
  290. //alert("sUserInfosS : " + sUserInfosS);
  291. var UserInfosS_Array = sUserInfosS.split("|");
  292. var userid = UserInfosS_Array[0]; //사용자번호
  293. var usernm = UserInfosS_Array[1]; //사용자이름
  294. var posinstcd = UserInfosS_Array[2]; //소속기관코드
  295. var posinstnm = UserInfosS_Array[3]; //소속기관명
  296. var dutplcecd = UserInfosS_Array[4]; //근무지부서코드
  297. var dutplcenm = UserInfosS_Array[5]; //근무지부서명
  298. var dutinstnm = UserInfosS_Array[7]; //근무지기관명
  299. /*
  300. model.makeNode("ds_hidden_session/" + "userid");
  301. model.makeNode("ds_hidden_session/" + "usernm");
  302. model.makeNode("ds_hidden_session/" + "posinstcd");
  303. model.makeNode("ds_hidden_session/" + "posinstnm");
  304. model.makeNode("ds_hidden_session/" + "dutplcecd");
  305. model.makeNode("ds_hidden_session/" + "dutplcenm");
  306. model.makeNode("ds_hidden_session/" + "dutinstnm");
  307. */
  308. ds_hidden_session.setColumn( 0, "userid",userid);
  309. ds_hidden_session.setColumn( 0, "usernm",usernm);
  310. ds_hidden_session.setColumn( 0, "posinstcd",posinstcd);
  311. ds_hidden_session.setColumn( 0, "posinstnm",posinstnm);
  312. ds_hidden_session.setColumn( 0, "dutplcecd",dutplcecd);
  313. ds_hidden_session.setColumn( 0, "dutplcenm",dutplcenm);
  314. ds_hidden_session.setColumn( 0, "dutinstnm",dutinstnm);
  315. }
  316. function fInitialize() {
  317. ds_main_h_rcpt_rcpt.clearData();
  318. ds_send_data1.setColumn( 0, "fromdd", utlf_getCurrentDate()); // common.js에서 제공하는 함수를 사용하여 오늘 날짜를 구한다.
  319. ds_send_data1.setColumn( 0, "tm_from", "0000");
  320. ds_send_data1.setColumn( 0, "tm_to", "2400");
  321. ds_send_data1.setColumn( 0, "rcpt_id", "");
  322. ds_send_data1.setColumn( 0, "rcpt_flag", "");
  323. ds_send_data1.setColumn( 0, "ordtype", "O");
  324. //exeReportPreview("RPPAS01692", "XMLSTR", "", "", "false", "", "", "", "", "","", "switch1.case2", "", "", "", "1", "75");
  325. //model.refresh();
  326. }
  327. function fSearch() {
  328. //외래전체수입통계
  329. if(switch1.selectedIndex == "0") {
  330. // submit("TRPAS00521");
  331. exeReportPreview("RPPAS00521", "XMLSTR", "", "", "false", "", "", "", "", "","", "switch1.case1", "", "", "", "1", "75");
  332. switch1.case1.grd_rcpt.subtotalPosition = "below";
  333. //#c8e67b
  334. switch1.case1.grd_rcpt.subtotal("sum", -1, 1, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  335. switch1.case1.grd_rcpt.subtotal("sum", -1, 2, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  336. switch1.case1.grd_rcpt.subtotal("sum", -1, 3, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  337. switch1.case1.grd_rcpt.subtotal("sum", -1, 4, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  338. switch1.case1.grd_rcpt.subtotal("sum", -1, 5, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  339. switch1.case1.grd_rcpt.subtotal("sum", -1, 6, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  340. switch1.case1.grd_rcpt.subtotal("sum", -1, 7, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  341. switch1.case1.grd_rcpt.subtotal("sum", -1, 8, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  342. switch1.case1.grd_rcpt.subtotal("sum", -1, 9, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  343. switch1.case1.grd_rcpt.subtotal("sum", -1, 10, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  344. switch1.case1.grd_rcpt.subtotal("sum", -1, 11, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  345. switch1.case1.grd_rcpt.subtotal("sum", -1, 12, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  346. switch1.case1.grd_rcpt.subtotal("sum", -1, 13, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  347. switch1.case1.grd_rcpt.subtotal("sum", -1, 14, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
  348. }
  349. //수납자별외래수입통계
  350. if(switch1.selectedIndex == "1") {
  351. // submit("TRPAS00522");
  352. // submit("TRPAS00543");
  353. switch1.case2.grd_rcpt1.rebuildStyle();
  354. setRowStyle("switch1.case2.grd_rcpt1" , "0" , "총계" , "col1", "equal" ); //총계 색깔 표시
  355. cash = parseInt(model.getvalue("ds_main_h_rcpt2_rcpt2[18]_col3" )); //좌측 그리드 현금 - (은행입금액 +통장입금액 + 비고) 키인계산하기위해쓰임
  356. exeReportPreview("RPPAS00522", "XMLSTR", "", "", "false", "", "", "", "", "","", "switch1.case2", "", "", "", "1", "75");
  357. }
  358. //model.refresh();
  359. }
  360. function group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {
  361. fSearch();
  362. }
  363. function group2_button95_onclick(obj:Button, e:ClickEventInfo) {
  364. var vToday = new Date();
  365. var tmpYear = vToday.getYear();
  366. var tmpMonth = vToday.getMonth()+1;
  367. var tmpDate = vToday.getDate();
  368. //
  369. // ds_documenttitle.setColumn( 0, "title",document.title);
  370. //
  371. //model.refresh();
  372. // var subjectTitle = ds_documenttitle.getColumn(0, "title");
  373. if(switch1.selectedIndex == "0") {
  374. //엑셀저장 여부(타이틀별)
  375. var fileName = window.fileDialog("save", "", false, "외래전체수입통계"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  376. if (fileName != "")
  377. {
  378. grd_rcpt2.saveExcel(fileName, "외래전체수입통계"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
  379. }
  380. }
  381. if(switch1.selectedIndex == "1") {
  382. //엑셀저장 여부(타이틀별)
  383. var fileName = window.fileDialog("save", "", false, "수납자별외래수입통계"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  384. if (fileName != "")
  385. {
  386. switch1.case2.grd_rcpt1.saveExcel(fileName, "수납자별외래수입통계"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
  387. }
  388. }
  389. }
  390. function group2_btn_print_onclick(obj:Button, e:ClickEventInfo) {
  391. if(switch1.selectedIndex == "0") {
  392. exeReportPreview("RPPAS00521", "XMLSTR", "", "", "true", "", "", "", "", "","", "switch1.case2", "", "", "", "1", "75");
  393. }
  394. if(switch1.selectedIndex == "1") {
  395. exeReportPreview("RPPAS00522", "XMLSTR", "", "", "true", "", "", "", "", "","", "switch1.case2", "", "", "", "1", "75");
  396. }
  397. }
  398. function btn_init_onclick(obj:Button, e:ClickEventInfo) {
  399. fInitialize();
  400. }
  401. function switch1_case1_grd_rcpt_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
  402. if (isDataCell() == true) {
  403. var temp = switch1.case1.grd_rcpt.row -1;
  404. ds_send_data1.setColumn( 0, "rcpt_id", ds_main_h_rcpt_rcpt.getColumn(temp, "rcpt_rcptrid")) );
  405. //group2.input2.refresh();
  406. btn_rcptid.dispatch("onclick");
  407. fSearch();
  408. }
  409. }
  410. function switch1_case2_grd_rcpt1_ontextchanged(obj:Grid, e:GridEditTextChangedEventInfo) {
  411. //if(switch1.case2.grd_rcpt1.col=="1" && switch1.case2.grd_rcpt1.row=="4" ){
  412. var temp = 0;
  413. for(var a=1; a < 11 ; a++) {
  414. //9는 미수금 미수금은 총계에서 제외
  415. if(a != 9) { temp = parseInt(ds_main_h_rcpt2_rcpt2.getColumn(a, "col2")) + temp;
  416. }
  417. }
  418. ds_main_h_rcpt2.setColumn( 0, "rcpt2[11]_col2" , temp);
  419. //}
  420. //if(switch1.case2.grd_rcpt1.col=="2" && switch1.case2.grd_rcpt1.row=="4" ){
  421. var temp = 0;
  422. for(var a=1; a < 11 ; a++) {
  423. //9는 미수금 미수금은 총계에서 제외
  424. if(a != 9) {temp = parseInt(ds_main_h_rcpt2_rcpt2.getColumn(a, "col3")) + temp;
  425. }
  426. }
  427. ds_main_h_rcpt2.setColumn( 0, "rcpt2[11]_col3" , temp);
  428. //}
  429. //좌측 그리드 현금 - (은행입금액 +통장입금액 + 비고) 키인계산하기위해쓰임
  430. var temp = cash;
  431. temp = temp - parseInt(ds_main_h_rcpt2_rcpt2.getColumn(14, "col3")))
  432. - parseInt(ds_main_h_rcpt2_rcpt2.getColumn(15, "col3")))
  433. - parseInt(ds_main_h_rcpt2_rcpt2.getColumn(16, "col3")));
  434. ds_main_h_rcpt2.setColumn( 0, "rcpt2[18]_col3" , temp);
  435. //좌측 그리드 계산끝
  436. //model.refresh();
  437. exeReportPreview("RPPAS00522", "XMLSTR", "", "", "false", "", "", "", "", "","", "switch1.case2", "", "", "", "1", "75");
  438. }
  439. function switch1_case2_grd_rcpt1_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
  440. if (isDataCell() == true) {
  441. if(switch1.case2.grd_rcpt1.col=="0" && switch1.case2.grd_rcpt1.row < "11" ) {
  442. ds_send_data1.setColumn( 0, "rcpt_flag",ds_main_h_rcpt2_rcpt2.getColumn(switch1.case2.grd_rcpt1.row, "col1"));
  443. frmf_open("SMPAO00500", "", "ds_send_data1" "-"ds_temp_rcpt_data1"", "", "", "", "", "", "", "", "", "", "M");
  444. //frmf_open("SMPAO00500", "", ""-"", "", "", "", "", "", "", "", "", "", "M");
  445. }
  446. }
  447. }
  448. function button3_onclick(obj:Button, e:ClickEventInfo) {
  449. }
  450. function btn_rcptid_onclick(obj:Button, e:ClickEventInfo) {
  451. group2.caption1.visible = true;
  452. group2.input2.visible = true;
  453. exeReportPreview("RPPAS00522", "XMLSTR", "", "", "false", "", "", "", "", "","", "switch1.case2", "", "", "", "1", "75");
  454. }
  455. function btn_all_onclick(obj:Button, e:ClickEventInfo) {
  456. group2.caption1.visible = false;
  457. group2.input2.visible = false;
  458. }
  459. ]]></Script>
  460. </Form>
  461. </FDL>