Proyectos de Subversion LeadersLinked - Backend

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
9350 eleazar 1
<?php
2
 
3
declare(strict_types=1);
4
 
5
namespace LeadersLinked\Controller;
6
 
7
use Laminas\Db\Adapter\AdapterInterface;
8
use Laminas\Cache\Storage\Adapter\AbstractAdapter;
9
use Laminas\Mvc\Controller\AbstractActionController;
10
use Laminas\Log\LoggerInterface;
11
use Laminas\View\Model\ViewModel;
12
use Laminas\View\Model\JsonModel;
13
use LeadersLinked\Library\Functions;
14
use LeadersLinked\Mapper\MyTrainerCategoriesMapper;
10117 eleazar 15
use LeadersLinked\Mapper\TopicMapper;
9356 eleazar 16
use LeadersLinked\Mapper\MyTrainerQuestionsMapper;
9350 eleazar 17
use LeadersLinked\Form\MyTrainerQuestionForm;
9369 eleazar 18
use LeadersLinked\Model\MyTrainerQuestions;
9350 eleazar 19
use LeadersLinked\Mapper\CompanyMapper;
20
use LeadersLinked\Model\Company;
21
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
22
 
23
class MyTrainerQuestionController extends AbstractActionController {
24
 
25
    /**
26
     *
27
     * @var AdapterInterface
28
     */
29
    private $adapter;
30
 
31
    /**
32
     *
33
     * @var AbstractAdapter
34
     */
35
    private $cache;
36
 
37
    /**
38
     *
39
     * @var  LoggerInterface
40
     */
41
    private $logger;
42
 
43
    /**
44
     *
45
     * @var array
46
     */
47
    private $config;
48
 
49
    /**
50
     *
51
     * @param AdapterInterface $adapter
52
     * @param AbstractAdapter $cache
53
     * @param LoggerInterface $logger
54
     * @param array $config
55
     */
56
    public function __construct($adapter, $cache, $logger, $config) {
57
        $this->adapter = $adapter;
58
        $this->cache = $cache;
59
        $this->logger = $logger;
60
        $this->config = $config;
61
    }
62
 
63
    public function indexAction() {
64
        $request = $this->getRequest();
65
        $currentUserPlugin = $this->plugin('currentUserPlugin');
66
        $currentCompany = $currentUserPlugin->getCompany();
67
        $currentUser = $currentUserPlugin->getUser();
68
 
69
        try{
70
        $request = $this->getRequest();
71
        if ($request->isGet()) {
72
 
73
            $headers = $request->getHeaders();
74
 
75
            $isJson = false;
76
            if ($headers->has('Accept')) {
77
                $accept = $headers->get('Accept');
78
 
79
                $prioritized = $accept->getPrioritized();
80
 
81
                foreach ($prioritized as $key => $value) {
82
                    $raw = trim($value->getRaw());
83
 
84
                    if (!$isJson) {
85
                        $isJson = strpos($raw, 'json');
86
                    }
87
                }
88
            }
89
 
90
            if ($isJson) {
91
                $search = $this->params()->fromQuery('search', []);
92
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
93
 
94
                $page = intval($this->params()->fromQuery('start', 1), 10);
95
                $records_x_page = intval($this->params()->fromQuery('length', 10), 10);
96
                $order = $this->params()->fromQuery('order', []);
97
                $order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);
98
                $order_direction = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));
99
 
100
                $fields = ['title'];
101
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'title';
102
 
103
                if (!in_array($order_direction, ['ASC', 'DESC'])) {
104
                    $order_direction = 'ASC';
105
                }
106
 
107
                $acl = $this->getEvent()->getViewModel()->getVariable('acl');
108
                $allowAdd = $acl->isAllowed($currentUser->usertype_id, 'my-trainer/question/add');
109
                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'my-trainer/question/edit');
110
                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'my-trainer/question/delete');
111
 
9356 eleazar 112
                $questionsMapper = MyTrainerQuestionsMapper::getInstance($this->adapter);
9350 eleazar 113
                $paginator = $questionsMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
114
 
115
                $items = [];
116
                $records = $paginator->getCurrentItems();
117
 
118
                foreach ($records as $record) {
119
 
120
                    $item = [
10557 eleazar 121
                        'id' => $record->uuid,
9350 eleazar 122
                        'title' => $record->title,
123
                        'text' => $record->text,
124
                        'actions' => [
125
                            'link_edit' => $this->url()->fromRoute('my-trainer/question/edit', ['id' => $record->uuid]),
10557 eleazar 126
                            'link_delete' => $this->url()->fromRoute('my-trainer/question/delete', ['id' => $record->uuid]),
127
                            'link_feed' => $this->url()->fromRoute('my-trainer/answer/index', ['id' => $record->uuid, 'topic_id' => $record->category_id])
9350 eleazar 128
                        ]
129
                    ];
130
 
131
                    array_push($items, $item);
132
                }
133
 
