/**
* Execute the job.
*
* @return void
*/
public function handle()
{
$v = data_vendor::find($this->req['id_vendor']);
$v->update(['nm_vendor' => $this->req['nm_vendor'], 'pemilik' => $this->req['nama_pemilik'], 'alamat' => $this->req['alamat'], 'telpon' => $this->req['telpon'], 'fax' => $this->req['fax'], 'email' => $this->req['email'], 'website' => $this->req['website']]);
\Loguser::create('Melakukan perubahan terhadap data Penyedia Kode. ' . $v->kode);
return $this->req;
}
public function getAlamat(Request $req)
{
if ($req->ajax()) {
$res = [];
$vendor = data_vendor::find($req->id);
if ($vendor == null) {
$res['alamat'] = '';
} else {
$res['alamat'] = $vendor->alamat;
}
return json_encode($res);
}
}
public function getRetur($id = 0)
{
if (empty($id)) {
return abort(404);
}
$vendor = data_vendor::find($id);
if ($vendor == null) {
return abort(404);
}
$items = data_retur::forvendor($id, [], [1, 2, 3])->paginate(10);
$status = [1 => 'Baru', 2 => 'Proses', 3 => 'Selesai'];
return view('Pembelian.Vendor.Retur', ['vendor' => $vendor, 'items' => $items, 'status' => $status]);
}
public function getPrint($id)
{
$items = data_sph_item::join('data_prq', 'data_prq.id_prq', '=', 'data_sph_item.id_prq')->join('data_barang', 'data_barang.id_barang', '=', 'data_sph_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_barang.id_satuan')->where('data_sph_item.id_sph', $id)->select('data_prq.no_prq', 'data_barang.nm_barang', 'data_barang.id_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'data_sph_item.*', 'ref_satuan.nm_satuan')->get();
$sph = data_sph::find($id);
$vendor = data_vendor::find($sph->id_vendor);
$grup = data_sph_grup::whereId_sph_grup($sph->id_sph_grup)->select('status')->first();
/* Matematika */
$subtotal = 0;
foreach ($items as $item) {
$subtotal += ($item->harga - $item->harga * $item->diskon / 100) * $item->qty;
}
$diskon = $subtotal * $sph->diskon / 100;
$aftdiskon = $subtotal - $diskon;
$ppn = $aftdiskon * $sph->ppn / 100;
$pph = $aftdiskon * $sph->pph / 100;
$grandtotal = $aftdiskon + $ppn + $pph + $sph->adjustment;
$matematika = ['subtotal' => $subtotal, 'diskon' => $diskon, 'aftdiskon' => $aftdiskon, 'ppn' => $ppn, 'pph' => $pph, 'grandtotal' => $grandtotal];
// Status SPH
$status = $grup->status == 2 && $sph->status == 1 ? true : false;
return view('Print.Pembelian.SPH.PrintSPH', ['items' => $items, 'sph' => $sph, 'vendor' => $vendor, 'mtk' => $matematika, 'status' => $status]);
}
public function getPrint($id)
{
$po = data_po::poprint($id)->first();
if ($po == null) {
return redirect('/po')->withNotif(['label' => 'warning', 'err' => 'PO tidak tersedia!']);
}
$items = data_po_item::join('data_barang', 'data_barang.id_barang', '=', 'data_po_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_barang.id_satuan')->where('data_po_item.id_po', $id)->select('data_barang.nm_barang', 'data_barang.id_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'data_po_item.*', 'ref_satuan.nm_satuan')->get();
$vendor = data_vendor::find($po->id_vendor);
/* Matematika */
$subtotal = 0;
foreach ($items as $item) {
$subtotal += ($item->harga - $item->harga * $item->diskon / 100) * $item->req_qty;
}
$diskon = $subtotal * $po->diskon / 100;
$aftdiskon = $subtotal - $diskon;
$ppn = $aftdiskon * $po->ppn / 100;
$grandtotal = $aftdiskon + $ppn + $po->adjustment;
$matematika = ['subtotal' => $subtotal, 'diskon' => $diskon, 'aftdiskon' => $aftdiskon, 'ppn' => $ppn, 'grandtotal' => $grandtotal];
return view('Print.Pembelian.PO.printPO', ['items' => $items, 'po' => $po, 'vendor' => $vendor, 'mtk' => $matematika]);
}
