Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/ArticleAnalysisDTO.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/ArticleAnalysisDTO.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/ArticleAnalysisDTO.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -0,0 +1,14 @@
+package com.bazi.fullystocked.Models.DTO;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class ArticleAnalysisDTO {
+    String articlename;
+    String locationname;
+    String defict;
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/LocationAnalysisDTO.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/LocationAnalysisDTO.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/LocationAnalysisDTO.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -0,0 +1,15 @@
+package com.bazi.fullystocked.Models.DTO;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.math.BigInteger;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class LocationAnalysisDTO {
+    String locationname;
+    BigInteger profit;
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/TopUsersDTO.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/TopUsersDTO.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/DTO/TopUsersDTO.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -0,0 +1,22 @@
+package com.bazi.fullystocked.Models.DTO;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.math.BigInteger;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class TopUsersDTO {
+    String firstname;
+    String lastname;
+    String username;
+    String email;
+    BigInteger topinvoicesum;
+    String toparticlename;
+    Integer toparticleprice;
+    Integer toparticlequantity;
+    Integer toparticletotalprice;
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Services/ArticlesService.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Services/ArticlesService.java	(revision 4b34fed4286f06cb11e734e5a971b441cbbe3d91)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Services/ArticlesService.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -3,4 +3,5 @@
 import com.bazi.fullystocked.Models.Articles;
 import com.bazi.fullystocked.Models.Categories;
+import com.bazi.fullystocked.Models.DTO.ArticleAnalysisDTO;
 import com.bazi.fullystocked.Models.SqlViews.ArticlesAtLocationReport;
 import com.bazi.fullystocked.Models.SqlViews.SupplierSuppliesArticleReport;
@@ -20,4 +21,5 @@
 
     List<ArticlesAtLocationReport> findAvailabilityAtAllLocations(Integer id);
+    List<ArticleAnalysisDTO> getArticleAnalysis();
 
 }
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/ArticlesServiceImpl.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/ArticlesServiceImpl.java	(revision 4b34fed4286f06cb11e734e5a971b441cbbe3d91)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/ArticlesServiceImpl.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -3,4 +3,5 @@
 import com.bazi.fullystocked.Models.Articles;
 import com.bazi.fullystocked.Models.Categories;
+import com.bazi.fullystocked.Models.DTO.ArticleAnalysisDTO;
 import com.bazi.fullystocked.Models.Exceptions.InvalidArgumentsException;
 import com.bazi.fullystocked.Models.SqlViews.ArticlesAtLocationReport;
@@ -11,6 +12,10 @@
 import com.bazi.fullystocked.Repositories.SupplierSuppliesArticleRepository;
 import com.bazi.fullystocked.Services.ArticlesService;
+import org.hibernate.query.NativeQuery;
+import org.hibernate.transform.Transformers;
 import org.springframework.stereotype.Service;
 
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
 import javax.transaction.Transactional;
 import java.util.List;
@@ -23,4 +28,6 @@
     private final SupplierSuppliesArticleRepository supplierSuppliesArticleRepository;
     private final ArticlesAtLocationRepository articlesAtLocationRepository;
+    @PersistenceContext
+    private EntityManager entityManager;
 
     public ArticlesServiceImpl(ArticlesRepository articlesRepository, CategoriesRepository categoriesRepository, SupplierSuppliesArticleRepository supplierSuppliesArticleRepository, ArticlesAtLocationRepository articlesAtLocationRepository) {
@@ -85,3 +92,38 @@
         return articlesAtLocationRepository.findAllByArticleid(id);
     }
+
+    @Override
+    public List<ArticleAnalysisDTO> getArticleAnalysis() {
+        List<ArticleAnalysisDTO> results = entityManager.createNativeQuery("""
+        select a.articlename, l.locationname,
+        (case
+            when q1.dostapnost+coalesce(q2.incoming, 0)<coalesce(q3.sold, 0) then 'Yes'
+            else 'No'
+        end
+        ) as defict from project.articles a
+       left join project.storedarticles s on s.articleid=a.articleid
+       left join project.locations l on l.locationid=s.locationid
+       left join (
+        select articleid, locationid, coalesce(sum(quantity), 0) as dostapnost from project.storedarticles s
+        group by s.sarticleid, s.locationid
+       ) q1 on q1.articleid=a.articleid and q1.locationid=l.locationid
+       left join (
+        select articleid, locationid, coalesce(sum(quantity), 0) as incoming from project.orderedarticles o
+        where o.articlestatus='Ordered' or o.articlestatus='Delivered'
+        group by o.articleid, o.locationid
+       ) q2 on q2.articleid=a.articleid and q2.locationid=l.locationid
+       left join (
+        select i.articleid, l.locationid, coalesce(sum(quantity), 0) as sold from project.invoicedarticles i
+        left join project.invoices inv on inv.invoiceid=i.invoiceid and inv.datecreate between now()-interval '1 month' and now()
+        left join project.workers w on w.userid=inv.workeruserid
+        left join project.locations l on l.locationid=w.locationid
+        group by i.articleid, l.locationid
+       )q3 on q3.articleid=a.articleid and q3.locationid=l.locationid
+       order by a.articlename\s
+""")
+                .unwrap(NativeQuery.class)
+                .setResultTransformer(Transformers.aliasToBean(ArticleAnalysisDTO.class))
+                .getResultList();
+        return results;
+    }
 }
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/LocationServiceImpl.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/LocationServiceImpl.java	(revision 4b34fed4286f06cb11e734e5a971b441cbbe3d91)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/LocationServiceImpl.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -1,4 +1,6 @@
 package com.bazi.fullystocked.Services.Implementations;
 
+import com.bazi.fullystocked.Models.DTO.LocationAnalysisDTO;
+import com.bazi.fullystocked.Models.DTO.TopUsersDTO;
 import com.bazi.fullystocked.Models.Locations;
 import com.bazi.fullystocked.Models.SqlViews.ArticlesAtLocationReport;
@@ -6,6 +8,10 @@
 import com.bazi.fullystocked.Repositories.LocationsRepository;
 import com.bazi.fullystocked.Services.LocationsService;
+import org.hibernate.query.NativeQuery;
+import org.hibernate.transform.Transformers;
 import org.springframework.stereotype.Service;
 
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
 import java.util.List;
 
@@ -14,4 +20,6 @@
     private final ArticlesAtLocationRepository articlesAtLocationRepository;
     private final LocationsRepository locationsRepository;
+    @PersistenceContext
+    private EntityManager entityManager;
 
     public LocationServiceImpl(ArticlesAtLocationRepository articlesAtLocationRepository, LocationsRepository locationsRepository) {
@@ -29,3 +37,30 @@
         return locationsRepository.findAll();
     }
+
+    @Override
+    public List<LocationAnalysisDTO> getLocationAnalysis() {
+        List<LocationAnalysisDTO> results = entityManager.createNativeQuery("""
+        select q1.locationname, prihod-odliv as profit from\s
+           (
+            select l.locationid, l.locationname, coalesce(sum(i.price*i.quantity), 0) as prihod from project.locations l\s
+            left join project.storedarticles s on s.locationid=l.locationid\s
+            left join project.invoicedarticles i on i.articleid=s.articleid
+            left join project.invoices i2 on i2.invoiceid=i.invoiceid and i2.datecreate between now()-interval '1 year' and now()
+            group by l.locationid
+            
+           ) as q1
+           full outer join\s
+           (
+            select l.locationid, l.locationname, coalesce(sum(o.price*o.quantity), 0) as odliv from project.locations l\s
+            left join project.orderedarticles o on o.locationid=l.locationid\s
+            left join project.orders o2 on o2.orderid=o.orderid and o2.datecreated between now()-interval '1 year' and now()
+            group by l.locationid
+            
+           ) q2 on q2.locationid=q1.locationid
+""")
+                .unwrap(NativeQuery.class)
+                .setResultTransformer(Transformers.aliasToBean(LocationAnalysisDTO.class))
+                .getResultList();
+        return results;
+    }
 }
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/WorkersServiceImpl.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/WorkersServiceImpl.java	(revision 4b34fed4286f06cb11e734e5a971b441cbbe3d91)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Services/Implementations/WorkersServiceImpl.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -1,4 +1,6 @@
 package com.bazi.fullystocked.Services.Implementations;
 
