SMPAS00170_신용카드수납현황.xfdl 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml" />
  4. <Form id="SMPAS00170" position="absolute 0 0 1211 784" titletext="신용카드수납현황" onload="SMPAS00170_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 183 14" style="font:돋움,,돋움;align: middle;" text="신용카드수납현황" />
  11. </Layout>
  12. </Layouts>
  13. </Div>
  14. <Div id="group2" position="absolute 4 22 1207 57" 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 15 9 213 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 70 8 190 27" style="" anchor="default" onkeydown="group2_input7_onkeydown" />
  22. <Calendar id="input1" class="input_default" taborder="7" position="absolute 215 8 335 27" style="" anchor="default" onkeydown="group2_input1_onkeydown" />
  23. <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="combo1" position="absolute 350 8 470 27" style="">
  24. <Dataset id="innerdataset">
  25. <ColumnInfo>
  26. <Column id="codecolumn" />
  27. <Column id="datacolumn" />
  28. </ColumnInfo>
  29. <Rows>
  30. <Row>
  31. <Col id="codecolumn">ALL</Col>
  32. <Col id="datacolumn">전체</Col>
  33. </Row>
  34. <Row>
  35. <Col id="codecolumn">I</Col>
  36. <Col id="datacolumn">입원</Col>
  37. </Row>
  38. <Row>
  39. <Col id="codecolumn">O</Col>
  40. <Col id="datacolumn">외래</Col>
  41. </Row>
  42. <Row>
  43. <Col id="codecolumn">K</Col>
  44. <Col id="datacolumn">외래무인</Col>
  45. </Row>
  46. <Row>
  47. <Col id="codecolumn">S</Col>
  48. <Col id="datacolumn">입원무인</Col>
  49. </Row>
  50. <Row>
  51. <Col id="codecolumn">KS</Col>
  52. <Col id="datacolumn">무인</Col>
  53. </Row>
  54. <Row>
  55. <Col id="codecolumn">H</Col>
  56. <Col id="datacolumn">건진</Col>
  57. </Row>
  58. <Row>
  59. <Col id="codecolumn">KO</Col>
  60. <Col id="datacolumn">외래+외래무인</Col>
  61. </Row>
  62. <Row>
  63. <Col id="codecolumn">SI</Col>
  64. <Col id="datacolumn">입원+입원무인</Col>
  65. </Row>
  66. <Row>
  67. <Col id="codecolumn">-</Col>
  68. <Col id="datacolumn">강제카드</Col>
  69. </Row>
  70. </Rows>
  71. </Dataset>
  72. </Combo>
  73. <Button id="button95" class="btn6_letter4" visible="false" position="absolute 971 7 1051 29" style="" text="액셀저장" onclick="group2_button95_onclick" />
  74. <Shape id="line1" class="line_4" linetype="vertical" position="absolute 1058 7 1061 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default" />
  75. <Button id="btn_print" class="btn6_letter2" position="absolute 1066 7 1122 29" style="" text="출력" onclick="group2_btn_print_onclick" />
  76. </Layout>
  77. </Layouts>
  78. </Div>
  79. <Grid id="datagrid4" binddataset="ds_main_conficardamtlist_conficardamtstats" position="absolute 3 69 1206 765" style="" oncelldblclick="datagrid4_oncelldblclick" onaftersort="datagrid4_onaftersort">
  80. <Formats>
  81. <Format id="default">
  82. <Columns>
  83. <Column size="230" />
  84. <Column size="230" />
  85. <Column size="230" />
  86. <Column size="230" />
  87. <Column size="230" />
  88. </Columns>
  89. <Rows>
  90. <Row size="24" band="head" />
  91. <Row size="24" />
  92. </Rows>
  93. <Band id="head">
  94. <Cell text="카드사" />
  95. <Cell col="1" text="건수" />
  96. <Cell col="2" text="결제액" />
  97. <Cell col="3" text="수수료" />
  98. <Cell col="4" text="실수령액" />
  99. </Band>
  100. <Band id="body">
  101. <Cell text="bind:cdnm" />
  102. <Cell col="1" text="bind:cardcmpycode" />
  103. <Cell col="2" text="bind:cardamt" />
  104. <Cell col="3" text="bind:coms" />
  105. <Cell col="4" text="bind:carddepoamt" />
  106. </Band>
  107. </Format>
  108. </Formats>
  109. </Grid>
  110. </Layout>
  111. </Layouts>
  112. <Objects>
  113. <Dataset id="ds_main_tmpinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  114. <ColumnInfo />
  115. </Dataset>
  116. <Dataset id="ds_main_tmpinfo_info" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  117. <ColumnInfo>
  118. <Column id="user" type="STRING" size="256" />
  119. </ColumnInfo>
  120. <Rows>
  121. <Row>
  122. <Col id="user"></Col>
  123. </Row>
  124. </Rows>
  125. </Dataset>
  126. <Dataset id="ds_main_conficardamtlist_conficardamtstats" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  127. <ColumnInfo>
  128. <Column id="cdnm" type="STRING" size="256" />
  129. <Column id="cardcmpycode" type="STRING" size="256" />
  130. <Column id="cardamt" type="STRING" size="256" />
  131. <Column id="coms" type="STRING" size="256" />
  132. <Column id="carddepoamt" type="STRING" size="256" />
  133. <Column id="banhwan" type="STRING" size="256" />
  134. <Column id="cardcmpycd" type="STRING" size="256" />
  135. </ColumnInfo>
  136. <Rows>
  137. <Row>
  138. <Col id="cdnm"></Col>
  139. <Col id="cardcmpycode"></Col>
  140. <Col id="cardamt"></Col>
  141. <Col id="coms"></Col>
  142. <Col id="carddepoamt"></Col>
  143. <Col id="banhwan"></Col>
  144. <Col id="cardcmpycd"></Col>
  145. </Row>
  146. </Rows>
  147. </Dataset>
  148. <Dataset id="ds_main_confisumamtlist_confisumamtstats" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  149. <ColumnInfo>
  150. <Column id="cdnm" type="STRING" size="256" />
  151. <Column id="cardcmpycode" type="STRING" size="256" />
  152. <Column id="cardamt" type="STRING" size="256" />
  153. <Column id="coms" type="STRING" size="256" />
  154. <Column id="carddepoamt" type="STRING" size="256" />
  155. <Column id="banhwan" type="STRING" size="256" />
  156. <Column id="cardcmpycd" type="STRING" size="256" />
  157. </ColumnInfo>
  158. <Rows>
  159. <Row>
  160. <Col id="cdnm">합 계</Col>
  161. <Col id="cardcmpycode"></Col>
  162. <Col id="cardamt"></Col>
  163. <Col id="coms"></Col>
  164. <Col id="carddepoamt"></Col>
  165. <Col id="banhwan"></Col>
  166. <Col id="cardcmpycd"></Col>
  167. </Row>
  168. </Rows>
  169. </Dataset>
  170. <Dataset id="ds_main_conficardamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  171. <ColumnInfo />
  172. </Dataset>
  173. <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  174. <ColumnInfo>
  175. <Column id="fromdata" type="STRING" size="256" />
  176. <Column id="todata" type="STRING" size="256" />
  177. <Column id="datagubun" type="STRING" size="256" />
  178. <Column id="erdata" type="STRING" size="256" />
  179. <Column id="dcgubun" type="STRING" size="256" />
  180. <Column id="noperchk" type="STRING" size="256" />
  181. </ColumnInfo>
  182. <Rows>
  183. <Row>
  184. <Col id="fromdata"></Col>
  185. <Col id="todata"></Col>
  186. <Col id="datagubun">ALL</Col>
  187. <Col id="erdata">1</Col>
  188. <Col id="dcgubun">D</Col>
  189. <Col id="noperchk"></Col>
  190. </Row>
  191. </Rows>
  192. </Dataset>
  193. <Dataset id="ds_main_confisumamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  194. <ColumnInfo />
  195. </Dataset>
  196. <Dataset id="ds_init_PAM_P0008list_P0008" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  197. <ColumnInfo>
  198. <Column id="cdnm" type="STRING" size="256" />
  199. <Column id="cdid" type="STRING" size="256" />
  200. <Column id="detl" type="STRING" size="256" />
  201. </ColumnInfo>
  202. </Dataset>
  203. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  204. <ColumnInfo />
  205. </Dataset>
  206. <Dataset id="ds_init_PAM_P0008list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  207. <ColumnInfo />
  208. </Dataset>
  209. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  210. <ColumnInfo />
  211. </Dataset>
  212. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  213. <ColumnInfo>
  214. <Column id="fromdata" type="STRING" size="256" />
  215. <Column id="todata" type="STRING" size="256" />
  216. <Column id="datagubun" type="STRING" size="256" />
  217. <Column id="erdata" type="STRING" size="256" />
  218. <Column id="dcgubun" type="STRING" size="256" />
  219. <Column id="datalabel" type="STRING" size="256" />
  220. <Column id="noperchk" type="STRING" size="256" />
  221. </ColumnInfo>
  222. <Rows>
  223. <Row>
  224. <Col id="fromdata"></Col>
  225. <Col id="todata"></Col>
  226. <Col id="datagubun"></Col>
  227. <Col id="erdata"></Col>
  228. <Col id="dcgubun"></Col>
  229. <Col id="datalabel"></Col>
  230. <Col id="noperchk"></Col>
  231. </Row>
  232. </Rows>
  233. </Dataset>
  234. <Dataset id="ds_init_PAM" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  235. <ColumnInfo />
  236. </Dataset>
  237. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  238. <ColumnInfo>
  239. <Column id="session" type="STRING" size="256" />
  240. </ColumnInfo>
  241. <Rows>
  242. <Row>
  243. <Col id="session"></Col>
  244. </Row>
  245. </Rows>
  246. </Dataset>
  247. </Objects>
  248. <Bind>
  249. <BindItem id="item0" compid="group2.input7" propid="value" datasetid="ds_main_search" columnid="fromdata" />
  250. <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_main_search" columnid="todata" />
  251. <BindItem id="item2" compid="group2.combo1" propid="value" datasetid="ds_main_search" columnid="datagubun" />
  252. </Bind>
  253. <Script type="xscript4.0"><![CDATA[function SMPAS00170_onload(obj:Form, e:LoadEventInfo) {
  254. var arrParam = [ {dsNm: "ds_init_PAM_P0008list",
  255. cdGrpId: "P0008" } ];
  256. pamfGetCodeList(arrParam, );
  257. // submit("TRPAS00001");
  258. var vToday = new Date();
  259. var tmpYear = vToday.getYear();
  260. var tmpMonth = vToday.getMonth()+1;
  261. var tmpDate = vToday.getDate();
  262. if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
  263. if(tmpDate<10){tmpDate ="0"+tmpDate;}
  264. ds_main_search.setColumn( 0, "fromdata", tmpYear+""+tmpMonth+""+tmpDate);
  265. ds_main_search.setColumn( 0, "todata", tmpYear+""+tmpMonth+""+tmpDate);
  266. //Rexport에 출력날자를 보여주기위한 데이터 저장
  267. dsf_makeValue( ds_main_tmp_print, "date", "string", "" );
  268. ds_main_tmp_print_date.copyData(ds_main_search_fromdata);
  269. ds_main_tmp_print.setColumn( 0, "date", ds_main_search.getColumn(0, "fromdata"));
  270. //group2.input7.refresh();
  271. //group2.input1.refresh();
  272. datagrid4.explorerbar = "sort";
  273. }
  274. include '../../.._com_commonweb_js_common.js'
  275. include '../../.._com_commonweb_js_utilHelper.js'
  276. include '../../.._com_commonweb_js_tfHelper.js'
  277. include '../../.._com_commonweb_js_dateHelper.js'
  278. include '../../.._com_commonweb_js_numericHelper.js'
  279. include '../../.._com_commonweb_js_stringHelper.js'
  280. include '../../.._com_basiccodeweb_js_ZBC001.js'
  281. include '../../.._com_zipcodeweb_js_ZBP001.js'
  282. include '../../.._pam_pamcomnweb_js_PAM001.js'
  283. function group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {
  284. var fromdata = ds_main_search.getColumn(0, "fromdata");
  285. var todata = ds_main_search.getColumn(0, "todata");
  286. if(fromdata==""||fromdata==null){
  287. sysf_messageBox("시작일을 입력","E007");
  288. group2.input7.setFocus();
  289. return false;
  290. }
  291. if(todata==""|| todata==null){
  292. sysf_messageBox("끝일을 입력","E007");
  293. group2.input1.setFocus();
  294. return false;
  295. }
  296. if(fromdata > todata){
  297. sysf_messageBox("시작일이 끝일자보다 클수 ", "C001")
  298. return false;
  299. }else{
  300. ds_send.setColumn( 0, "fromdata",ds_main_search.getColumn(0, "fromdata"));
  301. ds_send.setColumn( 0, "todata",ds_main_search.getColumn(0, "todata"));
  302. ds_send.setColumn( 0, "datagubun",ds_main_search.getColumn(0, "datagubun"));
  303. ds_main_conficardamtlist.clearData();
  304. // submit("TRPAS00161");
  305. var oParam = {};
  306. oParam.id = "TRPAS00161";
  307. oParam.service = "rcptteamstatsapp.rcptTeamOrdStats";
  308. oParam.method = "reqConfiCardamtList";
  309. oParam.inds = "req=ds_";
  310. oParam.outds = "ds_=conficardamtstats";
  311. oParam.async = false;
  312. oParam.callback = "cf_TRPAS00161";
  313. tranf_submit(oParam);
  314. /*
  315. function cf_TRPAS00161(sSvcId, nErrorCode, sErrorMsg) {
  316. if(nErrorCode < 0) return;
  317. }
  318. function cf_TRPAS00161(sSvcId, nErrorCode, sErrorMsg) {
  319. arErrorCode.push(sSvcId, nErrorCode);
  320. }
  321. arErrorCode.pop("TRPAS00161") > -1
  322. arErrorCode.pop("TRPAS00161") < 0
  323. */
  324. //로드값이 있을때 엑셀저장여부 버튼 생성여부
  325. var nodelist = bind1.nodeset;
  326. if(nodelist.length>0){
  327. group2.line1.visible =true;
  328. group2.button95.visible = true;
  329. }else{
  330. group2.line1.visible =false;
  331. group2.button95.visible = false;
  332. }
  333. ds_main_conficardamtlist_conficardamtstats.copyData(ds_main_confisumamtlist_confisumamtstats);
  334. datagrid4.rebuild();
  335. }
  336. }
  337. function group2_input7_onkeydown(obj:Calendar, e:KeyEventInfo) {
  338. if( event.keyCode == 13 ) {
  339. var pCurTargetObj = event.ptarget.parent;
  340. if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
  341. event.keyCode = 9;
  342. pCurTargetObj.dispatch("onkeydown");
  343. }
  344. else {
  345. event.keyCode = 9;
  346. }
  347. }
  348. event.stopPropagation();
  349. }
  350. function group2_input1_onkeydown(obj:Calendar, e:KeyEventInfo) {
  351. if( event.keyCode == 13 ) {
  352. var pCurTargetObj = event.ptarget.parent;
  353. if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
  354. event.keyCode = 9;
  355. pCurTargetObj.dispatch("onkeydown");
  356. }
  357. else {
  358. event.keyCode = 9;
  359. }
  360. }
  361. event.stopPropagation();
  362. }
  363. function group2_button95_onclick(obj:Button, e:ClickEventInfo) {
  364. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  365. if (fileName != "")
  366. {
  367. grdf_exportExcel(datagrid1, "Sheet1", fileName, false, "" , 'user' , true);
  368. }
  369. }
  370. function group2_btn_print_onclick(obj:Button, e:ClickEventInfo) {
  371. var objDOM = rptf_createDOM();
  372. var objParam = new Object();
  373. rptf_setNodeListToDOM(objDOM, "/root/XXX" , ds_XXX);
  374. objParam.xml_data_XML1 = objDOM.documentElement.source;
  375. var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
  376. rptf_exeReportPreview30(["RPPAS00161"],[objParam], option);
  377. }
  378. function datagrid4_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
  379. var row = datagrid4.row;
  380. var datagubun
  381. if ( ds_main_search.getColumn(0, "datagubun") == "ALL" ) {
  382. datagubun = "%";
  383. } else {
  384. datagubun = ds_main_search.getColumn(0, "datagubun");
  385. }
  386. var parm = ds_main_search.getColumn(0, "fromdata") + "▦" + //시작일자
  387. ds_main_search.getColumn(0, "todata") + "▦" + //종료일자
  388. datagubun + "▦" + //진료형태
  389. ds_main_conficardamtlist_conficardamtstats.getColumn(row, "cardcmpycd")) + "▦";
  390. frmf_setParameter("SPPAS00170_PARM", parm);
  391. frmf_modal("../../.._pam_rcptteamstatsweb_xrw_SPPAS00170", "SPPAS00170", ""-"", "", "1", "350", "350", "", "", "", "", "", "M");
  392. }
  393. function datagrid4_onaftersort {
  394. //sorting 시 인스턴스 구조를 재구성
  395. datagrid4.gridToInstance();
  396. }
  397. ]]></Script>
  398. </Form>
  399. </FDL>