src/Repository/CategoryProductRepository.php line 11

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Category;
  6. use Doctrine\ORM\EntityRepository;
  8. class CategoryProductRepository extends EntityRepository
  9. {
  11. public function searchProducts($query = '', $category, $filters=[],$sort=[],$page=1,$limit=25)
  12. {
  13. $q = $this->createQueryBuilder('cp')
  14. ->innerJoin('cp.product','p')
  15. ->where('cp.category = :category')
  16. // ->andWhere('p.parent IS NULL')
  17. ->setParameter('category', $category);
  18. if(!empty($query)){
  19. if(ctype_digit($query)){
  20. $q->andWhere(
  21. $q->expr()->eq('p.id',$query)
  22. );
  23. }else{
  24. $q->andWhere(
  25. 'p.model LIKE \'%'.$query.'%\''
  26. );
  27. }
  28. }
  29. if(empty($sort)){
  30. $q->orderBy('p.id', 'desc');
  31. }else{
  32. // foreach($sort as $s){
  33. // $q->addOrderBy('p.'.$s->property, $s->direction);
  34. // }
  35. }
  36. $q->setMaxResults($limit);
  37. $q->setFirstResult(($page-1)*$limit);
  38. $q = $q->getQuery();
  39. $products = [];
  40. $cps = $q->getResult();
  41. foreach($cps as $cp){
  42. $products[] = $cp->getProduct();
  43. }
  44. return $products;
  45. }
  47. public function searchProductsCount($query = '', $category, $filters=[])
  48. {
  49. $q = $this->createQueryBuilder('cp')
  50. ->select('count(p.id)')
  51. ->innerJoin('cp.product','p')
  52. ->where('cp.category = :category')
  53. // ->andWhere('p.parent IS NULL')
  54. ->setParameter('category', $category);
  55. if(!empty($query)){
  56. if(ctype_digit($query)){
  57. $q->andWhere(
  58. $q->expr()->eq('p.id',$query)
  59. );
  60. }else{
  61. $q->andWhere(
  62. 'p.model LIKE \'%'.$query.'%\''
  63. );
  64. }
  65. }
  66. $q = $q->getQuery();
  67. return $q->getSingleScalarResult();
  68. }
  70. public function getCategoriesByProduct(\App\Entity\Product $product, $onlyActive=false, $limit=null, $page=1){
  71. $q = $this->createQueryBuilder('cp')
  72. ->join('cp.product', 'p')
  73. ->where('cp.product = :product')
  74. ->setParameter('product', $product);
  75. if($onlyActive){
  76. $q->andWhere('p.active = 1');
  77. }
  78. if($limit){
  79. $q->setMaxResults($limit);
  80. $q->setFirstResult(($page-1)*$limit);
  81. }
  82. $q = $q->getQuery();
  83. $results = $q->getResult();
  84. // dump($results);
  85. $output = [];
  86. foreach($results as $result){
  87. $output[] = $result->getCategory();
  88. }
  89. return $output;
  90. }
  92. public function getProductsByCategory(\App\Entity\Category $category, $onlyActive=false, $limit=null, $page=1, $sort = 'new', $filters = [], $excludes = []){
  93. $q = $this->createQueryBuilder('cp')
  94. ->where('cp.category = :category')
  95. ->innerJoin('cp.product','p')
  96. ->setParameter('category', $category);
  97. if($onlyActive){
  98. $q->andWhere('p.status = 1');
  99. }
  100. if($limit){
  101. $q->setMaxResults($limit);
  102. $q->setFirstResult(($page-1)*$limit);
  103. }
  104. if($excludes){
  105. $q->andWhere('cp.product not in (:excludes)');
  106. $q->setParameter('excludes', $excludes);
  107. }
  108. $q = $q->getQuery();
  109. $results = $q->getResult();
  110. // dump($results);
  111. $output = [];
  112. foreach($results as $result){
  113. $output[] = $result->getProduct();
  114. }
  115. return $output;
  116. }
  118. public function getProductCountByCategory(\App\Entity\Category $category, $onlyActive=false){
  119. $q = $this->createQueryBuilder('cp')
  120. ->select('count(cp.product)')
  121. ->innerJoin('cp.product','p')
  122. ->where('cp.category = :category')
  123. ->setParameter('category', $category);
  124. if($onlyActive){
  125. $q->andWhere('p.status = 1');
  126. }
  127. $q = $q->getQuery();
  128. return $q->getSingleScalarResult();
  129. }
  131. }