Article.php 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\Article as Request;
  3. use App\Models\Article as Model;
  4. use App\Models\ArticleComment;
  5. use Illuminate\Support\Facades\DB;
  6. use App\Models\City;
  7. /**
  8. * 分享设置
  9. *
  10. * @author huanglei
  11. *
  12. */
  13. class Article extends Auth{
  14. protected function _initialize(){
  15. parent::_initialize();
  16. $this->assign('breadcrumb1','分享设置');
  17. $this->assign('breadcrumb2','内容分享');
  18. }
  19. /**
  20. * 首页列表
  21. *
  22. * */
  23. public function index(Model $Model,ArticleComment $ArticleComment){
  24. // 接受参数
  25. $code = request('article_code','');
  26. $status = request('status');
  27. $startTime = request('start_time','');
  28. $endTime = request('end_time','');
  29. // 编码转ID
  30. $id = $code ? $Model->codeToId($code) : 0;
  31. // 查询条件
  32. $map = [];
  33. // 编码ID
  34. if( $id ) $map[] = ['id','=',$id];
  35. if( $startTime ) $map[] = ['start_time','>=',strtotime($startTime)];
  36. if( $endTime ) $map[] = ['end_time','<=',strtotime($endTime)];
  37. if( !is_null($status) ) $map[] = ['status','=',$status];
  38. // 查询数据
  39. $list = $Model->query()->where($map);
  40. $list = $list->orderByDesc('id')->paginate(request('limit',config('page_num',10)))->appends(request()->all());
  41. // 循环处理数据
  42. foreach ($list as $key => $value) {
  43. // id转编号
  44. $value['article_code'] = $Model->idToCode($value['id']);
  45. // 重组
  46. $list[$key] = $value;
  47. }
  48. // 分配数据
  49. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  50. $this->assign('list', $list);
  51. // 加载模板
  52. return $this->fetch();
  53. }
  54. /**
  55. * 状态
  56. *
  57. * */
  58. public function set_status( Request $request, Model $Model){
  59. // 验证参数
  60. $request->scene('set_status')->validate();
  61. // 接收参数
  62. $id = request('id',0);
  63. $status = request('status',0);
  64. // 查询数据
  65. $result = $Model->edit($id,['status'=>$status]);
  66. // 提示新增失败
  67. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  68. // 告知结果
  69. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  70. }
  71. /**
  72. * 添加
  73. *
  74. * */
  75. public function add( Request $request, Model $Model,City $City,Product $Product){
  76. if( request()->isMethod('post') ){
  77. // 验证参数
  78. $request->scene('add')->validate();
  79. // 组合数据
  80. $data['poster'] = request('poster',0);
  81. $data['title'] = request('title',0);
  82. $data['qrcode_link'] = request('link',0);
  83. $data['content'] = request('description',0);
  84. $data['status'] = request('status',0);
  85. // 验证信息
  86. // if( $data['rebate_type'] == 2 && $data['rebate'] > 9.99 ) return json_send(['code'=>'error','msg'=>'不能设置大于9.99折']);
  87. // 组合数据,写入订单表,子表
  88. DB::beginTransaction();
  89. try {
  90. // 写入
  91. $id = $Model->add($data);
  92. // 提示新增失败
  93. if( !$id ) {
  94. // 回滚
  95. DB::rollBack();
  96. // 提示
  97. return json_send(['code'=>'error','msg'=>'新增失败']);
  98. }
  99. // 提交
  100. DB::commit();
  101. // 记录行为
  102. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  103. // 告知结果
  104. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  105. } catch (\Throwable $th) {
  106. // 回滚
  107. DB::rollBack();
  108. // 提示失败
  109. return json_send(['code'=>'error','msg'=>'内部错误,请重试','data'=>['error'=>$th->getMessage()]]);
  110. }
  111. }
  112. // 获取列表
  113. $cityList = $City->getCityList();
  114. // 分配数据
  115. $this->assign('cityList',$cityList);
  116. $this->assign('crumbs','新增');
  117. // 加载模板
  118. return $this->fetch();
  119. }
  120. /**
  121. * 编辑
  122. *
  123. * */
  124. public function edit( Request $request, Model $Model){
  125. // 接收参数
  126. $id = request('id',0);
  127. // 查询数据
  128. $oldData = $Model->where(['id'=>$id])->first();
  129. // 修改
  130. if(request()->isMethod('post')){
  131. // 验证参数
  132. $request->scene('edit')->validate();
  133. // 组合数据
  134. $data['poster'] = request('poster',0);
  135. $data['title'] = request('title',0);
  136. $data['qrcode_link'] = request('link',0);
  137. $data['content'] = request('description',0);
  138. $data['status'] = request('status',0);
  139. // 转换时间,默认现在现在生效
  140. $data['update_time'] = time();
  141. // 组合数据,写入订单表,子表
  142. DB::beginTransaction();
  143. try {
  144. // 写入
  145. $result = $Model->edit($id,$data);
  146. // 提示新增失败
  147. if( !$result ) {
  148. // 回滚
  149. DB::rollBack();
  150. // 提示
  151. return json_send(['code'=>'error','msg'=>'修改失败']);
  152. }
  153. // 提交
  154. DB::commit();
  155. // 记录行为
  156. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],$data);
  157. // 告知结果
  158. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  159. } catch (\Throwable $th) {
  160. // 回滚
  161. DB::rollBack();
  162. // 提示失败
  163. return json_send(['code'=>'error','msg'=>'内部错误,请重试','data'=>['error'=>$th->getMessage()]]);
  164. }
  165. }
  166. // 如果是没有数据
  167. if( !$oldData ) return $this->error('查无数据');
  168. // 分配数据
  169. $this->assign('oldData',$oldData);
  170. $this->assign('crumbs','修改');
  171. // 加载模板
  172. return $this->fetch();
  173. }
  174. }