/** * Edit Dailyspecail And Campaign Action * @param Request $request * @param $did * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View * @throws \Exception * @author: Vini Dubey<*****@*****.**> * @since: xx-xx-xxxx */ public function editDailyspecial(Request $request, $did) { $objProductCategory = ProductCategory::getInstance(); $objCampaignModel = Campaigns::getInstance(); $objProductModel = Products::getInstance(); $supplierId = Session::get('fs_supplier')['id']; if ($request->isMethod('post')) { $rules = array('campaign_name' => 'unique:campaigns,campaign_name,' . $did . ',campaign_id', 'dailyspecial_image' => 'image'); $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $postData = $request->all(); if (sizeof($postData['product']) >= 10) { if (Input::hasFile('dailyspecial_image')) { $filePath = uploadImageToStoragePath(Input::file('dailyspecial_image'), 'flashsale', 'flashsale_' . $supplierId . '_' . time() . ".jpg"); $data['campaign_banner'] = $filePath; } $data['campaign_name'] = $postData['campaign_name']; $data['campaign_type'] = 2; $data['discount_type'] = '2'; // if ($data['discount_type'] == '1') { // $data['discount_value'] = $postData['flatdiscount']; // } else { $data['discount_value'] = $postData['percentagediscount']; // } $validFrom = strtotime(str_replace("-", "", $postData['availablefromdate'])); $validTo = strtotime(str_replace("-", "", $postData['availableuptodate'])); $data['available_from'] = $validFrom; $data['available_upto'] = $validTo; $categ = $postData['productcategories']; if (isset($postData['productsubcategories'])) { $subcat = $postData['productsubcategories']; } else { $subcat = []; } $tmp = []; foreach ($categ as $index => $item) { $tmp[$item] = array_values(array_filter(array_map(function ($cat) use($item) { if (explode('_', $cat)[0] == $item) { return explode('_', $cat)[1]; } }, $subcat))); } $data['for_category_ids'] = json_encode($tmp); $data['by_user_id'] = $supplierId; // $product = $postData['product']; $data['for_product_ids'] = implode(",", $postData['product']); $where = ['rawQuery' => 'campaign_id = ?', 'bindParams' => [$did]]; $campaigns = 'Flashsale'; // print_a($data); } else { if (Input::hasFile('dailyspecial_image')) { $filePath = uploadImageToStoragePath(Input::file('dailyspecial_image'), 'dailyspecial', 'dailyspecial_' . $supplierId . '_' . time() . ".jpg"); $data['campaign_banner'] = $filePath; } $data['campaign_name'] = $postData['campaign_name']; $data['campaign_type'] = $postData['campaign_type']; $data['discount_type'] = '2'; $data['discount_value'] = $postData['percentagediscount']; $validFrom = strtotime(str_replace("-", "", $postData['availablefromdate'])); $validTo = strtotime(str_replace("-", "", $postData['availableuptodate'])); $data['available_from'] = $validFrom; $data['available_upto'] = $validTo; $categ = $postData['productcategories']; if (isset($postData['productsubcategories'])) { $subcat = $postData['productsubcategories']; } else { $subcat = []; } // print_r($categ); // print_a($subcat); $tmp = []; foreach ($categ as $index => $item) { $tmp[$item] = array_values(array_filter(array_map(function ($cat) use($item) { if (explode('_', $cat)[0] == $item) { return explode('_', $cat)[1]; } }, $subcat))); } // print_a(json_encode($tmp)); $data['for_category_ids'] = json_encode($tmp); $data['by_user_id'] = $supplierId; // $product = $postData['product']; $data['for_product_ids'] = implode(",", $postData['product']); // $data['for_product_ids'] = $postData['product'][0]; $where = ['rawQuery' => 'campaign_id = ?', 'bindParams' => [$did]]; $campaigns = 'Dailyspecial'; // print_a($data); } $campaignUpdate = $objCampaignModel->updateFlashsaleStatus($data, $where); if ($campaignUpdate) { if (isset($filePath)) { deleteImageFromStoragePath($postData['oldImage']); } return Redirect::back()->with(['status' => 'success', 'msg' => $campaigns . ' ' . 'Updated Successfully.']); } else { return Redirect::back()->with(['status' => 'error', 'msg' => $campaigns . ' ' . 'Some Error try again.']); } } $where = ['rawQuery' => 'campaign_id = ? AND by_user_id = ?', 'bindParams' => [$did, $supplierId]]; $selectedColumn = ['campaigns.*', 'users.username']; $dailyspecialInfo = $objCampaignModel->getAllFlashsaleDetails($where, $selectedColumn); // print_a($dailyspecialInfo); if (isset($dailyspecialInfo) && !empty($dailyspecialInfo)) { foreach ($dailyspecialInfo as $flashkey => $flashval) { $categoryIds = json_decode($flashval->for_category_ids, true); $categoryMerg = array_merge(array_keys($categoryIds)); $categoryMergee = array_merge(array_flatten($categoryIds)); $categoryMerge = array_merge(array_keys($categoryIds), array_flatten($categoryIds)); // echo'<pre>';print_r($categoryMerg); // echo'<pre>';print_r($categoryMergee); // print_a($categoryMerge); $where = ['rawQuery' => 'category_id IN(' . implode(",", $categoryMerge) . ')']; $selectedColumn = [DB::raw('GROUP_CONCAT(DISTINCT category_name) AS category_name'), DB::raw('GROUP_CONCAT(DISTINCT category_id) AS category_id')]; $getcategory = $objProductCategory->getCategoryNameById($where, $selectedColumn); foreach ($getcategory as $catkey => $catval) { $dailyspecialInfo[$flashkey]->category = $catval->category_name; $dailyspecialInfo[$flashkey]->category_ids = $catval->category_id; } $whereProduct = ['rawQuery' => 'product_id IN(' . $flashval->for_product_ids . ')']; $selectedColumn = [DB::raw('GROUP_CONCAT(DISTINCT product_name) AS product_name'), DB::raw('GROUP_CONCAT(DISTINCT product_id) AS product_id')]; $getproduct = $objProductModel->getProductNameById($whereProduct, $selectedColumn); foreach ($getproduct as $prodkey => $prodval) { $dailyspecialInfo[$flashkey]->product_name = $prodval->product_name; $dailyspecialInfo[$flashkey]->product_id = $prodval->product_id; } } $where = ['rawQuery' => 'category_status = ? AND parent_category_id = ?', 'bindParams' => [1, 0]]; $selectedColumn = ['category_id', 'category_name', 'category_status', 'for_shop_id']; $allactivecategories = $objProductCategory->getAllMainCategories($where, $selectedColumn); $where = ['rawQuery' => 'category_status = ?', 'bindParams' => [1]]; $selectedColumn = ['product_categories.*', DB::raw('GROUP_CONCAT(category_id)AS main_category_id'), DB::raw('GROUP_CONCAT(category_name)AS main_category_name')]; $allActiveSubcategories = $objProductCategory->getSubCategoriesForMaincategory($where, $selectedColumn); $mainCategory = array_filter(array_map(function ($category) { if ($category->parent_category_id == 0) { return $category; } }, $allActiveSubcategories))[0]; $finalCatData = []; foreach (explode(',', $mainCategory->main_category_id) as $index => $mainCatID) { foreach ($allActiveSubcategories as $subCatKey => $allActiveSubcategory) { if ($allActiveSubcategory->parent_category_id == $mainCatID) { $allActiveSubcategory->main_cat_name = explode(',', $mainCategory->main_category_name)[$index]; $finalCatData[$mainCatID] = $allActiveSubcategory; } } } $where = ['rawQuery' => 'added_by = ? AND product_type = ?', 'bindParams' => [$supplierId, 0]]; $selectedColumn = ['product_id', 'product_name']; $allproducts = $objProductModel->getAllSupplierProducts($where, $selectedColumn); return view('Supplier/Views/dailyspecial/editDailySpecial', ['dailyspecialInfo' => $dailyspecialInfo[0], 'activeCategory' => $allactivecategories, 'allProducts' => $allproducts, 'allcategories' => $finalCatData]); } else { return view('Supplier/Views/dailyspecial/editDailySpecial'); } }
/** * @param Request $request * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function addNewShop(Request $request) { $userId = Session::get('fs_supplier')['id']; $objCategoryModel = ProductCategory::getInstance(); $objLocationModel = Location::getInstance(); $objShopModel = Shop::getInstance(); $objShopMetadataModel = ShopMetadata::getInstance(); $whereforCategory = ['rawQuery' => 'category_status =? and parent_category_id =?', 'bindParams' => [1, 0]]; $allCategories = $objCategoryModel->getAllCategoriesWhere($whereforCategory); $whereforCountry = ['rawQuery' => 'is_visible =? and location_type =?', 'bindParams' => [0, 0]]; $allCountry = $objLocationModel->getAllLocationsWhere($whereforCountry); $whereforShop = ['rawQuery' => 'user_id =?', 'bindParams' => [$userId]]; $allShop = $objShopModel->getAllshopsWhere($whereforShop); //echo "<pre>";print_r($allShop);die; /////////////////////////////Flag Set By admin side///////////////Todo- Flag Set By admin side $multiple_store_flag = 1; // Value 1 if flag is set $sub_store_flag = 1; // Value 1 if flag is set $parent_category_flag = 1; // Value 1 if flag is set ///////////////////////////////////////////////////////////////// $flag['multiple_store_flag'] = $multiple_store_flag; $flag['sub_store_flag'] = $sub_store_flag; $flag['parent_category_flag'] = $parent_category_flag; $data['allCategories'] = $allCategories; $data['Country'] = $allCountry; $data['Shop'] = $allShop; if (!empty($allShop) && $multiple_store_flag != 1) { //Error msg if multiple shop not allowed and shopeady added return view("Supplier/Views/supplier/addNewShop", ['multiple_store_err' => "Shop already added, Can not add Multiple Shop"]); } else { $parentCategoryId = 0; if (isset($request['parent_category']) && !empty($request['parent_category'])) { $parentCategoryId = $request['parent_category']; } $parentShopId = ""; if (isset($request['parent_shop']) && !empty($request['parent_shop'])) { $parentShopId = $request['parent_shop']; } if ($request->isMethod('post')) { if ($parentShopId == '') { //Sub store flag is not set $rules = array('shop_name' => 'required'); } else { //Sub store flag is set $rules = array(); } $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { try { $addressLine1 = ""; if (isset($request['address_line_1'])) { $addressLine1 = $request['address_line_1']; } $addressLine2 = ""; if (isset($request['address_line_2'])) { $addressLine2 = $request['address_line_2']; } $country = ""; if (isset($request['country'])) { $country = $request['country']; } $state = ""; if (isset($request['state'])) { $state = $request['state']; } $city = ""; if (isset($request['city'])) { $city = $request['city']; } $zipcode = ""; if (isset($request['zipcode'])) { $zipcode = $request['zipcode']; } $shop_flag = 1; if (isset($request['shop_flag'])) { $shop_flag = $request['shop_flag']; } $show_shop = 2; if (isset($request['show_shop'])) { $show_shop = $request['show_shop']; } ////////////Upload Shop Banner Start/////////////////////// if (isset($_FILES["shop_banner"]["name"]) && !empty($_FILES["shop_banner"]["name"])) { $bannerFilePath = uploadImageToStoragePath(Input::file('shop_banner'), 'shopbanner', 'shopbanner_' . $userId . '_' . time() . ".jpg"); } else { $bannerFilePath = uploadImageToStoragePath($_SERVER['DOCUMENT_ROOT'] . "/assets/images/no-image.png", 'shopbanner', 'shopbanner_' . $userId . '_' . time() . ".jpg"); } ////////////Upload Shop banner End/////////////////////// ////////////Upload Shop Logo Start/////////////////////// if (isset($_FILES["shop_logo"]["name"]) && !empty($_FILES["shop_logo"]["name"])) { $logoFilePath = uploadImageToStoragePath(Input::file('shop_logo'), 'shoplogo', 'shoplogo_' . $userId . '_' . time() . ".jpg"); } else { $logoFilePath = uploadImageToStoragePath($_SERVER['DOCUMENT_ROOT'] . "/assets/images/no-image.png", 'shoplogo', 'shoplogo_' . $userId . '_' . time() . ".jpg"); } ////////////Upload Shop Logo End/////////////////////// if ($parentShopId == "") { //Sub store flag is not set $shopdata = array('user_id' => $userId, 'shop_name' => $request['shop_name'], 'shop_banner' => $bannerFilePath, 'shop_logo' => $logoFilePath, 'parent_category_id' => $parentCategoryId, 'shop_flag' => $shop_flag); $addShop = $objShopModel->addShop($shopdata); $shop_id = $addShop; $shopType = "0"; } else { //Sub store flag is set $shopType = "1"; $shop_id = $parentShopId; } $shopMatadata = array('shop_id' => $shop_id, 'shop_type' => $shopType, 'address_line_1' => $addressLine1, 'address_line_2' => $addressLine2, 'city' => $city, 'state' => $state, 'country' => $country, 'zipcode' => $zipcode, 'added_date' => time(), 'show_shop_address' => $show_shop, 'shop_metadata_status' => 1); $addShop = $objShopMetadataModel->addShopMetadata($shopMatadata); if ($addShop) { if ($parentShopId == "") { return redirect()->back()->with('shop_success_msg', 'Shop Added Successfully, Waiting for Admin Approval.'); } else { return redirect()->back()->with('shop_success_msg', 'Shop Added Successfully.'); } } } catch (\Exception $ex) { return redirect()->back()->with('exception', 'An exception occurred, please reload the page and try again.'); } } } return view("Supplier/Views/supplier/addNewShop", ['data' => $data], ['flag' => $flag]); } }
public function editFlashsale(Request $request, $fid) { $objCategoryModel = ProductCategory::getInstance(); $objCampaignModel = Campaigns::getInstance(); $postData = $request->all(); $supplierId = Session::get('fs_supplier')['id']; if ($request->isMethod('POST')) { $rules = array('campaign_name' => 'unique:campaigns,campaign_name,' . $fid . ',campaign_id', 'flashsale_image' => 'image'); $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { if (Input::hasFile('flashsale_image')) { $filePath = uploadImageToStoragePath(Input::file('flashsale_image'), 'flashsale', 'flashsale_' . $supplierId . '_' . time() . ".jpg"); $data['campaign_banner'] = $filePath; } $postData = $request->all(); $data['campaign_name'] = $postData['campaign_name']; $data['for_shop_id'] = $postData['suppliershop']; $data['discount_type'] = $postData['discounttype']; if ($postData['discounttype'] == 1) { $data['discount_value'] = $postData['flatdiscount']; } else { $data['discount_value'] = $postData['percentagediscount']; } $validFrom = strtotime(str_replace("-", "", $postData['availablefromdate'])); $validTo = strtotime(str_replace("-", "", $postData['availableuptodate'])); $data['available_from'] = $validFrom; $data['available_upto'] = $validTo; $categ = $postData['productcategories']; $data['for_category_ids'] = implode(",", $categ); $where = ['rawQuery' => 'campaign_id = ?', 'bindParams' => [$fid]]; $campaignUpdate = $objCampaignModel->updateFlashsaleStatus($data, $where); if ($campaignUpdate) { if (isset($filePath)) { deleteImageFromStoragePath($postData['oldImage']); } return Redirect::back()->with(['status' => 'success', 'msg' => 'FlashSale Added Successfully.']); } else { return Redirect::back()->with(['status' => 'error', 'msg' => 'Some Error try again.']); } } } $where = ['rawQuery' => 'campaign_id = ?', 'bindParams' => [$fid]]; $selectedColumn = ['campaigns.*', 'users.username']; $flashsaleInfo = $objCampaignModel->getAllFlashsaleDetails($where, $selectedColumn); if (isset($flashsaleInfo) && !empty($flashsaleInfo)) { foreach ($flashsaleInfo as $flashkey => $flashval) { $categoryIds = $flashval->for_category_ids; $where = ['rawQuery' => 'category_id IN(' . $categoryIds . ')']; $getcategory = $objCategoryModel->getCategoryNameById($where); foreach ($getcategory as $catkey => $catval) { $flashsaleInfo[$flashkey]->category = $catval->category_name; } } // echo'<pre>';print_r($flashsaleInfo);die("dxv"); $where = ['rawQuery' => 'category_status = ? AND parent_category_id = ?', 'bindParams' => [1, 0]]; $selectedColumn = ['category_id', 'category_name', 'category_status', 'for_shop_id']; $allactivecategories = $objCategoryModel->getAllMainCategories($where, $selectedColumn); return view('Supplier/Views/flashsale/editFlashsale', ['flashsaleDetails' => $flashsaleInfo[0], 'activeflashsale' => $allactivecategories]); } else { return view('Supplier/Views/flashsale/editFlashsale'); } }
/** * Edit category action * @param Request $request * @param $id Category id * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View * @throws \FlashSale\Http\Modules\Supplier\Models\Exception * @since 29-01-2016 * @author Dinanath Thakur <*****@*****.**> */ public function editCategory(Request $request, $id) { $objCategoryModel = ProductCategory::getInstance(); $userId = Session::get('fs_supplier')['id']; if ($request->isMethod('post')) { Validator::extend('word_count', function ($field, $value, $parameters) { if (count(explode(' ', $value)) > 10) { return false; } return true; }, 'Meta keywords should not contain more than 10 words.'); $rules = array('category_name' => 'required|max:50|unique:product_categories,category_name,' . $id . ',category_id', 'category_desc' => 'max:255', 'status' => 'required', 'seo_name' => 'max:100', 'page_title' => 'max:70', 'meta_desc' => 'max:160', 'meta_keywords' => 'word_count'); $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return Redirect::back()->with(["status" => 'error', 'msg' => 'Please correct the following errors.'])->withErrors($validator)->withInput(); } else { if (Input::hasFile('category_image')) { $filePath = uploadImageToStoragePath(Input::file('category_image'), 'category'); if ($filePath) { $dataToUpdate['category_banner_url'] = $filePath; } } $dataToUpdate['category_name'] = $request->input('category_name'); $dataToUpdate['category_desc'] = $request->input('category_desc'); $dataToUpdate['category_status'] = $request->input('status'); $dataToUpdate['parent_category_id'] = $request->input('parent_category'); $dataToUpdate['page_title'] = $request->input('page_title'); $dataToUpdate['meta_description'] = $request->input('meta_desc'); $dataToUpdate['meta_keywords'] = $request->input('meta_keywords'); $whereForUpdate = ['rawQuery' => 'category_id =?', 'bindParams' => [$id]]; $updateResult = $objCategoryModel->updateCategoryWhere($dataToUpdate, $whereForUpdate); if ($updateResult > 0) { if (isset($filePath)) { deleteImageFromStoragePath($request->input('old_image')); } return Redirect::back()->with(['status' => 'success', 'msg' => 'Category details has been updated.']); } else { return Redirect::back()->with(['status' => 'info', 'msg' => 'Nothing to update.']); } } } $where = ['rawQuery' => 'category_id =? AND category_status IN(0,1,2) AND created_by=?', 'bindParams' => [$id, $userId]]; $categoryDetails = $objCategoryModel->getCategoryDetailsWhere($where); $allCategories = ''; if ($categoryDetails) { $allCategories = $objCategoryModel->getAllCategoriesWhere(['rawQuery' => 'created_by IN (' . DB::raw("SELECT `id` FROM `users` WHERE `role` IN(4,5)") . ') OR created_by=? AND category_status IN(0,1,2)', 'bindParams' => [$userId]]); } return view('Supplier/Views/category/editCategory', ['categoryDetails' => $categoryDetails, 'allCategories' => $allCategories]); }
public function editFeature(Request $request, $featureId) { $objModelFeatures = ProductFeatures::getInstance(); $objModelCategory = ProductCategory::getInstance(); $objModelFeatureVariants = ProductFeatureVariants::getInstance(); $whereForFeatureGroup = ['rawQuery' => 'group_flag =? and status = ?', 'bindParams' => [1, 1]]; $allFeatureGroups = $objModelFeatures->getAllFeaturesWhere($whereForFeatureGroup); $whereForFeature = ['rawQuery' => 'feature_id = ? and group_flag=?', 'bindParams' => [$featureId, 0]]; $featureDetails = $objModelFeatures->getFeatureWhere($whereForFeature); $whereForCat = ['rawQuery' => 'category_status =?', 'bindParams' => [1]]; $allCategories = $objModelCategory->getAllCategoriesWhere($whereForCat); $whereForFV = ['rawQuery' => 'feature_id = ?', 'bindParams' => [$featureId]]; $fvData = $objModelFeatureVariants->getAllFeatureVariantsWhere($whereForFV); if ($request->isMethod('post')) { // echo "<pre>"; print_r($request->input()); die; $dataUpdateFeature = array(); $dataUpdateFeature['parent_id'] = (string) json_decode($featureDetails, true)['data']['parent_id']; if ($request->input('parent_id') != null) { $dataUpdateFeature['parent_id'] = $request->input('parent_id'); } $rulesEditdFeature = ['feature_name' => 'required|regex:/(^[A-Za-z0-9 ]+$)+/|max:255|unique:product_features,feature_name,' . $featureId . ',feature_id,parent_id,' . $dataUpdateFeature['parent_id'] . ',group_flag,0', 'full_description' => 'max:255', 'feature_type' => 'required', 'for_categories' => 'required']; $messagesEditFeature = ['feature_name.required' => 'Please enter a name', 'feature_name.alpha_num' => 'Please enter a valid name', 'full_description.max' => 'Description should not exceed 255 characters', 'feature_type.required' => 'Please select a feature type', 'for_categories.required' => 'Please select atleast one category']; $featureVariants = $request->input('feature_variant')['name']; $featureVariantsDesc = $request->input('feature_variant')['description']; $featureVariantIds = $request->input('feature_variant')['variant_id']; // echo '<pre>'; print_r($featureVariantIds); die; foreach ($featureVariants as $keyFV => $valueFV) { //NEED MORE VALIDATION HERE $rulesEditdFeature['feature_variant.name.' . $keyFV] = 'regex:/(^[A-Za-z0-9 ]+$)+/|max:255|unique:product_feature_variants,variant_name,' . (isset($featureVariantIds[$keyFV]) ? $featureVariantIds[$keyFV] : 'NULL') . ',variant_id,feature_id,' . $featureId; $rulesEditdFeature['feature_variant.description.' . $keyFV] = 'regex:/(^[A-Za-z0-9 ]+$)+/|max:255'; $messagesEditFeature['feature_variant.name.' . $keyFV . '.regex'] = 'Name can contain alphanumeric characters and spaces only'; $messagesEditFeature['feature_variant.name.' . $keyFV . '.max'] = 'Name is too long to use. 255 characters max.'; $messagesEditFeature['feature_variant.name.' . $keyFV . '.unique'] = 'Variant name already in use.'; $messagesEditFeature['feature_variant.description.' . $keyFV . '.regex'] = 'Invalid description.'; } // $this->validate($request, $rulesEditdFeature, $messagesEditFeature); $validator = Validator::make($request->all(), $rulesEditdFeature, $messagesEditFeature); if ($validator->fails()) { return Redirect::back()->with(["code" => '400', 'message' => 'Please correct the following errors.'])->withErrors($validator)->withInput(); } else { $dataUpdateFeature['feature_name'] = $request->input('feature_name'); $dataUpdateFeature['full_description'] = $request->input('full_description'); $dataUpdateFeature['feature_type'] = $request->input('feature_type'); $selectedCategories = $request->input('for_categories'); $dataUpdateFeature['for_categories'] = implode(',', array_keys($selectedCategories)); $dataUpdateFeature['display_on_product'] = 0; if ($request->input('display_on_product') != null) { $dataUpdateFeature['display_on_product'] = 1; } $dataUpdateFeature['display_on_catalog'] = 0; if ($request->input('display_on_catalog') != null) { $dataUpdateFeature['display_on_catalog'] = 1; } $dataUpdateFeature['group_flag'] = 0; $whereForFeatureUpdate = ['rawQuery' => 'feature_id = ?', 'bindParams' => [$featureId]]; $updatedFeature = json_decode($objModelFeatures->updateFeatureWhere($dataUpdateFeature, $whereForFeatureUpdate), true); //CODE TO INSERT VARIANTS HERE $whereForVariantId = ['rawQuery' => 'feature_id =?', 'bindParams' => [$featureId]]; $selectedVariantColumn = array(DB::raw('GROUP_CONCAT(variant_id) AS variant_ids')); $oldVariantIds = explode(',', json_decode($objModelFeatureVariants->getFeatureVariantWhere($whereForVariantId, $selectedVariantColumn), true)['data']['variant_ids']); $inputVariantIds = array(); $updateVariantResultFlag = false; $newVariantResultFlag = false; $deletedVariantResultFlag = false; $variantIdsToDelete = $oldVariantIds; if ($dataUpdateFeature['feature_type'] != 0) { foreach ($featureVariants as $keyFV => $valueFV) { if ($valueFV != '') { if (isset($featureVariantIds[$keyFV]) && in_array($featureVariantIds[$keyFV], $oldVariantIds)) { //UPDATE VARIANT DETAILS $inputVariantIds[] = $featureVariantIds[$keyFV]; $updateVariantData = ''; $updateVariantData['variant_name'] = $valueFV; $updateVariantData['description'] = $featureVariantsDesc[$keyFV]; $whereForUpdateVariant = ['rawQuery' => 'variant_id =?', 'bindParams' => [$featureVariantIds[$keyFV]]]; $updateVariantResult = $objModelFeatureVariants->updateFeatureVariantWhere($updateVariantData, $whereForUpdateVariant); if ($updateVariantResult) { $updateVariantResultFlag = true; } } else { //ADD NEW VARIANT DETAILS $newVariantData['feature_id'] = $featureId; $newVariantData['variant_name'] = $valueFV; // $newVariantData['added_by'] = $userId; $newVariantData['description'] = $featureVariantsDesc[$keyFV]; $newInsertedVariantId = $objModelFeatureVariants->addFeatureVariant($newVariantData); if ($newInsertedVariantId) { $newVariantResultFlag = true; } } } } $variantIdsToDelete = array_diff($oldVariantIds, $inputVariantIds); } if (!empty($variantIdsToDelete)) { $whereForDeleteVariant = ['rawQuery' => 'variant_id IN (?)', 'bindParams' => [implode(',', $variantIdsToDelete)]]; $deletedVariantResult = $objModelFeatureVariants->deleteFeatureVariantWhere($whereForDeleteVariant); if ($deletedVariantResult) { $deletedVariantResultFlag = true; } } if (isset($updatedFeature) && $updatedFeature['code'] == 200 || isset($updateVariantResultFlag) && $updateVariantResultFlag || isset($newVariantResultFlag) && $newVariantResultFlag || isset($deletedVariantResultFlag) && $deletedVariantResultFlag) { //ALL DETAILS UPDATED return Redirect::back()->with(['code' => '200', 'message' => 'Changes saved successfully.']); } else { //NOTHING TO UPDATE return Redirect::back()->with(['code' => '200', 'message' => 'Nothing to update.']); } } } return view('Supplier/Views/features/editFeature', ['code' => '', 'featureGroups' => json_decode($allFeatureGroups, true), 'allCategories' => $allCategories, 'featureDetails' => json_decode($featureDetails, true), 'fvData' => json_decode($fvData, true)]); //, ['successMsg' => $successMsg, 'errMsg' => $errMsg] }