<?php
 namespace App\Reports\Sources\UsersAccess; class PopulateQuickColumns extends \App\Reports\Sources\PopulateAbstract { public function populate() :void { global $DBTOffices, $DBTDepartments, $DBTUserProfiles; $reportTable = $this->tableManager->getTableName(); $activeColumns = array_keys( $this->columnsManager->getStdColumns() ); $this->reportGenerationStatusUpdate('extractMainDataFromDb', 'updateUserDetails', 0); $reportCopyInfo = new \App\Reports\Db\ManageRecords\UpdateSimple($reportTable, $activeColumns); $reportCopyInfo->populateSimple($DBTOffices, 'officeName', 'idOffice', 'name'); $reportCopyInfo = new \App\Reports\Db\ManageRecords\UpdateSimple($reportTable, $activeColumns); $reportCopyInfo->populateSimple($DBTDepartments, 'departmentName', 'idDepartment', 'name'); $this->reportGenerationStatusUpdate('extractMainDataFromDb', 'updateAccessDetails', 0); $reportCopyInfo = new \App\Reports\Db\ManageRecords\UpdateSimple($reportTable, $activeColumns); $reportCopyInfo->populateSimple($DBTUserProfiles, 'profileName', 'idProfile', 'name'); if (in_array('sectionName', $activeColumns)) { \App\Loader_Lang::getInstance()->loadAppFile("_customLoad/usersAccess/options.lang.php"); $_LANG = \App\Loader_Lang::getInstance()->getGlobal(); } $reportCopyInfo = new \App\Reports\Db\ManageRecords\Update($reportTable, 'rep', $activeColumns); $reportCopyInfo->addCaseStructureColumn("sectionName", "idSection", (Array)$_LANG['usersAccess']['options']); $reportCopyInfo->addFilter("rep.type", "=", "option"); $reportCopyInfo->populate(); $reportCopyInfo = new \App\Reports\Db\ManageRecords\Update($reportTable, 'rep', $activeColumns); $reportCopyInfo->addCaseStructureColumn("sectionName", "idSection", (Array)$_LANG['menu']); $reportCopyInfo->addFilter("rep.type", "=", "section"); $reportCopyInfo->populate(); } } 