public function apply_coupon(Request $request, $item_id = '')
{
$coupon_code = trim($request->input('coupon_code', ''));
if ($item_id != '' && $coupon_code != '') {
//find item in db
$objItem = App\ItemMaster::where('item_id', $item_id)->where('status', 1)->first();
//find item in mongo cart
if ($this->user_session->is_logged_in) {
$objCartItem = App\CartMaster::where(function ($query) {
$query->where('user_id', (int) $this->user_session->user_id)->orWhere('session_id', session_id());
})->where('item_id', (int) $item_id)->first();
} else {
$objCartItem = App\CartMaster::where('session_id', session_id())->where('item_id', (int) $item_id)->first();
}
//if item found both in database and cart
if (null != $objItem && null != $objCartItem) {
//check if item is still eligible for coupon addition
if ($objCartItem->coupon_added == 1) {
$_SESSION['elegance_cut']['error'] = 'Coupon has already activated for this item.';
return redirect('cart');
}
//get coupon information if any
$objCouponMaster = DB::table('coupon_master')->join('coupon_type_master', 'coupon_type_master.coupon_id', '=', 'coupon_master.coupon_id')->where('coupon_master.status', 1)->where('coupon_type_master.type_id', $objItem->item_type)->where('coupon_master.coupon_code', $coupon_code)->select('coupon_master.*')->first();
if ($objCouponMaster != null) {
//everything is fine, add the coupon
$coupon_discount_rate = $objCouponMaster->discount_percent;
$discount_price = $coupon_discount_rate / 100 * $objCartItem->price;
$objCartItem->price = $objCartItem->price - $discount_price;
try {
$objCartItem->save();
} catch (Exception $e) {
$_SESSION['elegance_cut']['error'] = 'We are sorry, could not add the coupon. Please try again or contact our customer service.';
return redirect('cart');
}
$objCartItem->coupon_added = 1;
$objCartItem->save();
$_SESSION['elegance_cut']['success'] = 'The coupon has been successfully added.';
return redirect('cart');
} else {
$_SESSION['elegance_cut']['error'] = 'The coupon code, you have entered is invalid.';
return redirect('cart');
}
} else {
$_SESSION['elegance_cut']['error'] = 'Sorry, This item is no longer available. You can remove it from your cart.';
return redirect('cart');
}
} else {
$_SESSION['elegance_cut']['error'] = 'Please enter coupon code.';
return redirect('cart');
}
}
public function index(Request $request, $item_id = '')
{
if ($item_id != '') {
$objItem = App\ItemMaster::where('item_id', $item_id)->where('status', 1)->first();
if (null != $objItem) {
//fetch all the categories
$objCategory = App\CategoryMaster::all();
//fetch all the item types
$objType = App\TypeMaster::all();
//get category id versus category name array
$arrCetegory_id_obj = getKeyValueArray('cat_id', 'name', $objCategory, 'object', true);
$arrType_id_obj = getKeyValueArray('type_id', 'name', $objType, 'object', true);
//get coupon information if any
$objCouponMaster = DB::table('coupon_master')->join('coupon_type_master', 'coupon_type_master.coupon_id', '=', 'coupon_master.coupon_id')->where('coupon_master.status', 1)->where('coupon_type_master.type_id', $objItem->item_type)->select('coupon_master.*')->get();
$size = null;
$message = '';
$show_size_chart = false;
if ($objItem->qty == null) {
$show_size_chart = true;
}
if ($show_size_chart == true) {
//get item sizes
$objSizes = DB::table('item_size_master')->where('item_id', $objItem->item_id)->join('size_master', 'size_master.size_id', '=', 'item_size_master.size_id')->select('item_size_master.*', 'size_master.*')->get();
$arrSize_id_size_code = getKeyValueArray('size_id', 'size_code', $objSizes, 'object', false);
}
//get total available quantity
$total_available_qty = 0;
if ($show_size_chart) {
foreach ($objSizes as $key => $value) {
$total_available_qty = $total_available_qty + $value->qty;
}
} else {
if ($objItem->qty != null) {
$total_available_qty = $objItem->qty;
}
}
//add to cart
if ($request->isMethod('post')) {
//check size is valid
if ($show_size_chart == true) {
$size = filter_form_input($request->input('size', ''));
$size_valid = false;
foreach ($objSizes as $key => $value) {
if ($value->qty > 0 && $value->size_code == $size) {
$size_valid = true;
}
}
if (!$size_valid) {
$message[] = 'Plese select size first.';
}
}
$qty = filter_form_input($request->input('qty', ''));
if ($message == '') {
if ($qty != '' && is_numeric($qty) && $qty <= $total_available_qty) {
if ($this->user_session->is_logged_in == true) {
$user_id = $this->user_session->user_id;
} else {
$user_id = null;
}
if ($this->user_session->is_logged_in) {
$check_if_already_added = App\CartMaster::where(function ($query) {
$query->where('user_id', (int) $this->user_session->user_id)->orWhere('session_id', session_id());
})->where('item_id', (int) $objItem->item_id)->first();
} else {
$check_if_already_added = App\CartMaster::where('session_id', session_id())->where('item_id', (int) $objItem->item_id)->first();
}
if (null == $check_if_already_added) {
//add to cart
DB::connection('mongodb')->table('cart')->insert(['item_id' => (int) $objItem->item_id, 'user_id' => (int) $user_id, 'session_id' => session_id(), 'qty' => (int) $qty, 'size' => $size, 'price' => $objItem->price, 'coupon_added' => 0]);
return redirect()->route('cart');
} else {
$message[] = 'You already have added this item to your cart.';
}
} else {
$message[] = 'Oops! the selected quantity is not available. Plese select lesser quantity.';
}
}
}
//other product images
$objProductImages = array();
if (is_array($message)) {
$temp = '';
foreach ($message as $value) {
$temp = $temp . $value . '<br>';
}
$message = $temp;
}
return view('product.product', compact('objCouponMaster', 'total_available_qty', 'message', 'show_size_chart', 'objSizes', 'objProductImages', 'objItem', 'objCategory', 'objType', 'arrCetegory_id_obj', 'arrType_id_obj'));
} else {
abort(404);
}
} else {
abort(404);
}
}
