use App\Category; use App\Ship; use App\Position; use App\Department; use App\Municipality; use App\addressbook; use App\CaseOwner; if (\Auth::user()->role == 1) { $cases = CaseReport::whereNotNull('gps_lat')->whereNotNull('gps_lng')->get(); } else { $casesIds = CaseOwner::where('user', '=', \Auth::user()->id)->get(); $ids = array(); foreach ($casesIds as $case) { $ids[] = $case->caseId; } $cases = CaseReport::whereNotNull('gps_lat')->whereNotNull('gps_lng')->whereIn('id', $ids)->get(); } foreach ($cases as $case) { if ($case->addressbook == 1) { $userObj = addressbook::find($case->reporter); $ReporterName = $userObj->FirstName . ' ' . $userObj->Surname; $ReporterPosition = ""; $ReporterMobile = $userObj->cellphone; } else { $userObj = user::find($case->reporter); $ReporterName = $userObj->name . ' ' . $userObj->surname; $RepPos = Position::find($userObj->position); $ReporterPosition = $RepPos->name; $ReporterMobile = $userObj->email; } $user = User::find($case->user);
greenLocalityOverlay = new google.maps.GroundOverlay('images/locality_overlay_green.png', imageBounds); greenLocalityOverlay.setMap(null); var oms = new OverlappingMarkerSpiderfier(map, { markersWontMove: true, keepSpiderfied:true, circleSpiralSwitchover:20 }); <?php use App\User; use App\CaseReport; use App\CaseNote; use App\Category; use App\Ship; use App\Position; use App\Department; use App\Municipality; use App\addressbook; $cases = CaseReport::whereNotNull('gps_lat')->whereNotNull('gps_lng')->get(); foreach ($cases as $case) { if ($case->addressbook == 1) { $userObj = addressbook::find($case->reporter); $ReporterName = $userObj->FirstName . ' ' . $userObj->Surname; $ReporterPosition = ""; $ReporterMobile = $userObj->cellphone; } else { $userObj = user::find($case->reporter); $ReporterName = $userObj->name . ' ' . $userObj->surname; $RepPos = Position::find($userObj->position); $ReporterPosition = $RepPos->name; $ReporterMobile = $userObj->email; } $user = User::find($case->user); $position = Position::find($user->position);