prepare("SELECT * FROM ipe_requests WHERE id=?"); $get->bind_param("i",$id); $get->execute(); $row = $get->get_result()->fetch_assoc(); // ✅ refund logic if($status == "failed" && $row['request_status'] != "failed"){ $stmt = $conn->prepare(" UPDATE balance SET amount = amount + ? WHERE user=? "); $stmt->bind_param("ds", $row['amount'], $row['user']); $stmt->execute(); } // update request $stmt = $conn->prepare(" UPDATE ipe_request SET request_status=?, reply=? WHERE id=? "); $stmt->bind_param("ssi",$status,$reply,$id); $stmt->execute(); $msg = "Updated successfully"; } /* ================= STATS ================= */ $daily = $conn->query("SELECT COUNT(*) c, SUM(amount) s FROM ipe_requests WHERE DATE(created_at)=CURDATE()")->fetch_assoc(); $weekly = $conn->query("SELECT COUNT(*) c, SUM(amount) s FROM ipe_requests WHERE YEARWEEK(created_at)=YEARWEEK(NOW())")->fetch_assoc(); $monthly = $conn->query("SELECT COUNT(*) c, SUM(amount) s FROM ipe_requests WHERE MONTH(created_at)=MONTH(NOW())")->fetch_assoc(); /* ================= FETCH ================= */ $data = $conn->query("SELECT * FROM ipe_request ORDER BY id DESC"); ?> IPE Admin Dashboard
IPE Admin Dashboard
Transactions
Daily:
Weekly:
Monthly:
Amount
Daily: ₦
Weekly: ₦
Monthly: ₦
Profit
Daily: ₦
Weekly: ₦
Monthly: ₦
fetch_assoc()): ?>
User Tracking ID Price Status Reply Action
₦