Proyectos de Subversion LeadersLinked - Antes de SPA

use LeadersLinked\Library\MyCoachAccessControl;

use LeadersLinked\Form\MyCoach\MyCoachAnswerForm;

use LeadersLinked\Mapper\MyCoachQuestionMapper;

use LeadersLinked\Mapper\MyCoachQuestionCategoryMapper;

use LeadersLinked\Model\MyCoachQuestionCategory;

use LeadersLinked\Mapper\QueryMapper;

use LeadersLinked\Model\MyCoachQuestion;

use Laminas\Db\ResultSet\HydratingResultSet;

use Laminas\Paginator\Adapter\DbSelect;

use Laminas\Paginator\Paginator;

use LeadersLinked\Mapper\UserMapper;

use LeadersLinked\Hydrator\ObjectPropertyHydrator;

use LeadersLinked\Library\Functions;

use LeadersLinked\Mapper\MyCoachAnswerMapper;

use LeadersLinked\Mapper\CommentMapper;

use LeadersLinked\Model\MyCoachAnswer;

use LeadersLinked\Form\MyCoach\CommentForm;

use LeadersLinked\Model\Comment;

use LeadersLinked\Mapper\ContentReactionMapper;

use LeadersLinked\Model\ContentReaction;

use LeadersLinked\Mapper\MyCoachQuestionViewMapper;

use LeadersLinked\Model\MyCoachQuestionView;

