Calculation/app/public/js/se_yjcl.js

'use strict';

/**
 * 期 - 甲供材料
 *
 * @author Mai
 * @date 2020/2/12
 * @version
 */

$(document).ready(() => {
    autoFlashHeight();
    const spreadSetting = {
        cols: [
            {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 100, formatter: '@'},
            {title: '规格型号', colSpan: '1', rowSpan: '2', field: 'spec', hAlign: 0, width: 100, formatter: '@'},
            {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', cellType: 'unit'},
            {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 100, type: 'Number', readOnly: true},
            {title: '除税单价', colSpan: '1', rowSpan: '2', field: 'ex_tax_up', hAlign: 2, width: 100, type: 'Number', readOnly: true},
            {title: '税率', colSpan: '1', rowSpan: '2', field: 'tax', hAlign: 1, width: 50, type: 'Number'},
            {title: '到场|数量',  colSpan: '2|1', rowSpan: '1|1', field: 'arrive_qty', hAlign: 2, width: 60, type: 'Number'},
            {title: '|金额',  colSpan: '|1', rowSpan: '|1', field: 'arrive_tp', hAlign: 2, width: 60, type: 'Number'},
            {title: '本期计量|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qty', hAlign: 2, width: 60, type: 'Number'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'tp', hAlign: 2, width: 60, type: 'Number', readOnly: true},
            {title: '截止本期计量|数量', colSpan: '2|1', rowSpan: '1|1', field: 'end_qty', hAlign: 2, width: 60, type: 'Number', readOnly: true},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'end_tp', hAlign: 2, width: 60, type: 'Number', readOnly: true},
            {title: '到场信息|到场时间', colSpan: '5|1', rowSpan: '1|1', field: 'arrive_time', hAlign: 1, width: 80, formatter: '@'},
            {title: '|材料来源', colSpan: '|1', rowSpan: '|1', field: 'source', hAlign: 0, width: 150, formatter: '@', wordWrap: true},
            {title: '|单据号', colSpan: '|1', rowSpan: '|1', field: 'bills_code', hAlign: 0, width: 100, formatter: '@', wordWrap: true},
            {title: '|存放位置', colSpan: '|1', rowSpan: '|1', field: 'location', hAlign: 0, width: 80, formatter: '@', wordWrap: true},
            {title: '|拟用于部位', colSpan: '|1', rowSpan: '|1', field: 'prepare_pos', hAlign: 0, width: 150, formatter: '@', wordWrap: true},
            {title: '备注', colSpan: '1', rowSpan: '2', field: 'memo', hAlign: 0, width: 100, formatter: '@', cellType: 'ellipsisAutoTip'}
        ],
        emptyRows: readOnly ? 0 : 3,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: readOnly,
        localCache: {
            key: 'stage-extra-yjcl',
            colWidth: true,
        },
        getColor: function (sheet, data, row, col, defaultColor) {
            if (!data || !data.end_tp) return defaultColor;

            return data.end_qty >= 0
                ? data.end_qty > data.arrive_qty ? '#f8d7da' : defaultColor
                : data.end_qty < data.arrive_qty ? '#f8d7da' : defaultColor;
        },
    };
    const yjclSpread = SpreadJsObj.createNewSpread($('#yjcl-spread')[0]);
    const yjclSheet = yjclSpread.getActiveSheet();
    if (thousandth) sjsSettingObj.setTpThousandthFormat(spreadSetting);
    SpreadJsObj.initSheet(yjclSheet, spreadSetting);
    $.subMenu({
        menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
        toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
        key: 'menu.1.0.0',
        miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
        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();
            yjclSpread.refresh();
        }
    });

    class Yjcl {
        constructor () {
            this.data = [];
        }
        resortData() {
            this.data.sort(function (a, b) {
                return a.m_order - b.m_order;
            });
        }
        calculateAll() {
            for (const d of this.data) {
                d.end_qty = ZhCalc.add(d.pre_qty, d.qty);
                d.end_tp = ZhCalc.add(d.pre_tp, d.tp);
            }
        }
        loadDatas(datas) {
            this.data = datas;
            this.calculateAll();
            this.resortData();
        }
        loadUpdateData(updateData) {
            if (updateData.add) {
                for (const a of updateData.add) {
                    this.data.push(a);
                }
            }
            if (updateData.update) {
                for (const u of updateData.update) {
                    const d = this.data.find(function (x) {
                        return u.id === x.id;
                    });
                    if (d) {
                        _.assign(d, u);
                    } else {
                        this.data.push(d);
                    }
                }
            }
            if (updateData.del) {
                _.remove(this.data, function (d) {
                    return updateData.del.indexOf(d.id) >= 0;
                });
            }
            this.calculateAll();
            this.resortData();
        }
        getMaxOrder() {
            return this.data.length > 0 ? this.data[this.data.length - 1].m_order : 0;
        }
    }
    const yjclObj = new Yjcl();

    postData(window.location.pathname + '/load', null, function (result) {
        yjclObj.loadDatas(result);
        SpreadJsObj.loadSheetData(yjclSheet, SpreadJsObj.DataType.Data, yjclObj.data);
    });

    if (!readOnly) {
        const yjclOprObj = {
            /**
             * 删除按钮响应事件
             * @param sheet
             */
            deletePress: function (sheet) {
                if (!sheet.zh_setting || readOnly) return;

                const sortData = sheet.zh_data;
                const datas = [];
                const sels = sheet.getSelections();
                if (!sels || !sels[0]) return;

                for (let iRow = sels[0].row; iRow < sels[0].row + sels[0].rowCount; iRow++) {
                    let bDel = false;
                    const node = sortData[iRow];
                    if (node) {
                        const data = {id: node.id};
                        for (let iCol = sels[0].col; iCol < sels[0].col + sels[0].colCount; iCol++) {
                            const colSetting = sheet.zh_setting.cols[iCol];
                            if (colSetting.field === 'name') {
                                toastr.error('名称不能为空，如需删除材料请使用右键删除');
                                return;
                            }
                            const style = sheet.getStyle(iRow, iCol);
                            if (!style.locked) {
                                const colSetting = sheet.zh_setting.cols[iCol];
                                data[colSetting.field] = colSetting.type === 'Number' ? 0 : '';
                                bDel = true;
                            }
                        }
                        if (bDel) {
                            datas.push(data);
                        }
                    }
                }
                if (datas.length > 0) {
                    postData(window.location.pathname + '/update', {update: datas}, function (result) {
                        yjclObj.loadUpdateData(result);
                        SpreadJsObj.reLoadSheetData(yjclSheet);
                    }, function () {
                        SpreadJsObj.reLoadSheetData(yjclSheet);
                    });
                }
            },
            delete: function (sheet) {
                if (!sheet.zh_setting || readOnly) return;

                const sortData = sheet.zh_data;
                const datas = [];
                const sels = sheet.getSelections();
                if (!sels || !sels[0]) return;
                const hint = {
                    isOld: {type: 'warning', msg: '该材料已计量，不可删除'},
                    invalidDel: {type: 'warning', msg: '该材料不是您新增的，只有原报和新增人可删除'},
                };

                for (let iRow = sels[0].row, iLen = sels[0].row + sels[0].rowCount; iRow < iLen; iRow++) {
                    const node = sortData[iRow];
                    if (node.pre_used || !checkZero(node.end_qty) || !checkZero(node.end_qty)) {
                        toastMessageUniq(hint.isOld);
                        continue;
                    } else {
                        if (node.add_uid !== userID && stageUserId !== userID) {
                            toastMessageUniq(hint.invalidDel);
                            continue;
                        }
                        datas.push(node.id);
                    }
                }
                if (datas.length > 0) {
                    postData(window.location.pathname + '/update', {del: datas}, function (result) {
                        yjclObj.loadUpdateData(result);
                        SpreadJsObj.reLoadSheetData(yjclSheet);
                    }, function () {
                        SpreadJsObj.reLoadSheetData(yjclSheet);
                    });
                }
            },
            insert: function(sheet) {
                if (!sheet.zh_setting || !sheet.zh_data) return;

                const node = SpreadJsObj.getSelectObject(sheet);
                postData(window.location.pathname + '/update', {insert: { select: node.id, count: 1 }}, function (result) {
                    yjclObj.loadUpdateData(result);
                    SpreadJsObj.reLoadSheetData(sheet);
                }, function () {
                    SpreadJsObj.reLoadSheetData(sheet);
                });
            },
            editEnded: function (e, info) {
                if (!info.sheet.zh_setting || !info.sheet.zh_data) return;

                const node = info.sheet.zh_data[info.row];
                const col = info.sheet.zh_setting.cols[info.col];
                const data = {};
                const maxOrder = yjclObj.getMaxOrder();

                if (node) {
                    data.update = {};
                    data.update.id = node.id;

                    const oldValue = node ? node[col.field] : null;
                    const newValue = col.wordWrap ? info.editingText : trimInvalidChar(info.editingText);
                    if (oldValue == info.editingText || ((!oldValue || oldValue === '') && (newValue === ''))) {
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    data.update[col.field] = newValue;
                } else {
                    if (col.field !== 'name') {
                        toastr.warning('新增材料，请先输入名称');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    data.add = {};
                    data.add.m_order = maxOrder + 1;
                    data.add.name = col.wordWrap ? info.editingText : trimInvalidChar(info.editingText);
                }

                postData(window.location.pathname + '/update', data, function (result) {
                    yjclObj.loadUpdateData(result);
                    SpreadJsObj.reLoadSheetData(info.sheet);
                }, function () {
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                });
            },
            editStarting(e, info) {
                if (!info.sheet.zh_setting || !info.sheet.zh_data) {
                    info.cancel = true;
                    return;
                }

                const col = info.sheet.zh_setting.cols[info.col];
                const node = info.sheet.zh_data[info.row];
                if (!node) return;

                switch (col.field) {
                    case 'name':
                    case 'spec':
                    case 'unit':
                    case 'tax':
                    case 'arrive_qty':
                    case 'arrive_tp':
                    case 'arrive_time':
                    case 'source':
                    case 'bills_code':
                    case 'location':
                    case 'prepare_pos':
                        info.cancel = readOnly || node.add_sid !== stageId;
                        break;
                }
            },
            clipboardPasting(e, info) {
                const setting = info.sheet.zh_setting, sortData = info.sheet.zh_data;
                info.cancel = true;

                if (!setting || !sortData) return;
                const pasteData = info.pasteData.html
                    ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
                    : (info.pasteData.text === ''
                        ? SpreadJsObj.Clipboard.getAnalysisPasteText()
                        : SpreadJsObj.analysisPasteText(info.pasteData.text));
                const hint = {
                    name: {type: 'warning', msg: '材料名称不可为空，已过滤'},
                    tax: {type: 'warning', msg: '输入的 税率 非法，已过滤'},
                    arrive: {type: 'warning', msg: '输入的 到场数量/金额 非法，已过滤'},
                    qty: {type: 'warning', msg: '输入的 本期计量-数量 非法，已过滤'},
                };

                const uDatas = [], iDatas = [];
                const maxOrder = yjclObj.getMaxOrder();
                for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
                    const curRow = info.cellRange.row + iRow;
                    const node = sortData[curRow];

                    let bPaste = false;
                    const data = {};
                    for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
                        const curCol = info.cellRange.col + iCol;
                        const colSetting = setting.cols[curCol];
                        const value = colSetting.wordWrap ? pasteData[iRow][iCol] : trimInvalidChar(pasteData[iRow][iCol]);

                        if (colSetting.field === 'name' && (!value || value === '')) {
                            toastMessageUniq(hint.name);
                            break;
                        }
                        if (colSetting.type === 'Number') {
                            const num = _.toNumber(value);
                            if (num) {
                                data[colSetting.field] = num;
                                bPaste = true;
                            }
                        } else {
                            data[colSetting.field] = value;
                            bPaste = true;
                        }
                    }
                    if (bPaste) {
                        if (node) {
                            data.id = node.id;
                            uDatas.push(data);
                        } else {
                            data.m_order = maxOrder + iDatas.length + 1;
                            iDatas.push(data);
                        }
                    }
                }
                const updateData = {};
                if (uDatas.length > 0) updateData.update = uDatas;
                if (iDatas.length > 0) updateData.add = iDatas;
                if (uDatas.length > 0 || iDatas.length > 0) {
                    postData(window.location.pathname + '/update', updateData, function (result) {
                        yjclObj.loadUpdateData(result);
                        SpreadJsObj.reLoadSheetData(info.sheet);
                    });
                } else {
                    SpreadJsObj.reLoadSheetData(info.sheet);
                }
            },
            upMove: function () {
                const sels = yjclSheet.getSelections(), sortData = yjclSheet.zh_data;
                const node = sortData[sels[0].row];
                const preNode = sortData[sels[0].row - 1];
                const data = [
                    { id: node.id, m_order: preNode.m_order },
                    { id: preNode.id, m_order: node.m_order }
                ];
                postData(window.location.pathname + '/update', {update: data}, function (result) {
                    yjclObj.loadUpdateData(result);
                    SpreadJsObj.reLoadRowsData(yjclSheet, [sels[0].row, sels[0].row - 1]);
                    yjclSheet.setSelection(sels[0].row - 1, sels[0].col, sels[0].rowCount, sels[0].colCount);
                });
            },
            downMove: function () {
                const sels = yjclSheet.getSelections(), sortData = yjclSheet.zh_data;
                const node = sortData[sels[0].row];
                const nextNode = sortData[sels[0].row + 1];
                const data = [
                    {id: node.id, m_order: nextNode.m_order},
                    {id: nextNode.id, m_order: node.m_order}
                ];
                postData(window.location.pathname + '/update', {update: data}, function (result) {
                    yjclObj.loadUpdateData(result);
                    SpreadJsObj.reLoadRowsData(yjclSheet, [sels[0].row, sels[0].row + 1]);
                    yjclSheet.setSelection(sels[0].row + 1, sels[0].col, sels[0].rowCount, sels[0].colCount);
                });
            }
        };
        yjclSheet.bind(spreadNS.Events.EditEnded, yjclOprObj.editEnded);
        yjclSheet.bind(spreadNS.Events.EditStarting, yjclOprObj.editStarting);
        yjclSheet.bind(spreadNS.Events.ClipboardPasting, yjclOprObj.clipboardPasting);
        SpreadJsObj.addDeleteBind(yjclSpread, yjclOprObj.deletePress);
        $.contextMenu({
            selector: '#yjcl-spread',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, yjclSpread);
                return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
            },
            items: {
                del: {
                    name: '删除',
                    icon: 'fa-remove',
                    callback: function (key, opt) {
                        yjclOprObj.delete(yjclSheet);
                    },
                    disabled: function (key, opt) {
                        const sels = yjclSheet.getSelections();
                        if (!sels || !sels[0]) return true;

                        const row = sels[0].row;
                        const node = yjclObj.data[row];
                        return node === undefined || node === null;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
                sprDel: '------------',
                insert: {
                    name: '插入',
                    icon: 'fa-plus',
                    callback: function (key, opt) {
                        yjclOprObj.insert(yjclSheet);
                    },
                    disabled: function (key, opt) {
                        const node = SpreadJsObj.getSelectObject(yjclSheet);
                        return !node;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
                upMove: {
                    name: '上移',
                    icon: 'fa-arrow-up',
                    callback: function (key, opt) {
                        yjclOprObj.upMove();
                    },
                    disabled: function (key, opt) {
                        const sels = yjclSheet.getSelections();
                        if (!sels || !sels[0] || sels[0].row === 0) return true;

                        const row = sels[0].row;
                        const node = yjclObj.data[row];
                        return node === undefined || node === null;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
                downMove: {
                    name: '下移',
                    icon: 'fa-arrow-down',
                    callback: function (key, opt) {
                        yjclOprObj.downMove();
                    },
                    disabled: function (key, opt) {
                        const sels = yjclSheet.getSelections();
                        if (!sels || !sels[0] || sels[0].row >= yjclObj.data.length - 1) return true;

                        const row = sels[0].row;
                        const node = yjclObj.data[row];
                        return node === undefined || node === null;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                }
            },
        })
    }

    $('#exportExcel').click(function () {
        SpreadExcelObj.exportSimpleXlsxSheet(spreadSetting, yjclObj.data, $('.sidebar-title').attr('data-original-title') + "-永久材料.xlsx");
    });
});