Calculation/app/public/js/material.js

'use strict';

/**
 * 材料调差 - 调差工料
 *
 * @author Mai
 * @date 2019/1/16
 * @version
 */

function loadUpdateMaterials(newMaterial, fields) {
    const newMaterials = newMaterial instanceof Array ? newMaterial : [newMaterial];
    for (const nm of newMaterials) {
        const om = _.find(materialBillsData, {id: nm.id});
        for (const prop in nm) {
            if (!fields || fields.indexOf(prop) >= 0) {
                om[prop] = nm[prop];
            }
        }
    }
}
$(document).ready(() => {
    autoFlashHeight();
    const materialSpread = SpreadJsObj.createNewSpread($('#material-spread')[0]);
    const materialSpreadSetting = {
        cols: [
            {title: '调差类型', colSpan: '1', rowSpan: '2', field: 't_type', hAlign: 0, width: 80, formatter: '@', readOnly: 'readOnly.isEdit', cellType: 'customizeCombo', comboItems: materialType.t_type, cellTypeKey: 1},
            {title: '编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
            {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 180, formatter: '@', readOnly: 'readOnly.isEdit'},
            {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
            {title: '规格', colSpan: '1', rowSpan: '2', field: 'spec', hAlign: 0, width: 180, formatter: '@', readOnly: 'readOnly.isEdit'},
            {title: '工料分类', colSpan: '1', rowSpan: '2', field: 'm_type', hAlign: 0, width: 60, readOnly: 'readOnly.isEdit', cellType: 'customizeCombo', comboItems: materialType.m_type, cellTypeKey: 2},
            {title: '本期应耗数量', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 100, type: 'Number', readOnly: true},
            {title: '基准价', colSpan: '1', rowSpan: '2', field: 'basic_price', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit'},
            {title: '基准时间', colSpan: '1', rowSpan: '2', field: 'basic_times', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
            {title: '本期信息价|单价', colSpan: '3|1', rowSpan: '1|1', field: 'msg_tp', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit'},
            {title: '|时间', colSpan: '|1', rowSpan: '|1', field: 'msg_times', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
            {title: '|价差', colSpan: '1', rowSpan: '1|1', field: 'msg_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.msg_spread'},
            {title: '本期材料调差|上涨幅度（%）', colSpan: '4|1', rowSpan: '1|1', field: 'm_up_risk', hAlign: 2, width: 100, type: 'Number', readOnly: 'readOnly.isEdit'},
            {title: '|下跌幅度（%）', colSpan: '|1', rowSpan: '|1', field: 'm_down_risk', hAlign: 2, width: 100, type: 'Number', readOnly: 'readOnly.isEdit'},
            {title: '|有效价差', colSpan: '|1', rowSpan: '|1', field: 'm_spread', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.m_spread'},
            {title: '|调整金额', colSpan: '|1', rowSpan: '1|1', field: 'm_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.m_tp'},
            {title: '截止上期调差金额', colSpan: '1', rowSpan: '2', field: 'pre_tp', hAlign: 2, width: 120, type: 'Number', readOnly: true},
            {title: '备注', colSpan: '1', rowSpan: '2', field: 'remark', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.remark'},
        ],
        emptyRows: 0,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: readOnly,
    };

    const materialBase = {
        isEdit: function (data) {
            return materialListData.find(function (item) {
                return item.mb_id === data.id;
            });
        },
        // isStage: function (data) {
        //     return data.mid === materialID;
        // }
    }

    const materialCol = {
        getValue: {
            msg_spread: function (data) {
                return ZhCalc.round(ZhCalc.sub(data.msg_tp, data.basic_price), 2);
            },
            m_spread : function (data) {
                const msg_spread = materialCol.getValue.msg_spread(data);
                const cor = msg_spread >= 0 ? ZhCalc.mul(data.basic_price, ZhCalc.div(data.m_up_risk, 100)) : ZhCalc.mul(data.basic_price, ZhCalc.div(data.m_down_risk, 100));
                return Math.abs(msg_spread) > Math.abs(cor) ? (msg_spread > 0 ? ZhCalc.round(ZhCalc.sub(msg_spread, cor), 2) : ZhCalc.round(ZhCalc.add(msg_spread, cor), 2)) : 0;
            },
            m_tp: function (data) {
                return ZhCalc.round(ZhCalc.mul(materialCol.getValue.m_spread(data), data.quantity), 2);
            }
        },
        readOnly: {
            isEdit: function (data) {
                return !(!readOnly && materialBase.isEdit(data) === undefined);
            },
            remark: function () {
                return readOnly;
            },
        },
    };
    SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
    SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
    SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);

    const materialSpreadObj = {
        refreshActn: function () {
            const setObjEnable = function (obj, enable) {
                if (enable) {
                    obj.removeClass('disabled');
                } else {
                    obj.addClass('disabled');
                }
            };
            const sheet = materialSpread.getActiveSheet();
            const select = SpreadJsObj.getSelectObject(sheet);
            // 还需判断是否已被调差清单调用
            setObjEnable($('#del'), !readOnly && select && materialBase.isEdit(select) === undefined);
        },
        add: function () {
            const sheet = materialSpread.getActiveSheet();
            postData(window.location.pathname + '/save', {type: 'add'}, function (result) {
                if (result) {
                    materialBillsData.push(result);
                    sheet.addRows(materialBillsData.length - 1, 1);
                    SpreadJsObj.reLoadRowData(sheet, materialBillsData.length - 1);
                    sheet.setSelection(materialBillsData.length - 1, 0, 1, 1);
                    materialSpreadObj.refreshActn();
                }
            });
        },
        del: function () {
            const sheet = materialSpread.getActiveSheet();
            const select = SpreadJsObj.getSelectObject(sheet);
            postData(window.location.pathname + '/save', {type: 'del', id: select.id}, function (result) {
                const index = materialBillsData.indexOf(select);
                materialBillsData.splice(index, 1);
                sheet.deleteRows(index, 1);
                SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
                const sel = sheet.getSelections();
                sheet.setSelection(index > 0 ? index - 1 : 0, sel.length > 0 ? sel[0].col : 0, 1, 1);
                materialSpreadObj.refreshActn();
            });
        },
        selectionChanged: function (e, info) {
            materialSpreadObj.refreshActn();
            const sel = info.sheet.getSelections()[0];
            const col = info.sheet.zh_setting.cols[sel.col];
            const data = SpreadJsObj.getSelectObject(info.sheet);
            materialSpreadObj.setReadOnly(true);
        },
        editEnded: function (e, info) {
            if (info.sheet.zh_setting) {
                const select = SpreadJsObj.getSelectObject(info.sheet);
                const col = info.sheet.zh_setting.cols[info.col];
                // 未改变值则不提交
                const validText = info.editingText ? (typeof(info.editingText) === 'String' ? info.editingText.replace('\n', '') : info.editingText) : null;
                const orgValue = select[col.field];
                if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    return;
                }
                // 判断部分值是否输入的是数字判断和数据计算
                if (col.field === 'basic_price') {
                    if (isNaN(validText)) {
                        toastr.error('不能输入其它非数字类型字符');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    const num = parseFloat(validText);
                    if (num < 0 || !/^\d+(\.\d{1,3})?$/.test(num)) {
                        toastr.error('请输入大于0并且小于3位小数的浮点数');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                }
                if (col.field === 'msg_tp') {
                    if (isNaN(validText)) {
                        toastr.error('不能输入其它非数字类型字符');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    const num = parseFloat(validText);
                    if (num < 0 || !/^\d+(\.\d{1,3})?$/.test(num)) {
                        toastr.error('请输入大于0并且小于3位小数的浮点数');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                }
                if (col.field === 'm_up_risk') {
                    // 只能输入正整数
                    if (isNaN(validText)) {
                        toastr.error('不能输入其它非数字类型字符');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    const num = parseFloat(validText);
                    if (num < 0 || num > 100 || !/^\d+$/.test(num)) {
                        toastr.error('只能输入0-100的正整数');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                }
                if (col.field === 'm_down_risk') {
                    // 只能输入正整数
                    if (isNaN(validText)) {
                        toastr.error('不能输入其它非数字类型字符');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    const num = parseFloat(validText);
                    if (num < 0 || num > 100 || !/^\d+$/.test(num)) {
                        toastr.error('只能输入0-100的正整数');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                }
                select[col.field] = validText;
                select.msg_spread = materialCol.getValue.msg_spread(select);
                select.m_spread = materialCol.getValue.m_spread(select);
                select.m_tp = materialCol.getValue.m_tp(select);
                // 更新至服务器
                postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                }, function () {
                    select[col.field] = orgValue;
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                });
            }
        },
        setReadOnly: function(readOnly) {
            SpreadJsObj.resetFieldReadOnly(materialSpread.getActiveSheet(), 'msg_spread', 'm_spread', 'm_tp', 'pre_tp', readOnly);
        }
    };
    materialSpreadObj.refreshActn();
    materialSpread.bind(spreadNS.Events.SelectionChanged, materialSpreadObj.selectionChanged);
    if (!readOnly) {
        $('#add').click(materialSpreadObj.add);
        $('#del').click(materialSpreadObj.del);
        materialSpread.bind(spreadNS.Events.EditEnded, materialSpreadObj.editEnded);
        // 右键菜单
        $.contextMenu({
            selector: '#material-spread',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, materialSpread);
                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) {
                        materialSpreadObj.add(materialSpread.getActiveSheet());
                    },
                },
                'delete': {
                    name: '删除材料',
                    icon: 'fa-remove',
                    callback: function (key, opt) {
                        materialSpreadObj.del(materialSpread.getActiveSheet());
                    },
                    disabled: function (key, opt) {
                        const sheet = materialSpread.getActiveSheet();
                        const select = SpreadJsObj.getSelectObject(sheet);
                        materialSpreadObj.refreshActn();
                        if (!readOnly && select && materialBase.isEdit(select) === undefined) {
                            return false;
                        } else {
                            return true;
                        }
                    }
                },
            }
        });
        $('#changeRate').change(function () {
            const rate = parseInt($(this).val());
            postData(window.location.pathname + '/save', { type:'rate', rate: rate }, function (result) {
                const bqhs = ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), 2);
                const jzbqhs = ZhCalc.round(ZhCalc.mul(ZhCalc.add(pre_tp, m_tp), 1+rate/100), 2);
                $('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
                $('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
            });
        })
    } else {
        // SpreadJsObj.forbiddenSpreadContextMenu('#material-spread', materialSpread);
    }
    $.subMenu({
        menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
        toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
        //key: 'stage.compare.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();
            materialSpread.refresh();
        }
    });
});