| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203 |
- var ExcelData, ExcelKind;
- 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 layActivationTime = laydate.render({
- elem: '#ActivationTime',
- 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;
- layActivationTime.hint('日期范围请不要超过1个月');
- setTimeout(function () {
- $(".laydate-btns-confirm").addClass("laydate-disabled");
- }, 1);
- }
- } else {
- op = false;
- layActivationTime.hint('日期范围请不要超过1个月');
- setTimeout(function () {
- $(".laydate-btns-confirm").addClass("laydate-disabled");
- }, 1);
- }
- if (op) {
- $('#ActivationTime').val(value);
- }
- }
- });
- var layBindingTime = laydate.render({
- elem: '#BindingTime',
- 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;
- layBindingTime.hint('日期范围请不要超过1个月');
- setTimeout(function () {
- $(".laydate-btns-confirm").addClass("laydate-disabled");
- }, 1);
- }
- } else {
- op = false;
- layBindingTime.hint('日期范围请不要超过1个月');
- setTimeout(function () {
- $(".laydate-btns-confirm").addClass("laydate-disabled");
- }, 1);
- }
- if (op) {
- $('#BindingTime').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/StoreHouse/Sort?r=" + Math.random(1),
- data: "Id=" + data.Id + "&Sort=" + value,
- dataType: "text",
- success: function (data) { }
- });
- }
- });
- //列表数据
- table.render({
- elem: '#LAY-list-manage'
- , url: '/Admin/SysTools/Team1InfoDo' //模拟接口
- , cols: [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'wname', width: 200, title: '伙伴名称', sort: true }
- , { field: 'Name', width: 200, title: '机具品牌', sort: true }
- , { field: 'PosSn', width: 200, title: '机具Sn', sort: true }
- , { field: 'merchantname', width: 200, title: '商户姓名', sort: true }
- , { field: 'SeoKeyword', width: 200, title: '服务费', sort: true }
- , { field: 'BindingTime', width: 200, title: '绑定时间', sort: true }
- , { field: 'ActivationTime', width: 200, title: '激活时间', sort: true }
- , { field: 'amount', width: 200, title: '返现金额', sort: true }
- , { field: 'maxdate', width: 200, title: '返现时间', sort: true }
- , { field: 'CreditRewardAmount', width: 200, title: '开机奖', sort: true }
- , { field: 'opdate', width: 200, title: '开机奖发放时间', sort: true }
- , { field: 'info', width: 200, title: '发放对象', sort: true }
- ]]
- , where: {
- }
- , page: true
- , limit: 30
- , height: 'full-' + String($('.layui-card-header').height() + 130)
- , text: '对不起,加载出现异常!'
- , done: function (res, curr, count) {
- $(".layui-none").text("无数据");
- }
- });
- $('.layui-btn').on('click', function () {
- var type = $(this).data('type');
- active[type] ? active[type].call(this) : '';
- });
- //监听工具条
- table.on('tool(LAY-list-manage)', function (obj) {
- var data = obj.data;
- });
- //监听搜索
- 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-searchall)', function (data) {
- table.reload('LAY-list-manage', {
- where: null,
- page: {
- curr: 1
- }
- });
- });
- //事件
- var active = {
- 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()) + '&';
- });
- var index = layer.confirm('确定导出吗?', function (index) {
- var indexs = layer.load(1, {
- shade: [0.5, '#000']
- });
- $.ajax({
- type: "POST",
- url: "/Admin/SysTools/ExportTeam1InfoExcelDo?r=" + Math.random(1),
- data: userdata,
- dataType: "text",
- success: function (data) {
- layer.close(index); //关闭弹层
- if (data == "success") {
- layer.close(indexs); //关闭弹层
- layer.msg('导出成功,请到我的下载中点击下载文件', {
- time: 1000
- }, function () {
- window.location.reload();
- });
- } else {
- layer.close(indexs); //关闭弹层
- layer.msg(data);
- }
- }
- });
- });
- },
- };
- $('.layui-btn').on('click', function () {
- var type = $(this).data('type');
- active[type] ? active[type].call(this) : '';
- });
- });
|