Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. use MagentoFrameworkApiFilterBuilder;
  2. use MagentoFrameworkApiSearchFilterGroupBuilder;
  3. use MagentoFrameworkApiSearchCriteriaBuilder;
  4. use MagentoCmsModelBlockRepository;
  5.  
  6. /**
  7. * @var FilterBuilder
  8. */
  9. private $filterBuilder;
  10.  
  11. /**
  12. * @var FilterGroupBuilder
  13. */
  14. private $filterGroupBuilder;
  15.  
  16. /**
  17. * @var SearchCriteriaBuilder
  18. */
  19. private $searchCriteriaBuilder;
  20.  
  21. /**
  22. * @var BlockRepository
  23. */
  24. private $blockRepository;
  25.  
  26. public function __construct(
  27. FilterBuilder $filterBuilder,
  28. FilterGroupBuilder $filterGroupBuilder,
  29. SearchCriteriaBuilder $searchCriteriaBuilder,
  30. BlockRepository $blockRepository
  31. ) {
  32. $this->filterBuilder = $filterBuilder;
  33. $this->filterGroupBuilder = $filterGroupBuilder;
  34. $this->searchCriteriaBuilder = $searchCriteriaBuilder;
  35. $this->blockRepository = $blockRepository;
  36.  
  37. }
  38.  
  39. $filter = $this->filterBuilder->setField('identifier')
  40. ->setConditionType('eq')
  41. ->setValue('men-block')
  42. ->create();
  43.  
  44. $filter2 = $this->filterBuilder->setField('identifier')
  45. ->setConditionType('eq')
  46. ->setValue('gear-block')
  47. ->create();
  48.  
  49. $filterGroup = $this->filterGroupBuilder->setFilters([$filter, $filter2])
  50. ->create();
  51.  
  52. $filter3 = $this->filterBuilder->setField('is_active')
  53. ->setConditionType('eq')
  54. ->setValue(1)
  55. ->create();
  56.  
  57. $filterGroup2 = $this->filterGroupBuilder->setFilters([$filter3])
  58. ->create();
  59.  
  60. $searchCriteria = $this->searchCriteriaBuilder->setFilterGroups([$filterGroup, $filterGroup2])
  61. ->create();
  62. $blockItems = $this->blockRepository->getList($searchCriteria)->getItems();
  63.  
  64. SELECT `main_table`.* FROM `cms_block` AS `main_table` WHERE ((`identifier` = 'men-block') OR (`identifier` = 'gear-block')) AND ((`is_active` = 1))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement