/** * Mencari data absen dengan menggunakan filter search. * * @return string */ public function cariAbsen() { if (Auth::check() && Auth::user()->id_karyawan == '1') { $karyawan = Karyawan::where("id_karyawan", ">", "1")->get(); $shifts = Shift::shift(); if (\Input::get('karyawan') != null && \Input::get('shift') == null && \Input::get('tipe') == null) { $cariAbsen = Absen::where("id_karyawan", "=", \Input::get('karyawan'))->orderBy("id_absen", "DESC")->paginate(10)->appends(['karyawan' => \Input::get('karyawan')]); } elseif (\Input::get('karyawan') == null && \Input::get('shift') != null && \Input::get('tipe') == null) { $cariAbsen = Absen::where("id_shift", "=", \Input::get('shift'))->orderBy("id_absen", "DESC")->paginate(10)->appends(['shift' => \Input::get('shift')]); } elseif (\Input::get('karyawan') == null && \Input::get('shift') == null && \Input::get('tipe') != null) { $cariAbsen = Absen::where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->paginate(10)->appends(['tipe' => \Input::get('tipe')]); } elseif (\Input::get('karyawan') != null && \Input::get('shift') != null && \Input::get('tipe') == null) { $cariAbsen = Absen::where("id_karyawan", "=", \Input::get('karyawan'))->where("id_shift", "=", \Input::get('shift'))->paginate(10)->appends(['karyawan' => \Input::get('karyawan'), 'shift' => \Input::get('shift')]); } elseif (\Input::get('karyawan') != null && \Input::get('shift') == null && \Input::get('tipe') != null) { $cariAbsen = Absen::where("id_karyawan", "=", \Input::get('karyawan'))->where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->paginate(10)->appends(['karyawan' => \Input::get('karyawan'), 'tipe' => \Input::get('tipe')]); } elseif (\Input::get('karyawan') == null && \Input::get('shift') != null && \Input::get('tipe') != null) { $cariAbsen = Absen::where("id_shift", "=", \Input::get('shift'))->where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->paginate(10)->appends(['shift' => \Input::get('shift'), 'tipe' => \Input::get('tipe')]); } elseif (\Input::get('karyawan') != null && \Input::get('shift') != null && \Input::get('tipe') != null) { $cariAbsen = Absen::where("id_karyawan", "=", \Input::get('karyawan'))->where("id_shift", "=", \Input::get('shift'))->where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->paginate(10)->appends(['karyawan' => \Input::get('karyawan'), 'shift' => \Input::get('shift'), 'tipe' => \Input::get('tipe')]); } else { $cariAbsen = Absen::orderBy("id_absen", "DESC")->paginate(10)->appends(['karyawan' => \Input::get('karyawan'), 'shift' => \Input::get('shift'), 'tipe' => \Input::get('tipe')]); } return view('admin/absen/cari')->with("cariAbsen", $cariAbsen)->with("karyawan", $karyawan)->with("shifts", $shifts); } else { return view('errors/403'); } }
public function cariAbsen() { if (Auth::check() && Auth::user()->id_karyawan == '1') { $karyawan = Karyawan::get(); $shifts = Shift::shift(); $cariAbsen = Absen::where("id_karyawan", "=", \Input::get('karyawan'))->where("id_shift", "=", \Input::get('shift'))->where("status", "=", \Input::get('tipe'))->get(); return view('admin/absen/absen')->with("cariAbsen", $cariAbsen)->with("karyawan", $karyawan)->with("shifts", $shifts); } else { return view('errors/403'); } }
/** * Display a listing of the resource. * * @return string Data absen karyawan dan pengumuman. */ public function index() { if (Auth::check()) { $id_karyawan = Auth::user()->id_karyawan; $today = date("Y-m-d"); $absen = Absen::where("id_karyawan", "=", $id_karyawan)->orderBy("id_absen", "DESC")->paginate(10); $getNotice = Notice::byDivisi(Auth::user()->id_divisi); return view('absen/index')->with("absen", $absen)->with("getNotice", $getNotice); } else { return \Redirect::to('login'); } }
/** * Display a listing of the resource. * * @return string */ public function index() { if (Auth::check()) { $id_karyawan = Auth::user()->id_karyawan; $absen = Absen::where("id_karyawan", "=", $id_karyawan)->orderBy("id_absen", "DESC")->first(); $today = date('Y-m-d'); $report = Laporan::where("id_karyawan", "=", $id_karyawan)->where("tanggal", "=", $today)->first(); $note = Dashboard::where("id_karyawan", "=", $id_karyawan)->first(); $getNotice = Notice::where("id_karyawan", "=", $id_karyawan)->where("tanggal", "=", $today)->get(); $shiftLine = Shift::join("shift", "shift_line.id_shift", "=", "shift.id_shift")->where("tanggal_shift", "=", $today)->where("id_karyawan", "=", $id_karyawan)->first(); $yesterday = date("Y-m-d", time() - 86400); $shiftKmrn = Shift::join("shift", "shift_line.id_shift", "=", "shift.id_shift")->where("tanggal_shift", "=", $yesterday)->where("id_karyawan", "=", $id_karyawan)->first(); $besok = date("Y-m-d", time() + 86400); $shiftBesok = Shift::join("shift", "shift_line.id_shift", "=", "shift.id_shift")->where("tanggal_shift", "=", $besok)->where("id_karyawan", "=", $id_karyawan)->first(); /** * untuk mengecek $id_karyawan * masuk shift berapa * @return string */ if ($shiftLine != null) { $shiftname = $shiftLine->nama_shift; } else { $shiftname = "Non Shift"; } if ($absen != null) { $tgl = explode(" ", $absen->created_at); if ($absen->status == "masuk" && $tgl[0] == $yesterday) { $absen = new Absen(); $absen->id_karyawan = $id_karyawan; $absen->id_shift = $shiftKmrn->id_shift; $absen->status = "keluar"; $absen->save(); } elseif ($absen->status == "masuk" && $tgl[0] != $today) { $absen = new Absen(); $absen->id_karyawan = $id_karyawan; $absen->id_shift = "4"; $absen->status = "keluar"; $absen->save(); } } return view('dashboard/index')->with("absen", $absen)->with("report", $report)->with("note", $note)->with("getNotice", $getNotice)->with("shiftLine", $shiftLine)->with("shiftKmrn", $shiftKmrn)->with("shiftBesok", $shiftBesok)->with("shiftname", $shiftname); } else { return \Redirect::to('login'); } }