chamilo / chamilo-lms

     * @param	int $session_id

     * @return	array html with the content and count of announcements or false otherwise

     */

    public static function get_all_annoucement_by_course($course_info, $session_id = 0)

    {

        $session_id = intval($session_id);

        $course_id = $course_info['real_id'];

        $tbl_announcement = Database::get_course_table(TABLE_ANNOUNCEMENT);

        $tbl_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);

        $sql = "SELECT DISTINCT announcement.id, announcement.title, announcement.content

				FROM $tbl_announcement announcement, $tbl_item_property toolitemproperties

				WHERE

				    announcement.id = toolitemproperties.ref AND

                    toolitemproperties.tool='announcement' AND

                    announcement.session_id  = '$session_id' AND

                    announcement.c_id = $course_id AND

                    toolitemproperties.c_id = $course_id

				ORDER BY display_order DESC";

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

        $num_rows = Database::num_rows($rs);

        if ($num_rows > 0) {

            $list = array();

            while ($row = Database::fetch_array($rs)) {

                $list[] = $row;

            }

            return $list;

        }

        return false;

    }

    /**

     * This functions switches the visibility a course resource

     * @param $courseId

     * @return array

     */

    public static function getUserCourseCategoryForCourse($userId, $courseId)

    {

        $tblCourseRelUser = Database::get_main_table(TABLE_MAIN_COURSE_USER);

        $tblUserCategory = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);

        $courseId = intval($courseId);

        $userId = intval($userId);

        $sql = "SELECT user_course_cat, title

                FROM $tblCourseRelUser cru

                LEFT JOIN $tblUserCategory ucc

                ON cru.user_course_cat = ucc.id

                WHERE

                    cru.user_id = $userId AND c_id= $courseId ";

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

        $result = array();

        if (Database::num_rows($res) > 0) {

            $data = Database::fetch_assoc($res);

            $result[] = $data['user_course_cat'];

            $result[] = $data['title'];

        }

        return $result;

    }

    /**

     * Get the course id based on the original id and field name in the extra fields.

     *

     * @return array

     */

    public function getAllSkillPerTag($fieldId, $tagId)

    {

        $skillTable = Database::get_main_table(TABLE_MAIN_SKILL);

        $tagRelXtraTable = Database::get_main_table(TABLE_MAIN_EXTRA_FIELD_REL_TAG);

        $fieldId = intval($fieldId);

        $tagId = intval($tagId);

        $sql = "SELECT s.id

                FROM $skillTable s INNER JOIN $tagRelXtraTable t

                ON t.item_id = s.id

                WHERE tag_id = $tagId AND t.field_id = $fieldId;

        ";

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

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

        $skillList = [];

        foreach ($result as $index => $value) {

            $skillList[$value['id']] = $value['id'];

        }

        return $skillList;

    }

}