public function detail(Request $request,$nik)
    {
        DB::statement(DB::raw('set @rownum=0'));
        $users = \DB::table('absen')->where('nik',$nik)->select([
            DB::raw('@rownum  := @rownum  + 1 AS rownum'),
            'nik','tanggal'])->groupBy('nik','tanggal');
        $datatables = Datatables::of($users)->addColumn('masuk',function($e){
            $cek = \DB::table('absen')->where('nik',$e->nik)->where('tanggal',$e->tanggal)->where('keterangan','masuk')->count();
            if($cek < 1){
                $masuk = '<p style="color:red;">Tidak Absen</p>';
            }else{
                $dt = \DB::table('absen')->where('nik',$e->nik)->where('tanggal',$e->tanggal)->where('keterangan','masuk')->first();
                $masuk = date('H:i:s',strtotime($dt->created_at));
            }
            return $masuk;
        })->addColumn('pulang',function($e){
            $cek = \DB::table('absen')->where('nik',$e->nik)->where('tanggal',$e->tanggal)->where('keterangan','pulang')->count();
            if($cek < 1){
                $pulang = '<p style="color:red;">Tidak Absen</p>';
            }else{
                $dt = \DB::table('absen')->where('nik',$e->nik)->where('tanggal',$e->tanggal)->where('keterangan','pulang')->first();
                $pulang = date('H:i:s',strtotime($dt->created_at));
            }
            return $pulang;
        })->editColumn('tanggal',function($e){
            $tgl = $e->tanggal;
            $tgl = date('Y-m-d',strtotime($tgl));
            return $tgl;
        })->rawColumns(['masuk','pulang']);

        if ($keyword = $request->get('search')['value']) {
            $datatables->filterColumn('rownum', 'whereRaw', '@rownum  + 1 like ?', ["%{$keyword}%"]);
        }

        return $datatables->make(true);
    }

    public function yajra(Request $request)
    {
        DB::statement(DB::raw('set @rownum=0'));
        $users = \DB::table('absen')->select([
            DB::raw('@rownum  := @rownum  + 1 AS rownum'),
            'nama','nik'])->groupBy('nama','nik')->orderBy('nama','asc');
        $datatables = Datatables::of($users)->addColumn('total_masuk',function($e){
            $total_masuk = \DB::table('absen')->where('nik',$e->nik)->where('keterangan','masuk')->count();

            return $total_masuk;
        })->addColumn('total_pulang',function($e){
            $total_pulang = \DB::table('absen')->where('nik',$e->nik)->where('keterangan','pulang')->count();

            return $total_pulang;
        })->addColumn('details_url',function($e){
            return url('admin/rekap/absen/detail/'.$e->nik);
        });

        if ($keyword = $request->get('search')['value']) {
            $datatables->filterColumn('rownum', 'whereRaw', '@rownum  + 1 like ?', ["%{$keyword}%"]);
        }

        return $datatables->make(true);
    }