ConstructionCost/web/building_saas/glj/js/project_glj_spread.js

/**
 * 项目工料机相关spread
 *
 * @author CaiAoLin
 * @date 2017/7/19
 * @version
 */

/**
 * 构造函数
 *
 * @return {void}
 */
function ProjectGLJSpread() {
    this.isChanging = false;
    this.sheetObj = null;
    this.firstMachineRow = -1;
    this.firstMixRatioRow = -1;
    this.successCallback = null;
    this.supplyType = ['自行采购', '部分甲供', '完全甲供', '甲定乙供'];
    this.supplyComboMap = supplyComboMap
    // 工料机类型是混凝土、砂浆、配合比、机械(不包括机械组成物)时，供货方式列只读。
    this.supplyReadonlyType = notEditType;
}

/**
 * 初始化
 *
 * @return {object}
 */
ProjectGLJSpread.prototype.init = function () {
    // 供货方式类型
    let supplySelect = [];
    for(let comM of this.supplyComboMap) {
        supplySelect.push({
            text: comM.text,
            value: comM.value
        });
    }
    let selectBox = new GC.Spread.Sheets.CellTypes.ComboBox();
    selectBox.items(supplySelect);
    selectBox.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.value);
    let header = [
        {name: '编码', field: 'code', visible: true,width:80},
        {name: '名称', field: 'name', visible: true,width:160},
        {name: '规格型号', field: 'specs', visible: true,width:120},
        {name: '单位', field: 'unit', visible: true,width:45},
        {name: '类型', field: 'short_name', visible: true,width:45},
        {name: '类型', field: 'unit_price.type', visible: false},
        {name: '总消耗量', field: 'quantity', visible: true,width:100,decimalField:'glj.quantity'},
        {name: '定额价', field: "base_price", visible: true,width:70,decimalField:"glj.unitPrice",validator: 'number'},//这里feiedID设置是为了在计不计取价差的时候做显示用
        {name: '调整价', field: 'adjust_price', visible: true,width:70,decimalField:"glj.unitPrice"},
        {name: '市场价', field: "unit_price.market_price", visible: true, validator: 'number',width:70,decimalField:"glj.unitPrice"},
        {
            name: '是否暂估',
            field: 'is_evaluate',
            visible: true,
            cellType: new GC.Spread.Sheets.CellTypes.CheckBox(),
            validator: 'boolean'
            ,width:60
        },
        {name: '供货方式', field: 'supply', visible: true, cellType: selectBox,width:80},
        {name: '甲供数量', field: 'supply_quantity',validator:'number', visible: true,width:100},
        {name: '交货方式', field: 'delivery', visible: true,width:90},
        {name: '送达地点', field: 'delivery_address', visible: true,width:100},
        {
            name: '不调价',
            field: 'is_adjust_price',
            visible: true,
            cellType: new GC.Spread.Sheets.CellTypes.CheckBox(),
            validator: 'boolean',
            width:55
        },
        {name: 'UID', field: 'unit_price.id', visible: false},
        {name: '工料机ID', field: 'glj_id', visible: false},
        {name: '组成物消耗量', field: 'consumption', visible: false},
        {name: '父级关联编码', field: 'connect_code', visible: false},
        {name: '组成物信息', field: 'ratio_data', visible: false},
        {name: '分部分项总消耗量', field: 'subdivisionQuantity', visible: false,width:100,decimalField:'glj.quantity'},
        {name: '技术措施项目总消耗量', field: 'techQuantity', visible: false,width:100,decimalField:'glj.quantity'},
        {name: 'ID', field: 'id', visible: false}
    ];
    let sourceData = jsonData;

    this.sheetObj = new CommonSpreadJs(header);
    this.sheetObj.init('project-glj');

    // 获取列号
    let isEvaluateColumn = this.sheetObj.getFieldColumn('is_evaluate');
    let isAdjustPriceColumn = this.sheetObj.getFieldColumn('is_adjust_price');
    let unitColumn = this.sheetObj.getFieldColumn('unit');
    let quantityColumn = this.sheetObj.getFieldColumn('quantity');
    let basePriceColumn = this.sheetObj.getFieldColumn('base_price');
    let adjustPriceColumn = this.sheetObj.getFieldColumn('adjust_price');
    let marketPriceColumn = this.sheetObj.getFieldColumn('unit_price.market_price');
    let supplyColumn = this.sheetObj.getFieldColumn('supply');
    let shortNameColumn = this.sheetObj.getFieldColumn('unit_price.short_name');
    let supplyQuantity = this.sheetObj.getFieldColumn('supply_quantity');
    let nameColumn = this.sheetObj.getFieldColumn('name');
    let specsColumn = this.sheetObj.getFieldColumn('specs');

    //左对齐样式
    let leftStyleSetting = {hAlign: GC.Spread.Sheets.HorizontalAlign.left};
    this.sheetObj.setStyle(-1, nameColumn, leftStyleSetting);
    this.sheetObj.setStyle(-1, specsColumn, leftStyleSetting);

    // 居中样式
    let centerStyleSetting = {hAlign: 1};
    this.sheetObj.setStyle(-1, isEvaluateColumn, centerStyleSetting);
    this.sheetObj.setStyle(-1, isAdjustPriceColumn, centerStyleSetting);
    this.sheetObj.setStyle(-1, unitColumn, centerStyleSetting);
    this.sheetObj.setStyle(-1, shortNameColumn, centerStyleSetting);

    // 向右对齐样式
    let rightStyleSetting = {hAlign: GC.Spread.Sheets.HorizontalAlign.right};
    this.sheetObj.setStyle(-1, quantityColumn, rightStyleSetting);
    this.sheetObj.setStyle(-1, basePriceColumn, rightStyleSetting);
    this.sheetObj.setStyle(-1, adjustPriceColumn, rightStyleSetting);
    this.sheetObj.setStyle(-1, marketPriceColumn, rightStyleSetting);
    this.sheetObj.setStyle(-1, supplyColumn, rightStyleSetting);
    this.sheetObj.setStyle(-1, supplyQuantity, rightStyleSetting);

    // 设置可编辑列
    this.sheetObj.setColumnEditable(basePriceColumn);
    this.sheetObj.setColumnEditable(marketPriceColumn);
    this.sheetObj.setColumnEditable(isEvaluateColumn);
    this.sheetObj.setColumnEditable(isAdjustPriceColumn);
    this.sheetObj.setColumnEditable(supplyColumn);
    this.sheetObj.setData(sourceData);
    // 取消正在加载字符提示
    $("#project-glj > p").hide();
    this.specialColumn(sourceData);

    // 绑定修改事件
    let self = this;
    this.sheetObj.bind(GC.Spread.Sheets.Events.ValueChanged, function(element, info) {
        self.updateProjectGLJField(info, self.successCallback);
    });

    // 绑定双击事件
    this.sheetObj.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (element, info) {
        let column = info.col;
        let row = info.row;
        let field = self.sheetObj.getColumnField(column);
        let activeSheet = self.sheetObj.getSheet();

        // 获取类型
        let typeColumn = self.sheetObj.getFieldColumn('unit_price.type');
        let type = activeSheet.getValue(row, typeColumn);

        let ratioColumn = self.sheetObj.getFieldColumn('ratio_data');
        let ratioData = activeSheet.getValue(row, ratioColumn);

        // 如果类型为混凝土、砂浆、配合比、机械，则提示
        if (field === 'unit_price.market_price' && canNotChangeTypeId.indexOf(type) >= 0) {
            if(ratioData&&ratioData.length>0){
                alert('当前工料机的市场单价由组成物计算得出，不可直接修改');
            }
        }
    });


    return this.sheetObj;
};

