tp5获取查询条件

<?php
 
class Base extends Controller
{
 

    /*自动加载显示页面的表格*/
    $show_field=[
        "字段名"=>"字段标题"
    ];
    
 
    public function where(sym)
    {
        switch ($sym) {
                case '=':
                case '<>':
                    $where[] = [$k, $sym, (string)$v];
                    break;
                case 'LIKE':
                case 'NOT LIKE':
                case 'LIKE %...%':
                case 'NOT LIKE %...%':
                    $where[] = [$k, trim(str_replace('%...%', '', $sym)), "%{$v}%"];
                    break;
                case '>':
                case '>=':
                case '<':
                case '<=':
                    $where[] = [$k, $sym, intval($v)];
                    break;
                case 'FINDIN':
                case 'FINDINSET':
                case 'FIND_IN_SET':
                    $where[] = "FIND_IN_SET('{$v}', " . ($relationSearch ? $k : '`' . str_replace('.', '`.`', $k) . '`') . ")";
                    break;
                case 'IN':
                case 'IN(...)':
                case 'NOT IN':
                case 'NOT IN(...)':
                    $where[] = [$k, str_replace('(...)', '', $sym), is_array($v) ? $v : explode(',', $v)];
                    break;
                case 'BETWEEN':
                case 'NOT BETWEEN':
                    $arr = array_slice(explode(',', $v), 0, 2);
                    if (stripos($v, ',') === false || !array_filter($arr)) {
                        continue 2;
                    }
                    //当出现一边为空时改变操作符
                    if ($arr[0] === '') {
                        $sym = $sym == 'BETWEEN' ? '<=' : '>';
                        $arr = $arr[1];
                    } elseif ($arr[1] === '') {
                        $sym = $sym == 'BETWEEN' ? '>=' : '<';
                        $arr = $arr[0];
                    }
                    $where[] = [$k, $sym, $arr];
                    break;
                case 'RANGE':
                case 'NOT RANGE':
                    $v = str_replace(' - ', ',', $v);
                    $arr = array_slice(explode(',', $v), 0, 2);
                    if (stripos($v, ',') === false || !array_filter($arr)) {
                        continue 2;
                    }
                    //当出现一边为空时改变操作符
                    if ($arr[0] === '') {
                        $sym = $sym == 'RANGE' ? '<=' : '>';
                        $arr = $arr[1];
                    } elseif ($arr[1] === '') {
                        $sym = $sym == 'RANGE' ? '>=' : '<';
                        $arr = $arr[0];
                    }
                    $where[] = [$k, str_replace('RANGE', 'BETWEEN', $sym) . ' time', $arr];
                    break;
                case 'LIKE':
                case 'LIKE %...%':
                    $where[] = [$k, 'LIKE', "%{$v}%"];
                    break;
                case 'NULL':
                case 'IS NULL':
                case 'NOT NULL':
                case 'IS NOT NULL':
                    $where[] = [$k, strtolower(str_replace('IS ', '', $sym))];
                    break;
                default:
                    break;
            }
        }
        $this->where(); 
    }
    public function Validate()
    {
            /*获取数据并排序*/
        $data = input("post.");
        $datt = ['father_id', 'name', 'type', 'oneself', 'principal', 'mobile', 'site', 'postal_code', 'fax', 'email', 'remark', 'department_id'];
        $datas = SortAnArray($data, $datt);
         /*定义规则*/
        $rule = [
          'father_id' => 'require',
          'name' => 'require' 
        ];
         /*定义提醒*/
        $msg = [
          'father_id.require' => '上级组织不能为空',
          'name.require' => '调解组织名称不能为空' 
        ];
        /*定义数据*/
        $da = [
          'father_id' => $datas['father_id'],
          'name' => $datas['name'] 
        ];
        /*逻辑判断*/
            /*定义验证器*/
        $validate = new Validate($rule, $msg);
        /*验证数据*/
        $result = $validate->check($da);
        /*返回验证结果*/
        if (!$result) {
          return ['10003', __($validate->getError()];
        }else{
            return  [1];
        }
            
    }
     
    
}