WebSVN – LeadersLinked - Antes de SPA – Diff – /module/LeadersLinked/src/Mapper/RecruitmentSelectionInterviewMapper.php

      * @return Paginator
      */
     public function fetchAllDataTableByCompanyId($companyId, $search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
+    {
         $prototype = new RecruitmentSelectionInterview();
-        $select = $this->sql->select(self::_TABLE);
+        $select = $this->sql->select();
+        $select->from(['i' => self::_TABLE]);
+        $select->join(['c', RecruitmentSelectionCandidateMapper::_TABLE], "i.candidate_id = c.id", ['c.first_name']);
+        $select->columns(['i.uuid']);
         $select->where->equalTo('company_id', $companyId);
         if($search) {
-            $select->where->like('name', '%' . $search . '%');
+            $select->where->like('c.first_name', '%' . $search . '%');
+        }
         $select->order($order_field . ' ' . $order_direction);
         $adapter = new DbSelect($select, $this->sql, $resultset);
         $paginator = new Paginator($adapter);
         $paginator->setItemCountPerPage($records_per_page);
         $paginator->setCurrentPageNumber($page);
         return $paginator;
+    }

Proyectos de Subversion LeadersLinked - Antes de SPA