SPPAS00723_미수발생입금조회.xfdl 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPPAS00723" position="absolute 0 0 1205 770" titletext="미수발생입금 조회" onload="SPPAS00723_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 23 1200 89" id="grp" class="div_SA" anchor="left top right">
  8. <Layouts>
  9. <Layout width="1206" height="67">
  10. <Button position="absolute 1125 10 1181 32" id="btn_search" class="btn1" text="조회" onclick="grp_btn_search_onclick" anchor="top right"/>
  11. <Shape position="absolute 1097 5 1103 62" linetype="vertical" id="line1" class="line_4" visible="true" anchor="top right"/>
  12. <Static text="미수기간 :" position="absolute 10 41 84 58" id="caption4" class="search_name" anchor="default"/>
  13. <Calendar position="absolute 90 40 195 59" id="input1" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" value="null" anchor="default"/>
  14. <Static text="~" position="absolute 203 42 214 57" align="align:center middle;" id="caption1" anchor="default"/>
  15. <Calendar position="absolute 222 40 327 59" id="input2" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" anchor="default"/>
  16. <Static text="미수구분 :" position="absolute 360 12 433 29" id="caption3" class="search_name" anchor="default"/>
  17. <Combo position="absolute 436 11 531 30" id="cmd_uncocd" innerdataset="ds_init_uncocd" datacolumn="nm" codecolumn="cd" anchor="default"/>
  18. <Radio position="absolute 345 40 560 60" id="radio2" columncount="3" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
  19. <Dataset id="innerdataset">
  20. <ColumnInfo>
  21. <Column id="codecolumn"/>
  22. <Column id="datacolumn"/>
  23. </ColumnInfo>
  24. <Rows>
  25. <Row>
  26. <Col id="codecolumn">O</Col>
  27. <Col id="datacolumn">진료일자</Col>
  28. </Row>
  29. <Row>
  30. <Col id="codecolumn">R</Col>
  31. <Col id="datacolumn">수납일자</Col>
  32. </Row>
  33. <Row>
  34. <Col id="codecolumn">G</Col>
  35. <Col id="datacolumn">발생일자</Col>
  36. </Row>
  37. </Rows>
  38. </Dataset>
  39. </Radio>
  40. <Static text="진료구분 :" position="absolute 10 12 84 29" id="caption7" class="search_name" anchor="default"/>
  41. <Combo position="absolute 90 11 170 30" id="combo2" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
  42. <Dataset id="innerdataset">
  43. <ColumnInfo>
  44. <Column id="codecolumn"/>
  45. <Column id="datacolumn"/>
  46. </ColumnInfo>
  47. <Rows>
  48. <Row>
  49. <Col id="codecolumn">A</Col>
  50. <Col id="datacolumn">전체</Col>
  51. </Row>
  52. <Row>
  53. <Col id="codecolumn">O</Col>
  54. <Col id="datacolumn">외래</Col>
  55. </Row>
  56. <Row>
  57. <Col id="codecolumn">I</Col>
  58. <Col id="datacolumn">입원</Col>
  59. </Row>
  60. </Rows>
  61. </Dataset>
  62. </Combo>
  63. <Combo position="absolute 272 11 337 30" id="combo4" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
  64. <Dataset id="innerdataset">
  65. <ColumnInfo>
  66. <Column id="codecolumn"/>
  67. <Column id="datacolumn"/>
  68. </ColumnInfo>
  69. <Rows>
  70. <Row>
  71. <Col id="codecolumn">A</Col>
  72. <Col id="datacolumn">전체</Col>
  73. </Row>
  74. <Row>
  75. <Col id="codecolumn">Y</Col>
  76. <Col id="datacolumn">종결</Col>
  77. </Row>
  78. <Row>
  79. <Col id="codecolumn">N</Col>
  80. <Col id="datacolumn">미결</Col>
  81. </Row>
  82. </Rows>
  83. </Dataset>
  84. </Combo>
  85. <Static text="종결구분 :" position="absolute 195 12 271 29" id="caption9" class="search_name" anchor="default"/>
  86. <Static text="담당자ID :" position="absolute 745 12 816 29" id="caption10" class="search_name" anchor="default"/>
  87. <Edit position="absolute 817 11 887 30" id="input6" anchor="default"/>
  88. <Static text="환자번호 :" position="absolute 915 12 986 29" id="caption11" class="search_name" anchor="default"/>
  89. <Edit position="absolute 992 11 1062 30" id="input7" anchor="default"/>
  90. <Button position="absolute 1125 39 1181 61" id="button1" class="btn7" text="엑셀" onclick="grp_button1_onclick" anchor="top right"/>
  91. <Static text="지정구분 :" position="absolute 550 11 621 31" id="caption5" class="search_name" anchor="default"/>
  92. <Combo position="absolute 627 11 712 30" id="combo1" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
  93. <Dataset id="innerdataset">
  94. <ColumnInfo>
  95. <Column id="codecolumn"/>
  96. <Column id="datacolumn"/>
  97. </ColumnInfo>
  98. <Rows>
  99. <Row>
  100. <Col id="codecolumn">A</Col>
  101. <Col id="datacolumn">전체</Col>
  102. </Row>
  103. <Row>
  104. <Col id="codecolumn">Y</Col>
  105. <Col id="datacolumn">지정완료</Col>
  106. </Row>
  107. <Row>
  108. <Col id="codecolumn">N</Col>
  109. <Col id="datacolumn">미지정</Col>
  110. </Row>
  111. </Rows>
  112. </Dataset>
  113. </Combo>
  114. </Layout>
  115. </Layouts>
  116. </Div>
  117. <Static text="미수내역" position="absolute 0 96 140 111" id="caption2" class="tit_2"/>
  118. <Grid position="absolute 0 115 1200 760" align="align:center middle;" id="grd_uncolist" binddataset="ds_main_uncoinfo" oncelldblclick="grd_uncolist_oncelldblclick" cellsizebandtype="allband" cellsizingtype="col" anchor="all">
  119. <Formats>
  120. <Format id="default">
  121. <Columns>
  122. <Column size="80"/>
  123. <Column size="80"/>
  124. <Column size="80"/>
  125. <Column size="85"/>
  126. <Column size="85"/>
  127. <Column size="85"/>
  128. <Column size="120"/>
  129. <Column size="80"/>
  130. <Column size="60"/>
  131. <Column size="120"/>
  132. <Column size="80"/>
  133. <Column size="90"/>
  134. <Column size="90"/>
  135. <Column size="90"/>
  136. <Column size="60"/>
  137. <Column size="250"/>
  138. </Columns>
  139. <Rows>
  140. <Row size="24" band="head"/>
  141. <Row size="24"/>
  142. </Rows>
  143. <Band id="head">
  144. <Cell text="진료구분"/>
  145. <Cell col="1" text="환자번호"/>
  146. <Cell col="2" text="성명"/>
  147. <Cell col="3" text="진료일자"/>
  148. <Cell col="4" text="수납일자"/>
  149. <Cell col="5" text="발생일자"/>
  150. <Cell col="6" text="진료부서"/>
  151. <Cell col="7" text="수납자"/>
  152. <Cell col="8" text="미수코드"/>
  153. <Cell col="9" text="미수명"/>
  154. <Cell col="10" text="유형"/>
  155. <Cell col="11" text="미수발생금액"/>
  156. <Cell col="12" text="미수입금액"/>
  157. <Cell col="13" text="미수잔액"/>
  158. <Cell col="14" text="미수번호"/>
  159. <Cell col="15" text="비고"/>
  160. </Band>
  161. <Band id="body">
  162. <Cell text="bind:ordtypenm"/>
  163. <Cell col="1" text="bind:pid"/>
  164. <Cell col="2" text="bind:hngnm"/>
  165. <Cell col="3" displaytype="date" text="bind:orddd" mask="yyyy-MM-dd" calendardisplaynulltype="none" enable="false"/>
  166. <Cell col="4" displaytype="date" text="bind:rcptexecdd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
  167. <Cell col="5" displaytype="date" text="bind:orgrcptdd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
  168. <Cell col="6" text="bind:orddeptnm"/>
  169. <Cell col="7" text="bind:rcptrnm"/>
  170. <Cell col="8" text="bind:uncocd"/>
  171. <Cell col="9" text="bind:unconm"/>
  172. <Cell col="10" text="bind:insunm"/>
  173. <Cell col="11" displaytype="number" style="align:right middle;" text="bind:uncoamt" mask="9,999"/>
  174. <Cell col="12" displaytype="number" style="align:right middle;" text="bind:rcptamt" mask="9,999"/>
  175. <Cell col="13" displaytype="number" style="align:right middle;" text="bind:uncorem" mask="9,999"/>
  176. <Cell col="14" text="bind:uncono"/>
  177. <Cell col="15" text="bind:remfact"/>
  178. </Band>
  179. </Format>
  180. </Formats>
  181. </Grid>
  182. <Edit position="absolute 135 90 155 109" id="input4" visible="false"/>
  183. <Edit position="absolute 160 90 185 109" id="input5" visible="false"/>
  184. <Static text="★ 미수번호 지정유무는 지정구분에서 완료여부에 따라 조회가능. 발생일자는 최초 미수금액 발생일자를 기준으로 함. ★" position="absolute 95 94 1100 114" id="caption6" style="color:blue;font:Dotum,9,bold;"/>
  185. <Static id="caption60" text="미수 지정별, 기간별 조회" class="tit_1" position="absolute 0 0 200 25"/>
  186. </Layout>
  187. </Layouts>
  188. <Objects>
  189. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  190. <ColumnInfo>
  191. <Column id="fromdd" type="STRING" size="256"/>
  192. <Column id="todd" type="STRING" size="256"/>
  193. <Column id="uncocd" type="STRING" size="256"/>
  194. <Column id="ordtype" type="STRING" size="256"/>
  195. <Column id="endflag" type="STRING" size="256"/>
  196. <Column id="rcptrid" type="STRING" size="256"/>
  197. <Column id="pid" type="STRING" size="256"/>
  198. <Column id="dayflag" type="STRING" size="256"/>
  199. <Column id="uncoflag" type="STRING" size="256"/>
  200. </ColumnInfo>
  201. <Rows>
  202. <Row>
  203. <Col id="fromdd"/>
  204. <Col id="todd"/>
  205. <Col id="uncocd"/>
  206. <Col id="ordtype"/>
  207. <Col id="endflag"/>
  208. <Col id="rcptrid"/>
  209. <Col id="pid"/>
  210. <Col id="dayflag"/>
  211. <Col id="uncoflag"/>
  212. </Row>
  213. </Rows>
  214. </Dataset>
  215. <Dataset id="ds_init_com_comncdlist_P0072list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  216. <Dataset id="ds_main_uncoinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  217. <ColumnInfo>
  218. <Column id="ordtypenm" type="STRING" size="256" sumtext="진료구분"/>
  219. <Column id="pid" type="STRING" size="256" sumtext="환자번호"/>
  220. <Column id="hngnm" type="STRING" size="256" sumtext="환자명"/>
  221. <Column id="orddd" type="STRING" size="256" sumtext="진료일자"/>
  222. <Column id="rcptexecdd" type="STRING" size="256" sumtext="수납실시일자"/>
  223. <Column id="orddeptnm" type="STRING" size="256" sumtext="진료과명"/>
  224. <Column id="orddeptcd" type="STRING" size="256" sumtext="진료과코드"/>
  225. <Column id="uncocd" type="STRING" size="256" sumtext="미수코드"/>
  226. <Column id="unconm" type="STRING" size="256" sumtext="미수명"/>
  227. <Column id="insunm" type="STRING" size="256" sumtext="보험유형"/>
  228. <Column id="uncoamt" type="STRING" size="256" sumtext="미수금액"/>
  229. <Column id="rcptamt" type="STRING" size="256" sumtext="입금금액"/>
  230. <Column id="uncorem" type="STRING" size="256" sumtext="미수잔액"/>
  231. <Column id="uncono" type="STRING" size="256" sumtext="미수번호"/>
  232. <Column id="remfact" type="STRING" size="256" sumtext="비고"/>
  233. <Column id="rcptrnm" type="STRING" size="256" sumtext="최종수납자명"/>
  234. <Column id="orgrcptdd" type="STRING" size="256" sumtext="원발생일자"/>
  235. </ColumnInfo>
  236. </Dataset>
  237. <Dataset id="ds_init_uncocd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  238. </Objects>
  239. <Bind>
  240. <BindItem id="item0" compid="grp.combo2" propid="value" datasetid="ds_send" columnid="ordtype"/>
  241. <BindItem id="item1" compid="grp.combo4" propid="value" datasetid="ds_send" columnid="endflag"/>
  242. <BindItem id="item2" compid="grp.cmd_uncocd" propid="value" datasetid="ds_send" columnid="uncocd"/>
  243. <BindItem id="item3" compid="grp.combo1" propid="value" datasetid="ds_send" columnid="uncoflag"/>
  244. <BindItem id="item4" compid="grp.input6" propid="value" datasetid="ds_send" columnid="rcptrid"/>
  245. <BindItem id="item5" compid="grp.input7" propid="value" datasetid="ds_send" columnid="pid"/>
  246. <BindItem id="item6" compid="grp.radio2" propid="value" datasetid="ds_send" columnid="dayflag"/>
  247. <BindItem id="item7" compid="grp.input2" propid="value" datasetid="ds_send" columnid="todd"/>
  248. <BindItem id="item8" compid="grp.input1" propid="value" datasetid="ds_send" columnid="fromdd"/>
  249. </Bind>
  250. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  251. * System Name :
  252. * Job Name :
  253. * Creator :
  254. * Make Date : 2016-05-24
  255. * Description :
  256. *---------------------------------------------------------------------------------------
  257. * Modify Date Modifier Modify Description
  258. *---------------------------------------------------------------------------------------
  259. * 2016-05-24 Live Converter TF->XP
  260. *
  261. *---------------------------------------------------------------------------------------
  262. ****************************************************************************************/
  263. //=======================================================================================
  264. // Lib Include
  265. //---------------------------------------------------------------------------------------
  266. include 'com_commonxp::comm_main.xjs';
  267. var arErrorCode = new HashArray();
  268. //=======================================================================================
  269. // Local methods
  270. //---------------------------------------------------------------------------------------
  271. /**
  272. * submit 후 호출 될 공통 콜백
  273. * @param {[type]} sSvcId [description]
  274. * @param {[type]} nErrorCode [description]
  275. * @param {[type]} sErrorMsg [description]
  276. * @return {Function} [description]
  277. */
  278. function callback(sSvcId, nErrorCode, sErrorMsg){
  279. arErrorCode.push(sSvcId, nErrorCode);
  280. }
  281. //=======================================================================================
  282. // Events
  283. //---------------------------------------------------------------------------------------
  284. /**
  285. * onload 이벤트 발생 시 호출
  286. * @param {[type]} obj:Form [description]
  287. * @param {[type]} e:LoadEventInfo [description]
  288. */
  289. function SPPAS00723_onload(obj: Form, e: LoadEventInfo) {
  290. frmf_initForm(obj);
  291. grdf_setGridSort(grd_uncolist);
  292. ds_send.setColumn(0, "fromdd", utlf_getCurrentDate());
  293. ds_send.setColumn(0, "todd", utlf_getCurrentDate());
  294. ds_send.setColumn(0, "ordtype", "A");
  295. ds_send.setColumn(0, "endflag", "N");
  296. ds_send.setColumn(0, "dayflag", "O");
  297. ds_send.setColumn(0, "uncoflag", "A");
  298. //미수분류(개인,계약처)
  299. appf_getCodeList([{ dsNm: 'ds_init_com_comncdlist_P0072list', cdGrpId: 'P0072' }])
  300. if (ds_init_com_comncdlist_P0072list.rowcount > 0) {
  301. ds_init_com_comncdlist_P0072list.setColumn(0, "cdnm", "-");
  302. ds_init_com_comncdlist_P0072list.setColumn(0, "cdid", "%");
  303. }
  304. dsf_createDsRow('ds_TRPAMCOM01', [{ col: 'sess_posinstcd', type: 'string', size: 256, val: '' }]);
  305. var oParam = {};
  306. oParam.id = "TRPAMCOM01";
  307. oParam.service = "pamcomnapp.PamComn";
  308. oParam.method = "reqGetComCD";
  309. oParam.inds = "req=ds_TRPAMCOM01";
  310. oParam.outds = "ds_init_uncocd=uncocd";
  311. oParam.async = false;
  312. tranf_submit(oParam);
  313. frmf_addComboItemAll('grp.cmd_uncocd');
  314. grp.cmd_uncocd.index = 0;
  315. }
  316. /**
  317. * 조회 버튼 클릭 이벤트
  318. * @param {[type]} obj: Button [description]
  319. * @param {[type]} e: ClickEventInfo [description]
  320. * @return {[type]} [description]
  321. */
  322. function grp_btn_search_onclick(obj: Button, e: ClickEventInfo) {
  323. ds_main_uncoinfo.clearData();
  324. var oParam = {};
  325. oParam.id = "TRPAS00813";
  326. oParam.service = "rcptteamstatsapp.rcptTeamOrdStats";
  327. oParam.method = "reqGetUncoOutInList";
  328. oParam.inds = "req=ds_send";
  329. oParam.outds = "ds_main_uncoinfo=uncolist";
  330. oParam.async = false;
  331. tranf_submit(oParam);
  332. }
  333. /**
  334. * 엑셀 버튼 클릭 이벤트
  335. * @param {[type]} obj: Button [description]
  336. * @param {[type]} e: ClickEventInfo [description]
  337. * @return {[type]} [description]
  338. */
  339. function grp_button1_onclick(obj: Button, e: ClickEventInfo) {
  340. grdf_exportExcel(grd_uncolist, "excel", "SheetName", true, "", "user", false);
  341. }
  342. /**
  343. * 미수내역 그리드 셀 더블클릭 이벤트
  344. * @param {[type]} obj: Grid [description]
  345. * @param {[type]} e: GridClickEventInfo [description]
  346. * @return {[type]} [description]
  347. */
  348. function grd_uncolist_oncelldblclick(obj: Grid, e: GridClickEventInfo) {
  349. var row = grd_uncolist.currentrow;
  350. opener.frmf_setParameter("SMPAS00700_PID", ds_main_uncoinfo.getColumn(row, "pid"));
  351. this.close();
  352. }
  353. ]]></Script>
  354. </Form>
  355. </FDL>