From fab7d63333b86b9fe0f1c52d2c642b52bbf506c0 Mon Sep 17 00:00:00 2001
From: gabrhr <73925454+gabrhr@users.noreply.github.com>
Date: Mon, 6 Jun 2022 11:35:56 -0500
Subject: Add CRUD Camiones
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

- están ok funcionando: listar, insertar, editar, eliminar

#TODO
- añadir todos los puntos
- Mejorar el path del punto con funcion
- añadir tiempos segun distancia
- estetica al final (camion, colores, etc)

- Arreglar combos
- Añadir los reducer de pedidos, rutas, almacen

Camiones CRUD
- ver codigo de camion corelativo
- añadir Ciudad origen
---
 .../odiparback/controllers/TipoCamionController.java   |  5 +++++
 .../java/pe/edu/pucp/odiparback/dao/TipoCamionDao.java |  1 +
 .../edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java  | 18 ++++++++++++++++++
 .../java/pe/edu/pucp/odiparback/models/Camion.java     | 10 +---------
 .../pucp/odiparback/services/TipoCamionService.java    |  4 ++++
 5 files changed, 29 insertions(+), 9 deletions(-)

(limited to 'back')

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/controllers/TipoCamionController.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/controllers/TipoCamionController.java
index 72beae9..31374a6 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/controllers/TipoCamionController.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/controllers/TipoCamionController.java
@@ -35,6 +35,11 @@ public class TipoCamionController {
         return tipoCamionService.get(id);
     }
 
+    @GetMapping(value = "/nombre={nombre}")
+    TipoCamion get(@PathVariable String nombre)throws AuthenticationException{
+        return tipoCamionService.getXNombre(nombre);
+    }
+
     @PostMapping(value = "/")
     void register(@RequestBody TipoCamion tipoCamion)throws SQLException{
         tipoCamionService.register(tipoCamion);
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/TipoCamionDao.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/TipoCamionDao.java
index 4340dfc..4b73298 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/TipoCamionDao.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/TipoCamionDao.java
@@ -7,6 +7,7 @@ import pe.edu.pucp.odiparback.models.TipoCamion;
 public interface TipoCamionDao {
     public List<TipoCamion> getAll();
     public TipoCamion get(int id);
+    public TipoCamion getXNombre(String nombre);
     public void register(TipoCamion tipoCamion);
     public TipoCamion update(TipoCamion tipoCamion);   
     public void delete(int id);
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java
index d352634..76ad979 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java
@@ -48,6 +48,24 @@ public class TipoCamionDaoImp implements TipoCamionDao{
         return resultado;
     }
 
+    @Transactional
+    @Override
+    public TipoCamion getXNombre(String nombre) {
+        TipoCamion resultado = null;
+        List<TipoCamion> lista = null;
+        try {
+            char nomb = nombre.charAt(0);
+            String hql = "FROM TipoCamion WHERE nombre  = '" + nomb + "'";
+            lista =  entityManager.createQuery(hql).getResultList();
+            resultado = lista.get(0);
+        }
+        catch(Exception ex){ 
+            System.out.print(ex.getMessage()); 
+        }
+        
+        return resultado;
+    }
+
     @Transactional
     @Override
     public void register(TipoCamion tipoCamion) {
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Camion.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Camion.java
index 7c66069..747d937 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Camion.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Camion.java
@@ -40,9 +40,6 @@ public class Camion {
     @Column(name = "placa")
     private String placa;
 
-    @Column(name = "codigo")
-    private String codigo;
-
     @Column(name = "kilometraje")
     private double kilometraje;
 
@@ -56,9 +53,4 @@ public class Camion {
     @JoinColumn(name = "tipoCamion_fk")
     private TipoCamion tipoCamion;
 
-    @Column(name = "activo")
-    @JsonProperty(access = JsonProperty.Access.WRITE_ONLY)
-    private int activo = 1;
-
-
-}
+}
\ No newline at end of file
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/services/TipoCamionService.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/services/TipoCamionService.java
index fd7b811..e92e355 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/services/TipoCamionService.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/services/TipoCamionService.java
@@ -18,6 +18,10 @@ public class TipoCamionService {
         return daoTipoCamion.get(id);
     }
 
+    public TipoCamion getXNombre(String nombre){
+        return daoTipoCamion.getXNombre(nombre);
+    }
+
     public void register(TipoCamion tipoCamion){
         daoTipoCamion.register(tipoCamion);
     }
-- 
cgit v1.2.3