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