upload.jsp 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288
  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2. pageEncoding="UTF-8"%>
  3. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
  4. <c:set value="<%=request.getContextPath()%>" var="ctx"></c:set>
  5. <!DOCTYPE html>
  6. <html>
  7. <head>
  8. <meta charset="utf-8">
  9. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  10. <title>表单</title>
  11. <meta name="keywords" content="关键字台">
  12. <meta name="description" content="描述">
  13. <link href="${ctx}/css/bootstrap.min.css?v=3.3.6" rel="stylesheet">
  14. <link href="${ctx}/css/font-awesome.css?v=4.4.0" rel="stylesheet">
  15. <link href="${ctx}/css/bootstrap-select.min.css" rel="stylesheet">
  16. <link href="${ctx}/css/plugins/bootstrap-table/bootstrap-table.min.css" rel="stylesheet">
  17. <link href="${ctx}/css/animate.css" rel="stylesheet">
  18. <link href="${ctx}/css/style.css?v=4.1.0" rel="stylesheet">
  19. <style>
  20. .col-sm-1{
  21. width:100px !important;
  22. }
  23. </style>
  24. </head>
  25. <body>
  26. <div class="wrapper wrapper-content animated fadeInRight">
  27. <div class="row">
  28. <div class="col-sm-12">
  29. <div class="ibox">
  30. <div class="ibox-title">
  31. <div class="row">
  32. <div class="col-sm-10">
  33. <h3>产线数据</h3>
  34. </div>
  35. <div class="col-sm-2">
  36. <div class="ibox-tools">
  37. <!-- <button class="btn btn-success" onclick="addUser();"> -->
  38. <!-- <i class="glyphicon glyphicon-plus"></i> 添加用户 -->
  39. <!-- </button> -->
  40. </div>
  41. </div>
  42. </div>
  43. </div>
  44. <div class="ibox-content">
  45. <div class="row row-lg">
  46. <form class="form-horizontal m-t" >
  47. <div id="condition">
  48. <div>
  49. <label class="col-sm-1 control-label"><span class="text-danger"></span>箱码:</label>
  50. <div class="col-sm-2">
  51. <input id="id" class="form-control" placeholder="箱码"/>
  52. </div>
  53. </div>
  54. <div>
  55. <label class="col-sm-1 control-label"><span class="text-danger"></span>任务单号:</label>
  56. <div class="col-sm-2">
  57. <input id="task_no" class="form-control" placeholder="任务单号"/>
  58. </div>
  59. </div>
  60. <div>
  61. <label class="col-sm-1 control-label"><span class="text-danger"></span>托码:</label>
  62. <div class="col-sm-2">
  63. <input id="duo_code" class="form-control " placeholder="托码"/>
  64. </div>
  65. </div>
  66. <div>
  67. <label class="col-sm-1 control-label"><span class="text-danger"></span>生产线:</label>
  68. <div class="col-sm-2">
  69. <select id="lineName" class="form-control " placeholder="生产线">
  70. </select>
  71. </div>
  72. </div>
  73. </div>
  74. <div style="width: 100%;height: 10px;display: flex;"></div>
  75. <div>
  76. <label class="col-sm-1 control-label"><span class="text-danger"></span>生产日期:</label>
  77. <div class="col-sm-2">
  78. <input id="startdate" class="form-control form_datetime" placeholder="请输入开始日期"/>
  79. </div>
  80. <div class="col-sm-2">
  81. <input id="enddate" class="form-control form_datetime" placeholder="请输入结束日期"/>
  82. </div>
  83. </div>
  84. <button style="" type="button" id="searchBtn" class="btn btn-success" onclick="search();return false;">搜索</button>
  85. </form>
  86. </div>
  87. <div class="row row-lg">
  88. <div class="col-sm-12">
  89. <table id="table" data-toggle="table" data-mobile-responsive="true">
  90. </table>
  91. </div>
  92. </div>
  93. </div>
  94. </div>
  95. </div>
  96. </div>
  97. <!-- 全局js -->
  98. <script src="${ctx}/js/jquery.min.js?v=2.1.4"></script>
  99. <script src="${ctx}/js/bootstrap.min.js?v=3.3.6"></script>
  100. <script src="${ctx}/js/bootstrap-select.min.js"></script>
  101. <!-- 自定义js -->
  102. <script src="${ctx}/js/content.js?v=1.0.0"></script>
  103. <!-- jQuery Validation plugin javascript-->
  104. <script src="${ctx}/js/plugins/validate/jquery.validate.min.js"></script>
  105. <script src="${ctx}/js/plugins/validate/messages_zh.min.js"></script>
  106. <script src="${ctx}/js/plugins/bootstrap-table/bootstrap-table.min.js"></script>
  107. <script src="${ctx}/js/plugins/bootstrap-table/bootstrap-table-mobile.min.js"></script>
  108. <script src="${ctx}/js/plugins/bootstrap-table/locale/bootstrap-table-zh-CN.min.js"></script>
  109. <script src="${ctx}/js/common.js"></script>
  110. <script src="${ctx}/js/plugins/layer/layer.min.js"></script>
  111. <script src="${ctx}/js/Math.uuid.js"></script>
  112. <script src="${ctx}/js/laydate/laydate.js"></script>
  113. </div>
  114. </body>
  115. <script>
  116. var table = null;
  117. $(document).ready(function(){
  118. var doms = $(".form_datetime");
  119. for(let i =0;i<doms.length;i++){
  120. let dom = doms[i];
  121. let id = dom.id;
  122. console.log(id);
  123. let end = {
  124. elem : '#'+id,
  125. format : 'YYYY-MM-DD',
  126. istime : false,
  127. istoday : true,
  128. };
  129. laydate(end);
  130. }
  131. table = $('#table').bootstrapTable("destroy");//通过AJAX必须先destroy不知道为啥
  132. initTable();
  133. lineData();
  134. });
  135. function queryParams(param){
  136. let id = $("#id").val();
  137. let task_no = $("#task_no").val();
  138. let duo_code = $("#duo_code").val();
  139. let startdate = $("#startdate").val();
  140. let enddate = $("#enddate").val();
  141. let lineName = $("#lineName").val();
  142. param["key"] = 'jinzai_upload_master';
  143. param['toolBarConfig'] = JSON.stringify([{type:"input",key:"id"},
  144. {type:"input",key:"task_no"},
  145. {type:"input",key:"duo_code"},
  146. {type:"input",key:"device_no"}]);
  147. if(id){
  148. param['id'] = id;
  149. }
  150. if(startdate){
  151. param['datefield'] = 'produce_date';
  152. param['startdate'] = startdate;
  153. }
  154. if(enddate){
  155. param['datefield'] = 'produce_date';
  156. param['enddate'] = enddate;
  157. }
  158. if(task_no){
  159. param['task_no'] = task_no;
  160. }
  161. if(duo_code){
  162. param['duo_code'] = duo_code;
  163. }
  164. if(lineName){
  165. param['device_no'] = lineName;
  166. }
  167. return param;
  168. }
  169. function lineData(){
  170. var param = {"pageSize":100,"pageNumber":1,"sortOrder":"asc",key:"t_jz_device"}
  171. $.ajax({
  172. url:"${ctx}/uploadData/query",
  173. data:param,
  174. success:function(data){
  175. $("#lineName").html('<option value="">全部</option>');
  176. for(var i=0;i<data.rows.length;i++){
  177. $("#lineName").append('<option value="'+data.rows[i].device_no+'">'+data.rows[i].lineName+'</option>')
  178. }
  179. }
  180. })
  181. }
  182. function search(){
  183. table = $('#table').bootstrapTable("destroy");
  184. initTable();
  185. }
  186. function initTable(){
  187. var index = 1;
  188. table = $('#table').bootstrapTable({
  189. method: 'get',
  190. sortable : true,
  191. toolbar: '#toolbar', //工具按钮用哪个容器
  192. striped: true, //是否显示行间隔色
  193. cache: false, //是否使用缓存,默认为true,所以一般情况下需要设置一下这个属性(*)
  194. pagination: true, //是否显示分页(*)
  195. pageNumber:1, //初始化加载第一页,默认第一页
  196. pageSize: 10, //每页的记录行数(*)
  197. pageList: [10, 25, 50, 100], //可供选择的每页的行数(*)
  198. url: "${ctx}/uploadData/query",//这个接口需要处理bootstrap table传递的固定参数
  199. queryParamsType:'', //默认值为 'limit' ,在默认情况下 传给服务端的参数为:offset,limit,sort
  200. // 设置为 '' 在这种情况下传给服务器的参数为:pageSize,pageNumber
  201. queryParams: queryParams,//前端调用服务时,会默认传递上边提到的参数,如果需要添加自定义参数,可以自定义一个函数返回请求参数
  202. sidePagination: "server", //分页方式:client客户端分页,server服务端分页(*)
  203. // search: true, //是否显示表格搜索,此搜索是客户端搜索,不会进服务端,所以,个人感觉意义不大
  204. strictSearch: false,
  205. //showColumns: true, //是否显示所有的列
  206. // showRefresh: true, //是否显示刷新按钮
  207. minimumCountColumns: 2, //最少允许的列数
  208. clickToSelect: true, //是否启用点击选中行
  209. searchOnEnterKey: true,
  210. idField : "id",
  211. columns: [{
  212. field:"task_no",
  213. title:"任务单号",
  214. formatter:function(value,data){
  215. return "<div style='word-wrap: normal;word-wrap: break-word;width:150px'>"+value+"</div>"
  216. }
  217. },
  218. {
  219. field:"id",
  220. title:"箱码",
  221. formatter:function(value,data){
  222. return "<div style='word-wrap: normal;word-wrap: break-word;width:150px'>"+value+"</div>"
  223. }
  224. },{
  225. field:"duo_code",
  226. title:"托码",
  227. formatter:function(value,data){
  228. return "<div style='word-wrap: normal;word-wrap: break-word;width:150px'>"+value+"</div>"
  229. }
  230. },{
  231. field:"lineName",
  232. title:"产线",
  233. },
  234. {
  235. field:"pinxiang",
  236. title:"品项",
  237. }, {
  238. field:"kouwei",
  239. title:"口味",
  240. },{
  241. field:"produce_date",
  242. title:"生产日期",
  243. },
  244. {
  245. field:"sku",
  246. title:"sku",
  247. }
  248. ,
  249. {
  250. field:"guo_time",
  251. title:"绑定时间",
  252. }
  253. ],
  254. });
  255. }
  256. </script>
  257. <%--<%@include file="../common/table.jsp"%>--%>
  258. <script>
  259. </script>