how to show only last record with query builder in laravel

I only want to display the latest data from the tanggal_ins that I have marked, how to?

This is my json data:

And this is my query:

$cuti = DB::table('t_cuti as cuti')
        ->join('m_karyawan as kary', 'kary.nik', '=', 'cuti.nik')
        ->join('m_rumah_sakit as rs', 'rs.kd_rs', '=', 'kary.kd_rs')
        ->join('m_unit as unit', 'unit.kd_unit', '=', 'kary.kd_unit')
        ->join('m_jabatan as jab', 'jab.kd_jabatan', '=', 'kary.kd_jabatan')
        ->leftJoin('t_cuti_adjust as adj', function ($leftJoin) {
            $leftJoin->on('adj.nik', '=', 'cuti.nik')
                ->latest();
        })
        ->select('adj.tanggal_ins','cuti.saldo_cuti','kary.nik','kary.nm_karyawan','rs.nm_rs','unit.nm_unit','jab.nm_jabatan')
        ->whereYear('adj.tanggal_ins', '<', $year)
        ->orWhere('adj.tanggal_ins', null)
        ->get();

Thanks.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2RBw7IS
via IFTTT