<?php
namespace App\Http\Controllers\Branch;
use App\CentralLogics\Helpers;
use App\Http\Controllers\Controller;
use App\Model\Branch;
use App\Model\Category;
use App\Model\Order;
use App\Model\OrderDetail;
use App\Model\Product;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Support\Facades\DB;
use function App\CentralLogics\translate;
class POSController extends Controller
{
public function index(Request $request)
{
$category = $request->query('category_id', 0);
$categories = Category::active()->get();
$keyword = $request->query('search', false);
$key = explode(' ', $keyword);
$products = Product::
when($request->has('category_id') && $request['category_id'] != 0, function ($query) use ($request) {
$query->whereJsonContains('category_ids', [[['id' => (string)$request['category_id']]]]);
})
->when($keyword, function ($query) use ($key) {
return $query->where(function ($q) use ($key) {
foreach ($key as $value) {
$q->orWhere('name', 'like', "%{$value}%");
}
});
})
->active()->latest()->paginate(Helpers::pagination_limit());
$branch = Branch::find(auth('branch')->id());
return view('branch-views.pos.index', compact('categories', 'products', 'category', 'keyword', 'branch'));
}
public function quick_view(Request $request)
{
$product = Product::findOrFail($request->product_id);
return response()->json([
'success' => 1,
'view' => view('branch-views.pos._quick-view-data', compact('product'))->render(),
]);
}
public function variant_price(Request $request)
{
$product = Product::find($request->id);
$str = '';
$quantity = 0;
$price = 0;
foreach (json_decode($product->choice_options) as $key => $choice) {
if ($str != null) {
$str .= '-' . str_replace(' ', '', $request[$choice->name]);
} else {
$str .= str_replace(' ', '', $request[$choice->name]);
}
}
if ($str != null) {
$count = count(json_decode($product->variations));
for ($i = 0; $i < $count; $i++) {
if (json_decode($product->variations)[$i]->type == $str) {
$price = json_decode($product->variations)[$i]->price - Helpers::discount_calculate($product, $product->price);
}
}
} else {
$price = $product->price - Helpers::discount_calculate($product, $product->price);
}
return array('price' => ($price * $request->quantity));
}
public function get_customers(Request $request)
{
$key = explode(' ', $request['q']);
$data = DB::table('users')
->where(function ($q) use ($key) {
foreach ($key as $value) {
$q->orWhere('f_name', 'like', "%{$value}%")
->orWhere('l_name', 'like', "%{$value}%")
->orWhere('phone', 'like', "%{$value}%");
}
})
->limit(8)
->get([DB::raw('id, CONCAT(f_name, " ", l_name, " (", phone ,")") as text')]);
$data[] = (object)['id' => false, 'text' => translate('walk_in_customer')];
return response()->json($data);
}
public function update_tax(Request $request)
{
if ($request->tax < 0) {
Toastr::error(translate('Tax_can_not_be_less_than_0_percent'));
return back();
} elseif ($request->tax > 100) {
Toastr::error(translate('Tax_can_not_be_more_than_100_percent'));
return back();
}
$cart = $request->session()->get('cart', collect([]));
$cart['tax'] = $request->tax;
$request->session()->put('cart', $cart);
return back();
}
public function update_discount(Request $request)
{
if ($request->type == 'percent' && $request->discount < 0) {
Toastr::error(translate('Extra_discount_can_not_be_less_than_0_percent'));
return back();
} elseif ($request->type == 'percent' && $request->discount > 100) {
Toastr::error(translate('Extra_discount_can_not_be_more_than_100_percent'));
return back();
}
$cart = $request->session()->get('cart', collect([]));
$cart['extra_discount'] = $request->discount;
$cart['extra_discount_type'] = $request->type;
$request->session()->put('cart', $cart);
return back();
}
public function updateQuantity(Request $request)
{
$cart = $request->session()->get('cart', collect([]));
$cart = $cart->map(function ($object, $key) use ($request) {
if ($key == $request->key) {
$object['quantity'] = $request->quantity;
}
return $object;
});
$request->session()->put('cart', $cart);
return response()->json([], 200);
}
public function addToCart(Request $request)
{
$product = Product::find($request->id);
$data = array();
$data['id'] = $product->id;
$str = '';
$variations = [];
$price = 0;
//Gets all the choice values of customer choice option and generate a string like Black-S-Cotton
foreach (json_decode($product->choice_options) as $key => $choice) {
$data[$choice->name] = $request[$choice->name];
$variations[$choice->title] = $request[$choice->name];
if ($str != null) {
$str .= '-' . str_replace(' ', '', $request[$choice->name]);
} else {
$str .= str_replace(' ', '', $request[$choice->name]);
}
}
$data['variations'] = $variations;
$data['variant'] = $str;
if ($request->session()->has('cart')) {
if (count($request->session()->get('cart')) > 0) {
foreach ($request->session()->get('cart') as $key => $cartItem) {
if (is_array($cartItem) && $cartItem['id'] == $request['id'] && $cartItem['variant'] == $str) {
return response()->json([
'data' => 1
]);
}
}
}
}
//Check the string and decreases quantity for the stock
if ($str != null) {
$count = count(json_decode($product->variations));
for ($i = 0; $i < $count; $i++) {
if (json_decode($product->variations)[$i]->type == $str) {
$price = json_decode($product->variations)[$i]->price;
}
}
} else {
$price = $product->price;
}
$data['quantity'] = $request['quantity'];
$data['price'] = $price;
$data['name'] = $product->name;
$data['discount'] = Helpers::discount_calculate($product, $price);
$data['image'] = $product->image;
if ($request->session()->has('cart')) {
$cart = $request->session()->get('cart', collect([]));
$cart->push($data);
} else {
$cart = collect([$data]);
$request->session()->put('cart', $cart);
}
return response()->json([
'data' => $data
]);
}
public function cart_items()
{
return view('branch-views.pos._cart');
}
public function emptyCart(Request $request)
{
session()->forget('cart');
return response()->json([], 200);
}
public function removeFromCart(Request $request)
{
if ($request->session()->has('cart')) {
$cart = $request->session()->get('cart', collect([]));
$cart->forget($request->key);
$request->session()->put('cart', $cart);
}
return response()->json([], 200);
}
//order
public function order_list(Request $request)
{
$query_param = [];
$search = $request['search'];
Order::where(['checked' => 0])->update(['checked' => 1]);
$query = Order::pos()->where(['branch_id' => auth('branch')->id()])->with(['customer', 'branch']);
if ($request->has('search')) {
$key = explode(' ', $request['search']);
$query = $query->where(function ($q) use ($key) {
foreach ($key as $value) {
$q->orWhere('id', 'like', "%{$value}%")
->orWhere('order_status', 'like', "%{$value}%")
->orWhere('transaction_reference', 'like', "%{$value}%");
}
});
$query_param = ['search' => $request['search']];
}
$orders = $query->latest()->paginate(Helpers::getPagination())->appends($query_param);
return view('branch-views.pos.order.list', compact('orders', 'search'));
}
public function order_details($id)
{
$order = Order::with('details')->where(['id' => $id, 'branch_id' => auth('branch')->id()])->first();
if (isset($order)) {
return view('branch-views.pos.order.order-view', compact('order'));
} else {
Toastr::info('No more orders!');
return back();
}
}
public function place_order(Request $request)
{
if ($request->session()->has('cart')) {
if (count($request->session()->get('cart')) < 1) {
Toastr::error(translate('cart_empty_warning'));
return back();
}
} else {
Toastr::error(translate('cart_empty_warning'));
return back();
}
$cart = $request->session()->get('cart');
$total_tax_amount = 0;
$product_price = 0;
$order_details = [];
$order_id = 100000 + Order::all()->count() + 1;
if (Order::find($order_id)) {
$order_id = Order::orderBy('id', 'DESC')->first()->id + 1;
}
$order = new Order();
$order->id = $order_id;
$order->user_id = session()->has('customer_id') ? session('customer_id') : null;
$order->coupon_discount_title = $request->coupon_discount_title == 0 ? null : 'coupon_discount_title';
$order->payment_status = 'paid';
$order->order_status = 'delivered';
$order->order_type = 'pos';
$order->coupon_code = $request->coupon_code ?? null;
$order->payment_method = $request->type;
$order->transaction_reference = $request->transaction_reference ?? null;
$order->delivery_charge = 0; //since pos, no distance, no d. charge
$order->delivery_address_id = $request->delivery_address_id ?? null;
$order->order_note = null;
$order->checked = 1;
$order->created_at = now();
$order->updated_at = now();
foreach ($cart as $c) {
if (is_array($c)) {
$discount_on_product = 0;
$product_subtotal = ($c['price']) * $c['quantity'];
$discount_on_product += ($c['discount'] * $c['quantity']);
$product = Product::find($c['id']);
$product->total_stock -= $c['quantity'];
if ($product) {
$price = $c['price'];
$product = Helpers::product_data_formatting($product);
$or_d = [
'product_id' => $c['id'],
'product_details' => $product,
'quantity' => $c['quantity'],
'price' => $price,
'tax_amount' => Helpers::tax_calculate($product, $price),
'discount_on_product' => Helpers::discount_calculate($product, $price),
'discount_type' => 'discount_on_product',
'variant' => json_encode($c['variant']),
'variation' => json_encode([$c['variations']]),
'created_at' => now(),
'updated_at' => now()
];
$total_tax_amount += $or_d['tax_amount'] * $c['quantity'];
$product_price += $product_subtotal - $discount_on_product;
$order_details[] = $or_d;
}
$product->save();
}
}
$total_price = $product_price;
if (isset($cart['extra_discount'])) {
$extra_discount = $cart['extra_discount_type'] == 'percent' && $cart['extra_discount'] > 0 ? (($total_price * $cart['extra_discount']) / 100) : $cart['extra_discount'];
$total_price -= $extra_discount;
}
$tax = isset($cart['tax']) ? $cart['tax'] : 0;
$total_tax_amount = ($tax > 0) ? (($total_price * $tax) / 100) : $total_tax_amount;
try {
$order->extra_discount = $extra_discount??0;
$order->total_tax_amount = $total_tax_amount;
$order->order_amount = $total_price + $total_tax_amount + $order->delivery_charge;
$order->coupon_discount_amount = 0.00;
$order->branch_id = auth('branch')->id();
$order->save();
foreach ($order_details as $key => $item) {
$order_details[$key]['order_id'] = $order->id;
}
OrderDetail::insert($order_details);
session()->forget('cart');
session()->forget('customer_id');
session(['last_order' => $order->id]);
Toastr::success(translate('order_placed_successfully'));
return back();
} catch (\Exception $e) {
info($e);
}
Toastr::warning(translate('failed_to_place_order'));
return back();
}
public function store_keys(Request $request)
{
session()->put($request['key'], $request['value']);
return response()->json('', 200);
}
public function generate_invoice($id)
{
$order = Order::where('id', $id)->first();
return response()->json([
'success' => 1,
'view' => view('branch-views.pos.order.invoice', compact('order'))->render(),
]);
}
}