| public modulo ( integer | float $value, integer | float $interval, boolean $include = true ) : string | ||
| $value | integer | float | The starting value of the search space |
| $interval | integer | float | The interval period of the search space |
| $include | boolean | Should I include the boundaries in the search? |
| Résultat | string | The SQL where clause |
public function modulo($value, $interval, $include = true)
{
if ($this->isEmpty($value) || $this->isEmpty($interval)) {
return '';
}
$extra = '';
if ($include) {
$extra = '=';
}
$sql = '(' . $this->getFieldName() . ' >' . $extra . ' ' . $value . ' AND ';
$sql .= '(' . $this->getFieldName() . ' - ' . $value . ') % ' . $interval . ' = 0)';
return $sql;
}