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