public function contactUs() { $member1 = Session::get('brand_userid'); $member2 = Session::get('member_userid'); if (!empty($member1)) { $memberdetail = Brandmember::find($member1); } elseif (!empty($member2)) { $memberdetail = Brandmember::find($member2); } else { $memberdetail = (object) array("email" => "", "fname" => "", "lname" => ""); } if (Request::isMethod('post')) { $user_name = Request::input('contact_name'); $user_email = Request::input('contact_email'); $subject = Request::input('contact_subject'); $cmessage = Request::input('message'); $setting = DB::table('sitesettings')->where('name', 'email')->first(); $admin_users_email = $setting->value; $sent = Mail::send('frontend.cms.contactemail', array('name' => $user_name, 'email' => $user_email, 'messages' => $cmessage), function ($message) use($admin_users_email, $user_email, $user_name) { $message->from($admin_users_email); $message->to($user_email, $user_name)->cc($admin_users_email)->subject(Request::input('contact_subject')); }); if (!$sent) { Session::flash('error', 'something went wrong!! Mail not sent.'); return redirect('contact-us'); } else { Session::flash('success', 'Message is sent to admin successfully. We will getback to you shortly'); return redirect('contact-us'); } } return view('frontend.cms.contactus', compact('memberdetail'), array('title' => 'Miramix - Contact Us')); }
public function admin_inactive_status($id) { //echo $id;exit; $brandmember = Brandmember::find($id); $brandmember->admin_status = 0; $brandmember->update(); //dd($brandmember);exit; Session::flash('success', 'Member status updated successfully'); return redirect('admin/member'); }
/** * Display a listing of the resource. * * @return Response */ public function inventory() { $member1 = Session::get('brand_userid'); if (!empty($member1)) { $memberdetail = Brandmember::find($member1); } else { $memberdetail = (object) array("email" => "", "fname" => "", "lname" => ""); } if (Request::isMethod('post')) { $name = Request::input('name'); $ingradient_name = Request::input('ingradient_name'); $user_email = Request::input('contact_email'); $subject = 'Request for ingredient'; $cmessage = Request::input('request_ing'); $setting = DB::table('sitesettings')->where('name', 'email')->first(); $admin_users_email = $setting->value; $sent = Mail::send('frontend.inventory.ingredientemail', array('admin_users_email' => $admin_users_email, 'name' => $name, 'ingradient_name' => $ingradient_name, 'email' => $user_email, 'messages' => $cmessage), function ($message) use($admin_users_email, $user_email, $ingradient_name, $subject) { $message->from($admin_users_email); $message->to($user_email, $ingradient_name)->cc($admin_users_email)->subject($subject); }); if (!$sent) { Session::flash('error', 'something went wrong!! Mail not sent.'); return redirect('inventory'); } else { Session::flash('success', 'Message is sent to admin successfully. We will getback to you shortly'); return redirect('inventory'); } } $start = 'a'; $end = 'z'; $pageindex = array(); for ($i = $start; $i < $end; $i++) { $inv = DB::table('ingredients')->whereRaw(" name like '" . $i . "%'")->orderBy('name', 'ASC')->get(); $pageindex[$i] = $inv; } $inv = DB::table('ingredients')->whereRaw(" name like 'z%'")->orderBy('name', 'ASC')->get(); $pageindex['z'] = $inv; return view('frontend.inventory.inventory', compact('pageindex', 'memberdetail'), array('title' => 'Miramix Inventory')); }
public function productDetails($slug) { // Check if brand subscription expires show message $pro_dtls = DB::table('products')->where('product_slug', $slug)->first(); if (!empty($pro_dtls)) { $pro_brand_memid = $pro_dtls->brandmember_id; $brand_details = Brandmember::find($pro_brand_memid); if ($brand_details->subscription_status != "active") { Session::flash('error', 'Subscription is over of this brand.'); if (Session::has('brand_userid')) { return redirect('my-products'); } else { return redirect('brand'); } } } // echo $brand_details->subscription_status;exit; //$content = Cart::content();echo "<pre>";print_r($content);exit; $productdetails = DB::table('products')->leftJoin('brandmembers', 'brandmembers.id', '=', 'products.brandmember_id')->select('products.*', 'brandmembers.fname', 'brandmembers.lname', 'brandmembers.business_name', 'brandmembers.pro_image', 'brandmembers.brand_details', 'brandmembers.brand_sitelink', 'brandmembers.status', 'brandmembers.admin_status', 'brandmembers.slug')->where('products.product_slug', '=', $slug)->where('products.active', 1)->where('products.is_deleted', 0)->where('brandmembers.status', 1)->where('brandmembers.admin_status', 1)->first(); //echo "<pre/>";print_r($productdetails); exit; // Return to home page if the product is not active or deleted if (empty($productdetails)) { //return redirect('home'); return view('frontend.product.restrictproductdetails', array('title' => 'Not Authorize Product Details')); } $productformfactor = DB::table('product_formfactors')->join('form_factors', 'form_factors.id', '=', 'product_formfactors.formfactor_id')->join('products', 'products.id', '=', 'product_formfactors.product_id')->select('product_formfactors.*', 'form_factors.name', 'form_factors.image', 'form_factors.price', 'form_factors.maximum_weight', 'form_factors.minimum_weight', 'products.product_name')->where('product_formfactors.product_id', '=', $productdetails->id)->where('product_formfactors.actual_price', '!=', 0)->where('products.active', 1)->orderBy('form_factors.name', 'asc')->get(); // echo print_r(DB::enableQueryLog()); exit; //echo "<pre/>";print_r($productformfactor);exit; $timeduration = DB::table('time_durations')->where('status', 1)->get(); $rating = DB::table('product_rating')->leftJoin('brandmembers', 'brandmembers.id', '=', 'product_rating.user_id')->select('product_rating.*', 'brandmembers.username')->where('product_rating.status', 1)->where('product_rating.product_id', $productdetails->id)->get(); $product_id = $productdetails->id; // Get Related Product $related_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.active', 1)->where('product_formfactors.actual_price', '!=', 0)->where('products.is_deleted', 0)->where('products.related', 'yes')->groupBy('product_formfactors.product_id')->get(); //echo "<pre/>";print_r($related_product); exit; return view('frontend.product.productdetails', compact('productdetails', 'productformfactor', 'timeduration', 'rating', 'product_id', 'related_product'), array('title' => 'Product Details')); }
public function editMemberShippingAddress() { $obj = new helpers(); if (!$obj->checkMemberLogin()) { return redirect('memberLogin'); } $id = Request::input('id'); if (empty($id)) { return redirect('member-shipping-address'); } $country = DB::table('countries')->orderBy('name', 'ASC')->get(); $alldata = array(); foreach ($country as $key => $value) { $alldata[$value->country_id] = $value->name; } if (Request::isMethod('post')) { $address = array(); $address['mem_brand_id'] = Session::get('member_userid'); $address['first_name'] = Request::input('first_name'); $address['last_name'] = Request::input('last_name'); $address['address'] = Request::input('address'); $address['address2'] = Request::input('address2'); $address['country_id'] = Request::input('country'); $address['zone_id'] = Request::input('zone_id'); // State id $address['city'] = Request::input('city'); $address['postcode'] = Request::input('postcode'); $address['phone'] = Request::input('phone'); $address['email'] = Request::input('email'); DB::table('addresses')->where('id', Request::input('id'))->update($address); if (Request::input('default_address') == '1') { $addressId = Request::input('id'); $dataUpdateAddress = DB::table('brandmembers')->where('id', Session::get('member_userid'))->update(['address' => $addressId]); } Session::flash('success', 'Shipping Address successfully updated.'); return redirect('member-shipping-address'); } $address = DB::table('addresses')->find($id); $states = DB::table('zones')->where('country_id', $address->country_id)->orderBy('name', 'ASC')->get(); $allstates = array(); foreach ($states as $key => $value) { $allstates[$value->zone_id] = $value->name; } $member_details = Brandmember::find(Session::get('member_userid')); $total_add = DB::table('addresses')->where('mem_brand_id', Session::get('member_userid'))->where('id', '!=', $id)->count(); return view('frontend.member.edit_member_shipping', compact('alldata', 'address', 'allstates', 'member_details', 'total_add'), array('title' => 'Edit Shipping Address')); }
public function sendpasswordmail() { //return false; $members = DB::table('brandmembers')->whereRaw('CHAR_LENGTH(password)<1')->get(); foreach ($members as $member) { $brand = array(); $fname = explode(" ", $member->fname); if (isset($fname[0]) && isset($fname[1])) { $brand = array("fname" => trim($fname[0]), "lname" => trim($fname[1])); } //echo $member->id;exit; $brandresult = Brandmember::find($member->id); $orgpass = uniqid(); $password = Hash::make($orgpass); $brand["password"] = $password; $brand["status"] = '1'; $brand["admin_status"] = '1'; $brandresult->update($brand); $sitesettings = DB::table('sitesettings')->where("name", "email")->first(); $admin_users_email = $sitesettings->value; $user_name = $member->fname . ' ' . $member->lname; $user_email = $member->email; if ($member->role == 0) { $activateLink = 'http://www.miramix.com/memberLogin/'; $changepass_link = 'http://www.miramix.com/member-changepass/'; } else { $activateLink = 'http://www.miramix.com/brandlogin/'; $changepass_link = 'http://www.miramix.com/change-password/'; } $pass = $orgpass; $userid = $member->email; $sent = Mail::send('frontend.register.newPassword', array('name' => $user_name, 'email' => $user_email, 'activate_link' => $activateLink, 'userid' => $userid, 'admin_users_email' => $admin_users_email, 'password' => $pass, 'changepass_link' => $changepass_link), function ($message) use($admin_users_email, $user_email, $user_name) { $message->from($admin_users_email); $message->to($user_email, $user_name)->subject('New password generated for site migration'); }); if (!$sent) { echo 'Unable to send email' . $member->id . ' <br />'; } else { echo 'mail sent to ->' . $member->id . $member->email . "<br />"; } } echo count($members); }
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 delete_product($id) { // Check if brand subscription expires show message $brand_details = Brandmember::find(Session::get('brand_userid')); if ($brand_details->subscription_status != "active") { Session::flash('error', 'Your subscription is over. Subscribe to delete products.'); return redirect('my-products'); } $product_update['id'] = $id; $product_update['discountinue'] = 1; $pro_result = Product::find($product_update['id']); $pro_result->update($product_update); Session::flash('success', 'Product deleted successfully'); return redirect('my-products'); }
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 admin_inactive_status($id) { $brandmember = Brandmember::find($id); $brandmember->admin_status = 0; $brandmember->update(); Session::flash('success', 'Brand status updated successfully'); return redirect('admin/brand'); }
public function destroy($id) { Brandmember::find($id)->delete(); Session::flash('success', 'Member deleted successfully'); return redirect('admin/member'); }
public function newsletterajax() { $email = Input::get('newsemail'); if (Session::has('member_userid')) { $member = Brandmember::find(Session::get('member_userid')); $newsletter = array("email" => $email, "fname" => $member->fname, "lname" => $member->lname, "created_on" => date("Y-m-d H:s:i"), "status" => 1); $subscriber = $member->fname == '' ? $member->username : $member->fname; $lname = $member->lname; } else { if (Session::has('brand_userid')) { $member = Brandmember::find(Session::get('brand_userid')); $newsletter = array("email" => $email, "fname" => $member->fname, "lname" => $member->lname, "created_on" => date("Y-m-d H:s:i"), "status" => 1); $subscriber = $member->fname; $lname = $member->lname; } else { $newsletter = array("email" => $email, "fname" => 'guest', "lname" => 'guest', "created_on" => date("Y-m-d H:s:i"), "status" => 1); $subscriber = 'subscriber'; $lname = ''; } } $setting = DB::table('sitesettings')->where('name', 'email')->first(); $admin_users_email = $setting->value; $countexists = DB::table('newsletter_subscription')->where('email', '=', $email)->count(); if ($countexists > 0) { $result = array("message" => "You have already subscribed.", "status" => "fail"); } else { $sitesettings = DB::table('sitesettings')->get(); $all_sitesetting = array(); foreach ($sitesettings as $each_sitesetting) { $all_sitesetting[$each_sitesetting->name] = $each_sitesetting->value; } //print_r($all_sitesetting); exit; $merge_vars = array('OPTIN_IP' => $_SERVER['REMOTE_ADDR'], 'OPTIN-TIME' => "now", 'FNAME' => ucwords(strtolower(trim($subscriber))), 'LNAME' => ucwords(strtolower(trim($lname))), 'COMPANY' => ucwords(strtolower(trim(""))), 'ORGTYPE' => ucwords(strtolower(trim(""))), 'PLANNING' => strtolower(trim("Unknown"))); $send_data = array('email' => array('email' => $email), 'apikey' => $all_sitesetting['mailchimp_api_key'], 'id' => $all_sitesetting['mailchimp_list_id'], 'merge_vars' => $merge_vars, 'double_optin' => false, 'send_welcome' => false, 'email_type' => "html"); $payload = json_encode($send_data); //$submit_url="https://api.mailchimp.com/2.0/lists/subscribe.json"; $submit_url = $all_sitesetting['mailchimp_url']; //"https://us8.api.mailchimp.com/2.0/lists/subscribe.json"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $submit_url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_POSTFIELDS, $payload); $result = curl_exec($ch); curl_close($ch); $mcdata = json_decode($result); if (empty($mcdata->error)) { $newsletterres = Newsletter::create($newsletter); $result = array("message" => "You have successfully subscribed.", "status" => "success"); } else { echo $mcdata->error; $result = array("message" => "Newsletter subscription fails.", "status" => "fail"); } // $sent = Mail::send('frontend.home.newsletter', array('admin_users_email'=>$admin_users_email,'subscriber'=>$subscriber), // function($message) use ($admin_users_email,$email) // { // $message->from($admin_users_email); //support mail // $message->to($email)->subject('Miramix Subscription Mail'); // }); } echo json_encode($result); }
public function admin_inactive_status($id) { $brandmember = Brandmember::find($id); $brandmember->admin_status = 0; $brandmember->update(); $sitesettings = DB::table('sitesettings')->where("name", "email")->first(); $admin_users_email = $sitesettings->value; if ($brandmember->fname != '') { $user_name = $brandmember->fname . ' ' . $brandmember->lname; } else { $user_name = $brandmember->username; } $user_email = $brandmember->email; $msg = "Your account has been de-activated by admin.Please contact with miramix support."; $sent = Mail::send('admin.brands.activate_brand', array('name' => $user_name, 'email' => $user_email, 'admin_users_email' => $admin_users_email, 'msg' => $msg), function ($message) use($admin_users_email, $user_email, $user_name, $msg) { $message->from($admin_users_email); $message->to($user_email, $user_name)->subject('Miramix Brand Account Now Deactivated'); }); if (!$sent) { Session::flash('error', 'something went wrong!! Mail not sent.'); return redirect('admin/brand'); } else { Session::flash('success', 'Brand status updated successfully'); return redirect('admin/brand'); } }
public function store(Request $request) { $obj = new helpers(); //echo "<pre>";print_r(Request::all());exit; 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, 380, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName1, 109, 89, $destinationPath, $medium); } else { $fileName1 = ''; } 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, 380, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName2, 109, 89, $destinationPath, $medium); } else { $fileName2 = ''; } 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, 380, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName3, 109, 89, $destinationPath, $medium); } else { $fileName3 = ''; } 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, 380, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName4, 109, 89, $destinationPath, $medium); } else { $fileName4 = ''; } 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, 380, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName5, 109, 89, $destinationPath, $medium); } else { $fileName5 = ''; } 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, 380, 270, $destinationPath, $home_thumb_path); $obj->createThumbnail($fileName6, 109, 89, $destinationPath, $medium); } else { $fileName6 = ''; } if (Input::hasFile('label')) { $destinationPath = 'uploads/product/'; // upload path $thumb_path = 'uploads/product/thumb/'; $medium = 'uploads/product/medium/'; $extension = Input::file('label')->getClientOriginalExtension(); // getting image extension $label = rand(111111111, 999999999) . '.' . $extension; // renameing image Input::file('label')->move($destinationPath, $label); // uploading file to given path $this->obj->createThumbnail($label, 600, 650, $destinationPath, $thumb_path); $this->obj->createThumbnail($label, 109, 89, $destinationPath, $medium); } else { $label = Request::input('hidden_label'); } $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['label'] = $label; $product['description1'] = htmlentities(Request::input('description1')); $product['description2'] = htmlentities(Request::input('description2')); $product['description3'] = htmlentities(Request::input('description3')); $product['brandmember_id'] = Request::input('brandmember_id'); $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"); // Create Product $product_row = Product::create($product); $lastinsertedId = $product_row->id; // ++++++++++++++++++++++++++ Logic for insert brand name and tags in tag table +++++++++++++++++++++++++++++++++++++ $ii = 0; $allTags = array(); 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(Request::input('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' => $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', '=', Request::input('brandmember_id'))->first(); $row1 = array(); if (!empty($row)) { $count = $row->count + 1; MemberProfile::where('brandmember_id', '=', Request::input('brandmember_id'))->update(['count' => $count]); } else { $count = 1; $row1['count'] = $count; $row1['brandmember_id'] = Request::input('brandmember_id'); MemberProfile::create($row1); } Session::flash('success', 'Product added successfully'); return redirect('admin/product-list/0'); }