Нет описания

complaintProductDateSheet.html 18KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464
  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: 30px auto;
  40. max-width: 100%;
  41. background: #FFFFFF;
  42. }
  43. .header-num-date {
  44. position: relative;
  45. }
  46. .num-header {
  47. position: absolute;
  48. top: 10px;
  49. right: 10px;
  50. }
  51. .date-header {
  52. position: absolute;
  53. left: 10px;
  54. bottom: 10px;
  55. }
  56. </style>
  57. </head>
  58. <body class="gray-bg" style="background: #fefefe;">
  59. <div class="zxtable">
  60. <div class="daoHang clearfix">
  61. <div class="dhLeft">
  62. <sapn><i class="syIcon"></i>位置:
  63. <a id="ReIndex" href="javaScript:;">首页</a>&gt;
  64. <a href="javaScript:;">报表分析</a>&gt;
  65. <a href="javaScript:;">业务数据分析</a>&gt;
  66. <a href="" class="nowPosition">产品日期分布情况表</a>
  67. </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"></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) + "-" + "01" + " ~ " + 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. sttime: $('#startTime').val() ? $('#startTime').val().split('~')[0] : "",
  139. endtime: $('#startTime').val() ? $('#startTime').val().split('~')[1] : "",
  140. isdc: 0,
  141. },
  142. success: function(data) {
  143. if(data.state.toLowerCase() == 'success') {
  144. var content = data.data.rows;
  145. $('.table').html('');
  146. $('.table').append(
  147. '<tr>' +
  148. '<td rowspan="1" colspan="12" style="font-size: 16px; font-weight: 700">' + data.data.msg + '</td>' +
  149. '</tr>' +
  150. '<tr>' +
  151. '<td rowspan="2" colspan="1" class="header-num-date"><div class="num-header">数量</div><div class="date-header">日期</div></td>' +
  152. '<td rowspan="1" colspan="1">投诉产品</td>' +
  153. '<td rowspan="1" colspan="2" class="month-count-1name"></td>' +
  154. '<td rowspan="1" colspan="2" class="month-count-2name"></td>' +
  155. '<td rowspan="1" colspan="2" class="month-count-3name"></td>' +
  156. '<td rowspan="1" colspan="2" class="month-count-4name"></td>' +
  157. '<td rowspan="1" colspan="2" class="month-count-5name"></td>' +
  158. '</tr>' +
  159. '<tr>' +
  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. '<td>占比</td>' +
  171. '</tr>'
  172. );
  173. //投诉产品日期分布情况表
  174. $(".month-count-1name").html(content.dates[0].MonthCount1name);
  175. $(".month-count-2name").html(content.dates[0].MonthCount2name);
  176. $(".month-count-3name").html(content.dates[0].MonthCount3name);
  177. $(".month-count-4name").html(content.dates[0].MonthCount4name);
  178. $(".month-count-5name").html(content.dates[0].MonthCount5name);
  179. for(var i = 0; i < content.dates.length; i++) {
  180. $(".table").append('<tr>' +
  181. '<td>' + content.dates[i].name + '</td>' +
  182. '<td>' + content.dates[i].total + '</td>' +
  183. '<td>' + content.dates[i].MonthCount1 + '</td>' +
  184. '<td>' + content.dates[i].MonthCountmix1 + '</td>' +
  185. '<td>' + content.dates[i].MonthCount2 + '</td>' +
  186. '<td>' + content.dates[i].MonthCountmix2 + '</td>' +
  187. '<td>' + content.dates[i].MonthCount3 + '</td>' +
  188. '<td>' + content.dates[i].MonthCountmix3 + '</td>' +
  189. '<td>' + content.dates[i].MonthCount4 + '</td>' +
  190. '<td>' + content.dates[i].MonthCountmix4 + '</td>' +
  191. '<td>' + content.dates[i].MonthCount5 + '</td>' +
  192. '<td>' + content.dates[i].MonthCountmix5 + '</td>' +
  193. '</tr>')
  194. }
  195. //工厂投诉比,各质量问题占比,结构占比
  196. var factoryLen = content.factory.length;
  197. var cyclesNum = content.problem.length + content.product.length;
  198. var factoryLenCeil = Math.ceil(factoryLen / 2)
  199. if(factoryLenCeil >= cyclesNum) {
  200. for(var i = 0, num = 0, p = 0, k = 1; num < factoryLenCeil; i += 2, num++, k += 2) {
  201. if(num === 0) {
  202. $(".table").append('<tr>' +
  203. '<td rowspan="' + factoryLenCeil + '">工厂投诉占比</td>' +
  204. '<td>' + content.factory[i].name + '</td>' +
  205. '<td>' + content.factory[i].number + '</td>' +
  206. '<td>' + content.factory[i].proportion + '</td>' +
  207. '<td>' + content.factory[i + 1].name + '</td>' +
  208. '<td>' + content.factory[i + 1].number + '</td>' +
  209. '<td>' + content.factory[i + 1].proportion + '</td>' +
  210. '<td rowspan="' + content.problem.length + '">各质量问题占比</td>' +
  211. '<td colspan="2">' + content.problem[num].name + '</td>' +
  212. '<td>' + content.problem[num].number + '</td>' +
  213. '<td>' + content.problem[num].proportion + '</td>' +
  214. '</tr>')
  215. } else if(num > 0 && num < content.problem.length) {
  216. // if (num < )
  217. $(".table").append('<tr>' +
  218. '<td>' + content.factory[i].name + '</td>' +
  219. '<td>' + content.factory[i].number + '</td>' +
  220. '<td>' + content.factory[i].proportion + '</td>' +
  221. '<td>' + content.factory[i + 1].name + '</td>' +
  222. '<td>' + content.factory[i + 1].number + '</td>' +
  223. '<td>' + content.factory[i + 1].proportion + '</td>' +
  224. '<td colspan="2">' + content.problem[num].name + '</td>' +
  225. '<td>' + content.problem[num].number + '</td>' +
  226. '<td>' + content.problem[num].proportion + '</td>' +
  227. '</tr>')
  228. } else if(num >= content.problem.length && num < cyclesNum) {
  229. if(p === 0) {
  230. $(".table").append('<tr>' +
  231. '<td>' + content.factory[i].name + '</td>' +
  232. '<td>' + content.factory[i].number + '</td>' +
  233. '<td>' + content.factory[i].proportion + '</td>' +
  234. '<td>' + content.factory[i + 1].name + '</td>' +
  235. '<td>' + content.factory[i + 1].number + '</td>' +
  236. '<td>' + content.factory[i + 1].proportion + '</td>' +
  237. '<td rowspan="' + content.product.length + '">结构占比</td>' +
  238. '<td colspan="2">' + content.product[p].name + '</td>' +
  239. '<td>' + content.product[p].number + '</td>' +
  240. '<td>' + content.product[p].proportion + '</td>' +
  241. '</tr>')
  242. } else if(0 < p && p < content.product.length) {
  243. $(".table").append('<tr>' +
  244. '<td>' + content.factory[i].name + '</td>' +
  245. '<td>' + content.factory[i].number + '</td>' +
  246. '<td>' + content.factory[i].proportion + '</td>' +
  247. '<td>' + content.factory[i + 1].name + '</td>' +
  248. '<td>' + content.factory[i + 1].number + '</td>' +
  249. '<td>' + content.factory[i + 1].proportion + '</td>' +
  250. '<td colspan="2">' + content.product[p].name + '</td>' +
  251. '<td>' + content.product[p].number + '</td>' +
  252. '<td>' + content.product[p].proportion + '</td>' +
  253. '</tr>')
  254. }
  255. p += 1;
  256. } else if(num >= cyclesNum) {
  257. if(content.factory[i + 1] != undefined) {
  258. $(".table").append('<tr>' +
  259. '<td>' + content.factory[i].name + '</td>' +
  260. '<td>' + content.factory[i].number + '</td>' +
  261. '<td>' + content.factory[i].proportion + '</td>' +
  262. '<td>' + content.factory[i + 1].name + '</td>' +
  263. '<td>' + content.factory[i + 1].number + '</td>' +
  264. '<td>' + content.factory[i + 1].proportion + '</td>' +
  265. '</tr>')
  266. } else {
  267. $(".table").append('<tr>' +
  268. '<td>' + content.factory[i].name + '</td>' +
  269. '<td>' + content.factory[i].number + '</td>' +
  270. '<td>' + content.factory[i].proportion + '</td>' +
  271. '<td></td>' +
  272. '<td></td>' +
  273. '<td></td>' +
  274. '</tr>')
  275. }
  276. }
  277. }
  278. } else if(factoryLenCeil < cyclesNum) {
  279. for(var i = 0, num = 0, p = 0, k = 1; num < cyclesNum; i += 2, num++, k += 2) {
  280. if(i === 0) {
  281. $(".table").append('<tr>' +
  282. '<td rowspan="' + cyclesNum + '">工厂投诉占比</td>' +
  283. '<td>' + content.factory[i].name + '</td>' +
  284. '<td>' + content.factory[i].number + '</td>' +
  285. '<td>' + content.factory[i].proportion + '</td>' +
  286. '<td>' + content.factory[i + 1].name + '</td>' +
  287. '<td>' + content.factory[i + 1].number + '</td>' +
  288. '<td>' + content.factory[i + 1].proportion + '</td>' +
  289. '<td rowspan="' + content.problem.length + '">各质量问题占比</td>' +
  290. '<td colspan="2">' + content.problem[num].name + '</td>' +
  291. '<td>' + content.problem[num].number + '</td>' +
  292. '<td>' + content.problem[num].proportion + '</td>' +
  293. '</tr>')
  294. } else if(i > 0 && k < factoryLen) {
  295. if(num < content.problem.length) {
  296. $(".table").append('<tr>' +
  297. '<td>' + content.factory[i].name + '</td>' +
  298. '<td>' + content.factory[i].number + '</td>' +
  299. '<td>' + content.factory[i].proportion + '</td>' +
  300. '<td>' + content.factory[i + 1].name + '</td>' +
  301. '<td>' + content.factory[i + 1].number + '</td>' +
  302. '<td>' + content.factory[i + 1].proportion + '</td>' +
  303. '<td colspan="2">' + content.problem[num].name + '</td>' +
  304. '<td>' + content.problem[num].number + '</td>' +
  305. '<td>' + content.problem[num].proportion + '</td>' +
  306. '</tr>')
  307. } else if(num >= content.problem.length) {
  308. if(p === 0) {
  309. $(".table").append('<tr>' +
  310. '<td>' + content.factory[i].name + '</td>' +
  311. '<td>' + content.factory[i].number + '</td>' +
  312. '<td>' + content.factory[i].proportion + '</td>' +
  313. '<td>' + content.factory[i + 1].name + '</td>' +
  314. '<td>' + content.factory[i + 1].number + '</td>' +
  315. '<td>' + content.factory[i + 1].proportion + '</td>' +
  316. '<td rowspan="' + content.product.length + '">结构占比</td>' +
  317. '<td colspan="2">' + content.product[p].name + '</td>' +
  318. '<td>' + content.product[p].number + '</td>' +
  319. '<td>' + content.product[p].proportion + '</td>' +
  320. '</tr>')
  321. } else if(0 < p && p < content.product.length) {
  322. $(".table").append('<tr>' +
  323. '<td>' + content.factory[i].name + '</td>' +
  324. '<td>' + content.factory[i].number + '</td>' +
  325. '<td>' + content.factory[i].proportion + '</td>' +
  326. '<td>' + content.factory[i + 1].name + '</td>' +
  327. '<td>' + content.factory[i + 1].number + '</td>' +
  328. '<td>' + content.factory[i + 1].proportion + '</td>' +
  329. '<td colspan="2">' + content.product[p].name + '</td>' +
  330. '<td>' + content.product[p].number + '</td>' +
  331. '<td>' + content.product[p].proportion + '</td>' +
  332. '</tr>')
  333. }
  334. p += 1;
  335. }
  336. } else if(k == factoryLen) {
  337. if(num < content.problem.length) {
  338. $(".table").append('<tr>' +
  339. '<td>' + content.factory[i].name + '</td>' +
  340. '<td>' + content.factory[i].number + '</td>' +
  341. '<td>' + content.factory[i].proportion + '</td>' +
  342. '<td></td>' +
  343. '<td></td>' +
  344. '<td></td>' +
  345. '<td colspan="2">' + content.problem[num].name + '</td>' +
  346. '<td>' + content.problem[num].number + '</td>' +
  347. '<td>' + content.problem[num].proportion + '</td>' +
  348. '</tr>')
  349. } else if(num >= content.problem.length) {
  350. if(p === 0) {
  351. $(".table").append('<tr>' +
  352. '<td>' + content.factory[i].name + '</td>' +
  353. '<td>' + content.factory[i].number + '</td>' +
  354. '<td>' + content.factory[i].proportion + '</td>' +
  355. '<td></td>' +
  356. '<td></td>' +
  357. '<td></td>' +
  358. '<td rowspan="' + content.product.length + '">结构占比</td>' +
  359. '<td colspan="2">' + content.product[p].name + '</td>' +
  360. '<td>' + content.product[p].number + '</td>' +
  361. '<td>' + content.product[p].proportion + '</td>' +
  362. '</tr>')
  363. } else if(0 < p && p < content.product.length) {
  364. $(".table").append('<tr>' +
  365. '<td>' + content.factory[i].name + '</td>' +
  366. '<td>' + content.factory[i].number + '</td>' +
  367. '<td>' + content.factory[i].proportion + '</td>' +
  368. '<td></td>' +
  369. '<td></td>' +
  370. '<td></td>' +
  371. '<td colspan="2">' + content.product[p].name + '</td>' +
  372. '<td>' + content.product[p].number + '</td>' +
  373. '<td>' + content.product[p].proportion + '</td>' +
  374. '</tr>')
  375. }
  376. p += 1;
  377. }
  378. } else if(k > factoryLen) {
  379. if(num < content.problem.length) {
  380. $(".table").append('<tr>' +
  381. '<td></td>' +
  382. '<td></td>' +
  383. '<td></td>' +
  384. '<td></td>' +
  385. '<td></td>' +
  386. '<td></td>' +
  387. '<td colspan="2">' + content.problem[num].name + '</td>' +
  388. '<td>' + content.problem[num].number + '</td>' +
  389. '<td>' + content.problem[num].proportion + '</td>' +
  390. '</tr>')
  391. } else if(num >= content.problem.length) {
  392. if(p === 0) {
  393. $(".table").append('<tr>' +
  394. '<td></td>' +
  395. '<td></td>' +
  396. '<td></td>' +
  397. '<td></td>' +
  398. '<td></td>' +
  399. '<td></td>' +
  400. '<td rowspan="' + content.product.length + '">结构占比</td>' +
  401. '<td colspan="2">' + content.product[p].name + '</td>' +
  402. '<td>' + content.product[p].number + '</td>' +
  403. '<td>' + content.product[p].proportion + '</td>' +
  404. '</tr>')
  405. } else if(0 < p && p < content.product.length) {
  406. $(".table").append('<tr>' +
  407. '<td></td>' +
  408. '<td></td>' +
  409. '<td></td>' +
  410. '<td></td>' +
  411. '<td></td>' +
  412. '<td></td>' +
  413. '<td colspan="2">' + content.product[p].name + '</td>' +
  414. '<td>' + content.product[p].number + '</td>' +
  415. '<td>' + content.product[p].proportion + '</td>' +
  416. '</tr>')
  417. }
  418. p += 1;
  419. }
  420. }
  421. }
  422. }
  423. } else {
  424. layer.msg(data.message);
  425. }
  426. }
  427. });
  428. }
  429. //导出
  430. $(".export").click(function() {
  431. var exportSttime = $('#startTime').val() ? $('#startTime').val().split('~')[0] : "";
  432. var exportEndtime = $('#startTime').val() ? $('#startTime').val().split('~')[1] : "";
  433. var url = huayi.config.callcenter_url + "Business/Distribution?token=" + $.cookie("token");
  434. url += "&sttime=" + exportSttime + "&endtime=" + exportEndtime + "&isdc=1";
  435. window.location.href = url;
  436. });
  437. })
  438. </script>
  439. </body>
  440. </html>