接口路由
Route::get('v1/place/list', 'Api\ApiController@placeList'); //活动地点信息查询接口
Route::post('v1/place/add', 'Api\ApiController@placeAdd'); // 新增活动地点接口
Route::post('v1/place/update/{id}', 'Api\ApiController@placeUpdate'); // 修改活动地点接口
Route::post('v1/place/del/{id}', 'Api\ApiController@placeDel'); // 删除活动地点接口
数据获取接口
public function placeList(Request $request){
$place = $this->place;
if($request->name !==null){
$place = $place->where('name','like','%'.$request->name.'%');
}
if($request->school !==null){
$school = $this->school->where('name','like','%'.$request->school.'%')->get();
if($school){
$schools=[];
foreach($school as $value){
$schools[]=$value->id;
}
$place = $place->whereIn('school',$schools);
}else{
return response()->json(['errorCode'=>100002,'data'=>'无该活动地点']);
}
}
return response()->json(['errorCode' => 0, 'data' => $place->with('school')->orderBy('created_at','desc')->paginate($request->size)]);
}
或者
public function schoolList(Request $request)
{
return response()->json(['errorCode' => 0, 'data' => $this->school->orderBy('created_at','desc')->get()]);
}
数据添加接口
public function placeAdd(Request $request){
$all = $request->all();
$re=$this->place->where('name',$all['name'])->first();
if($re){
return response()->json(['errorCode'=>10002,'errorMsg'=>'该活动地点已存在,请重新添加']);
}else{
$res = $this->place->create($all);
if($res){
return response()->json(['errorCode'=>0,'message'=>'添加成功']);
}else{
return response()->json(['errorCode'=>10002,'errorMsg'=>'添加失败']);
}
}
}
更新数据接口
public function placeUpdate(Request $request,$id){
$all = $request->all();
if ($this->place->find($id)->update($all)) {
return response()->json(['errorCode'=>0,'message'=>'更新成功'], 201);
} else {
return response()->json(['errorCode'=>10002,'errorMsg'=>'更新失败']);
}
}
删除数据接口
public function placeDel(Request $request,$id){
$all = $request->all();
if ($this->place->destroy($id)) {
return response()->json(['errorCode'=>0,'message'=>'删除成功'], 201);
} else {
return response()->json(['errorCode'=>10002,'errorMsg'=>'删除失败']);
}
}