134
                return new JsonModel([
135
                    'success' => true,
136
                    'data' => [
137
                        'items' => $items,
138
                        'total' => $paginator->getTotalItemCount(),
139
                    ]
140
                ]);
141
            } else {
142
 
10189 eleazar 143
                $form = new MyTrainerQuestionForm($this->adapter);
9350 eleazar 144
 
145
                $this->layout()->setTemplate('layout/layout-backend');
146
                $viewModel = new ViewModel();
147
                $viewModel->setTemplate('leaders-linked/my-trainer-question/index.phtml');
148
                $viewModel->setVariable('form', $form);
149
                return $viewModel;
150
            }
151
        } else {
152
            return new JsonModel([
153
                'success' => false,
154
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
155
            ]);
156
        }
157
    } catch (\Throwable $e) {
158
            $e->getMessage();
159
            return new JsonModel([
160
                'success' => false,
161
                'data' => $e
162
            ]);
163
        }
164
    }
165
 
166
    public function addAction() {
167
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
168
        $currentCompany     = $currentUserPlugin->getCompany();
169
        $currentUser        = $currentUserPlugin->getUser();
170
 
10180 eleazar 171
        $request    = $this->getRequest();
10238 eleazar 172
        try{
9350 eleazar 173
        if($request->isPost()) {
10189 eleazar 174
            $form = new  MyTrainerQuestionForm($this->adapter);
9365 eleazar 175
            $dataPost = $request->getPost()->toArray();
9373 eleazar 176
            $form->setData($dataPost);
10212 eleazar 177
 
9350 eleazar 178
            if($form->isValid()) {
10198 eleazar 179
 
10196 eleazar 180
                $dataPost = (array) $form->getData();
9385 eleazar 181
                $hydrator = new ObjectPropertyHydrator();
9384 eleazar 182
                $questions = new MyTrainerQuestions();
9383 eleazar 183
                $hydrator->hydrate($dataPost, $questions);
184
 
9382 eleazar 185
                $questions->first_name = $currentUser->first_name;
9381 eleazar 186
                $questions->last_name = $currentUser->last_name;
187
                $questions->company_id = $currentCompany->id;
9377 eleazar 188
 
10117 eleazar 189
                $categoriesMapper = TopicMapper::getInstance($this->adapter);
9363 eleazar 190
                $category = $categoriesMapper->fetchOneByUuid($dataPost['category_id']);
10249 eleazar 191
                $questions->category_id = $category->id;
9363 eleazar 192
 
9356 eleazar 193
                $questionsMapper = MyTrainerQuestionsMapper::getInstance($this->adapter);
9350 eleazar 194
 
195
                if($questionsMapper->insert($questions)) {
196
                     $questions = $questionsMapper->fetchOne($questions->id);
197
 
198
                    $this->logger->info('Se agrego la pregunta ' . $questions->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
199
 
200
                    $data = [
201
                        'success'   => true,
202
                        'data'   => 'LABEL_RECORD_ADDED'
203
                    ];
204
                } else {
205
                    $data = [
206
                        'success'   => false,
207
                        'data'      => $questionsMapper->getError()
208
                    ];
209
 
210
                }
211
 
212
                return new JsonModel($data);
213
 
214
            } else {
215
                $messages = [];
216
                $form_messages = (array) $form->getMessages();
217
                foreach($form_messages  as $fieldname => $field_messages)
218
                {
219
 
220
                    $messages[$fieldname] = array_values($field_messages);
221
                }
222
 
223
            }
224
 
225
        } else {
226
            $data = [
227
                'success' => false,
228
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
229
            ];
230
 
231
            return new JsonModel($data);
232
        }
233
 
234
        return new JsonModel($data);
10238 eleazar 235
    } catch (\Throwable $e) {
10247 eleazar 236
        return $e;
9350 eleazar 237
    }
10238 eleazar 238
    }
9350 eleazar 239
 
240
    public function editAction() {
241
        $request = $this->getRequest();
242
        $currentUserPlugin = $this->plugin('currentUserPlugin');
243
        $currentCompany = $currentUserPlugin->getCompany();
244
        $currentUser = $currentUserPlugin->getUser();
245
 
246
        $request = $this->getRequest();
247
        $uuid = $this->params()->fromRoute('id');
248
        try{
249
        if (!$uuid) {
250
            $data = [
251
                'success' => false,
252
                'data' => 'ERROR_INVALID_PARAMETER'
253
            ];
254
 
255
            return new JsonModel($data);
256
        }
257
 
9356 eleazar 258
        $questionsMapper = MyTrainerQuestionsMapper::getInstance($this->adapter);
9350 eleazar 259
        $questions = $questionsMapper->fetchOneByUuid($uuid);
260
 
261
        if (!$questions) {
262
            $data = [
263
                'success' => false,
264
                'data' => 'ERROR_RECORD_NOT_FOUND'
265
            ];
266
 
267
            return new JsonModel($data);
268
        }
269
 
270
        if ($questions->company_id != $currentCompany->id) {
271
            return new JsonModel([
272
                'success' => false,
273
                'data' => 'ERROR_UNAUTHORIZED'
274
            ]);
275
        }
276
 
277
 
278
        if ($request->isPost()) {
10189 eleazar 279
            $form = new MyTrainerQuestionForm($this->adapter);
9350 eleazar 280
            $dataPost = $request->getPost()->toArray();
281
 
282
            $form->setData($dataPost);
283
 
284
            if ($form->isValid()) {
285
                $dataPost = (array) $form->getData();
286
 
287
                $hydrator = new ObjectPropertyHydrator();
288
                $hydrator->hydrate($dataPost, $questions);
10250 eleazar 289
                $categoriesMapper = TopicMapper::getInstance($this->adapter);
290
                $category = $categoriesMapper->fetchOneByUuid($dataPost['category_id']);
291
                $questions->category_id = $category->id;
9350 eleazar 292
 
293
                if($questionsMapper->update($questions)) {
294
                    $questions = $questionsMapper->fetchOne($questions->id);
295
 
296
                   $this->logger->info('Se modifico la pregunta ' . $questions->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
297
 
298
                   $data = [
299
                       'success'   => true,
300
                       'data'   => 'LABEL_RECORD_UPDATED'
301
                   ];
302
               } else {
303
                   $data = [
304
                       'success'   => false,
305
                       'data'      => $questionsMapper->getError()
306
                   ];
307
 
308
               }
309
 
310
                return new JsonModel($data);
311
            } else {
312
                $messages = [];
313
                $form_messages = (array) $form->getMessages();
314
                foreach ($form_messages as $fieldname => $field_messages) {
315
                    $messages[$fieldname] = array_values($field_messages);
316
                }
317
 
318
                return new JsonModel([
319
                    'success' => false,
320
                    'data' => $messages
321
                ]);
322
            }
323
        } else if ($request->isGet()) {
324
 
325
            $hydrator = new ObjectPropertyHydrator();
10252 eleazar 326
            $categoriesMapper = TopicMapper::getInstance($this->adapter);
327
            $category = $categoriesMapper->fetchOne($questions->category_id);
9350 eleazar 328
 
329
            $data = [
330
                'success' => true,
331
                'data' => [
332
                    'id' => $questions->uuid,
10252 eleazar 333
                    'category_id' => $category->uuid,
9350 eleazar 334
                    'title' => $questions->title,
335
                    'text' => $questions->text,
336
                ]
337
            ];
338
 
339
            return new JsonModel($data);
340
        } else {
341
            $data = [
342
                'success' => false,
343
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
344
            ];
345
 
346
            return new JsonModel($data);
347
        }
348
 
349
        return new JsonModel($data);
350
    } catch (\Throwable $e) {
351
        $e->getMessage();
352
        return new JsonModel([
353
            'success' => false,
354
            'data' => $e
355
        ]);
356
    }
357
    }
358
 
359
    public function deleteAction() {
360
        $request = $this->getRequest();
361
        $currentUserPlugin = $this->plugin('currentUserPlugin');
362
        $currentCompany = $currentUserPlugin->getCompany();
363
        $currentUser = $currentUserPlugin->getUser();
364
 
365
        $request = $this->getRequest();
366
        $uuid = $this->params()->fromRoute('id');
367
 
368
        if (!$uuid) {
369
            $data = [
370
                'success' => false,
371
                'data' => 'ERROR_INVALID_PARAMETER'
372
            ];
373
 
374
            return new JsonModel($data);
375
        }
376
 
9356 eleazar 377
        $questionsMapper = MyTrainerQuestionsMapper::getInstance($this->adapter);
9350 eleazar 378
        $questions = $questionsMapper->fetchOneByUuid($uuid);
379
        if (!$questions) {
380
            $data = [
381
                'success' => false,
382
                'data' => 'ERROR_RECORD_NOT_FOUND'
383
            ];
384
 
385
            return new JsonModel($data);
386
        }
387
 
388
        if ($questions->company_id != $currentCompany->id) {
389
            return new JsonModel([
390
                'success' => false,
391
                'data' => 'ERROR_UNAUTHORIZED'
392
            ]);
393
        }
394
 
395
        if ($request->isPost()) {
396
 
397
 
398
            $result = $questionsMapper->delete($questions->id);
399
            if ($result) {
400
                $this->logger->info('Se borro la pregunta ' . $questions->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
401
 
402
                $data = [
403
                    'success' => true,
404
                    'data' => 'LABEL_RECORD_DELETED'
405
                ];
406
            } else {
407
 
408
                $data = [
409
                    'success' => false,
410
                    'data' => $questionsMapper->getError()
411
                ];
412
 
413
                return new JsonModel($data);
414
            }
415
        } else {
416
            $data = [
417
                'success' => false,
418
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
419
            ];
420
 
421
            return new JsonModel($data);
422
        }
423
 
424
        return new JsonModel($data);
425
    }
426
}