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');
}
