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();
}
