Sadržaj

reloationships and db queries

• $dolazak = Dolazak::with('clan.clanZadnjaClanarina')->get();
• $br_dolazaka = count($dolazak);
• $dolazak_array = $dolazak->toArray();
• dd('br_dolazaka - collection count ',$br_dolazaka,' dolazak - ',$dolazak);

br_dolazak to array, array count ukupno dolazaka - radi uredno

$dolazak = Dolazak::with('clan.clanZadnjaClanarina')->latest('clanarina.datum_isteka')->get();

SELECT * FROM clan_dolazak join clan on clan_dolazak.clan_id=clan.id join clanarina on clanarina.clan_id=clan.id where clan.clan_status_id=1

DB::table('clan_dolazak') ->select('*') ->join('clan','clan_dolazak.clan_id','=','clan.id') ->join('clanarina','clanarina.clan_id','=','clan.id') ->where('clan.clan_status_id','=',1) ->where('clanarina.datum_isteka','=',DB::raw('CURRENT_DATE'())) ->get();

// code parts

                              /*
        $subquery = DB::table('catch-text')
    ->select(DB::raw("user_id,MAX(created_at) as MaxDate"))
    ->groupBy('user_id');

        $query = User::joinSub($subquery,'MaxDates',function($join){
        $join->on('users.id','=','MaxDates.user_id');
        })->select(['users.*','MaxDates.*']); */


         ## br_dolazak to array, array count ukupno dolazaka - radi uredno
        // $dolazak = Dolazak::with('clan.zadnjaClanarina')->latest('clanarina.datum_isteka')->get();
        //dd('dolasci',$model,'broj dolazaka',$broj_model);
        //dd('broj dolazaka',$broj_model ,'dolazak3 - join s clan',$dolazak3_array,'dolazak3 - clanarina',$dolazak3_clanarina);