ЧАСТЬ.1 План по созданию сайта знакомств.

composer create-project laravel/laravel . --prefer-dist

Win + R → введи sysdm.cpl → Enter

C:\Program Files\PostgreSQL\18\bin

psql --version

pg_isready -h localhost -p 5432

psql -U postgres -h localhost -p 5432

psql -U postgres -h localhost -p 5432 -c "CREATE DATABASE dating_db ENCODING='UTF8' LC_COLLATE='Russian_Russia.UTF-8' LC_CTYPE='Russian_Russia.UTF-8' TEMPLATE=template0;"

psql -U postgres -h localhost -p 5432 -l | grep dating_db

psql -U postgres -h localhost -p 5432 -c "CREATE USER laravel_user WITH PASSWORD 'laravel_pass';"

psql -U postgres -h localhost -p 5432 -c "GRANT ALL PRIVILEGES ON DATABASE dating_db TO laravel_user;"

psql -U laravel_user -h localhost -p 5432 -d dating_db

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=dating_db
DB_USERNAME=postgres
DB_PASSWORD=root

cd server
php artisan migrate

   INFO  Preparing database.  

  Creating migration table ........................................................................................................... 228.52ms DONE

   INFO  Running migrations.  

  0001_01_01_000000_create_users_table ............................................................................................... 416.58ms DONE
  0001_01_01_000001_create_cache_table ................................................................................................ 16.00ms DONE
  0001_01_01_000002_create_jobs_table ................................................................................................ 114.36ms DONE

php artisan db:show

  PostgreSQL .................................................................................................................................. 18.4
  Connection ................................................................................................................................. pgsql
  Database ............................................................................................................................... dating_db
  Host ................................................................................................................................... 127.0.0.1
  Port ........................................................................................................................................ 5432
  Username ................................................................................................................................ postgres
  URL ..............................................................................................................................................
  Open Connections ............................................................................................................................... 9  
  Tables ......................................................................................................................................... 9  
  Total Size ............................................................................................................................. 216.00 KB  

  Schema / Table .............................................................................................................................. Size
  public / cache .......................................................................................................................... 24.00 KB  
  public / cache_locks .................................................................................................................... 24.00 KB  
  public / failed_jobs .................................................................................................................... 32.00 KB  
  public / job_batches .................................................................................................................... 16.00 KB  
  public / jobs ........................................................................................................................... 24.00 KB
  public / migrations ..................................................................................................................... 24.00 KB
  public / password_reset_tokens .......................................................................................................... 16.00 KB
  public / sessions ....................................................................................................................... 32.00 KB
  public / users .......................................................................................................................... 24.00 KB

php artisan install:api

php artisan migrate

psql -U postgres -h localhost -p 5432 -d dating_db -c "CREATE EXTENSION postgis;"

php artisan make:migration create_profiles_table
php artisan make:migration create_swipes_table

public function up(): void
{
    Schema::create('profiles', function (Blueprint $table) {
        $table->id();
        $table->foreignId('user_id')->constrained()->onDelete('cascade'); // Привязка к юзеру
        
        $table->string('name')->nullable(); // Имя
        $table->date('birth_date')->nullable(); // Дата рождения (возраст будем считать на лету)
        $table->enum('gender', ['male', 'female', 'other'])->nullable(); // Пол
        $table->enum('looking_for', ['male', 'female', 'both'])->default('both'); // Кого ищет
        $table->text('bio')->nullable(); // О себе
        $table->json('interests')->nullable(); // Интересы (массив)
        
        // Геолокация! Используем PostGIS
        $table->geography('location', subtype: 'point')->nullable(); // Координаты (широта/долгота)
        $table->string('city')->nullable(); // Город для быстрого отображения
        
        $table->timestamps();
    });
}

public function up(): void
{
    Schema::create('swipes', function (Blueprint $table) {
        $table->id();
        $table->foreignId('swiper_id')->constrained('users')->onDelete('cascade'); // Кто свайпнул
        $table->foreignId('swiped_id')->constrained('users')->onDelete('cascade'); // Кого свайпнули
        $table->enum('action', ['like', 'dislike', 'superlike'])->default('like'); // Тип свайпа
        $table->timestamps();

        // Уникальный индекс: юзер может свайпнуть другого юзера только один раз
        $table->unique(['swiper_id', 'swiped_id']);
    });
}

php artisan migrate

