Proyectos de Subversion LeadersLinked - Services

    }

    /*

    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)

    {

    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 (!$ok) {

    return new JsonModel([

    'success'   => false,

    'data'   => 'ERROR_KNOWLEDGE_AREA_YOU_DO_NOT_HAVE_PERMISSION'

    ]);

    }

    if ($request->isGet()) {

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

    $category_ids = [];

    $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()) {

    $category_with_edition_ids = [];

    $category_ids = [];

    $categories = [];

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

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

    foreach ($records as $record) {

    if ($record->role == MyCoachCategoryUser::ROLE_ADMINISTRATOR || $record->role == MyCoachCategoryUser::ROLE_USER) {

    array_push($category_with_edition_ids, $record->category_id);

    }

    array_push($category_ids, $record->category_id);

    }

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

    if ($category_ids) {

    $records =  $myCoachCategoryMapper->fetchAllByIds($category_ids);

    foreach ($records as $record) {

    if ($record->status == MyCoachCategory::STATUS_ACTIVE) {

    $categories[$record->id] = [

    'uuid' => $record->uuid,

    'name' => $record->name,

    ];

    }

    }

    }

    $categories = array_values($categories);

    usort($categories, function ($a, $b) {

    return $a['name'] <=> $b['name'];

    });

    $categories_question_available = [];

    foreach($categories as $cartegory)

    {

    $categories_question_available[ $cartegory['uuid'] ] = $cartegory['name'];

    }

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

    $form = new MyCoachQuestionForm($categories_question_available);

    $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 viewAction()

    {

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

    $currentUser = $currentUserPlugin->getUser();

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

    $currentNetwork = $currentNetworkPlugin->getNetwork();

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

    ]);

    }

    $request = $this->getRequest();

    if ($request->isGet()) {

    $category_with_edition_ids = [];

    $category_ids = [];

    $categories = [];

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

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

    foreach ($records as $record) {

    if ($record->role == MyCoachCategoryUser::ROLE_ADMINISTRATOR || $record->role == MyCoachCategoryUser::ROLE_USER) {

    array_push($category_with_edition_ids, $record->category_id);

    }

    array_push($category_ids, $record->category_id);

    }

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

    if ($category_ids) {

    $records =  $myCoachCategoryMapper->fetchAllByIds($category_ids);

    foreach ($records as $record) {

    $categories[$record->id] = [

    'uuid' => $record->uuid,

    'name' => $record->name,

    ];

    }

    }

    $records =  $myCoachCategoryMapper->fetchAllPublicByNetworkId($currentNetwork->id);

    foreach ($records as $record) {

    if (!isset($categories[$record->id])) {

    $categories[$record->id] = [

    'uuid' => $record->uuid,

    'name' => $record->name,

    ];

    }

    }

    $categories = array_values($categories);

    usort($categories, function ($a, $b) {

    return $a['name'] <=> $b['name'];

    });

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

    $allowDelete = false;

    $allowAnswer = false;

    $bags_categories = [];

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

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

    foreach($questionCategories as $questionCategory)

    {

    if(in_array($questionCategory->category_id, $categories)) {

    $access = true;

    }

    if(in_array($questionCategory->category_id, $category_with_edition_ids)) {

    $allowDelete = true;

    $allowAnswer = true;

    }

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

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

    if ($category) {

    $categories[$category->id] = [

    'uuid' =>  $category->uuid,

    'name' =>  $category->name,

    ];

    }

    }

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

    }

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

    $data = [

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

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

    'title' => $myCoachQuestion->title,

    'description' => $myCoachQuestion->description,

    'categories' => $bags_categories,

    'views' => $myCoachQuestion->views,

    'answers' => $myCoachQuestion->answers,

    'reactions' => $myCoachQuestion->reactions,

    'added_on' => $added_on,

    'updated_on' => $updated_on,

    'answers' => [],

    ];

    if($allowDelete || $myCoachQuestion->zuser_id == $currentUser->id) {

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

    } else {

    $data['ink_delete'] = '';

    }

    if ($allowAnswer) {

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

    } else {

    $data['link_answers'] = '';

    }

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

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

    foreach($records as $record)

    {

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

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

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

    } else {

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

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

    }

    array_push($data['answers'], [

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

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

    'text' => $record->text,

    'added_on' => $added_on,

    'updated_on' => $updated_on,

    'link_delete' => $allowAnswer ? $this->url()->fromRoute('my-coach/questions/answer/delete', ['code' => $myCoachQuestion->uuid, 'answer' => $record->uuid]) : '',

    ]);

    }

    return new JsonModel([

    'success' => true,

    'data' => $data

    ]);

    } else {

    return new JsonModel([

    'success' => false,

    'data' => 'ERROR_METHOD_NOT_ALLOWED'

    ]);

    }

    return new JsonModel($data);