kailin/app/Http/Controllers/Admin/RiddleActive.php

<?php namespace App\Http\Controllers\Admin;

use App\Facades\Servers\WechatMini\Mini;
use App\Http\Requests\Admin\Riddle\Active as Request;
use App\Models\Riddle\Active as Model;
use App\Models\City;
use App\Models\WeiBan\Taglist as WeiBanTagList;

/**
 * 答题活动规则
 *
 * @author    刘相欣
 *
 */
class RiddleActive extends Auth{
	
	protected function _initialize(){
		parent::_initialize();
		$this->assign('breadcrumb1','答题活动');
		$this->assign('breadcrumb2','活动列表');
	}

	/**
	 * 列表页
	 * 
	 * */
    public function index(Model $Model){
		// 接收参数
		$name					= request('name','');
		// 查询条件
		$map 					= [];
		// 组合条件
		if( $name )				$map[] = ['name','=',$name];
		// 查询数据
		$list					= $Model->query()->where($map)->orderByDesc('id')->paginate(config('page_num',10))->appends(request()->all());
		// 循环处理数据
		foreach ($list as $key => $value) {
			// 小程序链接
			$value['mp_urllink']= $this->getUrlLink($value['id']);
			// 重组
			$list[$key]			= $value;
		}
		// 分配数据
		$this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
		$this->assign('list',$list);
		// 加载模板
		return 					$this->fetch();
    }

	/**
	 * 获取小程序链接
	 * 
	 */
	private function getUrlLink($id){
		// 结果数据
        $link                  = cache('admin:riddle:active:urllink:'.$id);
        // 不存在数据
        if ( is_null($link) ) {
            // 从数据库获取数据
            $link              = Mini::getUrlLink('pages/activity/index','id='.$id);
            // 存起来
            cache(['admin:riddle:active:urllink:'.$id=>$link],$link ? now()->addDays(28) : now()->addMinutes(3));
        }
        // 返回结果
        return                  $link;

	}

	/**
	 * 添加
	 * 
	 * */
	public function add(Request $request,Model $Model,City $City,WeiBanTagList $WeiBanTagList){
		if( request()->isMethod('post') ){
			// 验证参数
			$request->scene('add')->validate();
			// 接收数据
			$data['logo']			= request('logo','');
			$data['name']			= request('name','');
			$data['rule']			= request('rule','');
			$data['freq']			= request('freq',0);
			$data['join_total']		= request('join_total',0);
			$data['join_share']		= request('join_share',0);
			$data['lottery_id']		= request('lottery_id',0);
			$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',[]);
			$data['city_ids']		= implode(',',$cityIds);
			$data['tag_scope']		= implode(',',$tagScope);
			$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					= $WeiBanTagList->query()->get(['tag_group_name as group','tag_name as 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,WeiBanTagList $WeiBanTagList){
		// 接收参数
		$id							= request('id',0);
		// 查询用户
		$oldData					= $Model->where(['id'=>$id])->first();
		// 修改
		if(request()->isMethod('post')){
			// 验证参数
			$request->scene('edit')->validate();
			// 接收数据
			$data['logo']			= request('logo','');
			$data['name']			= request('name','');
			$data['rule']			= request('rule','');
			$data['freq']			= request('freq',0);
			$data['join_total']		= request('join_total',0);
			$data['join_share']		= request('join_share',0);
			$data['lottery_id']		= request('lottery_id',0);
			$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',[]);
			$data['city_ids']		= implode(',',$cityIds);
			$data['tag_scope']		= implode(',',$tagScope);
			// 写入数据表
			$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']);
		// 获取列表
		$cityList					= $City->getCityList();
		// 标签列表
		$tagData					= $WeiBanTagList->query()->get(['tag_group_name as group','tag_name as 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'=>'']);
	}

}