kxs-admin/wwwroot/layuiadmin/modules_main/TradeRecord_Admin.js

var ExcelData;
function ConfirmImport() {
    $.ajax({
        type: "POST",
        url: "/Admin/TradeRecord/Import?r=" + Math.random(1),
        data: "ExcelData=" + encodeURIComponent(JSON.stringify(ExcelData)),
        dataType: "text",
        success: function (data) {
            if (data == "success") {
                layer.msg("导入成功", { time: 2000 }, function () {
                    window.location.reload();
                });
            } else {
                layer.msg(data);
            }
        }
    });
}

function ConfirmImportTrade() {
    $.ajax({
        type: "POST",
        url: "/Admin/TradeRecord/ImportTrade?r=" + Math.random(1),
        data: "ExcelData=" + encodeURIComponent(JSON.stringify(ExcelData)),
        dataType: "text",
        success: function (data) {
            if (data == "success") {
                layer.msg("导入成功", { time: 2000 }, function () {
                    window.location.reload();
                });
            } else {
                layer.msg(data);
            }
        }
    });
}

function CheckImport(table, key, loadindex, index) {
    $.ajax({
        url: "/Admin/TradeRecord/CheckImportV2?r=" + Math.random(1),
        data: "key=" + key,
        dataType: "json",
        success: function (data) {
            console.log(data);
            if (data.status == 1) {
                layer.msg("成功操作" + data.data + "条", {
                    time: 2000
                }, function () {
                    layer.close(index); //关闭弹层
                    layer.close(loadindex);
                    table.reload('LAY-list-manage'); //数据刷新
                });
            } else if (data.status == 2) {
                layer.close(index); //关闭弹层
                layer.close(loadindex);
                var content = '';
                for (var i = 0; i < data.errList.length; i++) {
                    content += data.errList[i] + '<br/>'
                }
                layer.alert(content);
            } else {
                layer.msg(data.data, {
                    time: 1000
                }, function () {
                    CheckImport(table, key, loadindex, index);
                });
            }
        }
    });
}

