Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 15344 | Rev 15348 | Ir a la última revisión | | Comparar con el anterior | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
15338 efrain 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\NetworkMapper;
15
use LeadersLinked\Model\Network;
16
use LeadersLinked\Form\NetworkCreateForm;
17
use LeadersLinked\Model\User;
18
use LeadersLinked\Model\UserType;
19
use LeadersLinked\Mapper\UserMapper;
20
use LeadersLinked\Mapper\UserPasswordMapper;
21
use LeadersLinked\Model\UserPassword;
22
use LeadersLinked\Mapper\CompanySizeMapper;
23
use LeadersLinked\Mapper\IndustryMapper;
24
use LeadersLinked\Model\Company;
25
use LeadersLinked\Mapper\CompanyMapper;
26
use LeadersLinked\Model\CompanyUser;
27
use LeadersLinked\Mapper\CompanyUserMapper;
28
use LeadersLinked\Form\NetworkEditForm;
29
use LeadersLinked\Mapper\EmailTemplateMapper;
30
use LeadersLinked\Model\EmailTemplate;
31
use LeadersLinked\Mapper\PushTemplateMapper;
32
use LeadersLinked\Model\PushTemplate;
33
 
34
class PrivateNetworksController extends AbstractActionController {
35
 
36
    /**
37
     *
38
     * @var AdapterInterface
39
     */
40
    private $adapter;
41
 
42
    /**
43
     *
44
     * @var AbstractAdapter
45
     */
46
    private $cache;
47
 
48
    /**
49
     *
50
     * @var  LoggerInterface
51
     */
52
    private $logger;
53
 
54
    /**
55
     *
56
     * @var array
57
     */
58
    private $config;
59
 
60
    /**
61
     *
62
     * @param AdapterInterface $adapter
63
     * @param AbstractAdapter $cache
64
     * @param LoggerInterface $logger
65
     * @param array $config
66
     */
67
    public function __construct($adapter, $cache, $logger, $config) {
68
        $this->adapter = $adapter;
69
        $this->cache = $cache;
70
        $this->logger = $logger;
71
        $this->config = $config;
72
    }
73
 
74
    public function indexAction()
75
    {
76
        $currentUserPlugin = $this->plugin('currentUserPlugin');
77
        $currentUser = $currentUserPlugin->getUser();
78
 
79
        $request = $this->getRequest();
80
 
81
        $request = $this->getRequest();
82
        if($request->isGet()) {
83
 
84
 
85
            $headers  = $request->getHeaders();
86
 
87
            $isJson = false;
88
            if($headers->has('Accept')) {
89
                $accept = $headers->get('Accept');
90
 
91
                $prioritized = $accept->getPrioritized();
92
 
93
                foreach($prioritized as $key => $value) {
94
                    $raw = trim($value->getRaw());
95
 
96
                    if(!$isJson) {
97
                        $isJson = strpos($raw, 'json');
98
                    }
99
 
100
                }
101
            }
102
 
103
 
104
            if($isJson) {
105
                $acl = $this->getEvent()->getViewModel()->getVariable('acl');
106
                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'settings/private-networks/edit');
107
                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'settings/private-networks/delete');
108
 
109
 
110
                $search = $this->params()->fromQuery('search');
111
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
112
 
113
                $page               = intval($this->params()->fromQuery('start', 1), 10);
114
                $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
115
                $order =  $this->params()->fromQuery('order', []);
116
                $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
117
                $order_direction    = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var( $order[0]['dir'], FILTER_SANITIZE_STRING));
118
 
119
                $fields =  ['name','main_hostname', 'admin_hostname'];
120
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
121
 
122
                if(!in_array($order_direction, ['ASC', 'DESC'])) {
123
                    $order_direction = 'ASC';
124
                }
125
 
126
                $networkMapper = NetworkMapper::getInstance($this->adapter);
127
                $paginator = $networkMapper->fetchAllDataTable($search, $page, $records_x_page, $order_field, $order_direction);
128
 
129
                $items = [];
130
                $records = $paginator->getCurrentItems();
131
                foreach($records as $record)
132
                {
133
                    $item = [
134
                        'name' => $record->name,
135
                        'main_hostname' => $record->main_hostname,
136
                        'admin_hostname' => $record->admin_hostname,
137
                        'status' => $record->status,
138
                        'actions' => [
139
                            'link_edit' => $allowEdit ?  $this->url()->fromRoute('settings/private-networks/edit', ['id' => $record->uuid ]) : '',
140
                            'link_delete' => $allowDelete && $record->default == Network::DEFAULT_NO ? $this->url()->fromRoute('settings/private-networks/delete', ['id' => $record->uuid ]) : '',
141
                        ],
142
 
143
                    ];
144
 
145
                    array_push($items, $item);
146
                }
147
 
148
                return new JsonModel([
149
                    'success' => true,
150
                    'data' => [
151
                        'items' => $items,
152
                        'total' => $paginator->getTotalItemCount(),
153
                    ]
154
                ]);
155
            } else  {
156
                $formAdd = new NetworkCreateForm($this->adapter);
157
                $formEdit = new NetworkEditForm();
158
 
159
                $this->layout()->setTemplate('layout/layout-backend');
160
                $viewModel = new ViewModel();
161
                $viewModel->setTemplate('leaders-linked/private-networks/index.phtml');
162
                $viewModel->setVariables([
163
                    'formAdd' =>  $formAdd,
164
                    'formEdit' => $formEdit
165
 
166
                ]);
167
                return $viewModel ;
168
            }
