Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 2 Rev 129
Línea 29... Línea 29...
29 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserSectorMapper;
 29 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserSectorMapper;
30 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserStudentTypeMapper;
 30 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserStudentTypeMapper;
31 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserMapper;
 31 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserMapper;
32 
use LeadersLinked\Mapper\DeviceMapper;
 32 
use LeadersLinked\Mapper\DeviceMapper;
33 
use LeadersLinked\Model\Application;
 33 
use LeadersLinked\Model\Application;
- 
 
 34 
use LeadersLinked\Mapper\CompanyMicrolearningUserMapper;
- 
 
 35 
use LeadersLinked\Model\CompanyMicrolearningExtendUser;
Línea 34... Línea 36...
34 
 
 36 
 
35 
 
 37 
 
36 
class MicrolearningReportsController extends AbstractActionController
 38 
class MicrolearningReportsController extends AbstractActionController
Línea 712... Línea 714...
712 
                }
 714 
                }
713 
            }
 715 
            }
Línea 714... Línea 716...
714
716
Línea -... Línea 717...
- 
 
 717 
            if($isJson) {
- 
 
 718
- 
 
 719
- 
 
 720 
                $company_id = filter_var($this->params()->fromQuery('company_id', ''), FILTER_SANITIZE_STRING);
- 
 
 721 
                $function_id = filter_var($this->params()->fromQuery('function_id', ''), FILTER_SANITIZE_STRING);
- 
 
 722 
                $group_id = filter_var($this->params()->fromQuery('group_id', ''), FILTER_SANITIZE_STRING);
- 
 
 723 
                $institution_id = filter_var($this->params()->fromQuery('institution_id', ''), FILTER_SANITIZE_STRING);
- 
 
 724 
                $program_id = filter_var($this->params()->fromQuery('program_id', ''), FILTER_SANITIZE_STRING);
- 
 
 725 
                $partner_id = filter_var($this->params()->fromQuery('partner_id', ''), FILTER_SANITIZE_STRING);
- 
 
 726 
                $sector_id = filter_var($this->params()->fromQuery('sector_id', ''), FILTER_SANITIZE_STRING);
- 
 
 727 
                $student_type_id = filter_var($this->params()->fromQuery('student_type_id', ''), FILTER_SANITIZE_STRING);
- 
 
 728
- 
 
 729
- 
 
 730 
                if($company_id) {
- 
 
 731 
                    $extendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
- 
 
 732 
                    $extendUserCompany = $extendUserCompanyMapper->fetchOneByUuid($company_id);
- 
 
 733
- 
 
 734 
                    if($extendUserCompany) {
- 
 
 735 
                        $company_id = $extendUserCompany->id;
- 
 
 736 
                    } else {
- 
 
 737 
                        $company_id = 0;
- 
 
 738 
                    }
- 
 
 739 
                }
- 
 
 740
- 
 
 741 
                if($function_id) {
- 
 
 742 
                    $extendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
- 
 
 743 
                    $extendUserFunction = $extendUserFunctionMapper->fetchOneByUuid($function_id);
- 
 
 744
- 
 
 745 
                    if($extendUserFunction) {
- 
 
 746 
                        $function_id = $extendUserFunction->id;
- 
 
 747 
                    } else {
- 
 
 748 
                        $function_id = 0;
- 
 
 749 
                    }
- 
 
 750 
                }
- 
 
 751
- 
 
 752 
                if($group_id) {
- 
 
 753 
                    $extendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
- 
 
 754 
                    $extendUserGroup = $extendUserGroupMapper->fetchOneByUuid($group_id);
- 
 
 755
- 
 
 756 
                    if($extendUserGroup) {
- 
 
 757 
                        $group_id = $extendUserGroup->id;
- 
 
 758 
                    } else {
- 
 
 759 
                        $group_id = 0;
- 
 
 760 
                    }
- 
 
 761 
                }
- 
 
 762
- 
 
 763 
                if($institution_id) {
- 
 
 764 
                    $extendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
- 
 
 765 
                    $extendUserInstitution = $extendUserInstitutionMapper->fetchOneByUuid($institution_id);
- 
 
 766 
                    if($extendUserInstitution) {
- 
 
 767 
                        $institution_id = $extendUserInstitution->id;
- 
 
 768 
                    } else {
- 
 
 769 
                        $institution_id = 0;
- 
 
 770 
                    }
- 
 
 771 
                }
- 
 
 772
- 
 
 773 
                if($program_id) {
- 
 
 774 
                    $extendUserProgramMapper = CompanyMicrolearningExtendUserProgramMapper::getInstance($this->adapter);
- 
 
 775 
                    $extendUserProgram = $extendUserProgramMapper->fetchOneByUuid($program_id);
- 
 
 776
- 
 
 777 
                    if($extendUserProgram) {
- 
 
 778 
                        $program_id = $extendUserProgram->id;
- 
 
 779 
                    } else {
- 
 
 780 
                        $program_id = 0;
- 
 
 781 
                    }
- 
 
 782
- 
 
 783
- 
 
 784 
                }
- 
 
 785
- 
 
 786 
                if($partner_id) {
- 
 
 787 
                    $extendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
- 
 
 788 
                    $extendUserPartner = $extendUserPartnerMapper->fetchOneByUuid($partner_id);
- 
 
 789 
                    if($extendUserPartner) {
- 
 
 790 
                        $partner_id = $extendUserPartner;
- 
 
 791 
                    } else {
- 
 
 792 
                        $partner_id = 0;
- 
 
 793 
                    }
- 
 
 794 
                }
- 
 
 795
- 
 
 796 
                if($sector_id) {
- 
 
 797 
                    $extendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
- 
 
 798 
                    $extendUserSector = $extendUserSectorMapper->fetchOneByUuid($sector_id);
- 
 
 799 
                    if($extendUserSector) {
- 
 
 800 
                        $sector_id = $extendUserSector->id;
- 
 
 801 
                    } else {
- 
 
 802 
                        $sector_id = 0;
- 
 
 803 
                    }
- 
 
 804 
                }
- 
 
 805
- 
 
 806 
                if($student_type_id) {
- 
 
 807 
                    $extendUserStudentTypeMapper = CompanyMicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
- 
 
 808 
                    $extendUserStudentType = $extendUserStudentTypeMapper->fetchOneByUuid($student_type_id);
- 
 
 809
- 
 
 810 
                    if($extendUserStudentType) {
- 
 
 811 
                        $student_type_id = $extendUserStudentType->id;
- 
 
 812 
                    } else {
- 
 
 813 
                        $student_type_id = 0;
- 
 
 814 
                    }
- 
 
 815 
                }
- 
 
 816
- 
 
 817
- 
 
 818
- 
 
 819 
                /*
- 
 
 820 
                echo 'company_id 1 =  '. $company_id . PHP_EOL;
- 
 
 821 
                echo 'function_id 1 =  '. $function_id . PHP_EOL;
- 
 
 822 
                echo 'group_id 1 =  '. $group_id . PHP_EOL;
- 
 
 823 
                echo 'institution_id 1 =  '. $institution_id . PHP_EOL;
- 
 
 824 
                echo 'program_id 1 =  '. $program_id . PHP_EOL;
- 
 
 825 
                echo 'partner_id 1 =  '. $partner_id . PHP_EOL;
- 
 
 826 
                echo 'sector_id 1 =  '. $sector_id . PHP_EOL;
- 
 
 827 
                echo 'student_type_id 1 =  '. $student_type_id . PHP_EOL;
- 
 
 828 
                exit;
- 
 
 829 
                */
715 
            if($isJson) {
 830
716
831
Línea 717... Línea 832...
717 
                $date = date('Y-m-d');
 832 
                $date = date('Y-m-d');
Línea 731... Línea 846...
731
846
Línea 732... Línea 847...
732 
                //echo $select->getSqlString($this->adapter->platform); exit;
 847 
                //echo $select->getSqlString($this->adapter->platform); exit;
733
848
734 
                $select = $queryMapper->getSql()->select();
 849 
                $select = $queryMapper->getSql()->select();
- 
 
 850 
                $select->columns(['id' , 'uuid', 'first_name', 'last_name', 'email']);
- 
 
 851 
                $select->from([ 'u' => UserMapper::_TABLE]);
- 
 
 852 
                if( $company_id || $function_id  || $group_id || $institution_id || $program_id || $partner_id ||  $sector_id || $student_type_id ) {
- 
 
 853
- 
 
 854 
                    $select->join(['e' => CompanyMicrolearningExtendUserMapper::_TABLE], 'e.user_id = u.id');
- 
 
 855
735 
                $select->columns(['id' , 'uuid', 'first_name', 'last_name', 'email']);
 856 
                }
- 
 
 857
736 
                $select->from(UserMapper::_TABLE);
 858 
                $select->where->in('u.id', $selectCapsuleUser);
- 
 
 859 
                if($company_id) {
- 
 
 860 
                    $select->where->equalTo('e.extend_company_id', $company_id);
- 
 
 861 
                }
- 
 
 862
- 
 
 863 
                if($function_id) {
- 
 
 864 
                    $select->where->equalTo('e.extend_function_id', $function_id);
- 
 
 865
- 
 
 866 
                }
- 
 
 867 
                if($group_id) {
Línea -... Línea 868...
- 
 
 868 
                    $select->where->equalTo('e.extend_group_id', $group_id);
- 
 
 869 
                }
- 
 
 870
- 
 
 871 
                if($institution_id) {
- 
 
 872 
                    $select->where->equalTo('e.extend_institution_id', $institution_id);
- 
 
 873 
                }
- 
 
 874
- 
 
 875 
                if($program_id) {
- 
 
 876 
                    $select->where->equalTo('e.extend_program_id', $program_id);
- 
 
 877 
                }
- 
 
 878
- 
 
 879 
                if($partner_id) {
- 
 
 880 
                    $select->where->equalTo('e.extend_partner_id', $partner_id);
- 
 
 881 
                }
- 
 
 882
- 
 
 883 
                if($sector_id) {
- 
 
 884 
                    $select->where->equalTo('e.extend_sector_id', $sector_id);
- 
 
 885 
                }
- 
 
 886
- 
 
 887 
                if($student_type_id) {
- 
 
 888 
                    $select->where->equalTo('e.extend_student_type_id', $student_type_id);
Línea 737... Línea 889...
737 
                $select->where->in('id', $selectCapsuleUser);
 889 
                }
738 
                $select->order(['first_name', 'last_name']);
 890 
                $select->order(['u.first_name', 'u.last_name']);
739
891
Línea 784... Línea 936...
784
936
785
937
786
938
- 
 
 939 
                return new JsonModel([
Línea 787... Línea 940...
787 
                return new JsonModel([
 940 
                    'success' => true,
Línea 788... Línea 941...
788 
                    'success' => true,
 941 
                    'data' => $students,