Index: src/main/java/com/example/cookbook/controller/VrabotenController.java
===================================================================
--- src/main/java/com/example/cookbook/controller/VrabotenController.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/controller/VrabotenController.java	(revision ee276857e882c951c22c0041683ace305d6d6de6)
@@ -3,10 +3,15 @@
 
 import com.example.cookbook.model.Naracka;
+import com.example.cookbook.model.Recept;
+import com.example.cookbook.model.Stavka;
 import com.example.cookbook.service.NarackiService;
 import org.springframework.stereotype.Controller;
 import org.springframework.ui.Model;
 import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestParam;
 
 import java.sql.SQLException;
+import java.time.LocalDateTime;
 import java.util.List;
 
@@ -33,3 +38,20 @@
         return "naracki";
     }
+
+    @GetMapping("/naracki/naracka")
+    public String getNarackaPage(@RequestParam String telefon,
+                                 @RequestParam LocalDateTime vreme,
+                                 Model model){
+
+        List<Stavka> stavkiVoNaracka = null;
+        try {
+            stavkiVoNaracka = narcakiService.findByTelAndVreme(telefon, vreme);
+        } catch (SQLException e) {
+            return "redirect:/error-page/SQL%20Exception";
+        }
+
+        model.addAttribute("stavki", stavkiVoNaracka);
+
+        return "stavka";
+    }
 }
Index: src/main/java/com/example/cookbook/model/Komentar.java
===================================================================
--- src/main/java/com/example/cookbook/model/Komentar.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/model/Komentar.java	(revision ee276857e882c951c22c0041683ace305d6d6de6)
@@ -87,5 +87,5 @@
 
     public String getDataFormatirana(){
-        return komData.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm"));
+        return komData.format(DateTimeFormatter.ofPattern("yyyy-MMM-dd HH:mm"));
     }
 }
Index: src/main/java/com/example/cookbook/model/Stavka.java
===================================================================
--- src/main/java/com/example/cookbook/model/Stavka.java	(revision ee276857e882c951c22c0041683ace305d6d6de6)
+++ src/main/java/com/example/cookbook/model/Stavka.java	(revision ee276857e882c951c22c0041683ace305d6d6de6)
@@ -0,0 +1,58 @@
+package com.example.cookbook.model;
+
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
+
+public class Stavka {
+    private LocalDateTime vreme;
+    private String telefon;
+    private String recIme;
+    private String nacin;
+
+    public LocalDateTime getVreme() {
+        return vreme;
+    }
+
+    public void setVreme(LocalDateTime vreme) {
+        this.vreme = vreme;
+    }
+
+    public String getTelefon() {
+        return telefon;
+    }
+
+    public void setTelefon(String telefon) {
+        this.telefon = telefon;
+    }
+
+
+
+    public String getNacin() {
+        return nacin;
+    }
+
+    public void setNacin(String nacin) {
+        this.nacin = nacin;
+    }
+
+    public String getRecIme() {
+        return recIme;
+    }
+
+    public void setRecIme(String recIme) {
+        this.recIme = recIme;
+    }
+
+    public Stavka(LocalDateTime vreme, String telefon, String recIme, String nacin) {
+        this.vreme = vreme;
+        this.telefon = telefon;
+        this.recIme = recIme;
+        this.nacin = nacin;
+    }
+    public String getDataFormatirana(){
+        return vreme.format(DateTimeFormatter.ofPattern("yyyy-MMM-dd HH:mm"));
+    }
+
+    public Stavka() {
+    }
+}
Index: src/main/java/com/example/cookbook/repository/NarackiRepository.java
===================================================================
--- src/main/java/com/example/cookbook/repository/NarackiRepository.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/repository/NarackiRepository.java	(revision ee276857e882c951c22c0041683ace305d6d6de6)
@@ -4,10 +4,9 @@
 import com.example.cookbook.dbConfig.DB;
 import com.example.cookbook.model.Naracka;
+import com.example.cookbook.model.Recept;
+import com.example.cookbook.model.Stavka;
 import org.springframework.stereotype.Repository;
 
-import java.sql.Connection;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
+import java.sql.*;
 import java.time.LocalDateTime;
 import java.util.ArrayList;
@@ -39,3 +38,30 @@
         return naracki;
     }
+
+    public List<Stavka> findByTelAndVreme(String telefon, LocalDateTime vreme) throws SQLException {
+
+        Connection connection = DB.getConnection();
+        String query = "select sk.vreme, sk.telefon, r.rec_ime, nacin from so_koi sk\n" +
+                "        left join recepti r on r.rec_id = sk.rec_id\n" +
+                "where vreme = ? and telefon = ?;";
+        PreparedStatement prepStm = connection.prepareStatement(query);
+
+        prepStm.setObject(1, vreme);
+        prepStm.setString(2, telefon);
+
+        ResultSet result = prepStm.executeQuery();
+        List<Stavka> stavki = new ArrayList<>();
+        while (result.next()){
+            Stavka stavka = new Stavka();
+            stavka.setRecIme(result.getString("rec_ime"));
+            stavka.setTelefon(result.getString("telefon"));
+            stavka.setNacin(result.getString("nacin"));
+            stavka.setVreme(result.getObject("vreme", LocalDateTime.class));
+            stavki.add(stavka);
+        }
+        DB.closeConnection();
+        result.close();
+        prepStm.close();
+        return stavki;
+    }
 }
Index: src/main/java/com/example/cookbook/service/NarackiService.java
===================================================================
--- src/main/java/com/example/cookbook/service/NarackiService.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/service/NarackiService.java	(revision ee276857e882c951c22c0041683ace305d6d6de6)
@@ -2,6 +2,9 @@
 
 import com.example.cookbook.model.Naracka;
+import com.example.cookbook.model.Recept;
+import com.example.cookbook.model.Stavka;
 
 import java.sql.SQLException;
+import java.time.LocalDateTime;
 import java.util.List;
 
@@ -9,3 +12,5 @@
 
     List<Naracka> listAll() throws SQLException;
+
+    List<Stavka> findByTelAndVreme(String telefon, LocalDateTime vreme) throws SQLException;
 }
Index: src/main/java/com/example/cookbook/service/impl/NarackiServiceImpl.java
===================================================================
--- src/main/java/com/example/cookbook/service/impl/NarackiServiceImpl.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/service/impl/NarackiServiceImpl.java	(revision ee276857e882c951c22c0041683ace305d6d6de6)
@@ -3,4 +3,6 @@
 
 import com.example.cookbook.model.Naracka;
+import com.example.cookbook.model.Recept;
+import com.example.cookbook.model.Stavka;
 import com.example.cookbook.repository.NarackiRepository;
 import com.example.cookbook.service.NarackiService;
@@ -8,4 +10,5 @@
 
 import java.sql.SQLException;
+import java.time.LocalDateTime;
 import java.util.List;
 
@@ -23,3 +26,8 @@
         return narackiRepository.findAll();
     }
+
+    @Override
+    public List<Stavka> findByTelAndVreme(String telefon, LocalDateTime vreme) throws SQLException {
+        return narackiRepository.findByTelAndVreme(telefon, vreme);
+    }
 }
