public function recapCirculationGeneration()
{
$registrations = Classification::where('category', '=', 'Registration')->get();
$resigns = Classification::where('category', '=', 'Resign')->get();
$generations = Generation::all();
$comes = array();
$leaves = array();
foreach ($registrations as $registration) {
$statistics = array();
foreach ($generations as $generation) {
$count = Registration::with(array('issue'))->join('issues', 'issues.registration_id', '=', 'registrations.id')->where('registrations.project_id', '=', Auth::user()->curr_project_id)->where('registrations.location_id', '=', Auth::user()->location_id)->where('registrations.classification_id', '=', $registration->id)->where('issues.generation_id', '=', $generation->id)->count();
$statistics[] = array('count' => $count);
}
$comes[] = array('name' => $registration->name, 'statistics' => $statistics);
}
foreach ($resigns as $resign) {
$statistics = array();
foreach ($generations as $generation) {
$count = Resign::with(array('issue'))->join('issues', 'issues.id', '=', 'resigns.issue_id')->where('resigns.project_id', '=', Auth::user()->curr_project_id)->where('resigns.location_id', '=', Auth::user()->location_id)->where('resigns.classification_id', '=', $resign->id)->where('issues.generation_id', '=', $generation->id)->count();
$statistics[] = array('count' => $count);
}
$leaves[] = array('name' => $resign->name, 'statistics' => $statistics);
}
$menu = 'report';
return View::make('reports.recapcirculationgeneration', compact('comes', 'leaves', 'generations', 'menu'));
}
