public function dpenagihan($id)
{
$total = 0;
$header = \App\resi::select('resi.*', 'resi.status', 'resi.noresi', 'resi.tglresi', 'resi.tagihan', 'resi.totalbiaya', 'resi.dp', 'resi.sisa', 'k.nama AS ppengirim', 'k.cp AS cppengirim', 'k.notelp AS telppengirim', 'k.alamat AS alamatpengirim', 'ktk.nmkota AS kotapengirim', 't.nama AS ppenerima', 't.cp AS cppenerima', 't.notelp AS telppenerima', 't.alamat AS alamatpenerima', 'ktp.nmkota AS kotapenerima', 'u.name AS pegawai')->leftJoin('konsumen AS k', 'k.idkonsumen', '=', 'resi.idkonsumen')->leftJoin('konsumen AS t', 't.idkonsumen', '=', 'resi.idpenerima')->leftJoin('kota AS ktk', 'ktk.idkota', '=', 'k.kota')->leftJoin('kota AS ktp', 'ktp.idkota', '=', 't.kota')->leftJoin('users AS u', 'u.id', '=', 'resi.user')->where('noresi', '=', $id)->first();
$dresi = \App\dresi::where('dresi.idresi', '=', $id)->leftJoin('satuan AS s', 's.idsatuan', '=', 'dresi.satuan')->select('dresi.*', 's.namasatuan')->get();
return view('laporan.dpenagihan')->with('header', $header)->with('dresis', $dresi);
}
public function getJmlKoli($idberangkat, $idrute)
{
return \App\dresi::rightJoin('resi', 'resi.noresi', '=', 'dresi.idresi')->where('idberangkat', $idberangkat)->where('idrute', $idrute)->count('*');
}
