/** * 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 index() { if (Auth::check() && Auth::user()->id_karyawan == '1') { $absen = Absen::all(); $laporan = Laporan::all(); $shift = Shift::all(); return view('admin/index')->with("absen", $absen)->with("laporan", $laporan)->with("shift", $shift); } 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'); } }
/** * Menampilkan data pengumuman. * * @return integer */ public function index() { if (Auth::check() && Auth::user()->id_karyawan == '1') { $absen = Absen::all(); $laporan = Laporan::all(); $shift = Shift::all(); $notice = Notice::orderBy("id_notice", "DESC")->paginate(10); $divisi = Karyawan::divisi(); return view('admin/pengumuman/pengumuman')->with("absen", $absen)->with("laporan", $laporan)->with("shift", $shift)->with("divisi", $divisi)->with("notice", $notice); } else { return view('errors/403'); } }
/** * Display a listing of the resource. * * @return string Data shift dan request. */ public function index() { // if (Auth::check()) { $id_karyawan = Auth::user()->id_karyawan; $today = date("Y-m-d"); $getNotice = Notice::byDivisi(Auth::user()->id_divisi); $shift = \DB::table('shift')->get(); $month_end = date('Y-m-d', strtotime('last day of this month', time())); $shiftLine = Shift::join("shift", "shift_line.id_shift", "=", "shift.id_shift")->where("id_karyawan", "=", $id_karyawan)->whereBetween("tanggal_shift", array($today, $month_end))->orderBy("id_shiftline")->get(); $req = rModel::join("shift_line", "request.shift_lama", "=", "shift_line.tanggal_shift")->where("request.id_karyawan", "=", "{$id_karyawan}")->orderBy("id", "DESC")->first(); return view('shift/index')->with("getNotice", $getNotice)->with("shift", $shift)->with("shiftLine", $shiftLine)->with("req", $req); } else { return \Redirect::to('login'); } }
/** * Display a listing of the resource. * * @return string Data shift dan request. */ public function index() { // if (Auth::check()) { $id_karyawan = Auth::user()->id_karyawan; $today = date("Y-m-d"); $getNotice = Notice::where("id_karyawan", "=", $id_karyawan)->where("tanggal", "=", $today)->get(); $shift = \DB::table('shift')->get(); $month_end = date('Y-m-d', strtotime('last day of this month', time())); $shiftLine = Shift::join("shift", "shift_line.id_shift", "=", "shift.id_shift")->where("id_karyawan", "=", $id_karyawan)->whereBetween("tanggal_shift", array($today, $month_end))->orderBy("id_shiftline")->get(); $req = rModel::where("id_karyawan", "=", $id_karyawan)->orderBy("id", "DESC")->first(); \DB::table('logs')->insert(['id_karyawan' => $id_karyawan, 'content' => Auth::user()->username . ' akses halaman daftar shift', 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')]); return view('shift/index')->with("getNotice", $getNotice)->with("shift", $shift)->with("shiftLine", $shiftLine)->with("req", $req); } 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'); } }
public function postgenerator() { if (Auth::check() && Auth::user()->id_karyawan == '1') { $dari = \Input::get('dari'); $id_karyawan = \Input::get('id_karyawan'); $sampai = \Input::get('sampai'); $id_shift = \Input::get('id_shift'); $dariMysql = Shift::ExplodeDate($dari, 'hari') . "/" . Shift::ExplodeDate($dari, 'bulan') . "/" . Shift::ExplodeDate($dari, 'tahun'); $sampaiMysql = Shift::ExplodeDate($sampai, 'hari') . "/" . Shift::ExplodeDate($sampai, 'bulan') . "/" . Shift::ExplodeDate($sampai, 'tahun'); $datePeriod = Shift::returnDates($dariMysql, $sampaiMysql); foreach ($datePeriod as $date) { $data = ["id_shift" => $id_shift, "id_karyawan" => $id_karyawan, "tanggal_shift" => $date->format('Y-m-d')]; Shift::insert($data); } return \Redirect::to('admin/shift'); } else { return view('errors/403'); } //return view('admin/shift/generator'); }
/** * Update data jadwal shift karyawan. * * @return integer */ public function update($id) { if (Auth::check() && Auth::user()->id_karyawan == '1') { $data = Shift::find($id); $data->id_shift = \Input::get('id_shift'); $tgl = explode("/", \Input::get('tanggal')); $data->tanggal_shift = $tgl[2] . "-" . $tgl[0] . "-" . $tgl[1]; $data->id_karyawan = \Input::get('id_karyawan'); $data->save(); return \Redirect::to('admin/shift'); } else { return view('errors/403'); } }