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);
}
}