[JesterRoberts]

I have startTime and endTime columns in my table which are MySQL time type.

I'd like to show them in grocery crud in hh:mm format and possibly have a dropdown list of 30min increments in the editor.

 

Id this possible?

[davidoster]

If the fields are set within MySQL as time then Grocery CRUD displays it in hh:mm:ss format so you don't need to do anything.

If you just need to omit the ss (seconds) just use the callbacks (callback_field, callback_column) to change the format.

 

As far as it concerns the dropdown list of 30 mins try to use the field_type function.

[JesterRoberts]

Yes I'd like to only display hours and minutes.

The documentation on callbacks is very brief and I'm not exactly sure how to apply it to my problem.

Can you give or point to an example of callbacks being used to change the way a field is displayed?

Thanks.

[JesterRoberts]

Ok as far as I can tell this I should be using callbacks something like this but I'm really not sure.

The fields are displayed correctly but times are never updated in the database.

 

    public function program()
    {
        $this->grocery_crud->set_table('program');
        $this->grocery_crud->field_type('startTime','dropdown', array('1' => '00:30',
                                                                        '2' => '01:00',
                                                                        '3' => '01:30',
                                                                        '4' => '02:00'));
        $this->grocery_crud->callback_column('startTime',array($this,'formatTime'));
        $this->grocery_crud->callback_before_insert(array($this,'beforeInsert'));
        $output = $this->grocery_crud->render();


        $this->_example_output($output);        
    }
    public function beforeInsert ($fields)
    {
        $fields['startTime'] = $fields['startTime'] . ":00";
        return $fields; 
    }
    public function formatTime ($value, $row)
    {
        return substr($value, 0, -3);  
    }
 

[davidoster]

Date and/or Time are different field types in PHP and not a string. This is the reason that they are not stored in MySQL.

See an example here, http://stackoverflow.com/questions/2767068/adding-30-minutes-to-time-formatted-as-hi-in-php

[Paul Savostin]

If the fields are set within MySQL as time then Grocery CRUD displays it in hh:mm:ss format so you don't need to do anything.

If you just need to omit the ss (seconds) just use the callbacks (callback_field, callback_column) to change the format.

 

As far as it concerns the dropdown list of 30 mins try to use the field_type function.

Hi! Where did you see the "time" in GC field_type?