add_styles_page();
$db = new db_safeguard();
echo $_SESSION['user_id'];
// check user type
$user_type_res = $db->query("users", "SELECT user_type FROM users WHERE record_id = '{$_SESSION['user_id']}'");
$user_type = $user_type_res->fetch_assoc()['user_type'];
if ($user_type == 'SUPPLIER') {
$client_requests = $db->query("delivery_request", "SELECT * FROM delivery_request WHERE status = 'PENDING' AND user_id = '{$_SESSION['user_id']}'");
if ($request_res->num_rows > 0) {
while ($request_data = $request_res->fetch_assoc()) {
$data_table = $data_table . "
{$request_data['supplier_batch_no']}
{$request_data['date_created']}
{$request_data['contact_number']}
{$request_data['global_gap_no']}
{$request_data['status']}
";
}
} else {
$data_table = "
NO JOBCARDS FOUND
";
}
} else if ($user_type == 'ADMIN') {
$request_res = $db->query("delivery_request", "SELECT * FROM delivery_request WHERE status = 'PENDING'");
if ($request_res->num_rows > 0) {
while ($request_data = $request_res->fetch_assoc()) {
$data_table = $data_table . "
{$request_data['supplier_batch_no']}
{$request_data['date_created']}
{$request_data['contact_number']}
{$request_data['global_gap_no']}
{$request_data['status']}
";
}
} else {
$data_table = "
NO JOBCARDS FOUND
";
}
} elseif ($user_type == 'QA') {
$request_res = $db->query("delivery_request", "SELECT * FROM delivery_request WHERE status = 'SEND SAMPLE TO QA'");
if ($request_res->num_rows > 0) {
while ($request_data = $request_res->fetch_assoc()) {
$data_table = $data_table . "