mambax7 / smartfaq

     * @param  bool            $as_object

     * @return array           array of <a href='psi_element://sfAnswer'>sfAnswer</a> objects

     */

    public function &getObjects(\CriteriaElement $criteria = null, $id_as_key = false, $as_object = true)

    {

        $ret   = [];

        $limit = $start = 0;

        $sql   = 'SELECT * FROM ' . $this->db->prefix('smartfaq_answers');

        if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) {

            $sql .= ' ' . $criteria->renderWhere();

            if ('' != $criteria->getSort()) {

                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();

            }

            $limit = $criteria->getLimit();

            $start = $criteria->getStart();

        }

        //echo "<br>" . $sql . "<br>";

        $result = $this->db->query($sql, $limit, $start);

        if (!$result) {

            return $ret;

        }

        while (false !== ($myrow = $this->db->fetchArray($result))) {

            $answer = new Smartfaq\Answer();

            $answer->assignVars($myrow);

            if (!$id_as_key) {

                $ret[] =& $answer;

            } else {

                $ret[$myrow['answerid']] = $answer;

            }

            unset($answer);

        }

        return $ret;

    }

    /**

     * retrieve 1 official answer (for now SmartFAQ only allow 1 official answer...)

     * @param  bool   $id_as_key use the categoryid as key for the array?

     * @return array  array of {@link XoopsFaq} objects

     */

    public function getObjects($criteria = null, $id_as_key = false)

    {

        $ret   = [];

        $limit = $start = 0;

        $sql   = 'SELECT * FROM ' . $this->db->prefix('smartfaq_categories');

        if (null !== $criteria && is_subclass_of($criteria, 'CriteriaElement')) {

            $sql .= ' ' . $criteria->renderWhere();

            if ('' != $criteria->getSort()) {

                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();

            }

            $limit = $criteria->getLimit();

            $start = $criteria->getStart();

        }

        //echo "<br>" . $sql . "<br>";

        $result = $this->db->query($sql, $limit, $start);

        if (!$result) {

            return $ret;

        }

        while (false !== ($myrow = $this->db->fetchArray($result))) {

            $category = new Smartfaq\Category();

            $category->assignVars($myrow);

            if (!$id_as_key) {

                $ret[] = $category;

            } else {

                $ret[$myrow['categoryid']] = $category;

            }

            unset($category);

        }

        return $ret;

    }

    /**

     * @param  int    $limit