project_view.js 24 KB

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