public function getTambah(Request $request)
{
$data['jabatan'] = Jabatan::paginate(10);
$dt = new Jabatan();
$dt->nama = $request->nama;
$dt->save();
return redirect()->route('jabatan', $data);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$data = Karyawan::find($id)->toArray();
$jabatans = Jabatan::all()->toArray();
//dd($data);
return view('karyawan.edit', compact('data', 'jabatans'));
}
public function getHapus($id)
{
$val = explode(",", $id);
foreach ($val as $value) {
Jabatan::where('id', $value)->delete();
}
return redirect()->route('jabatan');
}
public function getUpdate(Request $request)
{
$data = Jabatan::find($request->id);
$data->nama = $request->nama;
$data->save();
$data['jabatan'] = Jabatan::paginate(1);
return redirect()->route('jabatan', $data)->with(session()->flash('success', 'Data Berhasil diupdate !!'));
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('jabatans', function (Blueprint $table) {
$table->increments('id');
$table->string('nama');
});
Jabatan::create(['nama' => 'Default']);
Jabatan::create(['nama' => 'Sales']);
Jabatan::create(['nama' => 'Lihat yag lain lagi']);
}
public function uploadFile()
{
try {
Excel::load(Input::file('file'), function ($reader) {
foreach ($reader->toObject() as $row) {
if (KartuIndukPegawai::where('nip', $row->nip)->exists()) {
//do nothing;
} else {
$kartu_induk_pegawais = new KartuIndukPegawai();
$kartu_induk_pegawais->nip = $row->nip;
$kartu_induk_pegawais->karpeg = $row->karpeg;
$kartu_induk_pegawais->karis_karsu = $row->karis_karsu;
$kartu_induk_pegawais->nama_lengkap = $row->nama_lengkap;
$kartu_induk_pegawais->tempat_lahir = $row->tempat_lahir;
$kartu_induk_pegawais->tgl_lahir = date("Y-m-d", strtotime($row->tgl_lahir));
$kartu_induk_pegawais->jenis_kelamin = $row->jenis_kelamin;
$kartu_induk_pegawais->status_perkawinan = $row->status_perkawinan;
$kartu_induk_pegawais->tgl_masuk_pegawai = date("Y-m-d", strtotime($row->tgl_masuk_pegawai));
$kartu_induk_pegawais->status_kepegawaian = $row->status_kepegawaian;
$kartu_induk_pegawais->agama = $row->agama;
$kartu_induk_pegawais->jenis_kepegawaian = $row->jenis_kepegawaian;
$kartu_induk_pegawais->tgl_pensiun = date("Y-m-d", strtotime($row->tgl_pensiun));
$kartu_induk_pegawais->foto = 'no-foto.png';
$kartu_induk_pegawais->save();
//process jabatan
$jabatans = new Jabatan();
$jabatans->kartu_induk_pegawai_id = $kartu_induk_pegawais->id;
$jabatans->tmt_pangkat = NULL;
$jabatans->save();
}
}
});
Session::flash('message', 'Import File telah sukses.');
return Redirect::to('import-file');
} catch (\Exception $e) {
Session::flash('message', 'Import File Error');
//$e->getMessage()
Session::flash('alert-class', 'alert-danger');
return Redirect::to('import-file');
}
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(Request $request, $id)
{
$jabatans = Jabatan::find($id);
//$jabatans->kartu_induk_pegawai_id = Input::get('id');
$jabatans->jabatan = Input::get('jabatan');
$jabatans->unit_kerja = Input::get('unit_kerja');
$jabatans->keterangan_unit_kerja = Input::get('keterangan_unit_kerja');
$jabatans->pangkat_golongan_ruang = Input::get('pangkat_golongan_ruang');
$jabatans->tmt_pangkat = date("Y-m-d", strtotime(Input::get('tmt_pangkat')));
$jabatans->masakerja_tahun = Input::get('masakerja_tahun');
$jabatans->masakerja_bulan = Input::get('masakerja_bulan');
$jabatans->pendidikan_terakhir = Input::get('pendidikan_terakhir');
$jabatans->save();
$kartuindukpegawais = KartuIndukPegawai::find(Input::get('kartu_induk_pegawai_id'));
Session::flash('message', 'Input Jabatan Pegawai NIP: ' . $kartuindukpegawais->nip . ' Sukses');
return Redirect::to('kartu-induk-pegawai/' . Input::get('kartu_induk_pegawai_id') . '/jabatan');
}
public function __construct(Model $model, $base = 'pns')
{
parent::__construct($model, $base);
$jabatans = Jabatan::lists('jabatan', 'id')->toArray();
$instansis = Instansi::lists('instansi', 'id')->toArray();
$atasans = Model::whereHas('Jabatan', function ($query) {
$query->where('status', Jabatan::STRUKTURAL);
});
$list = $atasans->get();
$atasans = [];
foreach ($list as $atasan) {
$atasans[$atasan->id] = "{$atasan->nip} - {$atasan->nama}";
}
$jenis_kelamins = Model::getJenisKelamin();
view()->share('breadcrumb2', 'PNS');
view()->share('breadcrumb2Icon', 'male');
view()->share('jabatans', $jabatans);
view()->share('instansis', $instansis);
view()->share('atasans', $atasans);
view()->share('jenis_kelamins', $jenis_kelamins);
}
public function jabatan($id)
{
$kartu_induk_pegawais = KartuIndukPegawai::find($id);
$jabatans = Jabatan::where('kartu_induk_pegawai_id', $id)->first();
return view('kartu-induk-pegawai.jabatan', ['jabatan' => $jabatans, 'kartu_induk_pegawai' => $kartu_induk_pegawais]);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
// Validation //
$validation = Validator::make($request->all(), Jabatan::rules($id));
// Check if it fails //
if ($validation->fails()) {
Alert::error('Terjadi kesalahan!')->persistent("Close");
return redirect()->back()->withInput()->with('errors', $validation->errors());
}
$jb = Jabatan::find($id);
$jb->name = $request->input('name');
$jb->save();
Alert::success('Berhasil merubah, ' . $request->input('name') . ' !')->persistent("Close");
return redirect('jabatan/list')->with('message', 'Berhasil edit !');
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$data = Employee::find($id);
$province = Province::all();
$cities = City::all();
$citmin = City::whereRaw('id = (select min(`id`) from cities)')->get();
$citmax = City::whereRaw('id = (select max(`id`) from cities)')->get();
$grade = Grade::all();
$jabatans = Jabatan::all();
$pt = array('sd' => 'SD', 'smp' => 'SMP', 'sma' => 'SMA', 'd3' => 'D3', 's1' => 'S1', 'S2' => 'S2');
$citsel = unserialize($data->id_cities);
$tls = Teamleader::where('id_users', $data->id)->get();
$pos = ProjectOfficer::where('id_users', $data->id)->get();
$adms = Admin::where('id_users', $data->id)->get();
return view('dropmin/data/edit')->with('data', $data)->with('province', $province)->with('grade', $grade)->with('tls', $tls)->with('pos', $pos)->with('adms', $adms)->with('jabatans', $jabatans)->with('pt', $pt)->with('citsel', $citsel)->with('cities', $cities);
}
public function getExportPdf(Request $r)
{
$nelayan = User::where('profesi', 'Nelayan')->whereBetween('created_at', [$r->offset, $r->limit])->orderBy('id', 'desc');
$data['nelayan'] = $nelayan->get();
$data['kelompok'] = Kelompok::where('tipe', '2')->get();
$data['jabatan'] = Jabatan::all();
$data['tgl_awal'] = $r->offset;
$data['tgl_akhir'] = $r->limit;
$pdf = PDF::loadView('app.nelayan.export-pdf', $data);
return $pdf->setPaper('legal')->setOrientation('landscape')->setWarnings(false)->download('Data Nelayan.pdf');
}
public function update(Request $request, $id)
{
// Start Check Authorization
$invalid_auth = 1;
$authRole = Auth::user()->UserRoles->role;
if ($authRole == 1 or $authRole == 3) {
$invalid_auth = 0;
}
if ($invalid_auth == 1) {
Alert::error('Anda tidak memilik akses ini')->persistent('close');
return redirect('dashboard');
}
// End Check Authorization
// Validation //
$validation = Validator::make($request->all(), Jabatan::rules($id));
// Check if it fails //
if ($validation->fails()) {
Alert::error('Terjadi kesalahan!')->persistent("Close");
return redirect()->back()->withInput()->with('errors', $validation->errors());
}
$jb = Jabatan::find($id);
$jb->name = $request->input('name');
$jb->save();
Alert::success('Berhasil merubah, ' . $request->input('name') . ' !')->persistent("Close");
return redirect('jabatan/list')->with('message', 'Berhasil edit !');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$jabatan = Jabatan::find($id);
$jabatan->delete();
return redirect('jabatan');
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
// Start Check Authorization
/**
* 1. FullAccess - 1
* 2. HRD - 3
* 3. Creator - 5
* 4. Handler - 7
*/
$invalid_auth = 1;
$authRole = Auth::user()->UserRoles->role;
if ($authRole == 7 or $authRole == 1 or $authRole == 3) {
$invalid_auth = 0;
}
if ($invalid_auth == 1) {
Alert::error('Anda tidak memilik akses ini')->persistent('close');
return redirect('data/list');
}
// End Check Authorization
$data = Employee::find($id);
$province = Province::all();
$cities = City::all();
$citmin = City::whereRaw('id = (select min(`id`) from cities)')->get();
$citmax = City::whereRaw('id = (select max(`id`) from cities)')->get();
$grade = Grade::all();
$jabatans = Jabatan::all();
$pt = array('sd' => 'SD', 'smp' => 'SMP', 'sma' => 'SMA', 'd3' => 'D3', 's1' => 'S1', 'S2' => 'S2');
$citsel = unserialize($data->id_cities);
$tls = Teamleader::where('id_users', $data->id)->get();
$pos = ProjectOfficer::where('id_users', $data->id)->get();
$adms = Admin::where('id_users', $data->id)->get();
return view('dropmin/data/edit')->with('data', $data)->with('province', $province)->with('grade', $grade)->with('tls', $tls)->with('pos', $pos)->with('adms', $adms)->with('jabatans', $jabatans)->with('pt', $pt)->with('citsel', $citsel)->with('cities', $cities);
}
public function getExportPdf(Request $r)
{
$pembudidaya = User::where('profesi', 'Pembudidaya')->whereBetween('created_at', [$r->offset, $r->limit])->orderBy('id', 'desc');
if ($r->f != "") {
$pembudidaya->where('jenis_usaha', $r->f);
}
$data['pembudidaya'] = $pembudidaya->get();
$data['kelompok'] = Kelompok::where('tipe', 'Pembudidaya')->get();
$data['jabatan'] = Jabatan::all();
$data['tgl_awal'] = $r->offset;
$data['tgl_akhir'] = $r->limit;
$pdf = PDF::loadView('app.pembudidaya.export-pdf', $data);
return $pdf->setPaper('legal')->setOrientation('landscape')->setWarnings(false)->download('Data Pembudidaya.pdf');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy(Jabatan $jabatan)
{
$jabatan->delete();
return redirect('/jabatan');
}
public function cetak($id)
{
$kartu_induk_pegawais = KartuIndukPegawai::find($id);
$jabatans = Jabatan::where('kartu_induk_pegawai_id', $id)->first();
$riwayat_pendidikans = RiwayatPendidikan::where('kartu_induk_pegawai_id', $id)->get();
$riwayat_pangkats = RiwayatPangkat::where('kartu_induk_pegawai_id', $id)->get();
$riwayat_jabatans = Riwayatjabatan::where('kartu_induk_pegawai_id', $id)->get();
$riwayat_diklats = RiwayatDiklat::where('kartu_induk_pegawai_id', $id)->get();
$riwayat_suami_istris = RiwayatSuamiIstri::where('kartu_induk_pegawai_id', $id)->get();
$riwayat_anaks = RiwayatAnak::where('kartu_induk_pegawai_id', $id)->get();
$riwayat_alamats = RiwayatAlamat::where('kartu_induk_pegawai_id', $id)->get();
return view('kartu-induk-pegawai.cetak', ['kartu_induk_pegawai' => $kartu_induk_pegawais, 'jabatan' => $jabatans, 'riwayat_pendidikan' => $riwayat_pendidikans, 'riwayat_pangkat' => $riwayat_pangkats, 'riwayat_jabatan' => $riwayat_jabatans, 'riwayat_diklat' => $riwayat_diklats, 'riwayat_suami_istri' => $riwayat_suami_istris, 'riwayat_anak' => $riwayat_anaks, 'riwayat_alamat' => $riwayat_alamats]);
}
