常用查询之按时间范围查询,按名称查询

html

<include file="Public:header" />
<include file="Public:nav" />
<div id="page-wrapper">
    <div class="container-fluid">
        <div class="row">


            <div class="col-lg-12">

                <ol class="breadcrumb">
                    <include file="Public:listCrumbs" />
                </ol>
            </div>
        </div>

        <div class="alert sb-alert alert-gray margin-left-right-20 margin-top-10 margin-bottom-20">
            <div class="row">
                <div class="col-lg-4 search-margin">
                    <span class="input-group input-group-sm">
                        <span class="input-group-addon" id="uid"><b>支付时间:</b></span>
                        <input class="form-control-erbi col-lg-4" onclick="WdatePicker({dateFmt:'yyyy-MM-dd'})" onfocus="WdatePicker({dateFmt:'yyyy-MM-dd'})" type="text" id="start_time" placeholder='开始时间' value="<?php echo $start_time; ?>" />
                        <span style="display: block;float: left;margin-top: 5px;margin-left: 5px;margin-right: 5px;">-</span>
                        <input class="form-control-erbi col-lg-4" onclick="WdatePicker({dateFmt:'yyyy-MM-dd'})" onfocus="WdatePicker({dateFmt:'yyyy-MM-dd'})" type="text" id="end_time" placeholder='结束时间' value="<?php echo $end_time; ?>" />
                        <img onclismoothck="WdatePicker()" src="/plugin/My97DatePicker/skin/datePicker2.gif" style="display: block;float: left;margin-top: 5px;margin-left: 5px;" width="16" height="22" align="absmiddle">
                    </span>
                </div>

                <div class="col-lg-3 search-margin">
                    <span class="input-group input-group-sm">
                        <span class="input-group-addon"><b>企业名称:</b></span>
                        <input class="form-control-erbi col-lg-10 yh-style" type="text" id="company_name" placeholder='企业名称' value="<?php echo $company_name; ?>" />
                    </span>
                </div>

                <button type="button" class="btn btn-sm btn-primary" style="float: right; margin-right: 40px;" id="search">
                    <i class="fa fa-search" aria-hidden="true"></i> 查询
                </button>
            </div>
        </div>

        <div class="row">
            <div class="col-lg-12">
                <div class="panel panel-default">
                    <!-- /.panel-heading -->
                    <div class="panel-body" style="padding-top: 10px;">
                        <div class="table-responsive">
                            <table class="table table-striped table-bordered table-hover">
                                <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>充值企业</th>
                                    <th>充值单号</th>
                                    <th>微信支付流水号</th>
                                    <th>充值金额(元)</th>
                                    <th>会员年限</th>
                                    <th>支付时间</th>
                                </tr>
                                </thead>
                                <tbody id="tbody">
                                <volist name="result" id="vo">
                                    <tr data-id="{$vo.id}" data-table="banner">
                                        <td>{$vo.id}</td>
                                        <td><span class="over-ellipsis">{$vo.company_uid}-{$vo.company_name}</span></td>
                                        <td>{$vo.order_num}</td>
                                        <td>{$vo.transaction_id}</td>
                                        <td>{$vo.amount}</td>
                                        <td>{$vo.year}</td>
                                        <td>{$vo.pay_time|date='Y-m-d H:i',###}</td>
                                    </tr>
                                </volist>
                                </tbody>
                            </table>
                            <include file="Public:page" />
                            <input type="hidden" name="page" id="page" value="{$page}" />
                        </div>
                        <!-- /.table-responsive -->
                    </div>
                    <!-- /.panel-body -->
                </div>
                <!-- /.panel -->
            </div>
        </div>

    </div>
    <!-- /.container-fluid -->

</div>
<include file="Public:bottomJs" />

<script>
    function get_search(){
        let start_time = $("#start_time").val();
        let end_time = $("#end_time").val();
        let company_name = $("#company_name").val();

        if(start_time && !end_time)
        {
            alert('请选择结束时间');
            return;
        }
        if(!start_time && end_time)
        {
            alert('请选择开始时间');
            return;
        }
        if(start_time && end_time)
        {
            if(end_time < start_time)
            {
                alert('开始结束时间选择不对');
                return;
            }
        }

        let search_str = '';
        if(start_time && end_time) search_str +='&start_time=' + start_time + '&end_time=' + end_time;
        if(company_name) search_str +='&company_name=' + company_name;

        return search_str;
    }



    $(function () {
        // 搜索
        $("#search").on('click', function () {
            let search_str = get_search();
            if (search_str) {
                window.location.href = '__URL__/index?page=' + 1 + search_str;
            }
        });
    })
</script>

<include file="Public:footer" />

php

<?php

namespace AdminAction;

class RechargeOrderAction extends CommonAction
{
    public function _initialize()
    {
        parent::_initialize();
        $model_name = '企业会员充值订单';
        $this->assign('model_name', $model_name);
    }

    public function index()
    {
        $page = 1;
        if (!empty($_GET['page'])) {
            $page = (int) $_GET['page'];
        }

        $this->assign('page', $page);

        $step = C('PAGE_NORMAL_COUNT');
        $model = D('Page');
        $start = ($page - 1) * $step;

        // search
        $where['status'] = 2; // 正常

        //搜索
        if($_GET['company_name'])
        {
            $company_user = M('company_user');
            $company_uids = $company_user->where(['name'=>['like','%'.$_GET['company_name'].'%']])->getField('id',true);
            $where['company_uid'] = ['in', $company_uids];
            $this->assign('company_name', $_GET['company_name']);
        }
  
        if($_GET['start_time'])
        {
            $this->assign('start_time', $_GET['start_time']);
            $this->assign('end_time', $_GET['end_time']);

            $where['pay_time']  = array(array('gt',strtotime($_GET['start_time'].' 00:00')),array('lt',strtotime($_GET['end_time'].' 23:59')),'and'); 
        }


        $recharge_order = M('recharge_order');
        $result_list = $recharge_order->where($where)->limit($start . ',' . $step)->order('id desc')->select();
        $company_user = M('company_user');
        foreach($result_list as $k => &$v) {
            $v['company_name'] = $company_user->where(['id'=>$v['company_uid']])->getField('name');
        }

        $this->assign('result', $result_list);
        $model_flag = $model->index('recharge_order', $page, $where);
        $this->assign('allPage', $model_flag);
        $this->display();
    }
}

tips:后台的一个重要功能,就是查询.然后是统计.