bach.html 9.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  5. <meta name="ctx" content="" />
  6. <link rel="stylesheet" type="text/css" href="/static/easyui/themes/default/easyui.css">
  7. <link rel="stylesheet" type="text/css" href="/static/easyui/themes/icon.css">
  8. <link rel="stylesheet" type="text/css" href="/static/styles/demo.css">
  9. <link rel="stylesheet" type="text/css" href="/static/uploadify/uploadify.css">
  10. <link rel="stylesheet" type="text/css" href="/Public/libs/css/export.css">
  11. <script type="text/javascript" src="/static/basejs/jquery-1.8.0.min.js"></script>
  12. <script type="text/javascript" src="/static/easyui/jquery.easyui.min.js"></script>
  13. <script type="text/javascript" src="/static/easyui/easyui-lang-zh_CN.js"></script>
  14. <script type="text/javascript" src="/static/uploadify/jquery.uploadify.js"></script>
  15. <script type="text/javascript" src="/static/basejs/th.js"></script>
  16. <script type="text/javascript" src="/static/easyui/src/jquery.window.js"></script>
  17. <script type="text/javascript" src="/static/easyui/formatter.js"></script>
  18. <script type="text/javascript" src="/static/easyui/easyui-extend.js"></script>
  19. <script type="text/javascript" src="/static/easyui/easyui-validatebox-extend.js"></script>
  20. <script type="text/javascript" src="/static/easyui/easyui-loading.js"></script>
  21. <script type="text/javascript" src="/static/basejs/jquery.qrcode.min.js"></script>
  22. <script type="text/javascript" src="/static/basejs/LodopFuncs.js"></script>
  23. <script type="text/javascript" src="/static/basejs/newqcode.js"></script>
  24. <script type="text/javascript" src="/static/basejs/template.js"></script>
  25. </head>
  26. <body class="easyui-layout">
  27. <div data-options="region:'north',title:'',split:true" style="height: 830px;border:none">
  28. <div id="supBthGridToolbar">
  29. <form id="searchBthForm" class="smShow">
  30. <table width=1000px style="white-space: nowrap;padding:10px;">
  31. <tr>
  32. <td align="left">
  33. 辅料名称:
  34. </td>
  35. <td>
  36. <select name="sysCdNm" style="height:30px;" >
  37. <option value="0">全部</option>
  38. <volist name="productlist" id="val">
  39. <option value="{$val.product_name}">{$val.product_name}</option>
  40. </volist>
  41. </select>
  42. </td>
  43. <td align="left">
  44. 公司名称:
  45. </td>
  46. <td>
  47. <select name="user_name" style="height:30px;">
  48. <volist name="userlist" id="val">
  49. <option value="{$val.id}">{$val.nickname}</option>
  50. </volist>
  51. </select>
  52. </td>
  53. <td align="left">
  54. 生产开始时间:
  55. </td>
  56. <td>
  57. <input id ="startDate" name="startDate" class="easyui-datebox" style="width:150px" type="text" value="" data-options="editable:false"/>
  58. </td>
  59. <td align="left">
  60. 生产结束时间:
  61. </td>
  62. <td>
  63. <input id ="endDate" name="endDate" class="easyui-datebox" style="width:150px" type="text" value="" data-options="editable:false"/>
  64. </td>
  65. <td colspan="2" align="center">
  66. <a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-search'" onclick="searchBthFun()">查询</a>
  67. </td>
  68. <tr/>
  69. </table>
  70. </form>
  71. </div>
  72. <table id="supBthGrid">
  73. </table>
  74. <div class="body"></div>
  75. </div>
  76. <script>
  77. var supBthGrid, supTgGrid, printType;
  78. bt_is_load=true;//定义防重复弹出小标签全局变量
  79. $(document).ready(function () {
  80. //初始化日期输入框
  81. initDateBox();
  82. supBthGrid = $('#supBthGrid').datagrid({
  83. url: '/index.php?s=/Admin/Export/getExcelData',
  84. method: 'post',
  85. toolbar: '#supBthGridToolbar',
  86. striped : true,
  87. showFooter:false,
  88. rownumbers: true, // 如果为true,则显示一个行号列。
  89. singleSelect: false, // 如果为true,则只允许选择一行。
  90. nowrap: false, // 如果为true,则在同一行中显示数据。设置为true可以提高加载性能。
  91. fit: true, // datagrid自适应宽高
  92. fitColumns: true, // 使列自动展开/收缩到合适的数据表格宽度。
  93. autoRowHeight: false, // 定义设置行的高度,根据该行的内容。设置为false可以提高负载性能。
  94. sortName: 'id', // 排序字段
  95. sortOrder: 'desc', // 排序方式
  96. pagination: true, // 显示分页工具条
  97. pageSize: 100,//初始化页面大小
  98. pageList: [10, 20, 30, 50, 100, 500,1000,2000,5000,10000],// 初始化页面大小选择列表
  99. queryParams: $('#searchBthForm').serializeObject(),
  100. columns: [[
  101. {field: 'matter_name', title: '辅料名称', sortable: true, width: 200},
  102. {field: 'matter_no', title: '辅料规格', sortable: true, width: 200},
  103. {field: 'large_num', title: '大件数量', align: 'center', sortable: true, width: 100},
  104. {field: 'small_num', title: '小件数量', align: 'center', sortable: true, width: 100},
  105. {field: 'date', title: '创建日期', align: 'center', sortable: true, width: 150,
  106. formatter: function(value,row,index){
  107. return UnixToDate(value,true,8);
  108. }
  109. },
  110. {field: 'file_dir', title: '点击下载', align: 'center', sortable: true, width: 200,
  111. formatter: function(value,row,index){
  112. return "<a href="+value+">点击下载</a>";
  113. }
  114. },
  115. {field:'status',title:'状态',align:'center',sortable:false,width:100,
  116. formatter: function(value,row,index){
  117. if(value==0){
  118. return '已发货';
  119. }else{
  120. return '已删除';
  121. }
  122. }
  123. },
  124. {field:'id',title:'操作',align:'center',sortable:false,width:100,
  125. formatter: function(value,row,index){
  126. if(row.status==0){
  127. return '<a class="red" data-id='+value+' onclick="deal('+value+')">删除</a>';
  128. }else{
  129. //return '<a class="green" data-id='+value+' onclick="fa('+value+')">发货</a>';
  130. }
  131. }
  132. }
  133. ]],
  134. onClickRow: function (rowIndex, rowData) {
  135. $('#supBthGrid').datagrid('unselectRow', rowIndex);
  136. },
  137. onClickCell:function(rowIndex, field, value){
  138. },
  139. onLoadError: function () {
  140. //$.messager.alert('系统提示', '数据加载错误,请刷新重试!', 'error');
  141. },
  142. onBeforeLoad: function (param,data) {
  143. /*if (supBthGrid != null) {
  144. supBthGrid.datagrid('loadData', {total: 0, rows: []});
  145. }
  146. if (supTgGrid != null) {
  147. supTgGrid.datagrid('loadData', {total: 0, rows: []});
  148. }
  149. return true;*/
  150. },
  151. onLoadSuccess: function(data,options){
  152. }
  153. });
  154. });
  155. function deal(id){
  156. $('.body').loading();
  157. $.ajax({
  158. url: "/index.php?s=/Admin/Export/changeExcelData",
  159. type: "post",
  160. dataType: "json",
  161. data: {id:id},
  162. success: function (data) {
  163. //console.log(data);
  164. $('.body').loadend();
  165. if (data != null) {
  166. if (data.status == 0) {
  167. $.messager.alert('系统提示', data.msg, 'error');
  168. supBthGrid.datagrid('load', $('#searchBthForm').serializeObject());
  169. } else {
  170. $.messager.alert('系统提示', data.msg, 'success',function(){
  171. supBthGrid.datagrid('load', $('#searchBthForm').serializeObject());
  172. });
  173. }
  174. }
  175. },
  176. error: function (error) {
  177. }
  178. })
  179. }
  180. function fa(id){
  181. }
  182. //初始化日期输入框
  183. function initDateBox() {
  184. var nowDate = new Date;
  185. $('#endDate').datebox('setValue', nowDate.Format("yyyy-MM-dd"));
  186. nowDate.setMonth(nowDate.getMonth() - 1);
  187. nowDate.setDate(nowDate.getDay() +1);
  188. $('#startDate').datebox('setValue', nowDate.Format("yyyy-MM-dd"));
  189. }
  190. function searchBthFun() {
  191. if ($('#searchBthForm').form('validate')) {
  192. //var obj = $('#searchBthForm').serializeObject();
  193. supBthGrid.datagrid('load', $('#searchBthForm').serializeObject());
  194. }
  195. }
  196. function UnixToDate(unixTime, isFull, timeZone) {
  197. if (typeof (timeZone) == 'number') {
  198. unixTime = parseInt(unixTime) + parseInt(timeZone) * 60 * 60;
  199. }
  200. var time = new Date(unixTime * 1000);
  201. var ymdhis = "";
  202. ymdhis += time.getUTCFullYear() + "-";
  203. ymdhis += (time.getUTCMonth() + 1) + "-";
  204. ymdhis += time.getUTCDate();
  205. if (isFull === true) {
  206. ymdhis += " " + time.getUTCHours() + ":";
  207. ymdhis += time.getUTCMinutes() + ":";
  208. ymdhis += time.getUTCSeconds();
  209. }
  210. return ymdhis;
  211. }
  212. </script>
  213. </body>
  214. </html>