+import com.bazi.fullystocked.Models.DTO.ArticleAnalysisDTO;
+import com.bazi.fullystocked.Models.DTO.TopUsersDTO;
 import com.bazi.fullystocked.Models.Exceptions.InvalidArgumentsException;
 import com.bazi.fullystocked.Models.Locations;
@@ -7,6 +9,10 @@
 import com.bazi.fullystocked.Repositories.WorkersRepository;
 import com.bazi.fullystocked.Services.WorkersService;
+import org.hibernate.query.NativeQuery;
+import org.hibernate.transform.Transformers;
 import org.springframework.stereotype.Service;
 
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
 import java.util.List;
 import java.util.Optional;
@@ -16,4 +22,6 @@
     private final WorkersRepository workersRepository;
     private final LocationsRepository locationsRepository;
+    @PersistenceContext
+    private EntityManager entityManager;
 
     public WorkersServiceImpl(WorkersRepository workersRepository, LocationsRepository locationsRepository) {
@@ -34,3 +42,40 @@
         return workersRepository.findAllByLocationIsNull();
     }
+
+    @Override
+    public List<TopUsersDTO> findAllTopUsers() {
+        List<TopUsersDTO> results = entityManager.createNativeQuery("""
+        select u.firstname, u.lastname, u.username, u.email, coalesce(max(ti.totalPrice), 0) as topInvoiceSum,\s
+        (select a.articlename from project.articles a
+            left join project.invoicedarticles i2 on i2.articleid=a.articleid
+            where i2.price*i2.quantity=max(ba.totalPrice)) as topArticleName,
+        (select i2.price  from project.articles a
+            left join project.invoicedarticles i2 on i2.articleid=a.articleid
+            where i2.price*i2.quantity=max(ba.totalPrice)) as topArticlePrice,
+        (select i2.quantity from project.articles a
+            left join project.invoicedarticles i2 on i2.articleid=a.articleid
+            where i2.price*i2.quantity=max(ba.totalPrice)) as topArticleQuantity,
+        max(ba.totalPrice) as topArticleTotalPrice from project.workers w\s
+                left join project.users u on u.userid=w.userid
+                left join\s
+                    (
+                        select i.invoiceid, i.workeruserid , sum(ia.price*ia.quantity) as totalPrice from project.invoices i
+                        left join project.invoicedarticles ia on ia.invoiceid=i.invoiceid
+                        group by i.invoiceid, i.workeruserid
+                    ) ti on ti.workeruserid=u.userid
+                left join
+                    (
+                        select ia2.invoiceid, a.articlename, ia2.price as price, ia2.quantity as quantity, ia2.price*ia2.quantity as totalPrice from project.invoicedarticles ia2
+                        left join project.articles a on a.articleid=ia2.articleid
+                    ) ba on ba.invoiceid=ti.invoiceid
+                group by u.userid
+                order by topInvoiceSum desc
+""")
+                .unwrap(NativeQuery.class)
+                .setResultTransformer(Transformers.aliasToBean(TopUsersDTO.class))
+                .getResultList();
+        return results;
+    }
+
+
 }
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Services/LocationsService.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Services/LocationsService.java	(revision 4b34fed4286f06cb11e734e5a971b441cbbe3d91)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Services/LocationsService.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -2,4 +2,5 @@
 
 
+import com.bazi.fullystocked.Models.DTO.LocationAnalysisDTO;
 import com.bazi.fullystocked.Models.Locations;
 import com.bazi.fullystocked.Models.SqlViews.ArticlesAtLocationReport;
