project_glj_view.js 62 KB

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