Module: FieldtypeTime & InputfieldTime

[netcarver]

I've just posted a Fieldtype and Inputfield module combination that support the use of MySQL time fields in ProcessWire. Ryan's Datetime module is great but I needed something that dealt specifically with times for a scheduling system and this is one of the results.

For 24 hour clock format ('HH24MM') you now get a clock-picker pop-up by default...

...but you can inhibit it if you don't want it...

Although the input time format is selectable, as this is stored as a MySQL time field, you currently need to specify values in selectors in full "H:MM:SS" format. So if you wanted to get all events starting on or after 9am you'd do something like this...

$events = $pages->find("template=events, starts>=9:00:00")->sort("starts");

This is definitely a beta module as I've not tested every single input format yet.

Currently does not support negative time-periods or fractions of a second.

FieldtypeTime on Github

FieldtypeTime in the Module Repository 

 

Releases

Version 0.2.0: Adds support for the use of this input field in repeaters and repeater matrix types.

Version 0.1.0: Adds clock picker.

[Martijn Geerts]

I have sneaked around this feature many times with dirty solutions. Thanks for making this Steve.

[netcarver]

Now added to the module repo and the opening post has been updated. Please report any issues with installation/use here.

Thank you!

[gebeer]

Thank you for the module.

I'm using it on a site in development as input for publishing times. Discovered no problems so far. All is running smoothly.

Have you considered adding optional JS to the field for user friendly input through a time picker like http://jonthornton.github.io/jquery-timepicker/ ?

[netcarver]

@gebeer

Thank you for the feedback - glad this is working for you. For this Inputfield I deliberately wanted to have a way of quickly entering things from the keyboard but I do appreciate that some folks might want a way of adding a JS picker to this. When I'm less busy with my current project I'll look at re-visiting this to add one. If anyone else has additional suggestions for a candidate time-picker, please drop a note below. 

[gebeer]

@netcarver

here are some more timepickers that I was looking at when trying to quickly implement one with your field:

https://fgelinas.com/code/timepicker/ : this one is based on jQuery UI

http://jdewit.github.io/bootstrap-timepicker/ : personally, I like this one best, but it relies on Bootstrap and I couldn't get it to work with BS 3 and with other date fields present in the same form

http://weareoutman.github.io/clockpicker/jquery.html : funny picker looks like a clock

http://amsul.ca/pickadate.js/

[netcarver]

@gebeer

I'm starting to play with adding clockpicker (which I find really intuitive) to the inputfield. Here's a screenshot...

...what do you think? Of course, this is only valid for HH24MM format times.

[Martijn Geerts]

I love it Steve !

[netcarver]

I just pushed a new branch to the github repository that adds the clockpicker popup as seen in the screenshot above. If you want to try it simply use the files from the clockpicker branch. If all goes well with your testing I'll merge this change into the master branch and bump the version.

Thanks!

[Marty Walker]

That's excellent!

[Nico Knoll]

@steve: Looks great

[netcarver]

I've now added clock-picker to the master branch and bumped the version number. Please see the opening post for more details. 

[gebeer]

Looks great, thank you!

[Beluga]

Thanks for the module.

How can I prevent it from populating the field (with 00:00:00) by default?

[netcarver]

Hi Beluga,

Do you need a configurable value or just a blank as a default?

[Beluga]

Hi Beluga,

Do you need a configurable value or just a blank as a default?

Blank by default would be the best as it's in line with how Datetime behaves. Configurable is fine by me, though, if you have a usecase for populating by default.

[gebeer]

I updated my site from 2.5.2 to 2.6.3 with the ProcessUpgrade Module.

When updating InputfieldTime (also through ProcessUpgrade Module) I got a worning that it is not compatible with 2.6. I went ahead anyways to see what will happen.

After upgrade I got 2 Warnings:

ModulesDuplicates: There appear to be multiple copies of module "FieldtypeTime" on the file system. Please edit the module settings to tell ProcessWire which one to use:FieldtypeTime

ModulesDuplicates: There appear to be multiple copies of module "InputfieldTime" on the file system. Please edit the module settings to tell ProcessWire which one to use:InputfieldTime

and a message:

InputfieldTime was updated successfully.

Button: Continue to module settings

In the module settings I got:

There are multiple copies of this module. Select the module file you want to use.

 

/site/modules/InputfieldTime/InputfieldTime.module (the new one after update)

/site/modules/PW-FieldtypeTime/InputfieldTime.module (the old one)

 

I chose the new one.

 

Then I did the same for Fieldtype Time module.

 

Everything seems to be working fine with 2.6.3

 

Just wanted to let you know.

 

[Juergen]

@netcarver,

first of all thanx for the awesome module.

Are there any news about a blank value as Beluga pointed out? I also need a blank value for opening hours.

Best regards

[netcarver]

@Beluga, @Juergen

Thanks for pressing me on this. I've just been testing this in PhpMyAdmin and there seems to be a problem with trying to set a blank value to MySQL time fields; MySQL itself sees the blank as an invalid time and sets it to '00:00:00'. There is some more detail about this in the MySQL Time type manual page. Here's a quote from the linked manual page...

Illegal TIME values are converted to '00:00:00'. Note that because '00:00:00' is itself a legal TIME value, there is no way to tell, from a value of '00:00:00' stored in a table, whether the original value was specified as '00:00:00' or whether it was illegal.

You could setup your own test table with a TIME field and try it yourself. Please let me know if you find a workable solution and I'll try and work it into the module. At this point in time I'm not sure how to prevent PW from trying to save a blank value into the DB if nothing is entered in the Inputfield.

[netcarver]

@geeber

I'm not sure how the duplicate modules got into your filesystem but I've updated the module information to show compatibility with 2.6.

[Pete Jones]

I'm using Netcarver's FieldtypeTime module and I'm trying to sort results by time (in 24hr format hh:mm) but the following doesn't seem to work. My time field is fde_racetime.

foreach ($page->children("fde_date>$todaysDate,sort=fde_date,sort=fde_racetime") as $alldays) {
    foreach ($alldays->fde as $entry) {
      if ($entry->fde_declared == 1) {
        $section_main .= showFDE($alldays, $entry);

      }
    }
  }

Would I need to create a specific sort condition?

http://modules.processwire.com/modules/inputfield-time/

Edited May 24, 2016 by kongondo
Moved: For modules that have support forums, please post such questions in their respective forums

[netcarver]

Hello Pete,

I'm trying to sort results by time (in 24hr format hh:mm) but the following doesn't seem to work.

Just to clarify; are you getting a non-empty, but incorrectly sorted, result set for that selector?

[bernhard]

needed this today! thank you!

[Zahari M.]

Hi Steve

When i use this field in the profields repeater matrix, the clock picker no longer works.

But outside of the repeater matrix, it works fine.

Within the repeater, we do not get <script type="text/javascript">$('.clockpicker').clockpicker();</script> added. I guess that  is the cause.

Any ideas what could cause that and how we can get it to show up?

Cheers

 

[netcarver]

@Zahari Majini

Apa khabar, Zahari? I guess that the JS and/or the CSS file from InputfieldTime isn't getting loaded in that context, I don't know why yet.

Steve