Changeset d14176d for src/main/java/project/fmo/app/projcetfmo/Repository

Timestamp:

07/07/23 12:14:58 (19 months ago)

Author:

HristijanMitic00 <hristijan.mitic.01@…>

Branches:

main

Parents:

1dd9226

Message:

First commit

Location:

src/main/java/project/fmo/app/projcetfmo/Repository

Files:

• AdminRepository.java (modified) (1 diff)
• CenaRepository.java (modified) (1 diff)
• DostavaRepository.java (modified) (1 diff)
• DostavuvacRepository.java (modified) (1 diff)
• KategorijaRepository.java (modified) (1 diff)
• KorisnikRepository.java (modified) (1 diff)
• KupuvacRepository.java (modified) (1 diff)
• NarackaRepository.java (modified) (1 diff)
• NarackaSodrziProduktRepository.java (modified) (1 diff)
• ProduktEOdKategorijaRepository.java (modified) (1 diff)
• ProduktRepository.java (modified) (1 diff)
• TelefnoskiBrojRepository.java (modified) (1 diff)

src/main/java/project/fmo/app/projcetfmo/Repository/AdminRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface AdminRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.apache.catalina.User;
+import org.springframework.data.domain.Page;
+import org.springframework.data.domain.Pageable;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import project.fmo.app.projcetfmo.Model.AdminKorisnik;
+
+import java.util.Collection;
+
+public interface AdminRepository extends JpaRepository<AdminKorisnik, Integer> {
+
 }

src/main/java/project/fmo/app/projcetfmo/Repository/CenaRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface CenaRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.Cena;
+import project.fmo.app.projcetfmo.Model.CenaPK;
+
+public interface CenaRepository extends JpaRepository<Cena, CenaPK> {
+    Cena findByIdProdukt(Integer idProdukt);
+    void deleteByIdProdukt(Integer idProdukt);
 }

src/main/java/project/fmo/app/projcetfmo/Repository/DostavaRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface DostavaRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.Dostava;
+import project.fmo.app.projcetfmo.Model.Dostavuvac;
+
+import java.util.List;
+
+public interface DostavaRepository extends JpaRepository<Dostava, Integer> {
+    List<Dostava> findByDostavuvacAndStatus(Dostavuvac dostavuvac, String status);
+    List<Dostava> findByStatus(String status);
 }

src/main/java/project/fmo/app/projcetfmo/Repository/DostavuvacRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface DostavuvacRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.Dostavuvac;
+
+public interface DostavuvacRepository extends JpaRepository<Dostavuvac, Integer> {
 }

src/main/java/project/fmo/app/projcetfmo/Repository/KategorijaRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface KategorijaRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.Kategorija;
+
+public interface KategorijaRepository extends JpaRepository<Kategorija, Integer> {
 }

src/main/java/project/fmo/app/projcetfmo/Repository/KorisnikRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface KorisnikRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import project.fmo.app.projcetfmo.Model.Korisnik;
+
+import java.util.List;
+
+public interface KorisnikRepository extends JpaRepository<Korisnik, Integer> {
+    Korisnik findByImePrezime(String s);
+    Korisnik findByImePrezimeAndPasswordKorisnik(String s, String p);
+
+    @Query(value ="select k.id_korisnik,k.ime_prezime,\n" +
+            "\n" +
+            "(select count(n) from project.naracka as n\n" +
+            "where n.id_korisnik  = k.id_korisnik)\n" +
+            "as vkupno_naracki, \n" +
+            "\n" +
+            "(select avg(vkupno_suma) from project.naracka )\n" +
+            "as prosecna_suma_na_naracka_za_site_kupuvaci,\n" +
+            "\n" +
+            "(select sum(n3.vkupno_suma) from project.naracka as n3 \n" +
+            "where k.id_korisnik = n3.id_korisnik) \n" +
+            "as vkupno_suma_od_site_naracki_na_kupuvacot,\n" +
+            "\n" +
+            "(select count(n2) from project.naracka as n2\n" +
+            "where k.id_korisnik = n2.id_korisnik \n" +
+            "and n2.datum between now() - interval '1year'  and now() \n" +
+            "and n2.vkupno_suma > (select avg(vkupno_suma) from project.naracka) )\n" +
+            "as vkupno_naracki_nad_prosek_na_korisnikot,\n" +
+            "\n" +
+            "(select sum(n4.vkupno_suma) from project.naracka as n4 \n" +
+            "where  k.id_korisnik = n4.id_korisnik \n" +
+            "and n4.datum between now() - interval '1year' and now() \n" +
+            "and n4.vkupno_suma > (select avg(vkupno_suma) from project.naracka) ) \n" +
+            "as vkupno_suma_na_naracki_nad_prosek_za_korisnikot\n" +
+            "\n" +
+            "from project.korisnik as k \n" +
+            "inner join project.kupuvac as  k2 on k.id_korisnik = k2.id_korisnik \n" +
+            "group by k.ime_prezime,k.id_korisnik ;" ,
+    nativeQuery = true)
+    List<Object> statistics2();
 }

src/main/java/project/fmo/app/projcetfmo/Repository/KupuvacRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface KupuvacRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.Kupuvac;
+
+public interface KupuvacRepository extends JpaRepository<Kupuvac, Integer> {
 }

