MAINHACK

Viewing / Editing File: transactions.php

<?php
require_once '../config/database.php';
require_once '../config/functions.php';

requireAuth('accountant');

// Get search parameters
$date_from = $_GET['date_from'] ?? date('Y-m-01');
$date_to = $_GET['date_to'] ?? date('Y-m-d');
$transaction_type = $_GET['transaction_type'] ?? '';

// Build query conditions
$where_conditions = [];
$params = [];

if ($transaction_type === 'payments') {
    $where_conditions[] = "DATE(created_at) BETWEEN ? AND ?";
    $params = [$date_from, $date_to];
    
    // Get payments
    $stmt = $pdo->prepare("
        SELECT 'payment' as type, p.id, p.receipt_number as number, 
               c.name as client_name, c.phone as client_phone,
               u.full_name as representative_name, p.amount, 
               p.previous_balance, p.new_balance, p.created_at,
               NULL as product_name, NULL as quantity
        FROM payments p
        JOIN clients c ON p.client_id = c.id
        LEFT JOIN users u ON p.representative_id = u.id
        WHERE " . implode(' AND ', $where_conditions) . "
        ORDER BY p.created_at DESC
    ");
    $stmt->execute($params);
    $transactions = $stmt->fetchAll();
    
} elseif ($transaction_type === 'returns') {
    $where_conditions[] = "DATE(processed_at) BETWEEN ? AND ? AND status = 'approved'";
    $params = [$date_from, $date_to];
    
    // Get approved returns
    $stmt = $pdo->prepare("
        SELECT 'return' as type, r.id, r.return_number as number,
               c.name as client_name, c.phone as client_phone,
               u.full_name as representative_name, r.return_value as amount,
               r.client_balance_before as previous_balance, 
               r.client_balance_after as new_balance, r.processed_at as created_at,
               p.name as product_name, r.quantity
        FROM returns r
        JOIN clients c ON r.client_id = c.id
        JOIN users u ON r.representative_id = u.id
        JOIN products p ON r.product_id = p.id
        WHERE " . implode(' AND ', $where_conditions) . "
        ORDER BY r.processed_at DESC
    ");
    $stmt->execute($params);
    $transactions = $stmt->fetchAll();
    
} else {
    // Get both payments and returns
    $stmt = $pdo->prepare("
        (SELECT 'payment' as type, p.id, p.receipt_number as number, 
                c.name as client_name, c.phone as client_phone,
                u.full_name as representative_name, p.amount, 
                p.previous_balance, p.new_balance, p.created_at,
                NULL as product_name, NULL as quantity
         FROM payments p
         JOIN clients c ON p.client_id = c.id
         LEFT JOIN users u ON p.representative_id = u.id
         WHERE DATE(p.created_at) BETWEEN ? AND ?)
        UNION ALL
        (SELECT 'return' as type, r.id, r.return_number as number,
                c.name as client_name, c.phone as client_phone,
                u.full_name as representative_name, r.return_value as amount,
                r.client_balance_before as previous_balance, 
                r.client_balance_after as new_balance, r.processed_at as created_at,
                p.name as product_name, r.quantity
         FROM returns r
         JOIN clients c ON r.client_id = c.id
         JOIN users u ON r.representative_id = u.id
         JOIN products p ON r.product_id = p.id
         WHERE DATE(r.processed_at) BETWEEN ? AND ? AND r.status = 'approved')
        ORDER BY created_at DESC
    ");
    $stmt->execute([$date_from, $date_to, $date_from, $date_to]);
    $transactions = $stmt->fetchAll();
}

// Calculate totals
$total_payments = 0;
$total_returns = 0;
foreach ($transactions as $transaction) {
    if ($transaction['type'] === 'payment') {
        $total_payments += $transaction['amount'];
    } else {
        $total_returns += $transaction['amount'];
    }
}
?>

<!DOCTYPE html>
<html lang="ar" dir="rtl">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>التدفق المالي - حسابات عربية بن فريش</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.rtl.min.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css" rel="stylesheet">
    <style>
        .filter-card {
            background: linear-gradient(135deg, #0d6efd, #198754);
            color: white;
            border-radius: 15px;
        }
        .transaction-payment {
            border-left: 4px solid #198754;
        }
        .transaction-return {
            border-left: 4px solid #fd7e14;
        }
        .whatsapp-btn {
            background: #25d366;
            border: none;
            color: white;
            border-radius: 50%;
            width: 35px;
            height: 35px;
            display: flex;
            align-items: center;
            justify-content: center;
        }
        .whatsapp-btn:hover {
            background: #128c7e;
            color: white;
        }
    </style>
</head>
<body class="bg-light">
    <div class="container-fluid mt-4">
        <div class="d-flex justify-content-between align-items-center mb-4">
            <h2><i class="fas fa-exchange-alt me-2"></i>التدفق المالي</h2>
            <a href="/dashboard.php" class="btn btn-outline-secondary">
                <i class="fas fa-arrow-left me-1"></i>العودة
            </a>
        </div>

<div class="filter-card p-4 mb-4">
            <h5 class="mb-3"><i class="fas fa-filter me-2"></i>تصفية العمليات</h5>
            <form method="GET" class="row align-items-end">
                <div class="col-md-3">
                    <label class="form-label">من تاريخ</label>
                    <input type="date" class="form-control" name="date_from" value="<?= htmlspecialchars($date_from) ?>">
                </div>
                <div class="col-md-3">
                    <label class="form-label">إلى تاريخ</label>
                    <input type="date" class="form-control" name="date_to" value="<?= htmlspecialchars($date_to) ?>">
                </div>
                <div class="col-md-3">
                    <label class="form-label">نوع العملية</label>
                    <select class="form-select" name="transaction_type">
                        <option value="">جميع العمليات</option>
                        <option value="payments" <?= $transaction_type === 'payments' ? 'selected' : '' ?>>المدفوعات فقط</option>
                        <option value="returns" <?= $transaction_type === 'returns' ? 'selected' : '' ?>>المرتجعات فقط</option>
                    </select>
                </div>
                <div class="col-md-3">
                    <button type="submit" class="btn btn-light">
                        <i class="fas fa-search me-1"></i>تحديث
                    </button>
                </div>
            </form>
        </div>

<div class="row mb-4">
            <div class="col-md-4">
                <div class="card bg-success text-white">
                    <div class="card-body text-center">
                        <h4><?= formatCurrency($total_payments) ?></h4>
                        <p class="mb-0">إجمالي المدفوعات</p>
                    </div>
                </div>
            </div>
            <div class="col-md-4">
                <div class="card bg-warning text-white">
                    <div class="card-body text-center">
                        <h4><?= formatCurrency($total_returns) ?></h4>
                        <p class="mb-0">إجمالي المرتجعات</p>
                    </div>
                </div>
            </div>
            <div class="col-md-4">
                <div class="card bg-primary text-white">
                    <div class="card-body text-center">
                        <h4><?= formatCurrency($total_payments - $total_returns) ?></h4>
                        <p class="mb-0">صافي التدفق</p>
                    </div>
                </div>
            </div>
        </div>

<div class="card">
            <div class="card-header bg-primary text-white">
                <h5 class="mb-0">
                    <i class="fas fa-list me-2"></i>
                    العمليات المالية (<?= count($transactions) ?>)
                </h5>
            </div>
            <div class="card-body p-0">
                <?php if (empty($transactions)): ?>
                    <div class="text-center py-5">
                        <i class="fas fa-inbox fa-3x text-muted mb-3"></i>
                        <p class="text-muted">لا توجد عمليات في الفترة المحددة</p>
                    </div>
                <?php else: ?>
                    <div class="table-responsive">
                        <table class="table table-hover mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>النوع</th>
                                    <th>الرقم</th>
                                    <th>العميل</th>
                                    <th>المندوب</th>
                                    <th>التفاصيل</th>
                                    <th>المبلغ</th>
                                    <th>الرصيد السابق</th>
                                    <th>الرصيد الجديد</th>
                                    <th>التاريخ</th>
                                    <th>واتساب</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($transactions as $transaction): ?>
                                    <tr class="transaction-<?= $transaction['type'] ?>">
                                        <td>
                                            <?php if ($transaction['type'] === 'payment'): ?>
                                                <span class="badge bg-success">دفعة</span>
                                            <?php else: ?>
                                                <span class="badge bg-warning">مرتجع</span>
                                            <?php endif; ?>
                                        </td>
                                        <td><?= htmlspecialchars($transaction['number']) ?></td>
                                        <td>
                                            <?= htmlspecialchars($transaction['client_name']) ?>
                                            <br><small class="text-muted"><?= htmlspecialchars($transaction['client_phone']) ?></small>
                                        </td>
                                        <td><?= htmlspecialchars($transaction['representative_name'] ?: 'نظام') ?></td>
                                        <td>
                                            <?php if ($transaction['type'] === 'return'): ?>
                                                <?= htmlspecialchars($transaction['product_name']) ?>
                                                <br><small class="text-muted">الكمية: <?= $transaction['quantity'] ?></small>
                                            <?php else: ?>
                                                دفعة نقدية
                                            <?php endif; ?>
                                        </td>
                                        <td>
                                            <span class="fw-bold <?= $transaction['type'] === 'payment' ? 'text-success' : 'text-warning' ?>">
                                                <?= formatCurrency($transaction['amount']) ?>
                                            </span>
                                        </td>
                                        <td><?= formatCurrency($transaction['previous_balance']) ?></td>
                                        <td><?= formatCurrency($transaction['new_balance']) ?></td>
                                        <td><?= date('Y-m-d H:i', strtotime($transaction['created_at'])) ?></td>
                                        <td>
                                            <?php if (hasRole('accountant')): ?>
                                                <?php if ($transaction['type'] === 'payment'): ?>
                                                    <a href="<?= generatePaymentWhatsAppURL($transaction, $transaction['client_phone']) ?>" 
                                                       target="_blank" class="whatsapp-btn" title="إرسال إيصال">
                                                        <i class="fab fa-whatsapp"></i>
                                                    </a>
                                                <?php else: ?>
                                                    <a href="<?= generateReturnWhatsAppURL($transaction, $transaction['client_phone']) ?>" 
                                                       target="_blank" class="whatsapp-btn" title="إرسال إشعار مرتجع">
                                                        <i class="fab fa-whatsapp"></i>
                                                    </a>
                                                <?php endif; ?>
                                            <?php endif; ?>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php endif; ?>
            </div>
        </div>
    </div>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: transactions.php

Server Info

System Features

User Info