123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869 |
- <?php
- namespace app\model;
- use think\facade\Db;
- use think\Model;
- class CdssDisease extends Model
- {
- protected $table = "jm_cdss_xy_disease";
- /**
- * 组装知识库详情返回
- */
- public static function jointZskDetailFieds($table , $model , $field , $value)
- {
- /**
- * 获取表结构
- */
- $sql ="show full columns from {$table}";
- $res = Db::query($sql);
-
- if (is_array($value)){
- $detail=[];
- foreach ($value as $k=>$v){
- $detail[] = $model::where($field , $v)->find();
- }
- if (!empty($detail)){
- foreach ($res as $val) {
- foreach ($detail as $k=>$v){
- $v[$val['Field']] = [
- 'name' => $val['Comment'] ,
- 'text' => $v[$val['Field']] ?? ''
- ];
- unset($v['id']);
- unset($v['productionEnterprise']);
- }
- }
- }
- return $detail;
- }else{
- if ($field == 'zhonglian_name'){
- $detail = $model::whereRaw('FIND_IN_SET(?, zhonglian_name)', [$value])->find();
- //$detail = $model::where($field ,'like' ,"%$value%")->find();
- }else{
- $detail = $model::where($field , $value)->find();
- }
- }
-
- /**
- * 组装返回格式
- */
- foreach ($res as $val) {
- $detail[$val['Field']] = [
- 'name' => $val['Comment'] ,
- 'text' => $detail[$val['Field']] ?? ''
- ];
- }
- unset($detail['id']);
- return $detail;
- }
- }
|