public function checkoutMemberLogin() { $obj = new helpers(); if ($obj->checkMemberLogin()) { return redirect('member-dashboard'); } if ($obj->checkBrandLogin()) { return redirect('brand-dashboard'); } if (Request::isMethod('post')) { $email = Request::input('email'); $password = Request::input('password'); $encrypt_pass = Hash::make($password); $login_arr = array('email' => $email, 'password' => $encrypt_pass); $users = DB::table('brandmembers')->where('email', $email)->where('role', 0)->first(); // Only member Can Login here // print_r($_POST);exit; if ($users != "") { $user_pass = $users->password; // check for password if (Hash::check($password, $user_pass)) { // Check for active $user_cnt = DB::table('brandmembers')->where('email', $email)->where('status', 1)->where('admin_status', 1)->count(); //echo $user_cnt;exit; //echo DB::enableQueryLog();exit; if ($user_cnt) { Session::put('member_userid', $users->id); Session::put('member_user_email', $users->email); Session::put('member_username', ucfirst($users->username)); Session::forget('step1'); Session::forget('guest_array'); Session::forget('guest'); Session::forget('step3'); //Set the user cart $this->update_cart($users->id); return redirect('/checkout'); } else { $site = DB::table('sitesettings')->where('name', 'email')->first(); Session::flash('error', 'Your Status is inactive. Contact Admin at ' . $site->value . ' to get your account activated!'); return redirect('/checkout'); } } else { Session::flash('error', 'Email and password does not match.'); return redirect('/checkout'); } } else { Session::flash('error', 'This email-id is not register as a member.'); return redirect('/checkout'); } } return view('frontend.checkout.checkout_setp1', compact('body_class'), array('title' => 'MIRAMIX | checkout')); }
public function __construct() { parent::__construct(); $obj = new helpers(); if (!$obj->checkBrandLogin()) { $brandlogin = 0; // Logged as a member } else { $brandlogin = 1; // Logged as a brand } view()->share('brandlogin', $brandlogin); }
public function soldProducts() { $obj = new helpers(); if (!$obj->checkBrandLogin()) { return redirect('brandLogin'); } $brand_details = Brandmember::find(Session::get('brand_userid')); $limit = 2; $products = DB::table('products')->select(DB::raw('products.id,products.brandmember_id,products.product_name,products.product_slug,products.image1, SUM(order_items.`quantity`) as `sale_qty`,SUM(order_items.`price`) as `total_sale`'))->leftJoin('order_items', 'products.id', '=', 'order_items.product_id')->where('products.brandmember_id', '=', Session::get('brand_userid'))->whereRaw('products.active="1"')->where('products.is_deleted', 0)->where('products.discountinue', 0)->whereRaw('(order_items.`quantity`)>0')->groupBy('products.id')->paginate($limit); $products->setPath('sold-products'); return view('frontend.brand.sold_product_history', compact('products', 'brand_details'), array('title' => 'Sold Product History')); }
public function checkoutStep4() { $obj = new helpers(); if ($obj->checkMemberLogin() && !$obj->checkBrandLogin()) { $sitesettings = DB::table('sitesettings')->get(); if (!empty($sitesettings)) { foreach ($sitesettings as $each_sitesetting) { if ($each_sitesetting->name == 'shipping_rate') { $shipping_rate = (int) $each_sitesetting->value; } } } if (Request::isMethod('post')) { $shp_address = DB::table('addresses')->where('mem_brand_id', Session::get('member_userid'))->where('id', Session::get('selected_address_id'))->first(); // Serialize the Shipping Address because If user delete there address from "addresses" table,After that the address also store in the "order" table for getting order history// $shiping_address = array('address_title' => $shp_address->address_title, 'mem_brand_id' => $shp_address->mem_brand_id, 'first_name' => $shp_address->first_name, 'last_name' => $shp_address->last_name, 'email' => $shp_address->email, 'phone' => $shp_address->phone, 'address' => $shp_address->address, 'address2' => $shp_address->address2, 'city' => $shp_address->city, 'zone_id' => $shp_address->zone_id, 'country_id' => $shp_address->country_id, 'postcode' => $shp_address->postcode); $shiping_address_serial = serialize($shiping_address); $order = Order::create(['order_total' => Request::input('grand_total'), 'sub_total' => Request::input('sub_total'), 'order_status' => 'pending', 'shipping_address_id' => Session::get('selected_address_id'), 'shipping_cost' => $shipping_rate, 'shipping_type' => 'flat', 'user_id' => Session::get('member_userid'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'payment_method' => Session::get('payment_method'), 'transaction_id' => '', 'transaction_status' => '', 'shiping_address_serialize' => $shiping_address_serial, 'created_at' => date('Y-m-d H:s:i'), 'updated_at' => date('Y-m-d H:s:i')]); $last_order_id = $order->id; $allCart = DB::table('carts')->where('user_id', Session::get('member_userid'))->get(); foreach ($allCart as $eachCart) { $product_details = DB::table('products')->where('id', $eachCart->product_id)->first(); // echo $each_content->brandmember_id; exit; $brandmember_deatils = DB::table('products')->leftJoin('brandmembers', 'brandmembers.id', '=', 'products.brandmember_id')->select('products.*', 'brandmembers.fname', 'brandmembers.lname', 'brandmembers.username', 'brandmembers.slug', 'brandmembers.pro_image', 'brandmembers.brand_details', 'brandmembers.brand_sitelink', 'brandmembers.status', 'brandmembers.admin_status')->where('products.id', '=', $eachCart->product_id)->first(); //echo "<pre>";print_r($brandmember_deatils); exit; //echo $brandmember->slug ; exit; $brand_member_name = $brandmember_deatils->fname ? $brandmember_deatils->fname . ' ' . $brandmember_deatils->lname : $brandmember_deatils->username; $formfactor = DB::table('form_factors')->where('id', '=', $eachCart->form_factor)->first(); $order_item = OrderItems::create(['order_id' => $last_order_id, 'brand_id' => $brandmember_deatils->brandmember_id, 'brand_name' => $brand_member_name, 'product_id' => $eachCart->product_id, 'product_name' => $eachCart->product_name, 'product_image' => $product_details->image1, 'quantity' => $eachCart->quantity, 'price' => $eachCart->amount, 'form_factor_id' => $formfactor->id, 'form_factor_name' => $formfactor->name]); // All Cart deleted from cart table after inserting all data to order and order_item table. //$deleteCart = Cart::where('user_id', '=', Session::get('member_userid'))->delete(); } if (Session::get('payment_method') == 'creditcard') { return redirect('/checkout-authorize/' . $last_order_id); } elseif (Session::get('payment_method') == 'paypal') { return redirect('/checkout-paypal/' . $last_order_id); } } // All Cart Contain In Session Will Display Here // $content = DB::table('carts')->where('user_id', Session::get('member_userid'))->get(); //echo "<pre>";print_r($content); exit; foreach ($content as $each_content) { $product_res = DB::table('products')->where('id', $each_content->product_id)->first(); // echo $each_content->brandmember_id; exit; $brandmember = DB::table('products')->leftJoin('brandmembers', 'brandmembers.id', '=', 'products.brandmember_id')->select('products.*', 'brandmembers.fname', 'brandmembers.lname', 'brandmembers.username', 'brandmembers.slug', 'brandmembers.pro_image', 'brandmembers.brand_details', 'brandmembers.brand_sitelink', 'brandmembers.status', 'brandmembers.admin_status')->where('products.id', '=', $each_content->product_id)->first(); //echo "<pre>";print_r($brandmember); //echo $brandmember->slug ; exit; $brand_name = $brandmember->fname ? $brandmember->fname . ' ' . $brandmember->lname : $brandmember->username; $formfactor = DB::table('form_factors')->where('id', '=', $each_content->form_factor)->first(); $formfactor_name = $formfactor->name; $formfactor_id = $formfactor->id; $cart_result[] = array('rowid' => $each_content->row_id, 'product_name' => $each_content->product_name, 'product_slug' => $brandmember->product_slug, 'product_image' => $product_res->image1, 'qty' => $each_content->quantity, 'price' => $each_content->amount, 'duration' => $each_content->duration, 'formfactor_name' => $formfactor_name, 'formfactor_id' => $formfactor_id, 'brand_name' => $brand_name, 'brand_slug' => $brandmember->slug, 'subtotal' => $each_content->sub_total); } //echo "sph= ".$shipping_rate; exit; return view('frontend.checkout.checkout_setp4', compact('body_class', 'cart_result', 'shipping_rate'), array('title' => 'MIRAMIX | Checkout-Step4')); } else { redirect('/checkout-step1'); } }
public function allProductByBrand() { $obj = new helpers(); if (!$obj->checkBrandLogin()) { return redirect('brandLogin'); } // Check if brand subscription expires show message $subscription_status = 'active'; $brand_details = Brandmember::find(Session::get('brand_userid')); if ($brand_details->subscription_status != "active") { $subscription_status = 'inactive'; } $limit = 10; //echo "hello= " . Session::get('brand_userid'); $product = DB::table('products')->select(DB::raw('products.id,products.brandmember_id,products.script_generated,products.product_name,products.product_slug,products.image1, MIN(`actual_price`) as `min_price`,MAX(`actual_price`) as `max_price`'))->leftJoin('product_formfactors', 'products.id', '=', 'product_formfactors.product_id')->where('products.brandmember_id', '=', Session::get('brand_userid'))->where('products.active', 1)->where('product_formfactors.actual_price', '!=', 0)->where('products.is_deleted', 0)->where('products.discountinue', 0)->groupBy('product_formfactors.product_id')->paginate($limit); // echo "<pre>";print_r($product); exit; return view('frontend.product.my_product', compact('product', 'subscription_status'), array('title' => 'MIRAMIX | Brand Listing')); }
public function subscriptionHistory() { $obj = new helpers(); if (!$obj->checkBrandLogin()) { return redirect('brandLogin'); } $limit = 5; // $subscription = DB::table('subscription_history')->where('member_id', Session::get('brand_userid'))->orderBy('end_date','DESC')->get(); $subscription = Subscription::with('getSubMembers')->where("member_id", Session::get('brand_userid'))->orderBy('end_date', 'DESC')->paginate($limit); $brand = Brandmember::find(Session::get('brand_userid')); return view('frontend.brand.subscription_history', compact('brand', 'subscription'), array('title' => 'Subscription History')); }
public function showAllCart() { /*----- Only Member Will Access This Page ----*/ $obj = new helpers(); if (!$obj->checkMemberLogin() && $obj->checkBrandLogin()) { return redirect('home'); } //$content = Cart::content(); $content = $obj->content(); //echo "<pre>";print_r($content);exit; /* Site Setting Start */ $sitesettings = DB::table('sitesettings')->get(); $all_sitesetting = array(); foreach ($sitesettings as $each_sitesetting) { $all_sitesetting[$each_sitesetting->name] = $each_sitesetting->value; } foreach ($content as $each_content) { $product_res = DB::table('products')->where('id', $each_content->id)->first(); // echo $each_content->brandmember_id; exi $brandmember = DB::table('products')->leftJoin('brandmembers', 'brandmembers.id', '=', 'products.brandmember_id')->select('products.*', 'brandmembers.fname', 'brandmembers.lname', 'brandmembers.username', 'brandmembers.slug', 'brandmembers.pro_image', 'brandmembers.brand_details', 'brandmembers.brand_sitelink', 'brandmembers.status', 'brandmembers.admin_status')->where('products.id', '=', $each_content->id)->first(); //echo "<pre>";print_r($brandmember); //echo $brandmember->slug ; exit; $brand_name = $brandmember->fname ? $brandmember->fname . ' ' . $brandmember->lname : $brandmember->username; $formfactor = DB::table('form_factors')->where('id', '=', $each_content->options->form_factor)->first(); $formfactor_name = $formfactor->name; $formfactor_id = $formfactor->id; /* Discount Share Start */ // $user_share = DB::table('product_shares') // ->where('user_email','=',Session::get('member_user_email')) // ->where('product_id','=',$each_content->id) // ->count(); //print_r($user_share); exit; if (Session::has('product_id')) { $share_discount = $all_sitesetting['discount_share']; } else { $share_discount = ''; } /* Discount Share End */ $cart_result[] = array('rowid' => $each_content->rowid, 'product_name' => $each_content->name, 'product_slug' => $brandmember->product_slug, 'product_image' => $product_res->image1, 'qty' => $each_content->qty, 'price' => $each_content->price, 'duration' => $each_content->options->duration, 'formfactor_name' => $formfactor_name, 'formfactor_id' => $formfactor_id, 'brand_name' => $brand_name, 'brand_slug' => $brandmember->slug, 'share_discount' => $share_discount, 'subtotal' => $each_content->subtotal); } $cartcontent = Cart::content(); $member = array(); $redemctrl = array("min" => 5, "max" => 100, "step" => 5); if (Session::has('member_userid')) { $member = DB::table('brandmembers')->where("id", Session::get('member_userid'))->first(); $setting_point = DB::table('sitesettings')->where('name', 'points_for_price')->first(); $step = $member->user_points; $redemctrl = array("min" => $setting_point->value, "max" => $step, "step" => $setting_point->value); } return view('frontend.product.showAllCart', compact('cart_result', 'cartcontent', 'member', 'redemctrl'), array('title' => 'cart product')); }
public function brand_login() { //echo Hash::make(123456); exit; $obj = new helpers(); if ($obj->checkMemberLogin()) { return redirect('member-dashboard'); } if ($obj->checkBrandLogin()) { return redirect('brand-dashboard'); } if (Request::isMethod('post')) { $email = Request::input('email'); $password = Request::input('password'); $users = DB::table('brandmembers')->where('email', $email)->where('role', 1)->first(); if ($users != "") { $user_pass = $users->password; // check for password if (Hash::check($password, $user_pass)) { // Check for active $user_cnt = DB::table('brandmembers')->where('email', $email)->where('status', 1)->count(); if ($user_cnt) { // Check for remember me if (Request::input('remember_me') == 1) { Cookie::queue(Cookie::make('brand_email', Request::input('email'), 60 * 24 * 30)); } Session::put('brand_userid', $users->id); Session::put('brand_user_email', $users->email); return redirect('brand-dashboard'); } else { Session::flash('error', 'Your Status is inactive. Contact Admin to activated your account'); return redirect('brandLogin'); } } else { Session::flash('error', 'Email and password does not match.'); return redirect('brandLogin'); } } else { Session::flash('error', 'Email and password does not match.'); return redirect('brandLogin'); } } // check for remenber me cookie $brand_email = ''; $brand_email = Cookie::get('brand_email'); return view('frontend.home.brand_login', compact('brand_email'), array('title' => 'MIRAMIX | Brand Login')); }
public function brand_login() { if (substr($_SERVER['SERVER_NAME'], 0, 4) != "www." && $_SERVER['SERVER_NAME'] != '192.168.1.112' && $_SERVER['SERVER_NAME'] != 'localhost') { header('Location: http://www.' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI']); } /*if( ! Request::secure() ) { return Redirect::secure( Request::path() ); }*/ $obj = new helpers(); if ($obj->checkMemberLogin()) { return redirect('member-dashboard'); } if ($obj->checkBrandLogin()) { return redirect('brand-dashboard'); } Session::put('member_type', 1); if (Request::isMethod('post')) { $email = Request::input('email'); $password = Request::input('password'); $users = DB::table('brandmembers')->where('email', $email)->where('role', 1)->first(); if ($users != "") { $user_pass = $users->password; // check for password if (Hash::check($password, $user_pass)) { // Check for active $user_cnt = DB::table('brandmembers')->where('email', $email)->where('status', 1)->count(); if ($user_cnt) { $this->check_subscription($users); // Check for remember me if (Request::input('remember_me') == 1) { Cookie::queue(Cookie::make('brand_email', Request::input('email'), 60 * 24 * 30)); } Session::put('brand_userid', $users->id); Session::put('brand_user_email', $users->email); Session::put('brand_username', ucfirst($users->username)); return redirect('brand-dashboard'); } else { Session::flash('error', 'Your Status is inactive. Contact Admin to activated your account'); return redirect('brandLogin'); } } else { Session::flash('error', 'Email and password does not match.'); return redirect('brandLogin'); } } else { Session::flash('error', 'Email and password does not match.'); return redirect('brandLogin'); } } // check for remenber me cookie $brand_email = ''; $brand_email = Cookie::get('brand_email'); $subfee = DB::table('sitesettings')->where('name', 'brand_fee')->first(); $subprofee = DB::table('sitesettings')->where('name', 'brand_perproduct_fee')->first(); return view('frontend.home.brand_login', compact('brand_email', 'subfee', 'subprofee'), array('title' => 'MIRAMIX | Brand Login')); }