main_tree_col.js 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. /**
  2. * Created by Mai on 2017/7/25.
  3. */
  4. let MainTreeCol = {
  5. getText: {
  6. type: function (node) {
  7. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  8. return '';
  9. } else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
  10. return '定';
  11. } else if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) {
  12. if (node.data.type === '人工') return '量人'
  13. else if (node.data.type === '材料') return '量材'
  14. else if (node.data.type === '机械') return '量机'
  15. else if (node.data.type === '主材') return '量主'
  16. else if (node.data.type === '设备') return '量设';
  17. } else if (node.sourceType === projectObj.project.ration_glj.getSourceType()) {
  18. return '主';
  19. }
  20. },
  21. // CSL, 2017-11-28
  22. calcProgramName: function (node) {
  23. let programID = node.data.programID;
  24. if (!programID) return
  25. else return projectObj.project.calcProgram.compiledTemplateMaps[programID];
  26. }
  27. },
  28. readOnly: {
  29. type: function (node){
  30. return node.sourceType !== projectObj.project.VolumePrice.getSourceType();
  31. },
  32. // CSL, 2017-11-28
  33. calcProgramName: function (node) {
  34. if (
  35. node.sourceType === projectObj.project.VolumePrice.getSourceType() ||
  36. node.sourceType === projectObj.project.Ration.getSourceType() ||
  37. (node.sourceType === projectObj.project.Bills.getSourceType() && node.source.children && node.source.children.length === 0 && projectObj.project.projSetting.billsCalcMode === billsPrice)
  38. ) return false
  39. else return true;
  40. },
  41. bills: function (node) {
  42. return node.sourceType === projectObj.project.Bills.getSourceType();
  43. },
  44. ration: function (node) {
  45. return node.sourceType === projectObj.project.Ration.getSourceType();
  46. },
  47. volumePrice: function (node) {
  48. return node.sourceType === projectObj.project.VolumePrice.getSourceType();
  49. },
  50. non_bills: function (node) {
  51. return node.sourceType !== projectObj.project.Bills.getSourceType();
  52. },
  53. non_ration: function (node) {
  54. return node.sourceType !== projectObj.project.Ration.getSourceType();
  55. },
  56. non_volumePrice: function (node) {
  57. return node.sourceType !== projectObj.project.Ration.getSourceType();
  58. },
  59. billsParent: function (node) {
  60. return node.sourceType === projectObj.project.Bills.getSourceType() && node.source.children.length > 0;
  61. },
  62. leafBillsWithDetail: function (node) {
  63. return (!MainTreeCol.readOnly.billsParent(node)) && (node.children.length > 0);
  64. },
  65. forCalcBase: function (node) {
  66. // to do according to billsParentType
  67. return MainTreeCol.readOnly.billsParent(node) || MainTreeCol.readOnly.non_bills(node)||MainTreeCol.readOnly.leafBillsWithDetail(node);
  68. },
  69. forUnitFee: function (node) {
  70. return MainTreeCol.readOnly.ration(node) || MainTreeCol.readOnly.billsParent(node) || MainTreeCol.readOnly.leafBillsWithDetail(node);
  71. },
  72. forTotalFee: function (node) {
  73. return MainTreeCol.readOnly.non_bills(node) || MainTreeCol.readOnly.billsParent(node) || (MainTreeCol.readOnly.leafBillsWithDetail(node));
  74. },
  75. forQuantifyDetail:function (node) {
  76. return !(node.sourceType==ModuleNames.ration||!MainTreeCol.readOnly.billsParent(node));
  77. }
  78. },
  79. cellType: {
  80. unit: function () {
  81. let combo = new GC.Spread.Sheets.CellTypes.ComboBox();
  82. combo.itemHeight(10).items(['m', 'm2', 'm3', 'km', 't', 'kg', '台班', '工日', '昼夜', '元', '项', '处', '个', '件',
  83. '根', '组', '系统', '台', '套', '株', '丛', '缸', '支', '只', '块', '座', '对', '份', '樘', '攒', '榀']);
  84. return combo;
  85. },
  86. units: function () {
  87. this.unit;
  88. },
  89. feeRate: function () {
  90. return feeRateObject.getFeeRateEditCellType();
  91. },
  92. // CSL, 2017-11-28
  93. calcProgramName: function (node) {
  94. if (
  95. node.sourceType === projectObj.project.VolumePrice.getSourceType() ||
  96. node.sourceType === projectObj.project.Ration.getSourceType() ||
  97. (node.sourceType === projectObj.project.Bills.getSourceType() && node.source.children && node.source.children.length === 0 && projectObj.project.projSetting.billsCalcMode === billsPrice)
  98. ) {
  99. var names = new GC.Spread.Sheets.CellTypes.ComboBox();
  100. names.items(projectObj.project.calcProgram.compiledTemplateNames);
  101. return names;
  102. }
  103. },
  104. // CSL, 2017-11-28
  105. type: function (node) {
  106. if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) {
  107. let VPType = new GC.Spread.Sheets.CellTypes.ComboBox();
  108. VPType.items(["人工","材料","机械","主材","设备"]);
  109. return VPType;
  110. };
  111. }
  112. },
  113. getEvent: function (eventName) {
  114. let names = eventName.split('.');
  115. let event = this;
  116. for (let name of names) {
  117. if (event[name]) {
  118. event = event[name];
  119. } else {
  120. return null;
  121. }
  122. }
  123. if (event && Object.prototype.toString.apply(event) !== "[object Function]") {
  124. return null;
  125. } else {
  126. return event;
  127. }
  128. },
  129. getNumberFormatter: function (digit) {
  130. switch (digit) {
  131. case 1:
  132. return '0.#';
  133. case 2:
  134. return '0.##';
  135. case 3:
  136. return '0.###';
  137. case 4:
  138. return '0.####';
  139. case 5:
  140. return '0.#####';
  141. case 6:
  142. return '0.######';
  143. default:
  144. return '0.##';
  145. }
  146. }
  147. };
  148. let colSettingObj = {
  149. settingSpread: null,
  150. checkBox: new GC.Spread.Sheets.CellTypes.CheckBox(),
  151. loadSetting: function (sheet, setting) {
  152. sheet.setRowCount(setting.cols.length);
  153. sheet.setColumnCount(setting.headRows, GC.Spread.Sheets.SheetArea.rowHeader);
  154. sheet.setColumnCount(1);
  155. sheet.getRange(-1, 0, -1, 1).cellType(this.checkBox).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
  156. sheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.colHeader).value('显示');
  157. sheet.setColumnWidth(0, 300);
  158. setting.cols.forEach(function (col, index) {
  159. let i, iCol = 0, cell;
  160. for (i = 0; i < col.head.spanCols.length; i++) {
  161. if (col.head.spanCols[i] !== 0) {
  162. cell = sheet.getCell(index, iCol, GC.Spread.Sheets.SheetArea.rowHeader);
  163. cell.value(col.head.titleNames[i]).font(col.head.font).hAlign(col.head.hAlign[i]).vAlign(col.head.vAlign[i]);
  164. }
  165. if (col.head.spanCols[i] > 1 || col.head.spanRows[i] > 1) {
  166. sheet.addSpan(index, iCol, col.head.spanRows[i], col.head.spanCols[i], GC.Spread.Sheets.SheetArea.rowHeader);
  167. }
  168. iCol += col.head.spanRows[i];
  169. };
  170. let colWidth = sheet.getColumnWidth(index, GC.Spread.Sheets.SheetArea.rowHeader);
  171. colWidth = colWidth > col.width ? colWidth : col.width;
  172. sheet.setColumnWidth(index, colWidth, GC.Spread.Sheets.SheetArea.rowHeader);
  173. cell = sheet.getCell(index, 0).value(col.visible);
  174. sheet.autoFitRow(index);
  175. });
  176. },
  177. initSettingSpread: function () {
  178. this.settingSpread = SheetDataHelper.createNewSpread($('#col_setting_spread')[0], {sheetCount: 1});
  179. this.settingSpread.options.showScrollTip = GC.Spread.Sheets.ShowScrollTip.vertical;
  180. this.loadSetting(this.settingSpread.getActiveSheet(), projectObj.project.projSetting.main_tree_col);
  181. }
  182. };
  183. $('#column').on('shown.bs.modal', function () {
  184. if (!colSettingObj.settingSpread) {
  185. colSettingObj.initSettingSpread();
  186. }
  187. });
  188. $('#column').on('hide.bs.modal', function () {
  189. let sheet = colSettingObj.settingSpread.getActiveSheet();
  190. for (let iRow = 0; iRow < sheet.getRowCount(); iRow++) {
  191. projectObj.project.projSetting.main_tree_col.cols[iRow].visible = sheet.getValue(iRow, 0);
  192. projectObj.project.projSetting.mainGridSetting.cols[iRow].visible = sheet.getValue(iRow, 0);
  193. }
  194. SheetDataHelper.refreshColumnVisible(projectObj.project.projSetting.mainGridSetting, projectObj.mainSpread.getActiveSheet());
  195. projectObj.project.pushNow('editColSetting', projectObj.project.projSetting.moduleName, {projectID: projectObj.project.ID(), main_tree_col: projectObj.project.projSetting.main_tree_col});
  196. });