ScoreClockinActive.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310
  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\Score\Clockin as Clockin;
  7. use App\Models\WeiBan\Tags as WeiBanTags;
  8. use Illuminate\Support\Facades\DB;
  9. use Intervention\Image\Facades\Image;
  10. /**
  11. * 打卡活动
  12. *
  13. * @author jun
  14. *
  15. */
  16. class ScoreClockinActive extends Auth{
  17. protected function _initialize(){
  18. parent::_initialize();
  19. $this->assign('breadcrumb1','任务打卡');
  20. $this->assign('breadcrumb2','打卡任务');
  21. }
  22. /**
  23. * 列表页
  24. *
  25. * */
  26. public function index( Model $Model, City $City){
  27. // 接收参数
  28. $name = request('name','');
  29. // 查询条件
  30. $map = [];
  31. // 组合条件
  32. if( $name ) $map[] = ['name','=',$name];
  33. // 查询数据
  34. $list = $Model->query()->where($map)->orderByDesc('id')->paginate(config('page_num',10));
  35. // 循环处理数据
  36. foreach ($list as $key => $value) {
  37. // 小程序链接
  38. $value['mp_urllink']= $this->getUrlLink($value['id']);
  39. if( $value['city_ids'] ) {
  40. // 解析数组
  41. $cityids = explode(',',$value['city_ids']);
  42. // 获取城市
  43. foreach ($cityids as $kk=>$vv) {
  44. // 获取值
  45. $vv = $City->getOne($vv,'name');
  46. // 获取城市名
  47. $cityids[$kk] = $vv;
  48. }
  49. // 城市列表
  50. $value['city_ids'] = implode('、',$cityids);
  51. }
  52. // 重组
  53. $list[$key] = $value;
  54. }
  55. // 分配数据
  56. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  57. $this->assign('list',$list);
  58. // 加载模板
  59. return $this->fetch();
  60. }
  61. /**
  62. * 获取小程序链接
  63. *
  64. */
  65. private function getUrlLink($id){
  66. // 结果数据
  67. $link = cache('admin:clockin:active:urllink:'.$id);
  68. // 不存在数据
  69. if ( is_null($link) ) {
  70. // 从数据库获取数据
  71. $link = Mini::getUrlLink('pages/score/clockin','id='.$id);
  72. // 存起来
  73. cache(['admin:clockin:active:urllink:'.$id=>$link],$link ? now()->addDays(28) : now()->addMinutes(3));
  74. }
  75. // 返回结果
  76. return $link;
  77. }
  78. /**
  79. * 获取小程序海报
  80. *
  81. */
  82. public function get_poster(Model $Model){
  83. // 接收参数
  84. $id = request('id',0);
  85. // 查询用户
  86. $oldData = $Model->where(['id'=>$id])->first();
  87. // 错误告知
  88. if( !$oldData ) return $this->error('查无数据');
  89. // 获取分享海报图片
  90. $result = $this->getShareImage('id='.$id);
  91. // 错误提示
  92. if( isset($result['error']) ) return $this->error($result['error']);
  93. // 分配数据
  94. $this->assign('image',$result);
  95. $this->assign('oldData',$oldData);
  96. $this->assign('crumbs','海报');
  97. // 加载模板
  98. return $this->fetch();
  99. }
  100. /**
  101. * 获取分享海报图片
  102. * @param int $scene 场景值
  103. *
  104. */
  105. private function getShareImage($scene){
  106. // 尝试执行
  107. try {
  108. // 加载图片
  109. $image = Image::make(public_path('uploads/images/poster/').'score_clockin.png');
  110. // 生成小程序二维码
  111. $qrcode = Mini::getUnlimit($scene,['page'=>'pages/score/clockin','width'=>280,'is_hyaline'=>true]);
  112. // 错误提示
  113. if( isset($qrcode['error']) ) return $qrcode;
  114. // 加载图片
  115. $qrcode = Image::make($qrcode);
  116. // 插入图片
  117. $image->insert($qrcode,'bottom-right',60,80);
  118. // 转码成字符串
  119. $image = $image->encode('jpg', 90)->__toString();
  120. // 转base64
  121. $base64 = 'data:image/jpg;base64,' . base64_encode($image);
  122. // 返回结果
  123. return $base64;
  124. } catch (\Throwable $th) {
  125. // 错误提示
  126. return ['error'=>$th->getMessage()];
  127. }
  128. }
  129. /**
  130. * 添加
  131. *
  132. * */
  133. public function add(Request $request, Model $Model, City $City, WeiBanTags $WeiBanTags){
  134. if( request()->isMethod('post') ){
  135. // 验证参数
  136. $request->scene('add')->validate();
  137. // 接收数据
  138. $data['banner_img'] = request('banner_img','');
  139. $data['name'] = request('name','');
  140. $data['active_rule'] = request('active_rule','');
  141. $data['start_time'] = request('start_time','');
  142. $data['end_time'] = request('end_time','');
  143. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  144. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  145. $cityIds = request('city_ids',[]);
  146. $tagScope = request('tag_scope',[]);
  147. $data['city_ids'] = implode(',',$cityIds);
  148. $data['tag_scope'] = implode(',',$tagScope);
  149. $data['status'] = 1;
  150. // 写入数据表
  151. $id = $Model->add($data);
  152. // 如果操作失败
  153. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  154. // 记录行为
  155. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  156. // 告知结果
  157. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  158. }
  159. // 获取列表
  160. $cityList = $City->getCityList();
  161. // 标签列表
  162. $tagData = $WeiBanTags->query()->groupBy('group')->groupBy('name')->get(['group','name'])->toArray();
  163. // 标签列表
  164. $tagList = [];
  165. // 循环数据
  166. foreach ($tagData as $value) {
  167. $tagList[$value['group']][] = $value['name'];
  168. }
  169. // 分配数据
  170. $this->assign('cityList',$cityList);
  171. $this->assign('tagList',$tagList);
  172. $this->assign('crumbs','新增');
  173. // 加载模板
  174. return $this->fetch();
  175. }
  176. /**
  177. * 修改
  178. *
  179. * */
  180. public function edit(Request $request,Model $Model,City $City,WeiBanTags $WeiBanTags){
  181. // 接收参数
  182. $id = request('id',0);
  183. // 查询用户
  184. $oldData = $Model->where(['id'=>$id])->first();
  185. // 修改
  186. if(request()->isMethod('post')){
  187. // 验证参数
  188. $request->scene('edit')->validate();
  189. // 接收数据
  190. $data['banner_img'] = request('banner_img','');
  191. $data['name'] = request('name','');
  192. $data['active_rule'] = request('active_rule','');
  193. $data['start_time'] = request('start_time','');
  194. $data['end_time'] = request('end_time','');
  195. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  196. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  197. $cityIds = request('city_ids',[]);
  198. $tagScope = request('tag_scope',[]);
  199. $data['city_ids'] = implode(',',$cityIds);
  200. $data['tag_scope'] = implode(',',$tagScope);
  201. // 写入数据表
  202. $result = $Model->edit($id,$data);
  203. // 如果操作失败
  204. if( !$result ) return json_send(['code'=>'error','msg'=>'修改失败']);
  205. // 记录行为
  206. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  207. // 告知结果
  208. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  209. }
  210. // 错误告知
  211. if( !$oldData ) return $this->error('查无数据');
  212. // 获取城市ID
  213. $oldData['city_ids'] = explode(',',$oldData['city_ids']);
  214. $oldData['tag_scope'] = explode(',',$oldData['tag_scope']);
  215. // 获取列表
  216. $cityList = $City->getCityList();
  217. // 标签列表
  218. $tagData = $WeiBanTags->query()->groupBy('group')->groupBy('name')->get(['group','name'])->toArray();
  219. // 标签列表
  220. $tagList = [];
  221. // 循环数据
  222. foreach ($tagData as $value) {
  223. $tagList[$value['group']][] = $value['name'];
  224. }
  225. // 分配数据
  226. $this->assign('cityList',$cityList);
  227. $this->assign('tagList',$tagList);
  228. $this->assign('oldData',$oldData);
  229. $this->assign('crumbs','修改');
  230. // 加载模板
  231. return $this->fetch();
  232. }
  233. /**
  234. * 修改状态
  235. *
  236. * */
  237. public function set_status(Request $request,Model $Model){
  238. // 验证参数
  239. $request->scene('set_status')->validate();
  240. // 设置状态
  241. $id = request('id',0);
  242. $status = request('status',0);
  243. // 查询用户
  244. $oldData = $Model->where(['id'=>$id])->first();
  245. // 如果用户不存在
  246. if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
  247. // 执行修改
  248. $result = $Model->edit($id,['status'=>$status]);
  249. // 提示新增失败
  250. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  251. // 记录行为
  252. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  253. // 告知结果
  254. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  255. }
  256. /**
  257. * 复制
  258. *
  259. * */
  260. public function copy(Request $request,Model $Model,Clockin $Clockin){
  261. // 验证参数
  262. $request->scene('copy')->validate();
  263. // 设置状态
  264. $id = request('id',0);
  265. $time = time();
  266. // 查询
  267. $data = $Model->where(['id'=>$id])->first()->toArray();
  268. if (!$data) json_send(['code'=>'error','msg'=>'复制失败,活动不存在']);
  269. $clockinList = $Clockin->getActiveList($id);
  270. DB::beginTransaction();
  271. try {
  272. unset($data['id']);
  273. $data['status'] = 1;
  274. $data['name'] = $data['name'].'复制';
  275. //复制活动
  276. $newId = $Model->add($data);
  277. if (!$newId){
  278. DB::rollBack();
  279. return json_send(['code'=>'error','msg'=>'复制失败']);
  280. }
  281. if ($clockinList){
  282. foreach ($clockinList as &$clockin){
  283. $clockin['active_id'] = $newId;
  284. $clockin['insert_time'] = $time;
  285. $clockin['update_time'] = $time;
  286. unset($clockin['id']);
  287. }
  288. $re = $Clockin->Query()->insert($clockinList);
  289. if (!$re) return json_send(['code'=>'error','msg'=>'复制失败']);
  290. }
  291. DB::commit();
  292. }catch (\Exception $e){
  293. // 回退数据
  294. DB::rollBack();
  295. // 失败提示
  296. return json_send(['code'=>'error','msg'=>'复制失败','data'=>['error'=>$e->getMessage().$e->getLine()]]);
  297. }
  298. return json_send(['code'=>'success','msg'=>'复制成功','path'=>'']);
  299. }
  300. }