php artisan make:model Profile
php artisan make:model Swipe

    // Связь с профилем
    public function profile()
    {
        return $this->hasOne(Profile::class);
    }

    // Исходящие свайпы (кого лайкнул/дизлайкнул этот юзер)
    public function swipesGiven()
    {
        return $this->hasMany(Swipe::class, 'swiper_id');
    }

    // Входящие свайпы (кто лайкнул/дизлайкнул этого юзера)
    public function swipesReceived()
    {
        return $this->hasMany(Swipe::class, 'swiped_id');
    }

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Carbon\Carbon; // Библиотека для работы с датами

class Profile extends Model
{
    // Разрешаем массовое заполнение этих полей
    protected $fillable = [
        'user_id',
        'name',
        'birth_date',
        'gender',
        'looking_for',
        'bio',
        'interests',
        'location',
        'city',
    ];

    // Связь с юзером (Профиль принадлежит Юзеру)
    public function user()
    {
        return $this->belongsTo(User::class);
    }

    // Автоматический расчет возраста при обращении к $profile->age
    public function getAgeAttribute()
    {
        return Carbon::parse($this->birth_date)->age;
    }

    // Чтобы поле interests автоматически конвертировалось из JSON в массив и обратно
    protected function casts(): array
    {
        return [
            'interests' => 'array',
            'birth_date' => 'date',
        ];
    }
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Swipe extends Model
{
    protected $fillable = [
        'swiper_id',
        'swiped_id',
        'action',
    ];

    // Кто свайпнул
    public function swiper()
    {
        return $this->belongsTo(User::class, 'swiper_id');
    }

    // Кого свайпнули
    public function swiped()
    {
        return $this->belongsTo(User::class, 'swiped_id');
    }
}

  <?php

namespace App\Models;

use Laravel\Sanctum\HasApiTokens; 

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Database\Factories\UserFactory;
use Illuminate\Database\Eloquent\Attributes\Fillable;
use Illuminate\Database\Eloquent\Attributes\Hidden;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

#[Fillable(['email', 'password'])]
#[Hidden(['password', 'remember_token'])]
class User extends Authenticatable
{
    /** @use HasFactory<UserFactory> */
    use HasApiTokens, HasFactory, Notifiable;
      // Автоматически создаем пустой профиль при регистрации юзера
    protected static function booted(): void
    {
        static::created(function (User $user) {
            // Просто создаем пустую заглушку профиля
            $user->profile()->create([]);
        });
    }

    /**
     * Get the attributes that should be cast.
     *
     * @return array<string, string>
     */
    protected function casts(): array
    {
        return [
            'email_verified_at' => 'datetime',
            'password' => 'hashed',
        ];
    }
     // Связь с профилем
    public function profile()
    {
        return $this->hasOne(Profile::class);
    }

    // Исходящие свайпы (кого лайкнул/дизлайкнул этот юзер)
    public function swipesGiven()
    {
        return $this->hasMany(Swipe::class, 'swiper_id');
    }

    // Входящие свайпы (кто лайкнул/дизлайкнул этого юзера)
    public function swipesReceived()
    {
        return $this->hasMany(Swipe::class, 'swiped_id');
    }
}

php artisan make:controller AuthController

<?php

namespace App\Http\Controllers;

use App\Models\User;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Hash;
use Illuminate\Validation\ValidationException;

class AuthController extends Controller
{
    // РЕГИСТРАЦИЯ
    public function register(Request $request)
    {
        $request->validate([
            'email' => 'required|email|unique:users',
            'password' => 'required|min:8',
        ]);

        $user = User::create([
            'email' => $request->email,
            'password' => Hash::make($request->password), // Пароль всегда хэшим!
        ]);

        // Создаем токен доступа (Sanctum)
        $token = $user->createToken('auth_token')->plainTextToken;

        return response()->json([
            'user' => $user->load('profile'), // Возвращаем юзера сразу с профилем
            'token' => $token
        ], 201);
    }

    // АВТОРИЗАЦИЯ (Логин)
    public function login(Request $request)
    {
        $request->validate([
            'email' => 'required|email',
            'password' => 'required',
        ]);

        $user = User::where('email', $request->email)->first();

        // Проверяем пароль
        if (! $user || ! Hash::check($request->password, $user->password)) {
            throw ValidationException::withMessages([
                'email' => ['Неверный email или пароль.'],
            ]);
        }

        $token = $user->createToken('auth_token')->plainTextToken;

        return response()->json([
            'user' => $user->load('profile'),
            'token' => $token
        ]);
    }

