project_view.js 20 KB

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