Calculation/app/public/js/stage.js

'use strict';

/**
 * 期计量 - 本期计量台账页面 js
 *
 * @author Mai
 * @date 2018/12/7
 * @version
 */
const ckBillsSpread = window.location.pathname + '-billsSelect';
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: ['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', 'end_gather_percent'], visible: true },
        { title: '本期批注', fields: ['postil'], visible: true },
        { title: '图册号', fields: ['drawing_code'], visible: true },
        { title: '备注', fields: ['memo'], visible: true },
    ];
    if (checkTzMeasureType()) {
        defaultSetting.splice(0, 1);
    }
    const settingStr = Cookies.get('stage-col-visible-1.0.2-' + tender.id);
    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);
        }
    }
}
function needCheckDetail() {
    stage.check_detail = true;
    $('#check_point').show();
    $('#sub-sp-btn').attr('data-target', '#sub-sp3');
    $('#sp-done-btn').attr('data-target', '#sub-sp3');
    $('#sp-list2-btn').attr('data-target', '#sub-sp3');
}

// 生成所有附件列表
function getAllList(currPageNum = 1) {
    // 每页最多几个附件
    const pageCount = 11;
    // 附件总数
    const total = attData.length;
    // 总页数
    const pageNum = Math.ceil(total/pageCount);
    $('#totalPage').text(pageNum);
    $('#currentPage').text(currPageNum);
    // 当前页附件内容
    const currPageAttData = attData.slice((currPageNum-1)*pageCount, currPageNum*pageCount);
    let html = '';
    for(const att of currPageAttData) {
        html += '<tr><td><a href="javascript:void(0)" file-id="'+ att.id +'">'+ att.filename + att.fileext +'</a></td><td>'+ att.username +'</td></tr>';
    }
    $('#alllist-table').html(html);
}
// 生成当前节点列表
function getNodeList(node) {
    let html = '';
    for(const att of attData) {
        if (node === att.lid) {
            html += '<tr><td><a href="javascript:void(0)" file-id="'+ att.id +'">'+ att.filename + att.fileext +'</a></td><td>'+ att.username +'</td></tr>';

        }
    }
    $('#nodelist-table').html(html);
}

