Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace App\Http\Controllers;
- use Illuminate\Http\Request;
- use DB;
- use App\Cater;
- use App\Master;
- class RekapLaporanController extends Controller
- {
- public function tunggakan_500rb()
- {
- $tusbung = Cater::select('tusbung')->groupBy('tusbung')->get();
- foreach ($tusbung as $key => $value) {
- $belumlunas = Master::select(DB::raw('count(*) as jumlah'))
- ->join('cater', 'master.cater_id', '=', 'cater.id')
- ->where('master.lembar', '=', 2)
- ->where('master.rptag', '>=', 500000)
- ->where('cater.tusbung', '=', $value->tusbung)
- ->where('master.posisi_tunggakan', '=', 'AKTIF')
- ->groupBy('tusbung')->get();
- $sudahlunas = Master::select(DB::raw('count(*) as jumlah'))
- ->join('cater', 'master.cater_id', '=', 'cater.id')
- ->where('master.lembar', '=', 2)
- ->where('master.rptag', '>=', 500000)
- ->where('cater.tusbung', '=', $value->tusbung)
- ->where('master.posisi_tunggakan', '=', 'PASIF')
- ->groupBy('tusbung')->get();
- $sisatunggakan = ($belumlunas->jumlah - $sudahlunas->jumlah);
- if ($belumlunas == 0){
- $persen="Sudah Tidak ada lagi tunggakan";
- }
- else
- {
- $persen=($sudahlunas / $belumlunas)*100;
- }
- $tusbung = $value->tusbung;
- $dataArray = array(); //data $tusbung, $belumlunas, $sudahlunas, $sisatunggakan, $persen akan dimasukkan ke dalam array berdasar tusubng.
- }
- return view('rekapdata.tunggakan500rb', compact('dataArray'));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement