Hi All!
Have this working code now, but give me a warning in the console
$query = DB::table('gpstrackers')
->select('*', 'users.name')
->join('users', 'gpstrackers.player_id_ref', '=', 'users.id')
->whereIn('gpstrackers.id', function($query) use ($from1, $to1) {
$query->selectRaw('MAX(gpstrackers.id) as id')
->from('gpstrackers')
->join('users', 'gpstrackers.player_id_ref', '=', 'users.id')
->whereBetween('gpstrackers.regdate',[$from1,$to1])
->groupBy('gpstrackers.flight','gpstrackers.player_id_ref');
});
if($holenumber=='true'){
$query1 = DB::table('holesclub')
->select('*', 'users.name')
->join('users', 'users.id', '=','holesclub.player_id_ref');
$query->union($query1);
}
if($flagget=='true'){
$query2 = DB::table('flagpositions')
->select('*', 'users.name')
->join('users', 'users.id', '=','flagpositions.player_id_ref');
$query->union($query2);
}
if($toilet=='true'){
$query3 = DB::table('objectsclub')
->select('*', 'users.name')
->join('users', 'users.id', '=','objectsclub.player_id_ref');
$query->union($query3);
}
if($flagget=='false')
{
$query->where('type', '<>', 2);
}
if($judge=='false')
{
$query->where('type', '<>', 3);
}
if($toilet=='false')
{
$query->where('type', '<>', 5);
}
if($holenumber=='false')
{
$query->where('type', '<>', 7);
}
if($dl=='false')
{
$query->where('type', '<>', 12);
}
if($bm=='false')
{
$query->where('type', '<>', 8);
}
if($td=='false')
{
$query->where('type', '<>', 9);
}
if($tl=='false')
{
$query->where('type', '<>', 10);
}
if($range=='false')
{
$query->where('type', '<>', 11);
}
if($green=='false'){
$query->where('colormarker', '<>', 1);
}
if($orange=='false'){
$query->where('colormarker', '<>', 2);
}
if($red=='false'){
$query->where('colormarker', '<>', 3);
}
$gpsdata = $query->get();
return $gpsdata;
Warnig message console:
[Vue warn]: Duplicate keys detected: '1'. This may cause an update error.
found in...
