<?php  include 'dbconnection.php'; ?>
<?php 
  require("/classes/Warehouse.php");
  require("/classes/Firm.php");
   require("/classes/Client.php");
    require("/classes/Role.php");
    require("/classes/User.php");
/*
$dbUser = "root";
$dbPass = "";
$dbDatabase = "railtech_db";
$dbHost = 'localhost';
$conn = new mysqli($dbHost, $dbUser, $dbPass, $dbDatabase);*/

$user_id = $_REQUEST['id'];

$sql_query_user = "select * from tbl_users where user_id='".$user_id."'";
//echo $sql_query;
$sql_query_firm = "select firm_name from tbl_firms tf left join user_firms uf on tf.firm_id=uf.firm_id WHERE uf.user_id='".$user_id."'";

$sql_query_warehouse = "select warehouse_name from user_warehouse uw left join warehouse_master wm on uw.ware_id=wm.ware_id WHERE uw.user_id='".$user_id."'";

$sql_query_role = "select role_name from user_roles ur left join role_master rm on ur.role_id=rm.role_id WHERE ur.user_id='".$user_id."'";

$sql_query_client = "select client_name from user_clients uc left join client_master cm on uc.client_id=cm.client_id WHERE uc.user_id='".$user_id."'";


/*if (!$mysqli->multi_query($sql)) {
    echo "Multi query failed: (" . $mysqli->errno . ") " . $mysqli->error;
}

do {
    if($res = $mysqli->store_result()) {
       var_dump($res->fetch_all(mysqli_ASSOC));
       $res->free();
    }
} while ($mysqli->more_results() && $mysqli->next_result());


/* $result_user = $conn->query($sql_query_user);
  //$data = array();
  if($object = mysqli_fetch_object($result_user)) {
  $data[]= array("firstName"=> $object->first_name,"lastName"=>$object->last_name,"username"=>$object->user_name,"password"=>$object->user_password,"email"=>$object->email);
  } */
$userWarehouseList = array();
$result_query_warehouse = $conn->query($sql_query_warehouse);
if($result_query_warehouse->num_rows>0){
    while($row_query_warehouse=$result_query_warehouse->fetch_assoc()){
        $userWarehouseList[]=new Warehouse($row_query_warehouse['warehouse_name']);
       
        
    }
}

$userFirmList=array();
$result_query_firmlist=$conn->query($sql_query_firm);
if($result_query_firmlist->num_rows>0){
    while($row_query_firmlist=$result_query_firmlist->fetch_assoc()){
        $userFirmList[]=new Firm($row_query_firmlist['firm_name']);
    }
}


$userClientList=array();
$result_query_clientlist=$conn->query($sql_query_client);
if($result_query_clientlist->num_rows>0){
    while($row_query_clientlist=$result_query_clientlist->fetch_assoc()){
        $userClientList[]=new Client($row_query_clientlist['client_name']);
    }
}


$userRoleList=array();
$result_query_rolelist=$conn->query($sql_query_role);
if($result_query_rolelist->num_rows>0){
    while($row_query_rolelist=$result_query_rolelist->fetch_assoc()){
        $userRoleList[]=new Role($row_query_rolelist['role_name']);
    }
}


$user=null;
$result_query_user=$conn->query($sql_query_user);
if($result_query_user->num_rows>0){
   $row_query_user=$result_query_user->fetch_assoc();
        $user=new User($row_query_user['user_name']);
       
    }
    $user->setUserFirmList($userFirmList);
    $user->setUserClientList($userClientList);
    $user->setUserWarehouseList($userWarehouseList);
    $user->setUserRoleList($userRoleList);
    
    
  ///echo json_encode($user);
     
        
?>