Proyectos de Subversion LeadersLinked - Services

            // Capturar datos de la pregunta ANTES de eliminarla para formato consistente

            $userMapper = UserMapper::getInstance($this->adapter);

            $contentReactionMapper = ContentReactionMapper::getInstance($this->adapter);

            $commentMapper = CommentMapper::getInstance($this->adapter);

            $myCoachAnswerMapper = MyCoachAnswerMapper::getInstance($this->adapter);

            $myCoachQuestionViewMapper = MyCoachQuestionViewMapper::getInstance($this->adapter);

            $myCoachCategoryMapper = MyCoachCategoryMapper::getInstance($this->adapter);

            $storage = Storage::getInstance($this->config, $this->adapter);

            // Obtener categorías de la pregunta antes de eliminar

            $myCoachQuestionCategoryMapper = MyCoachQuestionCategoryMapper::getInstance($this->adapter);

            $questionCategories = $myCoachQuestionCategoryMapper->fetchAllByQuestionId($myCoachQuestion->id);

            $bags_categories = [];

            foreach($questionCategories as $questionCategory) {

                $category = $myCoachCategoryMapper->fetchOne($questionCategory->category_id);

                if($category) {

                    array_push($bags_categories, $category->name);

                }

            }

            // Formatear descripción (limitar a 250 caracteres)

            $description = strip_tags($myCoachQuestion->description);

            if (strlen($description) > 250) {

                $description = substr($description, 0, 250) . '...';

            }

            // Formatear fechas

            $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $myCoachQuestion->added_on);

            $added_on = $dt->format('d/m/Y H:i a');

            $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $myCoachQuestion->updated_on);

            $updated_on = $dt->format('d/m/Y H:i a');

            // Capturar datos completos antes de eliminar

            $questionData = [

                'uuid' => $myCoachQuestion->uuid,

                'user_name' => trim($user->first_name . ' ' . $user->last_name),

                'user_image' => $storage->getUserImage($user),

                'title' => $myCoachQuestion->title,

                'description' => $description,

                'categories' => $bags_categories,

                'views' => intval($myCoachQuestionViewMapper->fetchCountByQuestionId($myCoachQuestion->id), 10),

                'answers' => intval($myCoachAnswerMapper->fetchCountByMyCoachQuestionId($myCoachQuestion->id), 10),

                'reactions' => intval($contentReactionMapper->fetchCountByMyCoachQuestionId($myCoachQuestion->id), 10),

                'comments' => intval($commentMapper->fetchCountByMyCoachQuestionId($myCoachQuestion->id), 10),

                'added_on' => $added_on,

                'updated_on' => $updated_on,

                'link_add_comment' => $this->url()->fromRoute('my-coach/questions/comments/add', ['id' => $myCoachQuestion->uuid],['force_canonical' => true]),

                'link_view' => $this->url()->fromRoute('my-coach/questions/view', ['id' => $myCoachQuestion->uuid]),

                'link_edit' => $this->url()->fromRoute('my-coach/questions/edit', ['id' => $myCoachQuestion->uuid],['force_canonical' => true]),

                'link_delete' => $this->url()->fromRoute('my-coach/questions/delete', ['id' => $myCoachQuestion->uuid],['force_canonical' => true]),

                'link_reactions' => $this->url()->fromRoute('my-coach/questions/reactions', ['id' => $myCoachQuestion->uuid],['force_canonical' => true])

            $myCoachQuestionCategoryMapper->deleteAllByQuestionId($myCoachQuestion->id);

            $myCoachAnswerMapper->deleteAllByQuestionId($myCoachQuestion->id);

            if ($result) {

                $this->logger->info('Se elimino la pregunta ' . $myCoachQuestion->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                $data = [