project_view.js 43 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939
  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 (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  20. calcProgramObj.showData(node);
  21. };
  22. //zhong 2017-9-1 特征及内容
  23. if(pageCCOprObj.active){
  24. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  25. if(node.sourceType === project.Bills.getSourceType()){
  26. pageCCOprObj.setCacheAndShow(node);
  27. }
  28. else{
  29. pageCCOprObj.clearData();
  30. }
  31. }
  32. },
  33. refreshBaseActn: function (tree) {
  34. let setButtonValid = function (valid, btn) {
  35. if (valid) {
  36. btn.removeClass('disabled');
  37. } else {
  38. btn.addClass('disabled');
  39. }
  40. };
  41. let selected = tree.selected, that = projectObj;
  42. let canUpLevel = function (node) {
  43. if (selected && selected.depth() > 0 && selected.canUpLevel()) {
  44. if (selected.sourceType === that.project.Bills.getSourceType()) {
  45. return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0);
  46. } else {
  47. return false;
  48. }
  49. } else {
  50. return false;
  51. }
  52. };
  53. let canDownLevel = function (node) {
  54. if (selected && selected.depth() > 0 && selected.canDownLevel()) {
  55. if (selected.sourceType === that.project.Bills.getSourceType()) {
  56. return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0);
  57. } else {
  58. return false;
  59. }
  60. } else {
  61. return false;
  62. }
  63. };
  64. let canDelete = function (node) {
  65. if (selected) {
  66. if (selected.sourceType === that.project.Bills.getSourceType()) {
  67. return !(selected.data.flagsIndex && selected.data.flagsIndex.fixed && selected.data.flagsIndex.fixed.flag > 0);
  68. } else {
  69. return true;
  70. }
  71. } else {
  72. return false;
  73. }
  74. };
  75. setButtonValid(canUpLevel(selected), $('#upLevel'));
  76. setButtonValid(canDownLevel(selected), $('#downLevel'));
  77. setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove'));
  78. setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove'));
  79. setButtonValid(canDelete(selected), $('#delete'));
  80. },
  81. checkCommonField: function (editingText, colSetting) {
  82. let value;
  83. if (colSetting.data.decimal) {
  84. value = Number(editingText);
  85. if (number_util.isNumber(value)) {
  86. if (colSetting.data.decimal) {
  87. value = value.toDecimal(colSetting.data.decimal);
  88. }
  89. } else {
  90. value = null;
  91. alert('当前输入的数据类型不正确,请重新输入。');
  92. }
  93. } else {
  94. value = editingText;
  95. }
  96. return value;
  97. },
  98. checkFormulaValidField: function (editingText, colSetting) {
  99. let value = Number(editingText);
  100. if (!value) {
  101. try {
  102. let exp = new Expression('');
  103. exp.Expression(editingText);
  104. value = Number(exp.Evaluate());
  105. } catch (error) {
  106. value = null;
  107. }
  108. }
  109. if (value!=undefined||value!=null) {
  110. if (colSetting.data.decimal) {
  111. value = value.toDecimal(colSetting.data.decimal);
  112. }
  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 === 'contain') {
  121. return this.checkFormulaValidField(editingText, colSetting);
  122. }
  123. else if (colSetting.data.field === 'programID') {
  124. return this.project.calcProgram.compiledTemplateMaps[editingText];
  125. }
  126. else if (colSetting.data.field === 'subType') {
  127. if (typeof(editingText) !== "number")
  128. return volumePriceMaps[editingText]
  129. else
  130. return editingText;
  131. }
  132. else {
  133. return this.checkCommonField(editingText, colSetting);
  134. }
  135. },
  136. /*updateAndReCalculate: function (node, fieldName, value) {
  137. let project = projectObj.project, calc = new BillsCalcHelper(project), nodes = [];
  138. let getNodes = function (node) {
  139. let cur = node, nodes = [];
  140. while (cur) {
  141. nodes.push(cur);
  142. cur = cur.parent;
  143. }
  144. return nodes;
  145. }
  146. if (value) {
  147. value = value.toDecimal(projectObj.project.Decimal.common.quantity);
  148. }
  149. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  150. calcFees.setFee(node.data, fieldName, value);
  151. calc.calcNode(node, true);
  152. nodes = getNodes(node);
  153. project.Bills.updateNodes(nodes, true);
  154. }
  155. else if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) {
  156. project.beginUpdate('VolumePrice_QuantityChange');
  157. project.VolumePrice.updateField(node.source, fieldName, value, false);
  158. calc.calcNode(node.parent, true);
  159. nodes = getNodes(node.parent);
  160. project.Bills.updateNodes(nodes, false);
  161. project.endUpdate();
  162. nodes.push(node);
  163. }
  164. else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
  165. project.beginUpdate('Ration_QuantityChange');
  166. calcFees.setFee(node.data, fieldName, value);
  167. node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID);
  168. // calcProgram.calculate的传参必须是cacheNode类型,故无法将计算放在Ration模块中。
  169. project.calcProgram.calculate(node);
  170. project.Ration.updateRation(node.source, false); // 加入待存储队列
  171. calc.calcNode(node.parent, true); //
  172. nodes = getNodes(node.parent);
  173. project.Bills.updateNodes(nodes, false);
  174. project.endUpdate();
  175. nodes.push(node);
  176. }
  177. this.mainController.refreshTreeNode(nodes, false);
  178. calc = null;
  179. },*/
  180. updateBillsCode: function (node, value) {
  181. let project = projectObj.project;
  182. let stdMatchCode, formatCode, matchs;
  183. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  184. let orgCode = node.data.code.substr(0, 9);
  185. if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
  186. project.Bills.updateField(node.source, 'code', formatCode, true);
  187. projectObj.mainController.refreshTreeNode([node], false);
  188. } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
  189. let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
  190. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  191. if (data) {
  192. data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
  193. if (/\//.test(data.unit)) {
  194. ConfirmModal.stdBillsUnit.check(data, function (std) {
  195. project.Bills.replaceBills(node.source, std, formatCode);
  196. projectObj.mainController.refreshTreeNode([node], false);
  197. }, function () {
  198. projectObj.mainController.refreshTreeNode([node], false);
  199. });
  200. } else {
  201. project.Bills.replaceBills(node.source, data, formatCode);
  202. projectObj.mainController.refreshTreeNode([node], false);
  203. }
  204. } else {
  205. project.Bills.updateField(node.source, 'code', formatCode, true);
  206. projectObj.mainController.refreshTreeNode([node], false);
  207. }
  208. });
  209. }
  210. }
  211. if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
  212. stdMatchCode = value;
  213. formatCode = project.Bills.newFormatCode(stdMatchCode);
  214. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  215. } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
  216. stdMatchCode = value.substr(0, 9);
  217. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  218. if (matchs.indexOf(value) === -1) {
  219. searchStdBillsAndUpdate(stdMatchCode, value);
  220. } else if (confirm('已存在该编码的清单,是否继续?')) {
  221. formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  222. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  223. }
  224. } else {
  225. project.Bills.updateField(node.source, 'code', value, true);
  226. this.mainController.refreshTreeNode([node], false);
  227. }
  228. },
  229. updateRationCode: function (node, value) {
  230. if (/[\w]{2}[\d]{4}/.test(value)) {
  231. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  232. alert('当前项目无定额库,请添加定额库。');
  233. this.mainController.refreshTreeNode([node], false);
  234. } else {
  235. let libId = projectInfoObj.projectInfo.engineeringInfo.ration_lib[0].id;
  236. CommonAjax.postRationLib('/rationRepository/api/matchRation', {user_id: userID, rationLibId: libId, code: value}, function (data) {
  237. if (data) {
  238. projectObj.project.Ration.replaceRation(node.source, data);
  239. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  240. } else {
  241. alert('当前库中找不到定额"' + value + '"');
  242. }
  243. projectObj.mainController.refreshTreeNode([node], false);
  244. });
  245. }
  246. } else {
  247. alert('输入的定额编码有误,请检查。');
  248. this.mainController.refreshTreeNode([node], false);
  249. }
  250. },
  251. updateCode: function (node, value) {
  252. let project = projectObj.project;
  253. if (node.sourceType === project.Bills.getSourceType()) {
  254. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  255. } else if (node.sourceType === project.Ration.getSourceType()) {
  256. this.updateRationCode(node, value); // 新套定额适合实时计算
  257. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  258. /*project.calcProgram.calculate(node);
  259. project.calcProgram.saveNode(node);
  260. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  261. calcProgramObj.showData(node, false);
  262. };*/
  263. }
  264. },
  265. updateCellValue: function (node, value, colSetting) {
  266. let project = projectObj.project, fieldName = colSetting.data.field;
  267. if(node.sourceType==project.ration_glj.getSourceType()){
  268. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  269. }else if(node.sourceType==ModuleNames.ration&&node.data.type==rationType.gljRation){
  270. gljOprObj.updateRationTypeGLJ(value,node,fieldName);
  271. } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  272. if (fieldName === 'code' && !project.calcProgram.isVolumePrice(node)) {
  273. projectObj.updateCode(node, value);
  274. }
  275. else if(fieldName ==='feeRate'){
  276. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  277. }else if(fieldName ==='contain'){//编辑含量
  278. project.Ration.updateContain(value,node);
  279. }
  280. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
  281. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'feesIndex.common.unitFee'){
  282. if (fieldName === 'quantity') {
  283. project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName);
  284. return;
  285. }
  286. else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee') {
  287. if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
  288. }
  289. else if (fieldName === 'calcBase') {
  290. //zhong
  291. if(value === undefined ||value === null || value.toString().trim() === ''){
  292. value = '';
  293. }
  294. node.data.userCalcBase = value;
  295. project.calcBase.calculate(node);
  296. if(!project.calcBase.success){
  297. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  298. projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: '');
  299. return;
  300. }
  301. // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
  302. };
  303. node.changed = true;
  304. if (fieldName == 'feesIndex.common.unitFee'){
  305. project.calcProgram.initFeeField(node, 'common');
  306. node.data.feesIndex.common.unitFee = value;
  307. }
  308. else node.data[fieldName] = value;
  309. project.calcProgram.calculate(node);
  310. project.calcProgram.saveNode(node);
  311. gljOprObj.showRationGLJSheetData();
  312. }
  313. else {
  314. if (node.sourceType === project.Bills.getSourceType()) {
  315. project.Bills.updateField(node.source, fieldName, value, true);
  316. }
  317. else if (node.sourceType === project.Ration.getSourceType()) {
  318. project.Ration.updateField(node.source, fieldName, value, true);
  319. };
  320. if (colSetting.data.wordWrap) {
  321. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  322. }
  323. projectObj.mainController.refreshTreeNode([node]);
  324. }
  325. } else if(value==null && fieldName ==='feeRate'){
  326. project.FeeRate.cleanFeeRateID(node);
  327. } else {
  328. projectObj.mainController.refreshTreeNode([node], false);
  329. }
  330. },
  331. mainSpreadLeaveCell: function (sender, info) {
  332. let colSetting = projectObj.mainController.setting.cols[info.col];
  333. projectObj.lastCol = colSetting;
  334. },
  335. mainSpreadEnterCell: function (sender, info) {
  336. let colSetting = projectObj.mainController.setting.cols[info.col];
  337. if(colSetting.data.field === 'unit' || projectObj.lastCol.data.field === 'unit'||colSetting.data.field ==='subType'|| projectObj.lastCol.data.field === 'subType'){
  338. info.sheet.repaint();
  339. }
  340. },
  341. mainSpreadEditEnded: function (sender, info) {
  342. let project = projectObj.project;
  343. let node = project.mainTree.items[info.row];
  344. let colSetting = projectObj.mainController.setting.cols[info.col];
  345. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  346. // 检查输入类型等
  347. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  348. projectObj.updateCellValue(node, value, colSetting);
  349. // 自动行高
  350. const autoHeight = project.property.displaySetting.autoHeight;
  351. if (autoHeight) {
  352. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  353. }
  354. },
  355. mainSpreadRangeChanged: function (sender, info) {
  356. let project = projectObj.project, setting = projectObj.mainController.setting;
  357. if (info.changedCells.length > 0) {
  358. for (let changedCell of info.changedCells) {
  359. let cell = info.sheet.getCell(changedCell.row, changedCell.col);
  360. let node = project.mainTree.items[changedCell.row];
  361. let colSetting = setting.cols[changedCell.col];
  362. let value = projectObj.checkSpreadEditingText(cell.text(), colSetting);
  363. projectObj.updateCellValue(node, value, colSetting);
  364. }
  365. }
  366. },
  367. checkMainSpread: function () {
  368. if (!this.mainSpread) {
  369. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  370. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  371. }
  372. },
  373. refreshMainSpread: function () {
  374. if (this.mainSpread) {
  375. this.mainSpread.refresh();
  376. }
  377. },
  378. loadProjectData: function () {
  379. var that = this;
  380. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  381. let startTime = +new Date();
  382. console.log("开始加载-----"+startTime);
  383. this.project.loadDatas(function (err) {
  384. if (!err) {
  385. that.project.projectGLJ.calcQuantity();//计算分部分项和技术措施项目消耗量;
  386. that.project.property = projectInfoObj.projectInfo.property;
  387. //that.project.calcProgram.compileAllTemps();
  388. that.project.calcBase.init(that.project);
  389. that.project.calcFields = JSON.parse(JSON.stringify(feeType));
  390. // that.project.initCalcFields();
  391. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  392. that.project.projSetting.mainGridSetting = JSON.parse(str);
  393. that.project.projSetting.mainGridSetting.frozenCols = 4;
  394. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  395. const autoHeight = that.project.property.displaySetting !== undefined ?
  396. that.project.property.displaySetting.autoHeight : false;
  397. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  398. // for test. 后端没有绑定,暂时写死用于测试。
  399. /* if (col.data.field == '' && col.head.titleNames[0] == "取费专业") {
  400. col.data.field = 'programID';
  401. col.data.getText = 'getText.calcProgramName';
  402. col.data.cellType = 'cellType.calcProgramName';
  403. };*/
  404. col.data.splitFields = col.data.field.split('.');
  405. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  406. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  407. }
  408. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  409. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  410. }
  411. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  412. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  413. col.data.cellType = getCellType;
  414. }
  415. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  416. // col.data.decimal = that.project.getDecimal(col.data.digit);
  417. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  418. // }
  419. if (col.data.field === 'code') {
  420. col.data.formatter = '@';
  421. }
  422. // 根据配置设置自动行高
  423. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  424. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  425. if (!autoHeight) {
  426. col.showHint = true;
  427. col.data.wordWrap = false;
  428. } else {
  429. col.showHint = false;
  430. col.data.wordWrap = true;
  431. }
  432. }
  433. if(col.data.field ==='quantity'){
  434. col.showHint = true;
  435. }
  436. // for test digit. CSLAAAAA
  437. if (col.data.field.hasSubStr("totalFee"))
  438. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, false)
  439. else if (col.data.field.hasSubStr("unitFee"))
  440. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, false)
  441. else if (col.data.field == "quantity")
  442. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.quantity, false);
  443. });
  444. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  445. that.mainController.showTreeData();
  446. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  447. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  448. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  449. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  450. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  451. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  452. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  453. that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
  454. that.loadMainSpreadContextMenu();
  455. that.loadFocusLocation();
  456. let endTime = +new Date();
  457. console.log("加载完成-----"+endTime);
  458. }
  459. else {
  460. }
  461. });
  462. },
  463. loadMainSpreadContextMenu: function () {
  464. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  465. $.contextMenu({
  466. selector: '#billsSpread',
  467. build: function ($trigger, e) {
  468. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  469. controller.setTreeSelected(controller.tree.items[target.row]);
  470. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  471. },
  472. items: {
  473. "insertRootBill": {
  474. name: "插入大项费用",
  475. icon: 'fa-sign-in',
  476. disabled: function () {
  477. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  478. },
  479. callback: function (key, opt) {
  480. ProjectController.addRootBill(project, controller);
  481. },
  482. visible: function(key, opt){
  483. return false;//project.mainTree.selected&&project.mainTree.selected.parent ==null;;
  484. }
  485. },
  486. "insertBills": {
  487. name: "插入清单",
  488. icon: 'fa-sign-in',
  489. disabled: function () {
  490. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  491. },
  492. callback: function (key, opt) {
  493. ProjectController.addBills(project, controller);
  494. }
  495. },
  496. "insertRation": {
  497. name: "插入定额",
  498. icon: 'fa-sign-in',
  499. disabled: function () {
  500. var selected = project.mainTree.selected;
  501. if (selected) {
  502. if ( // CSL, 2017-11-28
  503. selected.sourceType === project.Ration.getSourceType() ||
  504. (selected.sourceType === project.Bills.getSourceType() && selected.source.children.length === 0)
  505. ) return false
  506. else return true
  507. } else return true
  508. },
  509. callback: function (key, opt) {
  510. ProjectController.addRation(project, controller, rationType.ration);
  511. }
  512. },
  513. "insertLJ": {
  514. name: "插入量价",
  515. icon: 'fa-sign-in',
  516. disabled: function () {
  517. var selected = project.mainTree.selected;
  518. if (selected) {
  519. if ( // CSL, 2017-11-28
  520. selected.sourceType === project.Ration.getSourceType() ||
  521. (selected.sourceType === project.Bills.getSourceType() && selected.source.children.length === 0)
  522. ) return false
  523. else return true
  524. } else return true
  525. },
  526. callback: function (key, opt) {
  527. ProjectController.addRation(project, controller, rationType.volumePrice);
  528. }
  529. },
  530. "insertGLJ": {
  531. name: "插入工料机",
  532. icon: 'fa-sign-in',
  533. disabled: function () {
  534. var selected = project.mainTree.selected;
  535. var readOnly = MainTreeCol.readOnly;
  536. return readOnly.billsParent(selected)||(readOnly.bills(selected)&&!readOnly.forCalcBase(selected))||readOnly.glj(selected);
  537. },
  538. callback: function (key, opt) {
  539. getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
  540. }
  541. },
  542. "spr1": '--------',
  543. "delete": {
  544. name: '删除',
  545. icon: 'fa-remove',
  546. disabled: function () {
  547. var selected = project.mainTree.selected;
  548. return !selected;
  549. },
  550. callback: function () {
  551. var selected = controller.tree.selected, parent = selected.parent;
  552. if (selected) {
  553. if (selected.sourceType === project.Bills.getSourceType()) {
  554. project.Bills.deleteBills(selected.source);
  555. controller.delete();
  556. } else if (selected.sourceType === project.Ration.getSourceType()) {
  557. project.Ration.delete(selected.source);
  558. controller.delete();
  559. };
  560. projectObj.converseCalculateBills(parent);
  561. }
  562. }
  563. },
  564. "spr2":'--------',
  565. "calculateAll_RationContent": {
  566. name: '造价计算',
  567. callback: function () {
  568. let changedNodes = project.calcProgram.calcAllNodes();
  569. project.calcProgram.saveNodes(changedNodes);
  570. }
  571. }
  572. }
  573. });
  574. },
  575. // 计算node及node的所有父项
  576. converseCalculateBills: function (node) {
  577. /* if (node) {
  578. let calc = new BillsCalcHelper(this.project);
  579. calc.calcNode(node, true);
  580. let cur = node, nodes = [];
  581. while (cur) {
  582. nodes.push(cur);
  583. cur = cur.parent;
  584. }
  585. this.mainController.refreshTreeNode(nodes, false);
  586. this.project.Bills.updateNodes(nodes, true);
  587. calc = null;
  588. }*/
  589. projectObj.project.calcProgram.calculate(node);
  590. projectObj.project.calcProgram.saveNode(node);
  591. },
  592. // 计算全部清单
  593. /* calculateAll: function () {
  594. let calc = new BillsCalcHelper(this.project);
  595. calc.calcAll();
  596. this.mainController.showTreeData();
  597. this.project.Bills.updateAll();
  598. calc = null;
  599. }*/
  600. // 获取上次退出时的焦点位置
  601. loadFocusLocation: function() {
  602. const projectId = scUrlUtil.GetQueryString('project');
  603. let row = getLocalCache('lastRow:' + projectId);
  604. let col = getLocalCache('lastCol:' + projectId);
  605. if (row !== null && col !== null) {
  606. row = parseInt(row);
  607. col = parseInt(col);
  608. const sheet = this.mainSpread.getActiveSheet();
  609. sheet.setSelection(row, col, 1, 1);
  610. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  611. }
  612. },
  613. // 选中区域合计数字
  614. amountAreaNumber: function(e, info) {
  615. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  616. return false;
  617. }
  618. const selectedArea = info.newSelections[0];
  619. const sheet = info.sheet;
  620. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  621. return false;
  622. }
  623. // 获取鼠标位置
  624. let x = window.event.clientX;
  625. let y = window.event.clientY;
  626. // 匹配数字或小数
  627. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  628. // 小数点最高位数
  629. let max = 0;
  630. let total = 0;
  631. let counter = 0;
  632. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  633. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  634. const value = sheet.getCell(row, col).text();
  635. if (!regular.test(value)) {
  636. continue;
  637. }
  638. counter++;
  639. // 获取当前数据小数位数
  640. let pointPosition = value.toString().indexOf(".");
  641. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  642. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  643. max = current > max ? current : max;
  644. total += parseFloat(value);
  645. }
  646. }
  647. // 如果不为0则悬浮显示
  648. if (total > 0 && counter > 1) {
  649. const div = $('<div id="total-tips"><p>合计: <input type="text" id="total" readonly="readonly" style="border: none;"/></p><p><a href="javascript:void(0);">复制</a></p></div>');
  650. div.css({
  651. position: "absolute",
  652. border: "1px #C0C0C0 solid",
  653. background: "#fff",
  654. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  655. });
  656. div.children("p").css({
  657. textAlign: "center",
  658. padding: 8,
  659. marginBottom: 2,
  660. });
  661. div.children("p").first().css({
  662. borderBottom: "1px #C0C0C0 solid"
  663. });
  664. const totalString = total.toFixed(max);
  665. // input长度
  666. const inputWidth = totalString.length * 8;
  667. // 计算是否会超出显示范围
  668. const baseWidth = 48;
  669. const baseHeight = 81;
  670. const canvasWidth = $("#billsSpreadvp_vp").width();
  671. const canvasHeight = $("#billsSpreadvp_vp").height();
  672. x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  673. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  674. div.css({
  675. left: x,
  676. top: y,
  677. });
  678. div.children().children("#total").width(inputWidth).val(totalString);
  679. $("body").append(div);
  680. // 用于判断是否要关闭窗体
  681. setTimeout(function() {
  682. isTotalShowing = true;
  683. }, 200);
  684. };
  685. }
  686. };
  687. // 点击合计框中的复制
  688. $("body").on("click", "#total-tips a", function() {
  689. const totalElement = $(this).parent().siblings("p").find("#total");
  690. totalElement.select();
  691. document.execCommand("Copy");
  692. $(this).text("已复制");
  693. });
  694. // 合计框点击其他位置关闭
  695. let isTotalShowing = false;
  696. $("body").on("click", function(e) {
  697. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  698. $("#total-tips").remove();
  699. isTotalShowing = false;
  700. }
  701. });
  702. $('#insert').click(function () {
  703. var controller = projectObj.mainController, project = projectObj.project;
  704. var selected = controller.tree.selected;
  705. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  706. ProjectController.addBills(project, controller);
  707. } else if (selected.sourceType === project.Ration.getSourceType()) {
  708. ProjectController.addRation(project, controller, selected.data.type);
  709. }
  710. });
  711. $('#delete').click(function () {
  712. var controller = projectObj.mainController, project = projectObj.project;
  713. var selected = controller.tree.selected, parent = selected.parent;
  714. if (selected) {
  715. if (selected.sourceType === project.Bills.getSourceType()) {
  716. project.Bills.deleteBills(selected.source);
  717. controller.delete();
  718. } else if (selected.sourceType === project.Ration.getSourceType()) {
  719. project.Ration.delete(selected.source);
  720. controller.delete();
  721. }else if(selected.sourceType==ModuleNames.ration_glj){
  722. project.ration_glj.updataOrdelete(selected.source);
  723. };
  724. projectObj.converseCalculateBills(parent);
  725. }
  726. });
  727. $('#upLevel').click(function () {
  728. var controller = projectObj.mainController, project = projectObj.project;
  729. var selected = controller.tree.selected, orgParent = selected.parent;
  730. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  731. project.Bills.upLevelBills(selected.source);
  732. controller.upLevel();
  733. projectObj.converseCalculateBills(orgParent);
  734. }
  735. });
  736. $('#downLevel').click(function () {
  737. var controller = projectObj.mainController, project = projectObj.project;
  738. var selected = controller.tree.selected;
  739. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  740. project.Bills.downLevelBills(selected.source);
  741. controller.downLevel();
  742. projectObj.converseCalculateBills(selected.parent);
  743. }
  744. });
  745. $('#upMove').click(function () {
  746. var controller = projectObj.mainController, project = projectObj.project;
  747. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  748. if (selected.sourceType === project.Bills.getSourceType()) {
  749. project.Bills.upMoveBills(selected.source);
  750. controller.upMove();
  751. } else if (selected.sourceType === project.Ration.getSourceType()) {
  752. project.Ration.changePos(selected.source, selected.preSibling.source);
  753. controller.upMove();
  754. };
  755. });
  756. $('#downMove').click(function () {
  757. var controller = projectObj.mainController, project = projectObj.project;
  758. var selected = controller.tree.selected, next, nextSerialNo;
  759. if (selected) {
  760. if (selected.sourceType === project.Bills.getSourceType()) {
  761. project.Bills.downMoveBills(selected.source);
  762. controller.downMove();
  763. } else if (selected.sourceType === project.Ration.getSourceType()) {
  764. project.Ration.changePos(selected.source, selected.nextSibling.source);
  765. controller.downMove();
  766. };
  767. }
  768. });
  769. $('#poj-set').on('show.bs.modal', function () {
  770. let setCalcFlag = function (obj, val, curFlag) {
  771. obj.val(val);
  772. if (val === curFlag) {
  773. obj.attr('checked', true);
  774. } else {
  775. obj.removeAttr('checked');
  776. }
  777. }
  778. if (projectObj.project) {
  779. // let mode = projectObj.project.projSetting.billsCalcMode;
  780. // let settingConst = projectObj.project.projSetting.settingConst;
  781. let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
  782. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  783. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  784. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  785. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  786. // mode = projectObj.project.projSetting.zanguCalcType;
  787. let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  788. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  789. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  790. }
  791. });
  792. $('#property_ok').click(function () {
  793. let project = projectObj.project,
  794. projectID = project.ID(),
  795. properties = {},
  796. labourCoes = {},
  797. rations = [],
  798. bills = [],
  799. mixDatas = {
  800. projectID: projectID,
  801. updateType: 'update',
  802. properties: properties,
  803. labourCoes: labourCoes,
  804. rations: rations,
  805. bills: bills
  806. },
  807. reCalcBills= false,
  808. reCalcRations= false;
  809. let b = parseInt($("input[name='calcFlag']:checked").val());
  810. if (b !== project.property.billsCalcMode) {
  811. properties['property.billsCalcMode'] = b;
  812. project.property.billsCalcMode = b;
  813. reCalcBills = true;
  814. };
  815. let zg = parseInt($("input[name='zangu']:checked").val());
  816. if (zg !== project.property.zanguCalcMode) {
  817. properties['property.zanguCalcMode'] = zg;
  818. project.property.zanguCalcMode = zg;
  819. reCalcBills = true;
  820. };
  821. //基本信息
  822. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  823. properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
  824. }
  825. //工程特征
  826. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  827. properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
  828. }
  829. //清单工程量精度
  830. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  831. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  832. billsQuanDecimal.datas = newBillsDecimalDatas;
  833. reCalcBills = true;
  834. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  835. }
  836. //小数位数
  837. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  838. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  839. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  840. setDecimal(decimalObj, updateDecimal);
  841. if (frChanged) {
  842. project.calcProgram.compileAllTemps()
  843. }
  844. reCalcRations = true;
  845. reCalcBills = true;
  846. properties['property.decimal'] = updateDecimal;
  847. }
  848. // 呈现选项
  849. projDisplayView.updateChecking(properties);
  850. if(calcOptions.updateChecking(properties)){
  851. reCalcRations = true;
  852. }
  853. // 人工系数
  854. if (labourCoeView.needSave()){
  855. let libID = $("#std_labour_coe_files").children("option:selected").val();
  856. let libName = $("#std_labour_coe_files").children("option:selected").text();
  857. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  858. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  859. project.calcProgram.compileAllTemps();
  860. reCalcRations = true;
  861. reCalcBills = true;
  862. };
  863. // 重新计算树节点
  864. let changedNodes = [];
  865. if (reCalcRations) // 定额动,全部计算。
  866. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  867. else if (reCalcBills) // 清单动,可以只计算清单。
  868. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  869. if (changedNodes.length > 0) {
  870. for (let node of changedNodes){
  871. let data = {
  872. // projectID: projectID,
  873. ID: node.data.ID,
  874. quantity: node.data.quantity,
  875. calcBase: node.data.calcBase,
  876. calcBaseValue: node.data.calcBaseValue,
  877. marketUnitFee: node.data.marketUnitFee,
  878. marketTotalFee: node.data.marketTotalFee,
  879. fees: node.data.fees,
  880. feeRate: node.data.feeRate,
  881. feeRateID: node.data.feeRateID
  882. };
  883. if (node.sourceType == 'ration'){
  884. rations.push(data);
  885. }
  886. else if (node.sourceType == 'bills'){
  887. bills.push(data);
  888. };
  889. };
  890. };
  891. // for test.
  892. /* console.log(mixDatas);
  893. return; */
  894. function hasMixData() {
  895. return Object.keys(mixDatas.properties).length > 0 ||
  896. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  897. }
  898. if(hasMixData()){
  899. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  900. /* if (changedNodes.length > 0) {
  901. for (let node of changedNodes){delete node.changed};
  902. };
  903. if (mixDatas.labourCoes.updateData) labourCoeView.refresh();*/
  904. window.location.href = '/main?project=' + projectID;
  905. });
  906. }
  907. });