<?php
include 'db.php';
$inserted_user_id = $_POST['inserted_user_id'];
$array = [];
$qarray = [];
if ($inserted_user_id!=null) {
$result_user_data = mysqli_query($link, "SELECT * FROM user WHERE user_id = $inserted_user_id");
$numrows = mysqli_num_rows($result_user_data);
$res = mysqli_fetch_assoc($result_user_data);

if ($numrows > 0) {
    if ($res['user_type'] == 'seller') {
        $result_seller_data = mysqli_query($link, "SELECT * FROM seller WHERE user_id =" . $res['user_id'] . " ");
        $res_seller = mysqli_fetch_assoc($result_seller_data);
        $numrows1 = mysqli_num_rows($result_seller_data);
        if ($numrows1 > 0) {

            $result_order_data = mysqli_query($link, "SELECT * FROM orders WHERE seller_id ='" . $res_seller['seller_id'] . "' AND order_status!='Delivered'  AND order_status!='Rejected' ");
            $res_order = mysqli_fetch_assoc($result_order_data);
            $numrows2 = mysqli_num_rows($result_order_data);
            if ($numrows2 > 0) {

            while ($result_order = mysqli_fetch_assoc($result_order_data)) {
                $qid = $res_order['quality_id'];
                $qty_data = mysqli_query($link,"SELECT * FROM quality WHERE quality_id = $qid");
                $result_qty = mysqli_fetch_assoc($qty_data);
                array_push($array, $result_order);
                array_push($qarray, $result_qty);
            }
 
            $return['data'] = $array;      
            $return['qdata'] = $qarray;      
            $return["error_flag"] = 0;
            $return["message"] = "Orders Found Successfully!";
        }
        else
        {
            $return["error_flag"] = 1;
            $return["message"] = "Orders Not Found!". $link->error;
        }


}
    }
    else if ($res['user_type'] == 'buyer') {
        $result_seller_data = mysqli_query($link, "SELECT * FROM buyer WHERE user_id =" . $res['user_id'] . " ");
        $res_seller = mysqli_fetch_assoc($result_seller_data);
        $numrows1 = mysqli_num_rows($result_seller_data);
        if ($numrows1 > 0) {

            $result_order_data = mysqli_query($link, "SELECT * FROM orders WHERE buyer_id ='" . $res_seller['buyer_id'] . "' AND order_status!='Delivered'  AND order_status!='Rejected' ");
            $res_order = mysqli_fetch_assoc($result_order_data);
            $numrows2 = mysqli_num_rows($result_order_data);
            if ($numrows2 > 0) {

            while ($result_order = mysqli_fetch_assoc($result_order_data)) {
                $qid = $res_order['quality_id'];
                $qty_data = mysqli_query($link,"SELECT * FROM quality WHERE quality_id = $qid");
                $result_qty = mysqli_fetch_assoc($qty_data);
                array_push($array, $result_order);
                array_push($qarray, $result_qty);
            }
 
            $return['data'] = $array;  
            $return['qdata'] = $qarray;          
            $return["error_flag"] = 0;
            $return["message"] = "Orders Found Successfully!";
        }
        else
        {
            $return["error_flag"] = 1;
            $return["message"] = "Orders Not Found!". $link->error;
        }


}
    }
  
}
else{
    $return["error_flag"] = 1;
    $return["message"] = "This user is not Found!" . $link->error;
    $return['inserted_user_id'] = $inserted_user_id;
    }
}
else{
    $return["error_flag"] = 1;
    $return["message"] = "Please Insert valid user ID!" . $link->error;
    $return['inserted_user_id'] = $inserted_user_id;
    }

echo json_encode($return);
$link->close();
?>