project_view.js 21 KB

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