YangHuCost/web/building_saas/main/js/views/divide_view.js

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;
          setItemsPrice(r);
          datas.push(r)
          if(parentMap[r.ID] && parentMap[r.ID].length > 0){
            for(let c of parentMap[r.ID]){
              setItemsPrice(c);
              datas.push(c);
            }
          }
        }
      }
      return datas;
    }

    function setItemsPrice(item){
      if(item.fees){
        let commonFee = _.find(item.fees,{"fieldName":"common"})
        if (commonFee){
          item.marketPrice = commonFee.unitFee;
          item.marketTotalFee = commonFee.totalFee;
        }
          
      }
    }

  },


  showCalcProgramDatas:function(){
    if(!$('#divede_calc_nav').hasClass('active')) return;
    this.divideSubSpread.setActiveSheetIndex(1);
    //this.rationGLJDatas = getTreeRationGLJDatas();
  },

  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 =="marketUnitFee" || dataCode =="programID" ) return false;
        //有子项时，单价不可编辑
        if(dataCode =="marketPrice"&& _.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;
      newItem.fees = [{fieldName:"common",tenderTotalFee:0,unitFee:0,totalFee:0,tenderUnitFee:0}];
    }
    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);
    await this.calcDivideItem(newItem);
  },
  calcBills:function(bills,deleteMap){
    let divideSetting =  projectObj.project.divide_setting.datas;
    let subNodes = [];
    let item=null;
    for(let c of divideSetting.divideList){
      if(c.ParentID == bills.ID){
        if(deleteMap && deleteMap[c.ID]) continue;
        this.initFeeIndexs(c);
        subNodes.push({data:c, sourceType:"ration", calcType: 1, updateData:[]});
      } 
      if(c.ID == bills.ID) item = c;
    }
    if(subNodes.length > 0) projectObj.project.calcProgram.innerCalcBill({data:item, sourceType:"bills", updateData:[],children:subNodes},3);
    if(subNodes.length == 0){
      item.calcFlag = 2;
      this.initFeeIndexs(item);
      projectObj.project.calcProgram.innerCalcBillCustom({data:item, sourceType:"bills", updateData:[],children:[]},3);
    } 
    return item;
  },
  initFeeIndexs:function(item){
    item.feesIndex = {};
    if(item.fees){
      for(let f of item.fees){
        item.feesIndex[f.fieldName] = f;
      }
    }
  },
  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});
      }
    }else{
      let deleteMap = {};
      deleteMap[selected.ID] = true;
      let item = this.calcBills({ID:selected.ParentID},deleteMap);
      subItems.push({ID:item.ID,type:'update',doc:{fees:item.fees}});  
    }
    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];
    await this.updateDivideRation(data);
    this.divideSheet.setSelection(sel.row+1,sel.col,sel.rowCount,sel.colCount);

  },
  updateDivideRation:async function(data){
    let divideSetting =  projectObj.project.divide_setting.datas;
    let newRation = data;
    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);
        newRation = result.ration;
        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(newRation);
    } catch (error) {
      console.log(error)
    }
    $.bootstrapLoading.end();
    //this.showDatas();
  },
  calcDivideItem:async function(divide){
    let updateDatas = [];
    let children =[];
    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 == "定额"){
        updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees}});  
      }else{
        updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees,marketUnitFee:divide.marketUnitFee}});
      } 
      for(let c of divideSetting.divideList){
        if(c.ID == divide.ParentID) parent = c;
        if(c.ParentID == divide.ParentID){
          let t = c.ID != divide.ID?c:divide;
          this.initFeeIndexs(t);
          children.push({data:t, sourceType:"ration", calcType: 1, updateData:[]});
        }
      }
      if(children.length > 0){
        projectObj.project.calcProgram.innerCalcBill({data:parent, sourceType:"bills", updateData:[],children:children},3);
        updateDatas.push({ID:parent.ID,type:'update',doc:{fees:parent.fees}});  
      } 
    }else{
      divide = this.calcBills(divide);
      updateDatas.push({ID:divide.ID,type:'update',doc:{fees:divide.fees}});  
    }
    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 commonFee = _.find(recode.fees,{"fieldName":"common"})
        if (commonFee){
          let tu = scMathUtil.roundForObj(commonFee.unitFee&&commonFee.unitFee!=""?commonFee.unitFee:0,getDecimal("bills.unitPrice"))
          commonFee.totalFee = scMathUtil.roundForObj(value * tu,getDecimal("bills.totalPrice"));
          doc["fees"] = recode.fees;
        }
      }
      if(dataCode == "marketPrice"){
        value = scMathUtil.roundForObj(value,getDecimal("bills.unitPrice"));
        let commonFee = _.find(recode.fees,{"fieldName":"common"})
        if (commonFee){
          //let tu = scMathUtil.roundForObj(commonFee.unitFee&&commonFee.unitFee!=""?commonFee.unitFee:0,getDecimal("bills.unitPrice"))
          commonFee.unitFee = scMathUtil.roundForObj(value,getDecimal("bills.unitPrice"));
          doc["fees"] = recode.fees;
        }
        return {ID:recode.ID,type:'update',doc:doc};
      }
      
    }
    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);
    this.calcProgramSheet = this.divideSubSpread.getSheet(1);
    calcProgramObj.initSheet(this.calcProgramSheet);
  },
  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();
                  console.log(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();
});

$('#divideBottom ul li a').on('shown.bs.tab',function () {
  divideObj.showRationGLJDatas();
  divideObj.showCalcProgramDatas();
});