How to remove used Serials display in user account

-- HikaShop version -- : 4.7.2
-- Joomla version -- : 4.2.9

Hi,
I have added the ability to customers to see their own serials (coupon codes), in their account, but, is there a way to show only the not used once, or, add a row with the status of it. In the db there is a serial_status, but where or how to use it to get the right info displayed?

Thank you
Xavier

Hello,

Serials and coupons are two different entities.

The Serial is a "generic" content created in HikaSerial via a plugin.
The Coupon is a data from HikaShop.

When you use the "coupon generator" in HikaSerial, in the same time that the serial is generated, an HikaShop coupon code is created too.
But when you use the coupon in HikaShop, you do not have an interaction with the Serial.

Regards,

Hi,
ok, thanks, but the db contains a value status, this value is updated when a serial is used and becomes useless for an other use, so it should be possible to change the 'listing' display to only show the serials not used, or do I missunderstand something?

Merci
Xavier

Hello,

The serial has a status ; that status evolve depending the action performed.
If you're using a "consumption" plugin, a serial can be changed from "assigned" to "used".
But when you're using an HikaShop coupon, you're just using the coupon code ; not the HikaSerial serial.

Regards,

Hi,
yes, ok, I agree, but as the hikashop_discount_code is the same as hikaserial_serial_data, the search is easily done with an inner join, to display the hikashop code used yes or no (if 1 then used else available) in the hikaserial list shown on the user page.

I'm ok with sql, should find how to display it in php, but never 'played' with joomla code

Merci
Xavier

Hello,

Sure ; if you consider that all your HikaShop codes have a correct quota.

In the Serial table, the discount_id is stored in the Serial "extra data", which can be used to directly access to the coupon (without trying to perform a join on a text field).

Regards,

Hi Jerome,
thanks for the answer. Could you please have the patience to explain me how, because I cannot find the right way to do so.

Thanks