src/Controller/Api/ProudctController.php line 102

Open in your IDE?
  1. <?php
  2. namespace App\Controller\Api;
  4. use App\Controller\Api\ApiController;
  5. use Symfony\Component\Routing\Annotation\Route;
  6. use App\Entity\Product;
  7. use App\Entity\ProductCategory;
  8. use App\Entity\UserProductStar;
  10. /**
  11.  * @Route("/api", name="api_")
  12.  * 
  13.  * @IgnoreAnnotation("api")
  14.  * @IgnoreAnnotation("apiName")
  15.  * @IgnoreAnnotation("apiGroup")
  16.  * @IgnoreAnnotation("apiVersion")
  17.  * @IgnoreAnnotation("apiParam")
  18.  * @IgnoreAnnotation("apiSuccessExample")
  19.  * @IgnoreAnnotation("apiErrorExample")
  20.  */
  21. class ProudctController extends ApiController
  22. {       
  23.     /**
  24.      * @Route("/home/category", name="categoryHome", options={"ignore"=true})
  25.      * 
  26.      * @api {post} /api/home/category 金刚区分类
  27.      * @apiName 金刚区分类
  28.      * @apiGroup product
  29.      * @apiVersion 1.0.0
  30.      * 
  31.      * 
  32.      * @apiSuccessExample {json} Success-Response:
  33.      *     HTTP/1.1 200 OK
  34.      *     {
  35.      *       "code": "0",
  36.      *       "message": "",
  37.      *       "result": 
  38.                 [{
  39.                     id: 分类id
  40.                     name: 名称
  41.                     image: 图片   
  42.                 },...]
  43.      * 
  44.      *     }
  45.      * 
  46.      * @apiErrorExample {json} Error-Response:
  47.      *     HTTP/1.1 200 
  48.      *     {
  49.      *       "code": "1",
  50.      *       "message": "",
  51.      *       "result": {}
  52.      *     }
  53.      */
  54.     public function category()
  55.     {    
  56.         $categorys = $this->entityManager->getRepository(ProductCategory::class)->createQueryBuilder('u')
  57.             ->select('u.id, u.name, u.image')
  58.             ->andWhere('u.level = 1 and u.isHome = 1')->getQuery()->getResult();
  59.         
  60.         foreach ($categorys as &$category) {
  61.             $category['image'] = $this->request->getSchemeAndHttpHost() . $category['image'];
  62.         }
  64.         return $this->json(['code'=>0, 'message'=>'success', 'result'=> $categorys]);
  65.     }
  67.     /**
  68.      * @Route("/home", name="home", options={"ignore"=true})
  69.      * 
  70.      * @api {post} /api/home 首页商品
  71.      * @apiName 首页商品
  72.      * @apiGroup product
  73.      * @apiVersion 1.0.0  
  74.      * 
  75.      * @apiParam {NUmber} [page]    分页 默认1
  76.      * @apiParam {NUmber} [rows]    每页条数 默认10个 
  77.      * 
  78.      * @apiSuccessExample {json} Success-Response:
  79.      *     HTTP/1.1 200 OK
  80.      *     {
  81.      *       "code": "0",
  82.      *       "message": "",
  83.      *       "result": 
  84.                 [{   
  85.                     id:           商品id
  86.                     oldPrice:     原始价格
  87.                     price:        当前价格                
  88.                     name:         商品名称
  89.                     image:        http://domain.com/图片
  90.                 }, ...]
  91.      * 
  92.      *     }
  93.      * 
  94.      * @apiErrorExample {json} Error-Response:
  95.      *     HTTP/1.1 200 
  96.      *     {
  97.      *       "code": "1",
  98.      *       "message": "",
  99.      *       "result": {}
  100.      *     }
  101.      */
  102.     public function home()
  103.     {    
  104.         $page = $this->request->request->get('page', 1);     
  105.         $rows = $this->request->request->get('rows', 10);
  107.         $queryBuilder = $this->entityManager->getRepository(Product::class)->createQueryBuilder('u')
  108.             ->select('u.id, u.name, u.price, u.oldPrice, u.image')
  109.             ->andWhere('u.isHome = 1 and u.isEnabled = 1');
  110.         
  111.         $pagination = $this->paginator->paginate($queryBuilder, $page, $rows); 
  112.         $products = $pagination->getItems();
  113.         
  114.         foreach ($products as &$product) {
  115.             $product['image'] = $this->request->getSchemeAndHttpHost() . $product['image'];
  116.         }
  118.         return $this->json(['code'=>0, 'message'=>'success', 'result'=> $products]);
  119.     }
  121.      /**
  122.      * @Route("/category", name="category", options={"ignore"=true})
  123.      * 
  124.      * @api {post} /api/category 分类
  125.      * @apiName 分类
  126.      * @apiGroup product
  127.      * @apiVersion 1.0.0
  128.      * 
  129.      * 
  130.      * @apiSuccessExample {json} Success-Response:
  131.      *     HTTP/1.1 200 OK
  132.         {
  133.         "code": 0,
  134.         "message": "success",
  135.         "result": [
  136.             {
  137.                 "id": 1,
  138.                 "image": "https://laiju.hbpt.xyz/uploads/category/6322cc61907a2.jpg",
  139.                 "name": "猪肉专区",
  140.                 "erji": [  //二级
  141.                     {
  142.                         "id": 4,
  143.                         "image": "https://laiju.hbpt.xyz/uploads/category/6322ccd6b5902.jpg",
  144.                         "name": "猪肉1"
  145.                     },
  146.                     {
  147.                         "id": 5,
  148.                         "image": "https://laiju.hbpt.xyz/uploads/category/6322cce9c3e79.jpg",
  149.                         "name": "猪肉2"
  150.                     }
  151.                 ]
  152.             },
  153.             {
  154.                 "id": 2,
  155.                 "image": "https://laiju.hbpt.xyz/uploads/category/6322cc8b78d64.jpg",
  156.                 "name": "牛肉专区",
  157.                 "erji": []
  158.             },
  159.             {
  160.                 "id": 3,
  161.                 "image": "https://laiju.hbpt.xyz/uploads/category/6322cc95b1da3.jpg",
  162.                 "name": "羊肉专区",
  163.                 "erji": []
  164.             }
  165.         ]
  166.     }
  167.      * 
  168.      * @apiErrorExample {json} Error-Response:
  169.      *     HTTP/1.1 200 
  170.      *     {
  171.      *       "code": "1",
  172.      *       "message": "",
  173.      *       "result": {}
  174.      *     }
  175.      */
  176.     public function categorys()
  177.     {           
  178.         //
  179.         $categorys = $this->entityManager->getRepository(ProductCategory::class)->createQueryBuilder('u')
  180.                 ->select('u.id, u.image, u.name')->andWhere('u.level = 1')
  181.                 ->getQuery()->getResult();
  183.         $queryBuilder = $this->entityManager->getRepository(ProductCategory::class)->createQueryBuilder('u')
  184.             ->select('u.id, u.image, u.name')->andWhere('u.parent = :category');
  185.         
  186.         foreach ($categorys as &$category) {
  187.             $category['image'] = $this->request->getSchemeAndHttpHost() . $category['image'];
  188.             $erji = $queryBuilder->setParameter('category', $category['id'])->getQuery()->getResult();
  189.             foreach ($erji as &$v) {
  190.                 $v['image'] = $this->request->getSchemeAndHttpHost() . $v['image'];                
  191.             }
  192.             $category['erji'] = $erji;
  193.         }      
  195.         return $this->json(['code'=>0, 'message'=>'success', 'result'=> $categorys]);
  196.     }
  198.     /**
  199.      * @Route("/category/erji", name="categoryerji", options={"ignore"=true})
  200.      * 
  201.      * @api {post} /api/category/erji 二级分类
  202.      * @apiName 二级分类
  203.      * @apiGroup product
  204.      * @apiVersion 1.0.0
  205.      * 
  206.      * @apiParam {String} category_id  一级分类id
  207.      * 
  208.      * @apiSuccessExample {json} Success-Response:
  209.      *     HTTP/1.1 200 OK
  210.         {
  211.             "code": 0,
  212.             "message": "success",
  213.             "result": [
  214.                 {
  215.                     "id": 4,
  216.                     "image": "https://laiju.hbpt.xyz/uploads/category/6322ccd6b5902.jpg",
  217.                     "name": "猪肉1"
  218.                 },
  219.                 {
  220.                     "id": 5,
  221.                     "image": "https://laiju.hbpt.xyz/uploads/category/6322cce9c3e79.jpg",
  222.                     "name": "猪肉2"
  223.                 }
  224.             ]
  225.         }
  226.      * 
  227.      * @apiErrorExample {json} Error-Response:
  228.      *     HTTP/1.1 200 
  229.      *     {
  230.      *       "code": "1",
  231.      *       "message": "",
  232.      *       "result": {}
  233.      *     }
  234.      */
  235.     public function categoryErji()
  236.     {    
  237.         
  238.         $category_id = $this->request->request->get('category_id');
  240.         if (!$category_id) return $this->json(['code'=>1, 'message'=>'参数不完整']);
  241.         $categorys = $this->entityManager->getRepository(ProductCategory::class)->createQueryBuilder('u')
  242.                 ->select('u.id, u.image, u.name')->andWhere('u.parent = :category')->setParameter('category', $category_id)
  243.                 ->getQuery()->getResult();
  244.         
  245.         foreach ($categorys as &$category) {
  246.             $category['image'] = $this->request->getSchemeAndHttpHost() . $category['image'];
  247.         }
  249.        
  250.         return $this->json(['code'=>0, 'message'=>'success', 'result'=> $categorys]);
  251.     }
  253.     /**
  254.      * @Route("/category/product", name="categoryProduct", options={"ignore"=true})
  255.      * 
  256.      * @api {post} /api/category/product 分类商品
  257.      * @apiName 分类商品
  258.      * @apiGroup product
  259.      * @apiVersion 1.0.0
  260.      * 
  261.      * @apiParam {String} [category_id]  分类id
  262.      * @apiParam {String} [price]   0从价格由低到高 1由高到低
  263.      * @apiParam {String} [sales]   销量     升序 0 或倒序 1
  264.      * @apiParam {String} [lastest] 最新     0从近到远 1从远到近
  265.      * @apiParam {NUmber} [page]    分页 默认1
  266.      * @apiParam {NUmber} [rows]    每页条数 默认10个
  267.      * 
  268.      * @apiSuccessExample {json} Success-Response:
  269.      *     HTTP/1.1 200 OK
  270.         {
  271.         "code": 0,
  272.         "message": "success",
  273.         "result": [
  274.             {
  275.                 "id": 3,
  276.                 "oldPrice": "400.00",
  277.                 "price": "300.00",
  278.                 "name": "土猪肉3",
  279.                 "image": "https://laiju.hbpt.xyz/uploads/product/6322d06d538ca.avif",
  280.                 "sales": 2999   //销量
  281.                 "comments": 10  //评论数
  282.             },
  283.             {
  284.                 "id": 2,
  285.                 "oldPrice": "300.00",
  286.                 "price": "200.00",
  287.                 "name": "土猪肉2",
  288.                 "image": "https://laiju.hbpt.xyz/uploads/product/6322cf4ddbe6e.avif",
  289.                 "sales": 2999   //销量
  290.                 "comments": 10  //评论数
  291.             },
  292.             {
  293.                 "id": 1,
  294.                 "oldPrice": "200.00",
  295.                 "price": "100.00",
  296.                 "name": "土猪肉",
  297.                 "image": "https://laiju.hbpt.xyz/uploads/product/6322cf18381b1.avif",
  298.                 "sales": 2999   //销量
  299.                 "comments": 10  //评论数
  300.             }
  301.         ]
  302.     }
  304.      * @apiErrorExample {json} Error-Response:
  305.      *     HTTP/1.1 200 
  306.      *     {
  307.      *       "code": "1",
  308.      *       "message": "",
  309.      *       "result": {}
  310.      *     }
  311.      */
  312.     public function categoryProduct()
  313.     {    
  314.         $page = $this->request->request->get('page', 1);     
  315.         $rows = $this->request->request->get('rows', 10);
  317.         $price = $this->request->request->get('price', '');  
  318.         $sales = $this->request->request->get('sales', '');
  319.         $lastest = $this->request->request->get('lastest', 0); //默认
  320.         $category_id = $this->request->request->get('category_id');
  322.         $queryBuilder = $this->entityManager->getRepository(Product::class)->createQueryBuilder('u')
  323.             ->leftJoin('u.category', 'c');
  324.         
  325.         if ($sales !== '') {
  326.             $queryBuilder->orderBy('u.sales', $sales == 1 ? 'desc' : 'asc');
  327.         }
  328.         if ($lastest !== '') {
  329.             $queryBuilder->orderBy('u.id', $lastest == 0 ? 'desc' : 'asc');
  330.         }
  331.         if ($price !== '') {
  332.             $queryBuilder->orderBy('u.price', $price == 0 ? 'asc' : 'desc');
  333.         }   
  335.         if (!$category_id) {
  336.             $queryBuilder->andWhere('u.isHome = 1');
  337.         } else {
  338.             $queryBuilder->andWhere('c.id = :category or c.parent = :category')->setParameter('category', $category_id);
  339.         }
  340.         
  342.         $total = $queryBuilder->select('count(u.id) as count')->getQuery()->getOneOrNullResult();
  343.         
  344.         $queryBuilder->select('u.id, u.oldPrice, u.price, u.name, u.image, u.sales');        
  345.         $pagination = $this->paginator->paginate($queryBuilder, $page, $rows); 
  346.         $products = $pagination->getItems();
  347.         
  348.         $qb = $this->entityManager->getRepository('App\Entity\FinanceTradeProductComment')->createQueryBuilder('u')
  349.             ->select('count(u.id) as count')->andWhere('u.product = :product');
  350.         foreach ($products as &$product) {
  351.             $product['image'] = $this->request->getSchemeAndHttpHost() . $product['image'];
  352.             //评论数
  353.             $comments = $qb->setParameter('product', $product['id'])->getQuery()->getOneOrNullResult();
  354.             $product['comments'] = $comments['count'] ?: 0;
  355.         }
  356.         
  358.         return $this->json(['code'=>0, 'message'=>'success', 'result'=> $products]);
  359.     }
  363.     /**
  364.      * @Route("/product/detail", name="auth_product_detail", options={"ignore"=true})
  365.      * 
  366.      * @api {post} /api/product/detail 商品详情
  367.      * @apiName 商品详情
  368.      * @apiGroup product
  369.      * @apiVersion 1.0.0
  370.      * 
  371.      * @apiParam {String} id        商品id
  372.      * 
  373.      * @apiSuccessExample {json} Success-Response:
  374.      *     HTTP/1.1 200 OK
  375.      *     {
  376.      *       "code": "0",
  377.      *       "message": "",
  378.      *       "result": {
  379.         id:             商品id
  380.         price:          当前价格    
  381.         shipping:       运费            
  382.         name:           商品名称
  383.         image:          http://domain.com/图片
  384.         imageList:      [http://domain.com/图片, http://domain.com/图片]  图片数组
  385.         stock:          库存
  386.         sales:          销量
  387.         content:        商品详情
  388.         comments:       评论条数
  389.         stars:          点赞数
  390.         star:           是否点赞 1是 0否
  391.         descript:       商品描述
  392.     }        
  393.      * 
  394.      *     }
  395.      * 
  396.      * @apiErrorExample {json} Error-Response:
  397.      *     HTTP/1.1 200 
  398.      *     {
  399.      *       "code": "1",
  400.      *       "message": "",
  401.      *       "result": {}
  402.      *     }
  403.      */
  404.     public function productDetail()
  405.     {
  406.         $id = $this->request->request->get('id');
  407.                
  408.         if (!$id) return $this->json(['code'=>1, 'message'=> 'id不能为空']);
  409.         $product = $this->entityManager->getRepository(Product::class)->createQueryBuilder('u')
  410.             ->select('u.id, u.price, u.shipping, u.name, u.image, u.stock, u.sales, u.content, u.imageList, u.descript')
  411.             ->andWhere('u.id = :id and u.isEnabled = 1 ')
  412.             ->setParameter('id', $id)
  413.             ->getQuery()->getOneOrNullResult();
  414.         if (!$product) return $this->json(['code'=>1, 'message'=>'商品信息不存在']);
  415.         
  416.         $product['image'] = $this->request->getSchemeAndHttpHost() . $product['image'];
  417.         foreach ($product['imageList'] as &$v) {
  418.             $v = $this->request->getSchemeAndHttpHost() . $v;
  419.         } 
  421.         $comments = $this->entityManager->getRepository('App\Entity\FinanceTradeProductComment')->createQueryBuilder('u')->select('count(u.id) as count')
  422.             ->andWhere('u.product = :id')->setParameter('id', $id)->getQuery()->getOneOrNullResult();
  423.         $product['comments'] = $comments['count'] ?: 0;
  424.         $stars = $this->entityManager->getRepository('App\Entity\UserProductStar')->createQueryBuilder('u')->select('count(u.id) as count')
  425.             ->andWhere('u.product = :id')->setParameter('id', $id)->getQuery()->getOneOrNullResult();
  426.         $product['stars'] = $stars['count'] ?: 0;
  428.         $productStar = $this->entityManager->getRepository('App\Entity\UserProductStar')->findOneBy(['user'=>$this->getUser(), 'product'=>$id]);
  429.         //var_dump($this->getUser());var_dump($id);
  430.         $product['star'] = $productStar ? 1 : 0;
  432.         $pattern = "/ style=\".*?\"/";
  433.         $replacement = "";
  434.         $product['content'] = preg_replace($pattern, $replacement, $product['content']); 
  435.         
  436.         $exp= ["/height=.{0,5}\s/i", "/width=.{0,5}\s/i"];
  437.         $exp_o= ['', ''];
  438.         $product['content'] = preg_replace($exp, $exp_o, $product['content']);
  440.         $product['content'] = str_replace('<img ', '<img style="width:100%" ', $product['content']);              
  441.         return $this->json(['code'=>0, 'message'=>'success', 'result'=> $product]);
  442.     }
  444.     /**
  445.      * @Route("/product/comment", name="product_comment", options={"ignore"=true})
  446.      * 
  447.      * @api {post} /api/product/comment 商品评价列表
  448.      * @apiName 商品评价列表
  449.      * @apiGroup product
  450.      * @apiVersion 1.0.0
  451.      * 
  452.      * @apiParam {String} id        商品id
  453.      * 
  454.      * @apiSuccessExample {json} Success-Response:
  455.      *     HTTP/1.1 200 OK
  456.      *     {
  457.      *       "code": "0",
  458.      *       "message": "",
  459.      *       "result": {
  460.             count: 1000 总评论数
  461.             comments: [{
  462.                 headimg:    用户头像
  463.                 nickname:   用户昵称
  464.                 star:       好评情况 1差评2中评3好评
  465.                 content:    评论内容
  466.                 images:     评论图片 数组
  467.             }, ...]      
  468.      }
  469.      * 
  470.      *     }
  471.      * 
  472.      * @apiErrorExample {json} Error-Response:
  473.      *     HTTP/1.1 200 
  474.      *     {
  475.      *       "code": "1",
  476.      *       "message": "",
  477.      *       "result": {}
  478.      *     }
  479.      */
  480.     public function productComment()
  481.     {
  482.         $id = $this->request->request->get('id');
  484.         if (!$id) return $this->json(['code'=>1, 'message'=> 'id不能为空']);
  485.         $queryBuilder = $this->entityManager->getRepository('App\Entity\FinanceTradeProductComment')->createQueryBuilder('u')
  486.             ->leftJoin('u.comment', 'c')->leftJoin('u.user', 'uu')
  487.             ->andWhere('u.product = :id')
  488.             ->setParameter('id', $id);
  490.         $count = $queryBuilder->select('count(u.id) as count')->getQuery()->getOneOrNullResult();
  491.         $comments = $queryBuilder->select('uu.nickname, uu.inviteCode, uu.headimg, c.star, c.content, c.images')
  492.             ->getQuery()->getResult();        
  493.         
  494.         foreach ($comments as &$item) {
  495.             foreach ($item['images'] as $k => $image) {
  496.                 $items[$k] = $this->request->getSchemeAndHttpHost() . $image;
  497.             }
  498.         } 
  499.         return $this->json(['code'=>0, 'message'=>'success', 'result'=> [
  500.             'count' => $count['count'] ?: 0,
  501.             'comments' => $comments,
  502.         ]]);
  503.     }
  505.     /**
  506.      * @Route("/product/star", name="auth_productstar", options={"ignore"=true})
  507.      * 
  508.      * @api {post} /api/product/star 商品点赞
  509.      * @apiName 商品点赞
  510.      * @apiGroup product
  511.      * @apiVersion 1.0.0
  512.      * 
  513.      * @apiParam {String} id        商品id
  514.      * @apiParam {String} star      1是点赞 0是取消
  515.      * 
  516.      * @apiSuccessExample {json} Success-Response:
  517.      *     HTTP/1.1 200 OK
  518.      *     {
  519.      *       "code": "0",
  520.      *       "message": "",
  521.      *       "result": {  
  522.                 star: 1 已点赞  0已取消
  523.      }
  524.      * 
  525.      *     }
  526.      * 
  527.      * @apiErrorExample {json} Error-Response:
  528.      *     HTTP/1.1 200 
  529.      *     {
  530.      *       "code": "1",
  531.      *       "message": "",
  532.      *       "result": {}
  533.      *     }
  534.      */
  535.     public function star()
  536.     {        
  537.         $id = $this->request->request->get('id');
  538.         $star = $this->request->request->get('star', 0);
  540.         if (!$id) return $this->json(['code'=>1, 'message'=> 'id不能为空']);
  541.         $product = $this->entityManager->getRepository(Product::class)->find($id);
  542.         if (!$product) return $this->json(['code'=>1, 'message'=> 'id不能为空']);
  543.         $productStar = $this->entityManager->getRepository('App\Entity\UserProductStar')->findOneBy(['user'=>$this->getUser(), 'product'=>$product]);
  544.         if ($star == 0 && $productStar) {
  545.             $this->entityManager->remove($productStar);
  546.             $this->entityManager->flush();
  547.         } 
  549.         if ($star == 1 && !$productStar) {
  550.             $productStar = new UserProductStar();
  551.             $productStar->setUser($this->getUser());
  552.             $productStar->setProduct($product);
  554.             $this->entityManager->persist($productStar);
  555.             $this->entityManager->flush();
  556.         } 
  557.         
  558.         return $this->json(['code'=>0, 'message'=>'success', 'result'=>[
  559.             'star' => $star
  560.         ]]);
  561.     }
  563. }