Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 16932 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 16932 Rev 17002
Línea 12... Línea 12...
12 
use Laminas\View\Model\JsonModel;
 12 
use Laminas\View\Model\JsonModel;
13 
use LeadersLinked\Form\ExtendUserMicrolearningForm;
 13 
use LeadersLinked\Form\ExtendUserMicrolearningForm;
14 
use LeadersLinked\Mapper\QueryMapper;
 14 
use LeadersLinked\Mapper\QueryMapper;
15 
use LeadersLinked\Mapper\UserMapper;
 15 
use LeadersLinked\Mapper\UserMapper;
16 
use Laminas\Db\Sql\Expression;
 16 
use Laminas\Db\Sql\Expression;
17 
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
 17 
use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
18 
use LeadersLinked\Model\CompanyMicrolearningCapsuleUser;
 18 
use LeadersLinked\Model\MicrolearningCapsuleUser;
19 
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
 19 
use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
20 
use LeadersLinked\Mapper\CompanyMicrolearningUserProgressMapper;
 20 
use LeadersLinked\Mapper\MicrolearningUserProgressMapper;
21 
use LeadersLinked\Mapper\CompanyMicrolearningSlideMapper;
 21 
use LeadersLinked\Mapper\MicrolearningSlideMapper;
22 
use LeadersLinked\Mapper\CompanyMicrolearningUserLogMapper;
 22 
use LeadersLinked\Mapper\MicrolearningUserLogMapper;
23 
use Google\Service\Classroom\Student;
 23 
use Google\Service\Classroom\Student;
24 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCompanyMapper;
 24 
use LeadersLinked\Mapper\MicrolearningExtendUserCompanyMapper;
25 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserFunctionMapper;
 25 
use LeadersLinked\Mapper\MicrolearningExtendUserFunctionMapper;
26 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserGroupMapper;
 26 
use LeadersLinked\Mapper\MicrolearningExtendUserGroupMapper;
27 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserInstitutionMapper;
 27 
use LeadersLinked\Mapper\MicrolearningExtendUserInstitutionMapper;
28 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserProgramMapper;
 28 
use LeadersLinked\Mapper\MicrolearningExtendUserProgramMapper;
29 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserPartnerMapper;
 29 
use LeadersLinked\Mapper\MicrolearningExtendUserPartnerMapper;
30 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserSectorMapper;
 30 
use LeadersLinked\Mapper\MicrolearningExtendUserSectorMapper;
31 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserStudentTypeMapper;
 31 
use LeadersLinked\Mapper\MicrolearningExtendUserStudentTypeMapper;
32 
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserMapper;
 32 
use LeadersLinked\Mapper\MicrolearningExtendUserMapper;
33 
use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
 33 
use LeadersLinked\Mapper\MicrolearningTopicMapper;
34 
use LeadersLinked\Mapper\DeviceMapper;
 34 
use LeadersLinked\Mapper\DeviceMapper;
35 
use LeadersLinked\Model\Application;
 35 
use LeadersLinked\Model\Application;
36 
use LeadersLinked\Mapper\CompanyMicrolearningUserMapper;
 36 
use LeadersLinked\Mapper\MicrolearningUserMapper;
37 
use LeadersLinked\Model\CompanyMicrolearningExtendUser;
 37 
use LeadersLinked\Model\MicrolearningExtendUser;
38 
use LeadersLinked\Form\TopicCapsuleForm;
 38 
use LeadersLinked\Form\TopicCapsuleForm;
39 
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleCommentMapper;
 39 
use LeadersLinked\Mapper\MicrolearningCapsuleCommentMapper;
40 
use Laminas\Hydrator\ArraySerializableHydrator;
 40 
use Laminas\Hydrator\ArraySerializableHydrator;
41 
use Laminas\Db\ResultSet\HydratingResultSet;
 41 
use Laminas\Db\ResultSet\HydratingResultSet;
42 
use Laminas\Paginator\Adapter\DbSelect;
 42 
use Laminas\Paginator\Adapter\DbSelect;
43 
use Laminas\Paginator\Paginator;
 43 
use Laminas\Paginator\Paginator;
44 
use LeadersLinked\Model\CompanyMicrolearningUserProgress;
 44 
use LeadersLinked\Model\MicrolearningUserProgress;
45 
use PhpOffice\PhpSpreadsheet\IOFactory;
 45 
use PhpOffice\PhpSpreadsheet\IOFactory;
46 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
 46 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
47 
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
 47 
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
48 
use PhpOffice\PhpSpreadsheet\Calculation\TextData\Replace;
 48 
use PhpOffice\PhpSpreadsheet\Calculation\TextData\Replace;
49 
use LeadersLinked\Form\TopicReportForm;
 49 
use LeadersLinked\Form\TopicReportForm;
Línea 172... Línea 172...
172 
                            array_push($user_ids, $record['user_id']);
 172 
                            array_push($user_ids, $record['user_id']);
173 
                        }
 173 
                        }
174 
                    }
 174 
                    }
Línea 175... Línea 175...
175 
 
 175 
 
176 
 
 176 
 
177 
                    $select = $queryMapper->getSql()->select(CompanyMicrolearningCapsuleUserMapper::_TABLE);
 177 
                    $select = $queryMapper->getSql()->select(MicrolearningCapsuleUserMapper::_TABLE);
178 
                    $select->columns(['user_id']);
 178 
                    $select->columns(['user_id']);
179 
                    $select->where->equalTo('company_id', $currentCompany->id);
 179 
                    $select->where->equalTo('company_id', $currentCompany->id);
180 
                    $select->where->in('access', [CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED, CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD]);
 180 
                    $select->where->in('access', [MicrolearningCapsuleUser::ACCESS_UNLIMITED, MicrolearningCapsuleUser::ACCESS_PAY_PERIOD]);
181 
                    $records = $queryMapper->fetchAll($select);
 181 
                    $records = $queryMapper->fetchAll($select);
182 
                    foreach ($records as $record) {
 182 
                    foreach ($records as $record) {
183 
                        if (!in_array($record['user_id'], $user_ids)) {
 183 
                        if (!in_array($record['user_id'], $user_ids)) {
Línea 316... Línea 316...
316 
                        array_push($user_ids, $record['user_id']);
 316 
                        array_push($user_ids, $record['user_id']);
317 
                    }
 317 
                    }
318 
                }
 318 
                }
Línea 319... Línea 319...
319 
 
 319 
 
320 
 
 320 
 
321 
                $select = $queryMapper->getSql()->select(CompanyMicrolearningCapsuleUserMapper::_TABLE);
 321 
                $select = $queryMapper->getSql()->select(MicrolearningCapsuleUserMapper::_TABLE);
322 
                $select->columns(['user_id']);
 322 
                $select->columns(['user_id']);
323 
                $select->where->equalTo('company_id', $currentCompany->id);
 323 
                $select->where->equalTo('company_id', $currentCompany->id);
324 
                $select->where->in('access', [CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED, CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD]);
 324 
                $select->where->in('access', [MicrolearningCapsuleUser::ACCESS_UNLIMITED, MicrolearningCapsuleUser::ACCESS_PAY_PERIOD]);
325 
                $records = $queryMapper->fetchAll($select);
 325 
                $records = $queryMapper->fetchAll($select);
326 
                foreach ($records as $record) {
 326 
                foreach ($records as $record) {
327 
                    if (!in_array($record['user_id'], $user_ids)) {
 327 
                    if (!in_array($record['user_id'], $user_ids)) {