use Laminas\Db\Sql\Expression;

        if ($request->isGet()) {

            $myCoachAccesControl = MyCoachAccessControl::getInstance($this->adapter);

            $categories = $myCoachAccesControl->getCategoriesWithAccessToFormSelect($currentUser->id, $currentNetwork->id);

            $formQuestion = new MyCoachQuestionForm($categories);

            $formAnswer = new MyCoachAnswerForm();

            $this->layout()->setTemplate('layout/layout');

            $viewModel = new ViewModel();

            $viewModel->setTemplate('leaders-linked/my-coach/index');

            $viewModel->setVariables([

                'categories' => $categories,

                'formQuestion' => $formQuestion,

                'formAnswer' => $formAnswer,

            ]);

            return $viewModel;

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

    }

    public function questionsAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $currentNetworkPlugin = $this->plugin('currentNetworkPlugin');

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        if ($request->isGet()) {

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

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

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

            $myCoachAccessControl           = MyCoachAccessControl::getInstance($this->adapter);

            $category_filter_id = filter_var($this->params()->fromQuery('category_id'), FILTER_SANITIZE_STRING);

            $search = filter_var($this->params()->fromQuery('search'), FILTER_SANITIZE_STRING);

            $page   = intval($this->params()->fromQuery('start', 1), 10);

            $order_field        = 'added_on';

            $order_direction    = 'asc';

            $records_x_page     = 12;

            if ($category_filter_id) {

                    return new JsonModel([

                        'data' => $message_error,

                    ]);

                }

                $categoryFilter = $myCoachCategoryMapper->fetchOneByUuid($category_filter_id);

                $category_ids = [$categoryFilter->id];

            } else {

                $category_ids = $myCoachAccessControl->getCategoryIdsWithAccess($currentUser->id, $currentNetwork->id);

            }

            $category_ids_with_edition = $myCoachAccessControl->getCategoryIdsWithEdition($currentUser->id);

            $queryMapper = QueryMapper::getInstance($this->adapter);

            $prototype = new MyCoachQuestion();

            $selectIn = $queryMapper->getSql()->select(MyCoachQuestionCategoryMapper::_TABLE);

            $selectIn->columns(['question_id' => new Expression('DISTINCT(id)')]);

            $selectIn->where->in('category_id', $category_ids);

            $select = $queryMapper->getSql()->select(MyCoachQuestionMapper::_TABLE);

            $select->where->in('id', $selectIn);

            if($search) {

                $select->where->nest()

                -> like('title', '%' . $search . '%')->or->like('description', '%' . $search . '%')

                ->unnest();

            }

            $select->order($order_field . ' ' . $order_direction);

            //echo $select->getSqlString($this->adapter->platform);

            //exit;

            $users = [];

            $categories = [];

            //echo $select->getSqlString($this->adapter->platform); exit;

            $hydrator   = new ObjectPropertyHydrator();

            $resultset  = new HydratingResultSet($hydrator, $prototype);

            $adapter = new DbSelect($select, $queryMapper->getSql(), $resultset);

            $paginator = new Paginator($adapter);

            $paginator->setItemCountPerPage($records_x_page);

            $paginator->setCurrentPageNumber($page);

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

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

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

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

            $items = [];

            $records = $paginator->getCurrentItems();

            foreach ($records as $record)

                $bags_categories = [];

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

                $allowEdit   = $myCoachAccessControl->hasAccessEditQuestion($currentUser->id, $record->id, $currentNetwork->id, $message_error);

                        if ($category) {

                            $categories[$category->id] = $category->name;

                    }

                    array_push($bags_categories,['category' => $categories[ $questionCategory->category_id ] ]);

                if(isset($users[$record->user_id])) {

                    $user = $users[ $record->user_id ];

                } else {

                    $user = $userMapper->fetchOne($record->user_id);

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

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

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

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

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

                $item = [

                    'uuid' => $record->uuid,

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

                    'user_image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $user->uuid, 'filename' => $user->image]),

                    'title' => $record->title,

                    'description' => $description,

                    'categories' => $bags_categories,

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

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

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

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

                    'added_on' => $added_on,

                    'updated_on' => $updated_on,

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

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

                    'link_edit' => $allowEdit ?  $this->url()->fromRoute('my-coach/questions/edit', ['id' => $record->uuid]) : '',

                    'link_delete' => $allowDelete ? $this->url()->fromRoute('my-coach/questions/delete', ['id' =>  $record->uuid]) : '',

                ];

                array_push($items, $item);

            }

            return new JsonModel([

                'success' => true,

                'data' => [

                    'items' => $items,

                    'total' => $paginator->getTotalItemCount(),

                    'page' => $paginator->getCurrentPageNumber(),

                    'total_pages' => $paginator->getPageRange()

                ]

            ]);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

    }

    public function addQuestionAction()

    {

        $currentNetworkPlugin  = $this->plugin('currentNetworkPlugin');

        $currentNetwork        = $currentNetworkPlugin->getNetwork();

        $currentUserPlugin  = $this->plugin('currentUserPlugin');

        $currentUser        = $currentUserPlugin->getUser();

        $request            = $this->getRequest();

        if ($request->isPost()) {

            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());

            $myCoachAccessControl = MyCoachAccessControl::getInstance($this->adapter);

            $categories = $myCoachAccessControl->getCategoriesWithAccessToFormSelect($currentUser->id, $currentNetwork->id);

            $form = new MyCoachQuestionForm($categories);

            $form->setData($dataPost);

            if ($form->isValid()) {

                $dataPost = (array) $form->getData();

                $myCoachQuestion = new MyCoachQuestion();

                $myCoachQuestion->network_id    = $currentNetwork ->id;

                $myCoachQuestion->user_id       = $currentUser->id;

                $myCoachQuestion->title         = $dataPost['title'];

                $myCoachQuestion->description   = $dataPost['description'];

                $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

                if ($myCoachQuestionMapper->insert($myCoachQuestion)) {

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

                    $category_ids = $dataPost['category_id'];

                    foreach($category_ids as $category_id)

                    {

                        $myCoachCategory = $myCoachCategoryMapper->fetchOneByUuid($category_id);

                        if($myCoachCategory) {

                            $myCoachQuestionCategory->question_id = $myCoachQuestion->id;

                            $myCoachQuestionCategoryMapper->insert($myCoachQuestionCategory);

                        }

                    }

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

                    $data = [

                        'success'   => true,

                        'data'   => 'LABEL_RECORD_ADDED'

                    ];

                } else {

                    $data = [

                        'success'   => false,

                        'data'      => $myCoachQuestionMapper->getError()

                    ];

                }

                return new JsonModel($data);

            } else {

                $form_messages = (array) $form->getMessages();

                foreach ($form_messages  as $fieldname => $field_messages)

                {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success'   => false,

                    'data'   => $messages

                ]);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

    public function deleteQuestionAction()

    {

        $currentNetworkPlugin  = $this->plugin('currentNetworkPlugin');

        $currentNetwork        = $currentNetworkPlugin->getNetwork();

        $currentUserPlugin  = $this->plugin('currentUserPlugin');

        $currentUser        = $currentUserPlugin->getUser();

        $request    = $this->getRequest();

        $id         = $this->params()->fromRoute('id');

        $message_error = '';

        $myCoachAccessControl = MyCoachAccessControl::getInstance($this->adapter);

        if(!$myCoachAccessControl->hasAccessDeleteQuestion($currentUser->id, $id, $currentNetwork->id, $message_error)) {

            return new JsonModel([

                'success'   => false,

                'data'   => $message_error

            ]);

        }

        $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

        $myCoachQuestion = $myCoachQuestionMapper->fetchOneByUuid($id);

        if ($request->isPost()) {

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

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

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

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

            $result =  $myCoachQuestionMapper->delete($myCoachQuestion);

            if ($result) {

                $data = [

                    'success' => true,

                    'data' => 'LABEL_RECORD_DELETED'

                ];

            } else {

                $data = [

                    'success'   => false,

                    'data'      => $myCoachQuestionMapper->getError()

                ];

                return new JsonModel($data);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

    public function editQuestionAction()

    {

        $currentNetworkPlugin  = $this->plugin('currentNetworkPlugin');

        $currentNetwork        = $currentNetworkPlugin->getNetwork();

        $currentUserPlugin  = $this->plugin('currentUserPlugin');

        $currentUser        = $currentUserPlugin->getUser();

        $request    = $this->getRequest();

        $id    = $this->params()->fromRoute('id');

        $message_error = '';

        $myCoachAccessControl = MyCoachAccessControl::getInstance($this->adapter);

        if(!$myCoachAccessControl->hasAccessEditQuestion($currentUser->id, $id, $currentNetwork->id, $message_error)) {

            return new JsonModel([

                'success'   => false,

                'data'   => $message_error

            ]);

        }

        $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

        $myCoachQuestion = $myCoachQuestionMapper->fetchOneByUuid($id);

        if ($request->isGet()) {

            $category_ids = [];

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

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

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

            foreach($records as $record)

            {

                $myCoachCategory = $myCoachCategoryMapper->fetchOne($record->category_id);

                if($myCoachCategory) {

                    array_push($category_ids,$myCoachCategory->uuid);

                }

            }

            $data = [

                'success' => true,

                'data' => [

                    'category_id' => $category_ids,

                    'title' => $myCoachQuestion->title,

                    'description' => $myCoachQuestion->description,

                ]

            ];

            return new JsonModel($data);

        } else if ($request->isPost()) {

            $categories = $myCoachAccessControl->getCategoriesWithAccessToFormSelect($myCoachQuestion->user_id, $currentNetwork->id);

            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());

            $form = new MyCoachQuestionForm($categories);

            $form->setData($dataPost);

            if ($form->isValid()) {

                $dataPost = (array) $form->getData();

                $myCoachQuestion->title = $dataPost['title'];

                $myCoachQuestion->description = $dataPost['description'];

                if ($myCoachQuestionMapper->update($myCoachQuestion)) {

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

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

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

                    $category_ids = $dataPost['category_id'];

                    foreach($category_ids as $category_id)

                    {

                        $myCoachCategory = $myCoachCategoryMapper->fetchOneByUuid($category_id);

                        if($myCoachCategory) {

                            $myCoachQuestionCategory = new MyCoachQuestionCategory();

                            $myCoachQuestionCategory->category_id = $myCoachCategory->id;

                            $myCoachQuestionCategory->question_id = $myCoachQuestion->id;

                            $myCoachQuestionCategoryMapper->insert($myCoachQuestionCategory);

                        }

                    }

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

                    $data = [

                        'success'   => true,

                        'data'   => 'LABEL_RECORD_UPDATED'

                    ];

                } else {

                    $data = [

                        'success'   => false,

                        'data'      => $myCoachQuestionMapper->getError()

                    ];

                }

                return new JsonModel($data);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach ($form_messages  as $fieldname => $field_messages) {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success'   => false,

                    'data'   => $messages

                ]);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

    public function viewQuestionAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $currentNetworkPlugin = $this->plugin('currentNetworkPlugin');

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $request    = $this->getRequest();

        $id    = $this->params()->fromRoute('id');

        $message_error = '';

        $myCoachAccessControl = MyCoachAccessControl::getInstance($this->adapter);

        if(!$myCoachAccessControl->hasAccessViewQuestion($currentUser->id, $id, $currentNetwork->id, $message_error)) {

            return new JsonModel([

                'success'   => false,

                'data'   => $message_error

            ]);

        }

        $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

        $myCoachQuestion = $myCoachQuestionMapper->fetchOneByUuid($id);

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

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

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

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

        $request = $this->getRequest();

        if ($request->isGet()) {

            $categories = [];

            $users = [];

            $bags_categories = [];

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

            $myCoachQuestionView = $myCoachQuestionViewMapper->fetchOneByQuestionIdAndUserId($myCoachQuestion->id, $currentUser->id);

            if(!$myCoachQuestionView) {

                $myCoachQuestionView = new MyCoachQuestionView();

                $myCoachQuestionView->question_id = $myCoachQuestion->id;

                $myCoachQuestionView->user_id = $currentUser->id;

                $myCoachQuestionViewMapper->insert($myCoachQuestionView);

            }

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

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

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

            foreach($questionCategories as $questionCategory)

            {

                if (!isset($categories[$questionCategory->category_id])) {

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

                    if ($category) {

                        $categories[$category->id] = $category->name;

                    }

                }

                array_push($bags_categories,['category' => $categories[ $questionCategory->category_id ] ]);

            }

            $users = [];

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

            if(isset($users[$myCoachQuestion->user_id])) {

                $user = $users[$myCoachQuestion->user_id];

            } else {

                $user = $userMapper->fetchOne( $myCoachQuestion->user_id );

                $users[ $myCoachQuestion->user_id ] = $user;

            }

            $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');

            $allowDelete = $myCoachAccessControl->hasAccessDeleteQuestion($currentUser->id, $myCoachQuestion->id, $currentNetwork->id, $message_error);

            if($allowDelete) {

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

            } else {

                $link_delete = '';

            }

            $allowAnswerAdd = $myCoachAccessControl->hasAccessAnswerQuestion($currentUser->id, $myCoachQuestion->id, $currentNetwork->id, $message_error);

            if ($allowAnswerAdd) {

                $link_answers_add = $this->url()->fromRoute('my-coach/questions/answers/add', ['id' => $myCoachQuestion->uuid]);

            } else {

                $link_answers_add = '';

            }

            $myCoachLastAnswer = $myCoachAnswerMapper->fetchOneLastAnswerByQuestionId($myCoachQuestion->id);

            if( $myCoachLastAnswer) {

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

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

            } else {

                $last_answer_on = '';

            }

            return new JsonModel([

                'success' => true, 

                'data' => [

                    'uuid' => $myCoachQuestion->uuid,

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

                    'user_image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $user->uuid, 'filename' => $user->image]),

                    'title' => $myCoachQuestion->title,

                    'description' => $myCoachQuestion->description,

                    'categories' => $bags_categories,

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

                    'answers' => intval($myCoachAnswerMapper->fetchAllByQuestionId($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,

                    'last_answer_on' => $last_answer_on,

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

                    'link_answers_add' => $link_answers_add,

                    'link_delete' => $link_delete,

                ]

            ]);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

    }

    /**

     *

     * {@inheritDoc}

     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()

     */

    public function answersAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $currentNetworkPlugin = $this->plugin('currentNetworkPlugin');

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $request    = $this->getRequest();

        $id    = $this->params()->fromRoute('id');

        $message_error = '';

        $myCoachAccessControl = MyCoachAccessControl::getInstance($this->adapter);

        if(!$myCoachAccessControl->hasAccessViewQuestion($currentUser->id, $id, $currentNetwork->id, $message_error)) {

            return new JsonModel([

                'success'   => false,

                'data'   => $message_error

            ]);

        }

        $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

        $myCoachQuestion = $myCoachQuestionMapper->fetchOneByUuid($id);

        $request = $this->getRequest();

        if ($request->isGet()) {

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

            $now = $myCoachAnswerMapper->getDatebaseNow();

            $records = $myCoachAnswerMapper->fetchAllByQuestionId($myCoachQuestion->id);

            $items = [];

            foreach($records as $record)

            {

                $items[] = $this->renderAnswer($record->id, $currentUser->id, $now);

            }

            return new JsonModel([

                'success' => true,

                'data' => [

                    'items' => $items

                ]

            ]);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

    }

    public function addAnswerAction()

    {

        $currentNetwork        = $currentNetworkPlugin->getNetwork();

        $currentUserPlugin  = $this->plugin('currentUserPlugin');

        $currentUser        = $currentUserPlugin->getUser();

        $message_error = '';

        $myCoachAccessControl = MyCoachAccessControl::getInstance($this->adapter);

        if(!$myCoachAccessControl->hasAccessAnswerQuestion($currentUser->id, $id, $currentNetwork->id, $message_error)) {

            return new JsonModel([

                'success'   => false,

                'data'   => $message_error

            ]);

        }

        $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

        $myCoachQuestion = $myCoachQuestionMapper->fetchOneByUuid($id);

        if ($request->isPost()) {

            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());

            $form = new MyCoachAnswerForm();

            $form->setData($dataPost);

            if ($form->isValid()) {

                $myCoachAnswer = new MyCoachAnswer();

                $myCoachAnswer->question_id = $myCoachQuestion->id;

                $myCoachAnswer->text        = $dataPost['description'];

                $myCoachAnswer->user_id     = $currentUser->id;

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

                if($myCoachAnswerMapper->insert($myCoachAnswer)) {

                    $now = $myCoachAnswerMapper->getDatebaseNow();

                    $this->logger->info('Se agrego la respuesta ' . $myCoachAnswer->text, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                    $data = [

                        'success'   => true,

                        'data'   => [

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

                            'item' => $this->renderAnswer($myCoachAnswer->id, $currentUser->id, $now)

                        ]

                    ];

                        'success'   => false,

                return new JsonModel($data);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach ($form_messages  as $fieldname => $field_messages)

                {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success'   => false,

                    'data'   => $messages

                ]);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

    }

    /*

    public function deleteAction()

    {

    $currentUserPlugin = $this->plugin('currentUserPlugin');

    $currentUser    = $currentUserPlugin->getUser();

    $request    = $this->getRequest();

    $id         = $this->params()->fromRoute('id');

    $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

    $myCoachQuestion = $myCoachQuestionMapper->fetchOneByUuid($id);

    if (!$myCoachQuestion) {

    return new JsonModel([

    'success'   => false,

    'data'   => 'ERROR_RECORD_NOT_FOUND'

    ]);

    }

    $ok = false;

    if(!$myCoachQuestion->answers) {

    if($currentUser->id == $myCoachQuestion->user_id) {

    $ok = true;

    } else {

    $category_ids_with_edition = [];

    $myCoachCategoryUserMapper = MyCoachCategoryUserMapper::getInstance($this->adapter);

    $records = $myCoachCategoryUser = $myCoachCategoryUserMapper->fetchAllByUserId($currentUser->id);

    foreach($records as $record)

    {

    array_push($category_ids_with_edition, $record->user_id);

    }

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

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

    foreach($records as $record)

    {

    if (in_array($record->category_id, $category_ids_with_edition) && $myCoachCategoryUser->role == MyCoachCategoryUser::ROLE_EDITOR || $myCoachCategoryUser->role == MyCoachCategoryUser::ROLE_ADMINISTRATOR) {

    $ok = true;

    break;

    }

    }

    }

    }

    if (!$ok) {

    return new JsonModel([

    'success'   => false,

    'data'   => 'ERROR_KNOWLEDGE_AREA_YOU_DO_NOT_HAVE_PERMISSION'

    ]);

    }

    if ($request->isPost()) {

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

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

    $result =  $myCoachQuestionMapper->delete($myCoachQuestion);

    if ($result) {

    $data = [

    'success' => true,

    'data' => 'LABEL_RECORD_DELETED'

    ];

    } else {

    $data = [

    'success'   => false,

    'data'      => $myCoachQuestionMapper->getError()

    ];

    return new JsonModel($data);

    }

    } else {

    $data = [

    'success' => false,

    'data' => 'ERROR_METHOD_NOT_ALLOWED'

    ];

    return new JsonModel($data);

    }

    return new JsonModel($data);

    }

    public function editAction()

    {

    $currentUserPlugin = $this->plugin('currentUserPlugin');

    $currentUser    = $currentUserPlugin->getUser();

    $request    = $this->getRequest();

    $id    = $this->params()->fromRoute('id');

    $myCoachQuestionMapper = MyCoachQuestionMapper::getInstance($this->adapter);

    $myCoachQuestion = $myCoachQuestionMapper->fetchOneByUuid($id);

    if (!$myCoachQuestion) {

    return new JsonModel([

    'success'   => false,

    'data'   => 'ERROR_RECORD_NOT_FOUND'

    ]);

    }

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

    $ok = false;

    if(!$myCoachQuestion->answers) {

    if($currentUser->id == $myCoachQuestion->user_id) {

    $ok = true;

    } else {

    $category_ids_with_edition = [];

    $myCoachCategoryUserMapper = MyCoachCategoryUserMapper::getInstance($this->adapter);

    $records = $myCoachCategoryUser = $myCoachCategoryUserMapper->fetchAllByUserId($currentUser->id);

    foreach($records as $record)

    {

    array_push($category_ids_with_edition, $record->user_id);

    }

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

    foreach($records as $record)

    {