project_view.js 62 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394
  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. if (/\//.test(data.unit)) {
  250. ConfirmModal.stdBillsUnit.check(data, function (std) {
  251. project.Bills.replaceBills(node.source, std, formatCode);
  252. projectObj.mainController.refreshTreeNode([node], false);
  253. }, function () {
  254. projectObj.mainController.refreshTreeNode([node], false);
  255. });
  256. } else {
  257. project.Bills.replaceBills(node.source, data, formatCode);
  258. projectObj.mainController.refreshTreeNode([node], false);
  259. }
  260. } else {
  261. project.Bills.updateField(node.source, 'code', formatCode, true);
  262. projectObj.mainController.refreshTreeNode([node], false);
  263. }
  264. });
  265. }
  266. }
  267. if(node.data.type==billType.FX||(node.data.type==billType.BILL&&node.source.children.length==0)){//是分项或者叶子清单的情况下才需要查找替换
  268. if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
  269. stdMatchCode = value;
  270. formatCode = project.Bills.newFormatCode(stdMatchCode);
  271. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  272. return;
  273. } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
  274. stdMatchCode = value.substr(0, 9);
  275. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  276. if (matchs.indexOf(value) === -1) {
  277. searchStdBillsAndUpdate(stdMatchCode, value);
  278. } else if (confirm('已存在该编码的清单,是否继续?')) {
  279. formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  280. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  281. return;
  282. }
  283. }
  284. }
  285. project.Bills.updateField(node.source, 'code', value, true);
  286. this.mainController.refreshTreeNode([node], false);
  287. },
  288. updateRationCode: function (node, value) {
  289. if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
  290. return;
  291. }
  292. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  293. alert('当前项目无定额库,请添加定额库。');
  294. this.mainController.refreshTreeNode([node], false);
  295. } else {
  296. let libId = projectInfoObj.projectInfo.engineeringInfo.ration_lib[0].id;
  297. CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
  298. if (data) {
  299. projectObj.project.Ration.replaceRation(node.source, data);
  300. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  301. } else {
  302. alert('当前库中找不到定额"' + value + '"');
  303. }
  304. projectObj.mainController.refreshTreeNode([node], false);
  305. });
  306. }
  307. },
  308. updateCode: function (node, value) {
  309. let project = projectObj.project;
  310. if (node.sourceType === project.Bills.getSourceType()) {
  311. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  312. } else if (node.sourceType === project.Ration.getSourceType()) {
  313. this.updateRationCode(node, value); // 新套定额适合实时计算
  314. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  315. /*project.calcProgram.calcAndSave(node);
  316. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  317. calcProgramObj.showData(node, false);
  318. };*/
  319. }
  320. },
  321. updateCellValue: function (node, value, colSetting,editingText) {
  322. let project = projectObj.project, fieldName = colSetting.data.field;
  323. if(node.sourceType==project.ration_glj.getSourceType()){
  324. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  325. }
  326. else if(calcTools.isGljRation(node)){
  327. gljOprObj.updateRationTypeGLJ(value,node,fieldName);
  328. }
  329. else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  330. if (fieldName === 'code' && !calcTools.isVolumePrice(node)) {
  331. projectObj.updateCode(node, value);
  332. }
  333. else if(fieldName ==='feeRate'){
  334. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  335. }
  336. else if(fieldName ==='contain'){//编辑含量
  337. project.Ration.updateContain(value,node);
  338. }
  339. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
  340. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
  341. if (fieldName === 'quantity') {
  342. project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
  343. return;
  344. }
  345. else if (fieldName === 'marketUnitFee') {
  346. if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
  347. }
  348. else if (fieldName === 'calcBase') {
  349. //zhong
  350. if(value === undefined ||value === null || value.toString().trim() === ''){
  351. value = '';
  352. }
  353. node.data.userCalcBase = value;
  354. project.calcBase.calculate(node);
  355. if(!project.calcBase.success){
  356. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  357. projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: '');
  358. return;
  359. }
  360. // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
  361. };
  362. //计算基数赋值要经过解析和标准化,已在calculate里赋值
  363. if(fieldName !== 'calcBase'){
  364. node.data[fieldName] = value;
  365. node.changed = true;
  366. }
  367. project.calcProgram.calcAndSave(node);
  368. gljOprObj.showRationGLJSheetData();
  369. }
  370. else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
  371. node.data[fieldName] = value;
  372. node.changed = true;
  373. if(node.data.quantity){
  374. node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  375. }
  376. project.calcProgram.calcAndSave(node);
  377. }
  378. else {
  379. if (node.sourceType === project.Bills.getSourceType()) {
  380. project.Bills.updateField(node.source, fieldName, value, true);
  381. }
  382. else if (node.sourceType === project.Ration.getSourceType()) {
  383. project.Ration.updateField(node.source, fieldName, value, true);
  384. };
  385. if (colSetting.data.wordWrap) {
  386. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  387. }
  388. projectObj.mainController.refreshTreeNode([node]);
  389. }
  390. }
  391. else if(value==null && fieldName ==='feeRate'){
  392. project.FeeRate.cleanFeeRateID(node);
  393. }
  394. else {
  395. projectObj.mainController.refreshTreeNode([node], false);
  396. }
  397. },
  398. mainSpreadLeaveCell: function (sender, info) {
  399. let colSetting = projectObj.mainController.setting.cols[info.col];
  400. projectObj.lastCol = colSetting;
  401. },
  402. //repaint 动态下拉框
  403. mainSpreadEnterCell: function (sender, info) {
  404. let colSetting = projectObj.mainController.setting.cols[info.col];
  405. if(colSetting.data.field === 'unit' || projectObj.lastCol.data.field === 'unit'||colSetting.data.field ==='subType'
  406. || projectObj.lastCol.data.field === 'subType' || colSetting.data.field === 'programID' ||projectObj.lastCol.data.field === 'programID'){
  407. info.sheet.repaint();
  408. }
  409. },
  410. mainSpreadEditStarting: function (sender, info) {
  411. let project = projectObj.project;
  412. let node = project.mainTree.items[info.row];
  413. if(isDef(node) && node.sourceType === project.Ration.getSourceType() && isDef(node.data.code) && isDef(node.data.from) && node.data.from === 'cpt'){
  414. let orgV = info.sheet.getValue(info.row, info.col);
  415. let newV = orgV.replace(new RegExp('补'), '');
  416. info.sheet.setValue(info.row, info.col, newV);
  417. }
  418. },
  419. mainSpreadEditEnded: function (sender, info) {
  420. let project = projectObj.project;
  421. let node = project.mainTree.items[info.row];
  422. let colSetting = projectObj.mainController.setting.cols[info.col];
  423. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  424. // 检查输入类型等
  425. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  426. projectObj.updateCellValue(node, value, colSetting,info.editingText);
  427. // 自动行高
  428. const autoHeight = project.property.displaySetting.autoHeight;
  429. if (autoHeight) {
  430. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  431. }
  432. },
  433. msClipboardChanged: function (sender, info) {
  434. let cDatas = sheetCommonObj.getTableData(info.sheet);
  435. sheetCommonObj.copyTextToClipboard(cDatas);
  436. return;
  437. },
  438. mainSpreadRangeChanged: function (sender, info) {
  439. let project = projectObj.project, setting = projectObj.mainController.setting;
  440. let changedObj = projectObj.checkSpreadChangedCells(info);
  441. let refreshNodes = [];
  442. for(let row of changedObj.refreshRows){
  443. refreshNodes.push(project.mainTree.items[row]);
  444. }
  445. let updateRationCodes = [];//更新定额编码时要用同步的方式
  446. if(changedObj.changedCells.length > 0){
  447. for (let changedCell of changedObj.changedCells) {
  448. let node = project.mainTree.items[changedCell.row];
  449. let colSetting = setting.cols[changedCell.col];
  450. let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
  451. if(colSetting.data.field=='code'&& node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
  452. updateRationCodes.push({'node':node,value:value});
  453. }else {
  454. projectObj.updateCellValue(node, value, colSetting,changedCell.text);
  455. }
  456. }
  457. }
  458. if(updateRationCodes.length>0){
  459. project.Ration.updateRationCodes(updateRationCodes);
  460. }
  461. if(refreshNodes.length > 0){
  462. projectObj.mainController.refreshTreeNode(refreshNodes);
  463. }
  464. },
  465. checkMainSpread: function () {
  466. if (!this.mainSpread) {
  467. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  468. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  469. }
  470. },
  471. refreshMainSpread: function () {
  472. if (this.mainSpread) {
  473. this.mainSpread.refresh();
  474. }
  475. },
  476. loadProjectData: function () {
  477. var that = this;
  478. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  479. let startTime = +new Date();
  480. console.log("开始加载-----"+startTime);
  481. this.project.loadDatas(function (err) {
  482. if (!err) {
  483. that.project.projectGLJ.calcQuantity();//计算分部分项和技术措施项目消耗量;
  484. that.project.property = projectInfoObj.projectInfo.property;
  485. //that.project.calcProgram.compileAllTemps();
  486. that.project.calcBase.init(that.project);
  487. // that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
  488. // that.project.initCalcFields();
  489. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  490. that.project.projSetting.mainGridSetting = JSON.parse(str);
  491. that.project.projSetting.mainGridSetting.frozenCols = 4;
  492. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  493. const autoHeight = that.project.property.displaySetting !== undefined ?
  494. that.project.property.displaySetting.autoHeight : false;
  495. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  496. col.data.splitFields = col.data.field.split('.');
  497. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  498. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  499. }
  500. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  501. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  502. }
  503. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  504. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  505. col.data.cellType = getCellType;
  506. }
  507. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  508. // col.data.decimal = that.project.getDecimal(col.data.digit);
  509. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  510. // }
  511. if (col.data.field === 'code') {
  512. col.data.formatter = '@';
  513. }
  514. // 根据配置设置自动行高
  515. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  516. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  517. if (!autoHeight) {
  518. col.showHint = true;
  519. col.data.wordWrap = false;
  520. } else {
  521. col.showHint = false;
  522. col.data.wordWrap = true;
  523. }
  524. }
  525. if(col.data.field ==='quantity'){
  526. col.showHint = true;
  527. }
  528. // 综合单价、综合合价,小数部分应补0对齐。 CSLAAAAA
  529. // if (col.data.field.hasSubStr("common")){
  530. if (col.data.field.hasSubStr(".totalFee"))
  531. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true)
  532. else if (col.data.field.hasSubStr(".unitFee"))
  533. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true)
  534. // }
  535. });
  536. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  537. that.mainController.showTreeData();
  538. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  539. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  540. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  541. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  542. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  543. that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);
  544. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  545. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  546. that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
  547. that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
  548. that.loadMainSpreadContextMenu();
  549. that.loadFocusLocation();
  550. let endTime = +new Date();
  551. socketObject.connect();//连接socket服务器
  552. console.log("加载完成-----"+endTime);
  553. console.log(`时间——${endTime - startTime}`);
  554. that.project.projectMarkChecking();//是否需要重新进行造价计算
  555. installationFeeObj.engineeringTypeChecking();//检查是否安装工程
  556. }
  557. else {
  558. }
  559. });
  560. },
  561. loadMainSpreadContextMenu: function () {
  562. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  563. $.contextMenu({
  564. selector: '#billsSpread',
  565. build: function ($trigger, e) {
  566. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  567. controller.setTreeSelected(controller.tree.items[target.row]);
  568. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  569. },
  570. items: {
  571. "insertRootBill": {
  572. name: "插入大项费用",
  573. icon: 'fa-sign-in',
  574. disabled: function () {
  575. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  576. },
  577. callback: function (key, opt) {
  578. ProjectController.addRootBill(project, controller);
  579. },
  580. visible: function(key, opt){
  581. return project.mainTree.selected&&project.mainTree.selected.parent==null;
  582. }
  583. },
  584. "insertFB": {
  585. name: "插入分部",
  586. icon: 'fa-sign-in',
  587. disabled: function () {
  588. let selected = project.mainTree.selected;
  589. if(selected&&selected.sourceType==project.Bills.getSourceType()){
  590. if(selected.data.type==billType.FB){
  591. return false;
  592. }
  593. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  594. if(selected.children.length>0){
  595. return selected.children[0].data.type==billType.FX;//焦点行是分部分项工程,且子项是分项
  596. }else {
  597. return false
  598. }
  599. }
  600. }
  601. return true;//除了清单,其它类型都只读
  602. },
  603. callback: function (key, opt) {
  604. ProjectController.addFB(project, controller);
  605. },
  606. visible: function(key, opt){
  607. if(project.mainTree.selected){
  608. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  609. }else {
  610. return false;
  611. }
  612. }
  613. },
  614. "insertFX": {
  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.FX){//焦点行是分项,有效显示
  621. return false
  622. }
  623. if(selected.data.type==billType.FB){//点行是分部,
  624. if(selected.children.length>0){//且有子项,子项是分部,灰显。
  625. return selected.children[0].data.type == billType.FB
  626. }else {
  627. return false;
  628. }
  629. }
  630. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  631. if(selected.children.length>0){
  632. return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
  633. }else {
  634. return false
  635. }
  636. }
  637. }
  638. return true;//除了清单,其它类型都只读
  639. },
  640. callback: function (key, opt) {
  641. ProjectController.addFX(project, controller);
  642. },
  643. visible: function(key, opt){
  644. if(project.mainTree.selected){
  645. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  646. }else {
  647. return false;
  648. }
  649. }
  650. },
  651. "insertBills": {
  652. name: "插入清单",
  653. icon: 'fa-sign-in',
  654. disabled: function () {
  655. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  656. },
  657. callback: function (key, opt) {
  658. if(project.mainTree.selected.data.type == billType.DXFY){
  659. if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
  660. alert("当前有基数计算不能插入子项。");
  661. return;
  662. }
  663. }
  664. ProjectController.addBills(project, controller);
  665. },
  666. visible: function(key, opt){
  667. if(project.mainTree.selected){
  668. return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
  669. }else {
  670. return false;
  671. }
  672. }
  673. },
  674. "insertRation": {
  675. name: "插入定额",
  676. icon: 'fa-sign-in',
  677. disabled: function () {
  678. var selected = project.mainTree.selected;
  679. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  680. },
  681. callback: function (key, opt) {
  682. project.Ration.addNewRation(null,rationType.ration);
  683. // ProjectController.addRation(project, controller, rationType.ration);
  684. },
  685. visible: function(key, opt){
  686. var selected = project.mainTree.selected;
  687. if(selected){
  688. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  689. return false
  690. }else {
  691. return true
  692. }
  693. }
  694. return false;
  695. }
  696. },
  697. "insertLJ": {
  698. name: "插入量价",
  699. icon: 'fa-sign-in',
  700. disabled: function () {
  701. var selected = project.mainTree.selected;
  702. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  703. },
  704. callback: function (key, opt) {
  705. project.Ration.addNewRation(null,rationType.volumePrice);
  706. // ProjectController.addRation(project, controller, rationType.volumePrice);
  707. },
  708. visible: function(key, opt){
  709. var selected = project.mainTree.selected;
  710. if(selected){
  711. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  712. return false
  713. }else {
  714. return true
  715. }
  716. }
  717. return false;
  718. }
  719. },
  720. "insertGLJ": {
  721. name: "插入工料机",
  722. icon: 'fa-sign-in',
  723. disabled: function () {
  724. var selected = project.mainTree.selected;
  725. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  726. },
  727. callback: function (key, opt) {
  728. var selected = project.mainTree.selected;
  729. if(selected.sourceType == ModuleNames.bills){
  730. if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
  731. if(selected.data.calcBase&&selected.data.calcBase!=""){
  732. alert("当前有基数计算不能插入子项。");
  733. return;
  734. }
  735. }
  736. }
  737. getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
  738. },
  739. visible: function(key, opt){
  740. var selected = project.mainTree.selected;
  741. if(selected){
  742. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  743. return false;
  744. }else {
  745. return true;
  746. }
  747. }
  748. return false;
  749. }
  750. },
  751. "ZLFB": {
  752. name: "整理分部",
  753. icon: 'fa-sign-in',
  754. disabled: function () {
  755. return false;
  756. },
  757. callback: function (key, opt) {
  758. zlfb_object.getSectionInfo();
  759. },
  760. visible: function(key, opt){
  761. return true;
  762. }
  763. },
  764. "calc_installation_fee": {
  765. name: "计取安装费用",
  766. icon: 'fa-sign-in',
  767. disabled: function () {
  768. return false;
  769. },
  770. callback: function (key, opt) {
  771. installationFeeObj.showCalcInstallSettingDiv();
  772. },
  773. visible: function(key, opt){
  774. let engineering = projectInfoObj.projectInfo.property.engineering;
  775. return engineering==engineeringType.BUILD_IN;
  776. }
  777. },
  778. "spr1": '--------',
  779. "delete": {
  780. name: '删除',
  781. icon: 'fa-remove',
  782. disabled: function () {
  783. return !ifCanDelete();
  784. },
  785. callback: function () {
  786. $("#delete_row").modal({show:true});//弹出删除提示框;
  787. }
  788. },
  789. "spr2":'--------',
  790. "calculateAll_RationContent": {
  791. name: '造价计算',
  792. callback: function () {
  793. $.bootstrapLoading.start();
  794. project.calcProgram.calcAllNodesAndSave();
  795. }
  796. }
  797. }
  798. });
  799. },
  800. // 计算node及node的所有父项
  801. converseCalculateBills: function (node) {
  802. /* if (node) {
  803. let calc = new BillsCalcHelper(this.project);
  804. calc.calcNode(node, true);
  805. let cur = node, nodes = [];
  806. while (cur) {
  807. nodes.push(cur);
  808. cur = cur.parent;
  809. }
  810. this.mainController.refreshTreeNode(nodes, false);
  811. this.project.Bills.updateNodes(nodes, true);
  812. calc = null;
  813. }*/
  814. projectObj.project.calcProgram.calcAndSave(node);
  815. },
  816. // 计算全部清单
  817. /* calculateAll: function () {
  818. let calc = new BillsCalcHelper(this.project);
  819. calc.calcAll();
  820. this.mainController.showTreeData();
  821. this.project.Bills.updateAll();
  822. calc = null;
  823. }*/
  824. // 获取上次退出时的焦点位置
  825. loadFocusLocation: function() {
  826. const projectId = scUrlUtil.GetQueryString('project');
  827. let row = getLocalCache('lastRow:' + projectId);
  828. let col = getLocalCache('lastCol:' + projectId);
  829. if (row !== null && col !== null) {
  830. row = parseInt(row);
  831. col = parseInt(col);
  832. const sheet = this.mainSpread.getActiveSheet();
  833. sheet.setSelection(row, col, 1, 1);
  834. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  835. }
  836. },
  837. // 选中区域合计数字
  838. amountAreaNumber: function(e, info) {
  839. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  840. return false;
  841. }
  842. const selectedArea = info.newSelections[0];
  843. const sheet = info.sheet;
  844. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  845. return false;
  846. }
  847. // 获取鼠标位置
  848. let x = window.event.clientX;
  849. let y = window.event.clientY;
  850. // 匹配数字或小数
  851. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  852. // 小数点最高位数
  853. let max = 0;
  854. let total = 0;
  855. let counter = 0;
  856. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  857. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  858. const value = sheet.getCell(row, col).text();
  859. if (!regular.test(value)) {
  860. continue;
  861. }
  862. counter++;
  863. // 获取当前数据小数位数
  864. let pointPosition = value.toString().indexOf(".");
  865. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  866. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  867. max = current > max ? current : max;
  868. total += parseFloat(value);
  869. }
  870. }
  871. // 如果不为0则悬浮显示
  872. if (total > 0 && counter > 1) {
  873. 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>');
  874. div.css({
  875. position: "absolute",
  876. border: "1px #C0C0C0 solid",
  877. background: "#fff",
  878. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  879. });
  880. div.children("p").css({
  881. textAlign: "center",
  882. padding: 8,
  883. marginBottom: 2,
  884. });
  885. div.children("p").first().css({
  886. borderBottom: "1px #C0C0C0 solid"
  887. });
  888. const totalString = total.toFixed(max);
  889. // input长度
  890. const inputWidth = totalString.length * 8;
  891. // 计算是否会超出显示范围
  892. const baseWidth = 48;
  893. const baseHeight = 81;
  894. const canvasWidth = $("#billsSpreadvp_vp").width();
  895. const canvasHeight = $("#billsSpreadvp_vp").height();
  896. x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  897. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  898. div.css({
  899. left: x,
  900. top: y,
  901. });
  902. div.children().children("#total").width(inputWidth).val(totalString);
  903. $("body").append(div);
  904. // 用于判断是否要关闭窗体
  905. setTimeout(function() {
  906. isTotalShowing = true;
  907. }, 200);
  908. };
  909. },
  910. onButtonClick: function (e, info) {
  911. let node = projectObj.project.mainTree.items[info.row];
  912. if (node.data.isSubcontract) node.data.isSubcontract = false
  913. else node.data.isSubcontract = true;
  914. node.changed = true;
  915. projectObj.project.calcProgram.calcAndSave(node);
  916. },
  917. //根据节点获取行style(颜色、字体加粗)
  918. getNodeColorStyle: function (node, colSetting) {
  919. let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
  920. let mapping = {DEFAULT: 'DEFAULT', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
  921. FX: 'FX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
  922. let styleMap = null;
  923. //中文字段名,由于同一节点中,中文字体大小和数字字体大小不同
  924. let stringFields = [
  925. 'code',
  926. 'subType',
  927. 'name',
  928. 'unit',
  929. 'itemCharacterText',
  930. 'jobContentText',
  931. 'adjustState',
  932. 'calcBase',
  933. 'programID',
  934. 'ruleText'
  935. ];
  936. if(!isDef(node)){
  937. return null;
  938. }
  939. //清单大类
  940. if(node.sourceType === this.project.Bills.getSourceType()){
  941. //大项费用
  942. //大项费用
  943. if(node.data.type === billType.DXFY){
  944. styleMap = mapping.DXFY;
  945. }
  946. //分部
  947. if(node.data.type === billType.FB){
  948. styleMap = mapping.FB;
  949. }
  950. //分项
  951. else if(node.data.type === billType.FX){
  952. styleMap = mapping.FX;
  953. }
  954. //清单
  955. else if(node.data.type === billType.BILL){
  956. //非叶子节点的清单
  957. if(node.source.children.length > 0){
  958. styleMap = mapping.UNLEAFBILL;
  959. }
  960. //未使用基数计算的叶子节点的清单
  961. else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
  962. styleMap = mapping.UNCBBILL;
  963. }
  964. //使用基数计算的叶子节点的清单
  965. else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
  966. styleMap = mapping.CBBILL;
  967. }
  968. }
  969. }
  970. //定额下的主材、设备
  971. else if(node.sourceType === this.project.ration_glj.getSourceType()){
  972. styleMap = mapping.ZCSB;
  973. }
  974. else {
  975. styleMap = mapping.DEFAULT;
  976. }
  977. let styleSetting = colorSetting[styleMap];
  978. let defaultSetting = colorSetting[mapping.DEFAULT];
  979. if(!isDef(styleSetting)){
  980. return null;
  981. }
  982. let style = new GC.Spread.Sheets.Style();
  983. //设置style属性
  984. for(let attr in styleSetting){
  985. if(attr !== 'stringFont' && attr !== 'numFont'){
  986. style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
  987. }
  988. //暂时不开放字体设置,开放的话只能每个单元格进入此方法
  989. /* else {
  990. if(stringFields.indexOf(colSetting.data.field) > 0){
  991. style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
  992. }
  993. else {
  994. style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
  995. }
  996. }*/
  997. }
  998. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  999. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1000. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1001. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1002. return style;
  1003. },
  1004. //大项费用则字体加粗,String 15px, Number 13px
  1005. getBoldFontStyle: function (node, colSetting) {
  1006. if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
  1007. return null;
  1008. }
  1009. let style = new GC.Spread.Sheets.Style();
  1010. //备注暂无字段
  1011. let stringFields = [
  1012. 'code',
  1013. 'subType',
  1014. 'name',
  1015. 'unit',
  1016. 'itemCharacterText',
  1017. 'jobContentText',
  1018. 'adjustState',
  1019. 'calcBase',
  1020. 'programID',
  1021. 'ruleText'
  1022. ];
  1023. if(stringFields.indexOf(colSetting.data.field) > 0){
  1024. style.font = 'bold 15px Arial';
  1025. }
  1026. else {
  1027. style.font = 'bold 13px Arial';
  1028. }
  1029. return style;
  1030. }
  1031. };
  1032. // 点击合计框中的复制
  1033. $("body").on("click", "#total-tips a", function() {
  1034. const totalElement = $(this).parent().siblings("p").find("#total");
  1035. totalElement.select();
  1036. document.execCommand("Copy");
  1037. $(this).text("已复制");
  1038. });
  1039. // 合计框点击其他位置关闭
  1040. let isTotalShowing = false;
  1041. $("body").on("click", function(e) {
  1042. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  1043. $("#total-tips").remove();
  1044. isTotalShowing = false;
  1045. }
  1046. });
  1047. $('#insert').click(function () {
  1048. var controller = projectObj.mainController, project = projectObj.project;
  1049. var selected = controller.tree.selected;
  1050. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  1051. ProjectController.addBills(project, controller);
  1052. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1053. ProjectController.addRation(project, controller, selected.data.type);
  1054. };
  1055. });
  1056. $('#delete').click(function () {
  1057. $("#delete_row").modal({show:true});//弹出删除提示框;
  1058. });
  1059. $('#upLevel').click(function () {
  1060. var controller = projectObj.mainController, project = projectObj.project;
  1061. var selected = controller.tree.selected, orgParent = selected.parent;
  1062. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1063. project.Bills.upLevelBills(selected.source);
  1064. controller.upLevel();
  1065. controller.refreshTreeNode([orgParent]);
  1066. projectObj.project.calcProgram.calcBillsAndSave([selected,orgParent]);
  1067. }
  1068. });
  1069. $('#downLevel').click(function () {
  1070. var controller = projectObj.mainController, project = projectObj.project;
  1071. var selected = controller.tree.selected;
  1072. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1073. project.Bills.downLevelBills(selected.source);
  1074. controller.downLevel();
  1075. controller.refreshTreeNode([selected.parent]);
  1076. projectObj.converseCalculateBills(selected.parent);
  1077. }
  1078. });
  1079. $('#upMove').click(function () {
  1080. var controller = projectObj.mainController, project = projectObj.project;
  1081. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  1082. if (selected.sourceType === project.Bills.getSourceType()) {
  1083. project.Bills.upMoveBills(selected.source);
  1084. controller.upMove();
  1085. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1086. project.Ration.changePos(selected.source, selected.preSibling.source);
  1087. controller.upMove();
  1088. };
  1089. });
  1090. $('#downMove').click(function () {
  1091. var controller = projectObj.mainController, project = projectObj.project;
  1092. var selected = controller.tree.selected, next, nextSerialNo;
  1093. if (selected) {
  1094. if (selected.sourceType === project.Bills.getSourceType()) {
  1095. project.Bills.downMoveBills(selected.source);
  1096. controller.downMove();
  1097. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1098. project.Ration.changePos(selected.source, selected.nextSibling.source);
  1099. controller.downMove();
  1100. };
  1101. }
  1102. });
  1103. $('#poj-set').on('show.bs.modal', function () {
  1104. let setCalcFlag = function (obj, val, curFlag) {
  1105. obj.val(val);
  1106. if (val === curFlag) {
  1107. obj.attr('checked', true);
  1108. } else {
  1109. obj.removeAttr('checked');
  1110. }
  1111. }
  1112. if (projectObj.project) {
  1113. // let mode = projectObj.project.projSetting.billsCalcMode;
  1114. // let settingConst = projectObj.project.projSetting.settingConst;
  1115. let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
  1116. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  1117. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  1118. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  1119. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  1120. // mode = projectObj.project.projSetting.zanguCalcType;
  1121. let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  1122. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  1123. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  1124. }
  1125. });
  1126. $('#property_ok').click(function () {
  1127. let project = projectObj.project,
  1128. projectID = project.ID(),
  1129. properties = {},
  1130. labourCoes = {},
  1131. rations = [],
  1132. bills = [],
  1133. mixDatas = {
  1134. projectID: projectID,
  1135. updateType: 'update',
  1136. properties: properties,
  1137. labourCoes: labourCoes,
  1138. rations: rations,
  1139. bills: bills
  1140. },
  1141. reCalcBills = false,
  1142. reCalcRations = false;
  1143. let b = parseInt($("input[name='calcFlag']:checked").val());
  1144. if (b !== project.property.billsCalcMode) {
  1145. properties['property.billsCalcMode'] = b;
  1146. project.property.billsCalcMode = b;
  1147. reCalcBills = true;
  1148. };
  1149. let zg = parseInt($("input[name='zangu']:checked").val());
  1150. if (zg !== project.property.zanguCalcMode) {
  1151. properties['property.zanguCalcMode'] = zg;
  1152. project.property.zanguCalcMode = zg;
  1153. reCalcRations = true;
  1154. };
  1155. //基本信息
  1156. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  1157. properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
  1158. }
  1159. //工程特征
  1160. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  1161. properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
  1162. }
  1163. //清单工程量精度
  1164. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  1165. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  1166. billsQuanDecimal.datas = newBillsDecimalDatas;
  1167. reCalcBills = true;
  1168. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  1169. }
  1170. //小数位数
  1171. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  1172. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  1173. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  1174. setDecimal(decimalObj, updateDecimal);
  1175. if (frChanged) {
  1176. project.calcProgram.compileAllTemps()
  1177. }
  1178. reCalcRations = true;
  1179. reCalcBills = true;
  1180. properties['property.decimal'] = updateDecimal;
  1181. }
  1182. // 呈现选项
  1183. projDisplayView.updateChecking(properties);
  1184. if(calcOptions.updateChecking(properties)){
  1185. reCalcRations = true;
  1186. }
  1187. // 人工系数
  1188. if (labourCoeView.needSave()){
  1189. let libID = $("#std_labour_coe_files").children("option:selected").val();
  1190. let libName = $("#std_labour_coe_files").children("option:selected").text();
  1191. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  1192. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  1193. project.calcProgram.compileAllTemps();
  1194. reCalcRations = true;
  1195. reCalcBills = true;
  1196. };
  1197. // 重新计算树节点
  1198. let changedNodes = [];
  1199. if (reCalcRations) // 定额动,全部计算。算完先不存储,和后面的数据一起提交,一次通讯。
  1200. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  1201. else if (reCalcBills) // 清单动,可以只计算清单。
  1202. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  1203. if (changedNodes.length > 0) {
  1204. for (let node of changedNodes){
  1205. let data = calcTools.cutNodeForSave(node);
  1206. if (node.sourceType == 'ration') rations.push(data)
  1207. else if (node.sourceType == 'bills') bills.push(data);
  1208. };
  1209. };
  1210. // for test.
  1211. /* console.log(mixDatas);
  1212. return; */
  1213. function hasMixData() {
  1214. return Object.keys(mixDatas.properties).length > 0 ||
  1215. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  1216. }
  1217. if(hasMixData()){
  1218. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  1219. /* if (changedNodes.length > 0) {
  1220. for (let node of changedNodes){delete node.changed};
  1221. };
  1222. if (mixDatas.labourCoes.updateData) labourCoeView.refresh();*/
  1223. window.location.href = '/main?project=' + projectID;
  1224. });
  1225. }
  1226. });
  1227. $('#delete_row').on('shown.bs.modal', function (e) {
  1228. var controller = projectObj.mainController, project = projectObj.project;
  1229. var selected = controller.tree.selected, parent = selected.parent;
  1230. var showinfo = "确认要删除当前选中行吗?";
  1231. var showN = false;
  1232. var cancelText = "否";
  1233. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  1234. if(isSingleSelect()||selectionChecking()){
  1235. showinfo = "是否删除其下的子项?";
  1236. showN = true;
  1237. cancelText = "取消";
  1238. }
  1239. }
  1240. $('#delete_showinfo').text(showinfo);
  1241. showN==true? $('#deleteN').show():$('#deleteN').hide();
  1242. $('#deleteCancel').text(cancelText);
  1243. function selectionChecking() {
  1244. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1245. let mainTreeMap = {};
  1246. for(let i =0;i<selection.rowCount;i++){
  1247. let tem_node = controller.tree.items[selection.row+i];
  1248. if(i==0){//第一个直接添加;
  1249. mainTreeMap[tem_node.getID()] = tem_node;
  1250. }else {
  1251. project.Bills.setNodeToMap(tem_node,mainTreeMap);
  1252. }
  1253. }
  1254. let nodes = changeMapToArray(mainTreeMap);
  1255. if(nodes.length==1){
  1256. return true
  1257. }
  1258. return false;
  1259. }
  1260. });
  1261. function changeMapToArray(map) {
  1262. let newArray = [];
  1263. for(let key in map){
  1264. newArray.push(map[key]);
  1265. }
  1266. return newArray;
  1267. }
  1268. $('#deleteY').click(function () { //正常删除,级联删除子项
  1269. let project = projectObj.project;
  1270. if(isSingleSelect()){
  1271. project.Bills.deleteSelectedNode();
  1272. }else {
  1273. project.Bills.deleteSelectedNodes();
  1274. }
  1275. });
  1276. $('#deleteN').click(function () {//不删除子项
  1277. let controller = projectObj.mainController, project = projectObj.project;
  1278. let selected = controller.tree.selected, parent = selected.parent;
  1279. if(selected){
  1280. let preNode = selected.preSibling;
  1281. let nextNode = selected.nextSibling;
  1282. if(preNode){//有前兄弟
  1283. if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
  1284. alert("删除分部会导致分部和分项同级,不允许该操作!");
  1285. return;
  1286. }
  1287. }else if(nextNode){
  1288. if(nextNode.data.type != selected.children[0].data.type){
  1289. alert("删除分部会导致分部和分项同级,不允许该操作! ");
  1290. return;
  1291. }
  1292. }
  1293. project.Bills.singleDeleteBills(selected,controller);
  1294. }
  1295. });
  1296. function isSingleSelect() {//是否选中造价书中的单行
  1297. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1298. if (selections[0].rowCount == 1) {
  1299. return true;
  1300. }
  1301. return false;
  1302. }
  1303. function ifCanDelete() {
  1304. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1305. let tree = projectObj.project.mainTree;
  1306. let selected = projectObj.project.mainTree.selected;
  1307. if(selections[0].rowCount==1){//选中单行
  1308. return canDelete(selected);
  1309. }else {
  1310. return canDelete_m(selections[0]);
  1311. }
  1312. function canDelete(node,m_selection) {
  1313. if (node) {
  1314. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  1315. if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
  1316. return false;
  1317. }
  1318. }
  1319. if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
  1320. return false;
  1321. }
  1322. return true;
  1323. } else {
  1324. return false;
  1325. }
  1326. };
  1327. function canDelete_m(selection) {
  1328. for(let i =0;i<selection.rowCount;i++){
  1329. if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
  1330. return false;
  1331. }
  1332. if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
  1333. return false
  1334. }
  1335. if(canDelete(tree.items[selection.row+i],true)==false){
  1336. return false
  1337. }
  1338. }
  1339. return true
  1340. };
  1341. }