public function get($data = false)
{
if (is_string($data)) {
$data = parse_params($data);
}
if (!is_array($data)) {
$data = array();
}
$get = parent::get($data);
if (!empty($get)) {
foreach ($get as $k => $data) {
if (isset($data['attribute_value']) and isset($data['attribute_type']) and $data['attribute_type'] == 'array') {
$data['attribute_value'] = json_decode($data['attribute_value'], true);
$get[$k] = $data;
}
}
}
return $get;
}
/**
* Get array of content items from the database.
*
* It accepts string or array as parameters. You can pass any db field name as parameter to filter content by it.
* All parameter are passed to the get() function
*
* You can get and filter content and also order the results by criteria
*
* @function get_content
*
*
* @desc Get array of content items from the content DB table
*
* @uses get() You can use all the options of get(), such as limit, order_by, count, etc...
*
* @param mixed|array|bool|string $params You can pass parameters as string or as array
* @params
*
* *Some parameters you can use*
* You can use all defined database fields as parameters
*
* .[params-table]
*|-----------------------------------------------------------------------------
*| Field Name | Description | Values
*|------------------------------------------------------------------------------
*| id | the id of the content |
*| is_active | published or unpublished | "y" or "n"
*| parent | get content with parent | any id or 0
*| created_by | get by author id | any user id
*| created_at | the date of creation |
*| updated_at | the date of last edit |
*| content_type | the type of the content | "page" or "post", anything custom
*| subtype | subtype of the content | "static","dynamic","post","product", anything custom
*| url | the link to the content |
*| title | Title of the content |
*| content | The html content saved in the database |
*| description | Description used for the content list |
*| position | The order position |
*| active_site_template | Current template for the content |
*| layout_file | Current layout from the template directory |
*| is_deleted | flag for deleted content | "n" or "y"
*| is_home | flag for homepage | "n" or "y"
*| is_shop | flag for shop page | "n" or "y"
*
* @return array|bool|mixed Array of content or false if nothing is found
*
* @example
* #### Get with parameters as array
* <code>
*
* $params = array();
* $params['is_active'] = 1; //get only active content
* $params['parent'] = 2; //get by parent id
* $params['created_by'] = 1; //get by author id
* $params['content_type'] = 'post'; //get by content type
* $params['subtype'] = 'product'; //get by subtype
* $params['title'] = 'my title'; //get by title
*
* $data = $this->get($params);
* var_dump($data);
*
* </code>
* @example
* #### Get by params as string
* <code>
* $data = $this->get('is_active=1');
* var_dump($data);
* </code>
* @example
* #### Ordering and sorting
* <code>
* //Order by position
* $data = $this->get('content_type=post&is_active=1&order_by=position desc');
* var_dump($data);
*
* //Order by date
* $data = $this->get('content_type=post&is_active=1&order_by=updated_at desc');
* var_dump($data);
*
* //Order by title
* $data = $this->get('content_type=post&is_active=1&order_by=title asc');
* var_dump($data);
*
* //Get content from last week
* $data = $this->get('created_at=[mt]-1 week&is_active=1&order_by=title asc');
* var_dump($data);
* </code>
*/
public function get($params = false)
{
$params2 = array();
if (is_string($params)) {
$params = parse_str($params, $params2);
$params = $params2;
}
if (!is_array($params)) {
$params = array();
$params['is_active'] = 1;
}
$cache_group = 'content/global';
if (isset($params['cache_group'])) {
$cache_group = $params['cache_group'];
}
$table = $this->tables['content'];
if (!isset($params['is_deleted'])) {
$params['is_deleted'] = 0;
}
$params['table'] = $table;
$params['cache_group'] = $cache_group;
if (isset($params['id'])) {
$params['id'] = intval($params['id']);
}
if (isset($params['search_by_keyword'])) {
$params['keyword'] = $params['search_by_keyword'];
}
if (isset($params['category']) and is_numeric($params['category'])) {
$params['category'] = intval($params['category']);
//check if this is dynamic category
$cat_id = $params['category'];
$category = $this->app->category_manager->get_by_id($cat_id);
if (is_array($category) and isset($category['category_subtype']) and $category['category_subtype'] == 'content_filter' and isset($category['category_subtype_settings']) and isset($category['category_subtype_settings']['filter_content_by_keywords']) and trim($category['category_subtype_settings']['filter_content_by_keywords']) != '') {
$params['keyword'] = $category['category_subtype_settings']['filter_content_by_keywords'];
}
}
if (isset($params['keyword']) and !isset($params['search_in_fields'])) {
$params['search_in_fields'] = array('title', 'content_body', 'content', 'description', 'content_meta_keywords', 'content_meta_title', 'url');
}
if (isset($params['keyword'])) {
if (!is_admin()) {
$params['is_deleted'] = 0;
$params['is_active'] = 1;
}
}
$get = parent::get($params);
if (isset($params['count']) or isset($params['single']) or isset($params['one']) or isset($params['data-count']) or isset($params['page_count']) or isset($params['data-page-count'])) {
if (isset($get['url'])) {
$get['full_url'] = $this->app->url_manager->site($get['url']);
}
return $get;
}
if (is_array($get)) {
$data2 = array();
foreach ($get as $item) {
if (isset($item['url'])) {
$item['url'] = $this->app->url_manager->site($item['url']);
}
$data2[] = $item;
}
$get = $data2;
return $get;
}
}