ledger_check_modal.ejs 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261
  1. <!--数据检查-->
  2. <div class="modal fade" id="ledger-check-modal" data-backdrop="static">
  3. <div class="modal-dialog" role="document">
  4. <div class="modal-content">
  5. <div class="modal-header">
  6. <h5 class="modal-title">数据检查</h5>
  7. </div>
  8. <div class="modal-body">
  9. <div class="text-center my-3">
  10. <button class="btn btn-primary px-5" id="ledger-check-begin">开始检查</button>
  11. <h6 class="text-center mt-3">数据检查可以为您排查有问题项</h6>
  12. </div>
  13. </div>
  14. </div>
  15. </div>
  16. </div>
  17. <div class="modal fade" id="ledger-check-result" data-backdrop="static">
  18. <div class="modal-dialog" role="document">
  19. <div class="modal-content">
  20. <div class="modal-header">
  21. <h5 class="modal-title">数据检查</h5>
  22. </div>
  23. <div class="modal-body">
  24. <p>数据检查,将检查罗列台账中以下内容:</p>
  25. <div class="card mb-2 p-2 border-success" id="check-sibling">
  26. <div class="d-flex justify-content-between">
  27. 项目节、清单同层
  28. <span class="text-muted" name="check-status">待检查</span>
  29. </div>
  30. </div>
  31. <div class="card mb-2 p-2 border-success" id="check-empty-code">
  32. <div class="d-flex justify-content-between">
  33. 项目节、清单编号同时为空
  34. <span class="text-success" title="完成" name="check-status"><i class="fa fa-check"></i></span>
  35. </div>
  36. </div>
  37. <div class="card mb-2 p-2 border-success" id="check-calc">
  38. <div class="d-flex justify-content-between">
  39. 清单数量不等于计量单元之和
  40. <span class="text-success" title="完成" name="check-status"><i class="fa fa-check"></i></span>
  41. </div>
  42. </div>
  43. <div class="card mb-2 p-2 border-success" id="check-zero">
  44. <div class="d-flex justify-content-between">
  45. 清单数量或单价为0
  46. <span class="text-success" title="完成" name="check-status"><i class="fa fa-check"></i></span>
  47. </div>
  48. </div>
  49. <div class="card mb-2 p-2 border-success" id="check-tp">
  50. <div class="d-flex justify-content-between">
  51. 清单金额≠数量×单价
  52. <span class="text-success" title="完成" name="check-status"><i class="fa fa-check"></i></span>
  53. </div>
  54. </div>
  55. <a href="#" class="btn btn-sm btn-block btn-primary disabled" id="ledger-check-waiting">检查中,请等待...</a>
  56. <p class="text-center text-success" id="ledger-check-hint">检查完成,现在您可以查看结果。</p>
  57. </div>
  58. <div class="modal-footer">
  59. <button type="button" class="btn btn-sm btn-secondary" data-dismiss="modal">关闭</button>
  60. <!--检查完有结果显示按钮-->
  61. <button type="button" class="btn btn-sm btn-primary" id="ledger-check-show">查看结果</button>
  62. </div>
  63. </div>
  64. </div>
  65. </div>
  66. <script>
  67. const ledgerCheckType = {
  68. sibling: {value: 1, text: '项目节、清单同层'},
  69. empty_code: {value: 2, text: '项目节、清单编号同时为空'},
  70. calc: {value: 3, text: '清单数量不等于计量单元之和'},
  71. zero: {value: 4, text: '清单数量或单价为0'},
  72. tp: {value: 5, text: '清单金额≠数量×单价'},
  73. };
  74. const LedgerChecker = function (setting) {
  75. const ledger = setting.ledgerTree, ledgerPos = setting.ledgerPos, decimal = setting.decimal;
  76. const checkOption = setting.checkOption;
  77. const showCheckPart = function (obj, show) {
  78. if (show) {
  79. obj.show();
  80. } else {
  81. obj.hide();
  82. }
  83. }
  84. const initWaitingModal = function () {
  85. $('.card', '#ledger-check-result').removeClass('border-success').removeClass('border-warning');
  86. $('[name=check-status]', '#ledger-check-result').removeClass('text-success').removeClass('text-warning')
  87. .addClass('text-muted').html('待检查');
  88. showCheckPart($('#check-sibling'), checkOption.sibling.enable);
  89. showCheckPart($('#check-empty-code'), checkOption.empty_code.enable);
  90. showCheckPart($('#check-calc'), checkOption.calc.enable);
  91. showCheckPart($('#check-zero'), checkOption.zero.enable);
  92. showCheckPart($('#check-tp'), checkOption.tp.enable);
  93. $('#ledger-check-begin').show();
  94. $('#ledger-check-waiting').hide();
  95. $('#ledger-check-hint').removeClass('text-warning').addClass('text-success').html('检查完成,现在您可以查看结果。').hide();
  96. $('#ledger-check-show').hide();
  97. }
  98. const doSomeCheck = function (selector, checkFun, option) {
  99. const checkStatus = $('[name=check-status]', selector);
  100. checkStatus.html('<i class="fa fa-spinner fa-spin"></i>');
  101. const result = checkFun(ledger, option);
  102. if (result && result.length > 0) {
  103. checkStatus.removeClass('text-muted').addClass('text-warning').html('<i class="fa fa-exclamation-triangle"></i>');
  104. $(selector).addClass('border-warning');
  105. } else {
  106. checkStatus.removeClass('text-muted').addClass('text-success').html('<i class="fa fa-check"></i>');
  107. $(selector).addClass('border-success');
  108. }
  109. return result;
  110. }
  111. const ledgerCheckUtil = {
  112. checkSibling: function (ledgerTree) {
  113. const error = [];
  114. for (const node of ledgerTree.nodes) {
  115. if (!node.children || node.children.length === 0) continue;
  116. let hasXmj, hasGcl;
  117. for (const child of node.children) {
  118. if (child.b_code) hasXmj = true;
  119. if (!child.b_code) hasGcl = true;
  120. }
  121. if (hasXmj && hasGcl) error.push(node);
  122. }
  123. return error;
  124. },
  125. checkCodeEmpty: function (ledgerTree) {
  126. const error = [];
  127. const checkNodeCode = function (node) {
  128. if ((!node.code || node.code === '') && (!node.b_code || node.b_code === '')) error.push(node);
  129. if (node.children && node.children.length > 0) {
  130. for (const child of node.children) {
  131. checkNodeCode(child);
  132. }
  133. }
  134. }
  135. for (const topLevel of ledgerTree.children) {
  136. if (topLevel.node_type !== 1) continue;
  137. checkNodeCode(topLevel);
  138. }
  139. return error;
  140. },
  141. checkCalc: function (ledgerTree, option) {
  142. const error = [];
  143. for (const node of ledgerTree.nodes) {
  144. if (node.children && node.children.length > 0) continue;
  145. const nodePos = ledgerPos.getLedgerPos(node.id);
  146. if (!nodePos || nodePos.length === 0) continue;
  147. const checkData = {}, calcData = {};
  148. for (const f of option.fields) {
  149. checkData[f] = node[f] || 0;
  150. calcData[f] = 0;
  151. }
  152. for (const np of nodePos) {
  153. for (const f of option.fields) {
  154. calcData[f] = ZhCalc.add(calcData[f], np[f]) || 0;
  155. }
  156. }
  157. if (!_.isMatch(checkData, calcData)) error.push(node);
  158. }
  159. return error;
  160. },
  161. checkZero: function (ledgerTree) {
  162. const error = [];
  163. for (const node of ledgerTree.nodes) {
  164. if ((!node.b_code || node.b_code === '')) continue;
  165. if (node.children && node.children.length > 0) continue;
  166. if ((checkZero(node.sgfh_qty) && checkZero(node.qtcl_qty) && checkZero(node.sjcl_qty)
  167. && checkZero(node.deal_qty) && checkZero(node.quantity))
  168. || checkZero(node.unit_price)) error.push(node);
  169. }
  170. return error;
  171. },
  172. checkTp: function (ledgerTree, option) {
  173. const error = [];
  174. for (const node of ledgerTree.nodes) {
  175. if (node.children && node.children.length > 0) continue;
  176. if (option.filter && option.filter(node)) continue;
  177. const checkData = {}, calcData = {};
  178. for (const f of option.fields) {
  179. checkData[f.tp] = node[f.tp] || 0;
  180. calcData[f.tp] = ZhCalc.mul(node.unit_price, node[f.qty], decimal.tp) || 0;
  181. }
  182. if (!_.isMatch(checkData, calcData)) error.push(node);
  183. }
  184. return error;
  185. }
  186. };
  187. const assignWarningData = function (nodes, checkType, warningData) {
  188. for (const node of nodes) {
  189. warningData.push({
  190. type: checkType,
  191. ledger_id: node.ledger_id,
  192. code: node.code,
  193. b_code: node.b_code,
  194. name: node.name,
  195. })
  196. }
  197. }
  198. const checkData = function () {
  199. $('#ledger-check-waiting').show();
  200. const checkData = {
  201. check_time: new Date(),
  202. warning_data: [],
  203. }
  204. if (checkOption.sibling.enable) {
  205. const sibling = doSomeCheck('#check-sibling', ledgerCheckUtil.checkSibling, checkOption.sibling) || [];
  206. assignWarningData(sibling, ledgerCheckType.sibling.value, checkData.warning_data);
  207. }
  208. if (checkOption.empty_code.enable) {
  209. const empty_code = doSomeCheck('#check-empty-code', ledgerCheckUtil.checkCodeEmpty, checkOption.empty_code) || [];
  210. assignWarningData(empty_code, ledgerCheckType.empty_code.value, checkData.warning_data);
  211. }
  212. if (checkOption.calc.enable) {
  213. const calc = doSomeCheck('#check-calc', ledgerCheckUtil.checkCalc, checkOption.calc) || [];
  214. assignWarningData(calc, ledgerCheckType.calc.value, checkData.warning_data);
  215. }
  216. if (checkOption.zero.enable) {
  217. const zero = doSomeCheck('#check-zero', ledgerCheckUtil.checkZero, checkOption.zero) || [];
  218. assignWarningData(zero, ledgerCheckType.zero.value, checkData.warning_data);
  219. }
  220. if (checkOption.tp.enable) {
  221. const tp = doSomeCheck('#check-tp', ledgerCheckUtil.checkTp, checkOption.tp) || [];
  222. assignWarningData(tp, ledgerCheckType.tp.value, checkData.warning_data);
  223. }
  224. $('#ledger-check-waiting').hide();
  225. setting.checkList.clearCheckData();
  226. if (checkData.warning_data.length > 0) {
  227. $('#ledger-check-hint').removeClass('text-success').addClass('text-warning').html('检查完成,发现问题,请查阅检查结果。').show();
  228. $('#ledger-check-show').show();
  229. setting.checkList.loadCheckData(checkData);
  230. } else {
  231. setting.checkList.hide();
  232. $('#ledger-check-show').hide();
  233. $('#ledger-check-hint').html('检查完成,没有任何问题。').show();
  234. }
  235. }
  236. $('#ledger-check-begin').bind('click', () => {
  237. $('#ledger-check-modal').modal('hide');
  238. initWaitingModal();
  239. checkData();
  240. $('#ledger-check-result').modal('show');
  241. });
  242. $('#ledger-check-show').bind('click', function () {
  243. $('#ledger-check-result').modal('hide');
  244. setting.checkList.show();
  245. });
  246. }
  247. </script>