169
 
170
        } else {
171
            return new JsonModel([
172
                'success' => false,
173
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
174
            ]);;
175
        }
176
    }
177
 
178
 
179
    public function addAction() {
180
        $currentUserPlugin = $this->plugin('currentUserPlugin');
181
        $currentUser = $currentUserPlugin->getUser();
182
 
183
 
184
        $request = $this->getRequest();
185
 
186
 
187
        if ($request->isPost()) {
188
 
189
 
190
 
191
            $form = new NetworkCreateForm($this->adapter);
192
            $dataPost = $request->getPost()->toArray();
193
 
194
 
195
 
196
            $form->setData($dataPost);
197
            if ($form->isValid()) {
198
 
199
                $dataPost = (array) $form->getData();
200
 
201
                $networkMapper = NetworkMapper::getInstance($this->adapter);
202
                $networkDefault = $networkMapper->fetchOneByDefault();
203
 
204
 
205
 
206
 
207
 
208
                $network = new Network();
209
                $network->status = Network::STATUS_ACTIVE;
210
                $network->default = Network::DEFAULT_NO;
211
                $network->name = $dataPost['company'];
212
                $network->admin_hostname = $dataPost['admin_hostname'];
213
                $network->main_hostname = $dataPost['main_hostname'];
214
 
215
                foreach($networkDefault as $key => $value)
216
                {
217
                    if(strpos($key, 'css') !== false) {
218
 
219
                        $network->{$key} = $networkDefault->{$key};
220
 
221
                    }
222
                }
223
 
224
 
225
                if(!$networkMapper->insert($network)) {
226
 
227
                    $response = [
228
                        'success' => false,
229
                        'data' => $networkMapper->getError()
230
                    ];
231
 
232
                    return new JsonModel($response);
233
 
234
                }
235
 
236
                $this->logger->info('Se agrego la red privada : ' . $network->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
237
 
238
                $timestamp = time();
239
                $activation_key = sha1($dataPost['email'] . uniqid() . $timestamp);
240
 
241
                $password_hash = password_hash($dataPost['password'], PASSWORD_DEFAULT);
242
 
243
 
244
                $user = new User();
245
                $user->blocked = User::BLOCKED_NO;
246
                $user->email = $dataPost['email'];
247
                $user->email_verified = User::EMAIL_VERIFIED_YES;
248
                $user->first_name = $dataPost['first_name'];
249
                $user->last_name = $dataPost['last_name'];
250
                $user->usertype_id          = UserType::ADMIN;
251
                $user->password             = $password_hash;
252
                $user->password_updated_on  = date('Y-m-d H:i:s');
253
                $user->activation_key       = $activation_key;
254
                $user->status               = User::STATUS_ACTIVE;
255
                $user->login_attempt        = 0;
256
                $user->network_id           = $network->id;
257
 
258
                $userMapper = UserMapper::getInstance($this->adapter);
259
                if(!$userMapper->insert($user)) {
260
                    $response = [
261
                        'success' => false,
262
                        'data' => $networkMapper->getError()
263
                    ];
264
 
265
                    return new JsonModel($response);
266
 
267
                }
268
 
269
                $userPassword = new UserPassword();
270
                $userPassword->user_id = $user->id;
271
                $userPassword->password = $password_hash;
272
 
273
                $userPasswordMapper = UserPasswordMapper::getInstance($this->adapter);
274
                $userPasswordMapper->insert($userPassword);
275
 
276
                $this->logger->info('Se agrego el usuario administrador : ' . $user->first_name . ' ' . $user->last_name . ' de la red privada : ' . $network->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
277
 
278
                $companySizeMapper = CompanySizeMapper::getInstance($this->adapter);
279
                $companySize = $companySizeMapper->fetchOneByUuid($dataPost['company_size_id']);
280
 
281
                $industryMapper = IndustryMapper::getInstance($this->adapter);
282
                $industry = $industryMapper->fetchOneByUuid($dataPost['industry_id']);
283
 
284
                $company = new Company();
285
                $company->name = $network->name;
286
                $company->default_for_network = Company::DEFAULT_FOR_NETWORK_YES;
287
                $company->network_id = $network->id;
288
                $company->company_size_id =  $companySize->id;
289
                $company->industry_id = $industry->id;
290
                $company->foundation_year = date('Y');
291
                $company->status = Company::STATUS_ACTIVE;
292
                $company->description = '';
293
 
294
 
295
                $companyMapper = CompanyMapper::getInstance($this->adapter);
296
                $result = $companyMapper->insert($company);
297
 
298
                if($result) {
299
 
300
 
301
 
302
                    /** Creación del fake user propietario de la empresa */
303
                    $owner = new User();
15344 efrain 304
                    $owner->network_id = $network->id;
15338 efrain 305
                    $owner->email = 'fake-email'.$company->id;
306
                    $owner->first_name = substr($company->name, 0, 64);
307
                    $owner->last_name = substr($company->name, 64);
308
                    $owner->status = User::STATUS_INACTIVE;
309
                    $owner->blocked = User::BLOCKED_YES;
310
                    $owner->login_attempt = 0;
311
                    $owner->email_verified = User::EMAIL_VERIFIED_YES;
312
                    $owner->show_in_search = User::SHOW_IN_SEARCH_NO;
313
                    $owner->password = 'NO-PASSWORD';
314
                    $owner->usertype_id = UserType::COMPANY;
315
 
316
                    $userMapper = UserMapper::getInstance($this->adapter);
317
                    $userMapper->insert($owner);
318
 
319
                    $companyUser = new CompanyUser();
320
                    $companyUser->company_id = $company->id;
321
                    $companyUser->user_id = $owner->id;
322
                    $companyUser->owner = CompanyUser::OWNER_YES;
323
                    $companyUser->creator = CompanyUser::CREATOR_NO;
324
                    $companyUser->status = CompanyUser::STATUS_ACCEPTED;
325
 
326
                    $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
327
                    $companyUserMapper->insert($companyUser);
328
 
329
                    /** agregamos el usuario que lo crea como full administrador */
330
                    $companyUser = new CompanyUser();
331
                    $companyUser->company_id = $company->id;
332
                    $companyUser->user_id = $user->id;
333
                    $companyUser->owner = CompanyUser::OWNER_NO;
334
                    $companyUser->creator = CompanyUser::CREATOR_YES;
335
                    $companyUser->status = CompanyUser::STATUS_ACCEPTED;
336
                    $companyUser->backend = CompanyUser::BACKEND_YES;
337
                    $companyUserMapper->insert($companyUser);
338
 
339
 
340
                    $emailTemplateMapper = EmailTemplateMapper::getInstance($this->adapter);
341
                    $records = $emailTemplateMapper->fetchAllDefault();
342
 
343
                    foreach($records as $record)
344
                    {
345
                        $emailTemplate = new EmailTemplate();
15345 efrain 346
                        $emailTemplate->network_id = $network->id;
15338 efrain 347
                        $emailTemplate->email_template_default_id = $record->id;
348
                        $emailTemplate->code = $record->code;
349
                        $emailTemplate->subject = $record->subject;
350
                        $emailTemplate->content = $record->content;
351
                        $emailTemplate->status = $record->status;
352
 
15344 efrain 353
                        $emailTemplateMapper->insert($emailTemplate);
15338 efrain 354
 
355
                    }
356
 
357
 
358
                    $this->logger->info('Se agrego la empresa por defecto : ' . $company->name . ' de la red : ' . $network->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
359
 
360
                    $data = [
361
                        'success'   => true,
362
                        'data'   => 'LABEL_RECORD_ADDED'
363
                    ];
364
                } else {
365
                    $data = [
366
                        'success'   => false,
367
                        'data'      => $companyMapper->getError()
368
                    ];
369
 
370
                }
371
 
372
                return new JsonModel($data);
373
 
374
 
375
            } else {
376
                $messages = [];
377
                $form_messages = (array) $form->getMessages();
378
                foreach ($form_messages as $fieldname => $field_messages) {
379
 
380
                    $messages[$fieldname] = array_values($field_messages);
381
                }
382
 
383
                return new JsonModel([
384
                    'success' => false,
385
                    'data' => $messages
386
                ]);
387
            }
388
        } else {
389
            $data = [
390
                'success' => false,
391
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
392
            ];
393
 
394
            return new JsonModel($data);
395
        }
396
 
397
        return new JsonModel($data);
398
    }
399
 
400
 
401
    public function editAction()
402
    {
403
        $currentUserPlugin = $this->plugin('currentUserPlugin');
404
        $currentUser = $currentUserPlugin->getUser();
405
 
406
        $request = $this->getRequest();
407
        $id = $this->params()->fromRoute('id');
408
 
409
 
410
        if (!$id) {
411
            $data = [
412
                'success' => false,
413
                'data' => 'ERROR_INVALID_PARAMETER'
414
            ];
415
 
416
            return new JsonModel($data);
417
        }
418
 
419
        $networkMapper = NetworkMapper::getInstance($this->adapter);
420
        $network = $networkMapper->fetchOneByUuid($id);
421
        if (!$network) {
422
            $data = [
423
                'success' => false,
424
                'data' => 'ERROR_RECORD_NOT_FOUND'
425
            ];
426
 
427
            return new JsonModel($data);
428
        }
429
 
430
 
431
        if ($request->isPost()) {
432
            $form = new NetworkEditForm();
433
            $dataPost = $request->getPost()->toArray();
434
 
435
            $form->setData($dataPost);
436
 
437
            if ($form->isValid()) {
438
                $dataPost = (array) $form->getData();
439
 
440
 
441
                if(empty($dataPost['status'])) {
442
                    $network->status = Network::STATUS_INACTIVE;
443
                }
444
                $network->name = $dataPost['name'];
445
                $network->main_hostname = $dataPost['main_hostname'];
446
                $network->admin_hostname = $dataPost['admin_hostname'];
447
 
448
                $result = $networkMapper->update($network);
449
                if ($result) {
450
                    $this->logger->info('Se actualizo la red privada : ' . $network->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
451
 
452
                    $data = [
453
                        'success' => true,
454
                        'data' => 'LABEL_RECORD_UPDATED'
455
                    ];
456
                } else {
457
                    $data = [
458
                        'success' => false,
459
                        'data' => $networkMapper->getError()
460
                    ];
461
                }
462
 
463
                return new JsonModel($data);
464
            } else {
465
                $messages = [];
466
                $form_messages = (array) $form->getMessages();
467
                foreach ($form_messages as $fieldname => $field_messages) {
468
                    $messages[$fieldname] = array_values($field_messages);
469
                }
470
 
471
                return new JsonModel([
472
                    'success' => false,
473
                    'data' => $messages
474
                ]);
475
            }
476
        } else if ($request->isGet()) {
477
 
478
 
479
            $data = [
480
                'success' => true,
481
                'data' => [
482
                    'name' => $network->name,
483
                    'status' => $network->status,
484
                    'main_hostname' => $network->main_hostname,
485
                    'admin_hostname' => $network->admin_hostname,
486
                    'status' => $network->status,
487
                ]
488
            ];
489
 
490
            return new JsonModel($data);
491
        } else {
492
            $data = [
493
                'success' => false,
494
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
495
            ];
496
 
497
            return new JsonModel($data);
498
        }
499
 
500
        return new JsonModel($data);
501
    }
502
 
503
    public function deleteAction()
504
    {
505
        $currentUserPlugin = $this->plugin('currentUserPlugin');
506
        $currentUser = $currentUserPlugin->getUser();
507
 
508
 
509
        $request = $this->getRequest();
510
        if ($request->isPost()) {
511
 
512
            $id = $this->params()->fromRoute('id');
513
            if (!$id) {
514
                $response = [
515
                    'success' => false,
516
                    'data' => 'ERROR_INVALID_PARAMETER'
517
                ];
518
 
519
                return new JsonModel($response);
520
            }
521
 
522
 
523
            $networkMapper = NetworkMapper::getInstance($this->adapter);
524
            $network = $networkMapper->fetchOneByUuid($id);
525
            if (!$network) {
526
                $response = [
527
                    'success' => false,
528
                    'data' => 'ERROR_RECORD_NOT_FOUND'
529
                ];
530
 
531
                return new JsonModel($response);
532
            }
533
 
534
            if($network->default == Network::DEFAULT_YES) {
535
                $response = [
536
                    'success' => false,
537
                    'data' =>  'ERROR_PRIVATE_NETWORK_CANNOT_DELETED'
538
                ];
539
 
540
                return new JsonModel($response);
541
 
542
            }
543
 
544
 
545
 
546
            $result = $networkMapper->delete($network->id);
547
            if ($result) {
548
                $this->logger->info('Se borro la red privada : ' . $network->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
549
 
550
                $response = [
551
                    'success' => true,
552
                    'data' => 'LABEL_RECORD_DELETED'
553
                ];
554
            } else {
555
 
556
                $response = [
557
                    'success' => false,
558
                    'data' => $networkMapper->getError()
559
                ];
560
 
561
            }
562
        } else {
563
            $response = [
564
                'success' => false,
565
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
566
            ];
567
 
568
        }
569
 
570
        return new JsonModel($response);
571
    }
572
 
573
 
574
 
575
}