Calculation/app/public/js/ledger.js

/**
 * 台账相关js
 *
 * @author Mai
 * @date 2018/02/05
 * @version
 */

function loadContent(data) {
    const html = [];
    html.push('<div name="auditContent" class="card my-3">');
    html.push('<div class="card-body">');
    html.push('<table class="table table-sm table-bordered mb-2">');
    console.log(data);
    console.log(data.rela_bills);
    const bills = JSON.parse(data.rela_bills);
    console.log(bills);
    for (const b of bills) {
        html.push('<tr bid=' + b.ledger_id + '>');
        const code = b.code ? b.code : b.b_code;
        html.push('<td>' + code + '</td>');
        html.push('<td>' + b.name + '</td>');
        html.push('</tr>');
    }
    html.push('</table>');
    html.push('<p>'+ data.content +'</p>');
    html.push('<span class="text-muted">' + data.in_time.toLocaleString() + '</span>');
    html.push('</div>');
    html.push('</div>');
    $('#opinion>div.sjs-height-2').append(html.join(''));
}

function loadContents(data) {
    $('div[name=auditContent]').remove();
    for (const d of data) {
        loadContent(d);
    }
};

$(document).ready(function() {
    autoFlashHeight();
    const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
    SpreadJsObj.addDeleteBind(ledgerSpread);
    const ledgerTree = createNewPathTree('ledger', {
        id: 'ledger_id',
        pid: 'ledger_pid',
        order: 'order',
        level: 'level',
        rootId: -1,
        keys: ['id', 'tender_id', 'ledger_id'],
        preUrl: '/ledger'
    });
    ledgerTree.loadDatas(ledger);
    SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
    SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);

    const treeOperationObj = {
        getSelectNode: function (sheet) {
            if (!sheet || !sheet.zh_tree) {
                return null;
            } else {
                const sel = sheet.getSelections()[0];
                return sheet.zh_tree.nodes[sel.row];
            }
        },
        /**
         * 刷新顶部按钮是否可用
         * @param sheet
         * @param selections
         */
        refreshOperationValid: function (sheet, selections) {
            const setObjEnable = function (obj, enable) {
                if (enable) {
                    obj.removeClass('disabled');
                } else {
                    obj.addClass('disabled');
                }
            };

            const row = selections[0].row;
            const tree = sheet.zh_tree;
            if (!tree) { return; }
            const node = sheet.zh_tree.nodes[row];

            setObjEnable($('#delete'), !sheet.zh_setting.readOnly && node);
            setObjEnable($('#up-move'), !sheet.zh_setting.readOnly && node && node.order > 1);
            setObjEnable($('#down-move'), !sheet.zh_setting.readOnly && node && !tree.isLastSibling(node));
            setObjEnable($('#up-level'), !sheet.zh_setting.readOnly && node && tree.getParent(node));
            setObjEnable($('#down-level'), !sheet.zh_setting.readOnly && node && node.order > 1);
        },
        refreshTree: function (sheet, data) {
            SpreadJsObj.massOperationSheet(sheet, function () {
                const tree = sheet.zh_tree;
                // 处理删除
                if (data.delete) {
                    for (const d of data.delete) {
                        sheet.deleteRows(tree.nodes.indexOf(d), 1);
                    }
                }
                // 处理新增
                if (data.create) {
                    const newNodes = data.create;
                    if (newNodes) {
                        newNodes.sort(function (a, b) {
                            const aIndex = tree.nodes.indexOf(a);
                            const bIndex = tree.nodes.indexOf(b);
                            return aIndex - bIndex;
                        });
                        for (const node of newNodes) {
                            const index = tree.nodes.indexOf(node);
                            sheet.addRows(index, 1);
                            SpreadJsObj.reLoadRowData(sheet, index, 1);
                        }
                    }
                }
                // 处理更新
                if (data.update) {
                    const rows = [];
                    for (const u of data.update) {
                        rows.push(tree.nodes.indexOf(u));
                    }
                    SpreadJsObj.reLoadRowsData(sheet, rows);
                }
                // 处理展开
                if (data.expand) {
                    for (const e of data.expand) {
                        const posterity = tree.getPosterity(e);
                        for (const p of posterity) {
                            sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
                        }
                    }
                }
            });
        },
        /**
         * 新增节点
         * @param spread
         */
        addNode: function (spread) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const row = sheet.getSelections()[0].row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = sheet.zh_tree.nodes[row];
            if (!node) { return; }

            SpreadJsObj.massOperationSheet(sheet, function () {
                tree.baseOperation('base-operation', node, 'add', function (result) {
                    self.refreshTree(sheet, result);
                    self.refreshOperationValid(sheet, sheet.getSelections());
                });
            });
        },
        /**
         * 删除选中节点
         * @param spread
         */
        deleteNode: function (spread) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const row = sheet.getSelections()[0].row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = sheet.zh_tree.nodes[row];
            if (!node) { return; }

            const count = ledgerTree.getPosterity(node).length;
            tree.baseOperation('base-operation', node, 'delete', function (result) {
                sheet.deleteRows(row, count + 1);
                for (const data of result.update) {
                    SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(data), tree.getPosterity(data).length + 1);
                }
                self.refreshOperationValid(sheet, sheet.getSelections());
            });
        },
        /**
         * 上移选中节点
         * @param spread
         */
        upMove: function (spread) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const sel = sheet.getSelections()[0];
            const row = sel.row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = tree.nodes[row];
            if (!node) { return; }

            tree.baseOperation('base-operation', node, 'up-move', function (result) {
                for (const data of result.update) {
                    SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(data), tree.getPosterity(data).length + 1);
                }
                sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
                self.refreshOperationValid(sheet, sheet.getSelections());
                //sheet.moveTo(row, -1, tree.nodes.indexOf(node), -1, tree.getPosterity(node).length + 1, -1, GC.Spread.Sheets.CopyToOptions.value);
            });

        },
        /**
         * 下移选中节点
         * @param spread
         */
        downMove: function (spread) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const sel = sheet.getSelections()[0];
            const row = sel.row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = tree.nodes[row];
            if (!node) { return; }

            tree.baseOperation('base-operation', node, 'down-move', function (result) {
                for (const data of result.update) {
                    SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(data), tree.getPosterity(data).length + 1);
                }
                sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
                self.refreshOperationValid(sheet, sheet.getSelections());
            });

        },
        /**
         * 升级选中节点
         * @param spread
         */
        upLevel: function (spread) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const row = sheet.getSelections()[0].row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = tree.nodes[row];
            if (!node) { return; }

            tree.baseOperation('base-operation', node, 'up-level', function (result) {
                self.refreshTree(sheet, result);
                self.refreshOperationValid(sheet, sheet.getSelections());
            });

        },
        /**
         * 降级选中节点
         * @param spread
         */
        downLevel: function (spread) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const row = sheet.getSelections()[0].row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = tree.nodes[row];
            if (!node) { return; }

            tree.baseOperation('base-operation', node, 'down-level', function (result) {
                self.refreshTree(sheet, result);
                self.refreshOperationValid(sheet, sheet.getSelections());
            });
        },
        /**
         * 编辑单元格响应事件
         * @param {Object} e
         * @param {Object} info
         */
        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];
                const data = {
                    id: node.id,
                    tender_id: node.tender_id,
                    ledger_id: node.ledger_id
                };
                data[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;

                info.sheet.zh_tree.update('update', data, function (result) {
                    const rows = [];
                    for (const r of result) {
                        rows.push(sortData.indexOf(r));
                    }
                    SpreadJsObj.reLoadRowsData(info.sheet, rows);
                });
            }
        },
        /**
         * 粘贴单元格响应事件
         * @param e
         * @param info
         */
        clipboardPasted: function (e, info) {
            if (info.sheet.zh_setting && info.sheet.zh_dataType === 'tree') {
                const sortData = info.sheet.zh_tree.nodes;
                const datas = [], nodes = [];
                for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
                    const curRow = info.cellRange.row + iRow;
                    const node = sortData[curRow];
                    if (node) {
                        const data = info.sheet.zh_tree.getNodeKeyData(node);
                        for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
                            const curCol = info.cellRange.col + iCol;
                            const colSetting = info.sheet.zh_setting.cols[curCol];
                            data[colSetting.field] = info.sheet.getText(curRow, curCol);
                        }
                        datas.push(data);
                        nodes.push(node);
                    }
                }
                info.sheet.zh_tree.update('update', datas, function (result) {
                    const rows = [];
                    for (const data of result) {
                        rows.push(sortData.indexOf(data));
                    }
                    SpreadJsObj.reLoadRowsData(info.sheet, rows);
                });
            }
        },
        /**
         * 删除按钮响应事件
         * @param sheet
         */
        deletePress: function (sheet) {
            if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
                const sortData = sheet.zh_tree.nodes;
                const datas = [], nodes = [];
                const sel = sheet.getSelections()[0];
                for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
                    const node = sortData[iRow];
                    if (node) {
                        const data = sheet.zh_tree.getNodeKeyData(node);
                        for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
                            const colSetting = sheet.zh_setting.cols[iCol];
                            data[colSetting.field] = null;
                        }
                        datas.push(data);
                        nodes.push(node);
                    }
                }
                sheet.zh_tree.update('update-info', datas, function (result) {
                    const rows = [];
                    for (const data of result) {
                        rows.push(sortData.indexOf(data));
                    }
                    SpreadJsObj.reLoadRowsData(sheet, rows);
                });
            }
        },
        /**
         * 粘贴整块
         * @param spread
         * @param block
         */
        pasteBlock: function (spread, block) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const row = sheet.getSelections()[0].row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = tree.nodes[row];
            if (!node) { return; }

            tree.pasteBlock('paste-block', node, block, function (result) {
                self.refreshTree(sheet, result);
                self.refreshOperationValid(sheet, sheet.getSelections());
            });
        },
        batchInsertData: function (spread, data, fun) {
            const self = this;
            const sheet = spread.getActiveSheet();
            const row = sheet.getSelections()[0].row;

            const tree = sheet.zh_tree;
            if (!tree) { return; }

            const node = tree.nodes[row];
            if (!node) { return; }

            tree.batchInsert('batch-insert', node, data, function (result) {
                self.refreshTree(sheet, result);
                self.refreshOperationValid(sheet, sheet.getSelections());
                fun();
            });
        }
    };

    if (!ledgerSpreadSetting.readOnly) {
        ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, function (e, info) {
            treeOperationObj.refreshOperationValid(info.sheet, info.newSelections);
        });
        ledgerSpread.bind(GC.Spread.Sheets.Events.EditEnded, treeOperationObj.editEnded);
        ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasted, treeOperationObj.clipboardPasted);
        SpreadJsObj.addDeleteBind(ledgerSpread, treeOperationObj.deletePress);
        ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardChanging, function (e, info) {
            const copyText = SpreadJsObj.getFilterCopyText(info.sheet);
        });
        ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, function (e, info) {
            console.log(info.copyData.text);
        });
        ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (e, info) {
        });

        // 绑定 删除等 顶部按钮
        $('#delete').click(function () {
            treeOperationObj.deleteNode(ledgerSpread);
        });
        $('#up-move').click(function () {
            treeOperationObj.upMove(ledgerSpread);
        });
        $('#down-move').click(function () {
            treeOperationObj.downMove(ledgerSpread);
        });
        $('#up-level').click(function () {
            treeOperationObj.upLevel(ledgerSpread);
        });
        $('#down-level').click(function () {
            treeOperationObj.downLevel(ledgerSpread);
        });

        let batchInsertObj;
        // 右键菜单
        $.contextMenu({
            selector: '#ledger-spread',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
                return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
            },
            items: {
                'create': {
                    name: '新增',
                    icon: 'fa-sign-in',
                    callback: function (key, opt) {
                        treeOperationObj.addNode(ledgerSpread);
                    },
                    visible: function(key, opt){
                        const sheet = ledgerSpread.getActiveSheet();
                        const selection = sheet.getSelections();
                        const row = selection[0].row;
                        const select = ledgerTree.nodes[row];
                        return select;
                    }
                },
                'delete': {
                    name: '删除',
                    icon: 'fa-remove',
                    callback: function (key, opt) {
                        treeOperationObj.deleteNode(ledgerSpread);
                    },
                    visible: function (key, opt) {
                        const sheet = ledgerSpread.getActiveSheet();
                        const selection = sheet.getSelections();
                        const row = selection[0].row;
                        const select = ledgerTree.nodes[row];
                        return select;
                    }
                },
                'copyBlock': {
                    name: '复制整块',
                    icon: 'fa-files-o',
                    callback: function (key, opt) {
                        /*ledgerSpread.commandManager().execute({
                            cmd:"copy",
                            sheetName:ledgerSpread.getActiveSheet().name()
                        });*/
                        treeOperationObj.block = [];
                        const copyBlockList = [];
                        const sheet = ledgerSpread.getActiveSheet();
                        const sel = sheet.getSelections()[0];
                        let iRow = sel.row;
                        const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
                        while (iRow < sel.row + sel.rowCount) {
                            const node = sheet.zh_tree.nodes[iRow];
                            if (node.ledger_pid !== pid) {
                                toast('error: 仅可同时选中同层节点', 'error', 'exclamation-circle');
                                return;
                            }
                            copyBlockList.push(node.ledger_id);
                            iRow += sheet.zh_tree.getPosterity(node).length + 1;
                        }
                        treeOperationObj.block = copyBlockList;
                    },
                    visible: function (key, opt) {
                        const sheet = ledgerSpread.getActiveSheet();
                        const selection = sheet.getSelections();
                        const row = selection[0].row;
                        const select = ledgerTree.nodes[row];
                        return select;
                    }
                },
                'pasteBlock': {
                    name: '粘贴',
                    icon: 'fa-clipboard',
                    disabled: function (key, opt) {
                        const block = treeOperationObj.block || [];
                        return block.length <= 0 && false;
                    },
                    callback: function (key, opt) {
                        const block = treeOperationObj.block || [];
                        if (block.length > 0) {
                            treeOperationObj.pasteBlock(ledgerSpread, block);
                        } else {
                            document.execCommand('paste');
                        }
                    }
                },
                'batchInsertChild': {
                    name: '批量插入子项',
                    icon: 'fa-sign-in',
                    disabled: function (key, opt) {
                        return false;
                    },
                    callback: function(key, opt) {
                        $('h5', $('#batch')).text('批量插入子项');
                        if (!batchInsertObj) {
                            batchInsertObj = new BatchInsertObj($('#batch'), key);
                        } else {
                            batchInsertObj.batchType = key;
                            batchInsertObj.initView();
                        }
                        $('#batch').modal('show');
                    },
                },
                'batchInsertNext': {
                    name: '批量插入后项',
                    icon: 'fa-sign-in',
                    disabled: function (key, opt) {
                        return false;
                    },
                    callback: function (key, opt) {
                        $('h5', $('#batch')).text('批量插入后项');
                        if (!batchInsertObj) {
                            batchInsertObj = new BatchInsertObj($('#batch'), key);
                        } else {
                            batchInsertObj.batchType = key;
                            batchInsertObj.initView();
                        }
                        $('#batch').modal('show');
                    },
                },
            }
        });
    }

    treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet(), ledgerSpread.getActiveSheet().getSelections());

    let stdChapter, stdBills, dealBills, searchLedger;
    // 展开收起标准清单
    $('a', '#side-menu').bind('click', function () {
        const tab = $(this), tabPanel = $(tab.attr('content'));
        const showSideTools = function (show) {
            if (show) {
                $('.c-body.col-12').removeClass('col-12').addClass('col-8');
                $('.c-body.col-0').removeClass('col-0').addClass('col-4').show();
            } else {
                $('.c-body.col-8').removeClass('col-8').addClass('col-12');
                $('.c-body.col-4').removeClass('col-4').addClass('col-0').hide();
            }
        }
        if (!tab.hasClass('active')) {
            $('a', '#side-menu').removeClass('active');
            tab.addClass('active');
            showSideTools(tab.hasClass('active'));
            $('.tab-content .tab-pane').hide();
            tabPanel.show();
            if (tab.attr('content') === '#std-chapter' && !stdChapter) {
                stdChapter = new stdLib($('#std-chapter-spread')[0], 'chapter', {
                    id: 'chapter_id',
                    pid: 'pid',
                    order: 'order',
                    level: 'level',
                    rootId: -1,
                    keys: ['id', 'list_id', 'chapter_id'],
                }, {
                    cols: [
                        {title: '项目节编号', field: 'code', width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
                        {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
                        {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true}
                    ],
                    treeCol: 0,
                    emptyRows: 0,
                    headRows: 1,
                    headRowHeight: [40],
                    defaultRowHeight: 21,
                });
                stdChapter.loadLib(1);
            } else if (tab.attr('content') === '#std-bills' && !stdBills) {
                stdBills = new stdLib($('#std-bills-spread')[0], 'bills', {
                    id: 'bill_id',
                    pid: 'pid',
                    order: 'order',
                    level: 'level',
                    rootId: -1,
                    keys: ['id', 'list_id', 'bill_id']
                }, {
                    cols: [
                        {title: '清单编号', field: 'code', width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
                        {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
                        {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true}
                    ],
                    treeCol: 0,
                    emptyRows: 0,
                    headRows: 1,
                    headRowHeight: [40],
                    defaultRowHeight: 21,
                });
                stdBills.loadLib(1);
            } else if (tab.attr('content') === '#deal-bills' && !dealBills) {
                dealBills = new DealBills($('#deal-bills-spread')[0], {
                    cols: [
                        {title: '清单编号', field: 'code', width: 120, formatter: '@', readOnly: true},
                        {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
                        {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
                        {title: '单价', field: 'unit_price', width: 50, readOnly: true},
                        {title: '数量', field: 'quantity', width: 50, readOnly: true},
                    ],
                    emptyRows: 0,
                    headRows: 1,
                    headRowHeight: [40],
                    defaultRowHeight: 21,
                });
                dealBills.loadData();
            } else if (tab.attr('content') === '#search' && !searchLedger) {
                searchLedger = new SearchLedger($('#search'), {
                    cols: [
                        {title: '项目节编号', field: 'code', width: 120, formatter: '@', readOnly: true},
                        {title: '清单编号', field: 'b_code', width: 120, formatter: '@', readOnly: true},
                        {title: '名称', field: 'name', width: 230, formatter: '@', readOnly: true},
                        {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
                        {title: '单价', field: 'unit_price', width: 50, readOnly: true},
                        {title: '数量', field: 'quantity', width: 50, readOnly: true},
                    ],
                    emptyRows: 3,
                    headRows: 1,
                    headRowHeight: [40],
                    defaultRowHeight: 21,
                })
            }
        } else {
            tab.removeClass('active');
            showSideTools(tab.hasClass('active'));
            tabPanel.hide();
        }
        ledgerSpread.refresh();
    });

    class stdLib {
        constructor(obj, stdType, treeSetting, spreadSetting) {
            this.obj = obj;
            this.url = '/std/' + stdType;
            this.treeSetting = treeSetting;
            treeSetting.preUrl = this.url;
            this.spreadSetting = spreadSetting;
            this.spread = SpreadJsObj.createNewSpread(this.obj);
            SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
            this.spread.getActiveSheet().bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
                const stdSheet = info.sheet;
                const mainSheet = ledgerSpread.getActiveSheet();
                if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }

                const stdTree = stdSheet.zh_tree;
                const stdNode = stdTree.nodes[info.row];
                const mainTree = mainSheet.zh_tree;
                const sel = mainSheet.getSelections()[0];
                const mainNode = mainTree.nodes[sel.row];
                if (!stdNode) { return; }

                mainTree.postData('add-by-std', mainNode, {
                    tender_id: mainNode.tender_id,
                    stdType: stdType,
                    stdLibId: stdNode.list_id,
                    stdNode: stdTree.getNodeKey(stdNode)
                }, function (result) {
                    treeOperationObj.refreshTree(mainSheet, result);
                    treeOperationObj.refreshOperationValid(mainSheet, mainSheet.getSelections());
                });
            });
            this.pathTree = createNewPathTree('active', this.treeSetting);
        }
        loadLib (listId) {
            const self = this;
            postData(this.url+'/get-data', {list_id: listId}, function (data) {
                self.pathTree.loadDatas(data);
                SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'tree', self.pathTree);
            });
        }
    }
    class DealBills {
        constructor (obj, spreadSetting) {
            const self = this;
            this.obj = obj;
            this.url = '/deal';
            this.spreadSetting = spreadSetting;
            this.spread = SpreadJsObj.createNewSpread(this.obj);
            SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
            $('#upload-deal-bills').click(function () {
                const file = $('#deal-bills-file')[0];
                const formData = new FormData();
                formData.append('file', file.files[0]);
                postDataWithFile(self.url+'/upload-excel', formData, function (data) {
                    SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
                    $('#upload-deal').modal('hide');
                }, function () {
                    $('#upload-deal').modal('hide');
                });
            })
        }
        loadData () {
            const self = this;
            postData(this.url+'/get-data', {}, function (data) {
                SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
            });
        }
    }
    class BatchInsertObj {
        constructor (obj, batchType) {
            const self = this;
            this.obj = obj;
            this.batchType = batchType;
            this.billsCount = 6;

            this.xmSpreadSetting = {
                cols: [
                    {title: '部位', field: 'bw', width: 80, formatter: '@'},
                    {title: '图册号', field: 'drawingCode', formatter: '@', width: 60},
                ],
                emptyRows: 1000,
                headRows: 1,
                headRowHeight: [40],
            };
            for (let iNum = 1; iNum <= this.billsCount; iNum++) {
                this.xmSpreadSetting.cols.push(
                    {title: '清单' + iNum, field: 'bills' + iNum, width: 50}
                )
            }
            this.xmSpread = SpreadJsObj.createNewSpread($('.batch-l-t')[0]);

            this.gclSpreadSetting = {
                cols: [
                    {title: '编号', field: 'code', width: 80, formatter: '@'},
                    {title: '名称', field: 'name', width: 120, formatter: '@'},
                    {title: '单位', field: 'unit', width: 50, formatter: '@'},
                    {title: '单价', field: 'unit_price', width: 50},
                    {title: '图册号', field: 'name', width: 60, formatter: '@'},
                ],
                emptyRows: this.billsCount,
                headRows: 1,
                headRowHeight: [40],
            };
            this.gclSpread = SpreadJsObj.createNewSpread($('.batch-l-b')[0]);

            this.initView();

            this.dealSpreadSetting = {
                cols: [
                    {title: '清单编号', field: 'code', width: 80, formatter: '@', readOnly: true},
                    {title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true},
                    {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
                    {title: '单价', field: 'unit_price', width: 50, readOnly: true},
                ],
                emptyRows: 0,
                headRows: 1,
                headRowHeight: [40],
            };
            this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r')[0]);
            SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
            postData('/deal/get-data', {}, function (data) {
                SpreadJsObj.loadSheetData(self.dealSpread.getActiveSheet(), 'data', data);

                self.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
                    const deal = info.sheet.zh_data[info.row];
                    const sel = self.gclSpread.getActiveSheet().getSelections()[0];
                    self.gclSpread.getActiveSheet().getCell(sel.row, 0).value(deal.code);
                    self.gclSpread.getActiveSheet().getCell(sel.row, 1).value(deal.name);
                    self.gclSpread.getActiveSheet().getCell(sel.row, 2).value(deal.unit);
                    self.gclSpread.getActiveSheet().getCell(sel.row, 3).value(deal.unit_price);
                    if (sel.row + 1 === self.gclSpread.getActiveSheet().getRowCount()) {
                        const count = sel.row + 2;
                        self.gclSpread.getActiveSheet().setRowCount(count);
                        self.gclSpread.getActiveSheet().getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);

                        const colCount = self.xmSpread.getActiveSheet().getColumnCount() + 1
                        self.xmSpread.getActiveSheet().setColumnCount(colCount);
                        self.xmSpread.getActiveSheet().getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('数量' + count);
                    }
                    self.gclSpread.getActiveSheet().setSelection(sel.row + 1, sel.col, 1, 1);
                })
            });

            this.obj.bind('shown.bs.modal', function () {
                self.xmSpread.refresh();
                self.gclSpread.refresh();
                self.dealSpread.refresh();
            });

            $('#batch-ok').click(function () {
                treeOperationObj.batchInsertData(ledgerSpread, {
                    batchData: self.getBatchData(),
                    batchType: self.batchType,
                }, function () {
                    self.obj.modal('hide');
                });
            });
        }
        initView() {
            let time = new Date();
            const xmSheet = this.xmSpread.getActiveSheet();
            SpreadJsObj.initSheet(xmSheet, this.xmSpreadSetting);
            console.log(new Date() - time);
            time = new Date();

            SpreadJsObj.beginMassOperation(xmSheet);
            xmSheet.clear(0, 0, xmSheet.getRowCount(), xmSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
            SpreadJsObj.endMassOperation(xmSheet);
            console.log(new Date() - time);
            time = new Date();

            const gclSheet = this.gclSpread.getActiveSheet();
            SpreadJsObj.initSheet(gclSheet, this.gclSpreadSetting);
            SpreadJsObj.beginMassOperation(gclSheet);
            gclSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
            for (let iRow = 1; iRow <= this.billsCount; iRow ++) {
                gclSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
            }
            gclSheet.clear(0, 0, gclSheet.getRowCount(), gclSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
            SpreadJsObj.endMassOperation(gclSheet);
            console.log(new Date() - time);
            time = new Date();
        }
        getBatchData () {
            const result = [];
            const xmSheet = this.xmSpread.getActiveSheet(), gclSheet = this.gclSpread.getActiveSheet();
            for (let iRow = 0; iRow < xmSheet.getRowCount(); iRow++) {
                if (xmSheet.getText(iRow, 0) === '') { continue; }
                const xmj = {
                    name: xmSheet.getText(iRow, 0),
                    children: [],
                };
                result.push(xmj);
                for (let iCol = 2; iCol < xmSheet.getColumnCount(); iCol++) {
                    let value;
                    try {
                        value = parseFloat(xmSheet.getText(iRow, iCol));
                        if (value !== 0 && !isNaN(value)) {
                            const gcl = {
                                b_code: gclSheet.getText(iCol - 2, 0),
                                name: gclSheet.getText(iCol - 2, 1),
                                unit: gclSheet.getText(iCol - 2, 2),
                                quantity: value,
                            }
                            try {
                                gcl.unit_price = parseFloat(gclSheet.getText(iCol - 2, 3));
                            } catch (err) {
                            }
                            if (gcl.b_code !== '' || gcl.name !== '') {
                                xmj.children.push(gcl);
                            }
                        }
                    } catch (err) {
                    }
                }
            }
            return result;
        }
    }
    class SearchLedger {
        constructor(obj, spreadSetting) {
            const self = this;
            this.obj = obj;
            this.url = '/ledger/search';
            this.spreadSetting = spreadSetting;
            this.spread = SpreadJsObj.createNewSpread($('#search-result', this.obj)[0]);
            SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);

            $('#searchLedger', this.obj).bind('click', function () {
                const data = { keyword: $('input', self.obj).val() };
                postData('/ledger/search', data, function (result) {
                    SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', result);
                });
            });
            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 }

                const mainSheet = ledgerSpread.getActiveSheet();
                const mainTree = mainSheet.zh_tree;
                mainTree.postData('locate', null, {id: curBills.ledger_id}, function (result) {
                    treeOperationObj.refreshTree(mainSheet, result);
                    treeOperationObj.refreshOperationValid(mainSheet, mainSheet.getSelections());
                    SpreadJsObj.locateTreeNode(mainSheet, curBills.ledger_id);
                })
            });
        }
    }

    $('#searchAccount').click(() => {
        const data = {
            keyword: $('#searchName').val(),
        }
        postData('/search/user', data, (data) => {
            const resultDiv = $('#searchResult');
            $('h5>span', resultDiv).text(data.name);
            $('#addAuditor').attr('auditorId', data.id);
            $('h6', resultDiv).text(data.role);
            $('p', resultDiv).text(data.company);
            resultDiv.show();
        }, () => {
            $('#searchResult').hide();
        });
    });
    $('#addAuditor').click(() => {
        const data = {
            auditorId: $('#addAuditor').attr('auditorId'),
        };
        console.log(data);
        postData('/ledger/audit/add', data, (data) => {
            const html = [];
            html.push('<li class="list-group-item" auditorId="'+ data.audit_id +'"><a href="javascript: void(0)" class="text-danger pull-right">移除</a>');
            html.push('<span>');
            html.push(data.audit_order + ' ');
            html.push(data.name + ' ');
            html.push('</span>');
            html.push('<small class="text-muted">');
            html.push(data.role);
            html.push('</small></li>');
            $('#auditors').append(html.join(''));
        });
    });
    $('li>a', '#auditors').bind('click', function () {
        const li = $(this).parent();
        const data = {
            auditorId: parseInt(li.attr('auditorId')),
        };
        postData('/ledger/audit/delete', data, (data) => {
            li.remove();
            for (const a of data) {
                const aLi = $('li[auditorId=' + a.audit_id + ']');
                $('span', aLi).text(a.audit_order + ' ' + a.name + ' ');
            }
        });
    });

    $('select', '#opinion').change(function () {
        postData('/ledger/audit/getContent', {audit_id: parseInt($(this).val())}, (data) => {
            $('legend', '#opinion').text($(this).find('option:selected').text() + ' 清单意见');
            loadContents(data);
        });
    });
});