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']);

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

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

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

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

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

                $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 = $queryMapper->getSql()->buildSqlString($select);

                // $selectString = $queryMapper->getSql()->buildSqlString($select);

                print_r(

                // print_r(

                    $selectString

                //     $selectString

                );

                // );