private function prepareAllFiltersCommand(&$command) { if ($this->fromDate != "") { $command->andWhere("ticket_events.event_recorded_date >= '" . DateUtils::getSQLDateStringFromDateStr($this->fromDate) . "'"); } if ($this->toDate != "") { $command->andWhere("ticket_events.event_recorded_date <= '" . DateUtils::getSQLDateStringFromDateStr($this->toDate) . "'"); } if (isset($this->exclusiveDomainID) && $this->exclusiveDomainID > 0) { $command->andWhere("ticket.subdomain_id IS NULL AND ticket.domain_id = " . $this->exclusiveDomainID); } if (isset($this->agregatedDomainID) && $this->agregatedDomainID > 0) { $command->andWhere("ticket.domain_id = " . $this->agregatedDomainID); } if (isset($this->subdomainID) && $this->subdomainID > 0) { $command->andWhere("ticket.subdomain_id = " . $this->subdomainID); } if (isset($this->assigned_domain_mentor_id) && $this->assigned_domain_mentor_id > 0) { $command->andWhere("ticket.assign_user_id = " . $this->assigned_domain_mentor_id); } else { if (isset($this->assigned_project_mentor_id) && $this->assigned_project_mentor_id > 0) { $command->andWhere("ticket.assign_user_id = " . $this->assigned_project_mentor_id); } else { if (isset($this->assigned_personal_mentor_id) && $this->assigned_personal_mentor_id > 0) { $command->andWhere("ticket.assign_user_id = " . $this->assigned_personal_mentor_id); } } } if (isset($this->mentee_id) && $this->mentee_id > 0) { $command->andWhere("ticket.creator_user_id = " . $this->mentee_id); } if (isset($this->assigned_project_id) && $this->assigned_project_id > 0) { $command->andWhere("ticket.assigned_project_id = " . $this->assigned_project_id); } if (isset($this->mentee_id) && $this->mentee_id > 0) { $command->andWhere("ticket.creator_user_id = " . $this->mentee_id); } }