Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 15459 | Rev 16248 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 15459 Rev 15460
Línea 37... Línea 37...
37
use LeadersLinked\Mapper\UserNotificationSettingMapper;
37
use LeadersLinked\Mapper\UserNotificationSettingMapper;
38
use LeadersLinked\Mapper\EmailTemplateMapper;
38
use LeadersLinked\Mapper\EmailTemplateMapper;
39
use LeadersLinked\Library\QueueEmail;
39
use LeadersLinked\Library\QueueEmail;
40
use LeadersLinked\Mapper\NetworkMapper;
40
use LeadersLinked\Mapper\NetworkMapper;
41
use LeadersLinked\Model\Network;
41
use LeadersLinked\Model\Network;
-
 
42
use LeadersLinked\Mapper\CompanyMapper;
-
 
43
use LeadersLinked\Mapper\ConnectionMapper;
-
 
44
use LeadersLinked\Model\Connection;
-
 
45
use LeadersLinked\Mapper\CompanyFollowerMapper;
-
 
46
use LeadersLinked\Model\CompanyFollower;
-
 
47
use LeadersLinked\Mapper\CountryMapper;
-
 
48
use LeadersLinked\Mapper\LocationMapper;
-
 
49
use LeadersLinked\Model\Location;
Línea 42... Línea 50...
42
 
50
 
