query("SELECT COUNT(*) as t FROM ipe_requests")->fetch_assoc()['t']; $success = $conn->query("SELECT COUNT(*) as t FROM ipe_requests WHERE status='SUCCESSFUL'")->fetch_assoc()['t']; $failed = $conn->query("SELECT COUNT(*) as t FROM ipe_requests WHERE status='FAILED'")->fetch_assoc()['t']; /* ================= CHECK STATUS ================= */ if(isset($_POST['check_id'])){ $id = (int)$_POST['check_id']; $get = $conn->prepare("SELECT transaction_id FROM ipe_requests WHERE id=?"); $get->bind_param("i",$id); $get->execute(); $get->bind_result($transaction_id); $get->fetch(); $get->close(); if($transaction_id){ $ch = curl_init("https://new.unifyxpress.com/api/v4/transaction/".$transaction_id); curl_setopt_array($ch,[ CURLOPT_RETURNTRANSFER=>true, CURLOPT_HTTPHEADER=>["X-API-Key: $apiKey"] ]); $res = curl_exec($ch); curl_close($ch); $response = json_decode($res,true); $status = strtoupper($response['status'] ?? 'FAILED'); $raw = json_encode($response); $stmt = $conn->prepare("UPDATE ipe_requests SET status=?, raw_response=? WHERE id=?"); $stmt->bind_param("ssi",$status,$raw,$id); $stmt->execute(); } header("Location: ipe2_admin.php"); exit; } /* ================= RETRY ================= */ if(isset($_POST['retry_id'])){ $id = (int)$_POST['retry_id']; $get = $conn->prepare("SELECT tracking_id FROM ipe_requests WHERE id=?"); $get->bind_param("i",$id); $get->execute(); $get->bind_result($tracking_id); $get->fetch(); $get->close(); if($tracking_id){ $payload = json_encode(["tracking_ids"=>[$tracking_id]]); $ch = curl_init("https://new.unifyxpress.com/api/v4/nin/ipe"); curl_setopt_array($ch,[ CURLOPT_RETURNTRANSFER=>true, CURLOPT_POST=>true, CURLOPT_POSTFIELDS=>$payload, CURLOPT_HTTPHEADER=>[ "Content-Type: application/json", "X-API-Key: $apiKey" ] ]); $res = curl_exec($ch); curl_close($ch); $data = json_decode($res,true); if(isset($data['transactions'][0])){ $t = $data['transactions'][0]; $raw = json_encode($t); $stmt = $conn->prepare("UPDATE ipe_requests SET transaction_id=?, status=?, raw_response=? WHERE id=?"); $stmt->bind_param("sssi",$t['id'],$t['status'],$raw,$id); $stmt->execute(); } } header("Location: ipe2_admin.php"); exit; } /* ================= UPDATE STATUS / REPLY ================= */ if(isset($_POST['update_id'])){ $id = (int)$_POST['update_id']; $status = $_POST['status']; $reply = $_POST['reply']; $stmt = $conn->prepare("UPDATE ipe_requests SET status=?, reply=? WHERE id=?"); $stmt->bind_param("ssi",$status,$reply,$id); $stmt->execute(); header("Location: ipe2_admin.php"); exit; } /* ================= FETCH ================= */ $data = $conn->query("SELECT * FROM ipe_requests ORDER BY id DESC"); ?> Admin IPE

Admin IPE Dashboard

Total Requests

Successful

Failed

fetch_assoc()): ?>
ID User Tracking Status Report Actions Update
--