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;
}
