financial_summary.js 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308
  1. $(document).ready(function() {
  2. autoFlashHeight();
  3. postData('/financial/' + spid + '/summary/load', {}, function (result) {
  4. console.log(result);
  5. tenders = result.tenders;
  6. transferList = result.transferList;
  7. transferTenderList = result.transferTenderList;
  8. payList = result.payList;
  9. summaryObj.setTenderSelect(result.tenders);
  10. summaryObj.changeHtmlAndCharts(result.tenders, result.transferList, result.transferTenderList, result.payList);
  11. });
  12. $('#tender-select').on('changed.bs.select', function (e, clickedIndex, isSelected, previousValue) {
  13. const vals = $(this).val();
  14. if (vals.length === 0) {
  15. $('#tender-select').selectpicker('val', '0');
  16. } else if (clickedIndex !== 0 && vals.length > 1 && _.includes(vals, '0')) {
  17. $('#tender-select').selectpicker('val', _.without(vals, '0'));
  18. } else if (clickedIndex === 0 && isSelected) {
  19. $('#tender-select').selectpicker('val', '0');
  20. }
  21. });
  22. $('#search-btn').click(function () {
  23. const tenderSelects = $('#tender-select').val().map(function (item, index) {
  24. return parseInt(item);
  25. });
  26. // 判断是单还是多个标段
  27. const is_single = tenderSelects.length === 1 && tenderSelects[0] !== 0;
  28. const is_all = tenderSelects.length === 1 && tenderSelects[0] === 0;
  29. const startMonth = $('#start-month').val();
  30. const endMonth = $('#end-month').val();
  31. const condition = {};
  32. let newTransferList = _.cloneDeep(transferList);
  33. let newTransferTenderList = _.cloneDeep(transferTenderList);
  34. let newPayList = _.cloneDeep(payList);
  35. if (startMonth !== '' && endMonth !== '') {
  36. // 判断输入合法和endMonth大于startMonth
  37. if (!/^\d{4}-\d{2}$/.test(startMonth) || !/^\d{4}-\d{2}$/.test(endMonth)) {
  38. toastr.warning('请输入正确的日期格式');
  39. return;
  40. }
  41. if (startMonth > endMonth) {
  42. toastr.warning('结束日期不能小于开始日期');
  43. return;
  44. }
  45. newTransferList = _.filter(newTransferList, function (item) {
  46. return item.t_time >= startMonth && item.t_time <= endMonth;
  47. });
  48. newTransferTenderList = _.filter(newTransferTenderList, function (item) {
  49. return _.includes(_.map(newTransferList, 'id'), item.trid);
  50. });
  51. newPayList = _.filter(newPayList, function (item) {
  52. const thisMonth = moment(item.create_time).format('YYYY-MM');
  53. return thisMonth >= startMonth && thisMonth <= endMonth;
  54. });
  55. } else if (startMonth !== '' || endMonth !== '') {
  56. toastr.warning('请选择开始和结束日期查询');
  57. return;
  58. }
  59. newTransferTenderList = !is_all ? _.filter(newTransferTenderList, function (item) { return _.includes(tenderSelects, item.tid); }) : newTransferTenderList;
  60. newPayList = !is_all ? _.filter(newPayList, function (item) { return _.includes(tenderSelects, item.tid); }) : newPayList;
  61. const newTenders = !is_all ? _.filter(tenders, function (item) { return _.includes(tenderSelects, item.tid); }) : tenders;
  62. summaryObj.changeHtmlAndCharts(newTenders, newTransferList, newTransferTenderList, newPayList, tenderSelects);
  63. });
  64. const summaryObj = {
  65. setTenderSelect: function (tenders) {
  66. let tenderSelectHtml = '<option value="0" selected>全部</option>';
  67. for (const tender of tenders) {
  68. tenderSelectHtml += `<option value="${tender.id}">${tender.name}</option>`;
  69. }
  70. $('#tender-select').html(tenderSelectHtml);
  71. $('#tender-select').selectpicker();
  72. },
  73. changeHtmlAndCharts: function (tenders, transferList, transferTenderList, payList, tenderSelects = [0]) {
  74. const transfer_price = tenderSelects !== [0] ? _.map(transferTenderList, 'hb_tp') : _.map(transferList, 'total_price');
  75. const transfer_sum_price = ZhCalc.sum(transfer_price);
  76. const pay_price = _.map(payList, 'total_price');
  77. const pay_sum_price = ZhCalc.sum(pay_price);
  78. const pend_sum_price = ZhCalc.sub(transfer_sum_price, pay_sum_price);
  79. const small_expenses_tp = _.map(payList, 'small_expenses_tp');
  80. const small_expenses_sum_price = ZhCalc.sum(small_expenses_tp);
  81. // 金额概况
  82. $('#transfer_price').text(transfer_sum_price.format2Str('#,##0.######'));
  83. $('#pay_price').text(pay_sum_price.format2Str('#,##0.######'));
  84. $('#pend_price').text(pend_sum_price.format2Str('#,##0.######'));
  85. // 支付进度
  86. const pay_progress = (ZhCalc.div(pay_sum_price, ZhCalc.add(pay_sum_price, pend_sum_price)) * 100).toFixed(0);
  87. const pend_progress = 100 - pay_progress;
  88. $('#pay_progress').html(`
  89. <div class="progress-bar bg-success" style="width: ${pay_progress}%;" data-placement="bottom" data-toggle="tooltip" data-original-title="累计支付:¥${pay_sum_price.format2Str('#,##0.######')}">${pay_progress}%</div>
  90. <div class="progress-bar bg-gray" style="width: ${pend_progress}%;" data-placement="bottom" data-toggle="tooltip" data-original-title="待支付:¥${pend_sum_price.format2Str('#,##0.######')}">${pend_progress}%</div>`);
  91. $('[data-toggle="tooltip"]').tooltip();
  92. // 资金支出明细
  93. let pay_used_html = '';
  94. payUsedOption.series[0].data = [];
  95. for (const used of usedList) {
  96. const usedPays = _.filter(payList, { used: used });
  97. if (usedPays.length > 0) {
  98. const used_price = _.map(usedPays, 'total_price');
  99. const used_sum_price = ZhCalc.sum(used_price)
  100. pay_used_html += `<tr class="text-center"><td>${used}</td><td>${used_sum_price.format2Str('#,##0.######')}</td> <td>${(pay_sum_price ? ZhCalc.div(used_sum_price, pay_sum_price) * 100 : 0).toFixed(2)}%</td></tr>`;
  101. payUsedOption.series[0].data.push({ value: used_sum_price, name: used });
  102. }
  103. }
  104. pay_used_html += `<tr class="text-center"><td><strong>合计</strong></td><td>${pay_sum_price.format2Str('#,##0.######')}</td> <td></td></tr>`;
  105. pay_used_html += `<tr class="text-center"><td>其中:小额支出</td><td>${small_expenses_sum_price.format2Str('#,##0.######')}</td><td>${(pay_sum_price ? ZhCalc.div(small_expenses_sum_price, pay_sum_price) * 100 : 0).toFixed(2)}%</td></tr>`;
  106. $('#pay_used_table').html(pay_used_html);
  107. // 标段支出概况图表
  108. tenderOption.xAxis[0].data = _.map(tenders, 'name');
  109. tenderOption.series[0].data = [];
  110. tenderOption.series[1].data = [];
  111. for (const t of tenders) {
  112. const transferTenders = _.filter(transferTenderList, { tid: t.id });
  113. const transfer_tender_price = ZhCalc.sum(_.map(transferTenders, 'hb_tp'));
  114. const payTenders = _.filter(payList, { tid: t.id });
  115. const pay_tender_price = ZhCalc.sum(_.map(payTenders, 'total_price'));
  116. tenderOption.series[0].data.push(transfer_tender_price);
  117. tenderOption.series[1].data.push(pay_tender_price);
  118. }
  119. tenderChart.setOption(tenderOption);
  120. // 支出明细占比图表
  121. payUsedChart.setOption(payUsedOption);
  122. // 小额支出占比
  123. paySeOption.series[0].data = [
  124. { value: small_expenses_sum_price, name: '小额支出' },
  125. { value: ZhCalc.sub(pay_sum_price, small_expenses_sum_price), name: '其他' },
  126. ];
  127. paySeChart.setOption(paySeOption);
  128. },
  129. }
  130. let resizeTimer = null;
  131. $(window).bind('resize', function () {
  132. if (resizeTimer) clearTimeout(resizeTimer);
  133. resizeTimer = setTimeout(function () {
  134. echartsReset();
  135. }, 500);
  136. })
  137. function echartsReset() {
  138. tenderChart.resize();
  139. payUsedChart.resize();
  140. paySeChart.resize();
  141. }
  142. //标段占比
  143. const tenderChart = echarts.init(document.getElementById('jlchart3'));
  144. const tenderOption = {
  145. tooltip: {
  146. trigger: 'axis',
  147. axisPointer: {
  148. type: 'shadow'
  149. }
  150. },
  151. legend: {},
  152. grid: {
  153. left: '3%',
  154. right: '4%',
  155. bottom: '3%',
  156. containLabel: true
  157. },
  158. xAxis: [
  159. {
  160. type: 'category',
  161. data: []
  162. }
  163. ],
  164. yAxis: [
  165. {
  166. type: 'value'
  167. }
  168. ],
  169. series: [
  170. {
  171. name: '累计划拨',
  172. type: 'bar',
  173. emphasis: {
  174. focus: 'series'
  175. },
  176. data: []
  177. },
  178. {
  179. name: '累计支付',
  180. type: 'bar',
  181. stack: 'Ad',
  182. emphasis: {
  183. focus: 'series'
  184. },
  185. data: []
  186. }
  187. ]
  188. };
  189. // tenderChart.setOption(tenderOption);
  190. //费用明细占比//
  191. const payUsedChart = echarts.init(document.getElementById('jlchart1'));
  192. const payUsedOption = {
  193. color: ['#9489fa', '#f06464', '#f7af59', '#f0da49', '#71c16f', '#2aaaef', '#5690dd', '#bd88f5', '#009db2', '#0780cf'],
  194. //backgroundColor: '#343a40 ',
  195. tooltip: {
  196. trigger: 'item'
  197. },
  198. legend: {
  199. orient: 'vertical',
  200. left:'60%',
  201. right:'20%',
  202. top: 'middle'
  203. },
  204. series: [
  205. {
  206. name: '金额',
  207. type: 'pie',
  208. top:'20',
  209. bottom:'20',
  210. right:'40%',
  211. radius: ['80%'],
  212. avoidLabelOverlap: false,
  213. label: {
  214. show: false,
  215. position: 'right'
  216. },
  217. emphasis: {
  218. label: {
  219. show: true,
  220. fontSize: '40',
  221. fontWeight: 'bold'
  222. }
  223. },
  224. labelLine: {
  225. show: false
  226. },
  227. data: [],
  228. }
  229. ]
  230. };
  231. // 为echarts对象加载数据
  232. // myChart1.setOption(option1);
  233. //小额支出概况//
  234. var paySeChart = echarts.init(document.getElementById('jlchart2'));
  235. var paySeOption = {
  236. color: [ '#71c16f', '#2aaaef'],
  237. //backgroundColor: '#343a40 ',
  238. tooltip: {
  239. trigger: 'item'
  240. },
  241. legend: {
  242. orient: 'vertical',
  243. left:'60%',
  244. right: '20%',
  245. top: 'middle'
  246. },
  247. series: [
  248. {
  249. name: '金额',
  250. type: 'pie',
  251. top:'20',
  252. bottom:'20',
  253. right:'40%',
  254. radius: ['80%'],
  255. avoidLabelOverlap: false,
  256. label: {
  257. show: false,
  258. position: 'right'
  259. },
  260. emphasis: {
  261. label: {
  262. show: true,
  263. fontSize: '40',
  264. fontWeight: 'bold'
  265. }
  266. },
  267. labelLine: {
  268. show: false
  269. },
  270. data: []
  271. }
  272. ]
  273. };
  274. // 为echarts对象加载数据
  275. // myChart2.setOption(option2);
  276. $.subMenu({
  277. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  278. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  279. key: 'menu.1.0.0',
  280. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  281. callback: function (info) {
  282. if (info.mini) {
  283. $('.panel-title').addClass('fluid');
  284. $('#sub-menu').removeClass('panel-sidebar');
  285. } else {
  286. $('.panel-title').removeClass('fluid');
  287. $('#sub-menu').addClass('panel-sidebar');
  288. }
  289. autoFlashHeight();
  290. }
  291. });
  292. });