outStockStatis.jsp 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218
  1. <%@ page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%>
  2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  3. <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  5. <html>
  6. <head>
  7. <meta http-equiv="Content-Type" content="text/html;charset=GBK">
  8. <title>出库明细汇总</title>
  9. <script type="text/javascript"
  10. src="${pageContext.request.contextPath }/controls/print/plugPrint.js"></script>
  11. <!--media=print 这个属性可以在打印时有效-->
  12. <style media=print>
  13. .Noprint {
  14. display: none;
  15. }
  16. .PageNext {
  17. page-break-after: always;
  18. }
  19. </style>
  20. <style type="text/css">
  21. body {
  22. font-size: 12pt;
  23. }
  24. .auditOpionin_left_td {
  25. border-left: 1px solid #000000;
  26. border-bottom: 0px solid #000000;
  27. border-right: 1px solid #000000;
  28. }
  29. .auditOpionin_right_td {
  30. border-bottom: 0px solid #000000;
  31. border-right: 1px solid #000000;
  32. }
  33. .auditOpionin_div {
  34. padding-left: 10px;
  35. padding-top: 10px;
  36. margin-bottom: 10px;
  37. }
  38. .auditOpionin_content_left_td {
  39. border-left: 1px solid #000000;
  40. border-bottom: 1px solid #000000;
  41. border-right: 1px solid #000000;
  42. padding-left: 10px;
  43. }
  44. .auditOpionin_content_right_td {
  45. border-bottom: 1px solid #000000;
  46. border-right: 1px solid #000000;
  47. padding-left: 10px;
  48. }
  49. .ctd {
  50. margin: 5px;
  51. padding: 5px;
  52. }
  53. .tdp {
  54. border-bottom: 1 2px solid #000000 #000000;
  55. border-left: 1 2px solid #000000 #000000;
  56. border-right: 0 2px solid #000000 #ffffff;
  57. border-top: 0 2px solid #000000 #ffffff;
  58. }
  59. .tabp {
  60. border-color: #000000 #000000 #000000 #000000;
  61. border: 2px solid #000000;
  62. border-top-width: 2px;
  63. border-right-width: 2px;
  64. border-bottom-width: 1px;
  65. border-left-width: 1px;
  66. }
  67. .NOPRINT {
  68. font-family: "宋体";
  69. font-size: 9pt;
  70. }
  71. ul {
  72. list-style: none;
  73. margin: 0;
  74. padding: 0;
  75. }
  76. ul li {
  77. line-height: 28px;
  78. }
  79. #mdA table,#mdA table td,#mdA table th{border:1px solid #000000;border-collapse:collapse;}
  80. </style>
  81. <script language="javascript" type="text/javascript">
  82. //****************************************************************
  83. //* 名  称:formPrintit
  84. //* 功 能:打印
  85. //* 作 者: 章家明
  86. //* 入口参数:
  87. //* 出口参数:
  88. //*****************************************************************
  89. function formPrintit(isZong, isSelectPrinter) {
  90. setupHeaderAndFooter("", "");
  91. setupMargin("1", "28", "28", "28", "28");
  92. printit(isZong, isSelectPrinter);
  93. }
  94. //****************************************************************
  95. //* 名  称:formPageSetup
  96. //* 功 能:打印设置
  97. //* 作 者: 章家明
  98. //* 入口参数:
  99. //* 出口参数:
  100. //*****************************************************************
  101. function formPageSetup() {
  102. setupHeaderAndFooter("", "");
  103. setupMargin("1", "28", "28", "28", "28");
  104. popPageSetup();
  105. }
  106. //****************************************************************
  107. //* 名  称:formPreview
  108. //* 功 能:打印预览
  109. //* 作 者: 章家明
  110. //* 入口参数:
  111. //* 出口参数:
  112. //*****************************************************************
  113. function formPreview() {
  114. setupHeaderAndFooter("", "");
  115. setupMargin("1", "28", "28", "28", "28");
  116. popPreview();
  117. }
  118. function printWindow() {
  119. factory.printing.header = "This is MeadCo";
  120. factory.printing.footer = "Printing by ScriptX";
  121. factory.printing.portrait = false;
  122. factory.printing.leftMargin = 1.0;
  123. factory.printing.topMargin = 1.0;
  124. factory.printing.rightMargin = 1.0;
  125. factory.printing.bottomMargin = 1.0;
  126. // factory.printing.Print(false);
  127. factory.printing.Preview();
  128. }
  129. </script>
  130. </head>
  131. <body>
  132. <table width="100%" cellpadding="0" cellspacing="0" class="hl hr"
  133. bordercolor="#000000" align="center">
  134. <tr class="Noprint">
  135. <td align="center">
  136. <%-- <object id="xprint" name="xprint" style="display:none" classid="clsid:1663ed61-23eb-11d2-b92f-008048fdd814" codebase="${pageContext.request.contextPath }/controls/print/smsx.cab#version=6,5,439,72"></object> --%>
  137. <object id="factory" viewastext style="display: none"
  138. classid="clsid:1663ed61-23eb-11d2-b92f-008048fdd814"
  139. codebase="${pageContext.request.contextPath}/controls/print/smsx.cab#Version=7,0,0,8">
  140. </object> <input type=button value="选择打印" onclick="formPrintit(false, true)">
  141. <input type=button value="直接打印" onclick="formPrintit(true, false)">
  142. <input type=button value="页面设置" onclick="formPageSetup()"> <input
  143. type=button value="打印预览" onclick="formPreview()">
  144. </td>
  145. </tr>
  146. </table>
  147. <br />
  148. <div id="mdA" style="margin-top: 4px">
  149. <table cellpadding="0" width="1000" cellspacing="0" align="center" class="print">
  150. <tr>
  151. <th>出库日期</th>
  152. <th>部门</th>
  153. <th>出库单号</th>
  154. <th>仓库</th>
  155. <th>出库总量</th>
  156. <th>存货名称</th>
  157. <th>存货编码</th>
  158. <th>规格型号</th>
  159. <th>库存数量</th>
  160. <th>成本价</th>
  161. <th>成本小计</th>
  162. <th>售价</th>
  163. <th>金额小计</th>
  164. </tr>
  165. <c:forEach items="${outStockList }" var="osd">
  166. <tr>
  167. <td><fmt:formatDate value="${osd.outs_outstock_date }" pattern="yyyy-MM-dd"/></td>
  168. <td>${osd.groupName }</td>
  169. <td>${osd.outs_num }</td>
  170. <td>${osd.depot_name }</td>
  171. <td>${osd.outsd_product_count }</td>
  172. <td>${osd.product_name }</td>
  173. <td>${osd.product_num }</td>
  174. <td>${osd.product_mode }</td>
  175. <td>${osd.stock_product_count }</td>
  176. <td><fmt:formatNumber value="${osd.product_cost }" pattern="#.##" minFractionDigits="2" /></td>
  177. <td><fmt:formatNumber value="${osd.cost_total }" pattern="#.##" minFractionDigits="2" /></td>
  178. <td><fmt:formatNumber value="${osd.product_sell_price }" pattern="#.##" minFractionDigits="2" /></td>
  179. <td><fmt:formatNumber value="${osd.sell_total }" pattern="#.##" minFractionDigits="2" /></td>
  180. </tr>
  181. </c:forEach>
  182. <tr>
  183. <td colspan="12" align="right">出库存货数量总计</td>
  184. <td><fmt:formatNumber value="${proAllCountTotal}" pattern="#.##" minFractionDigits="2" /></td>
  185. </tr>
  186. <tr>
  187. <td colspan="12" align="right">出库存货成本总计</td>
  188. <td><fmt:formatNumber value="${proAllCostTotal}" pattern="#.##" minFractionDigits="2" /></td>
  189. </tr>
  190. <tr>
  191. <td colspan="12" align="right">出库存货金额总计</td>
  192. <td><fmt:formatNumber value="${proAllMoneyTotal}" pattern="#.##" minFractionDigits="2" /></td>
  193. </tr>
  194. </table>
  195. </div>
  196. </body>
  197. </html>