thinkphp5 增删改查模版
<?php namespace app\模块名\controller; use app\common\controller\JWTController; use app\控制器名\model\控制器名Model; use think\Request; // use think\Validate; class 控制器名 extends JWTController { /** * 添加 * * @param Request $request * @param 控制器名Model $控制器名Model * @return void */ public function add控制器名(Request $request, 控制器名Model $控制器名Model) { try { $data = $request->param(); $data['create_time'] = time(); $data['update_time'] = time(); $validate = validate('控制器名Validate'); if (!$validate->scene('add控制器名')->check($data)) { return json(['code' => 401, 'data' => [], 'msg' => $validate->getError()]); } $res = $控制器名Model->allowField(true)->save($data); if ($res) { return json(['code' => 0, 'data' => [], 'msg' => '新增成功']); } else { return json(['code' => 1, 'data' => [], 'msg' => '新增失败']); } } catch (\Exception $e) { return json(['code' => 500, 'data' => [], 'msg' => '内部错误,请联系管理员,' . $e->getMessage()]); } } /** * 删除 * * @param [type] $id * @return void */ public function delete控制器名($id, 控制器名Model $控制器名Model) { try { if ($控制器名Model->where('id', $id)->delete()) { return json(['code' => 0, 'data' => [], 'msg' => '删除成功']); } else { return json(['code' => 1, 'data' => [], 'msg' => '删除失败']); } } catch (\Exception $e) { return json(['code' => 500, 'data' => [], 'msg' => '内部错误,请联系管理员,' . $e->getMessage()]); } } /** * 修改 * * @param [type] $id * @param Request $request * @param 控制器名Model $控制器名Model * @return void */ public function update控制器名($id, Request $request, 控制器名Model $控制器名Model) { try { $data = $request->param(); $data['update_time'] = time(); $validate = validate('控制器名Validate'); if (!$validate->scene('update控制器名')->check($data)) { return json(['code' => 401, 'data' => [], 'msg' => $validate->getError()]); } $res = $控制器名Model ->allowField(['name','service_time','控制器名_info','update_time']) ->save($data, ['id' => $id]); if ($res) { return json(['code' => 0, 'data' => [], 'msg' => '修改成功']); } else { return json(['code' => 1, 'data' => [], 'msg' => '修改失败']); } } catch (\Exception $e) { return json(['code' => 500, 'data' => [], 'msg' => '内部错误,请联系管理员,' . $e->getMessage()]); } } /** * 查询 * * @param 控制器名Model $控制器名Model * @param Request $request * @return void */ public function get控制器名(控制器名Model $控制器名Model,Request $request) { try { if ($request->param('page_size') != '') { $page_size = $request->param('page_size'); } else { $page_size = 10; } $data['控制器名'] = $控制器名Model->paginate($page_size); return json(['code' => 0, 'data' => $data, 'msg' => '查询成功']); } catch (\Exception $e) { return json(['code' => 500, 'data' => [], 'msg' => '内部错误,请联系管理员,' . $e->getMessage()]); } } }
<?php namespace app\模块名\model; use think\Model; // use traits\model\SoftDelete; class 控制器名Model extends Model { protected $table = 'product'; protected $readonly = ['id']; }
<?php /** * 验证 */ namespace app\模块名\Validate; use think\Validate; class 控制器名Validate extends Validate { protected $rule = [ 'name' => 'require', 'service_time' => 'require|integer|>=:0', 'product_info' => 'require', ]; protected $scene = [ 'addProduct' => ['name','service_time','product_info'], 'updateProduct' => ['service_time'=> 'integer'], ]; }
//添加产品 Route::rule('addPaper', 'paper/paper/addPaper','GET|POST'); //修改产品 Route::rule('updatePaper/:id', 'paper/paper/updatePaper','PUT'); //删除产品 Route::delete('deletePaper/:id', 'paper/paper/deletePaper'); // 查询产品 Route::rule('getPaper', 'paper/paper/getPaper','GET');