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 

				INNER JOIN $tbl_item_property i

				ON (announcement.id = i.ref AND announcement.c_id = i.c_id)

				WHERE

                    i.tool='announcement' AND

                    announcement.session_id  = '$session_id' AND

                    announcement.c_id = $course_id AND

                    i.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;

     *

     * @return array

     */

    public function getAllSkillPerTag($fieldId, $tagId)

    {

        $skillTable = Database::get_main_table(TABLE_MAIN_SKILL);

        $tagRelExtraTable = 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 $tagRelExtraTable 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;

    }

}