Changes between Version 10 and Version 11 of AdvancedApplicationDevelopment

Timestamp:

09/25/25 13:25:59 (3 weeks ago)

Author:

223270

Comment:

--

AdvancedApplicationDevelopment

@@ -113 +113 @@
 {{{
 DB::transaction(function () use ($request) {
-    DB::table('rezervacii')->insert([
-        'idkorisnik' => auth()->id(),
-        'idaktivnost' => $request->aktivnost_id,
-        'datum' => now()
-    ]);
-
-    DB::table('aktivnosti')
-        ->where('idaktivnost', $request->aktivnost_id)
-        ->decrement('kvota', 1);
+    DB::table('activity_reservation')->insert([
+        'id_user' => auth()->id(),
+        'id_activity' => $request->activity_id,
+        'reservation_date' => now()
+    ]);
+
+    DB::table('activity')
+        ->where('id_activity', $request->activity_id)
+        ->decrement('amount', 1);
 });
 }}}
@@ -129 +129 @@
 Се користи трансакција за да сигурност дека внесувањето е валидно и се запишува како целина.
 {{{
-DB::transaction(function () use ($request) {
-            $validatedData = $request->validate([
-                'imepaket' => 'required|string|max:255',
-                'cena' => 'required|numeric',
-                'pochetok' => 'required|date_format:Y-m-d\TH:i',
-                'kraj' => 'required|date_format:Y-m-d\TH:i|after_or_equal:pochetok',
-            ]);
-
-            TravelPackage::create($validatedData);
-        });
+// Внесување TravelPackage
+DB::transaction(function () use ($request) {
+    $validatedData = $request->validate([
+        'package_name' => 'required|string|max:255',
+        'price' => 'required|numeric',
+        'start_date' => 'required|date_format:Y-m-d\TH:i',
+        'end_date' => 'required|date_format:Y-m-d\TH:i|after_or_equal:start_date',
+        'id_destination' => 'required|integer|exists:destination,id_destination'
+    ]);
+
+    TravelPackage::create($validatedData);
+});
 }}} 
 
 
 {{{
-DB::transaction(function () use ($request) {
-            $validatedData = $request->validate([
-                'naziv' => 'required|string|max:255',
-                'vidovi' => 'required|string|max:255',
-                'detali' => 'nullable|string',
-                'pochetendatum' => 'required|date',
-                'kraendatum' => 'required|date',
-            ]);
-
-            TravelEvent::create($validatedData);
-        });
-}}}
-
-
-{{{
-DB::transaction(function () use ($request) {
-            $validatedData = $request->validate([
-                'imeaktivnost' => 'required|string|max:255',
-                'informacii' => 'nullable|string|max:255',
-                'kategorija' => 'required|string|max:255',
-                'iznos' => 'nullable|numeric',
-            ]);
-
-            TravelActivity::create($validatedData);
-        });
+// Внесување TravelEvent
+DB::transaction(function () use ($request) {
+    $validatedData = $request->validate([
+        'event_name' => 'required|string|max:255',
+        'event_type' => 'required|string|max:255',
+        'details' => 'nullable|string',
+        'start_date' => 'required|date',
+        'end_date' => 'required|date',
+        'id_destination' => 'required|integer|exists:destination,id_destination'
+    ]);
+
+    TravelEvent::create($validatedData);
+});
+}}}
+
+
+{{{
+// Внесување TravelActivity
+DB::transaction(function () use ($request) {
+    $validatedData = $request->validate([
+        'activity_name' => 'required|string|max:255',
+        'information' => 'nullable|string|max:255',
+        'category' => 'required|string|max:255',
+        'amount' => 'nullable|numeric',
+        'id_destination' => 'required|integer|exists:destination,id_destination'
+    ]);
+
+    TravelActivity::create($validatedData);
+});
 }}}
 
@@ -180 +186 @@
     result FLOAT;
 BEGIN
-    SELECT AVG(ocenka)
+    SELECT AVG(quality)
     INTO result
-    FROM recenzii
-    WHERE iddest = dest_id;
+    FROM review
+    WHERE id_destination = dest_id;
     RETURN result;
 END;
@@ -191 +197 @@
 2. Додади препорака (процедура)
 {{{
-CREATE OR REPLACE PROCEDURE dodadi_preporaka(p_korisnik INT, p_dest INT)
+CREATE OR REPLACE PROCEDURE dodadi_preporaka(p_user INT, p_dest INT)
 LANGUAGE plpgsql
 AS $$
 BEGIN
-    INSERT INTO preporaki(idkorisnik, iddestinacija, datum)
-    VALUES (p_korisnik, p_dest, NOW());
+    INSERT INTO destination_user(id_user, id_destination, recommendation_date)
+    VALUES (p_user, p_dest, NOW());
 END;
 $$;