Answers

• webprophets Posts: 18Questions: 5Answers: 0

  December 2014

  I found another issue
  in my datatables , there are two data type with two datatime picker
  the first one is working, but for the second one, I can not get data on server end.

  how to modify the plugin code to make it work?

  Thanks
• allan Posts: 61,627Questions: 1Answers: 10,090 Site admin

  December 2014

  Hi,

  Could we possibly continue this discussion in a single thread please? Hadn't realised that you'd already resolved the Bootstrap issue before replying to your previous thread. Thanks!

  but some datatime picker icon gone. any idea ?

  It looks like there is an error in the plug-in where it doesn't actually specify what icon should be shown! Where it has:

  `'<span class="input-group-addon"><span class="glyphicon"></span>'+

  Can you replace it with:

   '<span class="input-group-addon"><span class="glyphicon glyphicon-calendar"></span>'+
  

  I'll update the site tomorrow morning.

  TypeError: $.fn.datetimepicker.dates is undefined

  I've just tried the URL you PM'ed me, but the server doesn't appear to be responding at the moment. I'll try again later on.

  Regards,
  Allan
• webprophets Posts: 18Questions: 5Answers: 0

  December 2014

  Hi Allen

  Sorry about multiple thread.
  I have solved icon miss issue by adding bootstrap font js css file , you may need mention these on bootstrap plugin document page as well:)

  the "TypeError: $.fn.datetimepicker.dates is undefined" seems that come from format function.

  After I change my php code to

              ->setFormatter(
                      function ( $val, $data, $opts ) {
  
                  return date('Y-m-d H:i:s', strtotime($val));
              }
              )
  

  it works

  But, for datetime picker, your validator function is not that quite right working

  if I code like this

            ->validator( 'Validate::dateFormat', array( 'empty'=>false, 'format'=>'m/d/Y h:i A' ) )
  

  it shows format doesn't match, but I check the http request , the format should be right, which means your validator function may not go through formate with min sec?

  I also try to customize validator code as below for testing

              ->validator(function ( $val, $data, $opts ) {
  
                  if (strlen( $val ) !=0) {
                      return true;
                  } else
                      return "time should not be null";
              })
  

  it works in some case.

  But I found a bug with two datetime picker on one table.

  Because datetime picker will auto fill up the text input, even you delete the text( leave it blank)( which is kind of no empty validation? I don know, but it helps)

  But if you delete one datetime picker text input(or try random funny input) , then delete (or try random funny input) for the second datetime picker, (When you input on the second one, the first datetime picker will auto fill the date back, it is fine, but......)

  the firebug will pop out "TypeError: conf._input.data(...).getDate(...) is null"
  and page is not working anymore.

  For testing this bug, you can try the html page I send you before. ( I will delete that page in couple days later, this bug is there , but not that important for us)
• webprophets Posts: 18Questions: 5Answers: 0

  December 2014

  One more question

  If I have two database , how to set up the config.php fire?or I can create two editor files with different name under Datatables extensions directory ?
• allan Posts: 61,627Questions: 1Answers: 10,090 Site admin

  December 2014

  Hi,

  which means your validator function may not go through formate with min sec?

  It should do - however, I've just tried the page you sent me before, at it looks like the data for the date/time is being sent in a full Javascript format. For example:

  data[time] Sat Apr 25 2015 18:37:00 GMT+0100

  This is a function of moment.js's toString() method - it returns that format unless otherwise specified. You could modify the plug-in code to replace .toString() with .format(...) - or possibly update the PHP to validate the moment.js returned string. Possibly I should update the plug-in so it returns an ISO format which might be a bit more useful than the JS format. Your thoughts are welcome!

  But I found a bug with two datetime picker on one table.

  Thanks for letting me know about that. I'll take a look into it and try to see what the problem is.

  If I have two database , how to set up the config.php fire?or I can create two editor files with different name under Datatables extensions directory ?

  The DataTables.php file will automatically create a database connection based on the options in config.php. However, you can also use the Database class to create another database connection, in exactly the same way DataTables.php does, if you need. The documentation for that class is available here.

  Regards,
  Allan
• allan Posts: 61,627Questions: 1Answers: 10,090 Site admin

  December 2014

  Update on the date / time picker. I've just made a change to the plug-in which will cause it to submit the value from the text box, rather than the Moment.js defined value (it was submitting a Javascript date / time string which wasn't much use...).

  Updated plug-in is available here: http://editor.datatables.net/plug-ins/field-type/editor.datetimepicker-2

  Regards,
  Allan