/** * 获取返回数据的关联记录 * @access protected * @param mixed $result 返回数据 * @param string|array $name 关联名称 * @param boolean $return 是否返回关联数据本身 * @return array */ protected function getRelation(&$result, $name = '', $return = false) { if (!empty($this->_link)) { foreach ($this->_link as $key => $val) { $mappingName = !empty($val['mapping_name']) ? $val['mapping_name'] : $key; // 映射名称 if (empty($name) || true === $name || $mappingName == $name || is_array($name) && in_array($mappingName, $name)) { $mappingType = !empty($val['mapping_type']) ? $val['mapping_type'] : $val; // 关联类型 $mappingClass = !empty($val['class_name']) ? $val['class_name'] : $key; // 关联类名 $mappingFields = !empty($val['mapping_fields']) ? $val['mapping_fields'] : '*'; // 映射字段 $mappingCondition = !empty($val['condition']) ? $val['condition'] : '1=1'; // 关联条件 $mappingKey = !empty($val['mapping_key']) ? $val['mapping_key'] : $this->getPk(); // 关联键名 if (strtoupper($mappingClass) == strtoupper($this->name)) { // 自引用关联 获取父键名 $mappingFk = !empty($val['parent_key']) ? $val['parent_key'] : 'parent_id'; } else { $mappingFk = !empty($val['foreign_key']) ? $val['foreign_key'] : strtolower($this->name) . '_id'; // 关联外键 } // 获取关联模型对象 $model = D($mappingClass); switch ($mappingType) { case self::HAS_ONE: $pk = $result[$mappingKey]; $mappingCondition .= " AND {$mappingFk}='{$pk}'"; $relationData = $model->cache(true, 2)->where($mappingCondition)->field($mappingFields)->find(); if (!empty($val['relation_deep'])) { $model->getRelation($relationData, $val['relation_deep']); } break; case self::BELONGS_TO: if (strtoupper($mappingClass) == strtoupper($this->name)) { // 自引用关联 获取父键名 $mappingFk = !empty($val['parent_key']) ? $val['parent_key'] : 'parent_id'; } else { $mappingFk = !empty($val['foreign_key']) ? $val['foreign_key'] : strtolower($model->getModelName()) . '_id'; // 关联外键 } //TODO Patch for thinkphp3.2 by GREENCMS $mapping_foreign_key = !empty($val['mapping_foreign_key']) ? $val['mapping_foreign_key'] : $model->getPk(); $fk = $result[$mappingFk]; $mappingCondition .= " AND {$mapping_foreign_key}='{$fk}'"; $relationData = $model->cache(true, 2)->where($mappingCondition)->field($mappingFields)->find(); if (!empty($val['relation_deep'])) { $model->getRelation($relationData, $val['relation_deep']); } break; case self::HAS_MANY: $pk = $result[$mappingKey]; $mappingCondition .= " AND {$mappingFk}='{$pk}'"; $mappingOrder = !empty($val['mapping_order']) ? $val['mapping_order'] : ''; $mappingLimit = !empty($val['mapping_limit']) ? $val['mapping_limit'] : ''; // 延时获取关联记录 $relationData = $model->cache(true, 2)->where($mappingCondition)->field($mappingFields)->order($mappingOrder)->limit($mappingLimit)->select(); if (!empty($val['relation_deep'])) { foreach ($relationData as $key => $data) { $model->getRelation($data, $val['relation_deep']); $relationData[$key] = $data; } } break; case self::MANY_TO_MANY: $pk = $result[$mappingKey]; $prefix = $this->tablePrefix; $mappingCondition = " {$mappingFk}='{$pk}'"; $mappingOrder = $val['mapping_order']; $mappingLimit = $val['mapping_limit']; $mappingRelationFk = $val['relation_foreign_key'] ? $val['relation_foreign_key'] : $model->getModelName() . '_id'; if (isset($val['relation_table'])) { $mappingRelationTable = preg_replace_callback("/__([A-Z_-]+)__/sU", function ($match) use($prefix) { return $prefix . strtolower($match[1]); }, $val['relation_table']); } else { $mappingRelationTable = $this->getRelationTableName($model); } $mappingRelationTable = $prefix . $mappingRelationTable; $sql = "SELECT b.{$mappingFields} FROM {$mappingRelationTable} AS a, " . $model->getTableName() . " AS b WHERE a.{$mappingRelationFk} = b.{$model->getPk()} AND a.{$mappingCondition}"; if (!empty($val['condition'])) { $sql .= ' AND ' . $val['condition']; } if (!empty($mappingOrder)) { $sql .= ' ORDER BY ' . $mappingOrder; } if (!empty($mappingLimit)) { $sql .= ' LIMIT ' . $mappingLimit; } //缓存key // $cache_key=md5($sql); // // if (S($cache_key)) { // // echo "cache hit $cache_key : $sql <br />"; // $relationData = S($sql); // if($relationData=="none"){ // $relationData=array(); // }else{ // $relationData= S($cache_key); // } // // } else { // // echo "cache miss $cache_key : $sql <br />"; // // $relationData = $this->query($sql); // // if(empty($relationData)){ // S($cache_key, "none", array('expire'=>get_opinion("DATA_CACHE_TIME"))); // }else{ // S($cache_key, $relationData, array('expire'=>get_opinion("DATA_CACHE_TIME"))); // } // } if ($key == 'Cat') { //key: relation_post_cat_$post_id // dump($mappingFk); // dump($pk); $relationData = CacheManager::getPostCatRelation($pk); if ($relationData == 'none') { // echo "Cat cache none {$pk} <br />"; $relationData = array(); } else { if ($relationData) { // echo "Cat cache hit {$pk}<br />"; } else { $relationData = $this->query($sql); if (empty($relationData)) { // echo "Cat is empty {$pk} <br />"; CacheManager::setPostCatRelation($pk, 'none'); } else { // echo "Cat cache missed {$pk} <br />"; CacheManager::setPostCatRelation($pk, $relationData); } } } } else { if ($key == 'Tag') { //key: relation_post_tag_$post_id $relationData = CacheManager::getPostTagRelation($pk); if ($relationData == 'none') { // echo "Tag cache none {$pk} <br />"; $relationData = array(); } else { if ($relationData) { // echo "Tag cache hit {$pk}<br />"; } else { $relationData = $this->query($sql); if (empty($relationData)) { // echo "Tag is empty {$pk} <br />"; CacheManager::setPostTagRelation($pk, 'none'); } else { // echo "Tag cache missed {$pk} <br />"; CacheManager::setPostTagRelation($pk, $relationData); } } } } else { // echo "no cache cover"; //todo improve performance $relationData = $this->query($sql); } } if (!empty($val['relation_deep'])) { foreach ($relationData as $key => $data) { $model->getRelation($data, $val['relation_deep']); $relationData[$key] = $data; } } break; } if (!$return) { if (isset($val['as_fields']) && in_array($mappingType, array(self::HAS_ONE, self::BELONGS_TO))) { // 支持直接把关联的字段值映射成数据对象中的某个字段 // 仅仅支持HAS_ONE BELONGS_TO $fields = explode(',', $val['as_fields']); foreach ($fields as $field) { if (strpos($field, ':')) { list($relationName, $nick) = explode(':', $field); $result[$nick] = $relationData[$relationName]; } else { $result[$field] = $relationData[$field]; } } } else { $result[$mappingName] = $relationData; } unset($relationData); } else { return $relationData; } } } } return $result; }