SMPAE00201_수납자별마감금액비교.xfdl 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMPAE00201" position="absolute 0 0 1210 804" titletext="수납자별 마감 금액 비교" onload="SMPAE00201_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption6" class="tit_1" position="absolute 0 0 272 23" style="" text="수납자별 마감 금액 비교 (개편 vs 기존)"/>
  8. <Static id="caption77" class="tit_2" position="absolute 0 69 144 86" style="" text="수납자별 마감내역"/>
  9. <Grid id="grd_comp" binddataset="ds_main_complist_compinfo" position="absolute 0 89 1195 779" style="" cellsizebandtype="allband" cellsizingtype="col" onheaddblclick="grd_comp_onheaddblclick">
  10. <Formats>
  11. <Format id="default">
  12. <Columns>
  13. <Column size="0"/>
  14. <Column size="75"/>
  15. <Column size="0"/>
  16. <Column size="0"/>
  17. <Column size="90"/>
  18. <Column size="90"/>
  19. <Column size="90"/>
  20. <Column size="90"/>
  21. <Column size="90"/>
  22. <Column size="0"/>
  23. <Column size="50"/>
  24. <Column size="90"/>
  25. <Column size="90"/>
  26. <Column size="90"/>
  27. <Column size="90"/>
  28. <Column size="90"/>
  29. <Column size="90"/>
  30. <Column size="90"/>
  31. <Column size="90"/>
  32. <Column size="90"/>
  33. <Column size="90"/>
  34. <Column size="90"/>
  35. <Column size="90"/>
  36. <Column size="90"/>
  37. <Column size="90"/>
  38. <Column size="90"/>
  39. <Column size="90"/>
  40. <Column size="90"/>
  41. </Columns>
  42. <Rows>
  43. <Row size="24" band="head"/>
  44. <Row size="18" band="head"/>
  45. <Row size="24"/>
  46. </Rows>
  47. <Band id="head">
  48. <Cell text="seq"/>
  49. <Cell col="1" rowspan="2" text="마감일" taborder="undefined"/>
  50. <Cell col="2" text="비교결과"/>
  51. <Cell col="3" text="비교결과(현금)"/>
  52. <Cell col="4" rowspan="2" text="현금" taborder="undefined"/>
  53. <Cell col="5" rowspan="2" text="카드" taborder="undefined"/>
  54. <Cell col="6" rowspan="2" text="온라인" taborder="undefined"/>
  55. <Cell col="7" rowspan="2" text="미수" taborder="undefined"/>
  56. <Cell col="8" rowspan="2" text="합계" taborder="undefined"/>
  57. <Cell col="9" text="수납자ID"/>
  58. <Cell col="10" rowspan="2" text="수납자" taborder="undefined"/>
  59. <Cell col="11" rowspan="2" text="합계" taborder="undefined"/>
  60. <Cell col="12" colspan="4" text="현금" taborder="undefined"/>
  61. <Cell col="16" colspan="4" text="카드" taborder="undefined"/>
  62. <Cell col="20" colspan="4" text="온라인" taborder="undefined"/>
  63. <Cell col="24" colspan="4" text="미수" taborder="undefined"/>
  64. <Cell col="28" text="seq"/>
  65. <Cell col="29" text="마감일"/>
  66. <Cell col="30" text="비교결과"/>
  67. <Cell col="31" text="비교결과(현금)"/>
  68. <Cell col="32" text="현금"/>
  69. <Cell col="33" text="카드"/>
  70. <Cell col="34" text="온라인"/>
  71. <Cell col="35" text="미수"/>
  72. <Cell col="36" text="합계"/>
  73. <Cell col="37" text="수납자ID"/>
  74. <Cell col="38" text="수납자"/>
  75. <Cell col="39" text="합계"/>
  76. <Cell col="40" text="외래"/>
  77. <Cell col="41" text="입원"/>
  78. <Cell col="42" text="건진"/>
  79. <Cell col="43" text="계"/>
  80. <Cell col="44" text="외래"/>
  81. <Cell col="45" text="입원"/>
  82. <Cell col="46" text="건진"/>
  83. <Cell col="47" text="계"/>
  84. <Cell col="48" text="외래"/>
  85. <Cell col="49" text="입원"/>
  86. <Cell col="50" text="건진"/>
  87. <Cell col="51" text="계"/>
  88. <Cell col="52" text="외래"/>
  89. <Cell col="53" text="입원"/>
  90. <Cell col="54" text="건진"/>
  91. <Cell col="55" text="계"/>
  92. <Cell row="1" text="seq"/>
  93. <Cell row="1" col="2" text="비교결과"/>
  94. <Cell row="1" col="3" text="비교결과(현금)"/>
  95. <Cell row="1" col="9" text="수납자ID"/>
  96. <Cell row="1" col="12" text="외래"/>
  97. <Cell row="1" col="13" text="입원"/>
  98. <Cell row="1" col="14" text="건진"/>
  99. <Cell row="1" col="15" text="계"/>
  100. <Cell row="1" col="16" text="외래"/>
  101. <Cell row="1" col="17" text="입원"/>
  102. <Cell row="1" col="18" text="건진"/>
  103. <Cell row="1" col="19" text="계"/>
  104. <Cell row="1" col="20" text="외래"/>
  105. <Cell row="1" col="21" text="입원"/>
  106. <Cell row="1" col="22" text="건진"/>
  107. <Cell row="1" col="23" text="계"/>
  108. <Cell row="1" col="24" text="외래"/>
  109. <Cell row="1" col="25" text="입원"/>
  110. <Cell row="1" col="26" text="건진"/>
  111. <Cell row="1" col="27" text="계"/>
  112. </Band>
  113. <Band id="body">
  114. <Cell text="bind:seq"/>
  115. <Cell col="1" displaytype="date" text="bind:enddd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
  116. <Cell col="2" text="bind:compflag"/>
  117. <Cell col="3" text="bind:cashflag"/>
  118. <Cell col="4" displaytype="number" style="background:BIND(&quot;cashDiffbgColor&quot;);background2:BIND(&quot;cashDiffbgColor&quot;);color:BIND(&quot;cashDiffColor&quot;);color2:BIND(&quot;cashDiffColor&quot;);font:BIND(&quot;cashDiffFont&quot;);" text="bind:cash_mgsm" mask="#,##0"/>
  119. <Cell col="5" displaytype="number" style="background:BIND(&quot;cardDiffbgColor&quot;);background2:BIND(&quot;cardDiffbgColor&quot;);color:BIND(&quot;cardDiffColor&quot;);color2:BIND(&quot;cardDiffColor&quot;);font:BIND(&quot;cardDiffFont&quot;);" text="bind:card_mgsm" mask="#,##0"/>
  120. <Cell col="6" displaytype="number" style="background:BIND(&quot;onlineDiffbgColor&quot;);background2:BIND(&quot;onlineDiffbgColor&quot;);color:BIND(&quot;onlineDiffColor&quot;);color2:BIND(&quot;onlineDiffColor&quot;);font:BIND(&quot;onlineDiffFont&quot;);" text="bind:online_mgsm" mask="#,##0"/>
  121. <Cell col="7" displaytype="number" style="background:BIND(&quot;uncoDiffbgColor&quot;);background2:BIND(&quot;uncoDiffbgColor&quot;);color:BIND(&quot;uncoDiffColor&quot;);color2:BIND(&quot;uncoDiffColor&quot;);font:BIND(&quot;uncoDiffFont&quot;);" text="bind:unco_mgsm" mask="#,##0"/>
  122. <Cell col="8" displaytype="number" style="background:BIND(&quot;newTotbgColor&quot;);background2:BIND(&quot;newTotbgColor&quot;);color:BIND(&quot;newTotColor&quot;);color2:BIND(&quot;newTotColor&quot;);font:BIND(&quot;newTotFont&quot;);controlfont:BIND(&quot;newTotColor&quot;);" text="bind:new_tot" mask="#,##0"/>
  123. <Cell col="9" displaytype="number" text="bind:rcptrid" mask="#,##0"/>
  124. <Cell col="10" displaytype="normal" style="background:BIND(&quot;rcptrnmbgColor&quot;);background2:BIND(&quot;rcptrnmbgColor&quot;);font:BIND(&quot;rcptrnmFont&quot;);" text="bind:rcptrnm" wordwrap="char"/>
  125. <Cell col="11" displaytype="number" style="background:BIND(&quot;oldTotbgColor&quot;);background2:BIND(&quot;oldTotbgColor&quot;);color:BIND(&quot;oldTotColor&quot;);color2:BIND(&quot;oldTotColor&quot;);font:BIND(&quot;oldTotFont&quot;);" text="bind:old_tot" mask="#,##0"/>
  126. <Cell col="12" displaytype="number" text="bind:cash_out" mask="#,##0"/>
  127. <Cell col="13" displaytype="number" text="bind:cash_in" mask="#,##0"/>
  128. <Cell col="14" displaytype="number" text="bind:cash_hi" mask="#,##0"/>
  129. <Cell col="15" displaytype="number" style="background:BIND(&quot;cashDiffbgColor&quot;);background2:BIND(&quot;cashDiffbgColor&quot;);color:BIND(&quot;cashDiffColor&quot;);color2:BIND(&quot;cashDiffColor&quot;);font:BIND(&quot;cashDiffFont&quot;);" text="bind:cash_sum" mask="#,##0"/>
  130. <Cell col="16" displaytype="number" text="bind:card_out" mask="#,##0"/>
  131. <Cell col="17" displaytype="number" text="bind:card_in" mask="#,##0"/>
  132. <Cell col="18" displaytype="number" text="bind:card_hi" mask="#,##0"/>
  133. <Cell col="19" displaytype="number" style="background:BIND(&quot;cardDiffbgColor&quot;);background2:BIND(&quot;cardDiffbgColor&quot;);color:BIND(&quot;cardDiffColor&quot;);color2:BIND(&quot;cardDiffColor&quot;);font:BIND(&quot;cardDiffFont&quot;);" text="bind:card_sum" mask="#,##0"/>
  134. <Cell col="20" displaytype="number" text="bind:online_out" mask="#,##0"/>
  135. <Cell col="21" displaytype="number" text="bind:online_in" mask="#,##0"/>
  136. <Cell col="22" displaytype="number" text="bind:online_hi" mask="#,##0"/>
  137. <Cell col="23" displaytype="number" style="background:BIND(&quot;onlineDiffbgColor&quot;);background2:BIND(&quot;onlineDiffbgColor&quot;);color:BIND(&quot;onlineDiffColor&quot;);color2:BIND(&quot;onlineDiffColor&quot;);font:BIND(&quot;onlineDiffFont&quot;);" text="bind:online_sum" mask="#,##0"/>
  138. <Cell col="24" displaytype="number" text="bind:unco_out" mask="#,##0"/>
  139. <Cell col="25" displaytype="number" text="bind:unco_in" mask="#,##0"/>
  140. <Cell col="26" displaytype="number" text="bind:unco_hi" mask="#,##0"/>
  141. <Cell col="27" displaytype="number" style="background:BIND(&quot;uncoDiffbgColor&quot;);background2:BIND(&quot;uncoDiffbgColor&quot;);color:BIND(&quot;uncoDiffColor&quot;);color2:BIND(&quot;uncoDiffColor&quot;);font:BIND(&quot;uncoDiffFont&quot;);" text="bind:unco_sum" mask="#,##0"/>
  142. </Band>
  143. </Format>
  144. </Formats>
  145. </Grid>
  146. <Button id="btn_xls" class="btn2" position="absolute 1153 65 1195 84" text="엑셀" onclick="btn_xls_onclick"/>
  147. <Shape id="line_comp" class="line_10" linetype="horizontal" position="absolute 0 86 1195 90" style="" anchor="default"/>
  148. <Shape id="line1" linetype="vertical" position="absolute 575 67 578 82" style="border:0 solid #b0b0b0ff #b0b0b0ff;" anchor="default"/>
  149. <Static id="caption1" position="absolute 577 67 625 82" style="color:#787878;" text="▶ 기존"/>
  150. <Shape id="line2" linetype="vertical" position="absolute 525 67 528 82" style="border:0 solid #b0b0b0ff #b0b0b0ff;" anchor="default"/>
  151. <Static id="caption2" position="absolute 482 67 524 82" style="align:right ;color:#787878;" text="개편 ◀"/>
  152. <Static id="caption3" position="absolute 910 33 1145 83" style="align:left ;color:#787878;" text="※ 기존 금액의 칼럼 헤더를 더블 클릭하면&#10; 각 금액별로 확장 및 축소가 가능합니다.&#10; (합계 : 전체 확장 / 축소)"/>
  153. <Div id="grp" taborder="6" class="div_SA" position="absolute 0 23 787 59">
  154. <Layouts>
  155. <Layout>
  156. <Shape id="line14" linetype="vertical" class="line_4" position="absolute 315 8 318 28" style="border:0 solid #ffd799ff #ffd799ff;font:돋움체,9;"/>
  157. <Button id="btn_search" taborder="2" text="조회" onclick="btn_search_onclick" class="btn1" position="absolute 335 8 391 28"/>
  158. <Static id="caption35" text="마감일자 :" class="search_name" position="absolute 5 8 79 28"/>
  159. <Calendar id="ipt_fromdd" taborder="0" position="absolute 89 8 179 28" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" value="null"/>
  160. <Static id="caption4" text="~" position="absolute 182 8 197 28" style="align:center ;"/>
  161. <Calendar id="ipt_todd" taborder="1" position="absolute 200 8 290 28" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd"/>
  162. <CheckBox id="chk_compflag" taborder="3" text="금액이 다른 항목만 보기" truevalue="Y" position="absolute 415 8 570 28" innerdataset="[object Dataset]" datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" onclick="grp_chk_compflag_onclick">
  163. <Dataset id="innerdataset">
  164. <ColumnInfo>
  165. <Column id="codecolumn"/>
  166. <Column id="datacolumn"/>
  167. </ColumnInfo>
  168. <Rows>
  169. <Row>
  170. <Col id="codecolumn">Y</Col>
  171. <Col id="datacolumn">금액이 다른 항목만 보기</Col>
  172. </Row>
  173. </Rows>
  174. </Dataset>
  175. </CheckBox>
  176. <CheckBox id="chk_cashflag" taborder="4" text="현금이 다른 항목만 보기" truevalue="Y" position="absolute 580 8 735 28" innerdataset="[object Dataset]" datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" onclick="grp_chk_cashflag_onclick">
  177. <Dataset id="innerdataset">
  178. <ColumnInfo>
  179. <Column id="codecolumn"/>
  180. <Column id="datacolumn"/>
  181. </ColumnInfo>
  182. <Rows>
  183. <Row>
  184. <Col id="codecolumn">Y</Col>
  185. <Col id="datacolumn">현금이 다른 항목만 보기</Col>
  186. </Row>
  187. </Rows>
  188. </Dataset>
  189. </CheckBox>
  190. </Layout>
  191. </Layouts>
  192. </Div>
  193. </Layout>
  194. </Layouts>
  195. <Objects>
  196. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  197. <ColumnInfo>
  198. <Column id="compflag" type="STRING" size="256"/>
  199. <Column id="cashflag" type="STRING" size="256"/>
  200. </ColumnInfo>
  201. <Rows>
  202. <Row/>
  203. </Rows>
  204. </Dataset>
  205. <Dataset id="ds_main_complist_compinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  206. <ColumnInfo>
  207. <Column id="enddd" type="STRING" size="256"/>
  208. <Column id="compflag" type="STRING" size="256"/>
  209. <Column id="cashflag" type="STRING" size="256"/>
  210. <Column id="cash_out" type="STRING" size="256"/>
  211. <Column id="cash_in" type="STRING" size="256"/>
  212. <Column id="cash_hi" type="STRING" size="256"/>
  213. <Column id="cash_sum" type="STRING" size="256"/>
  214. <Column id="card_out" type="STRING" size="256"/>
  215. <Column id="card_in" type="STRING" size="256"/>
  216. <Column id="card_hi" type="STRING" size="256"/>
  217. <Column id="card_sum" type="STRING" size="256"/>
  218. <Column id="online_out" type="STRING" size="256"/>
  219. <Column id="online_in" type="STRING" size="256"/>
  220. <Column id="online_hi" type="STRING" size="256"/>
  221. <Column id="online_sum" type="STRING" size="256"/>
  222. <Column id="unco_out" type="STRING" size="256"/>
  223. <Column id="unco_in" type="STRING" size="256"/>
  224. <Column id="unco_hi" type="STRING" size="256"/>
  225. <Column id="unco_sum" type="STRING" size="256"/>
  226. <Column id="old_tot" type="STRING" size="256"/>
  227. <Column id="rcptrid" type="STRING" size="256"/>
  228. <Column id="rcptrnm" type="STRING" size="256"/>
  229. <Column id="new_tot" type="STRING" size="256"/>
  230. <Column id="cash_mgsm" type="STRING" size="256"/>
  231. <Column id="card_mgsm" type="STRING" size="256"/>
  232. <Column id="online_mgsm" type="STRING" size="256"/>
  233. <Column id="unco_mgsm" type="STRING" size="256"/>
  234. </ColumnInfo>
  235. <Rows>
  236. <Row>
  237. <Col id="enddd"/>
  238. <Col id="compflag"/>
  239. <Col id="cashflag"/>
  240. <Col id="cash_out"/>
  241. <Col id="cash_in"/>
  242. <Col id="cash_hi"/>
  243. <Col id="cash_sum"/>
  244. <Col id="card_out"/>
  245. <Col id="card_in"/>
  246. <Col id="card_hi"/>
  247. <Col id="card_sum"/>
  248. <Col id="online_out"/>
  249. <Col id="online_in"/>
  250. <Col id="online_hi"/>
  251. <Col id="online_sum"/>
  252. <Col id="unco_out"/>
  253. <Col id="unco_in"/>
  254. <Col id="unco_hi"/>
  255. <Col id="unco_sum"/>
  256. <Col id="old_tot"/>
  257. <Col id="rcptrid"/>
  258. <Col id="rcptrnm"/>
  259. <Col id="new_tot"/>
  260. <Col id="cash_mgsm"/>
  261. <Col id="card_mgsm"/>
  262. <Col id="online_mgsm"/>
  263. <Col id="unco_mgsm"/>
  264. </Row>
  265. </Rows>
  266. </Dataset>
  267. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  268. <ColumnInfo/>
  269. </Dataset>
  270. <Dataset id="ds_main_complist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  271. <ColumnInfo/>
  272. </Dataset>
  273. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  274. <ColumnInfo>
  275. <Column id="fromdd" type="STRING" size="256"/>
  276. <Column id="todd" type="STRING" size="256"/>
  277. </ColumnInfo>
  278. <Rows>
  279. <Row>
  280. <Col id="fromdd"/>
  281. <Col id="todd"/>
  282. </Row>
  283. </Rows>
  284. </Dataset>
  285. <FilteredDataset id="dsft_main_complist_compinfo" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" binddataset="@ds_main_complist_compinfo"/>
  286. </Objects>
  287. <Bind>
  288. <BindItem id="item0" compid="grp.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
  289. <BindItem id="item1" compid="grp.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
  290. <BindItem id="item2" compid="grp.chk_compflag" propid="value" datasetid="ds_hidden" columnid="compflag"/>
  291. <BindItem id="item3" compid="grp.chk_cashflag" propid="value" datasetid="ds_hidden" columnid="cashflag"/>
  292. </Bind>
  293. <Script type="xscript4.0"><![CDATA[include 'com_commonxp::comm_main.xjs';
  294. //스크립트 시작 ***
  295. //전체에서 event와 src를 제외한 script 를 모두포함.
  296. var arErrorCode = new HashArray();
  297. function fSetColWidth(amt, expand) {
  298. var width = expand ? 90 : 0;
  299. if (utlf_transNullToEmpty(amt) == "") {
  300. grd_comp.setFormatColProperty(12, "size", width);
  301. grd_comp.setFormatColProperty(13, "size", width);
  302. grd_comp.setFormatColProperty(14, "size", width);
  303. grd_comp.setFormatColProperty(16, "size", width);
  304. grd_comp.setFormatColProperty(17, "size", width);
  305. grd_comp.setFormatColProperty(18, "size", width);
  306. grd_comp.setFormatColProperty(20, "size", width);
  307. grd_comp.setFormatColProperty(21, "size", width);
  308. grd_comp.setFormatColProperty(22, "size", width);
  309. grd_comp.setFormatColProperty(24, "size", width);
  310. grd_comp.setFormatColProperty(25, "size", width);
  311. grd_comp.setFormatColProperty(26, "size", width);
  312. } else {
  313. var col = 0;
  314. if (amt == 'cash'){
  315. col = 12;
  316. }
  317. else if(amt == 'card') {
  318. col = 16;
  319. }
  320. else if(amt == 'online') {
  321. col = 20;
  322. }
  323. else if(amt == 'unco') {
  324. col = 24;
  325. }
  326. grd_comp.setFormatColProperty(col, "size", width);
  327. grd_comp.setFormatColProperty(col + 1, "size", width);
  328. grd_comp.setFormatColProperty(col + 2, "size", width);
  329. }
  330. }
  331. function fSetCompflag() {
  332. // alert('befoer: ' + ds_main_complist_compinfo.rowcount);
  333. if (ds_hidden.getColumn(0, "cashflag") == "Y") {
  334. ds_main_complist_compinfo.filter("cashflag == 'N'");
  335. }
  336. else if (ds_hidden.getColumn(0, "compflag") == "Y") {
  337. ds_main_complist_compinfo.filter("compflag == 'N'");
  338. }
  339. else {
  340. ds_main_complist_compinfo.filter("");
  341. }
  342. var path = ds_main_complist_compinfo;
  343. var cnt = ds_main_complist_compinfo.rowcount;
  344. // alert('after: ' + cnt);
  345. var startRow = 0;
  346. for (var i = 0; i < cnt; i++) {
  347. if (path.getColumn(i, "compflag") != "Y") {
  348. //var row = grd_comp.findRow(path.getColumn(i, "seq"), 2, grd_comp.colRef("seq"), false, true);
  349. var row = path.findRowExpr('compflag != "Y"', startRow, i + 1);
  350. startRow = row + 1;
  351. // 수납자
  352. path.setColumn(row, 'rcptrnmFont', 'Dotum,9,bold');
  353. // 합계
  354. path.setColumn(row, 'newTotbgColor', '#ffffd2');
  355. path.setColumn(row, 'newTotColor', '#b40000');
  356. path.setColumn(row, 'newTotFont', 'Dotum,9,bold');
  357. //수납자
  358. path.setColumn(row, 'rcptrnmbgColor', '#ffffa0');
  359. path.setColumn(row, 'rcptrnmFont', 'Dotum,9,bold');
  360. // 합계
  361. path.setColumn(row, 'oldTotbgColor', '#ffffd2');
  362. path.setColumn(row, 'oldTotColor', '#b40000');
  363. path.setColumn(row, 'oldTotFont', 'Dotum,9,bold');
  364. if (path.getColumn(i, "cash_mgsm") != path.getColumn(i, "cash_sum")) {
  365. path.setColumn(row, 'cashDiffbgColor', '#ffffa0');
  366. path.setColumn(row, 'cashDiffColor', 'red');
  367. path.setColumn(row, 'cashDiffFont', 'Dotum,9,bold');
  368. }
  369. if (path.getColumn(i, "card_mgsm") != path.getColumn(i, "card_sum")) {
  370. path.setColumn(row, 'cardDiffbgColor', '#ffffa0');
  371. path.setColumn(row, 'cardDiffColor', 'red');
  372. path.setColumn(row, 'cardDiffFont', 'Dotum,9,bold');
  373. }
  374. if (path.getColumn(i, "online_mgsm") != path.getColumn(i, "online_sum")) {
  375. path.setColumn(row, 'onlineDiffbgColor', '#ffffa0');
  376. path.setColumn(row, 'onlineDiffColor', 'red');
  377. path.setColumn(row, 'onlineDiffFont', 'Dotum,9,bold');
  378. }
  379. if (path.getColumn(i, "unco_mgsm") != path.getColumn(i, "unco_sum")) {
  380. path.setColumn(row, 'uncoDiffbgColor', '#ffffa0');
  381. path.setColumn(row, 'uncoDiffColor', 'red');
  382. path.setColumn(row, 'uncoDiffFont', 'Dotum,9,bold');
  383. }
  384. }
  385. }
  386. }
  387. function SMPAE00201_onload(obj:Form, e:LoadEventInfo) {
  388. frmf_initForm(obj);
  389. //grdf_initGrid(this.grd_comp);
  390. var fromdd = utlf_getCurrentDate().toDate().getAddDate(-1).getDateFormat();
  391. ds_send.setColumn( 0, "fromdd", fromdd);
  392. ds_send.setColumn( 0, "todd", fromdd);
  393. fSetColWidth("", false);
  394. }
  395. function btn_search_onclick(obj:Button, e:ClickEventInfo) {
  396. ds_main_complist_compinfo.clearData();
  397. var oParam = {};
  398. oParam.id = "TRPAE00202";
  399. oParam.service = "pamendstatsapp.PamEndStats";
  400. oParam.method = "reqGetRcptCompareList";
  401. oParam.inds = "req=ds_send";
  402. oParam.outds = "ds_main_complist_compinfo=compinfo";
  403. oParam.async = false;
  404. tranf_submit(oParam);
  405. ds_main_complist_compinfo.addColumn('newTotbgColor', 'string');
  406. ds_main_complist_compinfo.addColumn('newTotColor', 'string');
  407. ds_main_complist_compinfo.addColumn('newTotFont', 'string');
  408. ds_main_complist_compinfo.addColumn('rcptrnmbgColor', 'string');
  409. ds_main_complist_compinfo.addColumn('rcptrnmFont', 'string');
  410. ds_main_complist_compinfo.addColumn('oldTotbgColor', 'string');
  411. ds_main_complist_compinfo.addColumn('oldTotColor', 'string');
  412. ds_main_complist_compinfo.addColumn('oldTotFont', 'string');
  413. ds_main_complist_compinfo.addColumn('cashDiffbgColor', 'string');
  414. ds_main_complist_compinfo.addColumn('cashDiffColor', 'string');
  415. ds_main_complist_compinfo.addColumn('cashDiffFont', 'string');
  416. ds_main_complist_compinfo.addColumn('cardDiffbgColor', 'string');
  417. ds_main_complist_compinfo.addColumn('cardDiffColor', 'string');
  418. ds_main_complist_compinfo.addColumn('cardDiffFont', 'string');
  419. ds_main_complist_compinfo.addColumn('onlineDiffbgColor', 'string');
  420. ds_main_complist_compinfo.addColumn('onlineDiffColor', 'string');
  421. ds_main_complist_compinfo.addColumn('onlineDiffFont', 'string');
  422. ds_main_complist_compinfo.addColumn('uncoDiffbgColor', 'string');
  423. ds_main_complist_compinfo.addColumn('uncoDiffColor', 'string');
  424. ds_main_complist_compinfo.addColumn('uncoDiffFont', 'string');
  425. fSetCompflag();
  426. }
  427. function btn_xls_onclick(obj:Button, e:ClickEventInfo) {
  428. // var file = window.fileDialog("save", "", "false", "수납자별 마감금액비교", "xls", "Excel Files(*.xls)|*.xls");
  429. // grd_rcptlist.saveExcel(file);
  430. grdf_exportExcel(grd_rcptlist, "수납자별 마감금액비교", "Sheet1", true, "" , 'user' , true);
  431. }
  432. function grp_chk_compflag_onclick(obj:CheckBox, e:ClickEventInfo)
  433. {
  434. fSetCompflag();
  435. }
  436. function grp_chk_cashflag_onclick(obj:CheckBox, e:ClickEventInfo)
  437. {
  438. fSetCompflag();
  439. }
  440. function grd_comp_onheaddblclick(obj:Grid, e:GridClickEventInfo)
  441. {
  442. var amt = "";
  443. var expand = true;
  444. // cash_out ~ cash_sum
  445. if (e.col >= 12 && e.col <= 15) {
  446. amt = "cash";
  447. expand = (grd_comp.getFormatColProperty(13, "size") > 0 ? false : true);
  448. }
  449. // card_out ~ card_sum
  450. else if (e.col >= 16 && e.col <= 19) {
  451. amt = "card";
  452. expand = (grd_comp.getFormatColProperty(17, "size") > 0 ? false : true);
  453. }
  454. // online_out ~ online_sum
  455. else if (e.col >= 20 && e.col <= 23) {
  456. amt = "online";
  457. expand = (grd_comp.getFormatColProperty(21, "size") > 0 ? false : true);
  458. }
  459. // unco_out ~ unco_sum
  460. else if (e.col >= 24 && e.col <= 27) {
  461. amt = "unco";
  462. expand = (grd_comp.getFormatColProperty(25, "size") > 0 ? false : true);
  463. }
  464. // old_tot
  465. else if (e.col == 11) {
  466. if (grd_comp.getFormatColProperty(13, "size") > 0 ||
  467. grd_comp.getFormatColProperty(17, "size") > 0 ||
  468. grd_comp.getFormatColProperty(21, "size") > 0 ||
  469. grd_comp.getFormatColProperty(25, "size") > 0) {
  470. expand = false;
  471. }
  472. else {
  473. expand = true;
  474. }
  475. fSetColWidth("", expand);
  476. }
  477. if (amt != "") {
  478. fSetColWidth(amt, expand);
  479. }
  480. }
  481. ]]></Script>
  482. </Form>
  483. </FDL>