public function getMyprofile()
{
$id = Auth::user()->id;
$alumni_id = null;
$sql = "SELECT * FROM alumni WHERE account_id = ?";
$prof = DB::select($sql, array($id));
if ($prof != null) {
$alumni_id = $prof[0]->id;
}
$sql2 = "SELECT * FROM degree WHERE alumni_id = ?";
$deg = DB::select($sql2, array($alumni_id));
$sql3 = "SELECT * FROM work_experience WHERE alumni_id = ?";
$wrk_exp = DB::select($sql3, array($alumni_id));
$sql4 = "SELECT * FROM certificate WHERE alumni_id = ?";
$certificate = DB::select($sql4, array($alumni_id));
// $sql5 = "SELECT * FROM alumni_tracer WHERE alumni_id = ?";
$sql5 = "SELECT at.*, sq.question, sc.choice\n\t\t\t\tFROM alumni_tracer AS at\n\t\t\t\tINNER JOIN survey_questions AS sq\n\t\t\t\tON sq.id = at.question_id\n\t\t\t\tINNER JOIN survey_choices AS sc\n\t\t\t\tON sc.id = at.choice_id\n\t\t\t\tWHERE at.alumni_id = ?\n\t\t\t\tORDER BY at.question_id";
$a_tracer = DB::select($sql5, array($alumni_id));
$dept = Department::all();
$region = Region::all();
$province = Province::all();
$occupation = Occupation::all();
$company = Company::all();
$deg_title = DegreeTitle::all();
$school = School::all();
$jobs = Job::all();
$field = Field::all();
$questions = DB::select("SELECT * FROM survey_questions");
$civil_status = DB::select("SELECT * FROM civil_status");
return View::make('user.profile')->with('company', $company)->with('field', $field)->with('occupation', $occupation)->with('work_exp', $wrk_exp)->with('degree', $deg)->with('a_tracer', $a_tracer)->with('certificate', $certificate)->with('school', $school)->with('deg_title', $deg_title)->with('profile', $prof)->with('dept', $dept)->with('region', $region)->with('province', $province)->with('civil_status', $civil_status)->with('questions', $questions)->with('jobs', $jobs);
}
/**
* Execute the console command
*
* @return void
*/
public function fire()
{
// Check for a list option
$list = $this->option('list');
$job_name = $this->argument('jobname');
if (empty($list) && !empty($job_name)) {
$inputController = new InputController();
list($collection_uri, $name) = $inputController->getParts($job_name);
// Check if the job exists
$job = \Job::where('name', '=', $name)->where('collection_uri', '=', $collection_uri)->first();
if (empty($job)) {
$this->error("The job with identified by: {$job_name} could not be found.\n");
exit;
}
$this->info('The job has been found.');
// Configure a log handler if configured
$this->addLogHandler();
$startDate = new Carbon();
$iso8601 = $startDate->toISo8601String();
\Log::info("Executing job {$name} at {$iso8601}");
try {
$job_exec = new JobExecuter($job, $this);
$job_exec->execute();
} catch (\Exception $ex) {
$endDate = new Carbon();
$iso8601 = $endDate->toISO8601String();
\Log::error("The job {$job_name} has failed at {$iso8601}");
\Log::error($ex->getMessage());
\Log::error($ex->getTraceAsString());
}
$endDate = new Carbon();
$iso8601 = $endDate->toISO8601String();
$job->date_executed = time();
$job->added_to_queue = false;
$job->save();
\Log::info("The job has ended at {$iso8601}");
} else {
$jobs = \Job::all(['name', 'collection_uri'])->toArray();
if (!empty($jobs)) {
$this->info("=== Job names ===");
foreach ($jobs as $job) {
$this->info($job['collection_uri'] . '/' . $job['name']);
}
} else {
$this->info("No jobs found.");
}
}
}
/**
* Execute the console command.
*
* @return void
*/
public function fire()
{
$queue = $this->argument('queue') ? $this->argument('queue') : \Config::get('queue.connections.beanstalkd.queue');
$this->info(sprintf('Clearing queue: %s', $queue));
$pheanstalk = \Queue::getPheanstalk();
$pheanstalk->useTube($queue);
$pheanstalk->watch($queue);
while ($job = $pheanstalk->reserve(0)) {
$pheanstalk->delete($job);
}
// Set the flag of the jobs
$jobs = \Job::all();
foreach ($jobs as $job) {
$job->added_to_queue = false;
$job->save();
}
$this->info('The Beankstalk queue has been cleared.');
}
/**
* Execute the console command.
*
* @return void
*/
public function fire()
{
// Get the file option from the command line
$filename = $this->option('file');
if (empty($filename)) {
$filename = self::getExportFile();
}
// Get the jobid, if none is provided, return all of the jobs by default
$jobid = $this->argument('jobid');
$content = null;
if (empty($jobid)) {
$jobs = \Job::all();
$content = array();
foreach ($jobs as $job) {
$content[$job->collection_uri . '/' . $job->name] = $job->getAllProperties();
}
$content = json_encode($content);
} else {
$job = InputController::get($jobid);
if (empty($job)) {
$this->error("No input job has been found with the given identifer ({$jobid}).");
die;
}
$content[$job->collection_uri . '/' . $job->name] = $job->getAllProperties();
$content = json_encode($content);
}
try {
// Write to file
$fs = new Filesystem();
if ($fs->exists($filename)) {
$fs->put($filename, $content);
} else {
$handle = fopen($filename, "w");
if (!$handle) {
\App::abort('Could not open/create the file ' . $filename);
}
fwrite($handle, $content);
}
$this->info("The export has been written to the file '{$filename}'.");
} catch (Exception $e) {
$this->error("The contents could not be written to the file '{$filename}'.");
die;
}
}
/**
* Execute the console command.
*
* @return void
*/
public function fire()
{
// Get the file option from the command line
$filename = $this->option('file');
if (empty($file)) {
$file = self::getExportFile();
}
// Get the jobid, if none is provided, return all of the jobs by default
$jobid = $this->argument('jobid');
$content = null;
if (empty($jobid)) {
$jobs = \Job::all();
$content = array();
foreach ($jobs as $job) {
$content[$job->collection_uri . '/' . $job->name] = $job->getAllProperties();
}
$content = json_encode($content);
} else {
$job = InputController::get($jobid);
if (empty($job)) {
$this->error("No input job has been found with the given identifer ({$jobid}).");
die;
}
$content[$job->collection_uri . '/' . $job->name] = $job->getAllProperties();
$content = json_encode($content);
}
// Output
if (empty($filename)) {
// Print to console
echo $content;
} else {
try {
// Write to file
file_put_contents($filename, $content);
$this->info("The export has been written to the file '{$filename}'.");
} catch (Exception $e) {
$this->error("The contents could not be written to the file '{$filename}'.");
die;
}
}
}
/**
* Return a list of jobs
*
* @return \View
*/
private function listJobs()
{
// Get list of jobs
$jobs = \Job::all();
return \View::make('input::ui.jobs.list')->with('title', 'Jobs management | The Datatank')->with('jobs', $jobs);
}
}
$app->response->body($pros->toJson());
});
//---------------------------//
//------JOBS FUNCTIONS-------//
/*
* Get Jobs(all) - OK
* Job details - OK
* New Job - OK
* Edit Job - OK
* Delete Job - OK
* Take offer -
*/
//Job by any condition
$app->get("/jobs", function () use($app) {
$app->response->body(Job::all()->toJson());
});
//Job Details
$app->get("/job/:job_id", function ($job_id) use($app) {
$job = Job::find($job_id);
$app->response->body($job->toJson());
});
//New job
$app->post('/job/new/', function () use($app) {
$params = $app->request()->params();
//Get all aprameters
$r = Job::new_job($params);
$app->response->body($r);
});
//Edit Job
$app->post('/job/update', function () use($app) {
public function feed()
{
$jobs = Job::all()->toArray();
return Response::json(['data' => $jobs], 200);
}
/**
* GET a job based on the uri provided
*
* @return \Response
*/
private function getJob()
{
$uri = $this->getUri();
// If the uri is nothing, return a list of all the jobs
if ($uri == '/') {
$jobs = \Job::all();
$input_document = array();
foreach ($jobs as $job) {
$input_document[$job->collection_uri . '/' . $job->name] = $job->getAllProperties();
}
return $this->makeResponse(str_replace('\\/', '/', json_encode($input_document)), 200);
}
if (!$this->exists($uri)) {
\App::abort(404, "No job has been found with the uri {$uri}");
}
// Get Definition object based on the given uri
$job = $this->get($uri);
$job = $job->getAllProperties();
return $this->makeResponse(str_replace('\\/', '/', json_encode($job)), 200);
}
/**
* Display a listing of jobs
*
* @return Response
*/
public function index()
{
$jobs = Job::all();
return View::make('jobs.index', compact('jobs'));
}
