constraint.php 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. <?php
  2. class Constraint {
  3. const TYPE_LESS_THAN = 0;
  4. const TYPE_LESS_THAN_OR_EQUAL = 1;
  5. const TYPE_EQUALS = 2;
  6. const TYPE_MORE_THAN_OR_EQUAL = 3;
  7. const TYPE_MORE_THAN = 4;
  8. const TYPE_BETWEEN = 5;
  9. const TYPE_BEGINS_WITH = 6;
  10. const TYPE_CONTAINS = 7;
  11. const TYPE_ENDS_WITH = 8;
  12. const TYPE_NOT_EQUALS = 9;
  13. const TYPE_IS_NULL = 10;
  14. const TYPE_IS_NOT_NULL = 11;
  15. private $type;
  16. private $values = [];
  17. /**
  18. * Constraint constructor.
  19. * @param string $type
  20. * @throws Exception
  21. */
  22. public function __construct(string $type) {
  23. $type = "TYPE_" . strtoupper($type);
  24. if(!defined("Constraint::$type")) throw new Exception("Constraint::$type is not defined.");
  25. $this->type = constant("Constraint::$type");
  26. }
  27. public function setValues(...$values) {
  28. $this->values = array_map("db::escape", $values);
  29. return $this;
  30. }
  31. public function getConstraintString() {
  32. $value_1 = $this->values[0] ?? 0;
  33. $value_2 = $this->values[1] ?? 0;
  34. switch($this->type) {
  35. case self::TYPE_LESS_THAN:
  36. return " < '$value_1'";
  37. case self::TYPE_LESS_THAN_OR_EQUAL:
  38. return " <= '$value_1'";
  39. case self::TYPE_EQUALS:
  40. return " = '$value_1'";
  41. case self::TYPE_MORE_THAN_OR_EQUAL:
  42. return " >= '$value_1'";
  43. case self::TYPE_MORE_THAN:
  44. return " > '$value_1'";
  45. case self::TYPE_BETWEEN:
  46. return " BETWEEN '$value_1' AND '$value_2'";
  47. case self::TYPE_BEGINS_WITH:
  48. return " LIKE '$value_1%'";
  49. case self::TYPE_CONTAINS:
  50. return " LIKE '%$value_1%'";
  51. case self::TYPE_ENDS_WITH:
  52. return " LIKE '%$value_1'";
  53. case self::TYPE_NOT_EQUALS:
  54. return " != '$value_1'";
  55. case self::TYPE_IS_NULL:
  56. return " IS NULL";
  57. case self::TYPE_IS_NOT_NULL:
  58. return " IS NOT NULL";
  59. }
  60. return false;
  61. }
  62. }