106 lines
3.2 KiB
PHP
106 lines
3.2 KiB
PHP
<?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);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
?>
|