var excel;
layui.config({
    base: '/layuiadmin/' //静态资源所在路径
}).extend({
    myexcel: 'layui/lay/modules/excel',
    index: 'lib/index' //主入口模块
}).use(['index', 'table', 'excel', 'laydate'], function () {
    var $ = layui.$
        , form = layui.form
        , table = layui.table;

    //- 筛选条件-日期
    var laydate = layui.laydate;
    var layCreateDate = laydate.render({
        elem: '#CreateDate',
        type: 'date',
        range: true,
        trigger: 'click',
        change: function (value, date, endDate) {
            var op = true;
            if (date.year == endDate.year && endDate.month - date.month <= 1) {
                if (endDate.month - date.month == 1 && endDate.date > date.date) {
                    op = false;
                    layCreateDate.hint('日期范围请不要超过1个月');
                    setTimeout(function () {
                        $(".laydate-btns-confirm").addClass("laydate-disabled");
                    }, 1);
                }
            } else {
                op = false;
                layCreateDate.hint('日期范围请不要超过1个月');
                setTimeout(function () {
                    $(".laydate-btns-confirm").addClass("laydate-disabled");
                }, 1);
            }
            if (op) {
                $('#CreateDate').val(value);
            }
        }
    });
    var layTradeDate = laydate.render({
        elem: '#TradeDate',
        trigger: 'click',
        type: 'date',
        range: true,
        change: function (value, date, endDate) {
            var op = true;
            if (date.year == endDate.year && endDate.month - date.month <= 2) {
                if (endDate.month - date.month == 2 && endDate.date > date.date) {
                    op = false;
                    layTradeDate.hint('日期范围请不要超过2个月');
                    setTimeout(function () {
                        $(".laydate-btns-confirm").addClass("laydate-disabled");
                    }, 1);
                }
            } else {
                op = false;
                layTradeDate.hint('日期范围请不要超过2个月');
                setTimeout(function () {
                    $(".laydate-btns-confirm").addClass("laydate-disabled");
                }, 1);
            }
            if (op) {
                $('#TradeDate').val(value);
            }
        }
    });


    //excel导入
    excel = layui.excel;
    $('#ExcelFile').change(function (e) {
        var files = e.target.files;
        excel.importExcel(files, {}, function (data) {
            ExcelData = data[0].sheet1;
        });
    });

    //监听单元格编辑
    table.on('edit(LAY-list-manage)', function (obj) {
        var value = obj.value //得到修改后的值
            , data = obj.data //得到所在行所有键值
            , field = obj.field; //得到字段
        if (field == "Sort") {
            $.ajax({
                type: "POST",
                url: "/Admin/TradeRecord/Sort?r=" + Math.random(1),
                data: "Id=" + data.Id + "&Sort=" + value,
                dataType: "text",
                success: function (data) {
                }
            });
        }
    });

    //列表数据
    table.render({
        elem: '#LAY-list-manage'
        , url: '/Admin/TradeRecord/IndexData' //模拟接口
        , cols: [[
            { type: 'checkbox', fixed: 'left' }


            , { field: 'MakerCode', width: 200, title: '创客编码', sort: true }
            , { field: 'RealName', width: 200, title: '创客姓名', sort: true }
            // , { field: 'TopMakerCode', width: 200, title: '顶级创客编码', sort: true }
            // , { field: 'TopRealName', width: 200, title: '顶级创客名称', sort: true }
            , { field: 'MerchantNo', width: 200, title: '商户编号', sort: true }
            , { field: 'MerchantName', width: 200, title: '商户名称', sort: true }
            , { field: 'MerMakerCode', width: 200, title: '商户直属创客编号', sort: true }
            , { field: 'MerRealName', width: 200, title: '商户直属创客姓名', sort: true }
            , { field: 'MerNo', width: 200, title: '快钱商户编号', sort: true }
            , { field: 'MerBuddyType', width: 200, title: '商户创客类型', sort: true }
            , { field: 'SnNo', width: 200, title: '快钱SN号', sort: true }
            , { field: 'MerHelpFlag', width: 200, title: '是否属于扶持周期内商户', sort: true }
            , { field: 'HelpMonthCount', width: 200, title: '扶持第几个月', sort: true }
            // ,{field:'TradeDate', width: 200, title:'交易日期', sort: true}
            , { field: 'CreateDate', width: 200, title: '交易日期', sort: true }
            , { field: 'TradeSerialNo', width: 200, title: '交易流水号', sort: true }
            , { field: 'TradeAmount', width: 200, title: '交易金额(元)', sort: true }
            , { field: 'BankCardType', width: 200, title: '银行卡类型', sort: true }
            , { field: 'CapFlag', width: 200, title: '借记卡封顶交易标志', sort: true }
            , { field: 'QrPayFlag', width: 200, title: '云闪付标识', sort: true }
            , { field: 'DirectFlag', width: 200, title: '是否直营', sort: true }
        ]]
        , where: {
            BrandId: BrandId
        }
        , page: true
        , limit: 30
        , height: 'full-' + String($('.layui-card-header').height() + 130)
        , text: '对不起，加载出现异常！'
        , done: function (res, curr, count) {
            $("#TotalTrade0").text(res.other.TotalTrade0);
            $("#TotalTrade1").text(res.other.TotalTrade1);
            $(".layui-none").text("无数据");
        }
    });


    // //激活预览列表数据
    // table.render({
    //     elem: '#LAY-list-managesim'
    //     , url: '/Admin/TradeRecord/IndexDataSIMDo' //模拟接口
    //     , cols: [[
    //         { type: 'checkbox', fixed: 'left' }
    //         , { field: 'iccId', width: 200, title: '广电卡号', sort: true } //广电卡号
    //         , { field: 'orderNo', width: 200, title: '订单编码', sort: true } //订单编码
    //         , { field: 'orderCreateTime', width: 200, title: '订单创建时间', sort: true } //订单创建时间
    //         , { field: 'phoneNo', width: 200, title: '选择号码', sort: true } //选择号码
    //         , { field: 'firstCharge', width: 200, title: '是否有首充', sort: true } //是否有首充
    //         , { field: 'initialChargeAmount', width: 200, title: '首充金额（元）', sort: true } //首充金额（元）
    //         , { field: 'province', width: 200, title: '号码归属省份', sort: true } //号码归属省份
    //         , { field: 'city', width: 200, title: '号码归属地市', sort: true } //号码归属地市
    //         , { field: 'productName', width: 200, title: '商品名称', sort: true } //商品名称
    //         , { field: 'promotionName', width: 200, title: '促销活动名称', sort: true } //促销活动名称
    //         , { field: 'productTypeName', width: 200, title: '商品类型名称', sort: true } //商品类型名称
    //         , { field: 'paidInAmount', width: 200, title: '实付金额', sort: true } //实付金额(元)
    //         , { field: 'orderStatus', width: 200, title: '订单状态', sort: true } //订单状态
    //         , { field: 'activationStatusName', width: 200, title: '激活状态名称', sort: true } //激活状态名称
    //         , { field: 'activationTime', width: 200, title: '激活时间', sort: true } //激活时间
    //         , { field: 'jobId', width: 200, title: 'BOSS员工工号', sort: true } //BOSS员工工号
    //     ]]
    //     , where: {
    //         DateStr: DateStr
    //     }
    //     , page: true
    //     , limit: 30
    //     , height: 'full-' + String($('.layui-card-header').height() + 130)
    //     , text: '对不起，加载出现异常！'
    //     , done: function (res, curr, count) {
    //         $(".layui-none").text("无数据");
    //     }
    // });

    //监听工具条
    table.on('tool(LAY-list-manage)', function (obj) {
        var data = obj.data;
        if (obj.event === 'del') {
            var index = layer.confirm('确定要删除吗？删除后不能恢复！', function (index) {
                $.ajax({
                    type: "POST",
                    url: "/Admin/TradeRecord/Delete?r=" + Math.random(1),
                    data: "Id=" + data.Id,
                    dataType: "text",
                    success: function (data) {
                        if (data == "success") {
                            obj.del();
                            layer.close(index);
                        } else {
                            parent.layer.msg(data);
                        }
                    }
                });
            });
        } else if (obj.event === 'edit') {
            var tr = $(obj.tr);
            var perContent = layer.open({
                type: 2
                , title: '交易记录-编辑'
                , content: 'Edit?Id=' + data.Id + ''
                , maxmin: true
                , area: ['500px', '450px']
                , btn: ['确定', '取消']
                , yes: function (index, layero) {
                    var iframeWindow = window['layui-layer-iframe' + index]
                        , submitID = 'LAY-list-front-submit'
                        , submit = layero.find('iframe').contents().find('#' + submitID);

                    setTimeout(function () {
                        layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
                            var errObj = $(this).find('.layui-form-danger');
                            if (errObj.length > 0) {
                                iframeWindow.element.tabChange('mytabbar', String(i + 1));
                                submit.click();
                            }
                        });
                    }, 300);






                    //监听提交
                    iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
                        var field = data.field; //获取提交的字段
                        var userdata = "";
                        for (var prop in field) {
                            userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
                        }
                        //提交 Ajax 成功后，静态更新表格中的数据
                        //$.ajax({});

                        $.ajax({
                            type: "POST",
                            url: "/Admin/TradeRecord/Edit?r=" + Math.random(1),
                            data: userdata,
                            dataType: "text",
                            success: function (data) {
                                layer.close(index); //关闭弹层
                                if (data == "success") {
                                    table.reload('LAY-list-manage'); //数据刷新
                                } else {
                                    layer.msg(data);
                                }
                            }
                        });
                    });

                    submit.trigger('click');
                }
                , success: function (layero, index) {

                }
            });
            layer.full(perContent);
        }
    });


    //监听搜索
    form.on('submit(LAY-list-front-search)', function (data) {
        var field = data.field;

        //执行重载
        table.reload('LAY-list-manage', {
            where: field,
            page: {
                curr: 1
            }
        });
    });

    // form.on('submit(LAY-list-front-searchsim)', function (data) {
    //     var field = data.field;

    //     //执行重载
    //     table.reload('LAY-list-managesim', {
    //         where: field,
    //         page: {
    //             curr: 1
    //         }
    //     });
    // });

    form.on('submit(LAY-list-front-searchall)', function (data) {
        table.reload('LAY-list-manage', {
            where: null,
            page: {
                curr: 1
            }
        });
    });

    //事件
    var active = {
        batchdel: function () {
            var checkStatus = table.checkStatus('LAY-list-manage')
                , data = checkStatus.data; //得到选中的数据
            if (data.length < 1) {
                parent.layer.msg("请选择要删除的项");
            } else {
                var ids = "";
                $.each(data, function (index, value) {
                    ids += data[index].Id + ",";
                });
                ids = ids.substring(0, ids.length - 1);
                var index = layer.confirm('确定要删除吗？删除后不能恢复！', function (index) {
                    $.ajax({
                        type: "POST",
                        url: "/Admin/TradeRecord/Delete?r=" + Math.random(1),
                        data: "Id=" + ids,
                        dataType: "text",
                        success: function (data) {
                            layer.close(index);
                            if (data == "success") {
                                table.reload('LAY-list-manage');
                            } else {
                                layer.msg(data);
                            }
                        }
                    });
                });
            }
        }
        , add: function () {
            var perContent = layer.open({
                type: 2
                , title: '交易记录-添加'
                , content: 'Add'
                , maxmin: true
                , area: ['500px', '450px']
                , btn: ['确定', '取消']
                , yes: function (index, layero) {
                    var iframeWindow = window['layui-layer-iframe' + index]
                        , submitID = 'LAY-list-front-submit'
                        , submit = layero.find('iframe').contents().find('#' + submitID);

                    setTimeout(function () {
                        layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
                            var errObj = $(this).find('.layui-form-danger');
                            if (errObj.length > 0) {
                                iframeWindow.element.tabChange('mytabbar', String(i + 1));
                                submit.click();
                            }
                        });
                    }, 300);






                    //监听提交
                    iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
                        var field = data.field; //获取提交的字段
                        var userdata = "";
                        for (var prop in field) {
                            userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
                        }
                        //提交 Ajax 成功后，静态更新表格中的数据
                        //$.ajax({});

                        $.ajax({
                            type: "POST",
                            url: "/Admin/TradeRecord/Add?r=" + Math.random(1),
                            data: userdata,
                            dataType: "text",
                            success: function (data) {
                                layer.close(index); //关闭弹层
                                if (data == "success") {
                                    table.reload('LAY-list-manage'); //数据刷新
                                } else {
                                    layer.msg(data);
                                }
                            }
                        });
                    });

                    submit.trigger('click');
                }
            });
            layer.full(perContent);
        }
        , Import: function () {
            // var perContent = layer.open({
            //     type: 2,
            //     title: '导激活',
            //     content: 'Import',
            //     maxmin: true,
            //     area: ['650px', '350px'],
            //     btn: ['确定', '取消'],
            //     yes: function (index, layero) {
            //         var iframeWindow = window['layui-layer-iframe' + index],
            //             submitID = 'LAY-list-front-submit',
            //             submit = layero.find('iframe').contents().find('#' + submitID);


            //         //监听提交
            //         iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
            //             var field = data.field; //获取提交的字段
            //             var userdata = "";
            //             for (var prop in field) {
            //                 userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
            //             }
            //             //提交 Ajax 成功后，静态更新表格中的数据
            //             //$.ajax({});
            //             var loadindex = layer.load(1, {
            //                 shade: [0.5, '#000']
            //             });
            //             $.ajax({
            //                 type: "POST",
            //                 url: "/Admin/TradeRecord/ImportPost?r=" + Math.random(1),
            //                 data: userdata,
            //                 dataType: "text",
            //                 success: function (data) {
            //                     layer.close(loadindex);
            //                     if (data == 'success') {
            //                         layer.msg('导入成功', {time:2000}, function(){
            //                             window.location.reload();
            //                         });
            //                     } else {
            //                         layer.msg(data);
            //                     }
            //                 }
            //             });
            //         });

            //         submit.trigger('click');
            //     }
            // });

            var perContent = layer.open({
                type: 2,
                title: '导激活',
                content: 'ImportTrade?ExcelKind=1',
                maxmin: true,
                area: ['650px', '350px'],
                btn: ['确定', '取消'],
                yes: function (index, layero) {
                    var iframeWindow = window['layui-layer-iframe' + index],
                        submitID = 'LAY-list-front-submit',
                        submit = layero.find('iframe').contents().find('#' + submitID);


                    //监听提交
                    iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
                        var field = data.field; //获取提交的字段
                        var userdata = "";
                        for (var prop in field) {
                            userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
                        }
                        //提交 Ajax 成功后，静态更新表格中的数据
                        //$.ajax({});
                        var loadindex = layer.load(1, {
                            shade: [0.5, '#000']
                        });
                        $.ajax({
                            type: "POST",
                            url: "/Admin/TradeRecord/ImportByQueuePost?r=" + Math.random(1),
                            data: userdata,
                            dataType: "text",
                            success: function (data) {
                                if (data.indexOf("success") == 0) {
                                    var datalist = data.split('|');
                                    var key = datalist[1];
                                    CheckImport(table, key, loadindex, index);
                                } else {
                                    layer.msg(data);
                                }
                            }
                        });
                    });

                    submit.trigger('click');
                }
            });
        }
        , ImportTrade: function () {
            // var perContent = layer.open({
            //     type: 2,
            //     title: '导交易',
            //     content: 'ImportTrade',
            //     maxmin: true,
            //     area: ['650px', '350px'],
            //     btn: ['确定', '取消'],
            //     yes: function (index, layero) {
            //         var iframeWindow = window['layui-layer-iframe' + index],
            //             submitID = 'LAY-list-front-submit',
            //             submit = layero.find('iframe').contents().find('#' + submitID);


            //         //监听提交
            //         iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
            //             var field = data.field; //获取提交的字段
            //             var userdata = "";
            //             for (var prop in field) {
            //                 userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
            //             }
            //             //提交 Ajax 成功后，静态更新表格中的数据
            //             //$.ajax({});
            //             var loadindex = layer.load(1, {
            //                 shade: [0.5, '#000']
            //             });
            //             $.ajax({
            //                 type: "POST",
            //                 url: "/Admin/TradeRecord/ImportTradePost?r=" + Math.random(1),
            //                 data: userdata,
            //                 dataType: "text",
            //                 success: function (data) {
            //                     layer.close(loadindex);
            //                     if (data.indexOf('success') == 0) {
            //                         var count = data.split('|')[1];
            //                         layer.msg('成功导入' + count + '条');
            //                     } else {
            //                         layer.msg(data);
            //                     }
            //                 }
            //             });
            //         });

            //         submit.trigger('click');
            //     }
            // });

            var perContent = layer.open({
                type: 2,
                title: '导交易',
                content: 'ImportTrade?ExcelKind=2',
                maxmin: true,
                area: ['650px', '350px'],
                btn: ['确定', '取消'],
                yes: function (index, layero) {
                    var iframeWindow = window['layui-layer-iframe' + index],
                        submitID = 'LAY-list-front-submit',
                        submit = layero.find('iframe').contents().find('#' + submitID);


                    //监听提交
                    iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
                        var field = data.field; //获取提交的字段
                        var userdata = "";
                        for (var prop in field) {
                            userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
                        }
                        //提交 Ajax 成功后，静态更新表格中的数据
                        //$.ajax({});
                        var loadindex = layer.load(1, {
                            shade: [0.5, '#000']
                        });
                        $.ajax({
                            type: "POST",
                            url: "/Admin/TradeRecord/ImportByQueuePost?r=" + Math.random(1),
                            data: userdata,
                            dataType: "text",
                            success: function (data) {
                                if (data.indexOf("success") == 0) {
                                    var datalist = data.split('|');
                                    var key = datalist[1];
                                    CheckImport(table, key, loadindex, index);
                                } else {
                                    layer.msg(data);
                                }
                            }
                        });
                    });

                    submit.trigger('click');
                }
            });
        }
        , ExportExcel: function () {
            var userdata = '';
            $(".layuiadmin-card-header-auto input").each(function (i) {
                userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
            });
            $(".layuiadmin-card-header-auto select").each(function (i) {
                userdata += $(this).attr('name') + '=' + encodeURIComponent($(this).val()) + '&';
            });
            $.ajax({
                type: "GET",
                url: "/Admin/TradeRecord/ExportExcel?r=" + Math.random(1),
                data: userdata,
                dataType: "json",
                success: function (data) {
                    data.Obj.unshift(data.Fields);
                    excel.exportExcel(data.Obj, data.Info, 'xlsx');
                }
            });
        }
        , Open: function () {
            var checkStatus = table.checkStatus('LAY-list-manage')
                , data = checkStatus.data; //得到选中的数据
            if (data.length < 1) {
                parent.layer.msg("请选择要开启的项");
            } else {
                var ids = "";
                $.each(data, function (index, value) {
                    ids += data[index].Id + ",";
                });
                ids = ids.substring(0, ids.length - 1);
                var index = layer.confirm('确定要开启吗？', function (index) {
                    $.ajax({
                        type: "POST",
                        url: "/Admin/TradeRecord/Open?r=" + Math.random(1),
                        data: "Id=" + ids,
                        dataType: "text",
                        success: function (data) {
                            layer.close(index);
                            if (data == "success") {
                                table.reload('LAY-list-manage');
                            } else {
                                layer.msg(data);
                            }
                        }
                    });
                });
            }
        }
        , Close: function () {
            var checkStatus = table.checkStatus('LAY-list-manage')
                , data = checkStatus.data; //得到选中的数据
            if (data.length < 1) {
                parent.layer.msg("请选择要关闭的项");
            } else {
                var ids = "";
                $.each(data, function (index, value) {
                    ids += data[index].Id + ",";
                });
                ids = ids.substring(0, ids.length - 1);
                var index = layer.confirm('确定要关闭吗？', function (index) {
                    $.ajax({
                        type: "POST",
                        url: "/Admin/TradeRecord/Close?r=" + Math.random(1),
                        data: "Id=" + ids,
                        dataType: "text",
                        success: function (data) {
                            layer.close(index);
                            if (data == "success") {
                                table.reload('LAY-list-manage');
                            } else {
                                layer.msg(data);
                            }
                        }
                    });
                });
            }
        }
        , GetActInfo: function () {
            var perContent = layer.open({
                type: 2
                , title: '获取广电卡激活数据'
                , content: 'GetSimTrade'
                , maxmin: true
                , area: ['500px', '450px']
                , btn: ['确定', '取消']
                , yes: function (index, layero) {
                    var iframeWindow = window['layui-layer-iframe' + index]
                        , submitID = 'LAY-list-front-submit'
                        , submit = layero.find('iframe').contents().find('#' + submitID);

                    setTimeout(function () {
                        layero.find('iframe').contents().find('.layui-tab-item').each(function (i) {
                            var errObj = $(this).find('.layui-form-danger');
                            if (errObj.length > 0) {
                                iframeWindow.element.tabChange('mytabbar', String(i + 1));
                                submit.click();
                            }
                        });
                    }, 300);


                    //监听提交
                    iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
                        var field = data.field; //获取提交的字段
                        var userdata = "";
                        for (var prop in field) {
                            userdata += prop + "=" + encodeURIComponent(field[prop]) + "&";
                        }
                        //提交 Ajax 成功后，静态更新表格中的数据
                        //$.ajax({});

                        $.ajax({
                            type: "POST",
                            url: "/Admin/TradeRecord/GetSimTradePost?r=" + Math.random(1),
                            data: userdata,
                            dataType: "text",
                            success: function (data) {
                                layer.close(index); //关闭弹层
                                if (data == "success") {
                                    layer.msg("提交成功");
                                } else {
                                    layer.msg(data);
                                }
                            }
                        });
                    });

                    submit.trigger('click');
                }
            });
        }
    };

    $('.layui-btn').on('click', function () {
        var type = $(this).data('type');
        active[type] ? active[type].call(this) : '';
    });
});