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

/**
 * Created by zhang on 2019/12/12.
 */
let electrovalenceObj = {
  setting: {
    header: [{
        headerName: "代号",
        headerWidth: 70,
        dataCode: "code",
        dataType: "String"
      },
      {
        headerName: "名称",
        headerWidth: 150,
        dataCode: "displayName",
        dataType: "String"
      },
      {
        headerName: "规格",
        headerWidth: 70,
        dataCode: "specs",
        dataType: "Number",
        validator: "number"
      },
      {
        headerName: "预算价",
        headerWidth: 75,
        dataCode: "electPrice",
        hAlign: "right",
        dataType: "Number",
        validator: "number"
      },
      {
        headerName: "加权系数",
        headerWidth: 80,
        dataCode: "coe",
        hAlign: "right",
        dataType: "Number",
        validator: "number"
      }
    ],
    view: {
      lockColumns: ["code", "specs"],
      rowHeaderWidth: 25,
      colHeaderHeight: 36
    }
  },
  spread: null,
  sheet: null,
  datas: [],
  total: 0,
  options: [{
      code: "3005003",
      name: "电网电",
      specs: "",
      unit: "kW·h",
      type: "201"
    },
    {
      code: "8017001",
      name: "5kW以内柴油发电机组",
      specs: "5GF1",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017002",
      name: "15kW以内柴油发电机组",
      specs: "12GF1",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017003",
      name: "30kW以内柴油发电机组",
      specs: "30GFY-2",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017004",
      name: "50kW以内柴油发电机组",
      specs: "50GFY-2",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017005",
      name: "75kW以内柴油发电机组",
      specs: "75GFY-4",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017006",
      name: "100kW以内柴油发电机组",
      specs: "90GFZ",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017007",
      name: "120kW以内柴油发电机组",
      specs: "120GFY-4",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017008",
      name: "160kW以内柴油发电机组",
      specs: "160GF",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017009",
      name: "200kW以内柴油发电机组",
      specs: "200GF",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017010",
      name: "250kW以内柴油发电机组",
      specs: "250GF4-4",
      unit: "台班",
      type: "301"
    },
    {
      code: "8017011",
      name: "320kW以内柴油发电机组",
      specs: "320GF-2",
      unit: "台班",
      type: "301"
    }
  ],
  initSpread: function () {
    if (this.spread) return this.spread.refresh();
    this.spread = SheetDataHelper.createNewSpread($("#electrovalence_sheet")[0]);
    sheetCommonObj.spreadDefaultStyle(this.spread);
    this.sheet = this.spread.getSheet(0);
    sheetCommonObj.initSheet(this.sheet, this.setting, 30);
    this.sheet.bind(GC.Spread.Sheets.Events.SelectionChanged, this.onElectrovalenceSelectionChange);
    this.sheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onElectrovalenceValueChange);
    this.sheet.bind(GC.Spread.Sheets.Events.EditStarting, this.onElectrovalenceEditStarting);
    this.sheet.name('electrovalence_sheet');
    if (projectReadOnly) {
      sheetCommonObj.disableSpread(this.spread);
    }
  },
  showDatas: function (datas) {
    let sel = this.sheet.getSelections()[0];
    let oldData = sel.row < this.datas.length ? this.datas[sel.row] : "";
    this.sheet.setRowCount(0);
    this.datas = datas ? datas : this.getElectrovalenceDatas();
    this.calcPertElectrovalenceMarketPrice(this.datas);
    sheetCommonObj.showData(this.sheet, this.setting, this.datas);
    this.sheet.setRowCount(this.datas.length + 1);
    let nameCol = _.findIndex(this.setting.header, {
      'dataCode': 'displayName'
    });
    let nameOptions = this.getElectrovalenceOptions();
    sheetCommonObj.setComboBox(-1, nameCol, this.sheet, nameOptions, false, false, 5);
    sel.row = oldData ? _.findIndex(this.datas, {
      'ID': oldData.ID
    }) : sel.row;
    this.sheet.setSelection(sel.row == -1 ? 0 : sel.row, sel.col, sel.rowCount, sel.colCount);
  },
  getElectrovalenceDatas: function (ext, tcom_electrovalence, tgljList) {
    let datas = [];
    let pgljMap = {};
    let com_electrovalence = tcom_electrovalence ? tcom_electrovalence : projectObj.project.projectGLJ.datas.com_electrovalence;
    let gljList = tgljList ? tgljList : projectObj.project.projectGLJ.datas.gljList;
    for (let pg of gljList) {
      pgljMap[gljUtil.getIndex(pg)] = pg;
    }
    if (com_electrovalence && com_electrovalence.gljList) {
      for (let g of com_electrovalence.gljList) {
        let t = this.createNewElectrovalenceData(g);
        let tg = pgljMap[gljUtil.getIndex(g)];
        if (tg) gljOprObj.setGLJPrice(t, tg, false, ext);
        datas.push(t);
      }
    }
    return datas;
  },
  createNewElectrovalenceData: function (g) { //只是拷贝一份
    let t = {
      ID: g.ID,
      GLJID: g.GLJID,
      projectGLJID: g.projectGLJID,
      name: g.name,
      displayName: g.displayName,
      code: g.code,
      specs: g.specs,
      unit: g.unit,
      type: g.type,
      coe: g.coe,
      from: g.from
    };
    return t;
  },

  calcPertElectrovalenceMarketPrice: function (datas, ext) {
    let total = 0;
    for (let d of datas) {
      if (ext && ext[d.projectGLJID] && gljUtil.isDef(ext[d.projectGLJID].marketPrice)) d.marketPrice = ext[d.projectGLJID].marketPrice;
      if (d.name == "电网电") {
        d.electPrice = d.marketPrice;
      } else {
        let w = parseInt(d.name);
        if (!w) continue;
        let t = scMathUtil.roundForObj(d.marketPrice / w, getDecimal("process"));
        d.electPrice = scMathUtil.roundForObj(t * gljUtil.getElecCoe(), getDecimal("glj.unitPriceHasMix"));
      }
      let et = scMathUtil.roundForObj(d.electPrice * d.coe, getDecimal("process"));
      total = scMathUtil.roundForObj(et + total, getDecimal("process"));
    }
    this.total = scMathUtil.roundForObj(total, getDecimal("glj.unitPriceHasMix"));
    $("#electrovalenceLabel").text(`综合电价：${this.total}`);
    return this.total;
  },
  clacNewElecPrice: function (ext) {
    for (let g of projectObj.project.projectGLJ.datas.gljList) {
      if (g.code == gljUtil.getElecCode() && g.name == "电" && g.unit == "kW·h") { //更新电价
        let datas = this.getElectrovalenceDatas(ext);
        if (datas.length > 0) {
          let marketPrice = this.calcPertElectrovalenceMarketPrice(datas, ext);
          if (marketPrice && g.unit_price.market_price != marketPrice + '') return {
            projectGLJID: g.id,
            id: g.unit_price.id,
            'unit_price_file_id': g.unit_price.unit_price_file_id,
            doc: {
              'market_price': marketPrice + ''
            }
          }
        }
      }
    }
    return null;
  },
  getElectrovalenceOptions: function () {
    return _.map(this.options, "name")
  },
  onElectrovalenceSelectionChange: function (sender, args) {
    args.sheet.repaint();
  },
  onElectrovalenceEditStarting: function (sender, args) {
    let me = electrovalenceObj;
    let dataCode = me.setting.header[args.col].dataCode;
    if (dataCode == "electPrice") { //除电网电外，不可修改
      let cancel = true;
      if (me.datas[args.row] && me.datas[args.row].name == "电网电") cancel = false;
      args.cancel = cancel;
    }
  },


  onElectrovalenceValueChange: function (sender, args) {
    let me = electrovalenceObj;
    let dataCode = me.setting.header[args.col].dataCode;
    let value = args.newValue;
    if (dataCode == "displayName" && args.row >= me.datas.length) { //新增
      me.addElectrovalence(value);
    } else { //修改
      let tem = me.datas[args.row];
      if (value && !sheetCommonObj.checkData(args.col, me.setting, value)) {
        alert('输入的数据类型不对，请重新输入!');
        return me.showDatas(me.datas);
      }
      if (dataCode == 'coe' || dataCode == 'electPrice') {
        let dec = dataCode == 'coe' ? getDecimal("process") : getDecimal("glj.unitPrice");
        if (value) {
          value = scMathUtil.roundForObj(value, dec);
        }
        tem[dataCode] = value;
        if (dataCode == 'electPrice') tem.marketPrice = value;
      } else if (dataCode == 'displayName') { //下拉替换
        me.editElectrovalence(value, args.row, "replace");
      }
      me.showDatas(me.datas);
    }
  },
  addElectrovalence: async function (name) {
    this.editElectrovalence(name);
  },
  editElectrovalence: async function (name, row, type = "add") {
    //新建项目的时候，电已经默认生成了，所以不用考考虑电没有的情况
    try {
      let glj = _.find(this.options, {
        name: name
      });
      if (glj) {
        let tem = {
          displayName: glj.name,
          code: glj.code,
          specs: glj.specs,
          unit: glj.unit,
          type: glj.type,
          projectID: projectObj.project.ID()
        };
        tem.ID = uuid.v1();
        $.bootstrapLoading.start();
        let result = await ajaxPost('/glj/insertElectrovalence', tem);
        //插入项目工料机列表
        if (type == "add" && (!result.projetcGLJData || result.projetcGLJData.length == 0)) {
          alert("没有找到该工料机，请检查工料机库");
          return this.showDatas(this.datas);
        }
        let newProjectPGJ = projectObj.project.projectGLJ.loadNewProjectGLJToCache(result.projetcGLJData);
        //加入综合电价显示列表缓存
        tem.GLJID = result.projetcGLJData.glj_id;
        tem.projectGLJID = result.projetcGLJData.id;
        tem.name = result.projetcGLJData.name;
        tem.coe = 0;
        tem.from = "std";
        gljOprObj.setGLJPrice(tem, newProjectPGJ);

        if (type == "add") {
          this.datas.push(tem);
        } else { //除了添加的就是替换
          if (this.datas[row]) this.datas[row] = tem;
        }
        this.showDatas(this.datas);
      }
    } catch (e) {
      console.log(e)
    } finally {
      //materialCalcObj.showDatas();
      $.bootstrapLoading.end();
    }
  },
  getGljListFromDatas: function (datas) {
    let gljList = [];
    for (let d of datas) {
      gljList.push(this.createNewElectrovalenceData(d));
    }
    return gljList;
  },
  updateElectrovalence: function () {
    let updateMap = {};
    let dwd = null; //电网电
    let com_electrovalence = projectObj.project.projectGLJ.datas.com_electrovalence;
    if (com_electrovalence) { //存在则是更新
      updateMap['electrovalence'] = {
        actionType: 'update',
        ID: com_electrovalence.ID,
        doc: {
          gljList: this.getGljListFromDatas(this.datas)
        }
      };
    } else { //不存在则是新增
      updateMap['electrovalence'] = {
        actionType: 'add',
        doc: {
          unit_price_file_id: projectObj.project.property.unitPriceFile.id,
          gljList: this.getGljListFromDatas(this.datas)
        }
      };
      updateMap['electrovalence']['doc'].ID = uuid.v1();
    }
    for (let t of this.datas) {
      if (t.name == '电网电') {
        dwd = t;
      }
    }
    let unitPrices = [];
    for (let g of projectObj.project.projectGLJ.datas.gljList) {
      if (dwd && g.id == dwd.projectGLJID) {
        if (g.unit_price.market_price != dwd.electPrice + '') {
          let t_unitPrice = {
            projectGLJID: g.id,
            id: g.unit_price.id,
            'unit_price_file_id': g.unit_price.unit_price_file_id,
            doc: {
              'market_price': dwd.electPrice + ""
            }
          };
          unitPrices.push(t_unitPrice);
        }
      }
      if (g.code == gljUtil.getElecCode() && g.name == "电" && g.unit == "kW·h") { //更新电价
        if (g.unit_price.market_price != this.total + '') {
          let d_unitPrice = {
            projectGLJID: g.id,
            id: g.unit_price.id,
            'unit_price_file_id': g.unit_price.unit_price_file_id,
            doc: {
              'market_price': this.total + ''
            }
          };
          unitPrices.push(d_unitPrice);
        }
      }
    }
    if (unitPrices.length > 0) updateMap["unitPrice"] = unitPrices;
    this.submitElectrovalenceChange(updateMap)
  },
  submitElectrovalenceChange: async function (updateMap) {
    try {
      if (!_.isEmpty(updateMap)) {
        $.bootstrapLoading.start();
        let result = await ajaxPost('/glj/updateElectrovalence', updateMap);
        projectObj.project.projectGLJ.refreshEctrovalenceCache(updateMap);
      }
    } catch (e) {
      console.log(e)
    } finally {
      $.bootstrapLoading.end();
    }

  }


};

$(function () {

  $("#electrovalenceDiv").on('shown.bs.modal', function () {
    electrovalenceObj.initSpread();
    electrovalenceObj.showDatas();
  });

  $("#removeElectrovalencec").click(function () {
    let record = sheetCommonObj.getSelectedRecode(electrovalenceObj.sheet, electrovalenceObj.datas);
    if (record) {
      _.remove(electrovalenceObj.datas, {
        'ID': record.ID
      });
      electrovalenceObj.showDatas(electrovalenceObj.datas);
    }
  });

  $("#electrovalencecConfirm").click(function () {
    electrovalenceObj.updateElectrovalence();
  })
});