/**
 * 更新项目工料机中的数据字段
 *
 * @param {object} info
 * @param {function} callback
 * @return {void|boolean}
 */
ProjectGLJSpread.prototype.updateProjectGLJField = function(info, callback) {
    // 获取修改的数据
    let column = info.col;
    let row = info.row;
    let idString = 'id';
    let field = projectGLJSheet.getColumnField(column);

    if (field === '') {
        return false;
    }
    let activeSheet = projectGLJSheet.getSheet();

    // 切割字段
    let fieldArray = field.split('.');
    idString = fieldArray.length > 1 ? 'unit_price.id' : idString;

    // 防止快速同时提交
    if (isChanging) {
        return false;
    }

    // 校验数据
    let value = info.newValue;
    if (!projectGLJSheet.checkData(column, value)) {
        alert('输入的数据类型不对，请重新输入!');
        activeSheet.setValue(row, column, info.oldValue);
        return false;
    }

    // 获取id
    let idColumn = projectGLJSheet.getFieldColumn(idString);
    if (idColumn < 0) {
        return false;
    }
    let id = activeSheet.getValue(row, idColumn);

    // 直接在前端计算后传值后台改
    let extend = {};
/*    let updateRecord = jsonData[row];  这时修改成在后端计算后直接更新，因为还要重新计算受影响的清单节点
    let parentMarketPrice = projectGLJSpread.compositionCalculate(updateRecord);
    if (parentMarketPrice !== null && Object.keys(parentMarketPrice).length > 0) {
        for (let activeCode in parentMarketPrice) {
            let tmpObject = {
                market_price: parentMarketPrice[activeCode],
            };
            extend[activeCode] = tmpObject;
        }
    }*/

    // 如果是供货方式则需要处理数据
    if (field === 'supply') {
        // value = this.supplyType.indexOf(value);
        extend.supply_quantity = this.getSupplyQuantity(value, activeSheet, info);
    }
    if(field === 'supply_quantity'){//修改数量需做4舍5入
        value= value.toDecimal(getDecimal('glj.quantity'));
    }
    if(field === 'unit_price.market_price'||field === 'base_price'){
        value= scMathUtil.roundForObj(value,getDecimal('glj.unitPrice'));//修改市场价和修改定额价时需要重新记算很多受影响的树节点，现在改成与定字额工料机那里调相同的方法。
        let editField = field === 'base_price'?field:"market_price";
        projectObj.project.projectGLJ.updatePrice(jsonData[row],editField,value);
        return;
    }
    extend = Object.keys(extend).length > 0 ?  JSON.stringify(extend) : '';
    this.postUpdate(id,field,value,info,extend,callback);
};

