$reportdata["headertext"] = $reportHeader; $reportdata["tableheadings"] = array($aInt->lang('fields', 'client'), $aInt->lang('fields', 'domain'), $aInt->lang('fields', 'dateSent'), $aInt->lang('domains', 'reminder'), $aInt->lang('emails', 'recipients'), $aInt->lang('domains', 'sent')); $typeMap = array(1 => $aInt->lang('domains', 'firstReminder'), 2 => $aInt->lang('domains', 'secondReminder'), 3 => $aInt->lang('domains', 'thirdReminder'), 4 => $aInt->lang('domains', 'fourthReminder'), 5 => $aInt->lang('domains', 'fifthReminder')); # Report Footer Text - this gets displayed below the report table of data $data["footertext"] = ""; $table = "tbldomainreminders"; $fields = "tbldomainreminders.id AS reminder_id,\n tbldomainreminders.date,\n tbldomainreminders.type,\n tbldomainreminders.days_before_expiry,\n tbldomainreminders.recipients,\n tblclients.firstname,\n tblclients.lastname,\n tblclients.companyname,\n tbldomains.domain\n"; $sort = "reminder_id"; $sortOrder = "DESC"; $join = "tbldomains ON (tbldomainreminders.domain_id = tbldomains.id) " . "JOIN tblclients ON (tbldomains.userid = tblclients.id)"; $where = array(); if ($userID) { $where['tblclients.id'] = (int) $userID; } if ($domain) { $where['tbldomains.domain'] = Sanitize::encode($domain); } if ($dateFrom && !$dateTo) { $where['date'] = array('sqltype' => '>=', 'value' => str_replace('-', '', $dateFrom)); } if ($dateTo && !$dateFrom) { $where['date'] = array('sqltype' => '<=', 'value' => str_replace('-', '', $dateTo)); } if ($registrar) { $where['tbldomains.registrar'] = $registrar; } $result = select_query($table, $fields, $where, $sort, $sortOrder, '', $join); while ($data = mysql_fetch_array($result)) { if ($dateFrom && $dateFrom != '' && ($dateTo && $dateTo != '')) { $from = new DateTime(str_replace('-', '', $dateFrom)); $to = new DateTime(str_replace('-', '', $dateTo));