public function checkoutStep4() { $obj = new helpers(); $shp_address = array(); $sitesettings = DB::table('sitesettings')->get(); if (!empty($sitesettings)) { foreach ($sitesettings as $each_sitesetting) { if ($each_sitesetting->name == 'shipping_rate') { $shipping_rate = (double) $each_sitesetting->value; } if ($each_sitesetting->name == 'free_discount_rate') { $free_discount_rate = (double) $each_sitesetting->value; } } } if (Request::isMethod('post')) { Session::put('name_card', Input::get('name_card')); //Input::get('name_card'); Session::put('card_number', Input::get('card_number')); //Input::get('card_number'); //"4042760173301988";// Session::put('card_exp_month', Input::get('card_exp_month')); // "03"; // Session::put('card_exp_year', Input::get('card_exp_year')); // "19"; // //checkout as guest if (!Session::has('member_userid')) { $guestdata = Session::get('guest_array'); $shiping_address = array('address_title' => 'default address', 'first_name' => $guestdata["guest_fname"], 'last_name' => $guestdata["guest_lname"], 'email' => $guestdata["guest_email"], 'phone' => $guestdata["guest_phone"], 'address' => $guestdata["guest_address"], 'address2' => $guestdata["guest_address2"], 'city' => $guestdata["guest_city"], 'zone_id' => $guestdata["guest_state"], 'country_id' => $guestdata["guest_country_id"], 'postcode' => $guestdata["guest_zip_code"]); $want_reg = Request::input('register_user'); if ($want_reg == 'register') { //register the member Session::put('guest_username_sess', Request::input('guest_username')); $brandmember = Brandmember::create(['fname' => $guestdata['guest_fname'], 'lname' => $guestdata['guest_lname'], 'email' => $guestdata['guest_email'], 'username' => Request::input('guest_username'), 'password' => Hash::make(Request::input('guest_password')), 'role' => 0, 'admin_status' => 1, 'status' => 1, 'updated_at' => date('Y-m-d H:i:s'), 'created_at' => date('Y-m-d H:i:s')]); $lastInsertedId = $brandmember->id; $shiping_address['mem_brand_id'] = $brandmember->id; $shp_address = Address::create($shiping_address); $lastAddressId = DB::getPdo()->lastInsertId(); $user_id = $brandmember->id; // Update Address id in brandmember table $addressId = $shp_address->id; $dataUpdateAddress = DB::table('brandmembers')->where('id', $brandmember->id)->update(['address' => $addressId]); } else { //set userid for not loggedin users to pass the order $user_id = NULL; $shp_address['id'] = NULL; $shp_address = (object) $shp_address; //print_r($shp_address); exit; } // End of registration ================================================== /* To get the country code And Zone code */ $shp_country = DB::table('countries')->where('country_id', $guestdata["guest_country_id"])->first(); $shp_zone = DB::table('zones')->where('zone_id', $guestdata["guest_state"])->first(); $shiping_address = array('address_title' => 'default address', 'first_name' => $guestdata["guest_fname"], 'last_name' => $guestdata["guest_lname"], 'email' => $guestdata["guest_email"], 'phone' => $guestdata["guest_phone"], 'address' => $guestdata["guest_address"], 'address2' => $guestdata["guest_address2"], 'city' => $guestdata["guest_city"], 'zone_id' => $shp_zone->code, 'country_id' => $shp_country->iso_code_3, 'postcode' => $guestdata["guest_zip_code"]); //print_r($shiping_address); exit; $shiping_address_serial = serialize($shiping_address); } else { //for logged-in users $shp_address = DB::table('addresses')->leftjoin('countries', 'countries.country_id', '=', 'addresses.country_id')->leftjoin('zones', 'zones.zone_id', '=', 'addresses.zone_id')->select('addresses.*', 'countries.name as country_name', 'countries.iso_code_3 as country_code', 'zones.name as zone_name', 'zones.code as zone_code')->where('mem_brand_id', Session::get('member_userid'))->where('id', Session::get('selected_address_id'))->first(); //echo "<pre>111111";print_r($shp_address); exit; // 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_code, 'country_id' => $shp_address->country_code, 'postcode' => $shp_address->postcode); $shiping_address_serial = serialize($shiping_address); //echo "pm= ".Session::get('payment_method'); exit; $user_id = Session::get('member_userid'); } $order = Order::create(['order_total' => Request::input('grand_total'), 'sub_total' => Request::input('sub_total'), 'discount' => Request::input('discount'), 'redeem_amount' => Request::input('redeem_amount'), 'order_status' => 'pending', 'shipping_address_id' => $shp_address->id, 'shipping_cost' => Request::input('shipping_rate'), 'shipping_type' => 'flat', 'user_id' => $user_id, '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; $obj = new helpers(); $order_number = 'ORD-' . $obj->random_string(5) . '-' . $last_order_id; // Generate random String for order number $update_order_number = DB::table('orders')->where('id', $last_order_id)->update(['order_number' => $order_number]); Session::put('order_number', $order_number); Session::put('order_id', $last_order_id); ///we are not storing new registered cart in cart table as it will be destroyed soon if (Session::has('member_userid')) { $allCart = DB::table('carts')->where('user_id', Session::get('member_userid'))->get(); } else { $allCart = $obj->content(); foreach ($allCart as $each_content) { $each_content->product_id = $each_content->id; $each_content->form_factor = $each_content->options->form_factor; $each_content->row_id = $each_content->rowid; $each_content->product_name = $each_content->name; $each_content->quantity = $each_content->qty; $each_content->amount = $each_content->price; $each_content->duration = $each_content->options->duration; $each_content->sub_total = $each_content->subtotal; $each_content->no_of_days = $each_content->options->no_of_days; } } 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.email', '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, 'brand_email' => $brandmember_deatils->email, '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, 'duration' => $eachCart->duration, 'no_of_days' => $eachCart->no_of_days]); //All Cart deleted from cart table after inserting all data to order and order_item table. if (Session::has('member_userid')) { $deleteCart = DB::table('carts')->where('user_id', '=', Session::get('member_userid'))->delete(); } Cart::destroy(); // After inserting all cart data into Order and Order_item Table database } //set points for users on purchase 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); } } //end of post /* // 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')); */ }
public function productPost(Request $request) { $obj = new helpers(); //echo "<pre>";print_r(Request::all());exit; // Update Old Product to discontinue product $product_update['id'] = Request::input('product_id'); $product_update['discountinue'] = 1; $pro_result = Product::find($product_update['id']); $pro_result->update($product_update); if (Input::hasFile('image1')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image1')->getClientOriginalExtension(); // getting image extension $fileName1 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image1')->move($destinationPath, $fileName1); // uploading file to given path $obj->createThumbnail($fileName1, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 109, 89, $destinationPath, $medium); // Delete old image // @unlink('uploads/product/'.Request::input('hidden_image1')); // @unlink('uploads/product/thumb/'.Request::input('hidden_image1')); // @unlink('uploads/product/medium/'.Request::input('hidden_image1')); } else { $fileName1 = Request::input('hidden_image1'); } if (Input::hasFile('image2')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image2')->getClientOriginalExtension(); // getting image extension $fileName2 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image2')->move($destinationPath, $fileName2); // uploading file to given path $obj->createThumbnail($fileName2, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName2, 109, 89, $destinationPath, $medium); } else { $fileName2 = Request::input('hidden_image2'); } if (Input::hasFile('image3')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image3')->getClientOriginalExtension(); // getting image extension $fileName3 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image3')->move($destinationPath, $fileName3); // uploading file to given path $obj->createThumbnail($fileName3, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName3, 109, 89, $destinationPath, $medium); } else { $fileName3 = Request::input('hidden_image3'); } if (Input::hasFile('image4')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image4')->getClientOriginalExtension(); // getting image extension $fileName4 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image4')->move($destinationPath, $fileName4); // uploading file to given path $obj->createThumbnail($fileName4, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName4, 109, 89, $destinationPath, $medium); } else { $fileName4 = Request::input('hidden_image4'); } if (Input::hasFile('image5')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image5')->getClientOriginalExtension(); // getting image extension $fileName5 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image5')->move($destinationPath, $fileName5); // uploading file to given path $obj->createThumbnail($fileName5, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName5, 109, 89, $destinationPath, $medium); } else { $fileName5 = Request::input('hidden_image5') != '' ? Request::input('hidden_image5') : ''; } if (Input::hasFile('image6')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image6')->getClientOriginalExtension(); // getting image extension $fileName6 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image6')->move($destinationPath, $fileName6); // uploading file to given path $obj->createThumbnail($fileName6, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName6, 109, 89, $destinationPath, $medium); } else { $fileName6 = Request::input('hidden_image6'); } $product['product_name'] = Request::input('product_name'); $product['product_slug'] = $obj->create_slug(Request::input('product_name'), 'products', 'product_slug'); $product['image1'] = $fileName1; $product['image2'] = $fileName2; $product['image3'] = $fileName3; $product['image4'] = $fileName4; $product['image5'] = $fileName5; $product['image6'] = $fileName6; $product['description1'] = htmlentities(Request::input('description1')); $product['description2'] = htmlentities(Request::input('description2')); $product['description3'] = htmlentities(Request::input('description3')); $product['brandmember_id'] = Session::get('brand_userid'); //$product['brandmember_id'] = 33; $product['tags'] = Request::input('tags'); $product['sku'] = $obj->random_string(9); $product['script_generated'] = '<a href="' . url() . '/product-details/' . $product['product_slug'] . '" style="color: #FFF;background: #78d5e5 none repeat scroll 0% 0%;padding: 10px 20px;font-weight: 400;font-size: 12px;line-height: 25px;text-shadow: none;border: 0px none;text-transform: uppercase;font-weight: 200;vertical-align: middle;box-shadow: none;display: block;float: left;" onMouseOver="this.style.backgroundColor=\'#afc149\'" onMouseOut="this.style.backgroundColor=\'#78d5e5\'">Buy Now</a>'; $product['created_at'] = date("Y-m-d H:i:s"); //echo "<pre>";print_r($product);exit; // Create Product $product_row = Product::create($product); $lastinsertedId = $product_row->id; // Create Product Ingredient group if (NULL != Request::input('ingredient_group')) { foreach (Request::input('ingredient_group') as $key => $value) { $arr = array('product_id' => $lastinsertedId, 'group_name' => $value['group_name']); $pro_ing_grp = ProductIngredientGroup::create($arr); $group_id = $pro_ing_grp->id; if (NULL != $value['ingredient']) { foreach ($value['ingredient'] as $key1 => $next_value) { $arr_next = array('product_id' => $lastinsertedId, 'ingredient_id' => $next_value['ingredient_id'], 'weight' => $next_value['weight'], 'ingredient_price' => $next_value['ingredient_price'], 'ingredient_group_id' => $group_id); ProductIngredient::create($arr_next); } } } } // Create Product Ingredient foreach (Request::input('ingredient') as $key2 => $ing_value) { $arr_next = array('product_id' => $lastinsertedId, 'ingredient_id' => $ing_value['id'], 'weight' => $ing_value['weight'], 'ingredient_price' => $ing_value['ingredient_price'], 'ingredient_group_id' => 0); ProductIngredient::create($arr_next); } // Add Ingredient form factor foreach (Request::input('formfactor') as $key3 => $formfactor_value) { $arr_pro_fac = array('product_id' => $lastinsertedId, 'formfactor_id' => $formfactor_value['formfactor_id'], 'servings' => $formfactor_value['servings'], 'min_price' => $formfactor_value['min_price'], 'recomended_price' => $formfactor_value['recomended_price'], 'actual_price' => $formfactor_value['actual_price']); ProductFormfactor::create($arr_pro_fac); } // Add Ingredient form factor for available form factor if (Request::input('excluded_val') != "") { $all_form_factor_ids = rtrim(Request::input('excluded_val'), ","); $all_ids = explode(",", $all_form_factor_ids); foreach ($all_ids as $key => $value) { $arr_pro_factor = array('product_id' => $lastinsertedId, 'formfactor_id' => $value); ProductFormfactor::create($arr_pro_factor); } } Session::flash('success', 'Product updated successfully'); return redirect('my-products'); //exit; }
public function productPost(Request $request) { $obj = new helpers(); //echo "<pre>";print_r(Request::all());exit; if (Request::input('own_product') == 1) { if (Input::hasFile('image1')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image1')->getClientOriginalExtension(); // getting image extension $fileName1 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image1')->move($destinationPath, $fileName1); // uploading file to given path $obj->createThumbnail($fileName1, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName1, 109, 89, $destinationPath, $medium); } else { $fileName1 = Request::input('hidden_image1'); } if (Input::hasFile('image2')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image2')->getClientOriginalExtension(); // getting image extension $fileName2 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image2')->move($destinationPath, $fileName2); // uploading file to given path $obj->createThumbnail($fileName2, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName2, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName2, 109, 89, $destinationPath, $medium); } else { $fileName2 = Request::input('hidden_image2'); } if (Input::hasFile('image3')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image3')->getClientOriginalExtension(); // getting image extension $fileName3 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image3')->move($destinationPath, $fileName3); // uploading file to given path $obj->createThumbnail($fileName3, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName3, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName3, 109, 89, $destinationPath, $medium); } else { $fileName3 = Request::input('hidden_image3'); } if (Input::hasFile('image4')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image4')->getClientOriginalExtension(); // getting image extension $fileName4 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image4')->move($destinationPath, $fileName4); // uploading file to given path $obj->createThumbnail($fileName4, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName4, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName4, 109, 89, $destinationPath, $medium); } else { $fileName4 = Request::input('hidden_image4'); } if (Input::hasFile('image5')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image5')->getClientOriginalExtension(); // getting image extension $fileName5 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image5')->move($destinationPath, $fileName5); // uploading file to given path $obj->createThumbnail($fileName5, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName5, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName5, 109, 89, $destinationPath, $medium); } else { $fileName5 = Request::input('hidden_image5') != '' ? Request::input('hidden_image5') : ''; } if (Input::hasFile('image6')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image6')->getClientOriginalExtension(); // getting image extension $fileName6 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image6')->move($destinationPath, $fileName6); // uploading file to given path $obj->createThumbnail($fileName6, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName6, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName6, 109, 89, $destinationPath, $medium); } else { $fileName6 = Request::input('hidden_image6'); } $lastinsertedId = $id = Request::input('product_id'); $product = Product::find(Request::input('product_id')); $product['id'] = Request::input('product_id'); $product['own_product'] = Request::input('own_product'); $product['product_name'] = Request::input('product_name'); $product['product_slug'] = $obj->edit_slug($product['product_name'], 'products', 'product_slug', Request::input('product_id')); $product['image1'] = $fileName1; $product['image2'] = $fileName2; $product['image3'] = $fileName3; $product['image4'] = $fileName4; $product['image5'] = $fileName5; $product['image6'] = $fileName6; $product['description1'] = htmlentities(Request::input('description1')); $product['description2'] = htmlentities(Request::input('description2')); $product['description3'] = htmlentities(Request::input('description3')); $product['tags'] = Request::input('tags'); $product['script_generated'] = '<a href="' . url() . '/product-details/' . $product['product_slug'] . '" style="color: #FFF;background: #78d5e5 none repeat scroll 0% 0%;padding: 10px 20px;font-weight: 400;font-size: 12px;line-height: 25px;text-shadow: none;border: 0px none;text-transform: uppercase;font-weight: 200;vertical-align: middle;box-shadow: none;display: block;float: left;" onMouseOver="this.style.backgroundColor=\'#afc149\'" onMouseOut="this.style.backgroundColor=\'#78d5e5\'">Buy Now</a>'; $product['created_at'] = date("Y-m-d H:i:s"); $product->save(); // ++++++++++++++++++++++++++ Logic for insert brand name and tags in tag table +++++++++++++++++++++++++++++++++++++ // Delete Search tags Searchtag::where('product_id', '=', $id)->delete(); $allTags = array(); $ii = 0; if ($product['tags'] != "") { $allTags = explode(",", $product['tags']); foreach ($allTags as $key => $value) { $all_data_arr[$ii]['value'] = $value; $all_data_arr[$ii]['type'] = 'tags'; $ii++; } } // get Brand Name from brand id $ii = $ii + 1; $brand_dtls = Brandmember::find($product['brandmember_id']); $brand_name = $brand_dtls['fname'] . ' ' . $brand_dtls['lname']; $all_data_arr[$ii]['value'] = $brand_name; $all_data_arr[$ii]['type'] = 'brand_name'; //Insert Into searchtags table foreach ($all_data_arr as $key => $value) { $arr = array('product_id' => $id, 'type' => $value['type'], 'name' => trim($value['value'])); Searchtag::create($arr); } // ++++++++++++++++++++ Logic for insert brand name and tags in tag table +++++++++++++++++++++++++++++++++++++ // Delete all ingredient before save new ProductIngredientGroup::where('product_id', '=', $id)->delete(); // Delete ingredient group ProductIngredient::where('product_id', '=', $id)->delete(); // Delete ingredient individual $flag = 0; if (NULL != Request::input('ingredient_group')) { foreach (Request::input('ingredient_group') as $key => $value) { // Check if that group contain atleast one ingredient if (isset($value['ingredient']) && NULL != $value['ingredient']) { foreach ($value['ingredient'] as $key1 => $next_value) { if ($next_value['ingredient_id'] != "" && $next_value['weight'] != "") { $flag = 1; break; } } } // ======================== Insert If flag==1 ===================== if ($flag == 1) { $arr = array('product_id' => $lastinsertedId, 'group_name' => $value['group_name']); $pro_ing_grp = ProductIngredientGroup::create($arr); $group_id = $pro_ing_grp->id; if (NULL != $value['ingredient']) { foreach ($value['ingredient'] as $key1 => $next_value) { if ($next_value['ingredient_id'] != "" && $next_value['weight'] != "") { $arr_next = array('product_id' => $lastinsertedId, 'ingredient_id' => $next_value['ingredient_id'], 'weight' => $next_value['weight'], 'ingredient_price' => $next_value['ingredient_price'], 'ingredient_group_id' => $group_id); ProductIngredient::create($arr_next); } } } } // ======================== Insert If flag==1 ===================== } } // Create Product Ingredient if (NULL != Request::input('ingredient')) { foreach (Request::input('ingredient') as $key2 => $ing_value) { if ($ing_value['id'] != "" && $ing_value['weight'] != "") { $arr_next = array('product_id' => $lastinsertedId, 'ingredient_id' => $ing_value['id'], 'weight' => $ing_value['weight'], 'ingredient_price' => $ing_value['ingredient_price'], 'ingredient_group_id' => 0); ProductIngredient::create($arr_next); } } } //echo "<pre>";print_r(Request::input('formfactor') );exit; // Delete all Formfactor before save new ProductFormfactor::where('product_id', '=', $id)->delete(); // Add Ingredient form factor foreach (Request::input('formfactor') as $key3 => $formfactor_value) { $arr_pro_fac = array('product_id' => $id, 'formfactor_id' => $formfactor_value['formfactor_id'], 'servings' => $formfactor_value['servings'], 'min_price' => $formfactor_value['min_price'], 'recomended_price' => $formfactor_value['recomended_price'], 'actual_price' => $formfactor_value['actual_price']); ProductFormfactor::create($arr_pro_fac); } } else { // Update Old Product to discontinue product $product_update['id'] = Request::input('product_id'); $product_update['discountinue'] = 1; $pro_result = Product::find($product_update['id']); $pro_result->update($product_update); if (Input::hasFile('image1')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image1')->getClientOriginalExtension(); // getting image extension $fileName1 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image1')->move($destinationPath, $fileName1); // uploading file to given path $obj->createThumbnail($fileName1, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName1, 109, 89, $destinationPath, $medium); // Delete old image // @unlink('uploads/product/'.Request::input('hidden_image1')); // @unlink('uploads/product/thumb/'.Request::input('hidden_image1')); // @unlink('uploads/product/medium/'.Request::input('hidden_image1')); } else { $fileName1 = Request::input('hidden_image1'); } if (Input::hasFile('image2')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image2')->getClientOriginalExtension(); // getting image extension $fileName2 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image2')->move($destinationPath, $fileName2); // uploading file to given path $obj->createThumbnail($fileName2, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName2, 109, 89, $destinationPath, $medium); } else { $fileName2 = Request::input('hidden_image2'); } if (Input::hasFile('image3')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image3')->getClientOriginalExtension(); // getting image extension $fileName3 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image3')->move($destinationPath, $fileName3); // uploading file to given path $obj->createThumbnail($fileName3, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName3, 109, 89, $destinationPath, $medium); } else { $fileName3 = Request::input('hidden_image3'); } if (Input::hasFile('image4')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image4')->getClientOriginalExtension(); // getting image extension $fileName4 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image4')->move($destinationPath, $fileName4); // uploading file to given path $obj->createThumbnail($fileName4, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName4, 109, 89, $destinationPath, $medium); } else { $fileName4 = Request::input('hidden_image4'); } if (Input::hasFile('image5')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image5')->getClientOriginalExtension(); // getting image extension $fileName5 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image5')->move($destinationPath, $fileName5); // uploading file to given path $obj->createThumbnail($fileName5, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName5, 109, 89, $destinationPath, $medium); } else { $fileName5 = Request::input('hidden_image5') != '' ? Request::input('hidden_image5') : ''; } if (Input::hasFile('image6')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $home_thumb_path = 'uploads/product/home_thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('image6')->getClientOriginalExtension(); // getting image extension $fileName6 = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('image6')->move($destinationPath, $fileName6); // uploading file to given path $obj->createThumbnail($fileName6, 771, 517, $destinationPath, $thumb_path); $obj->createThumbnail($fileName1, 580, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName6, 109, 89, $destinationPath, $medium); } else { $fileName6 = Request::input('hidden_image6'); } $product['product_name'] = Request::input('product_name'); $product['own_product'] = Request::input('own_product'); $product['product_slug'] = $obj->create_slug(Request::input('product_name'), 'products', 'product_slug'); $product['image1'] = $fileName1; $product['image2'] = $fileName2; $product['image3'] = $fileName3; $product['image4'] = $fileName4; $product['image5'] = $fileName5; $product['image6'] = $fileName6; $product['description1'] = htmlentities(Request::input('description1')); $product['description2'] = htmlentities(Request::input('description2')); $product['description3'] = htmlentities(Request::input('description3')); $product['brandmember_id'] = Session::get('brand_userid'); //$product['brandmember_id'] = 33; $product['tags'] = Request::input('tags'); $product['sku'] = $obj->random_string(9); $product['script_generated'] = '<a href="' . url() . '/product-details/' . $product['product_slug'] . '" style="color: #FFF;background: #78d5e5 none repeat scroll 0% 0%;padding: 10px 20px;font-weight: 400;font-size: 12px;line-height: 25px;text-shadow: none;border: 0px none;text-transform: uppercase;font-weight: 200;vertical-align: middle;box-shadow: none;display: block;float: left;" onMouseOver="this.style.backgroundColor=\'#afc149\'" onMouseOut="this.style.backgroundColor=\'#78d5e5\'">Buy Now</a>'; $product['created_at'] = date("Y-m-d H:i:s"); //echo "<pre>";print_r($product);exit; // Create Product $product_row = Product::create($product); $lastinsertedId = $product_row->id; // ++++++++++++++++++++++++++ Logic for insert brand name and tags in tag table +++++++++++++++++++++++++++++++++++++ if ($product['tags'] != "") { $allTags = explode(",", $product['tags']); $ii = 0; foreach ($allTags as $key => $value) { $all_data_arr[$ii]['value'] = $value; $all_data_arr[$ii]['type'] = 'tags'; $ii++; } } // get Brand Name from brand id $ii = $ii + 1; $brand_dtls = Brandmember::find(Session::get('brand_userid')); $brand_name = $brand_dtls['fname'] . ' ' . $brand_dtls['lname']; $all_data_arr[$ii]['value'] = $brand_name; $all_data_arr[$ii]['type'] = 'brand_name'; //Insert Into searchtags table foreach ($all_data_arr as $key => $value) { $arr = array('product_id' => $lastinsertedId, 'type' => $value['type'], 'name' => trim($value['value'])); Searchtag::create($arr); } // ++++++++++++++++++++ Logic for insert brand name and tags in tag table +++++++++++++++++++++++++++++++++++++ // Create Product Ingredient group $flag = 0; if (NULL != Request::input('ingredient_group')) { foreach (Request::input('ingredient_group') as $key => $value) { // Check if that group contain atleast one ingredient if (isset($value['ingredient']) && NULL != $value['ingredient']) { foreach ($value['ingredient'] as $key1 => $next_value) { if ($next_value['ingredient_id'] != "" && $next_value['weight'] != "") { $flag = 1; break; } } } // ======================== Insert If flag==1 ===================== if ($flag == 1) { $arr = array('product_id' => $lastinsertedId, 'group_name' => $value['group_name']); $pro_ing_grp = ProductIngredientGroup::create($arr); $group_id = $pro_ing_grp->id; if (NULL != $value['ingredient']) { foreach ($value['ingredient'] as $key1 => $next_value) { if ($next_value['ingredient_id'] != "" && $next_value['weight'] != "") { $arr_next = array('product_id' => $lastinsertedId, 'ingredient_id' => $next_value['ingredient_id'], 'weight' => $next_value['weight'], 'ingredient_price' => $next_value['ingredient_price'], 'ingredient_group_id' => $group_id); ProductIngredient::create($arr_next); } } } } // ======================== Insert If flag==1 ===================== } } // Create Product Ingredient foreach (Request::input('ingredient') as $key2 => $ing_value) { if ($ing_value['id'] != "" && $ing_value['weight'] != "") { $arr_next = array('product_id' => $lastinsertedId, 'ingredient_id' => $ing_value['id'], 'weight' => $ing_value['weight'], 'ingredient_price' => $ing_value['ingredient_price'], 'ingredient_group_id' => 0); ProductIngredient::create($arr_next); } } // Add Ingredient form factor foreach (Request::input('formfactor') as $key3 => $formfactor_value) { $arr_pro_fac = array('product_id' => $lastinsertedId, 'formfactor_id' => $formfactor_value['formfactor_id'], 'servings' => $formfactor_value['servings'], 'min_price' => $formfactor_value['min_price'], 'recomended_price' => $formfactor_value['recomended_price'], 'actual_price' => $formfactor_value['actual_price']); ProductFormfactor::create($arr_pro_fac); } // Add Ingredient form factor for available form factor if (Request::input('excluded_val') != "") { $all_form_factor_ids = rtrim(Request::input('excluded_val'), ","); $all_ids = explode(",", $all_form_factor_ids); foreach ($all_ids as $key => $value) { $arr_pro_factor = array('product_id' => $lastinsertedId, 'formfactor_id' => $value); ProductFormfactor::create($arr_pro_factor); } } //Add count to MemberProfile $row = MemberProfile::where('brandmember_id', '=', Session::get('brand_userid'))->first(); $row1 = array(); if (!empty($row)) { $count = $row->count + 1; MemberProfile::where('brandmember_id', '=', Session::get('brand_userid'))->update(['count' => $count]); } else { $count = 1; $row1['count'] = $count; $row1['brandmember_id'] = Session::get('brand_userid'); MemberProfile::create($row1); } } Session::flash('success', 'Product updated successfully'); return redirect('my-products'); //exit; }
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 = (double) $each_sitesetting->value; } if ($each_sitesetting->name == 'free_discount_rate') { $free_discount_rate = (double) $each_sitesetting->value; } } } if (Request::isMethod('post')) { Session::put('name_card', Input::get('name_card')); //Input::get('name_card'); Session::put('card_number', Input::get('card_number')); //Input::get('card_number'); //"4042760173301988";// Session::put('card_exp_month', Input::get('card_exp_month')); // "03"; // Session::put('card_exp_year', Input::get('card_exp_year')); // "19"; // $shp_address = DB::table('addresses')->join('countries', 'countries.country_id', '=', 'addresses.country_id')->join('zones', 'zones.zone_id', '=', 'addresses.zone_id')->select('addresses.*', 'countries.name as country_name', 'zones.name as zone_name')->where('mem_brand_id', Session::get('member_userid'))->where('id', Session::get('selected_address_id'))->first(); //echo "memid = ". Session::get('member_userid'); //echo "addid = ". Session::get('selected_address_id'); //echo "<pre>";print_r($shp_address); exit; // 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_name, 'country_id' => $shp_address->country_name, 'postcode' => $shp_address->postcode); $shiping_address_serial = serialize($shiping_address); //echo "pm= ".Session::get('payment_method'); exit; $order = Order::create(['order_total' => Request::input('grand_total'), 'sub_total' => Request::input('sub_total'), 'discount' => Request::input('discount'), '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; $obj = new helpers(); $order_number = 'ORD-' . $obj->random_string(5) . '-' . $last_order_id; // Generate random String for order number $update_order_number = DB::table('orders')->where('id', $last_order_id)->update(['order_number' => $order_number]); Session::put('order_number', $order_number); Session::put('order_id', $last_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.email', '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, 'brand_email' => $brandmember_deatils->email, '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, 'duration' => $eachCart->duration, 'no_of_days' => $eachCart->no_of_days]); //All Cart deleted from cart table after inserting all data to order and order_item table. $deleteCart = DB::table('carts')->where('user_id', '=', Session::get('member_userid'))->delete(); Cart::destroy(); // After inserting all cart data into Order and Order_item Table database } 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'); } }