material_calc_view.js 53 KB

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