Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 1230 Rev 1231
Línea 228... Línea 228...
228 
     */
 228 
     */
229 
    public function fetchAllDataTableByCompanyId($companyId, $search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
 229 
    public function fetchAllDataTableByCompanyId($companyId, $search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
230 
    {
 230 
    {
231 
        $prototype = new RecruitmentSelectionInterview();
 231 
        $prototype = new RecruitmentSelectionInterview();
232 
        $select = $this->sql->select();
 232 
        $select = $this->sql->select();
233 
        $select->columns(['uuid']);
 233 
        $select->columns(['uuid', 'company_id']);
234 
        $select->from(['i' => self::_TABLE]);
 234 
        $select->from(['i' => self::_TABLE]);
235 
        $select->join(['c' => RecruitmentSelectionCandidateMapper::_TABLE], "i.candidate_id = c.id", ['first_name']);
 235 
        $select->join(['c' => RecruitmentSelectionCandidateMapper::_TABLE], "i.candidate_id = c.id", ['first_name']);
236 
        $select->where->equalTo('company_id', $companyId);
 236 
        $select->where->equalTo('company_id', $companyId);
237 
        echo $select->getSqlString($this->adapter->platform); exit;
 237 
        echo $select->getSqlString($this->adapter->platform); exit;