| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884 |
- let divideObj = {
- divideSetting:{//“类别”、“清单编号”、“名称”、“单位”、“工程量”、“单价”、“金额”、“预算价”、“取费类别”。
- header: [
- {headerName: "类别", headerWidth: 60, dataCode: "itemType", hAlign:'center', dataType: "String"},
- {headerName: "清单编号", headerWidth: 130, dataCode: "code", hAlign:'left', dataType: "String", formatter: "@"},
- {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String",formatter: "@"},
- {headerName: "单位", headerWidth: 100, dataCode: "unit", dataType: "String",cellType:'comboBox',editable:true,options:['m', 'm2', 'm3', 'km', 't', 'kg', '台班', '工日', '昼夜', '元', '项', '处', '个', '件',
- '根', '组', '系统', '台', '套', '株', '丛', '缸', '支', '只', '块', '座', '对', '份', '樘', '攒', '榀']},
- {headerName: "工程量", headerWidth: 80, dataCode: "quantity", dataType: "Number",validator:"number",getText:"notZero"},
- {headerName: "单价", headerWidth: 100, dataCode: "marketPrice", dataType: "Number",validator:"number",getText:"notZero"},
- {headerName: "金额", headerWidth: 100, dataCode: "marketTotalFee", dataType: "Number",validator:"number",getText:"notZero"},
- {headerName: "预算价", headerWidth: 100, dataCode: "marketUnitFee", dataType: "Number",validator:"number",getText:"notZero"},
- {headerName: "取费类别", headerWidth: 60, dataCode: "programID", hAlign:'center', dataType: "String",cellType:'comboBox',editorValueType:true}
- ],
- view:{
- lockColumns: [0],
- colHeaderHeight:30
- },
- getText:{
- notZero:function (item,value) {
- return value == 0?"":value;
- }
- },
- treeCol:1
- },
- billsSetting:{
- header: [//“编号”、“名称”、“分摊比例”、“分摊金额”、“原始金额”、“合计”、“金额”。
- {headerName: "编号", headerWidth: 130, dataCode: "code", hAlign:'left', dataType: "String"},
- {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"},
- {headerName: "分摊比例", headerWidth: 80, dataCode: "divideRate", dataType: "Number",validator:"number"},
- {headerName: "分摊金额", headerWidth: 100, dataCode: "dividePrice", dataType: "Number",validator:"number"},
- {headerName: "原始金额", headerWidth: 100, dataCode: "originalPrice", dataType: "Number",validator:"number"},
- {headerName: "合计", headerWidth: 100, dataCode: "totalPrice", dataType: "Number",validator:"number"},
- {headerName: "金额", headerWidth: 60, dataCode: "price", dataType: "Number",validator:"number"}
- ],
- view:{
- lockColumns: [0,1,2,3,4,5,6],
- colHeaderHeight:30
- }
- },
- divideSpread:null,
- billsSpread:null,
- divideSubSpread:null,
- showDivideGljSubTab:false,
- initSpread:function(){
- this.initDivideSpread();
- this.initBillsSpread();
- this.initDivideSubSpread();
- if(!projectReadOnly){
- this.initDivideRightClick();
- }else {
- disableSpread(this.divideSpread);
- disableSpread(this.billsSpread);
- }
- },
- showDatas:function(){
- this.showDivideDatas();
- this.showBillsDatas();
- this.showRationGLJDatas();
- },
- refreshViews:function(){
- if(!$('#divide_main').is(':visible')) return;
- if(this.divideSpread) this.divideSpread.refresh();
- if(this.billsSpread) this.billsSpread.refresh();
- if(this.divideSubSpread) this.divideSubSpread.refresh();
- },
- showDivideDatas:function(){
- if(!$('#divide_main_sheet').is(':visible')) return;
- this.divideDatas = getDivideDatas();
- this.divideSheet.setRowCount(this.divideDatas.length);
- let fheader= _.find(this.divideSetting.header,{'dataCode': "programID"})
- fheader.options = this.getProgramOptions();
- sheetCommonObj.showTreeData(this.divideSheet, this.divideSetting,this.divideDatas);
- function getDivideDatas(){
- let datas = [];
- let divideSetting = projectObj.project.divide_setting.datas
- let parentMap={};
- //divideSetting.divideList = [{ID:"1",code:"1",ParentID:-1,collapsed:false},{ID:"2",code:"2",ParentID:"1",collapsed:false}]
- divideSetting.divideList = _.sortByAll(divideSetting.divideList,['seq'])
- for(let d of divideSetting.divideList){
- parentMap[d.ParentID]?parentMap[d.ParentID].push(d):parentMap[d.ParentID]=[d]
- }
- if(parentMap[-1]&&parentMap[-1].length>0){
- for(let r of parentMap[-1]){
- r.collapsed = false;
- datas.push(r)
- if(parentMap[r.ID] && parentMap[r.ID].length > 0){
- for(let c of parentMap[r.ID]){
- if(c.fees){
- let comnonFee = _.find(c.fees,{"fieldName":"common"})
- c.marketPrice = comnonFee.unitFee;
- }
- datas.push(c);
- }
- }
- }
- }
- return datas;
- }
- },
- showRationGLJDatas:function(){
- if(!$('#divide_glj_nav').hasClass('active')) return;
- this.divideSubSpread.setActiveSheetIndex(0);
- this.rationGLJDatas = getTreeRationGLJDatas();
- let rationGLJSheet = this.divideSubSpread.getSheet(0)
- rationGLJSheet.setRowCount(this.rationGLJDatas.length);
- sheetCommonObj.showTreeData(rationGLJSheet, gljCol.ration_glj_setting,this.rationGLJDatas);
- function getTreeRationGLJDatas(){
- let datas = [];
- let temDatas=[];//临时存放主工料机
- let selected = divideObj.getSelectedItem();
- let divideSetting = projectObj.project.divide_setting.datas;
- let projectGLJ = projectObj.project.projectGLJ
- let projectGLJData = projectGLJ.datas;
- let projectGljs = projectGLJData.gljList;
- let mixRatioMap = projectGLJData.mixRatioMap;
- if(selected && selected.itemType=="定额"){
- for(r of divideSetting.ration_gljs){
- if(r.rationID == selected.ID){
- let newr = Object.assign(r);
- newr.ParentID = -1;
- temDatas.push(newr);
- }
- }
- if(temDatas.length > 0){
- temDatas = gljUtil.sortRationGLJ(temDatas);
- let pgljMap = _.indexBy(projectGljs, 'id');
- for(let d of temDatas){
- let glj = pgljMap[d.projectGLJID];
- if(!glj) continue;
- if(projectGLJ.isEstimateType(d.type )) d.isEstimate = glj.is_evaluate;
- d.shortName=projectGLJ.getShortNameByID(d.type);
- d.isAdd = glj.unit_price.is_add;
- d=gljOprObj.setGLJPrice(d,glj,false);//设置工料机价格
- //计算工料机的总消耗量
- d.totalQuantity = gljUtil.getTotalQuantity(d,selected,getDecimal("ration.quantity"),getDecimal("glj.quantity"));
- datas.push(d);
- let connect_index = gljOprObj.getIndex(glj, gljKeyArray);
- if(mixRatioMap[connect_index]){//有组成物
- let mList = gljUtil.sortMixRatio(mixRatioMap[connect_index]);
- for(let m of mList){
- let mIndex = gljOprObj.getIndex(m,gljKeyArray);
- var mpg = _.find(projectGljs, function (item) {
- return gljOprObj.getIndex(item,gljKeyArray) == mIndex
- });
- if(!mpg) continue;
- let tem = {
- ParentID:d.ID,
- projectGLJID: mpg.id,
- code: mpg.code,
- name: mpg.name,
- specs: mpg.specs,
- unit: mpg.unit,
- type:m.type,
- shortName: projectGLJ.getShortNameByID(m.type),
- consumption:m.consumption,
- rationItemQuantity: scMathUtil.roundForObj(m.consumption, getDecimal("glj.quantity")),
- isMixRatio: true,
- isAdd: mpg.unit_price.is_add,
- GLJID: mpg.glj_id
- };
- if(projectGLJ.isEstimateType(mpg.type)){
- tem.isEstimate = mpg.is_evaluate;
- }
- tem.totalQuantity = scMathUtil.roundToString(tem.rationItemQuantity * parseFloat(d.totalQuantity), getDecimal("glj.quantity"));
- gljOprObj.setGLJPrice(tem,mpg);
- datas.push(tem);
- }
- }
- }
- }
- }
- return datas;
- }
- },
- getRationGLJDatas : function (ration){//这里是给计算程序统一调用的方法,树结构不用这个方法了
- let datas = [];
- let selected = ration;
- let divideSetting = projectObj.project.divide_setting.datas;
- if(selected && selected.itemType=="定额"){
- for(r of divideSetting.ration_gljs){
- if(r.rationID == selected.ID){
- let newr = Object.assign(r);
- newr.ParentID = -1;
- datas.push(newr);
- }
- }
- gljOprObj.combineWithProjectGlj(datas,false,selected);
- }
- return datas;
- },
- getCoeList:function(){
- let selected = this.getSelectedItem();
- let divideSetting = projectObj.project.divide_setting.datas;
- let coeList = [];
- if(selected.itemType == "定额"){
- let assList = selected&&selected.rationAssList ? selected.rationAssList : [];
- zmhs_obj.divide_assSheetData = assList;
- for(let c of divideSetting.ration_coes){
- if(c.rationID == selected.ID) coeList.push(c);
- _.remove(coeList,{"coeID":-1});
- }
- coeList = assList.concat(coeList)
- }
- return coeList;
- },
- getCusList:function(){
- let selected = this.getSelectedItem();
- let divideSetting = projectObj.project.divide_setting.datas;
- let cusList = [];
- if(selected.itemType == "定额"){
- for(let c of divideSetting.ration_coes){
- if(c.rationID == selected.ID && c.coeID == -1){
- zmhs_obj.divide_cusSheetData = c;
- cusList = c.coes;
- break;
- }
- }
- }
- return cusList;
- },
- getStableList:function(){
- return this.rationGLJDatas.filter(glj => !glj.isMixRatio && glj.rationProportion);
- },
- getProgramOptions:function(){
- let names = projectObj.project.calcProgram.compiledTemplateNames;
- let map = projectObj.project.calcProgram.compiledTemplateMaps;
- let options = [];
- for(let n of names){
- options.push({text:n,value:map[n]});
- }
- return options;
- },
- divideEditChecking:function(row,col){//return false表示不能编辑
- let me = this;
- let data = me.divideDatas[row],setting = me.divideSetting;
- let dataCode = setting.header[col].dataCode;
- if(data){
- if(data.itemType == "分摊项"){
- //金额,预算价,取费类别不可编辑
- if(dataCode =="marketTotalFee" || dataCode =="marketPrice" || dataCode =="programID" ) return false;
- //有子项时,单价不可编辑
- if(dataCode =="marketUnitFee"&& _.find(me.divideDatas,{ParentID:data.ID})) return false;
- }
- if( data.itemType == "量价" && dataCode =="marketTotalFee") return false//量价:“金额”不可编辑。
- if(data.itemType == "定额"){ //定额:“单位”、“单价”、“金额”、“预算价”
- return !(dataCode == "unit"||dataCode == "marketUnitFee"||dataCode == "marketTotalFee"||dataCode == "marketPrice")
- }
- return true
- }
- return false;
- },
- showBillsDatas:function(){
- if(!$('#divide_bills_sheet').is(':visible')) return;
- this.billsDatas = getBillsDatas();
- sheetCommonObj.showData(this.billsSheet, this.billsSetting,this.billsDatas);
- this.billsSheet.setRowCount(this.billsDatas.length);
- function getBillsDatas(){
- return [];
- }
- },
- getSelectedItem:function(){
- let me = this,data=null;
- let sel = me.divideSheet.getSelections()[0];
- let srow = sel.row == -1||sel.row == ""?0:sel.row;
- if(me.divideDatas.length>srow){
- data = me.divideDatas[srow];
- }
- return data;
- },
- addNewItems:async function(itemType,type){
- let newItem = {
- ID:uuid.v1(),
- itemType:itemType,
- ParentID:-1
- };
- if(type) newItem.subType = type;
- let selected = this.getSelectedItem();
- if(itemType!="分摊项"){//当插入定额或者量价时:
- newItem.ParentID = selected.itemType == "分摊项"?selected.ID:selected.ParentID;
- }
- if(itemType == "定额") newItem.type = rationType.ration;
- if(itemType == "量价"){
- newItem['programID'] = projectObj.project.calcProgram.compiledTemplateMaps["费率为0"];
- newItem.type = rationType.volumePrice;
- }
- let [seq,datas] = this.getNewSeqs(selected,newItem);
- newItem.seq = seq;
- datas.push({type:"add",doc:newItem});
- await this.updateItem(datas);
- },
- calcBills:function(bills){
- let divideSetting = projectObj.project.divide_setting.datas;
- let subNodes = [];
- let item=null;
- for(let c of divideSetting.divideList){
- if(c.ParentID == bills.ID){
- subNodes.push({data:c, sourceType:"ration", calcType: 1, updateData:[]});
- }
- if(c.ID == bills.ID) item = c;
- }
- projectObj.project.calcProgram.innerCalcBill({data:item, sourceType:"bills", calcType: 3, updateData:[],children:subNodes},3);
- console.log(selected)
- },
- deleteItem:async function(){
- let selected = this.getSelectedItem();
- let subItems = [];
- if(selected.itemType == "分摊项"){
- //检查是否执行了分摊,如果已经执行了,要取消分摊才能删除
- // todo
- for(let s of this.divideDatas){
- if(s.ParentID == selected.ID) subItems.push({type:"delete",ID:s.ID});
- }
- }
- subItems.push({type:"delete",ID:selected.ID,itemType:selected.itemType});
- await this.updateItem(subItems);
- },
- getNewSeqs:function(selected,newItem){
- let seq = 1,datas=[],refreshSeq = false;
- for(let d of this.divideDatas){
- if(d.ParentID == newItem.ParentID){
- if(refreshSeq == true){
- if(d.seq == seq || d.seq > seq) datas.push({ID:d.ID,type:'update',doc:{seq:d.seq+1}})
- }
- if(selected && d.ID == selected.ID){
- seq = d.seq + 1;
- refreshSeq = true;
- }
- }
- }
- return [seq,datas]
- },
- updateItem: async function(datas){
- let divideSetting = projectObj.project.divide_setting.datas
- try {
- $.bootstrapLoading.start();
- let result = ajaxPost("/divide/updateItem",{ID:divideSetting.ID,updateDatas:datas})
- this.refreshDivideCaches(datas);
- } catch (error) {
- console.log(error)
- }
- $.bootstrapLoading.end();
- this.showDatas();
- },
- refreshDivideCaches:function(datas){
- let divideSetting = projectObj.project.divide_setting.datas
- for(let d of datas){
- if(d.type == "add"){
- divideSetting.divideList.push(d.doc);
- }
- if(d.type == "delete"){
- _.remove(divideSetting.divideList,{'ID':d.ID});
- if(d.itemType =="定额"){
- _.remove(divideSetting.ration_gljs,{'rationID':d.ID});
- _.remove(divideSetting.ration_coes,{'rationID':d.ID});
- }
- }
- if(d.type == "update"){
- let item = _.find(divideSetting.divideList,{'ID':d.ID});
- if(item) gljUtil.updateProperty(item,d.doc);
- }
- }
- },
- addDivideRation:async function(rationRepId,code){
- let selected = this.getSelectedItem();
- if(!selected) return;
- let divideSetting = projectObj.project.divide_setting.datas
- let pEngineer = projectObj.project.projectInfo.property.projectEngineering;
- let libIDs = [rationRepId];
- let defaultLibID = rationLibObj.getDefaultStdRationLibID();
- let data = {userID:userID,defaultLibID:defaultLibID, rationRepIds: libIDs, code: code,quantityDecimal:getDecimal("ration.quantity"),projectID:projectObj.project.ID()};
- data.ParentID = selected.itemType == "分摊项"?selected.ID:selected.ParentID;
- let [seq,datas] = this.getNewSeqs(selected,data);
- data.type="add";
- data.seq = seq;
- data.divideID = divideSetting.ID;
- if(pEngineer) data.programID = pEngineer;
- data.divideDatas = datas;
- let sel = this.divideSheet.getSelections()[0];
- this.divideSheet.setSelection(sel.row+1,sel.col,sel.rowCount,sel.colCount);
- await this.updateDivideRation(data);
- },
- updateDivideRation:async function(data){
- let divideSetting = projectObj.project.divide_setting.datas
- try {
- $.bootstrapLoading.start();
- let result = await ajaxPost("/ration/updateDivideRation",data)
- if(data.type=="add"){
- data.divideDatas.push({type:"add",doc:result.ration});
- this.refreshDivideCaches(data.divideDatas);
- if(result.projectGLJList) projectObj.project.projectGLJ.loadNewProjectGLJToCaches(result.projectGLJList,true);
- if(result.ration_gljs) divideSetting.ration_gljs = divideSetting.ration_gljs.concat(result.ration_gljs);
- if(result.ration_coes) divideSetting.ration_coes = divideSetting.ration_coes.concat(result.ration_coes);
- }
- await this.calcDivideItem(data);
- } catch (error) {
- console.log(error)
- }
- $.bootstrapLoading.end();
- //this.showDatas();
- },
- calcDivideItem:async function(divide){
- let updateDatas = [];
- let divideSetting = projectObj.project.divide_setting.datas
- if(divide.itemType != "分摊项"){//不是分摊项,调用计算程序
- let parentSum = 0;
- let parent = null;
- projectObj.project.calcProgram.innerCalcRation({data:divide, sourceType:"ration", calcType: 1, updateData:[]});
- if(divide.itemType == "定额"){
- let comnonFee = _.find(divide.fees,{"fieldName":"common"})
- if(comnonFee)updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees,marketUnitFee:comnonFee.unitFee,marketTotalFee:comnonFee.totalFee}});
-
- }else{
- updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees,marketUnitFee:divide.marketUnitFee,marketTotalFee:divide.marketTotalFee}});
- }
- parentSum = this.getTotolFee(divide);
- for(let c of divideSetting.divideList){
- if(c.ID == divide.ParentID) parent = c;
- if(c.ParentID == divide.ParentID && c.ID != divide.ID){
- parentSum = scMathUtil.roundForObj(parentSum+this.getTotolFee(c),getDecimal("process"))
- }
- }
- parentSum = scMathUtil.roundForObj(parentSum,getDecimal("bills.totalPrice"));
- if(parent && parent.marketTotalFee != parentSum) updateDatas.push({ID:parent.ID,type:'update',doc:{marketTotalFee:parentSum}});;
- }
- updateDatas.length > 0?await this.updateItem(updateDatas):this.showDatas();
- },
- getTotolFee:function name(divide) {
- if(divide.itemType == "定额"){
- let comnonFee = _.find(divide.fees,{"fieldName":"common"})
- return comnonFee && comnonFee.totalFee ? comnonFee.totalFee:0;
- }else if(divide.itemType == "量价"){
- return divide.marketTotalFee;
- }
- },
- updateCustomerCoe:function(result){
- console.log(result);
- },
- initDivideSpread:function(){
- if(this.divideSpread) return;
- this.divideSpread = SheetDataHelper.createNewSpread($("#divide_main_sheet")[0]);
- sheetCommonObj.spreadDefaultStyle(this.divideSpread);
- this.divideSheet = this.divideSpread.getSheet(0);
- sheetCommonObj.initSheet(this.divideSheet, this.divideSetting, 2);
- this.divideSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onDivideEditStarting);
- this.divideSheet.bind(GC.Spread.Sheets.Events.ValueChanged,this.onDivideValueChange)
- this.divideSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onDivideSelectionChange);
- /* ;
- this.divideSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onCoeRangeChanged); */
- SheetDataHelper.protectdSheet(this.divideSheet);
- },
- onDivideEditStarting:function (sender, args) {
- let me = divideObj;
- let row = args.row;
- let col = args.col;
- if(me.divideEditChecking(row,col)==false){
- args.cancel = true;
- }
- },
- onDivideValueChange:async function(sender,info){
- let me = divideObj,row = info.row, col = info.col;
- let setting = me.divideSetting;
- let dataCode = setting.header[col].dataCode;
- let recode = me.divideDatas[row];
- let value = info.newValue;
- if(info.newValue === undefined ){
- return;
- }
- if(value && !sheetCommonObj.checkData(col,setting,value)) {
- alert('输入的数据类型不对,请重新输入!');
- return me.showDatas();
- }
- await me.updateItem([me.getDivideUpdateData(recode,dataCode,value)]);
- await me.calcDivideItem(recode);
- },
- onDivideSelectionChange:function(sender,args){
- let me = divideObj;
- let newSel = args.newSelections[0];
- let oldSel = args.oldSelections?args.oldSelections[0]:{};
- if(newSel.row != oldSel.row){
- me.initNavItem();
- me.showRationGLJDatas();
- }
- args.sheet.repaint();
- },
- getDivideUpdateData:function(recode,dataCode,value){
- let doc = {};
- if(recode.itemType == "分摊项"){
- if(dataCode == "quantity"){
- value = scMathUtil.roundForObj(value,3);
- let tu = scMathUtil.roundForObj(recode.marketUnitFee&&recode.marketUnitFee!=""?recode.marketUnitFee:0,getDecimal("bills.unitPrice"))
- doc["marketTotalFee"] = scMathUtil.roundForObj(value * tu,getDecimal("bills.totalPrice"))
- }
- if(dataCode == "marketUnitFee"){
- value = scMathUtil.roundForObj(value,getDecimal("bills.unitPrice"));
- let tq = scMathUtil.roundForObj(recode.quantity && recode.quantity!=""?recode.quantity:0,3)
- doc["marketTotalFee"] = scMathUtil.roundForObj(value * tq,getDecimal("bills.totalPrice"))
- }
- }
- if(recode.itemType =="定额"&& dataCode == 'quantity'){
- if(value){
- value = scMathUtil.roundForObj(parseFloat(value) / FilterNumberFromUnit(recode.unit),getDecimal("ration.quantity"));
- }else {
- value = 0;
- }
- }
- if(recode.itemType =="量价" && dataCode=="marketPrice") dataCode=="marketUnitFee"
- doc[dataCode]=value;
- return {ID:recode.ID,type:'update',doc:doc}
- },
- initBillsSpread:function(){
- if(this.billsSpread) return;
- this.billsSpread = SheetDataHelper.createNewSpread($("#divide_bills_sheet")[0]);
- sheetCommonObj.spreadDefaultStyle(this.billsSpread);
- this.billsSheet = this.billsSpread.getSheet(0);
- sheetCommonObj.initSheet(this.billsSheet, this.billsSetting, 0);
- SheetDataHelper.protectdSheet(this.divideSheet);
- },
- initDivideSubSpread:function(){
- if(this.divideSubSpread) return;
- this.divideSubSpread = SheetDataHelper.createNewSpread($("#divide_subSpread")[0],2);
- sheetCommonObj.spreadDefaultStyle(this.divideSubSpread);
- this.divideSubSheet = this.divideSubSpread.getSheet(0);
- sheetCommonObj.initSheet(this.divideSubSheet, gljCol.ration_glj_setting, 0);
- SheetDataHelper.protectdSheet(this.divideSubSheet);
- },
- initNavItem(){
- let selected = this.getSelectedItem();
- if(selected.itemType == "分摊项"){
- $("#divide_itemTextDiv").hide();
- $(`#divide_subSpread`).css('width', "100%");
- }else{
- $("#divide_itemTextDiv").show();
- if(this.showDivideGljSubTab == true){
- $("#divide_gljSubDiv").show();
- $("#divide_rgResize").show();
- } else {
- $("#divide_gljSubDiv").hide();
- $("#divide_rgResize").hide();
- }
- this.initItemWidth();
- }
- this.divideSubSpread.refresh();
- },
- initItemWidth:function (){
- //总宽度
- let totalWidth = $('#divide_subItems').width();
- //人材机和项目特征文本比例
- const openWidth = 30;//打开项目特征工具条
- const tab_tem = (305+openWidth+10)/totalWidth;//tab显示框默认宽度:305(表格宽度) + 30(工具条宽度)+10(resize div 宽度)
- let //默认比例
- textPercent = tab_tem * 100 + '%',//'15%',
- rcjPercent = (1 - tab_tem)* 100 + '%';//85
- //文本没显示,则打开工具条固定30px转换百分比
- if (!this.showDivideGljSubTab) {
- textPercent = openWidth / totalWidth;
- rcjPercent = 1 - textPercent;
- textPercent = textPercent * 100 + '%';
- rcjPercent = rcjPercent * 100 + '%';
- }
- //设置特征及内容与排版规则的比例
- $('#divide_subSpread').css('width', rcjPercent);
- $('#divide_itemTextDiv').css('width', textPercent);
- //打开了项目特征,则继续加载人材机表和项目特征文本具体比例
- if (divideObj.showDivideGljSubTab === true) {
- let rg_sideResizeEles = this.getSubSideResize();
- SlideResize.loadHorizonWidth(rg_sideResizeEles.eleObj.module,
- [rg_sideResizeEles.eleObj.resize], [rg_sideResizeEles.eleObj.left, rg_sideResizeEles.eleObj.right]);
- $("#divide_gljSubDiv").width( $('#divide_itemTextDiv').width() - rg_sideResizeEles.eleObj.resize.width() - 30)
- }
- },
- initDivideGljSubTab:function(){
- if(this.showDivideGljSubTab == true){
- $("#divide_gljSubDiv").show();
- $("#divide_rgResize").show();
- } else {
- $("#divide_gljSubDiv").hide();
- $("#divide_rgResize").hide();
- }
- this.initItemWidth();
- },
- getSubSideResize: function () {
- let rg_sideResizeEles = {};
- rg_sideResizeEles.eleObj = {
- module: this.moduleName,
- resize: $('#divide_rgResize'),
- parent: $('#divide_subItems'),
- left: $('#divide_subSpread'),
- right: $('#divide_itemTextDiv')
- };
- rg_sideResizeEles.limit = {
- min: 100,
- max: `$('#divide_subItems').width()-100`
- };
- return rg_sideResizeEles;
- },
- initDivideRightClick:function(){
- //如果当前行是无组成物的“普通材料”、“绿化苗木”、“外购砼构件”、“商品混凝土”、“商品砂浆”,则右键“添加计算材料”按钮有效。
- let me = this;
- $.contextMenu({
- selector: '#divide_main_sheet',
- build: function ($trigger, e) {
- me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.divideSpread);
- return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport ||
- me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
- },
- items: {
- "insertItem": {
- name: "插入分摊项",
- icon: 'fa-sign-in',
- disabled: function () {
- let selected = me.getSelectedItem();
- if(selected && selected.itemType !="分摊项") return true;
- return false;
- },
- callback: function (key, opt) {
- me.addNewItems("分摊项");
- }
- },
- "insertRation": {
- name: "插入定额",
- icon: 'fa-sign-in',
- disabled: function () {
- return me.rightClickTarget.row === undefined
- },
- callback: function (key, opt) {
- me.addNewItems("定额");
- }
- },
- "insertVolumePrice": {
- name: "插入量价",
- icon: 'fa-sign-in',
- disabled: function () {
- return me.rightClickTarget.row === undefined;
- },
- items:{
- insertLabour:{
- name: "人工",
- icon: 'fa-sign-in',
- callback:function(key){
- me.addNewItems("量价",1);
- }
- },
- insertMaterial:{
- name:"材料" ,
- icon: 'fa-sign-in',
- callback:function(key){
- me.addNewItems("量价",201);
- }
- },
- insertMachine:{
- name:"机械" ,
- icon: 'fa-sign-in',
- callback:function(key){
- me.addNewItems("量价",301);
- }
- }
- }
- },
- "calcRation": {
- name: "计算定额/量价",
- icon: 'fa-sign-in',
- disabled: function () {
- return me.rightClickTarget.row === undefined
- },
- callback: function (key, opt) {
- let selected = me.getSelectedItem();
- projectObj.project.calcProgram.innerCalcRation({data:selected, sourceType:"ration", calcType: 1, updateData:[]});
- console.log(selected)
- }
- },
- "calcBills": {
- name: "计算分摊项",
- icon: 'fa-sign-in',
- disabled: function () {
- return me.rightClickTarget.row === undefined
- },
- callback: function (key, opt) {
- let selected = me.getSelectedItem();
- me.calcBills(selected);
- }
- },
- "removeItem": {
- name: "删除",
- icon: 'fa-trash-o',
- disabled: function () {
- return me.rightClickTarget.row === undefined;;
- },
- callback: function (key, opt) {
- me.deleteItem();
- }
- }
- }
- });
- },
- getDivideResizeEles:function () {
- let divideResizeEles = {};
- divideResizeEles.eleObj = {
- module: 'divide',
- resize: $('#divide_rgResize'),
- top: $('#divide_top'),
- topSpread: $('#divide_main_sheet'),
- bottom: $('#divideBottom').children().find('.main-data-bottom'),
- bottomSpread: [$('#divide_subSpread')]
- };
- divideResizeEles.limit = {
- min: 150,
- max: `$(window).height()-$('.header').height()-$('#divideToolsBar').height()-150-5`,//5: resize.height()
- notTopSpread: 0,
- notBottomSpread: 0,
- bottomNav:`$('#divideBottom ul').height()`,
- totalHeight: `$(window).height()-$('.header').height()-$('#divideToolsBar').height()-5`
- };
- return divideResizeEles;
- }
- }
- function loadDivideHeight(){
- if(!$('#divide_main').is(':visible')) return;
- let me = divideObj;
- let divideResizeEles = me.getDivideResizeEles();
- SlideResize.loadVerticalHeight(divideResizeEles.eleObj.module, divideResizeEles.eleObj, divideResizeEles.limit, function () {
- me.refreshViews();
- zmhs_obj.refresh();
- });
- if($('#divide_de').is(':visible')) showDivideSide($($("#divide_stdRationTab").attr('relaPanel')), true, $("#divide_stdRationTab").attr('id'));
- }
- $('#tab_divide').on('shown.bs.tab', function (e) {
- sessionStorage.setItem('mainTab', '#tab_divide');
- loadDivideHeight();
- divideObj.initSpread();
- divideObj.showDatas();
- divideObj.initNavItem();
- })
- $('.divide-nav-link').bind('click', function () {//$('.side-tabs ul li a').bind 2018-11-23 使用更多标签,所以不能这样绑定事件了
- var tab = $(this), tabPanel = $(tab.attr('relaPanel'));
- if(tab.hasClass('disabled')){
- return;
- }
- let setActiveTab = tab;
- if (!(setActiveTab.hasClass('active')&&tabPanel.is(":visible"))) {
- $('.divide_side-tabs ul li a').removeClass('active');
- setActiveTab.addClass('active');
- showDivideSide(tabPanel, true, tab.attr('id'));
- } else {
- setActiveTab.removeClass('active');
- showDivideSide(tabPanel, false, tab.attr('id'));
- }
- divideObj.refreshViews();
-
- });
- //定额库上下拖动
- let dividRationLibResizeEles = {};
- dividRationLibResizeEles.eleObj = {
- module: 'divide_de',
- resize: $('#divide_deResize'),
- top: $('#divide_deTopDiv'),
- topSpread: $('#divide_stdRationChapter'),
- bottom: $('#divide_deBottomDiv'),
- bottomSpread: $('#divide_stdSectionRations')
- };
- dividRationLibResizeEles.limit = {
- min: 150,
- max: `$(window).height()-$('.header').height()-$('.toolsbar').height()-$('#deToolsBar').height()-150-5`,//5: resize.height()
- notTopSpread: 0,
- notBottomSpread: 0,
- totalHeight: `$(window).height()-$('.header').height()-$('.toolsbar').height()-$('#divide_deToolsBar').height()-5`
- };
- function showDivideSide(tabPanel, show, id){
- let divideSideResizeEles = {};
- divideSideResizeEles.eleObj = {
- module: 'divideRationLibTab',
- resize: $('#divideSideResize'),
- parent: $('#divideRow'),
- left: $('#divide_main'),
- right: $('#divide_side')
- };
- divideSideResizeEles.limit = {
- min: 150,
- max: `$('#divideRow').width()-150`
- };
- divideSideResizeEles.eleObj.module = id;
- if (show) {
- //刚打开各库时的默认比例
- divideSideResizeEles.eleObj.left.css('width', '66.666667%');
- divideSideResizeEles.eleObj.right.css('width', '33.333333%');
- SlideResize.setResizeWidth(divideSideResizeEles.eleObj.resize);
- $('.divide_side .tab-pane').hide();
- tabPanel.show();//locateTab要等div显示后才执行刷新操作
- //加载打开的库与主界面的宽度比
- SlideResize.loadHorizonWidth(id, [divideSideResizeEles.eleObj.resize], [divideSideResizeEles.eleObj.left, divideSideResizeEles.eleObj.right], function(){
- if (id === 'divide_stdRationTab') {//加载定额库内部上下高度
- SlideResize.loadVerticalHeight(dividRationLibResizeEles.eleObj.module, dividRationLibResizeEles.eleObj, dividRationLibResizeEles.limit, function () {
- if(rationLibObj.divide_rationChapterSpread) rationLibObj.divide_rationChapterSpread.refresh();
- if(rationLibObj.divide_sectionRationsSpread) rationLibObj.divide_sectionRationsSpread.refresh();
- });
- }
- });
- } else {
- divideSideResizeEles.eleObj.left.css('width', '100%');
- divideSideResizeEles.eleObj.right.css('width', '0%');
- tabPanel.hide();
- }
- }
- $('#divide_stdRationTab').bind('click', function () {
- var select = $('#divide_stdRationLibSelect');
- rationLibObj.checkSpread('divide');
- if (select[0].options.length === 0) {
- rationLibObj.loadStdRationLibs('divide');
- //rationLibObj.loadStdRationContextMenu();
- };
- divideObj.initNavItem();
- });
- $('#divide_stdRationLibSelect').change(function () {
- var select = $(this);
- if (this.children.length !== 0) {
- let rationLibId = select.val();
- sessionStorage.setItem('divide_stdRationLib', rationLibId);
- sessionStorage.removeItem('divide_stdRationLibExpState');
- rationLibObj.loadStdRation(rationLibId,'divide');
- }
- });
- $('.divide_gljSubTab ul li a').bind('click',function () {
- if(this.hash =="#divide_rnc-close"){
- $("#divide_zmhs_nav").hide();
- $("#divide_zmhs_toogle").show();
- closeTab(this);
- divideObj.showDivideGljSubTab = false;
- }else{
- divideObj.showDivideGljSubTab = true;
- }
- divideObj.initDivideGljSubTab();
- if(divideObj.divideSubSpread) divideObj.divideSubSpread.refresh();
- });
- $('.divide_gljSubTab ul li a').on('shown.bs.tab', function () {
- if(this.hash == "#divide_rnc-zm"){
- zmhs_obj.initCoeSpread();
- }else if(this.hash == "#divide_rnc-fz"){
- zmhs_obj.initAssSpread();
- }else if(this.hash == "#divide_rnc-cus"){
- zmhs_obj.initCusSpread();
- }else if(this.hash == "#divide_rnc-stable"){
- zmhs_obj.initStableSpread();
- }
- zmhs_obj.refresh();
- zmhs_obj.showDatas();
- });
- $('#divide_zmhs_toogle').bind('click',function (){
- $("#divide_zmhs_nav").show();
- if(divideObj.showDivideGljSubTab == false){
- $("#divide_hs-nav").click();
- }
- $("#divide_zmhs_toogle").hide();
- });
|