delete_post()

Complexity

Conditions	7
Paths	9

Size

Total Lines	62
Code Lines	35

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function delete_post($post_id)
{
    $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
    $post_id = (int) $post_id;
    $course_id = api_get_course_int_id();
    $em = Database::getManager();
    /** @var CForumPost $post */
    $post = $em
        ->getRepository('ChamiloCourseBundle:CForumPost')
        ->findOneBy(['cId' => $course_id, 'postId' => $post_id]);

    if ($post) {
        $em
            ->createQuery('
                UPDATE ChamiloCourseBundle:CForumPost p
                SET p.postParentId = :parent_of_deleted_post
                WHERE
                    p.cId = :course AND
                    p.postParentId = :post AND
                    p.thread = :thread_of_deleted_post AND
                    p.forum = :forum_of_deleted_post
            ')
            ->execute([
                'parent_of_deleted_post' => $post->getPostParentId(),
                'course' => $course_id,
                'post' => $post->getPostId(),
                'thread_of_deleted_post' => $post->getThread() ? $post->getThread()->getIid() : 0,
                'forum_of_deleted_post' => $post->getForum(),
            ]);

        $attachments = $post->getAttachments();
        if (!empty($attachments)) {
            foreach ($attachments as $attachment) {
                $em->remove($attachment);
            }
        }

        $em->remove($post);
        $em->flush();
    }

    $last_post_of_thread = check_if_last_post_of_thread($_GET['thread']);

    if (is_array($last_post_of_thread)) {
        // Decreasing the number of replies for this thread and also changing the last post information.
        $sql = "UPDATE $table_threads
                SET
                    thread_replies = thread_replies - 1,
                    thread_last_post = ".(int) ($last_post_of_thread['post_id']).",
                    thread_date='".Database::escape_string($last_post_of_thread['post_date'])."'
                WHERE c_id = $course_id AND thread_id = ".(int) ($_GET['thread']);
        Database::query($sql);

        return 'PostDeleted';
    }
    if (!$last_post_of_thread) {
        // We deleted the very single post of the thread so we need to delete the entry in the thread table also.
        $sql = "DELETE FROM $table_threads
                WHERE c_id = $course_id AND thread_id = ".(int) ($_GET['thread']);
        Database::query($sql);

        return 'PostDeletedSpecial';
    }