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