// +---------------------------------------------------------------------- namespace app\common\repositories\community; use app\common\dao\community\CommunityCategoryDao; use app\common\repositories\BaseRepository; use app\controller\api\community\CommunityTopic; use FormBuilder\Factory\Elm; use think\exception\ValidateException; use think\facade\Route; class CommunityCategoryRepository extends BaseRepository { /** * @var CommunityCategoryDao */ protected $dao; /** * CommunityCategoryRepository constructor. * @param CommunityCategoryDao $dao */ public function __construct(CommunityCategoryDao $dao) { $this->dao = $dao; } public function form(?int $id) { $formData = []; if (!$id) { $form = Elm::createForm(Route::buildUrl('systemCommunityCategoryCreate')->build()); } else { $formData = $this->dao->get($id)->toArray(); $form = Elm::createForm(Route::buildUrl('systemCommunityCategoryUpdate', ['id' => $id])->build()); } $form->setRule([ Elm::input('cate_name', '分类名称')->required(), Elm::switches('is_show', '是否显示', 1)->activeValue(1)->inactiveValue(0)->inactiveText('关')->activeText('开'), Elm::number('sort', '排序')->precision(0)->max(99999), ]); return $form->setTitle(is_null($id) ? '添加分类' : '编辑分类')->formData($formData); } public function delete(int $id) { $make = app()->make(CommunityTopicRepository::class); if ( $make->getWhereCount(['category_id' => $id]) ) throw new ValidateException('该分类下存在数据'); $this->dao->delete($id); } public function getList(array $where, int $page, int $limit) { $query = $this->dao->getSearch($where)->order('sort DESC,category_id DESC'); $count = $query->count(); $list = $query->page($page, $limit)->select(); return compact('count','list'); } public function options() { $data = $this->dao->getSearch(['is_show' => 1])->order('sort DESC,category_id DESC') ->field('category_id as value,cate_name as label')->select(); if ($data) $res = $data->toArray(); return $res; } public function getApiList() { $res = $this->dao->getSearch(['is_show' => 1])->order('sort DESC') ->setOption('filed',[])->field('category_id,cate_name')->with(['children'])->order('sort DESC,category_id DESC')->select(); $list = []; if ($res) $list = $res->toArray(); // $hot = app()->make(CommunityTopicRepository::class)->getHotList(); // $data[] = [ // 'category_id' => 0, // "cate_name" => "推荐", // "children" => $hot['list'] // ]; // return array_merge($data,$list); return $list; } public function checkName($name, $id) { $this->dao->fieldExists(); $this->dao->getSearch(['cate_name' => $name]); if ($id) { $this->dao->getSearch(['cate_name' => $name])->where('categ'); } } public function clearCahe() { // CacheService::clearByTag(0, CacheService::TAG_TOPIC); } }