SPPIF30401_지급보류관리.xfdl 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPPIF30401" position="absolute 0 0 1107 673" titletext="지급보류관리" oninit="SPPIF30401_oninit" onload="SPPIF30401_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 0 1100 640" id="group3" scrollbars="autoboth">
  8. <Layouts>
  9. <Layout>
  10. <Shape position="absolute 0 26 1100 32" linetype="horizontal" id="line8" class="line_1" style="strokepen:3 solid #33bbbbff;"/>
  11. <Static text="지급보류관리" position="absolute 1 10 137 32" id="caption4" class="tit_2"/>
  12. <Grid position="absolute 0 31 1100 636" id="grd_pifmmiun" class="datagrid2" binddataset="ds_main_pifmmiun" cellmovingtype="col" cellsizingtype="col">
  13. <Formats>
  14. <Format id="default">
  15. <Columns>
  16. <Column size="25"/>
  17. <Column size="34"/>
  18. <Column size="40"/>
  19. <Column size="50"/>
  20. <Column size="60"/>
  21. <Column size="50"/>
  22. <Column size="80"/>
  23. <Column size="80"/>
  24. <Column size="80"/>
  25. <Column size="80"/>
  26. <Column size="80"/>
  27. <Column size="70"/>
  28. <Column size="110"/>
  29. <Column size="80"/>
  30. <Column size="80"/>
  31. <Column size="80"/>
  32. <Column size="80"/>
  33. <Column size="80"/>
  34. <Column size="60"/>
  35. <Column size="0"/>
  36. <Column size="0"/>
  37. <Column size="0"/>
  38. <Column size="0"/>
  39. <Column size="0"/>
  40. </Columns>
  41. <Rows>
  42. <Row size="29" band="head"/>
  43. <Row size="24"/>
  44. </Rows>
  45. <Band id="head">
  46. <Cell/>
  47. <Cell col="1" text="선택"/>
  48. <Cell col="2" text="입금&#10;여부"/>
  49. <Cell col="3" text="명일련"/>
  50. <Cell col="4" text="등록번호"/>
  51. <Cell col="5" text="수진자"/>
  52. <Cell col="6" text="청구액"/>
  53. <Cell col="7" text="심결&#10;장애인기금"/>
  54. <Cell col="8" text="장애인전환금"/>
  55. <Cell col="9" text="기관삭감액"/>
  56. <Cell col="10" text="심사결정액"/>
  57. <Cell col="11" text="심결입금&#10;기관기호"/>
  58. <Cell col="12" text="기관명"/>
  59. <Cell col="13" text="장애인잔액"/>
  60. <Cell col="14" text="장애인입금액"/>
  61. <Cell col="15" text="대불금"/>
  62. <Cell col="16" text="대불입금액"/>
  63. <Cell col="17" text="심결입금액"/>
  64. <Cell col="18" text="심결구분"/>
  65. <Cell col="19" text="caption1"/>
  66. <Cell col="20"/>
  67. <Cell col="21"/>
  68. <Cell col="22"/>
  69. <Cell col="23"/>
  70. </Band>
  71. <Band id="body">
  72. <Cell celltype="head"/>
  73. <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:choice" expr="expr:choice == 'Y' || choice == '1' ? 1 : 0"/>
  74. <Cell col="2" text="bind:depoyn"/>
  75. <Cell col="3" text="bind:docuseqno"/>
  76. <Cell col="4" text="bind:pid"/>
  77. <Cell col="5" text="bind:patnm"/>
  78. <Cell col="6" displaytype="number" edittype="normal" style="align:right middle;" text="bind:clamamt"/>
  79. <Cell col="7" displaytype="number" edittype="normal" style="align:right middle;" text="bind:jrhandicaprfund"/>
  80. <Cell col="8" displaytype="number" edittype="normal" style="align:right middle;background:EXPR(!utlf_isNull(handicapcvrtamt) ? '#ffff00' : '#ffffff');background2:EXPR(!utlf_isNull(handicapcvrtamt) ? '#ffff00' : '#ffffff');" text="bind:handicapcvrtamt"/>
  81. <Cell col="9" displaytype="number" edittype="normal" style="align:right middle;background:EXPR(!utlf_isNull(instreductamt)? '#ffff00' : '#ffffff');background2:EXPR(!utlf_isNull(instreductamt)? '#ffff00' : '#ffffff');" text="bind:instreductamt"/>
  82. <Cell col="10" displaytype="none" edittype="none" text="bind:jrjudgdeciamt"/>
  83. <Cell col="11" text="bind:jrprocinstmark"/>
  84. <Cell col="12" text="bind:jrprocinstmarknm"/>
  85. <Cell col="13" displaytype="number" edittype="normal" style="align:right middle;" text="bind:remainamt"/>
  86. <Cell col="14" displaytype="number" edittype="normal" style="align:right middle;" text="bind:handicapdepoamt"/>
  87. <Cell col="15" displaytype="number" edittype="normal" style="align:right middle;" text="bind:subtamt"/>
  88. <Cell col="16" displaytype="number" edittype="normal" style="align:right middle;" text="bind:subtdepoamt"/>
  89. <Cell col="17" displaytype="number" edittype="normal" style="align:right middle;" text="bind:jrdepoamt"/>
  90. <Cell col="18" displaytype="combo" edittype="combo" text="bind:decotretflag"/>
  91. <Cell col="19" text="bind:clamym"/>
  92. <Cell col="20" text="bind:clamdg"/>
  93. <Cell col="21" text="bind:pidsn"/>
  94. <Cell col="22" text="bind:decoseq"/>
  95. <Cell col="23" text="bind:inddepoflag"/>
  96. </Band>
  97. </Format>
  98. </Formats>
  99. </Grid>
  100. <Button position="absolute 888 7 952 26" id="button1" class="btn2" text="전체선택" onclick="group3_button1_onclick"/>
  101. <Button position="absolute 954 7 1018 26" id="button2" class="btn2" text="전체해제" onclick="group3_button2_onclick"/>
  102. </Layout>
  103. </Layouts>
  104. </Div>
  105. <Div position="absolute 0 639 1100 666" id="group1" scrollbars="autoboth">
  106. <Layouts>
  107. <Layout>
  108. <Button position="absolute 1044 3 1100 25" id="btn_cancel" class="btn4" text="닫기" onclick="group1_btn_cancel_onclick" anchor="default"/>
  109. <Button position="absolute 943 4 985 23" id="button3" class="btn5" text="저장" onclick="group1_button3_onclick" anchor="default"/>
  110. <Static text="명일련 추가" position="absolute 15 4 115 21" id="caption1" class="search_name" anchor="default"/>
  111. <Button position="absolute 888 4 941 23" id="button5" class="btn5" text="행삭제" onclick="group1_button5_onclick" anchor="default"/>
  112. <Button position="absolute 987 3 1043 25" id="button6" class="btn4" text="확인" onclick="group1_button6_onclick" anchor="default"/>
  113. <Static text="(명일련 추가 후 추가할 데이터가 맞으면 저장버튼을, 틀리면 체크박스 체크 후 행삭제 버튼을 클릭하세요.)" position="absolute 225 5 801 25" id="caption2" style="color:#ff6600ff;" anchor="default"/>
  114. <Edit id="ipt_docuseqno" taborder="1" class="input_search" position="absolute 109 0 210 24" onkeyup="group1_ipt_docuseqno_onkeyup" onkeydown="group1_ipt_docuseqno_onkeydown" anchor="default"/>
  115. </Layout>
  116. </Layouts>
  117. </Div>
  118. <Button position="absolute 1020 7 1100 26" id="button4" class="btn7" text="엑셀저장" onclick="button4_onclick"/>
  119. </Layout>
  120. </Layouts>
  121. <Objects>
  122. <Dataset id="ds_main_pifmmiun" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false" oncolumnchanged="ds_main_pifmmiun_oncolumnchanged">
  123. <ColumnInfo>
  124. <Column id="choice" type="STRING"/>
  125. <Column id="depoyn" type="STRING"/>
  126. <Column id="docuseqno" type="STRING"/>
  127. <Column id="pid" type="STRING"/>
  128. <Column id="patnm" type="STRING"/>
  129. <Column id="clamamt" type="STRING"/>
  130. <Column id="jrhandicaprfund" type="STRING"/>
  131. <Column id="handicapcvrtamt" type="STRING"/>
  132. <Column id="instreductamt" type="STRING"/>
  133. <Column id="jrjudgdeciamt" type="STRING"/>
  134. <Column id="jrprocinstmark" type="STRING"/>
  135. <Column id="jrprocinstmarknm" type="STRING"/>
  136. <Column id="remainamt" type="STRING"/>
  137. <Column id="handicapdepoamt" type="STRING"/>
  138. <Column id="subtamt" type="STRING"/>
  139. <Column id="subtdepoamt" type="STRING"/>
  140. <Column id="jrdepoamt" type="STRING"/>
  141. <Column id="decotretflag" type="STRING"/>
  142. <Column id="clamym" type="STRING"/>
  143. <Column id="clamdg" type="STRING"/>
  144. <Column id="pidsn" type="STRING"/>
  145. <Column id="decoseq" type="STRING"/>
  146. <Column id="inddepoflag" type="STRING"/>
  147. </ColumnInfo>
  148. </Dataset>
  149. <Dataset id="ds_init_P0407list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  150. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  151. <ColumnInfo>
  152. <Column id="clamym" type="STRING" size="256"/>
  153. <Column id="clamdd" type="STRING" size="256"/>
  154. <Column id="acptno" type="STRING" size="256"/>
  155. <Column id="judgdg" type="STRING" size="256"/>
  156. <Column id="clamno" type="STRING" size="256"/>
  157. <Column id="cpcd" type="STRING" size="256"/>
  158. <Column id="assocd" type="STRING" size="256"/>
  159. <Column id="docuseqno" type="STRING" size="256"/>
  160. </ColumnInfo>
  161. <Rows>
  162. <Row>
  163. <Col id="clamym"/>
  164. <Col id="clamdd"/>
  165. <Col id="acptno"/>
  166. <Col id="judgdg"/>
  167. <Col id="clamno"/>
  168. <Col id="cpcd"/>
  169. <Col id="assocd"/>
  170. </Row>
  171. </Rows>
  172. </Dataset>
  173. <Dataset id="ds_tmp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  174. <Dataset id="ds_init_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  175. <ColumnInfo>
  176. <Column id="docuseqno" type="STRING" size="256"/>
  177. </ColumnInfo>
  178. </Dataset>
  179. </Objects>
  180. <Bind>
  181. <BindItem id="item0" compid="group1.ipt_docuseqno" propid="value" datasetid="ds_send_send01" columnid="acptno"/>
  182. </Bind>
  183. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  184. * System Name :
  185. * Job Name :
  186. * Creator :
  187. * Make Date : 2016-05-24
  188. * Description :
  189. *---------------------------------------------------------------------------------------
  190. * Modify Date Modifier Modify Description
  191. *---------------------------------------------------------------------------------------
  192. * 2016-05-24 Live Converter TF->XP
  193. *
  194. *---------------------------------------------------------------------------------------
  195. ****************************************************************************************/
  196. include "com_commonxp::comm_main.xjs";
  197. include "pam_pamcomnxp::PAM001.xjs";
  198. include "pam_pamcomnxp::PAM.xjs";
  199. function SPPIF30401_oninit(obj:Form, e:InitEventInfo)
  200. {
  201. frmf_initForm(obj);
  202. }
  203. function SPPIF30401_onload(obj:Form, e:LoadEventInfo)
  204. {
  205. grdf_initGrid(group3.grd_pifmmiun);
  206. grdf_setRowTypeIcon(group3.grd_pifmmiun, 0);
  207. ds_tmp.copyData(arg_ds_send);
  208. ds_send.setColumn(0, "acptno", ds_tmp.getColumn(0, "acptno"));
  209. ds_send.setColumn(0, "judgdg", ds_tmp.getColumn(0, "judgdg"));
  210. ds_send.setColumn(0, "clamno", ds_tmp.getColumn(0, "clamno"));
  211. ds_send.setColumn(0, "assocd", ds_tmp.getColumn(0, "assocd"));
  212. ds_send.setColumn(0, "cpcd", ds_tmp.getColumn(0, "cpcd"));
  213. var arrParam = [{dsNm: "ds_init_P0407list", cdGrpId: "P0407"}]
  214. appf_getCodeList(arrParam);
  215. pamGetDeptCDDrIDList();
  216. CommCode_Load();
  217. }
  218. function CommCode_Load()
  219. {
  220. var oParam = {};
  221. oParam.id = "TRPIF30408";
  222. oParam.service = "clamuncoapp.ClamUnco";
  223. oParam.method = "reqGetPayReteSpec";
  224. oParam.inds = "req=ds_send";
  225. oParam.outds = "ds_main_pifmmiun=gridpifmmiun";
  226. oParam.async = false;
  227. //oParam.callback = "cf_TRPIF30408";
  228. tranf_submit(oParam);
  229. var rows = ds_main_pifmmiun.rowcount;
  230. if(rows > 0)
  231. {
  232. for(var i = 0; i < rows; i++)
  233. {
  234. if(ds_main_pifmmiun.getColumn(i, "choice") == "Y")
  235. {
  236. group3.grd_pifmmiun.setCellProperty("Body", 0, "edittype", "none");
  237. group3.grd_pifmmiun.setCellProperty("Body", 8, "edittype", "nomal");
  238. group3.grd_pifmmiun.setCellProperty("Body", 9, "edittype" ,"nomal");
  239. }
  240. else
  241. {
  242. group3.grd_pifmmiun.setCellProperty("Body", 8, "edittype", "none");
  243. group3.grd_pifmmiun.setCellProperty("Body", 9, "edittype" ,"none");
  244. }
  245. }
  246. }
  247. // grd_pifmmiun.colStyle(8,"data","background-color") = "#ffff00";
  248. // grd_pifmmiun.colStyle(9,"data","background-color") = "#ffff00";
  249. }
  250. function group3_button1_onclick(obj:Button, e:ClickEventInfo)
  251. {
  252. var rows = ds_main_pifmmiun.rowcount;
  253. for(var i = 0; i < rows; i++)
  254. {
  255. if(ds_main_pifmmiun.getColumn(i, "choice") == "Y")
  256. {
  257. continue;
  258. }
  259. else
  260. {
  261. ds_main_pifmmiun.setColumn(i, "choice", "Y");
  262. group3.grd_pifmmiun.setCellProperty("Body", 8, "edittype", "nomal");
  263. group3.grd_pifmmiun.setCellProperty("Body", 9, "edittype" ,"nomal");
  264. grdf_setStatus(group3.grd_pifmmiun, "U", i);
  265. }
  266. }
  267. }
  268. function group3_button2_onclick(obj:Button, e:ClickEventInfo)
  269. {
  270. var rows = ds_main_pifmmiun.rowcount;
  271. for(var i = 0; i < rows; i++)
  272. {
  273. if(ds_main_pifmmiun.getColumn(i, "choice") == "N" || ds_main_pifmmiun.getRowType(i) == "2")
  274. {
  275. continue;
  276. }
  277. else
  278. {
  279. ds_main_pifmmiun.setColumn(i, "choice", "N");
  280. grdf_setStatus(group3.grd_pifmmiun, "U", i);
  281. ds_main_pifmmiun.setColumn(i, "handicapcvrtamt", "0");
  282. ds_main_pifmmiun.setColumn(i, "instreductamt", "0");
  283. group3.grd_pifmmiun.setCellProperty("Body", 8, "edittype", "none");
  284. group3.grd_pifmmiun.setCellProperty("Body", 9, "edittype" ,"none");
  285. }
  286. }
  287. }
  288. function button4_onclick(obj:Button, e:ClickEventInfo)
  289. {
  290. var today = new Date();
  291. var yy = today.getYear()+"";
  292. var mm = today.getMonth()+1;
  293. var dd = today.getDate();
  294. if(mm < 10)
  295. {
  296. mm = "0" + mm;
  297. }
  298. else
  299. {
  300. mm = mm + "";
  301. }
  302. if(dd < 10)
  303. {
  304. dd = "0" + dd;
  305. }
  306. else
  307. {
  308. dd = dd + "";
  309. }
  310. var tmp = yy + mm + dd;
  311. if (ds_main_pifmmiun.rowcount > 0)
  312. {
  313. grdf_exportExcel(group3.grd_pifmmiun, "지급보류관리_"+tmp, "see");
  314. }
  315. else
  316. {
  317. sysf_messageBox("엑셀저장할 내역이", "I004");
  318. }
  319. }
  320. function group1_button5_onclick(obj:Button, e:ClickEventInfo)
  321. {
  322. var rows = ds_main_pifmmiun.rowcount;
  323. for(var i = 0; i < rows; i++)
  324. {
  325. if(ds_main_pifmmiun.getColumn(i, "choice") == "Y")
  326. {
  327. ds_main_pifmmiun.deleteRow(i);
  328. }
  329. }
  330. }
  331. function group1_button3_onclick(obj:Button, e:ClickEventInfo)
  332. {
  333. var rows = ds_main_pifmmiun.rowcount;
  334. var cnt = 0;
  335. for(var i = 0; i < rows; i++)
  336. {
  337. if(ds_main_pifmmiun.getRowType(i) == "4")
  338. {
  339. cnt++;
  340. }
  341. }
  342. if(cnt > 0)
  343. {
  344. var oParam = {};
  345. oParam.id = "TXPIF30403";
  346. oParam.service = "clamuncoapp.ClamUnco";
  347. oParam.method = "reqSetPifmmiun";
  348. oParam.inds = "req=ds_main_pifmmiun:U";
  349. oParam.outds = "";
  350. oParam.async = false;
  351. oParam.callback = "cf_TXPIF30403";
  352. tranf_submit(oParam);
  353. }
  354. }
  355. function cf_TXPIF30403()
  356. {
  357. CommCode_Load();
  358. }
  359. function group1_button6_onclick(obj:Button, e:ClickEventInfo)
  360. {
  361. var rows = ds_main_pifmmiun.rowcount;
  362. var cnt = 0;
  363. var handicaprfund = 0;
  364. var handicapcvrtamt = 0;
  365. var instreductamt = 0;
  366. var totsum = 0;
  367. for(var i = 0; i < rows; i++)
  368. {
  369. if(ds_main_pifmmiun.getRowType(i) == "4")
  370. {
  371. cnt++;
  372. totsum = eval(totsum) + eval(ds_main_pifmmiun.getColumn(i, "jrjudgdeciamt"));
  373. ds_main_pifmmiun.setColumn(i, "inddepoflag", "09");
  374. }
  375. }
  376. if(cnt > 0)
  377. {
  378. var copyds = grdf_getGridUpdateData(group3.grd_pifmmiun,"update");
  379. opener.ds_main_list02_gridpifmidep.copyData(copyds);
  380. opener.ds_main_gridpifhmcdp.setColumn(ds_tmp.getColumn(0, "opn_row"), "depocnt", cnt);
  381. opener.ds_main_gridpifhmcdp.setColumn(ds_tmp.getColumn(0, "opn_row"), "depoamt", totsum);
  382. this.close();
  383. }
  384. }
  385. function group1_btn_cancel_onclick(obj:Button, e:ClickEventInfo)
  386. {
  387. this.close();
  388. }
  389. function group1_ipt_docuseqno_onkeyup(obj:Edit, e:KeyEventInfo)
  390. {
  391. if(e.keycode == 13)
  392. {
  393. var docuseqno = obj.value;
  394. if(docuseqno.length == 1)
  395. {
  396. docuseqno = "0000"+docuseqno;
  397. }
  398. if(docuseqno.length == 2)
  399. {
  400. docuseqno = "000"+docuseqno;
  401. }
  402. if(docuseqno.length == 3)
  403. {
  404. docuseqno = "00"+docuseqno;
  405. }
  406. if(docuseqno.length == 4)
  407. {
  408. docuseqno = "0"+docuseqno;
  409. }
  410. ds_send.setColumn(0, "docuseqno", docuseqno);
  411. var oParam = {};
  412. oParam.id = "TRPIF30409";
  413. oParam.service = "clamuncoapp.ClamUnco";
  414. oParam.method = "reqGetAddPayReteSpec";
  415. oParam.inds = "req=ds_send";
  416. oParam.outds = "ds_main_pifmmiun=gridpifmmiun";
  417. oParam.async = false;
  418. oParam.callback = "cf_TRPIF30409";
  419. tranf_submit(oParam);
  420. }
  421. }
  422. function cf_TRPIF30409()
  423. {
  424. if(!utlf_isNull(ds_main_pifmmiun.getColumn(0, "docuseqno")))
  425. {
  426. var row = ds_main_pifmmiun.addRow();
  427. var rows = ds_main_pifmmiun.rowcount;
  428. grdf_setStatus(group3.grd_pifmmiun, "U", row-1);
  429. }
  430. }
  431. function ds_main_pifmmiun_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  432. {
  433. if( e.columnid == "check" )
  434. {
  435. obj.setColumn(e.row, "check", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
  436. }
  437. }
  438. ]]></Script>
  439. </Form>
  440. </FDL>