baokan/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\Facades\Servers\WechatWork\CorpTag as WorkTag;
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(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){
        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();
        // 标签列表
		$tagList					= WorkTag::getList();
        // 分配数据
        $this->assign('cityList', $cityList);
        $this->assign('tagList', $tagList);
        $this->assign('crumbs', '新增');
        // 加载模板
        return                        $this->fetch();
    }

    /**
     * 修改
     *
     * */
    public function edit(Request $request, Model $Model, City $City)
    {
        // 接收参数
        $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();
        // 标签列表
		$tagList					= WorkTag::getList();
        // 分配数据
        $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' => '']);
    }
}