public function get_anggota($nama) { $data = \App\Anggota::where('nama', 'like', '%' . $nama . '%')->where('id_koperasi', Auth::user()->assigned_koperasi)->get(); $kirim = array(); foreach ($data as $key) { $saldo = \App\Keuangan::selectRaw('(sum(keluar)-sum(masuk)) as tabungan')->where('id_koperasi', Auth::user()->assigned_koperasi)->where('jenis', 'tabungan')->where('id_anggota', $key->id)->first(); $kirim[] = array('id' => $key['id'], 'value' => $key['nama'], 'label' => $key['no_anggota'] . " - " . $key['nama'], 'saldo' => $saldo->tabungan); } echo json_encode($kirim); }
public function laporansimpananexport($bulan, $tahun) { $data = array(); $data = \App\Transaksi::where('id_koperasi', Auth::user()->assigned_koperasi)->where('created_at', 'like', $tahun . "-%" . $bulan . "-%")->where('jenis_transaksi', 'Simpanan')->get(); $export = array(); foreach ($data as $key) { $export[] = array('Tanggal' => date_format(date_create($key->created_at), "d") . " " . \App\Bulan::where('bulan', date_format(date_create($key->created_at), "m"))->first()['nama'] . " " . date_format(date_create($key->created_at), "Y"), 'Nama' => \App\Anggota::where('id_koperasi', Auth::user()->assigned_koperasi)->find($key->id_anggota)['nama'], 'Jenis' => \App\Simpanan::where('id_koperasi', Auth::user()->assigned_koperasi)->find($key->id_jenis)['nama'], 'Jumlah' => (int) $key->jumlah_total); } Excel::create('Laporan Simpanan', function ($excel) use($export) { $excel->sheet('Laporan Simpanan', function ($sheet) use($export) { $sheet->fromArray($export); }); })->download('xls'); }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $v = Validator::make(Input::all(), ['nama' => 'required|min:1', 'jumlah' => 'required|min:1|numeric', 'tahun' => 'required|numeric']); if ($v->fails()) { return redirect()->back()->withErrors($v->errors()); } $cek = \App\Transaksi::where('id_koperasi', Auth::user()->assigned_koperasi)->where('id_jenis', Input::get('id_jenis'))->where('bulan', Input::get('bulan'))->where('tahun', Input::get('tahun'))->where('id_anggota', Input::get('id_anggota'))->where('jenis_transaksi', 'Simpanan')->get(); if (sizeof($cek) == 0) { $info_ke = \App\Transaksi::where('id_koperasi', Auth::user()->assigned_koperasi)->where('id_jenis', Input::get('id_jenis'))->where('id_anggota', Input::get('id_anggota'))->where('jenis_transaksi', 'Simpanan')->get(); $info_ke = sizeof($info_ke); $data = \App\Transaksi::orderBy('id', 'desc')->first()['id']; $new = new \App\Transaksi(); $new->no_transaksi = 'KSP-' . date("ymd") . ($data + 1) . "-S"; $new->id_anggota = Input::get('id_anggota'); $new->keterangan = Input::get('keterangan'); $new->jenis_transaksi = 'Simpanan'; $new->status = 'Lunas'; $new->id_jenis = Input::get('id_jenis'); $new->jumlah_asli = Input::get('jumlah'); $new->jumlah_bunga = 0; $new->bunga = 0; $new->info_ke = $info_ke + 1; $new->bulan = Input::get('bulan'); $new->tahun = Input::get('tahun'); $new->jumlah_total = Input::get('jumlah'); $new->id_koperasi = Auth::user()->assigned_koperasi; $new->created_by = Auth::user()->id; $new->save(); $data = \App\Keuangan::orderBy('id', 'desc')->first()['id']; $finan = new \App\Keuangan(); $finan->no_nota = 'KSP-' . date("ymd") . ($data + 1) . "-B"; $finan->id_koperasi = Auth::user()->assigned_koperasi; $finan->id_anggota = Input::get('id_anggota'); $finan->tabel = 'transaksis'; $finan->jenis = 'tabungan'; $finan->info = "Pembayaran " . \App\Simpanan::where('id_koperasi', Auth::user()->assigned_koperasi)->find(Input::get('id_jenis'))['nama'] . " " . \App\Anggota::where('id_koperasi', Auth::user()->assigned_koperasi)->find(Input::get('id_anggota'))['nama'] . " Rp. " . number_format(Input::get('jumlah'), 2, ",", ".") . " (" . date("d/m/Y H:i:s") . ") " . Auth::user()->name; $finan->id_transaksi = $new->id; $finan->masuk = Input::get('jumlah'); $finan->keluar = 0; $finan->save(); return redirect(url('transaksi/simpanan')); } else { return redirect(url('transaksi/simpanan/baru'))->withPesan('sudah_ada'); } }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['password' => 'required|min:6|same:confirm_password']); $data = $request->all(); $fill1['name'] = $data['nip']; $fill1['nama'] = $data['nama']; $fill1['password'] = bcrypt($data['password']); $fill2['nip'] = $data['nip']; $fill2['nama'] = $data['nama']; $fill2['email'] = $data['email']; $fill2['jabatan'] = $data['jabatan']; // dd($fill1,$fill2); $test = Anggota::where('nip', $fill1['name'])->firstOrFail(); if (!$test) { User::create($fill1); Anggota::create($fill2); return redirect()->action('AnggotaController@index'); } else { return redirect()->back()->withErrors(['NIP sudah digunakan']); } }
/** * Get all of the tasks for a given user. * * @param User $user * * @return Collection */ public function forUser(User $user) { return Anggota::where('user_id', $user->id)->get(); }
/** * Get all of the tasks for a given user. * * @param User $user * * @return Collection */ public function Anggota(User $user) { return Anggota::where('user_id', $user->id)->count(); }
| */ Route::get('/', function () { return view('welcome'); }); Route::get('relasi-1', function () { $anggota = Anggota::where('nama', '=', 'Arvin Chendriyana Supriyadi')->first(); return $anggota->detailanggota->alamat; }); Route::get('relasi-2', function () { $anggota = Anggota::where('nama', '=', 'Arvin Chendriyana Supriyadi')->first(); return $anggota->rental->nama; }); Route::get('relasi-3', function () { $rental = Rental::where('nama', '=', 'Hanzo')->first(); foreach ($rental->anggota as $temp) { echo '<li> Nama : ' . $temp->nama . '</li>'; } }); Route::get('relasi-4', function () { $arvin = Anggota::where('nama', '=', 'Arvin Chendriyana Supriyadi')->first(); foreach ($arvin->game as $temp) { echo '<li>' . $temp->judul . '</li>'; } }); Route::get('relasi-5', function () { $fallout_4 = Game::where('judul', '=', 'Fallout 4')->first(); foreach ($fallout_4->anggota as $temp) { echo '<li> Nama : ' . $temp->nama . '</li>'; } });
*/ Route::get('/', function () { return view('welcome'); }); Route::get('relasi-1', function () { $anggota = Anggota::where('email', '=', '*****@*****.**')->first(); return $anggota->status->pekerjaan; }); Route::get('relasi-2', function () { $anggota = Anggota::where('email', '=', '*****@*****.**')->first(); return $anggota->tokoBuku->nama; }); Route::get('relasi-3', function () { $tokoBuku = TokoBuku::where('nama', '=', 'Taman Bacaan')->first(); foreach ($tokoBuku->anggota as $temp) { echo '<li> Nama : ' . $temp->nama . ' ' . $temp->email . ' </li>'; } }); Route::get('relasi-4', function () { $aulia = Anggota::where('nama', '=', 'Aulia Marchita')->first(); foreach ($aulia->buku as $temp) { echo '<li>' . $temp->judul . '</li>'; } }); Route::get('relasi-5', function () { $circa = Buku::where('judul', '=', 'Circa')->first(); foreach ($circa->anggota as $temp) { echo '<li> Nama : ' . $temp->nama . ' <strong>' . $temp->email . '</strong></li>'; } });
public function livebuktimanual($id_induk, $id_transaksi, $id_anggota, $arrIDKeu) { $data['keuangan'] = \App\Keuangan::where('id_koperasi', Auth::user()->assigned_koperasi)->whereIn('id', explode(",", $arrIDKeu))->get(); $data['koperasi'] = \App\Koperasi::find(Auth::user()->assigned_koperasi); $jumlah = 0; foreach ($data['keuangan'] as $key) { $jumlah += $key->masuk; } $data['total'] = $jumlah; $data['transaksi'] = \App\Transaksi::where('id_koperasi', Auth::user()->assigned_koperasi)->where('id', $id_transaksi)->first(); $data['anggota'] = \App\Anggota::where('id_koperasi', Auth::user()->assigned_koperasi)->find($data['transaksi']->id_anggota); $data['induk'] = \App\Transaksi::where('id_koperasi', Auth::user()->assigned_koperasi)->where('id', $id_induk)->first(); // $pdf = \App::make('dompdf.wrapper'); //$pdf->loadView('transaksi.printpembayaran',$data); $pdf = PDF::loadView('transaksi.printpembayaran', $data); $pdf->setPaper(array(0, 0, 612, 379)); return $pdf->stream('download.pdf'); //return view('transaksi.printpembayaran')->with($data); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { \App\Anggota::where('id_koperasi', Auth::user()->assigned_koperasi)->find($id)->delete(); return redirect(url('anggota')); }