用TP的同學(xué)一定非常熟悉數(shù)組批量字段查詢埠对，在一些條件較多但并不復(fù)雜的查詢中斩祭，這種方式非潮啵快捷尖啡。但Phalcon沒有自帶，所以我在代碼中對(duì)Model做了一層封裝剩膘，用以處理數(shù)組查詢衅斩。

<?php
namespace app\models;

use Phalcon\Mvc\Model;

class MyBaseModel extends Model
{

    // 關(guān)聯(lián)數(shù)組查詢
    static public function arrFind($arr, $relation='and', $assist=[])
    {
        $parameters = self::dealWithWhereArr($arr, $relation, $assist);
        // 查詢返回
        return self::find($parameters);
    }

    // 關(guān)聯(lián)數(shù)組查詢
    static public function arrFindFirst($arr, $relation='and', $assist=[])
    {
        $parameters = self::dealWithWhereArr($arr, $relation, $assist);
        // 查詢返回
        return self::findFirst($parameters);
    }

    // 分頁查詢
    static public function arrFindPage($pageSize, $pageNum, $arr, $relation='and', $assist=[])
    {
        $count = self::count(self::dealWithWhereArr($arr, $relation, $assist));
        $offset = $pageSize*($pageNum-1);
        $assist['limit'] = [(int)$pageSize, (int)$offset];
        $list = self::arrFind($arr, $relation, $assist)->toArray();
        $meta = [
            'total' => $count,
            'pageNum' => $pageNum,
            'pageSize' => $pageSize
        ];
        self::keyToHump($list);
        return [
            'list' => $list,
            'meta' => $meta
        ];
    }

    /**
     * 組裝關(guān)聯(lián)數(shù)組查詢
     * @param $arr 關(guān)聯(lián)數(shù)組，支持類TP的[k=>['>',6], k=>['not null'], k=>['IN', Arr]]
     * @param string $relation
     * @param array $assist
     * @return array
     */
    static public function dealWithWhereArr($arr, $relation='and', $assist=[])
    {
        if (isset($arr['bind']) && is_array($arr['bind'])){
            return $arr;
        }
        if (is_array($relation)){
            $assist = array_merge($relation, $assist);
            $relation = 'and';
        }
        // 預(yù)處理conditions
        $conditions = [];
        $bind = [];
        foreach ($arr as $k => $v){
            $bindKey = str_replace('.', '__', $k); // SQL綁定參數(shù)變量名中不可有符號(hào).
            if (!is_array($v)){
                $conditions[] = $k.' = :'.$bindKey.':';
                $bind[$bindKey] = $v;
                continue;
            }
            if (isset($v[1]) && is_array($v[1])){
                $conditions[] = "{$k} {$v[0]} ({{$bindKey}:array})";
                $bind[$bindKey] = $v[1];
                continue;
            }
            $conditions[] = $k.' '.implode(' ', $v);
        }
        $conditions = implode(" {$relation} ", $conditions);
        // 查詢返回
        return array_merge([
            'conditions' => $conditions,
            'bind' => $bind,
        ], $assist);
    }

    /**
     * 數(shù)組鍵名下劃線轉(zhuǎn)駝峰
     * @param $list
     * @return array
     */
    static public function keyToHump(&$list){
        if (!is_array($list)){
            return $list;
        }
        $newList = [];
        foreach ($list as $k => $item){
            if (is_numeric($k)){
                $newList[] = self::keyToHump($item);
                continue;
            }
            $humpKey = preg_replace_callback('/([-_]+([a-z]{1}))/i',function($matches){
                return strtoupper($matches[2]);
            },$k);
            $newList[$humpKey] = $item;
        }
        $list = $newList;
        return $newList;
    }

    /*// 捕捉驗(yàn)證器失敗結(jié)果到全局變量
    protected function validate($validator){
        $bol = parent::validate($validator);
        if (!$bol){
            $Messages = $this->getMessages();
            foreach ($Messages as $msg){
                $GLOBALS['ExceptionTipsMsg'][] = $msg->getMessage();
            }
        }
        return $bol;
    }*/
}

表繼承后就可以使用類似下面的查詢方式

// 單表查詢
Drivers::arrFind([
    'id' => ['IN', $driverIdList],
    'age' => ['>', 6],
    'test' => ['not null'],
], 'and', [
    'columns' => 'id, real_name AS realName'
])->toArray();

// 多表?xiàng)l件預(yù)處理
$parameter = [
    'a.age' => ['>', 12],
    'b.status' => ['IN', [2, 3]],
];
$where = MyBaseModel::dealWithWhereArr($parameter);
$model =  $this->modelsManager->createBuilder()
    ->addfrom('app\models\Test\A','a')
    ->join('app\models\Test\B', 'b.a_id = a.id','b')
    ->where($where['conditions'], $where['bind'])
    ->getQuery()
    ->execute()
    ->toArray();