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 = '
Félicitations
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.
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.