SMRSO01900_거래처 제조회사별 출고금액현황.xrw 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242
  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. <rsohoutscustcdselect/>
  11. </main>
  12. <send>
  13. <instcd/>
  14. <goodflag/>
  15. <winfrdd/>
  16. <wintodd/>
  17. <lrgcd/>
  18. <lrgnm/>
  19. <mdlcd/>
  20. <mdlnm/>
  21. <smlcd/>
  22. <smlnm/>
  23. <sortmoneytype/>
  24. </send>
  25. <init/>
  26. <temp/>
  27. </root>
  28. </instance>
  29. <submission id="TRRSO01901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rsohoutscustcdselect"/>
  30. <script type="javascript" ev:event="xforms-ready">
  31. <![CDATA[
  32. //화면 Control을 초기화한다
  33. fInitialize();
  34. ]]>
  35. </script>
  36. <bind id="deliveamt" ref="/root/main/rsohoutscustcdselect/deliveamt" calculate="../delivedeptqty * ../goodunitcost"/>
  37. </model>
  38. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  39. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  40. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  41. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  42. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  43. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  44. <script type="javascript">
  45. <![CDATA[
  46. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  47. function fInitialize() {
  48. model.resetInstanceNode("/root/send");
  49. rszfGoodFlagListByPgmGubn(cmb_goodflag,"2","N");
  50. rszfUserInstList(cmb_instcd,getUserInfo("userid"));
  51. model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
  52. var curdate = getCurrentDate();
  53. var cvtdate = curdate.toDate("YYYYMMDD");
  54. misfGridInit(grd_rsohoutscustcdselect);
  55. misfMsterDetailSet(grd_rsohoutscustcdselect,null, "TRRSO01901" ,"N");
  56. model.setValue(ipt_winfrdd.attribute("ref") ,cvtdate.getAddDate(-10,"D").getDateFormat("YYYYMMDD"));
  57. model.setValue(ipt_wintodd.attribute("ref") ,curdate);
  58. grd_rsohoutscustcdselect.subtotalposition = "after";
  59. model.refresh();
  60. }
  61. //필수항목 체크하는 메소드 넣기.
  62. function fCheckRetrieveData()
  63. {
  64. if(!isRequiredControls("cmb_instcd") )return false; // 기관코드 , commonweb/js/tfHelper.js
  65. if(!isRequiredControls("cmb_goodflag") )return false; // 물품구분
  66. if(!isRequiredControls("ipt_delivefrdd") )return false; // 출고시작일자
  67. if(!isRequiredControls("ipt_delivetodd") )return false; // 출고종료일자
  68. //if(!isRequiredControls("cmb_stocdeptcd") )return false; // 부서코드
  69. }
  70. ]]>
  71. </script>
  72. </xhtml:head>
  73. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  74. <group id="group1" style="left:0px; top:0px; width:1195; height:13px; ">
  75. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:214px; height:14px; ">판매회사별 입고금액</caption>
  76. </group>
  77. <group id="group5" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  78. <caption id="caption21" class="tit_2" style="left:5px; top:109px; width:216px; height:13px; ">판매회사별 입고금액내역</caption>
  79. <group id="group6" style="left:0px; top:13px; width:1195px; height:87px; vertical-align:top; ">
  80. <shape id="roundrect3" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:87px; background-color:#fffbf2; border-color:#ffd799; "/>
  81. <caption id="cap_goodflag" class="search_name" style="left:236px; top:9px; width:93px; height:17px; ">물품구분 :</caption>
  82. <caption id="cap_delivefrdd" class="search_name" style="left:15px; top:35px; width:93px; height:17px; ">입고일자 :</caption>
  83. <select1 id="cmb_goodflag" ref="/root/send/goodflag" class="combo_s_essential" appearance="minimal" style="left:322px; top:8px; width:108px; height:19px; ">
  84. <choices>
  85. <itemset nodeset="/root/init">
  86. <label ref="cdnm"/>
  87. <value ref="cdid"/>
  88. </itemset>
  89. </choices>
  90. </select1>
  91. <input id="ipt_winfrdd" ref="/root/send/winfrdd" class="input_s_essential" inputtype="date" style="left:100px; top:34px; width:108px; height:19px; "/>
  92. <input id="ipt_wintodd" ref="/root/send/wintodd" class="input_s_essential" inputtype="date" style="left:224px; top:34px; width:108px; height:19px; "/>
  93. <caption id="caption11" class="search_n_b" style="left:210px; top:37px; width:12px; height:17px; font-weight:bolder; ">~</caption>
  94. <line id="line18" class="line_4" style="x1:1109px; y1:12px; x2:1109px; y2:76px; border-left-style:solid; "/>
  95. <button id="btn_search" class="btn1_letter2" style="left:1124px; top:31px; width:56px; height:22px; background-image:../../../com/commonweb/images/btn1_letter2.gif; ">
  96. <caption>조회</caption>
  97. <script type="javascript" ev:event="DOMActivate">
  98. <![CDATA[
  99. misfGridInit(grd_rsohoutscustcdselect);
  100. if(fCheckRetrieveData(false) == false)return;
  101. //misfGridInit(grd_rsohoutscustcdselect)
  102. misfMsterDetailRetrieve();
  103. // grd_rsohoutscustcdselect.subtotal("clear",0 , 0);
  104. //거래처별 출고금액합계
  105. // grd_rsohoutscustcdselect.subtotal("sum" , 1 , 7 , "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; " , 1 , "거래처별출고금액");
  106. //제조회사별 출로금액합계
  107. //grd_rsohoutscustcdselect.subtotal("sum" , 2 , 7 , "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; " , 2 , "제조회사별출고금액");
  108. /*
  109. var gridrow = grd_rsohoutscustcdselect.rows;
  110. alert(gridrow);
  111. if(sortmoneytype.value == 'A')
  112. {
  113. alert("A");
  114. grd_rsohoutscustcdselect.colsort(0) ="asc";
  115. grd_rsohoutscustcdselect.colsort(1) ="asc";
  116. grd_rsohoutscustcdselect.colsort(2) ="asc";
  117. grd_rsohoutscustcdselect.colsort(3) ="asc";
  118. grd_rsohoutscustcdselect.colsort(4) ="asc";
  119. grd_rsohoutscustcdselect.colsort(5) ="asc";
  120. grd_rsohoutscustcdselect.sort(1,0, gridrow-1 ,5) = "usersort";
  121. }else if (sortmoneytype.value == 'B') {
  122. alert("B");
  123. grd_rsohoutscustcdselect.colsort(5) ="asc";
  124. grd_rsohoutscustcdselect.sort(1,0, gridrow ,5) = "usersort";
  125. }
  126. */
  127. //submit("TRRSO01901");
  128. //alert("End" );
  129. //model.refresh();
  130. ]]>
  131. </script>
  132. </button>
  133. <caption id="cap_instcd" class="search_name" style="left:15px; top:9; width:93px; height:17px; ">기관코드 :</caption>
  134. <select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" appearance="minimal" style="left:100px; top:8; width:108px; height:19px; ">
  135. <choices>
  136. <itemset nodeset="/root/init">
  137. <label ref="cdnm"/>
  138. <value ref="cdid"/>
  139. </itemset>
  140. </choices>
  141. </select1>
  142. <input id="ipt_lrgnm_search" ref="/root/send/lrgnm" class="input_s_essential" style="left:702px; top:8px; width:200px; height:19px; "/>
  143. <button id="btn_lrgcd" class="icon_search" style="left:679px; top:10px; width:16px; height:16px; ">
  144. <caption/>
  145. <script type="javascript" ev:event="DOMActivate">
  146. <![CDATA[
  147. rszfOpenPopUpListByWndName(ipt_lrgcd_search,"","lrgcd,lrgnm","SPRSD00130","goodflag","cmb_goodflag");
  148. model.refresh();
  149. ]]>
  150. </script>
  151. </button>
  152. <input id="ipt_lrgcd_search" ref="/root/send/lrgcd" class="input_s_essential" style="left:572px; top:8px; width:100px; height:19px; "/>
  153. <caption id="caption1" class="search_name" style="left:490px; top:9px; width:86px; height:17px; ">대 분 류 :</caption>
  154. <button id="btn_mdlcd" class="icon_search" style="left:679px; top:36px; width:16px; height:16px; ">
  155. <caption/>
  156. <script type="javascript" ev:event="DOMActivate">
  157. <![CDATA[
  158. rszfOpenPopUpListByWndName(ipt_mdlcd_search,"","mdlcd,mdlnm","SPRSD00140" ,"goodflag,lrgcd,lrgnm","cmb_goodflag,ipt_lrgcd_search,ipt_lrgnm_search");
  159. model.refresh();
  160. ]]>
  161. </script>
  162. </button>
  163. <caption id="caption3" class="search_name" style="left:490px; top:35px; width:93px; height:17px; ">중 분 류 :</caption>
  164. <input id="ipt_mdlnm_search" ref="/root/send/mdlnm" class="input_s_essential" style="left:702px; top:34px; width:200px; height:19px; "/>
  165. <input id="ipt_mdlcd_search" ref="/root/send/mdlcd" class="input_s_essential" style="left:572px; top:34px; width:100px; height:19px; "/>
  166. <button id="button1" class="icon_search" style="left:679px; top:62px; width:16px; height:16px; ">
  167. <caption/>
  168. <script type="javascript" ev:event="DOMActivate">
  169. <![CDATA[
  170. rszfOpenPopUpListByWndName(ipt_smlcd_search,"","smlcd,smlnm","SPRSD00150","goodflag,lrgcd,lrgnm,mdlcd,mdlnm","cmb_goodflag_search,ipt_lrgcd_search,ipt_lrgnm_search,ipt_mdlcd_search,ipt_mdlnm_search");
  171. model.refresh();
  172. ]]>
  173. </script>
  174. </button>
  175. <caption id="caption2" class="search_name" style="left:490px; top:61px; width:93px; height:17px; ">소 분 류 :</caption>
  176. <input id="ipt_smlnm_search" ref="/root/send/smlnm" class="input_s_essential" style="left:702px; top:60px; width:200px; height:19px; "/>
  177. <input id="ipt_smlcd_search" ref="/root/send/smlcd" class="input_s_essential" style="left:572px; top:60px; width:100px; height:19px; "/>
  178. <caption id="caption9" class="search_name" style="left:15px; top:61px; width:112px; height:17px; ">정렬순서 :</caption>
  179. <select1 id="sortmoneytype" ref="/root/send/sortmoneytype" appearance="full" cellspacing="20" cols="2" overflow="visible" style="left:104px; top:61px; width:153px; height:20px; border-style:none; ">
  180. <choices>
  181. <item>
  182. <label>단가기준</label>
  183. <value>A</value>
  184. </item>
  185. <item>
  186. <label>금액기준</label>
  187. <value>B</value>
  188. </item>
  189. </choices>
  190. <script type="javascript" ev:event="xforms-value-changed">
  191. <![CDATA[
  192. btn_search.dispatch("DOMActivate");
  193. ]]>
  194. </script>
  195. </select1>
  196. </group>
  197. <line id="line15" class="line_1" style="x1:0px; y1:124px; x2:1195px; y2:124px; "/>
  198. <datagrid id="grd_rsohoutscustcdselect" nodeset="/root/main/rsohoutscustcdselect" caption="판매회사^약품코드^상품명^입고량^제품단가^입고금액" colsep="^" colwidth="400, 120, 280, 100, 120, 120" dataheight="25" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:128px; width:1195px; height:600px; ">
  199. <col ref="maincustlastsuplplcenm"/>
  200. <col ref="goodcd"/>
  201. <col ref="goodnm" visibility="visible"/>
  202. <col ref="winqty" style="text-align:right; "/>
  203. <col ref="goodunitcost" format="#,###" style="text-align:right; "/>
  204. <col ref="winamt" format="#,###" style="text-align:right; "/>
  205. <script type="javascript" ev:event="onaftersort">
  206. <![CDATA[
  207. grd_rsohoutscustcdselect.gridToInstance();
  208. ]]>
  209. </script>
  210. </datagrid>
  211. </group>
  212. <group id="group4" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
  213. <button id="button34" class="btn6_letter2" visibility="hidden" disable.background-image="../../../com/commonweb/images/dis_btn6_letter2.gif" style="left:0; top:3px; width:56px; height:22px; background-image:../../../com/commonweb/images/btn6_letter2.gif; ">
  214. <caption>출력</caption>
  215. </button>
  216. <line id="line1" class="line_6" style="x1:0px; y1:25; x2:1195; y2:25; "/>
  217. <button id="btn_init" class="btn4_letter3" style="left:1127px; top:3px; width:68px; height:22px; ">
  218. <caption>초기화</caption>
  219. <script type="javascript" ev:event="DOMActivate">
  220. <![CDATA[
  221. fInitialize();
  222. ]]>
  223. </script>
  224. </button>
  225. </group>
  226. </xhtml:body>
  227. </xhtml:html>