project_view.js 68 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525
  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. // CSL, 2018-02-09 用于测试显示。使用示例:projectObj.testDisplay(‘总额’, 100);
  15. testDisplay: function (caption, value) {
  16. let s = `          [ ${caption}: ${value} ]`;
  17. $('#testDisplay').html(s);
  18. },
  19. treeSelectedChanged: function (node) {
  20. let project = projectObj.project;
  21. subViewObj.loadComments(node);
  22. gljOprObj.showDataIfRationSelect(node);
  23. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  24. calcProgramObj.showData(node);
  25. };
  26. //zhong 2017-9-1 特征及内容
  27. if(pageCCOprObj.active){
  28. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  29. if(node.sourceType === project.Bills.getSourceType()){
  30. pageCCOprObj.setCacheAndShow(node);
  31. }
  32. else{
  33. pageCCOprObj.clearData();
  34. }
  35. }
  36. // for test interface. CSLAAAAA
  37. // projectObj.testDisplay('前四项累计值排除当前选中项' + projectObj.project.calcProgram.getBeforeTaxTotalFee([node]));
  38. // 公式结果
  39. /* let t = projectObj.project.calcProgram.compiledTemplates[node.data.programID];
  40. let c = t.calcItems[7];
  41. c.dispExpr = '[定额基价人工费] + [定额基价材料费] + F6 + [主材费]';
  42. let rst = analyzer.analyzeUserExpr(t, c);
  43. projectObj.testDisplay('结果', rst);*/
  44. // 基数
  45. // node.data.isSubcontract = true;
  46. node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID);
  47. let bname = '甲供定额基价材料费';
  48. projectObj.testDisplay(bname, rationCalcBases[bname](node));
  49. },
  50. refreshBaseActn: function (tree) {
  51. let setButtonValid = function (valid, btn) {
  52. if (valid) {
  53. btn.removeClass('disabled');
  54. } else {
  55. btn.addClass('disabled');
  56. }
  57. };
  58. let selected = tree.selected, that = projectObj;
  59. let canUpLevel = function (node) {
  60. if(!node){
  61. return false;
  62. }
  63. if(node.depth()<=1){//焦点行是树结构的第一/二层节点,灰显。
  64. return false;
  65. }
  66. if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机,灰显。
  67. return false;
  68. }else {
  69. if(node.data.type == billType.FX){//是分项,灰显。
  70. return false;
  71. }
  72. if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟,有子项.
  73. if(node.children[0].data.type==billType.FX){ //焦点行子项是分项
  74. return false;
  75. }
  76. }
  77. if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
  78. if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
  79. return false;
  80. }
  81. if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
  82. return false;
  83. }
  84. }
  85. }
  86. return true;
  87. };
  88. let canDownLevel = function (node) {
  89. if(!node){
  90. return false;
  91. }
  92. if(node.depth()==0){//焦点行是树结构的第一层节点,灰显。
  93. return false;
  94. }
  95. if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机,灰显。
  96. return false;
  97. }else {
  98. if(node.data.type == billType.FX){//是分项,灰显。
  99. return false;
  100. }
  101. if(!node.preSibling){//无前兄弟,灰显
  102. return false;
  103. }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
  104. return false
  105. }
  106. if(node.preSibling.children.length>0){//前兄弟有子项,子项是分项,灰显。
  107. if(node.data.type==billType.FB&&node.preSibling.children[0].data.type==billType.FX){//焦点行是分部前兄弟有子项,子项是分项,灰显。
  108. return false;
  109. }
  110. if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单,子项不是清单
  111. return false
  112. }
  113. }
  114. }
  115. return true;
  116. };
  117. let canUpMove = function (node) {
  118. if(node&&node.preSibling){//有前兄弟
  119. if(node.sourceType==that.project.Bills.getSourceType()&&node.data.type == billType.DXFY&&node.data.isAdd!==1){
  120. return false;
  121. }
  122. return true
  123. }
  124. return false
  125. };
  126. let canDownMove = function (node) {
  127. if(node&&node.nextSibling){
  128. if(node.sourceType==that.project.Bills.getSourceType()&&node.data.type == billType.DXFY&&node.data.isAdd!==1){
  129. return false;
  130. }
  131. return true;
  132. }
  133. return false
  134. };
  135. setButtonValid(ifCanDelete(), $('#delete'));
  136. setButtonValid(canUpLevel(selected), $('#upLevel'));
  137. setButtonValid(canDownLevel(selected), $('#downLevel'));
  138. setButtonValid(canUpMove(selected) , $('#upMove'));
  139. setButtonValid(canDownMove(selected), $('#downMove'));
  140. },
  141. checkCommonField: function (editingText, colSetting) {
  142. let value;
  143. if (colSetting.data.decimal) {
  144. value = Number(editingText);
  145. if (number_util.isNumber(value)) {
  146. if (colSetting.data.decimal) {
  147. value = value.toDecimal(colSetting.data.decimal);
  148. }
  149. } else {
  150. value = null;
  151. alert('当前输入的数据类型不正确,请重新输入。');
  152. }
  153. } else {
  154. value = editingText;
  155. }
  156. return value;
  157. },
  158. checkFormulaValidField: function (editingText, colSetting) {
  159. let value = Number(editingText);
  160. if (!value) {
  161. try {
  162. let exp = new Expression('');
  163. exp.Expression(editingText);
  164. value = Number(exp.Evaluate());
  165. } catch (error) {
  166. value = null;
  167. }
  168. }
  169. if (value!=undefined||value!=null) {
  170. if (colSetting.data.decimal) {
  171. value = value.toDecimal(colSetting.data.decimal);
  172. }
  173. } else if (editingText && editingText !== '') {
  174. value = null;
  175. alert('当前输入的数据类型不正确,请重新输入。');
  176. }
  177. return value;
  178. },
  179. checkSpreadEditingText: function (editingText, colSetting) {
  180. if (colSetting.data.field === 'quantity'||colSetting.data.field === 'contain') {
  181. return this.checkFormulaValidField(editingText, colSetting);
  182. }
  183. else if (colSetting.data.field === 'programID') {
  184. return this.project.calcProgram.compiledTemplateMaps[editingText];
  185. }
  186. else if (colSetting.data.field === 'subType') {
  187. if (typeof(editingText) !== "number")
  188. return volumePriceMaps[editingText]
  189. else
  190. return editingText;
  191. }
  192. else {
  193. return this.checkCommonField(editingText, colSetting);
  194. }
  195. },
  196. getVisibleRows: function (sRow, count) {
  197. let rst = [];
  198. let nodes = projectObj.project.mainTree.items;
  199. for(let i = sRow, len = nodes.length; i < len; i++){
  200. if(count <= 0){
  201. break;
  202. }
  203. if(nodes[i].visible){
  204. rst.push(i);
  205. count--;
  206. }
  207. }
  208. return rst;
  209. },
  210. //获取粘贴更改的单元格(粘贴时,跳过隐藏行)
  211. checkSpreadChangedCells: function (info) {
  212. let rst = {refreshRows: [], changedCells: []};
  213. //获取显示行号
  214. let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
  215. let vCount = vRows.length;
  216. let lastRow = null, count = 0;
  217. for(let cell of info.changedCells){
  218. cell.text = info.sheet.getCell(cell.row, cell.col).text();
  219. if(cell.row !== lastRow){
  220. count++;
  221. lastRow = cell.row;
  222. }
  223. if(count <= vCount){
  224. if(vRows[count - 1] !== cell.row){
  225. rst.refreshRows.push(cell.row);
  226. }
  227. rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
  228. }
  229. else {
  230. rst.refreshRows.push(cell.row);
  231. }
  232. }
  233. rst.refreshRows = Array.from(new Set(rst.refreshRows));
  234. return rst;
  235. },
  236. updateBillsCode: function (node, value) {
  237. let project = projectObj.project;
  238. let stdMatchCode, formatCode, matchs;
  239. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  240. let orgCode = node.data.code?node.data.code.substr(0, 9):"";
  241. if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
  242. project.Bills.updateField(node.source, 'code', formatCode, true);
  243. projectObj.mainController.refreshTreeNode([node], false);
  244. } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
  245. let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
  246. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  247. if (data) {
  248. //data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
  249. node.data.name = data.name;
  250. pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
  251. if (/\//.test(data.unit)) {
  252. let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
  253. if (existB) {
  254. data.unit = existB.unit;
  255. //
  256. project.Bills.replaceBills(node.source, data, formatCode);
  257. projectObj.mainController.refreshTreeNode([node], false);
  258. } else {
  259. ConfirmModal.stdBillsUnit.check(data, function (std) {
  260. project.Bills.replaceBills(node.source, std, formatCode);
  261. projectObj.mainController.refreshTreeNode([node], false);
  262. }, function () {
  263. projectObj.mainController.refreshTreeNode([node], false);
  264. });
  265. }
  266. } else {
  267. project.Bills.replaceBills(node.source, data, formatCode);
  268. projectObj.mainController.refreshTreeNode([node], false);
  269. }
  270. } else {
  271. project.Bills.updateField(node.source, 'code', formatCode, true);
  272. projectObj.mainController.refreshTreeNode([node], false);
  273. }
  274. });
  275. }
  276. }
  277. if(node.data.type==billType.FX||(node.data.type==billType.BILL&&node.source.children.length==0)){//是分项或者叶子清单的情况下才需要查找替换
  278. if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
  279. stdMatchCode = value;
  280. formatCode = project.Bills.newFormatCode(stdMatchCode);
  281. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  282. return;
  283. } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
  284. stdMatchCode = value.substr(0, 9);
  285. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  286. if (matchs.indexOf(value) === -1) {
  287. searchStdBillsAndUpdate(stdMatchCode, value);
  288. } else if (confirm('已存在该编码的清单,是否继续?')) {
  289. formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  290. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  291. return;
  292. }
  293. }
  294. }
  295. project.Bills.updateField(node.source, 'code', value, true);
  296. this.mainController.refreshTreeNode([node], false);
  297. },
  298. updateRationCode: function (node, value) {
  299. if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
  300. return;
  301. }
  302. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  303. alert('当前项目无定额库,请添加定额库。');
  304. this.mainController.refreshTreeNode([node], false);
  305. } else {
  306. let libId = parseInt($('#stdRationLibSelect').val());
  307. CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
  308. if (data) {
  309. projectObj.project.Ration.replaceRation(node.source, data);
  310. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  311. } else {
  312. alert('当前库中找不到定额"' + value + '"');
  313. }
  314. projectObj.mainController.refreshTreeNode([node], false);
  315. });
  316. }
  317. },
  318. updateCode: function (node, value) {
  319. let project = projectObj.project;
  320. if (node.sourceType === project.Bills.getSourceType()) {
  321. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  322. } else if (node.sourceType === project.Ration.getSourceType()) {
  323. project.Ration.updateRationCodes([{'node':node,value:value}]);
  324. // this.updateRationCode(node, value); // 新套定额适合实时计算
  325. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  326. /*project.calcProgram.calcAndSave(node);
  327. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  328. calcProgramObj.showData(node, false);
  329. };*/
  330. }
  331. },
  332. updateCellValue: function (node, value, colSetting,editingText) {
  333. let project = projectObj.project, fieldName = colSetting.data.field;
  334. if(node.sourceType==project.ration_glj.getSourceType()){
  335. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  336. }
  337. else if(calcTools.isGljRation(node)){
  338. gljOprObj.updateRationTypeGLJ(value,node,fieldName);
  339. }
  340. else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  341. if (fieldName === 'code' && !calcTools.isVolumePrice(node)) {
  342. projectObj.updateCode(node, value);
  343. }
  344. else if(fieldName ==='feeRate'){
  345. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  346. }
  347. else if(fieldName ==='contain'){//编辑含量
  348. project.Ration.updateContain(value,node);
  349. }
  350. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
  351. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
  352. if (fieldName === 'quantity') {
  353. project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
  354. return;
  355. }
  356. else if (fieldName === 'marketUnitFee') {
  357. if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
  358. }
  359. else if (fieldName === 'calcBase') {
  360. //zhong
  361. if(value === undefined ||value === null || value.toString().trim() === ''){
  362. value = '';
  363. }
  364. node.data.userCalcBase = value;
  365. project.calcBase.calculate(node);
  366. if(!project.calcBase.success){
  367. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  368. projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: '');
  369. return;
  370. }
  371. // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
  372. };
  373. //计算基数赋值要经过解析和标准化,已在calculate里赋值
  374. if(fieldName !== 'calcBase'){
  375. node.data[fieldName] = value;
  376. node.changed = true;
  377. }
  378. project.calcProgram.calcAndSave(node);
  379. gljOprObj.showRationGLJSheetData();
  380. }
  381. else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
  382. node.data[fieldName] = value;
  383. node.changed = true;
  384. if(node.data.quantity){
  385. node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  386. }
  387. project.calcProgram.calcAndSave(node);
  388. }
  389. else {
  390. if (node.sourceType === project.Bills.getSourceType()) {
  391. project.Bills.updateField(node.source, fieldName, value, true);
  392. }
  393. else if (node.sourceType === project.Ration.getSourceType()) {
  394. project.Ration.updateField(node.source, fieldName, value, true);
  395. };
  396. if (colSetting.data.wordWrap) {
  397. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  398. }
  399. projectObj.mainController.refreshTreeNode([node]);
  400. }
  401. }
  402. else if(value==null && fieldName ==='feeRate'){
  403. project.FeeRate.cleanFeeRateID(node);
  404. }
  405. else {
  406. projectObj.mainController.refreshTreeNode([node], false);
  407. }
  408. },
  409. mainSpreadLeaveCell: function (sender, info) {
  410. let colSetting = projectObj.mainController.setting.cols[info.col];
  411. projectObj.lastCol = colSetting;
  412. },
  413. //repaint 动态下拉框
  414. mainSpreadEnterCell: function (sender, info) {
  415. let colSetting = projectObj.mainController.setting.cols[info.col];
  416. if(colSetting.data.field === 'unit' || projectObj.lastCol.data.field === 'unit'||colSetting.data.field ==='subType'
  417. || projectObj.lastCol.data.field === 'subType' || colSetting.data.field === 'programID' ||projectObj.lastCol.data.field === 'programID'){
  418. info.sheet.repaint();
  419. }
  420. },
  421. mainSpreadEditStarting: function (sender, info) {
  422. let project = projectObj.project;
  423. let node = project.mainTree.items[info.row];
  424. if(isDef(node) && node.sourceType === project.Ration.getSourceType() && isDef(node.data.code) && isDef(node.data.from) && node.data.from === 'cpt'){
  425. let orgV = info.sheet.getValue(info.row, info.col);
  426. let newV = orgV.replace(new RegExp('补'), '');
  427. info.sheet.setValue(info.row, info.col, newV);
  428. }
  429. },
  430. onCellDoubleClick: function (sender, info){
  431. let project = projectObj.project;
  432. let node = project.mainTree.items[info.row];
  433. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  434. if(fieldName == 'marketUnitFee'){
  435. if(gljOprObj.hasComposition(node.data,true)){
  436. alert("当前工料机的市场价由组成物计算得出,不可直接修改。");
  437. return;
  438. }
  439. }
  440. },
  441. mainSpreadEditEnded: function (sender, info) {
  442. let project = projectObj.project;
  443. let node = project.mainTree.items[info.row];
  444. let colSetting = projectObj.mainController.setting.cols[info.col];
  445. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  446. // 检查输入类型等
  447. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  448. projectObj.updateCellValue(node, value, colSetting,info.editingText);
  449. // 自动行高
  450. const autoHeight = project.property.displaySetting.autoHeight;
  451. if (autoHeight) {
  452. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  453. }
  454. },
  455. msClipboardChanged: function (sender, info) {
  456. let colSettings = projectObj.mainController.setting.cols;
  457. let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
  458. sheetCommonObj.copyTextToClipboard(cDatas);
  459. return;
  460. },
  461. mainSpreadRangeChanged: function (sender, info) {
  462. let project = projectObj.project, setting = projectObj.mainController.setting;
  463. let changedObj = projectObj.checkSpreadChangedCells(info);
  464. let refreshNodes = [];
  465. for(let row of changedObj.refreshRows){
  466. refreshNodes.push(project.mainTree.items[row]);
  467. }
  468. let updateRationCodes = [];//更新定额编码时要用同步的方式
  469. if(changedObj.changedCells.length > 0){
  470. for (let changedCell of changedObj.changedCells) {
  471. let node = project.mainTree.items[changedCell.row];
  472. let colSetting = setting.cols[changedCell.col];
  473. let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
  474. if(colSetting.data.field=='code'&& node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
  475. updateRationCodes.push({'node':node,value:value});
  476. }else {
  477. projectObj.updateCellValue(node, value, colSetting,changedCell.text);
  478. }
  479. }
  480. }
  481. if(updateRationCodes.length>0){
  482. project.Ration.updateRationCodes(updateRationCodes);
  483. }
  484. if(refreshNodes.length > 0){
  485. projectObj.mainController.refreshTreeNode(refreshNodes);
  486. }
  487. },
  488. checkMainSpread: function () {
  489. if (!this.mainSpread) {
  490. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  491. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  492. this.mainSpread.getActiveSheet().name('mainSheet');
  493. }
  494. },
  495. refreshMainSpread: function () {
  496. if (this.mainSpread) {
  497. this.mainSpread.refresh();
  498. }
  499. },
  500. loadProjectData: function () {
  501. var that = this;
  502. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  503. let startTime = +new Date();
  504. console.log("开始加载-----"+startTime);
  505. this.project.loadDatas(function (err) {
  506. if (!err) {
  507. that.project.projectGLJ.calcQuantity();//计算分部分项和技术措施项目消耗量;
  508. that.project.property = projectInfoObj.projectInfo.property;
  509. //that.project.calcProgram.compileAllTemps();
  510. that.project.calcBase.init(that.project);
  511. // that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
  512. // that.project.initCalcFields();
  513. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  514. that.project.projSetting.mainGridSetting = JSON.parse(str);
  515. that.project.projSetting.mainGridSetting.frozenCols = 4;
  516. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  517. const autoHeight = that.project.property.displaySetting !== undefined ?
  518. that.project.property.displaySetting.autoHeight : false;
  519. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  520. col.data.splitFields = col.data.field.split('.');
  521. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  522. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  523. }
  524. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  525. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  526. }
  527. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  528. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  529. col.data.cellType = getCellType;
  530. }
  531. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  532. // col.data.decimal = that.project.getDecimal(col.data.digit);
  533. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  534. // }
  535. if (col.data.field === 'code') {
  536. col.data.formatter = '@';
  537. }
  538. // 根据配置设置自动行高
  539. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  540. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  541. if (!autoHeight) {
  542. col.showHint = true;
  543. col.data.wordWrap = false;
  544. } else {
  545. col.showHint = false;
  546. col.data.wordWrap = true;
  547. }
  548. }
  549. if(col.data.field ==='quantity'){
  550. col.showHint = true;
  551. }
  552. // 综合单价、综合合价,小数部分应补0对齐。 CSLAAAAA
  553. // if (col.data.field.hasSubStr("common")){
  554. if (col.data.field.hasSubStr(".totalFee"))
  555. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true)
  556. else if (col.data.field.hasSubStr(".unitFee"))
  557. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true)
  558. // }
  559. });
  560. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  561. that.mainController.showTreeData();
  562. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  563. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  564. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  565. that.mainSpread.getActiveSheet().startEdit();
  566. that.mainSpread.getActiveSheet().endEdit();
  567. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  568. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  569. that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);
  570. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  571. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  572. that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
  573. that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
  574. that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
  575. that.loadMainSpreadContextMenu();
  576. that.loadFocusLocation();
  577. let endTime = +new Date();
  578. socketObject.connect();//连接socket服务器
  579. console.log("加载完成-----"+endTime);
  580. console.log(`时间——${endTime - startTime}`);
  581. that.project.projectMarkChecking();//是否需要重新进行造价计算
  582. installationFeeObj.engineeringTypeChecking();//检查是否安装工程
  583. //初始需要触发一次点击表格事件,sheet.getAutoFitWidth值(获取单元格文本长度)才正确
  584. autoFlashHeight();
  585. projectObj.refreshMainSpread();
  586. }
  587. else {
  588. }
  589. });
  590. },
  591. loadMainSpreadContextMenu: function () {
  592. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  593. $.contextMenu({
  594. selector: '#billsSpread',
  595. build: function ($trigger, e) {
  596. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  597. controller.setTreeSelected(controller.tree.items[target.row]);
  598. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  599. },
  600. items: {
  601. "insertRootBill": {
  602. name: "插入大项费用",
  603. icon: 'fa-sign-in',
  604. disabled: function () {
  605. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  606. },
  607. callback: function (key, opt) {
  608. ProjectController.addRootBill(project, controller);
  609. },
  610. visible: function(key, opt){
  611. return project.mainTree.selected&&project.mainTree.selected.parent==null;
  612. }
  613. },
  614. "insertFB": {
  615. name: "插入分部",
  616. icon: 'fa-sign-in',
  617. disabled: function () {
  618. let selected = project.mainTree.selected;
  619. if(selected&&selected.sourceType==project.Bills.getSourceType()){
  620. if(selected.data.type==billType.FB){
  621. return false;
  622. }
  623. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  624. if(selected.children.length>0){
  625. return selected.children[0].data.type==billType.FX;//焦点行是分部分项工程,且子项是分项
  626. }else {
  627. return false
  628. }
  629. }
  630. }
  631. return true;//除了清单,其它类型都只读
  632. },
  633. callback: function (key, opt) {
  634. ProjectController.addFB(project, controller);
  635. },
  636. visible: function(key, opt){
  637. if(project.mainTree.selected){
  638. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  639. }else {
  640. return false;
  641. }
  642. }
  643. },
  644. "insertFX": {
  645. name: "插入分项",
  646. icon: 'fa-sign-in',
  647. disabled: function () {
  648. let selected = project.mainTree.selected;
  649. if(selected&&selected.sourceType==project.Bills.getSourceType()){
  650. if(selected.data.type==billType.FX){//焦点行是分项,有效显示
  651. return false
  652. }
  653. if(selected.data.type==billType.FB){//点行是分部,
  654. if(selected.children.length>0){//且有子项,子项是分部,灰显。
  655. return selected.children[0].data.type == billType.FB
  656. }else {
  657. return false;
  658. }
  659. }
  660. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  661. if(selected.children.length>0){
  662. return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
  663. }else {
  664. return false
  665. }
  666. }
  667. }
  668. return true;//除了清单,其它类型都只读
  669. },
  670. callback: function (key, opt) {
  671. ProjectController.addFX(project, controller);
  672. },
  673. visible: function(key, opt){
  674. if(project.mainTree.selected){
  675. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  676. }else {
  677. return false;
  678. }
  679. }
  680. },
  681. "insertBills": {
  682. name: "插入清单",
  683. icon: 'fa-sign-in',
  684. disabled: function () {
  685. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  686. },
  687. callback: function (key, opt) {
  688. if(project.mainTree.selected.data.type == billType.DXFY){
  689. if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
  690. alert("当前有基数计算不能插入子项。");
  691. return;
  692. }
  693. }
  694. ProjectController.addBills(project, controller);
  695. },
  696. visible: function(key, opt){
  697. if(project.mainTree.selected){
  698. return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
  699. }else {
  700. return false;
  701. }
  702. }
  703. },
  704. "insertRation": {
  705. name: "插入定额",
  706. icon: 'fa-sign-in',
  707. disabled: function () {
  708. var selected = project.mainTree.selected;
  709. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  710. },
  711. callback: function (key, opt) {
  712. project.Ration.addNewRation(null,rationType.ration);
  713. // ProjectController.addRation(project, controller, rationType.ration);
  714. },
  715. visible: function(key, opt){
  716. var selected = project.mainTree.selected;
  717. if(selected){
  718. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  719. return false
  720. }else {
  721. return true
  722. }
  723. }
  724. return false;
  725. }
  726. },
  727. "insertLJ": {
  728. name: "插入量价",
  729. icon: 'fa-sign-in',
  730. disabled: function () {
  731. var selected = project.mainTree.selected;
  732. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  733. },
  734. callback: function (key, opt) {
  735. project.Ration.addNewRation(null,rationType.volumePrice);
  736. // ProjectController.addRation(project, controller, rationType.volumePrice);
  737. },
  738. visible: function(key, opt){
  739. var selected = project.mainTree.selected;
  740. if(selected){
  741. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  742. return false
  743. }else {
  744. return true
  745. }
  746. }
  747. return false;
  748. }
  749. },
  750. "insertGLJ": {
  751. name: "插入工料机",
  752. icon: 'fa-sign-in',
  753. disabled: function () {
  754. var selected = project.mainTree.selected;
  755. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  756. },
  757. callback: function (key, opt) {
  758. var selected = project.mainTree.selected;
  759. if(selected.sourceType == ModuleNames.bills){
  760. if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
  761. if(selected.data.calcBase&&selected.data.calcBase!=""){
  762. alert("当前有基数计算不能插入子项。");
  763. return;
  764. }
  765. }
  766. }
  767. getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
  768. },
  769. visible: function(key, opt){
  770. var selected = project.mainTree.selected;
  771. if(selected){
  772. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  773. return false;
  774. }else {
  775. return true;
  776. }
  777. }
  778. return false;
  779. }
  780. },
  781. "ZLFB": {
  782. name: "整理分部",
  783. icon: 'fa-sign-in',
  784. disabled: function () {
  785. return false;
  786. },
  787. callback: function (key, opt) {
  788. zlfb_object.getSectionInfo();
  789. },
  790. visible: function(key, opt){
  791. return true;
  792. }
  793. },
  794. "calc_installation_fee": {
  795. name: "计取安装费用",
  796. icon: 'fa-sign-in',
  797. disabled: function () {
  798. return false;
  799. },
  800. callback: function (key, opt) {
  801. installationFeeObj.showCalcInstallSettingDiv();
  802. },
  803. visible: function(key, opt){
  804. let engineering = projectInfoObj.projectInfo.property.engineering;
  805. return engineering==engineeringType.BUILD_IN;
  806. }
  807. },
  808. "spr1": '--------',
  809. "delete": {
  810. name: '删除',
  811. icon: 'fa-remove',
  812. disabled: function () {
  813. return !ifCanDelete();
  814. },
  815. callback: function () {
  816. var selected = project.mainTree.selected;
  817. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  818. project.Bills.deleteSelectedNode();
  819. }else {
  820. $("#delete_row").modal({show:true});//弹出删除提示框;
  821. }
  822. }
  823. },
  824. "spr2":'--------',
  825. "calculateAll_RationContent": {
  826. name: '造价计算',
  827. callback: function () {
  828. project.calcProgram.calcAllNodesAndSave();
  829. }
  830. }
  831. }
  832. });
  833. },
  834. // 计算node及node的所有父项
  835. converseCalculateBills: function (node) {
  836. /* if (node) {
  837. let calc = new BillsCalcHelper(this.project);
  838. calc.calcNode(node, true);
  839. let cur = node, nodes = [];
  840. while (cur) {
  841. nodes.push(cur);
  842. cur = cur.parent;
  843. }
  844. this.mainController.refreshTreeNode(nodes, false);
  845. this.project.Bills.updateNodes(nodes, true);
  846. calc = null;
  847. }*/
  848. projectObj.project.calcProgram.calcAndSave(node);
  849. },
  850. // 计算全部清单
  851. /* calculateAll: function () {
  852. let calc = new BillsCalcHelper(this.project);
  853. calc.calcAll();
  854. this.mainController.showTreeData();
  855. this.project.Bills.updateAll();
  856. calc = null;
  857. }*/
  858. // 获取上次退出时的焦点位置
  859. loadFocusLocation: function() {
  860. const projectId = scUrlUtil.GetQueryString('project');
  861. let row = getLocalCache('lastRow:' + projectId);
  862. let col = getLocalCache('lastCol:' + projectId);
  863. if (row !== null && col !== null) {
  864. row = parseInt(row);
  865. col = parseInt(col);
  866. const sheet = this.mainSpread.getActiveSheet();
  867. sheet.setSelection(row, col, 1, 1);
  868. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  869. }
  870. },
  871. // 选中区域合计数字
  872. amountAreaNumber: function(e, info) {
  873. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  874. return false;
  875. }
  876. const selectedArea = info.newSelections[0];
  877. const sheet = info.sheet;
  878. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  879. return false;
  880. }
  881. // 获取鼠标位置
  882. let x = window.event.clientX;
  883. let y = window.event.clientY;
  884. // 匹配数字或小数
  885. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  886. // 小数点最高位数
  887. let max = 0;
  888. let total = 0;
  889. let counter = 0;
  890. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  891. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  892. const value = sheet.getCell(row, col).text();
  893. if (!regular.test(value)) {
  894. continue;
  895. }
  896. counter++;
  897. // 获取当前数据小数位数
  898. let pointPosition = value.toString().indexOf(".");
  899. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  900. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  901. max = current > max ? current : max;
  902. total += parseFloat(value);
  903. }
  904. }
  905. // 如果不为0则悬浮显示
  906. if (total > 0 && counter > 1) {
  907. 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>');
  908. div.css({
  909. position: "absolute",
  910. border: "1px #C0C0C0 solid",
  911. background: "#fff",
  912. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  913. });
  914. div.children("p").css({
  915. textAlign: "center",
  916. padding: 8,
  917. marginBottom: 2,
  918. });
  919. div.children("p").first().css({
  920. borderBottom: "1px #C0C0C0 solid"
  921. });
  922. const totalString = total.toFixed(max);
  923. // input长度
  924. const inputWidth = totalString.length * 8;
  925. // 计算是否会超出显示范围
  926. const baseWidth = 48;
  927. const baseHeight = 81;
  928. const canvasWidth = $("#billsSpreadvp_vp").width();
  929. const canvasHeight = $("#billsSpreadvp_vp").height();
  930. x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  931. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  932. div.css({
  933. left: x,
  934. top: y,
  935. });
  936. div.children().children("#total").width(inputWidth).val(totalString);
  937. $("body").append(div);
  938. // 用于判断是否要关闭窗体
  939. setTimeout(function() {
  940. isTotalShowing = true;
  941. }, 200);
  942. };
  943. },
  944. onButtonClick: function (e, info) {
  945. let node = projectObj.project.mainTree.items[info.row];
  946. if (node.data.isSubcontract) node.data.isSubcontract = false
  947. else node.data.isSubcontract = true;
  948. node.changed = true;
  949. projectObj.project.calcProgram.calcAndSave(node);
  950. },
  951. //根据节点获取行style(颜色、字体加粗)
  952. getNodeColorStyle: function (node, colSetting) {
  953. let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
  954. let mapping = {DEFAULT: 'DEFAULT', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
  955. FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
  956. let styleMap = null;
  957. //中文字段名,由于同一节点中,中文字体大小和数字字体大小不同
  958. if(colorSetting == null){
  959. return null;
  960. }
  961. let stringFields = [
  962. 'code',
  963. 'subType',
  964. 'name',
  965. 'unit',
  966. 'itemCharacterText',
  967. 'jobContentText',
  968. 'adjustState',
  969. 'calcBase',
  970. 'programID',
  971. 'ruleText'
  972. ];
  973. if(!isDef(node)){
  974. return null;
  975. }
  976. //清单大类
  977. if(node.sourceType === this.project.Bills.getSourceType()){
  978. //大项费用
  979. //大项费用
  980. if(node.data.type === billType.DXFY){
  981. styleMap = mapping.DXFY;
  982. }
  983. //分部
  984. if(node.data.type === billType.FB){
  985. styleMap = mapping.FB;
  986. }
  987. //分项
  988. else if(node.data.type === billType.FX){
  989. styleMap = mapping.FX;
  990. }
  991. //补项
  992. else if(node.data.type === billType.BX){
  993. styleMap = mapping.BX;
  994. }
  995. //清单
  996. else if(node.data.type === billType.BILL){
  997. //非叶子节点的清单
  998. if(node.source.children.length > 0){
  999. styleMap = mapping.UNLEAFBILL;
  1000. }
  1001. //未使用基数计算的叶子节点的清单
  1002. else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
  1003. styleMap = mapping.UNCBBILL;
  1004. }
  1005. //使用基数计算的叶子节点的清单
  1006. else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
  1007. styleMap = mapping.CBBILL;
  1008. }
  1009. }
  1010. }
  1011. //定额下的主材、设备
  1012. else if(node.sourceType === this.project.ration_glj.getSourceType()){
  1013. styleMap = mapping.ZCSB;
  1014. }
  1015. else {
  1016. styleMap = mapping.DEFAULT;
  1017. }
  1018. let styleSetting = colorSetting[styleMap];
  1019. let defaultSetting = colorSetting[mapping.DEFAULT];
  1020. if(!isDef(styleSetting)){
  1021. return null;
  1022. }
  1023. let style = new GC.Spread.Sheets.Style();
  1024. //设置style属性
  1025. for(let attr in styleSetting){
  1026. if(attr !== 'stringFont' && attr !== 'numFont'){
  1027. style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
  1028. }
  1029. //暂时不开放字体设置,开放的话只能每个单元格进入此方法
  1030. /* else {
  1031. if(stringFields.indexOf(colSetting.data.field) > 0){
  1032. style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
  1033. }
  1034. else {
  1035. style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
  1036. }
  1037. }*/
  1038. }
  1039. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1040. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1041. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1042. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1043. return style;
  1044. },
  1045. //大项费用则字体加粗,String 15px, Number 13px
  1046. getBoldFontStyle: function (node, colSetting) {
  1047. if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
  1048. return null;
  1049. }
  1050. let style = new GC.Spread.Sheets.Style();
  1051. //备注暂无字段
  1052. let stringFields = [
  1053. 'code',
  1054. 'subType',
  1055. 'name',
  1056. 'unit',
  1057. 'itemCharacterText',
  1058. 'jobContentText',
  1059. 'adjustState',
  1060. 'calcBase',
  1061. 'programID',
  1062. 'ruleText'
  1063. ];
  1064. if(stringFields.indexOf(colSetting.data.field) > 0){
  1065. style.font = 'bold 15px Arial';
  1066. }
  1067. else {
  1068. style.font = 'bold 13px Arial';
  1069. }
  1070. return style;
  1071. }
  1072. };
  1073. // 点击合计框中的复制
  1074. $("body").on("click", "#total-tips a", function() {
  1075. const totalElement = $(this).parent().siblings("p").find("#total");
  1076. totalElement.select();
  1077. document.execCommand("Copy");
  1078. $(this).text("已复制");
  1079. });
  1080. // 合计框点击其他位置关闭
  1081. let isTotalShowing = false;
  1082. $("body").on("click", function(e) {
  1083. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  1084. $("#total-tips").remove();
  1085. isTotalShowing = false;
  1086. }
  1087. });
  1088. $('#insert').click(function () {
  1089. var controller = projectObj.mainController, project = projectObj.project;
  1090. var selected = controller.tree.selected;
  1091. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  1092. ProjectController.addBills(project, controller);
  1093. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1094. ProjectController.addRation(project, controller, selected.data.type);
  1095. };
  1096. });
  1097. $('#delete').click(function () {
  1098. let project = projectObj.project;
  1099. let selected = project.mainTree.selected;
  1100. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  1101. project.Bills.deleteSelectedNode();
  1102. }else {
  1103. $("#delete_row").modal({show:true});//弹出删除提示框;
  1104. }
  1105. });
  1106. $('#upLevel').click(function () {
  1107. var controller = projectObj.mainController, project = projectObj.project;
  1108. var selected = controller.tree.selected, orgParent = selected.parent;
  1109. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1110. project.Bills.upLevelBills(selected.source);
  1111. controller.upLevel();
  1112. controller.refreshTreeNode([orgParent]);
  1113. projectObj.project.calcProgram.calcBillsAndSave([selected,orgParent]);
  1114. }
  1115. });
  1116. $('#downLevel').click(function () {
  1117. var controller = projectObj.mainController, project = projectObj.project;
  1118. var selected = controller.tree.selected;
  1119. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1120. project.Bills.downLevelBills(selected.source);
  1121. controller.downLevel();
  1122. controller.refreshTreeNode([selected.parent]);
  1123. projectObj.converseCalculateBills(selected.parent);
  1124. }
  1125. });
  1126. $('#upMove').click(function () {
  1127. var controller = projectObj.mainController, project = projectObj.project;
  1128. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  1129. if (selected.sourceType === project.Bills.getSourceType()) {
  1130. project.Bills.upMoveBills(selected.source);
  1131. controller.upMove();
  1132. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1133. project.Ration.changePos(selected.source, selected.preSibling.source);
  1134. controller.upMove();
  1135. };
  1136. });
  1137. $('#downMove').click(function () {
  1138. var controller = projectObj.mainController, project = projectObj.project;
  1139. var selected = controller.tree.selected, next, nextSerialNo;
  1140. if (selected) {
  1141. if (selected.sourceType === project.Bills.getSourceType()) {
  1142. project.Bills.downMoveBills(selected.source);
  1143. controller.downMove();
  1144. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1145. project.Ration.changePos(selected.source, selected.nextSibling.source);
  1146. controller.downMove();
  1147. };
  1148. }
  1149. });
  1150. //显示至..
  1151. let displayLevel = function(nodes, depth, type){
  1152. let refreshNodes = [];
  1153. function getExpandedController(){
  1154. if(type === 'DXFY' || type === 'FB'){
  1155. if(type === 'FB'){
  1156. projectObj.project.mainTree.items[0].setExpanded(true);
  1157. refreshNodes.push(projectObj.project.mainTree.items[0]);
  1158. }
  1159. return function expandedControl(nodes, depth){
  1160. let bType = type === 'FB' ? billType.FB : billType.DXFY;
  1161. for(let node of nodes){
  1162. let nodeDepth = node.depth();
  1163. if(nodeDepth <= depth){
  1164. let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
  1165. node.setExpanded(expanded);
  1166. refreshNodes.push(node);
  1167. if(nodeDepth < depth){
  1168. expandedControl(node.children, depth);
  1169. }
  1170. }
  1171. }
  1172. }
  1173. }
  1174. else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
  1175. return function expandedControl(nodes){
  1176. for(let node of nodes){
  1177. if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
  1178. let expanded = true;
  1179. if(type === 'FX'){
  1180. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
  1181. }
  1182. else if(type === 'ZM'){
  1183. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
  1184. }
  1185. node.setExpanded(expanded);
  1186. refreshNodes.push(node);
  1187. expandedControl(node.children);
  1188. }
  1189. }
  1190. }
  1191. }
  1192. }
  1193. getExpandedController()(nodes, depth);
  1194. let sheet = projectObj.mainSpread.getActiveSheet();
  1195. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  1196. TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
  1197. });
  1198. };
  1199. $('#displayDXFY').click(function () {
  1200. displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
  1201. });
  1202. //显示至一级分部
  1203. $('#displayFB1').click(function () {
  1204. displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
  1205. });
  1206. //二级分部
  1207. $('#displayFB2').click(function () {
  1208. displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
  1209. });
  1210. //三级分部
  1211. $('#displayFB3').click(function () {
  1212. displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
  1213. });
  1214. //四级分部
  1215. $('#displayFB4').click(function () {
  1216. displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
  1217. });
  1218. //分项
  1219. $('#displayFX').click(function () {
  1220. displayLevel(projectObj.project.mainTree.items, null, 'FX');
  1221. });
  1222. //子目
  1223. $('#displayZM').click(function () {
  1224. displayLevel(projectObj.project.mainTree.items, null, 'ZM');
  1225. });
  1226. //最底层
  1227. $('#displayZD').click(function () {
  1228. displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
  1229. });
  1230. $('#poj-set').on('show.bs.modal', function () {
  1231. let setCalcFlag = function (obj, val, curFlag) {
  1232. obj.val(val);
  1233. if (val === curFlag) {
  1234. obj.attr('checked', true);
  1235. } else {
  1236. obj.removeAttr('checked');
  1237. }
  1238. }
  1239. if (projectObj.project) {
  1240. // let mode = projectObj.project.projSetting.billsCalcMode;
  1241. // let settingConst = projectObj.project.projSetting.settingConst;、
  1242. let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
  1243. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  1244. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  1245. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  1246. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  1247. // mode = projectObj.project.projSetting.zanguCalcType;
  1248. let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  1249. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  1250. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  1251. projDisplayView.init();
  1252. calcOptions.init();
  1253. }
  1254. });
  1255. $('#property_ok').click(function () {
  1256. let project = projectObj.project,
  1257. projectID = project.ID(),
  1258. properties = {},
  1259. labourCoes = {},
  1260. rations = [],
  1261. bills = [],
  1262. mixDatas = {
  1263. projectID: projectID,
  1264. updateType: 'update',
  1265. properties: properties,
  1266. labourCoes: labourCoes,
  1267. rations: rations,
  1268. bills: bills
  1269. },
  1270. reCalcBills = false,
  1271. reCalcRations = false;
  1272. let b = parseInt($("input[name='calcFlag']:checked").val());
  1273. if (b !== project.property.billsCalcMode) {
  1274. properties['property.billsCalcMode'] = b;
  1275. project.property.billsCalcMode = b;
  1276. reCalcBills = true;
  1277. };
  1278. let zg = parseInt($("input[name='zangu']:checked").val());
  1279. if (zg !== project.property.zanguCalcMode) {
  1280. properties['property.zanguCalcMode'] = zg;
  1281. project.property.zanguCalcMode = zg;
  1282. reCalcRations = true;
  1283. };
  1284. //基本信息
  1285. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  1286. properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
  1287. }
  1288. //工程特征
  1289. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  1290. properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
  1291. }
  1292. //清单工程量精度
  1293. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  1294. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  1295. billsQuanDecimal.datas = newBillsDecimalDatas;
  1296. reCalcBills = true;
  1297. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  1298. }
  1299. //小数位数
  1300. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  1301. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  1302. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  1303. setDecimal(decimalObj, updateDecimal);
  1304. if (frChanged) {
  1305. project.calcProgram.compileAllTemps()
  1306. }
  1307. reCalcRations = true;
  1308. reCalcBills = true;
  1309. properties['property.decimal'] = updateDecimal;
  1310. }
  1311. // 呈现选项
  1312. projDisplayView.updateChecking(properties);
  1313. if(calcOptions.updateChecking(properties)){
  1314. reCalcRations = true;
  1315. }
  1316. // 人工系数
  1317. if (labourCoeView.needSave()){
  1318. let libID = $("#std_labour_coe_files").children("option:selected").val();
  1319. let libName = $("#std_labour_coe_files").children("option:selected").text();
  1320. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  1321. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  1322. project.calcProgram.compileAllTemps();
  1323. reCalcRations = true;
  1324. reCalcBills = true;
  1325. };
  1326. // 重新计算树节点
  1327. let changedNodes = [];
  1328. if (reCalcRations) // 定额动,全部计算。算完先不存储,和后面的数据一起提交,一次通讯。
  1329. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  1330. else if (reCalcBills) // 清单动,可以只计算清单。
  1331. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  1332. if (changedNodes.length > 0) {
  1333. for (let node of changedNodes){
  1334. let data = calcTools.cutNodeForSave(node);
  1335. if (node.sourceType == 'ration') rations.push(data)
  1336. else if (node.sourceType == 'bills') bills.push(data);
  1337. };
  1338. };
  1339. // for test.
  1340. /* console.log(mixDatas);
  1341. return; */
  1342. function hasMixData() {
  1343. return Object.keys(mixDatas.properties).length > 0 ||
  1344. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  1345. }
  1346. if(hasMixData()){
  1347. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  1348. /* if (changedNodes.length > 0) {
  1349. for (let node of changedNodes){delete node.changed};
  1350. };
  1351. if (mixDatas.labourCoes.updateData) labourCoeView.refresh();*/
  1352. window.location.href = '/main?project=' + projectID;
  1353. });
  1354. }
  1355. });
  1356. $('#delete_row').on('shown.bs.modal', function (e) {
  1357. var controller = projectObj.mainController, project = projectObj.project;
  1358. var selected = controller.tree.selected, parent = selected.parent;
  1359. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  1360. var showN = false;
  1361. var cancelText = "否";
  1362. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  1363. if(isSingleSelect()||selectionChecking()){
  1364. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  1365. showN = true;
  1366. cancelText = "取消";
  1367. }
  1368. }
  1369. $('#delete_showinfo').html(showinfo);
  1370. showN==true? $('#deleteN').show():$('#deleteN').hide();
  1371. $('#deleteCancel').text(cancelText);
  1372. function selectionChecking() {
  1373. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1374. let mainTreeMap = {};
  1375. for(let i =0;i<selection.rowCount;i++){
  1376. let tem_node = controller.tree.items[selection.row+i];
  1377. if(i==0){//第一个直接添加;
  1378. mainTreeMap[tem_node.getID()] = tem_node;
  1379. }else {
  1380. project.Bills.setNodeToMap(tem_node,mainTreeMap);
  1381. }
  1382. }
  1383. let nodes = changeMapToArray(mainTreeMap);
  1384. if(nodes.length==1){
  1385. return true
  1386. }
  1387. return false;
  1388. }
  1389. });
  1390. function changeMapToArray(map) {
  1391. let newArray = [];
  1392. for(let key in map){
  1393. newArray.push(map[key]);
  1394. }
  1395. return newArray;
  1396. }
  1397. $('#deleteY').click(function () { //正常删除,级联删除子项
  1398. let project = projectObj.project;
  1399. if(isSingleSelect()){
  1400. project.Bills.deleteSelectedNode();
  1401. }else {
  1402. project.Bills.deleteSelectedNodes();
  1403. }
  1404. });
  1405. $('#deleteN').click(function () {//不删除子项
  1406. let controller = projectObj.mainController, project = projectObj.project;
  1407. let selected = controller.tree.selected, parent = selected.parent;
  1408. if(selected){
  1409. let preNode = selected.preSibling;
  1410. let nextNode = selected.nextSibling;
  1411. if(preNode){//有前兄弟
  1412. if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
  1413. alert("删除分部会导致分部和分项同级,不允许该操作!");
  1414. return;
  1415. }
  1416. }else if(nextNode){
  1417. if(nextNode.data.type != selected.children[0].data.type){
  1418. alert("删除分部会导致分部和分项同级,不允许该操作! ");
  1419. return;
  1420. }
  1421. }
  1422. project.Bills.singleDeleteBills(selected,controller);
  1423. }
  1424. });
  1425. function isSingleSelect() {//是否选中造价书中的单行
  1426. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1427. if (selections[0].rowCount == 1) {
  1428. return true;
  1429. }
  1430. return false;
  1431. }
  1432. function ifCanDelete() {
  1433. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1434. let tree = projectObj.project.mainTree;
  1435. let selected = projectObj.project.mainTree.selected;
  1436. if(selections[0].rowCount==1){//选中单行
  1437. return canDelete(selected);
  1438. }else {
  1439. return canDelete_m(selections[0]);
  1440. }
  1441. function canDelete(node,m_selection) {
  1442. if (node) {
  1443. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  1444. if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
  1445. return false;
  1446. }
  1447. }
  1448. if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
  1449. return false;
  1450. }
  1451. return true;
  1452. } else {
  1453. return false;
  1454. }
  1455. };
  1456. function canDelete_m(selection) {
  1457. for(let i =0;i<selection.rowCount;i++){
  1458. if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
  1459. return false;
  1460. }
  1461. if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
  1462. return false
  1463. }
  1464. if(canDelete(tree.items[selection.row+i],true)==false){
  1465. return false
  1466. }
  1467. }
  1468. return true
  1469. };
  1470. }