dryreportexcel.jsp 3.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697
  1. <%@ page language="java" contentType="text/html; charset=gbk"%>
  2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  3. <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
  4. <%@ page import="com.kpt.common.Util" %>
  5. <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
  6. <meta http-equiv="Content-Type" content="text/html; charset=GBK" />
  7. <%
  8. String str = Util.getHeaderType(request,"效率分析");
  9. response.setContentType("application/vnd.ms-excel;charset=gbk");response.setHeader("Content-disposition",str);
  10. %>
  11. <head>
  12. <style>
  13. .STYLE1 {color: #FFFFFF}
  14. </style>
  15. <!--[if gte mso 9]><xml>
  16. <x:ExcelWorkbook>
  17. <x:ExcelWorksheets>
  18. <x:ExcelWorksheet>
  19. <x:Name>readers</x:Name>
  20. <x:WorksheetOptions>
  21. <x:Print>
  22. <x:ValidPrinterInfo />
  23. </x:Print>
  24. </x:WorksheetOptions>
  25. </x:ExcelWorksheet>
  26. </x:ExcelWorksheets>
  27. </x:ExcelWorkbook>
  28. </xml><![endif]-->
  29. </head>
  30. <body style="margin:0";>
  31. <div class="content">
  32. <table>
  33. <tbody>
  34. <tr style="height: 25px;">
  35. <td align="center" colspan="18"><b>效率分析${beginDate}</b></td>
  36. </tr>
  37. </tbody>
  38. </table>
  39. <table cellspacing="1" cellpadding="0" border="0" style="width: 99%;" class="tabsty">
  40. <tbody>
  41. <tr align="center" style="height: 25px;">
  42. <th width="7%">栏舍</th>
  43. <th width="7%">配方模版</th>
  44. <th>配方价格(元/kg)</th>
  45. <th>实际牛头数</th>
  46. <th>应上料量(kg)</th>
  47. <th>总上料量(kg)</th>
  48. <th>昨日转投剩料量(kg)</th>
  49. <th>今日剩料量(kg)</th>
  50. <th>剩料率(%)</th>
  51. <th>TMR干物质(%)</th>
  52. <th>配方干物质采食量(kg/头)</th>
  53. <th>实际干物质采食量(kg/头)</th>
  54. <th>采食率(%)</th>
  55. <th>配方成本(元/头)</th>
  56. <th>实际成本(元/头)</th>
  57. <th>产量(kg)</th>
  58. <th>产奶效率(奶料比)</th>
  59. <th>饲料成本(元/公斤奶)</th>
  60. </tr>
  61. <c:if test="${empty list}"><tr align="center" class="greb" style="height: 25px;"><td colspan="18">没有对应的结果</td></tr></c:if>
  62. <c:if test="${!empty list}">
  63. <c:forEach var="list" items="${list}">
  64. <tr align="center" class="greb" style="height: 25px;">
  65. <td>
  66. <c:if test="${empty list.Fname}"></c:if>
  67. <c:if test="${!empty list.Fname}">
  68. <c:if test="${list.Fname == '平均值' or list.Fname == '合计值'}"><c:out value="${list.Fname}" /></c:if>
  69. <c:if test="${list.Fname != '平均值' and list.Fname != '合计值'}">[<c:out value="${list.Fname}" />]</c:if>
  70. </c:if>
  71. </td>
  72. <td><c:out value="${list.TNAME}" /></td>
  73. <td><c:out value="${list.tprice}" /></td>
  74. <td><c:out value="${list.CCOUNT}" /></td>
  75. <td><c:out value="${list.beginSumActualWeightMinus}" /></td>
  76. <td><c:out value="${list.SumActualWeightMinus}" /></td>
  77. <td><c:out value="${list.YesterdayRemain}" /></td>
  78. <td><c:out value="${list.Remain}" /></td>
  79. <td><c:out value="${list.RemainRatio}" /></td>
  80. <td><c:out value="${list.tdry}" /></td>
  81. <td><c:out value="${list.dryWEIGHT}" /></td>
  82. <td><c:out value="${list.sjDryCSL}" /></td>
  83. <td><c:out value="${list.csl}" /></td>
  84. <td><c:out value="${list.lprice}" /></td>
  85. <td><c:out value="${list.price}" /></td>
  86. <td><c:out value="${list.product}" /></td>
  87. <td><c:out value="${list.milkratio}" /></td>
  88. <td><fmt:formatNumber value="${list.FeedPricePMilk }" pattern="#.##" minFractionDigits="2" /></td>
  89. </tr>
  90. </c:forEach>
  91. </c:if>
  92. </tbody>
  93. </table>
  94. </div>
  95. </body>
  96. </html>