public function store(Request $request)
{
//
$user = new Karyawan();
$user->nama_karyawan = \Input::get('name');
$user->id_jkelamin = \Input::get('jkelamin');
$user->alamat = \Input::get('alamat');
$tgl = explode("/", \Input::get('tanggal'));
$user->ttl = \Input::get('tempat') . ", " . $tgl[2] . "-" . $tgl[0] . "-" . $tgl[1];
$user->username = \Input::get('username');
$user->email = \Input::get('email');
$pass = \Input::get('password');
$user->password = bcrypt($pass);
$user->id_divisi = \Input::get('divisi');
$user->id_jabatan = \Input::get('jabatan');
$user->save();
return \Redirect::to('admin/karyawan');
}
public function listKaryawan()
{
if (Auth::check() && Auth::user()->id_jabatan == '2') {
$listKaryawan = Karyawan::where("id_divisi", "=", Auth::user()->id_divisi)->where("id_karyawan", "!=", Auth::user()->id_karyawan)->paginate(10);
$getNotice = Notice::byDivisi(Auth::user()->id_divisi);
return view('karyawan/karyawan')->with('listKaryawan', $listKaryawan)->with('getNotice', $getNotice);
} else {
return view('errors/403');
}
}
public function generator()
{
if (Auth::check() && Auth::user()->id_karyawan == '1') {
$employees = Karyawan::all();
$shifts = Shift::shift();
return view('admin/shift/generator')->with("employees", $employees)->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');
}
}
/**
* 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');
}
}
public function exportXLS()
{
if (\Input::get('karyawan') != null && \Input::get('shift') == null && \Input::get('tipe') == null) {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->where("absen.id_karyawan", "=", \Input::get('karyawan'))->orderBy("id_absen", "DESC")->get();
} elseif (\Input::get('karyawan') == null && \Input::get('shift') != null && \Input::get('tipe') == null) {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->where("absen.id_shift", "=", \Input::get('shift'))->orderBy("id_absen", "DESC")->get();
} elseif (\Input::get('karyawan') == null && \Input::get('shift') == null && \Input::get('tipe') != null) {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->get();
} elseif (\Input::get('karyawan') != null && \Input::get('shift') != null && \Input::get('tipe') == null) {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->where("absen.id_karyawan", "=", \Input::get('karyawan'))->where("absen.id_shift", "=", \Input::get('shift'))->get();
} elseif (\Input::get('karyawan') != null && \Input::get('shift') == null && \Input::get('tipe') != null) {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->where("absen.id_karyawan", "=", \Input::get('karyawan'))->where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->get();
} elseif (\Input::get('karyawan') == null && \Input::get('shift') != null && \Input::get('tipe') != null) {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->where("absen.id_shift", "=", \Input::get('shift'))->where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->get();
} elseif (\Input::get('karyawan') != null && \Input::get('shift') != null && \Input::get('tipe') != null) {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->where("absen.id_karyawan", "=", \Input::get('karyawan'))->where("absen.id_shift", "=", \Input::get('shift'))->where("status", "=", \Input::get('tipe'))->orderBy("id_absen", "DESC")->get();
} else {
$users = Absen::select('nama_karyawan as Nama_Karyawan', 'nama_shift as Shift', 'absen.created_at as Tanggal', 'status as Status')->join('karyawan', 'absen.id_karyawan', '=', 'karyawan.id_karyawan')->join('shift', 'absen.id_shift', '=', 'shift.id_shift')->orderBy("id_absen", "DESC")->get();
}
\Excel::create('Report Absen Karyawan ' . Karyawan::nama_karyawan(\Input::get('karyawan')), function ($excel) use($users) {
$excel->sheet('Sheet 1', function ($sheet) use($users) {
$sheet->fromArray($users);
});
})->export('xls');
}
/**
* Edit data karyawan.
*
* @return integer
*/
public function update($id)
{
if (Auth::check() && Auth::user()->id_karyawan == '1') {
$user = Karyawan::find($id);
$user->nama_karyawan = \Input::get('nama');
$user->id_jkelamin = \Input::get('jkelamin');
$user->alamat = \Input::get('alamat');
if (\Input::get('tanggal') != null) {
$tgl = explode("/", \Input::get('tanggal'));
$user->ttl = \Input::get('tempat') . ", " . $tgl[2] . "-" . $tgl[0] . "-" . $tgl[1];
}
$user->username = \Input::get('username');
$user->email = \Input::get('email');
$user->id_divisi = \Input::get('divisi');
$user->id_jabatan = \Input::get('jabatan');
$user->save();
return \Redirect::to('admin/karyawan');
} else {
return view('errors/403');
}
}
