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

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

use App\Facades\Servers\WechatMini\Mini;
use App\Http\Requests\Admin\ScoreClockinActive as Request;
use App\Models\City;
use App\Models\Score\ClockinActive as Model;
use App\Models\Score\Clockin as Clockin;
use App\Models\WeiBan\Tags as WeiBanTags;
use Illuminate\Support\Facades\DB;


/**
 * 打卡活动
 *
 * @author    jun
 * 
 */
class ScoreClockinActive extends Auth{

	protected function _initialize(){
		parent::_initialize();
		$this->assign('breadcrumb1','任务打卡');
		$this->assign('breadcrumb2','打卡任务');
	}

    /**
     * 列表页
     *
     * */
    public function index(Request $request, Model $Model, City $City){
        // 接收参数
        $name					= request('name','');
        // 查询条件
        $map 					= [];
        // 组合条件
        if( $name )				$map[] = ['name','=',$name];
        // 查询数据
        $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);
            }
            // 重组
            $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:clockin:active:urllink:'.$id);
        // 不存在数据
        if ( is_null($link) ) {
            // 从数据库获取数据
            $link              = Mini::getUrlLink('pages/clockin/active','?id='.$id);
            // 存起来
            cache(['admin:clockin:active:urllink:'.$id=>$link],$link ? now()->addDays(28) : now()->addMinutes(3));
        }
        // 返回结果
        return                  $link;

    }

    /**
     * 添加
     *
     * */
    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',[]);
            $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					= $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;
            $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					= $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'=>'']);
    }
    /**
     * 复制
     *
     * */
    public function copy(Request $request,Model $Model,Clockin $Clockin){
        // 验证参数
        $request->scene('copy')->validate();
        // 设置状态
        $id				= request('id',0);
        $time           =   time();
        // 查询
        $data		    = $Model->where(['id'=>$id])->first()->toArray();
        if (!$data)     json_send(['code'=>'error','msg'=>'复制失败,活动不存在']);
        $clockinList    = $Clockin->getActiveList($id);
        DB::beginTransaction();
        try {
            unset($data['id']);
            $data['status'] = 1;
            $data['name'] = $data['name'].'复制';
            //复制活动
            $newId          = $Model->add($data);
            if (!$newId){
                DB::rollBack();
                return json_send(['code'=>'error','msg'=>'复制失败']);
            }
            if ($clockinList){
                foreach ($clockinList as &$clockin){
                    $clockin['active_id'] = $newId;
                    $clockin['insert_time'] = $time;
                    $clockin['update_time'] = $time;
                    unset($clockin['id']);
                }
                $re = $Clockin->Query()->insert($clockinList);
                if (!$re)   return  json_send(['code'=>'error','msg'=>'复制失败']);
            }
            DB::commit();
        }catch (\Exception $e){
            // 回退数据
            DB::rollBack();
            // 失败提示
            return						json_send(['code'=>'error','msg'=>'复制失败','data'=>['error'=>$e->getMessage().$e->getLine()]]);
        }
        return json_send(['code'=>'success','msg'=>'复制成功','path'=>'']);
    }
}