/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/getrefer.php (4349B)
prepare('SELECT * FROM Broker_Profile WHERE Manager_ID = ? AND Broker_ID = ?');
$stmt->bind_param('ss', $user_n, $Broker_ID);
$stmt->execute();
$result = $stmt->get_result();
//$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
//$Client_Name= $_POST["user"];
$user_n=$_SESSION['user_id'];
$stmt = $mysqli->prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');
$stmt->bind_param('s', $Broker_ID);
$stmt->execute();
$result = $stmt->get_result();
//$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
//echo $Broker_ID .'-'.$Client_ID .'-'.$user_n;
//$querys = "SELECT CF.Client_ID,RF.Reference_ID,RF.Transaction_Type,RF.Reference_Status,RF.Reg_Date,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Receiver_ID=BP.Broker_ID AND RF.Manager_Receiver_ID= BP.Manager_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Manager_Receiver_ID='".$user_n."' AND RF.Broker_Receiver_ID='".$Broker_ID."' AND RF.Client_ID='".$Client_ID."' Group By Reference_ID";
$querys = "SELECT CF.Client_ID,RF.Reference_ID,RF.Transaction_Type,RF.Reference_Status,RF.Reg_Date,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Sender_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=RF.Category_Receiver_ID where RF.Manager_Receiver_ID='".$user_n."' AND RF.Broker_Receiver_ID='".$Broker_ID."' AND CF.Client_ID='".$Client_ID."' Group By Reference_ID";
$resultss = $mysqli->query($querys);
//echo $mysqli->error;
$_ResultSet = array();
while ($rowss = $resultss->fetch_assoc()) {
$Reference_ID= $rowss["Reference_ID"];
//$query = "SELECT CF.Client_ID,RF.Reference_ID_Follow_UP,RF.Reference_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Reg_Date,RF.Note,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Receiver_ID=BP.Broker_ID AND RF.Manager_Receiver_ID= BP.Manager_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Manager_Receiver_ID='".$user_n."' AND RF.Broker_Receiver_ID='".$Client_ID."' AND RF.Client_ID='".$Client_ID."' AND RF.Reference_ID='".$Reference_ID."' order by Reg_Date DESC Limit 1";
$query = "SELECT CF.Client_ID,RF.Reference_ID_Follow_UP,RF.Reference_ID,RF.Transaction_Type_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Reg_Date,RF.Note,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name AS Broker_Sender_First_Name,BP.Last_Name AS Broker_Sender_Last_Name,BPR.First_Name AS Broker_Receiver_First_Name,BPR.Last_Name AS Broker_Receiver_Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BPR ON BPR.Broker_ID=RF.Broker_Receiver_ID JOIN Broker_Profile BP ON RF.Broker_Sender_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=RF.Category_Receiver_ID where RF.Manager_Receiver_ID='".$user_n."' AND RF.Broker_Receiver_ID='".$Broker_ID."' AND CF.Client_ID='".$Client_ID."' AND RF.Reference_ID='".$Reference_ID."' order by Reg_Date DESC Limit 1";
$results = $mysqli->query($query);
//echo $mysqli->error;
while ($rows = $results->fetch_assoc()) {
$_ResultSet[] = $rows;
}
echo json_encode($_ResultSet);
}
}
}
}else
{
echo "Choose User";
}
?>