Proyectos de Subversion LeadersLinked - Antes de SPA

                $select = $queryMapper->getSql()->select();

                $select = $queryMapper->getSql()->select();

                $select->columns(['id', 'uuid', 'title', 'employment_type', 'last_date_of_application','image']);

                $select->columns(['id', 'uuid', 'title', 'employment_type', 'last_date_of_application','image']);

                $select->from(['j' => JobMapper::_TABLE]);

                $select->from(['j' => JobMapper::_TABLE]);

                $select->join(['comp' => CompanyMapper::_TABLE], 'j.company_id = comp.id');

                $select->join(['c' => CompanyMapper::_TABLE], 'j.company_id = c.id');

                $select->where->equalTo('j.status', Job::STATUS_ACTIVE);

                $select->where->equalTo('j.status', Job::STATUS_ACTIVE);

                $select->where->equalTo('js.user_id', $currentUser->id);

                $select->where->equalTo('js.user_id', $currentUser->id);

                if($search) {

                if($search) {

                    $select->where->like('title', '%' . $search . '%');

                    $select->where->like('title', '%' . $search . '%');

                }

                    $selectString

                );