Skip to content

Instantly share code, notes, and snippets.

@nicolasbinet
Last active June 14, 2017 19:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nicolasbinet/7e3835b13c3e9c21d2fa754243242b41 to your computer and use it in GitHub Desktop.
Save nicolasbinet/7e3835b13c3e9c21d2fa754243242b41 to your computer and use it in GitHub Desktop.
$query = craft()->elements->buildElementsQuery();
// First day of month included between agendaStartDate & agendaEndDate
$query->andWhere(
'(content.field_agendaStartDate <= :firstDayOfMonth AND content.field_agendaEndDate >= :firstDayOfMonth)
OR
(content.field_agendaStartDate <= :lastDayOfMonth AND content.field_agendaEndDate >= :lastDayOfMonth)
OR
(content.field_agendaStartDate >= :firstDayOfMonth AND content.field_agendaEndDate <= :lastDayOfMonth)',
[':firstDayOfMonth' => $firstDayOfMonth, ':lastDayOfMonth' => $lastDayOfMonth]
);
$entries = EntryModel::populateModels($query->queryAll());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment