Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 7244 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 7244 Rev 7328
Línea 5... Línea 5...
5 
 
 5 
 
6 
use LeadersLinked\Mapper\Common\MapperCommon;
 6 
use LeadersLinked\Mapper\Common\MapperCommon;
7 
use Laminas\Db\Adapter\AdapterInterface;
 7 
use Laminas\Db\Adapter\AdapterInterface;
8 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
 8 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
- 
 
 9 
use LeadersLinked\Model\SurveyCampaignJobDescription;
Línea 9... Línea 10...
9 
use LeadersLinked\Model\SurveyCampaignJobDescription;
 10 
use Laminas\Db\Sql\Expression;
10 
 
 11 
 
11 
 
 12 
 
Línea 12... Línea 13...
12 
class SurveyCampaignJobDescriptionMapper extends MapperCommon
 13 
class SurveyCampaignJobDescriptionMapper extends MapperCommon
13 
{
 14 
{
14 
    const _TABLE = 'tbl_survey_campaign_industries';
 15 
    const _TABLE = 'tbl_survey_campaign_jobs_description';
15
16
Línea 72... Línea 73...
72 
        return $this->executeFetchAllObject($select, $prototype);
 73 
        return $this->executeFetchAllObject($select, $prototype);
73 
    }
 74 
    }
Línea 74... Línea 75...
74
75
- 
 
 76
- 
 
 77 
    /**
- 
 
 78 
     *
- 
 
 79 
     * @param int $company_id
- 
 
 80 
     * @param int $campaign_id
- 
 
 81 
     * @return int[]
- 
 
 82 
     */
- 
 
 83 
    public function fetchAllUserIdsByCompanyIdAndCampaignId($company_id, $campaign_id)
- 
 
 84 
    {
- 
 
 85 
        $select2 = $this->sql->select(self::_TABLE);
- 
 
 86 
        $select2->columns(['job_description_id']);
- 
 
 87 
        $select2->where->equalTo('campaign_id', $campaign_id);
- 
 
 88
- 
 
 89
- 
 
 90 
        $select = $this->sql->select();
- 
 
 91 
        $select->columns(['user_id' => new Expression('DISTINCT(tb1.user_id)')]);
- 
 
 92 
        $select->from(['tb1' => CompanyUserMapper::_TABLE]);
- 
 
 93 
        $select->join(['tb2' => OrganizationPositionMapper::_TABLE], 'tb1.user_id = tb2.employee_id', []);
- 
 
 94 
        $select->where->in('tb2.job_description_id', $select2);
- 
 
 95 
        $select->where->equalTo('tb1.company_id', $company_id);
- 
 
 96
- 
 
 97 
        $ids = [];
- 
 
 98 
        $records = $this->executeFetchAllArray($select);
- 
 
 99 
        foreach($records as $record)
- 
 
 100 
        {
- 
 
 101 
            array_push($ids, $record['user_id']);
- 
 
 102 
        }
- 
 
 103
- 
 
 104 
        return $ids;
- 
 
 105 
    }
- 
 
 106
75
107
76 
    /**
 108 
    /**
77 
     *
109 
     *
78 
     * @param SurveyCampaignJobDescription $record
 110 
     * @param SurveyCampaignJobDescription $record
79 
     * @return boolean
 111 
     * @return boolean