public function pressData(Request $request) { $params = $request->only(['start', 'end']); $start = Carbon::createFromFormat('m/d/Y', '9/14/2015'); $end = Carbon::createFromFormat('m/d/Y', '9/20/2015'); if (!isset($params['start'])) { $params['start'] = $start; } if (!isset($params['end'])) { $params['end'] = $end; } $jobs = SiteJob::where('start', '>=', $params['start'])->where('end', '<=', $params['end'])->with('pub')->with('pressRun')->get(); //now we loop through jobs and build up the array the way we need to, and pass it back as a json encoded object $pressJobs = array(); foreach ($jobs as $job) { $pressjob = array(); $pressjob['id'] = $job->id; $pressjob['title'] = $job->pub->name . " " . date("m/d/Y", strtotime($job->product_date)); $pressjob['color'] = "#" . $job->pub->color; $pressjob['start'] = $job->start->format('m/d/Y H:i'); $pressjob['end'] = $job->end->format('m/d/Y H:i'); $pressjob['pub_date'] = $job->product_date->toRfc850String(); $pressjob['description'] = "This is my description"; $pressJobs[] = $pressjob; } return json_encode($pressJobs); }
public function index() { $jobs = Job::all(); $siteJobs = SiteJob::all(); return view('pages.dashboard', compact('jobs', 'siteJobs')); }