/**
* It gives the rss feed of contents of given ids.
*
* @param $content_id array The content ids of the contents for getting RssFeed
* @return $generated_rss_feed string This string contains the content of RssFeed file
*/
public static function get_feed_for_content($content_ids)
{
Logger::log("Enter: Content::get_feed_for_content()");
$sql = "SELECT * FROM {contents} WHERE content_id IN (" . $content_ids[0];
for ($i = 1; $i < count($content_ids); $i++) {
$sql .= ", " . $content_ids[$i];
}
$sql .= ")";
$data = array();
$res = Dal::query($sql, $data);
$new_rss = new RssFeedHelper();
$generated_rss_feed = $new_rss->get_rss_feed($res);
Logger::log("Exit: Content::get_feed_for_content()");
return $generated_rss_feed;
}
/**
* Add a new item to rss_helper object.
*
* @param $content_collection_id string The id of the content collection for which Rssfeed is Generated
* @param $no_of_items string The No of latest items for which Rssfeed is Generated
* @return $generated_rss_feed string This string contains the content of RssFeed file
*/
public static function get_feed_for_content_collection($collection_id, $no_of_items = 10)
{
Logger::log("Enter: ContentCollection::get__feed_for_content_collection()");
if (!$collection_id) {
Logger::log(" Throwing exception REQUIRED_PARAMETERS_MISSING | Message: Required variable not specified", LOGGER_ERROR);
throw new PAException(REQUIRED_PARAMETERS_MISSING, "Required variable not specified");
}
//Query for selecting all items from table cotents for generation of RssFeed
$sql = 'SELECT C.content_id AS content_id, C.author_id AS author_id, C.type AS type, C.body AS body, C.created AS created, C.changed AS changed, C.collection_id AS ccid FROM {contents} AS C WHERE C.collection_id = ? ORDER BY C.created DESC LIMIT ?';
$data = array($collection_id, $no_of_items);
$res = Dal::query($sql, $data);
// Collecting all $no_of_items rows in an array $row
while ($row[] = $res->fetchRow(DB_FETCHMODE_OBJECT)) {
}
$new_rss = new RssFeedHelper();
$generated_rss_feed = $new_rss->generate_rss($row);
Logger::log("Exit: ContentCollection::get__feed_for_content_collection()");
return $generated_rss_feed;
}
/**
* This method is called by all rss feed generator method (common to all methods) using generate_rss method
*
* @param $res string The user id of the user for getting RssFeed of the content. FIXME: from the code, it looks like this has to be a DB result object (returned from Dal::query).
* @return $result string This string contains the content of RssFeed file
*/
public function get_rss_feed($res, $user_id = 0)
{
// Collecting all $no_of_items rows in an array $row
while ($row[] = $res->fetchRow(DB_FETCHMODE_OBJECT)) {
}
$result = RssFeedHelper::generate_rss($row, (int) $user_id);
return $result;
}
/**
* get rss feed of blogs for a user.
*
* @param $user_id string The user id of the user for getting RssFeed of the blogpost
* @param $no_of_items string The No of latest items for which Rssfeed is Generated
* @return $generated_rss_feed string This string contains the content of RssFeed file
*/
public static function get_feed_for_user($user_id, $no_of_items = 10)
{
global $TB_CONTENTS;
Logger::log("Enter: BlogPost::get_feed_for_user()");
// Check if user id given
if (!$user_id) {
Logger::log(" Throwing exception REQUIRED_PARAMETERS_MISSING | Message: Required variable not specified", LOGGER_ERROR);
throw new PAException(REQUIRED_PARAMETERS_MISSING, "Required variable not specified");
}
//Query for selecting all title, description from table cotents for generation of RssFeed
$sql = "SELECT * FROM {contents} WHERE author_id = ? AND type = 1 AND is_active = 1 ORDER BY changed DESC LIMIT ?";
$data = array($user_id, $no_of_items);
$res = Dal::query($sql, $data);
$new_rss = new RssFeedHelper();
$generated_rss_feed = $new_rss->get_rss_feed($res, $user_id);
Logger::log("Exit: BlogPost::get_feed_for_user()");
return $generated_rss_feed;
}
