使用Laravel中的验证器检查两个表中两列的唯一性

use Illuminate\Contracts\Validation\Rule;

class UniqueColumns implements Rule
{
    protected $table1;
    protected $column1;
    protected $table2;
    protected $column2;

    public function __construct($table1, $column1, $table2, $column2)
    {
        $this->table1 = $table1;
        $this->column1 = $column1;
        $this->table2 = $table2;
        $this->column2 = $column2;
    }

    public function passes($attribute, $value)
    {
        $count1 = DB::table($this->table1)
            ->where($this->column1, $value)
            ->count();

        $count2 = DB::table($this->table2)
            ->where($this->column2, $value)
            ->count();

        return $count1 + $count2 === 0;
    }

    public function message()
    {
        return 'The :attribute already exists in either table.';
    }
}

use Illuminate\Support\Facades\Validator;

$data = [
    'value' => 'example',
];

$validator = Validator::make($data, [
    'value' => ['required', new UniqueColumns('table1', 'column1', 'table2', 'column2')],
]);

if ($validator->fails()) {
    // 验证失败处理逻辑
} else {
    // 验证通过，执行相应操作
}