diff options
Diffstat (limited to 'app/Models/EntryDAO.php')
| -rw-r--r-- | app/Models/EntryDAO.php | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/app/Models/EntryDAO.php b/app/Models/EntryDAO.php index 68746c380..fecf02cf8 100644 --- a/app/Models/EntryDAO.php +++ b/app/Models/EntryDAO.php @@ -917,6 +917,25 @@ SQL; $sub_search .= ') '; } + if ($filter->getCategoryIds() !== null) { + $sub_search .= 'AND ' . $alias . 'id_feed IN (SELECT f.id FROM `_feed` f WHERE f.category IN ('; + foreach ($filter->getCategoryIds() as $category_id) { + $sub_search .= '?,'; + $values[] = $category_id; + } + $sub_search = rtrim($sub_search, ','); + $sub_search .= ')) '; + } + if ($filter->getNotCategoryIds() !== null) { + $sub_search .= 'AND ' . $alias . 'id_feed NOT IN (SELECT f.id FROM `_feed` f WHERE f.category IN ('; + foreach ($filter->getNotCategoryIds() as $category_id) { + $sub_search .= '?,'; + $values[] = $category_id; + } + $sub_search = rtrim($sub_search, ','); + $sub_search .= ')) '; + } + if ($filter->getLabelIds() !== null) { if ($filter->getLabelIds() === '*') { $sub_search .= 'AND EXISTS (SELECT et.id_tag FROM `_entrytag` et WHERE et.id_entry = ' . $alias . 'id) '; |