request->param(); $page = $params['page'] ?? 1; $limit = $params['limit'] ?? 15; $language_code = $params['language_code'] ?? $this->lang; $query = KeywordLanguages::where('language_code', $language_code); $count = $query->count(); $list = $query->where('language_code', $language_code) ->order('weight','desc') ->paginate(['list_rows'=>$limit,'page'=>$page]); } catch (Exception $e) { return $this->error($e->getMessage()); } return $this->success(['count' => $count, 'list' => $list]); } //新增/编辑 public function update() { try { $params = (new KeywordValidate)->post()->goCheck('edit'); $id = $params['id'] ?? 0; $status = $params['status'] ?? 1; $keyword_id = $params['keyword_id'] ?? 0; $language_code = $params['language_code'] ?? $this->lang; $exists = KeywordLanguages::where('name', $params['name'])->where('language_code', $language_code)->find(); if ($exists ) { if (!$id || $id != $exists->id) { return $this->error('关键词已存在'); } } if (!$keyword_id) { $keyword = KeywordModel::create([ 'keyword_id' => $keyword_id, ]); $keyword_id = $keyword->id; } if (empty($params['id'])) { $keywordLanguages = new KeywordLanguages(); } else { $keywordLanguages = KeywordLanguages::where('id', $id)->find(); if (!$keywordLanguages) { return $this->error('关键词不存在'); } } $keywordLanguages->keyword_id = $keyword_id; $keywordLanguages->name = $params['name']; $keywordLanguages->weight = $params['weight']; $keywordLanguages->status = $status; $keywordLanguages->language_code = $language_code; $keywordLanguages->save(); } catch (Exception $e) { return $this->error($e->getMessage()); } return $this->success([], '操作成功'); } //设置状态 public function setStatus() { try { $params = (new KeywordValidate)->goCheck('id'); $info = KeywordLanguages::where('id', $params['id'])->find(); if (!$info) { return $this->error('关键词不存在'); } $info->status = $info->status == 0 ? 1 : 0; $info->save(); } catch (Exception $e) { return $this->error($e->getMessage()); } return $this->success([], '操作成功'); } //删除 public function delete() { try { $params = (new KeywordValidate)->goCheck('id'); $info = KeywordLanguages::where('id', $params['id'])->find(); if (!$info) { return $this->error('关键词不存在'); } $keyword_id = $info->keyword_id; $info->delete(); if (KeywordLanguages::where('keyword_id', $keyword_id)->count() == 0) { KeywordModel::where('id', $keyword_id)->delete(); } } catch (Exception $e) { return $this->error($e->getMessage()); } return $this->success([],'删除成功'); } }