/**
* 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();
}
