Нет описания

complaintProductDateSheet.html 13KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  6. <title>产品日期分布情况表</title>
  7. <!--[if lt IE 9]>
  8. <meta http-equiv="refresh" content="0;ie.html" />
  9. <![endif]-->
  10. <script src="../Script/Common/huayi.load.js"></script>
  11. <script src="../Script/Common/huayi.config.js"></script>
  12. <link rel="stylesheet" href="../js/select2/css/select2.min.css" />
  13. <link rel="stylesheet" href="../css/init.css" />
  14. <style>
  15. .zxtable {
  16. font-size: 12px;
  17. background: #F5F5F5;
  18. }
  19. .zxt-top {
  20. background: #FFFFFF;
  21. height: 60px;
  22. width: 95%;
  23. margin: 40px auto 0 auto;
  24. padding: 10px 20px;
  25. }
  26. .topCon {
  27. float: right;
  28. margin-right: 45px;
  29. }
  30. .zxt-content {
  31. width: 95%;
  32. margin: 0 auto;
  33. }
  34. .zxt-table {
  35. overflow-x: auto;
  36. }
  37. .zxt-table table {
  38. font-size: 12px;
  39. margin: 40px auto;
  40. width: 85%;
  41. max-width: 100%;
  42. background: #FFFFFF;
  43. }
  44. .zxt-table table tr td {
  45. /*background: #1ab394;*/
  46. /*color: #fff;*/
  47. }
  48. .header-num-date{
  49. position: relative;
  50. }
  51. .num-header{
  52. position: absolute;
  53. top: 10px;
  54. right: 10px;
  55. }
  56. .date-header{
  57. position: absolute;
  58. left: 10px;
  59. bottom: 10px;
  60. }
  61. </style>
  62. </head>
  63. <body class="gray-bg" style="background: #fefefe;">
  64. <div class="zxtable">
  65. <div class="daoHang clearfix">
  66. <div class="dhLeft">
  67. <sapn><i class="syIcon"></i>位置:<a id="ReIndex" href="javaScript:;">首页</a>&gt;<a href="javaScript:;">报表分析</a>&gt;<a href="javaScript:;">业务数据分析</a>&gt;<a href="" class="nowPosition">产品日期分布情况表</a></sapn>
  68. </div>
  69. <div class="dhRight">
  70. <a href="#" title="刷新"><i class="fa fa-refresh"></i></a>
  71. </div>
  72. </div>
  73. <div class="zxt-top clearfix">
  74. <div class="topCon">
  75. <div class="form-inline th-bar clearfix">
  76. <div class="time-box form-group" >
  77. <i class="tub fa fa-calendar"></i>
  78. <input class="form-control" type="text" id="startTime" placeholder="请选择起止时间" style="width: 228px;">
  79. </div>
  80. <div class="form-group tool_bars pull-right">
  81. <button class="btns sear">搜索</button>
  82. <a class="btns export">导出</a>
  83. </div>
  84. </div>
  85. </div>
  86. </div>
  87. <div class="zxt-content">
  88. <div class="zxt-table">
  89. <table class="table table-bordered text-center zjTable">
  90. </table>
  91. </div>
  92. </div>
  93. </div>
  94. <script src="../js/jquery.min.js?v=2.1.4"></script>
  95. <script src="../js/bootstrap.min.js?v=3.3.6"></script>
  96. <script src="../js/jquery.cookie.js"></script>
  97. <script src="../js/laydate/laydate.js"></script>
  98. <script src="../js/select2/js/select2.min.js"></script>
  99. <script>
  100. $(function() {
  101. //日期
  102. laydate.render({
  103. elem: '#startTime',
  104. type: 'date',
  105. theme: '#1ab394',
  106. // range: '~',
  107. });
  108. var myDate = new Date();
  109. $('#startTime').val( myDate.getFullYear() + "-" + turn(myDate.getMonth() + 1) + "-" + turn(myDate.getDate()));
  110. function turn(aa) {
  111. if(aa < 10) {
  112. aa = "0" + aa;
  113. }
  114. return aa;
  115. }
  116. reportForm();
  117. //点击搜索事件
  118. $('.sear').click(function() {
  119. reportForm();
  120. })
  121. //按enter搜索
  122. document.onkeydown = function (e) { // 回车提交表单
  123. var theEvent = window.event || e;
  124. var code = theEvent.keyCode || theEvent.which || theEvent.charCode;
  125. if (code == 13) {
  126. reportForm();
  127. }
  128. }
  129. //表格
  130. function reportForm () {
  131. $.ajax({
  132. type: "get",
  133. dataType: "json",
  134. url: huayi.config.callcenter_url+"Business/Distribution",
  135. async: true,
  136. data: {
  137. token: $.cookie("token"),
  138. datetime: $("#startTime").val(),
  139. isdc: 0,
  140. },
  141. success: function(data) {
  142. if (data.state.toLowerCase() == 'success') {
  143. var content = data.data.rows;
  144. $('.table').html('');
  145. $('.table').append(
  146. '<tr>'+
  147. '<td rowspan="1" colspan="12" style="font-size: 16px; font-weight: 700">'+ data.data.msg + '</td>'+
  148. '</tr>'+
  149. '<tr>'+
  150. '<td rowspan="2" colspan="1" class="header-num-date"><div class="num-header">数量</div><div class="date-header">日期</div></td>'+
  151. '<td rowspan="1" colspan="1">投诉产品</td>'+
  152. '<td rowspan="1" colspan="2" class="month-count-1name"></td>'+
  153. '<td rowspan="1" colspan="2" class="month-count-2name"></td>'+
  154. '<td rowspan="1" colspan="2" class="month-count-3name"></td>'+
  155. '<td rowspan="1" colspan="2" class="month-count-4name"></td>'+
  156. '<td rowspan="1" colspan="2" class="month-count-5name"></td>'+
  157. '</tr>'+
  158. '<tr>'+
  159. '<td>数量</td>'+
  160. '<td>数量</td>'+
  161. '<td>占比</td>'+
  162. '<td>数量</td>'+
  163. '<td>占比</td>'+
  164. '<td>数量</td>'+
  165. '<td>占比</td>'+
  166. '<td>数量</td>'+
  167. '<td>占比</td>'+
  168. '<td>数量</td>'+
  169. '<td>占比</td>'+
  170. '</tr>'
  171. );
  172. //投诉产品日期分布情况表
  173. $(".month-count-1name").html(content.dates[0].MonthCount1name);
  174. $(".month-count-2name").html(content.dates[0].MonthCount2name);
  175. $(".month-count-3name").html(content.dates[0].MonthCount3name);
  176. $(".month-count-4name").html(content.dates[0].MonthCount4name);
  177. $(".month-count-5name").html(content.dates[0].MonthCount5name);
  178. for (var i = 0; i < content.dates.length; i++){
  179. $(".table").append('<tr>'+
  180. '<td>'+ content.dates[i].name + '</td>' +
  181. '<td>'+ content.dates[i].total + '</td>' +
  182. '<td>'+ content.dates[i].MonthCount1 + '</td>' +
  183. '<td>'+ content.dates[i].MonthCountmix1 + '</td>' +
  184. '<td>'+ content.dates[i].MonthCount2 + '</td>' +
  185. '<td>'+ content.dates[i].MonthCountmix2 + '</td>' +
  186. '<td>'+ content.dates[i].MonthCount3 + '</td>' +
  187. '<td>'+ content.dates[i].MonthCountmix3 + '</td>' +
  188. '<td>'+ content.dates[i].MonthCount4 + '</td>' +
  189. '<td>'+ content.dates[i].MonthCountmix4 + '</td>' +
  190. '<td>'+ content.dates[i].MonthCount5 + '</td>' +
  191. '<td>'+ content.dates[i].MonthCountmix5 + '</td>' +
  192. '</tr>')
  193. }
  194. //工厂投诉比,各质量问题占比,结构占比
  195. var factoryLen = content.factory.length;
  196. var cyclesNum = content.problem.length + content.product.length;
  197. for (var i=0,num=0,p=0,k=1; num < cyclesNum; i+=2, num++, k+=2){
  198. if (i === 0) {
  199. $(".table").append('<tr>'+
  200. '<td rowspan="'+ cyclesNum + '">工厂投诉占比</td>'+
  201. '<td>' + content.factory[i].name + '</td>'+
  202. '<td>' + content.factory[i].number + '</td>'+
  203. '<td>' + content.factory[i].proportion + '</td>'+
  204. '<td>' + content.factory[i+1].name + '</td>'+
  205. '<td>' + content.factory[i+1].number + '</td>'+
  206. '<td>' + content.factory[i+1].proportion + '</td>'+
  207. '<td rowspan="'+ content.problem.length + '">各质量问题占比</td>'+
  208. '<td colspan="2">' + content.problem[num].name + '</td>'+
  209. '<td>' + content.problem[num].number + '</td>'+
  210. '<td>' + content.problem[num].proportion + '</td>'+
  211. '</tr>')
  212. } else if (i > 0 && k < factoryLen) {
  213. if (num < content.problem.length){
  214. $(".table").append('<tr>'+
  215. '<td>' + content.factory[i].name +'</td>'+
  216. '<td>' + content.factory[i].number +'</td>'+
  217. '<td>' + content.factory[i].proportion +'</td>'+
  218. '<td>' + content.factory[i+1].name +'</td>'+
  219. '<td>' + content.factory[i+1].number +'</td>'+
  220. '<td>' + content.factory[i+1].proportion +'</td>'+
  221. '<td colspan="2">' + content.problem[num].name + '</td>'+
  222. '<td>' + content.problem[num].number + '</td>'+
  223. '<td>' + content.problem[num].proportion + '</td>'+
  224. '</tr>')
  225. } else if (num >= content.problem.length) {
  226. if(p === 0){
  227. $(".table").append('<tr>'+
  228. '<td>' + content.factory[i].name +'</td>'+
  229. '<td>' + content.factory[i].number +'</td>'+
  230. '<td>' + content.factory[i].proportion +'</td>'+
  231. '<td>' + content.factory[i+1].name +'</td>'+
  232. '<td>' + content.factory[i+1].number +'</td>'+
  233. '<td>' + content.factory[i+1].proportion +'</td>'+
  234. '<td rowspan="'+ content.product.length + '">结构占比</td>'+
  235. '<td colspan="2">' + content.product[p].name + '</td>'+
  236. '<td>' + content.product[p].number + '</td>'+
  237. '<td>' + content.product[p].proportion + '</td>'+
  238. '</tr>')
  239. } else if (0 < p && p < content.product.length) {
  240. $(".table").append('<tr>'+
  241. '<td>' + content.factory[i].name +'</td>'+
  242. '<td>' + content.factory[i].number +'</td>'+
  243. '<td>' + content.factory[i].proportion +'</td>'+
  244. '<td>' + content.factory[i+1].name +'</td>'+
  245. '<td>' + content.factory[i+1].number +'</td>'+
  246. '<td>' + content.factory[i+1].proportion +'</td>'+
  247. '<td colspan="2">' + content.product[p].name + '</td>'+
  248. '<td>' + content.product[p].number + '</td>'+
  249. '<td>' + content.product[p].proportion + '</td>'+
  250. '</tr>')
  251. }
  252. p += 1;
  253. }
  254. } else if (k == factoryLen) {
  255. if (num < content.problem.length){
  256. $(".table").append('<tr>'+
  257. '<td>' + content.factory[i].name +'</td>'+
  258. '<td>' + content.factory[i].number +'</td>'+
  259. '<td>' + content.factory[i].proportion +'</td>'+
  260. '<td></td>'+
  261. '<td></td>'+
  262. '<td></td>'+
  263. '<td colspan="2">' + content.problem[num].name + '</td>'+
  264. '<td>' + content.problem[num].number + '</td>'+
  265. '<td>' + content.problem[num].proportion + '</td>'+
  266. '</tr>')
  267. } else if (num >= content.problem.length) {
  268. if(p === 0){
  269. $(".table").append('<tr>'+
  270. '<td>' + content.factory[i].name +'</td>'+
  271. '<td>' + content.factory[i].number +'</td>'+
  272. '<td>' + content.factory[i].proportion +'</td>'+
  273. '<td></td>'+
  274. '<td></td>'+
  275. '<td></td>'+
  276. '<td rowspan="'+ content.product.length + '">结构占比</td>'+
  277. '<td colspan="2">' + content.product[p].name + '</td>'+
  278. '<td>' + content.product[p].number + '</td>'+
  279. '<td>' + content.product[p].proportion + '</td>'+
  280. '</tr>')
  281. } else if (0 < p && p < content.product.length) {
  282. $(".table").append('<tr>'+
  283. '<td>' + content.factory[i].name +'</td>'+
  284. '<td>' + content.factory[i].number +'</td>'+
  285. '<td>' + content.factory[i].proportion +'</td>'+
  286. '<td></td>'+
  287. '<td></td>'+
  288. '<td></td>'+
  289. '<td colspan="2">' + content.product[p].name + '</td>'+
  290. '<td>' + content.product[p].number + '</td>'+
  291. '<td>' + content.product[p].proportion + '</td>'+
  292. '</tr>')
  293. }
  294. p += 1;
  295. }
  296. } else if ( k > factoryLen) {
  297. if (num < content.problem.length){
  298. $(".table").append('<tr>'+
  299. '<td></td>'+
  300. '<td></td>'+
  301. '<td></td>'+
  302. '<td></td>'+
  303. '<td></td>'+
  304. '<td></td>'+
  305. '<td colspan="2">' + content.problem[num].name + '</td>'+
  306. '<td>' + content.problem[num].number + '</td>'+
  307. '<td>' + content.problem[num].proportion + '</td>'+
  308. '</tr>')
  309. } else if (num >= content.problem.length) {
  310. if(p === 0){
  311. $(".table").append('<tr>'+
  312. '<td></td>'+
  313. '<td></td>'+
  314. '<td></td>'+
  315. '<td></td>'+
  316. '<td></td>'+
  317. '<td></td>'+
  318. '<td rowspan="'+ content.product.length + '">结构占比</td>'+
  319. '<td colspan="2">' + content.product[p].name + '</td>'+
  320. '<td>' + content.product[p].number + '</td>'+
  321. '<td>' + content.product[p].proportion + '</td>'+
  322. '</tr>')
  323. } else if (0 < p && p < content.product.length) {
  324. $(".table").append('<tr>'+
  325. '<td></td>'+
  326. '<td></td>'+
  327. '<td></td>'+
  328. '<td></td>'+
  329. '<td></td>'+
  330. '<td></td>'+
  331. '<td colspan="2">' + content.product[p].name + '</td>'+
  332. '<td>' + content.product[p].number + '</td>'+
  333. '<td>' + content.product[p].proportion + '</td>'+
  334. '</tr>')
  335. }
  336. p += 1;
  337. }
  338. }
  339. }
  340. } else {
  341. layer.msg(data.message);
  342. }
  343. }
  344. });
  345. }
  346. //导出
  347. $(".export").click(function () {
  348. var url = huayi.config.callcenter_url + "Business/Distribution?token=" + $.cookie("token");
  349. url += "&datetime=" + $("#startTime").val() + "&isdc=1";
  350. window.location.href = url;
  351. });
  352. })
  353. </script>
  354. </body>
  355. </html>