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', '~~暂无数据'); $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' => '']); } }