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);
