project_glj_view.js 64 KB

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