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