public function editProduct(Request $request, $productId) { $temp = ["cacheid" => "testcacheid1", "testsdata" => [["lessonid" => "1", "drills" => [["drillid" => "1", "result_ids" => "1,2,3"], ["drillid" => "2", "result_ids" => "4"]]], ["lessonid" => "2", "drills" => [["drillid" => "1", "result_ids" => "1,2,3"], ["drillid" => "2", "result_ids" => "4"]]]]]; dd(json_encode($temp, true)); die; //GET from product //GET from productmeta $objModelProducts = Products::getInstance(); $whereForProduct = ['rawQuery' => 'products.product_id = ?', 'bindParams' => [$productId]]; $productData = json_decode($objModelProducts->getProductWhere($whereForProduct), true); if (!empty($productData['data'])) { $objModelCategory = ProductCategory::getInstance(); $objModelFeatures = ProductFeatures::getInstance(); $objModelProductMeta = ProductMeta::getInstance(); $objModelProductImage = ProductImage::getInstance(); $objModelProductOption = ProductOption::getInstance(); $objModelProductOptionVariant = ProductOptionVariant::getInstance(); $objModelProductOptionVariantRelation = ProductOptionVariantRelation::getInstance(); $objModelProductFeatureVariantRelation = ProductFeatureVariantRelation::getInstance(); $objModelProductOptVarCombination = ProductOptionVariantsCombination::getInstance(); $objModelProductFeature = ProductFeatures::getInstance(); $userId = Session::get('fs_admin')['id']; $whereForCat = ['rawQuery' => 'category_status =?', 'bindParams' => [1]]; $allCategories = $objModelCategory->getAllCategoriesWhere($whereForCat); $whereForFeatureGroup = ['rawQuery' => 'group_flag =? and status = ?', 'bindParams' => [1, 1]]; $allFeatureGroups = $objModelFeatures->getAllFeaturesWhere($whereForFeatureGroup); //GET from product_feature_variant_relation $catId = (int) $productData['data']['category_id']; $catFlag = true; $parentCategory = array(); $count = 1; $bindParamsForFeature = array(); $queryForFeature = ""; $queryForFeatureGroup = ""; while ($catFlag) { if ($count == 1) { $queryForFeatureGroup = '(product_features.group_flag = 1) and (product_features.for_categories LIKE ? OR product_features.for_categories LIKE ? OR product_features.for_categories LIKE ? OR product_features.for_categories LIKE ?'; $queryForFeature = '(group_flag = 0 and parent_id = 0) and (for_categories LIKE ? OR for_categories LIKE ? OR for_categories LIKE ? OR for_categories LIKE ?'; } else { $count++; $catId = $parentCategory['category_id']; $queryForFeatureGroup .= 'OR product_features.for_categories LIKE ? OR product_features.for_categories LIKE ? OR product_features.for_categories LIKE ? OR product_features.for_categories LIKE ?'; $queryForFeature .= 'OR for_categories LIKE ? OR for_categories LIKE ? OR for_categories LIKE ? OR for_categories LIKE ?'; } array_push($bindParamsForFeature, "%,{$catId}"); array_push($bindParamsForFeature, "%,{$catId},%"); array_push($bindParamsForFeature, "{$catId},%"); array_push($bindParamsForFeature, "{$catId}"); $parentCategory = array(); $whereForCat = ['rawQuery' => 'parent_category_id = ?', "bindParams" => [$catId]]; $parentCategory = $objModelCategory->getCategoryDetailsWhere($whereForCat); if (!$parentCategory) { $catFlag = false; } } $queryForFeature .= ")"; $queryForFeatureGroup .= ")"; $whereForFeature = ['rawQuery' => $queryForFeature, 'bindParams' => $bindParamsForFeature]; $featureDetails = json_decode($objModelProductFeature->getAllFeaturesWithVariantsWhere($whereForFeature), true); // $featureDetails = json_decode($objModelProductFeature->getAllFeaturesWithFVRelationWhere($whereForFeature), true); $whereForFeatureGroup = ['rawQuery' => $queryForFeatureGroup, 'bindParams' => $bindParamsForFeature]; $featureGroups = json_decode($objModelProductFeature->getAllFGsWithFsWhere($whereForFeatureGroup), true); foreach ($featureGroups['data'] as $keyFG => $valueFG) { $whereForFs = ['rawQuery' => "product_features.parent_id IN (?)", "bindParams" => [$valueFG['feature_ids']]]; $featureGroups['data'][$keyFG]['featureDetails'] = json_decode($objModelProductFeature->getAllFeaturesWithVariantsWhere($whereForFs), true)['data']; } $whereForFVRelation = ['rawQuery' => "product_id = ?", 'bindParams' => [$productId]]; $fvRelations = $objModelProductFeatureVariantRelation->getAllFeatureVariantRelationsWhere($whereForFVRelation); // dd($fvRelations); $response['code'] = $featureDetails['code']; $response['message'] = $featureDetails['message']; $response['data']['featureDetails'] = $featureDetails['data']; $response['data']['featureGroupDetails'] = $featureGroups['data']; //GET from options $whereForOptions = ['rawQuery' => 'status = 1']; $allOptions = $objModelProductOption->getAllOptionsWhere($whereForOptions); //GET from option_variants // $objModelProductOptionVariant->getVariants //GET from option_variant_relation $whereForOptVar = ['rawQuery' => "1"]; //product_id = ?", 'bindParams' => [$productId]]; $whereForJoin = ['column' => 'product_id', 'condition' => '=', 'value' => "{$productId}"]; $dataOptVarWithRelations = json_decode($objModelProductOptionVariant->getOptionVarWithRelationsWhere($whereForOptVar, ['*'], $whereForJoin), true); // dd(json_decode($dataOptVarWithRelations, true));//$objModelProductOptionVariantRelation //GET from option_variants_combination $whereForOptVarCombinations = ['rawQuery' => "product_id = ?", 'bindParams' => [$productId]]; $dataOptVarCombs = json_decode($objModelProductOptVarCombination->getAllCombinationsWhere($whereForOptVarCombinations), true); // dd(json_decode($dataOptVarCombs, true));//$objModelProductOptionVariantRelation //GET from product_images $whereForImages = ['rawQuery' => 'for_product_id = ? and for_combination_id = ?', 'bindParams' => [$productId, 0]]; $dataDefaultImages = json_decode($objModelProductImage->getAllImagesWhere($whereForImages), true); // dd($dataImages); if ($request->isMethod('post')) { dd($request); // $inputData = $request->input('product_data');//Excludes image $inputData = $request->all()['product_data']; //Includes image // print_a($inputData['options']); // print_a($_FILES); $returnData = ['code' => 400, "message" => "Nothing to update.", "data" => null]; if (isset($inputData['updateFormName'])) { $updateFormName = $inputData['updateFormName']; $errors = array(); switch ($updateFormName) { case "general": $rules = ['product_name' => 'required', 'price' => 'required', 'in_stock' => 'required', 'comment' => 'max:100']; $messages = array(); $validator = Validator::make($inputData, $rules, $messages); if ($validator->fails()) { return Redirect::back()->with(["code" => 400, "status" => 'error', 'message' => 'Please correct the following errors.'])->withErrors($validator)->withInput(); } else { $productData = array(); $productData['product_name'] = trim($inputData['product_name']); $productData['for_shop_id'] = $inputData['shop_id']; if (array_key_exists('product_type', $inputData)) { $productData['product_type'] = 1; } $productData['min_qty'] = $inputData['minimum_order_quantity']; $productData['max_qty'] = $inputData['maximum_order_quantity']; $productData['category_id'] = $inputData['category_id']; $productData['for_gender'] = $inputData['for_gender']; $productData['price_total'] = $inputData['price']; $productData['list_price'] = $inputData['list_price']; $productData['in_stock'] = $inputData['in_stock']; $productData['added_date'] = time(); $productData['added_by'] = $userId; $productData['status_set_by'] = $userId; $returnData = $objModelProducts->updateProductsWhere($productData); // $returnData['code'] = 200; // $returnData['message'] = "General details saved successfully"; // $returnData['data'] = null; } //--------------------------PRODUCT-METADATA----------------------------// $productMetaData['product_id'] = $productId; $productMetaData['full_description'] = trim($inputData['full_description']); $productMetaData['short_description'] = trim($inputData['short_description']); $productMetaData['weight'] = $inputData['shipping_properties']['weight']; $productMetaData['shipping_freight'] = $inputData['shipping_properties']['shipping_freight']; $shippingParams = array(); $shippingParams['min_items'] = $inputData['shipping_properties']['min_items']; $shippingParams['max_items'] = $inputData['shipping_properties']['min_items']; if (array_key_exists('box_length', $inputData['shipping_properties'])) { $shippingParams['box_length'] = $inputData['shipping_properties']['box_length']; } if (array_key_exists('box_width', $inputData['shipping_properties'])) { $shippingParams['box_width'] = $inputData['shipping_properties']['box_width']; } if (array_key_exists('box_height', $inputData['shipping_properties'])) { $shippingParams['box_height'] = $inputData['shipping_properties']['box_height']; } $productMetaData['shipping_params'] = json_encode($shippingParams); $productMetaData['quantity_discount'] = json_encode($inputData['quantity_discount']); $productMetaData['product_tabs'] = json_encode($inputData['product_tabs']); $insertedProductMetaId = $objModelProductMeta->addProductMetaData($productMetaData); if (!$insertedProductMetaId) { $errors[] = 'Sorry, some of the product data were not added, please update the same on the edit section.'; } //--------------------------END PRODUCT-METADATA----------------------------// //------------------------PRODUCT FEATURES START HERE---------------------// if (array_key_exists('features', $inputData)) { $productDataFeatures = $inputData['features']; $fvrDataToInsert = array(); foreach ($productDataFeatures as $keyPDF => $valuePDF) { if (array_key_exists("single", $productDataFeatures[$keyPDF])) { // $fvrDataToInsert[] = ['product_id' => $insertedProductId, 'feature_id' => $keyPDF, 'variant_ids' => 0, 'display_status' => $productDataFeatures[$keyPDF]['status']]; $objModelProductFeatureVariantRelation->addFeatureVariantRelation(['product_id' => $insertedProductId, 'feature_id' => $keyPDF, 'variant_ids' => 0, 'display_status' => $productDataFeatures[$keyPDF]['status']]); } else { if (array_key_exists("muliple", $productDataFeatures[$keyPDF])) { // $fvrDataToInsert[] = ['product_id' => $insertedProductId, 'feature_id' => $keyPDF, 'variant_ids' => implode(",", array_keys($valuePDF['multiple'])), 'display_status' => $valuePDF['status']]; $objModelProductFeatureVariantRelation->addFeatureVariantRelation(['product_id' => $insertedProductId, 'feature_id' => $keyPDF, 'variant_ids' => implode(",", array_keys($valuePDF['multiple'])), 'display_status' => $valuePDF['status']]); } else { if (array_key_exists("select", $productDataFeatures[$keyPDF])) { // $fvrDataToInsert[] = ['product_id' => $insertedProductId, 'feature_id' => $keyPDF, 'variant_ids' => $valuePDF['select'], 'display_status' => $valuePDF['status']]; $objModelProductFeatureVariantRelation->addFeatureVariantRelation(['product_id' => $insertedProductId, 'feature_id' => $keyPDF, 'variant_ids' => "" . $valuePDF['select'], 'display_status' => $valuePDF['status']]); } } } } // $objModelProductFeatureVariantRelation->addFeatureVariantRelation($fvrDataToInsert); } //------------------------PRODUCT FEATURES END HERE---------------------// break; //TODO update main image here //TODO update main image here case "images": $rules = ['mainimage' => 'image|mimes:jpeg,bmp,png|max:1000']; $messages['mainimage.image'] = 'Only jpg, jpeg, gif images allowed for upload.'; $validator = Validator::make($inputData, $rules, $messages); if ($validator->fails()) { return Redirect::back()->with(["code" => 400, "status" => 'error', 'message' => 'Please correct the following errors.'])->withErrors($validator)->withInput(); } else { //TODO update otherimages here //----------------------------PRODUCT-IMAGES------------------------------// $productImages = $_FILES['product_data']; $imageData = array(); if ($productImages['error']['mainimage'] == 0) { $mainImageURL = uploadImageToStoragePath($productImages['tmp_name']['mainimage'], 'product_' . $insertedProductId, 'product_' . $insertedProductId . '_0_' . time() . '.jpg', 724, 1024); if ($mainImageURL) { $mainImageData['for_product_id'] = $insertedProductId; $mainImageData['image_type'] = 0; $mainImageData['image_upload_type'] = 0; $mainImageData['image_url'] = $mainImageURL; $imageData[] = $mainImageData; } } else { $errors[] = 'Sorry, something went wrong. Main image could not be uploaded, You can upload it on edit section.'; } if (array_key_exists('otherimages', $productImages['name'])) { foreach ($productImages['tmp_name']['otherimages'] as $otherImageKey => $otherImage) { if ($otherImage != '') { $otherImageURL = uploadImageToStoragePath($otherImage, 'product_' . $insertedProductId, 'product_' . $insertedProductId . '_' . ($otherImageKey + 1) . '_' . time() . '.jpg', 724, 1024); if ($otherImageURL) { $otherImageData['for_product_id'] = $insertedProductId; $otherImageData['image_type'] = 1; $otherImageData['image_upload_type'] = 0; $otherImageData['image_url'] = $otherImageURL; $imageData[] = $otherImageData; } } } } if (!empty($imageData)) { $objModelProductImage->addNewImage($imageData); } //--------------------------END PRODUCT-IMAGES----------------------------// $returnData['code'] = 200; $returnData['message'] = "Images updated successfully"; $returnData['data'] = null; } break; case "options": $rules = ['mainimage' => 'image|mimes:jpeg,bmp,png|max:1000']; $messages['mainimage.image'] = 'Only jpg, jpeg, gif images allowed for upload.'; $validator = Validator::make($inputData, $rules, $messages); if ($validator->fails()) { return Redirect::back()->with(["code" => 400, "status" => 'error', 'message' => 'Please correct the following errors.'])->withErrors($validator)->withInput(); } else { //TODO options code here if (array_key_exists('options', $inputData)) { $finalOptionVariantRelationData = array(); $varDataForCombinations = array(); foreach ($inputData['options'] as $key => $optionValue) { $optionVariantRelationData['product_id'] = $insertedProductId; $optionVariantRelationData['option_id'] = $optionValue['option_id']; $optionVariantRelationData['status'] = $optionValue['status']; $tempOptionVariantData = array(); $variantIds = array(); //-------------------------OLD OPTION VARIANT START-----------------------// /* if (array_key_exists('variantData', $optionValue)) { foreach ($optionValue['variantData'] as $variantKey => $variantValue) { $temp = array(); if ($variantValue['variant_id'] == 0) { $variantData['option_id'] = $optionValue['option_id']; $variantData['variant_name'] = $variantValue['variant_name']; $variantData['added_by'] = $userId; $variantData['status'] = $variantValue['status']; $variantData['created_at'] = NULL; $insertedVariantId = $objModelProductOptionVariant->addNewVariantAndGetID($variantData); if ($insertedVariantId > 0) { array_push($variantIds, $insertedVariantId); $temp['VID'] = $insertedVariantId; $temp['VN'] = $variantValue['variant_name']; $temp['PM'] = $variantValue['price_modifier']; $temp['PMT'] = $variantValue['price_modifier_type']; $temp['WM'] = $variantValue['weight_modifier']; $temp['WMT'] = $variantValue['weight_modifier_type']; $temp['STTS'] = $variantValue['status']; } } else { array_push($variantIds, $variantValue['variant_id']); $temp['VID'] = $variantValue['variant_id']; $temp['VN'] = $variantValue['variant_name']; $temp['PM'] = $variantValue['price_modifier']; $temp['PMT'] = $variantValue['price_modifier_type']; $temp['WM'] = $variantValue['weight_modifier']; $temp['WMT'] = $variantValue['weight_modifier_type']; $temp['STTS'] = $variantValue['status']; } $tempOptionVariantData[] = $temp; } if (!empty($variantIds) && !empty($tempOptionVariantData)) { $optionVariantRelationData['variant_ids'] = implode(',', $variantIds); $optionVariantRelationData['variant_data'] = json_encode($tempOptionVariantData); } } */ //-------------------------OLD OPTION VARIANT END-----------------------// //-------------------------NEW OPTION VARIANT START---------------------// if (array_key_exists('variantData', $optionValue)) { foreach ($optionValue['variantData'] as $variantKey => $variantValue) { $temp = array(); array_push($variantIds, $variantValue['variant_id']); $temp['VID'] = $variantValue['variant_id']; $temp['VN'] = $variantValue['variant_name']; $temp['PM'] = $variantValue['price_modifier']; $temp['PMT'] = $variantValue['price_modifier_type']; $temp['WM'] = $variantValue['weight_modifier']; $temp['WMT'] = $variantValue['weight_modifier_type']; $temp['STTS'] = $variantValue['status']; $tempOptionVariantData[] = $temp; } } if (array_key_exists('variantDataNew', $optionValue)) { foreach ($optionValue['variantDataNew'] as $variantKey => $variantValue) { $temp = array(); $variantData['option_id'] = $optionValue['option_id']; $variantData['variant_name'] = $variantValue['variant_name']; $variantData['added_by'] = $userId; $variantData['status'] = $variantValue['status']; $variantData['created_at'] = NULL; $insertedVariantId = $objModelProductOptionVariant->addNewVariantAndGetID($variantData); if ($insertedVariantId > 0) { $varDataForCombinations[$variantValue['variant_id']] = $insertedVariantId; array_push($variantIds, $insertedVariantId); $temp['VID'] = $insertedVariantId; $temp['VN'] = $variantValue['variant_name']; $temp['PM'] = $variantValue['price_modifier']; $temp['PMT'] = $variantValue['price_modifier_type']; $temp['WM'] = $variantValue['weight_modifier']; $temp['WMT'] = $variantValue['weight_modifier_type']; $temp['STTS'] = $variantValue['status']; } $tempOptionVariantData[] = $temp; } } if (!empty($variantIds) && !empty($tempOptionVariantData)) { $optionVariantRelationData['variant_ids'] = implode(',', $variantIds); $optionVariantRelationData['variant_data'] = json_encode($tempOptionVariantData); } //-------------------------NEW OPTION VARIANT END---------------------// $finalOptionVariantRelationData[] = $optionVariantRelationData; } if (!empty($finalOptionVariantRelationData)) { $objModelProductOptionVariantRelation->addNewOptionVariantRelation($finalOptionVariantRelationData); } //------------------------PRODUCT OPTION COMBINATIONS START HERE---------------------// foreach ($inputData['opt_combination'] as $keyCombination => $valueCombination) { $flags = explode("_", $valueCombination['newflag']); $combinationVarIds = explode("_", $keyCombination); $flagKeys = array_keys($flags, "1"); foreach ($flagKeys as $keyFK => $valueFK) { $combinationVarIds[$keyFK] = $varDataForCombinations[$combinationVarIds[[$keyFK]]]; } //TODO ADD BARCODE, shippig info and image data for the combination here $dataCombinations['product_id'] = $insertedProductId; $dataCombinations['variant_ids'] = implode("_", $combinationVarIds); $dataCombinations['quantity'] = $valueCombination['quantity']; $dataCombinations['exception_flag'] = 0; if (isset($valueCombination['excludeflag']) && $valueCombination['excludeflag'] == 'on') { $dataCombinations['exception_flag'] = 1; } $objModelProductOptVarCombination->addNewOptionVariantsCombination($dataCombinations); } //------------------------PRODUCT OPTION COMBINATIONS END HERE---------------------// } $returnData['code'] = 200; $returnData['message'] = "Options saved successfully"; $returnData['data'] = null; } break; /* case "features": $returnData['code'] = 200; $returnData['message'] = "Features saved successfully"; $returnData['data'] = null; break; */ /* case "features": $returnData['code'] = 200; $returnData['message'] = "Features saved successfully"; $returnData['data'] = null; break; */ case "filters": $rules = ['mainimage' => 'image|mimes:jpeg,bmp,png|max:1000']; $messages['mainimage.image'] = 'Only jpg, jpeg, gif images allowed for upload.'; $validator = Validator::make($inputData, $rules, $messages); if ($validator->fails()) { return Redirect::back()->with(["code" => 400, "status" => 'error', 'message' => 'Please correct the following errors.'])->withErrors($validator)->withInput(); } else { $returnData['code'] = 200; $returnData['message'] = "Filters saved successfully"; $returnData['data'] = null; } break; case "tabs": $rules = ['mainimage' => 'image|mimes:jpeg,bmp,png|max:1000']; $messages['mainimage.image'] = 'Only jpg, jpeg, gif images allowed for upload.'; $validator = Validator::make($inputData, $rules, $messages); if ($validator->fails()) { return Redirect::back()->with(["code" => 400, "status" => 'error', 'message' => 'Please correct the following errors.'])->withErrors($validator)->withInput(); } else { $returnData['code'] = 200; $returnData['message'] = "Tab details saved successfully"; $returnData['data'] = null; } break; default: break; } } } foreach ($allCategories as $key => $value) { $allCategories[$key]->display_name = $this->getCategoryDisplayName($value->category_id); } return view('Admin/Views/product/editProduct', ['code' => '', 'allCategories' => $allCategories, 'allOptions' => $allOptions, 'featureGroups' => json_decode($allFeatureGroups, true), 'productData' => $productData['data'], 'dataOptVarWithRelations' => $dataOptVarWithRelations, 'dataOptVarCombs' => $dataOptVarCombs, 'dataDefaultImages' => $dataDefaultImages]); } else { return view('Admin/Views/product/editProduct', ['code' => '400', 'message' => 'No such product exists.', 'productData' => array()]); } }
/** * Handle ajax calls * @param Request $request * @throws \FlashSale\Http\Modules\Admin\Models\Exception * @since 22-12-2015 * @author Dinanath Thakur <*****@*****.**> */ public function optionAjaxHandler(Request $request) { $objProductOptionModel = ProductOption::getInstance(); $objProductOptionVariantModel = ProductOptionVariant::getInstance(); $inputData = $request->input(); $method = $inputData['method']; switch ($method) { case 'changeOptionStatus': echo json_encode($objProductOptionModel->updateOptionWhere(['status' => $inputData['status']], ['rawQuery' => 'option_id =?', 'bindParams' => [$inputData['optionId']]]) == 1 ? ['status' => 'success', 'msg' => 'Status has been changed.'] : ['status' => 'error', 'msg' => 'Something went wrong, please reload the page and try again.']); break; case 'deleteOption': $optionId = $inputData['optionId']; $whereForDeleteOption = ['rawQuery' => 'option_id =?', 'bindParams' => [$optionId]]; $deleteOptionResult = $objProductOptionModel->deleteOptionWhere($whereForDeleteOption); if ($deleteOptionResult) { //TODO NOTIFICATION TO ALL SUPPLIER $deleteVariantResult = $objProductOptionVariantModel->deleteVariantWhere($whereForDeleteOption); echo json_encode(['status' => 'success', 'msg' => 'Selected option has been deleted.']); } else { echo json_encode(['status' => 'error', 'msg' => 'Something went wrong, please reload the page and try again.']); } break; default: break; } }