/**
  * 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');
     }
 }
 public function simpanpengeluarantabungan()
 {
     $v = Validator::make(Input::all(), ['jumlah' => 'required|numeric', 'id_anggota' => 'required']);
     if ($v->fails()) {
         return redirect()->back()->withErrors($v->errors());
     }
     $data = \App\Keuangan::orderBy('id', 'desc')->first()['id'];
     $new = new \App\Keuangan();
     $new->no_nota = 'KSP-' . date("ymd") . ($data + 1) . "-KLT";
     $new->id_koperasi = Auth::user()->assigned_koperasi;
     $new->id_anggota = Input::get('id_anggota');
     $new->info = "Koreksi Tabungan " . Input::get('keterangan') . " Rp. " . number_format(Input::get('jumlah'), 2, ",", ".") . " (" . date("d/m/Y H:i:s") . ") " . Auth::user()->name;
     $new->jenis = 'tabungan';
     $new->keluar = Input::get('jumlah');
     $new->save();
     return redirect('keuangan/pengeluaran/tabungan')->withData($new->no_nota);
 }
 public function simpanpembayaran()
 {
     $v = Validator::make(Input::all(), ['nama' => 'required|min:1']);
     if ($v->fails()) {
         return redirect()->back()->withErrors($v->errors());
     }
     $data = \App\Transaksi::where('id', Input::get('id_angsuran'))->first();
     $data->no_transaksi = 'KSP-' . date("ymd") . ($data->id_induk . $data->info_ke) . "-PA";
     $data->status = 'Lunas';
     $data->denda = Input::get('jumlah_denda');
     $data->total_denda = Input::get('total_denda');
     $data->keterangan = Input::get('keterangan');
     $data->save();
     if (Input::get('jumlah_angsuran') > 0) {
         $old_num = \App\Keuangan::orderBy('id', 'desc')->first()['id'];
         $finan = new \App\Keuangan();
         $finan->no_nota = 'KSP-' . date("ymd") . ($old_num + 1) . "-PS";
         $finan->id_koperasi = Auth::user()->assigned_koperasi;
         $finan->id_anggota = Input::get('id_anggota');
         $finan->tabel = 'transaksis';
         $finan->jenis = 'angsuran';
         $finan->info = "Pembayaran Pinjaman ke-" . $data->info_ke . " " . \App\Anggota::where('id_koperasi', Auth::user()->assigned_koperasi)->find(Input::get('id_anggota'))['nama'] . " Rp. " . number_format(Input::get('jumlah_angsuran'), 2, ",", ".") . " (" . date("d/m/Y H:i:s") . ") " . Auth::user()->name;
         $finan->id_transaksi = $data->id;
         $finan->masuk = Input::get('jumlah_angsuran');
         $finan->keluar = 0;
         $finan->save();
     }
     if (Input::get('jumlah_tabungan') > 0) {
         $old_num = \App\Keuangan::orderBy('id', 'desc')->first()['id'];
         $finan = new \App\Keuangan();
         $finan->no_nota = 'KSP-' . date("ymd") . ($old_num + 1) . "-PST";
         $finan->id_koperasi = Auth::user()->assigned_koperasi;
         $finan->id_anggota = Input::get('id_anggota');
         $finan->tabel = 'transaksis';
         $finan->jenis = 'tabungan';
         $finan->info = "Pembayaran Tabungan Pinjaman ke-" . $data->info_ke . " " . \App\Anggota::where('id_koperasi', Auth::user()->assigned_koperasi)->find(Input::get('id_anggota'))['nama'] . " Rp. " . number_format(Input::get('jumlah_tabungan'), 2, ",", ".") . " (" . date("d/m/Y H:i:s") . ") " . Auth::user()->name;
         $finan->id_transaksi = $data->id;
         $finan->masuk = Input::get('jumlah_tabungan');
         $finan->keluar = 0;
         $finan->save();
     }
     if (Input::get('total_denda') > 0) {
         $old_num = \App\Keuangan::orderBy('id', 'desc')->first()['id'];
         $finan = new \App\Keuangan();
         $finan->no_nota = 'KSP-' . date("ymd") . ($old_num + 1) . "-PSD";
         $finan->id_koperasi = Auth::user()->assigned_koperasi;
         $finan->id_anggota = Input::get('id_anggota');
         $finan->tabel = 'transaksis';
         $finan->jenis = 'denda';
         $finan->info = "Pembayaran Denda Pinjaman ke-" . $data->info_ke . " " . \App\Anggota::where('id_koperasi', Auth::user()->assigned_koperasi)->find(Input::get('id_anggota'))['nama'] . " Rp. " . number_format(Input::get('total_denda'), 2, ",", ".") . " (" . date("d/m/Y H:i:s") . ") " . Auth::user()->name;
         $finan->id_transaksi = $data->id;
         $finan->masuk = Input::get('total_denda');
         $finan->keluar = 0;
         $finan->save();
     }
     $cou = \App\Transaksi::where('status', 'Lunas')->where('id_induk', $data->id_induk)->get();
     $induk = \App\Transaksi::where('id', $data->id_induk)->first();
     if ($induk->info_ke == sizeof($cou)) {
         $induk->status = 'Lunas';
         $induk->save();
     }
     return redirect(url('transaksi/pembayaran/selesai/' . $data->no_transaksi));
 }