ProjectGLJSpread.prototype.postUpdate=function (id,field,value,info,extend,callback) {
    $.bootstrapLoading.start();
    $.ajax({
        url: '/glj/update',
        type: 'post',
        data: {id: id, field: field, value: value, extend: extend},
        dataType: 'json',
        error: function() {
            alert('数据传输有误!');
            isChanging = false;
        },
        beforeSend: function() {
            isChanging = true;
        },
        success: function(response) {
            isChanging = false;
            // 修改失败则恢复原值
            if (response.err !== 0&&info.fromRG!=true) {
                projectGLJSheet.getSheet().setValue(info.row, info.col, info.oldValue);
                alert('更改数据失败!');
            } else {
                // 成功则触发相应事件
                /* if (parentMarketPrice !== null) {
                 info.parentMarketPrice = parentMarketPrice;
                 }*/
                if(field !== 'supply'&&info.fromRG!=true){ //供货方式需做转换才能直接设置值， 这里设置值是为了早点更新数据，等getdata返回数据再刷新的话会有比较大的延时
                    projectGLJSheet.getSheet().setValue(info.row, info.col, value);
                }
                callback(field, info,id);
            }
        }
    });


}


/**
 * 设置特殊单元格数据
 *
 * @param {object} sourceData
 * @return {void}
 */
