query.jsp 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253
  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
  3. <%
  4. String path = request.getContextPath();
  5. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  6. %>
  7. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  8. <html>
  9. <head>
  10. <base href="<%=basePath%>">
  11. <title>工票查询</title>
  12. <meta name="viewport" content="width=device-width,minimum-scale=1,maximum-scale=1,initial-scale=1,user-scalable=no" />
  13. <meta http-equiv="pragma" content="no-cache">
  14. <meta http-equiv="cache-control" content="no-cache">
  15. <meta http-equiv="expires" content="0">
  16. <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  17. <meta http-equiv="description" content="This is my page">
  18. <script src="http://res.wx.qq.com/open/js/jweixin-1.0.0.js"></script>
  19. <!-- 导入jqueryWeui样式
  20. <link rel="stylesheet" href="https://cdn.bootcss.com/weui/1.1.2/style/weui.min.css">
  21. <link rel="stylesheet" href="https://cdn.bootcss.com/jquery-weui/1.2.0/css/jquery-weui.min.css">-->
  22. <script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery-2.1.4.js"></script>
  23. <link rel="stylesheet" href="${pageContext.request.contextPath }/jsp/js/jqueryWeui/weui.min.css">
  24. <link rel="stylesheet" href="${pageContext.request.contextPath }/jsp/js/jqueryWeui/jquery-weui.css">
  25. <link rel="stylesheet" href="${pageContext.request.contextPath }/jsp/js/jqueryWeui/demos.css">
  26. <script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
  27. <!-- 导入jqueryWeui样式 -->
  28. </head>
  29. <style>
  30. body{background-color:#eee;font-size: 17px; }
  31. #tou{background-color:#fff; width: 100%; text-align: left; height:45px;line-height: 40px; padding-top: 6px;}
  32. .context{background-color: #fff; margin-top: 20px; text-align: center; padding: 20px 0 10px;}
  33. .shuju{margin: 0 auto; margin-top: 15px; width: 95%; text-align: center; font-size: 14px;}
  34. .shuju tr{height:35px;}
  35. .shuju th{background-color: #eee; font-size: 16px;}
  36. .spt{
  37. padding:0px;
  38. line-height:1.5;
  39. }
  40. #chaxun a{
  41. margin:0 20 0 10px;
  42. }
  43. </style>
  44. <body>
  45. <div class="weui-flex" id="tou" >
  46. <div class="weui-flex__item" id="gly">&nbsp;
  47. <c:if test="${user.user_level == 1 }">普工单选:</c:if>
  48. <c:if test="${user.user_level == 2 }">管理员:</c:if>
  49. <c:if test="${user.user_level == 3 }">三工段:</c:if>
  50. <c:if test="${user.user_level == 4 }">普工多选:</c:if>
  51. <c:if test="${user.user_level == 5 }">超级管理员:</c:if>
  52. ${user.user_name }
  53. </div>
  54. <div class="weui-flex__item" id="ghl">&nbsp;工号:${user.job_number }</div>
  55. <input type="hidden" id="gonghao" value="${user.job_number }">
  56. </div>
  57. <!-- <div><font color="red">注:只能查询登录本人自己的工票</font></div> -->
  58. <div class="context">
  59. <!-- <table style="margin: 0 auto; width: 75%; height: 40px; text-align: center;" border="1" cellspacing="0" bordercolor="#ccc">
  60. <tr>
  61. <td><input type="radio" name="time" value="1" onclick="chaxun(1)">当天工票</td>
  62. <td><input type="radio" name="time" value="2" onclick="chaxun(2)">本周工票</td>
  63. <td><input type="radio" name="time" value="3" onclick="chaxun(3)">本月工票</td>
  64. </tr>
  65. </table> -->
  66. <div class="weui-cell" style="background-color: #eee; margin-bottom: 10px;">
  67. <!-- -->
  68. <div class="weui-cell__bd" >
  69. <div class="weui-cell__hd"><label for="" class="weui-label">开始日期</label></div>
  70. <input class="weui-input" id="time" type="date" value="">
  71. </div>
  72. <div class="weui-cell__bd">
  73. <div class="weui-cell__hd"><label for="" class="weui-label">结束日期</label></div>
  74. <input class="weui-input" id="timed" type="date" value="">
  75. </div>
  76. </div>
  77. <div id="chaxun">
  78. <a href="javascript:chaxun(2);" class="weui-btn weui-btn_mini weui-btn_primary" >普通查询</a>
  79. <a href="javascript:chaxun(1);" class="weui-btn weui-btn_mini weui-btn_primary">汇总查询</a>
  80. </div>
  81. <div style="margin-top: 10px;">工票张数:<span id="zhang">0</span>,合计包数:<span id="bao">0</span>,合计件数:<span id="jiang">0</span>,工资总计:<span id="gongzi">0</span></div>
  82. <div id="biaoge"></div>
  83. </div>
  84. <!-- jqueryWeui样式
  85. <script src="https://cdn.bootcss.com/jquery/1.11.0/jquery.min.js"></script>
  86. <script src="https://cdn.bootcss.com/jquery-weui/1.2.0/js/jquery-weui.min.js"></script>-->
  87. <!-- jqueryWeui样式 -->
  88. <!-- 如果使用了某些拓展插件还需要额外的JS
  89. <script src="https://cdn.bootcss.com/jquery-weui/1.2.0/js/swiper.min.js"></script>
  90. <script src="https://cdn.bootcss.com/jquery-weui/1.2.0/js/city-picker.min.js"></script> -->
  91. <script type="text/javascript">
  92. window.onload=function(){
  93. var username = sessionStorage.getItem("ur");
  94. var jobnumber = sessionStorage.getItem("gh");
  95. //alert(username+""+jobnumber );
  96. if(username!=null&&jobnumber!=null){
  97. document.getElementById("gly").innerHTML="用户:"+username;
  98. document.getElementById("ghl").innerHTML="工号:"+jobnumber;
  99. }
  100. var date = new Date();
  101. var seperator1 = "-";
  102. var year = date.getFullYear();
  103. var month = date.getMonth() + 1;
  104. var strDate = date.getDate();
  105. if (month >= 1 && month <= 9) {
  106. month = "0" + month;
  107. }
  108. if (strDate >= 0 && strDate <= 9) {
  109. strDate = "0" + strDate;
  110. }
  111. var currentdate = year + seperator1 + month + seperator1 + strDate;
  112. $("#time").val(currentdate);
  113. $("#timed").val(currentdate);
  114. };
  115. function chaxun(event){
  116. var job_number = sessionStorage.getItem("gh");
  117. var data = $("#time").val();
  118. var time2 = $("#timed").val();
  119. if(job_number==null){
  120. job_number= document.getElementById("gonghao").value;
  121. }
  122. if(data == undefined || data == "" ){
  123. alert("请选择日期再查询!", "警告!");
  124. if(time2 == undefined || data == "" ){
  125. alert("请选择结束日期再查询!", "警告!");
  126. }
  127. }else{
  128. console.log("1111")
  129. /* job_number="9528"; */
  130. document.getElementById("chaxun").innerHTML="<a href=\"javascript:;\" class=\"weui-btn weui-btn_mini weui-btn_primary weui-btn_loading\">正在加载...</a>";
  131. //job_number="QT19041281";
  132. $.ajax({
  133. url:"subgetInfo.action",
  134. type:"post",
  135. data:{job_number:job_number,time1:data,time2:time2,biao:event},
  136. dataType:"json",
  137. success:function(data){
  138. /* console.log(data.data); */
  139. if(data.data == undefined){
  140. alert("你当日未提交工序!");
  141. document.getElementById("biaoge").innerHTML="";
  142. document.getElementById("zhang").innerHTML="0";
  143. document.getElementById("bao").innerHTML="0";
  144. document.getElementById("jiang").innerHTML="0";
  145. document.getElementById("chaxun").innerHTML="<a href=\"javascript:chaxun(2);\" class=\"weui-btn weui-btn_mini weui-btn_primary\">普通查询</a><a href=\"javascript:chaxun(1);\" class=\"weui-btn weui-btn_mini weui-btn_primary\">汇总查询</a>";
  146. }else{
  147. //console.info(data.data);//var shuju=data.data;
  148. var shuju = data.data;
  149. var daima="";
  150. var gnumber = 0;
  151. var gongzi = 0;
  152. if(event==1){
  153. daima="<table class=\"shuju\" border=\"1\" cellspacing=\"0\" bordercolor=\"#ccc\"><tr class=\"diyi\"><th>生产号</th><th>款号</th><th>工序名称</th><th>工票数</th><th>数量</th><th>单价</th><th>总计</th></tr>";
  154. for(var i=0;i<shuju.length;i++){
  155. daima += "<td>"+shuju[i].place_num+"</td>";
  156. daima += "<td>"+shuju[i].user_name+"</td>";//款号
  157. gnumber+=parseInt(shuju[i].packe_num);
  158. //znum+=shuju[i].number;
  159. daima += "<td>"+shuju[i].t_name+"</td>";
  160. daima += "<td>"+shuju[i].packe_num+"</td>";//总包数
  161. daima += "<td>"+shuju[i].number+"</td>";
  162. daima += "<td>"+shuju[i].price+"</td>";
  163. daima += "<td>"+shuju[i].money+"</td></tr>";
  164. gongzi += shuju[i].money;
  165. }
  166. daima += "</table><h4 style='margin-top:10px;'>汇总表</h4>";
  167. var map = data.map;
  168. daima+="<table class=\"shuju\" border=\"1\" cellspacing=\"0\" bordercolor=\"#ccc\"><tr class=\"diyi\"><th>生产号</th><th>款号</th><th>工票数</th><th>数量</th></tr>";
  169. for(var key in map){
  170. daima += "<td>"+key+"</td>";
  171. daima += "<td>"+map[key].color+"</td>";
  172. daima += "<td>"+map[key].size+"</td>";
  173. daima += "<td>"+map[key].id+"</td></tr>";
  174. }daima += "</table>";
  175. }else{
  176. daima="<table class=\"shuju\" border=\"1\" cellspacing=\"0\" bordercolor=\"#ccc\"><tr class=\"diyi\"><th>生产号</th><th>工序</th><th>包号</th><th>数量</th><th>时间</th></tr>";
  177. var listt= data.data;
  178. for(var i=0;i<listt.length;i++){
  179. daima += "<td>"+listt[i].place_num+"</td>";
  180. daima += "<td>"+listt[i].t_name+"</td>";
  181. var paknum = listt[i].packe_num.substring(listt[i].packe_num.length-4);
  182. daima += "<td>"+paknum+"</td>";
  183. daima += "<td>"+listt[i].number+"</td>";
  184. var sub_time = listt[i].sub_time.slice(0,-3);
  185. daima += "<td>"+sub_time+"</td></tr>";
  186. }
  187. gnumber = listt.length;
  188. daima += "</table>";
  189. }
  190. document.getElementById("biaoge").innerHTML=daima;
  191. document.getElementById("zhang").innerHTML=gnumber;
  192. document.getElementById("bao").innerHTML=gnumber;
  193. document.getElementById("jiang").innerHTML=data.bao;
  194. document.getElementById("gongzi").innerHTML=gongzi;
  195. document.getElementById("chaxun").innerHTML="<a href=\"javascript:chaxun(2);\" class=\"weui-btn weui-btn_mini weui-btn_primary\">普通查询</a><a href=\"javascript:chaxun(1);\" class=\"weui-btn weui-btn_mini weui-btn_primary\">汇总查询</a>";
  196. }
  197. }
  198. });
  199. }
  200. }
  201. function shengqing(id){
  202. if(confirm("您确认申请作废吗,申请了就不可更改了?")){
  203. $.ajax({
  204. url:"subtovoid.action?id="+id,
  205. type:"post",
  206. dataType:"json",
  207. success:function(data){
  208. if(data.ok == undefined){
  209. alert("申请提交失败!");
  210. }else{
  211. alert("申请提交成功,待管理员确认!");
  212. var oo="zuo"+id;
  213. document.getElementById(oo).innerHTML="<font color=\"red\">待批准</font>";
  214. }
  215. }
  216. });return;
  217. }
  218. return false;
  219. /* $.confirm("您确认申请作废吗,申请了就不可更改了?", "确认申请?", function() {
  220. $.ajax({
  221. url:"subtovoid.action?id="+id,
  222. type:"post",
  223. dataType:"json",
  224. success:function(data){
  225. if(data.ok == undefined){
  226. $.toast("申请提交失败!");
  227. }else{
  228. $.toast("申请提交成功,待管理员确认!");
  229. var oo="zuo"+id;
  230. document.getElementById(oo).innerHTML="<font color=\"red\">待批准</font>";
  231. }
  232. }
  233. });
  234. }, function() {
  235. $.toast("已取消申请!", 'cancel');
  236. });*/
  237. }
  238. </script>
  239. </body>
  240. </html>