project_view.js 87 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987
  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. let mainSheet = projectObj.mainController.sheet;
  24. //设置选中行底色和恢复前选中行底色
  25. let refreshNodes = [node];
  26. if(!project.mainTree.preSelected){
  27. refreshNodes.push(project.mainTree.items[0]);
  28. }
  29. else {
  30. refreshNodes.push(project.mainTree.preSelected);
  31. }
  32. project.mainTree.preSelected = node;
  33. projectObj.setNodesStyle(projectObj.mainController.sheet, refreshNodes);
  34. subViewObj.loadComments(node);
  35. gljOprObj.showDataIfRationSelect(node);
  36. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  37. calcProgramObj.showData(node);
  38. }
  39. //zhong 2017-9-1 特征及内容
  40. if(pageCCOprObj.active){
  41. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  42. if(node && node.sourceType === project.Bills.getSourceType()){
  43. pageCCOprObj.setCacheAndShow(node);
  44. }
  45. else{
  46. pageCCOprObj.clearData();
  47. }
  48. }
  49. // for test interface. CSLAAAAA
  50. // projectObj.testDisplay('前四项累计值排除当前选中项' + projectObj.project.calcProgram.getBeforeTaxTotalFee([node]));
  51. // 基数
  52. // node.data.isSubcontract = true;
  53. // node.data.gljList = project.ration_glj.getGljArrByRation(node.data);
  54. // let bname = '甲供定额基价材料费';
  55. // projectObj.testDisplay(bname, rationCalcBases[bname](node));
  56. },
  57. refreshBaseActn: function (tree) {
  58. let setButtonValid = function (valid, btn) {
  59. if (valid) {
  60. btn.removeClass('disabled');
  61. } else {
  62. btn.addClass('disabled');
  63. }
  64. };
  65. let selected = tree.selected, that = projectObj;
  66. let canUpLevel = function (node) {
  67. if(!node){
  68. return false;
  69. }
  70. if(projectObj.project.isBillsLocked()== true){
  71. return false;
  72. }
  73. if(node.depth()<=1){//焦点行是树结构的第一/二层节点,灰显。
  74. return false;
  75. }
  76. if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机,灰显。
  77. return false;
  78. }else {
  79. if(node.data.type == billType.FX){//是分项,灰显。
  80. return false;
  81. }
  82. if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟,有子项.
  83. if(node.children[0].data.type==billType.FX){ //焦点行子项是分项
  84. return false;
  85. }
  86. }
  87. if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
  88. if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
  89. return false;
  90. }
  91. if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
  92. return false;
  93. }
  94. }
  95. }
  96. return true;
  97. };
  98. let canDownLevel = function (node) {
  99. if(!node){
  100. return false;
  101. }
  102. if(projectObj.project.isBillsLocked()== true){
  103. return false;
  104. }
  105. if(node.depth()==0){//焦点行是树结构的第一层节点,灰显。
  106. return false;
  107. }
  108. if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机,灰显。
  109. return false;
  110. }else {
  111. if(node.data.type == billType.FX){//是分项,灰显。
  112. return false;
  113. }
  114. if(!node.preSibling){//无前兄弟,灰显
  115. return false;
  116. }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
  117. return false
  118. }
  119. if(node.preSibling.children.length>0){//前兄弟有子项,子项是分项,灰显。
  120. if(node.data.type==billType.FB&&node.preSibling.children[0].data.type==billType.FX){//焦点行是分部前兄弟有子项,子项是分项,灰显。
  121. return false;
  122. }
  123. if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单,子项不是清单
  124. return false
  125. }
  126. }
  127. }
  128. return true;
  129. };
  130. let canUpMove = function (node) {
  131. if(node&&node.preSibling){//有前兄弟
  132. if(node.sourceType==that.project.Bills.getSourceType()){
  133. if(projectObj.project.isBillsLocked()== true){
  134. return false;
  135. }
  136. if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
  137. return false;
  138. }
  139. }
  140. return true
  141. }
  142. return false
  143. };
  144. let canDownMove = function (node) {
  145. if(node&&node.nextSibling){
  146. if(node.sourceType==that.project.Bills.getSourceType()){
  147. if(projectObj.project.isBillsLocked()== true){
  148. return false;
  149. }
  150. if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
  151. return false;
  152. }
  153. }
  154. return true;
  155. }
  156. return false
  157. };
  158. setButtonValid(ifCanDelete(), $('#delete'));
  159. setButtonValid(canUpLevel(selected), $('#upLevel'));
  160. setButtonValid(canDownLevel(selected), $('#downLevel'));
  161. setButtonValid(canUpMove(selected) , $('#upMove'));
  162. setButtonValid(canDownMove(selected), $('#downMove'));
  163. },
  164. checkCommonField: function (editingText, colSetting) {
  165. let value;
  166. if (colSetting.data.decimal) {
  167. value = Number(editingText);
  168. if (number_util.isNumber(value)) {
  169. if (colSetting.data.decimal) {
  170. value = value.toDecimal(colSetting.data.decimal);
  171. }
  172. } else {
  173. value = null;
  174. alert('当前输入的数据类型不正确,请重新输入。');
  175. }
  176. } else {
  177. value = editingText;
  178. }
  179. return value;
  180. },
  181. checkFormulaValidField: function (editingText, colSetting) {
  182. let value = Number(editingText);
  183. if (!value) {
  184. try {
  185. let exp = new Expression('');
  186. exp.Expression(editingText);
  187. value = Number(exp.Evaluate());
  188. } catch (error) {
  189. value = null;
  190. }
  191. }
  192. if (value!=undefined||value!=null) {
  193. if (colSetting.data.decimal) {
  194. value = value.toDecimal(colSetting.data.decimal);
  195. }
  196. } else if (editingText && editingText !== '') {
  197. value = null;
  198. alert('当前输入的数据类型不正确,请重新输入。');
  199. }
  200. return value;
  201. },
  202. checkSpreadEditingText: function (editingText, colSetting) {
  203. if (colSetting.data.field === 'quantity'||colSetting.data.field === 'contain') {
  204. return this.checkFormulaValidField(editingText, colSetting);
  205. }
  206. else if (colSetting.data.field === 'programID') {
  207. return this.project.calcProgram.compiledTemplateMaps[editingText];
  208. }
  209. else if (colSetting.data.field === 'subType') {
  210. if (typeof(editingText) !== "number")
  211. return volumePriceMaps[editingText]
  212. else
  213. return editingText;
  214. }
  215. else {
  216. return this.checkCommonField(editingText, colSetting);
  217. }
  218. },
  219. getVisibleRows: function (sRow, count) {
  220. let rst = [];
  221. let nodes = projectObj.project.mainTree.items;
  222. for(let i = sRow, len = nodes.length; i < len; i++){
  223. if(count <= 0){
  224. break;
  225. }
  226. if(nodes[i].visible){
  227. rst.push(i);
  228. count--;
  229. }
  230. }
  231. return rst;
  232. },
  233. //获取粘贴更改的单元格(粘贴时,跳过隐藏行)
  234. checkSpreadChangedCells: function (info) {
  235. let rst = {refreshRows: [], changedCells: []};
  236. //获取显示行号
  237. let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
  238. let vCount = vRows.length;
  239. let lastRow = null, count = 0;
  240. for(let cell of info.changedCells){
  241. cell.text = info.sheet.getCell(cell.row, cell.col).text();
  242. if(cell.row !== lastRow){
  243. count++;
  244. lastRow = cell.row;
  245. }
  246. if(count <= vCount){
  247. if(vRows[count - 1] !== cell.row){
  248. rst.refreshRows.push(cell.row);
  249. }
  250. rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
  251. }
  252. else {
  253. rst.refreshRows.push(cell.row);
  254. }
  255. }
  256. rst.refreshRows = Array.from(new Set(rst.refreshRows));
  257. return rst;
  258. },
  259. updateBillsCode: function (node, value) {
  260. let project = projectObj.project,me = this;
  261. let stdMatchCode, formatCode, matchs;
  262. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  263. let orgCode = node.data.code?node.data.code.substr(0, 9):"";
  264. if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
  265. normalUpdate(node,value);
  266. } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
  267. let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
  268. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  269. if (data) {
  270. //data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
  271. node.data.name = data.name;
  272. if(node.data.type == billType.BX){//从清单库中找到标准清单的话,要把补项改成分项
  273. node.data.type = billType.FX;
  274. }
  275. pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
  276. if (/\//.test(data.unit)) {
  277. let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
  278. if (existB) {
  279. data.unit = existB.unit;
  280. //
  281. project.Bills.replaceBills(node.source, data, formatCode);
  282. projectObj.mainController.refreshTreeNode([node], false);
  283. } else {
  284. ConfirmModal.stdBillsUnit.check(data, function (std) {
  285. project.Bills.replaceBills(node.source, std, formatCode);
  286. projectObj.mainController.refreshTreeNode([node], false);
  287. }, function () {
  288. projectObj.mainController.refreshTreeNode([node], false);
  289. });
  290. }
  291. } else {
  292. project.Bills.replaceBills(node.source, data, formatCode);
  293. projectObj.mainController.refreshTreeNode([node], false);
  294. }
  295. } else {
  296. normalUpdate(node,value);
  297. }
  298. });
  299. }
  300. }
  301. if(node.data.type==billType.FX||node.data.type==billType.BX||(node.data.type==billType.BILL&&node.source.children.length==0)){//是分项、补项或者叶子清单的情况下才需要查找替换
  302. if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
  303. stdMatchCode = value;
  304. formatCode = project.Bills.newFormatCode(stdMatchCode);
  305. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  306. return;
  307. } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
  308. stdMatchCode = value.substr(0, 9);
  309. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  310. if (matchs.indexOf(value) === -1) {
  311. searchStdBillsAndUpdate(stdMatchCode, value);
  312. return;
  313. } else {
  314. if (confirm('已存在该编码的清单,是否继续?')) {
  315. // formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  316. searchStdBillsAndUpdate(stdMatchCode, value);
  317. return;
  318. }else {
  319. this.mainController.refreshTreeNode([node], false);
  320. return;
  321. }
  322. }
  323. }
  324. }
  325. normalUpdate(node,value);
  326. function normalUpdate(billnode,codeValue) {//在标准库中没有找到清单时改分项为补项再更新
  327. let toBX = false;
  328. if(billnode.data.type == billType.FX){
  329. billnode.data.type = billType.BX;
  330. toBX = true;
  331. }
  332. project.Bills.updateField(billnode.source, 'code', codeValue, toBX);
  333. me.mainController.refreshTreeNode([billnode], false);
  334. }
  335. },
  336. updateRationCode: function (node, value) {
  337. if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
  338. return;
  339. }
  340. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  341. alert('当前项目无定额库,请添加定额库。');
  342. this.mainController.refreshTreeNode([node], false);
  343. } else {
  344. let libId = parseInt($('#stdRationLibSelect').val());
  345. CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
  346. if (data) {
  347. projectObj.project.Ration.replaceRation(node.source, data);
  348. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  349. } else {
  350. alert('当前库中找不到定额"' + value + '"');
  351. }
  352. projectObj.mainController.refreshTreeNode([node], false);
  353. });
  354. }
  355. },
  356. updateCode: function (node, value) {
  357. let project = projectObj.project;
  358. if (node.sourceType === project.Bills.getSourceType()) {
  359. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  360. } else if (node.sourceType === project.Ration.getSourceType()) {
  361. if(value && typeof(value) == 'string'){//小写转换成大写
  362. value = value.toUpperCase();
  363. }
  364. project.Ration.updateRationCodes([{'node':node,value:value}]);
  365. // this.updateRationCode(node, value); // 新套定额适合实时计算
  366. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  367. /*project.calcProgram.calcAndSave(node);
  368. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  369. calcProgramObj.showData(node, false);
  370. };*/
  371. }
  372. },
  373. updateNodeField : function (node,value,filedID,callback) {
  374. if(node.data[filedID] == value){
  375. return;
  376. }
  377. let data = {
  378. type:node.sourceType,
  379. data:{
  380. ID:node.data.ID
  381. }
  382. };
  383. data.data[filedID] = value;
  384. $.bootstrapLoading.start();
  385. projectObj.project.updateNodes([data],function () {
  386. node.data[filedID] = value;
  387. if(callback){
  388. callback();
  389. }
  390. $.bootstrapLoading.end();
  391. })
  392. },
  393. updateCellValue: function (node, value, colSetting,editingText) {
  394. let project = projectObj.project, fieldName = colSetting.data.field;
  395. if(node.sourceType==project.ration_glj.getSourceType()){
  396. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  397. }else if(fieldName === 'remark'){
  398. projectObj.updateNodeField(node,value,'remark');
  399. } else if(calcTools.isGljRation(node)){
  400. gljOprObj.updateRationTypeGLJ(value,node,fieldName,editingText);
  401. } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  402. if (fieldName === 'code' && !calcTools.isVolumePrice(node)) {
  403. projectObj.updateCode(node, value);
  404. }
  405. else if(fieldName ==='feeRate'){
  406. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  407. }
  408. else if(fieldName ==='contain'){//编辑含量
  409. project.Ration.updateContain(value,node);
  410. }
  411. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee' || fieldName === 'programID' ||
  412. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
  413. if (fieldName === 'quantity') {
  414. project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
  415. return;
  416. }
  417. else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee') {
  418. if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
  419. }
  420. else if (fieldName === 'calcBase') {
  421. //zhong
  422. if(value === undefined ||value === null || value.toString().trim() === ''){
  423. value = '';
  424. }
  425. node.data.userCalcBase = value;
  426. project.calcBase.calculate(node);
  427. if(!project.calcBase.success){
  428. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  429. projectObj.mainController.refreshTreeNode([node]);
  430. return;
  431. }
  432. // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
  433. };
  434. //计算基数赋值要经过解析和标准化,已在calculate里赋值
  435. if(fieldName !== 'calcBase'){
  436. calcTools.setFieldValue(node, fieldName, value);
  437. };
  438. project.calcProgram.calcAndSave(node);
  439. gljOprObj.showRationGLJSheetData();
  440. }
  441. else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
  442. node.data[fieldName] = value;
  443. node.changed = true;
  444. if(node.data.quantity){
  445. node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  446. }
  447. project.calcProgram.calcAndSave(node);
  448. }
  449. else {
  450. if (node.sourceType === project.Bills.getSourceType()) {
  451. project.Bills.updateField(node.source, fieldName, value, false);
  452. }
  453. else if (node.sourceType === project.Ration.getSourceType()) {
  454. project.Ration.updateField(node.source, fieldName, value);
  455. };
  456. if (colSetting.data.wordWrap) {
  457. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  458. }
  459. projectObj.mainController.refreshTreeNode([node]);
  460. }
  461. }
  462. else if(value==null && fieldName ==='feeRate'){
  463. project.FeeRate.cleanFeeRateID(node);
  464. }
  465. else {
  466. projectObj.mainController.refreshTreeNode([node], false);
  467. }
  468. },
  469. mainSpreadLeaveCell: function (sender, info) {
  470. let colSetting = projectObj.mainController.setting.cols[info.col];
  471. projectObj.lastCol = colSetting;
  472. projectObj.lastCell = {row: info.row, col: info.col};
  473. },
  474. //repaint 动态下拉框
  475. mainSpreadEnterCell: function (sender, info) {
  476. console.log('enterCell');
  477. let colSetting = projectObj.mainController.setting.cols[info.col];
  478. if(colSetting.data.field === 'unit' || (projectObj.lastCol&&projectObj.lastCol.data.field === 'unit')||colSetting.data.field ==='subType'
  479. || (projectObj.lastCol&&projectObj.lastCol.data.field === 'subType') || colSetting.data.field === 'programID' ||(projectObj.lastCol&&projectObj.lastCol.data.field === 'programID')){
  480. let rects = [];
  481. rects.push(info.sheet.getCellRect(info.row, info.col));
  482. if(projectObj.lastCell){
  483. rects.push(info.sheet.getCellRect(projectObj.lastCell.row, projectObj.lastCell.col));
  484. }
  485. for(let rect of rects){
  486. info.sheet.repaint(rect);
  487. }
  488. }
  489. },
  490. mainSpreadEditStarting: function (sender, info) {
  491. let project = projectObj.project;
  492. let node = project.mainTree.items[info.row];
  493. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  494. let orgV = info.sheet.getValue(info.row, info.col);
  495. let newV;
  496. if(node && node.sourceType === projectObj.project.Ration.getSourceType() && node.data.type === rationType.ration
  497. && isDef(node.data.code) && isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none && fieldName === 'code'){
  498. if(node.data.prefix === rationPrefix.complementary){
  499. newV = orgV.replace(new RegExp('补'), '');
  500. }
  501. if(node.data.prefix === rationPrefix.borrow){
  502. newV = orgV.replace(new RegExp('借'), '');
  503. }
  504. info.sheet.setValue(info.row, info.col, newV);
  505. }
  506. },
  507. onCellDoubleClick: function (sender, info){
  508. let project = projectObj.project;
  509. let node = project.mainTree.items[info.row];
  510. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  511. if(fieldName == 'marketUnitFee'){
  512. if(gljOprObj.hasComposition(node.data,true)){
  513. alert("当前人材机的市场价由组成物计算得出,不可直接修改。");
  514. return;
  515. }
  516. }
  517. },
  518. mainSpreadEditEnded: function (sender, info) {
  519. let project = projectObj.project;
  520. let node = project.mainTree.items[info.row];
  521. let colSetting = projectObj.mainController.setting.cols[info.col];
  522. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  523. // 检查输入类型等
  524. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  525. projectObj.updateCellValue(node, value, colSetting,info.editingText);
  526. // 自动行高
  527. const autoHeight = project.property.displaySetting.autoHeight;
  528. if (autoHeight) {
  529. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  530. }
  531. },
  532. msClipboardChanged: function (sender, info) {
  533. let colSettings = projectObj.mainController.setting.cols;
  534. let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
  535. sheetCommonObj.copyTextToClipboard(cDatas);
  536. return;
  537. },
  538. mainSpreadRangeChanged: function (sender, info) {
  539. let project = projectObj.project, setting = projectObj.mainController.setting;
  540. let changedObj = projectObj.checkSpreadChangedCells(info);
  541. let refreshNodes = [];
  542. for(let row of changedObj.refreshRows){
  543. refreshNodes.push(project.mainTree.items[row]);
  544. }
  545. let updateRationCodes = [];//更新定额编码时要用同步的方式
  546. if(changedObj.changedCells.length > 0){
  547. for (let changedCell of changedObj.changedCells) {
  548. let node = project.mainTree.items[changedCell.row];
  549. let colSetting = setting.cols[changedCell.col];
  550. let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
  551. if(colSetting.data.field=='code'&& node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
  552. updateRationCodes.push({'node':node,value:value});
  553. }else {
  554. projectObj.updateCellValue(node, value, colSetting,changedCell.text);
  555. }
  556. }
  557. }
  558. if(updateRationCodes.length>0){
  559. project.Ration.updateRationCodes(updateRationCodes);
  560. }
  561. if(refreshNodes.length > 0){
  562. projectObj.mainController.refreshTreeNode(refreshNodes);
  563. }
  564. },
  565. checkMainSpread: function () {
  566. if (!this.mainSpread) {
  567. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  568. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  569. this.mainSpread.getActiveSheet().name('mainSheet');
  570. }
  571. },
  572. refreshMainSpread: function () {
  573. if (this.mainSpread) {
  574. this.mainSpread.refresh();
  575. }
  576. },
  577. loadProjectData: function () {
  578. var that = this;
  579. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  580. let startTime = +new Date();
  581. console.log("开始加载-----"+startTime);
  582. $.bootstrapLoading.start();
  583. this.project.loadDatas(function (err) {
  584. let mTime = +new Date();
  585. console.log(`get data时间——${mTime - startTime}`);
  586. if (!err) {
  587. that.project.projectGLJ.calcQuantity(true);//计算分部分项和技术措施项目消耗量;
  588. let quantityTime = +new Date();
  589. console.log(`计算quantity时间——${quantityTime - mTime}`);
  590. that.project.property = projectInfoObj.projectInfo.property;
  591. //that.project.calcProgram.compileAllTemps();
  592. that.project.calcBase.init(that.project);
  593. // that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
  594. // that.project.initCalcFields();
  595. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  596. that.project.projSetting.mainGridSetting = JSON.parse(str);
  597. that.project.projSetting.mainGridSetting.frozenCols = 4;
  598. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  599. that.project.projSetting.mainGridSetting.setAutoFitRow = MainTreeCol.getEvent("setAutoFitRow");
  600. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  601. col.data.splitFields = col.data.field.split('.');
  602. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  603. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  604. }
  605. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  606. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  607. }
  608. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  609. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  610. col.data.cellType = getCellType;
  611. }
  612. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  613. // col.data.decimal = that.project.getDecimal(col.data.digit);
  614. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  615. // }
  616. if (col.data.field === 'code') {
  617. col.data.formatter = '@';
  618. }
  619. col.setAutoHeight = MainTreeCol.getEvent("setAutoHeight");
  620. col.editChecking = MainTreeCol.getEvent("editChecking");
  621. // 根据配置设置自动行高,在这里先做个标记,然后对每个单元格单独配置
  622. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  623. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  624. col.data.autoHeight = true;
  625. col.showHint = true;
  626. }
  627. if(col.data.field ==='quantity'){
  628. col.showHint = true;
  629. }
  630. // 综合单价、综合合价,小数部分应补0对齐。 CSLAAAAA
  631. // if (col.data.field.hasSubStr("common")){
  632. if (col.data.field.hasSubStr(".totalFee"))
  633. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true)
  634. else if (col.data.field.hasSubStr(".unitFee"))
  635. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true)
  636. // }
  637. });
  638. let startShowTime = +new Date();
  639. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  640. that.mainController.showTreeData();
  641. let endShowTime = +new Date();
  642. console.log(`show data时间——${endShowTime - startShowTime}`);
  643. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  644. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  645. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  646. setTimeout(function () {
  647. that.mainSpread.getActiveSheet().startEdit();//这两句需要挺多时间,而又需要在editend 事件前触发,而这些又不影响计算,所以这里用异步的方法
  648. that.mainSpread.getActiveSheet().endEdit();
  649. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  650. },100);
  651. that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
  652. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  653. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  654. that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);
  655. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  656. that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
  657. that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
  658. that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
  659. //let loadOtherStartTime = +new Date();
  660. that.loadMainSpreadContextMenu();
  661. that.loadFocusLocation();
  662. socketObject.connect();//连接socket服务器
  663. let endTime = +new Date();
  664. console.log(`其它时间——${endTime - endShowTime}`);
  665. console.log("加载完成-----"+endTime);
  666. console.log(`时间——${endTime - startTime}`);
  667. that.project.projectMarkChecking();//是否需要重新进行造价计算
  668. installationFeeObj.engineeringTypeChecking();//检查是否安装工程
  669. autoFlashHeight();
  670. projectObj.refreshMainSpread();
  671. //定位到会话中的选项
  672. let mainTabFocus = sessionStorage.getItem('mainTab') ? sessionStorage.getItem('mainTab') : '#tab_zaojiashu';
  673. $(`${mainTabFocus}`).click();
  674. $.bootstrapLoading.end();
  675. }
  676. else {
  677. }
  678. });
  679. },
  680. loadMainSpreadContextMenu: function () {
  681. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  682. $.contextMenu({
  683. selector: '#billsSpread',
  684. build: function ($trigger, e) {
  685. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  686. controller.setTreeSelected(controller.tree.items[target.row]);
  687. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  688. },
  689. items: {
  690. "insertRootBill": {
  691. name: "插入大项费用",
  692. icon: 'fa-sign-in',
  693. disabled: function () {
  694. return projectObj.project.isBillsLocked();
  695. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  696. },
  697. callback: function (key, opt) {
  698. ProjectController.addRootBill(project, controller);
  699. },
  700. visible: function(key, opt){
  701. return project.mainTree.selected&&project.mainTree.selected.parent==null;
  702. }
  703. },
  704. "insertFB": {
  705. name: "插入分部",
  706. icon: 'fa-sign-in',
  707. disabled: function () {
  708. let selected = project.mainTree.selected;
  709. if(projectObj.project.isBillsLocked()== false&&selected&&selected.sourceType==project.Bills.getSourceType()){
  710. if(selected.data.type==billType.FB){
  711. return false;
  712. }
  713. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  714. if(selected.children.length>0){
  715. return selected.children[0].data.type==billType.FX ||selected.children[0].data.type==billType.BX;//焦点行是分部分项工程,且子项是分项或补项
  716. }else {
  717. return false
  718. }
  719. }
  720. }
  721. return true;//除了清单,其它类型都只读
  722. },
  723. callback: function (key, opt) {
  724. ProjectController.addFB(project, controller);
  725. },
  726. visible: function(key, opt){
  727. if(project.mainTree.selected){
  728. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  729. }else {
  730. return false;
  731. }
  732. }
  733. },
  734. "insertFX": {
  735. name: "插入分项",
  736. icon: 'fa-sign-in',
  737. disabled: function () {
  738. let selected = project.mainTree.selected;
  739. if(projectObj.project.isBillsLocked()== false&& selected&&selected.sourceType==project.Bills.getSourceType()){
  740. if(selected.data.type==billType.FX||selected.data.type==billType.BX){//焦点行是分项,有效显示
  741. return false
  742. }
  743. if(selected.data.type==billType.FB){//点行是分部,
  744. if(selected.children.length>0){//且有子项,子项是分部,灰显。
  745. return selected.children[0].data.type == billType.FB
  746. }else {
  747. return false;
  748. }
  749. }
  750. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  751. if(selected.children.length>0){
  752. return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
  753. }else {
  754. return false
  755. }
  756. }
  757. }
  758. return true;//除了清单,其它类型都只读
  759. },
  760. callback: function (key, opt) {
  761. ProjectController.addFX(project, controller);
  762. },
  763. visible: function(key, opt){
  764. if(project.mainTree.selected){
  765. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  766. }else {
  767. return false;
  768. }
  769. }
  770. },
  771. "insertBills": {
  772. name: "插入清单",
  773. icon: 'fa-sign-in',
  774. disabled: function () {
  775. let selected = project.mainTree.selected;
  776. if(projectObj.project.isBillsLocked()== false && selected && selected.sourceType === project.Bills.getSourceType()){
  777. return false
  778. }
  779. return true;
  780. },
  781. callback: function (key, opt) {
  782. if(project.mainTree.selected.data.type == billType.DXFY){
  783. if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
  784. alert("当前有基数计算不能插入子项。");
  785. return;
  786. }
  787. }
  788. ProjectController.addBills(project, controller);
  789. },
  790. visible: function(key, opt){
  791. if(project.mainTree.selected){
  792. return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
  793. }else {
  794. return false;
  795. }
  796. }
  797. },
  798. "insertRation": {
  799. name: "插入定额",
  800. icon: 'fa-sign-in',
  801. disabled: function () {
  802. var selected = project.mainTree.selected;
  803. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  804. },
  805. callback: function (key, opt) {
  806. project.Ration.addNewRation(null,rationType.ration);
  807. // ProjectController.addRation(project, controller, rationType.ration);
  808. },
  809. visible: function(key, opt){
  810. var selected = project.mainTree.selected;
  811. if(selected){
  812. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  813. return false
  814. }else {
  815. return true
  816. }
  817. }
  818. return false;
  819. }
  820. },
  821. "insertLJ": {
  822. name: "插入量价",
  823. icon: 'fa-sign-in',
  824. disabled: function () {
  825. var selected = project.mainTree.selected;
  826. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  827. },
  828. callback: function (key, opt) {
  829. project.Ration.addNewRation(null,rationType.volumePrice);
  830. // ProjectController.addRation(project, controller, rationType.volumePrice);
  831. },
  832. visible: function(key, opt){
  833. var selected = project.mainTree.selected;
  834. if(selected){
  835. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  836. return false
  837. }else {
  838. return true
  839. }
  840. }
  841. return false;
  842. }
  843. },
  844. "insertGLJ": {
  845. name: "插入人材机",
  846. icon: 'fa-sign-in',
  847. disabled: function () {
  848. var selected = project.mainTree.selected;
  849. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  850. },
  851. callback: function (key, opt) {
  852. var selected = project.mainTree.selected;
  853. if(selected.sourceType == ModuleNames.bills){
  854. if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
  855. if(selected.data.calcBase&&selected.data.calcBase!=""){
  856. alert("当前有基数计算不能插入子项。");
  857. return;
  858. }
  859. }
  860. }
  861. getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
  862. },
  863. visible: function(key, opt){
  864. var selected = project.mainTree.selected;
  865. if(selected){
  866. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  867. return false;
  868. }else {
  869. return true;
  870. }
  871. }
  872. return false;
  873. }
  874. },
  875. "ZLFB": {
  876. name: "整理分部",
  877. icon: 'fa-sign-in',
  878. disabled: function () {
  879. return projectObj.project.isBillsLocked();
  880. },
  881. callback: function (key, opt) {
  882. zlfb_object.getSectionInfo();
  883. },
  884. visible: function(key, opt){
  885. return true;
  886. }
  887. },
  888. "calc_installation_fee": {
  889. name: "计取安装费用",
  890. icon: 'fa-sign-in',
  891. disabled: function () {
  892. return false;
  893. },
  894. callback: function (key, opt) {
  895. installationFeeObj.showCalcInstallSettingDiv();
  896. },
  897. visible: function(key, opt){
  898. let engineering = projectInfoObj.projectInfo.property.engineering;
  899. return engineering==engineeringType.BUILD_IN;
  900. }
  901. },
  902. "spr1": '--------',
  903. "delete": {
  904. name: '删除',
  905. icon: 'fa-remove',
  906. disabled: function () {
  907. return !ifCanDelete();
  908. },
  909. callback: function () {
  910. var selected = project.mainTree.selected;
  911. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  912. project.Bills.deleteSelectedNode();
  913. }else {
  914. $("#delete_row").modal({show:true});//弹出删除提示框;
  915. }
  916. }
  917. },
  918. "spr2":'--------',
  919. "calculateAll_RationContent": {
  920. name: '造价计算',
  921. callback: function () {
  922. project.calcProgram.calcAllNodesAndSave();
  923. }
  924. },
  925. "spr2":'--------',
  926. "copyBlock": {
  927. name: '复制整块',
  928. icon: 'fa-copy',
  929. disabled: function () {
  930. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  931. let firstNode = projectObj.project.mainTree.items[selection.row];//当多选的情况,用mainTree.selected判断不正确,要用第一个选中的节点
  932. return BlockController.copyBtnDisable(firstNode);
  933. },
  934. callback: function () {
  935. $.bootstrapLoading.start();
  936. //let selected = project.mainTree.selected;
  937. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  938. setTimeout(function () {
  939. BlockController.copyBlock(selections[0]);
  940. $.bootstrapLoading.end();
  941. },100)
  942. }
  943. },
  944. "spr2":'--------',
  945. "pasteBlock": {
  946. name: '粘贴整块',
  947. icon: 'fa-paste',
  948. disabled: function (){
  949. return BlockController.pasteBtnDisable(project.mainTree.selected);
  950. },
  951. callback: function () {
  952. BlockController.pasteBlock(project.mainTree.selected);
  953. }
  954. }
  955. }
  956. });
  957. },
  958. // 计算node及node的所有父项
  959. converseCalculateBills: function (node) {
  960. /* if (node) {
  961. let calc = new BillsCalcHelper(this.project);
  962. calc.calcNode(node, true);
  963. let cur = node, nodes = [];
  964. while (cur) {
  965. nodes.push(cur);
  966. cur = cur.parent;
  967. }
  968. this.mainController.refreshTreeNode(nodes, false);
  969. this.project.Bills.updateNodes(nodes, true);
  970. calc = null;
  971. }*/
  972. projectObj.project.calcProgram.calcAndSave(node);
  973. },
  974. // 计算全部清单
  975. /* calculateAll: function () {
  976. let calc = new BillsCalcHelper(this.project);
  977. calc.calcAll();
  978. this.mainController.showTreeData();
  979. this.project.Bills.updateAll();
  980. calc = null;
  981. }*/
  982. // 获取上次退出时的焦点位置
  983. loadFocusLocation: function() {
  984. const projectId = scUrlUtil.GetQueryString('project');
  985. let row = getLocalCache('lastRow:' + projectId);
  986. let col = getLocalCache('lastCol:' + projectId);
  987. if(row == null || col == null){
  988. row = 0;
  989. col = 0;
  990. }
  991. row = parseInt(row);
  992. col = parseInt(col);
  993. const sheet = this.mainSpread.getActiveSheet();
  994. sheet.setSelection(row, col, 1, 1);
  995. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  996. },
  997. // 选中区域合计数字
  998. amountAreaNumber: function(e, info) {
  999. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  1000. return false;
  1001. }
  1002. const selectedArea = info.newSelections[0];
  1003. const sheet = info.sheet;
  1004. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  1005. return false;
  1006. }
  1007. // 获取鼠标位置
  1008. let x = window.event.clientX;
  1009. let y = window.event.clientY;
  1010. // 匹配数字或小数
  1011. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  1012. // 小数点最高位数
  1013. let max = 0;
  1014. let total = 0;
  1015. let counter = 0;
  1016. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  1017. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  1018. const value = sheet.getCell(row, col).text();
  1019. if (!regular.test(value)) {
  1020. continue;
  1021. }
  1022. counter++;
  1023. // 获取当前数据小数位数
  1024. let pointPosition = value.toString().indexOf(".");
  1025. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  1026. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  1027. max = current > max ? current : max;
  1028. total += parseFloat(value);
  1029. }
  1030. }
  1031. // 如果不为0则悬浮显示
  1032. if (total > 0 && counter > 1) {
  1033. 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>');
  1034. div.css({
  1035. position: "absolute",
  1036. border: "1px #C0C0C0 solid",
  1037. background: "#fff",
  1038. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  1039. });
  1040. div.children("p").css({
  1041. textAlign: "center",
  1042. padding: 8,
  1043. marginBottom: 2,
  1044. });
  1045. div.children("p").first().css({
  1046. borderBottom: "1px #C0C0C0 solid"
  1047. });
  1048. const totalString = total.toFixed(max);
  1049. // input长度
  1050. const inputWidth = totalString.length * 8;
  1051. // 计算是否会超出显示范围
  1052. const baseWidth = 48;
  1053. const baseHeight = 81;
  1054. const canvasWidth = $("#billsSpreadvp_vp").width();
  1055. const canvasHeight = $("#billsSpreadvp_vp").height();
  1056. x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  1057. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  1058. div.css({
  1059. left: x,
  1060. top: y,
  1061. });
  1062. div.children().children("#total").width(inputWidth).val(totalString);
  1063. $("body").append(div);
  1064. // 用于判断是否要关闭窗体
  1065. setTimeout(function() {
  1066. isTotalShowing = true;
  1067. }, 200);
  1068. };
  1069. },
  1070. onButtonClick: function (e, info) {
  1071. let colSetting = projectObj.mainController.setting.cols[info.col];
  1072. let node = projectObj.project.mainTree.items[info.row];
  1073. let fieldName = colSetting.data.field;
  1074. if(fieldName == "isSubcontract"){
  1075. projectObj.onSubcontractClick(node);
  1076. }else if(fieldName == "isEstimate"){
  1077. projectObj.onIsEstimateClick(node,info);
  1078. }
  1079. },
  1080. onIsEstimateClick: function(node,info){
  1081. let checkboxValue = info.sheet.getCell(info.row, info.col).value();
  1082. let cell = info.sheet.getCell(info.row, info.col), newval = 0;
  1083. if (checkboxValue) {
  1084. newval = 0;
  1085. cell.value(newval);
  1086. } else {
  1087. newval = 1;
  1088. cell.value(newval);
  1089. }
  1090. if(MainTreeCol.readOnly.bills(node)){
  1091. projectObj.updateNodeField(node,newval,'isEstimate');
  1092. }else if(node.data.projectGLJID){//更新的是定额类型的工料机或者是显示在造价书页面的主材、设备
  1093. console.log(node);
  1094. let updateData = {id: node.data.projectGLJID, field: 'is_evaluate', value: newval};
  1095. projectObj.project.projectGLJ.pGljUpdate(updateData);
  1096. }
  1097. },
  1098. onSubcontractClick:function (node) {//点击分包费checkbox
  1099. if (node.data.isSubcontract) node.data.isSubcontract = false;
  1100. else node.data.isSubcontract = true;
  1101. node.changed = true;
  1102. projectObj.project.calcProgram.calcAndSave(node);
  1103. },
  1104. //根据节点获取行style(颜色、字体加粗)
  1105. getNodeColorStyle: function (sheet, node, colSetting = null) {
  1106. let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
  1107. let mapping = {DEFAULT: 'DEFAULT', SELECTED: 'SELECTED', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
  1108. FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
  1109. let styleMap = null;
  1110. //中文字段名,由于同一节点中,中文字体大小和数字字体大小不同
  1111. if(colorSetting == null){
  1112. return null;
  1113. }
  1114. let stringFields = [
  1115. 'code',
  1116. 'subType',
  1117. 'name',
  1118. 'unit',
  1119. 'itemCharacterText',
  1120. 'jobContentText',
  1121. 'adjustState',
  1122. 'calcBase',
  1123. 'programID',
  1124. 'ruleText'
  1125. ];
  1126. if(!isDef(node)){
  1127. return null;
  1128. }
  1129. //选中行
  1130. if(node === this.project.mainTree.selected){
  1131. styleMap = mapping.SELECTED;
  1132. }
  1133. //非选中行
  1134. else {
  1135. //清单大类
  1136. if(node.sourceType === this.project.Bills.getSourceType()){
  1137. //大项费用
  1138. if(node.data.type === billType.DXFY){
  1139. styleMap = mapping.DXFY;
  1140. }
  1141. //分部
  1142. if(node.data.type === billType.FB){
  1143. styleMap = mapping.FB;
  1144. }
  1145. //分项
  1146. else if(node.data.type === billType.FX){
  1147. styleMap = mapping.FX;
  1148. }
  1149. //补项
  1150. else if(node.data.type === billType.BX){
  1151. styleMap = mapping.BX;
  1152. }
  1153. //清单
  1154. else if(node.data.type === billType.BILL){
  1155. //非叶子节点的清单
  1156. if(node.source.children.length > 0){
  1157. styleMap = mapping.UNLEAFBILL;
  1158. }
  1159. //未使用基数计算的叶子节点的清单
  1160. else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
  1161. styleMap = mapping.UNCBBILL;
  1162. }
  1163. //使用基数计算的叶子节点的清单
  1164. else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
  1165. styleMap = mapping.CBBILL;
  1166. }
  1167. }
  1168. }
  1169. //定额下的主材、设备
  1170. else if(node.sourceType === this.project.ration_glj.getSourceType()){
  1171. styleMap = mapping.ZCSB;
  1172. }
  1173. else {
  1174. styleMap = mapping.DEFAULT;
  1175. }
  1176. }
  1177. let styleSetting = colorSetting[styleMap];
  1178. let defaultSetting = colorSetting[mapping.DEFAULT];
  1179. if(!isDef(styleSetting)){
  1180. return null;
  1181. }
  1182. let style = new GC.Spread.Sheets.Style();
  1183. //设置style属性
  1184. for(let attr in styleSetting){
  1185. if(attr !== 'stringFont' && attr !== 'numFont'){
  1186. style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
  1187. }
  1188. //暂时不开放字体设置,开放的话只能每个单元格进入此方法
  1189. /* else {
  1190. if(stringFields.indexOf(colSetting.data.field) > 0){
  1191. style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
  1192. }
  1193. else {
  1194. style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
  1195. }
  1196. }*/
  1197. }
  1198. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1199. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1200. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1201. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1202. return style;
  1203. },
  1204. //大项费用则字体加粗,String 15px, Number 13px
  1205. getBoldFontStyle: function (node, colSetting) {
  1206. let style = new GC.Spread.Sheets.Style();
  1207. if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
  1208. return null
  1209. }
  1210. //备注暂无字段
  1211. let stringFields = [
  1212. 'code',
  1213. 'subType',
  1214. 'name',
  1215. 'unit',
  1216. 'itemCharacterText',
  1217. 'jobContentText',
  1218. 'adjustState',
  1219. 'calcBase',
  1220. 'programID',
  1221. 'ruleText'
  1222. ];
  1223. if(stringFields.indexOf(colSetting.data.field) > 0){
  1224. style.font = 'bold 15px Arial';
  1225. }
  1226. else {
  1227. style.font = 'bold 13px Arial';
  1228. }
  1229. return style;
  1230. },
  1231. //设置节点style
  1232. setNodesStyle: function (sheet, nodes) {
  1233. let me = this;
  1234. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  1235. for(let node of nodes){
  1236. if(node && node.serialNo()!= -1){
  1237. sheet.getRange(node.serialNo(), -1, 1, -1).backColor(me.getNodeColorStyle(sheet, node).backColor);
  1238. }
  1239. }
  1240. });
  1241. },
  1242. loadLockBillsButton:function () {
  1243. if(projectInfoObj.projectInfo.property.lockBills == true){
  1244. $("a[name='lockBills']").prop("title","解锁清单");
  1245. $("a[name='lockBills']").html('<i class="fa fa-unlock-alt" aria-hidden="true"></i> 解锁清单');
  1246. }else {
  1247. $("a[name='lockBills']").prop("title","锁定清单");
  1248. $("a[name='lockBills']").html('<i class="fa fa-lock" aria-hidden="true"></i> 锁定清单');
  1249. }
  1250. }
  1251. };
  1252. // 点击合计框中的复制
  1253. $("body").on("click", "#total-tips a", function() {
  1254. const totalElement = $(this).parent().siblings("p").find("#total");
  1255. totalElement.select();
  1256. document.execCommand("Copy");
  1257. $(this).text("已复制");
  1258. });
  1259. // 合计框点击其他位置关闭
  1260. let isTotalShowing = false;
  1261. $("body").on("click", function(e) {
  1262. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  1263. $("#total-tips").remove();
  1264. isTotalShowing = false;
  1265. }
  1266. });
  1267. $('#insert').click(function () {
  1268. var controller = projectObj.mainController, project = projectObj.project;
  1269. var selected = controller.tree.selected;
  1270. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  1271. ProjectController.addBills(project, controller);
  1272. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1273. ProjectController.addRation(project, controller, selected.data.type);
  1274. };
  1275. });
  1276. $('#delete').click(function () {
  1277. let project = projectObj.project;
  1278. let selected = project.mainTree.selected;
  1279. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  1280. project.Bills.deleteSelectedNode();
  1281. }else {
  1282. $("#delete_row").modal({show:true});//弹出删除提示框;
  1283. }
  1284. });
  1285. $('#upLevel').click(function () {
  1286. var controller = projectObj.mainController, project = projectObj.project;
  1287. var selected = controller.tree.selected, orgParent = selected.parent;
  1288. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1289. project.Bills.upLevelBills(selected.source);
  1290. controller.upLevel();
  1291. controller.refreshTreeNode([orgParent]);
  1292. projectObj.project.calcProgram.calcBillsAndSave([selected,orgParent]);
  1293. }
  1294. });
  1295. $('#downLevel').click(function () {
  1296. var controller = projectObj.mainController, project = projectObj.project;
  1297. var selected = controller.tree.selected;
  1298. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1299. project.Bills.downLevelBills(selected.source);
  1300. controller.downLevel();
  1301. controller.refreshTreeNode([selected.parent]);
  1302. projectObj.converseCalculateBills(selected.parent);
  1303. }
  1304. });
  1305. $('#upMove').click(function () {
  1306. var controller = projectObj.mainController, project = projectObj.project;
  1307. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  1308. if (selected.sourceType === project.Bills.getSourceType()) {
  1309. project.Bills.upMoveBills(selected.source);
  1310. controller.upMove();
  1311. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1312. project.Ration.changePos(selected.source, selected.preSibling.source);
  1313. controller.upMove();
  1314. };
  1315. });
  1316. $('#downMove').click(function () {
  1317. var controller = projectObj.mainController, project = projectObj.project;
  1318. var selected = controller.tree.selected, next, nextSerialNo;
  1319. if (selected) {
  1320. if (selected.sourceType === project.Bills.getSourceType()) {
  1321. project.Bills.downMoveBills(selected.source);
  1322. controller.downMove();
  1323. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1324. project.Ration.changePos(selected.source, selected.nextSibling.source);
  1325. controller.downMove();
  1326. };
  1327. }
  1328. });
  1329. $("a[name='lockBills']").click(function () {
  1330. let lockBills = projectInfoObj.projectInfo.property.lockBills;
  1331. lockBills = !lockBills;
  1332. projectObj.project.updateLockBills(lockBills,function () {
  1333. var controller = projectObj.mainController, project = projectObj.project;
  1334. var selected = controller.tree.selected;
  1335. let nodes = _.filter(project.mainTree.items,{'sourceType':ModuleNames.bills});
  1336. controller.refreshTreeNode(nodes);
  1337. projectObj.mainController.setTreeSelected(selected);//触发树节点选中事件
  1338. projectObj.loadLockBillsButton();
  1339. pageCCOprObj.refreshRuleTools(lockBills);
  1340. });
  1341. });
  1342. //显示至..
  1343. let displayLevel = function(nodes, depth, type){
  1344. let refreshNodes = [];
  1345. function getExpandedController(){
  1346. if(type === 'DXFY' || type === 'FB'){
  1347. if(type === 'FB'){
  1348. projectObj.project.mainTree.items[0].setExpanded(true);
  1349. refreshNodes.push(projectObj.project.mainTree.items[0]);
  1350. }
  1351. return function expandedControl(nodes, depth){
  1352. let bType = type === 'FB' ? billType.FB : billType.DXFY;
  1353. for(let node of nodes){
  1354. let nodeDepth = node.depth();
  1355. if(nodeDepth <= depth){
  1356. let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
  1357. node.setExpanded(expanded);
  1358. refreshNodes.push(node);
  1359. if(nodeDepth < depth){
  1360. expandedControl(node.children, depth);
  1361. }
  1362. }
  1363. }
  1364. }
  1365. }
  1366. else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
  1367. return function expandedControl(nodes){
  1368. for(let node of nodes){
  1369. if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
  1370. let expanded = true;
  1371. if(type === 'FX'){
  1372. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
  1373. }
  1374. else if(type === 'ZM'){
  1375. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
  1376. }
  1377. node.setExpanded(expanded);
  1378. refreshNodes.push(node);
  1379. expandedControl(node.children);
  1380. }
  1381. }
  1382. }
  1383. }
  1384. }
  1385. getExpandedController()(nodes, depth);
  1386. let sheet = projectObj.mainSpread.getActiveSheet();
  1387. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  1388. TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
  1389. });
  1390. };
  1391. $('#displayDXFY').click(function () {
  1392. displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
  1393. });
  1394. //显示至一级分部
  1395. $('#displayFB1').click(function () {
  1396. displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
  1397. });
  1398. //二级分部
  1399. $('#displayFB2').click(function () {
  1400. displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
  1401. });
  1402. //三级分部
  1403. $('#displayFB3').click(function () {
  1404. displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
  1405. });
  1406. //四级分部
  1407. $('#displayFB4').click(function () {
  1408. displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
  1409. });
  1410. //分项
  1411. $('#displayFX').click(function () {
  1412. displayLevel(projectObj.project.mainTree.items, null, 'FX');
  1413. });
  1414. //子目
  1415. $('#displayZM').click(function () {
  1416. displayLevel(projectObj.project.mainTree.items, null, 'ZM');
  1417. });
  1418. //最底层
  1419. $('#displayZD').click(function () {
  1420. displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
  1421. });
  1422. $('#poj-set').on('show.bs.modal', function () {
  1423. let setCalcFlag = function (obj, val, curFlag) {
  1424. obj.val(val);
  1425. if (val === curFlag) {
  1426. obj.prop('checked', true);
  1427. } else {
  1428. obj.prop('checked', false);
  1429. }
  1430. }
  1431. if (projectObj.project) {
  1432. let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
  1433. let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  1434. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  1435. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  1436. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  1437. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  1438. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  1439. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  1440. projDisplayView.init();
  1441. calcOptions.init();
  1442. }
  1443. });
  1444. $('#property_ok').click(function () {
  1445. let project = projectObj.project,
  1446. projectID = project.ID(),
  1447. properties = {},
  1448. labourCoes = {},
  1449. rations = [],
  1450. bills = [],
  1451. mixDatas = {
  1452. projectID: projectID,
  1453. updateType: 'update',
  1454. properties: properties,
  1455. labourCoes: labourCoes,
  1456. rations: rations,
  1457. bills: bills
  1458. },
  1459. reCalcBills = false,
  1460. reCalcRations = false;
  1461. let b = parseInt($("input[name='calcFlag']:checked").val());
  1462. if (b !== project.property.billsCalcMode) {
  1463. properties['property.billsCalcMode'] = b;
  1464. project.property.billsCalcMode = b;
  1465. reCalcBills = true;
  1466. };
  1467. let zg = parseInt($("input[name='zangu']:checked").val());
  1468. if (zg !== project.property.zanguCalcMode) {
  1469. properties['property.zanguCalcMode'] = zg;
  1470. project.property.zanguCalcMode = zg;
  1471. reCalcRations = true;
  1472. };
  1473. //基本信息
  1474. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  1475. properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
  1476. }
  1477. //工程特征
  1478. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  1479. properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
  1480. }
  1481. //清单工程量精度
  1482. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  1483. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  1484. billsQuanDecimal.datas = newBillsDecimalDatas;
  1485. reCalcBills = true;
  1486. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  1487. }
  1488. //小数位数
  1489. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  1490. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  1491. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  1492. setDecimal(decimalObj, updateDecimal);
  1493. if (frChanged) {
  1494. project.calcProgram.compileAllTemps()
  1495. }
  1496. reCalcRations = true;
  1497. reCalcBills = true;
  1498. properties['property.decimal'] = updateDecimal;
  1499. }
  1500. // 呈现选项
  1501. projDisplayView.updateChecking(properties);
  1502. if(calcOptions.updateChecking(properties)){
  1503. reCalcRations = true;
  1504. }
  1505. // 人工系数
  1506. if (labourCoeView.needSave()){
  1507. let libID = $("#std_labour_coe_files").children("option:selected").val();
  1508. let libName = $("#std_labour_coe_files").children("option:selected").text();
  1509. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  1510. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  1511. project.calcProgram.compileAllTemps();
  1512. reCalcRations = true;
  1513. reCalcBills = true;
  1514. };
  1515. // 重新计算树节点
  1516. let changedNodes = [];
  1517. if (reCalcRations) // 定额动,全部计算。算完先不存储,和后面的数据一起提交,一次通讯。
  1518. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  1519. else if (reCalcBills) // 清单动,可以只计算清单。
  1520. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  1521. if (changedNodes.length > 0) {
  1522. for (let node of changedNodes){
  1523. let data = calcTools.cutNodeForSave(node);
  1524. if (node.sourceType == 'ration') rations.push(data)
  1525. else if (node.sourceType == 'bills') bills.push(data);
  1526. };
  1527. };
  1528. // for test.
  1529. /* console.log(mixDatas);
  1530. return; */
  1531. function hasMixData() {
  1532. return Object.keys(mixDatas.properties).length > 0 ||
  1533. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  1534. }
  1535. function needToReload(mixDatas){
  1536. if(Object.keys(mixDatas.labourCoes).length > 0){
  1537. return true;
  1538. }
  1539. if(Object.keys(mixDatas.properties).length > 0){
  1540. if(mixDatas.properties.hasOwnProperty('property.billsCalcMode') ||
  1541. mixDatas.properties.hasOwnProperty('property.zanguCalcMode') ||
  1542. mixDatas.properties.hasOwnProperty('property.calcOptions')||
  1543. mixDatas.properties.hasOwnProperty('property.billsQuantityDecimal')||
  1544. mixDatas.properties.hasOwnProperty('property.decimal')||
  1545. mixDatas.properties.hasOwnProperty('property.displaySetting')){
  1546. return true;
  1547. }
  1548. }
  1549. return false;
  1550. }
  1551. if(hasMixData()){
  1552. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  1553. //需要重载页面
  1554. if(needToReload(mixDatas)){
  1555. window.location.href = '/main?project=' + projectID;
  1556. }
  1557. else{
  1558. if(mixDatas.properties.hasOwnProperty('property.basicInformation')){
  1559. basicInfoView.orgDatas = basicInfoView.toViewDatas(mixDatas.properties['property.basicInformation']);
  1560. }
  1561. if(mixDatas.properties.hasOwnProperty('property.projectFeature')){
  1562. projFeatureView.orgDatas = projFeatureView.toViewDatas(mixDatas.properties['property.projectFeature']);
  1563. }
  1564. }
  1565. });
  1566. }
  1567. });
  1568. function testShow() {
  1569. var controller = projectObj.mainController, project = projectObj.project;
  1570. var selected = controller.tree.selected, parent = selected.parent;
  1571. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  1572. var showN = false;
  1573. var cancelText = "否";
  1574. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  1575. if(isSingleSelect()||selectionChecking()){
  1576. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  1577. showN = true;
  1578. cancelText = "取消";
  1579. }
  1580. }
  1581. $('#delete_showinfo').html(showinfo);
  1582. showN==true? $('#deleteN').show():$('#deleteN').hide();
  1583. $('#deleteCancel').text(cancelText);
  1584. function selectionChecking() {
  1585. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1586. let mainTreeMap = {};
  1587. for(let i =0;i<selection.rowCount;i++){
  1588. let tem_node = controller.tree.items[selection.row+i];
  1589. if(i==0){//第一个直接添加;
  1590. mainTreeMap[tem_node.getID()] = tem_node;
  1591. }else {
  1592. project.Bills.setNodeToMap(tem_node,mainTreeMap);
  1593. }
  1594. }
  1595. let nodes = changeMapToArray(mainTreeMap);
  1596. if(nodes.length==1){
  1597. return true
  1598. }
  1599. return false;
  1600. }
  1601. }
  1602. $('#delete_row').on('shown.bs.modal', function (e) {
  1603. var controller = projectObj.mainController, project = projectObj.project;
  1604. var selected = controller.tree.selected, parent = selected.parent;
  1605. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  1606. var showN = false;
  1607. var cancelText = "否";
  1608. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  1609. if(isSingleSelect()||selectionChecking()){
  1610. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  1611. showN = true;
  1612. cancelText = "取消";
  1613. }
  1614. }
  1615. $('#delete_showinfo').html(showinfo);
  1616. showN==true? $('#deleteN').show():$('#deleteN').hide();
  1617. $('#deleteCancel').text(cancelText);
  1618. function selectionChecking() {
  1619. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1620. let mainTreeMap = {}, nodes = [];
  1621. for(let i =0;i<selection.rowCount;i++){
  1622. let tem_node = controller.tree.items[selection.row+i];
  1623. if(i==0){//第一个直接添加;
  1624. mainTreeMap[tem_node.getID()] = tem_node;
  1625. }else {
  1626. project.Bills.setNodeToMapAndArray(tem_node,mainTreeMap,nodes);
  1627. }
  1628. }
  1629. if(nodes.length==1){
  1630. return true
  1631. }
  1632. return false;
  1633. }
  1634. });
  1635. function changeMapToArray(map) {
  1636. let newArray = [];
  1637. for(let key in map){
  1638. newArray.push(map[key]);
  1639. }
  1640. return newArray;
  1641. }
  1642. $('#deleteY').click(function () { //正常删除,级联删除子项
  1643. let project = projectObj.project;
  1644. project.Bills.deleteSelectedNodes();
  1645. /*if(isSingleSelect()){
  1646. project.Bills.deleteSelectedNode();//这个方法不用了,会出现异步删除干净的问题
  1647. }else {
  1648. project.Bills.deleteSelectedNodes();
  1649. }*/
  1650. });
  1651. $('#deleteN').click(function () {//不删除子项
  1652. let controller = projectObj.mainController, project = projectObj.project;
  1653. let selected = controller.tree.selected, parent = selected.parent;
  1654. if(selected){
  1655. let preNode = selected.preSibling;
  1656. let nextNode = selected.nextSibling;
  1657. if(preNode){//有前兄弟
  1658. if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
  1659. alert("删除分部会导致分部和分项同级,不允许该操作!");
  1660. return;
  1661. }
  1662. }else if(nextNode){
  1663. if(nextNode.data.type != selected.children[0].data.type){
  1664. alert("删除分部会导致分部和分项同级,不允许该操作! ");
  1665. return;
  1666. }
  1667. }
  1668. project.Bills.singleDeleteBills(selected,controller);
  1669. }
  1670. });
  1671. function isSingleSelect() {//是否选中造价书中的单行
  1672. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1673. if (selections[0].rowCount == 1) {
  1674. return true;
  1675. }
  1676. return false;
  1677. }
  1678. function ifCanDelete() {
  1679. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1680. let tree = projectObj.project.mainTree;
  1681. let selected = projectObj.project.mainTree.selected;
  1682. if(selections[0].rowCount==1){//选中单行
  1683. return canDelete(selected);
  1684. }else {
  1685. return canDelete_m(selections[0]);
  1686. }
  1687. function canDelete(node,m_selection) {
  1688. if (node) {
  1689. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  1690. if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
  1691. return false;
  1692. }
  1693. if(projectObj.project.isBillsLocked()== true){
  1694. return false;
  1695. }
  1696. }
  1697. if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
  1698. return false;
  1699. }
  1700. return true;
  1701. } else {
  1702. return false;
  1703. }
  1704. };
  1705. function canDelete_m(selection) {
  1706. for(let i =0;i<selection.rowCount;i++){
  1707. if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
  1708. return false;
  1709. }
  1710. if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
  1711. return false
  1712. }
  1713. if(canDelete(tree.items[selection.row+i],true)==false){
  1714. return false
  1715. }
  1716. }
  1717. return true
  1718. };
  1719. }
  1720. //选择要导入的excel文件
  1721. $('#customFile').change(function () {
  1722. let file = $(this)[0];
  1723. if(file.files.length > 0){
  1724. $('.custom-file-label').text(`${file.files[0].name} 准备导入上传`);
  1725. $('#uploadAlert').hide();
  1726. }
  1727. else{
  1728. $('.custom-file-label').text(`请选择上传文件`);
  1729. }
  1730. });
  1731. //从excel导入清单
  1732. $('#uploadConfirm').click(function () {
  1733. let me = this;
  1734. $(me).addClass('disabled');
  1735. try{
  1736. let formData = new FormData();
  1737. let file = $('#customFile')[0];
  1738. if(file.files.length <= 0){
  1739. throw '未选择文件';
  1740. }
  1741. formData.append('file', file.files[0]);
  1742. let projectID = scUrlUtil.GetQueryString('project');
  1743. if(!projectID || projectID <= 0){
  1744. throw '项目数据出错';
  1745. }
  1746. formData.append('projectID', projectID);
  1747. //要去匹配的清单库(第一个)
  1748. let matchBillLibId = projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0 ? projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id : null;
  1749. formData.append('billsLibId', matchBillLibId);
  1750. $.ajax({
  1751. url: '/bills/upload',
  1752. type: 'POST',
  1753. data: formData,
  1754. cache: false,
  1755. contentType: false,
  1756. processData: false,
  1757. beforeSend: function() {
  1758. $.bootstrapLoading.start();
  1759. },
  1760. success: function(response){
  1761. if (response.err === 0) {
  1762. const message = response.msg !== undefined ? response.msg : '';
  1763. if (message !== '') {
  1764. alert(message);
  1765. }
  1766. // 成功则关闭窗体
  1767. $('#import').modal("hide");
  1768. //更新前端
  1769. doAfterImport(response.data);
  1770. } else {
  1771. const message = response.msg !== undefined ? response.msg : '上传失败!';
  1772. $.bootstrapLoading.end();
  1773. alert(message);
  1774. }
  1775. $(me).removeClass('disabled');
  1776. },
  1777. error: function(){
  1778. alert("与服务器通信发生错误");
  1779. $.bootstrapLoading.end();
  1780. $(me).removeClass('disabled');
  1781. }
  1782. });
  1783. }
  1784. catch (err){
  1785. //alert(err);
  1786. showUploadAlert(false, err);
  1787. $(me).removeClass('disabled');
  1788. }
  1789. });
  1790. function showUploadAlert(success, msg){
  1791. if(!success){
  1792. $('#uploadAlert').removeClass('alert-success');
  1793. $('#uploadAlert').addClass('alert-danger');
  1794. }
  1795. else{
  1796. $('#uploadAlert').removeClass('alert-danger');
  1797. $('#uploadAlert').addClass('alert-success');
  1798. }
  1799. $('#uploadAlert').text(msg);
  1800. $('#uploadAlert').show();
  1801. }
  1802. //导入后更新操作
  1803. function doAfterImport(resData){
  1804. if(resData){
  1805. let nodes = projectObj.project.mainTree.nodes;
  1806. let bills_datas = projectObj.project.Bills.datas;
  1807. let ration_datas = projectObj.project.Ration.datas;
  1808. let quantity_detail_datas = projectObj.project.quantity_detail.datas;
  1809. let ration_glj_datas = projectObj.project.ration_glj.datas;
  1810. let ration_coe_datas = projectObj.project.ration_coe.datas;
  1811. let ration_install_datas = projectObj.project.ration_installation.datas;
  1812. let delNodes = [];
  1813. for(let billID of resData.remove.bill){
  1814. if(nodes['id_' + billID]){
  1815. delNodes.push(nodes['id_' + billID]);
  1816. }
  1817. //清除清单数据
  1818. _.remove(bills_datas, {ID: billID});
  1819. //清除清单工程量明细数据
  1820. _.remove(quantity_detail_datas, {billID: billID});
  1821. }
  1822. for(let rationID of resData.remove.ration){
  1823. //清除定额数据
  1824. _.remove(ration_datas, {ID: rationID});
  1825. //清除定额下的相关数据
  1826. _.remove(ration_glj_datas, {rationID: rationID});
  1827. _.remove(ration_coe_datas, {rationID: rationID});
  1828. _.remove(ration_install_datas, {rationID: rationID});
  1829. _.remove(quantity_detail_datas, {rationID: rationID});
  1830. }
  1831. //删除节点
  1832. if(delNodes.length > 0){
  1833. //通过固定清单获得删除节点的起始行索引
  1834. let beginRow = null;
  1835. if(resData.fixedBill){
  1836. let fixedNode = nodes['id_' + resData.fixedBill.ID];
  1837. if(fixedNode){
  1838. beginRow = projectObj.project.mainTree.items.indexOf(fixedNode) + 1;
  1839. }
  1840. }
  1841. //删除主树节点
  1842. projectObj.mainController.m_delete(delNodes, beginRow);
  1843. //删除清单树节点
  1844. let delIdNodes = [];
  1845. for(let delNode of delNodes){
  1846. delIdNodes.push(delNode.source);
  1847. }
  1848. projectObj.project.Bills.tree.m_delete(delIdNodes);
  1849. }
  1850. if(resData.insert.bill.length > 0){
  1851. //设置flagsIndex
  1852. for(let insertBill of resData.insert.bill){
  1853. insertBill.flagsIndex = {};
  1854. if (insertBill.flags) {
  1855. insertBill.flags.forEach(function (flag) {
  1856. insertBill.flagsIndex[flag.fieldName] = flag;
  1857. });
  1858. }
  1859. }
  1860. //插入清单节点
  1861. projectObj.project.Bills.tree.insertByDatas(resData.insert.bill);
  1862. //插入主树节点
  1863. let newNodes = projectObj.project.mainTree.insertByDatas(resData.insert.bill);
  1864. for(let node of newNodes){
  1865. node.source = projectObj.project.Bills.tree.nodes['id_' + node.getID()];
  1866. node.data = node.source.data;
  1867. node.sourceType = projectObj.project.Bills.getSourceType();
  1868. }
  1869. ProjectController.syncDisplayNewNodes(projectObj.mainController, newNodes);
  1870. }
  1871. //如果清单未锁定,导入后锁定清单
  1872. if(!projectInfoObj.projectInfo.property.lockBills){
  1873. $("a[name='lockBills']").click();
  1874. }
  1875. $.bootstrapLoading.end();
  1876. //重算
  1877. projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll, function () {
  1878. projectObj.project.projectGLJ.loadData(function () {
  1879. $.bootstrapLoading.end();
  1880. });
  1881. });
  1882. }
  1883. }
  1884. //下载导入清单示例文件
  1885. $('#uploadExample').click(function () {
  1886. window.location.href = '/bills/downloadExamp'
  1887. });
  1888. $(function () {
  1889. //清空导入清单选择文件
  1890. $('#import').on('show.bs.modal', function(){
  1891. $('#customFile').val('');
  1892. $('#uploadAlert').hide();
  1893. $('.custom-file-label').text(`请选择上传文件`);
  1894. });
  1895. $("#billsSpread").mouseover(function(){
  1896. spreadAutoFocus(projectObj.mainSpread,subSpread);
  1897. });
  1898. $("#subSpread").mouseover(function(){
  1899. spreadAutoFocus(subSpread,projectObj.mainSpread);
  1900. });
  1901. $("#paste_confirm").click(function (){
  1902. let selected = projectObj.project.mainTree.selected;
  1903. let blockData = BlockController.getBlockData();
  1904. let position = $("input[name='pastePositionRadio']:checked").val();
  1905. BlockController.confirmPaste(blockData,selected,position);
  1906. $("#pastePosition").modal("hide");
  1907. });
  1908. function spreadAutoFocus(spread,relateSpread) {
  1909. if(relateSpread&&relateSpread.getActiveSheet().isEditing()){//关联的spread不在编辑状态的情况下,才自动获得焦点;
  1910. return;
  1911. }else {
  1912. spread?spread.focus():'';
  1913. }
  1914. }
  1915. });