School.php 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\School as Request;
  3. use App\Models\School as Model;
  4. use App\Models\City;
  5. /**
  6. * banner管理
  7. *
  8. * @author 刘相欣
  9. *
  10. */
  11. class School extends Auth{
  12. protected function _initialize(){
  13. parent::_initialize();
  14. $this->assign('breadcrumb1','学校管理');
  15. $this->assign('breadcrumb2','学校列表');
  16. }
  17. /**
  18. * 列表页
  19. *
  20. * */
  21. public function index(Model $Model){
  22. // 接受参数
  23. $name = request('name','');
  24. $area = request('area','');
  25. $status = request('status');
  26. $startTime = request('start_time','');
  27. // 查询条件
  28. $map = [];
  29. if( $name ) $map[] = ['name','=',$name];
  30. if( $area ) $map[] = ['area','=',$area];
  31. if( $startTime ) $map[] = ['insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()];
  32. if( $startTime ) $map[] = ['insert_time','<=',Carbon::createFromFormat('Y-m-d',$startTime)->endOfDay()->getTimestamp()];
  33. if( !is_null($status) ) $map[] = ['status','=',$status];
  34. // 查询数据
  35. $list = $Model->query()->where($map)->orderByDesc('id')->paginate(config('page_num',10))->appends(request()->all());
  36. $areaList = $Model->getAreaList();
  37. // 分配数据
  38. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  39. $this->assign('areaList',$areaList);
  40. $this->assign('list',$list);
  41. // 加载模板
  42. return $this->fetch();
  43. }
  44. /**
  45. * 添加
  46. *
  47. * */
  48. public function add(Request $request,Model $Model){
  49. if( request()->isMethod('post') ){
  50. // 验证参数
  51. $request->scene('add')->validate();
  52. // 接收数据
  53. $data['name'] = request('name','');
  54. $data['area'] = request('area','');
  55. // 写入数据表
  56. $id = $Model->add($data);
  57. // 如果操作失败
  58. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  59. // 记录行为
  60. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  61. // 告知结果
  62. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  63. }
  64. $areaList = $Model->getAreaList();
  65. // 分配数据
  66. $this->assign('areaList',$areaList);
  67. $this->assign('crumbs','新增');
  68. // 加载模板
  69. return $this->fetch();
  70. }
  71. /**
  72. * 修改
  73. *
  74. * */
  75. public function edit(Request $request,Model $Model){
  76. // 接收参数
  77. $id = request('id',0);
  78. // 查询用户
  79. $oldData = $Model->where(['id'=>$id])->first();
  80. // 修改
  81. if(request()->isMethod('post')){
  82. // 验证参数
  83. $request->scene('edit')->validate();
  84. // 接收数据
  85. $data['name'] = request('name','');
  86. $data['area'] = request('area','');
  87. // 写入数据表
  88. $result = $Model->edit($id,$data);
  89. // 如果操作失败
  90. if( !$result ) return json_send(['code'=>'error','msg'=>'新增失败']);
  91. // 记录行为
  92. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  93. // 告知结果
  94. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  95. }
  96. $areaList = $Model->getAreaList();
  97. // 错误告知
  98. if( !$oldData ) return $this->error('查无数据');
  99. // 分配数据
  100. $this->assign('areaList',$areaList);
  101. $this->assign('oldData',$oldData);
  102. $this->assign('crumbs','修改');
  103. // 加载模板
  104. return $this->fetch();
  105. }
  106. /**
  107. * 修改状态
  108. *
  109. * */
  110. public function set_status(Request $request,Model $Model){
  111. // 验证参数
  112. $request->scene('set_status')->validate();
  113. // 设置状态
  114. $id = request('id',0);
  115. $status = request('status',0);
  116. // 查询用户
  117. $oldData = $Model->where(['id'=>$id])->first();
  118. // 如果用户不存在
  119. if( !$oldData ) return json_send(['code'=>'error','msg'=>'用户不存在']);
  120. // 执行修改
  121. $result = $Model->edit($id,['status'=>$status]);
  122. // 提示新增失败
  123. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  124. // 记录行为
  125. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  126. // 告知结果
  127. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  128. }
  129. }