FM / immovalet.ca

/home/techb158/immovalet.ca

Name	Size	Mode	Actions
.well-known/	-	0777	rm
bower_components/	-	0777	rm
bykotru/	-	0755	rm
cgi-bin/	-	0777	rm
Client/	-	0777	rm
css/	-	0777	rm
fonts/	-	0777	rm
ibgyutk/	-	0755	rm
ICONES/	-	0777	rm
igbwexq/	-	0755	rm
img/	-	0777	rm
includes/	-	0777	rm
j1pnuas/	-	0755	rm
jgazbtp/	-	0755	rm
jhqayno/	-	0755	rm
js/	-	0777	rm
Master/	-	0777	rm
misc/	-	0777	rm
q1jarnc/	-	0755	rm
report/	-	0777	rm
rnjluqa/	-	0755	rm
supdgkj/	-	0755	rm
w1efamk/	-	0755	rm
wgmhvfy/	-	0755	rm
xjvsyfc/	-	0755	rm
.htaccess	480	0644	edit dl rm
activate.php	2696	0666	edit dl rm
admin.php	970	0644	edit dl rm
ApplyNow.php	11097	0666	edit dl rm
emplois_offerts.php	18308	0666	edit dl rm
emplois_offertsx.php	18071	0666	edit dl rm
error.php	4201	0666	edit dl rm
footer.php	2708	0666	edit dl rm
forgetpassword.php	8602	0666	edit dl rm
head.php	2778	0666	edit dl rm
header.php	2159	0666	edit dl rm
index - BackUP 08-02-2019.php	6726	0666	edit dl rm
index.php	8445	0666	edit dl rm
Liste_des_entreprises.php	8671	0666	edit dl rm
register.php	6993	0666	edit dl rm
reset.php	6819	0666	edit dl rm
search.php	755	0666	edit dl rm
searchs.php	556	0666	edit dl rm
uxzyjcqn.php	7317	0644	edit dl rm
Voir_emplois.php	6563	0666	edit dl rm
Voir_emploisx.php	7389	0666	edit dl rm
wp-cron-ayhd.php	1659	0644	edit dl rm

Edit: /home/techb158/immovalet.ca/ApplyNow.php (11097B)

<?php

include_once 'includes/db_connect.php';
//include_once 'includes/psl-config.php';

include_once 'includes/functions.php';
sec_session_start();
$error_msg = "";

