public function getIndex() { //$konsumen = konsumen::all(); //data untuk laporan penagihan diambil berdasarkan nilai keuangan resi $tagihan = resi::where('crbyr', 'Non Tunai')->where('status', '>', 1)->get(); return view('admin.report.penagihan')->with('tagihans', $tagihan)->with('cab', 0)->with('kon', 0); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $berangkat = \App\berangkat::find($id); $data = []; $rute = \App\rute::where('sjt', '=', $id)->get(); $i = 0; foreach ($rute as $rt) { $resi = \App\resi::where('idberangkat', $rt->sjt)->where('idrute', $rt->id)->get(); $data[$i]['rute'] = $rt; $data[$i]['resi'] = $resi; $i++; } return view('admin.transaction.keberangkatan-detail')->with('berangkat', $berangkat)->with('data', $data); }
$table .= '<tbody>'; foreach ($resi as $r) { $table .= '<tr><td>' . $r->tglresi . '</td>'; $table .= '<td>' . $r->noresi . '</td>'; $table .= '<td>' . $r->totqty . '</td>'; $table .= '<td>' . $r->idkonsumen . '</td>'; $table .= '<td>' . $r->idpenerima . '</td>'; $table .= '<td>' . $r->totalbiaya . '</td>'; $table .= '<td>' . $r->dp . '</td>'; $table .= '<td>' . $r->sisa . '</td></tr>'; } $table .= '</tbody>'; $table .= '</table>'; return $table; }); Route::get('go', function () { return view('test.test1'); }); Route::get('go2/{id}', function ($id) { $berangkat = \App\berangkat::find($id); $data = []; $rute = \App\rute::where('sjt', '=', $id)->get(); $i = 0; foreach ($rute as $rt) { $resi = \App\resi::where('idberangkat', $rt->sjt)->where('idrute', $rt->id)->get(); $data[$i]['rute'] = $rt; $data[$i]['resi'] = $resi; $i++; } return view('test.test2')->with('data', $data)->with('berangkat', $berangkat); });
public function getNilaiMuatan($idberangkat, $idrute) { return \App\resi::where('idberangkat', $idberangkat)->where('idrute', $idrute)->sum('totalbiaya'); }
public function getJmlResi($sjt) { return \App\resi::where('idberangkat', $sjt)->count('noresi'); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $idkonsumen = \Auth::user()->konsumen->idkonsumen; $resis = resi::where('idkonsumen', '=', $idkonsumen)->get(); return view('world.dashboard.resi')->with('resis', $resis); }