public function getAdminOrganizations()
{
$organizations = \App\Models\Organization::all();
$datatables = Datatables::of($organizations)->addColumn('document', function ($organization) {
$orgdocs = $organization->orgdocs;
if ($orgdocs->count()) {
$document = 'Загружен';
} else {
$document = 'Не Загружен';
}
return $document;
})->addColumn('repetition', function ($organization) {
$user = $organization->user;
$documents_movalbes = $user->documents()->whereDocument_typeAndOs_type('residues_entering', 'movables')->count();
$document_value_movables = $user->documents()->whereDocument_typeAndOs_type('residues_entering', 'value_movables')->count();
$document_car = $user->documents()->whereDocument_typeAndOs_type('residues_entering', 'car')->count();
$document_buildings = $user->documents()->whereDocument_typeAndOs_type('residues_entering', 'buildings')->count();
$document_parcels = $user->documents()->whereDocument_typeAndOs_type('residues_entering', 'parcels')->count();
if ($documents_movalbes > 1 || $document_value_movables > 1 || $document_car > 1 || $document_buildings > 1 || $document_parcels > 1) {
$repetition = 'Есть повтор';
} else {
$repetition = 'Нет';
}
return $repetition;
})->addColumn('action', function ($organization) {
return '<a href="admin/organization/' . $organization->id . '" class="actions icons"><i class="fa fa-eye"></i></a><a href="/organization/' . $organization->id . '/edit" class="actions icons"><i class="fa fa-pencil-square-o"></i></a>';
});
return $datatables->make(true);
}
public function AddForAll()
{
$organizations = \App\Models\Organization::all();
foreach ($organizations as $organization) {
$id = $organization->id;
$reports = $organization->reports;
if ($reports->count()) {
$maxYear = \App\Models\Report::where('organization_id', '=', $id)->max('year');
$maxQuarter = \App\Models\Report::where('organization_id', '=', $id)->where('year', '=', $maxYear)->max('quarter');
if ($maxQuarter == 4 && $maxYear != 2016) {
$year = ++$maxYear;
$report = new \App\Models\Report();
$report->year = $year;
$report->quarter = 1;
$report->organization_id = $id;
$report->state = 'not_accepted';
$report->save();
} elseif ($maxQuarter != 4) {
$quarter = $maxQuarter + 1;
$report = new \App\Models\Report();
$report->year = $maxYear;
$report->quarter = $quarter;
$report->organization_id = $id;
$report->state = 'not_accepted';
$report->save();
}
} else {
$report = new \App\Models\Report();
$report->year = 2015;
$report->quarter = 1;
$report->organization_id = $id;
$report->state = 'not_accepted';
$report->save();
}
}
return redirect()->back();
}
