Línea 227... |
Línea 227... |
227 |
* @return Paginator
|
227 |
* @return Paginator
|
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 |
die("Test");
|
- |
|
233 |
$select = $this->sql->select();
|
232 |
$select = $this->sql->select();
|
- |
|
233 |
die("Test");
|
234 |
$select->from(['i' => self::_TABLE]);
|
234 |
$select->from(['i' => self::_TABLE]);
|
235 |
$select->join(['c', RecruitmentSelectionCandidateMapper::_TABLE], "i.candidate_id = c.id", ['c.first_name']);
|
235 |
$select->join(['c', RecruitmentSelectionCandidateMapper::_TABLE], "i.candidate_id = c.id", ['c.first_name']);
|
236 |
$select->columns(['uuid' => 'i.uuid']);
|
236 |
$select->columns(['uuid' => 'i.uuid']);
|
237 |
$select->where->equalTo('company_id', $companyId);
|
237 |
$select->where->equalTo('company_id', $companyId);
|
238 |
echo $select->getSqlString($this->adapter->platform); exit;
|
238 |
echo $select->getSqlString($this->adapter->platform); exit;
|