project_view.js 49 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058
  1. /**
  2. * Created by Mai on 2017/6/21.
  3. */
  4. var projectObj = {
  5. project: null,
  6. mainSpread: null,
  7. mainController: null,
  8. gljSpreed:null,
  9. beforeMainTreeSelectedChange: function (node) {
  10. /*if (node) {
  11. subViewObj.saveComments(node);
  12. }*/
  13. },
  14. treeSelectedChanged: function (node) {
  15. let project = projectObj.project;
  16. subViewObj.loadComments(node);
  17. gljOprObj.showDataIfRationSelect(node);
  18. // CSL.2017.07.25
  19. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  20. calcProgramObj.showData(node);
  21. };
  22. //zhong 2017-9-1 特征及内容
  23. if(pageCCOprObj.active){
  24. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  25. if(node.sourceType === project.Bills.getSourceType()){
  26. pageCCOprObj.setCacheAndShow(node);
  27. }
  28. else{
  29. pageCCOprObj.clearData();
  30. }
  31. }
  32. },
  33. refreshBaseActn: function (tree) {
  34. let setButtonValid = function (valid, btn) {
  35. if (valid) {
  36. btn.removeClass('disabled');
  37. } else {
  38. btn.addClass('disabled');
  39. }
  40. };
  41. let selected = tree.selected, that = projectObj;
  42. let canUpLevel = function (node) {
  43. if (selected && selected.depth() > 0 && selected.canUpLevel()) {
  44. if (selected.sourceType === that.project.Bills.getSourceType()) {
  45. return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0);
  46. } else {
  47. return false;
  48. }
  49. } else {
  50. return false;
  51. }
  52. };
  53. let canDownLevel = function (node) {
  54. if (selected && selected.depth() > 0 && selected.canDownLevel()) {
  55. if (selected.sourceType === that.project.Bills.getSourceType()) {
  56. return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0);
  57. } else {
  58. return false;
  59. }
  60. } else {
  61. return false;
  62. }
  63. };
  64. let canDelete = function (node) {
  65. if (selected) {
  66. if (selected.sourceType === that.project.Bills.getSourceType()) {
  67. if(selected.data.type == billType.DXFY&&selected.data.isAdd!=1){
  68. return false;
  69. }
  70. }
  71. return true;
  72. } else {
  73. return false;
  74. }
  75. };
  76. setButtonValid(canUpLevel(selected), $('#upLevel'));
  77. setButtonValid(canDownLevel(selected), $('#downLevel'));
  78. setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove'));
  79. setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove'));
  80. setButtonValid(canDelete(selected), $('#delete'));
  81. },
  82. checkCommonField: function (editingText, colSetting) {
  83. let value;
  84. if (colSetting.data.decimal) {
  85. value = Number(editingText);
  86. if (number_util.isNumber(value)) {
  87. if (colSetting.data.decimal) {
  88. value = value.toDecimal(colSetting.data.decimal);
  89. }
  90. } else {
  91. value = null;
  92. alert('当前输入的数据类型不正确,请重新输入。');
  93. }
  94. } else {
  95. value = editingText;
  96. }
  97. return value;
  98. },
  99. checkFormulaValidField: function (editingText, colSetting) {
  100. let value = Number(editingText);
  101. if (!value) {
  102. try {
  103. let exp = new Expression('');
  104. exp.Expression(editingText);
  105. value = Number(exp.Evaluate());
  106. } catch (error) {
  107. value = null;
  108. }
  109. }
  110. if (value!=undefined||value!=null) {
  111. if (colSetting.data.decimal) {
  112. value = value.toDecimal(colSetting.data.decimal);
  113. }
  114. } else if (editingText && editingText !== '') {
  115. value = null;
  116. alert('当前输入的数据类型不正确,请重新输入。');
  117. }
  118. return value;
  119. },
  120. checkSpreadEditingText: function (editingText, colSetting) {
  121. if (colSetting.data.field === 'quantity'||colSetting.data.field === 'contain') {
  122. return this.checkFormulaValidField(editingText, colSetting);
  123. }
  124. else if (colSetting.data.field === 'programID') {
  125. return this.project.calcProgram.compiledTemplateMaps[editingText];
  126. }
  127. else if (colSetting.data.field === 'subType') {
  128. if (typeof(editingText) !== "number")
  129. return volumePriceMaps[editingText]
  130. else
  131. return editingText;
  132. }
  133. else {
  134. return this.checkCommonField(editingText, colSetting);
  135. }
  136. },
  137. /*updateAndReCalculate: function (node, fieldName, value) {
  138. let project = projectObj.project, calc = new BillsCalcHelper(project), nodes = [];
  139. let getNodes = function (node) {
  140. let cur = node, nodes = [];
  141. while (cur) {
  142. nodes.push(cur);
  143. cur = cur.parent;
  144. }
  145. return nodes;
  146. }
  147. if (value) {
  148. value = value.toDecimal(projectObj.project.Decimal.common.quantity);
  149. }
  150. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  151. calcFees.setFee(node.data, fieldName, value);
  152. calc.calcNode(node, true);
  153. nodes = getNodes(node);
  154. project.Bills.updateNodes(nodes, true);
  155. }
  156. else if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) {
  157. project.beginUpdate('VolumePrice_QuantityChange');
  158. project.VolumePrice.updateField(node.source, fieldName, value, false);
  159. calc.calcNode(node.parent, true);
  160. nodes = getNodes(node.parent);
  161. project.Bills.updateNodes(nodes, false);
  162. project.endUpdate();
  163. nodes.push(node);
  164. }
  165. else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
  166. project.beginUpdate('Ration_QuantityChange');
  167. calcFees.setFee(node.data, fieldName, value);
  168. node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID);
  169. // calcProgram.calculate的传参必须是cacheNode类型,故无法将计算放在Ration模块中。
  170. project.calcProgram.calculate(node);
  171. project.Ration.updateRation(node.source, false); // 加入待存储队列
  172. calc.calcNode(node.parent, true); //
  173. nodes = getNodes(node.parent);
  174. project.Bills.updateNodes(nodes, false);
  175. project.endUpdate();
  176. nodes.push(node);
  177. }
  178. this.mainController.refreshTreeNode(nodes, false);
  179. calc = null;
  180. },*/
  181. updateBillsCode: function (node, value) {
  182. let project = projectObj.project;
  183. let stdMatchCode, formatCode, matchs;
  184. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  185. let orgCode = node.data.code.substr(0, 9);
  186. if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
  187. project.Bills.updateField(node.source, 'code', formatCode, true);
  188. projectObj.mainController.refreshTreeNode([node], false);
  189. } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
  190. let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
  191. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  192. if (data) {
  193. data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
  194. if (/\//.test(data.unit)) {
  195. ConfirmModal.stdBillsUnit.check(data, function (std) {
  196. project.Bills.replaceBills(node.source, std, formatCode);
  197. projectObj.mainController.refreshTreeNode([node], false);
  198. }, function () {
  199. projectObj.mainController.refreshTreeNode([node], false);
  200. });
  201. } else {
  202. project.Bills.replaceBills(node.source, data, formatCode);
  203. projectObj.mainController.refreshTreeNode([node], false);
  204. }
  205. } else {
  206. project.Bills.updateField(node.source, 'code', formatCode, true);
  207. projectObj.mainController.refreshTreeNode([node], false);
  208. }
  209. });
  210. }
  211. }
  212. if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
  213. stdMatchCode = value;
  214. formatCode = project.Bills.newFormatCode(stdMatchCode);
  215. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  216. } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
  217. stdMatchCode = value.substr(0, 9);
  218. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  219. if (matchs.indexOf(value) === -1) {
  220. searchStdBillsAndUpdate(stdMatchCode, value);
  221. } else if (confirm('已存在该编码的清单,是否继续?')) {
  222. formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  223. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  224. }
  225. } else {
  226. project.Bills.updateField(node.source, 'code', value, true);
  227. this.mainController.refreshTreeNode([node], false);
  228. }
  229. },
  230. updateRationCode: function (node, value) {
  231. if (/[\w]{2}[\d]{4}/.test(value)) {
  232. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  233. alert('当前项目无定额库,请添加定额库。');
  234. this.mainController.refreshTreeNode([node], false);
  235. } else {
  236. let libId = projectInfoObj.projectInfo.engineeringInfo.ration_lib[0].id;
  237. CommonAjax.postRationLib('/rationRepository/api/matchRation', {user_id: userID, rationLibId: libId, code: value}, function (data) {
  238. if (data) {
  239. projectObj.project.Ration.replaceRation(node.source, data);
  240. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  241. } else {
  242. alert('当前库中找不到定额"' + value + '"');
  243. }
  244. projectObj.mainController.refreshTreeNode([node], false);
  245. });
  246. }
  247. } else {
  248. alert('输入的定额编码有误,请检查。');
  249. this.mainController.refreshTreeNode([node], false);
  250. }
  251. },
  252. updateCode: function (node, value) {
  253. let project = projectObj.project;
  254. if (node.sourceType === project.Bills.getSourceType()) {
  255. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  256. } else if (node.sourceType === project.Ration.getSourceType()) {
  257. this.updateRationCode(node, value); // 新套定额适合实时计算
  258. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  259. /*project.calcProgram.calcAndSave(node);
  260. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  261. calcProgramObj.showData(node, false);
  262. };*/
  263. }
  264. },
  265. updateCellValue: function (node, value, colSetting) {
  266. let project = projectObj.project, fieldName = colSetting.data.field;
  267. if(node.sourceType==project.ration_glj.getSourceType()){
  268. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  269. }else if(treeNodeTools.isGljRation(node)){
  270. gljOprObj.updateRationTypeGLJ(value,node,fieldName);
  271. } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  272. if (fieldName === 'code' && !treeNodeTools.isVolumePrice(node)) {
  273. projectObj.updateCode(node, value);
  274. }
  275. else if(fieldName ==='feeRate'){
  276. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  277. }else if(fieldName ==='contain'){//编辑含量
  278. project.Ration.updateContain(value,node);
  279. }
  280. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
  281. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'feesIndex.common.unitFee'){
  282. if (fieldName === 'quantity') {
  283. project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName);
  284. return;
  285. }
  286. else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee') {
  287. if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
  288. }
  289. else if (fieldName === 'calcBase') {
  290. //zhong
  291. if(value === undefined ||value === null || value.toString().trim() === ''){
  292. value = '';
  293. }
  294. node.data.userCalcBase = value;
  295. project.calcBase.calculate(node);
  296. if(!project.calcBase.success){
  297. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  298. projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: '');
  299. return;
  300. }
  301. // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
  302. };
  303. node.changed = true;
  304. if (fieldName == 'feesIndex.common.unitFee'){
  305. treeNodeTools.initFeeField(node, 'common');
  306. node.data.feesIndex.common.unitFee = value;
  307. }
  308. else if(fieldName !== 'calcBase'){
  309. node.data[fieldName] = value;
  310. }
  311. project.calcProgram.calcAndSave(node);
  312. gljOprObj.showRationGLJSheetData();
  313. } else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
  314. node.data[fieldName] = value;
  315. node.changed = true;
  316. if(node.data.quantity){
  317. node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  318. }
  319. project.calcProgram.calcAndSave(node);
  320. }
  321. else {
  322. if (node.sourceType === project.Bills.getSourceType()) {
  323. project.Bills.updateField(node.source, fieldName, value, true);
  324. }
  325. else if (node.sourceType === project.Ration.getSourceType()) {
  326. project.Ration.updateField(node.source, fieldName, value, true);
  327. };
  328. if (colSetting.data.wordWrap) {
  329. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  330. }
  331. projectObj.mainController.refreshTreeNode([node]);
  332. }
  333. } else if(value==null && fieldName ==='feeRate'){
  334. project.FeeRate.cleanFeeRateID(node);
  335. } else {
  336. projectObj.mainController.refreshTreeNode([node], false);
  337. }
  338. },
  339. mainSpreadLeaveCell: function (sender, info) {
  340. let colSetting = projectObj.mainController.setting.cols[info.col];
  341. projectObj.lastCol = colSetting;
  342. },
  343. mainSpreadEnterCell: function (sender, info) {
  344. let colSetting = projectObj.mainController.setting.cols[info.col];
  345. if(colSetting.data.field === 'unit' || projectObj.lastCol.data.field === 'unit'||colSetting.data.field ==='subType'|| projectObj.lastCol.data.field === 'subType'){
  346. info.sheet.repaint();
  347. }
  348. },
  349. mainSpreadEditEnded: function (sender, info) {
  350. let project = projectObj.project;
  351. let node = project.mainTree.items[info.row];
  352. let colSetting = projectObj.mainController.setting.cols[info.col];
  353. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  354. // 检查输入类型等
  355. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  356. projectObj.updateCellValue(node, value, colSetting);
  357. // 自动行高
  358. const autoHeight = project.property.displaySetting.autoHeight;
  359. if (autoHeight) {
  360. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  361. }
  362. },
  363. mainSpreadRangeChanged: function (sender, info) {
  364. let project = projectObj.project, setting = projectObj.mainController.setting;
  365. if (info.changedCells.length > 0) {
  366. for (let changedCell of info.changedCells) {
  367. let cell = info.sheet.getCell(changedCell.row, changedCell.col);
  368. let node = project.mainTree.items[changedCell.row];
  369. let colSetting = setting.cols[changedCell.col];
  370. let value = projectObj.checkSpreadEditingText(cell.text(), colSetting);
  371. projectObj.updateCellValue(node, value, colSetting);
  372. }
  373. }
  374. },
  375. checkMainSpread: function () {
  376. if (!this.mainSpread) {
  377. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  378. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  379. }
  380. },
  381. refreshMainSpread: function () {
  382. if (this.mainSpread) {
  383. this.mainSpread.refresh();
  384. }
  385. },
  386. loadProjectData: function () {
  387. var that = this;
  388. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  389. let startTime = +new Date();
  390. console.log("开始加载-----"+startTime);
  391. this.project.loadDatas(function (err) {
  392. if (!err) {
  393. that.project.projectGLJ.calcQuantity();//计算分部分项和技术措施项目消耗量;
  394. that.project.property = projectInfoObj.projectInfo.property;
  395. //that.project.calcProgram.compileAllTemps();
  396. that.project.calcBase.init(that.project);
  397. that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
  398. // that.project.initCalcFields();
  399. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  400. that.project.projSetting.mainGridSetting = JSON.parse(str);
  401. that.project.projSetting.mainGridSetting.frozenCols = 4;
  402. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  403. const autoHeight = that.project.property.displaySetting !== undefined ?
  404. that.project.property.displaySetting.autoHeight : false;
  405. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  406. // for test. 后端没有绑定,暂时写死用于测试。
  407. /* if (col.data.field == '' && col.head.titleNames[0] == "取费专业") {
  408. col.data.field = 'programID';
  409. col.data.getText = 'getText.calcProgramName';
  410. col.data.cellType = 'cellType.calcProgramName';
  411. };*/
  412. col.data.splitFields = col.data.field.split('.');
  413. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  414. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  415. }
  416. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  417. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  418. }
  419. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  420. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  421. col.data.cellType = getCellType;
  422. }
  423. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  424. // col.data.decimal = that.project.getDecimal(col.data.digit);
  425. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  426. // }
  427. if (col.data.field === 'code') {
  428. col.data.formatter = '@';
  429. }
  430. // 根据配置设置自动行高
  431. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  432. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  433. if (!autoHeight) {
  434. col.showHint = true;
  435. col.data.wordWrap = false;
  436. } else {
  437. col.showHint = false;
  438. col.data.wordWrap = true;
  439. }
  440. }
  441. if(col.data.field ==='quantity'){
  442. col.showHint = true;
  443. }
  444. // for test digit. CSLAAAAA
  445. if (col.data.field.hasSubStr("totalFee"))
  446. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, false)
  447. else if (col.data.field.hasSubStr("unitFee"))
  448. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, false)
  449. else if (col.data.field == "quantity")
  450. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.quantity, false);
  451. });
  452. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  453. that.mainController.showTreeData();
  454. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  455. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  456. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  457. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  458. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  459. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  460. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  461. that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
  462. that.loadMainSpreadContextMenu();
  463. that.loadFocusLocation();
  464. let endTime = +new Date();
  465. console.log("加载完成-----"+endTime);
  466. }
  467. else {
  468. }
  469. });
  470. },
  471. loadMainSpreadContextMenu: function () {
  472. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  473. $.contextMenu({
  474. selector: '#billsSpread',
  475. build: function ($trigger, e) {
  476. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  477. controller.setTreeSelected(controller.tree.items[target.row]);
  478. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  479. },
  480. items: {
  481. "insertRootBill": {
  482. name: "插入大项费用",
  483. icon: 'fa-sign-in',
  484. disabled: function () {
  485. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  486. },
  487. callback: function (key, opt) {
  488. ProjectController.addRootBill(project, controller);
  489. cbTools.refreshFormulaNodes();
  490. },
  491. visible: function(key, opt){
  492. return project.mainTree.selected&&project.mainTree.selected.parent==null;
  493. }
  494. },
  495. "insertFB": {
  496. name: "插入分部",
  497. icon: 'fa-sign-in',
  498. disabled: function () {
  499. let selected = project.mainTree.selected;
  500. if(selected.sourceType==project.Bills.getSourceType()){
  501. if(selected.data.type==billType.FB){
  502. return false;
  503. }
  504. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  505. if(selected.children.length>0){
  506. return selected.children[0].data.type==billType.FX;//焦点行是分部分项工程,且子项是分项
  507. }else {
  508. return false
  509. }
  510. }
  511. }
  512. return true;//除了清单,其它类型都只读
  513. },
  514. callback: function (key, opt) {
  515. ProjectController.addFB(project, controller);
  516. cbTools.refreshFormulaNodes();
  517. },
  518. visible: function(key, opt){
  519. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  520. }
  521. },
  522. "insertFX": {
  523. name: "插入分项",
  524. icon: 'fa-sign-in',
  525. disabled: function () {
  526. let selected = project.mainTree.selected;
  527. if(selected.sourceType==project.Bills.getSourceType()){
  528. if(selected.data.type==billType.FX){//焦点行是分项,有效显示
  529. return false
  530. }
  531. if(selected.data.type==billType.FB){//点行是分部,
  532. if(selected.children.length>0){//且有子项,子项是分部,灰显。
  533. return selected.children[0].data.type == billType.FB
  534. }else {
  535. return false;
  536. }
  537. }
  538. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  539. if(selected.children.length>0){
  540. return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
  541. }else {
  542. return false
  543. }
  544. }
  545. }
  546. return true;//除了清单,其它类型都只读
  547. },
  548. callback: function (key, opt) {
  549. ProjectController.addFX(project, controller);
  550. cbTools.refreshFormulaNodes();
  551. },
  552. visible: function(key, opt){
  553. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  554. }
  555. },
  556. "insertBills": {
  557. name: "插入清单",
  558. icon: 'fa-sign-in',
  559. disabled: function () {
  560. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  561. },
  562. callback: function (key, opt) {
  563. if(project.mainTree.selected.data.type == billType.DXFY){
  564. if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
  565. alert("当前有基数计算不能插入子项。");
  566. return;
  567. }
  568. }
  569. ProjectController.addBills(project, controller);
  570. cbTools.refreshFormulaNodes();
  571. },
  572. visible: function(key, opt){
  573. return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;//不属于分部分项的话隐藏
  574. }
  575. },
  576. "insertRation": {
  577. name: "插入定额",
  578. icon: 'fa-sign-in',
  579. disabled: function () {
  580. var selected = project.mainTree.selected;
  581. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  582. },
  583. callback: function (key, opt) {
  584. ProjectController.addRation(project, controller, rationType.ration);
  585. cbTools.refreshFormulaNodes();
  586. },
  587. visible: function(key, opt){
  588. var selected = project.mainTree.selected;
  589. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  590. return false
  591. }else {
  592. return true
  593. }
  594. }
  595. },
  596. "insertLJ": {
  597. name: "插入量价",
  598. icon: 'fa-sign-in',
  599. disabled: function () {
  600. var selected = project.mainTree.selected;
  601. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  602. },
  603. callback: function (key, opt) {
  604. ProjectController.addRation(project, controller, rationType.volumePrice);
  605. cbTools.refreshFormulaNodes();
  606. },
  607. visible: function(key, opt){
  608. var selected = project.mainTree.selected;
  609. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  610. return false
  611. }else {
  612. return true
  613. }
  614. }
  615. },
  616. "insertGLJ": {
  617. name: "插入工料机",
  618. icon: 'fa-sign-in',
  619. disabled: function () {
  620. var selected = project.mainTree.selected;
  621. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  622. },
  623. callback: function (key, opt) {
  624. var selected = project.mainTree.selected;
  625. if(selected.sourceType == ModuleNames.bills){
  626. if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
  627. if(selected.data.calcBase&&selected.data.calcBase!=""){
  628. alert("当前有基数计算不能插入子项。");
  629. return;
  630. }
  631. }
  632. }
  633. getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
  634. cbTools.refreshFormulaNodes();
  635. },
  636. visible: function(key, opt){
  637. var selected = project.mainTree.selected;
  638. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  639. return false
  640. }else {
  641. return true
  642. }
  643. }
  644. },
  645. "spr1": '--------',
  646. "delete": {
  647. name: '删除',
  648. icon: 'fa-remove',
  649. disabled: function () {
  650. var selected = project.mainTree.selected;
  651. return !selected;
  652. },
  653. callback: function () {
  654. var selected = controller.tree.selected, parent = selected.parent;
  655. if (selected) {
  656. if (selected.sourceType === project.Bills.getSourceType()) {
  657. if (cbTools.isUsedByFormula(selected)){
  658. alert('该清单行被其它公式结点引用,不允许删除!');
  659. return;
  660. };
  661. project.Bills.deleteBills(selected.source);
  662. controller.delete();
  663. } else if (selected.sourceType === project.Ration.getSourceType()) {
  664. project.Ration.delete(selected.source);
  665. controller.delete();
  666. };
  667. projectObj.converseCalculateBills(parent);
  668. cbTools.refreshFormulaNodes();
  669. }
  670. }
  671. },
  672. "spr2":'--------',
  673. "calculateAll_RationContent": {
  674. name: '造价计算',
  675. callback: function () {
  676. $.bootstrapLoading.start();
  677. let changedNodes = project.calcProgram.calcAllNodes();
  678. project.calcProgram.saveNodes(changedNodes);
  679. $.bootstrapLoading.end();
  680. }
  681. }
  682. }
  683. });
  684. },
  685. // 计算node及node的所有父项
  686. converseCalculateBills: function (node) {
  687. /* if (node) {
  688. let calc = new BillsCalcHelper(this.project);
  689. calc.calcNode(node, true);
  690. let cur = node, nodes = [];
  691. while (cur) {
  692. nodes.push(cur);
  693. cur = cur.parent;
  694. }
  695. this.mainController.refreshTreeNode(nodes, false);
  696. this.project.Bills.updateNodes(nodes, true);
  697. calc = null;
  698. }*/
  699. projectObj.project.calcProgram.calcAndSave(node);
  700. },
  701. // 计算全部清单
  702. /* calculateAll: function () {
  703. let calc = new BillsCalcHelper(this.project);
  704. calc.calcAll();
  705. this.mainController.showTreeData();
  706. this.project.Bills.updateAll();
  707. calc = null;
  708. }*/
  709. // 获取上次退出时的焦点位置
  710. loadFocusLocation: function() {
  711. const projectId = scUrlUtil.GetQueryString('project');
  712. let row = getLocalCache('lastRow:' + projectId);
  713. let col = getLocalCache('lastCol:' + projectId);
  714. if (row !== null && col !== null) {
  715. row = parseInt(row);
  716. col = parseInt(col);
  717. const sheet = this.mainSpread.getActiveSheet();
  718. sheet.setSelection(row, col, 1, 1);
  719. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  720. }
  721. },
  722. // 选中区域合计数字
  723. amountAreaNumber: function(e, info) {
  724. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  725. return false;
  726. }
  727. const selectedArea = info.newSelections[0];
  728. const sheet = info.sheet;
  729. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  730. return false;
  731. }
  732. // 获取鼠标位置
  733. let x = window.event.clientX;
  734. let y = window.event.clientY;
  735. // 匹配数字或小数
  736. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  737. // 小数点最高位数
  738. let max = 0;
  739. let total = 0;
  740. let counter = 0;
  741. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  742. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  743. const value = sheet.getCell(row, col).text();
  744. if (!regular.test(value)) {
  745. continue;
  746. }
  747. counter++;
  748. // 获取当前数据小数位数
  749. let pointPosition = value.toString().indexOf(".");
  750. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  751. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  752. max = current > max ? current : max;
  753. total += parseFloat(value);
  754. }
  755. }
  756. // 如果不为0则悬浮显示
  757. if (total > 0 && counter > 1) {
  758. const div = $('<div id="total-tips"><p>合计: <input type="text" id="total" readonly="readonly" style="border: none;"/></p><p><a href="javascript:void(0);">复制</a></p></div>');
  759. div.css({
  760. position: "absolute",
  761. border: "1px #C0C0C0 solid",
  762. background: "#fff",
  763. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  764. });
  765. div.children("p").css({
  766. textAlign: "center",
  767. padding: 8,
  768. marginBottom: 2,
  769. });
  770. div.children("p").first().css({
  771. borderBottom: "1px #C0C0C0 solid"
  772. });
  773. const totalString = total.toFixed(max);
  774. // input长度
  775. const inputWidth = totalString.length * 8;
  776. // 计算是否会超出显示范围
  777. const baseWidth = 48;
  778. const baseHeight = 81;
  779. const canvasWidth = $("#billsSpreadvp_vp").width();
  780. const canvasHeight = $("#billsSpreadvp_vp").height();
  781. x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  782. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  783. div.css({
  784. left: x,
  785. top: y,
  786. });
  787. div.children().children("#total").width(inputWidth).val(totalString);
  788. $("body").append(div);
  789. // 用于判断是否要关闭窗体
  790. setTimeout(function() {
  791. isTotalShowing = true;
  792. }, 200);
  793. };
  794. }
  795. };
  796. // 点击合计框中的复制
  797. $("body").on("click", "#total-tips a", function() {
  798. const totalElement = $(this).parent().siblings("p").find("#total");
  799. totalElement.select();
  800. document.execCommand("Copy");
  801. $(this).text("已复制");
  802. });
  803. // 合计框点击其他位置关闭
  804. let isTotalShowing = false;
  805. $("body").on("click", function(e) {
  806. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  807. $("#total-tips").remove();
  808. isTotalShowing = false;
  809. }
  810. });
  811. $('#insert').click(function () {
  812. var controller = projectObj.mainController, project = projectObj.project;
  813. var selected = controller.tree.selected;
  814. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  815. ProjectController.addBills(project, controller);
  816. } else if (selected.sourceType === project.Ration.getSourceType()) {
  817. ProjectController.addRation(project, controller, selected.data.type);
  818. };
  819. cbTools.refreshFormulaNodes();
  820. });
  821. $('#delete').click(function () {
  822. var controller = projectObj.mainController, project = projectObj.project;
  823. var selected = controller.tree.selected, parent = selected.parent;
  824. if (selected) {
  825. if (selected.sourceType === project.Bills.getSourceType()) {
  826. if (cbTools.isUsedByFormula(selected)){
  827. alert('该清单行被其它公式结点引用,不允许删除!');
  828. return;
  829. };
  830. project.Bills.deleteBills(selected.source);
  831. controller.delete();
  832. } else if (selected.sourceType === project.Ration.getSourceType()) {
  833. project.Ration.delete(selected.source);
  834. controller.delete();
  835. }else if(selected.sourceType==ModuleNames.ration_glj){
  836. project.ration_glj.updataOrdelete(selected.source);
  837. };
  838. if(parent){
  839. projectObj.converseCalculateBills(parent);
  840. }
  841. };
  842. cbTools.refreshFormulaNodes();
  843. });
  844. $('#upLevel').click(function () {
  845. var controller = projectObj.mainController, project = projectObj.project;
  846. var selected = controller.tree.selected, orgParent = selected.parent;
  847. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  848. project.Bills.upLevelBills(selected.source);
  849. controller.upLevel();
  850. projectObj.converseCalculateBills(orgParent);
  851. }
  852. });
  853. $('#downLevel').click(function () {
  854. var controller = projectObj.mainController, project = projectObj.project;
  855. var selected = controller.tree.selected;
  856. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  857. project.Bills.downLevelBills(selected.source);
  858. controller.downLevel();
  859. projectObj.converseCalculateBills(selected.parent);
  860. }
  861. });
  862. $('#upMove').click(function () {
  863. var controller = projectObj.mainController, project = projectObj.project;
  864. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  865. if (selected.sourceType === project.Bills.getSourceType()) {
  866. project.Bills.upMoveBills(selected.source);
  867. controller.upMove();
  868. } else if (selected.sourceType === project.Ration.getSourceType()) {
  869. project.Ration.changePos(selected.source, selected.preSibling.source);
  870. controller.upMove();
  871. };
  872. });
  873. $('#downMove').click(function () {
  874. var controller = projectObj.mainController, project = projectObj.project;
  875. var selected = controller.tree.selected, next, nextSerialNo;
  876. if (selected) {
  877. if (selected.sourceType === project.Bills.getSourceType()) {
  878. project.Bills.downMoveBills(selected.source);
  879. controller.downMove();
  880. } else if (selected.sourceType === project.Ration.getSourceType()) {
  881. project.Ration.changePos(selected.source, selected.nextSibling.source);
  882. controller.downMove();
  883. };
  884. }
  885. });
  886. $('#poj-set').on('show.bs.modal', function () {
  887. let setCalcFlag = function (obj, val, curFlag) {
  888. obj.val(val);
  889. if (val === curFlag) {
  890. obj.attr('checked', true);
  891. } else {
  892. obj.removeAttr('checked');
  893. }
  894. }
  895. if (projectObj.project) {
  896. // let mode = projectObj.project.projSetting.billsCalcMode;
  897. // let settingConst = projectObj.project.projSetting.settingConst;
  898. let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
  899. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  900. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  901. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  902. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  903. // mode = projectObj.project.projSetting.zanguCalcType;
  904. let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  905. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  906. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  907. }
  908. });
  909. $('#property_ok').click(function () {
  910. let project = projectObj.project,
  911. projectID = project.ID(),
  912. properties = {},
  913. labourCoes = {},
  914. rations = [],
  915. bills = [],
  916. mixDatas = {
  917. projectID: projectID,
  918. updateType: 'update',
  919. properties: properties,
  920. labourCoes: labourCoes,
  921. rations: rations,
  922. bills: bills
  923. },
  924. reCalcBills= false,
  925. reCalcRations= false;
  926. let b = parseInt($("input[name='calcFlag']:checked").val());
  927. if (b !== project.property.billsCalcMode) {
  928. properties['property.billsCalcMode'] = b;
  929. project.property.billsCalcMode = b;
  930. reCalcBills = true;
  931. };
  932. let zg = parseInt($("input[name='zangu']:checked").val());
  933. if (zg !== project.property.zanguCalcMode) {
  934. properties['property.zanguCalcMode'] = zg;
  935. project.property.zanguCalcMode = zg;
  936. reCalcBills = true;
  937. };
  938. //基本信息
  939. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  940. properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
  941. }
  942. //工程特征
  943. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  944. properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
  945. }
  946. //清单工程量精度
  947. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  948. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  949. billsQuanDecimal.datas = newBillsDecimalDatas;
  950. reCalcBills = true;
  951. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  952. }
  953. //小数位数
  954. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  955. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  956. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  957. setDecimal(decimalObj, updateDecimal);
  958. if (frChanged) {
  959. project.calcProgram.compileAllTemps()
  960. }
  961. reCalcRations = true;
  962. reCalcBills = true;
  963. properties['property.decimal'] = updateDecimal;
  964. }
  965. // 呈现选项
  966. projDisplayView.updateChecking(properties);
  967. if(calcOptions.updateChecking(properties)){
  968. reCalcRations = true;
  969. }
  970. // 人工系数
  971. if (labourCoeView.needSave()){
  972. let libID = $("#std_labour_coe_files").children("option:selected").val();
  973. let libName = $("#std_labour_coe_files").children("option:selected").text();
  974. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  975. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  976. project.calcProgram.compileAllTemps();
  977. reCalcRations = true;
  978. reCalcBills = true;
  979. };
  980. // 重新计算树节点
  981. let changedNodes = [];
  982. if (reCalcRations) // 定额动,全部计算。
  983. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  984. else if (reCalcBills) // 清单动,可以只计算清单。
  985. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  986. if (changedNodes.length > 0) {
  987. for (let node of changedNodes){
  988. let data = {
  989. // projectID: projectID,
  990. ID: node.data.ID,
  991. quantity: node.data.quantity,
  992. calcBase: node.data.calcBase,
  993. calcBaseValue: node.data.calcBaseValue,
  994. marketUnitFee: node.data.marketUnitFee,
  995. marketTotalFee: node.data.marketTotalFee,
  996. fees: node.data.fees,
  997. feeRate: node.data.feeRate,
  998. feeRateID: node.data.feeRateID
  999. };
  1000. if (node.sourceType == 'ration'){
  1001. rations.push(data);
  1002. }
  1003. else if (node.sourceType == 'bills'){
  1004. bills.push(data);
  1005. };
  1006. };
  1007. };
  1008. // for test.
  1009. /* console.log(mixDatas);
  1010. return; */
  1011. function hasMixData() {
  1012. return Object.keys(mixDatas.properties).length > 0 ||
  1013. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  1014. }
  1015. if(hasMixData()){
  1016. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  1017. /* if (changedNodes.length > 0) {
  1018. for (let node of changedNodes){delete node.changed};
  1019. };
  1020. if (mixDatas.labourCoes.updateData) labourCoeView.refresh();*/
  1021. window.location.href = '/main?project=' + projectID;
  1022. });
  1023. }
  1024. });