Orders list: calendar filter not working

  • Posts: 215
  • Thank you received: 7
  • Hikaserial Subscription Hikashop Business
3 months 2 weeks ago #311520

-- HikaShop version -- : 4.2.1
-- Joomla version -- : 3.9.11
-- PHP version -- : 7.2.22

Hello,

in the order list the calendar filter behaves in an odd way

on firefox: www.screencast.com/t/AC60JWgnk
date is auto-filled with seemingly random dates, orders list is always blank no matter if I hit the "clear" button in the calendars or try to change the date or the other filters settings

on chrome www.screencast.com/t/L9tXy9MbN2
I managed to filter the orders by status the first time, but after that the filtered lists never change anymore, no matter if I chnage the dates in the calendar or clear out the other filters values. After a while it began behaving exactly like on firefox (dates auto-completing with random values with every search)

The only message I see in Chrome Console is:
JQMIGRATE: Migrate is installed, version 1.4.1
extension.js:24 onMessage extension
ial.js:425 Clean the cache of the scraper (new onComplete event)


Thank you

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

  • Posts: 67874
  • Thank you received: 10101
  • MODERATOR
3 months 2 weeks ago #311521

Hi,

Thank you for your feedback.
We'll add some patch for that in the next version of HikaShop.

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

  • Posts: 206
  • Thank you received: 7
2 months 3 weeks ago #312596

Hello,

We are working with version 4.2.2 and encounter the same problem. Tested Chrome, FireFox and Edge browsers. Date order filters just stopped working.
In addition, reports are acting weird as well. Selecting specific dates will give the month before. Something went horribly wrong with the last updates :(

Guy.

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

  • Posts: 215
  • Thank you received: 7
  • Hikaserial Subscription Hikashop Business
2 months 3 weeks ago #312609

Yes, I just updated to 4.2.2 and can confirm that still have issues with order list, especially when using dates to order the list. My list always showes the last orders, no matter which dates range I select.
I can provide access to a test site if you need to debug.

thanks

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

  • Posts: 67874
  • Thank you received: 10101
  • MODERATOR
2 months 3 weeks ago #312611

Hi,

I actually did a few tests and at first I didn't see any issue.
In fact, I only saw the issue after I used the start and end date filters at the same time.
And I found out why.
The line:

$filters[] = 'b.order_created > '.(int)$filter_start. ' AND b.order_created < '.(int)$filter_end;
which should be after the code:
$filters[]='b.order_created > '.(int)$filter_start;
						$pageInfo->filter->filter_start=(int)$filter_start;
						break;
					default:
						$filter_end = hikashop_getTime($pageInfo->filter->filter_end, '%d %B %Y');
						$pageInfo->filter->filter_start=(int)$filter_start;
						$pageInfo->filter->filter_end=(int)$filter_end;
in the file administrator/components/com_hikashop/views/order/view.html.php had been removed while fixing the different issues with these filters for the 4.2.2.
I've added it back and now it's working fine too when you have the two date filters used at the same time.
I've added that patch on our end so you can just download the install package on our website and install it on yours to get that patch.

The following user(s) said Thank You: oloccina

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

  • Posts: 206
  • Thank you received: 7
2 months 3 weeks ago #312612

Thank you Nicolas. That was indeed it. After adding the code back to the file everything returned working.

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

Time to create page: 0.070 seconds
Powered by Kunena Forum