× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Change format of Calendar (J_Calendar)

9 years 2 weeks ago #688 by Nick Gardei
Replied by Nick Gardei on topic Change format of Calendar (J_Calendar) - BUG FOUND
I modified my form XML file as Russell pointed out here - www.component-creator.com/wiki/index.php...ndar_(Date_Selector)  to change the format of the date generated in the date selector. As expected, this date format did not match up with the search function and an error was returned;

COM_PRUEBA_SEARCH_FILTER_DATE_FORMAT

Since the name of my component is 'com_boardmeeting' and not 'com_prueba' this seemed odd to me, so I did some digging. In the site side 'meetings' model I found this;
if ($error_dateformat)
      {
         $app->enqueueMessage(JText::_("COM_PRUEBA_SEARCH_FILTER_DATE_FORMAT"), "warning");
Sure enough I have this entry in my language file, but prefixed with my component name. After changing 'PRUEBA' to 'BOARDMEETING' the readable error from the language file shows up.

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

9 years 2 weeks ago - 9 years 2 weeks ago #689 by Nick Gardei
Replied by Nick Gardei on topic Change format of Calendar (J_Calendar)
Now with the error at least showing correctly I know I'm on the right path to changing the date format.

It appears that if I modify this function the search may work (or at least not return the error). I'll report back for Russells sake when I'm done tinkering.

(In the same model file that I found the bug)
private function isValidDate($date)
   {
      return preg_match("/^(19|20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$/", $date) && date_create($date);
   }

I would like to stress that the ability to change the date format for a component centrally, even if not in a language file would be much appreciated. I personally prefer the default Y-M-D format since it's easily understandable anywhere in the world, but several times now I have needed to change it in a component or my customer would not accept.
Last edit: 9 years 2 weeks ago by Nick Gardei. Reason: Update formatting for easier reading

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

9 years 2 weeks ago #690 by Nick Gardei
Replied by Nick Gardei on topic Change format of Calendar (J_Calendar)
Long story short is this;

Even after changing the preg_match to validate (return true) for my date format the search still fails.

There is yet another place where the preg_match needs to line up -  inside the getListQuery() function in the same file.
//Checking "_dateformat"
      $filter_date_from = $this->state->get("filter.date_from_dateformat");
      if ($filter_date_from && preg_match("/^(19|20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$/", $filter_date_from) && date_create($filter_date_from) ) {
         $query->where("a.date >= '".$db->escape($filter_date_from)."'");
      }

However this STILL won't work because the data is stored in the table in YYYY-MM-DD format.

Ugh....frustrating for something so simple. I've literally wasted 6 hours so far on this one tiny detail.

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

9 years 2 weeks ago - 9 years 2 weeks ago #691 by Russell English
Replied by Russell English on topic Change format of Calendar (J_Calendar)
Hi Nick, I'm glad it's not just me that was having difficulty with this.

Changing the date format should be a simple procedure and should be managed with a Language override within the CMS itself (as many other components and Joomla itself do).

Thanks for the updates though and for keeping me in the loop.
Last edit: 9 years 2 weeks ago by Russell English.

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

9 years 2 weeks ago #694 by Søren Beck Jensen
Replied by Søren Beck Jensen on topic Change format of Calendar (J_Calendar)
We are looking into the COM_PRUEBA issue and I am happy to report that it looks like someone will be buying "f**k up beer" this Friday, which is tradition when someone makes a stupid mistake in our company. If you are in or around Granada, Spain you are invited.

In relation to making it easier to change the date format, then we will investigate what we can do to make this easier to do.

Søren Beck Jensen
Founder, Component-Creator.com
The following user(s) said Thank You: Russell English

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

8 years 10 months ago #790 by Russell English
Replied by Russell English on topic Change format of Calendar (J_Calendar)
Hi Søren, is there any update on this please?

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

Time to create page: 0.187 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.