public function store(Request $request) { $branch = Auth::user()->branch; $categories = ''; $productNames = ''; $products = ''; $unit_prices = ''; $quantities = ''; $amounts = ''; for ($i = 1; $i < 41; $i++) { $category = $request->get('category' . $i); $product = $request->get('productName' . $i); $productName = $request->get('products' . $i); $unit_price = $request->get('price' . $i); $quantity = $request->get('quantity' . $i); $amount = $request->get('amount' . $i); if (isset($category)) { $categories = $categories . $category . ','; } if (isset($product)) { $products = $products . $product . ','; \DB::update('UPDATE stock SET quantity=round(quantity-' . $quantity . ',2) WHERE cid=' . $category . ' AND pid=' . $product . ' AND branch=' . "'" . $branch . "'"); } if (isset($productName)) { $productNames = $productNames . $productName . ','; } if (isset($unit_price)) { $unit_prices = $unit_prices . $unit_price . ','; } if (isset($quantity)) { $quantities = $quantities . $quantity . ','; } if (isset($amount)) { $amounts = $amounts . $amount . ','; } } $invoice = \DB::select('SELECT SUBSTR(s.invoice_no, 6) AS invoice_no FROM sales s ORDER BY s.id DESC LIMIT 1'); if (isset($invoice[0]->invoice_no)) { $inv = $invoice[0]->invoice_no; } else { $inv = 0; } $next_invoice = date('Y-') . (string) ($inv + 1); $input = array('total_price' => $request->get('total_price'), 'invoice_no' => $next_invoice, 'customer_id' => $request->get('customerName'), 'customer_address' => $request->get('address'), 'categories' => $categories, 'products' => $products, 'productNames' => $productNames, 'unit_price' => $unit_prices, 'quantity' => $quantities, 'amount' => $amounts, 'total_price' => $request->get('total_price'), 'vat' => $request->get('vat'), 'total_price_vat' => $request->get('totalAmountVat'), 'discount' => $request->get('discount'), 'discount_price' => $request->get('discountAmount'), 'paid' => $request->get('paid'), 'dues' => $request->get('dues'), 'profit' => $request->get('net_profit'), 'branch' => $branch, 'sold_by' => Auth::user()->name); \DB::insert('insert into income(invoice_no, income_title, amount, branch, status, collected_by, created_at, updated_at) VALUES ("' . $next_invoice . '", "' . 'Sales' . '" , "' . $request->get('paid') . '", "' . $branch . '", "' . 'Valid' . '", "' . Auth::user()->name . '", "' . date('Y-m-d H:i:s') . '", "' . date('Y-m-d H:i:s') . '")'); \DB::insert('insert into net_balance(transaction_title, address, credit, debit, branch, status, collected_by, created_at, updated_at) VALUES ("' . 'Sales Profit' . '", "' . $next_invoice . '", "' . $request->get('net_profit') . '", "0", "' . $branch . '", "' . 'Valid' . '", "' . Auth::user()->name . '", "' . date('Y-m-d H:i:s') . '", "' . date('Y-m-d H:i:s') . '")'); Sales::create($input); session()->put('sale_input', $input); return redirect('/prints'); }
/** * Store a newly created resource in storage. * * @param CreateSalesRequest * @return Response */ public function store(CreateSalesRequest $request) { Sales::create($request->all()); return redirect('sales'); }