public function get()
{
//init variable
$app = JFactory::getApplication();
//get data
$catid = $app->input->get('id', 0, 'INT');
$limitstart = $app->input->get('limitstart', 0, 'INT');
$limit = $app->input->get('limit', 10, 'INT');
$cat_obj = new CategoriesModelCategories();
$jlist = new JModelList();
$config = JFactory::getConfig();
$old_limit = $config->get('list_limit');
$config->set('list_limit', 0);
//$jlist->setState('list.start', 0);
//$jlist->setState('list.limit', 10);
//print_r($config);die("in api");
$rows = $cat_obj->getItems();
$items = array();
//format data
$obj = new BlogappSimpleSchema();
foreach ($rows as $row) {
$items[] = $obj->mapCategory($row);
}
$config->set('list_limit', $old_limit);
$items = array_slice($items, $limitstart, $limit);
$this->plugin->setResponse($items);
}
public function getLatest()
{
// Get the dbo
$db = JFactory::getDbo();
$result = new stdClass();
// Get an instance of the generic articles model
$model = JModelLegacy::getInstance('Articles', 'ContentModel', array('ignore_request' => true));
$plugin = JPluginHelper::getPlugin('api', 'articles');
if ($plugin) {
$params = new JRegistry($plugin->params);
// Set application parameters in model
$app = JFactory::getApplication();
$appParams = $app->getParams();
$model->setState('params', $appParams);
// Set the filters based on the module params
$model->setState('list.start', 0);
$model->setState('list.limit', (int) $params->get('count', 5));
$model->setState('filter.published', 1);
// Access filter
$access = !JComponentHelper::getParams('com_content')->get('show_noauth');
$authorised = JAccess::getAuthorisedViewLevels(JFactory::getUser()->get('id'));
$model->setState('filter.access', $access);
// Category filter
$model->setState('filter.category_id', $params->get('catid', array()));
// User filter
$userId = JFactory::getUser()->get('id');
switch ($params->get('user_id')) {
case 'by_me':
$model->setState('filter.author_id', (int) $userId);
break;
case 'not_me':
$model->setState('filter.author_id', $userId);
$model->setState('filter.author_id.include', false);
break;
case '0':
break;
default:
$model->setState('filter.author_id', (int) $params->get('user_id'));
break;
}
// Filter by language
$model->setState('filter.language', $app->getLanguageFilter());
// Featured switch
switch ($params->get('show_featured')) {
case '1':
$model->setState('filter.featured', 'only');
break;
case '0':
$model->setState('filter.featured', 'hide');
break;
default:
$model->setState('filter.featured', 'show');
break;
}
// Set ordering
$order_map = array('m_dsc' => 'a.modified DESC, a.created', 'mc_dsc' => 'CASE WHEN (a.modified = ' . $db->quote($db->getNullDate()) . ') THEN a.created ELSE a.modified END', 'c_dsc' => 'a.created', 'p_dsc' => 'a.publish_up', 'random' => 'RAND()');
$ordering = JArrayHelper::getValue($order_map, $params->get('ordering'), 'a.publish_up');
$dir = 'DESC';
$model->setState('list.ordering', $ordering);
$model->setState('list.direction', $dir);
$items = $model->getItems();
//format data
$obj = new BlogappSimpleSchema();
foreach ($items as &$item) {
$item->slug = $item->id . ':' . $item->alias;
$item->catslug = $item->catid . ':' . $item->category_alias;
if ($access || in_array($item->access, $authorised)) {
// We know that user has the privilege to view the article
$item->link = JRoute::_(ContentHelperRoute::getArticleRoute($item->slug, $item->catid, $item->language));
} else {
$item->link = JRoute::_('index.php?option=com_users&view=login');
}
$item = $obj->mapPost($item, '', 100, array());
}
$result->success = 1;
$result->data = $items;
} else {
$result->success = 0;
$result->data = 0;
$result->message = "Plugin params not found please, install and save plugin params";
}
return $result;
}
public function get()
{
$result = new stdClass();
//$article_id = JRequest::getVar('id', 0, '', 'int');
$target_user = JRequest::getVar('target_user', 0, '', 'int');
$ordering = JRequest::getVar('ordering', 'c_dsc', '', 'string');
$catid = JRequest::getVar('catid', '0', '', 'int');
$secid = JRequest::getVar('section_id', '0', '', 'int');
$target_blogs = JRequest::getVar('my_blogs', '0', '', 'string');
$show_front = JRequest::getVar('show_front', '0', '', 'string');
$search = JRequest::getVar('search', '', '', 'string');
$limit = JRequest::getVar('limit', 20, '', 'int');
$limitstart = JRequest::getVar('limitstart', 0, '', 'int');
$db = JFactory::getDBO();
$log_user = $this->plugin->get('user')->id;
$user = JFactory::getUser($log_user);
/*if(!$article_id)
{
$result->success = 0;
$result->message = 'Please select article';
$this->plugin->setResponse($result);
return;
}*/
$contentConfig = JComponentHelper::getParams('com_content');
$access = !$contentConfig->get('show_noauth');
$nullDate = $db->getNullDate();
$date = JFactory::getDate();
$now = $date->toMySQL();
$where = 'a.state = 1' . ' AND ( a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' )' . ' AND ( a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )';
// User Filter
if ($target_blogs) {
switch ($target_blogs) {
case 'by_me':
$where .= ' AND (created_by = ' . (int) $user->id . ' OR modified_by = ' . (int) $user->id . ')';
break;
case 'not_me':
$where .= ' AND (created_by <> ' . (int) $user->id . ' AND modified_by <> ' . (int) $user->id . ')';
break;
}
}
//search data
if ($search) {
//$where .= "AND a.title LIKE '% " . $search . " %' OR a.text LIKE '% " . $search . " %')";
$where .= "AND a.title LIKE '% " . $search . " %' ";
}
// Ordering
switch ($ordering) {
case 'm_dsc':
$ordering = 'a.modified DESC, a.created DESC';
break;
case 'c_dsc':
default:
$ordering = 'a.created DESC';
break;
}
if ($catid) {
$ids = explode(',', $catid);
JArrayHelper::toInteger($ids);
$catCondition = ' AND (cc.id=' . implode(' OR cc.id=', $ids) . ')';
}
/*if ($secid)
{
$ids = explode( ',', $secid );
JArrayHelper::toInteger( $ids );
$secCondition = ' AND (s.id=' . implode( ' OR s.id=', $ids ) . ')';
}*/
// Content Items only
$query = 'SELECT a.*, ' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ($show_front == '0' ? ' LEFT JOIN #__content_frontpage AS f ON f.content_id = a.id' : '') . ' INNER JOIN #__categories AS cc ON cc.id = a.catid' . ' INNER JOIN #__sections AS s ON s.id = a.sectionid' . ' WHERE ' . $where . ' AND s.id > 0' . ($access ? ' AND a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid . ' AND s.access <= ' . (int) $aid : '') . ($catid ? $catCondition : '') . ($secid ? $secCondition : '') . ($show_front == '0' ? ' AND f.content_id IS NULL ' : '') . ' AND s.published = 1' . ' AND cc.published = 1' . ' ORDER BY ' . $ordering;
//echo $query;
if ($limit) {
$query = $query . " LIMIT " . $limitstart . "," . $limit;
}
echo $query;
$db->setQuery($query, 0, $count);
$rows = $db->loadObjectList();
/*$art_obj = new ContentModelArticle();
$art_obj->setId($article_id);
$a_data = $art_obj->getArticle();*/
//format data
$obj = new BlogappSimpleSchema();
$items = array();
foreach ($rows as $row) {
$items[] = $obj->mapPost($row, '', 100, array());
}
$this->plugin->setResponse($items);
}
public function post()
{
//init variable
$app = JFactory::getApplication();
$result = new stdClass();
$article_id = $app->input->get('id', 0, 'INT');
if (!$article_id) {
$result->success = 0;
$result->message = 'Please select article';
$this->plugin->setResponse($result);
return;
}
$art_obj = new ContentModelArticle();
$art_obj->setId($article_id);
$a_data = $art_obj->getArticle();
//format data
$obj = new BlogappSimpleSchema();
//$item = $obj->mapPost($a_data,'', 100, array('text'));
$item = $obj->mapPost($a_data, '', 100, array());
$this->plugin->setResponse($item);
}
