Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/Categories.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/Categories.java	(revision 5c142f75d0cfcf16280039461c1609aa023099ce)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/Categories.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -27,5 +27,5 @@
     @ManyToMany(mappedBy = "categoryList")
     private List<Articles> articlesList=new ArrayList<>();
-    @ManyToMany(mappedBy = "categoryList2")
+    @ManyToMany(mappedBy = "categoryList")
     private List<Suppliers> suppliersList=new ArrayList<>();
 
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/Invoices.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/Invoices.java	(revision 5c142f75d0cfcf16280039461c1609aa023099ce)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/Invoices.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -8,4 +8,5 @@
 import javax.validation.constraints.NotNull;
 import java.time.LocalDateTime;
+import java.util.*;
 
 @Data
@@ -27,4 +28,6 @@
     @JoinColumn(name = "workeruserid")
     private Workers worker;
+    @OneToMany(mappedBy = "invoice")
+    private List<InvoicedArticles>articlesList=new ArrayList<>();
 
     public Invoices(Workers worker) {
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/Orders.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/Orders.java	(revision 5c142f75d0cfcf16280039461c1609aa023099ce)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/Orders.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -10,4 +10,5 @@
 import javax.validation.constraints.NotNull;
 import java.time.LocalDateTime;
+import java.util.*;
 
 @Data
@@ -36,4 +37,6 @@
     @JoinColumn(name = "supplieruserid")
     private Suppliers supplier;
+    @OneToMany(mappedBy="order")
+    private List<OrderedArticles> articlesList=new ArrayList<>();
 
     public Orders(OrderPriority priority, Managers manager, Suppliers supplier) {
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/SqlViews/ArticlesAndCategoriesId.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/SqlViews/ArticlesAndCategoriesId.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/SqlViews/ArticlesAndCategoriesId.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,30 @@
+package com.bazi.fullystocked.Models.SqlViews;
+
+import lombok.Getter;
+import lombok.Setter;
+
+import javax.persistence.Embeddable;
+import javax.persistence.Id;
+import java.io.Serializable;
+import java.util.Objects;
+
+@Embeddable
+@Getter
+@Setter
+public class ArticlesAndCategoriesId implements Serializable {
+    private Integer categoryid;
+    private Integer articleid;
+
+    @Override
+    public boolean equals(Object o) {
+        if (this == o) return true;
+        if (o == null || getClass() != o.getClass()) return false;
+        ArticlesAndCategoriesId that = (ArticlesAndCategoriesId) o;
+        return categoryid.equals(that.categoryid) && articleid.equals(that.articleid);
+    }
+
+    @Override
+    public int hashCode() {
+        return Objects.hash(categoryid, articleid);
+    }
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/SqlViews/ArticlesAndCategoriesReport.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/SqlViews/ArticlesAndCategoriesReport.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/SqlViews/ArticlesAndCategoriesReport.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,18 @@
+package com.bazi.fullystocked.Models.SqlViews;
+
+import org.hibernate.annotations.Immutable;
+
+import javax.persistence.EmbeddedId;
+import javax.persistence.Entity;
+import javax.persistence.Id;
+import javax.persistence.Table;
+
+@Entity
+@Immutable
+@Table(name = "articles_and_cats_report")
+public class ArticlesAndCategoriesReport {
+    @EmbeddedId
+    private ArticlesAndCategoriesId id;
+    private String categoryname;
+    private String articlename;
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Models/Suppliers.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Models/Suppliers.java	(revision 5c142f75d0cfcf16280039461c1609aa023099ce)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Models/Suppliers.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -40,5 +40,5 @@
             inverseJoinColumns = @JoinColumn(name = "categoryid")
     )
-    private List<Categories> categoryList2=new ArrayList<>();
+    private List<Categories> categoryList=new ArrayList<>();
 
     public Suppliers(String firstname, String lastname, String username, String email, String password, String supplierinfo, String phone, String street, int sttreetnumber, String city) {
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/AnswersRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/AnswersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/AnswersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,13 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.AnswerId;
+import com.bazi.fullystocked.Models.Answers;
+import com.bazi.fullystocked.Models.Questions;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface AnswersRepository extends JpaRepository<Answers, AnswerId> {
+    List<Answers> findAnswersByAnswerId_Question(Questions q);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesAndCategoriesRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesAndCategoriesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesAndCategoriesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,13 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.SqlViews.ArticlesAndCategoriesId;
+import com.bazi.fullystocked.Models.SqlViews.ArticlesAndCategoriesReport;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface ArticlesAndCategoriesRepository extends JpaRepository<ArticlesAndCategoriesReport, ArticlesAndCategoriesId> {
+    List<ArticlesAndCategoriesReport> findAllById_Articleid(Integer id);
+    List<ArticlesAndCategoriesReport> findAllById_Categoryid(Integer id);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesReportRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesReportRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesReportRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,12 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.SqlViews.ArticlesReport;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface ArticlesReportRepository extends JpaRepository<ArticlesReport, Integer> {
+    Optional<ArticlesReport> findByArticleid(Integer id);
+    List<ArticlesReport> findAllByLocationid(Integer id);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,13 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Articles;
+import com.bazi.fullystocked.Models.Categories;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface ArticlesRepository extends JpaRepository<Articles, Integer> {
+    List<Articles> findAllByArticlenameContainingIgnoreCase(String name);
+    List<Articles> findAllByCategoryListContaining(Categories category);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/CategoriesRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/CategoriesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/CategoriesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,11 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Categories;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface CategoriesRepository extends JpaRepository<Categories, Integer> {
+    List<Categories> findAllByCategorynameContainsIgnoreCase(String name);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/InvoicedArticlesRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/InvoicedArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/InvoicedArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,15 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Articles;
+import com.bazi.fullystocked.Models.InvoicedArticles;
+import com.bazi.fullystocked.Models.Invoices;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface InvoicedArticlesRepository extends JpaRepository<InvoicedArticles, Integer> {
+    List<InvoicedArticles> findAllByArticle(Articles article);
+    List<InvoicedArticles> findAllByInvoice(Invoices invoice);
+    List<InvoicedArticles> findAllByInvoiceAndArticle(Invoices invoice, Articles article);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/InvoicesRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/InvoicesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/InvoicesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,22 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.InvoicedArticles;
+import com.bazi.fullystocked.Models.Invoices;
+import com.bazi.fullystocked.Models.Locations;
+import com.bazi.fullystocked.Models.Workers;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+
+import java.time.LocalDateTime;
+import java.util.*;
+
+@Repository
+public interface InvoicesRepository extends JpaRepository<Invoices, Integer> {
+    List<Invoices> findAllByWorker(Workers worker);
+    List<Invoices> findAllByCustomernameContainingIgnoreCase(String name);
+    List<Invoices> findAllByDatecreateBetween(LocalDateTime from, LocalDateTime to);
+    List<Invoices> findAllByDatecreateBetweenAndWorker(LocalDateTime from, LocalDateTime to, Workers worker);
+    List<Invoices> findAllByWorker_Location(Locations location);
+    List<Invoices> findAllByWorker_LocationAndDatecreateBetween(Locations location, LocalDateTime from, LocalDateTime to);
+    List<Invoices> findAllByArticlesListContaining(InvoicedArticles article);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/LocationsRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/LocationsRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/LocationsRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,12 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Locations;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface LocationsRepository extends JpaRepository<Locations, Integer> {
+    List<Locations> findAllByCityIgnoreCase(String city);
+    List<Locations> findAllByLocationnameContainingIgnoreCase(String name);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ManagersRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ManagersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/ManagersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,10 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Managers;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+
+@Repository
+public interface ManagersRepository extends JpaRepository<Managers, Integer> {
+
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/OrderedArticlesRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/OrderedArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/OrderedArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,22 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Articles;
+import com.bazi.fullystocked.Models.Enumerations.ArticleStatus;
+import com.bazi.fullystocked.Models.Locations;
+import com.bazi.fullystocked.Models.OrderedArticles;
+import com.bazi.fullystocked.Models.Orders;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface OrderedArticlesRepository extends JpaRepository<OrderedArticles, Integer> {
+    List<OrderedArticles> findAllByArticle(Articles article);
+    List<OrderedArticles> findAllByLocation(Locations location);
+    List<OrderedArticles> findAllByOrder(Orders order);
+    List<OrderedArticles> findAllByOrderAndArticle(Orders order, Articles article);
+    List<OrderedArticles> findAllByArticlestatus(ArticleStatus status);
+    List<OrderedArticles> findAllByLocationAndArticlestatus(Locations location, ArticleStatus status);
+    List<OrderedArticles> findAllByOrderAndArticlestatus(Orders order, ArticleStatus status);
+    List<OrderedArticles> findAllByOrderAndPriceIsNull(Orders order);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/OrdersRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/OrdersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/OrdersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,34 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Enumerations.OrderPriority;
+import com.bazi.fullystocked.Models.Enumerations.OrderStatus;
+import com.bazi.fullystocked.Models.Managers;
+import com.bazi.fullystocked.Models.OrderedArticles;
+import com.bazi.fullystocked.Models.Orders;
+import com.bazi.fullystocked.Models.Suppliers;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+
+import java.time.LocalDateTime;
+import java.util.*;
+
+@Repository
+public interface OrdersRepository extends JpaRepository<Orders, Integer> {
+    List<Orders> findAllByManager(Managers manager);
+    List<Orders> findAllByManagerAndStatus(Managers manager, OrderStatus status);
+    List<Orders> findAllByManagerAndPriority(Managers manager, OrderPriority priority);
+    List<Orders> findAllBySupplierAndStatus(Suppliers supplier, OrderStatus status);
+    List<Orders> findAllBySupplierAndPriority(Suppliers supplier, OrderPriority priority);
+    List<Orders> findAllBySupplier(Suppliers supplier);
+    List<Orders> findAllByPriority(OrderPriority priority);
+    List<Orders> findAllByStatus(OrderStatus status);
+    List<Orders> findAllByDateapprovedBetween(LocalDateTime from, LocalDateTime to);
+    List<Orders> findAllByDatecreatedBetween(LocalDateTime from, LocalDateTime to);
+    List<Orders> findAllByDateapprovedBetweenAndPriority(LocalDateTime from, LocalDateTime to, OrderPriority priority);
+    List<Orders> findAllByDatecreatedBetweenAndPriority(LocalDateTime from, LocalDateTime to, OrderPriority priority);
+    List<Orders> findAllByDateapprovedBetweenAndSupplier(LocalDateTime from, LocalDateTime to, Suppliers supplier);
+    List<Orders> findAllByDatecreatedBetweenAndSupplier(LocalDateTime from, LocalDateTime to, Suppliers supplier);
+    List<Orders> findAllByDateapprovedBetweenAndManager(LocalDateTime from, LocalDateTime to, Managers manager);
+    List<Orders> findAllByDatecreatedBetweenAndManager(LocalDateTime from, LocalDateTime to, Managers manager);
+    List<Orders> findAllByArticlesListContaining(OrderedArticles article);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/QuestionsRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/QuestionsRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/QuestionsRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,17 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Managers;
+import com.bazi.fullystocked.Models.Questions;
+import com.bazi.fullystocked.Models.StoredArticles;
+import com.bazi.fullystocked.Models.Workers;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+
+@Repository
+public interface QuestionsRepository extends JpaRepository<Questions, Integer> {
+    List<Questions> findAllByManager(Managers manager);
+    List<Questions> findAllByWorker(Workers worker);
+    List<Questions> findAllByStoredarticlesListContaining(StoredArticles article);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/StoredArticlesRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/StoredArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/StoredArticlesRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,17 @@
+package com.bazi.fullystocked.Repositories;
+import com.bazi.fullystocked.Models.Articles;
+import com.bazi.fullystocked.Models.Locations;
+import com.bazi.fullystocked.Models.StoredArticles;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface StoredArticlesRepository extends JpaRepository<StoredArticles, Integer> {
+    List<StoredArticles> findAllByLocations(Locations location);
+    List<StoredArticles> findAllByArticle(Articles article);
+    List<StoredArticles> findAllByArticleAndLocations(Articles article, Locations location);
+    List<StoredArticles> findAllByLocationsAndQuantityIsLessThanEqual(Locations location, int quantity);
+    List<StoredArticles> findAllByLocationsAndQuantity(Locations location, int quantity);
+
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/SuppliersRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/SuppliersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/SuppliersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,13 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Categories;
+import com.bazi.fullystocked.Models.Suppliers;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+import java.util.*;
+
+@Repository
+public interface SuppliersRepository extends JpaRepository<Suppliers, Integer> {
+    List<Suppliers> findAllByCategoryListContains(Categories category);
+    List<Suppliers> findAllByCityIgnoreCase(String city);
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/UsersRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/UsersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/UsersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,14 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.User;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+
+import java.util.Optional;
+
+@Repository
+public interface UsersRepository extends JpaRepository<User, Integer> {
+    Optional<User> findByUsernameAndUserpassword(String username, String userpassword);
+    Optional<User> findByUsername(String username);
+
+}
Index: FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/WorkersRepository.java
===================================================================
--- FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/WorkersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
+++ FullyStocked/src/main/java/com/bazi/fullystocked/Repositories/WorkersRepository.java	(revision d37f9ee1e497ada6d742a51ad5b845db1d42e4a5)
@@ -0,0 +1,15 @@
+package com.bazi.fullystocked.Repositories;
+
+import com.bazi.fullystocked.Models.Invoices;
+import com.bazi.fullystocked.Models.Locations;
+import com.bazi.fullystocked.Models.Workers;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+
+import java.util.*;
+
+@Repository
+public interface WorkersRepository extends JpaRepository<Workers, Integer> {
+    List<Workers> findAllByLocation(Locations location);
+    List<Workers> findAllByLocationIsNull();
+}