ScoreClockinActive.php 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Facades\Servers\WechatMini\Mini;
  3. use App\Http\Requests\Admin\ScoreClockinActive as Request;
  4. use App\Models\City;
  5. use App\Models\Score\ClockinActive as Model;
  6. use App\Models\WeiBan\Tags as WeiBanTags;
  7. /**
  8. * 打卡活动
  9. *
  10. * @author jun
  11. *
  12. */
  13. class ScoreClockinActive 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(Request $request, Model $Model, City $City){
  24. // 接收参数
  25. $name = request('name','');
  26. // 查询条件
  27. $map = [];
  28. // 组合条件
  29. if( $name ) $map[] = ['name','=',$name];
  30. // 查询数据
  31. $list = $Model->query()->where($map)->orderByDesc('id')->paginate(config('page_num',10));
  32. // 循环处理数据
  33. foreach ($list as $key => $value) {
  34. // 小程序链接
  35. $value['mp_urllink']= $this->getUrlLink($value['id']);
  36. if( $value['city_ids'] ) {
  37. // 解析数组
  38. $cityids = explode(',',$value['city_ids']);
  39. // 获取城市
  40. foreach ($cityids as $kk=>$vv) {
  41. // 获取值
  42. $vv = $City->getOne($vv,'name');
  43. // 获取城市名
  44. $cityids[$kk] = $vv;
  45. }
  46. // 城市列表
  47. $value['city_ids'] = implode('、',$cityids);
  48. }
  49. // 重组
  50. $list[$key] = $value;
  51. }
  52. // 分配数据
  53. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  54. $this->assign('list',$list);
  55. // 加载模板
  56. return $this->fetch();
  57. }
  58. /**
  59. * 获取小程序链接
  60. *
  61. */
  62. private function getUrlLink($id){
  63. // 结果数据
  64. $link = cache('admin:clockin:active:urllink:'.$id);
  65. // 不存在数据
  66. if ( is_null($link) ) {
  67. // 从数据库获取数据
  68. $link = Mini::getUrlLink('pages/clockin/active','?id='.$id);
  69. // 存起来
  70. cache(['admin:clockin:active:urllink:'.$id=>$link],$link ? now()->addDays(28) : now()->addMinutes(3));
  71. }
  72. // 返回结果
  73. return $link;
  74. }
  75. /**
  76. * 添加
  77. *
  78. * */
  79. public function add(Request $request, Model $Model, City $City, WeiBanTags $WeiBanTags){
  80. if( request()->isMethod('post') ){
  81. // 验证参数
  82. $request->scene('add')->validate();
  83. // 接收数据
  84. $data['banner_img'] = request('banner_img','');
  85. $data['name'] = request('name','');
  86. $data['active_rule'] = request('active_rule','');
  87. $data['start_time'] = request('start_time','');
  88. $data['end_time'] = request('end_time','');
  89. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  90. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  91. $cityIds = request('city_ids',[]);
  92. $tagScope = request('tag_scope',[]);
  93. $data['city_ids'] = implode(',',$cityIds);
  94. $data['tag_scope'] = implode(',',$tagScope);
  95. $data['status'] = 1;
  96. // 写入数据表
  97. $id = $Model->add($data);
  98. // 如果操作失败
  99. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  100. // 记录行为
  101. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  102. // 告知结果
  103. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  104. }
  105. // 获取列表
  106. $cityList = $City->getCityList();
  107. // 标签列表
  108. $tagData = $WeiBanTags->query()->groupBy('group')->groupBy('name')->get(['group','name'])->toArray();
  109. // 标签列表
  110. $tagList = [];
  111. // 循环数据
  112. foreach ($tagData as $value) {
  113. $tagList[$value['group']][] = $value['name'];
  114. }
  115. // 分配数据
  116. $this->assign('cityList',$cityList);
  117. $this->assign('tagList',$tagList);
  118. $this->assign('crumbs','新增');
  119. // 加载模板
  120. return $this->fetch();
  121. }
  122. /**
  123. * 修改
  124. *
  125. * */
  126. public function edit(Request $request,Model $Model,City $City,WeiBanTags $WeiBanTags){
  127. // 接收参数
  128. $id = request('id',0);
  129. // 查询用户
  130. $oldData = $Model->where(['id'=>$id])->first();
  131. // 修改
  132. if(request()->isMethod('post')){
  133. // 验证参数
  134. $request->scene('edit')->validate();
  135. // 接收数据
  136. $data['banner_img'] = request('banner_img','');
  137. $data['name'] = request('name','');
  138. $data['active_rule'] = request('active_rule','');
  139. $data['start_time'] = request('start_time','');
  140. $data['end_time'] = request('end_time','');
  141. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  142. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  143. $cityIds = request('city_ids',[]);
  144. $tagScope = request('tag_scope',[]);
  145. $data['city_ids'] = implode(',',$cityIds);
  146. $data['tag_scope'] = implode(',',$tagScope);
  147. // 写入数据表
  148. $result = $Model->edit($id,$data);
  149. // 如果操作失败
  150. if( !$result ) return json_send(['code'=>'error','msg'=>'修改失败']);
  151. // 记录行为
  152. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  153. // 告知结果
  154. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  155. }
  156. // 错误告知
  157. if( !$oldData ) return $this->error('查无数据');
  158. // 获取城市ID
  159. $oldData['city_ids'] = explode(',',$oldData['city_ids']);
  160. $oldData['tag_scope'] = explode(',',$oldData['tag_scope']);
  161. // 获取列表
  162. $cityList = $City->getCityList();
  163. // 标签列表
  164. $tagData = $WeiBanTags->query()->groupBy('group')->groupBy('name')->get(['group','name'])->toArray();
  165. // 标签列表
  166. $tagList = [];
  167. // 循环数据
  168. foreach ($tagData as $value) {
  169. $tagList[$value['group']][] = $value['name'];
  170. }
  171. // 分配数据
  172. $this->assign('cityList',$cityList);
  173. $this->assign('tagList',$tagList);
  174. $this->assign('oldData',$oldData);
  175. $this->assign('crumbs','修改');
  176. // 加载模板
  177. return $this->fetch();
  178. }
  179. /**
  180. * 修改状态
  181. *
  182. * */
  183. public function set_status(Request $request,Model $Model){
  184. // 验证参数
  185. $request->scene('set_status')->validate();
  186. // 设置状态
  187. $id = request('id',0);
  188. $status = request('status',0);
  189. // 查询用户
  190. $oldData = $Model->where(['id'=>$id])->first();
  191. // 如果用户不存在
  192. if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
  193. // 执行修改
  194. $result = $Model->edit($id,['status'=>$status]);
  195. // 提示新增失败
  196. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  197. // 记录行为
  198. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  199. // 告知结果
  200. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  201. }
  202. }