public function saldo() { $data = array(); $data['saldo'] = \App\Keuangan::selectRaw('(sum(masuk)-sum(keluar)) as jumlah')->where('id_koperasi', Auth::user()->assigned_koperasi)->first(); $data['saldo_bulan_lalu'] = \App\Keuangan::selectRaw('(sum(masuk)-sum(keluar)) as jumlah')->where('created_at', 'like', date("Y-m-", strtotime("-1 month")) . "%")->where('id_koperasi', Auth::user()->assigned_koperasi)->first(); $data['saldo_tahun_lalu'] = \App\Keuangan::selectRaw('(sum(masuk)-sum(keluar)) as jumlah')->where('created_at', 'like', date("Y-", strtotime("-1 year")) . "%")->where('id_koperasi', Auth::user()->assigned_koperasi)->first(); return view('laporan.saldo')->with($data); }
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 rekapexport() { //$data = \App\Keuangan::selectRaw('created_at as "Waktu",no_nota as "No. Nota", jenis as "Jenis",info as "Keterangan",masuk as "Pemasukan",keluar as "Pengeluaran"')->get(); $tgl[0] = session('tgl0'); $tgl[1] = session('tgl1'); $id_anggota = session('id_anggota'); $lama = \App\Keuangan::selectRaw('created_at as "Waktu", no_nota as "No. Nota", id_anggota, jenis as "Jenis", info as "Keterangan", masuk as "Pemasukan", keluar as "Pengeluaran"')->whereRaw('DATE_FORMAT(created_at,"%Y-%m-%d") between "' . $tgl[0] . '" and "' . $tgl[1] . '"')->where('id_koperasi', Auth::user()->assigned_koperasi)->where('id_anggota', 'like', '%' . $id_anggota . '%')->get(); $data = array(); foreach ($lama as $key) { $data[] = array('Waktu' => $key['Waktu'], 'No. Nota' => $key['No. Nota'], 'Jenis' => $key['Jenis'], 'Anggota' => \App\Anggota::find($key['id_anggota'])['nama'], 'Keterangan' => $key['Keterangan'], 'Pemasukan' => (int) $key['Pemasukan'], 'Pengeluaran' => (int) $key['Pengeluaran']); } Excel::create('Laporan Keuangan', function ($excel) use($data) { $excel->sheet('Laporan Keuangan', function ($sheet) use($data) { $sheet->fromArray($data); }); })->download('xls'); }