public function reportByDate(Request $request)
{
$start_date = Input::get('start_date');
$end_date = Input::get('end_date');
$counselors = array();
if (Input::has('start_date') && Input::has('start_date')) {
$checkings = DB::table('checking')->whereBetween('day_event', [$start_date, $end_date])->get();
foreach ($checkings as $i => $checking) {
$accreditation = DB::table('accreditation')->where('id', $checking->accreditation_id)->first();
$counselor = Counselor::find($accreditation->counselor_id);
array_push($counselors, $counselor);
}
}
$items = collect($counselors);
$total = count($counselors);
$page = Input::get('page', 1);
$perPage = 10;
$counselors = new LengthAwarePaginator($items->forPage($page, $perPage), $items->count(), $perPage, $page);
return view('reports.index', compact('counselors', 'start_date', 'end_date', 'total'));
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$validator = Validator::make(Request::all(), ['name' => 'required', 'phone' => 'required']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator->errors());
} else {
$counselor = Request::all();
$counselor = new Counselor();
$counselor->name = Input::get('name');
$counselor->email = Input::get('email');
$counselor->phone = Input::get('phone');
$counselor->phone_cel = Input::get('phone_cel');
$counselor->address = Input::get('address');
$counselor->number = Input::get('number');
$counselor->complement = Input::get('complement');
$counselor->city = Input::get('city');
$counselor->state = Input::get('state');
$counselor->church = Input::get('church');
$counselor->pastor = Input::get('pastor');
$counselor->save();
return redirect('counselors');
}
}
