src/Repository/CategoryProductModelRepository.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 CategoryProductModelRepository extends EntityRepository
  9. {
  11. public function searchProducts($query = '', $category, $filters=[],$sort=[],$page=1,$limit=25)
  12. {
  13. $q = $this->createQueryBuilder('cp')
  14. ->innerJoin('cp.model','p')
  15. ->where('cp.category = :category')
  16. ->setParameter('category', $category);
  17. if(!empty($query)){
  18. if(ctype_digit($query)){
  19. $q->andWhere(
  20. $q->expr()->eq('p.id',$query)
  21. );
  22. }else{
  23. $q->andWhere(
  24. 'p.model LIKE \'%'.$query.'%\''
  25. );
  26. }
  27. }
  28. if(empty($sort)){
  29. $q->orderBy('p.id', 'desc');
  30. }
  31. $q->setMaxResults($limit);
  32. $q->setFirstResult(($page-1)*$limit);
  33. $q = $q->getQuery();
  34. $products = [];
  35. $cps = $q->getResult();
  36. foreach($cps as $cp){
  37. $products[] = $cp->getProduct();
  38. }
  39. return $products;
  40. }
  42. public function searchProductsCount($query = '', $category, $filters=[])
  43. {
  44. $q = $this->createQueryBuilder('cp')
  45. ->select('count(p.id)')
  46. ->innerJoin('cp.model','p')
  47. ->where('cp.category = :category')
  48. ->setParameter('category', $category);
  49. if(!empty($query)){
  50. if(ctype_digit($query)){
  51. $q->andWhere(
  52. $q->expr()->eq('p.id',$query)
  53. );
  54. }else{
  55. $q->andWhere(
  56. 'p.model LIKE \'%'.$query.'%\''
  57. );
  58. }
  59. }
  60. $q = $q->getQuery();
  61. return $q->getSingleScalarResult();
  62. }
  64. public function getCategoriesByProduct(\App\Entity\ProductModel $product, $onlyActive=false, $limit=null, $page=1){
  65. $q = $this->createQueryBuilder('cp')
  66. ->join('cp.model', 'p')
  67. ->where('cp.model = :product')
  68. ->setParameter('product', $product);
  69. if($onlyActive){
  70. $q->andWhere('p.active = 1');
  71. }
  72. if($limit){
  73. $q->setMaxResults($limit);
  74. $q->setFirstResult(($page-1)*$limit);
  75. }
  76. $q = $q->getQuery();
  77. $results = $q->getResult();
  78. // dump($results);
  79. $output = [];
  80. foreach($results as $result){
  81. $output[] = $result->getCategory();
  82. }
  83. return $output;
  84. }
  86. public function getProductModelsByCategory(\App\Entity\Category $category, $onlyActive=false, $limit=null, $page=1, $sort = 'new', $filters = [], $excludes = []){
  87. $q = $this->createQueryBuilder('cp')
  88. ->where('cp.category = :category')
  89. ->innerJoin('cp.model','p')
  90. ->setParameter('category', $category);
  91. if($onlyActive){
  92. $q->andWhere('p.status = 1');
  93. }
  94. if($limit){
  95. $q->setMaxResults($limit);
  96. $q->setFirstResult(($page-1)*$limit);
  97. }
  98. if($excludes){
  99. $q->andWhere('cp.product not in (:excludes)');
  100. $q->setParameter('excludes', $excludes);
  101. }
  102. $q = $q->getQuery();
  103. $results = $q->getResult();
  104. // dump($results);
  105. $output = [];
  106. foreach($results as $result){
  107. $output[] = $result->getProduct();
  108. }
  109. return $output;
  110. }
  112. public function getProductModelCountByCategory(\App\Entity\Category $category, $onlyActive=false){
  113. $q = $this->createQueryBuilder('cp')
  114. ->select('count(cp.product)')
  115. ->innerJoin('cp.product','p')
  116. ->where('cp.category = :category')
  117. ->setParameter('category', $category);
  118. if($onlyActive){
  119. $q->andWhere('p.status = 1');
  120. }
  121. $q = $q->getQuery();
  122. return $q->getSingleScalarResult();
  123. }
  125. }