## 基礎BaselModel ``` ~~~ <?php namespace app\api\model; use think\Model; use traits\model\SoftDelete; class BaseModel extends Model { // 軟刪除，設置后在查詢時要特別注意whereOr // 使用whereOr會將設置了軟刪除的記錄也查詢出來 // 可以對比下SQL語句，看看whereOr的SQL use SoftDelete; protected $hidden = ['delete_time']; protected function prefixImgUrl($value, $data){ $finalUrl = $value; if($data['from'] == 1){ $finalUrl = config('setting.img_prefix').$value; } return $finalUrl; } } ~~~ ``` ## 其他的model繼承 ~~~ <?php namespace app\api\model; use think\Model; class Category extends BaseModel { public function products() { return $this->hasMany('Product', 'category_id', 'id'); } public function img() { return $this->belongsTo('Image', 'topic_img_id', 'id'); } public static function getCategories($ids) { $categories = self::with('products') ->with('products.img') ->select($ids); return $categories; } public static function getCategory($id) { $category = self::with('products') ->with('products.img') ->find($id); return $category; } } ~~~ ## 控制器里面調用 ## ``` ~~~ public function getCategory($id) { $validate = new IDMustBePositiveInt(); $validate->goCheck(); $category = CategoryModel::getCategory($id); if(empty($category)){ throw new MissException([ 'msg' => 'category not found' ]); } return $category; } ~~~ ```