designAfterStatistics.zml 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284
  1. <#def designatedPath="/personalRefundRateStat.htm"/>
  2. <script>
  3. var blamerAfterMap = new Z.HashMap();
  4. var dataList = [];
  5. //倒叙方法 [].reverse();
  6. function getObject(json)
  7. {
  8. json = json.replace(/\r/g, '');
  9. json = json.replace(/\n/g, '<br/>');
  10. json = json.replace(/\t/g, '&nbsp;&nbsp;&nbsp;&nbsp;');
  11. var reg = /(\u0000)|(\u0001)|(\u0002)|(\u0003)|(\u0004)|(\u0005)|(\u0006)|(\u0007)|(\u000b)|(\u000e)|(\u000f)|(\u0010)|(\u0011)|(\u0012)|(\u0013)|(\u0014)|(\u0015)|(\u0016)|(\u0017)|(\u0018)|(\u0019)|(\u001a)|(\u001b)|(\u001c)|(\u001d)|(\u001e)|(\u001f)/g;
  12. //var reg = //g;
  13. return Z.J.toObject(json.replace(reg, ""));
  14. }
  15. Z.onload(function()
  16. {
  17. <#for item : blamerAfterMap.values()>
  18. blamerAfterMap.put('${item.getAfterBlamer()}', getObject('${item}'));
  19. dataList.push(blamerAfterMap.get('${item.getAfterBlamer()}'));
  20. </#for>
  21. //显示数据
  22. doShowBlamerList(dataList);
  23. //显示详情
  24. doShowDetail(dataList.length > 0 ? dataList[0].afterBlamer : '');
  25. });
  26. function doShowBlamerList(dataList)
  27. {//显示责任人列表
  28. dataList.sort(function (a, b){
  29. a.afterCount = Z.V.isInteger(a.afterCount) ? a.afterCount : 0;
  30. b.afterCount = Z.V.isInteger(b.afterCount) ? b.afterCount : 0;
  31. a.lostAmount = Z.V.isFloat(a.lostAmount) ? a.lostAmount : 0;
  32. b.lostAmount = Z.V.isFloat(b.lostAmount) ? b.lostAmount : 0;
  33. var result1 = a.afterCount - b.afterCount;
  34. var result2 = a.lostAmount - b.lostAmount;
  35. return result2 != 0 ? result2 : result1;
  36. });
  37. dataList.sort();
  38. dataList.reverse();
  39. var blamerResultHtml = "";
  40. blamerResultHtml +='<table class="z-table z-bordered z-pd6 z-bg-white z-text-center" id="statTable">';
  41. blamerResultHtml +='<tr class="z-h40" bgcolor="'+"${zmr_thead_bgcolor}"+'">';
  42. blamerResultHtml +=' <td>序号</td>';
  43. blamerResultHtml +=' <td>责任人</td>';
  44. blamerResultHtml +=' <td>售后单数</td>';
  45. blamerResultHtml +=' <td>定稿单数</td>';
  46. blamerResultHtml +=' <td title="售后单量/定稿单量">售后率</td>';
  47. blamerResultHtml +=' <td width="80">订单金额</td>';
  48. blamerResultHtml +=' <td width="80">损失金额</td>';
  49. blamerResultHtml +=' <td width="80">赔付金额</td>';
  50. blamerResultHtml +='</tr>';
  51. if (dataList.length > 0)
  52. {
  53. var totalCount = 0;
  54. var totalAmount = 0;
  55. var orderEndSum = 0;
  56. var lostAmount = 0;
  57. var totalLAmount = 0;
  58. var totalOrderAmount = 0;
  59. var myselectYear=document.getElementById("year");
  60. var myselectMonth=document.getElementById("month");
  61. var year=myselectYear.value;
  62. var month=myselectMonth.value;
  63. var dateTime = new Date(year+"-"+month+"-01 00:00:00").getTime();
  64. var lDateTime = new Date("2021-10-01 00:00:00").getTime();
  65. var amount = 0;
  66. var lamount = 0;
  67. Z.each(dataList, function(item, i){
  68. if(dateTime >= lDateTime){
  69. lostAmount = item.compensateAmount;
  70. }else {
  71. lostAmount = item.lostAmount;
  72. }
  73. amount=lostAmount ? lostAmount : 0;
  74. lamount = (item.lostAmount ? item.lostAmount : 0)-(item.lossAmountCanceled ? item.lossAmountCanceled : 0);
  75. blamerResultHtml +='<tr class="z-h40" bgcolor="'+(i%2 != 0 ? '#f3fdfc' : '#ffffff')+'" onclick="doShowDetail(\''+(item.afterBlamer)+'\')">';
  76. blamerResultHtml +=' <td>'+(i+1)+'</td>';
  77. blamerResultHtml +=' <td>'+(item.afterBlamer)+'</td>';
  78. blamerResultHtml +=' <td>'+(item.afterCount ? item.afterCount : 0)+'</td>';
  79. blamerResultHtml +=' <td>'+(item.orderEnds)+'</td>';
  80. blamerResultHtml +=' <td>'+(item.afterRatio)+'%</td>';
  81. blamerResultHtml +=' <td>'+(item.totalOrderAmount>=0 ? item.totalOrderAmount : 0).toFixed(2)/100+'</td>';
  82. blamerResultHtml +=' <td>'+(lamount>=0 ? lamount : 0).toFixed(2)+'</td>';
  83. blamerResultHtml +=' <td>'+(amount>=0 ? amount : 0).toFixed(2)+'</td>';
  84. blamerResultHtml +='</tr>';
  85. totalOrderAmount += parseFloat((item.totalOrderAmount>=0 ? item.totalOrderAmount : 0))/100;
  86. totalCount += parseFloat((item.afterCount ? item.afterCount : 0));
  87. totalAmount += parseFloat((lamount>=0 ? lamount : 0));
  88. totalLAmount += parseFloat((amount>=0 ? amount : 0));
  89. orderEndSum += item.orderEnds;
  90. });
  91. blamerResultHtml +='<tr class="z-h40">';
  92. blamerResultHtml +=' <td colspan="2">总计</td>';
  93. blamerResultHtml +=' <td>'+totalCount+'</td>';
  94. blamerResultHtml +=' <td>'+orderEndSum+'</td>';
  95. blamerResultHtml +=' <td>'+((totalCount *100)/orderEndSum).toFixed(2)+'%</td>';
  96. blamerResultHtml +=' <td>'+totalOrderAmount.toFixed(2)+'</td>';
  97. blamerResultHtml +=' <td>'+totalAmount.toFixed(2)+'</td>';
  98. blamerResultHtml +=' <td>'+totalLAmount.toFixed(2)+'</td>';
  99. blamerResultHtml +='</tr>';
  100. }
  101. else
  102. {
  103. blamerResultHtml +='<tr class="z-h40">';
  104. blamerResultHtml +=' <td colspan="7">暂时没有数据信息</td>';
  105. blamerResultHtml +='</tr>';
  106. }
  107. Z("#blamerResult").htmlc(blamerResultHtml);
  108. }
  109. function getAfterStatusHtml(status)
  110. {//获取售后窗台
  111. <#for item : AfterConstants.getStatusList()>
  112. if (''+status == ''+'${item.value()}')
  113. {
  114. var status${item_index} = "${AfterConstants.statusHtml(item.value())}";
  115. return status${item_index};
  116. }
  117. </#for>
  118. return '';
  119. }
  120. function doShowDetail(afterBlamer)
  121. {//显示详情
  122. var blamer = blamerAfterMap.get(afterBlamer);
  123. var afterDetail = blamer ? blamer.afterDetail : [];
  124. afterDetail = afterDetail ? afterDetail : [];
  125. var canceledDetail = blamer ? blamer.canceledDetail : [];
  126. canceledDetail = canceledDetail ? canceledDetail : [];
  127. var commNorecod = '';
  128. commNorecod += '<tr valign="middle" class="z-h40 z-text-center z-bg-white">';
  129. commNorecod += ' <td colspan="11">暂无数据信息</td>';
  130. commNorecod += '</tr>';
  131. var commThead = ''
  132. commThead += '<tr class="z-h40 z-text-center z-bg-gray">';
  133. commThead += ' <td width="120">设计单号</td>';
  134. commThead += ' <td width="100">处理状态</td>';
  135. commThead += ' <td width="100">损失金额</td>';
  136. commThead += ' <td width="100">赔付金额</td>';
  137. commThead += ' <td width="100">设计师</td>';
  138. commThead += ' <td width="*">产品</td>';
  139. commThead += ' <td width="90">售后完成时间</td>';
  140. commThead += ' <td width="*">售后原因</td>';
  141. commThead += '</tr>';
  142. var blamerAfterDetailHtml = '';
  143. blamerAfterDetailHtml += '<div class="z-overflow-y-auto">'
  144. blamerAfterDetailHtml += '<table class="z-table z-bordered z-bg-white z-text-center">';
  145. blamerAfterDetailHtml += '<tr class="z-h40"> ';
  146. blamerAfterDetailHtml += ' <td class="z-text-left z-bold z-px14 z-bg-white" colspan="10">&nbsp;<span class="z-text-red z-bold">['+afterBlamer+']</span>售后订单详情</td>';
  147. blamerAfterDetailHtml += '</tr>';
  148. blamerAfterDetailHtml += commThead;
  149. var lossAmount = 0;
  150. var lamount = 0;
  151. if (afterDetail.length > 0)
  152. {
  153. Z.each(afterDetail, function(item, i)
  154. {
  155. var myselectYear=document.getElementById("year");
  156. var myselectMonth=document.getElementById("month");
  157. var year=myselectYear.value;
  158. var month=myselectMonth.value;
  159. var dateTime = new Date(year+"-"+month+"-01 00:00:00").getTime();
  160. var lDateTime = new Date("2021-10-01 00:00:00").getTime();
  161. if(dateTime >= lDateTime){
  162. lossAmount = item.compensateAmount;
  163. }else {
  164. lossAmount = item.lossAmount;
  165. }
  166. lamount = item.lossAmount;
  167. blamerAfterDetailHtml += '<tr align="center" class="z-h40 z-pointer" bgcolor="'+(i%2 != 0 ? '#f3fdfc' : '#ffffff')+'"> ';
  168. blamerAfterDetailHtml += ' <td>'+item.designId+'</td>';
  169. blamerAfterDetailHtml += ' <td>'+getAfterStatusHtml(item.afterStatus)+'</td>';
  170. blamerAfterDetailHtml += ' <td>'+(lamount ? lamount : 0).toFixed(2)+'</td>';
  171. blamerAfterDetailHtml += ' <td>'+(lossAmount ? lossAmount : 0).toFixed(2)+'</td>';
  172. blamerAfterDetailHtml += ' <td>'+item.designer+'</td>';
  173. blamerAfterDetailHtml += ' <td>'+(item.orderText ? item.orderText : '')+'</td>';
  174. blamerAfterDetailHtml += ' <td>'+(item.afterFinishTime ? item.afterFinishTime : '')+'</td>';
  175. blamerAfterDetailHtml += ' <td>'+(item.problemDesc ? item.problemDesc : '')+'</td>';
  176. blamerAfterDetailHtml += '</tr>';
  177. });
  178. blamerAfterDetailHtml += '<tr valign="middle" class="z-h40 z-text-right z-bg-white">';
  179. blamerAfterDetailHtml += ' <td colspan="11">共&nbsp;<span class="z-text-red">'+afterDetail.length+'</span>&nbsp;条数据&nbsp;&nbsp;</td>';
  180. blamerAfterDetailHtml += '</tr>';
  181. }
  182. else
  183. blamerAfterDetailHtml += commNorecod;
  184. blamerAfterDetailHtml += ' </table>';
  185. blamerAfterDetailHtml += '</div>'
  186. blamerAfterDetailHtml += '</table>';
  187. blamerAfterDetailHtml += '</div>';
  188. Z("#blamerAfterDetailHtml").htmlc(blamerAfterDetailHtml);
  189. }
  190. </script>
  191. ${zhiqim_manager_breadcrumb("售后统计")}
  192. ${zhiqim_manager_content()}
  193. <#-- 导航栏 -->
  194. <div class="z-tabnav-main z-blue z-mg-b20">
  195. <nav>
  196. <ul>
  197. <!--<li onclick="Z.Location.href('personalAfterStatistics.htm');">个人售后统计</li>-->
  198. <li class="z-active">售后订单统计</li>
  199. <#if ZmrPathRule.check(request, "/designAfterReasonStatistics.htm")><li onclick="Z.L.href('designAfterReasonStatistics.htm')">售后原因统计</li></#if>
  200. </ul>
  201. </nav>
  202. </div>
  203. <table class="z-table z-bordered z-pd6">
  204. <tr>
  205. <td colspan="2">
  206. <form name="theForm">
  207. <table class="z-table">
  208. <tr class="z-h40" bgcolor="${zmr_thead_bgcolor}">
  209. <td class="z-bold z-px14 zi-pd-l5">&nbsp;统计查询条件:</td>
  210. </tr>
  211. </table>
  212. <table class="z-table z-bordered z-pd6">
  213. <tr class="z-h40 z-bg-white">
  214. <td width="300px">查询日期:
  215. <select id="year" name="year" class="z-select" data-role="z-select" data-class="z-blue">
  216. <#for yyyy : 2018..DateTimes.getCurrentYear()>
  217. <option id="optionYear" value="${yyyy}" <#if year==yyyy>selected</#if>>${yyyy}</option>
  218. </#for>
  219. </select>
  220. <select id="month" name="month" class="z-select" data-role="z-select" data-class="z-blue">
  221. <#for mm : 1..12>
  222. <option id="optionMonth" value="${mm}" <#if month==mm>selected</#if>>${mm}</option>
  223. </#for>
  224. </select>
  225. </td>
  226. <#if Validates.isNotEmpty(orgList)>
  227. <td width="250px">&nbsp;组&nbsp;&nbsp;织
  228. <select name="orgId" class="z-select z-w180" data-role="z-select-search" data-class="${zmr_color_class}">
  229. <option value="">请选择</option>
  230. <#for item : orgList>
  231. <option value="${item.getOrgId()}" <#if orgId == item.getOrgId()>selected</#if>>${item.getOrgName()}</option>
  232. </#for>
  233. </select>
  234. </td>
  235. </#if>
  236. <td>
  237. <button type="button" class="z-mg-l10 z-button ${zmr_color_class}" onclick="this.form.submit()">查询</button>
  238. </td>
  239. </table>
  240. </form>
  241. </td>
  242. </tr>
  243. <tr class="z-h40">
  244. <td width="500" valign="top">
  245. <div id="blamerResult" class="z-overflow-y-auto" style="max-height:760px">
  246. <table class="z-table z-bordered z-pd6 z-bg-white z-text-center" id="statTable">
  247. <tr class="z-h40">
  248. <td>责任人</td>
  249. <td>售后单数</td>
  250. <td>损失金额</td>
  251. </tr>
  252. <tr class="z-h40">
  253. <td colspan="5">暂时没有数据信息</td>
  254. </tr>
  255. </table>
  256. </div>
  257. </td>
  258. <td width="*" id="blamerAfterDetailHtml" valign="top"></td>
  259. </tr>
  260. </table>
  261. ${zhiqim_manager_content_end()}