project_view.js 23 KB

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