Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
contact.php	9.39 KB	-rw-r--r--	2026-03-01 23:09
dashboard.php	12.62 KB	-rw-r--r--	2026-03-01 23:07
login.php	3.36 KB	-rw-r--r--	2026-03-01 20:35
logout.php	90 B	-rw-r--r--	2026-03-01 20:36
orders.php	24.63 KB	-rw-r--r--	2026-03-01 23:09
payment_methods.php	16.54 KB	-rw-r--r--	2026-03-01 23:03
save_contact.php	1.4 KB	-rw-r--r--	2026-03-01 20:30
services.php	15.75 KB	-rw-r--r--	2026-03-01 23:05
settings.php	6.88 KB	-rw-r--r--	2026-03-01 23:10
users.php	7.52 KB	-rw-r--r--	2026-03-01 23:08
verify_payment.php	13.79 KB	-rw-r--r--	2026-03-01 23:18
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
include '../includes/db.php';
session_start();

if (!isset($_SESSION['admin_id'])) {
    header('Location: login.php');
    exit;
}

// Update Status & Handle Delivery
if (isset($_POST['update_status'])) {
    $order_id = $_POST['order_id'];
    $new_status = $_POST['status'];

$labels = [
        1 => 'Order Placed',
        2 => 'Requirements Analysis',
        3 => 'Design Phase',
        4 => 'Core Development',
        5 => 'Quality Assurance',
        6 => 'Beta Testing',
        7 => 'Final Refinements',
        8 => 'Order Complete'
    ];
    $label = $labels[$new_status] ?? 'Updated';

$deliverable_path = null;
    if (isset($_FILES['deliverable']) && $_FILES['deliverable']['error'] == 0) {
        $upload_dir = '../uploads/deliverables/';
        if (!is_dir($upload_dir))
            mkdir($upload_dir, 0777, true);
        $filename = "CS_ORDER_" . $order_id . "_" . time() . "_" . basename($_FILES['deliverable']['name']);
        if (move_uploaded_file($_FILES['deliverable']['tmp_name'], $upload_dir . $filename))
            $deliverable_path = $filename;
    }

if ($deliverable_path) {
        $stmt = $pdo->prepare("UPDATE orders SET order_status = ?, deliverable_file = ? WHERE id = ?");
        $stmt->execute([$new_status, $deliverable_path, $order_id]);
    }
    else {
        $stmt = $pdo->prepare("UPDATE orders SET order_status = ? WHERE id = ?");
        $stmt->execute([$new_status, $order_id]);
    }

$stmt = $pdo->prepare("INSERT INTO order_status_history (order_id, status_label) VALUES (?, ?)");
    $stmt->execute([$order_id, $label]);
    header('Location: orders.php?success=1');
    exit;
}

// Handle Payment Approval/Rejection
if (isset($_POST['process_payment'])) {
    $order_id = $_POST['order_id'];
    $action = $_POST['action']; // 'Accept' or 'Reject'

if ($action == 'Accept') {
        $stmt = $pdo->prepare("UPDATE orders SET payment_status = 'Paid', order_status = CASE WHEN order_status = 1 THEN 2 ELSE order_status END WHERE id = ?");
        $stmt->execute([$order_id]);
        $msg = "payment_approved=1";
    }
    else {
        $stmt = $pdo->prepare("UPDATE orders SET payment_status = 'Unpaid', payment_screenshot = NULL WHERE id = ?");
        $stmt->execute([$order_id]);
        $msg = "payment_rejected=1";
    }
    header('Location: orders.php?' . $msg);
    exit;
}

