project_view.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369
  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 = info.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. if (colSetting.data.wordWrap) {
  57. info.sheet.autoFitRow(info.row);
  58. }
  59. if (value) {
  60. if (node.sourceType === project.Bills.getSourceType()) {
  61. project.Bills.updateField(node.source, fieldName, value);
  62. } else if (node.sourceType === project.Ration.getSourceType()) {
  63. project.Ration.updateField(node.source, fieldName, value);
  64. } else if (node.sourceType === project.VolumePrice.getSourceType()) {
  65. project.VolumePrice.updateField(node.source, fieldName, value);
  66. }
  67. }
  68. projectObj.mainController.refreshTreeNode([node]);
  69. },
  70. checkMainSpread: function () {
  71. if (!this.mainSpread) {
  72. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  73. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.single);
  74. }
  75. },
  76. refreshMainSpread: function () {
  77. if (this.mainSpread) {
  78. this.mainSpread.refresh();
  79. }
  80. },
  81. loadProjectData: function () {
  82. var that = this;
  83. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  84. this.project.loadDatas(function (err) {
  85. if (!err) {
  86. BillsGridSetting.cols.forEach(function (col) {
  87. col.data.splitFields = col.data.field.split('.');
  88. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  89. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  90. }
  91. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  92. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  93. }
  94. if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  95. col.data.decimal = that.project.getDecimal(col.data.digit);
  96. col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  97. }
  98. });
  99. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), BillsGridSetting);
  100. that.mainController.showTreeData();
  101. that.mainController.bind('refreshBaseActn', function (tree) {
  102. var setButtonValid = function (valid, btn) {
  103. if (valid) {
  104. btn.removeClass('disabled');
  105. } else {
  106. btn.addClass('disabled');
  107. }
  108. };
  109. let selected = tree.selected;
  110. let canUpLevel = function (node) {
  111. if (selected && selected.depth() > 0 && selected.canUpLevel()) {
  112. if (selected.sourceType === that.project.Bills.getSourceType()) {
  113. return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0);
  114. } else {
  115. return false;
  116. }
  117. } else {
  118. return false;
  119. }
  120. };
  121. let canDownLevel = function (node) {
  122. if (selected && selected.depth() > 0 && selected.canDownLevel()) {
  123. if (selected.sourceType === that.project.Bills.getSourceType()) {
  124. return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0);
  125. } else {
  126. return false;
  127. }
  128. } else {
  129. return false;
  130. }
  131. };
  132. setButtonValid(canUpLevel(selected), $('#upLevel'));
  133. setButtonValid(canDownLevel(selected), $('#downLevel'));
  134. setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove'));
  135. setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove'));
  136. setButtonValid(selected, $('#delete'));
  137. });
  138. /* if(!projectObj.gljSpreed){
  139. projectObj.gljSpreed = gljView.buildSheet($("#gljSpread")[0]);
  140. that.loadGLJSpreadContextMenu();
  141. }*/
  142. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, function (node) {
  143. gljOprObj.showDataIfRationSelect(node);
  144. // CSL.2017.07.25
  145. if (SubActiveSheetNameIs('JSCX')) {
  146. if (node.sourceType === that.project.Bills.getSourceType()) {
  147. rationCalcView.clearData();
  148. } else if (node.sourceType==='ration') {
  149. rationCalcView.showData(node);
  150. } else {
  151. rationCalcView.clearData();
  152. }
  153. }
  154. });
  155. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  156. that.loadMainSpreadContextMenu();
  157. }
  158. else {
  159. }
  160. });
  161. },
  162. loadMainSpreadContextMenu: function () {
  163. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  164. $.contextMenu({
  165. selector: '#billsSpread',
  166. build: function ($trigger, e) {
  167. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  168. controller.setTreeSelected(controller.tree.items[target.row]);
  169. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  170. },
  171. items: {
  172. "insertBills": {
  173. name: "插入清单",
  174. icon: 'fa-sign-in',
  175. disabled: function () {
  176. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  177. },
  178. callback: function (key, opt) {
  179. ProjectController.addBills(project, controller);
  180. }
  181. },
  182. "insertRation": {
  183. name: "插入定额",
  184. icon: 'fa-sign-in',
  185. disabled: function () {
  186. var selected = project.mainTree.selected;
  187. if (selected) {
  188. if (selected.sourceType === project.Ration.getSourceType()) {
  189. return false;
  190. } else if (selected.sourceType === project.Bills.getSourceType()) {
  191. if (selected.source.children.length === 0) {
  192. return selected.children.length !== 0 ? selected.firstChild().sourceType !== project.Ration.getSourceType() : false;
  193. } else {
  194. return true;
  195. }
  196. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  197. return true;
  198. };
  199. } else {
  200. return true;
  201. }
  202. },
  203. callback: function (key, opt) {
  204. ProjectController.addRation(project, controller);
  205. }
  206. },
  207. "insertLJ": {
  208. name: "插入量价",
  209. icon: 'fa-sign-in',
  210. disabled: function () {
  211. var selected = project.mainTree.selected;
  212. if (selected) {
  213. if (selected.sourceType === project.Ration.getSourceType()) {
  214. return true;
  215. } else if (selected.sourceType === project.Bills.getSourceType()) {
  216. if (selected.source.children.length === 0) {
  217. return selected.children.length !== 0 ? selected.firstChild().sourceType !== project.VolumePrice.getSourceType() : false;
  218. } else {
  219. return true;
  220. }
  221. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  222. return false;
  223. };
  224. } else {
  225. return true;
  226. }
  227. },
  228. callback: function (key, opt) {
  229. ProjectController.addVolumePrice(project, controller);
  230. }
  231. },
  232. "spr1": '--------',
  233. "delete": {
  234. name: '删除',
  235. icon: 'fa-remove',
  236. disabled: function () {
  237. var selected = project.mainTree.selected;
  238. return !selected;
  239. },
  240. callback: function () {
  241. var selected = controller.tree.selected;
  242. if (selected) {
  243. if (selected.sourceType === project.Bills.getSourceType()) {
  244. project.Bills.deleteBills(selected.source);
  245. controller.delete();
  246. } else if (selected.sourceType === project.Ration.getSourceType()) {
  247. project.Ration.delete(selected.source);
  248. controller.delete();
  249. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  250. project.VolumePrice.delete(selected.source);
  251. controller.delete();
  252. };
  253. }
  254. }
  255. },
  256. "spr2":'--------',
  257. "calculateAll_RationContent": {
  258. name: '造价计算(子目含量取费)',
  259. callback: function () {
  260. ProjectController.calculateAll(project, controller, rationContent);
  261. }
  262. },
  263. "calculateAll_RationPrice": {
  264. name: '造价计算(子目单价取费)',
  265. callback: function () {
  266. ProjectController.calculateAll(project, controller, rationPrice);
  267. }
  268. },
  269. "calculateAll_RationPriceConverse": {
  270. name: '造价计算(子目单价取费-反算)',
  271. callback: function () {
  272. ProjectController.calculateAll(project, controller, rationPriceConverse);
  273. }
  274. },
  275. "calculateAll_BillsPrice": {
  276. name: '造价计算(清单单价取费)',
  277. callback: function () {
  278. ProjectController.calculateAll(project, controller, billsPrice);
  279. }
  280. }
  281. }
  282. });
  283. }
  284. };
  285. $('#insert').click(function () {
  286. var controller = projectObj.mainController, project = projectObj.project;
  287. var selected = controller.tree.selected;
  288. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  289. ProjectController.addBills(project, controller);
  290. } else if (selected.sourceType === project.Ration.getSourceType()) {
  291. ProjectController.addRation(project, controller);
  292. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  293. ProjectController.addVolumePrice(project, controller);
  294. }
  295. });
  296. $('#delete').click(function () {
  297. var controller = projectObj.mainController, project = projectObj.project;
  298. var selected = controller.tree.selected;
  299. if (selected) {
  300. if (selected.sourceType === project.Bills.getSourceType()) {
  301. project.Bills.deleteBills(selected.source);
  302. controller.delete();
  303. } else if (selected.sourceType === project.Ration.getSourceType()) {
  304. project.Ration.delete(selected.source);
  305. controller.delete();
  306. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  307. project.VolumePrice.delete(selected.source);
  308. controller.delete();
  309. };
  310. }
  311. });
  312. $('#upLevel').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. project.Bills.upLevelBills(selected.source);
  317. controller.upLevel();
  318. }
  319. });
  320. $('#downLevel').click(function () {
  321. var controller = projectObj.mainController, project = projectObj.project;
  322. var selected = controller.tree.selected;
  323. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  324. project.Bills.downLevelBills(selected.source);
  325. controller.downLevel();
  326. }
  327. });
  328. $('#upMove').click(function () {
  329. var controller = projectObj.mainController, project = projectObj.project;
  330. var selected = controller.tree.selected, pre, preSerialNo;
  331. if (selected.sourceType === project.Bills.getSourceType()) {
  332. project.Bills.upMoveBills(selected.source);
  333. controller.upMove();
  334. } else if (selected.sourceType === project.Ration.getSourceType()) {
  335. project.Ration.changePos(selected.source, selected.preSibling.source);
  336. controller.upMove();
  337. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  338. project.VolumePrice.changePos(selected.source, selected.preSibling.source);
  339. controller.upMove();
  340. }
  341. });
  342. $('#downMove').click(function () {
  343. var controller = projectObj.mainController, project = projectObj.project;
  344. var selected = controller.tree.selected, next, nextSerialNo;
  345. if (selected.sourceType === project.Bills.getSourceType()) {
  346. project.Bills.downMoveBills(selected.source);
  347. controller.downMove();
  348. } else if (selected.sourceType === project.Ration.getSourceType()) {
  349. project.Ration.changePos(selected.source, selected.nextSibling.source);
  350. controller.downMove();
  351. } else if (selected.sourceType === project.VolumePrice.getSourceType()) {
  352. project.VolumePrice.changePos(selected.source, selected.nextSibling.source);
  353. controller.downMove();
  354. }
  355. });