public function findInvoiceItem($id)
 {
     return InvoiceItem::findOrFail($id);
 }
 public function destroy($id)
 {
     $invoiceItem = InvoiceItem::find($id);
     $salesId = $invoiceItem->salesInvoice->id;
     $invoice = SalesInvoice::find($salesId);
     $invoice->update(['total_amount' => $invoice->total_amount - $invoiceItem->total_price]);
     $invoiceItem->delete();
     return redirect()->action('SalesInvoicesController@edit', [$salesId]);
 }
 public function creation(Requests\CreateSalesInvoiceRequest $request)
 {
     $input = Request::all();
     $salesInvoice = SalesInvoice::find($input['invoice_no']);
     $items = InvoiceItem::where('sales_invoice_id', $salesInvoice->id)->get();
     $output = $salesInvoice->Client->currentCredit();
     $creditOutput = $output[0]->credit;
     if ($creditOutput == null) {
         $creditOutput = 0;
     }
     $remaining = $salesInvoice->Client->credit_limit - $creditOutput;
     foreach ($items as $item) {
         $invoiceItem = InvoiceItem::find($item->id);
         $creditOutput += $input['quantity' . $item->id] * $input['unit_price' . $item->id];
     }
     if ($creditOutput > $salesInvoice->Client->credit_limit) {
         Flash::error('Cannot add the invoice, client would exceed the credit limit. The remaining allowable credit is only Php ' . $remaining . '.');
         return redirect()->back()->withInput();
         //return redirect()->back()->withInput()->with('message','Cannot add the invoice, client would exceed the credit limit. The remaining allowable credit is only Php ' . $remaining . '.');
     }
     $salesInvoice->update(['si_no' => $input['si_no'], 'po_number' => $input['po_number'], 'dr_number' => $input['dr_number'], 'date' => Carbon::now()]);
     $total_amount = 0;
     $items = InvoiceItem::where('sales_invoice_id', $salesInvoice->id)->get();
     //$items = $input(['items']);
     foreach ($items as $item) {
         $invoiceItem = InvoiceItem::find($item->id);
         $invoiceItem->update(['quantity' => $input['quantity' . $item->id], 'unit_price' => $input['unit_price' . $item->id], 'total_price' => $input['quantity' . $item->id] * $input['unit_price' . $item->id]]);
         $total_amount += $invoiceItem->total_price;
     }
     $salesInvoice->update(['total_amount' => $total_amount, 'status' => "Pending"]);
     if ($salesInvoice->Client->vat_exempt == 'VAT Exclusive') {
         $salesInvoice->update(['total_amount' => $salesInvoice->total_amount + $salesInvoice->total_amount * 0.12]);
     }
     Activity::log('Sales Invoice ' . $salesInvoice['si_no'] . ' was completed');
     return redirect()->action('SalesInvoicesController@show', [$salesInvoice->id]);
 }
Example #4
0
 /**
  * Ajax delete
  * @param $id
  */
 public function delete_item($id)
 {
     $objInvoiceItem = \App\InvoiceItem::find($id);
     if (!$this->objLoggedInUser->HasPermission("Edit/{$objInvoiceItem->Invoice->type}")) {
         abort('404');
     }
     $objInvoiceItem->status = \App\InvoiceItem::STATUS_DELETED;
     if ($objInvoiceItem->save()) {
         exit('success');
     }
     exit('error');
 }