    // ВЫХОД (Логаут)
    public function logout(Request $request)
    {
        // Удаляем текущий токен (закрываем сессию на устройстве)
        $request->user()->currentAccessToken()->delete();

        return response()->json([
            'message' => 'Вы вышли из системы'
        ]);
    }
}

<?php

use App\Http\Controllers\AuthController;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Route;

// Публичные роуты (доступны без токена)
Route::post('/register', [AuthController::class, 'register']);
Route::post('/login', [AuthController::class, 'login']);

// Защищенные роуты (нужен токен авторизации)
Route::middleware('auth:sanctum')->group(function () {
    
    // Роут из коробки (получить данные текущего юзера)
    Route::get('/user', function (Request $request) {
        return $request->user()->load('profile');
    });

    // Выход
    Route::post('/logout', [AuthController::class, 'logout']);
});

curl -X POST http://127.0.0.1:8000/api/register -H "Content-Type: application/json" -H "Accept: application/json" -d "{\"email\":\"alex@test.com\",\"password\":\"12345678\"}"

php artisan make:controller ProfileController

<?php

namespace App\Http\Controllers;

use App\Models\Profile;
use Illuminate\Http\Request;

class ProfileController extends Controller
{
    // Метод обновления профиля (Онбординг)
       public function update(Request $request)
    {
        $validated = $request->validate([
            'name' => 'sometimes|string|max:255',
            'birth_date' => 'sometimes|date',
            'gender' => 'sometimes|in:male,female,other',
            'looking_for' => 'sometimes|in:male,female,both',
            'bio' => 'sometimes|string|max:500',
            'interests' => 'sometimes|array',
            'city' => 'sometimes|string|max:255',
        ]);

        $profile = $request->user()->profile;

        // Заполняем и сохраняем
        $profile->fill($validated);
        $profile->save();

        // Возвращаем свежие данные из БД
        return response()->json([
            'message' => 'Profile upadated successfully !',
            'profile' => $profile->fresh()
        ]);
    }
}

// Защищенные роуты (нужен токен авторизации)
Route::middleware('auth:sanctum')->group(function () {
    
    Route::get('/user', function (Request $request) {
        return $request->user()->load('profile');
    });

    Route::post('/logout', [AuthController::class, 'logout']);
    
    // НОВЫЙ РОУТ ДЛЯ ПРОФИЛЯ
    Route::put('/profile', [ProfileController::class, 'update']); 
});

use App\Http\Controllers\ProfileController;

curl -X PUT http://127.0.0.1:8000/api/profile -H "Authorization: Bearer ТУТ_ВСТАВЬ_СВОЙ_ТОКЕН" -H "Content-Type: application/json" -H "Accept: application/json" -d "{\"name\":\"Alex\",\"birth_date\":\"1995-05-20\",\"gender\":\"male\",\"looking_for\":\"female\",\"city\":\"Moscow\"}"

php artisan make:controller LocationController

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class LocationController extends Controller
{
    // Обновление геолокации пользователя
    public function update(Request $request)
    {
        $request->validate([
            'latitude' => 'required|numeric|between:-90,90',
            'longitude' => 'required|numeric|between:-180,180',
        ]);

        $profile = $request->user()->profile; // ИСПРАВЛЕНО ЗДЕСЬ

        // Используем сырой запрос для PostGIS
        DB::table('profiles')
            ->where('id', $profile->id)
            ->update([
                'location' => DB::raw("ST_SetSRID(ST_MakePoint({$request->longitude}, {$request->latitude}), 4326)"),
                'updated_at' => now(),
            ]);

        return response()->json([
            'message' => 'Geolocation upadated successfully !'
        ]);
    }
}

Route::middleware('auth:sanctum')->group(function () {
    
    Route::get('/user', function (Request $request) {
        return $request->user()->load('profile');
    });

    Route::post('/logout', [AuthController::class, 'logout']);
    Route::put('/profile', [ProfileController::class, 'update']);
    
    // НОВЫЙ РОУТ ДЛЯ ГЕОЛОКАЦИИ
    Route::post('/location', [LocationController::class, 'update]); 
});

curl -X POST http://127.0.0.1:8000/api/location -H "Authorization: Bearer ТУТ_ТВОЙ_ТОКЕН" -H "Content-Type: application/json" -H "Accept: application/json" -d "{\"latitude\":55.7539,\"longitude\":37.6208}"

php artisan tinker

 $u = \App\Models\User::create(['email' => 'anna@test.com', 'password' => bcrypt('12345678')]); \DB::table('profiles')->where('id', $u->profile->id)->update(['name' => 'Anna', 'gender' => 'female', 'looking_for' => 'male', 'location' => \DB::raw("ST_SetSRID(ST_MakePoint(37.6173, 55.7558), 4326)")]);

 $u = \App\Models\User::create(['email' => 'elena@test.com', 'password' => bcrypt('12345678')]); \DB::table('profiles')->where('id', $u->profile->id)->update(['name' => 'Elena', 'gender' => 'female', 'looking_for' => 'male', 'location' => \DB::raw("ST_SetSRID(ST_MakePoint(37.5922, 55.7338), 4326)")]);

 $u = \App\Models\User::create(['email' => 'nastya@test.com', 'password' => bcrypt('12345678')]); \DB::table('profiles')->where('id', $u->profile->id)->update(['name' => 'Nastya', 'gender' => 'female', 'looking_for' => 'male', 'location' => \DB::raw("ST_SetSRID(ST_MakePoint(30.3086, 59.9375), 4326)")]);

exit

php artisan make:controller DiscoverController

<?php

namespace App\Http\Controllers;

use App\Models\Profile;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class DiscoverController extends Controller
{
    public function index(Request $request)
    {
        $user = $request->user();
        $profile = $user->profile;

        // Если у юзера нет координат, мы не можем его искать
        if (!$profile->location) {
            return response()->json(['message' => 'Сначала обновите геолокацию'], 400);
        }

        // Радиус поиска в метрах (50 км = 50000 метров)
        $radius = 50000; 

        // МАГИЯ POSTGIS: Ищем профили в радиусе $radius от текущего профиля
        $nearbyProfiles = Profile::where('user_id', '!=', $user->id) // Исключаем себя
            ->whereNotNull('location') // Только те, у кого есть геолокация
            ->whereRaw("
                ST_DWithin(
                    location,
                    (SELECT location FROM profiles WHERE id = ?),
                    ?
                )
            ", [$profile->id, $radius])
            ->get();

        return response()->json([
            'count' => $nearbyProfiles->count(),
            'profiles' => $nearbyProfiles
        ]);
    }
}

Route::get('/discover', [DiscoverController::class, 'index']);

curl http://127.0.0.1:8000/api/discover -H "Authorization: Bearer ТУТ_ТОКЕН_АЛЕКСЕЯ" -H "Accept: application/json"

<?php

namespace App\Http\Controllers;

use App\Models\Profile;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class DiscoverController extends Controller
{
    public function index(Request $request)
    {
        $user = $request->user();
        $profile = $user->profile;

        if (!$profile->location) {
            return response()->json(['message' => 'Сначала обновите геолокацию'], 400);
        }

        $radius = 50000; // 50 км в метрах

        $nearbyProfiles = Profile::where('user_id', '!=', $user->id)
            ->whereNotNull('location')
            ->whereRaw("
                ST_DWithin(
                    location,
                    (SELECT location FROM profiles WHERE id = ?),
                    ?
                )
            ", [$profile->id, $radius])
            // 1. Явно просим выбрать все поля профиля
            ->select('profiles.*') 
            // 2. Добавляем расстояние и ОБЯЗАТЕЛЬНО пишем AS distance_in_meters
            ->addSelect([
                DB::raw("
                    ST_Distance(
                        location, 
                        (SELECT location FROM profiles WHERE id = {$profile->id})
                    ) as distance_in_meters
                ")
            ])
            ->get()
            // 3. Прячем страшный hex-код координат из ответа
            ->makeHidden(['location']) 
            // 4. Форматируем: переводим метры в километры
            ->map(function ($item) {
                // Делим метры на 1000 и округляем до 1 знака после запятой
                $item->distance_km = round($item->distance_in_meters / 1000, 1);
                // Удаляем техническое поле метров, чтобы не мусорить в JSON
                unset($item->distance_in_meters); 
                return $item;
            });

        return response()->json([
            'count' => $nearbyProfiles->count(),
            'profiles' => $nearbyProfiles
        ]);
    }
}

curl http://127.0.0.1:8000/api/discover -H "Authorization: Bearer ТОКЕН-АЛЕКСЕЯ" -H "Accept: application/json"

{"count":2,"profiles":[{"id":4,"user_id":4,"name":"Anna","birth_date":null,"gend
er":"female","looking_for":"male","bio":null,"interests":null,"city":null,"creat
ed_at":"2026-07-15T15:15:01.000000Z","updated_at":"2026-07-15T15:15:01.000000Z",
"distance_km":0.3},{"id":5,"user_id":5,"name":"Elena","birth_date":null,"gender"
:"female","looking_for":"male","bio":null,"interests":null,"city":null,"created_
at":"2026-07-15T15:15:12.000000Z","updated_at":"2026-07-15T15:15:12.000000Z","di
stance_km":2.9}]} 

php artisan make:controller SwipeController

<?php

namespace App\Http\Controllers;

use App\Models\Swipe;
use Illuminate\Http\Request;

class SwipeController extends Controller
{
    public function store(Request $request)
    {
        $request->validate([
            'swiped_id' => 'required|exists:users,id', // Кого свайпнули
            'action' => 'required|in:like,dislike,superlike', // Тип свайпа
        ]);

        $swiperId = $request->user()->id;
        $swipedId = $request->swiped_id;

        // Защита: нельзя свайпать самого себя
        if ($swiperId === (int)$swipedId) {
            return response()->json(['message' => 'Нельзя свайпнуть себя'], 400);
        }

        // Защита: нельзя свайпать одного человека дважды
        $alreadySwiped = Swipe::where('swiper_id', $swiperId)
            ->where('swiped_id', $swipedId)
            ->exists();

        if ($alreadySwiped) {
            return response()->json(['message' => 'Вы уже свайпнули этого пользователя'], 409);
        }

        // Сохраняем свайп
        $swipe = Swipe::create([
            'swiper_id' => $swiperId,
            'swiped_id' => $swipedId,
            'action' => $request->action,
        ]);

        $isMatch = false;

        // Проверяем на МЭТЧ (только если это ЛАЙК или СУПЕРЛАЙК)
        if ($request->action === 'like' || $request->action === 'superlike') {
            
            // Искал ли тот человек (swiped_id) нас (swiper_id) с лайком/суперлайком?
            $reverseSwipe = Swipe::where('swiper_id', $swipedId)
                ->where('swiped_id', $swiperId)
                ->whereIn('action', ['like', 'superlike'])
                ->exists();

            if ($reverseSwipe) {
                $isMatch = true;
                // ТУТ ПОТОМ МЫ ДОБАВИМ ОТПРАВКУ PUSH-УВЕДОМЛЕНИЙ И СОЗДАНИЕ ЧАТА!
            }
        }

        return response()->json([
            'message' => 'Свайп засчитан',
            'is_match' => $isMatch, // Возвращаем флаг мэтча!
        ], 201);
    }
}

Route::post('/swipe', [SwipeController::class, 'store']);

curl -X POST http://127.0.0.1:8000/api/swipe -H "Authorization: Bearer 1|FIi5oBCpuDr41ZlA4RcvbHpOnojZ6VLKiNzlFYs64c2d68ac" -H "Content-Type: application/json" -H "Accept: application/json" -d "{\"swiped_id\":4,\"action\":\"like\"}"

curl -X POST http://127.0.0.1:8000/api/login -H "Content-Type: application/json" -H "Accept: application/json" -d "{\"email\":\"anna@test.com\",\"password\":\"12345678\"}"

curl -X POST http://127.0.0.1:8000/api/swipe -H "Authorization: Bearer ТОКЕН_АННЫ" -H "Content-Type: application/json" -H "Accept: application/json" -d "{\"swiped_id\":3,\"action\":\"like\"}"

<?php

namespace App\Http\Controllers;

use App\Models\Swipe;
use App\Models\Profile;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class DiscoverController extends Controller
{
    public function index(Request $request)
    {
        $user = $request->user();
        $profile = $user->profile;

        if (!$profile->location) {
            return response()->json(['message' => 'Сначала обновите геолокацию'], 400);
        }

        // 1. НОВОЕ: Получаем ID всех юзеров, которых мы уже засвайпали
        $swipedUserIds = Swipe::where('swiper_id', $user->id)->pluck('swiped_id')->toArray();

        $radius = 50000; 

        $nearbyProfiles = Profile::where('user_id', '!=', $user->id)
            ->whereNotNull('location')
            // 2. НОВОЕ: Исключаем тех, кого мы уже свайпнули
            ->whereNotIn('user_id', $swipedUserIds) 
            ->whereRaw("
                ST_DWithin(
                    location,
                    (SELECT location FROM profiles WHERE id = ?),
                    ?
                )
            ", [$profile->id, $radius])
            ->select('profiles.*') 
            ->addSelect([
                DB::raw("
                    ST_Distance(
                        location, 
                        (SELECT location FROM profiles WHERE id = {$profile->id})
                    ) as distance_in_meters
                ")
            ])
            ->get()
            ->makeHidden(['location']) 
            ->map(function ($item) {
                $item->distance_km = round($item->distance_in_meters / 1000, 1);
                unset($item->distance_in_meters); 
                return $item;
            });

        return response()->json([
            'count' => $nearbyProfiles->count(),
            'profiles' => $nearbyProfiles
        ]);
    }
}

curl http://127.0.0.1:8000/api/discover -H "Authorization: Bearer 1|FIi5oBCpuDr41ZlA4RcvbHpOnojZ6VLKiNzlFYs64c2d68ac" -H "Accept: application/json"