$(document).ready(() => {
    // 提示窗
    toastr.options = {
        "closeButton": false,
        "debug": false,
        "newestOnTop": false,
        "progressBar": false,
        "positionClass": "toast-top-center",
        "preventDuplicates": false,
        "onclick": null,
        "showDuration": "300",
        "hideDuration": "1000",
        "timeOut": "5000",
        "extendedTimeOut": "1000",
        "showEasing": "swing",
        "hideEasing": "linear",
        "showMethod": "fadeIn",
        "hideMethod": "fadeOut"
    };
    // 界面布局
    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', 'postil'];
    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 = ZhCalc.add(node.pre_contract_qty, node.pre_qc_qty);
            node.gather_qty = ZhCalc.add(node.contract_qty, node.qc_qty);
            node.end_contract_qty = ZhCalc.add(node.pre_contract_qty, node.contract_qty);
            node.end_qc_qty = ZhCalc.add(node.pre_qc_qty, node.qc_qty);
            node.end_gather_qty = ZhCalc.add(node.pre_gather_qty, node.gather_qty);
        }
        node.pre_gather_tp = ZhCalc.add(node.pre_contract_tp, node.pre_qc_tp);
        node.gather_tp = ZhCalc.add(node.contract_tp, node.qc_tp);
        node.end_contract_tp = ZhCalc.add(node.pre_contract_tp, node.contract_tp);
        node.end_qc_tp = ZhCalc.add(node.pre_qc_tp, node.qc_tp);
        node.end_gather_tp = ZhCalc.add(node.pre_gather_tp, node.gather_tp);
        node.end_final_tp = ZhCalc.add(node.end_qc_tp, node.total_price);
        node.end_gather_percent = ZhCalc.mul(ZhCalc.div(node.end_gather_tp, node.end_final_tp), 100, 2);
        node.final_dgn_price = ZhCalc.round(ZhCalc.div(node.end_gather_tp, ZhCalc.add(node.deal_dgn_qty1, node.c_dgn_qty1)), tenderInfo.decimal.up);
    };
    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 = ZhCalc.add(pos.pre_contract_qty, pos.pre_qc_qty);
        pos.gather_qty = ZhCalc.add(pos.contract_qty, pos.qc_qty);
        pos.end_contract_qty = ZhCalc.add(pos.pre_contract_qty, pos.contract_qty);
        pos.end_qc_qty = ZhCalc.add(pos.pre_qc_qty, pos.qc_qty);
        pos.end_gather_qty = ZhCalc.add(pos.pre_gather_qty, pos.gather_qty);
        pos.sum = ZhCalc.add(pos.end_qc_qty, pos.quantity);
        pos.end_gather_percent = ZhCalc.mul(ZhCalc.div(pos.end_gather_qty, pos.sum), 100, 2);
    };
    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, img: function (data) {
                        if (data.uamount && !checkZero(data.uamount)) {
                            return $('#icon-ok')[0];
                        } else {
                            return null;
                        }
                    }},
                    {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, getValue: function (data) {return data.vamount ? data.vamount + '' : '0';}},
                    {title: '本期计量', field: 'uamount', width: 60, formatter: '@', hAlign: 2, type: 'Number', },
                ],
                emptyRows: 0,
                headRows: 1,
                headRowHeight: [40],
                getColor: function (sheet, data, col, defaultColor) {
                    if (col.field === 'uamount') {
                        if (!data.vamount) {
                            return (data.uamount && data.uamount > 0) ? '#ff6f5c' : defaultColor;
                        } else if (data.uamount) {
                            return data.uamount > data.vamount ? '#ff6f5c' : defaultColor;
                        } else {
                            return defaultColor;
                        }
                    } else {
                        return defaultColor;
                    }
                }
            };
            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;
                    // 刷新界面
                    SpreadJsObj.reLoadRowData(info.sheet, info.row, 1);
                }
            });
            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
            $('#filterEmpty').click(function () {
                self._filterChange(!this.checked, $('#matchPos')[0].checked);
            });
            // 匹配编号
            $('#matchPos').click(function () {
                self._filterChange(!$('#filterEmpty')[0].checked, 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();
                }
            });
            // 添加调用变更令
            $('#usg-bg-ok').click(function () {
                const data = { target: self.callData, change: [] };
                for (const c of self.displayChanges) {
                    if (c.uamount) {
                        const vamount = (!c.vamount || checkZero(c.vamount)) ? 0 : c.vamount;
                        if (c.uamount > vamount) {
                            toast('变更令：' + c.code + ' 超计，请修改本期计量后，再提交', 'error');
                            return;
                        }
                        // if (!c.vamount || checkZero(c.vamount)) {
                        //     toast('变更令：' + c.code + ' 当前不可使用', 'error');
                        //     return;
                        // } else {
                        //     if (c.uamount > c.vamount) {
                        //         toast('变更令：' + c.code + ' 超计，请修改本期计量后，再提交', 'error');
                        //         return;
                        //     }
                        // }
                        data.change.push({ cid: c.cid, cbid: c.cbid, qty: c.uamount });
                    }
                }
                // 提交数据到后端
                postData(window.location.pathname + '/use-change', data, function(result) {
                    if (result.pos) {
                        stagePos.loadCurStageData(result.pos.curStageData);
                    }
                    const nodes = stageTree.loadPostStageData(result.bills);
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                    stagePosSpreadObj.loadCurPosData();
                    needCheckDetail();
                    self.obj.modal('hide');
                });
            })
        }
        _calculateAmount() {
            for (const c of this.changes) {
                c.bamount = _.toNumber(c.b_amount);
                c.vamount = ZhCalc.sub(c.bamount, c.used_amount);
                const uc = _.find(this.useChanges, {cid: c.cid, cbid: c.cbid});
                if (uc) {
                    c.org_uamount = uc.qty;
                    c.uamount = uc.qty;
                    c.vamount = ZhCalc.add(c.vamount, c.uamount);
                }
            }
        }
        _loadChangeDetail(change) {
            if (change) {
                if (change.cid === this.curChangeId) { return; }

                this.curChangeId = change.cid;
                const inputs = $('input[type!=checkbox][type!=radio]', 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.textContent = text;
                }
                const html = [];
                for (const a of change.attachments) {
                    html.push('<tr>');
                    html.push('<td>', '<a href="/change/download/file/' + a.id + '">', a.filename + a.fileext, '</a>', '</td>');
                    html.push('<td>', a.u_name, '</td>');
                    html.push('</tr>');
                }
                // 变更类型
                if (change.type) {
                    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 ? 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) {
                sheet.setSelection(0, 0, 1, 1);
                //SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, this.changes);
                this._filterChange(!$('#filterEmpty')[0].checked, $('#matchPos')[0].checked);
                this._loadChangeDetail(this.changes[0]);
            } else {
                toast('查询变更令有误，请刷新页面后重试', 'warning');
            }
        }
        _filterChange(filterEmpty, matchPosName) {
            this.displayChanges = [];
            for (const c of this.changes) {
                const filterVisible = filterEmpty ? (c.vamount ? !checkZero(c.vamount) : false) : true;
                const matchVisible = matchPosName && this.callData.pos ? c.b_bwmx === this.callData.pos.name : true;
                if ((filterVisible && matchVisible) || (c.org_uamount)) {
                    this.displayChanges.push(c);
                }
                //c.visible = filterVisible && matchVisible;
            }
            SpreadJsObj.loadSheetData(this.spread.getActiveSheet(), SpreadJsObj.DataType.Data, this.displayChanges);
            //SpreadJsObj.refreshTreeRowVisible(this.spread.getActiveSheet());
        }
        loadChanges(data) {
            this.callData = data;
            if (this.callData.pos) {
                $('#matchPos').parent().show();
            } else {
                $('#matchPos').parent().hide();
            }
            const self = this;
            $('#b-code-hint').text('当前变更清单：' + data.bills.b_code);
            postData(window.location.pathname + '/valid-change', data, function (result) {
                self.changes = result.changes;
                self.useChanges = result.useChanges;
                self._calculateAmount();
                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) || !(data.b_code && data.b_code !== '')) {
            return false;
        } else {
            const nodePos = stagePos.getLedgerPos(data.id);
            return !(nodePos && nodePos.length > 0);
        }
    };
    ledgerSpreadSetting.imageClick = function (data) {
        changesObj.loadChanges({bills: data});
    };
    ledgerSpreadSetting.dgnUpFields = ['deal_dgn_qty1', 'deal_dgn_qty2', 'c_dgn_qty1', 'c_dgn_qty2'];
    SpreadJsObj.initSheet(slSpread.getActiveSheet(), ledgerSpreadSetting);

    stageTree.loadDatas(ledgerData);
    // stageTree.loadCurStageData(curStageData);
    // stageTree.loadPreStageData(preStageData);
    // 根据设置 计算 台账树结构
    treeCalc.calculateAll(stageTree);
    // 绘制界面
    SpreadJsObj.loadSheetData(slSpread.getActiveSheet(), 'tree', stageTree);
    SpreadJsObj.loadTopAndSelect(slSpread.getActiveSheet(), ckBillsSpread);

    //初始化所有附件列表
    getAllList();

    // 初始化 部位明细 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({bills: node, pos: data});
    };
    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], updateData = {};

                const orgValue = node[col.field];
                const newValue =  col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
                if (orgValue == newValue || ((!orgValue || orgValue === '') && (newValue === ''))) {
                    return;
                }
                if (col.field.indexOf('_dgn_') > 0) {
                    if (node.b_code && node.b_code !== '') {
                        toast('仅项目节可输入设计数量');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                } else if (col.field !== 'postil') {
                    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;
                        }
                    }
                }

                if (col.field.indexOf('_dgn_') > 0) {
                    updateData.dgn = {
                        id: node.id
                    };
                    updateData.dgn[col.field] = newValue;
                } else {
                    updateData.stage = {
                        lid: node.id
                    };
                    updateData.stage[col.field] = newValue;
                }

                postData(window.location.href + '/update', {bills: updateData}, function (data) {
                    const nodes = stageTree.loadPostStageData(data);
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                    needCheckDetail();
                });
            }
        },
        selectionChanged: function (e, info) {
            if (!info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
                stagePosSpreadObj.loadCurPosData();
                SpreadJsObj.resetTopAndSelect(spSpread.getActiveSheet());
                posSearch.search();
            }
            SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
        },
        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 = [], dgnDatas = [];
                for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
                    const node = sortData[iRow];
                    if (node) {
                        const data = { lid: node.id }, dgnData = { id: node.id };
                        let filter = true, filterDgn = true;
                        for (const iCol of validCols) {
                            const colSetting = sheet.zh_setting.cols[iCol];
                            if (sheet.zh_setting.dgnUpFields.indexOf(colSetting.field) !== -1) {
                                if (node.b_code && node.b_code !== '') continue;
                            } else if (colSetting.field !== 'postil') {
                                if (node.children && node.children.length > 0) { continue; }
                                const nodePos = stagePos.getLedgerPos(node.id);
                                if (nodePos && nodePos.length > 0) { continue; }
                            }

                            if (sheet.zh_setting.dgnUpFields.indexOf(colSetting.field) !== -1) {
                                if (node[colSetting.field] && node[colSetting.field] !== 0) {
                                    dgnData[colSetting.field] = 0;
                                    filterDgn = false;
                                }
                            } else {
                                data[colSetting.field] = null;
                                filter = false;
                            }
                        }
                        if (!filter) datas.push(data);
                        if (!filterDgn) dgnDatas.push(dgnData);
                    }
                }
                if (datas.length > 0 || dgnDatas.length > 0) {
                    const bills = {};
                    if (datas.length > 0) bills.stage = datas;
                    if (dgnDatas.length > 0) bills.dgn = dgnDatas;
                    postData(window.location.href + '/update', {bills: bills}, function (result) {
                        const nodes = stageTree.loadPostStageData(result);
                        stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                        needCheckDetail();
                    });
                }
            }
        },
        clipboardPasting(e, info) {
            if (info.sheet.zh_setting) {
                const setting = info.sheet.zh_setting;
                const range = info.cellRange;
                const stageField = ['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 ((stageField.indexOf(col.field) === -1) && setting.dgnUpFields.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, setting = info.sheet.zh_setting;
                const filterNodes = [], datas = [], dgnDatas = [];

                for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
                    const curRow = iRow + info.cellRange.row;
                    const node = sheet.zh_tree.getItemsByIndex(curRow);

                    const data = {lid: node.id}, dgnData = {id: node.id};
                    let filter = true, filterDgn = true;
                    for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
                        const curCol = info.cellRange.col + iCol;
                        const col = info.sheet.zh_setting.cols[curCol];

                        if (setting.dgnUpFields.indexOf(col.field) !== -1) {
                            if (node.b_code && node.b_code !== '') continue;
                        } else if (col.field !== 'postil') {
                            if (node.children && node.children.length > 0) continue;
                            const nodePos = stagePos.getLedgerPos(node.id);
                            if (nodePos && nodePos.length > 0) continue;
                        }

                        if (setting.dgnUpFields.indexOf(col.field) !== -1) {
                            dgnData[col.field] = _.toNumber(sheet.getText(curRow, curCol));
                            filterDgn = false;
                        } else {
                            data[col.field] = col.type === 'Number' ? _.toNumber(sheet.getText(curRow, curCol)) : sheet.getText(curRow, curCol);
                            filter = false;
                        }
                    }
                    if (filter && filterDgn) {
                        filterNodes.push(node);
                    } else {
                        if (!filter) datas.push(data);
                        if (!filterDgn) dgnDatas.push(dgnData);
                    }
                }
                if (datas.length > 0 || dgnDatas.length > 0) {
                    const updateData = {};
                    if (datas.length > 0) updateData.stage = datas;
                    if (dgnDatas.length > 0) updateData.dgn = dgnDatas;
                    postData(window.location.href + '/update', {bills: updateData}, function (data) {
                        const nodes = stageTree.loadPostStageData(data);
                        stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes.concat(filterNodes));
                        needCheckDetail();
                    });
                } else {
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), filterNodes);
                }
            }
        },
        measureAllPosInNode(node, ratio = 1) {
            const posterity = stageTree.getPosterity(node)
            const data = {updateType: 'update', updateData: []};
            for (const p of posterity) {
                if (p.children && p.children.length > 0) continue;
                const posRange = stagePos.getLedgerPos(p.id);
                if (posRange && posRange.length > 0) {
                    for (const pr of posRange) {
                        if (pr.contract_qty && !checkZero(pr.contract_qty)) continue;
                        const validValue = ZhCalc.sub(pr.quantity, pr.end_contract_qty);
                        if (validValue <= 0) continue;
                        const value = ratio !== 1 ? ZhCalc.mul(pr.quantity, ratio) : pr.quantity;
                        const pData = {
                            pid: pr.id,
                            lid: pr.lid,
                            contract_qty: validValue > 0 ? (value > validValue ? validValue : value) : (value < validValue ? validValue : value),
                        };
                        data.updateData.push(pData);
                    }
                }
                if (data.updateData.length > 1000 || _.map(data.updateData, 'lid').length > 500) {
                    toastr.warning('选中的数据过多，仅计量' + data.updateData.length + '条，请稍后');
                    break;
                }
            }
            if (data.updateData.length === 0) {
                toastr.info('其下全部部位明细均已计量');
                return;
            }
            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);
                stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                stagePosSpreadObj.loadCurPosData();
                needCheckDetail();
                toastr.success('已计量' + data.updateData.length + '条');
            }, function () {
                stagePosSpreadObj.loadCurPosData();
            });
        },
        topRowChanged(e, info) {
            SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
        },
    };
    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);
    slSpread.bind(spreadNS.Events.TopRowChanged, stageTreeSpreadObj.topRowChanged);
    SpreadJsObj.addDeleteBind(slSpread, stageTreeSpreadObj.deletePress);
    $.contextMenu({
        selector: '#stage-ledger',
        build: function ($trigger, e) {
            const target = SpreadJsObj.safeRightClickSelection($trigger, e, slSpread);
            return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
        },
        items: {
            'measureAll': {
                name: '计量其下所有部位明细',
                icon: 'fa-rocket',
                callback: function (key, opt) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    stageTreeSpreadObj.measureAllPosInNode(node);
                },
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                }
            },
            'measureAllFiveTenth': {
                name: '计量其下所有部位明细（计量50%）',
                icon: 'fa-plane',
                callback: function (key, opt) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    stageTreeSpreadObj.measureAllPosInNode(node, 0.5);
                },
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                }
            },
            'measureAllOneTenth': {
                name: '计量其下所有部位明细（计量10%）',
                icon: 'fa-car',
                callback: function (key, opt) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    stageTreeSpreadObj.measureAllPosInNode(node, 0.1);
                },
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                }
            },
            'hint1': {
                name: '最多计量200条清单下1000条部位明细',
                className: 'text-danger',
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                },
                disabled: function (key, opt) {
                    return true;
                }
            },
            'hint1_1': {
                name: '(计数以清单为准，会计完清单下全部部位)',
                className: 'text-danger',
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                },
                disabled: function (key, opt) {
                    return true;
                }
            },
            'hint2': {
                name: '可再次使用该功能计量剩下的节点',
                className: 'text-danger',
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                },
                disabled: function (key, opt) {
                    return true;
                }
            },
            'hint2_2': {
                name: '(凡是计量的部位，不论计量多少，均不再计量)',
                className: 'text-danger',
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                },
                disabled: function (key, opt) {
                    return true;
                }
            },
            'hint3': {
                name: '如提示数据过多后，未成功，请缩小范围再试',
                className: 'text-danger',
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                },
                disabled: function (key, opt) {
                    return true;
                }
            },
            'hint4': {
                name: '该功能仅供测试用，请勿滥用，可能导致服务挂掉',
                className: 'text-danger',
                visible: function (key, opt) {
                    const select = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return select;
                },
                disabled: function (key, opt) {
                    return true;
                }
            },
        }
    });

    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);
                getNodeList(node.id);
                // 如果是附件是当前节点，隐藏
                if ($('#dqjiedian').hasClass('active')) {
                    $('#showAttachment').hide();
                }
            } else {
                SpreadJsObj.loadSheetData(spSpread.getActiveSheet(), 'data', []);
            }
        },
        editEnded: function (e, info) {
            if (info.sheet.zh_setting) {
                // 未改变过，则直接跳过
                const sortData = info.sheet.zh_data;
                const posData = sortData ? sortData[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');
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    return ;
                }
                // 不同节点下，部位明细检查输入
                //const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                const node = stagePosSpreadObj.stageTreeNode;
                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 || info.editingText === '') && posData) {
                        toast('部位名称不可为空', 'error', 'exclamation-circle');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    } else if (!posData) {
                        if (info.editingText !== '') {
                            data.updateType = 'add';
                            const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].porder + 1, sortData.length + 1);
                            data.updateData = {name: info.editingText, lid: node.id, tid: tender.id, porder: order};
                        } else {
                            SpreadJsObj.reLoadRowData(info.sheet, info.row);
                            return;
                        }
                    } else {
                        data.updateType = 'update';
                        data.updateData = {pid: posData.id, lid: posData.lid, 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 refreshData = stageTree.loadPostStageData(result.ledger);
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), refreshData);
                    stagePosSpreadObj.loadCurPosData();
                    needCheckDetail();
                }, function () {
                    stagePosSpreadObj.loadCurPosData();
                });
            }
        },
        editStarting: function (e, info) {
            stagePosSpreadObj.stageTreeNode = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
        },
        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'];
                if (!checkTzMeasureType()) {
                    validField.push('name', 'sgfh_qty', 'sjcl_qty', 'qtcl_qty');
                }
                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);
                    stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                    stagePosSpreadObj.loadCurPosData();
                    needCheckDetail();
                }, 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);
                        stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
                        needCheckDetail();
                        // todo 只加载改变项
                        stagePosSpreadObj.loadCurPosData();
                    });
                }
            }
        },
        deletePos: function (sheet) {
            const sels = sheet.getSelections();
            const sel = sels ? sels[0] : null;
            if (sheet.zh_data && sel) {
                const data = {updateType: 'delete', updateData: []};
                for (let iRow = 0; iRow < sel.rowCount; iRow++) {
                    const posData = sheet.zh_data[sel.row + iRow];
                    if (posData) {
                        data.updateData.push(posData.id);
                    }
                }
                if (data.updateData.length > 0) {
                    postData(window.location.pathname + '/update', {pos: data}, function (result) {
                        stagePos.removeDatas(result.pos.pos);
                        const refreshData = stageTree.loadPostStageData(result.ledger);
                        stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), refreshData);
                        stagePosSpreadObj.loadCurPosData();
                        needCheckDetail();
                    });
                }
            }
        },
    };
    // 加载上下窗口resizer
    $.divResizer({
        select: '#main-resize',
        callback: function () {
            slSpread.refresh();
            let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
            $(".sp-wrap").height(bcontent-40);
            spSpread.refresh();
        }
    });

    // 加载部位明细数据 - 暂时统一加载，如有需要，切换成动态加载并缓存
    console.time('loadPosFromServer');
    postData(window.location.pathname + '/pos', null, function (result) {
        console.timeEnd('loadPosFromServer');
        console.log('pos: ' + result.length);
        stagePos.loadDatas(result);
        stagePos.calculateAll();
        stagePosSpreadObj.loadCurPosData();
        SpreadJsObj.resetTopAndSelect(spSpread.getActiveSheet());
    }, null, true);
    spSpread.bind(spreadNS.Events.EditEnded, stagePosSpreadObj.editEnded);
    spSpread.bind(spreadNS.Events.ClipboardPasting, stagePosSpreadObj.clipboardPasting);
    spSpread.bind(spreadNS.Events.ClipboardPasted, stagePosSpreadObj.clipboardPasted);
    spSpread.bind(spreadNS.Events.EditStarting, stagePosSpreadObj.editStarting);
    SpreadJsObj.addDeleteBind(spSpread, stagePosSpreadObj.deletePress);
    if (!checkTzMeasureType()) {
        $.contextMenu({
            selector: '#stage-pos',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, spSpread);
                return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
            },
            items: {
                'del': {
                    name: '删除',
                    icon: 'fa-remove',
                    disabled: function (key, opt) {
                        const sheet = spSpread.getActiveSheet();
                        if (sheet.zh_data && !readOnly) {
                            const selection = sheet.getSelections();
                            if (selection && selection[0]) {
                                let valid = sheet.zh_data.length < selection[0].row + selection[0].rowCount;
                                for (let iRow = 0; iRow < selection[0].rowCount; iRow++) {
                                    const posData = sheet.zh_data[selection[0].row + iRow];
                                    if (posData) {
                                        if (posData.add_stage_order < stage.order || ZhCalc.isNonZero(posData.gather_qty) || ZhCalc.isNonZero(posData.end_gather_qty)) {
                                            valid = true;
                                            break;
                                        }
                                    } else {
                                        valid = true;
                                        break;
                                    }
                                }
                                return valid;
                            } else {
                                return true;
                            }
                        } else {
                            return true;
                        }
                    },
                    callback: function (key, opt) {
                        stagePosSpreadObj.deletePos(spSpread.getActiveSheet());
                    }
                }
            }
        })
    } else {
        $.contextMenu({
            selector: '#stage-pos',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, spSpread);
                return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
            },
            items: {
                'debug': {
                    name: 'debug',
                    callback: function (key, opt) {
                        console.log(SpreadJsObj.getSelectObject(spSpread.getActiveSheet()));
                    }
                }
            }
        })
    }
    $.subMenu({
        menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
        toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
        //key: 'stage.memu.1.0.0',
        callback: function (info) {
            if (info.mini) {
                $('.panel-title').addClass('fluid');
                $('#sub-menu').removeClass('panel-sidebar');
            } else {
                $('.panel-title').removeClass('fluid');
                $('#sub-menu').addClass('panel-sidebar');
            }
            autoFlashHeight();
            slSpread.refresh();
            spSpread.refresh();
        }
    });

    $('#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-1.0.1-' + tender.id, JSON.stringify(customDisplay), 30*24*60*60*1000);
        $('#row-view').modal('hide');
    });

    class SearchLedger {
        constructor(obj, mainSpread) {
            const self = this;
            this.obj = obj;
            this.mainSpread = mainSpread;
            this.spreadSetting = {
                cols: [
                    {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@'},
                    {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
                    {title: '名称', field: 'name', width: 230, hAlign: 0, formatter: '@'},
                    {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@'},
                    {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
                    {title: '数量', field: 'quantity', hAlign: 2, width: 50},
                    {title: '完成率(%)', field: 'complete_percent', hAlign: 2, width: 70},
                ],
                emptyRows: 0,
                headRows: 1,
                headRowHeight: [40],
                defaultRowHeight: 21,
                readOnly: true
            };
            this.spread = SpreadJsObj.createNewSpread($('#search-result', this.obj)[0]);
            SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
            $('#keyword', this.obj).bind('keydown', function(e) {
                if (e.keyCode == 13) self.searchText();
            });
            $('#searchLedger', this.obj).bind('click', () => {self.searchText()});
            $('#over', this.obj).bind('change', () => {self.searchOver()});
            $('#empty', this.obj).bind('change', () => {self.searchLess()});
            this.spread.getActiveSheet().bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
                const sheet = info.sheet;
                const data = sheet.zh_data;
                if (!data) { return }

                const curBills = data[info.row];
                if (!curBills) { return }

                SpreadJsObj.locateTreeNode(self.mainSpread.getActiveSheet(), curBills.ledger_id, true);
                stagePosSpreadObj.loadCurPosData();
            });
        }
        calculateCompletePercent() {
            if (!this.searchResult) return;
            for (const sr of this.searchResult) {
                const base = ZhCalc.add(sr.total_price, sr.end_qc_tp);
                sr.complete_percent = base !== 0 ? ZhCalc.mul(ZhCalc.div(sr.end_gather_tp, base), 100, 2) : 0;
            }
        }
        searchText() {
            const keyword = $('#keyword', this.obj).val();
            if (keyword !== '') {
                $('#over', this.obj)[0].checked = false;
                $('#empty', this.obj)[0].checked = false;
                this.searchResult = [];
                const sortData = SpreadJsObj.getSortData(this.mainSpread.getActiveSheet());
                for (const node of sortData) {
                    if ((node.code && node.code.indexOf(keyword) > -1) ||
                        node.b_code && node.b_code.indexOf(keyword) > -1 ||
                        node.name && node.name.indexOf(keyword) > -1) {
                        const data = JSON.parse(JSON.stringify(node));
                        data.visible = true;
                        this.searchResult.push(data);
                    }
                }
                this.calculateCompletePercent();
                SpreadJsObj.loadSheetData(this.spread.getActiveSheet(), 'data', this.searchResult);
            }
        }
        searchOver() {
            this.searchResult = [];
            const sortData = SpreadJsObj.getSortData(this.mainSpread.getActiveSheet());
            for (const node of sortData) {
                if (node.children && node.children.length > 0) continue;
                if (node.end_gather_qty) {
                    if (!node.quantity || Math.abs(node.end_gather_qty) > Math.abs(ZhCalc.add(node.quantity, node.end_qc_qty))) {
                        const data = JSON.parse(JSON.stringify(node));
                        data.visible = true;
                        this.searchResult.push(data);
                    }
                } else if (node.end_gather_tp) {
                    if (!node.total_price || Math.abs(node.end_gather_tp) > Math.abs(ZhCalc.add(node.total_price, node.end_qc_tp))) {
                        const data = JSON.parse(JSON.stringify(node));
                        data.visible = true;
                        this.searchResult.push(data);
                    }
                }
            }
            this.calculateCompletePercent();
            SpreadJsObj.loadSheetData(this.spread.getActiveSheet(), 'data', this.searchResult);
        }
        searchEmpty() {
            this.searchResult = [];
            const sortData = SpreadJsObj.getSortData(this.mainSpread.getActiveSheet());
            for (const node of sortData) {
                if (node.children && node.children.length > 0) continue;
                if (node.quantity) {
                    if (!node.end_gather_qty || checkZero(node.end_gather_qty)) {
                        const data = JSON.parse(JSON.stringify(node));
                        data.visible = true;
                        this.searchResult.push(data);
                    }
                } else if (node.total_price) {
                    if (!node.end_gather_tp || checkZero(node.end_gather_tp)) {
                        const data = JSON.parse(JSON.stringify(node));
                        data.visible = true;
                        this.searchResult.push(data);
                    }
                }
            }
            this.calculateCompletePercent();
            SpreadJsObj.loadSheetData(this.spread.getActiveSheet(), 'data', this.searchResult);
        }
        searchLess() {
            this.searchResult = [];
            const sortData = SpreadJsObj.getSortData(this.mainSpread.getActiveSheet());
            for (const node of sortData) {
                if (node.children && node.children.length > 0) continue;
                if (node.quantity) {
                    if (ZhCalc.sub(ZhCalc.add(node.quantity, node.end_qc_qty), node.end_gather_qty) > 0) {
                        const data = JSON.parse(JSON.stringify(node));
                        data.visible = true;
                        this.searchResult.push(data);
                    }
                } else if (node.total_price) {
                    if (ZhCalc.sub(ZhCalc.add(node.total_price, node.end_qc_tp), node.end_gather_tp) > 0) {
                        const data = JSON.parse(JSON.stringify(node));
                        data.visible = true;
                        this.searchResult.push(data);
                    }
                }
            }
            this.calculateCompletePercent();
            SpreadJsObj.loadSheetData(this.spread.getActiveSheet(), 'data', this.searchResult);
        }
    }
    let searchLedger;

    const posSearch = (function () {
        let resultArr = [];
        const search = function () {
            resultArr = [];
            const keyword = $('#pos-search-keyword').val();
            const checkOver = $('#pos-over-search')[0].checked;
            const checkEmpty = $('#pos-empty-search')[0].checked;
            const sortData = spSpread.getActiveSheet().zh_data;
            if (checkOver || checkEmpty) {
                if (sortData) {
                    for (let i = 0, iLength = sortData.length; i < iLength; i++) {
                        const sd = sortData[i];
                        let match = false;
                        if (checkOver) {
                            if (sd.end_gather_qty) {
                                if (!sd.quantity || Math.abs(sd.end_gather_qty) > Math.abs(ZhCalc.add(sd.quantity, sd.end_qc_qty))) match = true;
                            }
                        }
                        if (checkEmpty) {
                            if (sd.quantity) {
                                if (!sd.end_gather_qty || ZhCalc.sub(ZhCalc.add(sd.quantity, sd.end_qc_qty), sd.end_gather_qty) > 0) match = true;
                            }
                        }
                        if (keyword && keyword !== '' && sd.name && sd.name.indexOf(keyword) === -1) match = false;
                        if (match) {
                            resultArr.push({index: i, data: sd});
                        }
                    }
                }
            } else if (keyword && keyword !== '') {
                if (sortData) {
                    for (let i = 0, iLength = sortData.length; i < iLength; i++) {
                        const sd = sortData[i];
                        if (sd.name && sd.name.indexOf(keyword) > -1) {
                            resultArr.push({index: i, data: sd});
                        }
                    }
                }
            }
            $('#pos-search-result').html('结果：' + resultArr.length);
        };
        const searchAndLocate = function () {
            search();
            if (resultArr.length > 0) {
                const sheet = spSpread.getActiveSheet();
                const sel = sheet.getSelections()[0];
                const curRow = sel ? sel.row : 0;
                const pos = resultArr[0];
                if (pos.index !== curRow) {
                    sheet.setSelection(pos.index, sel ? sel.col : 0, 1, 1);
                    sheet.showRow(pos.index, spreadNS.VerticalPosition.center);
                }
            }
        };
        const locateNext = function () {
            if (resultArr.length > 0) {
                const sheet = spSpread.getActiveSheet();
                const sel = sheet.getSelections()[0];
                const curRow = sel ? sel.row : 0;
                let next = _.find(resultArr, function (d) {
                    return d.index > curRow;
                });
                if (!next) next = resultArr[0];
                if (next.index !== curRow) {
                    sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1);
                    sheet.showRow(next.index, spreadNS.VerticalPosition.center);
                }
            }
        };
        const locatePre = function () {
            if (resultArr.length > 0) {
                const sheet = spSpread.getActiveSheet();
                const sel = sheet.getSelections()[0];
                const curRow = sel ? sel.row : 0;
                let next = _.findLast(resultArr, function (d) {
                    return d.index < curRow;
                });
                if (!next) next = resultArr[resultArr.length - 1];
                if (next.index !== curRow) {
                    sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1);
                    sheet.showRow(next.index, spreadNS.VerticalPosition.center);
                }
            }
        };
        return {search, searchAndLocate, locateNext, locatePre};
    })();
    $('#pos-search-keyword').bind('keydown', function(e){
        if (e.keyCode == 13) posSearch.searchAndLocate();
    });
    $('#pos-empty-search').click(function () {
        if (this.checked) {
            $('[for=' + this.id +']').addClass('text-warning');
        } else {
            $('[for=' + this.id +']').removeClass('text-warning');
        }
        if (this.checked) {
            if ($('#pos-over-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '漏计中按名称查询');
            }
        } else {
            if ($('#pos-over-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '超计中按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            }
        }
        posSearch.searchAndLocate();
    });
    $('#pos-over-search').click(function () {
        if (this.checked) {
            $('[for=' + this.id +']').addClass('text-danger');
        } else {
            $('[for=' + this.id +']').removeClass('text-danger');
        }
        if (this.checked) {
            if ($('#pos-empty-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '超计中按名称查询');
            }
        } else {
            if ($('#pos-empty-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '漏计中按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            }
        }
        posSearch.searchAndLocate();
    });
    $('#pos-search-next').click(() => {posSearch.locateNext()});
    $('#pos-search-pre').click(() => {posSearch.locatePre()});

    $.divResizer({
        select: '#right-spr',
        callback: function () {
            slSpread.refresh();
            spSpread.refresh();
            if (searchLedger) {
                searchLedger.spread.refresh();
            }
        }
    });
    // 展开收起附件
    $('a', '.right-nav').bind('click', function () {
        //const main = $('#main-view'), tool = $('#tools-view');
        const tab = $(this), tabPanel = $(tab.attr('content'));
        const showTools = function (show) {
            const left = $('#main-view'), right = $('#tools-view'), parent = left.parent();
            if (show) {
                right.show();
                autoFlashHeight();
                /**
                 * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
                 * 第一次left.width调整后，parent的缩回left.height, 此时parent.width又增加了10px
                 * 故需要通过最终的parent.width再计算一次left.width
                 *
                 * Q: 为什么不通过先计算left.width的宽度，以避免计算两次left.width?
                 * A: 右侧工具栏不一定显示，当右侧工具栏显示过一次后，就必须使用parent和right来计算left.width
                 *
                 */
                    //left.css('width', parent.width() - right.outerWidth());
                    //left.css('width', parent.width() - right.outerWidth());
                const percent = 100 - right.outerWidth() /parent.width() * 100;
                left.css('width', percent + '%');
            } else {
                right.hide();
                left.css('width', '100%');
            }
        };
        if (!tab.hasClass('active')) {
            $('a', '.side-menu').removeClass('active');
            $('.tab-content .tab-select-show').removeClass('active');
            tab.addClass('active');
            tabPanel.addClass('active');
            showTools(tab.hasClass('active'));
            if (tab.attr('content') === '#search' && !searchLedger) {
                searchLedger = new SearchLedger($('#search'), slSpread);
                searchLedger.spread.refresh();
            }
            if (tab.attr('content') === '#fujian') {
                const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                getNodeList(node.id);
            }
        } else {
            tab.removeClass('active');
            tabPanel.removeClass('active');
            showTools(tab.hasClass('active'));
        }
        slSpread.refresh();
        spSpread.refresh();
    });

    // 切换附件里节点和所有附件
    $('#fujian .nav-link').on('click', function () {
        const tabPanel = $(this).attr('fujian-content');
        if (tabPanel !== 'syfujian') {
            $('#showPage').hide();
        } else {
            $('#showPage').show();
        }
        $('#showAttachment').hide();
    });
    // 上传附件
    $('#upload-file-btn').click(function () {
        const files = $('#upload-file')[0].files;
        const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
        const formData = new FormData();
        formData.append('lid', node.id);
        for (const file of files) {
            if (file === undefined) {
                toast('未选择上传文件！', 'error');
                return false;
            }
            const filesize = file.size;
            if (filesize > 10 * 1024 * 1024) {
                toast('存在上传文件大小过大！', 'error');
                return false;
            }
            const fileext = '.' + file.name.toLowerCase().split('.').splice(-1)[0];
            if (whiteList.indexOf(fileext) === -1) {
                toast('只能上传指定格式的附件！', 'error');
                return false;
            }
            formData.append('size', filesize);
            formData.append('file[]', file);
        }
        postDataWithFile('/tender/' + tender.id + '/measure/stage/' + stage.order + '/upload/file', formData, function (data) {
            $('#upload').modal('hide');
            // 插入到attData中
            attData = data.concat(attData);
            // 重新生成List
            getAllList();
            getNodeList(node.id);
        }, function () {
            toast('附件上传失败', 'error');
        });
        $('#upload-file').val('');
    });

    // 获取附件信息
    $('body').on('click', '.list-table a', function () {
        const fid = $(this).attr('file-id');
        if ($('#showAttachment').attr('file-id') === fid && !$('#showAttachment').is(":hidden")) {
            return;
        }
        const att = attData.find(function (item) {
            return item.id === parseInt(fid);
        });
        $('#edit-att').hide();
        $('#show-att').show();
        if (att !== undefined) {
            $('#show-att tr').eq(0).children('td').text(att.filename + att.fileext);
            const name = att.code !== null && att.code !== '' ? att.code : (att.b_code !== null ? att.b_code : '');
            $('#show-att tr').eq(1).children('td').text($.trim(name + ' ' + att.lname));
            $('#show-att tr').eq(2).find('a').attr('href', '/tender/' + tender.id + '/measure/stage/' + stage.order + '/download/file/' + att.id);
            $('#show-att tr').eq(3).children('td').eq(0).text(att.username);
            $('#show-att tr').eq(3).children('td').eq(1).text(att.in_time);
            $('#show-att tr').eq(4).children('td').text(att.remark);
            if (parseInt(userID) === att.uid) {
                $('#btn-att').show();
                $('#btn-att a').eq(1).show();
                $('#btn-att a').eq(0).hide();
                $('#btn-att a').eq(2).hide();
                $('#btn-att a').eq(3).hide();
            } else {
                $('#btn-att').hide();
                $('#btn-att a').eq(1).hide();
                $('#btn-att a').eq(0).hide();
                $('#btn-att a').eq(2).hide();
                $('#btn-att a').eq(3).hide();
            }
            $('#showAttachment').attr('file-id', fid);
            $('#showAttachment').show();
        } else {
            $('#showAttachment').hide();
            $('#showAttachment').attr('file-id', '');
            toast('附件信息获取失败', 'error');
        }
    });
    $('body').on('click', '#btn-att a', function () {
        const content = $(this).attr('content');
        const fid = $('#showAttachment').attr('file-id');
        const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
        if (content === 'edit') {
            $('#btn-att a').eq(1).hide();
            $('#btn-att a').eq(0).show();
            $('#btn-att a').eq(2).show();
            $('#btn-att a').eq(3).show();
            $('#show-att').hide();
            $('#edit-att').show();
            const att = attData.find(function (item) {
                return item.id === parseInt(fid);
            });
            $('#edit-att .form-group').eq(0).find('input').val(att.filename);
            $('#edit-att .form-group').eq(0).find('span').eq(1).text(att.fileext);
            const name = att.code !== null && att.code !== '' ? att.code : (att.b_code !== null ? att.b_code : '');
            $('#edit-att .form-group').eq(1).find('input').val($.trim(name + ' ' + att.lname));
            $('#edit-att .form-group').eq(2).find('input').val(att.in_time);
            $('#edit-att .form-group').eq(3).find('input').val(att.remark);
        } else if (content === 'cancel') {
            $('#show-att').show();
            $('#edit-att').hide();
            $('#btn-att a').eq(1).show();
            $('#btn-att a').eq(0).hide();
            $('#btn-att a').eq(2).hide();
            $('#btn-att a').eq(3).hide();
        } else if (content === 'save') {
            const formData = new FormData();
            formData.append('id', fid);
            formData.append('filename', $('#edit-att .form-group').eq(0).find('input').val());
            formData.append('fileext', $('#edit-att .form-group').eq(0).find('span').eq(1).text());
            formData.append('remark', $('#edit-att .form-group').eq(3).find('input').val());
            const file = $('#change-att-btn')[0];
            if (file.files[0] !== undefined) {
                const filesize = file.files[0].size;
                formData.append('size', filesize);
                formData.append('file', file.files[0]);
            }
            postDataWithFile('/tender/' + tender.id + '/measure/stage/' + stage.order + '/save/file', formData, function (data) {
                // 替换到attData中
                const att_index = attData.findIndex(function (item) {
                    return item.id === parseInt(fid);
                });
                attData.splice(att_index, 1, data);
                // 重新生成List
                getAllList(parseInt($('#currentPage').text()));
                getNodeList(node.id);
                $('#show-att').show();
                $('#edit-att').hide();
                $('#show-att tr').eq(0).children('td').text(data.filename + data.fileext);
                const name = data.code !== null && data.code !== '' ? data.code : (data.b_code !== null ? data.b_code : '');
                $('#show-att tr').eq(1).children('td').text($.trim(name + ' ' + data.lname));
                $('#show-att tr').eq(2).find('a').attr('href', '/tender/' + tender.id + '/measure/stage/' + stage.order + '/download/file/' + data.id);
                $('#show-att tr').eq(3).children('td').eq(0).text(data.username);
                $('#show-att tr').eq(3).children('td').eq(1).text(data.in_time);
                $('#show-att tr').eq(4).children('td').text(data.remark);
                $('#btn-att a').eq(1).show();
                $('#btn-att a').eq(0).hide();
                $('#btn-att a').eq(2).hide();
                $('#btn-att a').eq(3).hide();
            }, function () {
                toast('附件上传失败', 'error');
            });
            $('#change-att-btn').val('');
        } else if (content === 'del') {
            const data = {id: fid};
            postData('/tender/' + tender.id + '/measure/stage/' + stage.order + '/delete/file', data, function (result) {
                // 删除到attData中
                const att_index = attData.findIndex(function (item) {
                    return item.id === parseInt(fid);
                });
                attData.splice(att_index, 1);
                // 重新生成List
                getAllList();
                getNodeList(node.id);
                $('#showAttachment').hide();
                $('#showAttachment').attr('file-id', '');
            });
        }
    });

    // 替换附件
    $('#change-att-btn').on('change', function () {
        const file = $('#change-att-btn')[0].files[0];
        const name = file.name;
        const filename = name.substring(0, name.lastIndexOf("."));
        const fileext = name.substr(name.indexOf("."));
        const filesize = file.size;
        if (filesize > 10 * 1024 * 1024) {
            toast('文件大小过大！', 'error');
            $('#change-att-btn').val('');
            return false;
        }
        if (whiteList.indexOf(fileext) === -1) {
            toast('只能上传指定格式的附件！', 'error');
            $('#change-att-btn').val('');
            return false;
        }
        $('#edit-att .form-group').eq(0).find('input').val(filename);
        $('#edit-att .form-group').eq(0).find('span').eq(1).text(fileext);
    });

    // 切换页数
    $('.page-select').on('click', function () {
        const totalPageNum = $('#totalPage').text();
        const lastPageNum = $('#currentPage').text();
        const status = $(this).attr('content');
        if (status === 'pre' && lastPageNum > 1) {
            getAllList(parseInt(lastPageNum)-1);
            $('#showAttachment').hide();
        } else if (status === 'next' && lastPageNum < totalPageNum) {
            getAllList(parseInt(lastPageNum)+1);
            $('#showAttachment').hide();
        }
    });
    // 显示层次
    (function (select, sheet) {
        $(select).click(function () {
            if (!sheet.zh_tree) return;
            const tag = $(this).attr('tag');
            const tree = sheet.zh_tree;
            switch (tag) {
                case "1":
                case "2":
                case "3":
                case "4":
                case "5":
                    tree.expandByLevel(parseInt(tag));
                    SpreadJsObj.refreshTreeRowVisible(sheet);
                    break;
                case "last":
                    tree.expandByCustom(() => { return true; });
                    SpreadJsObj.refreshTreeRowVisible(sheet);
                    break;
                case "leafXmj":
                    tree.expandToLeafXmj();
                    SpreadJsObj.refreshTreeRowVisible(sheet);
                    break;
                case "curMeasure":
                    tree.expandByCustom(function (node) {
                        for (const field of ['contract_tp', 'qc_tp', 'gather_tp']) {
                            if (node[field]) {
                                return true;
                            }
                        }
                        return false;
                    });
                    SpreadJsObj.refreshTreeRowVisible(sheet);
                    break;
            }
        });
    })('a[name=showLevel]', slSpread.getActiveSheet());
});