Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15394 Rev 15452
Línea 53... Línea 53...
53 
use LeadersLinked\Model\CompanyMicrolearningExtendUserSector;
 53 
use LeadersLinked\Model\CompanyMicrolearningExtendUserSector;
54 
use LeadersLinked\Model\CompanyMicrolearningExtendUserStudentType;
 54 
use LeadersLinked\Model\CompanyMicrolearningExtendUserStudentType;
55 
use LeadersLinked\Model\CompanyMicrolearningUser;
 55 
use LeadersLinked\Model\CompanyMicrolearningUser;
56 
use LeadersLinked\Mapper\ApplicationVariantMapper;
 56 
use LeadersLinked\Mapper\ApplicationVariantMapper;
57 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCountryMapper;
 57 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCountryMapper;
- 
 
 58 
use LeadersLinked\Model\CompanyMicrolearningExtendUserCountry;
Línea 58... Línea 59...
58 
 
 59 
 
59 
 
 60 
 
60 
class MicrolearningAccessForStudentsController extends AbstractActionController
 61 
class MicrolearningAccessForStudentsController extends AbstractActionController
Línea 729... Línea 730...
729
730
Línea 730... Línea 731...
730 
                    $emails = [];
 731 
                    $emails = [];
731
732
- 
 
 733 
                    foreach($records as $record)
