criteria.php

<?php
 
 
define('XOOPS_CRITERIA_ASC', 'ASC');
define('XOOPS_CRITERIA_DESC', 'DESC');
define('XOOPS_CRITERIA_STARTWITH', 1);
define('XOOPS_CRITERIA_ENDWITH', 2);
define('XOOPS_CRITERIA_CONTAIN', 3);
 
 
class CriteriaElement
{
    public $order = [];

    public $sort = [];

    public $limit = 0;

    public $start = 0;

    public $groupby = '';

    public function __construct()
    {
    }

    public function render()
    {
    }

    public function hasChildElements()
    {
        return false;
    }
 
    public function getCountChildElements()
    {
        return 0;
    }

    public function getChildElement($idx)
    {
        return null;
    }

    public function getCondition($idx)
    {
        return null;
    }
 
    public function getName()
    {
        return null;
    }
 
    public function getValue()
    {
        return null;
    }
 
    public function getOperator()
    {
        return null;
    }

    public function setSort($sort, $order = null)
    {
        $this->sort[0] = $sort;
 
        if (!isset($this->order[0])) {
            $this->order[0] = 'ASC';
        }
 
        if (null != $order) {
            if ('ASC' == strtoupper($order)) {
                $this->order[0] = 'ASC';
            } elseif ('DESC' == strtoupper($order)) {
                $this->order[0] = 'DESC';
            }
        }
    }

    public function addSort($sort, $order = 'ASC')
    {
        $this->sort[] = $sort;
        if ('ASC' == strtoupper($order)) {
            $this->order[] = 'ASC';
        } elseif ('DESC' == strtoupper($order)) {
            $this->order[] = 'DESC';
        }
    }

    public function getSort()
    {
        if (isset($this->sort[0])) {
            return $this->sort[0];
        }
 
        return '';
    }

    public function getSorts()
    {
        $ret = [];
        $max = count($this->sort);
 
        for ($i = 0; $i < $max; $i++) {
            $ret[$i]['sort'] = $this->sort[$i];
            $ret[$i]['order'] = $this->order[$i] ?? 'ASC';
        }
 
        return $ret;
    }

    public function setOrder($order)
    {
        if ('ASC' == strtoupper($order)) {
            $this->order[0] = 'ASC';
        } elseif ('DESC' === strtoupper($order)) {
            $this->order[0] = 'DESC';
        }
    }

    public function getOrder()
    {
        if (isset($this->order[0])) {
            return $this->order[0];
        }
 
        return 'ASC';
    }

    public function setLimit($limit=0)
    {
        $this->limit = (int)$limit;
    }

    public function getLimit()
    {
        return $this->limit;
    }

    public function setStart($start=0)
    {
        $this->start = (int)$start;
    }

    public function getStart()
    {
        return $this->start;
    }

    public function setGroupby($group)
    {
        $this->groupby = $group;
    }

    public function getGroupby()
    {
        return ' GROUP BY '.$this->groupby;
    }

}

class CriteriaCompo extends CriteriaElement
{

    public $criteriaElements = [];

    public $conditions = [];

    public function __construct($ele=null, $condition='AND')
    {
        if (isset($ele) && is_object($ele)) {
            $this->add($ele, $condition);
        }
    }
 
    public function hasChildElements()
    {
        return count($this->criteriaElements) > 0;
    }
 
    public function getCountChildElements()
    {
        return count($this->criteriaElements);
    }
 
    public function getChildElement($idx)
    {
        return $this->criteriaElements[$idx];
    }
 
    public function getCondition($idx)
    {
        return $this->conditions[$idx];
    }

    public function &add($criteriaElement, $condition='AND')
    {
        $this->criteriaElements[] =& $criteriaElement;
        $this->conditions[] = $condition;
        return $this;
    }

    public function render()
    {
        $ret = '';
        $count = count($this->criteriaElements);
        if ($count > 0) {
            $elems =& $this->criteriaElements;
            $conds =& $this->conditions;
            $ret = '('. $elems[0]->render();
            for ($i = 1; $i < $count; $i++) {
                $ret .= ' '.$conds[$i].' '.$elems[$i]->render();
            }
            $ret .= ')';
        }
        return $ret;
    }

    public function renderWhere()
    {
        $ret = $this->render();
        $ret = ('' !== $ret) ? 'WHERE ' . $ret : $ret;
        return $ret;
    }

    public function renderLdap()
    {
        $retval = '';
        $count = count($this->criteriaElements);
        if ($count > 0) {
            $retval = $this->criteriaElements[0]->renderLdap();
            for ($i = 1; $i < $count; $i++) {
                $cond = $this->conditions[$i];
                if ('AND' == strtoupper($cond)) {
                    $op = '&';
                } elseif ('OR' == strtoupper($cond)) {
                    $op = '|';
                }
                $retval = "($op$retval" . $this->criteriaElements[$i]->renderLdap() . ')';
            }
        }
        return $retval;
    }
}
 

class Criteria extends CriteriaElement
{

    public $prefix;
    public $function;
    public $column;
    public $operator;
    public $value;
 
    public $dtype = 0;

    public function __construct($column, $value='', $operator='=', $prefix = '', $function = '')
    {
        $this->prefix = $prefix;
        $this->function = $function;
        $this->column = $column;
        $this->operator = $operator;
 
        //
        // Recive DTYPE. This is a prolongation of criterion life operation.
        //
        if (is_array($value) && 2 == count($value) && 'IN' !== $operator && 'NOT IN' !== $operator) {
            $this->dtype = (int)$value[0];
            $this->value = $value[1];
        } else {
            $this->value = $value;
        }
    }
 
    public function getName()
    {
        return $this->column;
    }
 
    public function getValue()
    {
        return $this->value;
    }
 
    public function getOperator()
    {
        return $this->operator;
    }

    public function render()
    {
        $value = $this->value;
        if (in_array(strtoupper($this->operator), ['IN', 'NOT IN'])) {
            $value = is_array($value) ? implode(',', $value) : trim($value, " ()\t"); // [Compat] allow value '("a", "b", "c")'
            if (isset($value)) {
                $value = '('.$value.')';
            } else {
                $value = '("")';
            }
        } else {
            $value = "'$value'";
        }
        $clause = (!empty($this->prefix) ? $this->prefix.'.' : '') . $this->column;
        if (!empty($this->function)) {
            $clause = sprintf($this->function, $clause);
        }
        $clause .= ' '.$this->operator.' '.$value;
        return $clause;
    }

    public function renderLdap()
    {
        return '(' . $this->column . $this->operator . $this->value . ')';
    }

    public function renderWhere()
    {
        $cond = $this->render();
        return empty($cond) ? '' : "WHERE $cond";
    }
}