// +---------------------------------------------------------------------- namespace think\model\relation; 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) { // 执行闭包查询 $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 $model 关联模型对象 * @param Model $result 父模型对象 * @return void * @throws Exception */ protected function bindAttr($model, &$result) { foreach ($this->bindAttr as $key => $attr) { $key = is_numeric($key) ? $attr : $key; if (isset($result->$key)) { throw new Exception('bind attr has exists:' . $key); } else { $result->setAttr($key, $model ? $model->$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) { $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; } }