web-base/Core/Driver/SQL/Condition/Compare.class.php

<?php

namespace Core\Driver\SQL\Condition;

use Core\Driver\SQL\MySQL;
use Core\Driver\SQL\SQL;

class Compare extends Condition {

  private string $operator;
  private string $column;
  private mixed $value;
  private bool $binary;

  public function __construct(string $col, $val, string $operator = '=', bool $binary = false) {
    $this->operator = $operator;
    $this->column = $col;
    $this->value = $val;
    $this->binary = $binary;
  }

  public function getColumn(): string { return $this->column; }
  public function getValue() { return $this->value; }
  public function getOperator(): string { return $this->operator; }

  function getExpression(SQL $sql, array &$params): string {

    if ($this->value === null) {
      if ($this->operator === "=") {
        return $sql->columnName($this->column) . " IS NULL";
      } else if ($this->operator === "!=") {
        return $sql->columnName($this->column) . " IS NOT NULL";
      }
    }

    $condition = $sql->columnName($this->column) . $this->operator . $sql->addValue($this->value, $params);
    if ($this->binary && $sql instanceof MySQL) {
      $condition = "BINARY $condition";
    }

    return $condition;
  }
}