/home/techb158/workloadmatch.com/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Manager/transfer_reference.php (27288B)
ImmoValet | Transfer Reference
|
|
|
|
|
|
|
|
|
|
|
query($querys);
//echo $mysqli->error;
while ($rowss = $resultss->fetch_assoc()) {
//$Manager_ID= $rowss["Manager_ID"];
$stmt = $mysqli->prepare('SELECT * FROM Manager_Profile WHERE Manager_ID = ?');
$stmt->bind_param('s', $user_n);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
$Reference_ID= $rowss["Reference_ID"];
$query = "SELECT CF.Client_ID, RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Category_Sender_ID,RF.Category_Receiver_ID,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 from Reference_File RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID where RF.Reference_ID='".$Reference_ID."' AND RF.Manager_Receiver_ID='".$user_n."' AND RF.Broker_Receiver_ID='0' order by Reg_Date DESC";
//$querys = "SELECT * from Reference_File_Follow_UP where Manager_ID='".$user_n."' order by Reg_Date DESC";
$results= $mysqli->query($query);
//echo $mysqli->error;
while ($rows = $results->fetch_assoc()) {
$Reference_ID= $rows["Reference_ID"];
$Category_Sender_ID= $rows["Category_Sender_ID"];
$Category_Receiver_ID= $rows["Category_Receiver_ID"];
$First_Name = "Non";
$Last_Name = "Non";
$Broker_Receiver_Name = $First_Name .' '. $Last_Name;
$queryss = "SELECT * FROM Categories WHERE Category_ID='".$Category_Receiver_ID."'";
$resultsss = $mysqli->query($queryss);
$row = $resultsss->fetch_assoc();
$BrokerSender_ID= $rows["Broker_Sender_ID"];
$queryxs = "SELECT * FROM Broker_Profile Where Broker_ID ='".$BrokerSender_ID."'";
$resultxs = $mysqli->query($queryxs);
$rowxs = $resultxs->fetch_assoc();
$Category_Sender_ID = $rowxs['Category_ID'];
$Sender_First_Name = $rowxs['First_Name'];
$Sender_Last_Name = $rowxs['Last_Name'];
$Broker_Sender_Name = $Sender_First_Name .' '. $Sender_Last_Name;
$queryssx = "SELECT * FROM Categories WHERE Category_ID='".$Category_Sender_ID."'";
$resultsssx = $mysqli->query($queryssx);
$rowxz = $resultsssx->fetch_assoc();
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|