project_view.js 49 KB

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