Lines Matching refs:filter
100 'filter' => []
176 case 'filter':
188 $data['filter'][] = $flt;
386 foreach ($filters as $filter) {
387 if (strpos($filter['compare'], 'LIKE') !== false) {
388 if (strpos($filter['compare'], 'NOT') !== false) {
389 $comparator_value = '!~' . str_replace('%', '*', $filter['value']);
391 $comparator_value = '*~' . str_replace('%', '', $filter['value']);
393 $fltrs[] = $filter['key'] . $comparator_value;
395 $fltrs[] = $filter['key'] . $filter['compare'] . $filter['value'];
399 $text .= '<div class="filter">';
657 if (is_array($data['filter']) && count($data['filter'])) {
658 foreach ($data['filter'] as $filter) {
659 $col = $filter['key'];
660 $closecompare = ($filter['compare'] == 'IN(' ? ')' : '');
663 $where2 .= " " . $filter['logic'] . " pages.page " .
664 $filter['compare'] . " " . $filter['value'] . $closecompare;
666 $where2 .= " " . $filter['logic'] . " pages.class " .
667 $filter['compare'] . " " . $filter['value'] . $closecompare;
669 $where2 .= " " . $filter['logic'] . " pages.title " .
670 $filter['compare'] . " " . $filter['value'] . $closecompare;
673 $filter['value'] = (int)strtotime($filter['value']);
674 $where2 .= " " . $filter['logic'] . " pages.lastmod " .
675 $filter['compare'] . " " . $filter['value'] . $closecompare;
677 // filter by hidden column?
683 if ($use_dataresolve && $filter['colname'] && (substr($filter['compare'], -4) == 'LIKE')) {
684 $where2 .= ' ' . $filter['logic'] .
685 ' DATARESOLVE(' . $table . '.value,' . $sqlite->getPdo()->quote($filter['colname']) . ') ' .
686 $filter['compare'] .
687 " " . $filter['value']; //value is already escaped
689 $where2 .= ' ' . $filter['logic'] . ' ' . $table . '.value ' . $filter['compare'] .
690 " " . $filter['value'] . $closecompare; //value is already escaped
734 $data['filter'] = array_merge($data['filter'], $this->dthlp->getFilters());
746 * Check whether a sort or filter request parameters are available