Frontend\Modules\Faq\Engine\Model::getMostRead PHP Метод

getMostRead() публичный статический Метод

Get all items in a category
public static getMostRead ( integer $limit ) : array
$limit integer
Результат array
    public static function getMostRead($limit)
    {
        $items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.*, m.url
             FROM faq_questions AS i
             INNER JOIN meta AS m ON i.meta_id = m.id
             WHERE i.num_views > 0 AND i.language = ? AND i.hidden = ?
             ORDER BY (i.num_usefull_yes + i.num_usefull_no) DESC
             LIMIT ?', array(LANGUAGE, 'N', (int) $limit));
        $link = FrontendNavigation::getURLForBlock('Faq', 'Detail');
        foreach ($items as &$item) {
            $item['full_url'] = $link . '/' . $item['url'];
        }
        return $items;
    }

Usage Example

Пример #1
0
 /**
  * Parse
  */
 private function parse()
 {
     $this->tpl->assign('widgetFaqMostRead', FrontendFaqModel::getMostRead($this->get('fork.settings')->get('Faq', 'most_read_num_items', 10)));
 }