public function handle() { $karyawan = data_karyawan::find($this->req['karyawan']); $user = User::create(['id_karyawan' => $this->req['karyawan'], 'name' => $karyawan->nm_depan . ' ' . $karyawan->nm_belakang, 'username' => $this->req['username'], 'password' => bcrypt($this->req['password']), 'permission' => $this->req['permission']]); foreach ($this->req['levels'] as $level) { data_level::firstOrCreate(['id_user' => $user->id_user, 'id_level_user' => $level]); } return $user; }
/** * Execute the job. * * @return void */ public function handle() { $rec = data_employment::find($this->req['id']); data_employment::find($this->req['id'])->update(['id_status' => $this->req['id_status']]); if ($this->req['id_status'] == 2) { data_karyawan::create(['nm_depan' => $rec->nm_depan, 'nm_belakang' => $rec->nm_belakang, 'email' => $rec->email, 'sex' => $rec->sex, 'hp' => $rec->mobile, 'tempat_lahir' => $rec->tempat_lahir, 'tgl_lahir' => date('Y-m-d', strtotime($rec->tgl_lahir)), 'jabatan' => 1, 'alamat' => $rec->alamat, 'agama' => $rec->agama, 'pendidikan' => $rec->pendidikan, 'id_status' => 15, 'tgl_bergabung' => date('Y-m-d')]); } else { } return $this->req; }
/** * Execute the job. * * @return void */ public function handle() { $karyawan = data_karyawan::create(['NIK' => $this->req['nik'], 'nm_depan' => $this->req['nm_depan'], 'nm_belakang' => $this->req['nm_belakang'], 'telp' => $this->req['telp'], 'email' => $this->req['email'], 'sex' => $this->req['gender'], 'hp' => $this->req['hp'], 'tempat_lahir' => $this->req['tempat_lahir'], 'tgl_lahir' => date('Y-m-d', strtotime($this->req['tgl_lahir'])), 'jabatan' => $this->req['jabatan'], 'alamat' => $this->req['alamat'], 'agama' => $this->req['agama'], 'pendidikan' => $this->req['pendidikan'], 'id_status' => 15, 'tgl_bergabung' => date('Y-m-d', strtotime($this->req['tgl_bergabung'])), 'id_departemen' => $this->req['id_departemen']]); return $karyawan; }
public function postDetailspb(Request $req) { if ($req->ajax()) { $result = []; $out = ''; $spb = data_spb::find($req->id); if ($spb->status > 2) { $items = data_spb_item::join('data_barang', 'data_barang.id_barang', '=', 'data_spb_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_spb_item.id_satuan')->where('data_spb_item.id_spb', $req->id)->whereIn('data_spb_item.status', [1, 2])->select('data_spb_item.*', 'data_barang.nm_barang', 'data_barang.kode', 'ref_satuan.nm_satuan')->get(); } else { $items = data_spb_item::join('data_barang', 'data_barang.id_barang', '=', 'data_spb_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_spb_item.id_satuan')->where('data_spb_item.id_spb', $req->id)->where('data_spb_item.status', 1)->select('data_spb_item.*', 'data_barang.nm_barang', 'data_barang.kode', 'ref_satuan.nm_satuan')->get(); } if ($spb->id_acc > 0) { $me = data_karyawan::find($spb->id_acc); $out .= '<div class="grid simple"> <div class="grid-title no-border"></div> <div class="grid-body no-border"> <b>Disetujui Oleh : </b> ' . $me->nm_depan . ' ' . $me->nm_belakang . ' </div> </div> '; } else { $out .= '<div class="grid simple"> <div class="grid-title no-border"></div> <div class="grid-body no-border"> <i class="fa fa-warning"></i> Permintaan belum disetujui Kepala </div> </div> '; } $out .= '<div class="grid simple"> <div class="grid-title no-border"> <h4>' . count($items) . ' barang <strong>ditemukan</strong></4><br /> <small>Deadline : ' . \Format::indoDate($spb->deadline) . '</small> </div> <div class="grid-body no-border"> <table class="table table-striped"> <thead> <tr> <th>Kode</th> <th>Barang</th> <th class="text-right">Req Qty</th> </tr> </thead> <tbody> '; foreach ($items as $item) { $out .= ' <tr> <td>' . $item->kode . '</td> <td>' . \Format::substr($item->nm_barang, 20) . '</td> <td class="text-right">' . number_format($item->qty_lg, 0, ',', '.') . ' ' . $item->nm_satuan . '</td> </tr> '; } $out .= ' </tbody> </table> </div> </div>'; $btn = $spb->id_acc > 0 && \Auth::user()->permission > 1 && in_array($spb->status, [1, 2]) ? '<a href="' . url('/skb/process/' . $req->id) . '" class="btn btn-primary">Proses</a>' : ''; $result['kode'] = $spb->no_spb; $result['content'] = $out; $result['button'] = $btn; return json_encode($result); } }
public function getAllitems(Request $req) { if ($req->ajax()) { $res = []; $items = data_karyawan::details()->where('NIK', 'like', $req->kode . "%")->where('nm_depan', 'like', $req->src . "%")->paginate(10); $out = ''; if ($items->total() > 0) { $no = $items->currentPage() == 1 ? 1 : $items->perPage() * $items->currentPage() - $items->perPage() + 1; foreach ($items as $item) { $out .= ' <tr class="item_' . $item->id . ' items"> <td>' . $no . '</td> <td> <a href="javascript:;" title="' . $item->nm_depan . '" data-toggle="tooltip" data-placement="bottom">' . $item->nm_depan . ' ' . $item->nm_belakang . '</a> <div style="display:none;" class="tbl-opsi"> <small>[ <a href="' . url('karyawan/review/' . $item->id_karyawan) . '">Lihat</a> | <a href="' . url('karyawan/review/' . $item->id_karyawan) . '">Detail</a> ]</small> </div> </td> <td>' . $item->NIK . '</td> <td>' . $item->nm_jabatan . '</td> <td> <div> ' . \Format::indoDate($item->created_at) . ' </div> <small class="text-muted">' . \Format::hari($item->created_at) . ', ' . \Format::jam($item->created_at) . '</small> </td> <td>' . $item->nm_status . '</td> </tr> '; $no++; } } else { $out = ' <tr> <td colspan="4">Tidak ditemukan</td> </tr> '; } $res['data'] = $out; $res['pagin'] = $items->render(); return json_encode($res); } }
public function getChain(Request $req) { $result = []; if ($req->ajax()) { $result['result'] = true; $data = data_karyawan::find($req->id); $result['departemen'] = $data->id_departemen; $result['jabatan'] = $data->jabatan; } else { $result['result'] = false; } return json_encode($result); }
public function getPegawaitidakaktif() { $aktifasi_karyawan = data_karyawan::join('ref_status_karyawan', 'ref_status_karyawan.id', '=', 'data_karyawan.id_status')->where('tipe_status', 2)->get(); return view('Personalia.Status.status_pegawai_aktif', ['status_aktif' => ref_status_karyawan::where('tipe_status', 1)->get(), 'aktifasi_karyawan' => $aktifasi_karyawan]); }
/** * Edit barang * @access Admin Logistik * @author @hexters */ public function getUpdate($id) { $item = data_barang::find($id); if ($item == null) { return redirect('/logistik')->withNotif(['label' => 'danger', 'err' => 'Maaf, Tidak ditemukan !']); } if (!in_array($item->tipe, \Me::accessGudang())) { return redirect('/logistik')->withNotif(['label' => 'danger', 'err' => 'Maaf Bukan domain anda!']); } $user = data_karyawan::find($item->id_karyawan); $details = data_barang_detail::where('id_barang', $item->id_barang)->get(); $konversi = ref_konversi_satuan::where('ref_konversi_satuan.id_barang', $id)->whereNotIn('ref_konversi_satuan.id_satuan_max', [$item->id_satuan])->get(); return view('Pengadaan.Update', ['kategoris' => ref_kategori::all(), 'satuan' => ref_satuan::all(), 'item' => $item, 'oleh' => $user->nm_depan . ' ' . $user->nm_belakang, 'details' => $details, 'klasifikasi' => ref_klasifikasi::all(), 'konversi' => $konversi]); }
public function postDetailspb(Request $req) { if ($req->ajax()) { $result = []; $out = ''; $spb = data_spb::find($req->id); if ($spb->status > 2) { $items = data_spb_item::join('data_barang', 'data_barang.id_barang', '=', 'data_spb_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_barang.id_satuan')->where('data_spb_item.id_spb', $req->id)->whereIn('data_spb_item.status', [1, 2])->select('data_spb_item.*', 'data_barang.nm_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'ref_satuan.nm_satuan')->get(); } else { $items = data_spb_item::join('data_barang', 'data_barang.id_barang', '=', 'data_spb_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_spb_item.id_satuan')->where('data_spb_item.id_spb', $req->id)->where('data_spb_item.status', 1)->select('data_spb_item.*', 'data_barang.nm_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'ref_satuan.nm_satuan')->get(); } if ($spb->id_acc > 0) { $me = data_karyawan::find($spb->id_acc); $out .= '<div class="grid simple"> <div class="grid-title no-border"></div> <div class="grid-body no-border"> <b>Disetujui Oleh : </b> ' . $me->nm_depan . ' ' . $me->nm_belakang . '<br /> <small class="text-muted">' . \Format::hari($spb->tgl_approval) . ', ' . \Format::indoDate2($spb->tgl_approval) . ' ' . \Format::jam($spb->tgl_approval) . '</small> </div> </div> '; } $out .= '<div class="grid simple"> <div class="grid-title no-border"> <h4>' . count($items) . ' barang <strong>ditemukan</strong></4><br /> <small>Deadline : ' . \Format::indoDate($spb->deadline) . '</small> </div> <div class="grid-body no-border"> <table class="table table-striped"> <thead> <tr> <th>Kode</th> <th>Barang</th> <th>Sisa</th> <th class="text-right">Qty</th> </tr> </thead> <tbody> '; foreach ($items as $item) { $out .= ' <tr> <td>' . $item->kode . '</td> <td>' . \Format::substr($item->nm_barang, 20) . '</td> <td>' . number_format($item->in - $item->out, 0, ',', '.') . ' ' . $item->nm_satuan . '</td> <td class="text-right">' . number_format($item->qty_lg, 0, ',', '.') . ' ' . $item->nm_satuan . '</td> </tr> '; } $out .= ' </tbody> </table> </div> </div>'; $btn = \Auth::user()->permission > 2 && $spb->status < 2 && empty($spb->id_acc) ? '<button data-loading-text="<i class=\'fa fa-circle-o-notch fa-spin\'></i> Proses..." class="btn btn-primary btn-accspb" onclick="acc(' . $req->id . ');"><i class="fa fa-check"></i> Setujui</button>' : ''; $result['kode'] = $spb->no_spb; $result['content'] = $out; $result['button'] = $btn; return json_encode($result); } }
public function departemen() { return data_karyawan::leftJoin('data_departemen', 'data_departemen.id_departemen', '=', 'data_karyawan.id_departemen')->where('data_karyawan.id_karyawan', \Auth::user()->id_karyawan)->select('data_departemen.nm_departemen')->first()->nm_departemen; }
public function getAdd() { $karyawan = data_karyawan::leftJoin('users', 'users.id_karyawan', '=', 'data_karyawan.id_karyawan')->whereNull('users.id_user')->select('data_karyawan.id_karyawan', 'data_karyawan.nm_depan', 'data_karyawan.nm_belakang')->get(); $levels = data_level_user::whereStatus(1)->get(); return view('Users.AddUsers', ['stafs' => $karyawan, 'levels' => $levels]); }
/** * Execute the job. * * @return void */ public function handle() { data_personalia::create(['id_karyawan' => $this->req['id_karyawan'], 'id_status' => $this->req['id_status'], 'surat_keputusan' => $this->req['surat_keputusan'], 'datetime_in' => date('Y-m-d', strtotime($this->req['datetime_in'])), 'keterangan' => $this->req['keterangan']]); data_karyawan::find($this->req['id_karyawan'])->update(['id_status' => $this->req['id_status']]); return $this->req; }