| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342 | <?php// +----------------------------------------------------------------------// | ThinkPHP [ WE CAN DO IT JUST THINK ]// +----------------------------------------------------------------------// | Copyright (c) 2006~2018 http://thinkphp.cn All rights reserved.// +----------------------------------------------------------------------// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )// +----------------------------------------------------------------------// | Author: liu21st <liu21st@gmail.com>// +----------------------------------------------------------------------namespace think\model\relation;use Closure;use think\db\Query;use think\Exception;use think\Loader;use think\Model;use think\model\Relation;class MorphMany extends Relation{    // 多态字段    protected $morphKey;    protected $morphType;    // 多态类型    protected $type;    /**     * 架构函数     * @access public     * @param  Model  $parent    上级模型对象     * @param  string $model     模型名     * @param  string $morphKey  关联外键     * @param  string $morphType 多态字段名     * @param  string $type      多态类型     */    public function __construct(Model $parent, $model, $morphKey, $morphType, $type)    {        $this->parent    = $parent;        $this->model     = $model;        $this->type      = $type;        $this->morphKey  = $morphKey;        $this->morphType = $morphType;        $this->query     = (new $model)->db();    }    /**     * 延迟获取关联数据     * @access public     * @param  string   $subRelation 子关联名     * @param  \Closure $closure     闭包查询条件     * @return \think\Collection     */    public function getRelation($subRelation = '', $closure = null)    {        if ($closure instanceof Closure) {            $closure($this->query);        }        $this->baseQuery();        $list   = $this->query->relation($subRelation)->select();        $parent = clone $this->parent;        foreach ($list as &$model) {            $model->setParent($parent);        }        return $list;    }    /**     * 根据关联条件查询当前模型     * @access public     * @param  string  $operator 比较操作符     * @param  integer $count    个数     * @param  string  $id       关联表的统计字段     * @param  string  $joinType JOIN类型     * @return Query     */    public function has($operator = '>=', $count = 1, $id = '*', $joinType = 'INNER')    {        throw new Exception('relation not support: has');    }    /**     * 根据关联条件查询当前模型     * @access public     * @param  mixed     $where 查询条件(数组或者闭包)     * @param  mixed     $fields 字段     * @return Query     */    public function hasWhere($where = [], $fields = null)    {        throw new Exception('relation not support: hasWhere');    }    /**     * 预载入关联查询     * @access public     * @param  array    $resultSet   数据集     * @param  string   $relation    当前关联名     * @param  string   $subRelation 子关联名     * @param  \Closure $closure     闭包     * @return void     */    public function eagerlyResultSet(&$resultSet, $relation, $subRelation, $closure)    {        $morphType = $this->morphType;        $morphKey  = $this->morphKey;        $type      = $this->type;        $range     = [];        foreach ($resultSet as $result) {            $pk = $result->getPk();            // 获取关联外键列表            if (isset($result->$pk)) {                $range[] = $result->$pk;            }        }        if (!empty($range)) {            $where = [                [$morphKey, 'in', $range],                [$morphType, '=', $type],            ];            $data = $this->eagerlyMorphToMany($where, $relation, $subRelation, $closure);            // 关联属性名            $attr = Loader::parseName($relation);            // 关联数据封装            foreach ($resultSet as $result) {                if (!isset($data[$result->$pk])) {                    $data[$result->$pk] = [];                }                foreach ($data[$result->$pk] as &$relationModel) {                    $relationModel->setParent(clone $result);                    $relationModel->isUpdate(true);                }                $result->setRelation($attr, $this->resultSetBuild($data[$result->$pk]));            }        }    }    /**     * 预载入关联查询     * @access public     * @param  Model    $result      数据对象     * @param  string   $relation    当前关联名     * @param  string   $subRelation 子关联名     * @param  \Closure $closure     闭包     * @return void     */    public function eagerlyResult(&$result, $relation, $subRelation, $closure)    {        $pk = $result->getPk();        if (isset($result->$pk)) {            $key   = $result->$pk;            $where = [                [$this->morphKey, '=', $key],                [$this->morphType, '=', $this->type],            ];            $data = $this->eagerlyMorphToMany($where, $relation, $subRelation, $closure);            if (!isset($data[$key])) {                $data[$key] = [];            }            foreach ($data[$key] as &$relationModel) {                $relationModel->setParent(clone $result);                $relationModel->isUpdate(true);            }            $result->setRelation(Loader::parseName($relation), $this->resultSetBuild($data[$key]));        }    }    /**     * 关联统计     * @access public     * @param  Model    $result  数据对象     * @param  \Closure $closure 闭包     * @param  string   $aggregate 聚合查询方法     * @param  string   $field 字段     * @param  string   $name 统计字段别名     * @return integer     */    public function relationCount($result, $closure, $aggregate = 'count', $field = '*', &$name = '')    {        $pk = $result->getPk();        if (!isset($result->$pk)) {            return 0;        }        if ($closure instanceof Closure) {            $return = $closure($this->query);            if ($return && is_string($return)) {                $name = $return;            }        }        return $this->query            ->where([                [$this->morphKey, '=', $result->$pk],                [$this->morphType, '=', $this->type],            ])            ->$aggregate($field);    }    /**     * 获取关联统计子查询     * @access public     * @param  \Closure $closure 闭包     * @param  string   $aggregate 聚合查询方法     * @param  string   $field 字段     * @param  string   $aggregateAlias 聚合字段别名     * @return string     */    public function getRelationCountQuery($closure, $aggregate = 'count', $field = '*', &$aggregateAlias = '')    {        if ($closure instanceof Closure) {            $return = $closure($this->query);            if ($return && is_string($return)) {                $aggregateAlias = $return;            }        }        return $this->query            ->whereExp($this->morphKey, '=' . $this->parent->getTable() . '.' . $this->parent->getPk())            ->where($this->morphType, '=', $this->type)            ->fetchSql()            ->$aggregate($field);    }    /**     * 多态一对多 关联模型预查询     * @access protected     * @param  array         $where       关联预查询条件     * @param  string        $relation    关联名     * @param  string        $subRelation 子关联     * @param  \Closure      $closure     闭包     * @return array     */    protected function eagerlyMorphToMany($where, $relation, $subRelation = '', $closure = null)    {        // 预载入关联查询 支持嵌套预载入        $this->query->removeOption('where');        if ($closure instanceof Closure) {            $closure($this->query);        }        $list     = $this->query->where($where)->with($subRelation)->select();        $morphKey = $this->morphKey;        // 组装模型数据        $data = [];        foreach ($list as $set) {            $data[$set->$morphKey][] = $set;        }        return $data;    }    /**     * 保存(新增)当前关联数据对象     * @access public     * @param  mixed $data 数据     * @return Model|false     */    public function save($data)    {        $model = $this->make();        return $model->save($data) ? $model : false;    }    /**     * 创建关联对象实例     * @param array $data     * @return Model     */    public function make($data = [])    {        if ($data instanceof Model) {            $data = $data->getData();        }        // 保存关联表数据        $pk = $this->parent->getPk();        $data[$this->morphKey]  = $this->parent->$pk;        $data[$this->morphType] = $this->type;        return new $this->model($data);    }    /**     * 批量保存当前关联数据对象     * @access public     * @param  array $dataSet 数据集     * @return array|false     */    public function saveAll(array $dataSet)    {        $result = [];        foreach ($dataSet as $key => $data) {            $result[] = $this->save($data);        }        return empty($result) ? false : $result;    }    /**     * 执行基础查询(仅执行一次)     * @access protected     * @return void     */    protected function baseQuery()    {        if (empty($this->baseQuery) && $this->parent->getData()) {            $pk = $this->parent->getPk();            $this->query->where([                [$this->morphKey, '=', $this->parent->$pk],                [$this->morphType, '=', $this->type],            ]);            $this->baseQuery = true;        }    }}
 |