Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 1222 Rev 1223
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
        die("Test");
-
 
234
        $select->from(['i' => self::_TABLE]);
233
        $select->from(['i' => self::_TABLE]);
235
        $select->join(['c', RecruitmentSelectionCandidateMapper::_TABLE], "i.candidate_id = c.id", ['c.first_name']);
234
        $select->join(['c', RecruitmentSelectionCandidateMapper::_TABLE], "i.candidate_id = c.id", ['c.first_name']);
-
 
235
        die("Test");
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;
Línea 239... Línea 239...
239
        
239