FM / Inc

/home/techb158/workloadmatch.com/workloadmatch.com/Teacher/Inc/

/home/techb158/workloadmatch.com/workloadmatch.com/Teacher/Inc

Name	Size	Mode	Actions
AddClient.php	4171	0644	edit dl rm
AddCoursePreference.php	18995	0644	edit dl rm
updateclient.php	2728	0644	edit dl rm
UpdateClient1.php	2726	0644	edit dl rm
Update_Course_Preference.php	11468	0644	edit dl rm
Update_Course_Preference_Secretarial.php	4129	0644	edit dl rm
Update_Profile.php	4514	0644	edit dl rm
Update_Reference.php	9131	0644	edit dl rm
Update_Reference_Follow_Up.php	7435	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Teacher/Inc/Update_Course_Preference.php (11468B)

<?php

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

//$datetime =date("Y/m/d") . ' ' . date('H:i:s') ;

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'save_preferences') {
    
    $teacher_id = $_SESSION['user_id'];
    $program_id = 1;
    $date_time = date("Y/m/d H:i:s");

// Debug: Check if data is received
   // error_log("Received POST data: " . print_r($_POST, true));

// Ensure course_ids and priorities are received correctly
    if (!empty($_POST['course_id']) && 
        !empty($_POST['priority'])) {
        
        //foreach ($_POST['course_id'] as $index => $course_id) {
            $course_id = intval($_POST['course_id']); // ✅ Ensure proper type
			$priority = $_POST['priority']; 
			//echo json_encode(["status" => "error", "message" => $priority]);
			//exit;
		// Convert priority to an integer value
        if ($priority == "First") {
            $priority = 1;
        } else if ($priority == "Second") {
            $priority = 2;
        } else if ($priority == "Third") {
            $priority = 3;
        } else {
            $priority = 0; // Default case
        }
            //if (!$priority) {
            //    echo json_encode(["status" => "error", "message" => "Invalid priority value."]);
            //    exit;
            //}

// Check if record exists
            $stmt = $mysqli->prepare("
                SELECT 1 FROM Teacher_Course_Preferences 
                WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?
            ");
            $stmt->bind_param("iii", $teacher_id, $program_id, $course_id);
            $stmt->execute();
            $stmt->store_result();
            $exists = $stmt->num_rows > 0;
            $stmt->close();

if ($exists) {
                // Update existing preference
                $update_stmt = $mysqli->prepare("
                    UPDATE Teacher_Course_Preferences 
                    SET Priority = ?, Date_Time = ? 
                    WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?
                ");
                $update_stmt->bind_param("isiii", $priority, $date_time, $teacher_id, $program_id, $course_id);
                $update_stmt->execute();
                $update_stmt->close();
				echo json_encode(["status" => "success", "message" => "Preferences updated successfully!"]);
            } else {
                // Insert new preference
                $insert_stmt = $mysqli->prepare("
                    INSERT INTO Teacher_Course_Preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time) 
                    VALUES (?, ?, ?, ?, ?)
                ");
                $insert_stmt->bind_param("iiiis", $teacher_id, $program_id, $course_id, $priority, $date_time);
                $insert_stmt->execute();
                $insert_stmt->close();
				echo json_encode(["status" => "success", "message" => "Preferences saved successfully!"]);
            }
        //}

} else {
        echo json_encode(["status" => "error", "message" => "No courses selected or missing data."]);
    }

// Close database connection
    $mysqli->close();
    exit;
/*
$teacher_id=$_SESSION['user_id'];
		//$teacher_id = $_POST['Course_ID']; // Replace with the actual teacher ID from session or input
        $program_id = 1; // Modify this dynamically if needed
        //$date_time = date('Y-m-d H:i:s');
		$date_time =date("Y/m/d") . ' ' . date('H:i:s') ;
if (!empty($_POST['Course_ID'])) { // Check if any checkbox is selected
    foreach ($_POST['Course_ID'] as $index => $course_id) {
        // Ensure course_id is safe and an integer
        $course_id = (int) $course_id;

// Check if the radio button exists for the corresponding index
        if (isset($_POST['optionsRadios' . ($index + 1)])) {
            $priority = $_POST['optionsRadios' . ($index + 1)];
        } else {
            continue; // Skip this iteration if no radio button is selected
        }

// Convert priority to an integer value
        if ($priority == "First") {
            $priority = 1;
        } else if ($priority == "Second") {
            $priority = 2;
        } else if ($priority == "Third") {
            $priority = 3;
        } else {
            $priority = 0; // Default case
        }

// Your INSERT query here
        $query = "INSERT INTO Teacher_Course_Preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time) 
                  VALUES ('$teacher_id', '$program_id', '$course_id', '$priority', '$date_time')";

if ($mysqli->query($query)) {
 echo "Preferences saved successfully!";
 } else {
 
			echo "Error executing query: " . $mysqli->error . "";
 }
 }
} else {
	echo "No course selected. Please check at least one course.";
 
}
*/
/* $stmt = $mysqli->prepare("INSERT INTO Teacher_Course_Preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time) VALUES (?, ?, ?, ?, ?)");

if ($stmt) {
    foreach ($_POST['Course_ID'] as $index => $course_id) {
        $priority = isset($_POST['optionsRadios' . ($index + 1)]) ? $_POST['optionsRadios' . ($index + 1)] : 'N/A';
        
		if ($priority == "First") {
    $priority = 1;
} else if ($priority == "Second") {
    $priority = 2;
} else if ($priority == "Third") {
    $priority = 3;
} else {
    $priority = 0; // Default case, e.g., for "N/A"
}

$stmt->bind_param("iiiss", $teacher_id, $program_id, $course_id, $priority, $date_time);

if (!$stmt->execute()) {
 echo "Error executing query: " . $stmt->error . "";
 }
 }
 echo "Preferences saved successfully!";
} else {
 echo "Error preparing the statement: " . $mysqli->error . "";
}
*/

//$Teacher_ID=$_SESSION['user_id'];
//
//	
//		$query = "SELECT * FROM Teacher_Profile Where Teacher_ID ='".$Teacher_ID."'";	
//		$result = $mysqli->query($query);	
//		$row = $result->fetch_assoc();
//		$Admin_ID = $row['Admin_ID'];
//		$Master_ID = $row['Master_ID'];
//		$Manager_ID = $row['Manager_ID'];
//		$Teacher_ID = $row['Teacher_ID'];
//		$Broker_Email = $row['Email'];
//		//$User_Type_ID = $row['User_Type_ID'];
//		$Broker_Name = $row['First_Name'] .' '.$row['Last_Name'];
//	
//		///////////////////////////////////////////////////////////////////////////////////
//		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.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) {
//						
//		
//		$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.'<info@immovalet.com>' . "\r\n";
//		$headers .= 'CC: '.$Broker_Name.'<'.$Manager_Receiver_Email.'>' . "\r\n";
//		$headers .= 'Bcc: support<info@immovalet.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.php?error=The Reference has been Updated!');
//		exit();	
//		//}
//		//	}
//		}else{
//			header('Location: reference.php?error=Client Name is not exist.');
//		exit(); 
//		}

}else if ($_POST['action'] === 'remove_preference' && !empty($_POST['course_id'])) {
    $course_id = intval($_POST['course_id']);
 $teacher_id = $_SESSION['user_id'];
    $program_id = 1;
    // Ensure Teacher_ID and Program_ID are properly set
    if (!isset($teacher_id, $program_id)) {
        echo json_encode(["status" => "error", "message" => "Missing teacher or program ID."]);
        exit;
    }

// Delete preference from the database
    $delete_stmt = $mysqli->prepare("
        DELETE FROM Teacher_Course_Preferences 
        WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?
    ");
    $delete_stmt->bind_param("iii", $teacher_id, $program_id, $course_id);
    $delete_stmt->execute();
    $delete_stmt->close();

echo json_encode(["status" => "success", "message" => "Preference removed successfully!"]);
    exit;
}

$course_id) { $course_id = intval($_POST['course_id']); // ✅ Ensure proper type $priority = $_POST['priority']; //echo json_encode(["status" => "error", "message" => $priority]); //exit; // Convert priority to an integer value if ($priority == "First") { $priority = 1; } else if ($priority == "Second") { $priority = 2; } else if ($priority == "Third") { $priority = 3; } else { $priority = 0; // Default case } //if (!$priority) { // echo json_encode(["status" => "error", "message" => "Invalid priority value."]); // exit; //} // Check if record exists $stmt = $mysqli->prepare(" SELECT 1 FROM Teacher_Course_Preferences WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ? "); $stmt->bind_param("iii", $teacher_id, $program_id, $course_id); $stmt->execute(); $stmt->store_result(); $exists = $stmt->num_rows > 0; $stmt->close(); if ($exists) { // Update existing preference $update_stmt = $mysqli->prepare(" UPDATE Teacher_Course_Preferences SET Priority = ?, Date_Time = ? WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ? "); $update_stmt->bind_param("isiii", $priority, $date_time, $teacher_id, $program_id, $course_id); $update_stmt->execute(); $update_stmt->close(); echo json_encode(["status" => "success", "message" => "Preferences updated successfully!"]); } else { // Insert new preference $insert_stmt = $mysqli->prepare(" INSERT INTO Teacher_Course_Preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time) VALUES (?, ?, ?, ?, ?) "); $insert_stmt->bind_param("iiiis", $teacher_id, $program_id, $course_id, $priority, $date_time); $insert_stmt->execute(); $insert_stmt->close(); echo json_encode(["status" => "success", "message" => "Preferences saved successfully!"]); } //} } else { echo json_encode(["status" => "error", "message" => "No courses selected or missing data."]); } // Close database connection $mysqli->close(); exit; /* $teacher_id=$_SESSION['user_id']; //$teacher_id = $_POST['Course_ID']; // Replace with the actual teacher ID from session or input $program_id = 1; // Modify this dynamically if needed //$date_time = date('Y-m-d H:i:s'); $date_time =date("Y/m/d") . ' ' . date('H:i:s') ; if (!empty($_POST['Course_ID'])) { // Check if any checkbox is selected foreach ($_POST['Course_ID'] as $index => $course_id) { // Ensure course_id is safe and an integer $course_id = (int) $course_id; // Check if the radio button exists for the corresponding index if (isset($_POST['optionsRadios' . ($index + 1)])) { $priority = $_POST['optionsRadios' . ($index + 1)]; } else { continue; // Skip this iteration if no radio button is selected } // Convert priority to an integer value if ($priority == "First") { $priority = 1; } else if ($priority == "Second") { $priority = 2; } else if ($priority == "Third") { $priority = 3; } else { $priority = 0; // Default case } // Your INSERT query here $query = "INSERT INTO Teacher_Course_Preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time) VALUES ('$teacher_id', '$program_id', '$course_id', '$priority', '$date_time')"; if ($mysqli->query($query)) { echo "

Preferences saved successfully!

"; } else { echo "

Error executing query: " . $mysqli->error . "

"; } } } else { echo "

No course selected. Please check at least one course.

"; } */ /* $stmt = $mysqli->prepare("INSERT INTO Teacher_Course_Preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time) VALUES (?, ?, ?, ?, ?)"); if ($stmt) { foreach ($_POST['Course_ID'] as $index => $course_id) { $priority = isset($_POST['optionsRadios' . ($index + 1)]) ? $_POST['optionsRadios' . ($index + 1)] : 'N/A'; if ($priority == "First") { $priority = 1; } else if ($priority == "Second") { $priority = 2; } else if ($priority == "Third") { $priority = 3; } else { $priority = 0; // Default case, e.g., for "N/A" } $stmt->bind_param("iiiss", $teacher_id, $program_id, $course_id, $priority, $date_time); if (!$stmt->execute()) { echo "

Error executing query: " . $stmt->error . "

"; } } echo "

Preferences saved successfully!

"; } else { echo "

Error preparing the statement: " . $mysqli->error . "

"; } */ //$Teacher_ID=$_SESSION['user_id']; // // // $query = "SELECT * FROM Teacher_Profile Where Teacher_ID ='".$Teacher_ID."'"; // $result = $mysqli->query($query); // $row = $result->fetch_assoc(); // $Admin_ID = $row['Admin_ID']; // $Master_ID = $row['Master_ID']; // $Manager_ID = $row['Manager_ID']; // $Teacher_ID = $row['Teacher_ID']; // $Broker_Email = $row['Email']; // //$User_Type_ID = $row['User_Type_ID']; // $Broker_Name = $row['First_Name'] .' '.$row['Last_Name']; // // /////////////////////////////////////////////////////////////////////////////////// // 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.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) { // // // $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.'' . "\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.php?error=The Reference has been Updated!'); // exit(); // //} // // } // }else{ // header('Location: reference.php?error=Client Name is not exist.'); // exit(); // } }else if ($_POST['action'] === 'remove_preference' && !empty($_POST['course_id'])) { $course_id = intval($_POST['course_id']); $teacher_id = $_SESSION['user_id']; $program_id = 1; // Ensure Teacher_ID and Program_ID are properly set if (!isset($teacher_id, $program_id)) { echo json_encode(["status" => "error", "message" => "Missing teacher or program ID."]); exit; } // Delete preference from the database $delete_stmt = $mysqli->prepare(" DELETE FROM Teacher_Course_Preferences WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ? "); $delete_stmt->bind_param("iii", $teacher_id, $program_id, $course_id); $delete_stmt->execute(); $delete_stmt->close(); echo json_encode(["status" => "success", "message" => "Preference removed successfully!"]); exit; }