/** * Store a newly created resource in storage. * POST /invoice * * @return Response */ public function store() { $validator = Validator::make(Input::all(), Invoice::$rules); if ($validator->fails()) { return Redirect::to('invoice')->withErrors($validator)->withInput(Input::all()); } else { $invoice = new Invoice(); $invoice->no_inv = Input::get('no_inv'); $invoice->tgl_inv = Input::get('tgl_inv'); $invoice->no_PO = Input::get('no_PO'); $invoice->ship_by = Input::get('ship_by'); $invoice->pay_method = Input::get('pay_method'); $invoice->no_rek = Input::get('no_rek'); $invoice->pelabuhan = Input::get('pelabuhan'); $invoice->carrier = Input::get('carrier'); $invoice->save(); $SPPB = Barang::join('detil_SPPB', 'barang.kode_barang', '=', 'detil_SPPB.kode_barang')->join('SPPB', 'detil_SPPB.no_SPPB', '=', 'SPPB.no_SPPB')->join('PO', 'SPPB.no_SPPB', '=', 'PO.no_SPPB')->where('no_PO', Input::get('no_PO'))->selectRaw('barang.kode_barang as barang, jml_pesan as pesan')->get(); foreach ($SPPB as $key => $value) { $barang = Barang::find($value->barang); $barang->jml_barang = $barang->jml_barang - $value->pesan; $barang->save(); } Session::flash('message', 'Successfully created invoice!'); return Redirect::to('invoice'); } }
public function lapSPPB($awal, $akhir) { $data = array('awal' => $awal, 'akhir' => $akhir, 'data' => Barang::join('detil_SPPB', 'barang.kode_barang', '=', 'detil_SPPB.kode_barang')->join('SPPB', 'detil_SPPB.no_SPPB', '=', 'SPPB.no_SPPB')->join('PO', 'SPPB.no_SPPB', '=', 'PO.no_SPPB')->join('invoice', 'PO.no_PO', '=', 'invoice.no_PO')->join('supplier', 'PO.id_supp', '=', 'supplier.id_supp')->whereBetween('tgl_SPPB', array($awal, $akhir))->select('nm_barang', 'barang.kode_barang', 'satuan', DB::raw('sum(jml_pesan) AS total_pesan'), 'nm_supp', 'brand', 'hrg_satuan')->groupBy('kode_barang')->get()); $pdf = PDF::loadView('reports.lapSPPB', $data)->setPaper('a4', 'potrait'); return $pdf->stream(); }