Нет описания

complaintProductDateSheet.html 18KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459
  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. .header-num-date{
  45. position: relative;
  46. }
  47. .num-header{
  48. position: absolute;
  49. top: 10px;
  50. right: 10px;
  51. }
  52. .date-header{
  53. position: absolute;
  54. left: 10px;
  55. bottom: 10px;
  56. }
  57. </style>
  58. </head>
  59. <body class="gray-bg" style="background: #fefefe;">
  60. <div class="zxtable">
  61. <div class="daoHang clearfix">
  62. <div class="dhLeft">
  63. <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>
  64. </div>
  65. <div class="dhRight">
  66. <a href="#" title="刷新"><i class="fa fa-refresh"></i></a>
  67. </div>
  68. </div>
  69. <div class="zxt-top clearfix">
  70. <div class="topCon">
  71. <div class="form-inline th-bar clearfix">
  72. <div class="time-box form-group" >
  73. <i class="tub fa fa-calendar"></i>
  74. <input class="form-control" type="text" id="startTime" placeholder="请选择起止时间" style="width: 228px;">
  75. </div>
  76. <div class="form-group tool_bars pull-right">
  77. <button class="btns sear">搜索</button>
  78. <a class="btns export">导出</a>
  79. </div>
  80. </div>
  81. </div>
  82. </div>
  83. <div class="zxt-content">
  84. <div class="zxt-table">
  85. <table class="table table-bordered text-center zjTable">
  86. </table>
  87. </div>
  88. </div>
  89. </div>
  90. <script src="../js/jquery.min.js?v=2.1.4"></script>
  91. <script src="../js/bootstrap.min.js?v=3.3.6"></script>
  92. <script src="../js/jquery.cookie.js"></script>
  93. <script src="../js/laydate/laydate.js"></script>
  94. <script src="../js/select2/js/select2.min.js"></script>
  95. <script>
  96. $(function() {
  97. //日期
  98. laydate.render({
  99. elem: '#startTime',
  100. type: 'date',
  101. theme: '#1ab394',
  102. range: '~',
  103. });
  104. var myDate = new Date();
  105. $('#startTime').val(myDate.getFullYear() + "-" + turn(myDate.getMonth() + 1) + "-" + "01" + " ~ " + myDate.getFullYear() + "-" + turn(myDate.getMonth() + 1) + "-" + turn(myDate.getDate()));
  106. function turn(aa) {
  107. if(aa < 10) {
  108. aa = "0" + aa;
  109. }
  110. return aa;
  111. }
  112. reportForm();
  113. //点击搜索事件
  114. $('.sear').click(function() {
  115. reportForm();
  116. })
  117. //按enter搜索
  118. document.onkeydown = function (e) { // 回车提交表单
  119. var theEvent = window.event || e;
  120. var code = theEvent.keyCode || theEvent.which || theEvent.charCode;
  121. if (code == 13) {
  122. reportForm();
  123. }
  124. }
  125. //表格
  126. function reportForm () {
  127. $.ajax({
  128. type: "get",
  129. dataType: "json",
  130. url: huayi.config.callcenter_url+"Business/Distribution",
  131. async: true,
  132. data: {
  133. token: $.cookie("token"),
  134. sttime: $('#startTime').val() ? $('#startTime').val().split('~')[0]:"",
  135. endtime: $('#startTime').val() ? $('#startTime').val().split('~')[1]:"",
  136. isdc: 0,
  137. },
  138. success: function(data) {
  139. if (data.state.toLowerCase() == 'success') {
  140. var content = data.data.rows;
  141. $('.table').html('');
  142. $('.table').append(
  143. '<tr>'+
  144. '<td rowspan="1" colspan="12" style="font-size: 16px; font-weight: 700">'+ data.data.msg + '</td>'+
  145. '</tr>'+
  146. '<tr>'+
  147. '<td rowspan="2" colspan="1" class="header-num-date"><div class="num-header">数量</div><div class="date-header">日期</div></td>'+
  148. '<td rowspan="1" colspan="1">投诉产品</td>'+
  149. '<td rowspan="1" colspan="2" class="month-count-1name"></td>'+
  150. '<td rowspan="1" colspan="2" class="month-count-2name"></td>'+
  151. '<td rowspan="1" colspan="2" class="month-count-3name"></td>'+
  152. '<td rowspan="1" colspan="2" class="month-count-4name"></td>'+
  153. '<td rowspan="1" colspan="2" class="month-count-5name"></td>'+
  154. '</tr>'+
  155. '<tr>'+
  156. '<td>数量</td>'+
  157. '<td>数量</td>'+
  158. '<td>占比</td>'+
  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. '</tr>'
  168. );
  169. //投诉产品日期分布情况表
  170. $(".month-count-1name").html(content.dates[0].MonthCount1name);
  171. $(".month-count-2name").html(content.dates[0].MonthCount2name);
  172. $(".month-count-3name").html(content.dates[0].MonthCount3name);
  173. $(".month-count-4name").html(content.dates[0].MonthCount4name);
  174. $(".month-count-5name").html(content.dates[0].MonthCount5name);
  175. for (var i = 0; i < content.dates.length; i++){
  176. $(".table").append('<tr>'+
  177. '<td>'+ content.dates[i].name + '</td>' +
  178. '<td>'+ content.dates[i].total + '</td>' +
  179. '<td>'+ content.dates[i].MonthCount1 + '</td>' +
  180. '<td>'+ content.dates[i].MonthCountmix1 + '</td>' +
  181. '<td>'+ content.dates[i].MonthCount2 + '</td>' +
  182. '<td>'+ content.dates[i].MonthCountmix2 + '</td>' +
  183. '<td>'+ content.dates[i].MonthCount3 + '</td>' +
  184. '<td>'+ content.dates[i].MonthCountmix3 + '</td>' +
  185. '<td>'+ content.dates[i].MonthCount4 + '</td>' +
  186. '<td>'+ content.dates[i].MonthCountmix4 + '</td>' +
  187. '<td>'+ content.dates[i].MonthCount5 + '</td>' +
  188. '<td>'+ content.dates[i].MonthCountmix5 + '</td>' +
  189. '</tr>')
  190. }
  191. //工厂投诉比,各质量问题占比,结构占比
  192. var factoryLen = content.factory.length;
  193. var cyclesNum = content.problem.length + content.product.length;
  194. var factoryLenCeil = Math.ceil(factoryLen/2)
  195. if (factoryLenCeil >= cyclesNum) {
  196. for (var i=0,num=0,p=0,k=1; num < factoryLenCeil; i+=2, num++, k+=2){
  197. if (num === 0) {
  198. $(".table").append('<tr>'+
  199. '<td rowspan="'+ factoryLenCeil + '">工厂投诉占比</td>'+
  200. '<td>' + content.factory[i].name + '</td>'+
  201. '<td>' + content.factory[i].number + '</td>'+
  202. '<td>' + content.factory[i].proportion + '</td>'+
  203. '<td>' + content.factory[i+1].name + '</td>'+
  204. '<td>' + content.factory[i+1].number + '</td>'+
  205. '<td>' + content.factory[i+1].proportion + '</td>'+
  206. '<td rowspan="'+ content.problem.length + '">各质量问题占比</td>'+
  207. '<td colspan="2">' + content.problem[num].name + '</td>'+
  208. '<td>' + content.problem[num].number + '</td>'+
  209. '<td>' + content.problem[num].proportion + '</td>'+
  210. '</tr>')
  211. } else if (num > 0 && num < content.problem.length) {
  212. // if (num < )
  213. $(".table").append('<tr>'+
  214. '<td>' + content.factory[i].name +'</td>'+
  215. '<td>' + content.factory[i].number +'</td>'+
  216. '<td>' + content.factory[i].proportion +'</td>'+
  217. '<td>' + content.factory[i+1].name +'</td>'+
  218. '<td>' + content.factory[i+1].number +'</td>'+
  219. '<td>' + content.factory[i+1].proportion +'</td>'+
  220. '<td colspan="2">' + content.problem[num].name + '</td>'+
  221. '<td>' + content.problem[num].number + '</td>'+
  222. '<td>' + content.problem[num].proportion + '</td>'+
  223. '</tr>')
  224. } else if (num >= content.problem.length && num < cyclesNum) {
  225. if(p === 0){
  226. $(".table").append('<tr>'+
  227. '<td>' + content.factory[i].name +'</td>'+
  228. '<td>' + content.factory[i].number +'</td>'+
  229. '<td>' + content.factory[i].proportion +'</td>'+
  230. '<td>' + content.factory[i+1].name +'</td>'+
  231. '<td>' + content.factory[i+1].number +'</td>'+
  232. '<td>' + content.factory[i+1].proportion +'</td>'+
  233. '<td rowspan="'+ content.product.length + '">结构占比</td>'+
  234. '<td colspan="2">' + content.product[p].name + '</td>'+
  235. '<td>' + content.product[p].number + '</td>'+
  236. '<td>' + content.product[p].proportion + '</td>'+
  237. '</tr>')
  238. } else if (0 < p && p < content.product.length) {
  239. $(".table").append('<tr>'+
  240. '<td>' + content.factory[i].name +'</td>'+
  241. '<td>' + content.factory[i].number +'</td>'+
  242. '<td>' + content.factory[i].proportion +'</td>'+
  243. '<td>' + content.factory[i+1].name +'</td>'+
  244. '<td>' + content.factory[i+1].number +'</td>'+
  245. '<td>' + content.factory[i+1].proportion +'</td>'+
  246. '<td colspan="2">' + content.product[p].name + '</td>'+
  247. '<td>' + content.product[p].number + '</td>'+
  248. '<td>' + content.product[p].proportion + '</td>'+
  249. '</tr>')
  250. }
  251. p += 1;
  252. } else if (num >= cyclesNum) {
  253. if (content.factory[i+1] != undefined) {
  254. $(".table").append('<tr>'+
  255. '<td>' + content.factory[i].name +'</td>'+
  256. '<td>' + content.factory[i].number +'</td>'+
  257. '<td>' + content.factory[i].proportion +'</td>'+
  258. '<td>' + content.factory[i+1].name +'</td>'+
  259. '<td>' + content.factory[i+1].number +'</td>'+
  260. '<td>' + content.factory[i+1].proportion +'</td>'+
  261. '</tr>')
  262. } else {
  263. $(".table").append('<tr>'+
  264. '<td>' + content.factory[i].name +'</td>'+
  265. '<td>' + content.factory[i].number +'</td>'+
  266. '<td>' + content.factory[i].proportion +'</td>'+
  267. '<td></td>'+
  268. '<td></td>'+
  269. '<td></td>'+
  270. '</tr>')
  271. }
  272. }
  273. }
  274. } else if (factoryLenCeil < cyclesNum) {
  275. for (var i=0,num=0,p=0,k=1; num < cyclesNum; i+=2, num++, k+=2){
  276. if (i === 0) {
  277. $(".table").append('<tr>'+
  278. '<td rowspan="'+ cyclesNum + '">工厂投诉占比</td>'+
  279. '<td>' + content.factory[i].name + '</td>'+
  280. '<td>' + content.factory[i].number + '</td>'+
  281. '<td>' + content.factory[i].proportion + '</td>'+
  282. '<td>' + content.factory[i+1].name + '</td>'+
  283. '<td>' + content.factory[i+1].number + '</td>'+
  284. '<td>' + content.factory[i+1].proportion + '</td>'+
  285. '<td rowspan="'+ content.problem.length + '">各质量问题占比</td>'+
  286. '<td colspan="2">' + content.problem[num].name + '</td>'+
  287. '<td>' + content.problem[num].number + '</td>'+
  288. '<td>' + content.problem[num].proportion + '</td>'+
  289. '</tr>')
  290. } else if (i > 0 && k < factoryLen) {
  291. if (num < content.problem.length){
  292. $(".table").append('<tr>'+
  293. '<td>' + content.factory[i].name +'</td>'+
  294. '<td>' + content.factory[i].number +'</td>'+
  295. '<td>' + content.factory[i].proportion +'</td>'+
  296. '<td>' + content.factory[i+1].name +'</td>'+
  297. '<td>' + content.factory[i+1].number +'</td>'+
  298. '<td>' + content.factory[i+1].proportion +'</td>'+
  299. '<td colspan="2">' + content.problem[num].name + '</td>'+
  300. '<td>' + content.problem[num].number + '</td>'+
  301. '<td>' + content.problem[num].proportion + '</td>'+
  302. '</tr>')
  303. } else if (num >= content.problem.length) {
  304. if(p === 0){
  305. $(".table").append('<tr>'+
  306. '<td>' + content.factory[i].name +'</td>'+
  307. '<td>' + content.factory[i].number +'</td>'+
  308. '<td>' + content.factory[i].proportion +'</td>'+
  309. '<td>' + content.factory[i+1].name +'</td>'+
  310. '<td>' + content.factory[i+1].number +'</td>'+
  311. '<td>' + content.factory[i+1].proportion +'</td>'+
  312. '<td rowspan="'+ content.product.length + '">结构占比</td>'+
  313. '<td colspan="2">' + content.product[p].name + '</td>'+
  314. '<td>' + content.product[p].number + '</td>'+
  315. '<td>' + content.product[p].proportion + '</td>'+
  316. '</tr>')
  317. } else if (0 < p && p < content.product.length) {
  318. $(".table").append('<tr>'+
  319. '<td>' + content.factory[i].name +'</td>'+
  320. '<td>' + content.factory[i].number +'</td>'+
  321. '<td>' + content.factory[i].proportion +'</td>'+
  322. '<td>' + content.factory[i+1].name +'</td>'+
  323. '<td>' + content.factory[i+1].number +'</td>'+
  324. '<td>' + content.factory[i+1].proportion +'</td>'+
  325. '<td colspan="2">' + content.product[p].name + '</td>'+
  326. '<td>' + content.product[p].number + '</td>'+
  327. '<td>' + content.product[p].proportion + '</td>'+
  328. '</tr>')
  329. }
  330. p += 1;
  331. }
  332. } else if (k == factoryLen) {
  333. if (num < content.problem.length){
  334. $(".table").append('<tr>'+
  335. '<td>' + content.factory[i].name +'</td>'+
  336. '<td>' + content.factory[i].number +'</td>'+
  337. '<td>' + content.factory[i].proportion +'</td>'+
  338. '<td></td>'+
  339. '<td></td>'+
  340. '<td></td>'+
  341. '<td colspan="2">' + content.problem[num].name + '</td>'+
  342. '<td>' + content.problem[num].number + '</td>'+
  343. '<td>' + content.problem[num].proportion + '</td>'+
  344. '</tr>')
  345. } else if (num >= content.problem.length) {
  346. if(p === 0){
  347. $(".table").append('<tr>'+
  348. '<td>' + content.factory[i].name +'</td>'+
  349. '<td>' + content.factory[i].number +'</td>'+
  350. '<td>' + content.factory[i].proportion +'</td>'+
  351. '<td></td>'+
  352. '<td></td>'+
  353. '<td></td>'+
  354. '<td rowspan="'+ content.product.length + '">结构占比</td>'+
  355. '<td colspan="2">' + content.product[p].name + '</td>'+
  356. '<td>' + content.product[p].number + '</td>'+
  357. '<td>' + content.product[p].proportion + '</td>'+
  358. '</tr>')
  359. } else if (0 < p && p < content.product.length) {
  360. $(".table").append('<tr>'+
  361. '<td>' + content.factory[i].name +'</td>'+
  362. '<td>' + content.factory[i].number +'</td>'+
  363. '<td>' + content.factory[i].proportion +'</td>'+
  364. '<td></td>'+
  365. '<td></td>'+
  366. '<td></td>'+
  367. '<td colspan="2">' + content.product[p].name + '</td>'+
  368. '<td>' + content.product[p].number + '</td>'+
  369. '<td>' + content.product[p].proportion + '</td>'+
  370. '</tr>')
  371. }
  372. p += 1;
  373. }
  374. } else if ( k > factoryLen) {
  375. if (num < content.problem.length){
  376. $(".table").append('<tr>'+
  377. '<td></td>'+
  378. '<td></td>'+
  379. '<td></td>'+
  380. '<td></td>'+
  381. '<td></td>'+
  382. '<td></td>'+
  383. '<td colspan="2">' + content.problem[num].name + '</td>'+
  384. '<td>' + content.problem[num].number + '</td>'+
  385. '<td>' + content.problem[num].proportion + '</td>'+
  386. '</tr>')
  387. } else if (num >= content.problem.length) {
  388. if(p === 0){
  389. $(".table").append('<tr>'+
  390. '<td></td>'+
  391. '<td></td>'+
  392. '<td></td>'+
  393. '<td></td>'+
  394. '<td></td>'+
  395. '<td></td>'+
  396. '<td rowspan="'+ content.product.length + '">结构占比</td>'+
  397. '<td colspan="2">' + content.product[p].name + '</td>'+
  398. '<td>' + content.product[p].number + '</td>'+
  399. '<td>' + content.product[p].proportion + '</td>'+
  400. '</tr>')
  401. } else if (0 < p && p < content.product.length) {
  402. $(".table").append('<tr>'+
  403. '<td></td>'+
  404. '<td></td>'+
  405. '<td></td>'+
  406. '<td></td>'+
  407. '<td></td>'+
  408. '<td></td>'+
  409. '<td colspan="2">' + content.product[p].name + '</td>'+
  410. '<td>' + content.product[p].number + '</td>'+
  411. '<td>' + content.product[p].proportion + '</td>'+
  412. '</tr>')
  413. }
  414. p += 1;
  415. }
  416. }
  417. }
  418. }
  419. } else {
  420. layer.msg(data.message);
  421. }
  422. }
  423. });
  424. }
  425. //导出
  426. $(".export").click(function () {
  427. var exportSttime = $('#startTime').val() ? $('#startTime').val().split('~')[0]:"";
  428. var exportEndtime = $('#startTime').val() ? $('#startTime').val().split('~')[1]:"";
  429. var url = huayi.config.callcenter_url + "Business/Distribution?token=" + $.cookie("token");
  430. url += "&sttime=" + exportSttime + "&endtime=" + exportEndtime + "&isdc=1";
  431. window.location.href = url;
  432. });
  433. })
  434. </script>
  435. </body>
  436. </html>