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