public function simpan1() { $no_SPPB = Input::get('noSPPB'); $id_dept = Input::get('idDept'); $tgl_SPPB = Input::get('tglSPPB'); $SPPB = new SPPB(); $SPPB->no_SPPB = $no_SPPB; $SPPB->tgl_SPPB = $tgl_SPPB; $SPPB->id_dept = $id_dept; $SPPB->no_kar = Auth::user()->no_kar; $SPPB->save(); /* DB::table('SPPB')->insert( array('no_SPPB' => $no_SPPB, 'tgl_SPPB' => $tgl_SPPB, 'id_dept' => $id_dept) ); */ $brg = array('confirm' => 'succes'); return Response::json($brg); }
/** * * Laporan Pengiriman Barang (DO) * @param $awal * @param $akhir * @return mixed */ public function lapDO($awal, $akhir) { $data = array('awal' => $awal, 'akhir' => $akhir, 'data' => SPPB::join('PO', 'SPPB.no_SPPB', '=', 'PO.no_SPPB')->join('supplier', 'PO.id_supp', '=', 'supplier.id_supp')->join('invoice', 'PO.no_PO', '=', 'invoice.no_PO')->join('DO', 'invoice.no_inv', '=', 'DO.no_inv')->whereBetween('DO.tgl_DO', array($awal, $akhir))->select('nm_supp', 'alamat', 'telp', 'pelabuhan', 'carrier', 'tgl_DO')->get()); $pdf = PDF::loadView('reports.lapDO', $data)->setPaper('a4', 'landscape'); return $pdf->stream(); }