= ?";
$params[] = $filters['date_from'];
}
if (!empty($filters['date_to'])) {
$where[] = "DATE(created_at) <= ?";
$params[] = $filters['date_to'];
}
if (!empty($filters['search'])) {
$where[] = "(action_description LIKE ? OR username LIKE ?)";
$search_term = '%' . $filters['search'] . '%';
$params[] = $search_term;
$params[] = $search_term;
}
$where_clause = !empty($where) ? 'WHERE ' . implode(' AND ', $where) : '';
$logs = $db->fetchAll(
"SELECT * FROM activity_logs
$where_clause
ORDER BY created_at DESC",
$params
);
// Classe semplice per generare PDF (HTML per stampa)
class LogPDF {
private $content = '';
public function addTitle($title) {
$this->content .= "$title
";
}
public function addSubtitle($subtitle) {
$this->content .= "$subtitle
";
}
public function addText($text) {
$this->content .= "$text
";
}
public function addTable($headers, $rows) {
$this->content .= "";
$this->content .= "";
foreach ($headers as $header) {
$this->content .= "| $header | ";
}
$this->content .= "
";
$odd = true;
foreach ($rows as $row) {
$bgColor = $odd ? '#ffffff' : '#f8f9fa';
$this->content .= "";
foreach ($row as $cell) {
$this->content .= "| $cell | ";
}
$this->content .= "
";
$odd = !$odd;
}
$this->content .= "
";
}
public function output($filename) {
header('Content-Type: text/html; charset=utf-8');
header('Content-Disposition: inline; filename="' . $filename . '.html"');
echo "
$filename
";
echo "";
echo "";
echo "";
echo "
";
echo $this->content;
echo "";
echo "
Generato il " . date('d/m/Y H:i') . " da " . htmlspecialchars($_SESSION['username']) . " - " . APP_NAME . "
";
echo "