Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15387 Rev 15388
Línea 49... Línea 49...
49 
use LeadersLinked\Model\User;
 49 
use LeadersLinked\Model\User;
50 
use LeadersLinked\Mapper\CompanyUserMapper;
 50 
use LeadersLinked\Mapper\CompanyUserMapper;
51 
use Laminas\Db\Sql\Select;
 51 
use Laminas\Db\Sql\Select;
52 
use LeadersLinked\Form\StudentReportForm;
 52 
use LeadersLinked\Form\StudentReportForm;
53 
use LeadersLinked\Model\UserType;
 53 
use LeadersLinked\Model\UserType;
- 
 
 54 
use LeadersLinked\Model\CompanyUser;
Línea 54... Línea 55...
54 
 
 55 
 
55 
 
 56 
 
Línea 143... Línea 144...
143
144
Línea 144... Línea 145...
144 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 145 
                $queryMapper = QueryMapper::getInstance($this->adapter);
Línea -... Línea 146...
- 
 
 146
- 
 
 147 
                if($currentCompany) {
- 
 
 148
- 
 
 149 
                    $user_ids = [];
- 
 
 150
- 
 
 151 
                    $select = $queryMapper->getSql()->select(CompanyUserMapper::_TABLE);
- 
 
 152 
                    $select->columns(['user_id']);
145
153 
                    $select->where->equalTo('company_id', $currentCompany->id);
- 
 
 154 
                    $select->where->equalTo('status', CompanyUser::STATUS_ACCEPTED);
- 
 
 155
- 
 
 156 
                    $records = $queryMapper->fetchAll($select);
- 
 
 157 
                    foreach($records as $record)
- 
 
 158 
                    {
- 
 
 159 
                        if(!in_array($record['user_id'], $user_ids)) {
- 
 
 160 
                            array_push($user_ids , $record['user_id']);
- 
 
 161 
                        }
- 
 
 162 
                    }
146 
                if($currentCompany) {
 163
147
164
- 
 
 165 
                    $select = $queryMapper->getSql()->select(CompanyMicrolearningCapsuleUserMapper::_TABLE);
- 
 
 166 
                    $select->columns(['user_id']);
- 
 
 167 
                    $select->where->equalTo('company_id', $currentCompany->id);
- 
 
 168 
                    $select->where->in('access', [CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED, CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD]);
- 
 
 169 
                    $records = $queryMapper->fetchAll($select);
- 
 
 170 
                    foreach($records as $record)
- 
 
 171 
                    {
- 
 
 172 
                        if(!in_array($record['user_id'], $user_ids)) {
- 
 
 173 
                            array_push($user_ids , $record['user_id']);
- 
 
 174 
                        }
148 
                    $select = $queryMapper->getSql()->select();
 175 
                    }
- 
 
 176
149 
                    $select->columns(['status', 'backend', 'creator']);
 177
150 
                    $select->from(['tb1' => CompanyUserMapper::_TABLE]);
 178 
                    $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
151 
                    $select->join(['tb2' => UserMapper::_TABLE] , 'tb1.user_id = tb2.id', [
 - 
 
152 
                        'id', 'uuid', 'first_name', 'last_name', 'email', 'last_activity_on', 'image',
 179 
                    $select->columns([
Línea 153... Línea 180...
153 
                        'blocked', 'login_attempt', 'email_verified'
 180 
                        'id', 'uuid', 'first_name', 'last_name', 'email', 'last_activity_on', 'image',
154
181 
                        'blocked', 'login_attempt', 'email_verified'
155 
                    ]);
 182 
                    ]);
156
183
157 
                    $select->where->equalTo('tb1.company_id', $currentCompany->id);
 184 
                    $select->where->in('id', $user_ids);
158 
                    $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
 185 
                    $select->where->equalTo('status', User::STATUS_ACTIVE);
159 
                    $select->where->equalTo('tb2.blocked', User::BLOCKED_YES);
 186 
                    $select->where->equalTo('blocked', User::BLOCKED_YES);
160 
                    $select->where->equalTo('tb2.email_verified', User::EMAIL_VERIFIED_YES );
 187 
                    $select->where->equalTo('email_verified', User::EMAIL_VERIFIED_YES );
161 
                    $select->where->equalTo('tb2.network_id', $currentUser->network_id);
 188 
                    $select->where->equalTo('network_id', $currentUser->network_id);
162 
                    $select->where->in('tb2.usertype_id', [UserType::ADMIN, UserType::USER]);
 189 
                    $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);
163 
                    $select->order('first_name ASC, last_name ASC');
 190 
                    $select->order('first_name ASC, last_name ASC');
Línea 250... Línea 277...
250
277
Línea 251... Línea 278...
251 
            $queryMapper = QueryMapper::getInstance($this->adapter);
 278 
            $queryMapper = QueryMapper::getInstance($this->adapter);
Línea -... Línea 279...
- 
 
 279
- 
 
 280 
            if($currentCompany) {
- 
 
 281
- 
 
 282 
                $user_ids = [];
- 
 
 283
- 
 
 284 
                $select = $queryMapper->getSql()->select(CompanyUserMapper::_TABLE);
- 
 
 285 
                $select->columns(['user_id']);
252
286 
                $select->where->equalTo('company_id', $currentCompany->id);
- 
 
 287 
                $select->where->equalTo('status', CompanyUser::STATUS_ACCEPTED);
- 
 
 288
- 
 
 289 
                $records = $queryMapper->fetchAll($select);
- 
 
 290 
                foreach($records as $record)
- 
 
 291 
                {
- 
 
 292 
                    if(!in_array($record['user_id'], $user_ids)) {
- 
 
 293 
                        array_push($user_ids , $record['user_id']);
- 
 
 294 
                    }
- 
 
 295 
                }
253 
            if($currentCompany) {
 296
254
297
- 
 
 298 
                $select = $queryMapper->getSql()->select(CompanyMicrolearningCapsuleUserMapper::_TABLE);
- 
 
 299 
                $select->columns(['user_id']);
- 
 
 300 
                $select->where->equalTo('company_id', $currentCompany->id);
- 
 
 301 
                $select->where->in('access', [CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED, CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD]);
- 
 
 302 
                $records = $queryMapper->fetchAll($select);
- 
 
 303 
                foreach($records as $record)
- 
 
 304 
                {
- 
 
 305 
                    if(!in_array($record['user_id'], $user_ids)) {
- 
 
 306 
                        array_push($user_ids , $record['user_id']);
- 
 
 307 
                    }
255 
                $select = $queryMapper->getSql()->select();
 308 
                }
- 
 
 309
256 
                $select->columns(['status', 'backend', 'creator']);
 310
257 
                $select->from(['tb1' => CompanyUserMapper::_TABLE]);
 311 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
258 
                $select->join(['tb2' => UserMapper::_TABLE] , 'tb1.user_id = tb2.id', [
 - 
 
259 
                    'id', 'uuid', 'first_name', 'last_name', 'email', 'last_activity_on', 'image',
 312 
                $select->columns([
Línea 260... Línea 313...
260 
                    'blocked', 'login_attempt', 'email_verified'
 313 
                    'id', 'uuid', 'first_name', 'last_name', 'email', 'last_activity_on', 'image',
261
314 
                    'blocked', 'login_attempt', 'email_verified'
262 
                ]);
 315 
                ]);
263
316
264 
                $select->where->equalTo('tb1.company_id', $currentCompany->id);
 317 
                $select->where->in('id', $user_ids);
265 
                $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
 318 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
266 
                $select->where->equalTo('tb2.blocked', User::BLOCKED_YES);
 319 
                $select->where->equalTo('blocked', User::BLOCKED_YES);
267 
                $select->where->equalTo('tb2.email_verified', User::EMAIL_VERIFIED_YES );
 320 
                $select->where->equalTo('email_verified', User::EMAIL_VERIFIED_YES );
268 
                $select->where->equalTo('tb2.network_id', $currentUser->network_id);
 321 
                $select->where->equalTo('network_id', $currentUser->network_id);
269 
                $select->where->in('tb2.usertype_id', [UserType::ADMIN, UserType::USER]);
 322 
                $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);
270 
                $select->order('first_name ASC, last_name ASC');
 323 
                $select->order('first_name ASC, last_name ASC');