divide_view.js 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884
  1. let divideObj = {
  2. divideSetting:{//“类别”、“清单编号”、“名称”、“单位”、“工程量”、“单价”、“金额”、“预算价”、“取费类别”。
  3. header: [
  4. {headerName: "类别", headerWidth: 60, dataCode: "itemType", hAlign:'center', dataType: "String"},
  5. {headerName: "清单编号", headerWidth: 130, dataCode: "code", hAlign:'left', dataType: "String", formatter: "@"},
  6. {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String",formatter: "@"},
  7. {headerName: "单位", headerWidth: 100, dataCode: "unit", dataType: "String",cellType:'comboBox',editable:true,options:['m', 'm2', 'm3', 'km', 't', 'kg', '台班', '工日', '昼夜', '元', '项', '处', '个', '件',
  8. '根', '组', '系统', '台', '套', '株', '丛', '缸', '支', '只', '块', '座', '对', '份', '樘', '攒', '榀']},
  9. {headerName: "工程量", headerWidth: 80, dataCode: "quantity", dataType: "Number",validator:"number",getText:"notZero"},
  10. {headerName: "单价", headerWidth: 100, dataCode: "marketPrice", dataType: "Number",validator:"number",getText:"notZero"},
  11. {headerName: "金额", headerWidth: 100, dataCode: "marketTotalFee", dataType: "Number",validator:"number",getText:"notZero"},
  12. {headerName: "预算价", headerWidth: 100, dataCode: "marketUnitFee", dataType: "Number",validator:"number",getText:"notZero"},
  13. {headerName: "取费类别", headerWidth: 60, dataCode: "programID", hAlign:'center', dataType: "String",cellType:'comboBox',editorValueType:true}
  14. ],
  15. view:{
  16. lockColumns: [0],
  17. colHeaderHeight:30
  18. },
  19. getText:{
  20. notZero:function (item,value) {
  21. return value == 0?"":value;
  22. }
  23. },
  24. treeCol:1
  25. },
  26. billsSetting:{
  27. header: [//“编号”、“名称”、“分摊比例”、“分摊金额”、“原始金额”、“合计”、“金额”。
  28. {headerName: "编号", headerWidth: 130, dataCode: "code", hAlign:'left', dataType: "String"},
  29. {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"},
  30. {headerName: "分摊比例", headerWidth: 80, dataCode: "divideRate", dataType: "Number",validator:"number"},
  31. {headerName: "分摊金额", headerWidth: 100, dataCode: "dividePrice", dataType: "Number",validator:"number"},
  32. {headerName: "原始金额", headerWidth: 100, dataCode: "originalPrice", dataType: "Number",validator:"number"},
  33. {headerName: "合计", headerWidth: 100, dataCode: "totalPrice", dataType: "Number",validator:"number"},
  34. {headerName: "金额", headerWidth: 60, dataCode: "price", dataType: "Number",validator:"number"}
  35. ],
  36. view:{
  37. lockColumns: [0,1,2,3,4,5,6],
  38. colHeaderHeight:30
  39. }
  40. },
  41. divideSpread:null,
  42. billsSpread:null,
  43. divideSubSpread:null,
  44. showDivideGljSubTab:false,
  45. initSpread:function(){
  46. this.initDivideSpread();
  47. this.initBillsSpread();
  48. this.initDivideSubSpread();
  49. if(!projectReadOnly){
  50. this.initDivideRightClick();
  51. }else {
  52. disableSpread(this.divideSpread);
  53. disableSpread(this.billsSpread);
  54. }
  55. },
  56. showDatas:function(){
  57. this.showDivideDatas();
  58. this.showBillsDatas();
  59. this.showRationGLJDatas();
  60. },
  61. refreshViews:function(){
  62. if(!$('#divide_main').is(':visible')) return;
  63. if(this.divideSpread) this.divideSpread.refresh();
  64. if(this.billsSpread) this.billsSpread.refresh();
  65. if(this.divideSubSpread) this.divideSubSpread.refresh();
  66. },
  67. showDivideDatas:function(){
  68. if(!$('#divide_main_sheet').is(':visible')) return;
  69. this.divideDatas = getDivideDatas();
  70. this.divideSheet.setRowCount(this.divideDatas.length);
  71. let fheader= _.find(this.divideSetting.header,{'dataCode': "programID"})
  72. fheader.options = this.getProgramOptions();
  73. sheetCommonObj.showTreeData(this.divideSheet, this.divideSetting,this.divideDatas);
  74. function getDivideDatas(){
  75. let datas = [];
  76. let divideSetting = projectObj.project.divide_setting.datas
  77. let parentMap={};
  78. //divideSetting.divideList = [{ID:"1",code:"1",ParentID:-1,collapsed:false},{ID:"2",code:"2",ParentID:"1",collapsed:false}]
  79. divideSetting.divideList = _.sortByAll(divideSetting.divideList,['seq'])
  80. for(let d of divideSetting.divideList){
  81. parentMap[d.ParentID]?parentMap[d.ParentID].push(d):parentMap[d.ParentID]=[d]
  82. }
  83. if(parentMap[-1]&&parentMap[-1].length>0){
  84. for(let r of parentMap[-1]){
  85. r.collapsed = false;
  86. datas.push(r)
  87. if(parentMap[r.ID] && parentMap[r.ID].length > 0){
  88. for(let c of parentMap[r.ID]){
  89. if(c.fees){
  90. let comnonFee = _.find(c.fees,{"fieldName":"common"})
  91. c.marketPrice = comnonFee.unitFee;
  92. }
  93. datas.push(c);
  94. }
  95. }
  96. }
  97. }
  98. return datas;
  99. }
  100. },
  101. showRationGLJDatas:function(){
  102. if(!$('#divide_glj_nav').hasClass('active')) return;
  103. this.divideSubSpread.setActiveSheetIndex(0);
  104. this.rationGLJDatas = getTreeRationGLJDatas();
  105. let rationGLJSheet = this.divideSubSpread.getSheet(0)
  106. rationGLJSheet.setRowCount(this.rationGLJDatas.length);
  107. sheetCommonObj.showTreeData(rationGLJSheet, gljCol.ration_glj_setting,this.rationGLJDatas);
  108. function getTreeRationGLJDatas(){
  109. let datas = [];
  110. let temDatas=[];//临时存放主工料机
  111. let selected = divideObj.getSelectedItem();
  112. let divideSetting = projectObj.project.divide_setting.datas;
  113. let projectGLJ = projectObj.project.projectGLJ
  114. let projectGLJData = projectGLJ.datas;
  115. let projectGljs = projectGLJData.gljList;
  116. let mixRatioMap = projectGLJData.mixRatioMap;
  117. if(selected && selected.itemType=="定额"){
  118. for(r of divideSetting.ration_gljs){
  119. if(r.rationID == selected.ID){
  120. let newr = Object.assign(r);
  121. newr.ParentID = -1;
  122. temDatas.push(newr);
  123. }
  124. }
  125. if(temDatas.length > 0){
  126. temDatas = gljUtil.sortRationGLJ(temDatas);
  127. let pgljMap = _.indexBy(projectGljs, 'id');
  128. for(let d of temDatas){
  129. let glj = pgljMap[d.projectGLJID];
  130. if(!glj) continue;
  131. if(projectGLJ.isEstimateType(d.type )) d.isEstimate = glj.is_evaluate;
  132. d.shortName=projectGLJ.getShortNameByID(d.type);
  133. d.isAdd = glj.unit_price.is_add;
  134. d=gljOprObj.setGLJPrice(d,glj,false);//设置工料机价格
  135. //计算工料机的总消耗量
  136. d.totalQuantity = gljUtil.getTotalQuantity(d,selected,getDecimal("ration.quantity"),getDecimal("glj.quantity"));
  137. datas.push(d);
  138. let connect_index = gljOprObj.getIndex(glj, gljKeyArray);
  139. if(mixRatioMap[connect_index]){//有组成物
  140. let mList = gljUtil.sortMixRatio(mixRatioMap[connect_index]);
  141. for(let m of mList){
  142. let mIndex = gljOprObj.getIndex(m,gljKeyArray);
  143. var mpg = _.find(projectGljs, function (item) {
  144. return gljOprObj.getIndex(item,gljKeyArray) == mIndex
  145. });
  146. if(!mpg) continue;
  147. let tem = {
  148. ParentID:d.ID,
  149. projectGLJID: mpg.id,
  150. code: mpg.code,
  151. name: mpg.name,
  152. specs: mpg.specs,
  153. unit: mpg.unit,
  154. type:m.type,
  155. shortName: projectGLJ.getShortNameByID(m.type),
  156. consumption:m.consumption,
  157. rationItemQuantity: scMathUtil.roundForObj(m.consumption, getDecimal("glj.quantity")),
  158. isMixRatio: true,
  159. isAdd: mpg.unit_price.is_add,
  160. GLJID: mpg.glj_id
  161. };
  162. if(projectGLJ.isEstimateType(mpg.type)){
  163. tem.isEstimate = mpg.is_evaluate;
  164. }
  165. tem.totalQuantity = scMathUtil.roundToString(tem.rationItemQuantity * parseFloat(d.totalQuantity), getDecimal("glj.quantity"));
  166. gljOprObj.setGLJPrice(tem,mpg);
  167. datas.push(tem);
  168. }
  169. }
  170. }
  171. }
  172. }
  173. return datas;
  174. }
  175. },
  176. getRationGLJDatas : function (ration){//这里是给计算程序统一调用的方法,树结构不用这个方法了
  177. let datas = [];
  178. let selected = ration;
  179. let divideSetting = projectObj.project.divide_setting.datas;
  180. if(selected && selected.itemType=="定额"){
  181. for(r of divideSetting.ration_gljs){
  182. if(r.rationID == selected.ID){
  183. let newr = Object.assign(r);
  184. newr.ParentID = -1;
  185. datas.push(newr);
  186. }
  187. }
  188. gljOprObj.combineWithProjectGlj(datas,false,selected);
  189. }
  190. return datas;
  191. },
  192. getCoeList:function(){
  193. let selected = this.getSelectedItem();
  194. let divideSetting = projectObj.project.divide_setting.datas;
  195. let coeList = [];
  196. if(selected.itemType == "定额"){
  197. let assList = selected&&selected.rationAssList ? selected.rationAssList : [];
  198. zmhs_obj.divide_assSheetData = assList;
  199. for(let c of divideSetting.ration_coes){
  200. if(c.rationID == selected.ID) coeList.push(c);
  201. _.remove(coeList,{"coeID":-1});
  202. }
  203. coeList = assList.concat(coeList)
  204. }
  205. return coeList;
  206. },
  207. getCusList:function(){
  208. let selected = this.getSelectedItem();
  209. let divideSetting = projectObj.project.divide_setting.datas;
  210. let cusList = [];
  211. if(selected.itemType == "定额"){
  212. for(let c of divideSetting.ration_coes){
  213. if(c.rationID == selected.ID && c.coeID == -1){
  214. zmhs_obj.divide_cusSheetData = c;
  215. cusList = c.coes;
  216. break;
  217. }
  218. }
  219. }
  220. return cusList;
  221. },
  222. getStableList:function(){
  223. return this.rationGLJDatas.filter(glj => !glj.isMixRatio && glj.rationProportion);
  224. },
  225. getProgramOptions:function(){
  226. let names = projectObj.project.calcProgram.compiledTemplateNames;
  227. let map = projectObj.project.calcProgram.compiledTemplateMaps;
  228. let options = [];
  229. for(let n of names){
  230. options.push({text:n,value:map[n]});
  231. }
  232. return options;
  233. },
  234. divideEditChecking:function(row,col){//return false表示不能编辑
  235. let me = this;
  236. let data = me.divideDatas[row],setting = me.divideSetting;
  237. let dataCode = setting.header[col].dataCode;
  238. if(data){
  239. if(data.itemType == "分摊项"){
  240. //金额,预算价,取费类别不可编辑
  241. if(dataCode =="marketTotalFee" || dataCode =="marketPrice" || dataCode =="programID" ) return false;
  242. //有子项时,单价不可编辑
  243. if(dataCode =="marketUnitFee"&& _.find(me.divideDatas,{ParentID:data.ID})) return false;
  244. }
  245. if( data.itemType == "量价" && dataCode =="marketTotalFee") return false//量价:“金额”不可编辑。
  246. if(data.itemType == "定额"){ //定额:“单位”、“单价”、“金额”、“预算价”
  247. return !(dataCode == "unit"||dataCode == "marketUnitFee"||dataCode == "marketTotalFee"||dataCode == "marketPrice")
  248. }
  249. return true
  250. }
  251. return false;
  252. },
  253. showBillsDatas:function(){
  254. if(!$('#divide_bills_sheet').is(':visible')) return;
  255. this.billsDatas = getBillsDatas();
  256. sheetCommonObj.showData(this.billsSheet, this.billsSetting,this.billsDatas);
  257. this.billsSheet.setRowCount(this.billsDatas.length);
  258. function getBillsDatas(){
  259. return [];
  260. }
  261. },
  262. getSelectedItem:function(){
  263. let me = this,data=null;
  264. let sel = me.divideSheet.getSelections()[0];
  265. let srow = sel.row == -1||sel.row == ""?0:sel.row;
  266. if(me.divideDatas.length>srow){
  267. data = me.divideDatas[srow];
  268. }
  269. return data;
  270. },
  271. addNewItems:async function(itemType,type){
  272. let newItem = {
  273. ID:uuid.v1(),
  274. itemType:itemType,
  275. ParentID:-1
  276. };
  277. if(type) newItem.subType = type;
  278. let selected = this.getSelectedItem();
  279. if(itemType!="分摊项"){//当插入定额或者量价时:
  280. newItem.ParentID = selected.itemType == "分摊项"?selected.ID:selected.ParentID;
  281. }
  282. if(itemType == "定额") newItem.type = rationType.ration;
  283. if(itemType == "量价"){
  284. newItem['programID'] = projectObj.project.calcProgram.compiledTemplateMaps["费率为0"];
  285. newItem.type = rationType.volumePrice;
  286. }
  287. let [seq,datas] = this.getNewSeqs(selected,newItem);
  288. newItem.seq = seq;
  289. datas.push({type:"add",doc:newItem});
  290. await this.updateItem(datas);
  291. },
  292. calcBills:function(bills){
  293. let divideSetting = projectObj.project.divide_setting.datas;
  294. let subNodes = [];
  295. let item=null;
  296. for(let c of divideSetting.divideList){
  297. if(c.ParentID == bills.ID){
  298. subNodes.push({data:c, sourceType:"ration", calcType: 1, updateData:[]});
  299. }
  300. if(c.ID == bills.ID) item = c;
  301. }
  302. projectObj.project.calcProgram.innerCalcBill({data:item, sourceType:"bills", calcType: 3, updateData:[],children:subNodes},3);
  303. console.log(selected)
  304. },
  305. deleteItem:async function(){
  306. let selected = this.getSelectedItem();
  307. let subItems = [];
  308. if(selected.itemType == "分摊项"){
  309. //检查是否执行了分摊,如果已经执行了,要取消分摊才能删除
  310. // todo
  311. for(let s of this.divideDatas){
  312. if(s.ParentID == selected.ID) subItems.push({type:"delete",ID:s.ID});
  313. }
  314. }
  315. subItems.push({type:"delete",ID:selected.ID,itemType:selected.itemType});
  316. await this.updateItem(subItems);
  317. },
  318. getNewSeqs:function(selected,newItem){
  319. let seq = 1,datas=[],refreshSeq = false;
  320. for(let d of this.divideDatas){
  321. if(d.ParentID == newItem.ParentID){
  322. if(refreshSeq == true){
  323. if(d.seq == seq || d.seq > seq) datas.push({ID:d.ID,type:'update',doc:{seq:d.seq+1}})
  324. }
  325. if(selected && d.ID == selected.ID){
  326. seq = d.seq + 1;
  327. refreshSeq = true;
  328. }
  329. }
  330. }
  331. return [seq,datas]
  332. },
  333. updateItem: async function(datas){
  334. let divideSetting = projectObj.project.divide_setting.datas
  335. try {
  336. $.bootstrapLoading.start();
  337. let result = ajaxPost("/divide/updateItem",{ID:divideSetting.ID,updateDatas:datas})
  338. this.refreshDivideCaches(datas);
  339. } catch (error) {
  340. console.log(error)
  341. }
  342. $.bootstrapLoading.end();
  343. this.showDatas();
  344. },
  345. refreshDivideCaches:function(datas){
  346. let divideSetting = projectObj.project.divide_setting.datas
  347. for(let d of datas){
  348. if(d.type == "add"){
  349. divideSetting.divideList.push(d.doc);
  350. }
  351. if(d.type == "delete"){
  352. _.remove(divideSetting.divideList,{'ID':d.ID});
  353. if(d.itemType =="定额"){
  354. _.remove(divideSetting.ration_gljs,{'rationID':d.ID});
  355. _.remove(divideSetting.ration_coes,{'rationID':d.ID});
  356. }
  357. }
  358. if(d.type == "update"){
  359. let item = _.find(divideSetting.divideList,{'ID':d.ID});
  360. if(item) gljUtil.updateProperty(item,d.doc);
  361. }
  362. }
  363. },
  364. addDivideRation:async function(rationRepId,code){
  365. let selected = this.getSelectedItem();
  366. if(!selected) return;
  367. let divideSetting = projectObj.project.divide_setting.datas
  368. let pEngineer = projectObj.project.projectInfo.property.projectEngineering;
  369. let libIDs = [rationRepId];
  370. let defaultLibID = rationLibObj.getDefaultStdRationLibID();
  371. let data = {userID:userID,defaultLibID:defaultLibID, rationRepIds: libIDs, code: code,quantityDecimal:getDecimal("ration.quantity"),projectID:projectObj.project.ID()};
  372. data.ParentID = selected.itemType == "分摊项"?selected.ID:selected.ParentID;
  373. let [seq,datas] = this.getNewSeqs(selected,data);
  374. data.type="add";
  375. data.seq = seq;
  376. data.divideID = divideSetting.ID;
  377. if(pEngineer) data.programID = pEngineer;
  378. data.divideDatas = datas;
  379. let sel = this.divideSheet.getSelections()[0];
  380. this.divideSheet.setSelection(sel.row+1,sel.col,sel.rowCount,sel.colCount);
  381. await this.updateDivideRation(data);
  382. },
  383. updateDivideRation:async function(data){
  384. let divideSetting = projectObj.project.divide_setting.datas
  385. try {
  386. $.bootstrapLoading.start();
  387. let result = await ajaxPost("/ration/updateDivideRation",data)
  388. if(data.type=="add"){
  389. data.divideDatas.push({type:"add",doc:result.ration});
  390. this.refreshDivideCaches(data.divideDatas);
  391. if(result.projectGLJList) projectObj.project.projectGLJ.loadNewProjectGLJToCaches(result.projectGLJList,true);
  392. if(result.ration_gljs) divideSetting.ration_gljs = divideSetting.ration_gljs.concat(result.ration_gljs);
  393. if(result.ration_coes) divideSetting.ration_coes = divideSetting.ration_coes.concat(result.ration_coes);
  394. }
  395. await this.calcDivideItem(data);
  396. } catch (error) {
  397. console.log(error)
  398. }
  399. $.bootstrapLoading.end();
  400. //this.showDatas();
  401. },
  402. calcDivideItem:async function(divide){
  403. let updateDatas = [];
  404. let divideSetting = projectObj.project.divide_setting.datas
  405. if(divide.itemType != "分摊项"){//不是分摊项,调用计算程序
  406. let parentSum = 0;
  407. let parent = null;
  408. projectObj.project.calcProgram.innerCalcRation({data:divide, sourceType:"ration", calcType: 1, updateData:[]});
  409. if(divide.itemType == "定额"){
  410. let comnonFee = _.find(divide.fees,{"fieldName":"common"})
  411. if(comnonFee)updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees,marketUnitFee:comnonFee.unitFee,marketTotalFee:comnonFee.totalFee}});
  412. }else{
  413. updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees,marketUnitFee:divide.marketUnitFee,marketTotalFee:divide.marketTotalFee}});
  414. }
  415. parentSum = this.getTotolFee(divide);
  416. for(let c of divideSetting.divideList){
  417. if(c.ID == divide.ParentID) parent = c;
  418. if(c.ParentID == divide.ParentID && c.ID != divide.ID){
  419. parentSum = scMathUtil.roundForObj(parentSum+this.getTotolFee(c),getDecimal("process"))
  420. }
  421. }
  422. parentSum = scMathUtil.roundForObj(parentSum,getDecimal("bills.totalPrice"));
  423. if(parent && parent.marketTotalFee != parentSum) updateDatas.push({ID:parent.ID,type:'update',doc:{marketTotalFee:parentSum}});;
  424. }
  425. updateDatas.length > 0?await this.updateItem(updateDatas):this.showDatas();
  426. },
  427. getTotolFee:function name(divide) {
  428. if(divide.itemType == "定额"){
  429. let comnonFee = _.find(divide.fees,{"fieldName":"common"})
  430. return comnonFee && comnonFee.totalFee ? comnonFee.totalFee:0;
  431. }else if(divide.itemType == "量价"){
  432. return divide.marketTotalFee;
  433. }
  434. },
  435. updateCustomerCoe:function(result){
  436. console.log(result);
  437. },
  438. initDivideSpread:function(){
  439. if(this.divideSpread) return;
  440. this.divideSpread = SheetDataHelper.createNewSpread($("#divide_main_sheet")[0]);
  441. sheetCommonObj.spreadDefaultStyle(this.divideSpread);
  442. this.divideSheet = this.divideSpread.getSheet(0);
  443. sheetCommonObj.initSheet(this.divideSheet, this.divideSetting, 2);
  444. this.divideSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onDivideEditStarting);
  445. this.divideSheet.bind(GC.Spread.Sheets.Events.ValueChanged,this.onDivideValueChange)
  446. this.divideSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onDivideSelectionChange);
  447. /* ;
  448. this.divideSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onCoeRangeChanged); */
  449. SheetDataHelper.protectdSheet(this.divideSheet);
  450. },
  451. onDivideEditStarting:function (sender, args) {
  452. let me = divideObj;
  453. let row = args.row;
  454. let col = args.col;
  455. if(me.divideEditChecking(row,col)==false){
  456. args.cancel = true;
  457. }
  458. },
  459. onDivideValueChange:async function(sender,info){
  460. let me = divideObj,row = info.row, col = info.col;
  461. let setting = me.divideSetting;
  462. let dataCode = setting.header[col].dataCode;
  463. let recode = me.divideDatas[row];
  464. let value = info.newValue;
  465. if(info.newValue === undefined ){
  466. return;
  467. }
  468. if(value && !sheetCommonObj.checkData(col,setting,value)) {
  469. alert('输入的数据类型不对,请重新输入!');
  470. return me.showDatas();
  471. }
  472. await me.updateItem([me.getDivideUpdateData(recode,dataCode,value)]);
  473. await me.calcDivideItem(recode);
  474. },
  475. onDivideSelectionChange:function(sender,args){
  476. let me = divideObj;
  477. let newSel = args.newSelections[0];
  478. let oldSel = args.oldSelections?args.oldSelections[0]:{};
  479. if(newSel.row != oldSel.row){
  480. me.initNavItem();
  481. me.showRationGLJDatas();
  482. }
  483. args.sheet.repaint();
  484. },
  485. getDivideUpdateData:function(recode,dataCode,value){
  486. let doc = {};
  487. if(recode.itemType == "分摊项"){
  488. if(dataCode == "quantity"){
  489. value = scMathUtil.roundForObj(value,3);
  490. let tu = scMathUtil.roundForObj(recode.marketUnitFee&&recode.marketUnitFee!=""?recode.marketUnitFee:0,getDecimal("bills.unitPrice"))
  491. doc["marketTotalFee"] = scMathUtil.roundForObj(value * tu,getDecimal("bills.totalPrice"))
  492. }
  493. if(dataCode == "marketUnitFee"){
  494. value = scMathUtil.roundForObj(value,getDecimal("bills.unitPrice"));
  495. let tq = scMathUtil.roundForObj(recode.quantity && recode.quantity!=""?recode.quantity:0,3)
  496. doc["marketTotalFee"] = scMathUtil.roundForObj(value * tq,getDecimal("bills.totalPrice"))
  497. }
  498. }
  499. if(recode.itemType =="定额"&& dataCode == 'quantity'){
  500. if(value){
  501. value = scMathUtil.roundForObj(parseFloat(value) / FilterNumberFromUnit(recode.unit),getDecimal("ration.quantity"));
  502. }else {
  503. value = 0;
  504. }
  505. }
  506. if(recode.itemType =="量价" && dataCode=="marketPrice") dataCode=="marketUnitFee"
  507. doc[dataCode]=value;
  508. return {ID:recode.ID,type:'update',doc:doc}
  509. },
  510. initBillsSpread:function(){
  511. if(this.billsSpread) return;
  512. this.billsSpread = SheetDataHelper.createNewSpread($("#divide_bills_sheet")[0]);
  513. sheetCommonObj.spreadDefaultStyle(this.billsSpread);
  514. this.billsSheet = this.billsSpread.getSheet(0);
  515. sheetCommonObj.initSheet(this.billsSheet, this.billsSetting, 0);
  516. SheetDataHelper.protectdSheet(this.divideSheet);
  517. },
  518. initDivideSubSpread:function(){
  519. if(this.divideSubSpread) return;
  520. this.divideSubSpread = SheetDataHelper.createNewSpread($("#divide_subSpread")[0],2);
  521. sheetCommonObj.spreadDefaultStyle(this.divideSubSpread);
  522. this.divideSubSheet = this.divideSubSpread.getSheet(0);
  523. sheetCommonObj.initSheet(this.divideSubSheet, gljCol.ration_glj_setting, 0);
  524. SheetDataHelper.protectdSheet(this.divideSubSheet);
  525. },
  526. initNavItem(){
  527. let selected = this.getSelectedItem();
  528. if(selected.itemType == "分摊项"){
  529. $("#divide_itemTextDiv").hide();
  530. $(`#divide_subSpread`).css('width', "100%");
  531. }else{
  532. $("#divide_itemTextDiv").show();
  533. if(this.showDivideGljSubTab == true){
  534. $("#divide_gljSubDiv").show();
  535. $("#divide_rgResize").show();
  536. } else {
  537. $("#divide_gljSubDiv").hide();
  538. $("#divide_rgResize").hide();
  539. }
  540. this.initItemWidth();
  541. }
  542. this.divideSubSpread.refresh();
  543. },
  544. initItemWidth:function (){
  545. //总宽度
  546. let totalWidth = $('#divide_subItems').width();
  547. //人材机和项目特征文本比例
  548. const openWidth = 30;//打开项目特征工具条
  549. const tab_tem = (305+openWidth+10)/totalWidth;//tab显示框默认宽度:305(表格宽度) + 30(工具条宽度)+10(resize div 宽度)
  550. let //默认比例
  551. textPercent = tab_tem * 100 + '%',//'15%',
  552. rcjPercent = (1 - tab_tem)* 100 + '%';//85
  553. //文本没显示,则打开工具条固定30px转换百分比
  554. if (!this.showDivideGljSubTab) {
  555. textPercent = openWidth / totalWidth;
  556. rcjPercent = 1 - textPercent;
  557. textPercent = textPercent * 100 + '%';
  558. rcjPercent = rcjPercent * 100 + '%';
  559. }
  560. //设置特征及内容与排版规则的比例
  561. $('#divide_subSpread').css('width', rcjPercent);
  562. $('#divide_itemTextDiv').css('width', textPercent);
  563. //打开了项目特征,则继续加载人材机表和项目特征文本具体比例
  564. if (divideObj.showDivideGljSubTab === true) {
  565. let rg_sideResizeEles = this.getSubSideResize();
  566. SlideResize.loadHorizonWidth(rg_sideResizeEles.eleObj.module,
  567. [rg_sideResizeEles.eleObj.resize], [rg_sideResizeEles.eleObj.left, rg_sideResizeEles.eleObj.right]);
  568. $("#divide_gljSubDiv").width( $('#divide_itemTextDiv').width() - rg_sideResizeEles.eleObj.resize.width() - 30)
  569. }
  570. },
  571. initDivideGljSubTab:function(){
  572. if(this.showDivideGljSubTab == true){
  573. $("#divide_gljSubDiv").show();
  574. $("#divide_rgResize").show();
  575. } else {
  576. $("#divide_gljSubDiv").hide();
  577. $("#divide_rgResize").hide();
  578. }
  579. this.initItemWidth();
  580. },
  581. getSubSideResize: function () {
  582. let rg_sideResizeEles = {};
  583. rg_sideResizeEles.eleObj = {
  584. module: this.moduleName,
  585. resize: $('#divide_rgResize'),
  586. parent: $('#divide_subItems'),
  587. left: $('#divide_subSpread'),
  588. right: $('#divide_itemTextDiv')
  589. };
  590. rg_sideResizeEles.limit = {
  591. min: 100,
  592. max: `$('#divide_subItems').width()-100`
  593. };
  594. return rg_sideResizeEles;
  595. },
  596. initDivideRightClick:function(){
  597. //如果当前行是无组成物的“普通材料”、“绿化苗木”、“外购砼构件”、“商品混凝土”、“商品砂浆”,则右键“添加计算材料”按钮有效。
  598. let me = this;
  599. $.contextMenu({
  600. selector: '#divide_main_sheet',
  601. build: function ($trigger, e) {
  602. me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.divideSpread);
  603. return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport ||
  604. me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  605. },
  606. items: {
  607. "insertItem": {
  608. name: "插入分摊项",
  609. icon: 'fa-sign-in',
  610. disabled: function () {
  611. let selected = me.getSelectedItem();
  612. if(selected && selected.itemType !="分摊项") return true;
  613. return false;
  614. },
  615. callback: function (key, opt) {
  616. me.addNewItems("分摊项");
  617. }
  618. },
  619. "insertRation": {
  620. name: "插入定额",
  621. icon: 'fa-sign-in',
  622. disabled: function () {
  623. return me.rightClickTarget.row === undefined
  624. },
  625. callback: function (key, opt) {
  626. me.addNewItems("定额");
  627. }
  628. },
  629. "insertVolumePrice": {
  630. name: "插入量价",
  631. icon: 'fa-sign-in',
  632. disabled: function () {
  633. return me.rightClickTarget.row === undefined;
  634. },
  635. items:{
  636. insertLabour:{
  637. name: "人工",
  638. icon: 'fa-sign-in',
  639. callback:function(key){
  640. me.addNewItems("量价",1);
  641. }
  642. },
  643. insertMaterial:{
  644. name:"材料" ,
  645. icon: 'fa-sign-in',
  646. callback:function(key){
  647. me.addNewItems("量价",201);
  648. }
  649. },
  650. insertMachine:{
  651. name:"机械" ,
  652. icon: 'fa-sign-in',
  653. callback:function(key){
  654. me.addNewItems("量价",301);
  655. }
  656. }
  657. }
  658. },
  659. "calcRation": {
  660. name: "计算定额/量价",
  661. icon: 'fa-sign-in',
  662. disabled: function () {
  663. return me.rightClickTarget.row === undefined
  664. },
  665. callback: function (key, opt) {
  666. let selected = me.getSelectedItem();
  667. projectObj.project.calcProgram.innerCalcRation({data:selected, sourceType:"ration", calcType: 1, updateData:[]});
  668. console.log(selected)
  669. }
  670. },
  671. "calcBills": {
  672. name: "计算分摊项",
  673. icon: 'fa-sign-in',
  674. disabled: function () {
  675. return me.rightClickTarget.row === undefined
  676. },
  677. callback: function (key, opt) {
  678. let selected = me.getSelectedItem();
  679. me.calcBills(selected);
  680. }
  681. },
  682. "removeItem": {
  683. name: "删除",
  684. icon: 'fa-trash-o',
  685. disabled: function () {
  686. return me.rightClickTarget.row === undefined;;
  687. },
  688. callback: function (key, opt) {
  689. me.deleteItem();
  690. }
  691. }
  692. }
  693. });
  694. },
  695. getDivideResizeEles:function () {
  696. let divideResizeEles = {};
  697. divideResizeEles.eleObj = {
  698. module: 'divide',
  699. resize: $('#divide_rgResize'),
  700. top: $('#divide_top'),
  701. topSpread: $('#divide_main_sheet'),
  702. bottom: $('#divideBottom').children().find('.main-data-bottom'),
  703. bottomSpread: [$('#divide_subSpread')]
  704. };
  705. divideResizeEles.limit = {
  706. min: 150,
  707. max: `$(window).height()-$('.header').height()-$('#divideToolsBar').height()-150-5`,//5: resize.height()
  708. notTopSpread: 0,
  709. notBottomSpread: 0,
  710. bottomNav:`$('#divideBottom ul').height()`,
  711. totalHeight: `$(window).height()-$('.header').height()-$('#divideToolsBar').height()-5`
  712. };
  713. return divideResizeEles;
  714. }
  715. }
  716. function loadDivideHeight(){
  717. if(!$('#divide_main').is(':visible')) return;
  718. let me = divideObj;
  719. let divideResizeEles = me.getDivideResizeEles();
  720. SlideResize.loadVerticalHeight(divideResizeEles.eleObj.module, divideResizeEles.eleObj, divideResizeEles.limit, function () {
  721. me.refreshViews();
  722. zmhs_obj.refresh();
  723. });
  724. if($('#divide_de').is(':visible')) showDivideSide($($("#divide_stdRationTab").attr('relaPanel')), true, $("#divide_stdRationTab").attr('id'));
  725. }
  726. $('#tab_divide').on('shown.bs.tab', function (e) {
  727. sessionStorage.setItem('mainTab', '#tab_divide');
  728. loadDivideHeight();
  729. divideObj.initSpread();
  730. divideObj.showDatas();
  731. divideObj.initNavItem();
  732. })
  733. $('.divide-nav-link').bind('click', function () {//$('.side-tabs ul li a').bind 2018-11-23 使用更多标签,所以不能这样绑定事件了
  734. var tab = $(this), tabPanel = $(tab.attr('relaPanel'));
  735. if(tab.hasClass('disabled')){
  736. return;
  737. }
  738. let setActiveTab = tab;
  739. if (!(setActiveTab.hasClass('active')&&tabPanel.is(":visible"))) {
  740. $('.divide_side-tabs ul li a').removeClass('active');
  741. setActiveTab.addClass('active');
  742. showDivideSide(tabPanel, true, tab.attr('id'));
  743. } else {
  744. setActiveTab.removeClass('active');
  745. showDivideSide(tabPanel, false, tab.attr('id'));
  746. }
  747. divideObj.refreshViews();
  748. });
  749. //定额库上下拖动
  750. let dividRationLibResizeEles = {};
  751. dividRationLibResizeEles.eleObj = {
  752. module: 'divide_de',
  753. resize: $('#divide_deResize'),
  754. top: $('#divide_deTopDiv'),
  755. topSpread: $('#divide_stdRationChapter'),
  756. bottom: $('#divide_deBottomDiv'),
  757. bottomSpread: $('#divide_stdSectionRations')
  758. };
  759. dividRationLibResizeEles.limit = {
  760. min: 150,
  761. max: `$(window).height()-$('.header').height()-$('.toolsbar').height()-$('#deToolsBar').height()-150-5`,//5: resize.height()
  762. notTopSpread: 0,
  763. notBottomSpread: 0,
  764. totalHeight: `$(window).height()-$('.header').height()-$('.toolsbar').height()-$('#divide_deToolsBar').height()-5`
  765. };
  766. function showDivideSide(tabPanel, show, id){
  767. let divideSideResizeEles = {};
  768. divideSideResizeEles.eleObj = {
  769. module: 'divideRationLibTab',
  770. resize: $('#divideSideResize'),
  771. parent: $('#divideRow'),
  772. left: $('#divide_main'),
  773. right: $('#divide_side')
  774. };
  775. divideSideResizeEles.limit = {
  776. min: 150,
  777. max: `$('#divideRow').width()-150`
  778. };
  779. divideSideResizeEles.eleObj.module = id;
  780. if (show) {
  781. //刚打开各库时的默认比例
  782. divideSideResizeEles.eleObj.left.css('width', '66.666667%');
  783. divideSideResizeEles.eleObj.right.css('width', '33.333333%');
  784. SlideResize.setResizeWidth(divideSideResizeEles.eleObj.resize);
  785. $('.divide_side .tab-pane').hide();
  786. tabPanel.show();//locateTab要等div显示后才执行刷新操作
  787. //加载打开的库与主界面的宽度比
  788. SlideResize.loadHorizonWidth(id, [divideSideResizeEles.eleObj.resize], [divideSideResizeEles.eleObj.left, divideSideResizeEles.eleObj.right], function(){
  789. if (id === 'divide_stdRationTab') {//加载定额库内部上下高度
  790. SlideResize.loadVerticalHeight(dividRationLibResizeEles.eleObj.module, dividRationLibResizeEles.eleObj, dividRationLibResizeEles.limit, function () {
  791. if(rationLibObj.divide_rationChapterSpread) rationLibObj.divide_rationChapterSpread.refresh();
  792. if(rationLibObj.divide_sectionRationsSpread) rationLibObj.divide_sectionRationsSpread.refresh();
  793. });
  794. }
  795. });
  796. } else {
  797. divideSideResizeEles.eleObj.left.css('width', '100%');
  798. divideSideResizeEles.eleObj.right.css('width', '0%');
  799. tabPanel.hide();
  800. }
  801. }
  802. $('#divide_stdRationTab').bind('click', function () {
  803. var select = $('#divide_stdRationLibSelect');
  804. rationLibObj.checkSpread('divide');
  805. if (select[0].options.length === 0) {
  806. rationLibObj.loadStdRationLibs('divide');
  807. //rationLibObj.loadStdRationContextMenu();
  808. };
  809. divideObj.initNavItem();
  810. });
  811. $('#divide_stdRationLibSelect').change(function () {
  812. var select = $(this);
  813. if (this.children.length !== 0) {
  814. let rationLibId = select.val();
  815. sessionStorage.setItem('divide_stdRationLib', rationLibId);
  816. sessionStorage.removeItem('divide_stdRationLibExpState');
  817. rationLibObj.loadStdRation(rationLibId,'divide');
  818. }
  819. });
  820. $('.divide_gljSubTab ul li a').bind('click',function () {
  821. if(this.hash =="#divide_rnc-close"){
  822. $("#divide_zmhs_nav").hide();
  823. $("#divide_zmhs_toogle").show();
  824. closeTab(this);
  825. divideObj.showDivideGljSubTab = false;
  826. }else{
  827. divideObj.showDivideGljSubTab = true;
  828. }
  829. divideObj.initDivideGljSubTab();
  830. if(divideObj.divideSubSpread) divideObj.divideSubSpread.refresh();
  831. });
  832. $('.divide_gljSubTab ul li a').on('shown.bs.tab', function () {
  833. if(this.hash == "#divide_rnc-zm"){
  834. zmhs_obj.initCoeSpread();
  835. }else if(this.hash == "#divide_rnc-fz"){
  836. zmhs_obj.initAssSpread();
  837. }else if(this.hash == "#divide_rnc-cus"){
  838. zmhs_obj.initCusSpread();
  839. }else if(this.hash == "#divide_rnc-stable"){
  840. zmhs_obj.initStableSpread();
  841. }
  842. zmhs_obj.refresh();
  843. zmhs_obj.showDatas();
  844. });
  845. $('#divide_zmhs_toogle').bind('click',function (){
  846. $("#divide_zmhs_nav").show();
  847. if(divideObj.showDivideGljSubTab == false){
  848. $("#divide_hs-nav").click();
  849. }
  850. $("#divide_zmhs_toogle").hide();
  851. });