Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 2804 Rev 2805
Línea 36... Línea 36...
36 
use LeadersLinked\Model\JobApplication;
 36 
use LeadersLinked\Model\JobApplication;
37 
use LeadersLinked\Mapper\JobSaveMapper;
 37 
use LeadersLinked\Mapper\JobSaveMapper;
38 
use LeadersLinked\Model\JobSave;
 38 
use LeadersLinked\Model\JobSave;
39 
use LeadersLinked\Mapper\QueryMapper;
 39 
use LeadersLinked\Mapper\QueryMapper;
40 
use LeadersLinked\Mapper\UserProfileMapper;
 40 
use LeadersLinked\Mapper\UserProfileMapper;
41 
use Zend\Db\Sql\Predicate\Expression;
 - 
 
- 
 
 41 
 
Línea 42... Línea 42...
42 
 
 42 
 
43 
class JobController extends AbstractActionController
 43 
class JobController extends AbstractActionController
44 
{
 44 
{
45 
    /**
 45 
    /**
Línea 875... Línea 875...
875
875
876 
                $select = $queryMapper->getSql()->select();
 876 
                $select = $queryMapper->getSql()->select();
877 
                $select->columns(['id', 'uuid', 'title', 'employment_type', 'last_date_of_application']);
 877 
                $select->columns(['id', 'uuid', 'title', 'employment_type', 'last_date_of_application']);
878 
                $select->from(['j' => JobMapper::_TABLE]);
 878 
                $select->from(['j' => JobMapper::_TABLE]);
879 
                $select->join(['js' => JobSaveMapper::_TABLE], 'j.id = js.job_id');
 879 
                $select->join(['js' => JobSaveMapper::_TABLE], 'j.id = js.job_id');
880 
                $select->join(['c' => CompanyMapper::_TABLE], 'j.company_id = c.id',['image', new Expression('vendors.daily_limit')]);
 880 
                $select->join(['c' => CompanyMapper::_TABLE], 'j.company_id = c.id',['image','uuid'=>'comp_uuid']);
881 
                $select->where->equalTo('j.status', Job::STATUS_ACTIVE);
 881 
                $select->where->equalTo('j.status', Job::STATUS_ACTIVE);
Línea 882... Línea 882...
882 
                $select->where->equalTo('js.user_id', $currentUser->id);
 882 
                $select->where->equalTo('js.user_id', $currentUser->id);
883
883