public function getBatchData() { $inputs = Input::all(); $franchisee_id = Session::get('franchiseId'); $batch_data = Batches::getAllBatchesbySeasonId($franchisee_id, $inputs['session_id']); for ($i = 0; $i < count($batch_data); $i++) { $batch_data[$i]['preferred_time'] = date("h:i", strtotime($batch_data[$i]['preferred_time'])); $batch_data[$i]['preferred_end_time'] = date("h:i", strtotime($batch_data[$i]['preferred_end_time'])); $location_data = Location::where('id', '=', $batch_data[$i]['location_id'])->get(); $batch_data[$i]['location_name'] = $location_data[0]['location_name']; $batch_data[$i]['created'] = date("Y-m-d", strtotime($batch_data[$i]['created_at'])); $batch_data[$i]['day'] = date('l', strtotime($batch_data[$i]['start_date'])); if ($batch_data[$i]['lead_instructor'] != '') { $user_data = User::find($batch_data[$i]['lead_instructor']); $batch_data[$i]['instructor_name'] = $user_data['first_name'] . '' . $user_data['last_name']; } else { $batch_data[$i]['instructor_name'] = ''; } $batch_data[$i]['count'] = StudentClasses::where('batch_id', '=', $batch_data[$i]['id'])->count(); } if ($batch_data) { return Response::json(array('status' => 'success', 'data' => $batch_data)); } else { return Response::json(array('status', 'failure')); } }