Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 647 Rev 852
Línea 3... Línea 3...
3
 
3
 
Línea 4... Línea 4...
4
namespace LeadersLinked\Mapper;
4
namespace LeadersLinked\Mapper;
5
 
5
 
6
use LeadersLinked\Mapper\Common\MapperCommon;
6
use LeadersLinked\Mapper\Common\MapperCommon;
7
use Laminas\Db\Adapter\AdapterInterface;
7
use Laminas\Db\Adapter\AdapterInterface;
8
use LeadersLinked\Model\RecruitmentSelectionSelection;
8
use LeadersLinked\Model\RecruitmentSelectionVacancy;
9
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
9
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
10
use Laminas\Paginator\Paginator;
10
use Laminas\Paginator\Paginator;
Línea 88... Línea 88...
88
        $select->where->equalTo('company_id', $company_id);
88
        $select->where->equalTo('company_id', $company_id);
89
        $select->order('name');
89
        $select->order('name');
Línea 90... Línea 90...
90
        
90
        
91
        return $this->executeFetchAllObject($select, $prototype);
91
        return $this->executeFetchAllObject($select, $prototype);
-
 
92
    }
-
 
93
 
-
 
94
     /**
-
 
95
     *
-
 
96
     * @param int $company_id
-
 
97
     * @param int $topic_id
-
 
98
     * @return RecruitmentSelectionVacancy[]
-
 
99
     */
-
 
100
    public function fetchAllByCompanyIdAndVacancyId($company_id, $vancacy_id)
-
 
101
    {
-
 
102
        $prototype = new CompanyMicrolearningCapsule();
-
 
103
        
-
 
104
        $select = $this->sql->select(self::_TABLE);
-
 
105
        $select->where->equalTo('company_id', $company_id);
-
 
106
        $select->where->equalTo('topic_id', $vacancy_id);
-
 
107
        $select->order(['order', 'name']);
-
 
108
        
-
 
109
        //echo $select->getSqlString($this->adapter->platform); exit;
-
 
110
        
-
 
111
        return $this->executeFetchAllObject($select, $prototype);
Línea 92... Línea 112...
92
    }
112
    }
93
    
113
    
94
    
114