if (isset ($_POST['Job_Post_ID'])) {
   
 
		
   $Job_Post_ID = $_POST['Job_Post_ID'];  
  
	$username=$_SESSION['username'];
     $Admin_ID=  $_SESSION['user_id'];
   
	 $Register_Time = date("Y/m/d") . ' ' . date('H:i:s');
    
	
	
	$query = "SELECT * FROM CV_File_Upload Where C_ID ='".$Admin_ID."' AND Username ='".$username."'";	
	$resultq = $mysqli->query($query);	
    if ($resultq->num_rows == 0) {
		
	}
	//echo $resultq->num_rows;
	$querys = "select * from Client_Essential_Values where C_ID ='".$Admin_ID."'";	
		$results = $mysqli->query($querys);
		if ($results->num_rows == 0) {
		}
	//	echo $results->num_rows;
		$querysd = "select * from Client_Benefits where C_ID ='".$Admin_ID."'";	
		$resultsd = $mysqli->query($querysd);
		if ($resultsd->num_rows == 0) {
		}
	//	echo $resultsd->num_rows;
	if($resultq->num_rows != 0 && $results->num_rows != 0 && $resultsd->num_rows != 0)
	{

//echo $Admin_ID .'-'.$username.'-'.$Job_Post_ID.'-'.$Register_Time;
	
	
    $query = "select * from Clients where C_ID ='".$Admin_ID."' and Username ='".$username."'";	
	$result = $mysqli->query($query);	
	$order= $result->fetch_assoc(); 
	$email = $order["Email"];
	$FirstName = $order["First_Name"];
	$LastName = $order["Last_name"];
	
	$Email_Type="Submit_CV";
	$queryse = "select * from Job_Post where Job_Post_ID ='".$Job_Post_ID."'";	
	$resulte = $mysqli->query($queryse);	
	$ordere= $resulte->fetch_assoc();		
	if ($resulte->num_rows != 0) {
$Master_ID = $ordere['Master_ID'];

/////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////

//$Match_query = "SELECT * FROM Submit_Talent_Profile_Apply_Job STP JOIN Client_Benefits CB ON CB.C_ID = STP.C_ID AND CB.Category_offering_ID = PSCO.Category_offering_ID
//JOIN Client_Essential_Values CEV ON CEV.C_ID = STP.C_ID AND CEV.Essential_values_ID = PSRV.Essential_values_ID JOIN Post_Select_Category_Offering PSCO ON PSCO.Job_Post_ID = STP.Job_Post_ID AND PSCO.Master_ID = STP.Master_ID JOIN Post_Select_Essential_Values PSRV ON PSRV.Job_Post_ID = STP.Job_Post_ID AND PSRV.Master_ID = STP.Master_ID WHERE STP.C_ID='".$Admin_ID."' AND STP.Master_ID='".$Master_ID."' AND STP.Job_Post_ID='".$Job_Post_ID."' Group by STP.C_ID";
//
//$Match_result = $mysqli->query($Match_query);		
//	//if ($Match_result->num_rows == 0) {	
//	//}
//$Matching_Rate=$Match_result->num_rows;
	
	//Unknown column 'CB.Client_Benefits' in 'field

//echo $mysqli->error;
	
/////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////

$querysew = "select * from Submit_Talent_Profile_Apply_Job where C_ID ='".$Admin_ID."' AND Master_ID ='".$Master_ID."' AND Job_Post_ID ='".$Job_Post_ID."'";	
	$resultew = $mysqli->query($querysew);	
	$orderew= $resultew->fetch_assoc();		
	if ($resultew->num_rows == 0) {	
	if ($insert_stmts = $mysqli->prepare("INSERT INTO Submit_Talent_Profile_Apply_Job (C_ID, User_Name, Master_ID, Job_Post_ID, Date_Time) VALUES (?, ?, ?, ?, ?)")) {
		$insert_stmts->bind_param('sssss',$Admin_ID,$username,$Master_ID,$Job_Post_ID,$Register_Time);		
		// Execute the prepared query.
		if (! $insert_stmts->execute()) {
			//echo $insert_stmts->error; 
		}else
		{
			//header('Location: submit_offer_employee.php?error=register success!');
			//exit();
/////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////
$Match_query = "SELECT * FROM Submit_Talent_Profile_Apply_Job STP 
JOIN Post_Select_Essential_Values PSRV ON PSRV.Job_Post_ID = STP.Job_Post_ID AND PSRV.Master_ID = STP.Master_ID 
JOIN Client_Essential_Values CEV ON CEV.C_ID = STP.C_ID AND CEV.Essential_values_ID = PSRV.Essential_values_ID 
WHERE STP.C_ID='".$Admin_ID."' AND STP.Master_ID='".$Master_ID."' AND STP.Job_Post_ID='".$Job_Post_ID."'";
$Match_result = $mysqli->query($Match_query);		
$Matching_Rate=$Match_result->num_rows;

$Match_querys = "SELECT * FROM Submit_Talent_Profile_Apply_Job STP 	
JOIN Post_Select_Category_Offering PSCO ON PSCO.Job_Post_ID = STP.Job_Post_ID AND PSCO.Master_ID = STP.Master_ID 
JOIN Client_Benefits CB ON CB.C_ID = STP.C_ID AND CB.Category_offering_ID = PSCO.Category_offering_ID
WHERE STP.C_ID='".$Admin_ID."' AND STP.Master_ID='".$Master_ID."' AND STP.Job_Post_ID='".$Job_Post_ID."'";
$Match_results = $mysqli->query($Match_querys);	
//$Match_qer= $Match_results->fetch_assoc();
$Matching_Rates=$Match_results->num_rows;
/////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////
	//echo $Matching_Rate .'-'.$Matching_Rates;
	
	if (!$mysqli->query("UPDATE Submit_Talent_Profile_Apply_Job SET Matching_Rate_Benefits ='$Matching_Rates', Matching_Rate_Essential='$Matching_Rate' WHERE C_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Job_Post_ID='".$Job_Post_ID."'")) {
	//header('Location: modifier_profil.php?error=Votre mise à jour a échoué!');
	//exit(); 
	}else{ 
	//header('Location: modifier_profil.php?error=Votre mise à jour est un succès!');
    //exit(); 
	}
////Update table Submit_Talent_Profile_Apply_Job ( Matching_Rate)

}		
	}

if ($insert_stmt = $mysqli->prepare("INSERT INTO Send_Email_Client (C_ID, User_Name, Email, Email_Type, Date_Time) VALUES (?, ?, ?, ?, ?)")) {
		$insert_stmt->bind_param('sssss',$Admin_ID,$username,$email,$Email_Type,$Register_Time);		
		// Execute the prepared query.
		if (! $insert_stmt->execute()) {
			//echo $insert_stmt->error;
		}else
		{
			//header('Location: submit_offer_employee.php?error=register success!');
			//exit();	
		
		}		
	}	
	
	$query = "SELECT * FROM Master Where M_ID ='".$Master_ID."'";		
$result = $mysqli->query($query);	
$Manager = $result->fetch_assoc(); 
$Master_Name = $Manager['First_Name'] .' '.$Manager['Last_name']; 
$Master_Email = $Manager['Email']; 
	
	$respons=sendemail($FirstName,$LastName,$email,$Master_Name,$Master_Email);	
	  	
		if($respons)
		{
			echo "Merci d'avoir soumis votre candidature! Nous vous avons envoyé un email.";
		}
	}else{
	echo "Vous avez soumis votre profil à cet emploi.";
	}

}
			 
			 
			 }else{
			 echo "S'il vous plaît compléter votre profil!";
			 }
}else{
//header('Location: modifier_profil.php?error=Toutes les informations sont obligatoires!');
 // exit();
    
}

