listPurchaseOrderReport.jsp 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334
  1. <%@ page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  3. <html>
  4. <head>
  5. <meta http-equiv="Content-Type" content="text/html;charset=GBK">
  6. <title>采购订单</title>
  7. <link href="${pageContext.request.contextPath}/main.css" rel="stylesheet" type="text/css" />
  8. <link href="${pageContext.request.contextPath }/liger/lib/ligerUI/skins/${sessionScope.css}/css/ligerui-all.css" rel="stylesheet" type="text/css" />
  9. <script src="${pageContext.request.contextPath }/liger/lib/jquery/jquery-1.3.2.min.js" type="text/javascript"></script>
  10. <script src="${pageContext.request.contextPath }/liger/lib/ligerUI/js/core/base.js" type="text/javascript"></script>
  11. <script src="${pageContext.request.contextPath }/liger/lib/ligerUI/js/plugins/ligerGrid.js" type="text/javascript"></script>
  12. <script type="text/javascript" src="/shares/js/constant.js"></script>
  13. <script type="text/javascript" src="/shares/js/common.js"></script>
  14. <script type="text/javascript" src="/shares/js/yw/erp/erpflow.js"></script>
  15. <script type="text/javascript" src="/shares/datePicker/WdatePicker.js"></script>
  16. <script src="${pageContext.request.contextPath}/liger/lib/ligerUI/js/ligerui.all.js" type="text/javascript"></script>
  17. <script type="text/javascript">
  18. var grid = null;
  19. $(function() {
  20. loadTypeTree("selectuserbutton", {
  21. type : "usersingle",
  22. backId : "purchase_assigned_user_id",
  23. backName : "purchase_assigned_user_name",
  24. tab : "1,2,3"
  25. });
  26. initPurchaseGridList();
  27. });
  28. function initPurchaseGridList(params) {
  29. var checkbox = false;
  30. if ("${checkbox}" == 'false' || "${checkbox}" == '') {
  31. checkbox = false;
  32. } else {
  33. checkbox = true;
  34. }
  35. var columns = [
  36. {
  37. display : '采购单号',
  38. name : 'purchase_number',
  39. width : 120
  40. },{
  41. display : '采购单主题',
  42. name : 'purchase_theme',
  43. width : 120
  44. },{
  45. display : '供应商名称',
  46. name : 'purchase_suppliers_name',
  47. width : 80
  48. },{
  49. display : '采购日期',
  50. name : 'purchase_date',
  51. width : 80
  52. },{
  53. display : '采购负责人',
  54. name : 'purchase_assigned_user_name',
  55. width : 80
  56. },{
  57. display : '采购总额',
  58. name : 'purchase_after_amount',
  59. width : 80
  60. },{
  61. display : '采购状态',
  62. name : 'purchase_status',
  63. width : 80,
  64. render:function(row){
  65. if(null !=row.purchase_status){
  66. var purchase_status = "";
  67. $.ajax({
  68. url:'erpSaleInvoiceAciton.do?task=toDict',
  69. async: false,
  70. type: 'post',
  71. data: {"dvalue":row.purchase_status,"type":"erp_purchase_order|purchase_status","userType":"C"},
  72. cache: false,
  73. error: function(obj){
  74. },
  75. success: function(obj){
  76. if(obj!=""){
  77. purchase_status = obj;
  78. }
  79. }
  80. });
  81. return purchase_status;
  82. }
  83. }
  84. },{
  85. display : '付款状态',
  86. name : 'purchase_payment_state',
  87. width : 80,
  88. render:function(row){
  89. if(null !=row.purchase_payment_state){
  90. var purchase_payment_state = "";
  91. $.ajax({
  92. url:'erpSaleInvoiceAciton.do?task=toDict',
  93. async: false,
  94. type: 'post',
  95. data: {"dvalue":row.purchase_payment_state,"type":"erp_purchase_order|purchase_payment_state"},
  96. cache: false,
  97. error: function(obj){
  98. },
  99. success: function(obj){
  100. if(obj!=""){
  101. purchase_payment_state = obj;
  102. }
  103. }
  104. });
  105. return purchase_payment_state;
  106. }
  107. }
  108. }];
  109. grid = $("#maingrid4")
  110. .ligerGrid(
  111. {
  112. columns : columns,
  113. pageSize : 20,
  114. url : 'erpPurchaseOrderAction.do?task=query&time=' + new Date().getTime() + params,
  115. pageParmName : 'p', //页索引参数名,(提交给服务器)
  116. pagesizeParmName : 'pSize', //页记录数参数名,(提交给服务器)
  117. width : '99.9%',
  118. height : '99%',
  119. checkbox : checkbox,
  120. onCheckRow: function(checked, rowdata, rowindex) {
  121. for (var rowid in this.records){
  122. this.unselect(rowid);
  123. }
  124. if(checked){
  125. this.select(rowindex);
  126. }else{
  127. this.unselect(rowindex);
  128. }
  129. }
  130. });
  131. $("#pageloading").hide();
  132. $(".l-grid-hd-cell-btn-checkbox").css("display", "none"); //隱藏checkAll
  133. }
  134. //查询
  135. function searchByKword() {
  136. var s = "";
  137. var purchase_number= $("#purchase_number").val();//采购单编号
  138. if (purchase_number != "" && typeof (purchase_number) != "undefined") {
  139. s += "&purchase_number=" + encodeURI(encodeURI(purchase_number));
  140. }
  141. var purchase_theme= $("#purchase_theme").val();//采购单主题
  142. if (purchase_theme != "" && typeof (purchase_theme) != "undefined") {
  143. s += "&purchase_theme=" + encodeURI(encodeURI(purchase_theme));
  144. }
  145. var purchase_status= $("#purchase_status").val();//采购入库状态
  146. if (purchase_status != "" && typeof (purchase_status) != "undefined") {
  147. s += "&purchaseStatus=" + encodeURI(encodeURI(purchase_status));
  148. }
  149. var purchase_payment_state = $("#purchase_payment_state").val();//采购付款状态
  150. if (purchase_payment_state != "" && typeof (purchase_payment_state) != "undefined") {
  151. s += "&purchase_payment_state=" + encodeURI(encodeURI(purchase_payment_state));
  152. }
  153. var purchase_assigned_user_id = $("#purchase_assigned_user_id").val();//采购负责人
  154. if (purchase_assigned_user_id != "" && typeof (purchase_assigned_user_id) != "undefined") {
  155. s += "&purchase_assigned_user_id=" + encodeURI(encodeURI(purchase_assigned_user_id));
  156. }
  157. var purchase_date_start = $("#purchase_date_start").val();//采购开始时间
  158. if (purchase_date_start != "" && typeof (purchase_date_start) != "undefined") {
  159. s += "&purchase_date_start=" + encodeURI(encodeURI(purchase_date_start));
  160. }
  161. var purchase_date_end = $("#purchase_date_end").val();//采购结束时间
  162. if (purchase_date_end != "" && typeof (purchase_date_end) != "undefined") {
  163. s += "&purchase_date_end=" + encodeURI(encodeURI(purchase_date_end));
  164. }
  165. grid.set("newPage","1");
  166. $(function() {
  167. initPurchaseGridList(s);
  168. });
  169. }
  170. //导出采购EXCEL
  171. function exportExcel(){
  172. var s = "";
  173. var purchase_number= $("#purchase_number").val();//采购单编号
  174. if (purchase_number != "" && typeof (purchase_number) != "undefined") {
  175. s += "&purchase_number=" + encodeURI(encodeURI(purchase_number));
  176. }
  177. var purchase_theme= $("#purchase_theme").val();//采购单主题
  178. if (purchase_theme != "" && typeof (purchase_theme) != "undefined") {
  179. s += "&purchase_theme=" + encodeURI(encodeURI(purchase_theme));
  180. }
  181. var purchase_status= $("#purchase_status").val();//采购入库状态
  182. if (purchase_status != "" && typeof (purchase_status) != "undefined") {
  183. s += "&purchaseStatus=" + encodeURI(encodeURI(purchase_status));
  184. }
  185. var purchase_payment_state = $("#purchase_payment_state").val();//采购付款状态
  186. if (purchase_payment_state != "" && typeof (purchase_payment_state) != "undefined") {
  187. s += "&purchase_payment_state=" + encodeURI(encodeURI(purchase_payment_state));
  188. }
  189. var purchase_assigned_user_id = $("#purchase_assigned_user_id").val();//采购负责人
  190. if (purchase_assigned_user_id != "" && typeof (purchase_assigned_user_id) != "undefined") {
  191. s += "&purchase_assigned_user_id=" + encodeURI(encodeURI(purchase_assigned_user_id));
  192. }
  193. var purchase_date_start = $("#purchase_date_start").val();//采购开始时间
  194. if (purchase_date_start != "" && typeof (purchase_date_start) != "undefined") {
  195. s += "&purchase_date_start=" + encodeURI(encodeURI(purchase_date_start));
  196. }
  197. var purchase_date_end = $("#purchase_date_end").val();//采购结束时间
  198. if (purchase_date_end != "" && typeof (purchase_date_end) != "undefined") {
  199. s += "&purchase_date_end=" + encodeURI(encodeURI(purchase_date_end));
  200. }
  201. window.open('erpPurchaseOrderAction.do?task=exportPurchaseExcel&time=' + new Date().getTime()+s,'导出EXCEL',"fullscreen=1")
  202. }
  203. //关闭窗口
  204. function f_Cancel(item, dialog){
  205. dialog.close();
  206. }
  207. function f_select() {
  208. var rows = grid.getCheckedRows();
  209. return rows;
  210. }
  211. //综合报表
  212. function searchReport(){
  213. var s = "";
  214. var purchase_number= $("#purchase_number").val();//采购单编号
  215. if (purchase_number != "" && typeof (purchase_number) != "undefined") {
  216. s += "&purchase_number=" + encodeURI(encodeURI(purchase_number));
  217. }
  218. var purchase_theme= $("#purchase_theme").val();//采购单主题
  219. if (purchase_theme != "" && typeof (purchase_theme) != "undefined") {
  220. s += "&purchase_theme=" + encodeURI(encodeURI(purchase_theme));
  221. }
  222. var purchase_status= $("#purchase_status").val();//采购入库状态
  223. if (purchase_status != "" && typeof (purchase_status) != "undefined") {
  224. s += "&purchaseStatus=" + encodeURI(encodeURI(purchase_status));
  225. }
  226. var purchase_payment_state = $("#purchase_payment_state").val();//采购付款状态
  227. if (purchase_payment_state != "" && typeof (purchase_payment_state) != "undefined") {
  228. s += "&purchase_payment_state=" + encodeURI(encodeURI(purchase_payment_state));
  229. }
  230. var purchase_assigned_user_id = $("#purchase_assigned_user_id").val();//采购负责人
  231. if (purchase_assigned_user_id != "" && typeof (purchase_assigned_user_id) != "undefined") {
  232. s += "&purchase_assigned_user_id=" + encodeURI(encodeURI(purchase_assigned_user_id));
  233. }
  234. var purchase_date_start = $("#purchase_date_start").val();//采购开始时间
  235. if (purchase_date_start != "" && typeof (purchase_date_start) != "undefined") {
  236. s += "&purchase_date_start=" + encodeURI(encodeURI(purchase_date_start));
  237. }
  238. var purchase_date_end = $("#purchase_date_end").val();//采购结束时间
  239. if (purchase_date_end != "" && typeof (purchase_date_end) != "undefined") {
  240. s += "&purchase_date_end=" + encodeURI(encodeURI(purchase_date_end));
  241. }
  242. window.open('erpPurchaseOrderAction.do?task=reportPurchaseOrder&time=' + new Date().getTime()+s,'采购综合报表',"fullscreen=1")
  243. }
  244. </script>
  245. </head>
  246. <body>
  247. <%@ include file="/include/message.jsp"%>
  248. <div class="container">
  249. <div class="default_search" style="margin: 0;">
  250. <ul style="width: 100px;padding-left:25px;">
  251. <li class="search-button"><input type="button" class='l-button'
  252. name="search" onclick="searchByKword()" value="查询" /></li>
  253. </ul>
  254. <ul style="width: 160px;">
  255. <li class="search-button"><input type="button" class='l-button'
  256. name="search" onclick="searchReport()" value="生成采购综合报表" style="width: 140px;"/>
  257. </li>
  258. </ul>
  259. <ul>
  260. <li class="search-button"><input type="button" class='l-button'
  261. name="search" onclick="exportExcel()" value="导出采购EXCEL" style="width: 100px;"/></li>
  262. </ul>
  263. <ul class="list_search" style="width: 300px;clear: both;">
  264. <li class="title">采购单号:</li>
  265. <li class="text"><input type="text" name="purchase_number" id="purchase_number">
  266. </li>
  267. </ul>
  268. <ul class="list_search" style="width: 300px;">
  269. <li class="title">采购单主题:</li>
  270. <li class="text"><input type="text" name="purchase_theme" id="purchase_theme">
  271. </li>
  272. </ul>
  273. <ul class="list_search" >
  274. <li class="title">采购日期:</li>
  275. <li class="text" >
  276. <input type="text" class="Wdate" name="purchase_date_start" id="purchase_date_start" onclick="WdatePicker({skin:'blue',dateFmt:'yyyy-MM-dd',maxDate:'#F{$dp.$D(\'purchase_date_end\',{d:-1})}'})">
  277. <input type="text" class="Wdate" name="purchase_date_end" id="purchase_date_end" onclick="WdatePicker({skin:'blue',dateFmt:'yyyy-MM-dd',minDate:'#F{$dp.$D(\'purchase_date_start\',{d:1})}'})">
  278. </li>
  279. </ul>
  280. <ul class="list_search" style="clear: both;width: 300px;">
  281. <li class="title">入库状态:</li>
  282. <li class="text">
  283. <select id="purchase_status" name="purchase_status" class="short-text" style="width:100px;">
  284. <option value="" selected="selected">--请选择--</option>
  285. <c:forEach items="${requestScope.purchase_status}" var="purchase_status">
  286. <option value="${purchase_status.dvalue }">${purchase_status.dname }</option>
  287. </c:forEach>
  288. </select>
  289. </li>
  290. </ul>
  291. <ul class="list_search" style="width: 300px;">
  292. <li class="title">付款状态:</li>
  293. <li class="text">
  294. <select id="purchase_payment_state" name="purchase_payment_state" class="short-text" style="width:100px;">
  295. <option value="" selected="selected">--请选择--</option>
  296. <c:forEach items="${requestScope.purchase_payment_state}" var="purchase_payment_state">
  297. <option value="${purchase_payment_state.dvalue }">${purchase_payment_state.dname }</option>
  298. </c:forEach>
  299. </select>
  300. </li>
  301. </ul>
  302. <ul class="list_search" >
  303. <li class="title">采购负责人:</li>
  304. <li class="text" >
  305. <input type="hidden" name="purchase_assigned_user_id" id="purchase_assigned_user_id">
  306. <input type="text" name="purchase_assigned_user_name" id="purchase_assigned_user_name" readonly="readonly">
  307. <input type="button" class="l-button" style="width: 60px;height: 28px;" id="selectuserbutton" value="选择" />
  308. </li>
  309. </ul>
  310. </div>
  311. <div style="clear:both;"></div>
  312. <div id="searchbar">
  313. <div style="overflow: hidden; clear: both;">
  314. <div id="maingrid4" style="margin: 0; padding: 0"></div>
  315. </div>
  316. </div>
  317. </div>
  318. </body>
  319. </html>