/** * Returns array of Inquiry records that comprise the RSS feed * for this Project. * * @param integer $limit (optional) default is 100 * @return unknown */ public function get_inquiries_in_rss_feed($limit = 100) { // make sure we have an integer if (!isset($limit)) { $limit = 100; } $q = Inquiry::get_base_query_for_published(); $q->innerJoin('i.ProjectInquiry pi'); $q->innerJoin('pi.Project p'); $q->andWhereIn('pi.pinq_status', array('A')); $q->andWhere('i.inq_rss_status = ?', 'Y'); $q->andWhere('p.prj_id = ?', $this->prj_id); if ($limit) { $q->limit($limit); } $q->orderBy('i.inq_publish_dtim desc'); return $q->execute(); }
/** * Returns array of Inquiry records that comprise the RSS feed * for this Organization. * * @param integer $limit (optional) default is 100 * @param unknown $ignore_src_id (optional) * @param unknown $class (optional) * @return array $inquiries */ public function get_inquiries_in_rss_feed($limit = 100, $ignore_src_id = null, $class = 'Inquiry') { // make sure we have an integer if (!isset($limit)) { $limit = 100; } $q = Inquiry::get_base_query_for_published($class); $q->innerJoin('i.InqOrg io'); $q->andWhereIn('io.iorg_status', array('A')); $q->andWhere('i.inq_rss_status = ?', 'Y'); $q->andWhere('io.iorg_org_id = ?', $this->org_id); if ($ignore_src_id) { $q->andWhere("i.inq_id not in (select srs_inq_id from src_response_set where srs_src_id = ?)", $ignore_src_id); } if ($limit) { $q->limit($limit); } $q->orderBy('i.inq_publish_dtim desc'); return $q->execute(); }