assign('breadcrumb1','拉新活动'); $this->assign('breadcrumb2','活动列表'); } /** * 列表页 * * */ public function index(Model $Model,City $City){ // 接收参数 $name = request('name',''); $idCode = request('id_code',''); $status = request('status',''); $start_time = request('start_time',''); $end_time = request('end_time',''); // 查询条件 $map = []; // 组合条件 if( $name ) $map[] = ['name','=',$name]; if( $idCode ){ $id = $Model->codeToId($idCode); $map[] = ['id','=',$id]; } if( $status ) $map[] = ['status','=',$status]; if( $start_time ) { $start_time = strtotime($start_time); $map[] = ['start_time','>=',$start_time]; } if( $end_time ) { $end_time = strtotime($end_time); $map[] = ['end_time','<=',$end_time]; } // 查询数据 $list = $Model->query()->where($map)->orderByDesc('id')->paginate(config('page_num',10)); // 循环处理数据 foreach ($list as $key => $value) { // 小程序链接 $value['mp_urllink']= $this->getUrlLink($value['id']); if( $value['city_ids'] ) { // 解析数组 $cityids = explode(',',$value['city_ids']); // 获取城市 foreach ($cityids as $kk=>$vv) { // 获取值 $vv = $City->getOne($vv,'name'); // 获取城市名 $cityids[$kk] = $vv; } // 城市列表 $value['city_ids'] = implode('、',$cityids); } if ($value['id']){ $value['id_code'] = $Model->idToCode($value['id']); } // 重组 $list[$key] = $value; } // 分配数据 $this->assign('empty', '~~暂无数据'); $this->assign('list',$list); // 加载模板 return $this->fetch(); } /** * 获取小程序链接 * */ private function getUrlLink($id){ // 结果数据 $link = cache('admin:recruitment:active:urllink:'.$id); // 不存在数据 if ( is_null($link) ) { // 从数据库获取数据 $link = Mini::getUrlLink('pages/recruitment/index','id='.$id); // 存起来 cache(['admin:recruitment:active:urllink:'.$id=>$link],$link ? now()->addDays(28) : now()->addMinutes(3)); } // 返回结果 return $link; } /** * 获取小程序海报 * */ public function get_poster(Model $Model){ // 接收参数 $id = request('id',0); // 查询用户 $oldData = $Model->where(['id'=>$id])->first(); // 错误告知 if( !$oldData ) return $this->error('查无数据'); // 获取分享海报图片 $result = $this->getShareImage('id='.$id); // 错误提示 if( isset($result['error']) ) return $this->error($result['error']); // 分配数据 $this->assign('image',$result); $this->assign('oldData',$oldData); $this->assign('crumbs','海报'); // 加载模板 return $this->fetch(); } /** * 获取分享海报图片 * @param int $scene 场景值 * */ private function getShareImage($scene){ // 尝试执行 try { // 加载图片 $image = Image::make(public_path('uploads/images/poster/').'recruitment.png'); // 生成小程序二维码 $qrcode = Mini::getUnlimit($scene,['page'=>'pages/recruitment/index','width'=>480,'is_hyaline'=>true]); // 错误提示 if( isset($qrcode['error']) ) return $qrcode; // 加载图片 $qrcode = Image::make($qrcode); // 插入图片 $image->insert($qrcode,'bottom-center',0,345); // 转码成字符串 $image = $image->encode('jpg', 90)->__toString(); // 转base64 $base64 = 'data:image/jpg;base64,' . base64_encode($image); // 返回结果 return $base64; } catch (\Throwable $th) { // 错误提示 return ['error'=>$th->getMessage()]; } } /** * 添加 * * */ public function add(Request $request,Model $Model,City $City,WeiBanTags $WeiBanTags){ if( request()->isMethod('post') ){ // 验证参数 $request->scene('add')->validate(); // 接收数据 $data['banner_img'] = request('banner_img',''); $data['name'] = request('name',''); $data['active_rule'] = request('active_rule',''); $data['start_time'] = request('start_time',''); $data['end_time'] = request('end_time',''); $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0; $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0; $cityIds = request('city_ids',[]); $tagScope = request('tag_scope',[]); $tagExcept = request('tag_except',[]); $data['city_ids'] = implode(',',$cityIds); $data['tag_scope'] = implode(',',$tagScope); $data['tag_except'] = implode(',',$tagExcept); $data['status'] = 1; // 写入数据表 $id = $Model->add($data); // 如果操作失败 if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']); // 记录行为 $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data); // 告知结果 return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']); } // 获取列表 $cityList = $City->getCityList(); // 标签列表 $tagData = $WeiBanTags->query()->groupBy('group')->groupBy('name')->get(['group','name'])->toArray(); // 标签列表 $tagList = []; // 循环数据 foreach ($tagData as $value) { $tagList[$value['group']][] = $value['name']; } // 分配数据 $this->assign('cityList',$cityList); $this->assign('tagList',$tagList); $this->assign('crumbs','新增'); // 加载模板 return $this->fetch(); } /** * 修改 * * */ public function edit(Request $request,Model $Model,City $City,WeiBanTags $WeiBanTags){ // 接收参数 $id = request('id',0); // 查询用户 $oldData = $Model->where(['id'=>$id])->first(); // 修改 if(request()->isMethod('post')){ // 验证参数 $request->scene('edit')->validate(); // 接收数据 $data['banner_img'] = request('banner_img',''); $data['name'] = request('name',''); $data['active_rule'] = request('active_rule',''); $data['start_time'] = request('start_time',''); $data['end_time'] = request('end_time',''); $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0; $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0; $tagExcept = request('tag_except',[]); $cityIds = request('city_ids',[]); $tagScope = request('tag_scope',[]); $data['city_ids'] = implode(',',$cityIds); $data['tag_scope'] = implode(',',$tagScope); $data['tag_except'] = implode(',',$tagExcept); // 写入数据表 $result = $Model->edit($id,$data); // 如果操作失败 if( !$result ) return json_send(['code'=>'error','msg'=>'修改失败']); // 记录行为 $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data); // 告知结果 return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']); } // 错误告知 if( !$oldData ) return $this->error('查无数据'); // 获取城市ID $oldData['city_ids'] = explode(',',$oldData['city_ids']); $oldData['tag_scope'] = explode(',',$oldData['tag_scope']); $oldData['tag_except'] = explode(',',$oldData['tag_except']); // 获取列表 $cityList = $City->getCityList(); // 标签列表 $tagData = $WeiBanTags->query()->groupBy('group')->groupBy('name')->get(['group','name'])->toArray(); // 标签列表 $tagList = []; // 循环数据 foreach ($tagData as $value) { $tagList[$value['group']][] = $value['name']; } // 分配数据 $this->assign('cityList',$cityList); $this->assign('tagList',$tagList); $this->assign('oldData',$oldData); $this->assign('crumbs','修改'); // 加载模板 return $this->fetch(); } /** * 修改状态 * * */ public function set_status(Request $request,Model $Model){ // 验证参数 $request->scene('set_status')->validate(); // 设置状态 $id = request('id',0); $status = request('status',0); // 查询用户 $oldData = $Model->where(['id'=>$id])->first(); // 如果用户不存在 if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']); // 执行修改 $result = $Model->edit($id,['status'=>$status]); // 提示新增失败 if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']); // 记录行为 $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]); // 告知结果 return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']); } }