model = new Saldokuotabbm(); $this->info = $this->model->makeInfo( $this->module); $this->access = array(); $this->data = array_merge(array( 'pageTitle' => $this->info['title'], 'pageNote' => $this->info['note'], 'pageModule'=> 'saldokuotabbm', 'return' => self::returnUrl() ),$this->data); } public function index( Request $request ) { // Make Sure users Logged if(!\Auth::check()) return redirect('user/login')->with('status', 'error')->with('message','You are not login'); // $this->grab( $request) ; // if($this->access['is_view'] ==0) // return redirect('dashboard')->with('message', __('core.note_restric'))->with('status','error'); // Render into template return view( $this->module.'.index',$this->data); } public function mapbbm(Request $request) { return view('dashboard.mapbbm'); } function dashboard( Request $request ) { // config(['app.debug' => true]); if(!\Auth::check()) return redirect('user/login')->with('status', 'error')->with('message','You are not login'); $result = \DB::select(" select b.stasiun, b.kapasitas, (sum(a.saldo) + (select ifnull(sum(jumlah), 0) from t_transfer_bbm where stasiun = a.stasiun)) - (select ifnull(sum(jumlah), 0) from t_pengeluaran_bbm where unit = '".session('fid')."' and statiun_id = a.stasiun) as saldo_akhir, (select sum(jumlah) from t_pengeluaran_bbm where unit = '".session('fid')."' and tgl_keluar = date(now()) and statiun_id = a.stasiun) as total_pengeluaran_hi, (select sum(jumlah) from t_pengeluaran_bbm where unit = '".session('fid')."' and statiun_id = a.stasiun) as total_pengeluaran_sd, (select ifnull(sum(jumlah), 0) from t_transfer_bbm where stasiun = a.stasiun) as transfer from t_saldo_bbm a inner join m_stasiun_bbm b on b.id = a.stasiun where a.jenis_bbm = 1 and a.unit = '".session('fid')."' group by a.stasiun "); $this->data['data'] = $result; return view( $this->module.'.dashboard',$this->data); } public function getPermintaanBBMTable(Request $request) { $unit = $request->input('unit', \session('fid')); $startDate = $request->input('start_date'); $endDate = $request->input('end_date'); $query = \DB::table('t_permintaan_bbm as a') ->select( 'a.kode_permintaan', 'a.tanggal', 'a.nomer_kartu', 'd.stasiun', 'b.no_kendaraan', 'b.deskripsi_kendaraan', 'c.jenis_bbm', 'a.jumlah_bbm as jml_permintaan', \DB::raw('sum(e.jumlah) as jml_pengeluaran'), 'a.satuan', 'a.keperluan' ) ->join('m_kendaraan as b', 'b.id', '=', 'a.kendaraan_id') ->join('m_jenis_bbm as c', 'c.id', '=', 'a.jenis_bbm') ->join('m_stasiun_bbm as d', 'd.id', '=', 'a.statiun_id') ->Join('t_pengeluaran_bbm as e', 'e.kode_permintaan', '=', 'a.kode_permintaan') ->where('a.unit', $unit); if ($startDate && $endDate) { $query->whereBetween('a.tanggal', [$startDate, $endDate]); } $results = $query->groupBy( 'a.kode_permintaan', 'a.tanggal', 'a.nomer_kartu', 'd.stasiun', 'b.no_kendaraan', 'b.deskripsi_kendaraan', 'c.jenis_bbm', 'a.jumlah_bbm', 'a.satuan', 'a.keperluan' )->get(); $html = ''; $html .= ''; $html .= ''; foreach ($results as $row) { $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; } $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= '

Kode Permintaan	Tanggal	Nomer Kartu	Stasiun	No Kendaraan	Deskripsi Kendaraan	Jenis BBM	Jumlah Permintaan	Jumlah Pengeluaran	Satuan	Keperluan
' . htmlspecialchars($row->kode_permintaan) . '	' . htmlspecialchars($row->tanggal) . '	' . htmlspecialchars($row->nomer_kartu) . '	' . htmlspecialchars($row->stasiun) . '	' . htmlspecialchars($row->no_kendaraan) . '	' . htmlspecialchars($row->deskripsi_kendaraan) . '	' . htmlspecialchars($row->jenis_bbm) . '	' . htmlspecialchars($row->jml_permintaan) . '	' . htmlspecialchars($row->jml_pengeluaran) . '	' . htmlspecialchars($row->satuan) . '	' . htmlspecialchars($row->keperluan) . '
Total							' . htmlspecialchars($results->sum('jml_permintaan')) . '	' . htmlspecialchars($results->sum('jml_pengeluaran')) . '

'; return response($html); } function showtables(Request $request) { $tunit = session('fid'); $ttgl = $request->input('filter_date'); $results = \DB::select('CALL GetSisaKuotaBBM(?, ?)', [$tunit, $ttgl]); $html = ''; $html .= ''; $html .= ''; foreach ($results as $row) { $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; } $html .= '

Nomer Kartu	No Kendaraan	Deskripsi Kendaraan	Jenis BBM	Satuan	Total Kuota	Total Permintaan	Sisa Kuota	Pemakaian HI
' . htmlspecialchars($row->nomer_kartu) . '	' . htmlspecialchars($row->no_kendaraan) . '	' . htmlspecialchars($row->deskripsi_kendaraan) . '	' . htmlspecialchars($row->jenis_bbm) . '	' . htmlspecialchars($row->satuan) . '	' . htmlspecialchars($row->total_kuota) . '	' . htmlspecialchars($row->jml_permintaan) . '	' . htmlspecialchars($row->sisa_kuota) . '	' . htmlspecialchars($row->pemakaian_hi) . '

'; return response($html); } function show( Request $request , $id ) { /* Handle import , export and view */ $task =$id ; switch( $task) { case 'export': return $this->getExport( $request ); break; case 'showtables': return $this->showtables( $request ); break; case 'dashboard': return $this->dashboard( $request ); break; case 'mapbbm': return $this->mapbbm( $request ); break; case 'getPermintaanBBMTable': return $this->getPermintaanBBMTable( $request ); break; } } }