- 
 
 734 
                    {
- 
 
 735 
                        /*
- 
 
 736 
                        A = Nombre
732 
                    foreach($records as $record)
 737 
                        B = Apellido
733 
                    {
 - 
 
- 
 
 738 
                        C = Email
- 
 
 739 
                        D = Contraseña
- 
 
 740 
                        E = Empresa
- 
 
 741 
                        F = Función
- 
 
 742 
                        G = Grupo
- 
 
 743 
                        H = Institución
- 
 
 744 
                        I = Programa
- 
 
 745 
                        J = Socio
- 
 
 746 
                        K = Sector
- 
 
 747 
                        L = Tipo de Estudiante
- 
 
 748 
                        M = País
Línea 734... Línea 749...
734 
                        //A = Nombre 	B = Apellidos	C = Email 	D = contraseña
 749 
                        N = Es adulto
735
750 
                        */
736
751
737
752
Línea 738... Línea -...
738 
                        $first_name = trim(filter_var($record['A'], FILTER_SANITIZE_STRING));
 - 
 
739 
                        $last_name = trim(filter_var($record['B'], FILTER_SANITIZE_STRING));
 753 
                        $first_name = trim(filter_var($record['A'], FILTER_SANITIZE_STRING));
740 
                        $email = trim(filter_var($record['C'], FILTER_SANITIZE_EMAIL));
 754 
                        $last_name = trim(filter_var($record['B'], FILTER_SANITIZE_STRING));
741 
                        $password = trim(filter_var($record['D'], FILTER_SANITIZE_STRING));
 - 
 
742
- 
 
743
755 
                        $email = trim(filter_var($record['C'], FILTER_SANITIZE_EMAIL));
744 
                        $employee = isset($record['E']) ? trim(filter_var($record['E'], FILTER_SANITIZE_STRING)) : '';
 756 
                        $password = trim(filter_var($record['D'], FILTER_SANITIZE_STRING));
745 
                        $adult = isset($record['F']) ? trim(filter_var($record['F'], FILTER_SANITIZE_STRING)) : '';
 757
746
758 
                        $company =  isset($record['E']) ? trim(filter_var($record['E'], FILTER_SANITIZE_STRING)) : '';
747
759 
                        $function = isset($record['F']) ? trim(filter_var($record['F'], FILTER_SANITIZE_STRING)) : '';
748 
                        $filterCountry =  isset($record['G']) ? trim(filter_var($record['G'], FILTER_SANITIZE_STRING)) : '';
 760 
                        $group = isset($record['G']) ? trim(filter_var($record['G'], FILTER_SANITIZE_STRING)) : '';
749 
                        $filterCompany =  isset($record['H']) ? trim(filter_var($record['H'], FILTER_SANITIZE_STRING)) : '';
 761 
                        $institution = isset($record['H']) ? trim(filter_var($record['H'], FILTER_SANITIZE_STRING)) : '';
750 
                        $filterFunction = isset($record['I']) ? trim(filter_var($record['I'], FILTER_SANITIZE_STRING)) : '';
 762 
                        $program = isset($record['I']) ? trim(filter_var($record['I'], FILTER_SANITIZE_STRING)) : '';
751 
                        $filterGroup = isset($record['J']) ? trim(filter_var($record['J'], FILTER_SANITIZE_STRING)) : '';
 - 
 
Línea -... Línea 763...
- 
 
 763 
                        $partner = isset($record['J']) ? trim(filter_var($record['J'], FILTER_SANITIZE_STRING)) : '';
752 
                        $filterInstitution = isset($record['K']) ? trim(filter_var($record['K'], FILTER_SANITIZE_STRING)) : '';
 764 
                        $sector = isset($record['K']) ? trim(filter_var($record['K'], FILTER_SANITIZE_STRING)) : '';
753 
                        $filterProgram = isset($record['L']) ? trim(filter_var($record['L'], FILTER_SANITIZE_STRING)) : '';
 765 
                        $studentType = isset($record['L']) ? trim(filter_var($record['L'], FILTER_SANITIZE_STRING)) : '';
754 
                        $filterPartner = isset($record['M']) ? trim(filter_var($record['M'], FILTER_SANITIZE_STRING)) : '';
 766 
                        $country =  isset($record['M']) ? trim(filter_var($record['M'], FILTER_SANITIZE_STRING)) : '';
755 
                        $filterSector = isset($record['N']) ? trim(filter_var($record['N'], FILTER_SANITIZE_STRING)) : '';
 767 
                        $isAdult = isset($record['N']) ? trim(filter_var($record['N'], FILTER_SANITIZE_STRING)) : '';
Línea 774... Línea 786...
774 
                            array_push($users, [
 786 
                            array_push($users, [
775 
                                'first_name' => $first_name,
 787 
                                'first_name' => $first_name,
776 
                                'last_name' => $last_name,
 788 
                                'last_name' => $last_name,
777 
                                'password'  => $password,
 789 
                                'password'  => $password,
778 
                                'email' => $email,
 790 
                                'email' => $email,
779 
                                'adult' => $adult,
 - 
 
780 
                                'employee' => $employee,
 - 
 
781 
                                'assigned_capsules' => $assigned_capsules,
791 
                                'assigned_capsules' => $assigned_capsules,
- 
 
 792 
                                'company' => $company,
782 
                                'filterCountry' => $filterCountry,
 793 
                                'function' => $function,
783 
                                'filterCompany' => $filterCompany,
 794 
                                'group' => $group,
784 
                                'filterFunction' => $filterFunction,
 795 
                                'institution' => $institution,
785 
                                'filterGroup' => $filterGroup,
 796 
                                'program' => $program,
786 
                                'filterInstitution' => $filterInstitution,
 797 
                                'partner' => $partner,
787 
                                'filterProgram' => $filterProgram,
 798 
                                'sector' => $sector,
788 
                                'filterPartner' => $filterPartner,
 799 
                                'studentType' => $studentType,
789 
                                'filterSector' => $filterSector,
 800 
                                'country' => $country,
790 
                                'filterStudentType' => $filterStudentType
 801 
                                'isAdult' => $isAdult,
791 
                            ]);
 802 
                            ]);
792 
                        }
 803 
                        }
Línea 878... Línea 889...
878 
                    $last_name = $record['last_name'];
 889 
                    $last_name = $record['last_name'];
879 
                    $password = $record['password'];
 890 
                    $password = $record['password'];
880 
                    $email = $record['email'];
 891 
                    $email = $record['email'];
Línea 881... Línea -...
881
- 
 
882
892
883 
                    $adult = $record['adult'];
 893
884 
                    $employee = $record['employee'];
 - 
 
885 
                    $filterCountry = $record['filterCountry'];
 894 
                    $company = $record['company'];
886
895 
                    $function = $record['function'];
887 
                    $filterCompany = $record['filterCompany'];
 896 
                    $group = $record['group'];
888 
                    $filterFunction = $record['filterFunction'];
 897 
                    $institution = $record['institution'];
889 
                    $filterGroup = $record['filterGroup'];
 898 
                    $program = $record['program'];
890 
                    $filterInstitution = $record['filterInstitution'];
 899 
                    $partner = $record['partner'];
891 
                    $filterProgram = $record['filterProgram'];
 900 
                    $sector = $record['sector'];
892 
                    $filterPartner = $record['filterPartner'];
 901 
                    $studentType = $record['studentType'];
- 
 
 902 
                    $country = $record['country'];
- 
 
 903 
                    $isAdult = $record['isAdult'];
Línea 893... Línea 904...
893 
                    $filterSector = $record['filterSector'];
 904
894 
                    $filterStudentType = $record['filterStudentType'];
 905
Línea 901... Línea 912...
901 
                        if($password) {
 912 
                        if($password) {
902 
                            $password_hash = password_hash($password, PASSWORD_DEFAULT);
 913 
                            $password_hash = password_hash($password, PASSWORD_DEFAULT);
Línea 903... Línea 914...
903
914
Línea -... Línea 915...
- 
 
 915 
                            $user = new User();
904 
                            $user = new User();
 916
905
917 
                            $user->network_id = $currentNetwork->id;
906 
                            $user->blocked = User::BLOCKED_NO;
 918 
                            $user->blocked = User::BLOCKED_NO;
907 
                            $user->email_verified = User::EMAIL_VERIFIED_YES;
 919 
                            $user->email_verified = User::EMAIL_VERIFIED_YES;
908 
                            $user->email = $email;
 920 
                            $user->email = $email;
909 
                            $user->first_name = $first_name;
 921 
                            $user->first_name = $first_name;
910 
                            $user->last_name = $last_name;
 922 
                            $user->last_name = $last_name;
911 
                            $user->password = $password_hash;
 923 
                            $user->password = $password_hash;
912 
                            $user->login_attempt = 0;
 924 
                            $user->login_attempt = 0;
- 
 
 925 
                            $user->usertype_id = UserType::USER;
Línea 913... Línea 926...
913 
                            $user->usertype_id = UserType::USER;
 926 
                            $user->status = User::STATUS_ACTIVE;
914 
                            $user->status = User::STATUS_ACTIVE;
 927 
                            $user->is_adult = $isAdult == User::IS_ADULT_YES;
915
928
916 
                            $result = $userMapper->insert($user);
 929 
                            $result = $userMapper->insert($user);
Línea 959... Línea 972...
959 
                        $extendUser->company_id = $currentCompany->id;
 972 
                        $extendUser->company_id = $currentCompany->id;
960 
                        $extendUser->user_id = $user->id;
 973 
                        $extendUser->user_id = $user->id;
961 
                    }
 974 
                    }
Línea 962... Línea 975...
962
975
963
976
Línea 964... Línea 977...
964 
                    if($filterCompany) {
 977 
                    if($company) {
965 
                        $record = $companyMicrolearningExtendUserCompanyMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterCompany);
 978 
                        $record = $companyMicrolearningExtendUserCompanyMapper->fetchOneByCompanyIdAndName($currentCompany->id, $company);
966
979
967 
                        if(!$record) {
 980 
                        if(!$record) {
Línea 968... Línea 981...
968 
                            $record = new CompanyMicrolearningExtendUserCompany();
 981 
                            $record = new CompanyMicrolearningExtendUserCompany();
969 
                            $record->company_id = $currentCompany->id;
 982 
                            $record->company_id = $currentCompany->id;
Línea 978... Línea 991...
978 
                        if($record->id) {
 991 
                        if($record->id) {
979 
                            $extendUser->extend_company_id = $record->id;
 992 
                            $extendUser->extend_company_id = $record->id;
980 
                        }
 993 
                        }
981 
                    }
 994 
                    }
Línea 982... Línea 995...
982
995
983 
                    if($filterFunction) {
 996 
                    if($function) {
984 
                        $record = $companyMicrolearningExtendUserFunctionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterFunction);
 997 
                        $record = $companyMicrolearningExtendUserFunctionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $function);
985 
                        if(!$record) {
 998 
                        if(!$record) {
986 
                            $record = new CompanyMicrolearningExtendUserFunction();
 999 
                            $record = new CompanyMicrolearningExtendUserFunction();
987 
                            $record->company_id = $currentCompany->id;
 1000 
                            $record->company_id = $currentCompany->id;
Línea 988... Línea 1001...
988 
                            $record->name = $filterFunction;
 1001 
                            $record->name = $function;
989
1002
Línea 990... Línea 1003...
990 
                            $companyMicrolearningExtendUserFunctionMapper->insert($record);
 1003 
                            $companyMicrolearningExtendUserFunctionMapper->insert($record);
991 
                        }
 1004 
                        }
992
1005
993 
                        if($record->id) {
 1006 
                        if($record->id) {
Línea 994... Línea 1007...
994 
                            $extendUser->extend_function_id = $record->id;
 1007 
                            $extendUser->extend_function_id = $record->id;
995 
                        }
 1008 
                        }
996 
                    }
 1009 
                    }
997
1010
998 
                    if($filterGroup) {
 1011 
                    if($group) {
999 
                        $record = $companyMicrolearningExtendUserGroupMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterGroup);
 1012 
                        $record = $companyMicrolearningExtendUserGroupMapper->fetchOneByCompanyIdAndName($currentCompany->id, $group);
Línea 1000... Línea 1013...
1000 
                        if(!$record) {
 1013 
                        if(!$record) {
1001 
                            $record = new CompanyMicrolearningExtendUserGroup();
 1014 
                            $record = new CompanyMicrolearningExtendUserGroup();
Línea 1002... Línea 1015...
1002 
                            $record->company_id = $currentCompany->id;
 1015 
                            $record->company_id = $currentCompany->id;
1003 
                            $record->name = $filterGroup;
 1016 
                            $record->name = $group;
1004
1017
1005 
                            $companyMicrolearningExtendUserGroupMapper->insert($record);
 1018 
                            $companyMicrolearningExtendUserGroupMapper->insert($record);
Línea 1006... Línea 1019...
1006 
                        }
 1019 
                        }
1007
1020
1008 
                        if($record->id) {
 1021 
                        if($record->id) {
1009 
                            $extendUser->extend_group_id = $record->id;
 1022 
                            $extendUser->extend_group_id = $record->id;
1010 
                        }
 1023 
                        }
1011 
                    }
 1024 
                    }
Línea 1012... Línea 1025...
1012
1025
1013 
                    if($filterInstitution) {
 1026 
                    if($institution) {
Línea 1014... Línea 1027...
1014 
                        $record = $companyMicrolearningExtendUserInstitutionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterInstitution);
 1027 
                        $record = $companyMicrolearningExtendUserInstitutionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $institution);
1015 
                        if(!$record) {
 1028 
                        if(!$record) {
1016 
                            $record = new CompanyMicrolearningExtendUserInstitution();
 1029 
                            $record = new CompanyMicrolearningExtendUserInstitution();
1017 
                            $record->company_id = $currentCompany->id;
 1030 
                            $record->company_id = $currentCompany->id;
Línea 1018... Línea 1031...
1018 
                            $record->name = $filterInstitution;
 1031 
                            $record->name = $institution;
1019
1032
1020 
                            $companyMicrolearningExtendUserInstitutionMapper->insert($record);
 1033 
                            $companyMicrolearningExtendUserInstitutionMapper->insert($record);
1021 
                        }
 1034 
                        }
1022
1035
1023 
                        if($record->id) {
 1036 
                        if($record->id) {
Línea 1024... Línea 1037...
1024 
                            $extendUser->extend_institution_id = $record->id;
 1037 
                            $extendUser->extend_institution_id = $record->id;
1025 
                        }
 1038 
                        }
Línea 1026... Línea 1039...
1026 
                    }
 1039 
                    }