@@ -10,3 +11,4 @@
     List<ArticlesAtLocationReport> findAllArticlesAtLocation(Integer locationid);
     List<Locations> findAll();
+    List<LocationAnalysisDTO> getLocationAnalysis();
 }
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Services/WorkersService.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Services/WorkersService.java	(revision 4b34fed4286f06cb11e734e5a971b441cbbe3d91)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Services/WorkersService.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -1,4 +1,6 @@
 package com.bazi.fullystocked.Services;
 
+import com.bazi.fullystocked.Models.DTO.ArticleAnalysisDTO;
+import com.bazi.fullystocked.Models.DTO.TopUsersDTO;
 import com.bazi.fullystocked.Models.Workers;
 import java.util.*;
@@ -7,3 +9,4 @@
     Optional<Workers> assignLocation(Integer workerId, Integer locationId);
     List<Workers> findAllWithNoLocation();
+    List<TopUsersDTO> findAllTopUsers();
 }
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Web/Controller/ManagerController.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Web/Controller/ManagerController.java	(revision 4b34fed4286f06cb11e734e5a971b441cbbe3d91)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Web/Controller/ManagerController.java	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -1,4 +1,5 @@
 package com.bazi.fullystocked.Web.Controller;
 
+import com.bazi.fullystocked.Services.ArticlesService;
 import com.bazi.fullystocked.Services.LocationsService;
 import com.bazi.fullystocked.Services.WorkersService;
@@ -15,8 +16,10 @@
     private final WorkersService workersService;
     private final LocationsService locationsService;
+    private final ArticlesService articlesService;
 
