1.模型代码:
public function getSubjectesLists($request){ $subjectes = DB::table($this->table); //查询条件namekeyword if ($request->namekeyword != "") { $namekeyword = $request->namekeyword; $subjectes->where(function ($subjectes) use ($namekeyword) { $subjectes->where('subjectname', 'like', '%' . $namekeyword . '%'); }); } $data = $subjectes->select('id','pid','subjectname','specials','sort','top','level')->where('is_delete', 1)->orderBy('top', 'desc')->orderBy('sort', 'asc')->get(); return $data; }
2.控制器代码 :
//获取分类列表 public function getLists(Request $request) { $dataContent = $this->subjectes