- Posts: 29
- Thank you received: 0
List of the customer's historical serials
2 years 2 months ago #362260
by Pajerchin
List of the customer's historical serials was created by Pajerchin
-- 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...
-- 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.
2 years 2 months ago #362267
by Jerome
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.
Replied by Jerome on topic List of the customer's historical serials
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,
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.
2 years 2 months ago #362282
by Pajerchin
Replied by Pajerchin on topic List of the customer's historical serials
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
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.
2 years 2 months ago #362288
by Jerome
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.
Replied by Jerome on topic List of the customer's historical serials
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
By
Then, in the "serial / listing" view (via the override or edit manually the file which is in the "tmpl" sub folder)
Replace
By
And you should see serials without an order linked.
(that modification will be in the next release).
Regards,
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
Code:
' INNER JOIN '.hikaserial::table('shop.order').' AS hk_order ON serial.serial_order_id = hk_order.order_id ';
Code:
' LEFT JOIN '.hikaserial::table('shop.order').' AS hk_order ON serial.serial_order_id = hk_order.order_id ';
Replace
Code:
<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>
Code:
<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>
(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.202 seconds