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 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() { $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 function getDelete($id) { $val = explode(",", $id); foreach ($val as $value) { Laporan::where('id', $value)->delete(); } return redirect()->route('laporan')->with(session()->flash('success', 'Data Berhasil Terhapus !!')); }
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 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 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'); }
/** * 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')); }
public function detailsTerkini($username, $status) { $laporans = null; $title = ''; if ($status == '0') { $status = 'Belum Selesai'; $laporans = Laporan::where('user', $username)->where('tarikh', 'like', Carbon::now()->format('Y-m') . '%')->where('status', 0)->paginate(10); $title = 'Belum Selesai'; // dd($laporans->toArray()); } else { if ($status == 'totalCurrent') { $laporans = Laporan::where('user', $username)->where('tarikh', '>=', Carbon::now()->startOfMonth())->where('tarikh', 'like', Carbon::now()->format('Y-m') . '%')->paginate(10); $title = ''; } else { if ($status == 'totalBefore') { $laporans = Laporan::where('user', $username)->where('tarikh', '<', Carbon::now()->startOfMonth())->where('status', '!=', 4)->paginate(10); $title = 'Bulan Sebelum'; } else { if ($status == 'grandTotal') { $laporans = Laporan::where('user', $username)->where('status', '!=', 4)->where('status', '!=', 0)->paginate(10); $title = 'Keseluruhan'; } else { $laporans = Laporan::where('user', $username)->where('tarikh', 'like', Carbon::now()->format('Y-m') . '%')->where('status', $status)->paginate(10); $status = Laporanstatus::find($status)->nama; $title = $status; } } } } $user = User::where('username', $username)->first(); $user = $user->nama; $month = Carbon::now()->format('m-Y'); $bil = 1; return View('members.supervisor.laporan.detailsTerkini', compact('bil', 'title', 'laporans', 'user', 'status', 'month')); }