$data['id'] = $technical_skills[1]['id'];
$data['technical_skill'] = 'scripting';
if ($resume->update_technical_skill($data)) {
$technical_skills = $resume->get_technical_skills();
echo "<pre>";
print_r($technical_skills);
echo "</pre>";
} else {
echo "failed";
exit;
}
echo "<br>";
?>
<b>Delete 1st resume...</b><br><br><?php
$resume = new Resume($uid, $first_resume);
if ($resume->delete()) {
echo "deleted";
} else {
echo "failed";
exit;
}
echo "<br>";
?>
<b>Delete 2nd resume...</b><br><br><?php
$resume = new Resume($uid, $second_resume);
if ($resume->delete()) {
echo "deleted";
} else {
echo "failed";
exit;
}
/**
* Delete a resume
*
* @param object $database JDatabase
* @param string $option Component name
* @param object $member \Hubzero\User\Profile
* @param integer $emp Is user employer?
* @return string
*/
protected function _deleteresume($database, $option, $member, $emp)
{
$row = new Resume($database);
if (!$row->loadResume($member->get('uidNumber'))) {
$this->setError(Lang::txt('Resume ID not found.'));
return '';
}
// Incoming file
$file = $row->filename;
$path = $this->build_path($member->get('uidNumber'));
if (!file_exists(PATH_APP . $path . DS . $file) or !$file) {
$this->setError(Lang::txt('FILE_NOT_FOUND'));
} else {
// Attempt to delete the file
if (!Filesystem::delete(PATH_APP . $path . DS . $file)) {
$this->setError(Lang::txt('UNABLE_TO_DELETE_FILE'));
} else {
$row->delete();
// Remove stats for prev resume
$jobstats = new \Components\Jobs\Tables\JobStats($database);
$jobstats->deleteStats($member->get('uidNumber'), 'seeker');
// Do not include profile in search without a resume
$js = new \Components\Jobs\Tables\JobSeeker($database);
$js->loadSeeker($member->get('uidNumber'));
$js->bind(array('active' => 0));
if (!$js->store()) {
$this->setError($js->getError());
}
}
}
// Push through to the main view
return $this->_view($database, $option, $member, $emp);
}
public function delete()
{
$query = "SELECT resume_file_hash, existing_resume_id \n FROM referral_buffers \n WHERE id = " . $this->id . " LIMIT 1";
$result = $this->mysqli->query($query);
if (!is_null($result[0]['resume_file_hash'])) {
$file = $GLOBALS['buffered_resume_dir'] . '/' . $this->id . '.' . $result[0]['resume_file_hash'];
@unlink($file);
} elseif (!is_null($result[0]['existing_resume_id'])) {
$resume = new Resume($result[0]['existing_resume_id']);
$resume->delete();
}
$query = "DELETE FROM referral_buffers WHERE id = " . $this->id;
return $this->mysqli->execute($query);
}
