/** * Execute the job. * * @return void */ public function handle() { try { \DB::begintransaction(); /* KREDIT */ data_jurnal::create(['id_faktur' => $this->req['id_faktur'], 'id_coa_ledger' => $this->req['id_coa_ledger'], 'tanggal' => date('Y-m-d', strtotime($this->req['tanggal'])), 'deskripsi' => $this->req['deskripsi'], 'id_payment_methode' => $this->req['id_payment_methode'], 'tipe' => 2, 'total' => $this->req['total']]); /* DEBET */ data_jurnal::create(['id_faktur' => $this->req['id_faktur'], 'id_coa_ledger' => $this->req['perkiraan'], 'tanggal' => date('Y-m-d', strtotime($this->req['tanggal'])), 'deskripsi' => $this->req['deskripsi'], 'id_payment_methode' => $this->req['id_payment_methode'], 'tipe' => 1, 'total' => $this->req['total']]); $faktur = data_faktur::find($this->req['id_faktur']); if ($this->req['total'] == $this->req['total_old']) { $faktur->status = 2; } else { $faktur->status = 1; } $faktur->amount_due = $faktur->amount_due + $this->req['total']; $faktur->save(); /* KREDIT */ $coa = ref_coa_ledger::find($this->req['id_coa_ledger']); $coa->balance = $coa->balance + $this->req['total']; $coa->save(); /* DEBET */ $kira = ref_coa_ledger::find($this->req['perkiraan']); $kira->balance = $kira->balance + $this->req['total']; $kira->save(); \DB::commit(); return ['label' => 'success', 'err' => 'Payment berhasil dilakukan']; } catch (\Exception $e) { \DB::rollback(); return ['label' => 'danger', 'err' => $e->getMessage()]; } }
/** * Execute the job. * * @return void */ public function handle() { //dd($this->req); $me = \Me::data()->id_karyawan; try { \DB::begintransaction(); $faktur = data_faktur::find($this->req['id']); $faktur->update(['Nomor_type' => $this->req['no_po'], 'prefix' => $this->req['prefix'], 'type' => 1, 'id_vendor' => $this->req['supplier'], 'id_po' => $this->req['id_po'], 'tgl_faktur' => date('Y-m-d', strtotime($this->req['tanggal'])), 'duodate' => date('Y-m-d', strtotime($this->req['duodate'])), 'id_payment_terms' => $this->req['terms'], 'ppn' => $this->req['ppn'], 'diskon' => $this->req['diskon'], 'adjustment' => $this->req['adjustment'], 'subtotal' => $this->req['subtotal'], 'total' => $this->req['grandtotal'], 'keterangan' => $this->req['keterangan'], 'status' => 0]); data_faktur_item::whereId_faktur($faktur->id_faktur)->delete(); foreach ($this->req['id_barang'] as $i => $id) { data_faktur_item::create(['id_faktur' => $faktur->id_faktur, 'id_item' => $id, 'deskripsi' => $this->req['deskripsi'][$i], 'qty' => $this->req['qty'][$i], 'harga' => $this->req['harga'][$i], 'diskon' => $this->req['diskons'][$i], 'total' => $this->req['total'][$i], 'id_po' => $this->req['id_po'], 'id_satuan' => $this->req['id_satuan'][$i]]); } \DB::commit(); return ['res' => true, 'label' => 'success', 'err' => '<center>Faktur No. #' . $faktur->nomor_faktur . ' berhasil diperbaharui</center>']; } catch (\Exception $e) { \DB::rollback(); return ['res' => false, 'label' => 'danger', 'err' => $e->getMessage()]; } }
public function postStatus(Request $req) { if ($req->ajax()) { data_faktur::find($req->id)->update(['status' => $req->status]); $status = [0 => ['label' => 'important', 'err' => 'Unpaid'], 1 => ['label' => 'warning', 'err' => 'Partially Paid'], 2 => ['label' => 'info', 'err' => 'Paid'], 3 => ['label' => 'important', 'err' => 'Batal']]; $out = ' <span class="label label-' . $status[$req->status]['label'] . '"> ' . $status[$req->status]['err'] . ' </span> '; return json_encode(['err' => $out, 'status' => $status[$req->status]['err']]); } }