ConstructionCost/web/glj/js/glj_index.js

/**
 * 工料机汇总相关
 *
 * @author CaiAoLin
 * @date 2017/6/15
 * @version
 */
let header = [];
let gljSheet = null;
let sourceData = [];
let spread = null;
let isChanging = false;
let gljActiveRowIndex = 0;
$(document).ready(function () {

    // 初始化表格
    initExcel();

    // 是否主动更改数据
    $("#message").on('click', '#load-data', function() {
        $("#notify").slideUp('fast');
        if (changeInfo.length > 0) {
            for (let index in changeInfo) {
                let cell = sheet.getCell(changeInfo[index].row, changeInfo[index].col, GC.Spread.Sheets.SheetArea.viewport);
                cell.value(changeInfo[index].newValue);
            }
        }
        changeInfo = [];
    });

});

/**
 * 初始化表格
 *
 */
function initExcel() {
    header = [
        {name: '编码', field: 'code', visible: true},
        {name: '名称', field: 'name', visible: true},
        {name: '规格型号', field: 'unit_price.specs', visible: true},
        {name: '单位', field: 'unit_price.unit', visible: true},
        {name: 'ID', field: 'id', visible: false},
        {name: '类型', field: 'unit_price.type', visible: false},
        {name: '总消耗量', field: 'quantity', visible: true},
        {name: '基价单价', field: "unit_price.base_price", visible: true},
        {name: '调整基价', field: 'adjust_price', visible: true},
        {name: '市场单价', field: "unit_price.market_price", visible: true, validator: 'number'},
        {name: '是否暂估', field: 'is_evaluate', visible: true, cellType: new GC.Spread.Sheets.CellTypes.CheckBox(),  validator: 'boolean'},
        {name: '供货方式', field: 'supply', visible: true},
        {name: '甲供数量', field: 'supply_quantity', visible: true},
        {name: '交货方式', field: 'delivery', visible: true},
        {name: '送达地点', field: 'delivery_address', visible: true},
        {name: '不调价', field: 'is_adjust_price', visible: true, cellType: new GC.Spread.Sheets.CellTypes.CheckBox(),  validator: 'boolean'},
        {name: 'UID', field: 'unit_price.id', visible: false},
    ];
    // 数据转换格式
    sourceData = JSON.parse(jsonData);
    let columnInfo = [];
    let setting = {
        header: []
    };
    for(let tmp of header) {
        setting.header.push({headerName: tmp.name, headerWidth: 120});
        columnInfo.push({name: tmp.field, displayName: tmp.name, visible: tmp.visible, cellType: tmp.cellType, size: 120});
    }

    spread = sheetCommonObj.buildSheet(document.getElementById("project-glj"), setting, sourceData.length);
    spread.options.scrollbarShowMax = true;
    spread.options.scrollbarMaxAlign = true;
    spread.options.showHorizontalScrollbar = true;
    gljSheet = spread.getActiveSheet();

    // 设置表单不可编辑
    gljSheet.options.isProtected = true;

    // 居中样式
    let centerStyleSetting = {hAlign: 1};
    gljSheet.setStyle(-1, 10, getStyle(centerStyleSetting), GC.Spread.Sheets.SheetArea.viewport);
    gljSheet.setStyle(-1, 15, getStyle(centerStyleSetting), GC.Spread.Sheets.SheetArea.viewport);
    gljSheet.setStyle(-1, 3, getStyle(centerStyleSetting), GC.Spread.Sheets.SheetArea.viewport);

    // 向右对齐样式
    let rightStyleSetting = {hAlign: GC.Spread.Sheets.HorizontalAlign.right};
    gljSheet.setStyle(-1, 6, getStyle(rightStyleSetting), GC.Spread.Sheets.SheetArea.viewport);
    gljSheet.setStyle(-1, 7, getStyle(rightStyleSetting), GC.Spread.Sheets.SheetArea.viewport);
    gljSheet.setStyle(-1, 8, getStyle(rightStyleSetting), GC.Spread.Sheets.SheetArea.viewport);
    gljSheet.setStyle(-1, 9, getStyle(rightStyleSetting), GC.Spread.Sheets.SheetArea.viewport);


    // 设置可编辑列
    gljSheet.getRange(-1, 9, -1, 1).locked(false);
    gljSheet.getRange(-1, 10, -1, 1).locked(false);
    gljSheet.getRange(-1, 15, -1, 1).locked(false);

    // 设置数据
    gljSheet.autoGenerateColumns = false;
    gljSheet.bindColumns(columnInfo);
    gljSheet.setDataSource(sourceData);

    specialColumn(sourceData);

    // 绑定事件
    gljSheet.bind(GC.Spread.Sheets.Events.ValueChanged, updateBindEvent);

    // 绑定双击事件
    gljSheet.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (element, info) {
        let column = info.col;
        let row = info.row;
        let field = header[column] !== undefined && header[column].field !== undefined ?
            header[column].field : '';

        // 获取类型
        let typeColumn = getFieldColumn(header, 'unit_price.type');
        let type = gljSheet.getValue(row, typeColumn);

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

    // 绑定单击事件
    gljSheet.bind(GC.Spread.Sheets.Events.CellClick, function (element, info) {
        gljActiveRowIndex = gljSheet.getActiveRowIndex();
    });
}

/**
 * 生成样式
 *
 * @param {object} setting
 * @return {object}
 */
function getStyle(setting) {
    let style = new GC.Spread.Sheets.Style();
    style.locked = setting.readOnly === undefined ? true : setting.readOnly;
    style.hAlign = setting.hAlign === undefined ? GC.Spread.Sheets.HorizontalAlign.center : setting.hAlign;
    return style;
}

/**
 * 查找指定字段的列index
 *
 * @param {object} data
 * @param {String} field
 * @return {Number}
 */
function getFieldColumn(data, field) {
    let result = -1;
    if (data.length <= 0) {
        return result;
    }
    for (let tmp in data) {
        if (data[tmp].field === field) {
            result = tmp;
            break;
        }
    }

    return result;
}

/**
 * 校验数据
 *
 * @param {string} validator
 * @param {string} value
 * @return {boolean}
 */
function checkData(validator, value) {
    let result = false;
    switch (validator) {
        case 'number':
            let regular = /^\d+(\.\d+)?$/;
            result = regular.test(value);
            break;
        case 'boolean':
            let booleanValue = [true, false];
            result = booleanValue.indexOf(value) >= 0;
            break;
    }

    return result;
}

/**
 * 成功事件
 *
 * @param {string} field
 * @param {object} info
 * @return {void}
 */
function successTrigger(field, info) {
    switch (field) {
        case 'unit_price.market_price':
            let row = info.row;
            // 获取类型
            let typeColumn = getFieldColumn(header, 'unit_price.type');
            let type = gljSheet.getValue(row, typeColumn);

            // 基价单价的计算
            basePriceCalculate(type, info);
            // 调整基价的计算
            adjustPriceCalculate(type, info);
            // 市场单价的计算
            marketPriceCalculate(type, info);

            // 触发websocket通知
            socket.emit('dataNotify', JSON.stringify(info));
            break;
    }
}

/**
 * 设置特殊单元格数据
 *
 * @param {object} sourceData
 * @return {void}
 */
function specialColumn(sourceData) {
    let rowCounter = 0;
    // 获取是否暂估的列号
    let isEvaluateColumn = getFieldColumn(header, 'is_evaluate');
    // 获取市场单价列号
    let marketPriceColumn = getFieldColumn(header, 'unit_price.market_price');
    for(let data of sourceData) {
        // 只有材料才显示是否暂估
        if (materialIdList.indexOf(data.unit_price.type + '') < 0) {
            let string = new GC.Spread.Sheets.CellTypes.Text();
            gljSheet.setCellType(rowCounter, isEvaluateColumn, string, GC.Spread.Sheets.SheetArea.viewport);
            // 锁定该单元格
            gljSheet.getRange(rowCounter, isEvaluateColumn, 1, 1).locked(true);
            gljSheet.setValue(rowCounter, isEvaluateColumn, '');
        }
        // 如果类型为混凝土、砂浆、配合比、机械，则市场单价不能修改
        if (canNotChangeTypeId.indexOf(data.unit_price.type) >= 0) {
            // 锁定该单元格
            gljSheet.getRange(rowCounter, marketPriceColumn, 1, 1).locked(true);
        }
        rowCounter++;
    }
}


/**
 * 基价单价计算
 *
 * @param {Number} type
 * @param {object} info
 * @return {void}
 */
function basePriceCalculate(type, info) {
    let basePriceColumn = getFieldColumn(header, 'unit_price.base_price');
    switch (type) {
        // 主材、设备自动赋值基价单价=市场单价
        case GLJTypeConst.MAIN_MATERIAL:
        case GLJTypeConst.EQUIPMENT:
            gljSheet.setValue(info.row, basePriceColumn, info.newValue);
            break;
    }
}

/**
 * 调整基价计算
 *
 * @param {Number} type
 * @param {object} info
 * @return {void}
 */
function adjustPriceCalculate(type, info) {
    let basePriceColumn = getFieldColumn(header, 'unit_price.base_price');
    let adjustPriceColumn = getFieldColumn(header, 'adjust_price');
    switch (type) {
        // 材料、主材、设备 调整基价=基价单价
        case GLJTypeConst.MAIN_MATERIAL:
        case GLJTypeConst.EQUIPMENT:
            let basePrice = sheet.getValue(info.row, basePriceColumn);
            gljSheet.setValue(info.row, adjustPriceColumn, basePrice);
            break;

    }
}

/**
 * 市场单价计算
 *
 * @param {Number} type
 * @param {object} info
 * @return {void}
 */
function marketPriceCalculate(type, info) {
    switch (type) {
        // 人工、材料(普通材料)触发 需计算混凝土、砂浆、配合比、机械的市场单价 @todo 后续添加
        case GLJTypeConst.LABOUR:
        case GLJTypeConst.GENERAL_MATERIAL:
            // 计算
            console.log('触发计算');
            break;
    }
}

/**
 * 筛选数据
 *
 * @param {Array} typeList
 * @return {void}
 */
function filterDataByType(type) {
    sourceData = [];
    let testData = JSON.parse(jsonData);
    for(let tmp of testData) {
        if (type.indexOf(tmp.unit_price.type) >= 0) {
            sourceData.push(tmp);
        }
    }
    gljSheet.setDataSource(sourceData);
}

/**
 * 绑定事件
 *
 * @param {object} element
 * @param {object} info
 * @return {void|boolean}
 */
function updateBindEvent(element, info) {
    // 获取修改的数据
    let column = info.col;
    let row = info.row;
    let model = 'glj';
    let idString = 'id';
    let field = header[column] !== undefined && header[column].field !== undefined ?
        header[column].field : '';
    if (field === '') {
        return false;
    }

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

    // 防止快速同时提交
    if (isChanging) {
        return false;
    }
    // 校验数据
    let validator = header[column].validator !== undefined ? header[column].validator : null;
    let value = info.newValue;
    if (validator && !checkData(validator, value)) {
        alert('数据格式错误，请重新输入!');
        gljSheet.setValue(row, column, info.oldValue);
        return false;
    }

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

    $.ajax({
        url: '/glj/update',
        type: 'post',
        data: {id: id, field: field, value: value, model: model},
        dataType: 'json',
        error: function() {
            alert('数据传输有误!');
            isChanging = false;
        },
        beforeSend: function() {
            isChanging = true;
        },
        success: function(response) {
            isChanging = false;
            // 修改失败则恢复原值
            if (response.err !== 0) {
                gljSheet.setValue(row, column, info.oldValue);
                alert('更改数据失败!');
            } else {
                // 成功则触发相应事件
                successTrigger(field, info);
            }
        }
    });
}