Dashboard

query($c_sql); $job_collection = ($res_c) ? ($res_c->fetch_assoc()['total'] ?? 0) : 0; // 2. AMC Income (Based on created_at - when the AMC was sold/entered) $amc_sql = "SELECT SUM(amount) as total FROM amc_records WHERE DATE(created_at) BETWEEN '$start_date' AND '$end_date'"; $res_amc = $conn->query($amc_sql); $amc_collection = ($res_amc) ? ($res_amc->fetch_assoc()['total'] ?? 0) : 0; $total_collection = $job_collection + $amc_collection; // 3. Expenses (Based on created_at) $e_sql = "SELECT SUM(amount) as total FROM expenses WHERE DATE(created_at) BETWEEN '$start_date' AND '$end_date'"; $res_e = $conn->query($e_sql); $expense = ($res_e) ? ($res_e->fetch_assoc()['total'] ?? 0) : 0; // 4. Pending Due (Total Bill - Collection) where Bill > Collection // Pending is usually a "current state" metric, not necessarily date-bound, // BUT for a report, maybe we only want pending/dues from jobs in this period? // Usually "Pending Due" implies "Total Outstanding in the market". // Let's keep it defined by the date range of the JOB to show "Receivables generated in this period". $p_sql = "SELECT SUM(total_bill - total_collection) as pending FROM jobs WHERE total_bill > total_collection AND status != 'Cancelled' AND DATE(updated_at) BETWEEN '$start_date' AND '$end_date'"; $res_p = $conn->query($p_sql); $pending = ($res_p) ? ($res_p->fetch_assoc()['pending'] ?? 0) : 0; // 5. Net Cash $profit = $total_collection - $expense; ?>

Collection (This Month)

₹

Jobs: + AMC:

Expenses (This Month)

₹

Net Cash in Hand

₹

Pending Due

₹

query("SELECT SUM(total_bill) as t FROM jobs WHERE assigned_to = $user_id AND status='Completed' AND payment_mode IN ('Cash', 'UPI') AND is_deposited=0"); $w_jobs = ($wj_q) ? ($wj_q->fetch_assoc()['t'] ?? 0) : 0; // You can add AMC wallet logic here later if Technicians sell AMC directly $wallet_balance = $w_jobs; } $filter = $_GET['filter'] ?? 'monthly'; $from_date = $_GET['from_date'] ?? null; $to_date = $_GET['to_date'] ?? null; $whereClause = ""; if ($from_date && $to_date) { // Custom Date Range $whereClause = " AND DATE(created_at) BETWEEN '$from_date' AND '$to_date'"; } elseif ($filter == 'weekly') { $whereClause = " AND YEARWEEK(created_at, 1) = YEARWEEK(CURDATE(), 1)"; } elseif ($filter == 'monthly') { $whereClause = " AND MONTH(created_at) = MONTH(CURDATE()) AND YEAR(created_at) = YEAR(CURDATE())"; } $stats = ['New' => 0, 'On Going' => 0, 'Pending' => 0, 'Cancelled' => 0, 'Not Answered' => 0, 'Refused' => 0]; $total_jobs = 0; if ($is_restricted) { // Technician sees only their stats $sql = "SELECT status, COUNT(*) as count FROM jobs WHERE assigned_to = $user_id $whereClause GROUP BY status"; $total_query = "SELECT COUNT(*) as c FROM jobs WHERE assigned_to = $user_id $whereClause"; } else { // Admin/Others see all // Note: WHERE 1=1 is not needed if we check empty, but good for appending $sql = "SELECT status, COUNT(*) as count FROM jobs WHERE 1=1 $whereClause GROUP BY status"; $total_query = "SELECT COUNT(*) as c FROM jobs WHERE 1=1 $whereClause"; } // Get Total Count $t_res = $conn->query($total_query); $total_jobs = ($t_res) ? $t_res->fetch_assoc()['c'] : 0; // Get Status Breakdown $result = $conn->query($sql); if ($result) { while ($row = $result->fetch_assoc()) { $stats[$row['status']] = $row['count']; } } ?>

My Virtual Wallet

₹

0): ?> Cash/UPI in Hand (Not Deposited) All settled with Admin.

View History

Total Jobs

= CURDATE()"; Let's stick to simple total for now unless requested active only. Request said "Total Count of AMC records". */ if ($is_restricted) { // If technician, maybe don't show AMC count or show 0? // Or if we want tech to see total amcs: $amc_total = $conn->query($amc_count_sql)->fetch_assoc()['c']; } else { $amc_total = $conn->query($amc_count_sql)->fetch_assoc()['c']; } // USER FEEDBACK CORRECTION: User expects "Active AMC" to reflect the AMC Jobs visible in "Recent Tickets" // So we should count JOBS where has_amc = 1. $amc_jobs_count_sql = "SELECT COUNT(*) as c FROM jobs WHERE has_amc = 1 $whereClause"; $amc_jobs_total = $conn->query($amc_jobs_count_sql)->fetch_assoc()['c']; ?>

AMC Jobs

Contracts Sold:

'blue', 'On Going' => 'amber', 'Pending' => 'purple', 'Cancelled' => 'red', 'Not Answered' => 'emerald', 'Refused' => 'gray' ]; foreach ($stats as $status => $count): $color = $colors[$status] ?? 'gray'; ?>

Recent Tickets

View All

query("SELECT id, customer_name, customer_phone, address, device_model, status, service_type, has_amc, created_at FROM jobs WHERE assigned_to = $user_id $whereClause ORDER BY created_at DESC LIMIT 5"); } else { // Use 1=1 to safely append whereClause (which starts with AND) $recent = $conn->query("SELECT id, customer_name, customer_phone, address, device_model, status, service_type, has_amc, created_at FROM jobs WHERE 1=1 $whereClause ORDER BY created_at DESC LIMIT 5"); } if ($recent && $recent->num_rows > 0): while($row = $recent->fetch_assoc()): $color = 'gray'; // Default if(isset($colors) && isset($colors[$row['status']])) { $color = $colors[$row['status']]; } else { // Fallback colors if $colors isn't defined (e.g. in accounts view) $c_map = ['New' => 'blue', 'On Going' => 'amber', 'Pending' => 'purple', 'Cancelled' => 'red', 'Not Answered' => 'emerald', 'Refused' => 'gray']; $color = $c_map[$row['status']] ?? 'gray'; } $is_amc = !empty($row['has_amc']); ?>

ID	Customer	Device	Status	Date
CTSC AMC	📍 Special		Recall

Create New Ticket