Calculation/app/public/js/stage.js

'use strict';

/**
 * 期计量 - 本期计量台账页面 js
 *
 * @author Mai
 * @date 2018/12/7
 * @version
 */
function checkTzMeasureType () {
    return tender.measure_type === measureType.tz.value;
}

/**
 * 从cookie中读取缓存的列显示设置，没有则取默认
 * @returns {*[]}
 */
function customColDisplay () {
    const defaultSetting = [
        { title: '签约合同', fields: ['deal_qty', 'deal_tp'], visible: true },
        { title: '施工图复核', fields: ['quantity', 'total_price'], visible: true },
        { title: '本期计量合同', fields: ['contract_qty', 'contract_tp'], visible: true },
        { title: '本期数量变更', fields: ['qc_qty', 'qc_tp', 'qc_bgl'], visible: true },
        { title: '本期完成计量', fields: ['gather_qty', 'gather_tp'], visible: true },
        { title: '截止本期计量合同', fields: ['end_contract_qty', 'end_contract_tp'], visible: true },
        { title: '截止本期数量变更', fields: ['end_qc_qty', 'end_qc_tp', 'end_qc_bgl'], visible: true },
        { title: '截止本期完成计量', fields: ['end_gather_qty', 'end_gather_tp'], visible: true },
        { title: '图册号', fields: ['drawing_code'], visible: true },
        { title: '累计完成率(%)', fields: ['percent'], visible: true },
        { title: '备注', fields: ['memo'], visible: true },
    ];
    const settingStr = Cookies.get('stage-col-visible');
    return settingStr ? JSON.parse(settingStr) : defaultSetting;
}

/**
 * 根据列显示设置，调整setting中的列是否显示
 * @param setting
 * @param customDisplay
 */
function customizeStageTreeSetting(setting, customDisplay) {
    for (const cd of customDisplay) {
        for (const c of setting.cols) {
            if (cd.fields.indexOf(c.field) !== -1) {
                c.visible = cd.visible;
            }
        }
    }
}
/**
 * 初始化 树结构 列事件
 * @param setting
 */
function initTreeColSettingEvents(setting) {
    const Events = {
        readOnly: {
            measureData: function (node) {
                return node.children && node.children.length > 0;
            },
        },
    };
    const getEvent = function (eventName) {
        const names = eventName.split('.');
        let event = Events;
        for (let name of names) {
            if (event[name]) {
                event = event[name];
            } else {
                return null;
            }
        }
        if (event && Object.prototype.toString.apply(event) !== "[object Function]") {
            return null;
        } else {
            return event;
        }
    };

    for (const col of setting.cols) {
        if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
            col.readOnly = getEvent(col.readOnly);
        }
    }
}

