divide_view.js 35 KB

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