spread.js 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date 2018/5/31
  7. * @version
  8. */
  9. const tzWithoutCols = ['deal_qty', 'deal_tp'];
  10. const dgnCols = ['dgn_qty1', 'dgn_qty2', 'dgn_price'];
  11. const ledgerSpread = {
  12. cols: [
  13. {title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'},
  14. {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
  15. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@'},
  16. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
  17. {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 60, type: 'Number'},
  18. {title: '设计数量|数量1', colSpan: '2|1', rowSpan: '1|1', field: 'dgn_qty1', hAlign: 2, width: 60, type: 'Number'},
  19. {title: '|数量2', colSpan: '|1', rowSpan: '|1', field: 'dgn_qty2', hAlign: 2, width: 60, type: 'Number'},
  20. {title: '经济指标', colSpan: '1', rowSpan: '2', field: 'dgn_price', hAlign: 2, width: 60, type: 'Number'},
  21. {title: '签约|数量', colSpan: '2|1', rowSpan: '1|1', field: 'deal_qty', hAlign: 2, width: 60, type: 'Number'},
  22. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'deal_tp', hAlign: 2, width: 60, type: 'Number'},
  23. {title: '施工图复核|数量', colSpan: '2|1', rowSpan: '1|1', field: 'quantity', hAlign: 2, width: 60, type: 'Number'},
  24. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'total_price', hAlign: 2, width: 60, type: 'Number'},
  25. {title: '图(册)号', colSpan: '1', rowSpan: '2', field: 'drawing_code', hAlign: 0, width: 80, formatter: '@'},
  26. {title: '备注', colSpan: '1', rowSpan: '2', field: 'memo', hAlign: 0, width: 100, formatter: '@'}
  27. ],
  28. emptyRows: 3,
  29. headRows: 2,
  30. headRowHeight: [40, 40],
  31. defaultRowHeight: 21,
  32. };
  33. const ledgerPosSpread = {
  34. cols: [
  35. {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 230, formatter: '@'},
  36. {title: '数量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 60, type: 'Number'},
  37. {title: '图册号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 80, formatter: '@'},
  38. ],
  39. emptyRows: 3,
  40. headRows: 1,
  41. headRowHeight: [40],
  42. defaultRowHeight: 21,
  43. };
  44. const measureSpread = {
  45. cols: [
  46. {title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 150, formatter: '@', readOnly: true, cellType: 'tree'},
  47. {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
  48. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  49. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: true},
  50. {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 60, readOnly: true, type: 'Number'},
  51. {title: '0号台账合同|数量', colSpan: '2|1', rowSpan: '1|1', field: 'quantity', hAlign: 2, width: 60, readOnly: true, type: 'Number'},
  52. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'total_price', hAlign: 2, width: 60, readOnly: true, type: 'Number'},
  53. {title: '本期合同计量|数量', colSpan: '2|1', rowSpan: '1|1', field: 'deal_quantity', hAlign: 2, width: 60, type: 'Number'},
  54. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'deal_totalprice', hAlign: 2, width: 60, type: 'Number'},
  55. {title: '本期数量变更|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qc_quantity', hAlign: 2, width: 60, type: 'Number'},
  56. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'qc_totalprice', hAlign: 2, width: 60, type: 'Number'},
  57. {title: '本期完成计量|数量', colSpan: '2|1', rowSpan: '1|1', field: 'gather_quantity', hAlign: 2, width: 60, readOnly: true, type: 'Number'},
  58. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'gather_totalprice', hAlign: 2, width: 60, readOnly: true, type: 'Number'},
  59. {title: '图(册)号', colSpan: '1', rowSpan: '2', field: 'drawing_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
  60. {title: '备注', colSpan: '1', rowSpan: '2', field: 'memo', hAlign: 0, width: 100, formatter: '@', readOnly: true},
  61. ],
  62. emptyRows: 3,
  63. headRows: 2,
  64. headRowHeight: [40, 40],
  65. defaultRowHeight: 21,
  66. };
  67. const measurePosSpread = {
  68. cols: [
  69. {title: '部位名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@', readOnly: true},
  70. {title: '复核数量', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  71. {title: '本期|合同计量', colSpan: '4|1', rowSpan: '1|1', field: 'deal_quantity', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  72. {title: '|数量变更计量', colSpan: '|1', rowSpan: '|1', field: 'qc_quantity', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  73. {title: '|变更令', colSpan: '|1', rowSpan: '|1', field: 'qc_bgl', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  74. {title: '|完成计量', colSpan: '|1', rowSpan: '|1', field: 'gather_quantity', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  75. {title: '截止|合同计量', colSpan: '4|1', rowSpan: '1|1', field: 'b_code', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  76. {title: '|数量变更计量', colSpan: '|1', rowSpan: '|1', field: 'b_code', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  77. {title: '|变更令', colSpan: '|1', rowSpan: '|1', field: 'b_code', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  78. {title: '|完成计量', colSpan: '|1', rowSpan: '|1', field: 'b_code', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  79. {title: '本期批注', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
  80. {title: '图册号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
  81. ],
  82. emptyRows: 3,
  83. headRows: 2,
  84. headRowHeight: [40, 40],
  85. defaultRowHeight: 21,
  86. };
  87. module.exports = {
  88. ledgerSpread,
  89. ledgerPosSpread,
  90. measureSpread,
  91. measurePosSpread,
  92. filterCols: {
  93. tzWithoutCols,
  94. dgnCols,
  95. }
  96. };