[1mdiff --git a/application/core/models/ProductModel.php b/application/core/models/ProductModel.php[m
[1mindex 1c787d76d..9dbb3eb4a 100644[m
[1m--- a/application/core/models/ProductModel.php[m
[1m+++ b/application/core/models/ProductModel.php[m
[36m@@ -5109,5 +5109,140 @@[m [mpublic function getProductNutrition($productID, $languageIDs,$productToNutrition[m
         else[m
             return false;[m
     }[m
[32m+[m[41m	
[m
[32m+[m	[32mpublic function getProductOptionsDetails2($languageIDs, $productID) {[m[41m
[m
[32m+[m[32m        $defaultLanguageID = $languageIDs['Default'];[m[41m
[m
[32m+[m[32m        $currentLanguageID = $languageIDs['Current'];[m[41m
[m
[32m+[m[32m        $sql               = "[m[41m
[m
[32m+[m					[32mSELECT[m[41m
[m
[32m+[m						[32mproductOpt.productOptionID,[m[41m
[m
[32m+[m						[32mproductOptDet.productOptionName,[m[41m
[m
[32m+[m						[32mproductOpt.*,[m[41m
[m
[32m+[m						[32mproductOptDet.*,[m[41m
[m
[32m+[m						[32mprodWebStore.currency AS productDefaultCurrency,[m[41m
[m
[32m+[m					[32mproductOpt.productOptionID,[m[41m
[m
[32m+[m					[32mprodWebStore.productOptionRegularPrice,[m[41m
[m
[32m+[m					[32mLEAST([m[41m
[m
[32m+[m						[32mCOALESCE([m[41m
[m
[32m+[m							[32mvarOffPri.offerPrice,[m[41m
[m
[32m+[m							[32mprodWebStore.productOptionProductPrice[m[41m
[m
[32m+[m						[32m),[m[41m
[m
[32m+[m						[32mCOALESCE([m[41m
[m
[32m+[m							[32mvarGroPri.specialPrice,[m[41m
[m
[32m+[m							[32mprodWebStore.productOptionProductPrice[m[41m
[m
[32m+[m						[32m)[m[41m 
[m
[32m+[m					[32m)[m[41m
[m
[32m+[m					[32mAS offerPrice,[m[41m
[m
[32m+[m					[32mROUND([m[41m
[m
[32m+[m						[32m([m[41m
[m
[32m+[m							[32m([m[41m
[m
[32m+[m								[32m([m[41m
[m
[32m+[m								[32mprodWebStore.productOptionRegularPrice-[m[41m
[m
[32m+[m									[32mLEAST([m[41m
[m
[32m+[m										[32mCOALESCE([m[41m
[m
[32m+[m											[32mvarOffPri.offerPrice,[m[41m
[m
[32m+[m											[32mprodWebStore.productOptionProductPrice[m[41m
[m
[32m+[m										[32m),[m[41m
[m
[32m+[m										[32mCOALESCE([m[41m
[m
[32m+[m											[32mvarGroPri.specialPrice,[m[41m
[m
[32m+[m											[32mprodWebStore.productOptionProductPrice[m[41m
[m
[32m+[m										[32m)[m[41m 
[m
[32m+[m									[32m)[m[41m
[m
[32m+[m								[32m)*100[m[41m
[m
[32m+[m							[32m)/prodWebStore.productOptionRegularPrice[m[41m
[m
[32m+[m						[32m),2[m[41m
[m
[32m+[m					[32m) AS productOptionOfferDiscount[m[41m
[m
[32m+[m					[32mFROM[m[41m
[m
[32m+[m						[32m" . DB_PREFIX . "product_options productOpt[m[41m
[m
[32m+[m						[32mINNER JOIN[m[41m 
[m
[32m+[m						[32m" . DB_PREFIX . "product_option_details productOptDet[m[41m
[m
[32m+[m						[32mON ([m[41m
[m
[32m+[m							[32mproductOptDet.productOptionID = productOpt.productOptionID[m[41m 
[m
[32m+[m						[32m)[m[41m
[m
[32m+[m						[32mINNER JOIN[m[41m 
[m
[32m+[m					[32m" . DB_PREFIX . "product_to_website_store AS prodWebStore[m[41m
[m
[32m+[m						[32mON ([m[41m
[m
[32m+[m							[32mprodWebStore.productOptionID = productOpt.productOptionID[m[41m 
[m
[32m+[m							[32mAND productOptionDefaultStore='Yes'[m[41m 
[m
[32m+[m[32m                                                        AND storeProductStatus='Active' AND[m[41m
[m
[32m+[m							[32mprodWebStore.store_id = '".SUBSITE_ID."'[m[41m
[m
[32m+[m						[32m)[m[41m
[m
[32m+[m[41m						
[m
[32m+[m					[32mLEFT JOIN[m[41m
[m
[32m+[m								[32m" . DB_PREFIX . "variant_offer_price AS varOffPri[m[41m
[m
[32m+[m									[32mON	([m[41m
[m
[32m+[m										[32mvarOffPri.productOptionID = productOpt.productOptionID[m[41m
[m
[32m+[m										[32m";[m[41m
[m
[32m+[m[32m            if(isset($userGroupID) && $userGroupID!='')[m[41m
[m
[32m+[m[32m                $sql .= " AND   	varOffPri.userGroupID='" .(int) $userGroupID . "' ";[m[41m
[m
[32m+[m[32m            $sql .= "[m[41m
[m
[32m+[m[32m                                                                                AND varOffPri.store_id = prodWebStore.	store_id[m[41m
[m
[32m+[m									[32m)[m[41m
[m
[32m+[m							[32mLEFT JOIN[m[41m
[m
[32m+[m								[32m" . DB_PREFIX . "variant_group_price AS varGroPri[m[41m
[m
[32m+[m									[32mON	([m[41m
[m
[32m+[m										[32mvarGroPri.productOptionID = productOpt.productOptionID[m[41m
[m
[32m+[m[32m                                                                                ";[m[41m
[m
[32m+[m[32m            if(isset($userGroupID) && $userGroupID!='')[m[41m
[m
[32m+[m[32m                $sql .= " AND[m[41m
[m
[32m+[m					[32mvarGroPri.userGroupID='" .(int) $userGroupID . "' ";[m[41m
[m
[32m+[m[32m            $sql .= "[m[41m
[m
[32m+[m[41m										
[m
[32m+[m[32m                                                                                AND varGroPri.store_id = prodWebStore.store_id[m[41m
[m
[32m+[m									[32m)[m[41m	
[m
[32m+[m							[32mLEFT JOIN[m[41m 
[m
[32m+[m								[32m" . DB_PREFIX . "product_combination AS proCom[m[41m 
[m
[32m+[m								[32mON ([m[41m
[m
[32m+[m									[32mproCom.productID=productOpt.productID[m[41m 
[m
[32m+[m									[32mAND[m[41m 
[m
[32m+[m									[32mproCom.status = 'A'[m[41m
[m
[32m+[m								[32m)[m[41m 
[m
[32m+[m							[32mLEFT JOIN[m[41m 
[m
[32m+[m								[32m" . DB_PREFIX . "product_combination_store AS proComStore[m[41m 
[m
[32m+[m								[32mON ([m[41m
[m
[32m+[m									[32mproComStore.combinationID=proCom.combinationID[m[41m 
[m
[32m+[m									[32mAND[m[41m 
[m
[32m+[m									[32mproComStore.store_id = prodWebStore.store_id[m[41m
[m
[32m+[m								[32m)[m[41m 
[m
[32m+[m							[32mLEFT JOIN[m[41m 
[m
[32m+[m								[32m" . DB_PREFIX . "product_combination AS proCom1[m[41m
[m
[32m+[m								[32mON[m[41m
[m
[32m+[m								[32m([m[41m
[m
[32m+[m									[32mproCom1.productID=productOpt.productID[m[41m  
[m
[32m+[m									[32mAND[m[41m 
[m
[32m+[m									[32mproCom1.status = 'A' AND proCom1.combinationQty=''[m[41m
[m
[32m+[m								[32m)[m[41m
[m
[32m+[m					[32mWHERE[m[41m
[m
[32m+[m						[32mproductOpt.productOptionID=productOptDet.productOptionID[m[41m
[m
[32m+[m						[32mAND[m[41m
[m
[32m+[m						[32mlanguageID=[m[41m
[m
[32m+[m							[32m([m[41m
[m
[32m+[m							[32mSELECT CASE[m[41m
[m
[32m+[m								[32mWHEN[m[41m
[m
[32m+[m								[32m([m[41m
[m
[32m+[m								[32mSELECT EXISTS[m[41m
[m
[32m+[m									[32m([m[41m
[m
[32m+[m									[32mSELECT[m[41m
[m
[32m+[m									[32m*[m[41m
[m
[32m+[m									[32mFROM[m[41m
[m
[32m+[m									[32m" . DB_PREFIX . "product_options[m[41m
[m
[32m+[m									[32mWHERE[m[41m
[m
[32m+[m									[32mproductOptionID=productOpt.productOptionID[m[41m
[m
[32m+[m									[32mAND[m[41m
[m
[32m+[m									[32mlanguageID='" .(int) $currentLanguageID . "'[m[41m
[m
[32m+[m									[32m)[m[41m
[m
[32m+[m								[32m)[m[41m
[m
[32m+[m								[32mTHEN[m[41m
[m
[32m+[m								[32m'" .(int) $currentLanguageID . "'[m[41m
[m
[32m+[m								[32mELSE[m[41m
[m
[32m+[m								[32m'" .(int) $currentLanguageID . "'[m[41m
[m
[32m+[m								[32mEND[m[41m
[m
[32m+[m							[32m)[m[41m
[m
[32m+[m						[32mAND[m[41m
[m
[32m+[m						[32mproductOpt.productID='" .(int) $productID . "'[m[41m
[m
[32m+[m						[32mAND[m[41m
[m
[32m+[m						[32mproductOptionStatus='Active' ";[m[41m
[m
[32m+[m[32m        return $this->ObjDatabase->readValuesSlave($sql);[m[41m
[m
[32m+[m[32m    }[m[41m
[m
 }[m
 // End of Class[m
