public function carian() { $bil = 1; $tarikh = Carbon::parse(\Input::get('tarikh')); $laporans = Laporan::where('tarikh', $tarikh)->latest('tarikh')->get(); return View('members.admin.laporan.carian', compact('bil', 'laporans', 'tarikh')); }
public function terkini() { $bil = 1; $laporans = Laporan::where('tarikh', 'like', Carbon::now()->format('Y-m') . '%')->where('user', Auth::user()->username)->get(); // dd($laporans); return View('members.technician.laporan.terkini', compact('bil', 'laporans')); }
public function run() { DB::table('ppl_koperasi_laporans')->delete(); Laporan::create(array('id' => NULL, 'id_koperasi' => 1, 'id_pengirim' => '100000000000000', 'tahun' => 2015, 'file' => 'koperasisatu.zip', 'permodalan' => 1, 'kualitas_aktiva_produktif' => 1, 'manajemen' => 1, 'efisiensi' => 1, 'likuiditas' => 1, 'kemandirian_dan_pertumbuhan' => 1, 'jatidiri_koperasi' => 1, 'terverifikasi' => 1)); Laporan::create(array('id' => NULL, 'id_koperasi' => 2, 'id_pengirim' => '100000000000000', 'tahun' => 2015, 'file' => 'koperasidua.zip')); Laporan::create(array('id' => NULL, 'id_koperasi' => 3, 'id_pengirim' => '100000000000000', 'tahun' => 2015, 'file' => 'koperasitiga.zip')); }
public function terkini() { $users = User::where('unit', Auth::user()->unit)->where('level_id', 3)->where('status', 1)->get(); if (Auth::user()->level->id == 1) { $users = User::where('status', 1)->where('level_id', '>', 1)->get(); } $data[] = null; $bil = 1; foreach ($users as $user) { //Belum Selesai $belumSelesai = Laporan::where('user', $user->username)->where('tarikh', '>=', Carbon::now()->startOfMonth())->where('status', 0)->count(); $user['belumSelesai'] = $belumSelesai; // dd(Carbon::now()->startOfMonth()->format('Y-m-d')); // dd($belumSelesai); //KIV $kiv = Laporan::where('user', $user->username)->where('tarikh', '>=', Carbon::now()->startOfMonth())->where('status', 3)->count(); $user['kiv'] = $kiv; //Selesai $selesai = Laporan::where('user', $user->username)->where('tarikh', '>=', Carbon::now()->startOfMonth())->where('status', 4)->count(); $user['selesai'] = $selesai; //Closing $closing = Laporan::where('user', $user->username)->where('tarikh', '>=', Carbon::now()->startOfMonth())->where('status', 1)->count(); $user['closing'] = $closing; //Jumlah tugasan current month $totalCurrentMonth = Laporan::where('user', $user->username)->where('tarikh', '>=', Carbon::now()->startOfMonth())->count(); $user['totalCurrentMonth'] = $totalCurrentMonth; //Jumlah tugasan bulan sebelum dan belum selesai $totalPreviousMonth = Laporan::where('user', $user->username)->where('tarikh', '<', Carbon::now()->startOfMonth())->where('status', '!=', 4)->count(); $user['totalPreviousMonth'] = $totalPreviousMonth; //Jumlah Bulan Semasa, KIV dan Belum Selesai $grandTotal = Laporan::where('user', $user->username)->where('status', '!=', 4)->count(); $user['grandTotal'] = $grandTotal; } return View('members.supervisor.laporan.cetak.terkini', compact('bil', 'users')); }
public static function deleteKoperasi($id) { $laporans = Laporan::where('id_koperasi', $id)->get(); foreach ($laporans as $laporan) { $laporan->delete(); } $koperasi = Koperasi::find($id); $koperasi->delete(); }
public function getUpdate(Request $request) { $data = Laporan::find($request->id); $data->jabatan = $request->jabatan; $data->nama = $request->nama; $data->nip = $request->nip; $data->save(); $data['laporan'] = Laporan::paginate(1); return redirect()->route('laporan', $data)->with(session()->flash('success', 'Data Berhasil diupdate !!')); }
public static function editLaporan($permodalan, $kualitas_aktiva_produktif, $manajemen, $efisiensi, $likuiditas, $kemandirian_dan_pertumbuhan, $jatidiri_koperasi, $id) { $laporan = Laporan::find($id); $laporan->permodalan = $permodalan; $laporan->kualitas_aktiva_produktif = $kualitas_aktiva_produktif; $laporan->manajemen = $manajemen; $laporan->efisiensi = $efisiensi; $laporan->likuiditas = $likuiditas; $laporan->kemandirian_dan_pertumbuhan = $kemandirian_dan_pertumbuhan; $laporan->jatidiri_koperasi = $jatidiri_koperasi; $laporan->terverifikasi = 1; $laporan->save(); }
public function hasilCarian() { $bil = 1; if (Session::has('tarikh')) { $tarikh = Session::get('tarikh'); } else { Session::put('tarikh', \Carbon\Carbon::parse(Input::get('tarikh'))->format('Y-m')); $tarikh = Session::get('tarikh'); } // dd($tarikh); $laporans = Laporan::where('cawangan_id', Input::get('cawangan_id'))->where('tarikh', 'like', $tarikh . '%')->where('status', Input::get('status'))->paginate(10); return View('members.admin.hasilCarian', compact('bil', 'laporans')); }
public function insertNilai(EditLaporanRequest $request, $id) { $r = $request->all(); Laporan::editLaporan($r['permodalan'], $r['kualitas_aktiva_produktif'], $r['manajemen'], $r['efisiensi'], $r['likuiditas'], $r['kemandirian_dan_pertumbuhan'], $r['jatidiri_koperasi'], $id); $searchlap = Laporan::find($id); $searchlap->terverifikasi = 1; $searchlap->save(); $search = Koperasi::find($searchlap->id_koperasi); $search->penilaian = $r['permodalan'] + $r['kualitas_aktiva_produktif'] + $r['manajemen'] + $r['efisiensi'] + $r['likuiditas'] + $r['kemandirian_dan_pertumbuhan'] + $r['jatidiri_koperasi']; $search->save(); // $laporan = Laporan::find($id); // $laporan->permodalan = $r['permodalan']; // $laporan->kualitas_aktiva_produktif = $kualitas_aktiva_produktif; // $laporan->manajemen = $manajemen; // $laporan->efisiensi = $efisiensi; // $laporan->likuiditas = $likuiditas; // $laporan->kemandirian_dan_pertumbuhan = $kemandirian_dan_pertumbuhan; // $laporan->jatidiri_koperasi = $jatidiri_koperasi; // $laporan->save(); return redirect()->back()->with('message', 'Nilai laporan berhasil ditambahkan'); }
public function getExportPdf(Request $r) { $data['rumputlaut'] = RumputLaut::whereBetween('created_at', [$r->offset, $r->limit])->get(); $data['kasi'] = Laporan::where('jabatan', 'Kasi Budidaya Laut. Payau dan Air Tawar')->get(); $data['petugas'] = Laporan::where('jabatan', 'Petugas Statistik')->get(); $data['tgl_awal'] = $r->offset; $data['tgl_akhir'] = $r->limit; $pdf = PDF::loadView('app.laporan-produksi.rumputlaut.export-pdf', $data); return $pdf->setPaper('legal')->setOrientation('landscape')->setWarnings(false)->download('Data rumputlaut.pdf'); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function getIndex() { $data['penugasan'] = Penugasan::paginate(10); $data['laporan'] = Laporan::all(); return view('app.master.penugasan', $data); }
/** * Run the database seeds. * * @return void */ public function run() { Laporan::where('pelapor', '')->delete(); Laporan::where('pemilik', '')->delete(); Laporan::where('peralatan_id', 0)->delete(); }
public function ringkasanPeratusan() { $tahun = Request::get('year'); $counts1 = []; $counts2 = []; for ($i = 1; $i <= 12; $i++) { if ($i < 10) { $bulan = '0' . $i; } else { $bulan = $i; } $tarikh = $tahun . '-' . $bulan; // In house $users = User::where('jawatan', 'not like', '%vendor%')->where('status', 1)->get(); $countLess = 0; $countGreater = 0; $total = 0; foreach ($users as $user) { $laporans = Laporan::where('tarikh', 'like', $tarikh . '%')->where('user', $user->username)->get(); foreach ($laporans as $laporan) { if ($laporan->tarikh->diff($laporan->tarikhSiap)->days < 10) { $countLess++; } else { $countGreater++; } } $total = $countLess + $countGreater; } if ($total != 0 || $countLess != 0) { $peratus = number_format($countLess / $total * 100, 2); } else { $peratus = '0.00'; } array_push($counts1, ['bulan' => $i, 'countLess' => $countLess, 'countGreater' => $countGreater, 'total' => $total, 'peratus' => $peratus]); // Vendor $users = User::where('jawatan', 'like', '%vendor%')->where('status', 1)->get(); $countLess = 0; $countGreater = 0; $total = 0; foreach ($users as $user) { $laporans = Laporan::where('tarikh', 'like', $tarikh . '%')->where('user', $user->username)->get(); foreach ($laporans as $laporan) { if ($laporan->tarikh->diff($laporan->tarikhSiap)->days <= 21) { $countLess++; } else { $countGreater++; } } $total = $countLess + $countGreater; } if ($total != 0 || $countLess != 0) { $peratus = number_format($countLess / $total * 100, 2); } else { $peratus = '0.00'; } array_push($counts2, ['bulan' => $i, 'countLess' => $countLess, 'countGreater' => $countGreater, 'total' => $total, 'peratus' => $peratus]); } return View('members.supervisor.laporan.ringkasanPeratusan', compact('bil', 'counts1', 'counts2')); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $laporan = Laporan::findOrFail($id); if ($laporan->delete()) { \Session::flash('success', 'Laporan berjaya dihapus'); } else { \Session::flash('error', 'Laporan gagal dihapus'); } return Redirect::route('members.user.laporan.index'); }
public function update2($id) { $laporan = Laporan::findOrFail($id); $laporan->fill(Request::all()); if (Request::get('status') == 4) { $laporan->tarikhSiap = Carbon::now(); } if ($laporan->save()) { \Session::flash('success', 'Laporan telah dikemaskini'); } else { \Session::flash('error', 'Laporan gagal dikemaskini'); } return Redirect::route('members.supervisor.laporan.terkini'); }