public function getTagihanCabang() { $arr = []; $cab = Request::get('cabang'); $tagihanPengirim = piutang::select('piutang.*')->join('resi', function ($join) { $join->on('resi.noresi', '=', 'piutang.noresi'); $join->on('resi.idkonsumen', '=', 'piutang.idkons'); })->join('rute', function ($join) { $join->on('rute.sjt', '=', 'resi.idberangkat'); $join->on('rute.id', '=', 'resi.idrute'); })->where('resi.tagihan', 'Pengirim')->where('rute.kotamuat', $cab)->get(); $tagihanPenerima = piutang::select('piutang.*')->join('resi', function ($join) { $join->on('resi.noresi', '=', 'piutang.noresi'); $join->on('resi.idpenerima', '=', 'piutang.idkons'); })->join('rute', function ($join) { $join->on('rute.sjt', '=', 'resi.idberangkat'); $join->on('rute.id', '=', 'resi.idrute'); })->where('resi.tagihan', 'Penerima')->where('rute.kotabongkar', $cab)->get(); $tagihan = $tagihanPenerima->merge($tagihanPengirim); return view('admin.report.penagihan')->with('kon', 0)->with('tagihan', $tagihan)->with('cab', $cab); /* $tagihan = resi::select('resi.*','piutang.status') ->rightJoin('rute AS rt',function($join){ $join->on('rt.sjt','=','resi.idberangkat'); $join->on('rt.id','=','resi.idrute'); }) ->leftJoin('piutang','piutang.noresi','=','resi.noresi') //->rightJoin('berangkat AS b','b.idberangkat','=','resi.idberangkat') ->where('resi.sisa','>',0) ->where('rt.status','>',1)->get(); return view('admin.report.penagihan')->with('kon',0)->with('tagihan',$tagihan)->with('cab',$cab); //dd($tagihan); if($cab){ $cabang = \App\cabang::where('idcabang','=',$cab)->first(); if($cabang) { $title = 'Tagihan '.$cabang->nama; $tagihan->where('rt.kotamuat',$cab)->where('resi.tagihan','Pengirim'); $tagihan->orWhere('rt.kotabongkar',$cab)->where('resi.tagihan','Penerima'); foreach ($tagihan->get() as $d) { if($d->tagihan=='Penerima'){ $arr[$d->idpenerima]['konsumen']=$d->penerima->nama; $arr[$d->idpenerima]['jmlresi']=isset($arr[$d->idpenerima]['jmlresi'])?$arr[$d->idpenerima]['jmlresi']+1:1; $arr[$d->idpenerima]['totalbiaya']=isset($arr[$d->idpenerima]['totalbiaya']) ? $arr[$d->idpenerima]['totalbiaya']+$d->totalbiaya : $d->totalbiaya; $arr[$d->idpenerima]['dp']=isset($arr[$d->idpenerima]['dp']) ? $arr[$d->idpenerima]['dp']+$d->dp : $d->dp; $arr[$d->idpenerima]['sisa']=isset($arr[$d->idpenerima]['sisa']) ? $arr[$d->idpenerima]['sisa']+$d->sisa : $d->sisa; $arr[$d->idpenerima]['resi']=isset($arr[$d->idpenerima]['resi']) ? array_merge($arr[$d->idpenerima]['resi'],[$d]) : [$d]; } if($d->tagihan=='Pengirim'){ $arr[$d->idkonsumen]['konsumen']=$d->pengirim->nama; $arr[$d->idkonsumen]['jmlresi']=isset($arr[$d->idkonsumen]['jmlresi'])?$arr[$d->idkonsumen]['jmlresi']+1:1; $arr[$d->idkonsumen]['totalbiaya']=isset($arr[$d->idkonsumen]['totalbiaya']) ? $arr[$d->idkonsumen]['totalbiaya']+$d->totalbiaya : $d->totalbiaya; $arr[$d->idkonsumen]['dp']=isset($arr[$d->idkonsumen]['dp']) ? $arr[$d->idkonsumen]['dp']+$d->dp : $d->dp; $arr[$d->idkonsumen]['sisa']=isset($arr[$d->idkonsumen]['sisa']) ? $arr[$d->idkonsumen]['sisa']+$d->sisa : $d->sisa; $arr[$d->idkonsumen]['resi']=isset($arr[$d->idkonsumen]['resi']) ? array_merge($arr[$d->idkonsumen]['resi'],[$d]) : [$d]; } } $list = Collection::make($arr); return view('admin.report.penagihan')->with('cab',$cab)->with('tagihans',$tagihan)->with('list',$list)->with('title',$title); } } */ if ($kon) { $tagihan->where('idkonsumen', '=', $kon)->orWhere('idpenerima', '=', $kon); $konsumen = \App\konsumen::find($kon); return view('admin.report.penagihan-detail')->with('resi', $tagihan->get())->with('k', $konsumen); } return $this->getIndex(); }
public function getByKonsumen($id) { $piutang = piutang::where('idkon', $id)->get(); return view('admin.transaction.piutang')->with('piutang', $piutang); }