作者：广佛笑嘻嘻_229 | 来源：互联网 | 2023-08-24 13:51
php教程|php手册thinkphp代码，代码示例，代码参考，php短信，数据库备份代码，令牌验证，去除代码中的空白和注释多层关联php教程-php手册重载或重写getRelat
php教程|php手册
thinkphp代码，代码示例，代码参考，php短信，数据库备份代码，令牌验证，去除代码中的空白和注释多层关联
php教程-php手册
重载或重写 getRelation函数，以获得多层关联，关联参数：array(&＃039;mapping_name&＃039;=>&＃039;next_mappingname_or_array&＃039;, &＃039;normal_mapping_name&＃039;)
/**
* 获取返回数据的关联记录
* @access protected
* @param mixed $result 返回数据
* @param string|array $name 关联名称
* @param boolean $return 是否返回关联数据本身
* @return array
*/
protected function getRelation(&$result,$name=&＃039;&＃039;,$return=false) {
if(!empty($this->_link)) {
foreach($this->_link as $key=>$val) {
$mappingName = !empty($val[&＃039;mapping_name&＃039;])?$val[&＃039;mapping_name&＃039;]:$key; // 映射名称
if(empty($name) || true === $name || $mappingName == $name || (is_array($name) && (in_array($mappingName,$name) || array_key_exists($mappingName,$name) ))) {
$mappingType = !empty($val[&＃039;mapping_type&＃039;])?$val[&＃039;mapping_type&＃039;]:$val; // 关联类型
$mappingClass = !empty($val[&＃039;class_name&＃039;])?$val[&＃039;class_name&＃039;]:$key; // 关联类名
$mappingFields = !empty($val[&＃039;mapping_fields&＃039;])?$val[&＃039;mapping_fields&＃039;]:&＃039;*&＃039;; // 映射字段
$mappingCOndition= !empty($val[&＃039;condition&＃039;])?$val[&＃039;condition&＃039;]:&＃039;1=1&＃039;; // 关联条件
$mappingKey =!empty($val[&＃039;mapping_key&＃039;])? $val[&＃039;mapping_key&＃039;] : $this->getPk(); // 关联键名
if(strtoupper($mappingClass)==strtoupper($this->name)) {
// 自引用关联 获取父键名
$mappingFk = !empty($val[&＃039;parent_key&＃039;])? $val[&＃039;parent_key&＃039;] : &＃039;parent_id&＃039;;
}else{
$mappingFk = !empty($val[&＃039;foreign_key&＃039;])?$val[&＃039;foreign_key&＃039;]:strtolower($this->name).&＃039;_id&＃039;; // 关联外键
}
// 获取关联模型对象
$model = D($mappingClass);
switch($mappingType) {
case HAS_ONE:
$pk = $result[$mappingKey];
$mappingCondition .= " AND {$mappingFk}=&＃039;{$pk}&＃039;";
if (is_array($name) && array_key_exists($mappingName,$name)){
$relatiOnData= $model->relation($name[$mappingName])->where($mappingCondition)->field($mappingFields)->find();
}else{
$relatiOnData= $model->where($mappingCondition)->field($mappingFields)->find();
}
break;
case BELONGS_TO:
if(strtoupper($mappingClass)==strtoupper($this->name)) {
// 自引用关联 获取父键名
$mappingFk = !empty($val[&＃039;parent_key&＃039;])? $val[&＃039;parent_key&＃039;] : &＃039;parent_id&＃039;;
}else{
$mappingFk = !empty($val[&＃039;foreign_key&＃039;])?$val[&＃039;foreign_key&＃039;]:strtolower($model->getModelName()).&＃039;_id&＃039;; // 关联外键
}
$fk = $result[$mappingFk];
$mappingCondition .= " AND {$model->getPk()}=&＃039;{$fk}&＃039;";
if (is_array($name) && array_key_exists($mappingName,$name)){
$relatiOnData= $model->relation($name[$mappingName])->where($mappingCondition)->field($mappingFields)->find();
}else
$relatiOnData= $model->where($mappingCondition)->field($mappingFields)->find();
break;
case HAS_MANY:
$pk = $result[$mappingKey];
$mappingCondition .= " AND {$mappingFk}=&＃039;{$pk}&＃039;";
$mappingOrder = !empty($val[&＃039;mapping_order&＃039;])?$val[&＃039;mapping_order&＃039;]:&＃039;&＃039;;
$mappingLimit = !empty($val[&＃039;mapping_limit&＃039;])?$val[&＃039;mapping_limit&＃039;]:&＃039;&＃039;;
// 延时获取关联记录
if (is_array($name) && array_key_exists($mappingName,$name)){
$relatiOnData= $model->relation($name[$mappingName])->where($mappingCondition)->field($mappingFields)->order($mappingOrder)->limit($mappingLimit)->select();
}else
$relatiOnData= $model->where($mappingCondition)->field($mappingFields)->order($mappingOrder)->limit($mappingLimit)->select();
break;
case MANY_TO_MANY:
$pk = $result[$mappingKey];
$mappingCOndition= " {$mappingFk}=&＃039;{$pk}&＃039;";
$mappingOrder = $val[&＃039;mapping_order&＃039;];
$mappingLimit = $val[&＃039;mapping_limit&＃039;];
$mappingRelatiOnFk= $val[&＃039;relation_foreign_key&＃039;]?$val[&＃039;relation_foreign_key&＃039;]:$model->getModelName().&＃039;_id&＃039;;
$mappingRelatiOnTable= $val[&＃039;relation_table&＃039;]?$val[&＃039;relation_table&＃039;]:$this->getRelationTableName($model);
$sql = "SELECT b.{$mappingFields} FROM {$mappingRelationTable} AS a, ".$model->getTableName()." AS b WHERE a.{$mappingRelationFk} = b.{$model->getPk()} AND a.{$mappingCondition}";
if(!empty($val[&＃039;condition&＃039;])) {
$sql .= &＃039; AND &＃039;.$val[&＃039;condition&＃039;];
}
if(!empty($mappingOrder)) {
$sql .= &＃039; ORDER BY &＃039;.$mappingOrder;
}
if(!empty($mappingLimit)) {
$sql .= &＃039; LIMIT &＃039;.$mappingLimit;
}
if (is_array($name) && array_key_exists($mappingName,$name)){php源码记账,vscode锁定只读文件,ubuntu系统压缩,tomcat加ssl证书,sqlite数据库和c,爬虫的相关法律风险有哪些,php 联动下拉列表,辽宁seo排名优化,网站源代码文件,html动态模板下载地址lzw
$mappingOrder = !empty($val[&＃039;mapping_order&＃039;])?$val[&＃039;mapping_order&＃039;]:&＃039;&＃039;;
$mappingLimit = !empty($val[&＃039;mapping_limit&＃039;])?$val[&＃039;mapping_limit&＃039;]:&＃039;&＃039;;
$relatiOnData= $model->relation($name[$mappingName])
->field($model->getTableName().&＃039;.&＃039;.$mappingFields)
->join($mappingRelationTable." on $mappingRelationTable.$mappingRelatiOnFk= ".$model->getTableName().".".$model->getPk())
->where($mappingRelationTable.".{$mappingFk}=&＃039;{$pk}&＃039;")
->order($mappingOrder)
->limit($mappingLimit)
->select();
}else
$relatiOnData= $this->query($sql);
break;
}
if(!$return){
if(isset($val[&＃039;as_fields&＃039;]) && in_array($mappingType,array(HAS_ONE,BELONGS_TO)) ) {
// 支持直接把关联的字段值映射成数据对象中的某个字段
// 仅仅支持HAS_ONE BELONGS_TO
$fields = explode(&＃039;,&＃039;,$val[&＃039;as_fields&＃039;]);
foreach ($fields as $field){
if(strpos($field,&＃039;:&＃039;)) {
list($relationName,$nick) = explode(&＃039;:&＃039;,$field);
$result[$nick] = $relationData[$relationName];
}else{
$result[$field] = $relationData[$field];
}
}
}else{
$result[$mappingName] = $relationData;
}
unset($relationData);
}else{
return $relationData;
}
}
}
}
return $result;
}
采集微信群的网站源码,ubuntu经常异常假死,胖胖的爬虫店,php cronrun,seo-992lzw
AD：真正免费，域名+虚机+企业邮箱=0元
.net 积分 源码,vscode不能编译dll,ubuntu安装xsdl,tomcat服务日志文件,SQLite中清空数据表,可以爬虫失信被执行人吗,php 找不到指定的模块,柳州谷歌seo优化方法,网站源码盗取,dw网页设计模板lzw
京公网安备 11010802041100号