protected function build()
{
parent::build();
if ($this->isMapItAreaOnly) {
$this->joins[] = " JOIN area_mapit_information ON area_mapit_information.area_id = area_information.id ";
}
if ($this->human) {
$this->joins[] = " JOIN human_in_area ON human_in_area.area_id = area_information.id AND human_in_area.human_id = :human_id AND human_in_area.removed_at IS NULL";
$this->params['human_id'] = $this->human->getId();
}
if ($this->includeAreasWithNoEventsOnly) {
$this->joins[] = " LEFT JOIN meetyournextmp_event_in_area ON meetyournextmp_event_in_area.area_id = area_information.id ";
$this->joins[] = " LEFT JOIN event_information ON event_information.id = meetyournextmp_event_in_area.event_id " . "AND event_information.is_deleted = '0' AND event_information.is_cancelled ='0'";
$this->where[] = " event_information.id IS NULL ";
}
}
