多条件检索

叫老板给我倒杯茶

已于 2022-03-15 20:36:27 修改

阅读量394

点赞数

文章标签：全文检索 php

于 2022-03-15 16:58:26 首次发布

本文链接：https://blog.csdn.net/m0_61928732/article/details/123506762

版权

控制层

public function activityList(Request $request)
{
    // 接收检索条件
    $title = $request->param('title');
    $status = $request->param('status');
    $startTime = $request->param('start_time');
    $endTime = $request->param('end_time', time());
    $where = array();
    if($title)
    {
        $where[] = array('title', 'like', "%$title%");
    }
    if(isset($status))
    {
        $where[] = array('status', '=', $status);
    }
    if($startTime)
    {
        $where[] = array('create_time', '>=', $startTime);
    }
    if($endTime)
    {
        $where[] = array('create_time', '<=', $endTime);
    }
    $stdData = array();
    $activity = new Activity();

    $list = $activity->getList($where);
    $stdData = $list;
    return success('200', 'success', $stdData);
}

模型层

public function getList($where)
{
    if($where)
    {
        return self::where($where)->order('sort', 'desc')->select()->toArray();
    }
    return self::order('sort', 'desc')->select()->toArray();
}

或者调用模型也可以

控制器层