project_view.js 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540
  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 (SubActiveSheetNameIs('JSCX')) {
  20. if (node.sourceType === project.Bills.getSourceType() || node.sourceType === project.Ration.getSourceType()) {
  21. calcProgramObj.showData(node);
  22. } else {
  23. calcProgramObj.clearData();
  24. };
  25. };
  26. //zhong 2017-9-1 特征及内容
  27. if(pageCCOprObj.active){
  28. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  29. if(node.sourceType === project.Bills.getSourceType()){
  30. pageCCOprObj.setCacheAndShow(node);
  31. }
  32. else{
  33. pageCCOprObj.clearData();
  34. }
  35. }
  36. },
  37. refreshBaseActn: function (tree) {
  38. let setButtonValid = function (valid, btn) {
  39. if (valid) {
  40. btn.removeClass('disabled');
  41. } else {
  42. btn.addClass('disabled');
  43. }
  44. };
  45. let selected = tree.selected, that = projectObj;
  46. let canUpLevel = function (node) {
  47. if (selected && selected.depth() > 0 && selected.canUpLevel()) {
  48. if (selected.sourceType === that.project.Bills.getSourceType()) {
  49. return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0);
  50. } else {
  51. return false;
  52. }
  53. } else {
  54. return false;
  55. }
  56. };
  57. let canDownLevel = function (node) {
  58. if (selected && selected.depth() > 0 && selected.canDownLevel()) {
  59. if (selected.sourceType === that.project.Bills.getSourceType()) {
  60. return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0);
  61. } else {
  62. return false;
  63. }
  64. } else {
  65. return false;
  66. }
  67. };
  68. let canDelete = function (node) {
  69. if (selected) {
  70. if (selected.sourceType === that.project.Bills.getSourceType()) {
  71. return !(selected.data.flagsIndex && selected.data.flagsIndex.fixed && selected.data.flagsIndex.fixed.flag > 0);
  72. } else {
  73. return true;
  74. }
  75. } else {
  76. return false;
  77. }
  78. };
  79. setButtonValid(canUpLevel(selected), $('#upLevel'));
  80. setButtonValid(canDownLevel(selected), $('#downLevel'));
  81. setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove'));
  82. setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove'));
  83. setButtonValid(canDelete(selected), $('#delete'));
  84. },
  85. checkCommonField: function (editingText, colSetting) {
  86. let value;
  87. if (colSetting.data.decimal) {
  88. value = Number(editingText);
  89. if (number_util.isNumber(value)) {
  90. value = value.toDecimal(colSetting.data.decimal);
  91. } else {
  92. value = null;
  93. alert('当前输入的数据类型不正确,请重新输入。');
  94. }
  95. } else {
  96. value = editingText;
  97. }
  98. return value;
  99. },
  100. checkFormulaValidField: function (editingText, colSetting) {
  101. let value = Number(editingText);
  102. if (!value) {
  103. try {
  104. let exp = new Expression('');
  105. exp.Expression(editingText);
  106. value = Number(exp.Evaluate());
  107. } catch (error) {
  108. value = null;
  109. }
  110. }
  111. if (value) {
  112. value = value.toDecimal(colSetting.data.decimal);
  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 === 'feesIndex.common.unitFee') {
  121. return this.checkFormulaValidField(editingText, colSetting);
  122. } else {
  123. return this.checkCommonField(editingText, colSetting);
  124. }
  125. },
  126. updateAndReCalculate: function (node, fieldName, value) {
  127. let project = projectObj.project, calc = new BillsCalcHelper(project), nodes = [];
  128. let getNodes = function (node) {
  129. let cur = node, nodes = [];
  130. while (cur) {
  131. nodes.push(cur);
  132. cur = cur.parent;
  133. }
  134. return nodes;
  135. }
  136. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  137. calcFees.setFee(node.data, fieldName, value);
  138. calc.calcNode(node, true);
  139. nodes = getNodes(node);
  140. project.Bills.updateNodes(nodes, true);
  141. } else if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) {
  142. project.beginUpdate('VolumePrice_QuantityChange');
  143. project.VolumePrice.updateField(node.source, fieldName, value, false);
  144. calc.calcNode(node.parent, true);
  145. nodes = getNodes(node.parent);
  146. project.Bills.updateNodes(nodes, false);
  147. project.endUpdate();
  148. nodes.push(node);
  149. } else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
  150. project.beginUpdate('Ration_QuantityChange');
  151. calcFees.setFee(node.data, fieldName, value);
  152. node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID);
  153. // calcProgram.calculate的传参必须是cacheNode类型,故无法将计算放在Ration模块中。
  154. project.calcProgram.calculate(node);
  155. project.Ration.updateRation(node.source, false);
  156. calc.calcNode(node.parent, true);
  157. nodes = getNodes(node.parent);
  158. project.Bills.updateNodes(nodes, false);
  159. project.endUpdate();
  160. nodes.push(node);
  161. }
  162. this.mainController.refreshTreeNode(nodes, false);
  163. calc = null;
  164. },
  165. updateBillsCode: function (node, value) {
  166. let project = projectObj.project;
  167. let stdMatchCode, formatCode, matchs;
  168. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  169. let orgCode = node.data.code.substr(0, 9);
  170. if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
  171. project.Bills.updateField(node.source, 'code', formatCode, true);
  172. projectObj.mainController.refreshTreeNode([node], false);
  173. } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
  174. let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
  175. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  176. if (data) {
  177. data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
  178. project.Bills.replaceBills(node.source, data, formatCode);
  179. } else {
  180. project.Bills.updateField(node.source, 'code', formatCode, true);
  181. }
  182. projectObj.mainController.refreshTreeNode([node], false);
  183. });
  184. }
  185. }
  186. if (value.length === 9 && /^[\d]+$/.test(value)) {
  187. stdMatchCode = value;
  188. formatCode = project.Bills.newFormatCode(stdMatchCode);
  189. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  190. } else if (value.length === 12 && /^[\d]+$/.test(value)) {
  191. stdMatchCode = value.substr(0, 9);
  192. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  193. if (matchs.indexOf(value) === -1) {
  194. searchStdBillsAndUpdate(stdMatchCode, value);
  195. } else if (confirm('已存在该编码的清单,是否继续?')) {
  196. formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  197. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  198. }
  199. } else {
  200. project.Bills.updateField(node.source, 'code', value, true);
  201. this.mainController.refreshTreeNode([node], false);
  202. }
  203. },
  204. updateRationCode: function (node, value) {
  205. if (/[\w]{2}[\d]{4}/.test(value)) {
  206. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  207. alert('当前项目无定额库,请添加定额库。');
  208. this.mainController.refreshTreeNode([node], false);
  209. } else {
  210. let libId = projectInfoObj.projectInfo.engineeringInfo.ration_lib[0].id;
  211. CommonAjax.postRationLib('/rationRepository/api/matchRation', {user_id: userID, rationLibId: libId, code: value}, function (data) {
  212. if (data) {
  213. projectObj.project.Ration.replaceRation(node.source, data);
  214. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  215. } else {
  216. alert('当前库中找不到定额"' + value + '"');
  217. }
  218. projectObj.mainController.refreshTreeNode([node], false);
  219. });
  220. }
  221. } else {
  222. alert('输入的定额编码有误,请检查。');
  223. this.mainController.refreshTreeNode([node], false);
  224. }
  225. },
  226. updateCode: function (node, value) {
  227. let project = projectObj.project;
  228. if (node.sourceType === project.Bills.getSourceType()) {
  229. this.updateBillsCode(node, value);
  230. } else if (node.sourceType === project.Ration.getSourceType()) {
  231. this.updateRationCode(node, value);
  232. }
  233. },
  234. mainSpreadEditEnded: function (sender, info) {
  235. let project = projectObj.project;
  236. let node = project.mainTree.items[info.row];
  237. let colSetting = projectObj.mainController.setting.cols[info.col];
  238. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  239. // 检查输入类型等
  240. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  241. if (value && value !== calcFees.getFee(node.data, fieldName)) {
  242. if (fieldName === 'code') {
  243. projectObj.updateCode(node, value);
  244. } else if (fieldName === 'quantity' && project.quantity_detail.quantityEditChecking(value,node,fieldName)) {
  245. projectObj.updateAndReCalculate(node, fieldName, value);
  246. } else if (fieldName === 'feesIndex.common.unitFee') {
  247. projectObj.updateAndReCalculate(node, fieldName, value);
  248. } else {
  249. if (node.sourceType === project.Bills.getSourceType()) {
  250. project.Bills.updateField(node.source, fieldName, value, true);
  251. } else if (node.sourceType === project.Ration.getSourceType()) {
  252. project.Ration.updateField(node.source, fieldName, value, true);
  253. } else if (node.sourceType === project.VolumePrice.getSourceType()) {
  254. project.VolumePrice.updateField(node.source, fieldName, value, true);
  255. }
  256. if (colSetting.data.wordWrap) {
  257. info.sheet.autoFitRow(info.row);
  258. }
  259. projectObj.mainController.refreshTreeNode([node]);
  260. }
  261. }
  262. },
  263. checkMainSpread: function () {
  264. if (!this.mainSpread) {
  265. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  266. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.single);
  267. }
  268. },
  269. refreshMainSpread: function () {
  270. if (this.mainSpread) {
  271. this.mainSpread.refresh();
  272. }
  273. },
  274. loadProjectData: function () {
  275. var that = this;
  276. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  277. this.project.loadDatas(function (err) {
  278. if (!err) {
  279. that.project.calcFields = JSON.parse(JSON.stringify(feeType));
  280. that.project.setCalcFlag(rationContent);
  281. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  282. that.project.projSetting.mainGridSetting = JSON.parse(str);
  283. that.project.projSetting.mainGridSetting.frozenCols = 4;
  284. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  285. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  286. col.data.splitFields = col.data.field.split('.');
  287. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  288. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  289. }
  290. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  291. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  292. }
  293. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  294. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  295. col.data.cellType = getCellType();
  296. }
  297. if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  298. col.data.decimal = that.project.getDecimal(col.data.digit);
  299. col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  300. }
  301. if (col.data.field === 'code') {
  302. col.data.formatter = '@';
  303. }
  304. });
  305. that.project.calcProgram = new CalcProgram(that.project);
  306. that.project.calcProgram.compileAllTemps();
  307. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  308. that.mainController.showTreeData();
  309. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  310. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  311. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  312. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  313. that.loadMainSpreadContextMenu();
  314. }
  315. else {
  316. }
  317. });
  318. },
  319. loadMainSpreadContextMenu: function () {
  320. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  321. $.contextMenu({
  322. selector: '#billsSpread',
  323. build: function ($trigger, e) {
  324. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  325. controller.setTreeSelected(controller.tree.items[target.row]);
  326. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  327. },
  328. items: {
  329. "insertBills": {
  330. name: "插入清单",
  331. icon: 'fa-sign-in',
  332. disabled: function () {
  333. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  334. },
  335. callback: function (key, opt) {
  336. ProjectController.addBills(project, controller);
  337. }
  338. },
  339. "insertRation": {
  340. name: "插入定额",
  341. icon: 'fa-sign-in',
  342. disabled: function () {
  343. var selected = project.mainTree.selected;
  344. if (selected) {
  345. if (selected.sourceType === project.Ration.getSourceType()) {
  346. return false;
  347. } else if (selected.sourceType === project.Bills.getSourceType()) {
  348. if (selected.source.children.length === 0) {
  349. return selected.children.length !== 0 ? selected.firstChild().sourceType !== project.Ration.getSourceType() : false;
  350. } else {
  351. return true;
  352. }
  353. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  354. return true;
  355. };
  356. } else {
  357. return true;
  358. }
  359. },
  360. callback: function (key, opt) {
  361. ProjectController.addRation(project, controller);
  362. }
  363. },
  364. "insertLJ": {
  365. name: "插入量价",
  366. icon: 'fa-sign-in',
  367. disabled: function () {
  368. var selected = project.mainTree.selected;
  369. if (selected) {
  370. if (selected.sourceType === project.Ration.getSourceType()) {
  371. return true;
  372. } else if (selected.sourceType === project.Bills.getSourceType()) {
  373. if (selected.source.children.length === 0) {
  374. return selected.children.length !== 0 ? selected.firstChild().sourceType !== project.VolumePrice.getSourceType() : false;
  375. } else {
  376. return true;
  377. }
  378. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  379. return false;
  380. };
  381. } else {
  382. return true;
  383. }
  384. },
  385. callback: function (key, opt) {
  386. ProjectController.addVolumePrice(project, controller);
  387. }
  388. },
  389. "spr1": '--------',
  390. "delete": {
  391. name: '删除',
  392. icon: 'fa-remove',
  393. disabled: function () {
  394. var selected = project.mainTree.selected;
  395. return !selected;
  396. },
  397. callback: function () {
  398. var selected = controller.tree.selected;
  399. if (selected) {
  400. if (selected.sourceType === project.Bills.getSourceType()) {
  401. project.Bills.deleteBills(selected.source);
  402. controller.delete();
  403. } else if (selected.sourceType === project.Ration.getSourceType()) {
  404. project.Ration.delete(selected.source);
  405. controller.delete();
  406. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  407. project.VolumePrice.delete(selected.source);
  408. controller.delete();
  409. };
  410. }
  411. }
  412. },
  413. "spr2":'--------',
  414. "calculateAll_RationContent": {
  415. name: '造价计算',
  416. callback: function () {
  417. projectObj.calculateAll();
  418. }
  419. }
  420. }
  421. });
  422. },
  423. // 计算node及node的所有父项
  424. converseCalculateBills: function (node) {
  425. let calc = new BillsCalcHelper(this.project);
  426. calc.calcNode(node, true);
  427. let cur = node, nodes = [];
  428. while (cur) {
  429. nodes.push(cur);
  430. cur = cur.parent;
  431. }
  432. this.mainController.refreshTreeNode(nodes, false);
  433. this.project.Bills.updateNodes(nodes, true);
  434. calc = null;
  435. },
  436. // 计算全部清单
  437. calculateAll: function () {
  438. let calc = new BillsCalcHelper(this.project);
  439. calc.calcAll();
  440. this.mainController.showTreeData();
  441. this.project.Bills.updateAll();
  442. calc = null;
  443. }
  444. };
  445. $('#insert').click(function () {
  446. var controller = projectObj.mainController, project = projectObj.project;
  447. var selected = controller.tree.selected;
  448. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  449. ProjectController.addBills(project, controller);
  450. } else if (selected.sourceType === project.Ration.getSourceType()) {
  451. ProjectController.addRation(project, controller);
  452. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  453. ProjectController.addVolumePrice(project, controller);
  454. }
  455. });
  456. $('#delete').click(function () {
  457. var controller = projectObj.mainController, project = projectObj.project;
  458. var selected = controller.tree.selected;
  459. if (selected) {
  460. if (selected.sourceType === project.Bills.getSourceType()) {
  461. project.Bills.deleteBills(selected.source);
  462. controller.delete();
  463. } else if (selected.sourceType === project.Ration.getSourceType()) {
  464. project.Ration.delete(selected.source);
  465. controller.delete();
  466. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  467. project.VolumePrice.delete(selected.source);
  468. controller.delete();
  469. };
  470. }
  471. });
  472. $('#upLevel').click(function () {
  473. var controller = projectObj.mainController, project = projectObj.project;
  474. var selected = controller.tree.selected;
  475. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  476. project.Bills.upLevelBills(selected.source);
  477. controller.upLevel();
  478. }
  479. });
  480. $('#downLevel').click(function () {
  481. var controller = projectObj.mainController, project = projectObj.project;
  482. var selected = controller.tree.selected;
  483. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  484. project.Bills.downLevelBills(selected.source);
  485. controller.downLevel();
  486. }
  487. });
  488. $('#upMove').click(function () {
  489. var controller = projectObj.mainController, project = projectObj.project;
  490. var selected = controller.tree.selected, pre, preSerialNo;
  491. if (selected.sourceType === project.Bills.getSourceType()) {
  492. project.Bills.upMoveBills(selected.source);
  493. controller.upMove();
  494. } else if (selected.sourceType === project.Ration.getSourceType()) {
  495. project.Ration.changePos(selected.source, selected.preSibling.source);
  496. controller.upMove();
  497. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  498. project.VolumePrice.changePos(selected.source, selected.preSibling.source);
  499. controller.upMove();
  500. }
  501. });
  502. $('#downMove').click(function () {
  503. var controller = projectObj.mainController, project = projectObj.project;
  504. var selected = controller.tree.selected, next, nextSerialNo;
  505. if (selected.sourceType === project.Bills.getSourceType()) {
  506. project.Bills.downMoveBills(selected.source);
  507. controller.downMove();
  508. } else if (selected.sourceType === project.Ration.getSourceType()) {
  509. project.Ration.changePos(selected.source, selected.nextSibling.source);
  510. controller.downMove();
  511. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  512. project.VolumePrice.changePos(selected.source, selected.nextSibling.source);
  513. controller.downMove();
  514. }
  515. });
  516. $('#rationContent').val(rationContent);
  517. $('#rationPrice').val(rationPrice);
  518. $('#rationPriceConverse').val(rationPriceConverse);
  519. $('#billsPrice').val(billsPrice);
  520. $('#property_ok').click(function () {
  521. projectObj.project.setCalcFlag(parseInt($("input[name='calcFlag']:checked").val()));
  522. projectObj.calculateAll();
  523. });