project_glj_view.js 54 KB

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