« Back to History
user_activity_today.php
|
20260920_164915.php
Initial Domain Snapshot
Copy Code
<?php /* ============================================================================= File: /erp/user_activity_today.php Title: User Activity (Today / Date Range) — Company-scoped (IST-correct) Scope: Page-local only. NO global/base edits. Modes: • Pull: beam_entry, pissing_entry, pasaria_entry, zari_kasab_entry • Auto: ?auto=1 (generic scan) • Push: user_activity_log (optional) Timezone fix: • All timestamps are converted in SQL via CONVERT_TZ(<ts>, TZ_FROM, '+05:30') • Date filters apply on converted time (true local dates) • Toggle: ?tzfrom=SYSTEM (default) or ?tzfrom=UTC ============================================================================= */ header('X-Frame-Options: SAMEORIGIN'); error_reporting(E_ALL); ini_set('display_errors',1); date_default_timezone_set('Asia/Kolkata'); // PHP side (UI) // ---------- Auth + PDO ---------- require __DIR__ . '/modules/auth/auth.php'; require_login(); $u = auth_user(); $company_id = (int)$u['company_id']; $login_uid = (int)$u['id']; $pdo = $GLOBALS['pdo'] ?? null; if (!$pdo) { require __DIR__ . '/core/db.php'; } $pdo->exec("SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"); // ---------- Helpers ---------- function table_exists(PDO $pdo, string $tbl): bool { $st=$pdo->prepare("SELECT 1 FROM information_schema.tables WHERE table_schema=DATABASE() AND table_name=?"); $st->execute([$tbl]); return (bool)$st->fetchColumn(); } function col_exists(PDO $pdo, string $tbl, string $col): bool { $st=$pdo->prepare("SELECT 1 FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name=? AND column_name=?"); $st->execute([$tbl,$col]); return (bool)$st->fetchColumn(); } function safe_ident(string $s): bool { return (bool)preg_match('/^[A-Za-z0-9_]+$/',$s); } function fetch_users_map(PDO $pdo, int $company_id): array { if (!table_exists($pdo,'users')) return []; $st=$pdo->prepare("SELECT id,name FROM users WHERE company_id=:c ORDER BY name"); $st->execute([':c'=>$company_id]); $out=[]; foreach($st->fetchAll(PDO::FETCH_ASSOC) as $r){ $out[(int)$r['id']]=$r['name']; } return $out; } function make_row($ts,$uid,$uname,$module,$text,$ref=null,$link=null){ return ['ts'=>$ts?:null,'user_id'=>(int)($uid??0),'user_name'=>$uname?:'User','module'=>$module,'text'=>$text,'ref'=>$ref,'link'=>$link]; } // ---------- TZ Controls (DB -> IST) ---------- $TZ_TO = '+05:30'; // Always show in IST $TZ_FROM = strtoupper($_GET['tzfrom'] ?? 'SYSTEM'); // 'SYSTEM' (default) or 'UTC' if (!in_array($TZ_FROM,['SYSTEM','UTC','+00:00','-00:00'],true)) $TZ_FROM='SYSTEM'; // helper to wrap SQL time expression into CONVERT_TZ(...) function tz_wrap(string $expr, string $from, string $to): string { return "CONVERT_TZ($expr, " . ($from==='SYSTEM' ? "'SYSTEM'" : "'$from'") . ", '$to')"; } // ---------- Filters ---------- $today = date('Y-m-d'); $date_from = $_GET['date_from'] ?? $today; $date_to = $_GET['date_to'] ?? $today; $filter_user_id = isset($_GET['user_id']) && $_GET['user_id']!=='' ? (int)$_GET['user_id'] : 0; $filter_modules = isset($_GET['modules']) && is_array($_GET['modules']) ? array_values(array_unique($_GET['modules'])) : []; $AUTO_MODE = isset($_GET['auto']) && $_GET['auto']==='1'; $INCLUDE_PUSH = true; // ---------- Users map ---------- $users_map = fetch_users_map($pdo,$company_id); // ---------- Sources ---------- $sources = []; /* ============================================================================ PULL MODE — TABLE-SPECIFIC BLOCKS (ALL with TZ conversion) ========================================================================== */ /* --------- BEAM ENTRY --------------------------------------------------- */ if (table_exists($pdo,'beam_entry')) { $tscol = col_exists($pdo,'beam_entry','created_at') ? 'be.created_at' : (col_exists($pdo,'beam_entry','entry_date') ? 'be.entry_date' : 'NULL'); $userCol = null; if (col_exists($pdo,'beam_entry','created_by')) $userCol='be.created_by'; elseif (col_exists($pdo,'beam_entry','user_id')) $userCol='be.user_id'; $empCol = col_exists($pdo,'beam_entry','employee_id') ? 'be.employee_id' : null; $joins=[]; $userSelId='NULL'; $userSelName='NULL'; if ($userCol && table_exists($pdo,'users')) { $joins[]="LEFT JOIN users u ON u.company_id=be.company_id AND u.id=$userCol"; $userSelId='u.id'; $userSelName='u.name'; } elseif ($empCol && (table_exists($pdo,'employees')||table_exists($pdo,'company_employee_master'))) { if (table_exists($pdo,'employees')) $joins[]="LEFT JOIN employees e ON e.company_id=be.company_id AND e.id=$empCol"; else $joins[]="LEFT JOIN company_employee_master e ON e.company_id=be.company_id AND e.id=$empCol"; $userSelId='e.id'; $userSelName='e.name'; } $sel_qname='NULL'; if (col_exists($pdo,'beam_entry','quality_id') && table_exists($pdo,'beam_qualities')) { $joins[]="LEFT JOIN beam_qualities q ON q.id=be.quality_id AND q.company_id=be.company_id"; $sel_qname='q.name'; } $sel_beam = col_exists($pdo,'beam_entry','beam_no') ? 'be.beam_no' : 'NULL'; $sel_taka = col_exists($pdo,'beam_entry','taka') ? 'be.taka' : (col_exists($pdo,'beam_entry','taka_no') ? 'be.taka_no':'NULL'); $sel_meter = col_exists($pdo,'beam_entry','meter') ? 'be.meter' : 'NULL'; $ts_disp = $tscol!=='NULL' ? tz_wrap($tscol,$TZ_FROM,$TZ_TO) : 'NULL'; $dateWhere = $tscol!=='NULL' ? "AND DATE($ts_disp) BETWEEN :df AND :dt" : ""; $sql=" SELECT $ts_disp AS ts, $userSelId AS user_id, $userSelName AS user_name, $sel_beam AS beam_no, $sel_taka AS taka_no, $sel_meter AS meter_val, $sel_qname AS quality_name, be.id AS rid FROM beam_entry be ".implode("\n",$joins)." WHERE be.company_id=:cid $dateWhere "; $st=$pdo->prepare($sql); $bind=[':cid'=>$company_id]; if ($dateWhere){ $bind[':df']=$date_from; $bind[':dt']=$date_to; } $st->execute($bind); foreach($st->fetchAll(PDO::FETCH_ASSOC) as $r){ $bits=[]; if (!empty($r['taka_no'])) $bits[]="Taka ".$r['taka_no']; if (!empty($r['beam_no'])) $bits[]="Beam ".$r['beam_no']; if (!empty($r['meter_val'])) $bits[]=$r['meter_val']." m"; if (!empty($r['quality_name'])) $bits[]="Quality ".$r['quality_name']; $sources['Beam Entry'][] = make_row( $r['ts'], $r['user_id']??0, $r['user_name']?:'User', 'Beam Entry', "Beam Entry — ".($bits?implode(" • ",$bits):("ID#".$r['rid'])), !empty($r['taka_no'])?('TAKA#'.$r['taka_no']):('ID#'.$r['rid']), '/erp/beam_entry_manage.php?id='.urlencode($r['rid']) ); } } /* --------- PISSING ENTRY ------------------------------------------------ */ if (table_exists($pdo,'pissing_entry')) { $tscol = col_exists($pdo,'pissing_entry','created_at') ? 'pe.created_at' : (col_exists($pdo,'pissing_entry','entry_date') ? 'pe.entry_date' : 'NULL'); $userCol = null; if (col_exists($pdo,'pissing_entry','created_by')) $userCol='pe.created_by'; elseif (col_exists($pdo,'pissing_entry','user_id')) $userCol='pe.user_id'; $empCol = col_exists($pdo,'pissing_entry','employee_id') ? 'pe.employee_id' : null; $joins=[]; $userSelId='NULL'; $userSelName='NULL'; if ($userCol && table_exists($pdo,'users')) { $joins[]="LEFT JOIN users u ON u.company_id=pe.company_id AND u.id=$userCol"; $userSelId='u.id'; $userSelName='u.name'; } elseif ($empCol && (table_exists($pdo,'employees')||table_exists($pdo,'company_employee_master'))) { if (table_exists($pdo,'employees')) $joins[]="LEFT JOIN employees e ON e.company_id=pe.company_id AND e.id=$empCol"; else $joins[]="LEFT JOIN company_employee_master e ON e.company_id=pe.company_id AND e.id=$empCol"; $userSelId='e.id'; $userSelName='e.name'; } $sel_qname='NULL'; if (col_exists($pdo,'pissing_entry','quality_id') && table_exists($pdo,'beam_qualities')) { $joins[]="LEFT JOIN beam_qualities q ON q.id=pe.quality_id AND q.company_id=pe.company_id"; $sel_qname='q.name'; } $sel_meter = col_exists($pdo,'pissing_entry','meter') ? 'pe.meter':'NULL'; $sel_type = col_exists($pdo,'pissing_entry','pissing_type') ? 'pe.pissing_type':'NULL'; $sel_mach = col_exists($pdo,'pissing_entry','machine_no') ? 'pe.machine_no':'NULL'; $ts_disp = $tscol!=='NULL' ? tz_wrap($tscol,$TZ_FROM,$TZ_TO) : 'NULL'; $dateWhere = $tscol!=='NULL' ? "AND DATE($ts_disp) BETWEEN :df AND :dt" : ""; $sql=" SELECT $ts_disp AS ts, $userSelId AS user_id, $userSelName AS user_name, $sel_qname AS quality_name, $sel_meter AS meter_val, $sel_type AS type_val, $sel_mach AS machine_no, pe.id AS rid FROM pissing_entry pe ".implode("\n",$joins)." WHERE pe.company_id=:cid $dateWhere "; $st=$pdo->prepare($sql); $bind=[':cid'=>$company_id]; if ($dateWhere){ $bind[':df']=$date_from; $bind[':dt']=$date_to; } $st->execute($bind); foreach($st->fetchAll(PDO::FETCH_ASSOC) as $r){ $bits=[]; if (!empty($r['type_val'])) $bits[]=$r['type_val']; if (!empty($r['quality_name'])) $bits[]="Quality ".$r['quality_name']; if (!empty($r['meter_val'])) $bits[]=$r['meter_val']." m"; if (!empty($r['machine_no'])) $bits[]="M".$r['machine_no']; $sources['Pissing Entry'][] = make_row( $r['ts'], $r['user_id']??0, $r['user_name']?:'User', 'Pissing Entry', "Pissing Entry — ".($bits?implode(" • ",$bits):("ID#".$r['rid'])), 'ID#'.$r['rid'], '/erp/pissing_entry_manage.php?id='.urlencode($r['rid']) ); } } /* --------- PASARIA ENTRY ------------------------------------------------ */ if (table_exists($pdo,'pasaria_entry')) { $tscol = col_exists($pdo,'pasaria_entry','created_at') ? 'pa.created_at' : (col_exists($pdo,'pasaria_entry','entry_date') ? 'pa.entry_date' : 'NULL'); $userCol = null; if (col_exists($pdo,'pasaria_entry','created_by')) $userCol='pa.created_by'; elseif (col_exists($pdo,'pasaria_entry','user_id')) $userCol='pa.user_id'; $empCol = col_exists($pdo,'pasaria_entry','employee_id') ? 'pa.employee_id' : null; $joins=[]; $userSelId='NULL'; $userSelName='NULL'; if ($userCol && table_exists($pdo,'users')) { $joins[]="LEFT JOIN users u ON u.company_id=pa.company_id AND u.id=$userCol"; $userSelId='u.id'; $userSelName='u.name'; } elseif ($empCol && (table_exists($pdo,'employees')||table_exists($pdo,'company_employee_master'))) { if (table_exists($pdo,'employees')) $joins[]="LEFT JOIN employees e ON e.company_id=pa.company_id AND e.id=$empCol"; else $joins[]="LEFT JOIN company_employee_master e ON e.company_id=pa.company_id AND e.id=$empCol"; $userSelId='e.id'; $userSelName='e.name'; } $sel_type = col_exists($pdo,'pasaria_entry','pasaria_type') ? 'pa.pasaria_type':'NULL'; $sel_beam = col_exists($pdo,'pasaria_entry','beam_no') ? 'pa.beam_no':'NULL'; $sel_q = 'NULL'; if (col_exists($pdo,'pasaria_entry','quality_id') && table_exists($pdo,'beam_qualities')) { $joins[]="LEFT JOIN beam_qualities q ON q.id=pa.quality_id AND q.company_id=pa.company_id"; $sel_q='q.name'; } $ts_disp = $tscol!=='NULL' ? tz_wrap($tscol,$TZ_FROM,$TZ_TO) : 'NULL'; $dateWhere = $tscol!=='NULL' ? "AND DATE($ts_disp) BETWEEN :df AND :dt" : ""; $sql=" SELECT $ts_disp AS ts, $userSelId AS user_id, $userSelName AS user_name, $sel_type AS type_val, $sel_beam AS beam_no, $sel_q AS quality_name, pa.id AS rid FROM pasaria_entry pa ".implode("\n",$joins)." WHERE pa.company_id=:cid $dateWhere "; $st=$pdo->prepare($sql); $bind=[':cid'=>$company_id]; if ($dateWhere){ $bind[':df']=$date_from; $bind[':dt']=$date_to; } $st->execute($bind); foreach($st->fetchAll(PDO::FETCH_ASSOC) as $r){ $bits=[]; if (!empty($r['type_val'])) $bits[]=$r['type_val']; if (!empty($r['beam_no'])) $bits[]="Beam ".$r['beam_no']; if (!empty($r['quality_name'])) $bits[]="Quality ".$r['quality_name']; $sources['Pasaria Entry'][] = make_row( $r['ts'], $r['user_id']??0, $r['user_name']?:'User', 'Pasaria Entry', "Pasaria Entry — ".($bits?implode(" • ",$bits):("ID#".$r['rid'])), 'ID#'.$r['rid'], '/erp/pasaria_entry.php?view='.urlencode($r['rid']) ); } } /* --------- ZARI KASAB ENTRY -------------------------------------------- */ if (table_exists($pdo,'zari_kasab_entry')) { $tscol = col_exists($pdo,'zari_kasab_entry','created_at') ? 'zk.created_at' : (col_exists($pdo,'zari_kasab_entry','entry_date') ? 'zk.entry_date' : 'NULL'); $has_cb = col_exists($pdo,'zari_kasab_entry','created_by'); $has_uid = col_exists($pdo,'zari_kasab_entry','user_id'); $has_emp = col_exists($pdo,'zari_kasab_entry','employee_id'); $userSelId='NULL'; $userSelName='NULL'; $userJoin=''; if (($has_cb || $has_uid) && table_exists($pdo,'users')) { $col = $has_cb ? 'zk.created_by' : 'zk.user_id'; $userSelId='u.id'; $userSelName='u.name'; $userJoin="LEFT JOIN users u ON u.company_id=zk.company_id AND u.id=$col"; } elseif ($has_emp && (table_exists($pdo,'employees')||table_exists($pdo,'company_employee_master'))) { $userSelId='e.id'; $userSelName='e.name'; if (table_exists($pdo,'employees')) $userJoin="LEFT JOIN employees e ON e.company_id=zk.company_id AND e.id=zk.employee_id"; else $userJoin="LEFT JOIN company_employee_master e ON e.company_id=zk.company_id AND e.id=zk.employee_id"; } $sel_w = col_exists($pdo,'zari_kasab_entry','weight') ? 'zk.weight':'NULL'; $sel_r = col_exists($pdo,'zari_kasab_entry','roll_no') ? 'zk.roll_no':'NULL'; $ts_disp = $tscol!=='NULL' ? tz_wrap($tscol,$TZ_FROM,$TZ_TO) : 'NULL'; $dateWhere = $tscol!=='NULL' ? "AND DATE($ts_disp) BETWEEN :df AND :dt" : ""; $sql=" SELECT $ts_disp AS ts, $userSelId AS user_id, $userSelName AS user_name, $sel_w AS weight_val, $sel_r AS roll_no, zk.id AS rid FROM zari_kasab_entry zk $userJoin WHERE zk.company_id=:cid $dateWhere "; $st=$pdo->prepare($sql); $bind=[':cid'=>$company_id]; if ($dateWhere){ $bind[':df']=$date_from; $bind[':dt']=$date_to; } $st->execute($bind); foreach($st->fetchAll(PDO::FETCH_ASSOC) as $r){ $bits=[]; if (!empty($r['roll_no'])) $bits[]="Roll ".$r['roll_no']; if (!empty($r['weight_val'])) $bits[]=$r['weight_val']." kg"; $sources['Zari/Kasab Entry'][] = make_row( $r['ts'], $r['user_id']??0, $r['user_name']?:'User', 'Zari/Kasab Entry', "Zari/Kasab Entry — ".($bits?implode(" • ",$bits):("ID#".$r['rid'])), 'ID#'.$r['rid'], '/erp/zari_kasab_entry.php?view='.urlencode($r['rid']) ); } } /* ============================================================================ PUSH MODE — user_activity_log (optional) with TZ convert ========================================================================== */ if ($INCLUDE_PUSH && table_exists($pdo,'user_activity_log')) { $ts_disp = tz_wrap('ual.created_at',$TZ_FROM,$TZ_TO); $sql=" SELECT $ts_disp AS ts, ual.user_id, u.name AS user_name, ual.module, ual.text, ual.ref FROM user_activity_log ual LEFT JOIN users u ON u.id=ual.user_id AND u.company_id=ual.company_id WHERE ual.company_id=:cid AND DATE($ts_disp) BETWEEN :df AND :dt ORDER BY ts DESC LIMIT 1000 "; $st=$pdo->prepare($sql); $st->execute([':cid'=>$company_id, ':df'=>$date_from, ':dt'=>$date_to]); foreach($st->fetchAll(PDO::FETCH_ASSOC) as $r){ $sources['(Log) '.$r['module']][] = make_row( $r['ts'],$r['user_id']??0,$r['user_name']?:'User',$r['module']?:'Activity',$r['text']?:'',$r['ref']?:null,null ); } } /* ============================================================================ AUTO-DISCOVERY (?auto=1) — with TZ convert ========================================================================== */ if ($AUTO_MODE) { $patterns=["%\\_entry","%\\_entries","%\\_log%","%\\_record%","%\\_txn%"]; $excl=['users','sessions','migrations_log','user_activity_log','page_permissions','page_access','page_acl_grants']; $inLike=implode(" OR ",array_fill(0,count($patterns),"t.table_name LIKE ?")); $stmt=$pdo->prepare(" SELECT DISTINCT t.table_name FROM information_schema.tables t WHERE t.table_schema=DATABASE() AND ($inLike) AND t.table_name NOT IN (".implode(",",array_map(fn($x)=>$pdo->quote($x),$excl)).") "); $stmt->execute($patterns); foreach($stmt->fetchAll(PDO::FETCH_COLUMN) as $tbl){ if (!safe_ident($tbl) || !table_exists($pdo,$tbl) || !col_exists($pdo,$tbl,'company_id')) continue; $tscol = col_exists($pdo,$tbl,'created_at')?'created_at':(col_exists($pdo,$tbl,'entry_date')?'entry_date':null); if (!$tscol || !col_exists($pdo,$tbl,'created_by')) continue; $maybeCols=['taka','taka_no','meter','meters','beam_no','pissing_type','machine_no','roll_no','weight','amount','qty','quality','quality_id','note','remarks']; $sel=["`$tbl`.".tz_wrap("`$tbl`.`$tscol`",$TZ_FROM,$TZ_TO)." AS ts","`$tbl`.`created_by` AS user_id","`$tbl`.`id` AS rid"]; foreach($maybeCols as $c){ if (col_exists($pdo,$tbl,$c)) $sel[]="`$tbl`.`$c` AS `$c`"; } $join = table_exists($pdo,'users') ? "LEFT JOIN users u ON u.id=`$tbl`.created_by AND u.company_id=`$tbl`.company_id" : ''; $sql=" SELECT ".implode(", ",$sel).", ".($join ? "u.name AS user_name" : "NULL AS user_name")." FROM `$tbl` $join WHERE `$tbl`.company_id=:cid AND DATE(".tz_wrap("`$tbl`.`$tscol`",$TZ_FROM,$TZ_TO).") BETWEEN :df AND :dt ORDER BY ts DESC LIMIT 500 "; $st=$pdo->prepare($sql); $st->execute([':cid'=>$company_id, ':df'=>$date_from, ':dt'=>$date_to]); $rows=$st->fetchAll(PDO::FETCH_ASSOC); if (!$rows) continue; $label=ucwords(trim(preg_replace('/(_entries|_entry|_log|_records?|_txn)$/','',str_replace('_',' ',$tbl)))); foreach($rows as $r){ $bits=[]; foreach($maybeCols as $c){ if (!array_key_exists($c,$r) || $r[$c]==='' || $r[$c]===null) continue; $val=$r[$c]; if ($c==='meter'||$c==='meters') $val.=' m'; if ($c==='weight') $val.=' kg'; if ($c==='machine_no') $val='M'.$val; if ($c==='quality_id') $val='Q#'.$val; $bits[]=ucfirst(str_replace('_',' ',$c)).": ".$val; if (count($bits)>=3) break; } $link=null; if ($tbl==='beam_entry') $link='/erp/beam_entry_manage.php?id='.urlencode($r['rid']); elseif ($tbl==='pissing_entry') $link='/erp/pissing_entry_manage.php?id='.urlencode($r['rid']); elseif ($tbl==='pasaria_entry') $link='/erp/pasaria_entry.php?view='.urlencode($r['rid']); elseif ($tbl==='zari_kasab_entry') $link='/erp/zari_kasab_entry.php?view='.urlencode($r['rid']); $sources["AUTO: $label"][] = make_row($r['ts'],$r['user_id']??0,$r['user_name']?:'User',$label,$label.' — '.($bits?implode(" • ",$bits):('Row ID '.$r['rid'])),'ID#'.$r['rid'],$link); } } } /* ---------- Merge + Filter + Sort ---------- */ $feed=[]; $available_modules=[]; foreach($sources as $mod=>$rows){ if ($rows) $available_modules[$mod]=true; } $available_modules=array_keys($available_modules); sort($available_modules); foreach($sources as $mod=>$rows){ foreach($rows as $r){ if ($filter_user_id && (int)$r['user_id']!==$filter_user_id) continue; if ($filter_modules && !in_array($r['module']??$mod,$filter_modules,true)) continue; $feed[]=$r; } } usort($feed,function($a,$b){ $ta=$a['ts']?strtotime($a['ts']):-1; $tb=$b['ts']?strtotime($b['ts']):-1; return $tb<=>$ta; }); /* ---------- Summaries ---------- */ $byUser=[]; $byModule=[]; foreach($feed as $r){ $un=$r['user_name']?:('User#'.$r['user_id']); $mn=$r['module']?:'Activity'; $byUser[$un]=($byUser[$un]??0)+1; $byModule[$mn]=($byModule[$mn]??0)+1; } arsort($byUser); arsort($byModule); /* ---------- CSV Export ---------- */ if (isset($_GET['fmt']) && $_GET['fmt']==='csv') { header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename="user_activity_'.$date_from.'_to_'.$date_to.($AUTO_MODE?'_auto':'').'.csv"'); $out=fopen('php://output','w'); fputcsv($out,['DateTime(IST)','User','Module','Activity','Ref','Link','TZFROM']); foreach($feed as $r) fputcsv($out, [$r['ts'],$r['user_name'],$r['module'],$r['text'],$r['ref'],$r['link'],$TZ_FROM]); fclose($out); exit; } /* ---------- UI (Mister Manager palette) ---------- */ $MM_GREEN='#34A853'; $MM_GRAY='#5F6368'; $MM_MINT='#F5FFF7'; $MM_SKY='#A7D8DE'; $MM_YELL='#FFF9C4'; ?> <!DOCTYPE html> <html lang="hi"> <head> <meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"> <title>User Activity — Today / Range (IST)</title> <style> :root{ --mm-green:<?= $MM_GREEN ?>; --mm-gray:<?= $MM_GRAY ?>; --mm-mint:<?= $MM_MINT ?>; --mm-sky:<?= $MM_SKY ?>; --mm-yell:<?= $MM_YELL ?>; } body{font-family:system-ui,-apple-system,Segoe UI,Roboto,Arial,sans-serif;background:var(--mm-mint);margin:0;color:#222} header{background:var(--mm-green);color:#fff;padding:14px 18px;display:flex;align-items:center;justify-content:space-between} header h1{font-size:18px;margin:0} .container{padding:16px} .filters{display:flex;flex-wrap:wrap;gap:12px;background:#fff;border:1px solid #e6efe8;border-radius:12px;padding:12px} .filters label{font-size:12px;color:#333;display:block;margin-bottom:4px} .filters input,.filters select{padding:8px 10px;border:1px solid #d9e2db;border-radius:8px;min-width:160px} .chips{display:flex;flex-wrap:wrap;gap:8px;margin-top:12px} .chip{background:var(--mm-sky);padding:8px 10px;border-radius:999px;font-size:12px;border:1px solid #cfe9ec} .section{margin-top:18px} .card{background:#fff;border:1px solid #e6efe8;border-radius:12px;padding:12px} .grid{display:grid;grid-template-columns:repeat(12,1fr);gap:12px} .col-4{grid-column:span 4}.col-8{grid-column:span 8} .summary-list{display:flex;flex-direction:column;gap:8px} .summary-item{display:flex;justify-content:space-between;align-items:center;border-bottom:1px dashed #eee;padding:6px 0} .toolbar{display:flex;gap:8px} .btn{background:#fff;border:1px solid #d9e2db;border-radius:10px;padding:8px 12px;cursor:pointer;text-decoration:none;color:#222} .btn.primary{background:var(--mm-green);border-color:var(--mm-green);color:#fff} .btn.warning{background:var(--mm-yell);border-color:#eadf9a} .timeline{display:flex;flex-direction:column;gap:10px} .act{display:grid;grid-template-columns:120px 180px 1fr;gap:12px;padding:10px;border:1px solid #eef3ee;border-radius:10px} .act-time{font-size:12px;color:#666}.act-user{font-weight:600}.act-text{color:#222} .badge{background:#e8f5ea;color:#16713a;border:1px solid #cfe1d3;padding:2px 8px;border-radius:999px;font-size:11px;margin-left:6px} .muted{color:#777} @media (max-width:800px){ .grid{grid-template-columns:1fr} .col-4,.col-8{grid-column:span 12} .act{grid-template-columns:1fr} } </style> </head> <body> <header> <h1>👀 User Activity — Today / Range <span class="badge">IST</span> <?= $AUTO_MODE?'<span class="badge" style="margin-left:6px">AUTO</span>':'' ?></h1> <div class="toolbar"> <a class="btn" href="?date_from=<?= urlencode($today) ?>&date_to=<?= urlencode($today) ?><?= $AUTO_MODE?'&auto=1':'' ?>&tzfrom=<?= urlencode($TZ_FROM) ?>">Today</a> <a class="btn" href="?<?= http_build_query(array_merge($_GET,['fmt'=>'csv'])) ?>">Export CSV</a> <a class="btn <?= $AUTO_MODE?'warning':'' ?>" href="?<?= http_build_query(array_merge($_GET,$AUTO_MODE?['auto'=>0]:['auto'=>1])) ?>"> <?= $AUTO_MODE?'Auto: ON (click to OFF)':'Auto: OFF (click to ON)' ?> </a> <a class="btn" href="?<?= http_build_query(array_merge($_GET,['tzfrom'=>($TZ_FROM==='UTC' ? 'SYSTEM' : 'UTC')])) ?>"> TZ: <?= htmlspecialchars($TZ_FROM) ?> → IST (switch) </a> <button class="btn primary" onclick="window.print()">Print</button> </div> </header> <div class="container"> <form method="get" class="filters"> <div><label>From</label><input type="date" name="date_from" value="<?= htmlspecialchars($date_from) ?>"></div> <div><label>To</label><input type="date" name="date_to" value="<?= htmlspecialchars($date_to) ?>"></div> <div> <label>User</label> <select name="user_id"> <option value="">— All —</option> <?php foreach($users_map as $uid=>$uname): ?> <option value="<?= (int)$uid ?>" <?= $filter_user_id===$uid?'selected':'' ?>><?= htmlspecialchars($uname) ?></option> <?php endforeach; ?> </select> </div> <div> <label>Modules</label> <select name="modules[]" multiple size="4" style="min-width:220px"> <?php foreach($available_modules as $m): ?> <option value="<?= htmlspecialchars($m) ?>" <?= in_array($m,$filter_modules,true)?'selected':'' ?>><?= htmlspecialchars($m) ?></option> <?php endforeach; ?> </select> <div class="muted" style="font-size:11px;margin-top:4px">Tip: Ctrl/⌘ multi-select</div> </div> <?php if($AUTO_MODE): ?><input type="hidden" name="auto" value="1"><?php endif; ?> <input type="hidden" name="tzfrom" value="<?= htmlspecialchars($TZ_FROM) ?>"> <div style="align-self:flex-end"> <button class="btn primary" type="submit">Apply</button> <a class="btn" href="?">Reset</a> </div> </form> <div class="chips"> <div class="chip">Range: <strong style="margin-left:6px"><?= htmlspecialchars($date_from) ?> → <?= htmlspecialchars($date_to) ?></strong></div> <div class="chip">TZ: <strong style="margin-left:6px"><?= htmlspecialchars($TZ_FROM) ?> → IST</strong></div> <div class="chip">Activities: <strong style="margin-left:6px"><?= count($feed) ?></strong></div> <?php if($filter_user_id): ?><div class="chip">User: <strong style="margin-left:6px"><?= htmlspecialchars($users_map[$filter_user_id] ?? ('#'.$filter_user_id)) ?></strong></div><?php endif; ?> <?php if($filter_modules): ?><div class="chip">Modules: <strong style="margin-left:6px"><?= htmlspecialchars(implode(', ',$filter_modules)) ?></strong></div><?php endif; ?> <div class="chip">Mode: <strong style="margin-left:6px"><?= $AUTO_MODE?'Auto-Discovery':'Pull + (optional) Log' ?></strong></div> </div> <div class="grid section"> <div class="col-4"> <div class="card"> <h3 style="margin:0 0 10px">👤 By User</h3> <div class="summary-list"> <?php if(!$byUser): ?><div class="muted">No activity in this range.</div> <?php else: foreach($byUser as $un=>$c): ?> <div class="summary-item"><strong><?= htmlspecialchars($un) ?></strong><span class="badge"><?= (int)$c ?></span></div> <?php endforeach; endif; ?> </div> </div> <div class="card" style="margin-top:12px"> <h3 style="margin:0 0 10px">🧩 By Module</h3> <div class="summary-list"> <?php if(!$byModule): ?><div class="muted">No activity.</div> <?php else: foreach($byModule as $mn=>$c): ?> <div class="summary-item"><strong><?= htmlspecialchars($mn) ?></strong><span class="badge"><?= (int)$c ?></span></div> <?php endforeach; endif; ?> </div> </div> </div> <div class="col-8"> <div class="card"> <h3 style="margin:0 0 10px">🕒 Timeline</h3> <div class="timeline"> <?php if(!$feed): ?> <div class="muted">No activity found for selected range/filters.</div> <?php else: foreach($feed as $row): ?> <div class="act"> <div class="act-time"> <?= $row['ts'] ? date('d M, H:i', strtotime($row['ts'])) : '<span class="muted">—</span>' ?> </div> <div class="act-user"> <?= htmlspecialchars($row['user_name']) ?> <span class="badge"><?= htmlspecialchars($row['module']) ?></span> </div> <div class="act-text"> <?= htmlspecialchars($row['text']) ?> <?php if(!empty($row['ref'])): ?><span class="muted" style="margin-left:6px"><?= htmlspecialchars($row['ref']) ?></span><?php endif; ?> <?php if(!empty($row['link'])): ?><a href="<?= htmlspecialchars($row['link']) ?>" style="margin-left:10px" class="btn">Open</a><?php endif; ?> </div> </div> <?php endforeach; endif; ?> </div> </div> </div> </div> <div class="section muted" style="font-size:12px"> <strong>TZ Fix:</strong> ऊपर <em>TZ</em> toggle से <code>?tzfrom=SYSTEM</code> ↔ <code>?tzfrom=UTC</code> बदल सकते हैं। सारे timestamps SQL में <code>CONVERT_TZ</code> से IST में convert हो रहे हैं — अब Timeline की घड़ी local रहेगी. </div> </div> </body> </html>