SMPAS00530_카드집계현황.xfdl 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml" />
  4. <Form id="SMPAS00530" position="absolute 0 0 1211 784" titletext="카드집계현황" onload="SMPAS00530_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 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 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" 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. <Radio datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="radio1" position="absolute 480 10 620 30" style="align:center middle;">
  31. <Dataset id="innerdataset">
  32. <ColumnInfo>
  33. <Column id="codecolumn" />
  34. <Column id="datacolumn" />
  35. </ColumnInfo>
  36. <Rows>
  37. <Row>
  38. <Col id="codecolumn">%</Col>
  39. <Col id="datacolumn">전체</Col>
  40. </Row>
  41. <Row>
  42. <Col id="codecolumn">O</Col>
  43. <Col id="datacolumn">외래</Col>
  44. </Row>
  45. <Row>
  46. <Col id="codecolumn">I</Col>
  47. <Col id="datacolumn">입원</Col>
  48. </Row>
  49. </Rows>
  50. </Dataset>
  51. </Radio>
  52. </Layout>
  53. </Layouts>
  54. </Div>
  55. <Div id="grp_btn" scrollbars="autoboth" position="absolute 19 757 1199 784" style="" />
  56. <Button id="btn_init" class="btn4_letter3" position="absolute 1129 760 1197 782" style="" text="초기화" onclick="btn_init_onclick" />
  57. <Grid id="grd_card" binddataset="ds_main_h_card_card" position="absolute 5 65 1202 751" style="">
  58. <Formats>
  59. <Format id="default">
  60. <Columns>
  61. <Column size="134" />
  62. <Column size="150" />
  63. <Column size="140" />
  64. <Column size="200" />
  65. <Column size="139" />
  66. <Column size="200" />
  67. </Columns>
  68. <Rows>
  69. <Row size="24" band="head" />
  70. <Row size="24" />
  71. </Rows>
  72. <Band id="head">
  73. <Cell text="구분" />
  74. <Cell col="1" text="카드종류" />
  75. <Cell col="2" text="수납건수" />
  76. <Cell col="3" text="수납금액" />
  77. <Cell col="4" text="취소건수" />
  78. <Cell col="5" text="취소금액" />
  79. </Band>
  80. <Band id="body">
  81. <Cell text="bind:card_title" />
  82. <Cell col="1" text="bind:card_cardcmpycd" />
  83. <Cell col="2" text="bind:card_cnt_y" />
  84. <Cell col="3" text="bind:card_cardamt_y" />
  85. <Cell col="4" text="bind:card_cnt_c" />
  86. <Cell col="5" text="bind:card_cardamt_c" />
  87. </Band>
  88. </Format>
  89. </Formats>
  90. </Grid>
  91. </Layout>
  92. </Layouts>
  93. <Objects>
  94. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  95. <ColumnInfo />
  96. </Dataset>
  97. <Dataset id="ds_main_h_card_card" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  98. <ColumnInfo>
  99. <Column id="card_title" type="STRING" size="256" />
  100. <Column id="card_cardcmpycd" type="STRING" size="256" />
  101. <Column id="card_cnt_y" type="STRING" size="256" />
  102. <Column id="card_cardamt_y" type="STRING" size="256" />
  103. <Column id="card_cnt_c" type="STRING" size="256" />
  104. <Column id="card_cardamt_c" type="STRING" size="256" />
  105. </ColumnInfo>
  106. <Rows>
  107. <Row>
  108. <Col id="card_title"></Col>
  109. <Col id="card_cardcmpycd"></Col>
  110. <Col id="card_cnt_y"></Col>
  111. <Col id="card_cardamt_y"></Col>
  112. <Col id="card_cnt_c"></Col>
  113. <Col id="card_cardamt_c"></Col>
  114. </Row>
  115. </Rows>
  116. </Dataset>
  117. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  118. <ColumnInfo />
  119. </Dataset>
  120. <Dataset id="ds_send_data1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  121. <ColumnInfo>
  122. <Column id="fromdd" type="STRING" size="256" />
  123. <Column id="tm_from" type="STRING" size="256" />
  124. <Column id="tm_to" type="STRING" size="256" />
  125. <Column id="rcpt_id" type="STRING" size="256" />
  126. <Column id="ordtype" type="STRING" size="256" />
  127. </ColumnInfo>
  128. <Rows>
  129. <Row>
  130. <Col id="fromdd"></Col>
  131. <Col id="tm_from"></Col>
  132. <Col id="tm_to"></Col>
  133. <Col id="rcpt_id"></Col>
  134. <Col id="ordtype"></Col>
  135. </Row>
  136. </Rows>
  137. </Dataset>
  138. <Dataset id="ds_main_h_card" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  139. <ColumnInfo />
  140. </Dataset>
  141. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  142. <ColumnInfo />
  143. </Dataset>
  144. <Dataset id="ds_hidden_session" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  145. <ColumnInfo>
  146. <Column id="userid" type="STRING" size="256" />
  147. <Column id="usernm" type="STRING" size="256" />
  148. <Column id="posinstcd" type="STRING" size="256" />
  149. <Column id="posinstnm" type="STRING" size="256" />
  150. <Column id="dutplcecd" type="STRING" size="256" />
  151. <Column id="dutplcenm" type="STRING" size="256" />
  152. <Column id="dutinstnm" type="STRING" size="256" />
  153. </ColumnInfo>
  154. </Dataset>
  155. </Objects>
  156. <Bind>
  157. <BindItem id="item0" compid="group2.input7" propid="value" datasetid="ds_send_data1" columnid="fromdd" />
  158. <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_send_data1" columnid="tm_from" />
  159. <BindItem id="item2" compid="group2.input15" propid="value" datasetid="ds_send_data1" columnid="tm_to" />
  160. <BindItem id="item3" compid="group2.input2" propid="value" datasetid="ds_send_data1" columnid="rcpt_id" />
  161. <BindItem id="item4" compid="group2.radio1" propid="value" datasetid="ds_send_data1" columnid="ordtype" />
  162. </Bind>
  163. <Script type="xscript4.0"><![CDATA[function SMPAS00530_onload(obj:Form, e:LoadEventInfo) {
  164. frmf_initForm(obj);
  165. //grdf_initGrid(grd_XXX);
  166. //grdf_setGridSort(grd_XXX);
  167. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  168. makeReportPreview(0,0,0,0,"");
  169. fInitialize();
  170. fGetUserInfo2();
  171. }
  172. include '../../.._com_commonweb_js_common.js'
  173. include '../../.._com_commonweb_js_utilHelper.js'
  174. include '../../.._com_commonweb_js_tfHelper.js'
  175. include '../../.._com_commonweb_js_dateHelper.js'
  176. include '../../.._com_commonweb_js_numericHelper.js'
  177. include '../../.._com_commonweb_js_stringHelper.js'
  178. include '../../.._com_basiccodeweb_js_ZBC001.js'
  179. include '../../.._com_zipcodeweb_js_ZBP001.js'
  180. //로그인한 사용자 정보조회
  181. function fGetUserInfo2(){
  182. var sUserInfosS = getUserInfos();
  183. sUserInfosS = sUserInfosS + "|";
  184. //alert("sUserInfosS : " + sUserInfosS);
  185. var UserInfosS_Array = sUserInfosS.split("|");
  186. var userid = UserInfosS_Array[0]; //사용자번호
  187. var usernm = UserInfosS_Array[1]; //사용자이름
  188. var posinstcd = UserInfosS_Array[2]; //소속기관코드
  189. var posinstnm = UserInfosS_Array[3]; //소속기관명
  190. var dutplcecd = UserInfosS_Array[4]; //근무지부서코드
  191. var dutplcenm = UserInfosS_Array[5]; //근무지부서명
  192. var dutinstnm = UserInfosS_Array[7]; //근무지기관명
  193. /*
  194. model.makeNode("ds_hidden_session/" + "userid");
  195. model.makeNode("ds_hidden_session/" + "usernm");
  196. model.makeNode("ds_hidden_session/" + "posinstcd");
  197. model.makeNode("ds_hidden_session/" + "posinstnm");
  198. model.makeNode("ds_hidden_session/" + "dutplcecd");
  199. model.makeNode("ds_hidden_session/" + "dutplcenm");
  200. model.makeNode("ds_hidden_session/" + "dutinstnm");
  201. */
  202. ds_hidden_session.setColumn( 0, "userid",userid);
  203. ds_hidden_session.setColumn( 0, "usernm",usernm);
  204. ds_hidden_session.setColumn( 0, "posinstcd",posinstcd);
  205. ds_hidden_session.setColumn( 0, "posinstnm",posinstnm);
  206. ds_hidden_session.setColumn( 0, "dutplcecd",dutplcecd);
  207. ds_hidden_session.setColumn( 0, "dutplcenm",dutplcenm);
  208. ds_hidden_session.setColumn( 0, "dutinstnm",dutinstnm);
  209. }
  210. function fInitialize() {
  211. ds_main_h_card_card.clearData();
  212. ds_send_data1.setColumn( 0, "fromdd", utlf_getCurrentDate()); // common.js에서 제공하는 함수를 사용하여 오늘 날짜를 구한다.
  213. ds_send_data1.setColumn( 0, "tm_from", "0000");
  214. ds_send_data1.setColumn( 0, "tm_to", "2400");
  215. ds_send_data1.setColumn( 0, "rcpt_id", "");
  216. ds_send_data1.setColumn( 0, "ordtype", "%");
  217. //model.refresh();
  218. }
  219. function group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {
  220. // submit("TRPAS00531");
  221. grd_card.subtotalPosition = "below";
  222. grd_card.subtotal("sum", -1, 2, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 0, "합계", false);
  223. grd_card.subtotal("sum", -1, 3, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 0, "합계", false);
  224. grd_card.subtotal("sum", -1, 4, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 0, "합계", false);
  225. grd_card.subtotal("sum", -1, 5, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 0, "합계", false);
  226. //model.refresh();
  227. }
  228. function group2_button95_onclick(obj:Button, e:ClickEventInfo) {
  229. var vToday = new Date();
  230. var tmpYear = vToday.getYear();
  231. var tmpMonth = vToday.getMonth()+1;
  232. var tmpDate = vToday.getDate();
  233. //
  234. // ds_documenttitle.setColumn( 0, "title",document.title);
  235. //
  236. //model.refresh();
  237. // var subjectTitle = ds_documenttitle.getColumn(0, "title");
  238. //엑셀저장 여부(타이틀별)
  239. var fileName = window.fileDialog("save", "", false, "카드집계현황"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  240. if (fileName != "")
  241. {
  242. grd_card.saveExcel(fileName, "카드집계현황"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
  243. }
  244. }
  245. function group2_btn_print_onclick(obj:Button, e:ClickEventInfo) {
  246. exeReportPreview("RPPAS00531", "XMLSTR", "", "", "true", "", "", "", "", "","", "", "", "", "", "1", "");
  247. //exeReportPreview("RPPAS01711", "XMLSTR", "", "", "true", "", "", "", "", "","", "case2", "", "", "", "1", "75");
  248. }
  249. function btn_init_onclick(obj:Button, e:ClickEventInfo) {
  250. fInitialize();
  251. }
  252. ]]></Script>
  253. </Form>
  254. </FDL>