Example #1
0
 function getCriteria()
 {
     $total_crit = array();
     $article_search = new Article($this->dbcon);
     if ($crit = $this->getData('sqlwhere')) {
         if ($bad_spot = strpos($crit, "or typeid")) {
             $crit = substr($crit, 0, $bad_spot) . ")";
         }
         $total_crit[] = $crit;
     }
     if ($id = $this->getData('class_id')) {
         #$total_crit[] = "class =".$id;
         $total_crit[] = $article_search->makeCriteriaClass($id);
     }
     if ($id = $this->getData('section_id')) {
         $section = new Section($this->dbcon, $id);
         $section_crit = $section->getDisplayCriteria();
         $crit = join(' AND ', $article_search->makeCriteria($section_crit));
         $total_crit[] = $crit;
     }
     if (empty($total_crit)) {
         return $article_search->makeCriteriaDisplayable();
     }
     return "( " . join(" " . $this->getCombineLogic() . " ", $total_crit) . " ) AND " . $article_search->makeCriteriaDisplayable();
 }
Example #2
0
 function _filter_by_date_allowed()
 {
     $dbcon = AMP_Registry::getDbcon();
     $article = new Article($dbcon);
     $criteria = "date >" . $dbcon->qstr(date('Y-m-d', time() - 60 * 60 * 24 * 365 * 2)) . " AND date <" . $dbcon->qstr(date('Y-m-d', time()));
     $criteria .= " AND " . $article->makeCriteriaDisplayable();
     $this->criteria = $criteria . $this->_base_criteria;
 }