ProjectGLJSpread.prototype.specialColumn = function (sourceData) {
    let rowCounter = 0;
    // 获取列号
    let isEvaluateColumn = this.sheetObj.getFieldColumn('is_evaluate');
    let marketPriceColumn = this.sheetObj.getFieldColumn('unit_price.market_price');
    let basePriceColumn = this.sheetObj.getFieldColumn('base_price');
    let adjustPriceColumn = this.sheetObj.getFieldColumn("adjust_price");
    let connectCodeColumn = this.sheetObj.getFieldColumn('connect_code');
    let consumptionColumn = this.sheetObj.getFieldColumn('consumption');
    let supplyColumn = this.sheetObj.getFieldColumn('supply');
    let shortNameColumn = this.sheetObj.getFieldColumn('short_name');
    let supplyQuantity = this.sheetObj.getFieldColumn('supply_quantity');
    let activeSheet = this.sheetObj.getSheet();

    for (let data of sourceData) {
        let rowStyle = null;
        //设置类型名称：
        activeSheet.setValue(rowCounter, shortNameColumn,projectObj.project.projectGLJ.getShortNameByID(data.unit_price.type));
        // 只有材料才显示是否暂估
        if (materialIdList.indexOf(data.unit_price.type) < 0) {
            let string = new GC.Spread.Sheets.CellTypes.Text();
            activeSheet.setCellType(rowCounter, isEvaluateColumn, string, GC.Spread.Sheets.SheetArea.viewport);

            // 锁定该单元格
            activeSheet.getCell(rowCounter, isEvaluateColumn, GC.Spread.Sheets.SheetArea.viewport).locked(true);
            activeSheet.setValue(rowCounter, isEvaluateColumn, '');
        }else {
            let checkBox = new GC.Spread.Sheets.CellTypes.CheckBox();
            activeSheet.setCellType(rowCounter, isEvaluateColumn, checkBox, GC.Spread.Sheets.SheetArea.viewport);
            activeSheet.getCell(rowCounter, isEvaluateColumn, GC.Spread.Sheets.SheetArea.viewport).locked(false);
            activeSheet.setValue(rowCounter, isEvaluateColumn, data.is_evaluate);
        }
       /* // 设置供货方式列是否可选
        if (this.supplyReadonlyType.indexOf(data.unit_price.type) >= 0) {
            // 锁定该单元格
            activeSheet.getCell(rowCounter, supplyColumn,  GC.Spread.Sheets.SheetArea.viewport).locked(true);
        }*/
        // 如果为部分甲供则甲供数量需要可编辑
        if (data.supply == 1) {
            activeSheet.getCell(rowCounter, supplyQuantity,  GC.Spread.Sheets.SheetArea.viewport).locked(false);
        }
        //供货方式为完全甲供时设置甲供数量为总消耗量
        if (data.supply == 2) {
            activeSheet.setValue(rowCounter, supplyQuantity,  data.quantity);
        }
        // 供货方式数据
        let supplyIndex = parseInt(data.supply);
        supplyIndex = isNaN(supplyIndex) ? 0 : supplyIndex;
        let supplyText = this.supplyType[supplyIndex] !== undefined ? this.supplyType[supplyIndex] : '自行采购';
        activeSheet.setValue(rowCounter, supplyColumn, supplyText);
        // activeSheet.setValue(rowCounter, supplyColumn, supplyIndex);

        // 如果类型为混凝土、砂浆、配合比、机械，则市场单价和供货方式不能修改
        if (canNotChangeTypeId.indexOf(data.unit_price.type) >= 0) {
            this.firstMixRatioRow = this.firstMixRatioRow === -1 && data.unit_price.type !== GLJTypeConst.GENERAL_MACHINE ?
                rowCounter : this.firstMixRatioRow;
            this.firstMachineRow = this.firstMachineRow === -1 && data.unit_price.type === GLJTypeConst.GENERAL_MACHINE ?
                rowCounter : this.firstMachineRow;
            // 锁定该单元格
            if (data.ratio_data  && data.ratio_data.length > 0){//有组成物时，市场单价、定额价、供货方式不能修改
                activeSheet.getCell(rowCounter, marketPriceColumn,  GC.Spread.Sheets.SheetArea.viewport).locked(true);
                activeSheet.getCell(rowCounter, basePriceColumn, GC.Spread.Sheets.SheetArea.viewport).locked(true);
                activeSheet.getCell(rowCounter, supplyColumn,  GC.Spread.Sheets.SheetArea.viewport).locked(true);
                //设置底色
                rowStyle = this.getRowStyle("#E0E0E0");
            }
        }
        if(data.unit_price.is_add!=1){//如果不是新增，定额价不可修改。
            activeSheet.getCell(rowCounter, basePriceColumn, GC.Spread.Sheets.SheetArea.viewport).locked(true);
        }

        // 处理数据
        if (data.ratio_data !== undefined && data.ratio_data.length > 0) {
            let connectCode = [];
            let consumption = [];
            for (let tmp of data.ratio_data) {
                connectCode.push(tmp.connect_key);
                consumption.push(tmp.consumption);
            }
            let connectCodeString = connectCode.join(',');
            let consumptionString = consumption.join(',');
            activeSheet.setValue(rowCounter, connectCodeColumn, connectCodeString);
            activeSheet.setValue(rowCounter, consumptionColumn, consumptionString);
        }
        data=this.sheetObj.setProjectGLJDiffPrice(data);
        activeSheet.setValue(rowCounter,basePriceColumn,data.base_price);
        activeSheet.setValue(rowCounter,adjustPriceColumn,data.adjust_price);
        if(rowStyle==null&&data.base_price == data.unit_price.market_price){//如果定额价等于市场价时，改底色。 优先度低于有组成物时的底色
            rowStyle = this.getRowStyle("#C4CAFB");
        }
        activeSheet.setStyle(rowCounter, -1, rowStyle);

        rowCounter++;
    }
};

