コード例 #1
0
ファイル: CronController.php プロジェクト: amittier5/miramix
 public function index()
 {
     $all_brand_member = DB::table('brandmembers')->where('role', 1)->where('status', 1)->where('admin_status', 1)->get();
     DB::connection()->enableQueryLog();
     foreach ($all_brand_member as $brand) {
         $product = DB::table('products')->select(DB::raw('products.id,products.brandmember_id,products.product_name,products.product_slug,products.image1, MIN(`actual_price`) as `min_price`,MAX(`actual_price`) as `max_price`'))->leftJoin('product_formfactors', 'products.id', '=', 'product_formfactors.product_id')->where('products.brandmember_id', '=', $brand->id)->where('products.active', 1)->where('products.is_deleted', 0)->where('product_formfactors.servings', '!=', 0)->where('products.discountinue', 0)->groupBy('product_formfactors.product_id');
         $profile = MemberProfile::find($brand->id);
         if (isset($profile) && $profile->count) {
             $count = (int) $profile->count;
         } else {
             $count = 0;
         }
         $setting = DB::table('sitesettings')->where('name', 'brand_fee')->first();
         $setting2 = DB::table('sitesettings')->where('name', 'brand_perproduct_fee')->first();
         if ($count == 1) {
             $fee = $setting->value;
         } elseif ($count > 1) {
             $fee = $setting->value;
             $perproduct_fee = $setting2->value;
             $fee = $fee + $perproduct_fee * $count;
         } else {
             $fee = 0;
         }
         //echo $brand->id;
         //echo '<br />';
         $br = array('member_fee' => $fee);
         //print_r($br);
         DB::table('brandmembers')->where('id', $brand->id)->update(array('member_fee' => $fee));
     }
     foreach ($all_brand_member as $brand) {
         //echo $brand->fname;
         $subscription = DB::table('subscription_history')->where('payment_status', 'pending')->where('member_id', $brand->id)->first();
         if (count($subscription) <= 0) {
             $paidsub = DB::table('subscription_history')->where('payment_status', 'paid')->where('member_id', $brand->id)->orderBy('end_date', 'DESC')->first();
             if (count($paidsub) > 0) {
                 $start_date = $paidsub->end_date;
                 $end_date = date("Y-m-d", strtotime($start_date . ' + 30 days'));
             } else {
                 $start_date = $brand->created_at;
                 $end_date = date("Y-m-d", strtotime($start_date . ' + 30 days'));
             }
             $setting = DB::table('sitesettings')->where('name', 'brand_fee')->first();
             $subdata = array("member_id" => $brand->id, "start_date" => $start_date, "end_date" => $end_date, "subscription_fee" => $brand->member_fee);
             Subscription::create($subdata);
         } else {
             $paidsubscription = DB::table('subscription_history')->where('member_id', $brand->id)->orderBy('end_date', 'DESC')->first();
             if (is_object($paidsubscription) && $paidsubscription->end_date <= date("Y-m-d") && $paidsubscription->payment_status == 'paid') {
                 echo 'subid-' . $paidsubscription->subscription_id . '- paid in prev month <br />';
             } else {
                 $today = Date('Y-m-d');
                 $enddate = date("Y-m-d", strtotime($subscription->end_date . " + 1 day"));
                 if ($enddate <= $today) {
                     //charge here
                     if (empty($brand->auth_profile_id)) {
                         continue;
                     }
                     echo "will be charged " . $subscription->member_id . '<br />';
                     // Create Auth & Capture Transaction
                     $request = new AuthorizeNetCIM();
                     $transaction = new AuthorizeNetTransaction();
                     $transaction->amount = $brand->member_fee;
                     $transaction->customerProfileId = $brand->auth_profile_id;
                     $transaction->customerPaymentProfileId = $brand->auth_payment_profile_id;
                     $transaction->customerShippingAddressId = $brand->auth_address_id;
                     $lineItem = new AuthorizeNetLineItem();
                     $lineItem->itemId = $subscription->subscription_id;
                     $lineItem->name = $brand->fname;
                     $lineItem->description = $brand->fname . " charged for subscription of " . $subscription->start_date;
                     $lineItem->quantity = "1";
                     $lineItem->unitPrice = $brand->member_fee;
                     $lineItem->taxable = "false";
                     $transaction->lineItems[] = $lineItem;
                     $response = $request->createCustomerProfileTransaction("AuthCapture", $transaction);
                     $updateWithCode = DB::table('brandmembers')->where('id', '=', $subscription->member_id)->update(array('subscription_status' => 'expired'));
                     if ($response->isOk()) {
                         $transactionResponse = $response->getTransactionResponse();
                         $transactionId = $transactionResponse->transaction_id;
                         $subdata = array("transaction_id" => $transactionResponse->transaction_id, "payment_status" => 'paid');
                         $sub = DB::table('subscription_history')->where('subscription_id', $subscription->subscription_id)->update($subdata);
                         $updateWithCode = DB::table('brandmembers')->where('id', '=', $subscription->member_id)->update(array('subscription_status' => 'active'));
                     } else {
                         print_r($response);
                     }
                 }
             }
         }
     }
     $this->onlineusers();
 }
コード例 #2
0
 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;
 }