project_view.js 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398
  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. checkCommonField: function (editingText, colSetting) {
  10. let value;
  11. if (colSetting.data.decimal) {
  12. value = Number(editingText);
  13. if (number_util.isNumber(value)) {
  14. value = value.toDecimal(colSetting.data.decimal);
  15. } else {
  16. value = null;
  17. alert('当前输入的数据类型不正确,请重新输入。');
  18. }
  19. } else {
  20. value = editingText;
  21. }
  22. return value;
  23. },
  24. checkQuantityField: function (editingText, colSetting) {
  25. let value = Number(editingText);
  26. if (!value) {
  27. try {
  28. let exp = new Expression('');
  29. exp.Expression(editingText);
  30. value = Number(exp.Evaluate());
  31. } catch (error) {
  32. value = null;
  33. }
  34. }
  35. if (value) {
  36. value = value.toDecimal(colSetting.data.decimal);
  37. } else {
  38. value = null;
  39. alert('当前输入的数据类型不正确,请重新输入。');
  40. }
  41. return value;
  42. },
  43. checkSpreadEditingText: function (editingText, colSetting) {
  44. if (colSetting.data.field === 'quantity') {
  45. return this.checkQuantityField(editingText, colSetting);
  46. } else {
  47. return this.checkCommonField(editingText, colSetting);
  48. }
  49. },
  50. mainSpreadEditEnded: function (sender, info) {
  51. let project = projectObj.project;
  52. let node = project.mainTree.items[info.row];
  53. let colSetting = projectObj.mainController.setting.cols[info.col];
  54. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  55. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  56. let validate = project.quantity_detail.quantityEditChecking(value,node,fieldName);
  57. if (colSetting.data.wordWrap) {
  58. info.sheet.autoFitRow(info.row);
  59. }
  60. if (value && value != calcFees.getFee(node.data, fieldName)&&validate) {
  61. if (node.sourceType === project.Bills.getSourceType()) {
  62. project.Bills.updateField(node.source, fieldName, value);
  63. } else if (node.sourceType === project.Ration.getSourceType()) {
  64. project.Ration.updateField(node.source, fieldName, value);
  65. } else if (node.sourceType === project.VolumePrice.getSourceType()) {
  66. project.VolumePrice.updateField(node.source, fieldName, value);
  67. }
  68. }
  69. projectObj.mainController.refreshTreeNode([node]);
  70. },
  71. checkMainSpread: function () {
  72. if (!this.mainSpread) {
  73. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  74. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.single);
  75. }
  76. },
  77. refreshMainSpread: function () {
  78. if (this.mainSpread) {
  79. this.mainSpread.refresh();
  80. }
  81. },
  82. loadProjectData: function () {
  83. var that = this;
  84. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  85. this.project.loadDatas(function (err) {
  86. if (!err) {
  87. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], BillsGridSetting);
  88. BillsGridSetting.cols.forEach(function (col) {
  89. col.data.splitFields = col.data.field.split('.');
  90. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  91. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  92. }
  93. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  94. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  95. }
  96. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  97. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  98. col.data.cellType = getCellType();
  99. }
  100. if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  101. col.data.decimal = that.project.getDecimal(col.data.digit);
  102. col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  103. }
  104. });
  105. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), BillsGridSetting);
  106. that.mainController.showTreeData();
  107. that.mainController.bind('refreshBaseActn', function (tree) {
  108. var setButtonValid = function (valid, btn) {
  109. if (valid) {
  110. btn.removeClass('disabled');
  111. } else {
  112. btn.addClass('disabled');
  113. }
  114. };
  115. let selected = tree.selected;
  116. let canUpLevel = function (node) {
  117. if (selected && selected.depth() > 0 && selected.canUpLevel()) {
  118. if (selected.sourceType === that.project.Bills.getSourceType()) {
  119. return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0);
  120. } else {
  121. return false;
  122. }
  123. } else {
  124. return false;
  125. }
  126. };
  127. let canDownLevel = function (node) {
  128. if (selected && selected.depth() > 0 && selected.canDownLevel()) {
  129. if (selected.sourceType === that.project.Bills.getSourceType()) {
  130. return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0);
  131. } else {
  132. return false;
  133. }
  134. } else {
  135. return false;
  136. }
  137. };
  138. let canDelete = function (node) {
  139. if (selected) {
  140. if (selected.sourceType === that.project.Bills.getSourceType()) {
  141. return !(selected.data.flagsIndex && selected.data.flagsIndex.fixed && selected.data.flagsIndex.fixed.flag > 0);
  142. } else {
  143. return true;
  144. }
  145. } else {
  146. return false;
  147. }
  148. };
  149. setButtonValid(canUpLevel(selected), $('#upLevel'));
  150. setButtonValid(canDownLevel(selected), $('#downLevel'));
  151. setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove'));
  152. setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove'));
  153. setButtonValid(canDelete(selected), $('#delete'));
  154. });
  155. /* if(!projectObj.gljSpreed){
  156. projectObj.gljSpreed = gljView.buildSheet($("#gljSpread")[0]);
  157. that.loadGLJSpreadContextMenu();
  158. }*/
  159. that.project.calcProgram = new CalcProgram(that.project);
  160. that.project.calcProgram.compileAllTemps();
  161. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, function (node) {
  162. gljOprObj.showDataIfRationSelect(node);
  163. // CSL.2017.07.25
  164. if (SubActiveSheetNameIs('JSCX')) {
  165. if (node.sourceType === that.project.Bills.getSourceType() || node.sourceType === that.project.Ration.getSourceType()) {
  166. calcProgramObj.showData(node);
  167. } else {
  168. calcProgramObj.clearData();
  169. };
  170. };
  171. //zhong 2017-9-1 特征及内容
  172. if(pageCCOprObj.active){
  173. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  174. if(node.sourceType === that.project.Bills.getSourceType()){
  175. pageCCOprObj.setCacheAndShow(node);
  176. }
  177. else{
  178. pageCCOprObj.clearData();
  179. }
  180. }
  181. });
  182. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  183. that.loadMainSpreadContextMenu();
  184. }
  185. else {
  186. }
  187. });
  188. },
  189. loadMainSpreadContextMenu: function () {
  190. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  191. $.contextMenu({
  192. selector: '#billsSpread',
  193. build: function ($trigger, e) {
  194. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  195. controller.setTreeSelected(controller.tree.items[target.row]);
  196. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  197. },
  198. items: {
  199. "insertBills": {
  200. name: "插入清单",
  201. icon: 'fa-sign-in',
  202. disabled: function () {
  203. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  204. },
  205. callback: function (key, opt) {
  206. ProjectController.addBills(project, controller);
  207. }
  208. },
  209. "insertRation": {
  210. name: "插入定额",
  211. icon: 'fa-sign-in',
  212. disabled: function () {
  213. var selected = project.mainTree.selected;
  214. if (selected) {
  215. if (selected.sourceType === project.Ration.getSourceType()) {
  216. return false;
  217. } else if (selected.sourceType === project.Bills.getSourceType()) {
  218. if (selected.source.children.length === 0) {
  219. return selected.children.length !== 0 ? selected.firstChild().sourceType !== project.Ration.getSourceType() : false;
  220. } else {
  221. return true;
  222. }
  223. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  224. return true;
  225. };
  226. } else {
  227. return true;
  228. }
  229. },
  230. callback: function (key, opt) {
  231. ProjectController.addRation(project, controller);
  232. }
  233. },
  234. "insertLJ": {
  235. name: "插入量价",
  236. icon: 'fa-sign-in',
  237. disabled: function () {
  238. var selected = project.mainTree.selected;
  239. if (selected) {
  240. if (selected.sourceType === project.Ration.getSourceType()) {
  241. return true;
  242. } else if (selected.sourceType === project.Bills.getSourceType()) {
  243. if (selected.source.children.length === 0) {
  244. return selected.children.length !== 0 ? selected.firstChild().sourceType !== project.VolumePrice.getSourceType() : false;
  245. } else {
  246. return true;
  247. }
  248. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  249. return false;
  250. };
  251. } else {
  252. return true;
  253. }
  254. },
  255. callback: function (key, opt) {
  256. ProjectController.addVolumePrice(project, controller);
  257. }
  258. },
  259. "spr1": '--------',
  260. "delete": {
  261. name: '删除',
  262. icon: 'fa-remove',
  263. disabled: function () {
  264. var selected = project.mainTree.selected;
  265. return !selected;
  266. },
  267. callback: function () {
  268. var selected = controller.tree.selected;
  269. if (selected) {
  270. if (selected.sourceType === project.Bills.getSourceType()) {
  271. project.Bills.deleteBills(selected.source);
  272. controller.delete();
  273. } else if (selected.sourceType === project.Ration.getSourceType()) {
  274. project.Ration.delete(selected.source);
  275. controller.delete();
  276. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  277. project.VolumePrice.delete(selected.source);
  278. controller.delete();
  279. };
  280. }
  281. }
  282. },
  283. "spr2":'--------',
  284. "calculateAll_RationContent": {
  285. name: '造价计算(子目含量取费)',
  286. callback: function () {
  287. ProjectController.calculateAll(project, controller, rationContent);
  288. }
  289. },
  290. "calculateAll_RationPrice": {
  291. name: '造价计算(子目单价取费)',
  292. callback: function () {
  293. ProjectController.calculateAll(project, controller, rationPrice);
  294. }
  295. },
  296. "calculateAll_RationPriceConverse": {
  297. name: '造价计算(子目单价取费-反算)',
  298. callback: function () {
  299. ProjectController.calculateAll(project, controller, rationPriceConverse);
  300. }
  301. },
  302. "calculateAll_BillsPrice": {
  303. name: '造价计算(清单单价取费)',
  304. callback: function () {
  305. ProjectController.calculateAll(project, controller, billsPrice);
  306. }
  307. }
  308. }
  309. });
  310. }
  311. };
  312. $('#insert').click(function () {
  313. var controller = projectObj.mainController, project = projectObj.project;
  314. var selected = controller.tree.selected;
  315. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  316. ProjectController.addBills(project, controller);
  317. } else if (selected.sourceType === project.Ration.getSourceType()) {
  318. ProjectController.addRation(project, controller);
  319. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  320. ProjectController.addVolumePrice(project, controller);
  321. }
  322. });
  323. $('#delete').click(function () {
  324. var controller = projectObj.mainController, project = projectObj.project;
  325. var selected = controller.tree.selected;
  326. if (selected) {
  327. if (selected.sourceType === project.Bills.getSourceType()) {
  328. project.Bills.deleteBills(selected.source);
  329. controller.delete();
  330. } else if (selected.sourceType === project.Ration.getSourceType()) {
  331. project.Ration.delete(selected.source);
  332. controller.delete();
  333. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  334. project.VolumePrice.delete(selected.source);
  335. controller.delete();
  336. };
  337. }
  338. });
  339. $('#upLevel').click(function () {
  340. var controller = projectObj.mainController, project = projectObj.project;
  341. var selected = controller.tree.selected;
  342. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  343. project.Bills.upLevelBills(selected.source);
  344. controller.upLevel();
  345. }
  346. });
  347. $('#downLevel').click(function () {
  348. var controller = projectObj.mainController, project = projectObj.project;
  349. var selected = controller.tree.selected;
  350. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  351. project.Bills.downLevelBills(selected.source);
  352. controller.downLevel();
  353. }
  354. });
  355. $('#upMove').click(function () {
  356. var controller = projectObj.mainController, project = projectObj.project;
  357. var selected = controller.tree.selected, pre, preSerialNo;
  358. if (selected.sourceType === project.Bills.getSourceType()) {
  359. project.Bills.upMoveBills(selected.source);
  360. controller.upMove();
  361. } else if (selected.sourceType === project.Ration.getSourceType()) {
  362. project.Ration.changePos(selected.source, selected.preSibling.source);
  363. controller.upMove();
  364. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  365. project.VolumePrice.changePos(selected.source, selected.preSibling.source);
  366. controller.upMove();
  367. }
  368. });
  369. $('#downMove').click(function () {
  370. var controller = projectObj.mainController, project = projectObj.project;
  371. var selected = controller.tree.selected, next, nextSerialNo;
  372. if (selected.sourceType === project.Bills.getSourceType()) {
  373. project.Bills.downMoveBills(selected.source);
  374. controller.downMove();
  375. } else if (selected.sourceType === project.Ration.getSourceType()) {
  376. project.Ration.changePos(selected.source, selected.nextSibling.source);
  377. controller.downMove();
  378. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  379. project.VolumePrice.changePos(selected.source, selected.nextSibling.source);
  380. controller.downMove();
  381. }
  382. });