123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230 |
- <?php
- namespace app\admin\controller\sys_manage;
- use app\admin\service\sys_manage\CategoryService;
- use app\admin\validate\sys_manage\CategoryValidate;
- use app\common\Tree;
- use app\controller\Curd;
- use app\model\SysCategory;
- use support\Request;
- use support\Response;
- class CategoryController extends Curd
- {
- public function __construct()
- {
- $this->model = new SysCategory();
- }
- public function index(Request $request)
- {
- [$where, $format, $limit, $field, $order] = $this->selectInput($request);
- $format = 'tree';
- $order = $request->get('order', 'desc');
- $field = $field ?? 'category_sort';
- $query = $this->doSelect($where, $field, $order);
- return $this->doFormat($query, $format, 1000);
- }
- /**
- * @Desc 分类列表
- * @Author Gorden
- * @Date 2024/2/22 11:28
- *
- * @param Request $request
- * @return \support\Response
- */
- public function categoryList(Request $request)
- {
- [$where, $format, $limit, $field, $order] = $this->selectInput($request);
- $format = 'tree';
- $order = $request->get('order', 'desc');
- $field = $field ?? 'category_sort';
- $where['category_status'] = 'ACTIVED';
- $query = $this->doSelect($where, $field, $order);
- return $this->doFormat($query, $format, 1000);
- }
- public function afterQuery($items){
- $categoryDatas = [];
- foreach($items as &$item){
- if (empty($item->category_super_path)){
- $item->category_super_path = '#'.$item['category_id'].'#';
- }
- $categorys = SysCategory::where('category_super_path','like',$item->category_super_path.'%')
- ->where('category_status','ACTIVED')
- ->paginate(1000)
- ->items();
- $categoryDatas = array_merge($categorys,$categoryDatas);
- }
- $items = array_merge($items,$categoryDatas);
- return $items;
- }
- protected function formatTree($items): Response
- {
- $format_items = [];
- foreach ($items as $item) {
- $format_items[] = [
- 'name' => $item->category_name,
- 'value' => (string)$item->category_id,
- 'id' => $item->id ?? $item->category_id,
- 'pid' => $item->pid ?? $item->category_super_id,
- 'category_id' => $item->category_id,
- 'category_name' => $item->category_name,
- 'category_super_id' => $item->category_super_id,
- 'category_status' => $item->category_status,
- 'category_classify' => $item->category_classify,
- 'category_type' => $item->category_type,
- 'category_icon' => $item->category_icon,
- 'category_images' => $item->category_images,
- 'category_url' => $item->category_url,
- 'category_page' => $item->category_page,
- 'category_sort' => $item->category_sort,
- 'category_groupby' => $item->category_groupby,
- 'category_remark' => $item->category_remark,
- 'category_extend_json' => $item->category_extend_json,
- 'category_addtimes' => $item->category_addtimes,
- ];
- }
- $tree = new Tree($format_items);
- return json_success('success', $tree->getTree());
- }
- public function goodsCategory(Request $request)
- {
- [$where, $format, $limit, $field, $order] = $this->selectInput($request);
- $format = 'tree';
- $order = $request->get('order', 'desc');
- $field = $field ?? 'category_sort';
- $where['category_status'] = 'ACTIVED';
- $where['category_super_id'] = ['in','31,154,5,181,30,70,42'];
- $query = $this->doSelect($where, $field, $order);
- return $this->doFormatForGoods($query, $format, 1000);
- // $model->orWhereIn('category_id', ['31','154','5','181','30','70','42']);
- }
- /**
- * 执行真正查询,并返回格式化数据
- * @param $query
- * @param $format
- * @param $limit
- * @return Response
- */
- protected function doFormatForGoods($query, $format, $limit): Response
- {
- $methods = [
- 'select' => 'formatSelect',
- 'tree' => 'formatTree',
- 'table_tree' => 'formatTableTree',
- 'normal' => 'formatNormal',
- ];
- $paginator = $query->paginate($limit);
- $total = $paginator->total();
- $items = $paginator->items();
- if (method_exists($this, "afterQuery")) {
- $items = call_user_func([$this, "afterQuery"], $items);
- }
- $super = SysCategory::whereIn('category_id', ['31','154','5','181','30','70','42']);
- $superPaginator = $super->paginate($limit);
- $superTotal = $superPaginator->total();
- $superItems = $superPaginator->items();
- $items = array_merge($items,$superItems);
- $total = $total + $superTotal;
- $format_function = $methods[$format] ?? 'formatNormal';
- return call_user_func([$this, $format_function], $items, $total);
- }
- /**
- * @Desc 分类详情
- * @Author Gorden
- * @Date 2024/2/22 11:37
- *
- * @param $id
- * @return \support\Response
- */
- public function categoryInfo($id)
- {
- return CategoryService::categoryInfo($id);
- }
- /**
- * @Desc 添加分类
- * @Author Gorden
- * @Date 2024/2/22 10:25
- *
- * @param Request $request
- * @return \support\Response
- */
- public function addCategory(Request $request)
- {
- $validate = new CategoryValidate();
- if (!$validate->scene('add')->check($request->post())) {
- return json_fail($validate->getError());
- }
- return CategoryService::insertCategory($request->post());
- }
- /**
- * @Desc 修改分类
- * @Author Gorden
- * @Date 2024/2/22 11:05
- *
- * @param $id
- * @param Request $request
- * @return \support\Response
- */
- public function updateCategory($id, Request $request)
- {
- $validate = new CategoryValidate();
- if (!$validate->scene('update')->check($request->post())) {
- return json_fail($validate->getError());
- }
- return CategoryService::updateCategory($id, $request->post());
- }
- /**
- * @Desc 修改分类状态
- * @Author Gorden
- * @Date 2024/2/22 11:49
- *
- * @param $id
- * @param Request $request
- * @return \support\Response
- */
- public function updateStatus($id, Request $request)
- {
- $validate = new CategoryValidate();
- if (!$validate->scene('update_status')->check($request->post())) {
- return json_fail($validate->getError());
- }
- return CategoryService::updateStatus($id, $request->post());
- }
- /**
- * @Desc 删除分类
- * @Author Gorden
- * @Date 2024/2/22 11:57
- *
- * @param $id
- * @return \support\Response
- */
- public function delCategory(Request $request)
- {
- return CategoryService::delCategory($request);
- }
- public function getCategoryTree(Request $request)
- {
- $category_id = $request->get('category_id');
- return CategoryService::getCategoryTree($category_id);
- }
- }
|