/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc/Update_Reference.php (8908B)
prepare('SELECT * FROM manager_profile WHERE Manager_ID = ?');
$stmt->bind_param('s', $Manager_ID);
$stmt->execute();
$result = $stmt->get_result();
//$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
$query = "SELECT * FROM Reference_File Where Reference_ID ='".$Reference_ID."' AND Manager_Sender_ID ='".$Manager_ID."' AND Client_ID ='".$Client_ID."'";
$result = $mysqli->query($query);
$Reference = $result->fetch_assoc();
$Reference_ID = $Reference['Reference_ID'];
$Client_ID = $Reference['Client_ID'];
$Category_Sender_ID = $Reference['Category_ID'];
$Category_Receiver_ID = $Reference['Category_Receiver_ID'];
$Admin_ID = $Reference['Admin_ID'];
$Master_ID = $Reference['Master_ID'];
$Manager_Sender_ID = $Reference['Manager_Sender_ID'];
$Manager_Receiver_ID = $Reference['Manager_Receiver_ID'];
$Broker_Sender_ID = $Reference['Broker_Sender_ID'];
$Broker_Receiver_ID = $Reference['Broker_Receiver_ID'];
$User_Type_ID = $Reference['User_Type_ID'];
//$Transaction_Type_ID = $Reference['Transaction_Type_ID'];
//$Transaction_Type = $Reference['Transaction_Type'];
//$Best_Time_Call = $Reference['Best_Time_Call'];
$Reference_Status = $Reference['Reference_Status'];
$query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_ID."'";
$result = $mysqli->query($query);
$Managers = $result->fetch_assoc();
//$Client_ID = $Managers['Client_ID'];
$First_Name = $Managers['First_Name'];
$Last_Name = $Managers['Last_Name'];
$Client_Name = $First_Name .''. $Last_Name;
///////////////////////////////////////////////////////////////////////////////////
$query = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Sender_ID."'";
$result = $mysqli->query($query);
$row = $result->fetch_assoc();
$Broker_Sender_Refer_ID = $row['Broker_Refer_ID'];
$Category_Sender_ID = $row['Category_ID'];
$Admin_ID = $row['Admin_ID'];
$Master_ID = $row['Master_ID'];
$Manager_ID = $row['Manager_ID'];
$Broker_ID = $row['Broker_ID'];
$Broker_Email = $row['Email'];
//$User_Type_ID = $row['User_Type_ID'];
$Broker_Name = $row['First_Name'] .' '.$row['Last_Name'];
if($Broker_Sender_Refer_ID == $Receiver_Code)
{
header('Location: reference.php?error=You are not allowed to send Reference to your acount!');
exit();
}
///////////////////////////////////////////////////////////////////////////////////
if($Receiver_Code !="")
{
$querye = "SELECT * FROM Broker_Profile Where Broker_Refer_ID ='".$Receiver_Code."' AND Manager_ID='".$Manager_Receiver_ID."'";
$resulte = $mysqli->query($querye);
$rowe = $resulte->fetch_assoc();
if ($resulte->num_rows > 0) {
$Broker_ID_Receiver = $rowe['Broker_ID'];
$Broker_Receiver_Email = $rowe['Email'];
$Broker_Receiver_Name = $rowe['First_Name'] .' '.$rowe['Last_Name'];
$Broker_Phone = $rowe['Phone'];
$Broker_SMS_Carrier = $rowe['SMS_Carrier'];
if($Broker_SMS_Carrier !="")
{
$queryee = "SELECT * FROM sms_gateways Where Gateways_ID ='".$Broker_SMS_Carrier."'";
$resultee = $mysqli->query($queryee);
$roweee = $resultee->fetch_assoc();
$Broker_SMS_Carrier = $Broker_Phone .''. $roweee['Gateway'];
}
$queryes = "SELECT * FROM manager_profile Where Manager_ID='".$Manager_Receiver_ID."'";
$resultes = $mysqli->query($queryes);
$rowes = $resultes->fetch_assoc();
$Manager_Receiver_Email = $rowes['Email'];
}else{
header('Location: reference_list.php?error=The refer code you are tring to insert is not correct!');
exit();
}
}else{
$querye = "SELECT * FROM manager_profile Where Manager_ID='".$Manager_Receiver_ID."'";
$resulte = $mysqli->query($querye);
$rowe = $resulte->fetch_assoc();
$Broker_ID_Receiver =0;
$Broker_Receiver_Email = $rowe['Email'];
$Manager_SMS_Carrier = $rowe['SMS_Carrier'];
$Manager_Phone =$rowe['Phone'];
$Broker_Receiver_Name = $rowe['First_Name'] .' '.$rowe['Last_Name'];
if($Manager_SMS_Carrier !="")
{
$querye = "SELECT * FROM sms_gateways Where Gateways_ID ='".$Manager_SMS_Carrier."'";
$resulte = $mysqli->query($querye);
$rowe = $resulte->fetch_assoc();
$Manager_SMS_Carrier = $Manager_Phone.''.$rowe['Gateway'];
}
}
$query = "SELECT * FROM Sub_Categories Where Sub_Category_ID ='".$Transaction_Type_ID."'";
$resultw = $mysqli->query($query);
$roww = $resultw->fetch_assoc();
$Sub_Category_Type = $roww['Sub_Category_Type'];
$datetime =date("Y/m/d") . ' ' . date('H:i:s') ;
//$Best_Time_Call = date("Y-m-d", strtotime($Best_Time_Call));
$Best_Time_Call = date("Y-m-d", strtotime($_POST['datepickerR']));
if ($Client_ID > 0) {
//header('Location: reference.php?error=The Reference has been sent!'.$Reference_ID.'-'.$Client_ID.'-'.$Admin_ID.'-'.$Manager_Sender_ID.'-'.$Manager_Receiver_ID.'-'.$Broker_Sender_ID.'-'.$Broker_Receiver_ID);
//exit();
if (!$mysqli->query("UPDATE Reference_File SET Transaction_Type_ID='".$Transaction_Type_ID."',Transaction_Type='".$Sub_Category_Type."',Transaction_Amount='".$Transaction_Amount."',Note='".$Note."',Best_time_contact='".$Best_Time_Call."' WHERE Reference_ID='".$Reference_ID."' and Client_ID='".$Client_ID."' and Admin_ID ='".$Admin_ID."' and Master_ID ='".$Master_ID."' and Manager_Sender_ID='".$Manager_Sender_ID."' and Manager_Receiver_ID='".$Manager_Receiver_ID."' and Broker_Sender_ID='".$Broker_Sender_ID."'and Broker_Receiver_ID='".$Broker_Receiver_ID."' and User_Type_ID='".$User_Type_ID."'")) {
//header('Location: reference.php?error='.$mysqli->error);
//exit;
}
if (!$mysqli->query("UPDATE Reference_File_Follow_UP SET Transaction_Type_ID='".$Transaction_Type_ID."',Transaction_Type='".$Sub_Category_Type."',Transaction_Amount='".$Transaction_Amount."',Note='".$Note."',Best_time_contact='".$Best_Time_Call."' WHERE Reference_ID='".$Reference_ID."' and Client_ID='".$Client_ID."' and Admin_ID ='".$Admin_ID."' and Master_ID ='".$Master_ID."' and Manager_Sender_ID='".$Manager_Sender_ID."' and Manager_Receiver_ID='".$Manager_Receiver_ID."' and Broker_Sender_ID='".$Broker_Sender_ID."' and Broker_Receiver_ID='".$Broker_Receiver_ID."' and User_Type_ID='".$User_Type_ID."'")) {
//header('Location: reference.php?error='.$mysqli->error);
//exit;
}
$subject = "New Update on Reference";
$uri = 'https://'. $_SERVER['HTTP_HOST'] ;
$message = '
ImmoValet: New Update on Reference
Dear "'.$Broker_Receiver_Name.'",
You have received a new update on reference, please go to Account Login to view it.
"'."Thank you for choosing ImmoValet.".'"
';
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$headers .= 'From: '.$Broker_Name.'<'.$Broker_Email.'>' . "\r\n";
$headers .= 'CC: '.$Broker_Name.'<'.$Manager_Receiver_Email.'>' . "\r\n";
$headers .= 'Bcc: support
' . "\r\n";
if(mail($Broker_Receiver_Email,$subject,$message,$headers))
{
$messages = 'New Update on your reference, please visit your profile to view it.';
if($Broker_SMS_Carrier !="")
{
mail($Broker_SMS_Carrier, $subject, "$messages", "From: $Broker_Name <$Broker_Email>\r\n");
}
if($Manager_SMS_Carrier !="")
{
mail($Manager_SMS_Carrier, $subject, "$messages", "From: $Broker_Name <$Broker_Email>\r\n");
}
}
header('Location: reference_list.php?error=The Reference has been Updated!');
exit();
//}
// }
}else{
header('Location: reference_list.php?error=Client Name is not exist.');
exit();
}
//header('Location: reference.php?error=Client Name is already exist.');
//exit();
//foreach ($_POST['Transaction_Type'] as $Transaction_Type)
//{
// $Transaction_Type= $Transaction_Type;
//}
}
}else{
header('Location: reference_list.php?error=Registration failure please insert all informaion!');
exit();
}
}