Orders list: calendar filter not working

  • Posts: 215
  • Thank you received: 7
  • Hikaserial Subscription Hikashop Business
10 months 1 week 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: 70194
  • Thank you received: 10508
  • MODERATOR
10 months 1 week 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: 218
  • Thank you received: 8
  • Hikashop Business
9 months 1 week 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
9 months 1 week 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: 70194
  • Thank you received: 10508
  • MODERATOR
9 months 1 week 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: 218
  • Thank you received: 8
  • Hikashop Business
9 months 1 week 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.

  • Posts: 138
  • Thank you received: 2
  • Hikashop Business Hikashop Essential
1 month 2 weeks ago #321259

Hello,
I'm having the same problem in the latest version fo Hikashop, it seems the code is there, but I cannot select and filter orders by a date range when view Orders in the backend.

Thanks

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

  • Posts: 70194
  • Thank you received: 10508
  • MODERATOR
1 month 2 weeks ago #321265

Hi,

All the patches regarding the date filtering on the orders listing are indeed included in the current version and no one else reported an issue with it in the latest version.
In that case, I don't know what could be the problem. I would need a backend access to check the situation.
Also, did you try with another browser ? Maybe it's linked to that.

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

  • Posts: 138
  • Thank you received: 2
  • Hikashop Business Hikashop Essential
1 month 2 weeks ago #321331

Nicolas,
Sent login details and a reference to this thread. Thanks

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

  • Posts: 70194
  • Thank you received: 10508
  • MODERATOR
1 month 2 weeks ago #321354

Hi,

You have a custom date format setup. But it has issues with the Joomla calendar selector we're using there when you don't have the same format for the extended date format.
I've changed it so both uses dashes instead of spaces and it works fine now.

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

  • Posts: 138
  • Thank you received: 2
  • Hikashop Business Hikashop Essential
1 month 1 week ago #321423

Awesome thanks :-)

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

Time to create page: 0.086 seconds
Powered by Kunena Forum