1027
1040
1028 
                    if($filterProgram) {
 1041 
                    if($program) {
1029 
                        $record = $companyMicrolearningExtendUserProgramMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterProgram);
 1042 
                        $record = $companyMicrolearningExtendUserProgramMapper->fetchOneByCompanyIdAndName($currentCompany->id, $program);
Línea 1030... Línea 1043...
1030 
                        if(!$record) {
 1043 
                        if(!$record) {
Línea 1031... Línea 1044...
1031 
                            $record = new CompanyMicrolearningExtendUserProgram();
 1044 
                            $record = new CompanyMicrolearningExtendUserProgram();
1032 
                            $record->company_id = $currentCompany->id;
 1045 
                            $record->company_id = $currentCompany->id;
1033 
                            $record->name = $filterProgram;
 1046 
                            $record->name = $program;
1034
1047
1035 
                            $companyMicrolearningExtendUserProgramMapper->insert($record);
 1048 
                            $companyMicrolearningExtendUserProgramMapper->insert($record);
Línea 1036... Línea 1049...
1036 
                        }
 1049 
                        }
1037
1050
Línea 1038... Línea 1051...
1038 
                        if($record->id) {
 1051 
                        if($record->id) {
1039 
                            $extendUser->extend_program_id = $record->id;
 1052 
                            $extendUser->extend_program_id = $record->id;
1040 
                        }
 1053 
                        }
1041 
                    }
 1054 
                    }
Línea 1042... Línea 1055...
1042
1055
1043 
                    if($filterPartner) {
 1056 
                    if($partner) {
1044
1057
1045
1058
1046 
                        $record = $companyMicrolearningExtendUserPartnerMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterPartner);
 1059 
                        $record = $companyMicrolearningExtendUserPartnerMapper->fetchOneByCompanyIdAndName($currentCompany->id, $partner);
1047 
                        if(!$record) {
 1060 
                        if(!$record) {
Línea 1048... Línea 1061...
1048 
                            $record = new CompanyMicrolearningExtendUserPartner();
 1061 
                            $record = new CompanyMicrolearningExtendUserPartner();
1049 
                            $record->company_id = $currentCompany->id;
 1062 
                            $record->company_id = $currentCompany->id;
Línea 1050... Línea 1063...
1050 
                            $record->name = $filterPartner;
 1063 
                            $record->name = $partner;
1051
1064
1052 
                            $companyMicrolearningExtendUserPartnerMapper->insert($record);
 1065 
                            $companyMicrolearningExtendUserPartnerMapper->insert($record);
1053 
                        }
 1066 
                        }
Línea 1054... Línea 1067...
1054
1067
1055 
                        if($record->id) {
 1068 
                        if($record->id) {
1056 
                            $extendUser->extend_partner_id = $record->id;
 1069 
                            $extendUser->extend_partner_id = $record->id;
1057 
                        }
 1070 
                        }
1058 
                    }
 1071 
                    }
1059
1072
Línea 1060... Línea 1073...
1060 
                    if($filterSector) {
 1073 
                    if($sector) {
1061 
                        $record = $companyMicrolearningExtendUserSectorMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterSector);
 1074 
                        $record = $companyMicrolearningExtendUserSectorMapper->fetchOneByCompanyIdAndName($currentCompany->id, $sector);
1062 
                        if(!$record) {
 1075 
                        if(!$record) {
1063 
                            $record = new CompanyMicrolearningExtendUserSector();
 1076 
                            $record = new CompanyMicrolearningExtendUserSector();
1064 
                            $record->company_id = $currentCompany->id;
 1077 
                            $record->company_id = $currentCompany->id;
1065 
                            $record->name = $filterSector;
 1078 
                            $record->name = $sector;
Línea -... Línea 1079...
- 
 
 1079
- 
 
 1080 
                            $companyMicrolearningExtendUserSectorMapper->insert($record);
- 
 
 1081 
                        }
- 
 
 1082
- 
 
 1083 
                        if($record->id) {
- 
 
 1084 
                            $extendUser->extend_sector_id = $record->id;
- 
 
 1085 
                        }
- 
 
 1086 
                    }
- 
 
 1087
1066
1088 
                    if($studentType) {
- 
 
 1089 
                        $record = $companyMicrolearningExtendUserStudentTypeMapper->fetchOneByCompanyIdAndName($currentCompany->id, $studentType);
- 
 
 1090 
                        if(!$record) {
- 
 
 1091 
                            $record = new CompanyMicrolearningExtendUserStudentType();
- 
 
 1092 
                            $record->company_id = $currentCompany->id;
- 
 
 1093 
                            $record->name = $studentType;
Línea 1067... Línea 1094...
1067 
                            $companyMicrolearningExtendUserSectorMapper->insert($record);
 1094
1068 
                        }
 1095 
                            $companyMicrolearningExtendUserStudentTypeMapper->insert($record);