List of the customer's historical serials

  • Posts: 29
  • Thank you received: 0
  • Hikaserial Subscription Hikashop Business
5 months 3 days ago #362260

-- HikaShop version -- : 5.1.0
-- HikaSerial version -- : 5
-- Joomla version -- : 5.1.1
-- PHP version -- : 8.2.19

Hi,

When the order is created and confirmed - the customer can see his serials (after login in the User Data / Serials) = everything is OK

But if the order is not created - and the Serial is created & assigned to the customer - then after customer login in the User Data / Serials = this serial is not listed

The question:
Is there a way to display customer's serials for him (in his profile after login) - if he doesn't created any order yet?
It is needed if I would like to provide a list of previously purchased licenses for him...

Please Log in or Create an account to join the conversation.

  • Posts: 26166
  • Thank you received: 4029
  • MODERATOR
5 months 2 days ago #362267

Hello,

The fact that the customer can't see these serials depends on the "display serials for customer" setting :
www.hikashop.com/support/documentation/1...ation.html#main_main
By default, we consider that an order which is not created should not let the customer see (and use) the serial.
But, the serial can be "reserved", so when the order is "confirmed" the serial become visible (and if you cancel and confirm back the order, the serial stay the same).

Afterwards, HikaSerial provides a customer interface to see the list of serials.
Even if you create a serial manually in the backend, as long as the serial status is authorized to be display (the mentioned setting above), it will be visible in that listing.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 29
  • Thank you received: 0
  • Hikaserial Subscription Hikashop Business
5 months 2 days ago #362282

Sorry, but based on your instruction I'm not able to list Serials for customer without order

1. Configuration
Display status for customer: Assigned + Used + Reserved

2. Pack named "Test"
Pack data: Pack SQL Data
Pack Generator: -

3. Serial:
Serial Data: LicXYZ
Pack: Test
Status: "Used" or "Reserved" or Assigned" ...not any effect
Assign date: -
Order number:-
User: UserXY

Please Log in or Create an account to join the conversation.

  • Posts: 26166
  • Thank you received: 4029
  • MODERATOR
5 months 2 days ago #362288

Hello,

You're right !
The HikaSerial Serial listing is doing a query with a link with HikaShop orders.

To fix that behavior, you need to edit the file under "components/com_hikaserial/views/serial/view.html.php" and change the lin

' INNER JOIN '.hikaserial::table('shop.order').' AS hk_order ON serial.serial_order_id = hk_order.order_id ';
By
' LEFT JOIN '.hikaserial::table('shop.order').' AS hk_order ON serial.serial_order_id = hk_order.order_id ';
Then, in the "serial / listing" view (via the override or edit manually the file which is in the "tmpl" sub folder)
Replace
			<td class="hikaserial_serial_ordernumber_value">
				<a href="<?php echo hikashop_completeLink('order&task=show&cid='.(int)$serial->serial_order_id); ?>"><?php
					echo $serial->order_number;
				?></a>
			</td>
By
			<td class="hikaserial_serial_ordernumber_value">
<?php if(!empty($serial->serial_order_id)) { ?>
				<a href="<?php echo hikashop_completeLink('order&task=show&cid='.(int)$serial->serial_order_id); ?>"><?php
					echo $serial->order_number;
				?></a>
<?php } else {
		echo JText::_('HIKASERIAL_NO_ORDER');
	} ?>
			</td>
And you should see serials without an order linked.
(that modification will be in the next release).

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: Pajerchin

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.061 seconds
Powered by Kunena Forum