chamilo / chamilo-lms

     * @param string $commentsDelete Set to 'on' to register as 'article_comments_delete' in tasks permissions

     * @param string $color

     */

    public static function addTask(

        $blog_id,

        $title,

        $description,

        $articleDelete,

        $articleEdit,

        $commentsDelete,

        $color

    ) {

        $tbl_blogs_tasks = Database::get_course_table(TABLE_BLOGS_TASKS);

        $tbl_tasks_permissions = Database::get_course_table(TABLE_BLOGS_TASKS_PERMISSIONS);

        $course_id = api_get_course_int_id();

        $blog_id = intval($blog_id);

        $title = Database::escape_string($title);

        $description = Database::escape_string($description);

        $color = Database::escape_string($color);

        // Create the task

        $sql = "INSERT INTO $tbl_blogs_tasks (c_id, blog_id, title, description, color, system_task)

                VALUES ($course_id , $blog_id, '$title', '$description', '$color', '0');";

        Database::query($sql);

        $task_id = Database::insert_id();

        if ($task_id) {

            $sql = "UPDATE $tbl_blogs_tasks SET task_id = iid WHERE iid = $task_id";

            Database::query($sql);

        }

        $tool = 'BLOG_'.$blog_id;

        if ($articleDelete == 'on') {

            $sql = "INSERT INTO $tbl_tasks_permissions ( c_id,  task_id, tool, action)

                    VALUES ($course_id, $task_id, '$tool', 'article_delete')";

            Database::query($sql);

            $id = Database::insert_id();

            if ($id) {

                $sql = "UPDATE $tbl_tasks_permissions SET id = iid WHERE iid = $id";

                Database::query($sql);

            }

        }

        if ($articleEdit == 'on') {

            $sql = "

                INSERT INTO $tbl_tasks_permissions (c_id, task_id, tool, action ) 

                VALUES ($course_id, $task_id, '$tool', 'article_edit')";

            Database::query($sql);

            $id = Database::insert_id();

            if ($id) {

                $sql = "UPDATE $tbl_tasks_permissions SET id = iid WHERE iid = $id";

                Database::query($sql);

            }

        }

        if ($commentsDelete == 'on') {

            $sql = "

                INSERT INTO $tbl_tasks_permissions (c_id, task_id, tool, action )

                VALUES ($course_id, $task_id, '$tool', 'article_comments_delete')";

            Database::query($sql);

            $id = Database::insert_id();

            if ($id) {

                $sql = "UPDATE $tbl_tasks_permissions SET id = iid WHERE iid = $id";

                Database::query($sql);

            }

        }

    }

    /**

     * Edit a task in a blog

     * @param string $commentsDelete Set to 'on' to register as 'article_comments_delete' in tasks permissions

     * @param string $color The color code

     */

    public static function editTask(

        $blog_id,

        $task_id,

        $title,

        $description,

        $articleDelete,

        $articleEdit,

        $commentsDelete,

        $color

    ) {

        $tbl_blogs_tasks = Database::get_course_table(TABLE_BLOGS_TASKS);

        $tbl_tasks_permissions = Database::get_course_table(TABLE_BLOGS_TASKS_PERMISSIONS);

        $course_id = api_get_course_int_id();

        $blog_id = intval($blog_id);

        $task_id = intval($task_id);

        $title = Database::escape_string($title);

        $description = Database::escape_string($description);

        $color = Database::escape_string($color);

        // Create the task

        $sql = "UPDATE $tbl_blogs_tasks SET

                    title = '$title',

                    description = '$description',

                    color = '$color'

                WHERE c_id = $course_id AND task_id = task_id LIMIT 1";

        Database::query($sql);

        $tool = 'BLOG_'.$blog_id;

        $sql = "DELETE FROM $tbl_tasks_permissions

                WHERE c_id = $course_id AND task_id = $task_id";

        Database::query($sql);

        if ($articleDelete == 'on') {

            $sql = "INSERT INTO $tbl_tasks_permissions ( c_id, task_id, tool, action)

                    VALUES ($course_id, $task_id, '$tool', 'article_delete')";

            Database::query($sql);

            $id = Database::insert_id();

            if ($id) {

                $sql = "UPDATE $tbl_tasks_permissions SET id = iid WHERE iid = $id";

                Database::query($sql);

            }

        }

        if ($articleEdit == 'on') {

            $sql = "INSERT INTO $tbl_tasks_permissions (c_id, task_id, tool, action) 

                    VALUES ($course_id, $task_id, '$tool', 'article_edit')";

            Database::query($sql);

            $id = Database::insert_id();

            if ($id) {

                $sql = "UPDATE $tbl_tasks_permissions SET id = iid WHERE iid = $id";

                Database::query($sql);

            }

        }

        if ($commentsDelete == 'on') {

            $sql = "INSERT INTO $tbl_tasks_permissions (c_id, task_id, tool, action)

                    VALUES ($course_id, $task_id, '$tool', 'article_comments_delete')";

            Database::query($sql);

            $id = Database::insert_id();

            if ($id) {

                $sql = "UPDATE $tbl_tasks_permissions SET id = iid WHERE iid = $id";

                Database::query($sql);

            }

        }

    }

    /**

     * Deletes a task from a blog

     * @param int $blog_id