function sendemail($First_Name,$Last_name,$Email,$Master_Name,$Master_Email)
{
	$to=$Email;
	//$to="abdalla.bala@gmail.com";
		$subject = "BonBoss.Ca Félicitations ".$First_Name . ' ' . $Last_name."";
		$uri = 'http://'. $_SERVER['HTTP_HOST'] ;
		$message = '
		<html>
		<head>
		<title>Félicitations</title>
		</head>
		<body>
		Votre profil a été complété sur BonBoss.ca. 
		Dès maintenant, vous pouvez postuler sur les emplois des Bons Boss et être informé dès qu’un recruteur consulte votre candidature. 
		Grâce à la nouveauté Alerte jumelage, les entreprises qui partagent vos valeurs recevront votre fiche professionnelle et vous serez informé des jumelages potentiels. Si elles recrutent, vous pourrez discuter avec les recruteurs et présenter votre candidature. 
	Bonne recherche d’emplois! 
	#qui se ressemble s’assemble
	
	
		<footer>
		Équipe de soutien
		Bon Boss.ca
		Phone: (514) 898-4939
		Email: info@bonboss.ca
		<a><img src="'.$uri.'/img/logo.png" class="stone-logo"></a>
		</footer>
		</body>
		</html>
		';
				$headers[] = 'MIME-Version: 1.0';
$headers[] = 'Content-type: text/html; charset=iso-8859-1';

// Additional headers
$info="info@bonboss.ca";
$headers[] = 'To: '.$to.'>';
$headers[] = 'From: Équipe de soutien <'.$info.'>';
$headers[] = 'Cc: abdalla.bala@gmail.com';
$headers[] = 'Bcc: abdalla.bala@gmail.com';

//$headers = "MIME-Version: 1.0" . "\r\n";
		//$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
		//$headers .= 'From: BonBoss.Ca<abdalla.bala@gmail.com>' . "\r\n";		
		//$headers .= 'Bcc: BonBoss.Ca<abdalla.bala@gmail.com>' . "\r\n";
$mail =mail($to, $subject, $message, implode("\r\n", $headers));
		if($mail){
		//$error_msg .= 'La vérification Courriel vous a été envoyée.';
		
		}else
		{
		//	$error_msg .= "S'il vous plaît contacter avec notre équipe de support.";
		}

$tos=$Master_Email;
	//$to="abdalla.bala@gmail.com";
		$subjects = "BonBoss.Ca Félicitations ".$Master_Name."";
		$uri = 'http://'. $_SERVER['HTTP_HOST'] ;
		$messages = '
		<html>
		<head>
		<title>Félicitations</title>
		</head>
		<body>
		Votre profil a été complété sur BonBoss.ca. 
		Dès maintenant, vous pouvez postuler sur les emplois des Bons Boss et être informé dès qu’un recruteur consulte votre candidature. 
		Grâce à la nouveauté Alerte jumelage, les entreprises qui partagent vos valeurs recevront votre fiche professionnelle et vous serez informé des jumelages potentiels. Si elles recrutent, vous pourrez discuter avec les recruteurs et présenter votre candidature. 
	Bonne recherche d’emplois! 
	#qui se ressemble s’assemble
	
	
		<footer>
		Équipe de soutien
		Bon Boss.ca
		Phone: (514) 898-4939
		Email: info@bonboss.ca
		<a><img src="'.$uri.'/img/logo.png" class="stone-logo"></a>
		</footer>
		</body>
		</html>
		';
				$headerss[] = 'MIME-Version: 1.0';
$headerss[] = 'Content-type: text/html; charset=iso-8859-1';

// Additional headers
$info="info@bonboss.ca";
$headerss[] = 'To: '.$tos.'>';
$headerss[] = 'From: Équipe de soutien <'.$info.'>';
$headerss[] = 'Cc: abdalla.bala@gmail.com';
$headerss[] = 'Bcc: abdalla.bala@gmail.com';

//$headers = "MIME-Version: 1.0" . "\r\n";
		//$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
		//$headers .= 'From: BonBoss.Ca<abdalla.bala@gmail.com>' . "\r\n";		
		//$headers .= 'Bcc: BonBoss.Ca<abdalla.bala@gmail.com>' . "\r\n";
$mails =mail($to, $subjects, $messages, implode("\r\n", $headerss));
		if($mails){
		$error_msg .= 'La vérification Courriel vous a été envoyée.';
		
		}else
		{
			$error_msg .= "S'il vous plaît contacter avec notre équipe de support.";
		}
		
		return $error_msg;
		
}

cmd: