query($sql);
$row = $result->fetch_assoc();
$request = $row['COUNT(user_id)'];
if(($role==$arole) or ($role==$rrole)){
$sql = "SELECT COUNT(user_id) FROM `request`where status=1" ;
} else {
$sql = "SELECT COUNT(user_id)FROM `request` where user_id=$user_id AND status=1";
}
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$pending = $row['COUNT(user_id)'];
if(($role==$arole) or ($role==$rrole)){
$sql = "SELECT COUNT(user_id) FROM `request`where status=2";
} else {
$sql = "SELECT COUNT(user_id)FROM `request` where user_id=$user_id AND status=2";;
}
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$approve = $row['COUNT(user_id)'];
if(($role==$arole) or ($role==$rrole)){
$sql = "SELECT COUNT(user_id) FROM `request`where status=3";
} else {
$sql = "SELECT COUNT(user_id)FROM `request` where user_id=$user_id AND status=3";
}
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$release = $row['COUNT(user_id)'];
if(($role==$arole) or ($role==$rrole)){
$sql = "SELECT COUNT(user_id) FROM `request`where status=4";
} else {
$sql = "SELECT COUNT(user_id)FROM `request` where user_id=$user_id AND status=4";
}
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$cancelled = $row['COUNT(user_id)'];
if(($role==$arole) or ($role==$rrole)){
$sql = "SELECT COUNT(user_id) FROM `request`where status=5";
} else {
$sql = "SELECT COUNT(user_id)FROM `request` where user_id=$user_id AND status=5";
}
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$disapproved = $row['COUNT(user_id)'];
// Simulated pie chart data
$chartData = [
'Pending' => $pending,
'Approved' => $approve,
'Released' => $release,
'Cancelled' => $cancelled,
'Disapproved' => $disapproved
];
?>