43
class UserController extends AbstractActionController
51
class UserController extends AbstractActionController
44
{
52
{
45
    /**
53
    /**
Línea 378... Línea 386...
378
        }
386
        }
379
        else if($request->isGet()) {
387
        else if($request->isGet()) {
380
            $this->layout()->setTemplate('layout/layout-backend');
388
            $this->layout()->setTemplate('layout/layout-backend');
381
            $viewModel = new ViewModel();
389
            $viewModel = new ViewModel();
Línea -... Línea 390...
-
 
390
            
-
 
391
            
382
            
392
            $formUploadUsers = new UserUploadForm();
383
            $formChangePassword = new ChangePasswordForm();
393
            $formChangePassword = new ChangePasswordForm();
384
            $company = $currentUserPlugin->getCompany();
394
            $company = $currentUserPlugin->getCompany();
385
            if($company) {
-
 
386
                
-
 
387
                $formUploadUsers = new UserUploadForm();
-
 
388
 
395
            if($company) {
389
                $viewModel->setTemplate('leaders-linked/users/company.phtml');
-
 
390
                $viewModel->setVariables([
-
 
391
                    'formUploadUsers' => $formUploadUsers,
-
 
392
                    'formChangePassword' => $formChangePassword,
-
 
-
 
396
                $viewModel->setTemplate('leaders-linked/users/company.phtml');
393
                ] ); 
397
                 
394
            } else { 
398
            } else { 
395
                $viewModel->setTemplate('leaders-linked/users/index.phtml');
-
 
396
                $viewModel->setVariables([
-
 
397
                    'formChangePassword' => $formChangePassword,
-
 
398
                ]);
399
                $viewModel->setTemplate('leaders-linked/users/index.phtml');
-
 
400
            }
-
 
401
            $viewModel->setVariables([
-
 
402
                'formUploadUsers' => $formUploadUsers,
-
 
403
                'formChangePassword' => $formChangePassword,
399
            }
404
            ] );
Línea 400... Línea 405...
400
            return $viewModel ;
405
            return $viewModel ;
401
      
406
      
402
        } else {
407
        } else {
Línea 1467... Línea 1472...
1467
                    
1472
                    
1468
                    foreach($records as $record)
1473
                    foreach($records as $record)
1469
                    {
1474
                    {
Línea 1470... Línea 1475...
1470
                        //A = Nombre 	B = Apellidos	C = Email 	D = contraseña
1475
                        //A = Nombre 	B = Apellidos	C = Email 	D = contraseña
1471
                        
-
 
1472
                        
1476
                        
1473
                        $email = trim(filter_var($record['C'], FILTER_SANITIZE_EMAIL));
1477
                      
-
 
1478
                        $first_name = trim(filter_var($record['A'], FILTER_SANITIZE_STRING));
-
 
1479
                        $last_name = trim(filter_var($record['B'], FILTER_SANITIZE_STRING));
1474
                        $first_name = trim(filter_var($record['A'], FILTER_SANITIZE_STRING));
1480
                        $email = trim(filter_var($record['C'], FILTER_SANITIZE_EMAIL));
-
 
1481
                     
-
 
1482
                        $password = trim(filter_var($record['D'], FILTER_SANITIZE_STRING));
-
 
1483
                        $isAdult = strtolower(trim(filter_var($record['E'], FILTER_SANITIZE_STRING)));
Línea 1475... Línea 1484...
1475
                        $last_name = trim(filter_var($record['B'], FILTER_SANITIZE_STRING));
1484
                        $country = strtolower(trim(filter_var($record['F'], FILTER_SANITIZE_STRING)));
1476
                        $password = trim(filter_var($record['D'], FILTER_SANITIZE_STRING));
1485
 
1477
                        
1486
                        
Línea 1487... Línea 1496...
1487
                            array_push($users, [
1496
                            array_push($users, [
1488
                                'first_name' => $first_name,
1497
                                'first_name' => $first_name,
1489
                                'last_name' => $last_name,
1498
                                'last_name' => $last_name,
1490
                                'password'  => $password,
1499
                                'password'  => $password,
1491
                                'email' => $email,
1500
                                'email' => $email,
-
 
1501
                                'is_adult' => $isAdult,
-
 
1502
                                'country' => $country,
-
 
1503
 
1492
                            ]);
1504
                            ]);
1493
                        }
1505
                        }
Línea 1550... Línea 1562...
1550
                        'success' => false,
1562
                        'success' => false,
1551
                        'data' => 'ERROR_CACHE_INVALID'
1563
                        'data' => 'ERROR_CACHE_INVALID'
1552
                    ]);
1564
                    ]);
1553
                }
1565
                }
Línea -... Línea 1566...
-
 
1566
                
-
 
1567
                $locationMapper = LocationMapper::getInstance($this->adapter);
-
 
1568
                $countryMapper = CountryMapper::getInstance($this->adapter);
-
 
1569
                
-
 
1570
                
-
 
1571
                $networkMapper = NetworkMapper::getInstance($this->adapter);
-
 
1572
                $networkDefault = $networkMapper->fetchOneByDefault();
1554
                
1573
                
1555
                $userMapper = UserMapper::getInstance($this->adapter);
1574
                $userMapper = UserMapper::getInstance($this->adapter);
1556
                $userPasswordMapper = UserPasswordMapper::getInstance($this->adapter);
-
 
-
 
1575
                $userPasswordMapper = UserPasswordMapper::getInstance($this->adapter);
Línea -... Línea 1576...
-
 
1576
                
-
 
1577
 
-
 
1578
                $user_ids_in_default_network = [];
1557
                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
1579
                
1558
 
1580
                
1559
                $users_created = 0;
1581
                $users_created = 0;
1560
                $user_ids = [];
1582
                $user_ids = [];
1561
                foreach($records as $record)
1583
                foreach($records as $record)
Línea 1579... Línea 1601...
1579
                        $user->last_name = $last_name;
1601
                        $user->last_name = $last_name;
1580
                        $user->password = $password_hash;
1602
                        $user->password = $password_hash;
1581
                        $user->login_attempt = 0;
1603
                        $user->login_attempt = 0;
1582
                        $user->usertype_id = UserType::USER;
1604
                        $user->usertype_id = UserType::USER;
1583
                        $user->status = User::STATUS_ACTIVE;
1605
                        $user->status = User::STATUS_ACTIVE;
-
 
1606
                        $user->is_adult = $record['is_adult'] == 'y' ? User::IS_ADULT_YES : User::IS_ADULT_NO;
Línea 1584... Línea 1607...
1584
                        
1607
                        
1585
                        $result = $userMapper->insert($user);
1608
                        $result = $userMapper->insert($user);
-
 
1609
                        if($result) {
-
 
1610
                            $users_created++;
-
 
1611
                            
-
 
1612
                            $country = $countryMapper->fetchOneByCodeOrCountry($record['country']);
-
 
1613
                            if($country) {
-
 
1614
                            
-
 
1615
                                $location = new Location();
-
 
1616
                                $location->formatted_address = $country->country;
-
 
1617
                                $location->country = $country->country;
-
 
1618
                                if($locationMapper->insert($location)) {
-
 
1619
                                
-
 
1620
                                    $user->location_id = $location->id;
-
 
1621
                                    $userMapper->updateLocation($user);
-
 
1622
                                }
-
 
1623
                                
-
 
1624
                            }
1586
                        if($result) {
1625
                            
1587
                            $userPassword = new UserPassword();
1626
                            $userPassword = new UserPassword();
1588
                            $userPassword->user_id = $user->id;
1627
                            $userPassword->user_id = $user->id;
1589
                            $userPassword->password = $password_hash;
1628
                            $userPassword->password = $password_hash;
-
 
1629
                            $userPasswordMapper->insert($userPassword);
-
 
1630
                            
-
 
1631
                            
-
 
1632
                            if($currentNetwork->default == Network::DEFAULT_YES) {
-
 
1633
                                array_push($user_ids_in_default_network, $user->id);
-
 
1634
                            } else {
-
 
1635
                                
-
 
1636
                                
-
 
1637
                                
-
 
1638
                                if($user->is_adult == User::IS_ADULT_YES) {
-
 
1639
                                    
-
 
1640
                                    $userInDefaultNetwork = $userMapper->fetchOneByEmailAndNetworkId($user->email, $networkDefault->id);
-
 
1641
                                    if($userInDefaultNetwork) {
-
 
1642
             
-
 
1643
                                        array_push($user_ids_in_default_network, $userInDefaultNetwork->id);
-
 
1644
                                        
-
 
1645
                                        if($userInDefaultNetwork->email_verified == User::EMAIL_VERIFIED_NO || $userInDefaultNetwork->status != User::STATUS_ACTIVE) {
-
 
1646
                                            $userInDefaultNetwork->email_verified = User::EMAIL_VERIFIED_YES;
-
 
1647
                                            $userInDefaultNetwork->status != User::STATUS_ACTIVE;
-
 
1648
                                            
-
 
1649
                                            if(!$userMapper->update($userInDefaultNetwork)) {
-
 
1650
                                                continue;
-
 
1651
                                            }
-
 
1652
                                        }
-
 
1653
                                        
-
 
1654
                                        
-
 
1655
                                    } else {
-
 
1656
                                        $userInDefaultNetwork = new User();
-
 
1657
                                        $userInDefaultNetwork->network_id = $networkDefault->id;
-
 
1658
                                        $userInDefaultNetwork->blocked = User::BLOCKED_NO;
-
 
1659
                                        $userInDefaultNetwork->email_verified = User::EMAIL_VERIFIED_YES;
-
 
1660
                                        $userInDefaultNetwork->email = $email;
-
 
1661
                                        $userInDefaultNetwork->first_name = $first_name;
-
 
1662
                                        $userInDefaultNetwork->last_name = $last_name;
-
 
1663
                                        $userInDefaultNetwork->password = $password_hash;
-
 
1664
                                        $userInDefaultNetwork->login_attempt = 0;
-
 
1665
                                        $userInDefaultNetwork->usertype_id = UserType::USER;
-
 
1666
                                        $userInDefaultNetwork->status = User::STATUS_ACTIVE;
-
 
1667
                                        $userInDefaultNetwork->is_adult = User::IS_ADULT_YES;
-
 
1668
                                        $result = $userMapper->insert($userInDefaultNetwork);
-
 
1669
                                        if($result) {
-
 
1670
                                            array_push($user_ids_in_default_network, $userInDefaultNetwork->id);
-
 
1671
                                            
-
 
1672
                                            if($country) {
-
 
1673
                                                
-
 
1674
                                                $location = new Location();
-
 
1675
                                                $location->formatted_address = $country->country;
-
 
1676
                                                $location->country = $country->country;
-
 
1677
                                                if($locationMapper->insert($location)) {
-
 
1678
                                                    
-
 
1679
                                                    $userInDefaultNetwork->location_id = $location->id;
-
 
1680
                                                    $userMapper->updateLocation($userInDefaultNetwork);
-
 
1681
                                                }
-
 
1682
                                                
-
 
1683
                                            }
-
 
1684
                                            
-
 
1685
                                            
-
 
1686
                                            $userPassword = new UserPassword();
-
 
1687
                                            $userPassword->user_id = $userInDefaultNetwork->id;
-
 
1688
                                            $userPassword->password = $password_hash;
-
 
1689
                                            $userPasswordMapper->insert($userPassword);
-
 
1690
                                        }
-
 
1691
                                        
-
 
1692
                                    }
-
 
1693
                                    
-
 
1694
                                    
-
 
1695
                                }
-
 
1696
                                
-
 
1697
                                
-
 
1698
                            }
-
 
1699
                            
-
 
1700
                            
-
 
1701
                            
-
 
1702
                            
-
 
1703
                            
1590
                            $userPasswordMapper->insert($userPassword);
1704
                            
1591
                        } else {
1705
                        } else {
1592
                            continue;
1706
                            continue;
1593
                        }
1707
                        }
1594
                    } else {
1708
                    } else {
Línea 1600... Línea 1714...
1600
                                continue;
1714
                                continue;
1601
                            }
1715
                            }
1602
                        }
1716
                        }
1603
                    }
1717
                    }
Línea 1604... Línea -...
1604
                    
-
 
1605
                    if(!in_array($user->id, $user_ids)) {
1718
                    
1606
                        array_push($user_ids, $user->id);
-
 
-
 
1719
                    array_push($user_ids, $user->id);
1607
                    }
1720
                    
Línea -... Línea 1721...
-
 
1721
                }
-
 
1722
                
-
 
1723
                if($currentCompany) {
-
 
1724
                
-
 
1725
                    $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
-
 
1726
                    
1608
                }
1727
                    $company_users_created = 0;
1609
                
1728
                    
1610
                foreach($user_ids as $user_id)
1729
                    foreach($user_ids as $user_id)
1611
                {
1730
                    {
-
 
1731
                        $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($currentCompany->id, $user_id);
-
 
1732
                        if(!$companyUser) {
-
 
1733
                            
-
 
1734
                            $companyUser = new CompanyUser(); 
-
 
1735
                            $companyUser->company_id = $currentCompany->id; 
-
 
1736
                            $companyUser->user_id = $user_id; 
-
 
1737
                            $companyUser->backend = CompanyUser::BACKEND_NO;
-
 
1738
                            $companyUser->creator = CompanyUser::CREATOR_NO;
-
 
1739
                            $companyUser->owner = CompanyUser::OWNER_NO; 
-
 
1740
                            
-
 
1741
                            if($currentNetwork->default == Network::DEFAULT_YES) {
-
 
1742
                                $companyUser->status = CompanyUser::STATUS_ADMIN_WILL_ADD;
-
 
1743
                            } else {
-
 
1744
                                $companyUser->status = CompanyUser::STATUS_ACCEPTED;
-
 
1745
                            }
-
 
1746
                            
-
 
1747
                            if($companyUserMapper->insert($companyUser)) {
-
 
1748
                                $company_users_created++;
-
 
1749
                            }
Línea -... Línea 1750...
-
 
1750
                            
-
 
1751
                        }
-
 
1752
                        
-
 
1753
                    }
-
 
1754
                    
-
 
1755
                    $this->logger->info('Se agregaron ' . $users_created . '  usuarios  la empresa ' . $currentCompany->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
-
 
1756
                    
-
 
1757
                    
-
 
1758
                    
-
 
1759
                } else {
-
 
1760
                    
-
 
1761
                    $this->logger->info('Se agregaron ' . $users_created . ' usuarios a la red', ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
-
 
1762
                    
-
 
1763
                }
-
 
1764
                
-
 
1765
                if($user_ids_in_default_network) {
-
 
1766
                    $companyMapper = CompanyMapper::getInstance($this->adapter);
-
 
1767
                    $companyToFollower = $companyMapper->fetchOneDefaultForFollowers();
-
 
1768
                    
-
 
1769
                    $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
-
 
1770
                    
-
 
1771
                    $userToConnection = $userMapper->fetchOneDefaultForConnection();
-
 
1772
                    
-
 
1773
                    
-
 
1774
                    $connectionMapper = ConnectionMapper::getInstance($this->adapter);
1612
                    $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($currentCompany->id, $user_id);
1775
                    
-
 
1776
                    foreach($user_ids_in_default_network as $user_id)
-
 
1777
                    {
1613
                    if(!$companyUser) {
1778
                        if($userToConnection) {
1614
                        
1779
                            $connection = $connectionMapper->fetchOneByUserId1AndUserId2($user_id, $userToConnection->id);
1615
                        $companyUser = new CompanyUser(); 
1780
                            if(!$connection) {
1616
                        $companyUser->company_id = $currentCompany->id; 
1781
                                $connection = new Connection();
-
 
1782
                                $connection->request_from = $user_id;
1617
                        $companyUser->user_id = $user_id; 
1783
                                $connection->request_to = $userToConnection->id;
-
 
1784
                                $connection->status = Connection::STATUS_ACCEPTED;
1618
                        $companyUser->backend = CompanyUser::BACKEND_NO;
1785
                                
-
 
1786
                                $connectionMapper->insert($connection);
-
 
1787
                            } else {
-
 
1788
                                if($connection->status == Connection::STATUS_SENT) {
-
 
1789
                                    $connectionMapper->approve($connection);
Línea -... Línea 1790...
-
 
1790
                                }
-
 
1791
                            }
-
 
1792
                        }
-
 
1793
                        
-
 
1794
                        if($companyToFollower) {
-
 
1795
                            $companyFollower = $companyFollowerMapper->fetchOneByCompanyIdAndUserId($companyToFollower->id, $user_id);
-
 
1796
                            if(!$companyFollower) {
1619
                        $companyUser->creator = CompanyUser::CREATOR_NO;
1797
                                $companyFollower = new CompanyFollower();
-
 
1798
                                $companyFollower->company_id = $companyToFollower->id; 
1620
                        $companyUser->owner = CompanyUser::OWNER_NO; 
1799
                                $companyFollower->follower_id = $user_id;
1621
                        $companyUser->status = CompanyUser::STATUS_ADMIN_WILL_ADD;
1800
                                
Línea 1622... Línea 1801...
1622
                        
1801
                                $companyFollowerMapper->insert($companyFollower);
Línea -... Línea 1802...
-
 
1802
                                
-
 
1803
                            }
-
 
1804
                        }
1623
                        if($companyUserMapper->insert($companyUser)) {
1805
                        
Línea 1624... Línea -...
1624
                            $users_created++;
-
 
-
 
1806
                    }
Línea 1625... Línea 1807...
1625
                        }
1807
                    
1626
                        
1808
                    
1627
                    }
1809
                    
1628
                    
1810