compare.ejs 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223
  1. <% include ./sub_menu.ejs %>
  2. <div class="panel-content">
  3. <div class="panel-title">
  4. <div class="title-main d-flex">
  5. <% include ./sub_mini_menu.ejs %>
  6. <div class="d-inline-block">
  7. <div class="dropdown">
  8. <button class="btn btn-sm btn-light dropdown-toggle text-primary" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
  9. <i class="fa fa-list-ol"></i> 显示层级
  10. </button>
  11. <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
  12. <a class="dropdown-item" name="showLevel" tag="1" href="javascirpt: void(0);">第一层</a>
  13. <a class="dropdown-item" name="showLevel" tag="2" href="javascirpt: void(0);">第二层</a>
  14. <a class="dropdown-item" name="showLevel" tag="3" href="javascirpt: void(0);">第三层</a>
  15. <a class="dropdown-item" name="showLevel" tag="4" href="javascirpt: void(0);">第四层</a>
  16. <a class="dropdown-item" name="showLevel" tag="5" href="javascirpt: void(0);">第五层</a>
  17. <a class="dropdown-item" name="showLevel" tag="last" href="javascirpt: void(0);">最底层</a>
  18. <a class="dropdown-item" name="showLevel" tag="leafXmj" href="javascirpt: void(0);">只显示项目节</a>
  19. <a class="dropdown-item" name="showLevel" tag="differ" href="javascirpt: void(0);">只显示修订项</a>
  20. </div>
  21. </div>
  22. </div>
  23. <div class="d-inline-block">
  24. <span class=""><i class="fa fa-stop text-warning-50 border-warning-50 bg-primary-50"></i> 新增</span>
  25. <span class="ml-2"><i class="fa fa-stop text-secondary-50 border-secondary-50 bg-secondary-50"></i> 删除</span>
  26. <span class="ml-2"><i class="fa fa-stop text-info-50 border-info-50 bg-info-50"></i> 结构调整</span>
  27. <span class="ml-2"><i class="fa fa-stop text-danger-50 border-danger-50 bg-danger-50"></i> 计算项修改</span>
  28. <span class="ml-2"><i class="fa fa-stop text-success-50 border-success-50 bg-success-50"></i> 文字修改</span>
  29. </div>
  30. <div class="ml-auto">
  31. <% if (lastStage) { %>
  32. <a class="btn btn-sm btn-primary mr-1" href="#load-stage" data-toggle="modal" data-target="#load-stage">加载计量数据</a>
  33. <% } %>
  34. </div>
  35. </div>
  36. </div>
  37. <div class="content-wrap row pr-46">
  38. <div class="c-header p-0 col-12"></div>
  39. <!--核心内容(两栏)-->
  40. <div class="row w-100 sub-content">
  41. <!--左栏-->
  42. <div class="c-body" id="left-view" style="width: 100%">
  43. <!--0号台账模式-->
  44. <div class="sjs-height-1" style="overflow: hidden" id="bills-spread">
  45. </div>
  46. <% if (ctx.tender.data.measure_type === measureType.tz.value) { %>
  47. <div class="bcontent-wrap">
  48. <div id="revise-resize" class="resize-y" id="top-spr" r-Type="height" div1=".sjs-height-1" div2=".bcontent-wrap" title="调整大小"><!--调整上下高度条--></div>
  49. <div class="bc-bar mb-1">
  50. <ul class="nav nav-tabs">
  51. <li class="nav-item">
  52. <a class="nav-link active" href="javascript:void(0)">计量单元</a>
  53. </li>
  54. <li>
  55. <div class="d-inline-block ml-2 mt-1">
  56. <span class=""><i class="fa fa-stop text-warning-50 border-warning-50 bg-primary-50"></i> 新增</span>
  57. <span class="ml-2"><i class="fa fa-stop text-secondary-50 border-secondary-50 bg-secondary-50"></i> 删除</span>
  58. <span class="ml-2"><i class="fa fa-stop text-danger-50 border-danger-50 bg-danger-50"></i> 数量修改</span>
  59. <span class="ml-2"><i class="fa fa-stop text-success-50 border-success-50 bg-success-50"></i> 文字修改</span>
  60. </div>
  61. </li>
  62. <li class="nav-item" id="pos-search">
  63. </li>
  64. </ul>
  65. </div>
  66. <div class="sp-wrap" id="pos-spread">
  67. </div>
  68. </div>
  69. <% } %>
  70. </div>
  71. <!--右栏-->
  72. <div class="c-body" id="right-view" style="display: none; width: 33%;">
  73. <div class="resize-x" id="revise-right-spr" r-Type="width" div1="#left-view" div2="#right-view" title="调整大小" a-type="percent"><!--调整左右高度条--></div>
  74. <div class="tab-content">
  75. <div id="search" class="tab-pane">
  76. </div>
  77. </div>
  78. </div>
  79. </div>
  80. <!--右侧菜单-->
  81. <div class="side-menu">
  82. <!--右侧菜单-->
  83. <ul class="nav flex-column right-nav" id="side-menu">
  84. <li class="nav-item">
  85. <a class="nav-link" content="#search" href="javascript: void(0);">查找定位</a>
  86. </li>
  87. </ul>
  88. </div>
  89. </div>
  90. </div>
  91. <script src="/public/js/moment/moment.min.js"></script>
  92. <script>
  93. const isTz = <%- ctx.tender.data.measure_type === measureType.tz.value %>;
  94. const thousandth = <%- ctx.tender.info.display.thousandth %>;
  95. const decimal = JSON.parse('<%- JSON.stringify(ctx.tender.info.decimal) %>');
  96. const compareFields = {
  97. info: ['code', 'b_code', 'name', 'unit'],
  98. leafCalc: ['unit_price', 'sgfh_qty', 'sgfh_tp', 'qtcl_qty', 'qtcl_tp', 'sjcl_qty', 'sjcl_tp', 'deal_qty', 'deal_tp', 'quantity', 'total_price'],
  99. parentCalc: ['dgn_qty1', 'dgn_qty2',],
  100. posInfo: ['name', 'position'],
  101. posCalc: ['sgfh_qty', 'qtcl_qty', 'sjcl_qty'],
  102. }
  103. const getCompare = function (node, field, prefix, defaultValue) {
  104. const result = {};
  105. for (const f of field) {
  106. result[f] = node[prefix + f] || defaultValue;
  107. }
  108. return result;
  109. };
  110. const billsSpreadSetting = {
  111. cols: [
  112. {title: '', colSpan: '1', rowSpan: '3', field: 'differ_str', hAlign: 1, width: 20, formatter: '@', cellType: 'tip', getTip: function (x) {
  113. if (x.differ_str.indexOf('改') >= 0) {
  114. const differ_hint = [];
  115. if (x.differ.indexOf('tree') >= 0)
  116. differ_hint.push('结构调整(原父项:' + (x.org_parent.code || '') + (x.org_parent.b_code || 0) + ')');
  117. if (x.differ.indexOf('calc') >= 0) differ_hint.push('计算项修改');
  118. if (x.differ.indexOf('info') >= 0) differ_hint.push('文字修改');
  119. const pos_hint = [];
  120. if (x.differ.indexOf('pos-add') >= 0) pos_hint.push('增');
  121. if (x.differ.indexOf('pos-del') >= 0) pos_hint.push('删');
  122. if (x.differ.indexOf('pos-info') >= 0) pos_hint.push('文改');
  123. if (x.differ.indexOf('pos-calc') >= 0) pos_hint.push('量改');
  124. if (pos_hint.length > 0) differ_hint.push('计量单元: ' + pos_hint.join(','))
  125. return differ_hint.join('<br>');
  126. } else {
  127. return '';
  128. }
  129. }},
  130. {title: '修订台账|项目节编号', colSpan: '16|1', rowSpan: '1|2', field: 'new_code', hAlign: 0, width: 145, formatter: '@', cellType: 'tree'},
  131. {title: '|清单编号', colSpan: '|1', rowSpan: '|2', field: 'new_b_code', hAlign: 0, width: 70, formatter: '@'},
  132. {title: '|名称', colSpan: '|1', rowSpan: '|2', field: 'new_name', hAlign: 0, width: 185, formatter: '@'},
  133. {title: '|单位', colSpan: '|1', rowSpan: '|2', field: 'new_unit', hAlign: 1, width: 50, formatter: '@'},
  134. {title: '|单价', colSpan: '|1', rowSpan: '|2', field: 'new_unit_price', hAlign: 2, width: 60, type: 'Number'},
  135. {title: '|项目节数量|数量1', colSpan: '|2|1', rowSpan: '|1|1', field: 'new_dgn_qty1', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.dgnQty%>},
  136. {title: '||数量2', colSpan: '||1', rowSpan: '||1', field: 'new_dgn_qty2', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.dgnQty%>},
  137. {title: '|经济指标', colSpan: '|1', rowSpan: '|2', field: 'new_dgn_price', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.dgnQty%>},
  138. {title: '|签约|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'new_deal_qty', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.data.measure_type === measureType.gcl.value%>},
  139. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'new_deal_tp', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.data.measure_type === measureType.gcl.value%>},
  140. {title: '|设计量|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'new_sgfh_qty', hAlign: 2, width: 60, type: 'Number'},
  141. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'new_sgfh_tp', hAlign: 2, width: 60, type: 'Number'},
  142. {title: '|设计错漏增减|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'new_sjcl_qty', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  143. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'new_sjcl_tp', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  144. {title: '|其他错漏增减|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'new_qtcl_qty', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  145. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'new_qtcl_tp', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  146. {title: '|台账小计|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'new_quantity', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  147. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'new_total_price', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  148. {title: '原台账|项目节编号', colSpan: '16|1', rowSpan: '1|2', field: 'org_code', hAlign: 0, width: 145, formatter: '@', cellType: 'tree'},
  149. {title: '|清单编号', colSpan: '|1', rowSpan: '|2', field: 'org_b_code', hAlign: 0, width: 70, formatter: '@'},
  150. {title: '|名称', colSpan: '|1', rowSpan: '|2', field: 'org_name', hAlign: 0, width: 185, formatter: '@'},
  151. {title: '|单位', colSpan: '|1', rowSpan: '|2', field: 'org_unit', hAlign: 1, width: 50, formatter: '@', cellType: 'unit'},
  152. {title: '|单价', colSpan: '|1', rowSpan: '|2', field: 'org_unit_price', hAlign: 2, width: 60, type: 'Number'},
  153. {title: '|项目节数量|数量1', colSpan: '|2|1', rowSpan: '|1|1', field: 'org_dgn_qty1', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.dgnQty%>},
  154. {title: '||数量2', colSpan: '||1', rowSpan: '||1', field: 'org_dgn_qty2', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.dgnQty%>},
  155. {title: '|经济指标', colSpan: '|1', rowSpan: '|2', field: 'org_dgn_price', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.dgnQty%>},
  156. {title: '|签约|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'org_deal_qty', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.data.measure_type === measureType.gcl.value%>},
  157. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'org_deal_tp', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.data.measure_type === measureType.gcl.value%>},
  158. {title: '|设计量|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'org_sgfh_qty', hAlign: 2, width: 60, type: 'Number'},
  159. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'org_sgfh_tp', hAlign: 2, width: 60, type: 'Number'},
  160. {title: '|设计错漏增减|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'org_sjcl_qty', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  161. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'org_sjcl_tp', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  162. {title: '|其他错漏增减|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'org_qtcl_qty', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  163. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'org_qtcl_tp', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  164. {title: '|台账小计|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'org_quantity', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  165. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'org_total_price', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  166. ],
  167. extraCols: [
  168. {title: '计量数据|本期合同计量|数量', colSpan: '8|2|1', rowSpan: '1|1|1', field: 'contract_qty', hAlign: 2, width: 60, type: 'Number'},
  169. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'contract_tp', hAlign: 2, width: 60, type: 'Number'},
  170. {title: '|本期数量变更|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'qc_qty', hAlign: 2, width: 60, type: 'Number'},
  171. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'qc_tp', hAlign: 2, width: 60, type: 'Number'},
  172. // {title: '|本期完成计量|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'gather_qty', hAlign: 2, width: 60, type: 'Number'},
  173. // {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'gather_tp', hAlign: 2, width: 60, type: 'Number'},
  174. {title: '|截止本期合同计量|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'end_contract_qty', hAlign: 2, width: 60, type: 'Number'},
  175. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'end_contract_tp', hAlign: 2, width: 60, type: 'Number'},
  176. {title: '|截止本期数量变更|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'end_qc_qty', hAlign: 2, width: 60, type: 'Number'},
  177. {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'end_qc_tp', hAlign: 2, width: 60, type: 'Number'},
  178. // {title: '|截止本期完成计量|数量', colSpan: '|2|1', rowSpan: '|1|1', field: 'end_gather_qty', hAlign: 2, width: 60, type: 'Number'},
  179. // {title: '||金额', colSpan: '||1', rowSpan: '||1', field: 'end_gather_tp', hAlign: 2, width: 60, type: 'Number'},
  180. ],
  181. emptyRows: 3,
  182. headRows: 3,
  183. headRowHeight: [25, 25, 25],
  184. defaultRowHeight: 21,
  185. headerFont: '12px 微软雅黑',
  186. font: '12px 微软雅黑',
  187. readOnly: true,
  188. };
  189. const posSpreadSetting = {
  190. cols: [
  191. {title: '', colSpan: '1', rowSpan: '3', field: 'differ_str', hAlign: 1, width: 60, formatter: '@'},
  192. {title: '修改台账|计量单元', colSpan: '6|1', rowSpan: '1|2', field: 'new_name', hAlign: 0, width: 230, formatter: '@'},
  193. {title: '|位置', colSpan: '|1', rowSpan: '|2', field: 'new_position', hAlign: 0, width: 60, formatter: '@'},
  194. {title: '|台账数量|设计量', colSpan: '|4|1', rowSpan: '|1|1', field: 'new_sgfh_qty', hAlign: 2, width: 100, type: 'Number'},
  195. {title: '||设计错漏增减', colSpan: '||1', rowSpan: '||1', field: 'new_sjcl_qty', hAlign: 2, width: 100, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  196. {title: '||其他错漏增减', colSpan: '||1', rowSpan: '||1', field: 'new_qtcl_qty', hAlign: 2, width: 100, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  197. {title: '||小计', colSpan: '||1', rowSpan: '||1', field: 'new_quantity', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  198. {title: '原台账|计量单元', colSpan: '6|1', rowSpan: '1|2', field: 'org_name', hAlign: 0, width: 230, formatter: '@'},
  199. {title: '|位置', colSpan: '|1', rowSpan: '|2', field: 'org_position', hAlign: 0, width: 60, formatter: '@'},
  200. {title: '|台账数量|设计量', colSpan: '|4|1', rowSpan: '|1|1', field: 'org_sgfh_qty', hAlign: 2, width: 100, type: 'Number'},
  201. {title: '||设计错漏增减', colSpan: '||1', rowSpan: '||1', field: 'org_sjcl_qty', hAlign: 2, width: 100, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  202. {title: '||其他错漏增减', colSpan: '||1', rowSpan: '||1', field: 'org_qtcl_qty', hAlign: 2, width: 100, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  203. {title: '||小计', colSpan: '||1', rowSpan: '||1', field: 'org_quantity', hAlign: 2, width: 60, type: 'Number', visible: <%- ctx.tender.info.display.ledger.clQty%>},
  204. ],
  205. extraCols: [
  206. {title: '计量数据|本期计量|合同', colSpan: '4|2|1', rowSpan: '1|1|1', field: 'contract_qty', hAlign: 2, width: 60, type: 'Number'},
  207. {title: '||数量变更', colSpan: '||1', rowSpan: '||1', field: 'qc_qty', hAlign: 2, width: 80, type: 'Number'},
  208. //{title: '||完成', colSpan: '||1', rowSpan: '||1', field: 'gather_qty', hAlign: 2, width: 60, type: 'Number'},
  209. {title: '|截止本期计量|合同', colSpan: '|2|1', rowSpan: '1|1', field: 'end_contract_qty', hAlign: 2, width: 60, type: 'Number'},
  210. {title: '||数量变更', colSpan: '||1', rowSpan: '||1', field: 'end_qc_qty', hAlign: 2, width: 80, type: 'Number'},
  211. //{title: '||完成', colSpan: '||1', rowSpan: '|1', field: 'end_gather_qty', hAlign: 2, width: 60, type: 'Number'},
  212. ],
  213. emptyRows: 3,
  214. headRows: 3,
  215. headRowHeight: [25, 25, 25],
  216. headColWidth: [30],
  217. defaultRowHeight: 21,
  218. headerFont: '12px 微软雅黑',
  219. font: '12px 微软雅黑',
  220. readOnly: true,
  221. }
  222. </script>