src/main/java/project/fmo/app/projcetfmo/Repository/NarackaRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public class NarackaRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.Kupuvac;
+import project.fmo.app.projcetfmo.Model.Naracka;
+
+public interface NarackaRepository extends JpaRepository<Naracka, Integer> {
+    Naracka findByKupuvacAndStatus(Kupuvac kupuvac, String status);
+    Naracka findByKupuvacAndIdNaracka(Kupuvac kupuvac, Integer idN);
+    Naracka findByKupuvac(Kupuvac k);
+
 }

src/main/java/project/fmo/app/projcetfmo/Repository/NarackaSodrziProduktRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface NarackaSodrziProduktRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.NarackaSodrziProdukt;
+import project.fmo.app.projcetfmo.Model.NarackaSodrziProduktPK;
+
+import javax.persistence.criteria.CriteriaBuilder;
+import java.util.List;
+
+public interface NarackaSodrziProduktRepository extends JpaRepository<NarackaSodrziProdukt, NarackaSodrziProduktPK> {
+    NarackaSodrziProdukt findByIdProduktAndIdNaracka(Integer idP, Integer idN);
+    List<NarackaSodrziProdukt> findByIdNaracka(Integer id);
+    void deleteByIdProdukt(Integer id);
+    List<NarackaSodrziProdukt> findByIdProdukt(Integer id);
 }

src/main/java/project/fmo/app/projcetfmo/Repository/ProduktEOdKategorijaRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface ProduktEOdKategorijaRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.ProduktEOdKategorija;
+import project.fmo.app.projcetfmo.Model.ProduktEOdKategorijaPK;
+
+public interface ProduktEOdKategorijaRepository extends JpaRepository<ProduktEOdKategorija, ProduktEOdKategorijaPK> {
+    ProduktEOdKategorija findByIdProdukt(Integer idProdukt);
+    void deleteByIdProdukt(Integer idProdukt);
+    ProduktEOdKategorija findByIdProduktAndIdKategorija(Integer idProdukt,Integer idKategorija);
 }

src/main/java/project/fmo/app/projcetfmo/Repository/ProduktRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public interface ProduktRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.domain.Pageable;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import project.fmo.app.projcetfmo.Model.Produkt;
+
+import java.util.List;
+
+public interface ProduktRepository extends JpaRepository<Produkt, Integer> {
+    @Query(value = """
+            select p.id_produkt,p.ime,\s
+            count(nsp) as broj_na_naracki_vo_koi_e_prisuten_produktot,\s
+            sum(nsp.kolicina) as kolicina_prodadeno_od_produktot,\s
+
+            (select avg(n4.vkupno_suma) from project.naracka as n4\s
+            join project.naracka_sodrzi_produkt nsp4 on n4.id_naracka = nsp4.id_naracka \s
+            where n4.id_naracka =nsp4.id_naracka and p.id_produkt = nsp4.id_produkt and n4.datum between now() - interval '3months'\s
+            and now())
+            as prosecna_suma_na_naracka_vo_koja_se_sodrzi_produktot,
+
+            (select count(n2) from project.naracka as n2\040
+            join project.naracka_sodrzi_produkt nsp2 on n2.id_naracka = nsp2.id_naracka\s
+            where nsp2.id_produkt = p.id_produkt and n2.adresa like '/'\s
+            and n2.datum between now() - interval '3months' and now())
+            as broj_na_naracki_na_produktot_koi_korisnikot_sam_ke_gi_podigne,
+
+            (select sum(nsp2.kolicina) from project.naracka as n2\s
+            join project.naracka_sodrzi_produkt nsp2 on n2.id_naracka = nsp2.id_naracka\s
+            where nsp2.id_produkt = p.id_produkt and n2.adresa like '/'\s
+            and n2.datum between now() - interval '3months' and now())\s
+            as  kolicina_prodadena_na_produktot_bez_dostava,
+
+            (select count(n3) from project.naracka as n3\s
+            join project.naracka_sodrzi_produkt nsp3 on n3.id_naracka = nsp3.id_naracka\s
+            where nsp3.id_produkt = p.id_produkt and n3.adresa not like '/' and n3.datum between now() - interval '3months' and now())
+            as broj_na_naracki_na_produktot_koi_ke_bidat_dostaveni_na_korisnikot,
+
+            (select sum(nsp3.kolicina) from project.naracka as n3\s
+            join project.naracka_sodrzi_produkt nsp3 on n3.id_naracka = nsp3.id_naracka
+            where nsp3.id_produkt = p.id_produkt and n3.adresa not like '/' and n3.datum between now() - interval '3months' and now())
+            as kolicina_prodadena_na_produktot_preku_dostava
+
+            from project.produkt as p
+            join project.naracka_sodrzi_produkt as nsp on p.id_produkt = nsp.id_produkt\s
+            join project.naracka as n on nsp.id_naracka = n.id_naracka\s
+            where n.datum between now() - interval '3months' and now()
+            group by p.ime,p.id_produkt;""",
+    nativeQuery = true)
+    List<Object> statistics1();
+
 }

src/main/java/project/fmo/app/projcetfmo/Repository/TelefnoskiBrojRepository.java

@@ -1 @@
-package project.fmo.app.projcetfmo.Repository;public class TelefnoskiBrojRepository {
+package project.fmo.app.projcetfmo.Repository;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import project.fmo.app.projcetfmo.Model.Telefonskibroj;
+import project.fmo.app.projcetfmo.Model.TelefonskibrojPK;
+
+public interface TelefnoskiBrojRepository extends JpaRepository<Telefonskibroj, TelefonskibrojPK> {
+
 }