ProjectGLJSpread.prototype.getRowStyle = function (bgColour) {
    let style = new GC.Spread.Sheets.Style();
    style.backColor = bgColour;
    style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
    style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
    style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
    style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
    return style;
};

/**
 * 计算当前行对应组成物的市场以及基价单价价格
 *
 * @param {Number} row
 * @return {Object}
 */
ProjectGLJSpread.prototype.compositionCalculate = function(updateRecord) {
    let gljData = projectObj.project.projectGLJ.datas;
    let m_index = gljOprObj.getIndex(updateRecord,gljKeyArray);
    let parent_connect_keys = gljData.mixRatioConnectData[m_index];
    if(!parent_connect_keys||parent_connect_keys.length<=0){// 不属于组成物则忽略
        return null;
    }
    let q_decimal = getDecimal("glj.quantity");
    let p_decimal = getDecimal("glj.unitPrice");
    let parentMarketPrice = {};
    for(let p  of parent_connect_keys) {
        let mix_ratios = gljData.mixRatioMap[p];
        let sum = 0;
        for (let m of mix_ratios) {
            let unitPrice = this.sheetObj.getUnitPrice(m);
            if (unitPrice) {
                let com = scMathUtil.roundForObj(m.consumption, q_decimal);
                let marketPrice = scMathUtil.roundForObj(unitPrice.market_price, p_decimal);
                sum = scMathUtil.roundForObj(marketPrice * com + sum, p_decimal);
            }
        }
        parentMarketPrice[p]=sum;
    }
    return parentMarketPrice;
};

/**
 * 组成物父类数据更新
 *
 * @param {Object} parentMarketPrice
 * @return {void}
 */
ProjectGLJSpread.prototype.compositionParentUpdate = function(parentMarketPrice) {
    let marketPriceColumn = this.sheetObj.getFieldColumn('unit_price.market_price');
    let activeSheet = this.sheetObj.getSheet();
    // 定位到父节点，然后更新
    for (let code in parentMarketPrice) {
        let changeRow = this.sheetObj.searchKeyword(code);
        activeSheet.setValue(changeRow, marketPriceColumn, parentMarketPrice[code]);
    }
};

