SMMRS01900_협의진료퇴원분석.xrw 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>협의진료통계 퇴원분석자표</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <listdata/>
  11. <rptinfo/>
  12. </main>
  13. <send>
  14. <reqdata>
  15. <fromdd/>
  16. <todd/>
  17. <chosflag/>
  18. <pivot/>
  19. <sum/>
  20. </reqdata>
  21. <condition>
  22. <cond1/>
  23. <rptcd/>
  24. </condition>
  25. </send>
  26. <init>
  27. <orddept/>
  28. <info/>
  29. <userlist/>
  30. <conddata>
  31. <cond1/>
  32. </conddata>
  33. </init>
  34. <hidden>
  35. <rptinfo/>
  36. </hidden>
  37. <temp>
  38. <datagridinfo>
  39. <info/>
  40. </datagridinfo>
  41. </temp>
  42. </root>
  43. </instance>
  44. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  45. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  46. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  47. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  48. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  49. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  50. <script type="javascript" ev:event="xforms-ready">
  51. <![CDATA[
  52. model.setValue("/root/send/reqdata/fromdd", getCurrentDate().substring(0, 6)+"01");
  53. model.setValue("/root/send/reqdata/todd", getCurrentDate());
  54. model.setValue(cmb_cond1.attribute("ref"), "D");
  55. fSetDataGridCaption();
  56. model.refresh();
  57. ]]>
  58. </script>
  59. <script type="javascript">
  60. <![CDATA[
  61. function fSetDataGridCaption(){
  62. //fGetHardCDList("N", 5664, 0 , "/root/temp/datagridinfo");
  63. submit("TRMRS01901");
  64. var node = "/root/temp/datagridinfo/info"
  65. var count = getNodesetCount(node);
  66. var strCaption = "의뢰 시행^";
  67. var strParameter_pivot = "";
  68. var strParameter_sum = " ( ";
  69. for(var i=1; i<=count; i++){
  70. var deptnm = model.getValue(node +"["+i+"]/deptnm");
  71. var deptcd = model.getValue(node +"["+i+"]/deptcd");
  72. strCaption += deptnm+"^";
  73. grd_stats.addColumn("ref:col"+i +"; format:#,###" ,false);
  74. strParameter_pivot += "'"+deptcd+"' as col"+i;
  75. strParameter_sum += "nvl(col"+i+", 0)";
  76. if(count != i){
  77. strParameter_pivot += ",\t";
  78. strParameter_sum += " + ";
  79. }else{
  80. strParameter_sum += " ) ";
  81. }
  82. }
  83. // 총합계
  84. strCaption += "총합계";
  85. grd_stats.addColumn("ref:sum; format:#,###",false);
  86. // Col 너비 조정
  87. for(var i=0; i<grd_stats.cols; i++){
  88. grd_stats.colWidth(i) = 100;
  89. }
  90. grd_stats.caption = strCaption;
  91. grd_stats.rebuild();
  92. grd_stats.refresh();
  93. model.setValue("/root/send/reqdata/pivot",strParameter_pivot);
  94. model.setValue("/root/send/reqdata/sum",strParameter_sum);
  95. model.refresh();
  96. }
  97. ]]>
  98. </script>
  99. <submission id="TRMRS01900" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/cnstlist"/>
  100. <submission id="TRMRS01901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/temp/datagridinfo/info"/>
  101. </model>
  102. </xhtml:head>
  103. <xhtml:body>
  104. <caption id="cap_title" ref="/root/main/rptinfo/rptnm" class="tit_1" style="left:0px; top:0px; width:220px; height:15px; ">협의진료(퇴원분석자료기준)</caption>
  105. <shape id="roundrect1" appearance="roundrect" style="left:0px; top:20px; width:1194px; height:40px; "/>
  106. <button id="btn_req" class="btn1_letter2" navindex="4" style="left:550px; top:30px; width:56px; height:22px; ">
  107. <caption>조회</caption>
  108. <script type="javascript" ev:event="DOMActivate">
  109. <![CDATA[
  110. //fSrchStatsList();
  111. if (submit("TRMRS01900")) {
  112. grd_stats.subtotalPosition = "below";
  113. for(var i=1; i<=grd_stats.cols; i++){
  114. grd_stats.subtotal("sum", -1, i, "#,###", "background-color:#99ffff", 0, "합계");
  115. }
  116. /*
  117. grd_stats.subtotal("sum", -1, 1, "#,###", "background-color:#99ffff", 0, "합계");
  118. grd_stats.subtotal("sum", -1, 2, "#,###", "background-color:#99ffff", 0, "합계");
  119. grd_stats.subtotal("sum", -1, 3, "#,###", "background-color:#99ffff", 0, "합계");
  120. grd_stats.subtotal("sum", -1, 4, "#,###", "background-color:#99ffff", 0, "합계");
  121. grd_stats.subtotal("sum", -1, 5, "#,###", "background-color:#99ffff", 0, "합계");
  122. grd_stats.subtotal("sum", -1, 6, "#,###", "background-color:#99ffff", 0, "합계");
  123. grd_stats.subtotal("sum", -1, 7, "#,###", "background-color:#99ffff", 0, "합계");
  124. grd_stats.subtotal("sum", -1, 8, "#,###", "background-color:#99ffff", 0, "합계");
  125. grd_stats.subtotal("sum", -1, 9, "#,###", "background-color:#99ffff", 0, "합계");
  126. grd_stats.subtotal("sum", -1, 10, "#,###", "background-color:#99ffff", 0, "합계");
  127. grd_stats.subtotal("sum", -1, 11, "#,###", "background-color:#99ffff", 0, "합계");
  128. grd_stats.subtotal("sum", -1, 12, "#,###", "background-color:#99ffff", 0, "합계");
  129. grd_stats.subtotal("sum", -1, 13, "#,###", "background-color:#99ffff", 0, "합계");
  130. grd_stats.subtotal("sum", -1, 14, "#,###", "background-color:#99ffff", 0, "합계");
  131. grd_stats.subtotal("sum", -1, 15, "#,###", "background-color:#99ffff", 0, "합계");
  132. grd_stats.subtotal("sum", -1, 16, "#,###", "background-color:#99ffff", 0, "합계");
  133. grd_stats.subtotal("sum", -1, 17, "#,###", "background-color:#99ffff", 0, "합계");
  134. grd_stats.subtotal("sum", -1, 18, "#,###", "background-color:#99ffff", 0, "합계");
  135. grd_stats.subtotal("sum", -1, 19, "#,###", "background-color:#99ffff", 0, "합계");
  136. grd_stats.subtotal("sum", -1, 20, "#,###", "background-color:#99ffff", 0, "합계");
  137. grd_stats.subtotal("sum", -1, 21, "#,###", "background-color:#99ffff", 0, "합계");
  138. grd_stats.subtotal("sum", -1, 22, "#,###", "background-color:#99ffff", 0, "합계");
  139. grd_stats.subtotal("sum", -1, 23, "#,###", "background-color:#99ffff", 0, "합계");
  140. grd_stats.subtotal("sum", -1, 24, "#,###", "background-color:#99ffff", 0, "합계");
  141. grd_stats.subtotal("sum", -1, 25, "#,###", "background-color:#99ffff", 0, "합계");
  142. grd_stats.subtotal("sum", -1, 26, "#,###", "background-color:#99ffff", 0, "합계");
  143. grd_stats.subtotal("sum", -1, 27, "#,###", "background-color:#99ffff", 0, "합계");
  144. grd_stats.subtotal("sum", -1, 28, "#,###", "background-color:#99ffff", 0, "합계");
  145. grd_stats.subtotal("sum", -1, 29, "#,###", "background-color:#99ffff", 0, "합계");
  146. grd_stats.subtotal("sum", -1, 30, "#,###", "background-color:#99ffff", 0, "합계");
  147. grd_stats.subtotal("sum", -1, 31, "#,###", "background-color:#99ffff", 0, "합계");
  148. */
  149. }
  150. ]]>
  151. </script>
  152. </button>
  153. <line id="line5" style="x1:540px; y1:20px; x2:540px; y2:60px; border-color:#ffe4bb; border-left-style:solid; "/>
  154. <caption id="lbl_list" class="tit_2" style="left:5px; top:88px; width:139px; height:14px; ">퇴원통계</caption>
  155. <line id="line1" class="line_1" style="x1:4px; y1:106px; x2:1191px; y2:107px; "/>
  156. <datagrid id="grd_stats" nodeset="/root/main/cnstlist" caption="의뢰 시행^순환기내과^호흡기내과^소화기내과^혈액종양내과^알레르기감염내과^신장내과^내분비대사내과^류마티스내과^외과^대장항문소아외과^유방갑상선외과^이식혈관외과^정형외과^신경외과^흉부외과^성형외과^소아청소년과^산부인과^정신건강의학과^신경과^이비인후과^피부과^비뇨기과^안과^마취통증의학과^핵의학과^재활의학과^치과^영상의학과^응급의학과^총합계" colsep="^" colwidth="100,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80" frozencols="1" mergecellsfixedcols="bycol" mergecellsfixedrows="byrowrec" rowsep="|" navindex="5" style="left:1px; top:110px; width:1190px; height:655px; ">
  157. <col ref="deptnm" style="text-align:center; "/>
  158. </datagrid>
  159. <button id="btn_ex" class="btn2_letter2" navindex="6" style="left:1145px; top:85px; width:42px; height:19px; ">
  160. <caption>엑셀</caption>
  161. <script type="javascript" ev:event="DOMActivate">
  162. <![CDATA[
  163. var fileName = window.fileDialog("save", ",", false, "협의진료퇴원분석", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  164. if (fileName != ""){
  165. grd_stats.saveExcel(fileName, "SheetName", false, false, "", "", false);
  166. }
  167. ]]>
  168. </script>
  169. </button>
  170. <caption id="caption9" class="search_name" style="left:5px; top:30px; width:71px; height:17px; ">구분 :</caption>
  171. <select1 id="cmb_cond1" ref="/root/send/reqdata/chosflag" class="combo_search" disabled="true" navindex="1" appearance="minimal" editmode="search" itemcount="20" style="left:75px; top:29px; width:90px; height:19px; ">
  172. <choices>
  173. <item>
  174. <label>퇴원</label>
  175. <value>D</value>
  176. </item>
  177. <item>
  178. <label>외래</label>
  179. <value>O</value>
  180. </item>
  181. <item>
  182. <label>응급</label>
  183. <value>E</value>
  184. </item>
  185. </choices>
  186. </select1>
  187. <line id="line2" style="x1:1px; y1:110px; x2:100px; y2:132px; "/>
  188. <input id="ipt_todd" ref="/root/send/reqdata/todd" class="input_s_essential" navindex="3" inputtype="date" style="left:420px; top:29px; width:95px; height:19px; "/>
  189. <input id="ipt_fromdd" ref="/root/send/reqdata/fromdd" class="input_s_essential" navindex="2" inputtype="date" style="left:309px; top:29px; width:95px; height:19px; "/>
  190. <caption id="caption1" class="search_name" style="left:215px; top:30px; width:86px; height:17px; ">조회기간 :</caption>
  191. <caption id="caption2" style="left:407px; top:30px; width:15px; height:20px; ">~</caption>
  192. </xhtml:body>
  193. </xhtml:html>