<?php

/**
 *+------------------
 * madong
 *+------------------
 * Copyright (c) https://gitee.com/motion-code All rights reserved.
 *+------------------
 * Author: Mr. April (405784684@qq.com)
 *+------------------
 * Official Website: http://www.madong.tech
 */

namespace madong\query\enum;

/**
 * 查询操作符枚举
 * 支持的查询操作符类型
 */
enum Operator: string
{
 case EQ = 'eq'; // 等于
 case NE = 'ne'; // 不等于
 case GT = 'gt'; // 大于
 case GTE = 'gte'; // 大于等于
 case LT = 'lt'; // 小于
 case LTE = 'lte'; // 小于等于
 case LIKE = 'like'; // 模糊匹配
 case ILIKE = 'ilike'; // 不区分大小写模糊匹配
 case IN = 'in'; // 包含
 case NOT_IN = 'not_in'; // 不包含
 case BETWEEN = 'between'; // 范围
 case NOT_BETWEEN = 'not_between'; // 非范围
 case NULL = 'null'; // 为空
 case NOT_NULL = 'not_null'; // 不为空

 /**
 * 获取所有操作符列表
 *
 * @return array
 */
 public static function all(): array
 {
 return array_map(fn($case) => $case->value, self::cases());
 }

 /**
 * 验证操作符是否有效
 *
 * @param string $operator
 * @return bool
 */
 public static function isValid(string $operator): bool
 {
 return in_array($operator, self::all(), true);
 }

 /**
 * 大写操作符映射
 * 将大写前缀映射到标准操作符
 *
 * @return array
 */
 public static function uppercaseMap(): array
 {
 return [
 'EQ' => self::EQ->value,
 'NE' => self::NE->value,
 'GT' => self::GT->value,
 'GTE' => self::GTE->value,
 'LT' => self::LT->value,
 'LTE' => self::LTE->value,
 'LIKE' => self::LIKE->value,
 'ILIKE' => self::ILIKE->value,
 'IN' => self::IN->value,
 'NOT_IN' => self::NOT_IN->value,
 'BETWEEN' => self::BETWEEN->value,
 'NOT_BETWEEN' => self::NOT_BETWEEN->value,
 'NULL' => self::NULL->value,
 'NOT_NULL' => self::NOT_NULL->value,
 ];
 }

 /**
 * 转换为大写格式
 *
 * @return string
 */
 public function toUppercase(): string
 {
 $map = array_flip(self::uppercaseMap());
 return $map[$this->value] ?? strtoupper($this->value);
 }
}