divide_view.js 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892
  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. this.initFeeIndexs(c);
  300. subNodes.push({data:c, sourceType:"ration", calcType: 1, updateData:[]});
  301. }
  302. if(c.ID == bills.ID) item = c;
  303. }
  304. projectObj.project.calcProgram.innerCalcBill({data:item, sourceType:"bills", calcType: 3, updateData:[],children:subNodes},3);
  305. console.log(item)
  306. },
  307. initFeeIndexs:function(item){
  308. item.feesIndex = {};
  309. if(item.fees){
  310. for(let f of item.fees){
  311. item.feesIndex[f.fieldName] = f;
  312. }
  313. }
  314. },
  315. deleteItem:async function(){
  316. let selected = this.getSelectedItem();
  317. let subItems = [];
  318. if(selected.itemType == "分摊项"){
  319. //检查是否执行了分摊,如果已经执行了,要取消分摊才能删除
  320. // todo
  321. for(let s of this.divideDatas){
  322. if(s.ParentID == selected.ID) subItems.push({type:"delete",ID:s.ID});
  323. }
  324. }
  325. subItems.push({type:"delete",ID:selected.ID,itemType:selected.itemType});
  326. await this.updateItem(subItems);
  327. },
  328. getNewSeqs:function(selected,newItem){
  329. let seq = 1,datas=[],refreshSeq = false;
  330. for(let d of this.divideDatas){
  331. if(d.ParentID == newItem.ParentID){
  332. if(refreshSeq == true){
  333. if(d.seq == seq || d.seq > seq) datas.push({ID:d.ID,type:'update',doc:{seq:d.seq+1}})
  334. }
  335. if(selected && d.ID == selected.ID){
  336. seq = d.seq + 1;
  337. refreshSeq = true;
  338. }
  339. }
  340. }
  341. return [seq,datas]
  342. },
  343. updateItem: async function(datas){
  344. let divideSetting = projectObj.project.divide_setting.datas
  345. try {
  346. $.bootstrapLoading.start();
  347. let result = ajaxPost("/divide/updateItem",{ID:divideSetting.ID,updateDatas:datas})
  348. this.refreshDivideCaches(datas);
  349. } catch (error) {
  350. console.log(error)
  351. }
  352. $.bootstrapLoading.end();
  353. this.showDatas();
  354. },
  355. refreshDivideCaches:function(datas){
  356. let divideSetting = projectObj.project.divide_setting.datas
  357. for(let d of datas){
  358. if(d.type == "add"){
  359. divideSetting.divideList.push(d.doc);
  360. }
  361. if(d.type == "delete"){
  362. _.remove(divideSetting.divideList,{'ID':d.ID});
  363. if(d.itemType =="定额"){
  364. _.remove(divideSetting.ration_gljs,{'rationID':d.ID});
  365. _.remove(divideSetting.ration_coes,{'rationID':d.ID});
  366. }
  367. }
  368. if(d.type == "update"){
  369. let item = _.find(divideSetting.divideList,{'ID':d.ID});
  370. if(item) gljUtil.updateProperty(item,d.doc);
  371. }
  372. }
  373. },
  374. addDivideRation:async function(rationRepId,code){
  375. let selected = this.getSelectedItem();
  376. if(!selected) return;
  377. let divideSetting = projectObj.project.divide_setting.datas
  378. let pEngineer = projectObj.project.projectInfo.property.projectEngineering;
  379. let libIDs = [rationRepId];
  380. let defaultLibID = rationLibObj.getDefaultStdRationLibID();
  381. let data = {userID:userID,defaultLibID:defaultLibID, rationRepIds: libIDs, code: code,quantityDecimal:getDecimal("ration.quantity"),projectID:projectObj.project.ID()};
  382. data.ParentID = selected.itemType == "分摊项"?selected.ID:selected.ParentID;
  383. let [seq,datas] = this.getNewSeqs(selected,data);
  384. data.type="add";
  385. data.seq = seq;
  386. data.divideID = divideSetting.ID;
  387. if(pEngineer) data.programID = pEngineer;
  388. data.divideDatas = datas;
  389. let sel = this.divideSheet.getSelections()[0];
  390. this.divideSheet.setSelection(sel.row+1,sel.col,sel.rowCount,sel.colCount);
  391. await this.updateDivideRation(data);
  392. },
  393. updateDivideRation:async function(data){
  394. let divideSetting = projectObj.project.divide_setting.datas
  395. try {
  396. $.bootstrapLoading.start();
  397. let result = await ajaxPost("/ration/updateDivideRation",data)
  398. if(data.type=="add"){
  399. data.divideDatas.push({type:"add",doc:result.ration});
  400. this.refreshDivideCaches(data.divideDatas);
  401. if(result.projectGLJList) projectObj.project.projectGLJ.loadNewProjectGLJToCaches(result.projectGLJList,true);
  402. if(result.ration_gljs) divideSetting.ration_gljs = divideSetting.ration_gljs.concat(result.ration_gljs);
  403. if(result.ration_coes) divideSetting.ration_coes = divideSetting.ration_coes.concat(result.ration_coes);
  404. }
  405. await this.calcDivideItem(data);
  406. } catch (error) {
  407. console.log(error)
  408. }
  409. $.bootstrapLoading.end();
  410. //this.showDatas();
  411. },
  412. calcDivideItem:async function(divide){
  413. let updateDatas = [];
  414. let divideSetting = projectObj.project.divide_setting.datas
  415. if(divide.itemType != "分摊项"){//不是分摊项,调用计算程序
  416. let parentSum = 0;
  417. let parent = null;
  418. projectObj.project.calcProgram.innerCalcRation({data:divide, sourceType:"ration", calcType: 1, updateData:[]});
  419. if(divide.itemType == "定额"){
  420. let comnonFee = _.find(divide.fees,{"fieldName":"common"})
  421. if(comnonFee)updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees,marketUnitFee:comnonFee.unitFee,marketTotalFee:comnonFee.totalFee}});
  422. }else{
  423. updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees,marketUnitFee:divide.marketUnitFee,marketTotalFee:divide.marketTotalFee}});
  424. }
  425. parentSum = this.getTotolFee(divide);
  426. for(let c of divideSetting.divideList){
  427. if(c.ID == divide.ParentID) parent = c;
  428. if(c.ParentID == divide.ParentID && c.ID != divide.ID){
  429. parentSum = scMathUtil.roundForObj(parentSum+this.getTotolFee(c),getDecimal("process"))
  430. }
  431. }
  432. parentSum = scMathUtil.roundForObj(parentSum,getDecimal("bills.totalPrice"));
  433. if(parent && parent.marketTotalFee != parentSum) updateDatas.push({ID:parent.ID,type:'update',doc:{marketTotalFee:parentSum}});;
  434. }
  435. updateDatas.length > 0?await this.updateItem(updateDatas):this.showDatas();
  436. },
  437. getTotolFee:function name(divide) {
  438. if(divide.itemType == "定额"){
  439. let comnonFee = _.find(divide.fees,{"fieldName":"common"})
  440. return comnonFee && comnonFee.totalFee ? comnonFee.totalFee:0;
  441. }else if(divide.itemType == "量价"){
  442. return divide.marketTotalFee;
  443. }
  444. },
  445. updateCustomerCoe:function(result){
  446. console.log(result);
  447. },
  448. initDivideSpread:function(){
  449. if(this.divideSpread) return;
  450. this.divideSpread = SheetDataHelper.createNewSpread($("#divide_main_sheet")[0]);
  451. sheetCommonObj.spreadDefaultStyle(this.divideSpread);
  452. this.divideSheet = this.divideSpread.getSheet(0);
  453. sheetCommonObj.initSheet(this.divideSheet, this.divideSetting, 2);
  454. this.divideSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onDivideEditStarting);
  455. this.divideSheet.bind(GC.Spread.Sheets.Events.ValueChanged,this.onDivideValueChange)
  456. this.divideSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onDivideSelectionChange);
  457. /* ;
  458. this.divideSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onCoeRangeChanged); */
  459. SheetDataHelper.protectdSheet(this.divideSheet);
  460. },
  461. onDivideEditStarting:function (sender, args) {
  462. let me = divideObj;
  463. let row = args.row;
  464. let col = args.col;
  465. if(me.divideEditChecking(row,col)==false){
  466. args.cancel = true;
  467. }
  468. },
  469. onDivideValueChange:async function(sender,info){
  470. let me = divideObj,row = info.row, col = info.col;
  471. let setting = me.divideSetting;
  472. let dataCode = setting.header[col].dataCode;
  473. let recode = me.divideDatas[row];
  474. let value = info.newValue;
  475. if(info.newValue === undefined ){
  476. return;
  477. }
  478. if(value && !sheetCommonObj.checkData(col,setting,value)) {
  479. alert('输入的数据类型不对,请重新输入!');
  480. return me.showDatas();
  481. }
  482. await me.updateItem([me.getDivideUpdateData(recode,dataCode,value)]);
  483. await me.calcDivideItem(recode);
  484. },
  485. onDivideSelectionChange:function(sender,args){
  486. let me = divideObj;
  487. let newSel = args.newSelections[0];
  488. let oldSel = args.oldSelections?args.oldSelections[0]:{};
  489. if(newSel.row != oldSel.row){
  490. me.initNavItem();
  491. me.showRationGLJDatas();
  492. }
  493. args.sheet.repaint();
  494. },
  495. getDivideUpdateData:function(recode,dataCode,value){
  496. let doc = {};
  497. if(recode.itemType == "分摊项"){
  498. if(dataCode == "quantity"){
  499. value = scMathUtil.roundForObj(value,3);
  500. let tu = scMathUtil.roundForObj(recode.marketUnitFee&&recode.marketUnitFee!=""?recode.marketUnitFee:0,getDecimal("bills.unitPrice"))
  501. doc["marketTotalFee"] = scMathUtil.roundForObj(value * tu,getDecimal("bills.totalPrice"))
  502. }
  503. if(dataCode == "marketUnitFee"){
  504. value = scMathUtil.roundForObj(value,getDecimal("bills.unitPrice"));
  505. let tq = scMathUtil.roundForObj(recode.quantity && recode.quantity!=""?recode.quantity:0,3)
  506. doc["marketTotalFee"] = scMathUtil.roundForObj(value * tq,getDecimal("bills.totalPrice"))
  507. }
  508. }
  509. if(recode.itemType =="定额"&& dataCode == 'quantity'){
  510. if(value){
  511. value = scMathUtil.roundForObj(parseFloat(value) / FilterNumberFromUnit(recode.unit),getDecimal("ration.quantity"));
  512. }else {
  513. value = 0;
  514. }
  515. }
  516. if(recode.itemType =="量价" && dataCode=="marketPrice") dataCode=="marketUnitFee"
  517. doc[dataCode]=value;
  518. return {ID:recode.ID,type:'update',doc:doc}
  519. },
  520. initBillsSpread:function(){
  521. if(this.billsSpread) return;
  522. this.billsSpread = SheetDataHelper.createNewSpread($("#divide_bills_sheet")[0]);
  523. sheetCommonObj.spreadDefaultStyle(this.billsSpread);
  524. this.billsSheet = this.billsSpread.getSheet(0);
  525. sheetCommonObj.initSheet(this.billsSheet, this.billsSetting, 0);
  526. SheetDataHelper.protectdSheet(this.divideSheet);
  527. },
  528. initDivideSubSpread:function(){
  529. if(this.divideSubSpread) return;
  530. this.divideSubSpread = SheetDataHelper.createNewSpread($("#divide_subSpread")[0],2);
  531. sheetCommonObj.spreadDefaultStyle(this.divideSubSpread);
  532. this.divideSubSheet = this.divideSubSpread.getSheet(0);
  533. sheetCommonObj.initSheet(this.divideSubSheet, gljCol.ration_glj_setting, 0);
  534. SheetDataHelper.protectdSheet(this.divideSubSheet);
  535. },
  536. initNavItem(){
  537. let selected = this.getSelectedItem();
  538. if(selected.itemType == "分摊项"){
  539. $("#divide_itemTextDiv").hide();
  540. $(`#divide_subSpread`).css('width', "100%");
  541. }else{
  542. $("#divide_itemTextDiv").show();
  543. if(this.showDivideGljSubTab == true){
  544. $("#divide_gljSubDiv").show();
  545. $("#divide_rgResize").show();
  546. } else {
  547. $("#divide_gljSubDiv").hide();
  548. $("#divide_rgResize").hide();
  549. }
  550. this.initItemWidth();
  551. }
  552. this.divideSubSpread.refresh();
  553. },
  554. initItemWidth:function (){
  555. //总宽度
  556. let totalWidth = $('#divide_subItems').width();
  557. //人材机和项目特征文本比例
  558. const openWidth = 30;//打开项目特征工具条
  559. const tab_tem = (305+openWidth+10)/totalWidth;//tab显示框默认宽度:305(表格宽度) + 30(工具条宽度)+10(resize div 宽度)
  560. let //默认比例
  561. textPercent = tab_tem * 100 + '%',//'15%',
  562. rcjPercent = (1 - tab_tem)* 100 + '%';//85
  563. //文本没显示,则打开工具条固定30px转换百分比
  564. if (!this.showDivideGljSubTab) {
  565. textPercent = openWidth / totalWidth;
  566. rcjPercent = 1 - textPercent;
  567. textPercent = textPercent * 100 + '%';
  568. rcjPercent = rcjPercent * 100 + '%';
  569. }
  570. //设置特征及内容与排版规则的比例
  571. $('#divide_subSpread').css('width', rcjPercent);
  572. $('#divide_itemTextDiv').css('width', textPercent);
  573. //打开了项目特征,则继续加载人材机表和项目特征文本具体比例
  574. if (divideObj.showDivideGljSubTab === true) {
  575. let rg_sideResizeEles = this.getSubSideResize();
  576. SlideResize.loadHorizonWidth(rg_sideResizeEles.eleObj.module,
  577. [rg_sideResizeEles.eleObj.resize], [rg_sideResizeEles.eleObj.left, rg_sideResizeEles.eleObj.right]);
  578. $("#divide_gljSubDiv").width( $('#divide_itemTextDiv').width() - rg_sideResizeEles.eleObj.resize.width() - 30)
  579. }
  580. },
  581. initDivideGljSubTab:function(){
  582. if(this.showDivideGljSubTab == true){
  583. $("#divide_gljSubDiv").show();
  584. $("#divide_rgResize").show();
  585. } else {
  586. $("#divide_gljSubDiv").hide();
  587. $("#divide_rgResize").hide();
  588. }
  589. this.initItemWidth();
  590. },
  591. getSubSideResize: function () {
  592. let rg_sideResizeEles = {};
  593. rg_sideResizeEles.eleObj = {
  594. module: this.moduleName,
  595. resize: $('#divide_rgResize'),
  596. parent: $('#divide_subItems'),
  597. left: $('#divide_subSpread'),
  598. right: $('#divide_itemTextDiv')
  599. };
  600. rg_sideResizeEles.limit = {
  601. min: 100,
  602. max: `$('#divide_subItems').width()-100`
  603. };
  604. return rg_sideResizeEles;
  605. },
  606. initDivideRightClick:function(){
  607. //如果当前行是无组成物的“普通材料”、“绿化苗木”、“外购砼构件”、“商品混凝土”、“商品砂浆”,则右键“添加计算材料”按钮有效。
  608. let me = this;
  609. $.contextMenu({
  610. selector: '#divide_main_sheet',
  611. build: function ($trigger, e) {
  612. me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.divideSpread);
  613. return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport ||
  614. me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  615. },
  616. items: {
  617. "insertItem": {
  618. name: "插入分摊项",
  619. icon: 'fa-sign-in',
  620. disabled: function () {
  621. let selected = me.getSelectedItem();
  622. if(selected && selected.itemType !="分摊项") return true;
  623. return false;
  624. },
  625. callback: function (key, opt) {
  626. me.addNewItems("分摊项");
  627. }
  628. },
  629. "insertRation": {
  630. name: "插入定额",
  631. icon: 'fa-sign-in',
  632. disabled: function () {
  633. return me.rightClickTarget.row === undefined
  634. },
  635. callback: function (key, opt) {
  636. me.addNewItems("定额");
  637. }
  638. },
  639. "insertVolumePrice": {
  640. name: "插入量价",
  641. icon: 'fa-sign-in',
  642. disabled: function () {
  643. return me.rightClickTarget.row === undefined;
  644. },
  645. items:{
  646. insertLabour:{
  647. name: "人工",
  648. icon: 'fa-sign-in',
  649. callback:function(key){
  650. me.addNewItems("量价",1);
  651. }
  652. },
  653. insertMaterial:{
  654. name:"材料" ,
  655. icon: 'fa-sign-in',
  656. callback:function(key){
  657. me.addNewItems("量价",201);
  658. }
  659. },
  660. insertMachine:{
  661. name:"机械" ,
  662. icon: 'fa-sign-in',
  663. callback:function(key){
  664. me.addNewItems("量价",301);
  665. }
  666. }
  667. }
  668. },
  669. "calcRation": {
  670. name: "计算定额/量价",
  671. icon: 'fa-sign-in',
  672. disabled: function () {
  673. return me.rightClickTarget.row === undefined
  674. },
  675. callback: function (key, opt) {
  676. let selected = me.getSelectedItem();
  677. projectObj.project.calcProgram.innerCalcRation({data:selected, sourceType:"ration", calcType: 1, updateData:[]});
  678. console.log(selected)
  679. }
  680. },
  681. "calcBills": {
  682. name: "计算分摊项",
  683. icon: 'fa-sign-in',
  684. disabled: function () {
  685. return me.rightClickTarget.row === undefined
  686. },
  687. callback: function (key, opt) {
  688. let selected = me.getSelectedItem();
  689. me.calcBills(selected);
  690. }
  691. },
  692. "removeItem": {
  693. name: "删除",
  694. icon: 'fa-trash-o',
  695. disabled: function () {
  696. return me.rightClickTarget.row === undefined;;
  697. },
  698. callback: function (key, opt) {
  699. me.deleteItem();
  700. }
  701. }
  702. }
  703. });
  704. },
  705. getDivideResizeEles:function () {
  706. let divideResizeEles = {};
  707. divideResizeEles.eleObj = {
  708. module: 'divide',
  709. resize: $('#divide_rgResize'),
  710. top: $('#divide_top'),
  711. topSpread: $('#divide_main_sheet'),
  712. bottom: $('#divideBottom').children().find('.main-data-bottom'),
  713. bottomSpread: [$('#divide_subSpread')]
  714. };
  715. divideResizeEles.limit = {
  716. min: 150,
  717. max: `$(window).height()-$('.header').height()-$('#divideToolsBar').height()-150-5`,//5: resize.height()
  718. notTopSpread: 0,
  719. notBottomSpread: 0,
  720. bottomNav:`$('#divideBottom ul').height()`,
  721. totalHeight: `$(window).height()-$('.header').height()-$('#divideToolsBar').height()-5`
  722. };
  723. return divideResizeEles;
  724. }
  725. }
  726. function loadDivideHeight(){
  727. if(!$('#divide_main').is(':visible')) return;
  728. let me = divideObj;
  729. let divideResizeEles = me.getDivideResizeEles();
  730. SlideResize.loadVerticalHeight(divideResizeEles.eleObj.module, divideResizeEles.eleObj, divideResizeEles.limit, function () {
  731. me.refreshViews();
  732. zmhs_obj.refresh();
  733. });
  734. if($('#divide_de').is(':visible')) showDivideSide($($("#divide_stdRationTab").attr('relaPanel')), true, $("#divide_stdRationTab").attr('id'));
  735. }
  736. $('#tab_divide').on('shown.bs.tab', function (e) {
  737. sessionStorage.setItem('mainTab', '#tab_divide');
  738. loadDivideHeight();
  739. divideObj.initSpread();
  740. divideObj.showDatas();
  741. divideObj.initNavItem();
  742. })
  743. $('.divide-nav-link').bind('click', function () {//$('.side-tabs ul li a').bind 2018-11-23 使用更多标签,所以不能这样绑定事件了
  744. var tab = $(this), tabPanel = $(tab.attr('relaPanel'));
  745. if(tab.hasClass('disabled')){
  746. return;
  747. }
  748. let setActiveTab = tab;
  749. if (!(setActiveTab.hasClass('active')&&tabPanel.is(":visible"))) {
  750. $('.divide_side-tabs ul li a').removeClass('active');
  751. setActiveTab.addClass('active');
  752. showDivideSide(tabPanel, true, tab.attr('id'));
  753. } else {
  754. setActiveTab.removeClass('active');
  755. showDivideSide(tabPanel, false, tab.attr('id'));
  756. }
  757. divideObj.refreshViews();
  758. });
  759. //定额库上下拖动
  760. let dividRationLibResizeEles = {};
  761. dividRationLibResizeEles.eleObj = {
  762. module: 'divide_de',
  763. resize: $('#divide_deResize'),
  764. top: $('#divide_deTopDiv'),
  765. topSpread: $('#divide_stdRationChapter'),
  766. bottom: $('#divide_deBottomDiv'),
  767. bottomSpread: $('#divide_stdSectionRations')
  768. };
  769. dividRationLibResizeEles.limit = {
  770. min: 150,
  771. max: `$(window).height()-$('.header').height()-$('.toolsbar').height()-$('#deToolsBar').height()-150-5`,//5: resize.height()
  772. notTopSpread: 0,
  773. notBottomSpread: 0,
  774. totalHeight: `$(window).height()-$('.header').height()-$('.toolsbar').height()-$('#divide_deToolsBar').height()-5`
  775. };
  776. function showDivideSide(tabPanel, show, id){
  777. let divideSideResizeEles = {};
  778. divideSideResizeEles.eleObj = {
  779. module: 'divideRationLibTab',
  780. resize: $('#divideSideResize'),
  781. parent: $('#divideRow'),
  782. left: $('#divide_main'),
  783. right: $('#divide_side')
  784. };
  785. divideSideResizeEles.limit = {
  786. min: 150,
  787. max: `$('#divideRow').width()-150`
  788. };
  789. divideSideResizeEles.eleObj.module = id;
  790. if (show) {
  791. //刚打开各库时的默认比例
  792. divideSideResizeEles.eleObj.left.css('width', '66.666667%');
  793. divideSideResizeEles.eleObj.right.css('width', '33.333333%');
  794. SlideResize.setResizeWidth(divideSideResizeEles.eleObj.resize);
  795. $('.divide_side .tab-pane').hide();
  796. tabPanel.show();//locateTab要等div显示后才执行刷新操作
  797. //加载打开的库与主界面的宽度比
  798. SlideResize.loadHorizonWidth(id, [divideSideResizeEles.eleObj.resize], [divideSideResizeEles.eleObj.left, divideSideResizeEles.eleObj.right], function(){
  799. if (id === 'divide_stdRationTab') {//加载定额库内部上下高度
  800. SlideResize.loadVerticalHeight(dividRationLibResizeEles.eleObj.module, dividRationLibResizeEles.eleObj, dividRationLibResizeEles.limit, function () {
  801. if(rationLibObj.divide_rationChapterSpread) rationLibObj.divide_rationChapterSpread.refresh();
  802. if(rationLibObj.divide_sectionRationsSpread) rationLibObj.divide_sectionRationsSpread.refresh();
  803. });
  804. }
  805. });
  806. } else {
  807. divideSideResizeEles.eleObj.left.css('width', '100%');
  808. divideSideResizeEles.eleObj.right.css('width', '0%');
  809. tabPanel.hide();
  810. }
  811. }
  812. $('#divide_stdRationTab').bind('click', function () {
  813. var select = $('#divide_stdRationLibSelect');
  814. rationLibObj.checkSpread('divide');
  815. if (select[0].options.length === 0) {
  816. rationLibObj.loadStdRationLibs('divide');
  817. //rationLibObj.loadStdRationContextMenu();
  818. };
  819. divideObj.initNavItem();
  820. });
  821. $('#divide_stdRationLibSelect').change(function () {
  822. var select = $(this);
  823. if (this.children.length !== 0) {
  824. let rationLibId = select.val();
  825. sessionStorage.setItem('divide_stdRationLib', rationLibId);
  826. sessionStorage.removeItem('divide_stdRationLibExpState');
  827. rationLibObj.loadStdRation(rationLibId,'divide');
  828. }
  829. });
  830. $('.divide_gljSubTab ul li a').bind('click',function () {
  831. if(this.hash =="#divide_rnc-close"){
  832. $("#divide_zmhs_nav").hide();
  833. $("#divide_zmhs_toogle").show();
  834. closeTab(this);
  835. divideObj.showDivideGljSubTab = false;
  836. }else{
  837. divideObj.showDivideGljSubTab = true;
  838. }
  839. divideObj.initDivideGljSubTab();
  840. if(divideObj.divideSubSpread) divideObj.divideSubSpread.refresh();
  841. });
  842. $('.divide_gljSubTab ul li a').on('shown.bs.tab', function () {
  843. if(this.hash == "#divide_rnc-zm"){
  844. zmhs_obj.initCoeSpread();
  845. }else if(this.hash == "#divide_rnc-fz"){
  846. zmhs_obj.initAssSpread();
  847. }else if(this.hash == "#divide_rnc-cus"){
  848. zmhs_obj.initCusSpread();
  849. }else if(this.hash == "#divide_rnc-stable"){
  850. zmhs_obj.initStableSpread();
  851. }
  852. zmhs_obj.refresh();
  853. zmhs_obj.showDatas();
  854. });
  855. $('#divide_zmhs_toogle').bind('click',function (){
  856. $("#divide_zmhs_nav").show();
  857. if(divideObj.showDivideGljSubTab == false){
  858. $("#divide_hs-nav").click();
  859. }
  860. $("#divide_zmhs_toogle").hide();
  861. });