/**
 * 价格计算
 *
 * @param {Object} info
 * @return {void}
 */
ProjectGLJSpread.prototype.priceCalculate = function(info) {
    let row = info.row;
    let typeColumn = this.sheetObj.getFieldColumn('unit_price.type');
    let basePriceColumn = this.sheetObj.getFieldColumn('base_price');
    let adjustPriceColumn = projectGLJSheet.getFieldColumn('adjust_price');
    let activeSheet = this.sheetObj.getSheet();

    // 获取类型
    let type = activeSheet.getValue(row, typeColumn);
  /*  let data = jsonData[row];
    if(gljOprObj.calcPriceDiff(data)==true){//是否记算价差
        data.base_price = data.unit_price.base_price;
        data.adjust_price = projectObj.project.projectGLJ.getAdjustPrice(data);
    }else {
        data.base_price = data.unit_price.market_price;
        data.adjust_price = data.unit_price.market_price;
    }
    activeSheet.setValue(info.row,basePriceColumn,data.base_price);
    activeSheet.setValue(info.row,adjustPriceColumn,data.adjust_price);*/


  /*  // 基价单价计算
    switch (type) {
        // 主材、设备自动赋值基价单价=市场单价
        case GLJTypeConst.MAIN_MATERIAL:
        case GLJTypeConst.EQUIPMENT:
            activeSheet.setValue(info.row, basePriceColumn, info.newValue);
            break;
    }*/

 /*   // 调整基价计算
    switch (type) {
        // 材料、主材、设备 调整基价=基价单价
        case GLJTypeConst.MAIN_MATERIAL:
        case GLJTypeConst.EQUIPMENT:
            let basePrice = activeSheet.getValue(info.row, basePriceColumn);
            activeSheet.setValue(info.row, adjustPriceColumn, basePrice);
            break;

    }*/

    // 市场单价计算
    switch (type) {
        // 人工、材料(普通材料)触发 需计算混凝土、砂浆、配合比、机械的市场单价
        case GLJTypeConst.LABOUR:
        case GLJTypeConst.GENERAL_MATERIAL:
            // 计算
            this.compositionParentUpdate(info.parentMarketPrice);
            break;
    }
};

/**
 * 更改供货方式
 *
 * @param {Object} info
 * @return {void}
 */
ProjectGLJSpread.prototype.changeSupplyType = function(info) {
    // let supply = info.newValue;
    // let supplyNumber = this.supplyType.indexOf(supply) > -1 ? this.supplyType.indexOf(supply) : 0;
    let supplyNumber = info.newValue;
    let supplyQuantityColumn = this.sheetObj.getFieldColumn('supply_quantity');
    let activeSheet = this.sheetObj.getSheet();

    // 部分甲供时可更改甲供数量数据,其余则只读
    let locked = supplyNumber == 1 ? false : true;
    activeSheet.getCell(info.row, supplyQuantityColumn,  GC.Spread.Sheets.SheetArea.viewport).locked(locked);

    let supplyQuantity = this.getSupplyQuantity(supplyNumber, activeSheet, info);
    activeSheet.setValue(info.row, supplyQuantityColumn, supplyQuantity);
};

/**
 * 根据供货方式获取甲供数量
 *
 * @param {Number} supplyType
 * @param {Object} activeSheet
 * @param {Object} info
 * @return {Number}
 */
ProjectGLJSpread.prototype.getSupplyQuantity = function(supplyType, activeSheet, info) {
    let quantityColumn = this.sheetObj.getFieldColumn('quantity');
    // 获取总消耗量
    let quantity = activeSheet.getValue(info.row, quantityColumn);
    // 自行采购和甲定乙供则把甲供数量设置为0，其余情况则设置为当前总消耗量
    let supplyQuantity = supplyType == 0 || supplyType == 3 ? 0 : quantity;
    supplyQuantity = parseFloat(supplyQuantity);

    return supplyQuantity;
};