FM / Inc

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

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

Name	Size	Mode	Actions
Update_Course_Preference.php	13049	0644	edit dl rm
Update_Course_Preference_Secretarial.php	5474	0644	edit dl rm
Update_Profile.php	4732	0644	edit dl rm

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

<?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!"]);
            }

$pname = ($priority == 1) ? 'First' : (($priority == 2) ? 'Second' : 'Third');
            $cname_q = $mysqli->query("SELECT Course_Name FROM Courses WHERE Course_ID = $course_id");
            $cname = $cname_q ? $cname_q->fetch_assoc()['Course_Name'] : 'Course #'.$course_id;
            $tp_q = $mysqli->query("SELECT Phone, SMS_Carrier FROM teacher_profile WHERE Teacher_ID = $teacher_id");
            if ($tp_q) {
                $tp = $tp_q->fetch_assoc();
                $tp_phone = $tp['Phone'];
                $tp_carrier = $tp['SMS_Carrier'];
                if ($tp_carrier > 0 && $tp_phone) {
                    $gw_q = $mysqli->query("SELECT Gateway FROM sms_gateways WHERE Gateways_ID = $tp_carrier");
                    if ($gw_q) {
                        $gw = $gw_q->fetch_assoc();
                        $sms_addr = $tp_phone . $gw['Gateway'];
                        $subj = "Course Preference Saved";
                        $msg = "Your preference for \"$cname\" has been saved as $pname priority.";
                        @mail($sms_addr, $subj, $msg, "From: info@workloadmatch.com\r\n");
                    }
                }
            }
        //}

} 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>Course Management System: 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 Course Management System.".'" 	
//		</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@workloadmatch.com>' . "\r\n";
//		$headers .= 'CC: '.$Broker_Name.'<'.$Manager_Receiver_Email.'>' . "\r\n";
//		$headers .= 'Bcc: support<info@workloadmatch.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 (isset($_POST['action']) && $_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;
}

cmd: