Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Form\Microlearning;

use Laminas\Form\Form;
use Laminas\Db\Adapter\AdapterInterface;
use LeadersLinked\Mapper\MicrolearningTopicMapper;
use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
use LeadersLinked\Mapper\QueryMapper;
use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
use Laminas\Db\Sql\Expression;
use LeadersLinked\Mapper\UserMapper;
use LeadersLinked\Model\User;

class StudentReportForm extends Form
{

    /**
     * 
     * @param AdapterInterface $adapter
     * @param int $company_id
     */
    public function __construct($adapter, $company_id) 
    {
        parent::__construct();
        $this->setInputFilter(new StudentReportFilter($adapter));
        
        $this->add([
            'name' => 'student_uuid',
            'type' => \Laminas\Form\Element\Select::class,
            'attributes' => [
                'id' => 'student_uuid',
            ],
            'options' => [
                'value_options' => $this->getSelectStudentOptions($adapter, $company_id)
            ]
        ]);
        
        
        

    }
    
    /**
     *
     * @param AdapterInterface $adapter
     */
    private function getSelectStudentOptions($adapter, $company_id)
    {
        
        $user_ids = [];
        $options = [];
        
        $mapper = QueryMapper::getInstance($adapter);
        $select = $mapper->getSql()->select();
        $select->columns(['user_id' => new Expression('DISTINCT(user_id)')]);
        $select->from(['tb1' => MicrolearningCapsuleUserMapper::_TABLE]);
        $select->where->equalTo('company_id', $company_id);
        
        $records = $mapper->fetchAll($select);
        foreach($records as $record)
        {
            array_push($user_ids, $record['user_id']);  
        }
        
        $mapper = QueryMapper::getInstance($adapter);
        $select = $mapper->getSql()->select();
        $select->columns(['uuid', 'first_name', 'last_name', 'email']);
        $select->from(['tb1' => UserMapper::_TABLE]);
        $select->where->in('id', $user_ids);
        $select->where->equalTo('status', User::STATUS_ACTIVE);
        $select->order('first_name ASC, last_name ASC');
        
        
        
        $records = $mapper->fetchAll($select);
        foreach($records as $record)
        {
            $options[ $record['uuid'] ] =  ucwords(strtolower(trim($record['first_name'] . '  ' . $record['last_name']))) . ' (' . strtolower($record['email']) .  ')';  
        }
        return $options;
    }
    
   
}