-    public ManagerController(WorkersService workersService, LocationsService locationsService) {
+    public ManagerController(WorkersService workersService, LocationsService locationsService, ArticlesService articlesService) {
         this.workersService = workersService;
         this.locationsService = locationsService;
+        this.articlesService = articlesService;
     }
 
@@ -47,3 +50,21 @@
         }
     }
+    @GetMapping("/topWorkers")
+    public String listTopWorkersModel(Model model)
+    {
+        model.addAttribute("workers", workersService.findAllTopUsers());
+        return "topWorkers";
+    }
+    @GetMapping("/articleAnalysis")
+    public String getArticleAnalysis(Model model)
+    {
+        model.addAttribute("articles", articlesService.getArticleAnalysis());
+        return "articleAnalysis";
+    }
+    @GetMapping("/locationAnalysis")
+    public String getLocationAnalysis(Model model)
+    {
+        model.addAttribute("locations", locationsService.getLocationAnalysis());
+        return "locationAnalysis";
+    }
 }
Index: FullyStocked/src/main/resources/templates/articleAnalysis.html
===================================================================
--- FullyStocked/src/main/resources/templates/articleAnalysis.html	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
+++ FullyStocked/src/main/resources/templates/articleAnalysis.html	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -0,0 +1,94 @@
+<!DOCTYPE html>
+<html lang="en" xmlns:sec="http://www.w3.org/1999/xhtml">
+<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
+
+<head>
+  <meta charset="UTF-8">
+  <title>Worker</title>
+</head>
+
+<body>
+<nav class="navbar navbar-expand-md navbar-dark bg-dark">
+  <div class="container">
+    <a class="navbar-brand" href="/manager">FULLYSTOCKED</a>
+    <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault"
+            aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
+      <span class="navbar-toggler-icon"></span>
+    </button>
+
+    <div class="collapse navbar-collapse justify-content-end" id="navbarsExampleDefault">
+      <ul class="navbar-nav m-auto">
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/questions/manager/list">Одговори прашање</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/orders/create">Креирај нарчка</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/articles/create">Внеси нови артикли</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/articles/category/add">Додај категорија на артикл</a>
+        </li>
+      </ul>
+
+      <ul class="nav navbar-nav navbar-right">
+
+        <li class="nav-item">
+          <a class="btn btn-light btn-sm ml-3" href="/logout">
+            <i class="fa fa-shopping-cart"></i> Logout
+          </a>
+        </li>
+      </ul>
+    </div>
+  </div>
+</nav>
+<div class="d-flex justify-content-center">
+  <h2 class="m-2">Анализа на достапноста</h2>
+</div>
+<table class="table mt-3">
+  <thead>
+  <tr>
+    <th>
+
+    </th>
+    <th>
+      Име
+    </th>
+    <th>
+      Локација
+    </th>
+    <th>
+      Дефицитарен
+    </th>
+  </tr>
+  </thead>
+  <tbody>
+  <tr th:each="w : ${articles}">
+    <td></td>
+    <td th:text="${w.getArticlename()}" class="link">
+    </td>
+    <td th:text="${w.getLocationname()}" class="link">
+    </td>
+    <td th:text="${w.getDefict()}" class="link">
+    </td>
+
+  </tr>
+  </tbody>
+</table>
+<style>
+  .link {
+    font-size: 20px;
+  }
+
+  .link1 {
+    font-size: 18px;
+  }
+
+  th {
+    font-size: 16px;
+  }
+
+</style>
+</body>
+</html>
Index: FullyStocked/src/main/resources/templates/locationAnalysis.html
===================================================================
--- FullyStocked/src/main/resources/templates/locationAnalysis.html	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
+++ FullyStocked/src/main/resources/templates/locationAnalysis.html	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -0,0 +1,89 @@
+<!DOCTYPE html>
+<html lang="en" xmlns:sec="http://www.w3.org/1999/xhtml">
+<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
+
+<head>
+  <meta charset="UTF-8">
+  <title>Worker</title>
+</head>
+
+<body>
+<nav class="navbar navbar-expand-md navbar-dark bg-dark">
+  <div class="container">
+    <a class="navbar-brand" href="/manager">FULLYSTOCKED</a>
+    <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault"
+            aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
+      <span class="navbar-toggler-icon"></span>
+    </button>
+
+    <div class="collapse navbar-collapse justify-content-end" id="navbarsExampleDefault">
+      <ul class="navbar-nav m-auto">
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/questions/manager/list">Одговори прашање</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/orders/create">Креирај нарчка</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/articles/create">Внеси нови артикли</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/articles/category/add">Додај категорија на артикл</a>
+        </li>
+      </ul>
+
+      <ul class="nav navbar-nav navbar-right">
+
+        <li class="nav-item">
+          <a class="btn btn-light btn-sm ml-3" href="/logout">
+            <i class="fa fa-shopping-cart"></i> Logout
+          </a>
+        </li>
+      </ul>
+    </div>
+  </div>
+</nav>
+<div class="d-flex justify-content-center">
+  <h2 class="m-2">Профит на секој магацин</h2>
+</div>
+<table class="table mt-3">
+  <thead>
+  <tr>
+    <th>
+
+    </th>
+    <th>
+      Локација
+    </th>
+    <th>
+      Профит
+    </th>
+  </tr>
+  </thead>
+  <tbody>
+  <tr th:each="w : ${locations}">
+    <td></td>
+    <td th:text="${w.getLocationname()}" class="link">
+    </td>
+    <td th:text="${w.getProfit()}" class="link">
+    </td>
+
+  </tr>
+  </tbody>
+</table>
+<style>
+  .link {
+    font-size: 20px;
+  }
+
+  .link1 {
+    font-size: 18px;
+  }
+
+  th {
+    font-size: 16px;
+  }
+
+</style>
+</body>
+</html>
Index: FullyStocked/src/main/resources/templates/topWorkers.html
===================================================================
--- FullyStocked/src/main/resources/templates/topWorkers.html	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
+++ FullyStocked/src/main/resources/templates/topWorkers.html	(revision 0328cb00c3398e47a5fb9c7eaa42b4c9c4ac5cb1)
@@ -0,0 +1,114 @@
+<!DOCTYPE html>
+<html lang="en" xmlns:sec="http://www.w3.org/1999/xhtml">
+<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
+
+<head>
+  <meta charset="UTF-8">
+  <title>Worker</title>
+</head>
+
+<body>
+<nav class="navbar navbar-expand-md navbar-dark bg-dark">
+  <div class="container">
+    <a class="navbar-brand" href="/manager">FULLYSTOCKED</a>
+    <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault"
+            aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
+      <span class="navbar-toggler-icon"></span>
+    </button>
+
+    <div class="collapse navbar-collapse justify-content-end" id="navbarsExampleDefault">
+      <ul class="navbar-nav m-auto">
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/questions/manager/list">Одговори прашање</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/orders/create">Креирај нарчка</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/articles/create">Внеси нови артикли</a>
+        </li>
+        <li class="nav-item m-auto">
+          <a class="nav-link active" href="/articles/category/add">Додај категорија на артикл</a>
+        </li>
+      </ul>
+
+      <ul class="nav navbar-nav navbar-right">
+
+        <li class="nav-item">
+          <a class="btn btn-light btn-sm ml-3" href="/logout">
+            <i class="fa fa-shopping-cart"></i> Logout
+          </a>
+        </li>
+      </ul>
+    </div>
+  </div>
+</nav>
+<div class="d-flex justify-content-center">
+  <h2 class="m-2">Најдобри магационери</h2>
+</div>
+<table class="table mt-3">
+  <thead>
+  <tr>
+    <th>
+
+    </th>
+    <th>
+      Име
+    </th>
+    <th>
+      Презиме
+    </th>
+    <th>
+      Износ на најдобра фактура
+    </th>
+    <th>
+      Највреден артикл
+    </th>
+    <th>
+      Цена на артиклот
+    </th>
+    <th>
+      Количина на артиклот
+    </th>
+    <th>
+      Вкупна цена на артиклот
+    </th>
+  </tr>
+  </thead>
+  <tbody>
+  <tr th:each="w : ${workers}">
+    <td></td>
+    <td th:text="${w.getFirstname()}" class="link">
+    </td>
+    <td th:text="${w.getLastname()}" class="link">
+    </td>
+    <td th:text="${w.getTopinvoicesum()}" class="link">
+    </td>
+    <td th:text="${w.getToparticlename()}" class="link">
+    </td>
+    <td th:text="${w.getToparticleprice()}" class="link">
+    </td>
+    <td th:text="${w.getToparticlequantity()}" class="link">
+    </td>
+    <td th:text="${w.getToparticletotalprice()}" class="link">
+    </td>
+
+  </tr>
+  </tbody>
+</table>
+<style>
+  .link {
+    font-size: 20px;
+  }
+
+  .link1 {
+    font-size: 18px;
+  }
+
+  th {
+    font-size: 16px;
+  }
+
+</style>
+</body>
+</html>