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;
- }
- }
- }
|