deletePost()

Complexity

Conditions	5
Paths	4

Size

Total Lines	49
Code Lines	28

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function deletePost(CForumPost $post): void
{
    $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
    $em = Database::getManager();
    $em
        ->createQuery('
            UPDATE ChamiloCourseBundle:CForumPost p
            SET p.postParent = :parent_of_deleted_post
            WHERE
                p.postParent = :post AND
                p.thread = :thread_of_deleted_post AND
                p.forum = :forum_of_deleted_post
        ')
        ->execute([
            'parent_of_deleted_post' => $post->getPostParent(),
            'post' => $post->getIid(),
            '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();

    $lastPostOfTheTread = getLastPostOfThread($post->getThread()->getIid());

    if (!empty($lastPostOfTheTread)) {
        // 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 = ".$lastPostOfTheTread['iid'].",
                    thread_date = '".$lastPostOfTheTread['post_date']."'
                WHERE iid = ".$post->getThread()->getIid();
        Database::query($sql);
        Display::addFlash(Display::return_message(get_lang('Post has been deleted')));
    } else {
        // We deleted the very last post of the thread, so we need to delete the thread as well.
        $sql = "DELETE FROM $table_threads
                WHERE iid = ".$post->getThread()->getIid();
        Database::query($sql);

        Display::addFlash(Display::return_message(get_lang('Thread deleted')));
    }