public function getByJobId($id)
{
$pdo = Config::getInstance()->get('db.pdo');
$stmt = $pdo->prepare('SELECT * FROM applications WHERE job_id = :id');
$stmt->execute(['id' => $id]);
$_applications = $stmt->fetchAll();
$applications = [];
foreach ($_applications as $_application) {
$a = new Application();
$a->fill($_application);
$applications[] = $a;
}
return $applications;
}
public function postJob($req)
{
$uploaded = !(!file_exists($_FILES['cv']['tmp_name']) || !is_uploaded_file($_FILES['cv']['tmp_name']));
if ($uploaded) {
$a = new Application();
$a->fill($_POST);
$a->job_id = $req->id;
// Upload with random base name to avoid collision
$target_folder = JF_PROJECT_ROOT . '/public/uploads/';
$target_file = time() . rand() . basename($_FILES['cv']['name']);
move_uploaded_file($_FILES['cv']['tmp_name'], $target_folder . $target_file);
$a->cv_path = $target_file;
$result = $a->save();
} else {
$result = false;
}
if ($result) {
$this->service->flash('Your application was saved.', 'success');
} else {
$this->service->flash('We are having problems saving your application. Please try again later.', 'alert');
}
return $this->service->back();
}