messagelist.html 3.97 KB
{include file="common/head"/}
<form class="layui-form layui-form-pane">
<div class="admin-main layui-anim layui-anim-upbit">
    <fieldset class="layui-elem-field layui-field-title">
        <legend>{:$title}</legend>
    </fieldset>
    <div class="demoTable">
        商家:
        <div class="layui-input-inline">
            <input class="layui-input" name="key" id="key"  placeholder="{:lang('pleaseEnter')}店铺名称" autocomplete="off">
        </div>
        给谁发:
        <div class="layui-input-inline" >
            <input type="checkbox" name="role[write]" lay-skin="primary" title="客户经理">
            <input type="checkbox" name="role[read]" lay-skin="primary" title="老板">
            <input type="checkbox" name="role[game]" lay-skin="primary" title="前台">
        </div>
        商家来源:
        <div class="layui-input-inline layui-form">
                <div class="layui-input-8">
                    <select name="class" id="channel" lay-filter="myselect">
                            <option value="1">合作</option>
                            <option value="2">推广</option>
                            <option value="3">测试</option>
                    </select>
                </div>
        </div>
        <button class="layui-btn"  id="search" data-type="reload">查询统计</button>
    </div>
    <table class="layui-table" id="list" lay-filter="list">
    </table>
</div>
</form>
{include file="common/foot"/}
<script>
    layui.use(['table','form','laydate'], function() {
        var table = layui.table,laydate = layui.laydate,$ = layui.jquery;
        console.log(layui);
        var tableIn = table.render({
            elem: '#list',
            url: '{:url("messagelist")}',
            method: 'post',
            title: '预定订单统计',
            page:true,
            cols: [[
                {checkbox:true,fixed: true},
                {field: 'sellername', title: 'FORMID'},
                {field: 'reserve_count_sort', title: 'OPENID'},
                {field: 'reserve_count', title: '失效时间'},
                {field: 'sms_send_count_sort',title: '可发送总数'},
                {field: 'sms_send_count',title: 'ID-商家'},
                {field: 'inviting',title: '角色'},
                {field: 'inviting',title: '昵称'},
                {field: 'inviting',title: '最后预定时间(小程序/电话机)'},
            ]],
            done: function(res, curr, count){
            }
            ,id: 'testReload'
            ,page: true
            ,limit:20
        });

        //日期时间范围
        laydate.render({
            elem: '#time'
            ,type: 'datetime'
            ,range: true
        });

        //搜索
        $('#search').on('click', function() {
            //关键字
            var key = $('#key').val();
            //选中的商家ID
            var checkStatus = table.checkStatus('testReload'); //test即为参数id设定的值
            var a = [];
            $(checkStatus.data).each(function(i,o){
                a.push(o.id);
            });
            console.log(a);
            
            var time = $('#time').val();
            console.log(time);
            //商家来源
            var channel = $('#channel').val();
            console.log(channel);
            //筛选条件
            var time_type = $('#time_type').val();
            console.log(time_type);
            //传参
            tableIn.reload({ page: {page: 1},where: {key: key,sid: a,time_type: time_type,time: time,channel: channel}});
        });

        var $ = layui.$, active = {
            reload: function(){
              var key = $('#key');
                //执行重载
                table.reload('testReload', {
                page: {
                  curr: 1 //重新从第 1 页开始
                }
                ,where: {
                  key: {
                    id: key.val()
                  }
                }
                });
            }
        };
    })
</script>