get() public method

public get ( $params )
Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
 /**
  * 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;
     }
 }