Updatecol and Date Filter Range

[SteveRL]

I understand the updatecol plugin cant function when a date has a range filter: http://fabrikar.com/forums/index.php?threads/updatecol-list-plugin.49127/

What about as a workaround, setting the date field to 'field' so updatecol functions correctly, then modifying a custom lists template default_buttons.php file? Could some code be manually added there to display a range for that field?

 

[troester]

Do you need the range filter and the updatecol at the same time?
If not you can copy your list, use one for filtering and the other one (date element without filter) with the updatecol plugin.

 

[SteveRL]

Yes I do need them at the same time and it's quite critical to have the functionality. I think I found a complicated path forward. I determined I couldn't drop the range filter because I'm doing things that depend on the range like this for other processes:

//Capture the Filter Array (Date Range of element 402)
$EventDateFilter = FabrikHelperElement::filterValue(402);
$PreRangeFrom = $EventDateFilter[0];
$PreRangeTo = $EventDateFilter[1];

So I created a new (hidden) date element 'event_date_update_col' and I modified the update_col plugin to be able to update this elements and not the 'event_date' field (which has a range filter). I then added the following code to the Post_Eval section of the plugin:

$db = JFactory::getDBO();
$ids = JRequest::getVar( 'ids', array(), 'method', 'array' );
$rowids = implode(', ', $ids);
foreach ($ids AS $id) {  
  $row = $model->getRow($id);
  $ID_event_date = $row->event_schedule___event_date;
  $ID_event_date_update_col = $row->event_schedule___event_date_update_col;
    $UpdateQuery="
    UPDATE event_schedule
    SET event_date = event_date_update_col
    WHERE '$ID_event_date' != '$ID_event_date_update_col'
    AND '$ID_event_date_update_col' > '1980-01-01 01:01:01'
    AND event_id IN ($rowids);
    ";
                
        $db->setQuery($UpdateQuery);
        $count++;
        $db->execute();
        }

So after the update_col plugin is used, the query checks for values in the 'event_date_update_col' and copy's them over to 'event_date'. Seems to be working

 

[cheesegrits]

Yup, that's pretty much what I would have done.

Note that JRequest is deprecated, you should use the input class instead ...

$app = JFactory::getApplication();
$ids = $app->input->get('ids', array(), 'array');

-- hugh

 

[SteveRL]

Appreciate that Hugh, I've updated that in about 6 places and made a note so I don't use it again.