X-Cart forums - Case Insensitive Coupon Codes

Hi,

The following patch should do the trick:

HTML Code:

Index: src/classes/XLite/Module/CDev/Coupons/Model/Repo/Coupon.php

IDEA additional info:

Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP

<+>UTF-8

===================================================================

--- src/classes/XLite/Module/CDev/Coupons/Model/Repo/Coupon.php    (revision 0ccac487726f63245ce987723148dcef1575ca44)

+++ src/classes/XLite/Module/CDev/Coupons/Model/Repo/Coupon.php    (date 1559578157000)

@@ -91,7 +91,7 @@

     protected function defineFindOneByCode($code)

     {

         $queryBuilder = $this->createQueryBuilder('c')

-            ->andWhere('COLLATE(c.code, utf8_bin) = :code')

+            ->andWhere('LOWER(COLLATE(c.code, utf8_bin)) = LOWER(:code)')

             ->setParameter('code', $code);

 

         return $queryBuilder;

Quote:

Originally Posted by CCP

Is it possible to change Coupon codes to be case-insensitive?

We have a fair number of clients who complain that they can't enter the codes, when it turns out they aren't typing them in ALLCAPS.