SMRSD07300_치과재료 처방집계 조회.xrw 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
  3. <xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
  4. <xhtml:head>
  5. <xhtml:title>처방집계 시행부서별</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <list>
  11. <prcptotinfo>
  12. <prcptotlist/>
  13. </prcptotinfo>
  14. </list>
  15. </main>
  16. <send>
  17. <search>
  18. <instcd/>
  19. <goodflag/>
  20. <goodcd/>
  21. <goodnm/>
  22. <prcpdeptcd/>
  23. <prcpdeptnm/>
  24. <prcpmm/>
  25. <sumflag/>
  26. </search>
  27. <prcptotlist/>
  28. </send>
  29. <init>
  30. <sumflag>
  31. <label>전체</label>
  32. <value/>
  33. <label>집계</label>
  34. <value>Y</value>
  35. <label>미집계</label>
  36. <value>N</value>
  37. </sumflag>
  38. </init>
  39. <temp>
  40. </temp>
  41. </root>
  42. </instance>
  43. <submission id="TRRSD07301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/list/prcptotinfo"/>
  44. </model>
  45. <script type="javascript" ev:event="xforms-ready">
  46. <![CDATA[
  47. //화면 Control을 초기화한다
  48. fInitialize();
  49. ]]>
  50. </script>
  51. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  52. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  53. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  54. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  55. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  56. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  57. <script type="javascript">
  58. <![CDATA[
  59. function fInitialize()
  60. {
  61. var curdate = getCurrentDate();
  62. var cvtdate = curdate.toDate("YYYYMMDD");
  63. misfComboComCdListMulti("Z0007","cmb_instcd");
  64. model.setValue("/root/send/search/instcd", getUserInfo("dutplceinstcd")); // 기관 설정
  65. model.setValue(ipt_prcpmm.attribute("ref"), cvtdate.getDateFormat("YYYYMM")); //시행 월
  66. model.removeNodeset("/root/main/list/prcptotinfo/prcptotlist");
  67. cmb_goodflag.select(0);
  68. model.refresh();
  69. }
  70. function fItemAllChoice( vFlag ) {
  71. if (grd_prcptot.rows - grd_prcptot.fixedRows <= 0 ) {
  72. messageBox("선택할 데이터가","I004");
  73. return false;
  74. }
  75. for( cnt = grd_prcptot.fixedRows; cnt < grd_prcptot.rows ; cnt++ ) {
  76. grd_prcptot.valueMatrix( cnt, grd_prcptot.colRef("trschkyn") ) = vFlag;
  77. if (vFlag == "Y"){
  78. grd_prcptot.rowStatus(cnt) = "1";
  79. }else{
  80. grd_prcptot.rowStatus(cnt) = "0";
  81. }
  82. }
  83. }
  84. ]]>
  85. </script>
  86. </xhtml:head>
  87. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  88. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  89. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:230px; height:15px; ">처방집계 시행부서별 조회</caption>
  90. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  91. </group>
  92. <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  93. <group id="grp_search" style="left:0px; top:17px; width:1195px; height:63px; vertical-align:top; ">
  94. <caption id="cap_allsizespecid" class="search_name" style="left:975px; top:10px; width:111px; height:17px; ">규격코드 :</caption>
  95. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:63px; background-color:#fffbf2; border-color:#ffd799; "/>
  96. <line id="line30" class="line_4" style="x1:1110px; y1:4px; x2:1110px; y2:58px; "/>
  97. <button id="btn_search" class="btn1_letter2" style="left:1125px; top:22px; width:56px; height:22px; ">
  98. <caption>조회</caption>
  99. <script type="javascript" ev:event="DOMActivate">
  100. <![CDATA[
  101. model.removeNodeset("/root/main/list/prcptotinfo/prcptotlist");
  102. submit("TRRSD07301");
  103. model.refresh();
  104. grd_prcptot.gridToInstance();
  105. ]]>
  106. </script>
  107. </button>
  108. <select1 id="cmb_instcd" ref="/root/send/search/instcd" class="combo_default" appearance="minimal" style="left:104px; top:10px; width:166px; height:19px; text-align:left; padding-left:10; ">
  109. <choices>
  110. <itemset nodeset="/root/main/init">
  111. <label ref="cnstnm"/>
  112. <value ref="cnstcd"/>
  113. </itemset>
  114. </choices>
  115. </select1>
  116. <caption id="cap_instcd" class="search_name" style="left:10px; top:10px; width:86px; height:17px; ">기관코드 :</caption>
  117. <input id="ipt_goodnm" ref="/root/send/search/goodnm" class="output_search" style="left:890px; top:10px; width:205px; height:19px; "/>
  118. <button id="btn_goodcd" class="icon_search" style="left:866px; top:10px; width:16px; height:16px; ">
  119. <caption/>
  120. <script type="javascript" ev:event="DOMActivate">
  121. <![CDATA[
  122. rszfOpenPopUpListByWndName(ipt_goodcd,"","goodcd,goodnm","SPRSD00210","instcd","cmb_instcd");
  123. model.refresh();
  124. ]]>
  125. </script>
  126. </button>
  127. <input id="ipt_goodcd" ref="/root/send/search/goodcd" class="input_search" maxlength="10" appearance="input" style="left:771px; top:10px; width:89px; height:19px; "/>
  128. <caption id="cap_goodcd" class="search_name" style="left:675px; top:10px; width:86px; height:17px; ">물품코드 :</caption>
  129. <button id="button1" class="icon_search" style="left:494px; top:12px; width:16px; height:16px; ">
  130. <caption/>
  131. <script type="javascript" ev:event="DOMActivate">
  132. <![CDATA[
  133. var recv_list = "prcpdeptcd,prcpdeptnm";
  134. misfOpenPopUpList("02", ipt_prcpdeptcd,"", recv_list) ;
  135. model.refresh();
  136. // btn_search.dispatch("DOMActivate");
  137. ]]>
  138. </script>
  139. </button>
  140. <input id="ipt_prcpdeptnm" ref="/root/send/search/prcpdeptnm" class="input_fix" appearance="input" style="left:515px; top:10px; width:130px; height:19px; ">
  141. <script type="javascript" ev:event="xforms-value-changed">
  142. <![CDATA[
  143. // 부서코드 읽어오기...
  144. fDeptValidationCheck(ipt_prcpdeptnm, ipt_prcpdeptcd, "prcpdeptcd,prcpdeptnm");
  145. ]]>
  146. </script>
  147. </input>
  148. <input id="ipt_prcpdeptcd" ref="/root/send/search/prcpdeptcd" class="input_fix" style="left:404px; top:10px; width:85px; height:19px; ">
  149. <script type="javascript" ev:event="xforms-value-changed">
  150. <![CDATA[
  151. // 부서코드 읽어오기...
  152. fDeptValidationCheck(ipt_prcpdeptcd, ipt_prcpdeptnm, "prcpdeptcd,prcpdeptnm");
  153. // fDataSearchTree();
  154. ]]>
  155. </script>
  156. </input>
  157. <caption id="caption2" class="search_name" style="left:305px; top:10px; width:93px; height:17px; ">시행부서 :</caption>
  158. <input id="ipt_prcpmm" ref="/root/send/search/prcpmm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:104px; top:38px; width:166px; height:19px; text-align:left; padding-left:10; ">
  159. <script type="javascript" ev:event="xforms-value-changed">
  160. <![CDATA[
  161. // fDataSearchTree();
  162. ]]>
  163. </script>
  164. </input>
  165. <caption id="caption3" class="search_name" style="left:7px; top:38px; width:89px; height:17px; ">시행 월 :</caption>
  166. <select1 id="rdo_sumflag" ref="/root/send/search/sumflag" appearance="full" cellspacing="5" cols="3" overflow="visible" style="left:404px; top:37px; width:173px; height:17px; background-color:transparent; border-style:none; ">
  167. <choices>
  168. <itemset nodeset="/root/init/sumflag">
  169. <label ref="label"/>
  170. <value ref="value"/>
  171. </itemset>
  172. </choices>
  173. <script type="javascript" ev:event="xforms-value-changed">
  174. <![CDATA[
  175. // fDataSearchTree();
  176. ]]>
  177. </script>
  178. </select1>
  179. <caption id="caption7" class="search_name" style="left:305px; top:37px; width:89px; height:17px; ">집계여부 :</caption>
  180. <caption id="caption1" class="search_name" style="left:675px; top:40px; width:86px; height:17px; ">물품구분 :</caption>
  181. <select1 id="cmb_goodflag" ref="/root/send/search/goodflag" class="combo_default" navindex="16" appearance="minimal" editmode="search" style="left:770px; top:40px; width:148px; height:19px; ">
  182. <choices>
  183. <item>
  184. <label>치과재료</label>
  185. <value>S</value>
  186. </item>
  187. <item>
  188. <label>방사선재료</label>
  189. <value>C</value>
  190. </item>
  191. </choices>
  192. </select1>
  193. </group>
  194. <line id="line1" class="line_1" style="x1:0px; y1:108px; x2:1190px; y2:108px; "/>
  195. <datagrid id="grd_prcptot" nodeset="/root/main/list/prcptotinfo/prcptotlist" caption="계정^시행부서^거래처코드^거래처명^물품코드^물품코드^물품명^규격^모델^수불수량^선입고량^출고량^BOX 단위^계약기간^계약기간^단가계약^환산수량^구매단위^기관코드^물품구분^창고구분^청구월^제조회사^단가^금액^청구월^입고계정^청구유무^출고일자(from)" colsep="^" colwidth="125, 133, 26, 129, 80, 33, 102, 112, 80, 68, 63, 69, 100, 86, 86, 66, 34, 17, 21, 27, 27, 23, 22, 23, 21, 17, 20, 17, 21" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="24" rowsep="|" style="left:0px; top:115px; width:1190px; height:615px; font-weight:normal; text-align:center; ">
  196. <col ref="winacntnm" style="text-align:left; padding-left:10; "/>
  197. <col ref="prcpdeptnm" style="text-align:left; padding-left:10; "/>
  198. <col ref="maincustlastsuplplce" visibility="hidden" style="text-align:center; "/>
  199. <col ref="maincustlastsuplplcenm" style="text-align:left; padding-left:10; "/>
  200. <col ref="goodcd" style="text-align:center; "/>
  201. <col ref="allsizespecid" style="text-align:center; "/>
  202. <col ref="goodnm" style="text-align:left; padding-left:10; "/>
  203. <col ref="goodspec" style="text-align:left; padding-left:10; "/>
  204. <col ref="goodmodel" visibility="hidden" style="text-align:left; padding-left:10; "/>
  205. <col ref="deliveqty" visibility="hidden" format="#,###" style="text-align:right; "/>
  206. <col ref="totreqqty" visibility="hidden" format="#,###" style="text-align:right; "/>
  207. <col ref="totstocqty" format="#,###" style="text-align:right; "/>
  208. <col ref="fullpurcunit" visibility="visible" style="text-align:left; padding-left:10; "/>
  209. <col ref="fromconterm" format="yyyy-mm-dd" style="text-align:center; "/>
  210. <col ref="toconterm" format="yyyy-mm-dd" style="text-align:center; "/>
  211. <col ref="costconyn" style="text-align:center; "/>
  212. <col ref="exchqty" visibility="hidden" style="text-align:center; "/>
  213. <col ref="purcunit" visibility="hidden" style="text-align:center; "/>
  214. <col ref="instcd" visibility="hidden" style="text-align:center; "/>
  215. <col ref="goodflag" visibility="hidden" style="text-align:center; "/>
  216. <col ref="wareflag" visibility="hidden" style="text-align:center; "/>
  217. <col ref="reqmm" visibility="hidden" style="text-align:center; "/>
  218. <col ref="prodcmpynm" visibility="hidden" style="text-align:center; "/>
  219. <col ref="goodunitcost" visibility="hidden" style="text-align:center; "/>
  220. <col ref="reqfla" visibility="hidden" style="text-align:center; "/>
  221. <col ref="reqmm" visibility="hidden" style="text-align:center; "/>
  222. <col ref="winacnt" visibility="hidden" style="text-align:center; "/>
  223. <col ref="reqyn" visibility="hidden"/>
  224. <col ref="deliveddfr" visibility="hidden"/>
  225. </datagrid>
  226. <button id="btn_excel" class="btn5_letter3" navindex="12" style="left:1135px; top:85px; width:53px; height:19px; ">
  227. <caption>Excel</caption>
  228. <script type="javascript" ev:event="DOMActivate">
  229. <![CDATA[
  230. var fileName = window.fileDialog("save", ",", false, "처방집계 시행부서별("+ model.getValue(ipt_prcpmm.attribute("ref")) +")", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  231. if (fileName != "")
  232. {
  233. grd_prcptot.saveExcel(fileName, "처방집계 시행부서별("+ model.getValue(ipt_prcpmm.attribute("ref")) +")",true,true, "");
  234. }
  235. ]]>
  236. </script>
  237. </button>
  238. </group>
  239. <group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  240. <line id="line7" class="line_6" style="x1:0px; y1:25; x2:1194px; y2:25; "/>
  241. <button id="btn_init" class="btn4_letter3" style="left:1126; top:3; width:68px; height:22px; ">
  242. <caption>초기화</caption>
  243. <script type="javascript" ev:event="DOMActivate">
  244. <![CDATA[
  245. fInitialize();
  246. ]]>
  247. </script>
  248. </button>
  249. </group>
  250. </xhtml:body>
  251. </xhtml:html>