get_statistics.html 5.91 KB
{include file="common/head"/}
<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="text" style = "width:300px"; class="layui-input" id="time" placeholder="默认为当天的统计情况">
        </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="1" selected>合作</option>
                            <option value="2">推广</option>
                            <option value="3">测试</option>
                    </select>
                </div>
        </div>
        筛选条件:
        <div class="layui-input-inline layui-form">
                <div class="layui-input-8">
                    <select name="class" id="time_type" lay-filter="myselect">
                            <option value="1">录入时间</option>
                            <option value="2">到店时间</option>
                    </select>
                </div>
        </div>
        <!--地区:
        <div class="layui-input-inline">
            <input type="text" class="layui-input" id="area" placeholder="地区暂未开放">
        </div>-->
        <button class="layui-btn"  id="search" data-type="reload">查询统计</button>
    </div>
    <table class="layui-table" id="list" lay-filter="list">
    </table>
</div>
<script type="text/html" id="toolbarDemo">
    <span>订单总数:<i id="count">X</i>条 【小程序 <i id="appReserveCount">X</i>  / 座机 <i id="AndroidReserveCount">D</i>  / C端 <i id="CReserveCount">C</i>】</span>
    <span>短信发送数量:<i id="size">Y</i>条 【小程序 <i id="appSmsCount">Y</i>  / 座机 <i id="AndroidSmsCount">Y</i>】</span>
    <span>邀请总数:<i id="invitee">Z</i>条</span>
    <span>联系人总数:<i id="Contacts">W</i>条</span>
</script>
{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("getStatistics")}',
            method: 'post',
            title: '预定订单统计',
            page:true,
            sort:true,
            toolbar: '#toolbarDemo',
            cols: [[
                {checkbox:true,fixed: true},
                {field: 'id', title: '{:lang("id")}',width:60, fixed: true},
                {field: 'address_component', title: '省-市', sort: true},
                {field: 'sellername', title: '商家名称'},
                {field: 'contacts_total', title: '联系人总数',width:110, sort: true},
                {field: 'table_room_total', title: '桌位/包间(总数)',width:130},
                {field: 'reserve_count_sort', align: 'right', title: '预定总量',width:100, sort: true},
                {field: 'reserve_count', align: 'left', title: '订单构成(小程序/座机/C端)',width:220},
                {field: 'sms_send_count_sort', align: 'right',title: '短信发送总量',colspan:1, sort: true},
                {field: 'sms_send_count', align: 'left',title: '短信发送构成(小程序/座机)'},
                {field: 'inviting', align: 'center',title: '当前商户通过邀请函拉到的顾客', sort: true},
            ]],
            done: function(res, curr, count){
                $('#count').html(res.countReserve);
                $('#size').html(res.countSms);
                $('#invitee').html(res.inviteeCount);
                $('#appReserveCount').html(res.appReserveCount);
                $('#AndroidReserveCount').html(res.AndroidReserveCount);
                $('#CReserveCount').html(res.CReserveCount);
                $('#appSmsCount').html(res.appSmsCount);
                $('#AndroidSmsCount').html(res.AndroidSmsCount);
                $('#Contacts').html(res.Contacts);
            }
            ,id: 'testReload'
            ,page: true
            ,limit:15
        });

        //日期时间范围
        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>