Name Department Company 1-Aug 2-Aug 3-Aug 4-Aug 5-Aug 6-Aug 7-Aug 8-Aug 9-Aug 10-Aug 11-Aug 12-Aug 13-Aug 14-Aug 15-Aug 16-Aug 17-Aug 18-Aug 19-Aug 20-Aug 21-Aug 22-Aug 23-Aug 24-Aug 25-Aug 26-Aug 27-Aug 28-Aug 29-Aug 30-Aug 31-Aug Total Workings Days Salary Per Month Per Day Per Day in Dollars Attendance " Total Amount
e6c535d verified | <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>Payroll Dashboard</title> | |
| <script src="https://cdn.tailwindcss.com"></script> | |
| <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> | |
| <script src="https://unpkg.com/feather-icons"></script> | |
| <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap" rel="stylesheet"> | |
| <style> | |
| body { | |
| font-family: 'Inter', sans-serif; | |
| background-color: #f8fafc; | |
| } | |
| .card { | |
| transition: all 0.3s ease; | |
| } | |
| .card:hover { | |
| transform: translateY(-5px); | |
| box-shadow: 0 10px 25px rgba(0, 0, 0, 0.1); | |
| } | |
| .department-tag { | |
| font-size: 0.75rem; | |
| padding: 0.25rem 0.5rem; | |
| border-radius: 9999px; | |
| } | |
| .RSA { | |
| background-color: #e0f2fe; | |
| color: #0369a1; | |
| } | |
| .I-I { | |
| background-color: #dcfce7; | |
| color: #166534; | |
| } | |
| </style> | |
| </head> | |
| <body class="bg-gray-50"> | |
| <div class="min-h-screen"> | |
| <!-- Header --> | |
| <header class="bg-white shadow-sm"> | |
| <div class="max-w-7xl mx-auto px-4 py-4 sm:px-6 lg:px-8 flex justify-between items-center"> | |
| <h1 class="text-2xl font-bold text-gray-800"> | |
| <span class="text-blue-600">Payroll</span> Visualization | |
| </h1> | |
| <div class="flex items-center space-x-4"> | |
| <div class="relative"> | |
| <input type="text" placeholder="Search employees..." class="pl-10 pr-4 py-2 border rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500"> | |
| <i data-feather="search" class="absolute left-3 top-2.5 text-gray-400"></i> | |
| </div> | |
| <button class="bg-blue-600 text-white px-4 py-2 rounded-lg hover:bg-blue-700 transition flex items-center"> | |
| <i data-feather="download" class="mr-2"></i> Export | |
| </button> | |
| </div> | |
| </div> | |
| </header> | |
| <!-- Main Content --> | |
| <main class="max-w-7xl mx-auto px-4 py-6 sm:px-6 lg:px-8"> | |
| <!-- Summary Cards --> | |
| <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-6 mb-8"> | |
| <div class="card bg-white p-6 rounded-xl shadow"> | |
| <div class="flex items-center justify-between"> | |
| <div> | |
| <p class="text-gray-500">Total Employees</p> | |
| <h3 class="text-3xl font-bold text-gray-800 mt-2">56</h3> | |
| </div> | |
| <div class="p-3 rounded-full bg-blue-100 text-blue-600"> | |
| <i data-feather="users"></i> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="card bg-white p-6 rounded-xl shadow"> | |
| <div class="flex items-center justify-between"> | |
| <div> | |
| <p class="text-gray-500">Total Payroll</p> | |
| <h3 class="text-3xl font-bold text-gray-800 mt-2">PKR 6.1M</h3> | |
| </div> | |
| <div class="p-3 rounded-full bg-green-100 text-green-600"> | |
| <i data-feather="dollar-sign"></i> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="card bg-white p-6 rounded-xl shadow"> | |
| <div class="flex items-center justify-between"> | |
| <div> | |
| <p class="text-gray-500">Average Salary</p> | |
| <h3 class="text-3xl font-bold text-gray-800 mt-2">PKR 109K</h3> | |
| </div> | |
| <div class="p-3 rounded-full bg-purple-100 text-purple-600"> | |
| <i data-feather="activity"></i> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="card bg-white p-6 rounded-xl shadow"> | |
| <div class="flex items-center justify-between"> | |
| <div> | |
| <p class="text-gray-500">Overtime Paid</p> | |
| <h3 class="text-3xl font-bold text-gray-800 mt-2">PKR 230K</h3> | |
| </div> | |
| <div class="p-3 rounded-full bg-yellow-100 text-yellow-600"> | |
| <i data-feather="clock"></i> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <!-- Charts Section --> | |
| <div class="grid grid-cols-1 lg:grid-cols-2 gap-6 mb-8"> | |
| <div class="card bg-white p-6 rounded-xl shadow"> | |
| <h2 class="text-lg font-semibold text-gray-800 mb-4">Salary Distribution by Department</h2> | |
| <div class="h-80"> | |
| <canvas id="departmentChart"></canvas> | |
| </div> | |
| </div> | |
| <div class="card bg-white p-6 rounded-xl shadow"> | |
| <h2 class="text-lg font-semibold text-gray-800 mb-4">Attendance Overview</h2> | |
| <div class="h-80"> | |
| <canvas id="attendanceChart"></canvas> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="grid grid-cols-1 gap-6 mb-8"> | |
| <div class="card bg-white p-6 rounded-xl shadow"> | |
| <h2 class="text-lg font-semibold text-gray-800 mb-4">Salary Range Distribution</h2> | |
| <div class="h-96"> | |
| <canvas id="salaryRangeChart"></canvas> | |
| </div> | |
| </div> | |
| </div> | |
| <!-- Employee Table --> | |
| <div class="card bg-white rounded-xl shadow overflow-hidden mb-8"> | |
| <div class="px-6 py-4 border-b border-gray-200 flex justify-between items-center"> | |
| <h2 class="text-lg font-semibold text-gray-800">Employee Details</h2> | |
| <div class="flex space-x-2"> | |
| <button class="px-3 py-1 text-sm border rounded-md hover:bg-gray-50">RSA</button> | |
| <button class="px-3 py-1 text-sm border rounded-md hover:bg-gray-50">I&I</button> | |
| <button class="px-3 py-1 text-sm border rounded-md hover:bg-gray-50">All</button> | |
| </div> | |
| </div> | |
| <div class="overflow-x-auto"> | |
| <table class="min-w-full divide-y divide-gray-200"> | |
| <thead class="bg-gray-50"> | |
| <tr> | |
| <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Name</th> | |
| <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Department</th> | |
| <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Company</th> | |
| <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Salary</th> | |
| <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Days Worked</th> | |
| <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Payable</th> | |
| <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Status</th> | |
| </tr> | |
| </thead> | |
| <tbody class="bg-white divide-y divide-gray-200"> | |
| <tr class="hover:bg-gray-50"> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <div class="flex items-center"> | |
| <div class="flex-shrink-0 h-10 w-10 rounded-full bg-blue-100 flex items-center justify-center"> | |
| <span class="text-blue-600 font-medium">AM</span> | |
| </div> | |
| <div class="ml-4"> | |
| <div class="text-sm font-medium text-gray-900">Abdul Moiz</div> | |
| <div class="text-sm text-gray-500">Nurse Navigator</div> | |
| </div> | |
| </div> | |
| </td> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <span class="department-tag RSA">RSA</span> | |
| </td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">RSA</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">PKR 35,000</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">21</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">PKR 35,000</td> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-green-100 text-green-800">Paid</span> | |
| </td> | |
| </tr> | |
| <tr class="hover:bg-gray-50"> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <div class="flex items-center"> | |
| <div class="flex-shrink-0 h-10 w-10 rounded-full bg-blue-100 flex items-center justify-center"> | |
| <span class="text-blue-600 font-medium">AT</span> | |
| </div> | |
| <div class="ml-4"> | |
| <div class="text-sm font-medium text-gray-900">Abu Talha Ijaz</div> | |
| <div class="text-sm text-gray-500">Patient Navigator</div> | |
| </div> | |
| </div> | |
| </td> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <span class="department-tag RSA">RSA</span> | |
| </td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">RSA</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">PKR 40,000</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">20</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">PKR 38,095</td> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-green-100 text-green-800">Paid</span> | |
| </td> | |
| </tr> | |
| <tr class="hover:bg-gray-50"> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <div class="flex items-center"> | |
| <div class="flex-shrink-0 h-10 w-10 rounded-full bg-blue-100 flex items-center justify-center"> | |
| <span class="text-blue-600 font-medium">AD</span> | |
| </div> | |
| <div class="ml-4"> | |
| <div class="text-sm font-medium text-gray-900">Adeel</div> | |
| <div class="text-sm text-gray-500">Finals Lead</div> | |
| </div> | |
| </div> | |
| </td> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <span class="department-tag RSA">RSA</span> | |
| </td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">RSA</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">PKR 76,435</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">20</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">PKR 76,435</td> | |
| <td class="px-6 py-4 whitespace-nowrap"> | |
| <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-green-100 text-green-800">Paid</span> | |
| </td> | |
| </tr> | |
| <!-- More rows would be added here --> | |
| </tbody> | |
| </table> | |
| </div> | |
| <div class="px-6 py-4 border-t border-gray-200 flex items-center justify-between"> | |
| <div class="text-sm text-gray-500"> | |
| Showing <span class="font-medium">1</span> to <span class="font-medium">10</span> of <span class="font-medium">56</span> employees | |
| </div> | |
| <div class="flex space-x-2"> | |
| <button class="px-3 py-1 border rounded-md text-sm font-medium hover:bg-gray-50">Previous</button> | |
| <button class="px-3 py-1 border rounded-md text-sm font-medium bg-blue-600 text-white hover:bg-blue-700">1</button> | |
| <button class="px-3 py-1 border rounded-md text-sm font-medium hover:bg-gray-50">2</button> | |
| <button class="px-3 py-1 border rounded-md text-sm font-medium hover:bg-gray-50">3</button> | |
| <button class="px-3 py-1 border rounded-md text-sm font-medium hover:bg-gray-50">Next</button> | |
| </div> | |
| </div> | |
| </div> | |
| </main> | |
| </div> | |
| <script> | |
| feather.replace(); | |
| // Department Chart | |
| const departmentCtx = document.getElementById('departmentChart').getContext('2d'); | |
| const departmentChart = new Chart(departmentCtx, { | |
| type: 'doughnut', | |
| data: { | |
| labels: ['RSA', 'I&I'], | |
| datasets: [{ | |
| data: [4500000, 1600000], | |
| backgroundColor: ['#3b82f6', '#10b981'], | |
| borderWidth: 0 | |
| }] | |
| }, | |
| options: { | |
| responsive: true, | |
| maintainAspectRatio: false, | |
| plugins: { | |
| legend: { | |
| position: 'right', | |
| }, | |
| tooltip: { | |
| callbacks: { | |
| label: function(context) { | |
| return `PKR ${context.raw.toLocaleString()}`; | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }); | |
| // Attendance Chart | |
| const attendanceCtx = document.getElementById('attendanceChart').getContext('2d'); | |
| const attendanceChart = new Chart(attendanceCtx, { | |
| type: 'bar', | |
| data: { | |
| labels: ['Present', 'Absent', 'Late'], | |
| datasets: [{ | |
| label: 'Days', | |
| data: [1200, 56, 42], | |
| backgroundColor: ['#10b981', '#ef4444', '#f59e0b'], | |
| borderWidth: 0 | |
| }] | |
| }, | |
| options: { | |
| responsive: true, | |
| maintainAspectRatio: false, | |
| scales: { | |
| y: { | |
| beginAtZero: true | |
| } | |
| }, | |
| plugins: { | |
| tooltip: { | |
| callbacks: { | |
| label: function(context) { | |
| return `${context.raw} days`; | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }); | |
| // Salary Range Chart | |
| const salaryRangeCtx = document.getElementById('salaryRangeChart').getContext('2d'); | |
| const salaryRangeChart = new Chart(salaryRangeCtx, { | |
| type: 'bar', | |
| data: { | |
| labels: ['< 50K', '50K-100K', '100K-150K', '150K-200K', '> 200K'], | |
| datasets: [{ | |
| label: 'Employees', | |
| data: [18, 22, 10, 4, 2], | |
| backgroundColor: '#3b82f6', | |
| borderWidth: 0 | |
| }] | |
| }, | |
| options: { | |
| responsive: true, | |
| maintainAspectRatio: false, | |
| scales: { | |
| y: { | |
| beginAtZero: true | |
| } | |
| }, | |
| plugins: { | |
| legend: { | |
| display: false | |
| }, | |
| tooltip: { | |
| callbacks: { | |
| label: function(context) { | |
| return `${context.raw} employees`; | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }); | |
| </script> | |
| </body> | |
| </html> | |