Frontend\Modules\Faq\Engine\Model::getFaqsForCategory PHP Method

getFaqsForCategory() public static method

Get the all questions for selected category
public static getFaqsForCategory ( integer $id ) : array
$id integer
return array
    public static function getFaqsForCategory($id)
    {
        $items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.id, i.category_id, i.question, i.hidden, i.sequence, m.url
             FROM faq_questions AS i
             INNER JOIN meta AS m ON i.meta_id = m.id
             WHERE i.language = ? AND i.category_id = ?
             ORDER BY i.sequence ASC', array(LANGUAGE, (int) $id));
        $link = FrontendNavigation::getURLForBlock('Faq', 'Detail');
        foreach ($items as &$item) {
            $item['full_url'] = $link . '/' . $item['url'];
        }
        return $items;
    }