$orders = $pdo->query("
    SELECT o.*, u.name as client_name, u.email as client_email, s.name as service_name, s.price as service_price 
    FROM orders o 
    JOIN users u ON o.user_id = u.id 
    JOIN services s ON o.service_id = s.id 
    ORDER BY o.ordered_at DESC
")->fetchAll();

$sidebar_links = [
    ['name' => 'Dashboard', 'icon' => 'fas fa-chart-line', 'active' => true, 'url' => 'dashboard.php'],
    ['name' => 'Users', 'icon' => 'fas fa-users', 'active' => false, 'url' => 'users.php'],
    ['name' => 'Services', 'icon' => 'fas fa-layer-group', 'active' => false, 'url' => 'services.php'],
    ['name' => 'Orders', 'icon' => 'fas fa-shopping-cart', 'active' => false, 'url' => 'orders.php'],
    ['name' => 'Payment Setup', 'icon' => 'fas fa-credit-card', 'active' => false, 'url' => 'payment_methods.php'],
    ['name' => 'Contact Details', 'icon' => 'fas fa-address-book', 'active' => false, 'url' => 'contact.php'],
    ['name' => 'Admin Details', 'icon' => 'fas fa-user-shield', 'active' => false, 'url' => 'settings.php'],
];
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Pipeline Management | Admin</title>
    <link rel="stylesheet" href="../assets/css/style.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        :root { --sidebar-width: 280px; }
        body { background: #fafafa; overflow: hidden; color: #0f172a; }
        .sidebar { width: var(--sidebar-width); height: 100vh; background: #ffffff; border-right: 1px solid rgba(0,0,0,0.05); position: fixed; left: 0; top: 0; padding: 3rem 1.5rem; display: flex; flex-direction: column; }
        .main-content { margin-left: var(--sidebar-width); height: 100vh; padding: 4rem; overflow-y: auto; }
        .sidebar-link { display: flex; align-items: center; gap: 1.2rem; padding: 1.1rem 1.5rem; border-radius: 12px; color: #64748b; margin-bottom: 0.5rem; font-weight: 600; text-decoration: none; transition: 0.2s; }
        .sidebar-link:hover, .sidebar-link.active { color: var(--primary); background: #f0fdf4; }
        .card { background: #fff; padding: 2.5rem; border-radius: 30px; border: 1px solid rgba(0,0,0,0.05); margin-bottom: 2rem; box-shadow: 0 10px 30px rgba(0,0,0,0.02); }
        table { width: 100%; border-collapse: collapse; }
        th { text-align: left; padding: 1.2rem; color: #64748b; font-size: 0.75rem; border-bottom: 2px solid #f1f5f9; text-transform: uppercase; letter-spacing: 1px; }
        td { padding: 1.5rem 1.2rem; border-bottom: 1px solid #f1f5f9; font-weight: 600; font-size: 0.9rem; }
        .status-badge { padding: 0.5rem 1rem; border-radius: 20px; font-size: 0.7rem; font-weight: 800; display: inline-block; text-decoration: none;}
        select { padding: 0.6rem; border-top-left-radius: 10px; border-bottom-left-radius: 10px; border: 1px solid #e2e8f0; font-weight: 600; font-size: 0.8rem; background: #f8fafc; outline: none; }

/* Responsive Styles */
        .mobile-admin-header { display: none; }
        .sidebar-overlay { display: none; }
        .mobile-only { display: none; }

@media (max-width: 1024px) {
            .sidebar {
                left: -var(--sidebar-width);
                transition: left 0.3s ease-in-out;
                z-index: 1001;
                box-shadow: 5px 0 15px rgba(0,0,0,0.1);
            }
            .sidebar.active { left: 0; }
            .main-content { margin-left: 0; padding: 2rem; }
            .mobile-admin-header {
                display: flex;
                justify-content: space-between;
                align-items: center;
                padding: 1rem 2rem;
                background: #fff;
                border-bottom: 1px solid rgba(0,0,0,0.05);
                position: sticky;
                top: 0;
                z-index: 1000;
            }
            .mobile-toggle {
                display: flex;
                flex-direction: column;
                gap: 5px;
                cursor: pointer;
            }
            .mobile-toggle span {
                width: 25px;
                height: 3px;
                background: #0f172a;
                border-radius: 2px;
            }
            .sidebar-overlay {
                display: block;
                position: fixed;
                top: 0;
                left: 0;
                width: 100%;
                height: 100%;
                background: rgba(0,0,0,0.5);
                z-index: 1000;
                opacity: 0;
                visibility: hidden;
                transition: opacity 0.3s ease-in-out, visibility 0.3s ease-in-out;
            }
            .sidebar-overlay.active {
                opacity: 1;
                visibility: visible;
            }
            .mobile-only { display: block; }
            .sidebar .logo { display: none !important; } /* Hide desktop logo */
            .sidebar > div:first-of-type { margin-bottom: 0; } /* Adjust margin for mobile */
        }
    </style>
</head>
<body>

<div class="mobile-admin-header">
        <a href="dashboard.php" class="logo" style="font-size: 1.4rem; text-decoration:none; color:#0f172a;">CodeBy<span style="color: var(--primary);">Sycho</span></a>
        <div class="mobile-toggle" onclick="toggleSidebar()">
            <span></span>
            <span></span>
            <span></span>
        </div>
    </div>

<div class="sidebar-overlay" id="sidebarOverlay" onclick="toggleSidebar()"></div>

<aside class="sidebar" id="adminSidebar">
        <div class="mobile-only" style="text-align: right; padding: 0 1rem 2rem 0;">
            <button onclick="toggleSidebar()" style="background:none; border:none; font-size: 1.5rem; color: #64748b;"><i class="fas fa-times"></i></button>
        </div>
        <a href="dashboard.php" class="logo" style="margin-bottom: 5rem; font-size: 1.8rem; text-decoration:none; color:#0f172a;">CodeBy<span style="color: var(--primary);">Sycho</span></a>
        <div style="flex-grow: 1;">
            <?php foreach ($sidebar_links as $link): ?>
                <a href="<?php echo $link['url']; ?>" class="sidebar-link <?php echo $link['active'] ? 'active' : ''; ?>">
                    <i class="<?php echo $link['icon']; ?>"></i> <?php echo $link['name']; ?>
                </a>
            <?php
endforeach; ?>
        </div>
        <div style="padding-top: 2rem; border-top: 1px solid #f1f5f9;">
            <a href="logout.php" style="color: #ef4444; font-weight: 700; text-decoration: none;"><i class="fas fa-power-off"></i> Logout</a>
        </div>
    </aside>

<main class="main-content">
        <div style="display:flex; justify-content:space-between; align-items:center; margin-bottom: 3.5rem; flex-wrap: wrap; gap: 1rem;">
            <div>
                <p style="font-size: 0.75rem; font-weight: 800; color: var(--primary); text-transform: uppercase; letter-spacing: 2px; margin-bottom: 0.5rem;">Operations Floor</p>
                <h1 style="font-size: 1.8rem; font-weight: 800; color: #0f172a; letter-spacing: -0.5px;">Project Pipeline</h1>
            </div>
            <div style="background: var(--primary-light); padding: 0.8rem 1.5rem; border-radius: 12px; font-weight: 800; color: var(--primary); font-size: 0.9rem;">
                Live Operations: <?php echo count($orders); ?>
            </div>
        </div>

<?php if (isset($_GET['payment_approved'])): ?>
            <div style="background: #dcfce7; color: #166534; padding: 1rem; border-radius: 12px; margin-bottom: 2rem; font-weight: 700; font-size: 0.9rem;"><i class="fas fa-check-circle" style="margin-right: 0.8rem;"></i> Payment Verified & Workflow Progressed.</div>
        <?php
endif; ?>
        <?php if (isset($_GET['payment_rejected'])): ?>
            <div style="background: #fee2e2; color: #991b1b; padding: 1rem; border-radius: 12px; margin-bottom: 2rem; font-weight: 700; font-size: 0.9rem;"><i class="fas fa-times-circle" style="margin-right: 0.8rem;"></i> Payment Rejected. Notification sent back to client.</div>
        <?php
endif; ?>

<div class="card admin-card">
            
            <table class="desktop-only-table">
                <thead>
                    <tr>
                        <th style="padding-left: 0;">Order ID</th>
                        <th>Stakeholder</th>
                        <th>Project Focus</th>
                        <th>Fiscal</th>
                        <th>Workflow Stage</th>
                        <th>Operations</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
$labels = [1 => 'Order Placed', 2 => 'Requirements Analysis', 3 => 'Design Phase', 4 => 'Core Development', 5 => 'Quality Assurance', 6 => 'Beta Testing', 7 => 'Final Refinements', 8 => 'Order Complete'];
foreach ($orders as $order): ?>
                        <tr>
                            <td style="padding-left: 0; color: var(--primary); font-weight: 800;">#CS-<?php echo str_pad($order['id'], 4, '0', STR_PAD_LEFT); ?></td>
                            <td>
                                <div style="display: flex; align-items: center; gap: 0.8rem;">
                                    <div style="width: 35px; height: 35px; background: #f1f5f9; border-radius: 10px; display: flex; align-items: center; justify-content: center; font-size: 0.8rem; font-weight: 800; color: #64748b;">
                                        <?php echo strtoupper($order['client_name'][0]); ?>
                                    </div>
                                    <div>
                                        <div style="font-weight: 800; font-size: 0.9rem;"><?php echo htmlspecialchars($order['client_name']); ?></div>
                                        <div style="font-size: 0.7rem; color: #94a3b8;"><?php echo htmlspecialchars($order['client_email']); ?></div>
                                    </div>
                                </div>
                            </td>
                            <td>
                                <div style="font-weight: 800; font-size: 0.9rem;"><?php echo htmlspecialchars($order['service_name']); ?></div>
                                <div style="color: var(--primary); font-size: 0.8rem; font-weight: 800;">$<?php echo number_format($order['service_price'], 2); ?></div>
                            </td>
                            <td>
                                <?php if ($order['payment_status'] == 'Paid'): ?>
                                    <span class="status-badge" style="background: #dcfce7; color: #166534;"><i class="fas fa-check-circle"></i> VERIFIED</span>
                                <?php
    elseif ($order['payment_status'] == 'Pending Approval'): ?>
                                    <a href="verify_payment.php?order_id=<?php echo $order['id']; ?>" class="status-badge" style="background: #fef9c3; color: #854d0e; border: 1px solid #fde047; text-decoration: none;">REVIEW</a>
                                <?php
    else: ?>
                                    <span class="status-badge" style="background: #fee2e2; color: #991b1b;">WAITING</span>
                                <?php
    endif; ?>
                            </td>
                            <td>
                                <span class="status-badge" style="background: #f1f5f9; color: #475569; border: 1px solid #e2e8f0;">
                                    Stage <?php echo $order['order_status']; ?>
                                </span>
                            </td>
                            <td>
                                <form action="" method="POST" enctype="multipart/form-data" style="display: flex; align-items: center;">
                                    <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                                    <select name="status" onchange="toggleUpload(this, <?php echo $order['id']; ?>)" style="padding: 0.5rem; border-radius: 8px 0 0 8px; border: 1px solid #e2e8f0; font-size: 0.75rem;">
                                        <?php foreach ($labels as $id => $text): ?>
                                            <option value="<?php echo $id; ?>" <?php echo $order['order_status'] == $id ? 'selected' : ''; ?>>Stage <?php echo $id; ?></option>
                                        <?php
    endforeach; ?>
                                    </select>
                                    <div id="upload-<?php echo $order['id']; ?>" style="display: <?php echo $order['order_status'] == 8 ? 'block' : 'none'; ?>; background:#f8fafc; border:1px solid #e2e8f0; border-left:none; padding: 0.4rem;">
                                        <input type="file" name="deliverable" style="font-size: 0.6rem; width: 100px;">
                                    </div>
                                    <button type="submit" name="update_status" style="background: var(--primary); color: #fff; border:none; padding: 0.55rem 1rem; border-radius: 0 8px 8px 0; font-weight:800; cursor:pointer; font-size:0.75rem;">PUSH</button>
                                </form>
                            </td>
                        </tr>
                    <?php
endforeach; ?>
                </tbody>
            </table>

<div class="mobile-only-list">
                <?php foreach ($orders as $order): ?>
                    <div style="background: #f8fafc; border: 1px solid #f1f5f9; border-radius: 20px; padding: 1.5rem; margin-bottom: 1.2rem;">
                        <div style="display: flex; justify-content: space-between; align-items: flex-start; margin-bottom: 1rem;">
                            <div>
                                <span style="display: block; color: var(--primary); font-weight: 800; font-size: 0.8rem; margin-bottom: 0.3rem;">#CS-<?php echo str_pad($order['id'], 4, '0', STR_PAD_LEFT); ?></span>
                                <h4 style="margin: 0; font-weight: 800; color: var(--text-main);"><?php echo htmlspecialchars($order['client_name']); ?></h4>
                            </div>
                            <?php if ($order['payment_status'] == 'Paid'): ?>
                                <span class="status-badge" style="background: #dcfce7; color: #166534; margin: 0;">VERIFIED</span>
                            <?php
    elseif ($order['payment_status'] == 'Pending Approval'): ?>
                                <a href="verify_payment.php?order_id=<?php echo $order['id']; ?>" class="status-badge" style="background: #fef9c3; color: #854d0e; text-decoration: none; margin: 0;">REVIEW</a>
                            <?php
    else: ?>
                                <span class="status-badge" style="background: #fee2e2; color: #991b1b; margin: 0;">WAITING</span>
                            <?php
    endif; ?>
                        </div>
                        
                        <div style="background: #fff; border-radius: 12px; padding: 1rem; margin-bottom: 1.2rem; border: 1px solid #eff6ff;">
                            <div style="font-weight: 800; font-size: 0.9rem;"><?php echo htmlspecialchars($order['service_name']); ?></div>
                            <div style="color: var(--primary); font-size: 0.85rem; font-weight: 800;">$<?php echo number_format($order['service_price'], 2); ?></div>
                        </div>

<form action="" method="POST" enctype="multipart/form-data">
                            <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                            <div style="display: flex; flex-direction: column; gap: 0.8rem;">
                                <div style="display: flex; gap: 0.5rem; align-items: center;">
                                    <select name="status" onchange="toggleUpload(this, <?php echo $order['id']; ?>)" style="flex: 1; padding: 0.8rem; border-radius: 10px; border: 1px solid #e2e8f0; font-weight: 700; font-size: 0.85rem;">
                                        <?php foreach ($labels as $id => $text): ?>
                                            <option value="<?php echo $id; ?>" <?php echo $order['order_status'] == $id ? 'selected' : ''; ?>><?php echo $text; ?></option>
                                        <?php
    endforeach; ?>
                                    </select>
                                    <button type="submit" name="update_status" style="background: var(--primary); color: #fff; border:none; padding: 0.8rem 1.5rem; border-radius: 10px; font-weight: 800;">PUSH</button>
                                </div>
                                <div id="upload-mobile-<?php echo $order['id']; ?>" style="display: <?php echo $order['order_status'] == 8 ? 'block' : 'none'; ?>; background:#fff; border:1px solid #e2e8f0; border-radius: 10px; padding: 0.8rem;">
                                    <label style="display: block; font-size: 0.7rem; font-weight: 800; color: #64748b; margin-bottom: 0.5rem;">ATTACH DELIVERABLE</label>
                                    <input type="file" name="deliverable" style="font-size: 0.8rem; width: 100%;">
                                </div>
                            </div>
                        </form>
                    </div>
                <?php
endforeach; ?>
            </div>
        </div>
    </main>

<div id="v-modal" style="display: none; position: fixed; top: 0; left: 0; width: 100%; height: 100%; background: rgba(0,0,0,0.6); z-index: 1000; align-items: center; justify-content: center; backdrop-filter: blur(15px); padding: 2rem;">
        <div style="background: #fff; width: 100%; max-width: 800px; padding: 4rem; border-radius: 40px; box-shadow: 0 40px 100px rgba(0,0,0,0.2); position: relative; max-height: 90vh; overflow-y: auto;">
            <button onclick="closeModal()" style="position: absolute; top: 30px; right: 30px; background: none; border: none; font-size: 1.5rem; cursor: pointer; color: #94a3b8;"><i class="fas fa-times"></i></button>
            
            <h2 style="font-weight: 900; font-size: 2rem; margin-bottom: 2rem; color: #0f172a;">Review Settlement</h2>
            
            <div style="display: grid; grid-template-columns: 1fr 1fr; gap: 3rem; margin-bottom: 4rem; padding-bottom: 3rem; border-bottom: 1px solid #f1f5f9;">
                <div>
                    <p style="text-transform:uppercase; font-size:0.7rem; font-weight:800; color:#94a3b8; letter-spacing:1px; margin-bottom:1rem;">Operational Details</p>
                    <div style="font-weight: 800; font-size: 1.3rem; margin-bottom: 0.5rem;" id="v-order-no">#CS-0000</div>
                    <div style="font-weight: 700; color: #64748b; margin-bottom: 1rem;" id="v-service">Premium Web App</div>
                    <div style="font-weight: 900; font-size: 1.5rem; color: var(--primary);">$<span id="v-price">0.00</span></div>
                </div>
                <div>
                    <p style="text-transform:uppercase; font-size:0.7rem; font-weight:800; color:#94a3b8; letter-spacing:1px; margin-bottom:1rem;">Client Identity</p>
                    <div style="font-weight: 800; font-size: 1.1rem;" id="v-client">Muzamil Nadeem</div>
                    <div style="font-weight: 600; color: #64748b;" id="v-email">client@email.com</div>
                </div>
            </div>

<div style="margin-bottom: 4rem;">
                <p style="text-transform:uppercase; font-size:0.7rem; font-weight:800; color:#94a3b8; letter-spacing:1px; margin-bottom:1.5rem;">Settlement Evidence (Screenshot)</p>
                <a id="v-screenshot-link" target="_blank">
                    <img id="v-screenshot" src="" style="width: 100%; max-height: 400px; border-radius: 25px; object-fit: contain; border: 2px solid #f1f5f9; background: #fafafa;">
                </a>
            </div>

<form action="" method="POST" style="display: grid; grid-template-columns: 1fr 1fr; gap: 2rem;">
                <input type="hidden" name="order_id" id="v-id">
                <button type="submit" name="process_payment" value="Reject" style="background: #fee2e2; color: #991b1b; border: none; padding: 1.3rem; border-radius: 18px; font-weight: 800; cursor: pointer; transition: 0.2s;"><i class="fas fa-times"></i> Discard Evidence</button>
                <button type="submit" name="process_payment" value="Accept" style="background: var(--primary); color: #fff; border: none; padding: 1.3rem; border-radius: 18px; font-weight: 800; cursor: pointer; transition: 0.2s;"><i class="fas fa-check"></i> Authorize Payment</button>
            </form>
        </div>
    </div>