FM / Inc

/home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc/

/home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc

Name	Size	Mode	Actions
AddClient.php	3930	0644	edit dl rm
AddCourse.php	1996	0644	edit dl rm
AddCourseTime.php	1709	0644	edit dl rm
AddGroup - Copy.php	4531	0644	edit dl rm
AddGroup.php	4921	0644	edit dl rm
AddHoliday.php	1636	0644	edit dl rm
AddReference.php	8258	0644	edit dl rm
AddTeacherLevel.php	2131	0644	edit dl rm
AddUser.php	11841	0644	edit dl rm
Add_Retake_Remediation.php	1248	0644	edit dl rm
Assignment-1.php	73605	0644	edit dl rm
Assignment-2.php	73605	0644	edit dl rm
Assignment - BackUp- orgenal.php	71487	0644	edit dl rm
Assignment - BackUp.php	61314	0644	edit dl rm
Assignment - Copy (Last File Updated 2025-05-15).php	71164	0644	edit dl rm
Assignment - Copy.php	60402	0644	edit dl rm
Assignment.php	74235	0644	edit dl rm
Assignment_BackUp.php	77046	0644	edit dl rm
Assign_Category_To_User.php	2733	0644	edit dl rm
Assign_Teacher_Manual.php	20508	0644	edit dl rm
Assign_Teacher_Manual_Force_conflict.php	20638	0644	edit dl rm
Available_Teacher_Report.php	2341	0644	edit dl rm
error_log	869	0644	edit dl rm
Process_Assignment - Copy.php	4150	0644	edit dl rm
Process_Assignment.php	5559	0644	edit dl rm
Schedule_Report_by_Group.php	2997	0644	edit dl rm
UpdateClient.php	2513	0644	edit dl rm
updateuser.php	2429	0644	edit dl rm
Update_Course.php	2019	0644	edit dl rm
Update_Course_Time.php	1755	0644	edit dl rm
Update_Group - Copy.php	3404	0644	edit dl rm
Update_Group.php	8905	0644	edit dl rm
Update_Holiday.php	2178	0644	edit dl rm
Update_Profile.php	4816	0644	edit dl rm
Update_Reference.php	8908	0644	edit dl rm
Update_Reference_Follow_Up.php	3481	0644	edit dl rm
Update_User.php	5204	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc/Update_Reference.php (8908B)

<?php

include_once '../includes/db_connect.php';
include_once '../includes/psl-config.php';
sec_session_start();
$error_msg = "";

if(isset($_POST["submit"]) && $_POST["submit"]!="") {	
	 
if (isset ($_POST['Update_ID'],$_POST['Update_No'],$_POST['Transaction_Amount'],$_POST['Transaction_Type'])) {
//header('Location: reference.php?error=The Reference has been sent!');
//exit();

//$Broker_ID= $_POST['Broker_ID'];
$Receiver_Code= $_POST['Receiver_Code'];
$Client_ID= $_POST['Update_ID'];
$Reference_ID= $_POST['Update_No'];
$Transaction_Amount= $_POST['Transaction_Amount'];
$Transaction_Type_ID= $_POST['Transaction_Type'];
$Note = $_POST['Note'];

$Manager_ID=$_SESSION['user_id'];

$stmt = $mysqli->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 = '
		<html>
		<head>
		<title>ImmoValet: New Update on Reference</title>
		</head>
		<body>
		Dear "'.$Broker_Receiver_Name.'", 		
		You have received a new update on reference, please go to <a href="'.$uri.'/index.php">Account Login</a> to view it. 
		"'."Thank you for choosing ImmoValet.".'" 	
		</body>
		<footer>
		Support Team 
		<a href="'.$uri.'/index.php" target="_blank"><img src="'.$uri.'/img/logo.png" class="stone-logo" height="50" width="150"></a>
		</footer>		
		</html>
		';
		$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<info@techbala.com>' . "\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();	
}
}

cmd: