chamilo / chamilo-lms

     * Get question count per exercise from DB (any special treatment)

     * @return int

     */

    public function getQuestionCount()

    {

        $TBL_EXERCICE_QUESTION = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);

        $TBL_QUESTIONS = Database::get_course_table(TABLE_QUIZ_QUESTION);

        $sql = "SELECT count(q.id) as count

                FROM $TBL_EXERCICE_QUESTION e 

                INNER JOIN $TBL_QUESTIONS q

                ON (e.question_id = q.id AND e.c_id = q.c_id)

                WHERE 

                    e.c_id = {$this->course_id} AND 

                    e.exercice_id	= ".Database::escape_string($this->id);

        $result = Database::query($sql);

        $count = 0;

        if (Database::num_rows($result)) {

            $row = Database::fetch_array($result);

            $count = $row['count'];

        }

        return $count;

    }

    /**

     * @return array

     */

    public function getQuestionOrderedListByName()

    {

        $TBL_EXERCICE_QUESTION = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);

        $TBL_QUESTIONS = Database::get_course_table(TABLE_QUIZ_QUESTION);

        // Getting question list from the order (question list drag n drop interface ).

        $sql = "SELECT e.question_id

                FROM $TBL_EXERCICE_QUESTION e 

                INNER JOIN $TBL_QUESTIONS q

                ON (e.question_id= q.id AND e.c_id = q.c_id)

                WHERE 

                    e.c_id = {$this->course_id} AND 

                    e.exercice_id = '".Database::escape_string($this->id)."'

                ORDER BY q.question";

        $result = Database::query($sql);

        $list = array();

        if (Database::num_rows($result)) {

            $list = Database::store_result($result, 'ASSOC');

        }

        return $list;

    }