I have a digital product store and a lot of time customers dont realize that they have purchase a downloadable product before and accidently order it again. Resulting in an email..and the time it takes for me to issue a refund, or give them another design.
I would like to code the cart page to alert customers that are logged in via a message below the product they enter telling them that tada.."You have purchsed this product before"
Heres the code I have so far but im not getting the message when i test adding a product that I have already have on the test account:
Code:
if($ccUserData[0][customer_id]>0)
{
$query = "SELECT * FROM ".$glob[dbprefix]."CubeCart_order_sum INNER JOIN ".$glob[dbprefix]."CubeCart_order_inv ON ".$glob[dbprefix]."CubeCart_order_sum.cart_order_id = ".$glob[dbprefix]."CubeCart_order_inv.cart_order_id WHERE ".$glob[dbprefix]."CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($_GET[cart_order_id])." AND ".$glob[dbprefix]."CubeCart_order_sum.cart_order_id=".$db->mySQLsafe($ccUserData[0][cart_order_id]);
$prodArray = $db->select($query);
if($prodArray == TRUE)
{
foreach($prodArray as $prodBought) {
$prodList[] = $prodBought[productId];
}
foreach($basket[conts] as $key => $value){
$i++;
$productId = $cart->getProductId($key);
if (in_array($productId, $prodList)) {
$view_cart->assign("SUCCESS2","You have already purchased this product.");
$view_cart->parse("view_cart.repeat_cart_contents.duplicate");
}}}}
I have a digital product store and a lot of time customers dont realize that they have purchase a downloadable product before and accidently order it again. Resulting in an email..and the time it takes for me to issue a refund, or give them another design.
I would like to code the cart page to alert customers that are logged in via a message below the product they enter telling them that tada.."You have purchsed this product before"
Heres the code I have so far but im not getting the message when i test adding a product that I have already have on the test account:
Code:
if($ccUserData[0][customer_id]>0)
{
$query = "SELECT * FROM ".$glob[dbprefix]."CubeCart_order_sum INNER JOIN ".$glob[dbprefix]."CubeCart_order_inv ON ".$glob[dbprefix]."CubeCart_order_sum.cart_order_id = ".$glob[dbprefix]."CubeCart_order_inv.cart_order_id WHERE ".$glob[dbprefix]."CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($_GET[cart_order_id])." AND ".$glob[dbprefix]."CubeCart_order_sum.cart_order_id=".$db->mySQLsafe($ccUserData[0][cart_order_id]);
$prodArray = $db->select($query);
if($prodArray == TRUE)
{
foreach($prodArray as $prodBought) {
$prodList[] = $prodBought[productId];
}
foreach($basket[conts] as $key => $value){
$i++;
$productId = $cart->getProductId($key);
if (in_array($productId, $prodList)) {
$view_cart->assign("SUCCESS2","You have already purchased this product.");
$view_cart->parse("view_cart.repeat_cart_contents.duplicate");
}}}}
|
|
Search Webmaster Help and Solution
Alerting a Customer of a Duplicate PurchaseRelated ItemsQuery failed: connection to localhost:3354 failed (errno=111, msg=Connection refused). |