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