Guest User

Untitled

a guest
May 25th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. // get all possible element ids
  2. $sectionId = X;
  3. $query = (new Query())
  4. ->select('elements.id')
  5. ->from('{{%elements}}')
  6. ->leftJoin('{{%elements_sites}}', 'elements_sites.elementId = elements.id')
  7. ->leftJoin('{{%entries}}', 'entries.id = elements.id')
  8. ->where(new OrCondition([
  9. ['=', 'entries.sectionId', $sectionId], <-- your section Id
  10. ['is', 'entries.sectionId', null],
  11. ]))
  12. ->andWhere(new OrCondition([
  13. ['=', 'elements.type', craftelementsEntry::class],
  14. ['=', 'elements.type', YourCalenderClassComesHere],
  15. ]))
  16. ->andWhere(['elements_sites.siteId' => 1])
  17. ->limit(10)
  18. ->offset(0)
  19. ->column();
  20.  
  21. // populate entry by Id
  22. foreach ($query as $elementId){
  23. $element = Craft::$app->getElements()->getElementById($elementId);
  24. }
Add Comment
Please, Sign In to add comment