Joomla Extensions Club 20,483 posts

[erik09 Friend erik09Join date: May 2014Posts: 5Downloads:1Uploads:0]

#203955

Hi,

I have an extrafield “date” with the format is dd-mm-yyy. I want to be able to filter a range of years (i.e. from 1856 till 2011) with the use of a slider.

I realise that I will have to hack the script in order to do this. However this task should not be too difficult, as it is easy with PHP to convert a date format into a number.

Perhaps you can push me in the right direction by telling me where in the script I should start looking in order to make these alterations.

Thanks & regards,

Erik

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#560509

Hi Erik,

Our developer had a look at your question, pls give him more time to investigate further.

We will answer you soon with some suggestions.

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#560633

Hi,

We have a suggestion like this:
1. In module, add range slider to date type format. You can choose the value of year maximum and minimum.
Edit in file: modulesmod_jak2filterelementsk2extrafield.php copy line 270 to 249.
2. In front-end, when searching, add value to make the number to date format, for example user select a range from 1999 to 2010 we will add it to: from 1-1-1999 to 31-12-2010
Edit in file: componentscom_jak2filtermodelsitemlist.php from line 1308 to 1318,
– Check Data type is Date then adding the suffix to minimum value and maximum value.

[eabe Friend eabeJoin date: December 2012Posts: 4Downloads:211Uploads:0]

#903402

I can only see break; in line 270 and also the same in 249.

Can you please explain again what exactly needs to be copied and where?

Thanks

[The Captain Moderator The CaptainJoin date: December 2014Posts: 66Downloads:74Uploads:19 Thanked: 11 times in 11 posts]

#904629

Hi eabe,

You can try with my tweak here:

• In the file modules/mod_jak2filter/elements/k2extrafield.php, +/ Search the snippet of code:

  case 'date':
  $typeOptions[] = JHTML::_('select.option', $prefix.'date', JText::_('FILTER_TYPE_DATE'));
  $typeOptions[] = JHTML::_('select.option', $prefix.'daterange', JText::_('FILTER_TYPE_DATERANGE'));

  Replace by the code:

  case 'date':
  $typeOptions[] = JHTML::_('select.option', $prefix.'date', JText::_('FILTER_TYPE_DATE'));
  $typeOptions[] = JHTML::_('select.option', $prefix.'daterange', JText::_('FILTER_TYPE_DATERANGE'));
  $typeOptions[] = JHTML::_('select.option', $prefix.'rangeslider', JText::_('FILTER_TYPE_RANGE_SLIDER'));

• In the file components/com_jak2filter/models/itemlist.php, search the snippet of code:

  case 'range':
    list($from, $to) = explode('|', $value);
             if($from != '') {
                   $from = (int) $from;
                   $searchPattern = $prefix.$this->rgRange($from, 1);
                    $where[] = "(i.extra_fields REGEXP '".$searchPattern."')";
               }
               if($to != '') {
                     $to = (int) $to;
                      $searchPattern = $prefix.$this->rgRange($to, 0);
                      $where[] = "(i.extra_fields REGEXP '".$searchPattern."')";
                }
                break;

  Replace by the code:

  case 'range':
                              preg_match_all('/[0-9]+/',$field, $matches);
                              $fxid = $matches[0][0];
                              list($from, $to) = explode('|', $value);
                              if($from != '') {
                                  if($this->isDateFX($fxid))
                                  {
                                      $from = $from.'-01-01';
                                      $searchPattern = $prefix.$this->rgRange($from, 1, 'date');
                                  }else
                                  {
                                      $from = (int) $from;
                                      $searchPattern = $prefix.$this->rgRange($from, 1);
                                  }
                                  $where[] = "(i.extra_fields REGEXP '".$searchPattern."')";
                              }
                              if($to != '') {
                                  if($this->isDateFX($fxid))
                                  {
                                      $to = $to.'-12-31';
                                      $searchPattern = $prefix.$this->rgRange($to, 0, 'date');
                                  }else
                                  {
                                      $to = (int) $to;
                                      $searchPattern = $prefix.$this->rgRange($to, 0);
                                  }
                                  $where[] = "(i.extra_fields REGEXP '".$searchPattern."')";
                              }
                              break;

  Hope this helps.

[Author]

Posts