123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337 |
- <?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 OneToOne
- * @package think\model\relation
- *
- */
- abstract class OneToOne extends Relation
- {
- // 预载入方式 0 -JOIN 1 -IN
- protected $eagerlyType = 1;
- // 当前关联的JOIN类型
- protected $joinType;
- // 要绑定的属性
- protected $bindAttr = [];
- // 关联名
- protected $relation;
- /**
- * 设置join类型
- * @access public
- * @param string $type JOIN类型
- * @return $this
- */
- public function joinType($type)
- {
- $this->joinType = $type;
- return $this;
- }
- /**
- * 预载入关联查询(JOIN方式)
- * @access public
- * @param Query $query 查询对象
- * @param string $relation 关联名
- * @param mixed $field 关联字段
- * @param string $joinType JOIN方式
- * @param \Closure $closure 闭包条件
- * @param bool $first
- * @return void
- */
- public function eagerly(Query $query, $relation, $field, $joinType, $closure, $first)
- {
- $name = Loader::parseName(basename(str_replace('\\', '/', get_class($this->parent))));
- if ($first) {
- $table = $query->getTable();
- $query->table([$table => $name]);
- if ($query->getOptions('field')) {
- $masterField = $query->getOptions('field');
- $query->removeOption('field');
- } else {
- $masterField = true;
- }
- $query->field($masterField, false, $table, $name);
- }
- // 预载入封装
- $joinTable = $this->query->getTable();
- $joinAlias = $relation;
- $joinType = $joinType ?: $this->joinType;
- $query->via($joinAlias);
- if ($this instanceof BelongsTo) {
- $joinOn = $name . '.' . $this->foreignKey . '=' . $joinAlias . '.' . $this->localKey;
- } else {
- $joinOn = $name . '.' . $this->localKey . '=' . $joinAlias . '.' . $this->foreignKey;
- }
- if ($closure instanceof Closure) {
- // 执行闭包查询
- $closure($query);
- // 使用withField指定获取关联的字段,如
- // $query->where(['id'=>1])->withField('id,name');
- if ($query->getOptions('with_field')) {
- $field = $query->getOptions('with_field');
- $query->removeOption('with_field');
- }
- }
- $query->join([$joinTable => $joinAlias], $joinOn, $joinType)
- ->field($field, false, $joinTable, $joinAlias, $relation . '__');
- }
- /**
- * 预载入关联查询(数据集)
- * @access protected
- * @param array $resultSet
- * @param string $relation
- * @param string $subRelation
- * @param \Closure $closure
- * @return mixed
- */
- abstract protected function eagerlySet(&$resultSet, $relation, $subRelation, $closure);
- /**
- * 预载入关联查询(数据)
- * @access protected
- * @param Model $result
- * @param string $relation
- * @param string $subRelation
- * @param \Closure $closure
- * @return mixed
- */
- abstract protected function eagerlyOne(&$result, $relation, $subRelation, $closure);
- /**
- * 预载入关联查询(数据集)
- * @access public
- * @param array $resultSet 数据集
- * @param string $relation 当前关联名
- * @param string $subRelation 子关联名
- * @param \Closure $closure 闭包
- * @param bool $join 是否为JOIN方式
- * @return void
- */
- public function eagerlyResultSet(&$resultSet, $relation, $subRelation, $closure, $join = false)
- {
- if ($join || 0 == $this->eagerlyType) {
- // 模型JOIN关联组装
- foreach ($resultSet as $result) {
- $this->match($this->model, $relation, $result);
- }
- } else {
- // IN查询
- $this->eagerlySet($resultSet, $relation, $subRelation, $closure);
- }
- }
- /**
- * 预载入关联查询(数据)
- * @access public
- * @param Model $result 数据对象
- * @param string $relation 当前关联名
- * @param string $subRelation 子关联名
- * @param \Closure $closure 闭包
- * @param bool $join 是否为JOIN方式
- * @return void
- */
- public function eagerlyResult(&$result, $relation, $subRelation, $closure, $join = false)
- {
- if (0 == $this->eagerlyType || $join) {
- // 模型JOIN关联组装
- $this->match($this->model, $relation, $result);
- } else {
- // IN查询
- $this->eagerlyOne($result, $relation, $subRelation, $closure);
- }
- }
- /**
- * 保存(新增)当前关联数据对象
- * @access public
- * @param mixed $data 数据 可以使用数组 关联模型对象 和 关联对象的主键
- * @return Model|false
- */
- public function save($data)
- {
- if ($data instanceof Model) {
- $data = $data->getData();
- }
- $model = new $this->model;
- // 保存关联表数据
- $data[$this->foreignKey] = $this->parent->{$this->localKey};
- return $model->save($data) ? $model : false;
- }
- /**
- * 设置预载入方式
- * @access public
- * @param integer $type 预载入方式 0 JOIN查询 1 IN查询
- * @return $this
- */
- public function setEagerlyType($type)
- {
- $this->eagerlyType = $type;
- return $this;
- }
- /**
- * 获取预载入方式
- * @access public
- * @return integer
- */
- public function getEagerlyType()
- {
- return $this->eagerlyType;
- }
- /**
- * 绑定关联表的属性到父模型属性
- * @access public
- * @param mixed $attr 要绑定的属性列表
- * @return $this
- */
- public function bind($attr)
- {
- if (is_string($attr)) {
- $attr = explode(',', $attr);
- }
- $this->bindAttr = $attr;
- return $this;
- }
- /**
- * 获取绑定属性
- * @access public
- * @return array
- */
- public function getBindAttr()
- {
- return $this->bindAttr;
- }
- /**
- * 一对一 关联模型预查询拼装
- * @access public
- * @param string $model 模型名称
- * @param string $relation 关联名
- * @param Model $result 模型对象实例
- * @return void
- */
- protected function match($model, $relation, &$result)
- {
- // 重新组装模型数据
- foreach ($result->getData() as $key => $val) {
- if (strpos($key, '__')) {
- list($name, $attr) = explode('__', $key, 2);
- if ($name == $relation) {
- $list[$name][$attr] = $val;
- unset($result->$key);
- }
- }
- }
- if (isset($list[$relation])) {
- $array = array_unique($list[$relation]);
- if (count($array) == 1 && null === current($array)) {
- $relationModel = null;
- } else {
- $relationModel = new $model($list[$relation]);
- $relationModel->setParent(clone $result);
- $relationModel->isUpdate(true);
- }
- if (!empty($this->bindAttr)) {
- $this->bindAttr($relationModel, $result, $this->bindAttr);
- }
- } else {
- $relationModel = null;
- }
- $result->setRelation(Loader::parseName($relation), $relationModel);
- }
- /**
- * 绑定关联属性到父模型
- * @access protected
- * @param Model $result 关联模型对象
- * @param Model $model 父模型对象
- * @return void
- * @throws Exception
- */
- protected function bindAttr($model, &$result)
- {
- foreach ($this->bindAttr as $key => $attr) {
- $key = is_numeric($key) ? $attr : $key;
- $value = $result->getOrigin($key);
- if (!is_null($value)) {
- throw new Exception('bind attr has exists:' . $key);
- }
- $result->setAttr($key, $model ? $model->getAttr($attr) : null);
- }
- }
- /**
- * 一对一 关联模型预查询(IN方式)
- * @access public
- * @param array $where 关联预查询条件
- * @param string $key 关联键名
- * @param string $relation 关联名
- * @param string $subRelation 子关联
- * @param \Closure $closure
- * @return array
- */
- protected function eagerlyWhere($where, $key, $relation, $subRelation = '', $closure = null)
- {
- // 预载入关联查询 支持嵌套预载入
- if ($closure instanceof Closure) {
- $closure($this->query);
- if ($field = $this->query->getOptions('with_field')) {
- $this->query->field($field)->removeOption('with_field');
- }
- }
- $list = $this->query->where($where)->with($subRelation)->select();
- // 组装模型数据
- $data = [];
- foreach ($list as $set) {
- $data[$set->$key] = $set;
- }
- return $data;
- }
- }
|