<?php
include('../helpers/init.php');

if(isset($_POST['addJob'])){

	$date=date('d M Y');
	$title=$_POST['title'];
	$brief=$_POST['brief'];
    
    $sql = "insert into careers(title,brief,date) values('$title','$brief','$date')";
		if(query($sql)){
			header('Location:../pages/job-list.php?&result=success');
		}else{
			$error = error();
			header('Location:../pages/job-list.php?&result=failer');
		}
	
	
}
//---------------------------- job post ends here ---------------


if(isset($_GET['action']) && $_GET['action']=="delJob"){
	$id=$_GET['id'];
		$sql = "delete from careers where id=$id";
        
		if(query($sql)){  
			header('Location:../pages/job-list.php?&result=dsuccess');
		}else{
			header('Location:../pages/job-list.php?result=failer');
		}
}

//---------------------- job Delete ends here -----------------------

if(isset($_POST['jobApply'])){
    
	$job=$_POST['jobapplied'];
	$name=$_POST['name'];
	$phone=$_POST['phone'];
	$email=$_POST['email'];
    $date=date('d/m/Y');
    $error = "";    
	$image="cv_".rand(111,999)."_".basename($_FILES['file']['name']);
    $fileinfo = @getimagesize($_FILES["file"]["tmp_name"]);
    
	if($_FILES['file']['size']>100000){
			header('Location:../../career.php??id='.$id.'&result=picfailer');
	}
    else{
		if (do_upload($image,"resume")){
		$sql = "insert into enrollments(name,email,phone,address,qualification,cv,applied_for,date) values ('$name','$email','$phone','$location','$education','$image','$job','$date')";
		if(query($sql)){
			header('Location:../../career.php?id='.$id.'&result=success');
		}else{
			$error = error();
			header('Location:../../career.php?id='.$id.'&result=failer');
		}
		}
	}/*end else for size validation*/
	
	
}

//-----------------------Add Image Edns Here ---------------


if(isset($_GET['action']) && $_GET['action']=="delApply"){
	$id=$_GET['id'];
	$data = getWhere("enrollments","id",$id);
    foreach($data as $row){
		$image= $row['cv'];
        $banner = "../uploads/resume/".$image;
        
		$sql = "delete from enrollments where id=$id";
        
		if(query($sql)){  
            unlink($banner);
			header('Location:../pages/appliedfor.php?&result=dsuccess');
		}else{
			header('Location:../pages/appliedfor.php?result=failer');
		}
	}
}

?>