project_glj_view.js 60 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325
  1. /**
  2. * Created by zhang on 2018/3/13.
  3. */
  4. projectGljObject={
  5. showTag:'ration',//mixRatio/machine
  6. showMixRatioMark:'',
  7. displayType:filterType.ALL,
  8. mixRatioType: [gljType.CONCRETE, gljType.MORTAR, gljType.MIX_RATIO,gljType.MAIN_MATERIAL],
  9. machineType: [gljType.GENERAL_MACHINE],
  10. projectGljSetting:{},
  11. projectGljSpread:null,
  12. projectGljSheet:null,
  13. materialTreeSheet:null,
  14. projectGljSheetData:[],
  15. mixRatioSetting:{},
  16. materialTreeSetting:{
  17. "emptyRows":0,
  18. "headRows":1,
  19. "headRowHeight":[21],
  20. "defaultRowHeight": 21,
  21. "treeCol": 0,
  22. "cols":[]
  23. },
  24. materialSetting:{
  25. header:[
  26. {headerName: "编码", headerWidth: 200, dataCode: "code", dataType: "String"},
  27. {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"},
  28. {headerName: "规格型号", headerWidth: 120, dataCode: "specs", hAlign: "left", dataType: "String"},
  29. {headerName: "单位", headerWidth: 45, dataCode: "unit", hAlign: "center", dataType: "String"},
  30. {headerName: "定额价", headerWidth: 70, dataCode: "basePrice", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'glj.unitPrice'
  31. {headerName: "市场价", headerWidth: 70, dataCode: "marketPrice", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:"glj.unitPrice"
  32. {headerName: "总消耗量", headerWidth: 100, dataCode: "quantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'},
  33. {headerName: "三材系数", headerWidth: 100, dataCode: "materialCoe", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'material'
  34. {headerName: "三材量", headerWidth: 100, dataCode: "materialQuantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'},
  35. {headerName: "三材类别", headerWidth: 80, dataCode: "materialType", hAlign: "center", dataType: "String",cellType:'comboBox',editorValueType:true,options:materialComboMap}
  36. ],
  37. view: {
  38. lockColumns: [0,1,2,3,6,8]
  39. }
  40. },
  41. mixRatioSpread:null,
  42. mixRatioSheet:null,
  43. mixRatioData:[],
  44. usedTenderList:[],
  45. usedUnitPriceInfo:null,
  46. initProjectGljSpread:function () {
  47. if(!this.projectGljSpread){
  48. this.projectGljSpread = SheetDataHelper.createNewSpread($("#project_glj_sheet")[0],2);
  49. }
  50. this.projectGljSpread.bind(GC.Spread.Sheets.Events.RangeChanged, this.onProjectGljRangeChange);
  51. this.initProjectGljSheet();
  52. this.initMaterialTreeSheet();
  53. disableRightMenu("project_glj_sheet",this.projectGljSpread,this.rightClickCallback);
  54. //打开别人分享的项目,只读
  55. if(projectReadOnly){
  56. //锁定逻辑走disabledSpread里的
  57. if(this.projectGljSetting.view.lockColumns){
  58. this.projectGljSetting.view.lockColumns = null;
  59. }
  60. disableSpread(this.projectGljSpread);
  61. }
  62. },
  63. initProjectGljSheet:function () {
  64. this.projectGljSheet = this.projectGljSpread .getSheet(0);
  65. this.initSheet(this.projectGljSheet,this.projectGljSetting);
  66. this.projectGljSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onProjectGljSelectionChange);
  67. this.projectGljSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onProjectGljEditStarting);
  68. this.projectGljSheet.name('projectGljSheet');
  69. this.projectGljSheet.setRowHeight(0, 45, 1);
  70. },
  71. initMixRatio:function () {
  72. let me = projectGljObject;
  73. if(me.mixRatioSpread==null){
  74. me.initMixRatioSpread();
  75. if(!projectReadOnly){
  76. me.initRightClick();
  77. }
  78. }
  79. },
  80. initMixRatioSpread:function () {
  81. this.mixRatioSpread = SheetDataHelper.createNewSpread($("#mix_ratio_sheet")[0]);
  82. this.mixRatioSheet = this.mixRatioSpread .getSheet(0);
  83. this.initSheet(this.mixRatioSheet,this.mixRatioSetting);
  84. this.mixRatioSheet.name('mixRatioSheet');
  85. this.mixRatioSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onMixRatioRangeChange);
  86. if(projectReadOnly){
  87. if(this.mixRatioSetting.view.lockColumns){
  88. this.mixRatioSetting.view.lockColumns = null;
  89. }
  90. disableSpread(this.mixRatioSpread);
  91. }
  92. },
  93. initMaterialTreeSheet:function () {
  94. this.materialTreeSheet = this.projectGljSpread.getSheet(1);
  95. this.materialTreeSetting = this.createMaterialTreeSheetSetting();
  96. this.materialTree = cacheTree.createNew(this);
  97. this.materialTreeController = TREE_SHEET_CONTROLLER.createNew(this.materialTree, this.materialTreeSheet, this.materialTreeSetting);
  98. this.materialTreeController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, this.onSelectionChange);
  99. this.materialTreeSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onProjectGljEditStarting);
  100. this.materialTreeSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onProjectGLJValueChange);
  101. this.materialTreeSheet.name('materialTreeSheet');
  102. if(projectReadOnly && this.materialSetting.view.lockColumns){
  103. if(this.materialSetting.view.lockColumns){
  104. this.materialSetting.view.lockColumns = null;
  105. }
  106. }
  107. },
  108. createMaterialTreeSheetSetting:function () {
  109. return sheetCommonObj.transferToTreeSetting(this.materialSetting,this.materialTreeSetting);
  110. },
  111. unitPriceFileInit:function() {
  112. let me = this;
  113. let projectGLJ = projectObj.project.projectGLJ;
  114. let data = projectGLJ.datas;
  115. me.usedTenderList = data.usedTenderList !== undefined ? data.usedTenderList : [];
  116. me.usedUnitPriceInfo = data.constData.usedUnitPriceInfo !== undefined ?
  117. data.constData.usedUnitPriceInfo : {};
  118. $("#current-name").text(me.usedUnitPriceInfo.name);
  119. let usedCount = me.usedTenderList.length <= 0 ? 1 : me.usedTenderList.length;
  120. $("#used-project-count").text(usedCount);
  121. },
  122. getUsedTenderInfo:function() {
  123. return projectGljObject.usedTenderList.join("<br>");
  124. },
  125. filterLibGLJForMixRatio:function () {
  126. let me = this;
  127. if(me.selectedProjectGLJ){
  128. let showTypes = [];
  129. let materialArr = [202, 203, 204];//混凝土、砂浆、配合比,
  130. if(me.selectedProjectGLJ.type == gljType.MAIN_MATERIAL){//对于主材,只显示没有组成物并且除了自已的主材
  131. showTypes = [gljType.MAIN_MATERIAL];
  132. }else if(_.includes(materialArr,me.selectedProjectGLJ.type)){//混凝土、砂浆、配合比
  133. showTypes = [gljType.GENERAL_MATERIAL];
  134. }else if(me.selectedProjectGLJ.type == gljType.GENERAL_MACHINE){//机械类型可添加机械组成物、机上人工
  135. showTypes = [gljType.MACHINE_COMPOSITION,gljType.MACHINE_LABOUR];
  136. }
  137. gljOprObj.gljLibSheetData = _.filter(gljOprObj.gljLibSheetData, function (item) {
  138. if(me.selectedProjectGLJ.type == gljType.MAIN_MATERIAL){
  139. let p_index = gljOprObj.getIndex(me.selectedProjectGLJ,gljKeyArray);
  140. let i_index = gljOprObj.getIndex(item,gljLibKeyArray);
  141. return item.gljType == gljType.MAIN_MATERIAL &&item.component.length == 0 && p_index!=i_index
  142. }else {
  143. return _.includes(showTypes,item.gljType);
  144. }
  145. });
  146. }
  147. },
  148. addMixRatio:function () {
  149. let me = this, projectGLJ = projectObj.project.projectGLJ;
  150. for(let mix of me.mixRatioData){
  151. let m_key = gljOprObj.getIndex(mix, gljKeyArray);
  152. let t_index = gljOprObj.GLJSelection.indexOf(m_key);
  153. t_index != -1?gljOprObj.GLJSelection.splice(t_index,1):'';
  154. }
  155. projectGLJ.addMixRatio(gljOprObj.GLJSelection,function (mixRatios) {
  156. me.showMixRatioData();//这里添加的组成物的消耗量默认都是0,所以对父工料机的价格不会有影响,不用触发计算
  157. projectGLJ.loadData(function () {
  158. me.showProjectGljData();
  159. gljOprObj.showRationGLJSheetData();
  160. me.onUnitFileChange(me.selectedProjectGLJ);
  161. });
  162. });
  163. },
  164. showMixRatioData:function () {
  165. let me = this,gljId = null,gljType = null;
  166. let sheet = me.projectGljSpread.getActiveSheet();
  167. let oldSel = me.mixRatioSheet.getSelections()[0];
  168. if(sheet.name() == 'projectGljSheet'){//projectGljSheet/materialSheet 工料机汇总和三材汇总表
  169. let sel = me.projectGljSheet.getSelections()[0];
  170. let srow = sel.row == -1||sel.row == ""?0:sel.row;
  171. if(me.projectGljSheetData.length>srow){
  172. gljId = me.projectGljSheetData[srow].id;
  173. gljType = me.projectGljSheetData[srow].type;
  174. }
  175. }else if(sheet.name() == 'materialTreeSheet'){
  176. if(this.materialTree.selected){
  177. gljId = this.materialTree.selected.data.id;
  178. gljType = this.materialTree.selected.data.type;
  179. }
  180. }
  181. if(compositionTypes.indexOf(gljType)==-1){//如果不是有组成物的类型,工料机id设置为空,组成物表设置为空
  182. gljId = null
  183. }
  184. projectObj.project.projectGLJ.getRatioData(gljId,function (data) {
  185. if(gljId !== projectObj.project.projectGLJ.getRatioId){//两个id不一致说明不是最新的请求,不用往下执行。
  186. return;
  187. }
  188. let rationList =[];
  189. for(let glj of data){
  190. rationList.push(me.getMixRatioSheetData(glj)) ;
  191. }
  192. me.mixRatioData = rationList;
  193. me.mixRatioSheet.setRowCount(0);
  194. sheetCommonObj.showData(me.mixRatioSheet, me.mixRatioSetting,me.mixRatioData);
  195. me.mixRatioSheet.setRowCount(me.mixRatioData.length);
  196. me.mixRatioSheet.setSelection(oldSel.row==-1?0:oldSel.row,oldSel.col,oldSel.rowCount,oldSel.colCount);
  197. })
  198. },
  199. getMixRatioSheetData:function (glj) {
  200. let data ={
  201. id:glj.id,
  202. mix_ratio_id:glj.ratio_data.id,
  203. code:glj.code,
  204. name:glj.name,
  205. specs:glj.specs,
  206. unit:glj.unit,
  207. type:glj.type,
  208. short_name:projectObj.project.projectGLJ.getShortNameByID(glj.type),
  209. consumption:glj.ratio_data.consumption,
  210. unit_price:glj.unit_price,
  211. connect_key:glj.ratio_data.connect_key
  212. };
  213. gljOprObj.setGLJPrice(data,glj);
  214. return data;
  215. },
  216. onProjectGljEditStarting:function (sender, args) {
  217. let me = projectGljObject;
  218. let row = args.row;
  219. let col = args.col;
  220. if(me.projectGljEditChecking(row,col)==false){
  221. args.cancel = true;
  222. }
  223. },
  224. projectGljEditChecking:function (row,col,isPaste=false) {//return false表示不能编辑
  225. let me = projectGljObject;
  226. let data = null, setting=null;
  227. let sheet = me.projectGljSpread.getActiveSheet();
  228. if(sheet.name() == 'projectGljSheet'){
  229. if(row>=me.projectGljSheetData.length) return false;
  230. data = me.projectGljSheetData[row];
  231. setting = me.projectGljSetting;
  232. }else if(sheet.name() == 'materialTreeSheet'){
  233. data = me.materialTree.selected.data;
  234. setting = me.materialSetting;
  235. let notEditId= ['GC','GJ','MC','SN','SZ'];
  236. if(notEditId.indexOf(data.id)!= -1){
  237. return false;
  238. }
  239. }
  240. let dataCode = setting.header[col].dataCode;
  241. let lockColumns = setting.view.lockColumns;
  242. if(lockColumns.indexOf(col)!= -1){
  243. return false;
  244. }
  245. if(isPaste == false &&(dataCode=='is_adjust_price'||dataCode=='is_evaluate'||dataCode=='is_main_material')){//除了粘贴,拖动填充等操作,其它的都不能编辑
  246. return false;
  247. }
  248. if(dataCode=='basePrice'||dataCode=='marketPrice'||dataCode=='supply'){//有组成物时,市场单价、定额价、供货方式不能修改
  249. if (data.ratio_data && data.ratio_data.length > 0){
  250. return false;
  251. }
  252. if(dataCode=='basePrice'&&data.is_add!=1){//如果不是新增,定额价不可修改。
  253. return false;
  254. }
  255. }
  256. if(dataCode == 'supply_quantity'){
  257. if (data.supply != 1) {// 如果为部分甲供则甲供数量需要可编辑,其它的都不能编辑
  258. return false;
  259. }
  260. }
  261. if(dataCode == 'materialCoe'){//三材类别为空时,三材系数应只读,不允许输入。
  262. if(data.materialType == undefined || data.materialType == null||data.materialType==''){
  263. return false;
  264. }
  265. }
  266. return true;
  267. },
  268. onSelectionChange:function (){
  269. let me = projectGljObject;
  270. me.showMixRatioData();
  271. me.materialTreeSheet.repaint();
  272. },
  273. onProjectGljSelectionChange:function (sender, args) {
  274. let me = projectGljObject;
  275. let newSel = args.newSelections[0];
  276. let oldSel = args.oldSelections?args.oldSelections[0]:{};
  277. if(newSel.row != oldSel.row){
  278. me.projectGljRowChang();
  279. }
  280. me.projectGljSheet.repaint();
  281. },
  282. projectGljRowChang:function(row){
  283. let me = projectGljObject;
  284. let sel = me.mixRatioSheet.getSelections()[0];
  285. sel.row = -1;
  286. sel.col = 0;
  287. sel.rowCount = 1;
  288. sel.colCount = 1;
  289. me.showMixRatioData();
  290. },
  291. rightClickCallback:function (row) {
  292. let me = projectGljObject;
  293. let sheet = me.projectGljSpread.getActiveSheet();
  294. if(sheet.name() == 'projectGljSheet'){
  295. me.projectGljRowChang(row);
  296. }else if(sheet.name() == 'materialTreeSheet'){
  297. me.materialTreeController.setTreeSelected(me.materialTreeController.tree.items[row]);
  298. }
  299. },
  300. onProjectGljRangeChange:function (sender,info) {
  301. let me = projectGljObject;
  302. let changeInfo=[];
  303. let canChange = true;
  304. if(info.action == GC.Spread.Sheets.RangeChangedAction.clear){
  305. if(me.projectGljEditChecking(info.row,info.col) == false){
  306. canChange = false;
  307. }else {
  308. info.newValue = null;
  309. me.onProjectGLJValueChange(sender,info);
  310. return ;
  311. }
  312. }
  313. for(let c of info.changedCells){
  314. let value= info.sheet.getCell(c.row, c.col).text();
  315. changeInfo.push({row:c.row,col:c.col,value:value});
  316. if(me.projectGljEditChecking(c.row,c.col,true)==false){//如果不能编辑
  317. canChange = false;
  318. break;
  319. }
  320. if (!me.checkData(c.col,me.projectGljSetting,value)) {
  321. alert('输入的数据类型不对,请重新输入!');
  322. canChange = false;
  323. break;
  324. }
  325. }
  326. if(canChange == false){//恢复原来的值
  327. info.sheetName =="materialTreeSheet"?me.showMaterialTreeData():me.showProjectGljData();
  328. }else if(info.sheetName =="projectGljSheet"){
  329. me.batchUpdateProjectGLJ(changeInfo,info.sheetName);
  330. }
  331. },
  332. onMixRatioRangeChange:function (sender,info){
  333. let me = projectGljObject;
  334. let canChange = true;
  335. let changeInfo=[];
  336. if (info.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  337. info.newValue = 0;
  338. me.onMixRatioValueChange(sender,info);
  339. info.sheet.getCell(info.row, info.col).text(0);
  340. return ;
  341. }
  342. for(let c of info.changedCells){
  343. let value = info.sheet.getCell(c.row, c.col).text();
  344. if (!me.checkData(c.col,me.mixRatioSetting,value)) {
  345. alert('输入的数据类型不对,请重新输入!');
  346. canChange = false;
  347. break;
  348. }else {
  349. changeInfo.push({row:c.row,col:c.col,value:value});
  350. }
  351. }
  352. if(canChange == false){//数据类型不对
  353. me.showMixRatioData();
  354. }
  355. if(changeInfo.length > 0){
  356. me.batchUpdateConsumption(changeInfo);
  357. }
  358. },
  359. batchUpdateProjectGLJ:function(changeInfo,sheetName){
  360. let projectGLJ = projectObj.project.projectGLJ;
  361. let me = projectGljObject;
  362. let propertyCells=[],priceCells=[];
  363. let setting = sheetName =="materialTreeSheet"?me.materialSetting:me.projectGljSetting;
  364. for(let c of changeInfo){
  365. c.dataCode = setting.header[c.col].dataCode;
  366. if(c.dataCode == 'basePrice'||c.dataCode=='marketPrice'){
  367. priceCells.push(c);
  368. }else {
  369. propertyCells.push(c);
  370. }
  371. }
  372. me.batchUpdateGLJProperty(propertyCells,sheetName,function () {
  373. //价格属于单价文件表,如果与项目工料机的其它属性一起的话计算起来会比较复杂,同时出现价格与其它属性一起更新的情况也会比较少;
  374. projectGLJ.batchUpdatePrice(priceCells,sheetName,function (impactList) {
  375. me.refreshBySheetName(sheetName);
  376. gljOprObj.refreshView();
  377. });
  378. });
  379. },
  380. refreshBySheetName:function (sheetName) {
  381. let me = projectGljObject;
  382. if(sheetName =="projectGljSheet"){
  383. me.showProjectGljData();
  384. }else if(sheetName =="materialTreeSheet"){
  385. me.showMaterialTreeData();
  386. }
  387. },
  388. batchUpdateGLJProperty:function (changeInfo,sheetName,callback) {
  389. let me = projectGljObject,updateMap = {};
  390. let projectGLJ = projectObj.project.projectGLJ;
  391. for(let c of changeInfo){
  392. let recode = sheetName =="materialTreeSheet"?me.materialTree.items[c.row].data:me.projectGljSheetData[c.row];
  393. if(recode[c.dataCode] == c.value){
  394. continue;
  395. }
  396. me.getUpdateData(recode.id,c.value,c.dataCode,recode.quantity,updateMap);
  397. }
  398. if(_.isEmpty(updateMap)){
  399. callback?callback():'';
  400. return;
  401. }
  402. projectGLJ.batchUpdateGLJProperty(updateMap,callback);
  403. },
  404. getUpdateData :function (id,value,dataCode,quantity,updateMap) {
  405. let me = projectGljObject;
  406. let supplyMap = {"自行采购":0,"部分甲供":1,"完全甲供":2,"甲定乙供":3};
  407. let materialMap = {"钢材":1,"钢筋":2,"木材":3,"水泥":4,"标准砖":5};
  408. let data = updateMap[id]?updateMap[id]:{};
  409. //供货方式 和三材类型 粘贴和填充过来的数据,要做对应转换,因为这里value只是中文文本,并不是实际的值
  410. // 如果是供货方式则需要处理数据
  411. if (dataCode === 'supply') {
  412. if(supplyMap[value]!==undefined||supplyMap[value]!==null){
  413. value = supplyMap[value];
  414. }
  415. data.supply_quantity = me.getSupplyQuantity(value,quantity);
  416. }
  417. if(dataCode === 'supply_quantity'){//修改数量需做4舍5入
  418. value = scMathUtil.roundForObj(value,getDecimal('glj.quantity'));
  419. }
  420. if(dataCode === 'is_evaluate'||dataCode === 'is_adjust_price'||dataCode === 'is_main_material'){
  421. value = value? 1:0;
  422. }
  423. if(dataCode === 'materialType'){//三材类型要做对应转换,因为这里value只是中文文本,并不是实际的值
  424. if(materialMap[value]!==undefined||materialMap[value]!==null){
  425. value = materialMap[value];
  426. }
  427. if(value == null || value==""){//删除三材类别时,清空三材系数
  428. value = null;
  429. data.materialCoe = null;
  430. }
  431. }
  432. if(dataCode == 'materialCoe'){
  433. value = scMathUtil.roundForObj(value,getDecimal("material"));
  434. }
  435. data[dataCode] = value ;
  436. updateMap[id] = data;
  437. },
  438. batchUpdateConsumption:function(changeInfo){
  439. let projectGLJ = projectObj.project.projectGLJ;
  440. let me = projectGljObject;
  441. let updateMap = {},updateData = [],parentBasePrice = 0,parentMarketPrice = 0;
  442. let parentKey = '',unit_price_file_id=null;
  443. for(let c of changeInfo){
  444. let record = me.mixRatioData[c.row];
  445. let value = scMathUtil.roundForObj(c.value,getDecimal("glj.quantity"));
  446. updateMap[record.mix_ratio_id] = {consumption: value,record:record };
  447. updateData.push({type:'mix_ratio',query:{id:record.mix_ratio_id},doc:{consumption:value}});
  448. parentKey = record.connect_key;
  449. unit_price_file_id = record.unit_price.unit_price_file_id;
  450. }
  451. for(let sub of me.mixRatioData){
  452. let marketPrice = scMathUtil.roundForObj(sub.unit_price.market_price,getDecimal("process"));
  453. let basePrice = scMathUtil.roundForObj(sub.unit_price.base_price,getDecimal("process"));
  454. let consumption = updateMap[sub.mix_ratio_id]?updateMap[sub.mix_ratio_id].consumption:scMathUtil.roundForObj(sub.consumption,getDecimal("glj.quantity"));
  455. parentMarketPrice = scMathUtil.roundForObj(marketPrice*consumption + parentMarketPrice,getDecimal("process"));
  456. parentBasePrice = scMathUtil.roundForObj(basePrice*consumption + parentBasePrice,getDecimal("process"));
  457. }
  458. parentBasePrice = scMathUtil.roundForObj(parentBasePrice,getDecimal("glj.unitPrice"));
  459. parentMarketPrice = scMathUtil.roundForObj(parentMarketPrice,getDecimal("glj.unitPrice"));
  460. updateData.push({type:'parent',connect_key:parentKey,base_price:parentBasePrice,market_price:parentMarketPrice,unit_price_file_id:unit_price_file_id});
  461. projectGLJ.batchUpdateConsumption(updateData,updateMap,function () {
  462. //更新人材机汇总表
  463. let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表
  464. let prow = parentSheet.getActiveRowIndex();//取父机械或组成物的下标
  465. let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data;
  466. me.refreshParentData(prow,prowData.id);
  467. me.onUnitFileChange(updateData);
  468. });
  469. },
  470. showProjectGljData:function () {
  471. this.projectGljSpread.setActiveSheetIndex(0);
  472. let sel = this.projectGljSheet.getSelections()[0];
  473. let oldData = sel.row<this.projectGljSheetData.length?this.projectGljSheetData[sel.row]:"";
  474. let projectGljSheetData = [];
  475. let gljList = projectObj.project.projectGLJ.datas.gljList;
  476. gljList = this.filterProjectGLJ(gljList);
  477. gljList = sortProjectGLJ(gljList);
  478. for(let glj of gljList){
  479. projectGljSheetData.push(this.getSheetDataByGLJ(glj));
  480. }
  481. this.projectGljSheetData = projectGljSheetData;
  482. this.projectGljSheet.setRowCount(this.projectGljSheetData.length);
  483. sheetCommonObj.showData(this.projectGljSheet, this.projectGljSetting,this.projectGljSheetData);
  484. //this.projectGljSheet.setRowCount(this.projectGljSheetData.length);
  485. sel.row = oldData?_.findIndex(this.projectGljSheetData,{'id':oldData.id}):'';
  486. this.projectGljSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount);
  487. },
  488. showMaterialTreeData:function () {
  489. this.projectGljSpread.setActiveSheetIndex(1);
  490. let sel = this.materialTreeSheet.getSelections()[0];
  491. let oldNodeID = this.materialTree.selected?this.materialTree.selected.data.id:"";
  492. let gljList = projectObj.project.projectGLJ.datas.gljList;
  493. gljList = _.sortByAll(gljList, [ 'code']);
  494. this.createMaterialTree(gljList);
  495. this.materialTreeController.showTreeData();
  496. let newNode = this.materialTree.getNodeByID(oldNodeID);
  497. sel.row = newNode?newNode.serialNo():-1;
  498. this.materialTreeSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount);
  499. this.materialTreeController.setTreeSelected(this.materialTree.items[sel.row==-1?0:sel.row]);
  500. },
  501. refreshDataSheet:function () {
  502. let me = projectGljObject;
  503. //------------5;
  504. let quantityCol = _.findIndex(me.projectGljSetting.header,function (header) {
  505. return header.dataCode == 'quantity'|| header.dataCode == 'techQuantity' || header.dataCode =='subdivisionQuantity';
  506. });
  507. if(me.displayType == filterType.FBFX){//分部分项人材机,将“总消耗量”替换显示为“分部分项总消耗量”。
  508. me.projectGljSetting.header[quantityCol].dataCode = 'subdivisionQuantity';
  509. me.projectGljSheet.setValue(0, quantityCol, "分部分项总消耗量", GC.Spread.Sheets.SheetArea.colHeader);
  510. }else if(me.displayType == filterType.TECH) {//措施项目人材机,将“总消耗量”替换显示为“措施项目总消耗量”。
  511. me.projectGljSetting.header[quantityCol].dataCode = 'techQuantity';
  512. me.projectGljSheet.setValue(0, quantityCol, "措施项目总消耗量", GC.Spread.Sheets.SheetArea.colHeader);
  513. }else {
  514. me.projectGljSetting.header[quantityCol].dataCode = 'quantity';
  515. me.projectGljSheet.setValue(0, quantityCol, "总消耗量", GC.Spread.Sheets.SheetArea.colHeader);
  516. }
  517. if(me.displayType == filterType.SCHZ){//三材汇总树节点
  518. me.showMaterialTreeData();
  519. }else {
  520. me.showProjectGljData();
  521. me.showMixRatioData();
  522. }
  523. },
  524. createMaterialTree:function (gljList) {
  525. let me = projectGljObject;
  526. let q_decimal = getDecimal("glj.quantity");
  527. let GC = {id:'GC',name:materialType[materialTypeMap.GC],code:'GC',unit:'t',ParentID:-1,NextSiblingID:'MC'};
  528. let GJ = {id:'GJ',name:materialType[materialTypeMap.GJ],code:'GJ',unit:'t',ParentID:'GC',NextSiblingID:-1};
  529. let MC = {id:'MC',name:materialType[materialTypeMap.MC],code:'MC',unit:'t',ParentID:-1,NextSiblingID:'SN'};
  530. let SN = {id:'SN',name:materialType[materialTypeMap.SN],code:'SN',unit:'m3',ParentID:-1,NextSiblingID:'SZ'};
  531. let SZ = {id:'SZ',name:materialType[materialTypeMap.SZ],code:'BZZ',unit:'千块',ParentID:-1,NextSiblingID:-1};
  532. let rootDatas= [GC,GJ,MC,SN,SZ];
  533. let parentMap = {};
  534. let sumMap = {};
  535. this.materialTree.nodes={},this.materialTree.selected = null,this.materialTree.roots = [],this.materialTree.items=[];
  536. for(let r of rootDatas){
  537. let baseNode = null;
  538. if(r.id == 'GJ'){
  539. baseNode = createMaterialNode(r,parentMap['GC'],null);//钢筋的父节点为钢材
  540. }else {
  541. baseNode = createMaterialNode(r,null,null);
  542. }
  543. parentMap[r.id] = baseNode;
  544. }
  545. for(let g of gljList){
  546. if(g.quantity !== 0 && g.quantity !== '0'){
  547. if(g.materialType){
  548. let tem = me.getMaterialSheetDataByGLJ(g);
  549. if(tem.materialQuantity){
  550. sumMap[g.materialType] = sumMap[g.materialType]?sumMap[g.materialType] + tem.materialQuantity:tem.materialQuantity;
  551. tem.materialQuantity = scMathUtil.roundToString(tem.materialQuantity,q_decimal);//转成string
  552. }
  553. if(g.materialType == materialTypeMap.GC){ //钢材的下一节点是钢筋
  554. createMaterialNode(tem,parentMap['GC'],parentMap['GJ']);
  555. }else {
  556. createMaterialNode(tem,parentMap[materialTypeMap[g.materialType]]);
  557. }
  558. }
  559. }
  560. }
  561. for(let mkey in sumMap){
  562. if(mkey == materialTypeMap.GC && sumMap[materialTypeMap.GJ]){//钢材汇总要加上钢筋的总量
  563. parentMap['GC'].data.materialQuantity = scMathUtil.roundToString(sumMap[mkey]+sumMap[materialTypeMap.GJ],q_decimal);
  564. }else {
  565. parentMap[materialTypeMap[mkey]].data.materialQuantity = scMathUtil.roundToString(sumMap[mkey],q_decimal);
  566. }
  567. }
  568. this.materialTree.sortTreeItems();
  569. function createMaterialNode(data,parent,next) {
  570. let newNode = me.materialTree.addNode(parent, next, data.id);
  571. newNode.data = data;
  572. return newNode;
  573. }
  574. },
  575. getMaterialSheetDataByGLJ:function (glj) {
  576. let q_decimal = getDecimal("glj.quantity");
  577. let m_decimal = getDecimal("material");
  578. let p_decimal = getDecimal("glj.unitPrice");
  579. let projectGLJ = projectObj.project.projectGLJ;
  580. let data ={
  581. id:glj.id,
  582. code:glj.code,
  583. name:glj.name,
  584. specs:glj.specs,
  585. unit:glj.unit,
  586. type:glj.type,
  587. short_name:projectGLJ.getShortNameByID(glj.type),
  588. quantity:scMathUtil.roundToString(glj.quantity,q_decimal),
  589. supply:glj.supply,
  590. supply_quantity:glj.supply_quantity,
  591. materialType:glj.materialType,
  592. delivery:glj.delivery,
  593. delivery_address:glj.delivery_address,
  594. is_adjust_price:glj.is_adjust_price,
  595. ratio_data:glj.ratio_data,
  596. is_add:glj.unit_price.is_add,
  597. bgColour:'white'
  598. };
  599. if(glj.materialCoe){
  600. data.materialCoe = scMathUtil.roundForObj(glj.materialCoe,m_decimal);
  601. //data.materialCoe = scMathUtil.roundToString(glj.materialCoe,m_decimal);
  602. data.materialQuantity = scMathUtil.roundForObj(glj.materialCoe * glj.quantity,q_decimal);//还要做汇总,汇总完再转成string
  603. }
  604. gljOprObj.setGLJPrice(data,glj);
  605. data.basePrice = scMathUtil.roundToString(data.basePrice,p_decimal);
  606. data.marketPrice = scMathUtil.roundToString(data.marketPrice,p_decimal);
  607. return data;
  608. },
  609. filterProjectGLJ:function (gljList) {
  610. let me = projectGljObject;
  611. if(gljList.length>0){
  612. gljList = _.filter(gljList,function (item) {
  613. return me.displayTypeFilter(item);
  614. });
  615. }
  616. return gljList;
  617. },
  618. displayTypeFilter:function (item) {
  619. let me = this;
  620. if(item.quantity !== 0 && item.quantity !== '0'){//过滤掉消耗量为0的工料机
  621. if(me.displayType == filterType.ALL){//所有工料机
  622. return true;
  623. }else if(filterTypeArray.indexOf(me.displayType) != -1){//人工、材料、机械、主材、设备
  624. let typeString = item.type+"";
  625. return typeString.startsWith(me.displayType);
  626. }else if(me.displayType == filterType.FBFX){//“分部分项总消耗量”≠0的工料机行
  627. return item.subdivisionQuantity !== 0 && item.subdivisionQuantity !== '0';
  628. }else if(me.displayType == filterType.TECH){//筛选“措施项目总消耗量”≠0的工料机行
  629. return item.techQuantity !== 0 && item.techQuantity !== '0';
  630. }else if(me.displayType == filterType.JGCL){//筛选“供货方式”=“完全甲供”或“部分甲供”的工料机行
  631. return item.supply == supplyType.WQJG || item.supply == supplyType.BFJG;
  632. }else if(me.displayType == filterType.ZGCL){//筛选“是否暂估”=“是”的工料机行。
  633. return item.is_evaluate == 1;
  634. }else if(me.displayType == filterType.ZYCL){//筛选“主要材料”=“是”的工料机行。
  635. return item.is_main_material == 1;
  636. }
  637. }
  638. return false;
  639. },
  640. getSheetDataByGLJ:function (glj) {
  641. let projectGLJ = projectObj.project.projectGLJ;
  642. let materialIdList = projectGLJ.datas.constData.materialIdList;
  643. let data ={
  644. id:glj.id,
  645. code:glj.code,
  646. name:glj.name,
  647. specs:glj.specs,
  648. unit:glj.unit,
  649. type:glj.type,
  650. short_name:projectGLJ.getShortNameByID(glj.type),
  651. quantity:glj.quantity,
  652. supply:glj.supply,
  653. supply_quantity:glj.supply_quantity,
  654. materialType:glj.materialType,
  655. materialCoe:glj.materialCoe,
  656. delivery:glj.delivery,
  657. delivery_address:glj.delivery_address,
  658. is_adjust_price:glj.is_adjust_price,
  659. ratio_data:glj.ratio_data,
  660. is_add:glj.unit_price.is_add,
  661. bgColour:'white',
  662. techQuantity:glj.techQuantity,
  663. subdivisionQuantity:glj.subdivisionQuantity,
  664. remark:glj.remark
  665. };
  666. gljOprObj.setGLJPrice(data,glj);
  667. data.is_main_material = glj.is_main_material == 1?1:0;
  668. //供货方式为完全甲供时设置甲供数量为总消耗量
  669. if (data.supply == 2) {
  670. data.supply_quantity = glj.quantity;
  671. }
  672. // 只有材料才显示是否暂估
  673. if (materialIdList.indexOf(glj.type) >= 0) {
  674. data.is_evaluate = glj.is_evaluate;
  675. }
  676. if(glj.materialCoe !== null && glj.materialCoe !==undefined){
  677. data.materialCoe = scMathUtil.roundForObj(glj.materialCoe,getDecimal("material"));
  678. }
  679. //bgColour
  680. if(data.basePrice == data.marketPrice){//如果定额价等于市场价时,改底色。 优先度低于有组成物时的底色
  681. data.bgColour = "#C4CAFB";
  682. }
  683. if (notEditType.indexOf(glj.type) >= 0) {
  684. if (data.ratio_data && data.ratio_data.length > 0){//有组成物时
  685. //设置底色
  686. data.bgColour = "#E0E0E0";
  687. }
  688. }
  689. return data;
  690. },
  691. refreshProjectGljRow:function (row) {
  692. let me = projectGljObject;
  693. let rowData = me.projectGljSheetData[row];
  694. let glj = projectObj.project.projectGLJ.getByID(rowData.id);
  695. let newRow = null;
  696. if(glj){
  697. newRow = me.getSheetDataByGLJ(glj);
  698. }
  699. if(me.displayTypeFilter(newRow) == true){
  700. me.projectGljSheetData[row] = newRow;
  701. sheetCommonObj.showRowData(this.projectGljSheet, this.projectGljSetting,row,this.projectGljSheetData);
  702. }else {
  703. me.projectGljSheetData.splice(row,1);
  704. me.projectGljSheet.deleteRows(row,1);
  705. me.showMixRatioData();
  706. }
  707. //me.projectGljSheetData[row] = me.getSheetDataByGLJ(glj);
  708. },
  709. initSheet: function (sheet,setting) {
  710. var me = this;
  711. sheetCommonObj.initSheet(sheet, setting, 30);
  712. sheet.bind(GC.Spread.Sheets.Events.ValueChanged, me.onSheetValueChange);
  713. },
  714. onSheetValueChange:function (e,info) {
  715. let me = projectGljObject;
  716. if(info.sheetName=='projectGljSheet'){
  717. me.onProjectGLJValueChange(e,info);
  718. }else if(info.sheetName == 'mixRatioSheet'){
  719. me.onMixRatioValueChange(e,info);
  720. }
  721. },
  722. onMixRatioValueChange:function (e,info){
  723. let composition = projectObj.project.composition;
  724. let me = projectGljObject,row = info.row, col = info.col;
  725. let dataCode = me.mixRatioSetting.header[col].dataCode;
  726. let recode = me.mixRatioData[row];
  727. let value = info.newValue;
  728. let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表
  729. if (!me.checkData(col,me.mixRatioSetting,value)) {
  730. alert('输入的数据类型不对,请重新输入!');
  731. me.mixRatioSheet.setValue(row, col, info.oldValue);
  732. return false;
  733. }
  734. value = scMathUtil.roundToString(value,getDecimal("glj.quantity"));
  735. let [parentMarketPrice, parentBasePrice] = me.getCompositionSumPrice('modify', row, value);
  736. let updateData ={id: recode.mix_ratio_id, field: 'mix_ratio.' + dataCode, value: value, market_price: parentMarketPrice, base_price: parentBasePrice};
  737. let prow = parentSheet.getActiveRowIndex();//取父机械或组成物的下标
  738. let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data;
  739. composition.updateConsumption(updateData,recode,prowData.id,function (sid) {
  740. /* if(parentSheet.name() == 'projectGljSheet'){ 之前是单行刷新,父工料机与组成物对应的工料机分开刷,发现这样比整个刷新慢所以先整个刷新,当以后数据量大的时候再测试
  741. me.refreshProjectGljRowByID(sid);
  742. }*/
  743. projectObj.project.projectGLJ.calcQuantity();
  744. me.refreshParentData(prow,prowData.id,sid);
  745. me.onUnitFileChange(recode);
  746. });
  747. },
  748. refreshParentData:function (row,pid,sid) {
  749. let me = this;
  750. let sheet = me.projectGljSpread.getActiveSheet();
  751. let parantData = null;
  752. if(sheet.name() == 'projectGljSheet'){
  753. me.showProjectGljData();// me.refreshProjectGljRow(row) 这里原来是分开刷新的,现在整个统一刷新,先留着
  754. //parantData = _.find(); //me.projectGljSheetData[row];
  755. }else {
  756. me.showMaterialTreeData();
  757. //parantData = me.materialTree.items[row].data;
  758. }
  759. let pglj = _.find(projectObj.project.projectGLJ.datas.gljList,{'id':pid});
  760. parantData = pglj?me.getSheetDataByGLJ(pglj):null;
  761. //projectObj.project.projectGLJ.datas.gljList
  762. // 更新组成物缓存
  763. projectObj.project.composition.loadData();
  764. //先查找使用了父项目工料机的定额工料机
  765. let updateNodes=[];
  766. let ration_gljs = _.filter(projectObj.project.ration_glj.datas,{'projectGLJID':pid});
  767. for(let rg of ration_gljs){
  768. let node = projectObj.project.mainTree.getNodeByID(rg.rationID);
  769. if(node){
  770. updateNodes.push(node);
  771. }
  772. }
  773. //或者是使用了父项目工料机的工料机类型的定额
  774. let rations = _.filter(projectObj.project.Ration.datas,{'type':3,'projectGLJID':pid});
  775. for(let r of rations){
  776. let r_node = projectObj.project.mainTree.getNodeByID(r.ID);
  777. if(r_node){
  778. r_node.data.marketUnitFee = parantData?parantData.marketPrice:'';//parentMarketPrice;//这里用显示的价格
  779. updateNodes.push(r_node);
  780. }
  781. }
  782. if(sid){
  783. let subRations = calcTools.getRationsByProjectGLJ(sid);
  784. updateNodes = updateNodes.concat(subRations);
  785. }
  786. if(updateNodes.length>0){
  787. projectObj.project.calcProgram.calcNodesAndSave(updateNodes,function () {
  788. projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
  789. installationFeeObj.calcInstallationFee();//计算安装增加费
  790. });
  791. }
  792. gljOprObj.refreshView();
  793. },
  794. onUnitFileChange:function (data) {
  795. socket.emit('unitFileChangeNotify', JSON.stringify(data));
  796. projectObj.project.markUpdateProject({projectID:projectObj.project.ID(),'unitFileID':socketObject.getUnitFileRoomID()},"unitFile");
  797. },
  798. deleteMixRatio:function (row) {
  799. let me = this, deleteRecode = me.mixRatioData[row];
  800. let consumption = deleteRecode.consumption;
  801. let [parentMarketPrice, parentBasePrice] = me.getCompositionSumPrice('delete', row);
  802. let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表
  803. let prow= parentSheet.getActiveRowIndex();//取父机械或组成物的下标
  804. let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data;
  805. let updateData = {id: deleteRecode.mix_ratio_id, field: 'mix_ratio.consumption' , value: 0, market_price: parentMarketPrice, base_price: parentBasePrice};
  806. projectObj.project.composition.deleteComposition(updateData,deleteRecode,prowData.id,function () {
  807. _.remove(me.mixRatioData,{"mix_ratio_id":deleteRecode.mix_ratio_id});
  808. me.refreshParentData(prow,prowData.id);
  809. me.mixRatioSheet.deleteRows(row,1);
  810. me.onUnitFileChange(deleteRecode);
  811. });
  812. },
  813. getCompositionSumPrice : function(scene, affectRow, newValue = 0) {
  814. let me = this;
  815. let parentMarketPrice = 0;
  816. let parentBasePrice = 0;
  817. for(let i = 0;i < me.mixRatioData.length;i++){
  818. let ratio = me.mixRatioData[i];
  819. let marketPrice = ratio.unit_price.market_price;
  820. let basePrice = ratio.unit_price.base_price;
  821. // 如果是删除则忽略即将被删除的行数据
  822. if (scene === 'delete' && affectRow === i) {
  823. continue;
  824. }
  825. let consumption = i === affectRow ? newValue : ratio.consumption;
  826. parentMarketPrice += operationWithRound(consumption,marketPrice,"glj.unitPrice","*");
  827. parentBasePrice += operationWithRound(consumption,basePrice,"glj.unitPrice","*");
  828. }
  829. parentMarketPrice = parentMarketPrice.toDecimal(getDecimal("glj.unitPrice"));
  830. parentBasePrice = parentBasePrice.toDecimal(getDecimal("glj.unitPrice"));
  831. return [parentMarketPrice, parentBasePrice];
  832. },
  833. onProjectGLJValueChange:function (e,info) {//me.projectGljSetting
  834. let projectGLJ = projectObj.project.projectGLJ;
  835. let me = projectGljObject,row = info.row, col = info.col;
  836. let setting = info.sheetName =="materialTreeSheet"?me.materialSetting:me.projectGljSetting;
  837. let dataCode = setting.header[col].dataCode;
  838. let recode = info.sheetName =="materialTreeSheet"?me.materialTree.selected.data:me.projectGljSheetData[row];
  839. let value = info.newValue;
  840. if(info.newValue === undefined ){
  841. return;
  842. }
  843. if (value&&!me.checkData(col,setting,value)) {
  844. alert('输入的数据类型不对,请重新输入!');
  845. info.sheetName =="materialTreeSheet"?me.materialTreeController.refreshTreeNode([me.materialTree.selected]):me.refreshProjectGljRow(row);
  846. return ;
  847. }
  848. let callback=function (impactList) {
  849. info.sheet.suspendPaint();
  850. info.sheet.suspendEvent();
  851. if(info.sheetName =="materialTreeSheet"){
  852. me.showMaterialTreeData();
  853. }else {
  854. me.refreshProjectGljRow(row);
  855. for(let g of impactList){
  856. me.refreshProjectGljRowByID(g.id,row);
  857. }
  858. }
  859. info.sheet.resumeEvent();
  860. info.sheet.resumePaint();
  861. if (dataCode === 'supply' || dataCode === 'supply_quantity'){ // basePrice、marketPrice 有自己的计算代码,无需走这里重复计算
  862. let rations = calcTools.getRationsByProjectGLJ(recode.id);
  863. projectObj.project.calcProgram.calcNodesAndSave(rations, function () {
  864. projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
  865. });
  866. }
  867. gljOprObj.refreshView();
  868. };
  869. if(dataCode=='basePrice'||dataCode=='marketPrice'){
  870. value= scMathUtil.roundForObj(value,getDecimal('glj.unitPrice'));//修改市场价和修改定额价时需要重新记算很多受影响的树节点,现在改成与定字额工料机那里调相同的方法。
  871. let editField = dataCode === 'basePrice'?"base_price":"market_price";
  872. projectObj.project.projectGLJ.updatePrice(recode,editField,value,'pg',callback);
  873. }else {
  874. let extend = {};
  875. // 如果是供货方式则需要处理数据
  876. if (dataCode === 'supply') {
  877. extend.supply_quantity = me.getSupplyQuantity(value, recode.quantity);
  878. }
  879. if(dataCode === 'supply_quantity'){//修改数量需做4舍5入
  880. value= scMathUtil.roundForObj(value,getDecimal('glj.quantity'));
  881. }
  882. if(dataCode === 'is_evaluate'||dataCode === 'is_adjust_price'||dataCode === 'is_main_material'){
  883. if(value == true){
  884. value = 1;
  885. }else if(value == false){
  886. value = 0;
  887. }
  888. }
  889. if(dataCode === 'materialType' && (value == null || value=="")){//删除三材类别时,清空三材系数
  890. value = null;
  891. extend.materialCoe = null;
  892. }
  893. if(dataCode == 'materialCoe'){
  894. value = scMathUtil.roundForObj(value,getDecimal("material"));
  895. }
  896. extend = Object.keys(extend).length > 0 ? JSON.stringify(extend) : '';
  897. if(recode[dataCode] == value) return;
  898. let updateData = {id: recode.id, field: dataCode, value: value, extend: extend};
  899. projectGLJ.pGljUpdate(updateData,callback);
  900. };
  901. },
  902. refreshProjectGljRowByID:function (ID,row) {//row 可以不传,如果row 和 index 相等就不刷新
  903. let me = this;
  904. let index = _.findIndex(me.projectGljSheetData, { 'id': ID});
  905. if(index>=0&&index != row){
  906. me.refreshProjectGljRow(index);
  907. }
  908. },
  909. getSupplyQuantity : function(supplyType, quantity) {
  910. // 自行采购和甲定乙供则把甲供数量设置为0,其余情况则设置为当前总消耗量
  911. let supplyQuantity = supplyType == 0 || supplyType == 3 ? 0 : quantity;
  912. supplyQuantity = parseFloat(supplyQuantity);
  913. return supplyQuantity;
  914. },
  915. checkData : function(col,setting, value) {
  916. let result = true;
  917. let validator = setting.header[col].validator !== undefined ? setting.header[col].validator : null;
  918. if (validator === null) {
  919. return result;
  920. }
  921. switch (validator) {
  922. case 'number':
  923. let regular = /^\d+(\.\d+)?$/;
  924. result = regular.test(value);
  925. break;
  926. case 'boolean':
  927. let booleanValue = [true, false];
  928. result = booleanValue.indexOf(value) >= 0;
  929. break;
  930. }
  931. return result;
  932. },
  933. getProjectGLJSelected:function () {
  934. let me = projectGljObject;
  935. let sheet = me.projectGljSpread.getActiveSheet();
  936. let selectedProjectGLJ = null;
  937. if(sheet.name() == 'projectGljSheet'){//projectGljSheet/materialSheet 工料机汇总和三材汇总表
  938. let sel = me.projectGljSheet.getSelections()[0];
  939. if(sel.row != -1 && me.projectGljSheetData.length>sel.row){
  940. selectedProjectGLJ = me.projectGljSheetData[sel.row]
  941. }
  942. }else if(sheet.name() == 'materialTreeSheet' ){
  943. if(me.materialTree.selected){
  944. selectedProjectGLJ = me.materialTree.selected.data;
  945. }
  946. }
  947. return selectedProjectGLJ;
  948. },
  949. initRightClick : function() {
  950. let activeSheet = this.mixRatioSheet;
  951. let me = this;
  952. $.contextMenu({
  953. selector: '#mix_ratio_sheet',
  954. build: function ($trigger, e) {
  955. me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.mixRatioSpread);
  956. return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport ||
  957. me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  958. },
  959. items: {
  960. "deleteMixRatio": {
  961. name: "删除",
  962. icon: 'fa-trash-o',
  963. disabled: function () {
  964. return me.rightClickTarget.row === undefined;
  965. },
  966. callback: function (key, opt) {
  967. let row = me.rightClickTarget.row;
  968. me.deleteMixRatio(row);
  969. }
  970. },
  971. "addMixRatio":{
  972. name: '添加',
  973. icon: 'fa-sign-in',
  974. disabled: function () {
  975. let projectGLJ = projectGljObject.getProjectGLJSelected();
  976. return !_.includes(compositionTypes,projectGLJ.type);
  977. },
  978. callback: function (key, opt) {
  979. me.selectedProjectGLJ = projectGljObject.getProjectGLJSelected();
  980. getGLJData('addMix');
  981. }
  982. }
  983. }
  984. });
  985. },
  986. changeFileCallback:function(){
  987. projectGljObject.unitPriceFileInit();
  988. projectGljObject.refreshDataSheet();
  989. gljOprObj.refreshView();
  990. projectObj.project.calcProgram.calcAllNodesAndSave();
  991. if(socketObject.roomInfo){
  992. let data ={
  993. projectID:projectObj.project.ID(),
  994. oldRoom:socketObject.roomInfo.unitFile,
  995. newRoom:socketObject.getUnitFileRoomID(),
  996. name:'unitFile'
  997. };
  998. socket.emit('changeNewRoom',data);
  999. socketObject.roomInfo.unitFile = socketObject.getUnitFileRoomID();
  1000. }
  1001. },
  1002. calcPartASupplyFeeByProjectGLJs: function (projectGLJsArr) {
  1003. for (let pGLJ of projectGLJsArr){
  1004. if (pGLJ.supply == supplyType.BFJG){
  1005. let rations = calcTools.getRationsByProjectGLJ(pGLJ.id);
  1006. projectObj.project.calcProgram.calcNodesAndSave(rations, function () {
  1007. projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
  1008. });
  1009. }
  1010. }
  1011. },
  1012. checkUnitFileName:function (name,callback) {
  1013. let projectGLJ = projectObj.project.projectGLJ;
  1014. projectGLJ.checkUnitFileName(name,function (data) {
  1015. if(data){
  1016. $("#save-as-tips").text('已存在同名单价文件').show();
  1017. $('#save-as-confirm').attr("disabled","disabled");
  1018. }else {
  1019. $("#save-as-tips").hide();
  1020. $('#save-as-confirm').removeAttr("disabled");
  1021. if(callback){
  1022. callback();
  1023. }
  1024. }
  1025. });
  1026. }
  1027. };
  1028. function getProjectResizeEles() {
  1029. let pojGljResizeEles = {};
  1030. pojGljResizeEles.id = '#project-glj-main';
  1031. pojGljResizeEles.resize = $('#project-glj-main').find('.resize');
  1032. pojGljResizeEles.nearElement = $('#project-glj-main').find('.top-content');
  1033. pojGljResizeEles.nearSpread = pojGljResizeEles.nearElement.children(".main-data-top");
  1034. pojGljResizeEles.farElement = $('#project-glj-main').find('.bottom-content');
  1035. pojGljResizeEles.farSpread = pojGljResizeEles.farElement.children().find(".main-data-bottom");
  1036. pojGljResizeEles.nav = pojGljResizeEles.farElement.children('ul.nav');
  1037. return pojGljResizeEles;
  1038. }
  1039. function loadProjectGljSize() {
  1040. let me = projectGljObject;
  1041. let pojGljResizeEles = getProjectResizeEles();
  1042. loadSize(pojGljResizeEles, 'height', function () {
  1043. me.projectGljSpread?me.projectGljSpread.refresh():'';
  1044. me.mixRatioSpread?me.mixRatioSpread.refresh():'';
  1045. });
  1046. }
  1047. //从其他建设项目中复制中,建设项目的文件层次结构名称和顺序
  1048. function getFileHierarchyInfo(treeData){
  1049. let tree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1});
  1050. tree.loadDatas(treeData);
  1051. let items = tree.items;
  1052. let rst = [];
  1053. function getFileHierarchyName(node){
  1054. let nodeName = node.data.name;
  1055. let name = [];
  1056. while (node.parent){
  1057. name.push(node.parent.data.name ? node.parent.data.name : '');
  1058. node = node.parent;
  1059. }
  1060. name = name.reverse();
  1061. name.push(nodeName);
  1062. return name.join('\\');
  1063. }
  1064. for(let node of items){
  1065. if(node.children.length === 0 ){//project
  1066. rst.push({ID: node.data.ID, fileHierarchyName: getFileHierarchyName(node)})
  1067. }
  1068. }
  1069. return rst;
  1070. }
  1071. $(function () {
  1072. let pojGljResizeEles = getProjectResizeEles();
  1073. slideResize(pojGljResizeEles, {min: 170, max: 700}, 'height', function () {
  1074. projectGljObject.projectGljSpread.refresh();
  1075. projectGljObject.mixRatioSpread?projectGljObject.mixRatioSpread.refresh():'';
  1076. });
  1077. $('#tab_project_glj').on('shown.bs.tab', function (e) {
  1078. sessionStorage.setItem('mainTab', '#tab_project_glj');
  1079. let me = projectGljObject;
  1080. $(e.relatedTarget.hash).removeClass('active');
  1081. if(me.projectGljSpread==null){
  1082. me.initProjectGljSpread();
  1083. }
  1084. me.unitPriceFileInit();
  1085. me.initMixRatio();
  1086. //projectObj.project.projectGLJ.calcQuantity(); 在工程量有更新的地方调用
  1087. me.refreshDataSheet();
  1088. loadProjectGljSize();
  1089. });
  1090. /* $('#ration_link').on('shown.bs.tab', function (e) {
  1091. let me = projectGljObject;
  1092. me.showTag='ration';
  1093. me.showProjectGljData();
  1094. });
  1095. $('#mix_ratio_link').on('shown.bs.tab', function (e) {
  1096. let me = projectGljObject;
  1097. me.showTag='mixRatio';
  1098. me.showProjectGljData();
  1099. me.initMixRatio();
  1100. });
  1101. $('#machine_ratio_link').on('shown.bs.tab', function (e) {
  1102. let me = projectGljObject;
  1103. me.showTag='machine';
  1104. me.showProjectGljData();
  1105. me.initMixRatio();
  1106. });*/
  1107. $('#pop-used-list').popover({
  1108. placement: "bottom",
  1109. html: true,
  1110. trigger: "hover | focus",
  1111. content: projectGljObject.getUsedTenderInfo
  1112. }
  1113. );
  1114. // 单价文件切换弹框
  1115. $('#change-unitFile').on('shown.bs.modal', function () {
  1116. let rootProjectID = projectInfoObj.projectInfo.property.rootProjectID;
  1117. // 获取切换单价文件相关数据
  1118. $.ajax({
  1119. url: '/glj/get-project-info',
  1120. type: 'post',
  1121. data: {project_id: scUrlUtil.GetQueryString('project'),rootProjectID:rootProjectID},
  1122. dataType: 'json',
  1123. success: function (response) {
  1124. if (response.err === 1) {
  1125. alert('数据传输错误!');
  1126. return false;
  1127. }
  1128. let data = response.data;
  1129. projectGljObject.changeInfo = data;
  1130. $("#current-project-name").text(data.currentProjectName);
  1131. // 本项目中的单价文件
  1132. if (data.self.length > 0) {
  1133. let selfFileHtml = '';
  1134. for (let tmp of data.self) {
  1135. let select = usedUnitPriceInfo === tmp.id ? ' selected="selected"' : '';
  1136. selfFileHtml += '<option' + select + ' value="' + tmp.id + '">' + tmp.name + '</option>';
  1137. }
  1138. $("#self-file").html(selfFileHtml);
  1139. }
  1140. // 其他建设项目数据
  1141. let newDataOther = [];
  1142. if (data.other.length > 0) {
  1143. //转换成按项目管理顺序,名称包含文件夹层次
  1144. let fileHierarchyDatas = getFileHierarchyInfo(data.treeData);
  1145. for(let fileHierarchyData of fileHierarchyDatas){
  1146. let projData = _.find(data.other, {ID: fileHierarchyData.ID});
  1147. if(projData){
  1148. projData.name = fileHierarchyData.fileHierarchyName;
  1149. newDataOther.push(projData);
  1150. }
  1151. }
  1152. data.other = newDataOther;
  1153. let otherProjectHtml = '';
  1154. let otherFileHtml = '';
  1155. for (let tmp of data.other) {
  1156. otherProjectHtml += '<option value="' + tmp.ID + '">' + tmp.name + '</option>';
  1157. otherFileData[tmp.ID] = tmp.unitPriceList;
  1158. if (otherFileHtml !== '') {
  1159. continue;
  1160. }
  1161. for (let unitPrice of tmp.unitPriceList) {
  1162. otherFileHtml += '<option value="' + unitPrice.id + '">' + unitPrice.name + '</option>';
  1163. }
  1164. }
  1165. $("#other-project").html(otherProjectHtml);
  1166. $("#other-file").html(otherFileHtml);
  1167. }
  1168. }
  1169. });
  1170. });
  1171. // 单价文件切换确认
  1172. $("#change-file-confirm").click(function () {
  1173. let type = $("input[name='change-type']:checked").val();
  1174. type = parseInt(type);
  1175. let changeUnitPriceId = 0;
  1176. $('#change-unitFile').modal("hide");
  1177. if (type === 0) {
  1178. // 从本项目中选择
  1179. changeUnitPriceId = $("#self-file").val();
  1180. } else {
  1181. // 从其他项目中复制
  1182. changeUnitPriceId = $("#other-file").val();
  1183. let newName = $("#other-file").children("option:selected").text();
  1184. let currentOption = _.find(projectGljObject.changeInfo.self,{name:newName});
  1185. if(currentOption){ //存在则说明有重名的文件
  1186. //rename-unitFile
  1187. $("#rename-unitFile").modal({show:true});
  1188. $("#newUnitFileID").val(changeUnitPriceId);
  1189. $("#newUnitFileName").val(newName);
  1190. return;
  1191. }
  1192. }
  1193. let data = {project_id: scUrlUtil.GetQueryString('project'), change_id: changeUnitPriceId, type: type};
  1194. projectObj.project.projectGLJ.changeFile(data,function () {
  1195. projectGljObject.changeFileCallback();
  1196. })
  1197. });
  1198. // 单价文件选项切换
  1199. $("input[name='change-type']").change(function () {
  1200. let type = $(this).val();
  1201. type = parseInt(type);
  1202. $("#change-unitFile .option").hide();
  1203. if (type === 0) {
  1204. $(".option.select").show();
  1205. } else {
  1206. $(".option.copy").show();
  1207. }
  1208. });
  1209. $("#unitFile-save-as").on('shown.bs.modal', function () {
  1210. // 获取当前建设项数据
  1211. $("#save-as-name").val(projectGljObject.usedUnitPriceInfo.name + '副本');
  1212. projectGljObject.checkUnitFileName(projectGljObject.usedUnitPriceInfo.name + '副本');
  1213. });
  1214. // 从其他建设项目中复制 选择建设项目
  1215. $("#other-project").change(function () {
  1216. let projectId = $(this).val();
  1217. if (otherFileData[projectId] === undefined) {
  1218. return false;
  1219. }
  1220. let otherFileHtml = '';
  1221. for (let unitPrice of otherFileData[projectId]) {
  1222. otherFileHtml += '<option value="' + unitPrice.id + '">' + unitPrice.name + '</option>';
  1223. }
  1224. $("#other-file").html(otherFileHtml);
  1225. });
  1226. $('#save-as-name').change(function () {
  1227. projectGljObject.checkUnitFileName(this.value);
  1228. });
  1229. $('#newUnitFileName').change(function () {
  1230. let projectGLJ = projectObj.project.projectGLJ;
  1231. projectGLJ.checkUnitFileName(this.value,function (data) {
  1232. if(data){
  1233. $("#renameError_unitFile").text('已存在同名单价文件').show();
  1234. $('#renameUnitFileConfirm').attr("disabled","disabled");
  1235. }else {
  1236. $("#renameError_unitFile").hide();
  1237. $('#renameUnitFileConfirm').removeAttr("disabled");
  1238. }
  1239. });
  1240. });
  1241. $("#renameUnitFileConfirm").click(function () {
  1242. let projectGLJ = projectObj.project.projectGLJ;
  1243. let newName = $('#newUnitFileName').val();
  1244. let changeUnitPriceId = $('#newUnitFileID').val();
  1245. projectGLJ.checkUnitFileName(newName,function (data) {
  1246. if(data){
  1247. $("#renameError_unitFile").text('已存在同名单价文件').show();
  1248. $('#renameUnitFileConfirm').attr("disabled","disabled");
  1249. }else {
  1250. $("#renameError_unitFile").hide();
  1251. $('#renameUnitFileConfirm').removeAttr("disabled");
  1252. let data = {project_id: scUrlUtil.GetQueryString('project'), change_id: changeUnitPriceId, type: 1,newName:newName};
  1253. projectObj.project.projectGLJ.changeFile(data,function () {
  1254. projectGljObject.changeFileCallback();
  1255. })
  1256. }
  1257. });
  1258. });
  1259. // 单价文件另存为操作
  1260. $("#save-as-confirm").click(function () {
  1261. let projectGLJ = projectObj.project.projectGLJ;
  1262. let name = $("#save-as-name").val();
  1263. if (name === '') {
  1264. $("#save-as-tips").text('请填写单价文件名称').show();
  1265. return false;
  1266. }
  1267. let saveData = {name: name, project_id: scUrlUtil.GetQueryString('project')};
  1268. projectGljObject.checkUnitFileName(name,function () {
  1269. projectGLJ.saveAs(saveData,function () {
  1270. projectGljObject.changeFileCallback();
  1271. $("#unitFile-save-as").modal("hide");
  1272. });
  1273. });
  1274. });
  1275. $("#filterType").on("click","ul li a",function(e){
  1276. let children = $('#filterType a');
  1277. for(let c of children){
  1278. $(c).removeClass('active');
  1279. }
  1280. $(this).addClass('active');
  1281. let me = projectGljObject;
  1282. me.displayType = filterType[this.id];
  1283. me.refreshDataSheet();
  1284. });
  1285. });