material_calc_view.js 52 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044
  1. /**
  2. * Created by zhang on 2019/3/11.
  3. */
  4. materialCalcObj = {
  5. moduleName:'materalCal',
  6. materialSpread:null,
  7. materialSheet:null,
  8. materialDatas:[],
  9. materialSetting:{
  10. header:[
  11. {headerName: "编号", headerWidth: 70, dataCode: "code", dataType: "String"},
  12. {headerName: "名称", headerWidth: 105, dataCode: "name", dataType: "String"},
  13. {headerName: "预算价", headerWidth: 60, dataCode: "marketPrice", hAlign: "right", dataType: "Number",validator:"number"},
  14. {headerName: "供应地点", headerWidth: 75, dataCode: "supplyLocation", hAlign: "left", dataType: "String"},
  15. {headerName: "原价", headerWidth: 60, dataCode: "originalPrice", hAlign: "right", dataType: "String"},
  16. {headerName: "单位运费", headerWidth: 60, dataCode: "unitFreight", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'glj.unitPrice'
  17. {headerName: "单位毛重(吨)", headerWidth: 65, dataCode: "grossWeightCoe_n", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:"glj.unitPrice"
  18. {headerName: "装卸总次数", headerWidth: 53, dataCode: "totalLoadingTimes", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:"glj.unitPrice"
  19. {headerName: "每增加一次装卸损耗率", headerWidth: 80, dataCode: "handlingLossRate_n", hAlign: "right", dataType: "Number",validator:"number"},
  20. {headerName: "场外运输损耗率", headerWidth: 60, dataCode: "offSiteTransportLossRate_n", hAlign: "right", dataType: "Number"},//,decimalField:"glj.unitPrice"
  21. {headerName: "场外运输损耗", headerWidth: 60, dataCode: "offSiteTransportLoss", hAlign: "right", dataType: "Number"},//,decimalField:"glj.unitPrice"
  22. {headerName: "采购及保管费率", headerWidth: 60, dataCode: "purchaseStorageRate_n", hAlign: "right", dataType: "Number"},//,decimalField:"glj.unitPrice"
  23. {headerName: "采购及保管费", headerWidth: 60, dataCode: "purchaseStorage", hAlign: "right", dataType: "Number"},//,decimalField:"glj.unitPrice"
  24. {headerName: "包装品回收价值", headerWidth: 60, dataCode: "packageRecoverValue", hAlign: "right", dataType: "Number"}//,decimalField:"glj.unitPrice"
  25. ],
  26. view: {
  27. lockColumns: ["code","name","marketPrice",'offSiteTransportLoss','purchaseStorage'],
  28. rowHeaderWidth:25,
  29. colHeaderHeight:36
  30. }
  31. },
  32. freightSpread:null,
  33. freightSheet:null,
  34. freightDatas:[],
  35. conveyanceOptions:["自办运输","汽车","火车","船舶","马车","手推车","拖拉机"],
  36. userFreightList:[],
  37. freightSetting:{
  38. header:[
  39. {headerName: "起讫地点", headerWidth: 85, dataCode: "start", dataType: "String"},
  40. {headerName: "运输工具", headerWidth: 65, dataCode: "conveyance", dataType: "String"},
  41. {headerName: "材料类型", headerWidth: 65, dataCode: "materialType", visible: false,dataType: "String",cellType:"comboBox",options:["","地方材料","外购材料","沥青、燃料等"]},
  42. {headerName: "单位运价", headerWidth: 65, dataCode: "unitFreight", hAlign: "right", dataType: "Number",validator:"number"},
  43. {headerName: "km运距", headerWidth: 55, dataCode: "kmDistance", hAlign: "right", dataType: "String",validator:"number"},
  44. {headerName: "装卸费\n单价", headerWidth: 53, dataCode: "unitLoadingFee", hAlign: "right", dataType: "String",validator:"number"},
  45. {headerName: "装卸\n次数", headerWidth: 41, dataCode: "loadingTimes", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'glj.unitPrice'
  46. {headerName: "其它\n费用", headerWidth: 41, dataCode: "otherFee", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:"glj.unitPrice"
  47. {headerName: "运价增\n加率(%)", headerWidth: 55, dataCode: "freightIncreaseRate", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:"glj.unitPrice"
  48. {headerName: "加权\n系数", headerWidth: 41, dataCode: "weightCoe", hAlign: "right", dataType: "Number",validator:"number"},
  49. {headerName: "计算式", headerWidth: 170, dataCode: "exp", hAlign: "left", dataType: "Number",getText:'forExp'},//,decimalField:"glj.unitPrice"
  50. {headerName: "计算方式", headerWidth: 80, dataCode: "calcType",visible: false, dataType: "String",cellType:"comboBox",options:["全国","内蒙古"]}
  51. ],
  52. view: {
  53. lockColumns: ["exp"],
  54. rowHeaderWidth:25,
  55. colHeaderHeight:36
  56. },
  57. getText:{
  58. forExp:function (item) {
  59. let material = materialCalcObj.getMaterialSelected();
  60. if(gljUtil.isDef(item.materialType)&&item.materialType != ""){
  61. let uString = materialCalcObj.getNeiMengUnitFreightString(item.kmDistance,item.materialType);
  62. return `((${uString}x(1+${item.freightIncreaseRate}%)+${item.unitLoadingFee}x${item.loadingTimes})/1.09+${item.otherFee})x${material.grossWeightCoe_n}x${item.weightCoe}`;
  63. }
  64. //(单位运价×(1+运距增加率%)+装卸费单价×装卸次数+其它费用)×单位毛重×加权系数
  65. if(item.conveyance == "自办运输") return `(${item.unitFreight}x(1+${item.freightIncreaseRate}%)+${item.unitLoadingFee}x${item.loadingTimes}+${item.otherFee})x${material.grossWeightCoe_n}x${item.weightCoe}`;
  66. //(单位运价×km运距×(1+运距增加率%)+装卸费单价×装卸次数+其它费用)×单位毛重×加权系数
  67. return `(${item.unitFreight}x${item.kmDistance}x(1+${item.freightIncreaseRate}%)+${item.unitLoadingFee}x${item.loadingTimes}+${item.otherFee})x${material.grossWeightCoe_n}x${item.weightCoe}`;
  68. }
  69. }
  70. },
  71. priceSpread:null,
  72. priceSheet:null,
  73. priceDatas:[],
  74. priceSetting:{
  75. header:[
  76. {headerName: "供应地点", headerWidth: 80, dataCode: "supplyLocation", dataType: "String"},
  77. {headerName: "供应价", headerWidth: 70, dataCode: "supplyPrice", hAlign: "right", dataType: "Number",validator:"number"},
  78. {headerName: "加权系数", headerWidth: 80, dataCode: "coe", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'glj.unitPrice'
  79. ],
  80. view: {
  81. lockColumns: [],
  82. rowHeaderWidth:25,
  83. colHeaderHeight:36
  84. }
  85. },
  86. freightRationSpread:null,
  87. freightRationSheet:null,
  88. freightRations:[],
  89. priceRations:[],
  90. priceRationSpread:null,
  91. priceRationSheet:null,
  92. rationSetting:{
  93. header:[
  94. {headerName: "编号", headerWidth: 80, dataCode: "code", dataType: "String",formatter: "@"},
  95. {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"},
  96. {headerName: "单位", headerWidth: 100, dataCode: "unit", dataType: "String"},
  97. {headerName: "数量", headerWidth: 100, dataCode: "quantity", dataType: "String",hAlign: "right",validator:"number"},
  98. {headerName: "高原取费类别", headerWidth: 100, dataCode: "feeType", dataType: "String",visible: false,cellType:"comboBox",options:[],maxDropDownItems:5}
  99. ],
  100. view: {
  101. lockColumns: ["unit"],
  102. rowHeaderWidth:25,
  103. colHeaderHeight:36
  104. }
  105. },
  106. initMaterialSpread:function () {
  107. this.materialSpread = SheetDataHelper.createNewSpread($("#materialCalcSheet")[0]);
  108. sheetCommonObj.spreadDefaultStyle(this.materialSpread);
  109. this.materialSheet = this.materialSpread.getSheet(0);
  110. sheetCommonObj.initSheet(this.materialSheet, this.materialSetting, 30);
  111. this.materialSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onMaterialValueChange);
  112. this.materialSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onMaterialSelectionChange);
  113. this.materialSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onMaterialEditStarting);
  114. this.materialSheet.name('material_calc');
  115. if(projectReadOnly){
  116. disableSpread(this.materialSpread);
  117. }else {
  118. this.initRightClick("materialCalcSheet",this.materialSpread)
  119. }
  120. },
  121. initFreightSpread:async function(){
  122. this.freightSpread = SheetDataHelper.createNewSpread($("#freightSheet")[0]);
  123. sheetCommonObj.spreadDefaultStyle(this.freightSpread);
  124. this.freightSheet = this.freightSpread.getSheet(0);
  125. sheetCommonObj.initSheet(this.freightSheet, this.freightSetting, 30);
  126. this.freightSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onFreightValueChange);
  127. this.freightSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onFreightSelectionChange);
  128. this.freightSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onFreightEditStarting);
  129. this.freightSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onFreightPriceRangeChange);
  130. this.freightSheet.name('freight_calc');
  131. if(projectReadOnly){
  132. disableSpread(this.freightSpread);
  133. }else {
  134. this.initRightClick("freightSheet",this.freightSpread)
  135. }
  136. this.userFreightList = await projectObj.project.projectGLJ.getUserFreights();
  137. },
  138. initFreightRationSpread:function () {
  139. this.freightRationSpread = SheetDataHelper.createNewSpread($("#freight_ration_sheet")[0]);
  140. sheetCommonObj.spreadDefaultStyle(this.freightRationSpread);
  141. this.freightRationSheet = this.freightRationSpread.getSheet(0);
  142. sheetCommonObj.initSheet(this.freightRationSheet, this.rationSetting, 30);
  143. this.freightRationSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onFreightRationValueChange);
  144. this.freightRationSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onRationSelectionChange);
  145. this.freightRationSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onFreightRationEditStarting);
  146. this.freightRationSheet.name('freight_ration');
  147. if(projectReadOnly){
  148. disableSpread(this.freightRationSpread);
  149. }else {
  150. this.initRightClick("freight_ration_sheet",this.freightRationSpread);
  151. }
  152. },
  153. initPriceRationSpread:function () {
  154. this.priceRationSpread = SheetDataHelper.createNewSpread($("#price_ration_sheet")[0]);
  155. sheetCommonObj.spreadDefaultStyle(this.priceRationSpread);
  156. this.priceRationSheet = this.priceRationSpread.getSheet(0);
  157. sheetCommonObj.initSheet(this.priceRationSheet, this.rationSetting, 30);
  158. this.priceRationSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onPriceRationValueChange);
  159. this.priceRationSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onRationSelectionChange);
  160. this.priceRationSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onPriceRationEditStarting);
  161. this.priceRationSheet.name('price_ration');
  162. if(projectReadOnly){
  163. disableSpread(this.priceRationSpread);
  164. }else {
  165. this.initRightClick("price_ration_sheet",this.priceRationSpread);
  166. }
  167. },
  168. initPriceSpread:async function(){
  169. this.priceSpread = SheetDataHelper.createNewSpread($("#priceSheet")[0]);
  170. sheetCommonObj.spreadDefaultStyle(this.priceSpread);
  171. this.priceSheet = this.priceSpread.getSheet(0);
  172. sheetCommonObj.initSheet(this.priceSheet, this.priceSetting, 30);
  173. this.priceSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onFreightPriceRangeChange);
  174. this.priceSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onPriceValueChange);
  175. this.priceSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onPriceSelectionChange);
  176. this.priceSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onPriceEditStarting);
  177. this.priceSheet.name('price_calc');
  178. if(projectReadOnly){
  179. disableSpread(this.priceSpread);
  180. }else {
  181. this.initRightClick("priceSheet",this.priceSpread)
  182. }
  183. },
  184. showFreightDatas:function () {
  185. if(!$('#freightSheet').is(':visible')) return;
  186. let sel = this.freightSheet.getSelections()[0];
  187. let oldData = sel.row<this.freightDatas.length?this.freightDatas[sel.row]:"";
  188. this.freightSheet.setRowCount(0);
  189. this.freightDatas = this.getFreightDatas();
  190. sheetCommonObj.showData(this.freightSheet, this.freightSetting,this.freightDatas);
  191. this.freightSheet.setRowCount(this.freightDatas.length+20);
  192. let convCol = _.findIndex(this.freightSetting.header,{'dataCode':'conveyance'});
  193. sheetCommonObj.setComboBox(-1,convCol,this.freightSheet,this.conveyanceOptions,false);
  194. let startCol = _.findIndex(this.freightSetting.header,{'dataCode':'start'});
  195. let startOptions = this.getUserFreightOptions();
  196. sheetCommonObj.setComboBox(-1,startCol,this.freightSheet,startOptions,false,true,5);
  197. sel.row = oldData?_.findIndex(this.freightDatas,{'ID':oldData.ID}):sel.row ;
  198. this.freightSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount);
  199. this.refreshRationView();
  200. },
  201. getUserFreightOptions :function () {
  202. let options = [];
  203. for(let uf of this.userFreightList){
  204. options.push(uf.freight.start);
  205. }
  206. return options;
  207. },
  208. showFreightRationDatas:function (freight) {
  209. let sel = this.freightRationSheet.getSelections()[0];
  210. let oldData = sel.row<this.freightRations.length?this.freightRations[sel.row]:"";
  211. this.freightRationSheet.setRowCount(0);
  212. this.freightRations = freight.rations?freight.rations:[];
  213. sheetCommonObj.showData(this.freightRationSheet, this.rationSetting,this.freightRations);
  214. this.freightRationSheet.setRowCount(this.freightRations+20);
  215. sel.row = oldData?_.findIndex(this.freightRations,{'ID':oldData.ID}):sel.row ;
  216. this.freightRationSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount);
  217. this.refreshAssView();
  218. },
  219. showPriceRationDatas:function () {
  220. let price = this.getSelectedPrice();
  221. let sel = this.priceRationSheet.getSelections()[0];
  222. let oldData = sel.row<this.priceRations.length?this.priceRations[sel.row]:"";
  223. this.priceRationSheet.setRowCount(0);
  224. this.priceRations = price&&price.rations?price.rations:[];
  225. sheetCommonObj.showData(this.priceRationSheet, this.rationSetting,this.priceRations);
  226. this.priceRationSheet.setRowCount(this.priceRations+20);
  227. sel.row = oldData?_.findIndex(this.priceRations,{'ID':oldData.ID}):sel.row ;
  228. this.priceRationSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount);
  229. this.refreshAssView();
  230. },
  231. showMaterialCalcDatas:function(){
  232. let sel = this.materialSheet.getSelections()[0];
  233. let oldData = sel.row<this.materialDatas.length?this.materialDatas[sel.row]:"";
  234. this.materialSheet.setRowCount(0);
  235. this.materialDatas = this.getMaterialCalcDatas();
  236. sheetCommonObj.showData(this.materialSheet, this.materialSetting,this.materialDatas);
  237. this.materialSheet.setRowCount(this.materialDatas.length);
  238. sel.row = oldData?_.findIndex(this.materialDatas,{'id':oldData.id}):-1;
  239. this.materialSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount);
  240. },
  241. showPriceDatas:function () {
  242. if(!$('#priceSheet').is(':visible')) return;
  243. let sel = this.priceSheet.getSelections()[0];
  244. let oldData = sel.row<this.priceDatas.length?this.priceDatas[sel.row]:"";
  245. this.priceSheet.setRowCount(0);
  246. this.priceDatas = this.getPriceDatas();
  247. sheetCommonObj.showData(this.priceSheet, this.priceSetting,this.priceDatas);
  248. this.priceSheet.setRowCount(this.priceDatas.length+20);
  249. sel.row = oldData?_.findIndex(this.priceDatas,{'ID':oldData.ID}):sel.row ;
  250. this.priceSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount);
  251. this.showPriceRationDatas();
  252. },
  253. showDatas:async function(){
  254. if(!$('#materialCalcSheet').is(':visible')) return;
  255. if(!this.materialSpread) this.initMaterialSpread();
  256. if(!this.freightSpread)await this.initFreightSpread();
  257. if(!this.priceSpread) this.initPriceSpread();
  258. if(!this.freightRationSpread) this.initFreightRationSpread();
  259. if(!this.priceRationSpread) this.initPriceRationSpread();
  260. let h =_.find(this.rationSetting.header,{"dataCode":"feeType"});
  261. if(h) h.options = projectObj.project.calcProgram.compiledTemplateNames;
  262. this.showMaterialCalcDatas();
  263. this.showFreightDatas();
  264. this.showPriceDatas();
  265. // 先试试看注释有没有bug projectGljObject.refreshSubViews();
  266. },
  267. getMaterialSelected:function () {
  268. let sel = this.materialSheet.getSelections()[0];
  269. if(sel.row != -1 && this.materialDatas.length>sel.row){
  270. return this.materialDatas[sel.row]
  271. }
  272. return null;
  273. },
  274. getPriceDatas:function () {
  275. let list = projectObj.project.projectGLJ.datas.originalList;
  276. let material = this.getMaterialSelected();
  277. return material?_.filter(list,{"connect_key":gljUtil.getIndex(material)}):[];
  278. },
  279. getFreightDatas:function () {
  280. let list = projectObj.project.projectGLJ.datas.freightList;
  281. let material = this.getMaterialSelected();
  282. return material?_.filter(list,{"connect_key":gljUtil.getIndex(material)}):[];
  283. },
  284. getMaterialCalcDatas:function () {
  285. let gljList = projectObj.project.projectGLJ.datas.gljList;
  286. let datas = [];
  287. for(let g of gljList){
  288. if(g.quantity !== 0 && g.quantity !== '0' && g.unit_price.calcMaterial == 1){
  289. let data = {
  290. id:g.id,
  291. code:g.code,
  292. name:g.name,
  293. type:g.type,
  294. unit:g.unit,
  295. specs:g.specs,
  296. unit_price:{id:g.unit_price.id,type:g.type,unit_price_file_id:g.unit_price.unit_price_file_id},//type用来排序
  297. supplyLocation:g.unit_price.supplyLocation,
  298. originalPrice:g.unit_price.originalPrice?g.unit_price.originalPrice:0,
  299. unitFreight:g.unit_price.unitFreight?g.unit_price.unitFreight:0,
  300. // unitWeight:g.unit_price.unitWeight?g.unit_price.unitWeight:0,
  301. totalLoadingTimes:g.unit_price.totalLoadingTimes?g.unit_price.totalLoadingTimes:0,
  302. handlingLossRate_n:g.unit_price.handlingLossRate_n?g.unit_price.handlingLossRate_n:0,
  303. offSiteTransportLossRate_n:g.unit_price.offSiteTransportLossRate_n?g.unit_price.offSiteTransportLossRate_n:0,
  304. offSiteTransportLoss:g.unit_price.offSiteTransportLoss?g.unit_price.offSiteTransportLoss:0,
  305. purchaseStorageRate_n:g.unit_price.purchaseStorageRate_n?g.unit_price.purchaseStorageRate_n:0,
  306. purchaseStorage:g.unit_price.purchaseStorage?g.unit_price.purchaseStorage:0,
  307. grossWeightCoe_n:g.unit_price.grossWeightCoe_n?g.unit_price.grossWeightCoe_n:0,
  308. packageRecoverValue:g.unit_price.packageRecoverValue?g.unit_price.packageRecoverValue:0
  309. };
  310. gljOprObj.setGLJPrice(data,g);
  311. datas.push(data);
  312. }
  313. }
  314. return gljUtil.sortProjectGLJ(datas);
  315. },
  316. onMaterialSelectionChange:function(sender,args){
  317. let me = materialCalcObj;
  318. let newSel = args.newSelections[0];
  319. let oldSel = args.oldSelections?args.oldSelections[0]:{};
  320. if(newSel.row != oldSel.row){
  321. me.showPriceDatas();
  322. me.showFreightDatas();
  323. }
  324. },
  325. onFreightSelectionChange:function (sender,args) {
  326. materialCalcObj.refreshRationView();
  327. args.sheet.repaint();
  328. },
  329. onRationSelectionChange:function(sender,args){
  330. materialCalcObj.refreshAssView(args);
  331. args.sheet.repaint();
  332. },
  333. onPriceSelectionChange:function (sender,args) {
  334. materialCalcObj.showPriceRationDatas();
  335. },
  336. onPriceEditStarting:function (sender,args) {
  337. let me = materialCalcObj;
  338. if(!me.getMaterialSelected()){
  339. args.cancel = true;
  340. }else {
  341. let price = me.priceDatas[args.row];
  342. let dataCode = me.priceSetting.header[args.col].dataCode;
  343. if(dataCode == "supplyPrice"){
  344. if(price.rations && price.rations.length > 0) args.cancel = true;
  345. }
  346. }
  347. },
  348. onFreightEditStarting:function(sender,args){
  349. let me = materialCalcObj;
  350. if(!me.getMaterialSelected()){
  351. args.cancel = true;
  352. }else {
  353. let freigth = me.freightDatas[args.row];
  354. let dataCode = me.freightSetting.header[args.col].dataCode;
  355. if(dataCode=="materialType"){
  356. if(!freigth){
  357. args.cancel = true;
  358. }else if(freigth.conveyance !="汽车"){//只有在汽车的情况下,材料类型列才能编辑
  359. args.cancel = true;
  360. }
  361. }
  362. if(freigth){
  363. if(dataCode == "kmDistance" || dataCode=="unitLoadingFee" || dataCode =="loadingTimes" || dataCode == "freightIncreaseRate"){
  364. if(freigth.conveyance == "自办运输") args.cancel = true;
  365. }
  366. if(dataCode == "unitFreight"){
  367. if(freigth.rations && freigth.rations.length > 0) args.cancel = true;
  368. if(gljUtil.isDef(freigth.materialType) && freigth.materialType != "") args.cancel = true;//当材料类型有值时,说明是内蒙古计算,运费是能过运距算出来的,不能编辑
  369. }
  370. }
  371. }
  372. },
  373. onFreightRationEditStarting:function (sender,args) {
  374. materialCalcObj.onRationEditStarting(sender,args,"freight");
  375. },
  376. onPriceRationEditStarting:function (sender,args) {
  377. materialCalcObj.onRationEditStarting(sender,args,"price");
  378. },
  379. onRationEditStarting:function(sender,args,type){
  380. let me = materialCalcObj;
  381. let dataCode = me.rationSetting.header[args.col].dataCode;
  382. let datas = type == "freight"?me.freightRations:me.priceRations;
  383. if(type == 'price' && !gljUtil.isDef(me.getSelectedPrice())) args.cancel = true;//没有选中原价,不可编辑
  384. if(args.row > datas.length){
  385. args.cancel = true;
  386. }else if(args.row == datas.length && dataCode != "code"){
  387. args.cancel = true;
  388. }
  389. },
  390. onMaterialEditStarting:function (sender,args) {
  391. let me = materialCalcObj;
  392. let dataCode = me.materialSetting.header[args.col].dataCode;
  393. if(dataCode == "supplyLocation" ||dataCode == "originalPrice"){//原价计算表有数据时只读,
  394. args.cancel = me.getPriceDatas().length > 0;
  395. }
  396. if(dataCode == "unitFreight"){//当运费计算表有数据时,则只读
  397. args.cancel = me.getFreightDatas().length > 0;
  398. }
  399. },
  400. onMaterialValueChange:function (sender,args) {
  401. let me = materialCalcObj;
  402. let dataCode = me.materialSetting.header[args.col].dataCode;
  403. let value = args.newValue;
  404. if (value&&!sheetCommonObj.checkData(args.col,me.materialSetting,value)) {
  405. alert('输入的数据类型不对,请重新输入!');
  406. me.showDatas();
  407. return;
  408. }
  409. if(dataCode != 'supplyLocation'){
  410. value = value?scMathUtil.roundForObj(value,getDecimal("glj.unitPrice"))+'':'0'//4舍五入加默认为0
  411. }
  412. let recode = me.materialDatas[args.row];
  413. if(recode[dataCode] == value) return;
  414. let doc = {};
  415. doc[dataCode] = value;
  416. projectObj.project.projectGLJ.updateMaterialCalc([{id:recode.id,doc:doc}]);
  417. },
  418. getDefualtCalcType:function () {
  419. return "全国";
  420. },
  421. getNewFreightData:function (material) {
  422. let newData = {
  423. ID: uuid.v1(),
  424. start:"",//起讫地点
  425. conveyance:"汽车",//运输工具
  426. unitFreight:'0',//单位运价
  427. kmDistance:'0',//km运距
  428. unitLoadingFee:'0',//装卸费单价
  429. loadingTimes:'0',//装卸次数
  430. otherFee:'0',//其它费用
  431. freightIncreaseRate:'0',//运价增加率
  432. weightCoe:'1',//加权系数
  433. connect_key:gljUtil.getIndex(material),
  434. materialType:"",
  435. unit_price_file_id:material.unit_price.unit_price_file_id
  436. };
  437. return newData;
  438. },
  439. getSavedFreight:function (start,material) {
  440. let t = null;
  441. for(let f of this.userFreightList){
  442. if(f.freight.start == start){
  443. t = newDatas(f.freight,material);
  444. break;
  445. }
  446. }
  447. return t;
  448. function newDatas(freight,material) {
  449. let doc = {};
  450. for(let key in freight){
  451. doc[key] = freight[key];
  452. if(key == "ID") doc[key] = uuid.v1();
  453. if(key == "connect_key") doc[key] = gljUtil.getIndex(material);
  454. if(key == "unit_price_file_id") doc[key] = material.unit_price.unit_price_file_id;
  455. }
  456. delete doc._id;
  457. return doc;
  458. }
  459. },
  460. checkSavedFreight:function (start) {
  461. let t = null;
  462. for(let f of this.userFreightList){
  463. if(f.freight.start == start){
  464. t = f;
  465. break;
  466. }
  467. }
  468. return t;
  469. },
  470. onFreightPriceRangeChange:function (sender,args) {
  471. let me = materialCalcObj;
  472. let dataMap={};
  473. let sheetName = args.sheet.name();
  474. for(let c of args.changedCells){
  475. let info = {row:c.row,col:c.col,cancel:false};
  476. sheetName == 'price_calc'?me.onPriceEditStarting(sender,info): me.onFreightEditStarting(sender,info);
  477. if(info.cancel) return me.showDatas();
  478. let value= args.sheet.getCell(c.row, c.col).text();
  479. if(dataMap[c.row]){
  480. dataMap[c.row][c.col]=value;
  481. }else{
  482. dataMap[c.row] ={};
  483. dataMap[c.row][c.col] = value;
  484. }
  485. }
  486. sheetName == 'price_calc'?me.addOrUpdatePriceCalc(dataMap):me.addOrUpdateFreightCalc(dataMap);
  487. },
  488. onFreightValueChange:function (sender,args) {
  489. let me = materialCalcObj;
  490. let dataMap = {};
  491. dataMap[args.row]={};
  492. dataMap[args.row][args.col] = args.newValue;
  493. me.addOrUpdateFreightCalc(dataMap);
  494. },
  495. addOrUpdateFreightCalc:function (dataMap) {//{2:{col:value}}
  496. let me = materialCalcObj;
  497. let material = me.getMaterialSelected();
  498. let addDatas=[],updateDatas=[];
  499. for(let row in dataMap) {
  500. let t = dataMap[row];
  501. let newData = {};
  502. let doc = {};
  503. let recode = me.freightDatas[row];
  504. for (let col in t) {
  505. let value = t[col];
  506. let dataCode = me.freightSetting.header[col].dataCode;
  507. if (value && !sheetCommonObj.checkData(col, me.freightSetting, value)) {
  508. alert('输入的数据类型不对,请重新输入!');
  509. return me.showDatas();
  510. }
  511. if (dataCode != 'start' && dataCode != 'conveyance' && dataCode != 'calcType' && dataCode != 'materialType') {
  512. value = value ? scMathUtil.roundForObj(value, getDecimal("glj.unitPrice")) + '' : '0'//4舍五入加默认为0
  513. }
  514. if (parseInt(row) >= me.freightDatas.length) {//新增
  515. let tempFreight = null;
  516. if (dataCode == "start") {
  517. tempFreight = me.getSavedFreight(value, material);
  518. }
  519. if (tempFreight) {
  520. newData = tempFreight;
  521. } else {
  522. if(_.isEmpty(newData)) newData = me.getNewFreightData(material);
  523. newData[dataCode] = value;
  524. }
  525. } else {//修改
  526. if (recode[dataCode] == value) continue;
  527. doc[dataCode] = value;
  528. if (dataCode == "conveyance") {//如果运输方式从自办运输切换成其它的东西时,要把底下挂的定额和定额工料机都清空
  529. if (recode[dataCode] == "自办运输") {//没改之前的值
  530. doc["rations"] = [];
  531. doc["ration_gljs"] = [];
  532. }
  533. if (value == "自办运输") {//当运输工具下拉选择“自办运输”时,“Km运距”、“装卸费单价”、“装卸次数”、“运价增加率(%)”列数据归0,且灰选不可编辑
  534. doc["kmDistance"] = '0';
  535. doc["unitLoadingFee"] = '0';
  536. doc["loadingTimes"] = '0';
  537. doc["freightIncreaseRate"] = '0';
  538. }
  539. if (recode[dataCode] == "汽车") doc["materialType"] = "";//当运输方式从汽车切换成其它方式时,清空材料类型
  540. }
  541. if (dataCode == "materialType" && value != "") doc["unitFreight"] = me.calcNeiMengUnitFreight(recode.kmDistance, value);
  542. if (dataCode == "kmDistance" && gljUtil.isDef(recode.materialType) && recode.materialType != "") doc["unitFreight"] = me.calcNeiMengUnitFreight(value, recode.materialType);
  543. if (dataCode == "start") {
  544. let t_f = me.getSavedFreight(value, material);
  545. if (t_f) doc = t_f;
  546. }
  547. }
  548. }
  549. if (!_.isEmpty(newData)) addDatas.push(newData);
  550. if (!_.isEmpty(doc)) updateDatas.push({ID:recode.ID,doc:doc});
  551. }
  552. if(addDatas.length > 0 && updateDatas.length > 0) {
  553. alert("不能同时增加和更新操作");
  554. return me.showDatas();
  555. }
  556. if(addDatas.length > 0) projectObj.project.projectGLJ.addFreightCalc(addDatas,material.id);
  557. if(updateDatas.length > 0) projectObj.project.projectGLJ.updateFreightCalc(updateDatas,material.id);
  558. },
  559. calcNeiMengUnitFreight:function (tkmDistance,tmaterialType) {
  560. if(!tkmDistance||tkmDistance == '0') return "0";
  561. let decimal = getDecimal("glj.unitPrice");
  562. tkmDistance = scMathUtil.roundForObj(tkmDistance,decimal);
  563. return scMathUtil.roundForObj(this.calNeiMengTotalFreight(tkmDistance,tmaterialType)/tkmDistance,decimal);
  564. },
  565. calNeiMengTotalFreight:function (kmDistance,materialType) {
  566. if(!kmDistance||kmDistance == '0') return 0;
  567. let decimal = getDecimal("glj.unitPrice");
  568. let baseMap = {"地方材料":6,"外购材料":13,"沥青、燃料等":19};//"地方材料","外购材料","沥青、燃料等"
  569. let baseFreight = baseMap[materialType];
  570. kmDistance = scMathUtil.roundForObj(kmDistance,decimal);
  571. //用截取的方式,一段段取值
  572. let less = kmDistance - 5;//kmDistance <= 5 这段
  573. if(less <= 0) return baseFreight ; //kmDistance <= 5 的时候直接取baseFreight
  574. //5< kmDistance <= 15 每增运1km 则增加0.6
  575. less = less - 10;
  576. if(less <=0) return scMathUtil.roundForObj(baseFreight + scMathUtil.roundForObj((less + 10) * 0.6,6),decimal);//baseFreight + (less + 10) * 0.6;
  577. baseFreight = baseFreight + 10 * 0.6; //累加5到15这一段的运费;
  578. //15< kmDistance <= 100 每增运1km 则增加0.45
  579. less = less - 85;
  580. if(less <=0) return scMathUtil.roundForObj(baseFreight + scMathUtil.roundForObj((less + 85)*0.45,6),decimal);//baseFreight + (less + 85)*0.45;
  581. baseFreight = scMathUtil.roundForObj(baseFreight + scMathUtil.roundForObj(85*0.45,6),6) ; //累加15到100这一段的运费;
  582. return scMathUtil.roundForObj(baseFreight + scMathUtil.roundForObj(less * 0.35,6),decimal); // >100 的所有部分每增运1km 则增加0.35 baseFreight + less * 0.35
  583. },
  584. getNeiMengUnitFreightString:function (kmDistance,materialType) {
  585. if(!kmDistance||kmDistance == '0') return "0";
  586. let decimal = getDecimal("glj.unitPrice");
  587. let baseMap = {"地方材料":6,"外购材料":13,"沥青、燃料等":19};//"地方材料","外购材料","沥青、燃料等"
  588. let baseFreight = baseMap[materialType];
  589. kmDistance = scMathUtil.roundForObj(kmDistance,decimal);
  590. let resultString = baseFreight+"";
  591. //用截取的方式,一段段取值
  592. let less = kmDistance - 5;//kmDistance <= 5 这段
  593. if(less <= 0) return resultString ; //kmDistance <= 5 的时候直接取baseFreight
  594. //5< kmDistance <= 15 每增运1km 则增加0.6
  595. less = less - 10;
  596. if(less <=0) return `(${resultString}+0.6x${less + 10})`;//baseFreight + (less + 10) * 0.6;
  597. resultString = `${resultString}+0.6x10`;
  598. //15< kmDistance <= 100 每增运1km 则增加0.45
  599. less = less - 85;
  600. if(less <=0) return `(${resultString}+0.45x${less + 85})`; //baseFreight + (less + 85)*0.45;
  601. resultString = `${resultString}+0.45x85`;
  602. return `(${resultString}+0.35x${less})`;// >100 的所有部分每增运1km 则增加0.35 baseFreight + less * 0.35
  603. },
  604. onFreightRationValueChange:function (sender,args) {
  605. materialCalcObj.onRationValueChange(sender,args,"freight");
  606. },
  607. onPriceRationValueChange:function (sender,args) {
  608. materialCalcObj.onRationValueChange(sender,args,"price");
  609. },
  610. onRationValueChange:function (sender,args,type) {
  611. let me = materialCalcObj;
  612. let dataCode = me.rationSetting.header[args.col].dataCode;
  613. let value = args.newValue;
  614. let parent = type == "freight"? me.getSelectedFreight():me.getSelectedPrice();
  615. let dataList = type == "freight"?me.freightRations:me.priceRations;
  616. if(dataCode == "code" && args.row >= dataList.length) {//新增
  617. if(parent) projectObj.project.projectGLJ.addMaterialRation(value,type,parent.ID,parent.connect_key);
  618. }else { //修改
  619. let ration = dataList[args.row];
  620. if (value&&!sheetCommonObj.checkData(args.col,me.rationSetting,value)) {
  621. alert('输入的数据类型不对,请重新输入!');
  622. return type == "freight"?me.showFreightRationDatas(parent):me.showPriceRationDatas();
  623. }
  624. if(dataCode == 'quantity'){
  625. if(value){
  626. value = scMathUtil.roundForObj(parseFloat(value) / FilterNumberFromUnit(ration.unit),getDecimal("ration.quantity"))+"";
  627. }else {
  628. value = "0";
  629. }
  630. }
  631. let datas = {parentID:parent.ID,rationID:ration.ID,type:type,actionType:"update",field:dataCode,value:value};
  632. if(dataCode == "code"){ //这时是替换,替换比较麻烦
  633. datas.code = value;
  634. datas.row = args.row;
  635. let libIDs = rationLibObj.getStdRationLibIDs();
  636. let defaultLibID = rationLibObj.getDefaultStdRationLibID();
  637. let selectedLib = sessionStorage.getItem("stdRationLib");
  638. selectedLib&&selectedLib!='undefined'?libIDs.unshift(selectedLib):libIDs.unshift(defaultLibID);
  639. datas.userID = userID;
  640. datas.defaultLibID = defaultLibID;
  641. datas.rationRepIds = libIDs;
  642. datas.quantityDecimal = getDecimal("ration.quantity");
  643. datas.connect_key = parent.connect_key;
  644. datas.projectID = projectObj.project.ID();
  645. datas.rations = parent.rations;
  646. datas.ration_gljs = parent.ration_gljs;
  647. }
  648. projectObj.project.projectGLJ.updateMaterialRation(datas);
  649. }
  650. },
  651. addOrUpdatePriceCalc:function (dataMap) {
  652. let me = materialCalcObj;
  653. let material = me.getMaterialSelected();
  654. let addDatas=[],updateDatas=[];
  655. for(let row in dataMap) {
  656. let t = dataMap[row];
  657. let doc = {};
  658. let recode = me.priceDatas[row];
  659. let newData = {};
  660. for (let col in t) {
  661. let value = t[col];
  662. let dataCode = me.priceSetting.header[col].dataCode;;
  663. if (value && !sheetCommonObj.checkData(col, me.priceSetting, value)) {
  664. alert('输入的数据类型不对,请重新输入!');
  665. return me.showDatas();
  666. }
  667. if(dataCode == 'coe'||dataCode == 'supplyPrice'){
  668. let decimal = dataCode == 'supplyPrice'?getDecimal("glj.unitPriceHasMix"):getDecimal("glj.unitPrice");
  669. value = value?scMathUtil.roundForObj(value,decimal)+'':'0'//4舍五入加默认为0
  670. }
  671. if(parseInt(row) >= me.priceDatas.length){//新增
  672. if(_.isEmpty(newData)) newData = me.getNewPriceData(material);
  673. newData[dataCode] = value;
  674. }else {//修改
  675. if(recode[dataCode] == value) continue;
  676. doc[dataCode] = value;
  677. }
  678. }
  679. if (!_.isEmpty(newData)) addDatas.push(newData);
  680. if (!_.isEmpty(doc)) updateDatas.push({ID:recode.ID,doc:doc});
  681. }
  682. if(addDatas.length > 0 && updateDatas.length > 0) {
  683. alert("不能同时增加和更新操作");
  684. return me.showDatas();
  685. }
  686. if(addDatas.length > 0) projectObj.project.projectGLJ.addPriceCalc(addDatas,material.id);
  687. if(updateDatas.length > 0) projectObj.project.projectGLJ.updatePriceCalc(updateDatas,material.id);
  688. },
  689. getNewPriceData:function (material) {
  690. let newData = {
  691. ID:uuid.v1(),
  692. supplyLocation:"",
  693. supplyPrice:'0',
  694. coe:'1',
  695. connect_key:gljUtil.getIndex(material),
  696. unit_price_file_id:material.unit_price.unit_price_file_id
  697. };
  698. return newData;
  699. },
  700. onPriceValueChange:function(sender,args){
  701. let me = materialCalcObj;
  702. let dataMap = {};
  703. dataMap[args.row]={};
  704. dataMap[args.row][args.col] = args.newValue;
  705. me.addOrUpdatePriceCalc(dataMap);
  706. },
  707. deleteMaterialCal:function (row) {
  708. let record = this.materialDatas[row];//修改材料计算标记的同时还要删除原价计算,运费计算等
  709. if(record){
  710. projectObj.project.projectGLJ.updateCalcMaterial(record,'calcMaterial',0);
  711. }
  712. },
  713. deletePriceCalc:function (row) {
  714. let record = this.priceDatas[row];
  715. if(record){
  716. let material = this.getMaterialSelected();
  717. projectObj.project.projectGLJ.deletePriceCalc(record.ID,material.id);
  718. }
  719. },
  720. deleteFreightCalc:function (row) {
  721. let record = this.freightDatas[row];
  722. if(record){
  723. let material = this.getMaterialSelected();
  724. projectObj.project.projectGLJ.deleteFreightCalc(record.ID,material.id);
  725. }
  726. },
  727. deleteRation:function (row,type) {
  728. let me = this;
  729. let parent = type == "freight"?me.getSelectedFreight():me.getSelectedPrice();
  730. let ration = type == "freight"?me.freightRations[row]:me.priceRations[row];
  731. let datas = {parentID:parent.ID,rationID:ration.ID,type:type,actionType:"delete"};
  732. projectObj.project.projectGLJ.updateMaterialRation(datas);
  733. },
  734. saveFreight:function (row) {
  735. let me = this;
  736. let record = this.freightDatas[row];
  737. if(record){
  738. let exist = this.checkSavedFreight(record.start);
  739. if(exist){//已存在的情况,更新
  740. let info =`起讫地点“${record.start}”已存在,是否覆盖?`;
  741. //to do 检查是否已经存在,存在给出是否覆盖提示
  742. hintBox.infoBox('操作确认', info, 2, function () {
  743. me.updateUserFreight(record,exist)
  744. }, function () {
  745. //
  746. },['确定','取消'],false);
  747. return true;
  748. }
  749. let user_freight = {rootProjectID:projectObj.project.projectInfo.property.rootProjectID};
  750. let f = {};
  751. for(let key in record){
  752. if(key == "_id") continue;
  753. f[key] = record[key];
  754. if(key =="ration" || key == "ration_gljs")f[key] = [];//下面的定额和工料机不用保存
  755. }
  756. user_freight.freight = f;
  757. projectObj.project.projectGLJ.updateUserFreight({freights:[user_freight],action:"add"});
  758. }
  759. },
  760. updateUserFreight:function (record,userFreight) {
  761. let t = {};
  762. for(let t_key in userFreight){
  763. if(t_key == "ID") continue;
  764. t[t_key] = userFreight[t_key];
  765. }
  766. t.rootProjectID = projectObj.project.projectInfo.property.rootProjectID;
  767. let f = {};
  768. for(let key in record){
  769. if(key == "_id") continue;
  770. f[key] = record[key];
  771. if(key =="ration" || key == "ration_gljs")f[key] = [];//下面的定额和工料机不用保存
  772. }
  773. t.freight = f;
  774. projectObj.project.projectGLJ.updateUserFreight({ID:userFreight.ID,doc:t,action:"update"});
  775. },
  776. getSideResize: function () {
  777. let rg_sideResizeEles = {};
  778. rg_sideResizeEles.eleObj = {
  779. module: this.moduleName,
  780. resize: $('#mrResize'),
  781. parent: $('#projectGljBottom'),
  782. left: $('#materialCalcSheet'),
  783. right: $('#calcDiv')
  784. };
  785. rg_sideResizeEles.limit = {
  786. min: 100,
  787. max: `$('#projectGljBottom').width()-100`
  788. };
  789. return rg_sideResizeEles;
  790. },
  791. initRightClick:function (id,spread) {
  792. let me = this;
  793. $.contextMenu({
  794. selector: '#'+id,
  795. build: function ($trigger, e) {
  796. me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  797. return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport ||
  798. me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  799. },
  800. items: {
  801. "insertFreight":{
  802. name: "内蒙古计算",
  803. icon: 'fa-sign-in',
  804. visible:function () {
  805. return false;//2019-11-17 改成不需要右键插入功能 id == "freightSheet";
  806. },
  807. disabled: function (){
  808. let material = me.getMaterialSelected();
  809. return !material;
  810. },
  811. callback:function () {
  812. $("#insertNeimengDiv").modal("show");
  813. }
  814. },
  815. "saveFreight":{
  816. name: "保存运输起讫地点",
  817. icon: 'fa-sign-in',
  818. visible:function () {
  819. return id == "freightSheet";
  820. },
  821. disabled: function (){
  822. if(id == "freightSheet") return me.rightClickTarget.row >= me.freightDatas.length;
  823. return me.rightClickTarget.row === undefined;
  824. },
  825. callback:function () {
  826. let row = me.rightClickTarget.row;
  827. me.saveFreight(row);
  828. }
  829. },
  830. "delete": {
  831. name: "删除",
  832. icon: 'fa-trash-o',
  833. disabled: function () {
  834. if(id == "priceSheet") return me.rightClickTarget.row >= me.priceDatas.length;
  835. if(id == "freightSheet") return me.rightClickTarget.row >= me.freightDatas.length;
  836. if(id == "freight_ration_sheet") return me.rightClickTarget.row >= me.freightRations.length;
  837. if(id == "price_ration_sheet") return me.rightClickTarget.row >= me.priceRations.length;
  838. return me.rightClickTarget.row === undefined;
  839. },
  840. callback: function (key, opt) {
  841. let row = me.rightClickTarget.row;
  842. if (id == "materialCalcSheet") me.deleteMaterialCal(row);
  843. if (id == "priceSheet") me.deletePriceCalc(row);
  844. if (id == "freightSheet") me.deleteFreightCalc(row);
  845. if (id == "freight_ration_sheet") me.deleteRation(row,"freight");
  846. if (id == "price_ration_sheet") me.deleteRation(row,"price");
  847. }
  848. }
  849. }
  850. });
  851. },
  852. initTabWidth:function () {
  853. if($("#mix_ratio_sheet").is(':visible')) return ;//如果是组成物计算界面,返回
  854. let mr_sideResizeEles = this.getSideResize();
  855. SlideResize.loadHorizonWidth(mr_sideResizeEles.eleObj.module,
  856. [mr_sideResizeEles.eleObj.resize], [mr_sideResizeEles.eleObj.left, mr_sideResizeEles.eleObj.right],null,2);
  857. $("#spreadTabDiv").width( $('#calcDiv').width() - mr_sideResizeEles.eleObj.resize.width() - 32)
  858. },
  859. refreshRationView:function () {
  860. let freight = this.getSelectedFreight();
  861. let hide = true;
  862. let stats = $("#freight_ration").is(':visible');
  863. if(freight && freight.conveyance == "自办运输"){
  864. this.showFreightRationDatas(freight);
  865. $("#freightSheet").css("height","50%");
  866. $("#freight_ration").show();
  867. hide = false;
  868. }
  869. if(hide){
  870. $("#freightSheet").css("height","100%");
  871. $("#freight_ration").hide();
  872. }
  873. if(stats != $("#freight_ration").is(':visible')){//状态改变了才刷新
  874. this.freightSpread.refresh();
  875. this.freightRationSpread.refresh();
  876. }
  877. },
  878. refreshAssView:function () {
  879. let me = materialCalcObj;
  880. let sheet = $('#freightSheet').is(':visible')?me.freightRationSheet:me.priceRationSheet;
  881. let preString = $('#freightSheet').is(':visible')?"freight":"price";
  882. let show = false;
  883. let ass = null;
  884. let ration = me.getSelectedRation();
  885. let stats = $(`#${preString}_ration_ass`).is(':visible');
  886. if(ration && ration.rationAssList){
  887. for(let r of ration.rationAssList){
  888. if(r.name.indexOf("运距")!= -1){//辅助定额只处理运距的情况,其它的都忽略 模糊匹配
  889. show = true;
  890. ass = r;
  891. }
  892. }
  893. }
  894. if(show){
  895. $(`#${preString}_ration_sheet`).addClass("material-ration-left");
  896. $(`#${preString}_ration_ass`).addClass("material-ass");
  897. $(`#${preString}_ass_value`).val(ass.actualValue);
  898. $(`#${preString}_ass_label`).text(ass.name);
  899. $(`#${preString}_ration_ass`).show();
  900. }else {
  901. $(`#${preString}_ration_sheet`).removeClass("material-ration-left");
  902. $(`#${preString}_ration_ass`).removeClass("material-ass");
  903. $(`#${preString}_ration_ass`).hide();
  904. }
  905. if(stats != $(`#${preString}_ration_ass`).is(':visible')) sheet.parent.refresh();//状态改变了才刷新
  906. },
  907. updateMaterialRationAss:function (value,ele) {//to do 同步修改定额工料机的消耗量
  908. let parent = this.getSelectedRationParent(),ration = this.getSelectedRation();
  909. let replaceList = [];
  910. if(value && !number_util.isNum(value)){
  911. alert("输入的数据类型不对,请重新输入!");
  912. let a = _.find(ration.rationAssList,function (item) {
  913. return item.name.indexOf("运距") != -1;
  914. });
  915. if(a)ele.val(a.actualValue);
  916. return;
  917. }
  918. for(let ass of ration.rationAssList){
  919. if(ass.name.indexOf("运距")!= -1){
  920. ass.actualValue = value?scMathUtil.roundForObj(value,2):ass.stdValue;
  921. }
  922. replaceList.push(value);
  923. }
  924. let name = ration.caption;
  925. for(let re of replaceList){
  926. name = name.replace('%s',re);
  927. }
  928. let type = $('#freightSheet').is(':visible')?"freight":"price";
  929. //let ration_glj =
  930. let datas = {parentID:parent.ID,rationID:ration.ID,type:type,actionType:"update",field:"name",value:name,ext:{rationAssList:ration.rationAssList}};
  931. let ration_gljs = projectObj.project.projectGLJ.calcMaterialAssQuantity(parent,ration,ration.rationAssList);
  932. if(ration_gljs.length > 0) datas.ration_gljs = ration_gljs;
  933. projectObj.project.projectGLJ.updateMaterialRation(datas);
  934. },
  935. getSelectedRation:function () {
  936. if($('#freightSheet').is(':visible')){
  937. return this.getSelectedRecode(this.freightRationSheet,this.freightRations);
  938. }else {
  939. return this.getSelectedRecode(this.priceRationSheet,this.priceRations);
  940. }
  941. },
  942. getSelectedRationParent:function () {
  943. if($('#freightSheet').is(':visible')){
  944. return this.getSelectedFreight();
  945. }else {
  946. return this.getSelectedRecode(this.priceSheet,this.priceDatas);
  947. }
  948. },
  949. getSelectedFreight:function(){
  950. return this.getSelectedRecode(this.freightSheet,this.freightDatas);
  951. },
  952. getSelectedPrice:function () {
  953. return this.getSelectedRecode(this.priceSheet,this.priceDatas)
  954. },
  955. getSelectedRecode:function (sheet,datas) {
  956. return sheetCommonObj.getSelectedRecode(sheet,datas);
  957. }
  958. };
  959. $(function () {
  960. $("#calc-nav").on('shown.bs.tab', function () {
  961. materialCalcObj.initTabWidth();
  962. projectGljObject.refreshSubViews();
  963. });
  964. $("#calTab ul li a").on('shown.bs.tab', function () {
  965. materialCalcObj.showFreightDatas();
  966. materialCalcObj.showPriceDatas();
  967. projectGljObject.refreshSubViews();
  968. });
  969. $(".ration_ass_value").change(function () {
  970. let me = materialCalcObj;
  971. me.updateMaterialRationAss($(this).val(),$(this));
  972. });
  973. $('#calcCoeDiv').on('show.bs.modal', function () {
  974. if(materialCalcObj.getAssistProductionLabel) $("#assistProductionLabel").text(materialCalcObj.getAssistProductionLabel);
  975. $("#assistProductionFeeRate").val(scMathUtil.roundForObj(projectObj.project.projectGLJ.datas.constData.assistProductionFeeRate,getDecimal("feeRate")));
  976. })
  977. $("#calcCoeConfirm").click(function () {
  978. let feeRate = $("#assistProductionFeeRate").val();
  979. if(!number_util.isNum(feeRate)){
  980. alert("输入的数据类型不对,请重新输入!");
  981. return $("#assistProductionFeeRate").val(scMathUtil.roundForObj(projectObj.project.projectGLJ.datas.constData.assistProductionFeeRate,getDecimal("feeRate")));
  982. }
  983. feeRate = scMathUtil.roundForObj(feeRate,getDecimal("feeRate"));
  984. $("#calcCoeDiv").modal("hide");
  985. projectObj.project.projectGLJ.changeAssistProductionFeeRate(feeRate);
  986. });
  987. $("#insertFreightconfirm").click(function () {
  988. let me = materialCalcObj;
  989. let material = me.getMaterialSelected();
  990. let newData = me.getNewFreightData(material);
  991. let start = $("#freight_start").val();
  992. let kmDistance = $("#freight_kmDistance").val();
  993. let materialType = $("#freight_materialType").val();
  994. if(!number_util.isNum(kmDistance)){
  995. alert("运输距离数据类型不对,请重新输入!");
  996. return ;
  997. }
  998. kmDistance = scMathUtil.roundForObj(kmDistance,getDecimal("glj.unitPrice"))+'';
  999. newData.start = start;
  1000. newData.kmDistance = kmDistance;
  1001. newData.materialType = materialType;
  1002. newData.calcType = "内蒙古";
  1003. newData.unitFreight = me.calcNeiMengUnitFreight(kmDistance,materialType);
  1004. $("#insertNeimengDiv").modal("hide");
  1005. projectObj.project.projectGLJ.addFreightCalc([newData],material.id);
  1006. })
  1007. });
  1008. let mr_sideResizeEles = materialCalcObj.getSideResize();
  1009. SlideResize.horizontalSlide(mr_sideResizeEles.eleObj, mr_sideResizeEles.limit, function(){
  1010. $("#spreadTabDiv").width( $('#calcDiv').width() - mr_sideResizeEles.eleObj.resize.width() - 32);
  1011. projectGljObject.refreshSubViews();
  1012. },2);