Calculation/app/public/js/change_information_show.js

'use strict';

/**
 * 变更令详细页js
 *
 * @author EllisRan.
 * @date 2018/11/22
 * @version
 */
$(document).ready(() => {
    const changeSpreadSetting = {
        cols: [
            {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 80, formatter: '@'},
            {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 120, formatter: '@'},
            {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
            {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 60, type: 'Number', getValue: 'getValue.unit_price'},
            {title: '变更部位', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 120, formatter: '@'},
            {title: '变更详情', colSpan: '1', rowSpan: '2', field: 'detail', hAlign: 0, width: 120, formatter: '@'},
            {title: '原设计|数量', colSpan: '2|1', rowSpan: '1|1', field: 'oamount', hAlign: 2, width: 60, type: 'Number', getValue: 'getValue.oamount'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'oa_tp', hAlign: 2, width: 80, type: 'Number', getValue: 'getValue.oa_tp'},
            {title: '申请变更增(+)减(-)|数量', colSpan: '2|1', rowSpan: '1|1', field: 'camount', hAlign: 2, width: 60, type: 'Number', getValue: 'getValue.camount'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'ca_tp', hAlign: 2, width: 80, type: 'Number', getValue: 'getValue.ca_tp'},
            {title: '审批后变更|数量', colSpan: '2|1', rowSpan: '1|1', field: 'samount', hAlign: 2, width: 60, type: 'Number', getValue: 'getValue.samount'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'sa_tp', hAlign: 2, width: 80, type: 'Number', getValue: 'getValue.sa_tp'},
            {title: '变更后|数量', colSpan: '2|1', rowSpan: '1|1', field: 'samount', hAlign: 2, width: 60, type: 'Number', getValue: 'getValue.changed_amount'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'sa_tp', hAlign: 2, width: 80, type: 'Number', getValue: 'getValue.changed_tp'},
        ],
        emptyRows: 0,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
        rowHeader:[
            {
                rowHeaderType: 'circle',
                setting: {
                    size: 5,
                    indent: 16,
                    getColor: function (index, data) {
                        if (!data) return;
                        if(data.lid != 0) return;
                        return '#007bff';
                    }
                },
            },
        ],
        localCache: {
            key: 'changes-spread',
            colWidth: true,
        }
    };
    for (const aid of aidList) {
        const userinfo = _.find(auditList2, { 'uid': aid });
        const newColcount = {
            title: userinfo.name + ' 审批|数量',
            colSpan: '2|1', rowSpan: '1|1',
            field: 'audit_amount_' + aid,
            hAlign: 2, width: 60, type: 'Number',
        };
        const newColTp = {
            title: '|金额',
            colSpan: '|1', rowSpan: '|1',
            field: 'sa_tp_' + aid,
            hAlign: 2, width: 80, type: 'Number',
        };
        changeSpreadSetting.cols.push(newColcount);
        changeSpreadSetting.cols.push(newColTp);
    }

    const changeCol = {
        getValue: {
            unit_price: function(data) {
                return ZhCalc.round(data.unit_price, unitPriceUnit);
            },
            oa_tp: function (data) {
                return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.oamount, findDecimal(data.unit))), totalPriceUnit);
            },
            ca_tp: function (data) {
                return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.camount, findDecimal(data.unit))), totalPriceUnit);
            },
            oamount: function (data) {
                return ZhCalc.round(data.oamount, findDecimal(data.unit));
            },
            camount: function (data) {
                return ZhCalc.round(data.camount, findDecimal(data.unit));
            },
            samount: function (data) {
                return ZhCalc.round(data.samount, findDecimal(data.unit));
            },
            sa_tp: function (data) {
                return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.samount, findDecimal(data.unit))), totalPriceUnit);
            },
            changed_amount: function (data) {
                return ZhCalc.round(data.changed_amount, findDecimal(data.unit));
            },
            changed_tp: function (data) {
                return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.changed_amount, findDecimal(data.unit))), totalPriceUnit);
            },
        },
    };

    const changeSpreadObj = {
        makeSjsFooter: function () {
            // 增加汇总行并设为锁定禁止编辑状态
            changeSpreadSheet.addRows(changeSpreadSheet.getRowCount(), 1);
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 0, '合计');
            changeSpreadSheet.setStyle(changeSpreadSheet.getRowCount() - 1, -1, style1);
            changeSpreadObj.countSum();
        },
        resetXmjSpread: function(data = null) {
            const xmj = [];
            if (data && data.lid != 0 && data.xmj_code !== '' && data.xmj_code !== null) {
                if (data.bwmx === data.xmj_jldy) {
                    data.bwmx = '';
                }
                xmj.push(data);
            }
            SpreadJsObj.loadSheetData(xmjSpread.getActiveSheet(), SpreadJsObj.DataType.Data, xmj);
        },
        selectionChanged: function (e, info) {
            const data = SpreadJsObj.getSelectObject(info.sheet);
            changeSpreadObj.resetXmjSpread(data);
        },
        setAuditValue: function () {
            const rowCount = changeSpreadSheet.getRowCount();
            // 用户的数据合计
            for (const j in aidList) {
                for(let i = 0; i <= rowCount - 1; i++){
                    const data = {
                        unit_price: changeSpreadSheet.getValue(i, 3),
                        amount: parseFloat(changeSpreadSheet.getValue(i, 14 + parseInt(j)*2)),
                    };
                    const sum = ZhCalc.round(ZhCalc.mul(data.unit_price, data.amount), totalPriceUnit);
                    changeSpreadSheet.setValue(i, 15 + j*2, sum !== 0 ? sum : null);
                }
            }
        },
        countSum: function() {
            const rowCount = changeSpreadSheet.getRowCount();
            let oSum = 0,
                cSum = 0,
                sSum = 0,
                cdSum = 0;
            for(let i = 0; i < rowCount - 1; i++){
                oSum = ZhCalc.add(oSum, changeSpreadSheet.getValue(i, 7));
                cSum = ZhCalc.add(cSum, changeSpreadSheet.getValue(i, 9));
                sSum = ZhCalc.add(sSum, changeSpreadSheet.getValue(i, 11));
                cdSum = ZhCalc.add(cdSum, changeSpreadSheet.getValue(i, 13));
            }
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 7, oSum !== 0 ? oSum : null);
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 9, cSum !== 0 ? cSum : null);
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 11, sSum !== 0 ? sSum : null);
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 13, cdSum !== 0 ? cdSum : null);
            // 用户的数据合计
            for (const j in aidList) {
                let audit_sum = 0;
                for(let i = 0; i < rowCount - 1; i++){
                    audit_sum = ZhCalc.add(audit_sum, changeSpreadSheet.getValue(i, 15 + j*2));
                }
                changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 15 + j*2, audit_sum !== 0 ? audit_sum : null);
            }
        },
        showHideAudit: function (show = false) {
            const count = changeSpreadSetting.cols.length;
            for (let i = 14; i < count; i++) {
                changeSpreadSheet.setColumnVisible(i, show, GC.Spread.Sheets.SheetArea.viewport);
            }
            changeSpreadSheet.setColumnVisible(10, !show, GC.Spread.Sheets.SheetArea.viewport);
            changeSpreadSheet.setColumnVisible(11, !show, GC.Spread.Sheets.SheetArea.viewport);
        }
    };

    SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol);
    SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting);
    for (const c  of changeList) {
        for (const j of aidList) {
            c['sa_tp_' + j] = ZhCalc.round(ZhCalc.mul(c['audit_amount_' + j], c.unit_price), totalPriceUnit);
        }
    }
    SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
    // changeSpreadObj.setAuditValue();
    changeSpreadObj.makeSjsFooter();
    changeSpreadObj.showHideAudit();
    changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
    changeSpread.bind(spreadNS.Events.SelectionChanged, changeSpreadObj.selectionChanged);

    // 审批流程展示与隐藏
    $('#show-table-detail').on('click', function (e) {
        if($(e.target).is('label')){
            return;
        }
        changeSpreadObj.showHideAudit($(this).is(':checked'));
    });

    // 重新审批获取手机验证码
    // 获取验证码
    let isPosting = false;
    $("#get-code").click(function() {
        if (isPosting) {
            return false;
        }
        const btn = $(this);

        $.ajax({
            url: '/profile/code?_csrf_j=' + csrf,
            type: 'post',
            data: { mobile: authMobile, type: 'shenpi' },
            dataTye: 'json',
            error: function() {
                isPosting = false;
            },
            beforeSend: function() {
                isPosting = true;
            },
            success: function(response) {
                isPosting = false;
                if (response.err === 0) {
                    codeSuccess(btn);
                    $("input[name='code']").removeAttr('readonly');
                    // $("#re-shenpi-btn").removeAttr('disabled');
                    $("#re-shenpi-btn2").removeAttr('disabled');
                } else {
                    toast(response.msg, 'error');
                }
            }
        });
    });
});
/**
 * 获取成功后的操作
 *
 * @param {Object} btn - 点击的按钮
 * @return {void}
 */
function codeSuccess(btn) {
    let counter = 60;
    btn.addClass('disabled').text('重新获取 ' + counter + 'S');
    btn.parent().siblings('input').removeAttr('readonly').attr('placeholder', '输入短信中的6位验证码');
    const bindBtn = $("#bind-btn");
    bindBtn.removeClass('btn-secondary disabled').addClass('btn-primary');

    const countDown = setInterval(function() {
        const countString = counter - 1 <= 0 ? '' : ' ' + (counter - 1) + 'S';
        // 倒数结束后
        if (countString === '') {
            clearInterval(countDown);
            btn.removeClass('disabled');
        }
        const text = '重新获取' + countString;
        btn.text(text);
        counter -= 1;
    }, 1000);
}