project_view.js 68 KB

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