$(document).ready(() => {
    // 界面布局
    autoFlashHeight();
    // 初始化 台账树结构 数据结构
    const stageTreeSetting = {
        id: 'ledger_id',
        pid: 'ledger_pid',
        order: 'order',
        level: 'level',
        rootId: -1,
        keys: ['id', 'tender_id', 'ledger_id'],
        stageId: 'id',
    };
    // 台账树结构计算相关设置
    stageTreeSetting.updateFields = ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'];
    stageTreeSetting.calcFields = ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp',
        'pre_contract_tp', 'pre_qc_tp', 'pre_gather_tp', 'end_contract_tp', 'end_qc_tp', 'end_gather_tp'];
    stageTreeSetting.calcFun = function (node) {
        if (node.children && node.children.length === 0) {
            node.pre_gather_qty = _.add(node.pre_contract_qty, node.pre_qc_qty);
            node.gather_qty = _.add(node.contract_qty, node.qc_qty);
            node.end_contract_qty = _.add(node.pre_contract_qty, node.contract_qty);
            node.end_qc_qty = _.add(node.pre_qc_qty, node.qc_qty);
            node.end_gather_qty = _.add(node.pre_gather_qty, node.gather_qty);
        }
        node.pre_gather_tp = _.add(node.pre_contract_tp, node.pre_qc_tp);
        node.gather_tp = _.add(node.contract_tp, node.qc_tp);
        node.end_contract_tp = _.add(node.pre_contract_tp, node.contract_tp);
        node.end_qc_tp = _.add(node.pre_qc_tp, node.qc_tp);
        node.end_gather_tp = _.add(node.pre_gather_tp, node.gather_tp);
        if (checkZero(node.dgn_qty1)) {
            node.dgn_price = _.round(node.total_price/node.dgn_qty1, 2);
        } else {
            node.dgn_price = null;
        }
    };
    const stageTree = createNewPathTree('stage', stageTreeSetting);
    // 初始化 部位明细 数据结构
    const stagePosSetting = {
        id: 'id', ledgerId: 'lid',
        updateFields: ['contract_qty', 'qc_qty', 'postil'],
    };
    stagePosSetting.calcFun = function (pos) {
        pos.pre_gather_qty = _.add(pos.pre_contract_qty, pos.pre_qc_qty);
        pos.gather_qty = _.add(pos.contract_qty, pos.qc_qty);
        pos.end_contract_qty = _.add(pos.pre_contract_qty, pos.contract_qty);
        pos.end_qc_qty = _.add(pos.pre_qc_qty, pos.qc_qty);
        pos.end_gather_qty = _.add(pos.pre_gather_qty, pos.gather_qty);
    };
    const stagePos = new StagePosData(stagePosSetting);

    class Changes {
        constructor(obj) {
            const self = this;
            this.obj = obj;
            // 初始化 清单编号窗口 参数
            this.spreadSetting = {
                cols: [
                    {title: '已用', field: '', width: 45, formatter: '@', cellType: 'image', readOnly: true, hAlign: 1, indent: 14},
                    {title: '变更令号', field: 'code', width: 100, formatter: '@', readOnly: true, hAlign: 0, },
                    {title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true, hAlign: 0,},
                    {title: '总数量', field: 'b_amount', width: 60, formatter: '@', readOnly: true, hAlign: 2, },
                    {title: '可变更数量', field: 'vamount', width: 60, readOnly: true, hAlign: 2, },
                    {title: '本期计量', field: 'uamount', width: 60, formatter: '@', hAlign: 2, },
                ],
                emptyRows: 0,
                headRows: 1,
                headRowHeight: [40],
            };
            this.spreadSetting.cols[0].img = function (data) {
                //return $('#icon-ok')[0];
                if (data.uamount && !checkZero(data.uamount)) {
                    return $('#icon-ok')[0];
                } else {
                    return null;
                }
            };
            this.curChangeId = '';
            this.spread = SpreadJsObj.createNewSpread($('#change-spread')[0]);
            this.firstView = true;
            SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
            // 初次显示，需刷新spread界面，保证界面绘制正确
            this.obj.bind('shown.bs.modal', function () {
                if (self.firstView) {
                    self.firstView = false;
                    self.spread.refresh();
                }
            });
            // 切换变更令，加载右侧明细数据
            this.spread.bind(spreadNS.Events.SelectionChanged, function (e, info) {
                const change = SpreadJsObj.getSelectObject(info.sheet);
                self._loadChangeDetail(change);
            });
            // 填写本期计量
            this.spread.bind(spreadNS.Events.EditEnded, function (e, info) {
                if (info.sheet.zh_setting) {
                    const col = info.sheet.zh_setting.cols[info.col];
                    const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
                    const node = sortData[info.row];
                    node[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
                    // 刷新已用提示
                    info.sheet.repaint(info.sheet.getCellRect(info.row, 0));
                }
            });
            this.spread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
                if (info.sheet.zh_setting) {
                    const sortData = SpreadJsObj.getSortData(info.sheet);
                    for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
                        const curRow = iRow + info.cellRange.row;
                        const curCol = info.cellRange.col;
                        const col = info.sheet.zh_setting.cols[info.cellRange.col];
                        sortData[curRow][col.field] = col.type === 'Number' ? _.toNumber(info.sheet.getText(curRow, curCol)) : info.sheet.getText(curRow, curCol);
                    }
                    SpreadJsObj.reLoadRowData(sheet, info.cellRange.row, sel.cellRange.rowCount);
                }
            });
            SpreadJsObj.addDeleteBind(this.spread, function (sheet) {
                if (sheet.zh_setting) {
                    const sel = sheet.getSelections()[0];
                    const sortData = SpreadJsObj.getSortData(sheet);
                    // 仅本期计量可删除
                    if (sel.col === 5 || sel.colCount === 1) {
                        const col = sheet.zh_setting.cols[sel.col];
                        for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
                            const data = sortData[iRow];
                            data[col.field] = null;
                        }
                        SpreadJsObj.reLoadRowData(sheet, sel.row, sel.rowCount);
                    }
                }
            });
            // 过滤可变更数量为0
            $('#customCheckDisabled').click(function () {
                self._filterEmptyChange(!this.checked);
            });
            $('#show-bgl-detail').bind('click', function () {
                const detail = $('#bgl-detail'), bgl=$('#bgl'), obj=$(this);
                if (detail.hasClass('col-4')) {
                    detail.attr('class', 'col').hide();
                    bgl.attr('class', 'col-12');
                    $('a', obj).attr('title', '展开侧栏');
                    $('i', obj).attr('class', 'fa fa-chevron-left');
                    self.spread.refresh();
                } else {
                    detail.attr('class', 'col-4').show();
                    bgl.attr('class', 'col-8');
                    $('a', obj).attr('title', '收起侧栏');
                    $('i', obj).attr('class', 'fa fa-chevron-right');
                    self.spread.refresh();
                }
            });
        }
        _loadChangeDetail(change) {
            if (change) {
                if (change.cid === this.curChangeId) { return; }

                this.curChangeId = change.cid;
                const inputs = $('input[type!=checkbox]', this.obj);
                for (const i of inputs) {
                    const field = $(i).attr('name');
                    const text = (field && change[field]) ? change[field] : '';
                    $(i).val(text);
                }
                const textareas = $('textarea', this.obj);
                for (const ta of textareas) {
                    const field = $(ta).attr('name');
                    const text = (field && change[field]) ? change[field] : '';
                    ta.innerText = text;
                }
                const html = [];
                for (const a of change.attachments) {
                    html.push('<tr>');
                    html.push('<td>', a.filename + a.fileext, '</td>');
                    html.push('<td>', a.u_name, '</td>');
                    html.push('</tr>');
                }
                // 变更类型
                const cType = change.type.split(',');
                $('input[name="type"]').prop("checked", false);
                for (const c of cType) {
                    $('input[name="type"][value='+ c +']').prop("checked", true);
                }
                // 变更类别
                $('select[name=class]').val(change.class);
                // 变更性质
                $('select[name=quality]').val(change.quality);
                // 变更单位
                $('select[name=company]').html('<option>' + change.company + '</option>');
                // 费用承担方
                $('input[name=charge][value=' + change.charge + ']').prop('checked', true);
                // 附件
                $('#attachment').html(html.join(''));
            } else {
                const inputs = $('input', this.obj);
                for (const i of inputs) {
                    $(i).val('');
                }
                const textareas = $('textarea', this.obj);
                for (const ta of textareas) {
                    ta.innerText = '';
                }
                $('#attachment').html('');
            }
        }
        _viewChanges() {
            const sheet = this.spread.getActiveSheet();
            if (this.changes) {
                SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, this.changes);
                sheet.setSelection(0, 0, 1, 1);
                this._loadChangeDetail(this.changes[0]);
                this._filterEmptyChange(!$('#customCheckDisabled')[0].checked);
            } else {
                toast('查询变更令有误，请刷新页面后重试', 'warning');
            }
        }
        _filterEmptyChange(isFilter) {
            for (const c of this.changes) {
                c.visible = isFilter ? (c.vamount || c.vamount === 0) : true;
            }
            SpreadJsObj.refreshTreeRowVisible(this.spread.getActiveSheet());
        }
        loadChanges(data, code) {
            this.callData = data;
            const self = this;
            $('#b-code-hint').text('当前变更清单：' + code);
            postData(window.location.pathname + '/valid-change', data, function (result) {
                self.changes = result;
                self._viewChanges();
                self.obj.modal('show');
            });
        }
    }
    const changesObj = new Changes($('#use-bg'));

    // 初始化 台账 spread
    const slSpread = SpreadJsObj.createNewSpread($('#stage-ledger')[0]);
    customizeStageTreeSetting(ledgerSpreadSetting, customColDisplay());
    // 数量变更列，添加按钮
    const col = _.find(ledgerSpreadSetting.cols, {field: 'qc_qty'});
    col.readOnly = true;
    col.cellType = 'imageBtn';
    col.hoverImg = '#ellipsis-icon';
    col.indent = 5;
    col.showImage = function (data) {
        if (!data || (data.children && data.children.length > 0)) {
            return false;
        } else {
            const nodePos = stagePos.getLedgerPos(data.id);
            return !(nodePos && nodePos.length > 0);
        }
    };
    ledgerSpreadSetting.imageClick = function (data) {
        changesObj.loadChanges({bills: data}, data.b_code);
    };
    //
    SpreadJsObj.initSheet(slSpread.getActiveSheet(), ledgerSpreadSetting);
    stageTree.loadDatas(ledgerData);
    stageTree.loadCurStageData(curStageData);
    stageTree.loadPreStageData(preStageData);
    // 根据设置 计算 台账树结构
    treeCalc.calculateAll(stageTree);
    // 绘制界面
    SpreadJsObj.loadSheetData(slSpread.getActiveSheet(), 'tree', stageTree);

    // 初始化 部位明细 Spread
    const spSpread = SpreadJsObj.createNewSpread($('#stage-pos')[0]);
    const spCol = _.find(posSpreadSetting.cols, {field: 'qc_qty'});
    spCol.readOnly = true;
    spCol.cellType = 'imageBtn';
    spCol.hoverImg = '#ellipsis-icon';
    spCol.indent = 5;
    spCol.showImage = function (data) {
        return data;
    };
    posSpreadSetting.imageClick = function (data) {
        const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
        changesObj.loadChanges({pos: data}, node.b_code);
    };
    SpreadJsObj.initSheet(spSpread.getActiveSheet(), posSpreadSetting);

    const stageTreeSpreadObj = {
        refreshTreeNodes: function (sheet, nodes) {
            const tree = sheet.zh_tree;
            if (!tree) { return }
            const rows = [];
            for (const node of nodes) {
                rows.push(tree.nodes.indexOf(node));
            }
            SpreadJsObj.reLoadRowsData(sheet, rows);
        },
        editEnded: function (e, info) {
            if (info.sheet.zh_setting) {
                const col = info.sheet.zh_setting.cols[info.col];
                const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
                const node = sortData[info.row];

                if (node.children && node.children.length > 0) {
                    toast('清单父项不可计量', 'error');
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    return;
                } else {
                    const nodePos = stagePos.getLedgerPos(node.id);
                    if (nodePos && nodePos.length > 0) {
                        toast('该清单有部位明细，请在部位明细处计量', 'error');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                }
                const billsData = {
                    lid: node.id
                };
                billsData[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;

                postData(window.location.href + '/update', { bills: billsData }, function (data) {
                    const nodes = stageTree.loadPostStageData(data.bills);
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                });
            }
        },
        selectionChanged: function (e, info) {
            stagePosSpreadObj.loadCurPosData();
        },
        deletePress(sheet) {
            if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
                const tree = sheet.zh_tree;
                if (!tree) { return; }

                const sel = sheet.getSelections()[0];
                const validCols = [];
                for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
                    if (!sheet.zh_setting.cols[iCol].readOnly) {
                        validCols.push(iCol);
                    }
                }
                if (validCols.length === 0) { return; }

                const sortData = sheet.zh_tree.nodes;
                const datas = [];
                for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
                    const node = sortData[iRow];
                    if (node) {
                        if (node.children && node.children.length > 0) { continue; }
                        const nodePos = stagePos.getLedgerPos(node.id);
                        if (nodePos && nodePos.length > 0) { continue; }

                        const data = { lid: node.id };
                        for (const iCol of validCols) {
                            const colSetting = sheet.zh_setting.cols[iCol];
                            data[colSetting.field] = null;
                        }
                        datas.push(data);
                    }
                }
                if (datas.length > 0) {
                    postData(window.location.href + '/update', {bills: datas}, function (result) {
                        const nodes = stageTree.loadPostStageData(result.bills);
                        stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                    });
                }
            }
        },
        clipboardPasting(e, info) {
            if (info.sheet.zh_setting) {
                const sortData = info.sheet.zh_data;
                const range = info.cellRange;
                const validField = ['contract_qty', 'contract_tp', 'qc_qty', 'postil'];
                for (let iCol = range.col; iCol < range.col + range.colCount; iCol++) {
                    const col = info.sheet.zh_setting.cols[iCol];
                    if (validField.indexOf(col.field) === -1) {
                        toast('不可修改此数据', 'error');
                        info.cancel = true;
                        return;
                    }
                }
            }
        },
        clipboardPasted(e, info) {
            if (info.sheet.zh_setting && info.sheet.zh_tree) {
                const sheet = info.sheet;
                const filterNodes = [], datas = [];

                console.log(info.cellRange);
                for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
                    const curRow = iRow + info.cellRange.row;
                    const node = sheet.zh_tree.getItemsByIndex(curRow);
                    if (node.children && node.children.length > 0) {
                        filterNodes.push(node);
                        continue;
                    }
                    const nodePos = stagePos.getLedgerPos(node.id);
                    if (nodePos && nodePos.length > 0) {
                        filterNodes.push(node);
                        continue;
                    }

                    const data = {lid: node.id};
                    for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
                        const curCol = info.cellRange.col + iCol;
                        const col = info.sheet.zh_setting.cols[curCol];
                        data[col.field] = col.type === 'Number' ? _.toNumber(info.sheet.getText(curRow, curCol)) : info.sheet.getText(curRow, curCol);
                    }
                    datas.push(data);
                }
                console.log(datas);
                if (datas.length > 0) {
                    postData(window.location.href + '/update', { bills: datas }, function (data) {
                        const nodes = stageTree.loadPostStageData(data.bills);
                        stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes.concat(filterNodes));
                    });
                } else {
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), filterNodes);
                }
            }
        }
    };
    slSpread.bind(spreadNS.Events.EditEnded, stageTreeSpreadObj.editEnded);
    slSpread.bind(spreadNS.Events.SelectionChanged, stageTreeSpreadObj.selectionChanged);
    slSpread.bind(spreadNS.Events.ClipboardPasting, stageTreeSpreadObj.clipboardPasting);
    slSpread.bind(spreadNS.Events.ClipboardPasted, stageTreeSpreadObj.clipboardPasted);
    SpreadJsObj.addDeleteBind(slSpread, stageTreeSpreadObj.deletePress);

    const stagePosSpreadObj = {
        /**
         * 加载部位明细 根据当前台账选择节点
         */
        loadCurPosData: function () {
            const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
            if (node) {
                const posData = stagePos.ledgerPos[itemsPre + node.id] || [];
                SpreadJsObj.loadSheetData(spSpread.getActiveSheet(), 'data', posData);
            } else {
                SpreadJsObj.loadSheetData(spSpread.getActiveSheet(), 'data', []);
            }
        },
        editEnded: function (e, info) {
            if (info.sheet.zh_setting) {
                // 未改变过，则直接跳过
                const posData = info.sheet.zh_data ? info.sheet.zh_data[info.row] : null;
                const col = info.sheet.zh_setting.cols[info.col];
                const orgText = posData ? posData[col.field] : null;
                if (orgText === info.editingText || ((!orgText || orgText === '') && (info.editingText === ''))) {
                    return;
                }
                // 台账模式下，不可新增
                if (checkTzMeasureType() && !posData) {
                    toast('台账模式不可新增部位明细数据', 'error');
                    info.cancel = true;
                    return ;
                }
                // 不同节点下，部位明细检查输入
                const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                if (!node) {
                    toast('数据错误, 请刷新页面后再试', 'warning');
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    return;
                } else if (info.editingText !== '' && node.children && node.children > 0) {
                    toast('父节点不可插入部位明细', 'error');
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    return;
                } else if (info.editingText !== '' && !node.b_code || node.b_code === '') {
                    toast('项目节不可插入部位明细', 'error');
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    return;
                }
                // 生成提交数据
                const data = {};
                if (col.field === 'name') {
                    if (info.editingText === '' && pos) {
                        toast('部位名称不可为空', 'error', 'exclamation-circle');
                        info.cancel = true;
                        return;
                    } else if (!pos) {
                        if (info.editingText !== '') {
                            data.updateType = 'add';
                            data.updateData = {name: info.editingText, lid: node.id, tid: tender.id};
                        } else {
                            return;
                        }
                    } else {
                        data.updateType = 'update';
                        data.updateData = {id: posData.id, name: info.editingText};
                    }
                } else if (!posData) {
                    toast('新增部位请先输入名称', 'warning');
                } else {
                    data.updateType = 'update';
                    data.updateData = {pid: posData.id, lid: posData.lid};
                    data.updateData[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
                }
                // 提交数据到服务器
                postData(window.location.pathname + '/update', {pos: data}, function (result) {
                    if (result.pos) {
                        stagePos.updateDatas(result.pos.pos);
                        stagePos.loadCurStageData(result.pos.curStageData);
                    }
                    const nodes = stageTree.loadPostStageData(result.ledger.curStageData);
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                    stagePosSpreadObj.loadCurPosData();
                }, function () {
                    stagePosSpreadObj.loadCurPosData();
                });
            }
        },
        clipboardPasting: function (e, info) {
            if (info.sheet.zh_setting) {
                const sortData = info.sheet.zh_data;
                const range = info.cellRange;
                const validField = ['contract_qty', 'qc_qty', 'postil'];
                for (let iCol = range.col; iCol < range.col + range.colCount; iCol++) {
                    const col = info.sheet.zh_setting.cols[iCol];
                    if (validField.indexOf(col.field) === -1) {
                        if (checkTzMeasureType()) {
                            toast('不可修改此数据', 'error');
                            info.cancel = true;
                            return;
                        } else {
                            for (let iRow = range.row; iRow < range.row + range.rowCount; iRow) {
                                const pos = sortData(iRow);
                                if (pos.add_stage !== stage.id || pos.add_times !== stage.times) {
                                    toast('不可修改此数据', 'error');
                                    info.cancel = true;
                                    return;
                                }
                            }
                        }
                    }
                }
            }
        },
        clipboardPasted: function (e, info) {
            const self = this;
            if (info.sheet.zh_setting) {
                const data = { updateType: '', updateData: [], };
                const sortData = info.sheet.zh_data;
                const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                if (sortData && (info.cellRange.row >= sortData.length)) {
                    data.updateType = 'add';
                    if (info.cellRange.col !== 0) {
                        toast('新增部位请先输入名称', 'warning');
                        self.loadCurPosData();
                        return;
                    }
                    for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
                        const curRow = info.cellRange.row + iRow;
                        const newData = {lid: node.id};
                        for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
                            const curCol = info.cellRange.col + iCol;
                            const colSetting = info.sheet.zh_setting.cols[curCol];
                            newData[colSetting.field] = info.sheet.getText(curRow, curCol);
                            if (colSetting.type === 'Number') {
                                newData[colSetting.field] = _.toNumber(newData[colSetting.field]);
                            }
                        }
                        data.updateData.push(newData);
                    }
                } else {
                    data.updateType = 'update';
                    for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
                        const curRow = info.cellRange.row + iRow;
                        const curPos = sortData[curRow];
                        if (curPos) {
                            const newData = {pid: curPos.id, lid: curPos.lid};
                            for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
                                const curCol = info.cellRange.col + iCol;
                                const colSetting = info.sheet.zh_setting.cols[curCol];
                                newData[colSetting.field] = info.sheet.getText(curRow, curCol);
                                if (colSetting.type === 'Number') {
                                    newData[colSetting.field] = _.toNumber(newData[colSetting.field]);
                                }
                            }
                            data.updateData.push(newData);
                        }
                    }
                }
                console.log(data);
                postData(window.location.pathname + '/update', {pos: data}, function (result) {
                    if (result.pos) {
                        stagePos.updateDatas(result.pos.pos);
                        stagePos.loadCurStageData(result.pos.curStageData);
                    }
                    const nodes = stageTree.loadPostStageData(result.ledger.curStageData);
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                    stagePosSpreadObj.loadCurPosData();
                }, function () {
                    stagePosSpreadObj.loadCurPosData();
                });
            }
        },
        deletePress: function (sheet) {
            if (sheet.zh_setting && sheet.zh_data) {
                const sortData = sheet.zh_data;
                if (!sortData || sortData.length === 0) { return; }

                const sel = sheet.getSelections()[0];
                const validCols = [];
                for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
                    if (!sheet.zh_setting.cols[iCol].readOnly) {
                        validCols.push(iCol);
                    }
                }
                if (validCols.length === 0) { return; }

                const datas = [], posSelects = [];
                for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
                    const node = sortData[iRow];
                    if (node) {
                        const data = {pid: node.id, lid: node.lid};
                        for (const iCol of validCols) {
                            const colSetting = sheet.zh_setting.cols[iCol];
                            if (colSetting.field === 'name') {
                                toast('部位名称不能为空', 'error');
                                return;
                            }
                            data[colSetting.field] = null;
                        }
                        datas.push(data);
                        posSelects.push(node);
                    }
                }
                if (datas.length > 0) {
                    postData(window.location.pathname + '/update', {pos: {updateType: 'update', updateData: datas} }, function (result) {
                        if (result.pos) {
                            stagePos.updateDatas(result.pos.pos);
                            stagePos.loadCurStageData(result.pos.curStageData);
                        }
                        const nodes = stageTree.loadPostStageData(result.ledger.curStageData);
                        stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                        // todo 只加载改变项
                        stagePosSpreadObj.loadCurPosData();
                    });
                }
            }
        },
    };
    // 加载上下窗口resizer
    $.divResizer({
        select: '#main-resize',
        callback: function () {
            slSpread.refresh();
            let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
            $(".sp-wrap").height(bcontent-40);
            spSpread.refresh();
        }
    });

    // 加载部位明细数据 - 暂时统一加载，如有需要，切换成动态加载并缓存
    postData(window.location.pathname + '/pos', null, function (result) {
        stagePos.loadDatas(result.pos);
        if (result.curStageData) {
            stagePos.loadCurStageData(result.curStageData);
        }
        if (result.preStageData) {
            stagePos.loadPreStageData(result.preStageData);
        }
        stagePos.calculateAll();
        stagePosSpreadObj.loadCurPosData();
    });
    spSpread.bind(spreadNS.Events.EditEnded, stagePosSpreadObj.editEnded);
    spSpread.bind(spreadNS.Events.ClipboardPasting, stagePosSpreadObj.clipboardPasting);
    spSpread.bind(spreadNS.Events.ClipboardPasted, stagePosSpreadObj.clipboardPasted);
    SpreadJsObj.addDeleteBind(spSpread, stagePosSpreadObj.deletePress);

    $('#row-view').on('show.bs.modal', function () {
        const html = [], customDisplay = customColDisplay();
        for (const cd of customDisplay) {
            html.push('<tr>');
            html.push('<td>', cd.title, '</td>');
            html.push('<td>', '<input type="checkbox"' + (cd.visible ? ' checked=""' : '') + '>', '</td>');
            html.push('</tr>');
        }
        $('#row-view-list').html(html.join(''));
    });
    $('#row-view-ok').click(function () {
        const customDisplay = customColDisplay();
        const cvl = $('#row-view-list').children();
        for (const cv of cvl) {
            const title = $(cv).children()[0].innerHTML;
            const check = $('input', cv)[0].checked;
            const cd = customDisplay.find(function (c) {
                return c.title === title;
            });
            cd.visible = check;
        }
        customizeStageTreeSetting(ledgerSpreadSetting, customDisplay);
        SpreadJsObj.refreshColumnVisible(slSpread.getActiveSheet());
        Cookies.set('stage-col-visible', JSON.stringify(customDisplay), 7*24*60*60*1000);
        $('#row-view').modal('hide');
    });
});