Introducing the Tour Planner With MongoDB Vector Search

1
composer require openai-php/laravel

1
php artisan vendor:publish --provider="OpenAI\Laravel\ServiceProvider"

1
OPENAI_API_KEY=your-api-key-here

1
use OpenAI\Laravel\Facades\OpenAI;

1
<?php
2
3
namespace App\Models;
4
5
use MongoDB\Laravel\Eloquent\Model;
6
7
class PointOfInterest extends Model
8
{
9
    protected $connection = 'mongodb';
10
    protected $collection = 'points_of_interest';
11
    
12
    protected $fillable = [
13
        'name',
14
        'description',
15
        'type',
16
        'rating',
17
        'location',
18
        'embedding',
19
    ];
20
    
21
    protected $casts = [
22
        'location' => 'object',
23
        'embedding' => 'array',
24
    ];
25
}

1
$embedding = $this->generateEmbedding($search);
2
$points = DB::collection('points_of_interest')
3
    ->raw(function ($collection) use ($embedding) {
4
        return $collection->aggregate([
5
            [
6
                '$vectorSearch' => [
7
                    'index' => 'vector_index',
8
                    'path' => 'embedding',
9
                    'queryVector' => $embedding,
10
                    'numCandidates' => 20,
11
                    'limit' => 5
12
                ],
13
            ],
14
            [
15
                '$project' => [
16
                    'name' => 1,
17
                    'description' => 1,
18
                    'rating' => 1,
19
                    'location' => 1,
20
                    'score' => ['$meta' => 'vectorSearchScore']
21
                ]
22
            ]
23
        ]);
24
    })
25
    ->toArray();

1
protected function generatePossibleTrip($cities, $context, $days) {
2
    $result = OpenAI::chat()->create([
3
        'model' => 'gpt-4o-mini',
4
        'temperature' => 0,
5
        'response_format' => ['type' => 'json_object'],
6
        'messages' => [
7
            [
8
                'role' => 'system',
9
                'content' => 'You are a travel agent helping a customer plan a trip to a city. If it will be hard to visit all in the number of days designated, return a one day plan stating the problem. The customer will provide you with points of interest to visit in json.'
10
            ],
11
            [
12
                'role' => 'system',
13
                'content' => 'Take this schema, for flights add orig_airport_code and dest_airport_code:
14
                "tripPlan": {
15
                    "destination": [{
16
                        "city": "string",
17
                        "country": "string"
18
                    }],
19
                    "pointsOfInterest": [
20
                        {
21
                            "name": "string",
22
                            "description": "string",
23
                            "location": {
24
                                "coordinates": [number, number]
25
                            },
26
                            "rating": number
27
                        }
28
                    ],
29
                    "flights" : [ "src_airport_code": "string",
30
                        "dest_airport_code": "string"
31
                    ],
32
                    "itinerary": [
33
                        {
34
                            "day": number,
35
                            "destination": "string",
36
                            "activities": [
37
                                {
38
                                    "time": "string",
39
                                    "activity": "string",
40
                                    "duration": "string",
41
                                    // if flight
42
                                    "src_airport_code": "string",
43
                                    dest_airport_code: "string"
44
                                }
45
                                ...
46
                            ]
47
                        }
48
                        ...
49
                    ]
50
                }'
51
            ],
52
            [
53
                'role' => 'user',
54
                'content' => 'For cities: ' . json_encode($cities) . '| Take this POIs: ' . $context . ' and build a plan for a trip of ' . $days . ' days.'
55
            ]
56
        ]
57
    ]);
58
    return $result->choices[0]->message->content;
59
}

1
cd laravel-openai-vector-search

1
composer install

1
OPENAI_API_KEY=your_openai_api_key
2
DB_URI=your_atlas_uri

1
php artisan key:generate

1
php artisan db:seed

1
{
2
    "name": "Eiffel Tower",
3
    "description": "Iconic iron lattice tower on the Champ de Mars in Paris.",
4
    "type": "landmark",
5
    "location": {
6
        "city": "Paris",
7
        "country": "France",
8
        "coordinates": [
9
            48.8584,
10
            2.2945
11
        ]
12
    },
13
    "rating": 4.7,
14
    "embedding":[]
15
}

1
{
2
    "airline": {
3
        "id": 410,
4
        "name": "Aerocondor",
5
        "alias": "2B",
6
        "iata": "ARD"
7
    },
8
    "src_airport": "CEK",
9
    "dst_airport": "KZN",
10
    "codeshare": "",
11
    "stops": 0,
12
    "airplane": "CR2"
13
}

1
{
2
    "fields": [
3
        {
4
            "type": "vector",
5
            "path": "embedding",
6
            "numDimensions": 1536,
7
            "similarity": "cosine"
8
        }
9
    ]
10
}

1
php artisan serve

1
cd frontend/trip-planner-frontend
2
npm install
3
npm run serve