TP5学习笔记八 模型（Model）

表前缀不同

别名法

$data_list = self::view(['oxygen_withdraw_change'=>'withdraw_change'])
            ->view('admin_user', 'username', 'admin_user.id=oxygen_withdraw_change.uid', 'left')
            ->select();

table指定法，table前的view里一定要传同样表名

$data_list = self::view('oxygen_withdraw_change')
            ->table('oxygen_withdraw_change')
            ->view('admin_user', 'username', 'admin_user.id=oxygen_withdraw_change.uid', 'left')
            ->select();

复杂查询举例

$post = [
            'client_id'   => $client_id,
            'tab'         => $tab,
            'name'        => $name,
            'create_time' => $create_time,
            'stage'       => $stage,
            'status'      => $status,
            'type'        => $type
        ];
        $client_index_status = Cases::$client_index_status;
        $client_status       = Cases::$client_status + Cases::$status;
        $row_list            = Cases::where(function($query) use($post, $client_index_status, $client_status){
            $query->where('client_id', $post['client_id']);
            if($post['tab'] == '待处理'){
                $query->where('status', 'in', array_keys($client_index_status));
            }
            if($post['name']){
                $name = $post['name'];
                $query->where("(name like '%{$name}%' OR apply_no like '%{$name}%' OR applicant like '%{$name}%')");
            }
            if ($post['create_time']) {
                $query->where('create_time', 'between time', explode(',', $post['create_time']));
            }
            if($post['stage'] && $post['status']){
                $query->where('stage', $post['stage']);
                switch ($post['stage']) {
                    case 0:
                        $status = array_keys([
                            "0001"=>"已撤回",
                            "0002"=>"稿件已确认",
                            "0003"=>"驳回放弃",
                            "0004"=>"结束已失效",
                            "0005"=>"驳回再申请",
                            "0006"=>"已失效"
                        ], $post['status']);
                        break;
                    case 1:
                        $status = array_keys([
                            "1001"=>"待支付",
                            "1002"=>"待审核",
                            "1003"=>"待修改",
                            "1004"=>"分配中",
                        ], $post['status']);
                        break;
                    case 2:
                        $status = array_keys([
                            "2001"=>"起名中",
                            "2002"=>"起名待确认",
                            "2003"=>"起名中",
                            "2004"=>"撰写中",
                            "2005"=>"撰写中",
                            "2006"=>"待确认",
                            "2007"=>"撰写中",
                        ], $post['status']);
                        break;
                    case 3:
                        $status = array_keys([
                            "3003"=>"已受理",
                            "3004"=>"补正中",
                            "3005"=>"补正中",
                            "3006"=>"补正待确认",
                            "3007"=>"补正中",
                            "3008"=>"递交中",
                            "3009"=>"递交中",
                        ]
                        , $post['status']);
                        break;
                    case 4:
                        $status = ['4001'];
                        break;
                    case 5:
                        $status = array_keys([
                            "5001"=>"实审中",
                            "5002"=>"答复中",
                            "5003"=>"答复中",
                            "5004"=>"答复中",
                            "5005"=>"答复待确认",
                            "5006"=>"答复待递交",
                            "5007"=>"答复中",
                            "5008"=>"驳回待确认",
                            "5009"=>"待授权"
                        ]
                        , $post['status']);
                        break;
                    case 6:
                        $status = array_keys([
                            "6001"=>"生效中",
                            "6002"=>"待缴纳年费",
                        ], $post['status']);
                        break;
                    default:
                        break;
                }
                $query->where('status', 'in', $status);
            }
            if($post['type']){
                $query->where('type', $post['type']);
            }
        })
        ->order('id DESC')
        ->paginate($list_rows)
        ->each(function ($item, $key) {
            $item['stage_text']         = $item['stage_text'];
            $item['client_status_text'] = $item['client_status_text'];
            $item['left_days']          = $item['left_days'];
            $item['applicant_text']     = $item['applicant_text'];
            return $item;
        });