calc_program_manage.js 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545
  1. /**
  2. * Created by CSL on 2017-08-03.
  3. * 计算程序管理。
  4. */
  5. let calcProgramManage = {
  6. datas: [],
  7. mainSpread: null,
  8. detailSpread: null,
  9. mainSetting: {
  10. header:[
  11. // {headerName:"ID",headerWidth:80,dataCode:"ID", hAlign: "center"},
  12. {headerName:"名称",headerWidth:200,dataCode:"name", dataType: "String"}
  13. ],
  14. view:{
  15. comboBox:[],
  16. lockColumns:[0,1],
  17. colHeaderHeight: CP_Col_Width.colHeader,
  18. rowHeaderWidth: CP_Col_Width.rowHeader
  19. }
  20. },
  21. detailSetting: {
  22. header:[
  23. // {headerName:"ID",headerWidth:80,dataCode:"ID", hAlign: "center"},
  24. {headerName:"费用代号",headerWidth:CP_Col_Width.code, dataCode:"code", dataType: "String"},
  25. {headerName:"费用名称",headerWidth:CP_Col_Width.name, dataCode:"name", dataType: "String"},
  26. {headerName:"计算基数",headerWidth:CP_Col_Width.dispExprUser, dataCode:"dispExprUser", dataType: "String"},
  27. {headerName:"费率",headerWidth:CP_Col_Width.feeRate, dataCode:"feeRate", dataType: "Number",hAlign: "right",decimalField:"feeRate"},
  28. {headerName:"费用类别",headerWidth:CP_Col_Width.displayFieldName, dataCode:"displayFieldName", dataType: "String", hAlign: "center"},
  29. {headerName:"基数说明",headerWidth:CP_Col_Width.statement, dataCode:"statement", dataType: "String"},
  30. {headerName:"备注",headerWidth:CP_Col_Width.memo, dataCode:"memo", dataType: "String"}
  31. ],
  32. view:{
  33. comboBox:[],
  34. lockColumns:[2,5],
  35. colHeaderHeight: CP_Col_Width.colHeader,
  36. rowHeaderWidth: CP_Col_Width.rowHeader
  37. }
  38. },
  39. buildSheet: function (){
  40. let me = this;
  41. me.datas = projectObj.project.calcProgram.datas.templates;
  42. if (me.mainSpread) {
  43. me.mainSpread.destroy();
  44. me.mainSpread = null;
  45. };
  46. if (me.detailSpread) {
  47. me.detailSpread.destroy();
  48. me.detailSpread = null;
  49. };
  50. me.mainSpread = sheetCommonObj.buildSheet($('#mainSpread')[0], me.mainSetting, me.datas.length);
  51. sheetCommonObj.spreadDefaultStyle(me.mainSpread);
  52. me.detailSpread = sheetCommonObj.buildSheet($('#detailSpread')[0], me.detailSetting, me.datas[0].calcItems.length);
  53. sheetCommonObj.spreadDefaultStyle(me.detailSpread);
  54. let arr = projectObj.project.calcProgram.compiledFeeTypeNames.slice();
  55. // arr.delete('暂估费');
  56. let fieldName = new GC.Spread.Sheets.CellTypes.ComboBox();
  57. fieldName.items(arr);
  58. me.detailSpread.getSheet(0).getRange(-1, 4, -1, 1).cellType(fieldName);
  59. me.mainSpread.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onMainEnterCell);
  60. me.detailSpread.getSheet(0).bind(GC.Spread.Sheets.Events.ValueChanged, me.onDetailValueChanged);
  61. me.detailSpread.getSheet(0).bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
  62. me.detailSpread.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onDetailEnterCell);
  63. me.detailSpread.getSheet(0).bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  64. let mSheet = me.mainSpread.getSheet(0);
  65. sheetCommonObj.showData(mSheet, me.mainSetting, me.datas);
  66. let dSheet = me.detailSpread.getSheet(0);
  67. dSheet.name('calc_detail');
  68. feeRateObject.setFeeRateCellCol(dSheet,_.findIndex(me.detailSetting.header,{'dataCode':'feeRate'}));
  69. dSheet.getRange(-1, _.findIndex(me.detailSetting.header, {'dataCode': 'dispExprUser'}), -1, 1).cellType(calcBaseView.getCalcBaseCellType('ration'));
  70. sheetCommonObj.showData(dSheet, me.detailSetting, me.datas[0].calcItems);
  71. customRowHeader(dSheet, me.datas[0].calcItems.length);
  72. if(!projectReadOnly){
  73. me.loadMainContextMenu();
  74. me.loadDetailContextMenu();
  75. }
  76. else {
  77. if(me.mainSetting.view.lockColumns){
  78. me.mainSetting.view.lockColumns = null;
  79. }
  80. if(me.detailSetting.view.lockColumns){
  81. me.detailSetting.view.lockColumns = null;
  82. }
  83. disableSpread(me.mainSpread);
  84. disableSpread(me.detailSpread);
  85. }
  86. },
  87. getStdCalcProgramFiles: function(){
  88. function getStdCPFilesHtml(stdCPLibs) {
  89. let result = '<option value="">请选择计算程序标准库</option>';
  90. if (stdCPLibs.length <= 0) {
  91. return result;
  92. };
  93. for (let lib of stdCPLibs){
  94. result += '<option value='+ lib.id +'>'+ lib.name +'</option>';
  95. };
  96. return result;
  97. };
  98. let stdCPHtml = getStdCPFilesHtml(projectInfoObj.projectInfo.engineeringInfo.program_lib);
  99. $("#calcProgramFileSelect").html(stdCPHtml);
  100. },
  101. onMainEnterCell: function(sender, args) {
  102. var me = calcProgramManage;
  103. var row = args.sheet.getActiveRowIndex();
  104. me.detailSpread.suspendPaint();
  105. var dSheet = me.detailSpread.getSheet(0);
  106. var dData = me.datas[row].calcItems;
  107. dSheet.setRowCount(dData.length, GC.Spread.Sheets.SheetArea.viewport);
  108. sheetCommonObj.showData(dSheet, me.detailSetting, dData);
  109. customRowHeader(dSheet, dData.length);
  110. me.detailSpread.resumePaint();
  111. },
  112. onRangeChanged:function (sender,args) {
  113. let me = calcProgramManage;
  114. let editInfo= me.getSelectionInfo();
  115. let dataCode = me.detailSetting.header[args.col].dataCode;
  116. // if (args.action == GC.Spread.Sheets.RangeChangedAction.clear&&args.changedCells.length == 1) {//清除操作
  117. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {//清除操作
  118. if (dataCode == 'feeRate') {
  119. $.bootstrapLoading.start();
  120. projectObj.project.FeeRate.updateFeeRateFromCalc(null, editInfo);
  121. }
  122. else if (dataCode == 'displayFieldName'){
  123. $.bootstrapLoading.start();
  124. for (let cell of args.changedCells){
  125. let curCalcItem = editInfo.template.calcItems[cell.row];
  126. curCalcItem.fieldName = '';
  127. curCalcItem.displayFieldName = '';
  128. };
  129. let data = {
  130. 'projectID': projectObj.project.ID(),
  131. 'ID': editInfo.template.ID,
  132. 'calcItems': editInfo.template.calcItems
  133. };
  134. calcProgramManage.updateTemplate(data, function (rst) {
  135. if (rst){
  136. calcProgramManage.refreshDetailSheet();
  137. $.bootstrapLoading.end();
  138. }
  139. });
  140. }
  141. }
  142. },
  143. onDetailValueChanged: function(sender, args) {
  144. $.bootstrapLoading.start();
  145. let me = calcProgramManage;
  146. let editInfo= me.getSelectionInfo();
  147. let curCalcItem = editInfo.calcItem;
  148. let dataCode = me.detailSetting.header[args.col].dataCode;
  149. if (dataCode == 'feeRate') {
  150. projectObj.project.FeeRate.updateFeeRateFromCalc(args.newValue, editInfo);
  151. $.bootstrapLoading.end();
  152. return;
  153. }
  154. let template = me.getSelectionInfo().template;
  155. if (dataCode == 'displayFieldName') {
  156. if (curCalcItem.displayFieldName == args.newValue) {
  157. $.bootstrapLoading.end();
  158. return;
  159. }
  160. if (analyzer.fieldNameIsUsed(template, args.newValue)){
  161. let sheet = me.detailSpread.getActiveSheet();
  162. sheet.suspendEvent();
  163. sheet.setValue(args.row, args.col, args.oldValue);
  164. sheet.resumeEvent();
  165. $.bootstrapLoading.end();
  166. let s = hintBox.font(template.fieldNameTempUsed + 1);
  167. hintBox.infoBox('系统提示', `“${args.newValue}” 已被第 ${s} 行使用,不允许重复选择!`, 1);
  168. delete template.fieldNameTempUsed;
  169. return;
  170. }
  171. curCalcItem.fieldName = projectObj.project.calcProgram.compiledFeeTypeMaps[args.newValue];
  172. }
  173. else if (dataCode == 'dispExprUser'){ // 除非直接改单元格,弹窗不会走这里
  174. hintBox.infoBox('系统提示', '用户直接在sheet中修改了dispExprUser值,触发onDetailEditEnded事件。', 1);
  175. };
  176. curCalcItem[dataCode] = args.newValue;
  177. if (dataCode == 'name'){
  178. analyzer.refreshUsedCalcItemsStatement(template, curCalcItem);
  179. let data = {
  180. 'projectID': projectObj.project.ID(),
  181. 'ID': template.ID,
  182. 'calcItems': template.calcItems
  183. };
  184. calcProgramManage.updateTemplate(data, function (rst) {
  185. if (rst){
  186. calcProgramManage.refreshDetailSheet();
  187. $.bootstrapLoading.end();
  188. }
  189. });
  190. if (activeSubSheetIsCalcProgram())
  191. calcProgramObj.refreshCalcProgram(projectObj.project.mainTree.selected, 1);
  192. }
  193. else{
  194. let data = {
  195. 'projectID': projectObj.project.ID(),
  196. 'templatesID': template.ID,
  197. 'calcItem': curCalcItem
  198. };
  199. me.saveCalcItem(data, function (rst) {
  200. if (rst){
  201. let relationNodes = calcTools.getNodesByProgramID(template.ID);
  202. projectObj.project.calcProgram.calcNodesAndSave(relationNodes);
  203. $.bootstrapLoading.end();
  204. }
  205. });
  206. }
  207. },
  208. onDetailEnterCell: function (sender, args) {
  209. // for test.
  210. // let t = calcProgramManage.getSelectionInfo().template;
  211. // let c = calcProgramManage.getSelectionInfo().calcItem;
  212. // let lc = analyzer.calcItemLabourCoe(c);
  213. // c.dispExpr = analyzer.getDispExpr(c.expression, t);
  214. // c.dispExprUser = analyzer.getDispExprUser(c.dispExpr, lc);
  215. // c.compiledExpr = analyzer.getCompiledExpr(c.expression, lc);
  216. // let e = `ID:${c.ID} ${c.expression} ${c.dispExpr} ${c.dispExprUser} ${c.compiledExpr} ${c.custom}`;
  217. // projectObj.testDisplay('', e);
  218. },
  219. onClipboardPasting: function (sender, args) {
  220. args.cancel = true;
  221. },
  222. loadMainContextMenu: function () {
  223. $.contextMenu({
  224. selector: '#mainSpread',
  225. build: function ($trigger, e) {
  226. SheetDataHelper.safeRightClickSelection($trigger, e, calcProgramManage.mainSpread);
  227. },
  228. items: {
  229. "copyTemplate": {
  230. name: "另存为",
  231. icon: 'copy',
  232. callback: function (key, opt) {
  233. $.bootstrapLoading.start();
  234. let template = calcProgramManage.getSelectionInfo().template;
  235. let idx = calcProgramManage.mainSpread.getActiveSheet().getActiveRowIndex();
  236. let newTemplate = {};
  237. newTemplate.ID = analyzer.templateMaxID() + 1;
  238. newTemplate.name = analyzer.templateNewName(template.name);
  239. newTemplate.custom = true;
  240. newTemplate.calcItems = [];
  241. $.extend(true, newTemplate.calcItems, template.calcItems);
  242. let data = {
  243. 'projectID': projectObj.project.ID(),
  244. 'ID': newTemplate.ID,
  245. 'name': newTemplate.name,
  246. 'custom': newTemplate.custom,
  247. 'calcItems': template.calcItems
  248. };
  249. calcProgramManage.addTemplate(data, function (rst) {
  250. if (rst){
  251. let ts = projectObj.project.calcProgram.templates;
  252. ts.push(newTemplate);
  253. projectObj.project.calcProgram.compileTemplateMaps();
  254. projectObj.project.calcProgram.compileTemplate(newTemplate);
  255. calcProgramManage.buildSheet();
  256. calcProgramManage.mainSpread.getActiveSheet().setSelection(ts.length - 1, 0, 1, 1);
  257. calcProgramManage.refreshDetailSheet();
  258. }
  259. });
  260. $.bootstrapLoading.end();
  261. }
  262. },
  263. "reNameTemplate": {
  264. name: "重命名...",
  265. icon: 'edit',
  266. disabled: function () {
  267. let custom = calcProgramManage.getSelectionInfo().template.custom;
  268. let canReName = custom ? custom : false;
  269. return !canReName;
  270. },
  271. callback: function (key, opt) {
  272. $.bootstrapLoading.start();
  273. let template = calcProgramManage.getSelectionInfo().template;
  274. let idx = calcProgramManage.mainSpread.getActiveSheet().getActiveRowIndex();
  275. let newName = '';
  276. hintBox.valueBox('重命名', template.name, function () {
  277. newName = hintBox.value;
  278. if (!newName){
  279. hintBox.error(`名称不能为空!`);
  280. return false;
  281. };
  282. if (newName == template.name) {
  283. $.bootstrapLoading.end();
  284. return;
  285. }
  286. if (analyzer.templateNameIsExist(newName)){
  287. hintBox.error(`“${newName}” 已存在,请重新输入!`);
  288. return false;
  289. };
  290. template.name = newName;
  291. let data = {
  292. 'projectID': projectObj.project.ID(),
  293. 'ID': template.ID,
  294. 'name': template.name
  295. };
  296. calcProgramManage.updateTemplate(data, function (rst) {
  297. if (rst){
  298. projectObj.project.calcProgram.compileTemplateMaps();
  299. projectObj.mainController.refreshTreeNode(calcTools.getNodesByProgramID(template.ID));
  300. sheetCommonObj.showData(calcProgramManage.mainSpread.getSheet(0), calcProgramManage.mainSetting, calcProgramManage.datas);
  301. $.bootstrapLoading.end();
  302. }
  303. });
  304. });
  305. }
  306. },
  307. "spr1": '--------',
  308. "deleteTemplate": {
  309. name: '删除',
  310. icon: 'fa-remove',
  311. disabled: function () {
  312. let custom = calcProgramManage.getSelectionInfo().template.custom;
  313. let canDelete = custom ? custom : false;
  314. return !canDelete;
  315. },
  316. callback: function () {
  317. let template = calcProgramManage.getSelectionInfo().template;
  318. if (analyzer.templateIsUsed(template.ID)) {
  319. $.bootstrapLoading.end();
  320. hintBox.infoBox('系统提示', `计算模板“${template.name}”已被使用,不允许删除!`, 1);
  321. return;
  322. };
  323. hintBox.infoBox('系统提示', `确定要删除计算模板“${template.name}”吗?`, 2, cbYes);
  324. function cbYes() {
  325. let data = {
  326. 'projectID': projectObj.project.ID(),
  327. 'ID': template.ID
  328. };
  329. calcProgramManage.deleteTemplate(data, function (rst) {
  330. if (rst){
  331. let idx = calcProgramManage.mainSpread.getActiveSheet().getActiveRowIndex();
  332. projectObj.project.calcProgram.templates.splice(idx, 1);
  333. projectObj.project.calcProgram.compileTemplateMaps();
  334. calcProgramManage.buildSheet();
  335. calcProgramManage.mainSpread.getActiveSheet().setSelection(idx - 1, 0, 1, 1);
  336. calcProgramManage.refreshDetailSheet();
  337. }
  338. });
  339. };
  340. }
  341. }
  342. }
  343. });
  344. },
  345. loadDetailContextMenu: function () {
  346. $.contextMenu({
  347. selector: '#detailSpread',
  348. build: function ($triggerElement, event) {
  349. SheetDataHelper.safeRightClickSelection($triggerElement, event, calcProgramManage.detailSpread);
  350. },
  351. items: {
  352. "newCalcItem": {
  353. name: "插入行",
  354. icon: 'fa-sign-in',
  355. callback: function () {
  356. $.bootstrapLoading.start();
  357. let template = calcProgramManage.getSelectionInfo().template;
  358. let idx = calcProgramManage.detailSpread.getActiveSheet().getActiveRowIndex();
  359. let newItem = {};
  360. newItem.ID = analyzer.calcItemMaxID(template) + 1;
  361. // newItem.name = '新建';
  362. newItem.memo = '自定义';
  363. newItem.custom = true;
  364. newItem.expression = '0'; // 这里必须得有值,否则程序内部公式解析会出现诸多问题
  365. template.calcItems.splice(idx + 1, 0, newItem);
  366. let data = {
  367. 'projectID': projectObj.project.ID(),
  368. 'ID': template.ID,
  369. 'calcItems': template.calcItems
  370. };
  371. calcProgramManage.updateTemplate(data, function (rst) {
  372. if (rst){
  373. projectObj.project.calcProgram.compileTemplate(template);
  374. calcProgramManage.refreshDetailSheet();
  375. calcProgramManage.detailSpread.getActiveSheet().setSelection(idx + 1, 0, 1, 1);
  376. let relationNodes = calcTools.getNodesByProgramID(template.ID);
  377. projectObj.project.calcProgram.calcNodesAndSave(relationNodes);
  378. }
  379. });
  380. $.bootstrapLoading.end();
  381. }
  382. },
  383. "spr1": '--------',
  384. "deleteCalcItem": {
  385. name: '删除行',
  386. icon: 'fa-remove',
  387. callback: function () {
  388. $.bootstrapLoading.start();
  389. let template = calcProgramManage.getSelectionInfo().template;
  390. let idx = calcProgramManage.detailSpread.getActiveSheet().getActiveRowIndex();
  391. let item = template.calcItems[idx];
  392. if (item.fieldName == 'common'){
  393. $.bootstrapLoading.end();
  394. hintBox.infoBox('系统提示', `费用类别为“工程造价”的行不允许删除!`, 1);
  395. return;
  396. };
  397. if (analyzer.calcItemIsUsed(template, item)){
  398. $.bootstrapLoading.end();
  399. let s = hintBox.font(item.tempUsed + 1);
  400. hintBox.infoBox('系统提示', `第 ${idx + 1} 行“${item.name}”已被第 ${s} 行引用,不允许删除!`, 1);
  401. delete item.tempUsed;
  402. return;
  403. };
  404. hintBox.infoBox('系统提示', `确定要删除计算规则“${item.name}”吗?`, 2, cbYes);
  405. function cbYes() {
  406. template.calcItems.splice(idx, 1);
  407. let data = {
  408. 'projectID': projectObj.project.ID(),
  409. 'ID': template.ID,
  410. 'calcItems': template.calcItems
  411. };
  412. calcProgramManage.updateTemplate(data, function (rst) {
  413. if (rst){
  414. projectObj.project.calcProgram.compileTemplate(template);
  415. calcProgramManage.refreshDetailSheet();
  416. let relationNodes = calcTools.getNodesByProgramID(template.ID);
  417. projectObj.project.calcProgram.calcNodesAndSave(relationNodes);
  418. $.bootstrapLoading.end();
  419. }
  420. });
  421. };
  422. }
  423. }
  424. }
  425. });
  426. },
  427. saveCalcItem: function (data, callback) {//data
  428. CommonAjax.post('/calcProgram/saveCalcItem', data,
  429. function (result) {
  430. if(callback){
  431. callback(result);
  432. }
  433. }
  434. );
  435. },
  436. updateTemplate: function (data, callback) {
  437. CommonAjax.post('/calcProgram/updateTemplate', data,
  438. function (result) {
  439. if(callback){
  440. callback(result);
  441. }
  442. }
  443. );
  444. },
  445. addTemplate: function (data, callback) {
  446. CommonAjax.post('/calcProgram/addTemplate', data,
  447. function (result) {
  448. if(callback){
  449. callback(result);
  450. }
  451. }
  452. );
  453. },
  454. deleteTemplate: function (data, callback) {
  455. $.bootstrapLoading.start();
  456. CommonAjax.post('/calcProgram/deleteTemplate', data,
  457. function (result) {
  458. if(callback){
  459. callback(result);
  460. }
  461. $.bootstrapLoading.end();
  462. }
  463. );
  464. },
  465. getSelectionInfo:function () {
  466. var templateIndex = this.mainSpread.getActiveSheet().getActiveRowIndex();
  467. var dIndex = this.detailSpread.getActiveSheet().getActiveRowIndex();
  468. var info = {
  469. template:this.datas[templateIndex],
  470. calcItem:this.datas[templateIndex].calcItems[dIndex]
  471. }
  472. return info;
  473. },
  474. refreshDetailSheet:function () {
  475. var me = this;
  476. if(me.mainSpread && me.detailSpread){
  477. let mainRowIdx = me.mainSpread.getActiveSheet().getActiveRowIndex();
  478. let calcItems = me.datas[mainRowIdx].calcItems;
  479. let detailSheet = me.detailSpread.getActiveSheet();
  480. detailSheet.setRowCount(calcItems.length);
  481. sheetCommonObj.showData(detailSheet, me.detailSetting, calcItems);
  482. customRowHeader(detailSheet, calcItems.length);
  483. }
  484. }
  485. };
  486. $(document).ready(function(){
  487. $('#tab_calc_program_manage').on('shown.bs.tab', function (e) {
  488. sessionStorage.setItem('mainTab', '#tab_calc_program_manage');
  489. $(e.relatedTarget.hash).removeClass('active');
  490. if (!calcProgramManage.mainSpread)
  491. calcProgramManage.buildSheet()
  492. else
  493. calcProgramManage.mainSpread.refresh();
  494. });
  495. $("#calcProgramFileSelect").change(function() {
  496. // 取标准库数据过来显示。
  497. let libID = $(this).val();
  498. if (libID == ''){
  499. calcProgramManage.mainSpread.getSheet(0).setRowCount(0);
  500. calcProgramManage.detailSpread.getSheet(0).setRowCount(0);
  501. return false;
  502. };
  503. $.bootstrapLoading.start();
  504. libID = parseFloat(libID);
  505. let projectID = projectObj.project.ID();
  506. CommonAjax.post('/calcProgram/updateTemplateFile', {"projectID": projectID, "libID": libID}, function (data) {
  507. projectObj.project.calcProgram.datas.templates = data;
  508. projectObj.project.calcProgram.compileAllTemps();
  509. projectObj.project.calcProgram.calcAllNodesAndSave();
  510. calcProgramManage.buildSheet();
  511. $.bootstrapLoading.end();
  512. });
  513. });
  514. });