From 7060ad33b3104080688a6a383746932b7e4e2957 Mon Sep 17 00:00:00 2001
From: gabrhr <73925454+gabrhr@users.noreply.github.com>
Date: Sat, 14 May 2022 12:48:56 -0500
Subject: Add odiparback

carpetas falta model se borro :(
---
 .../main/java/pe/edu/pucp/odiparback/demo/controllers/eliminame.java | 5 +++++
 .../main/java/pe/edu/pucp/odiparback/demo/dao/impl/eliminame.java    | 5 +++++
 .../src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java      | 1 +
 3 files changed, 11 insertions(+)
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/controllers/eliminame.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/dao/impl/eliminame.java
 create mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java

(limited to 'back/odiparback/src/main')

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/controllers/eliminame.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/controllers/eliminame.java
new file mode 100644
index 0000000..946b9ef
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/controllers/eliminame.java
@@ -0,0 +1,5 @@
+package pe.edu.pucp.odiparback.demo.controllers;
+
+public class eliminame {
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/dao/impl/eliminame.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/dao/impl/eliminame.java
new file mode 100644
index 0000000..11a66ab
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/dao/impl/eliminame.java
@@ -0,0 +1,5 @@
+package pe.edu.pucp.odiparback.demo.dao.impl;
+
+public class eliminame {
+    
+}
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java
new file mode 100644
index 0000000..7898192
--- /dev/null
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java
@@ -0,0 +1 @@
+a
-- 
cgit v1.2.3


From 0d238caafe9b58559ca65c036b354d9aa33ba151 Mon Sep 17 00:00:00 2001
From: Mitsuo Tokumori <rtokumori@pucp.edu.pe>
Date: Tue, 31 May 2022 14:02:20 -0500
Subject: Make mvnw executable.  Specify database

odiparback/src/main/resources/application.properties
---
 .../src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java      | 1 -
 back/odiparback/src/main/resources/application.properties            | 5 ++++-
 2 files changed, 4 insertions(+), 2 deletions(-)
 delete mode 100644 back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java

(limited to 'back/odiparback/src/main')

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java
deleted file mode 100644
index 7898192..0000000
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/demo/services/aaa.java
+++ /dev/null
@@ -1 +0,0 @@
-a
diff --git a/back/odiparback/src/main/resources/application.properties b/back/odiparback/src/main/resources/application.properties
index 8b13789..bdbd503 100644
--- a/back/odiparback/src/main/resources/application.properties
+++ b/back/odiparback/src/main/resources/application.properties
@@ -1 +1,4 @@
-
+spring.datasource.url=jdbc:mysql://tokumori.xyz:3306/
+spring.datasource.dbname=odiparback
+spring.datasource.username=gabs
+spring.datasource.password=odiparfront
-- 
cgit v1.2.3


From 4fef941b7f221943ea654cd7c0b3c452b562f09c Mon Sep 17 00:00:00 2001
From: Mitsuo Tokumori <rtokumori@pucp.edu.pe>
Date: Tue, 31 May 2022 21:31:54 -0500
Subject: Remove ODP_ prefix from DAO implementations

---
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java     | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java      | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java      | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java     | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java         | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java      | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java      | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java        | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java  | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java  | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java       | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java   | 2 +-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java     | 2 +-
 13 files changed, 13 insertions(+), 13 deletions(-)

(limited to 'back/odiparback/src/main')

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
index 575d38a..c1967b5 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
@@ -23,7 +23,7 @@ public class AlmacenDaoImp implements AlmacenDao {
     public List<Almacen> getAll() {
         List<Almacen> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Almacen";
+            String query = "SELECT * FROM almacen";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java
index 1bf1882..745a0c2 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java
@@ -23,7 +23,7 @@ public class AveriaDaoImp implements AveriaDao{
     public List<Averia> getAll() {
         List<Averia> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Averia";
+            String query = "SELECT * FROM averia";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java
index 4c97808..00d723d 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java
@@ -23,7 +23,7 @@ public class CamionDaoImp implements CamionDao {
     public List<Camion> getAll() {
         List<Camion> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Camion";
+            String query = "SELECT * FROM camion";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java
index 2a9ae44..54b8d92 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java
@@ -23,7 +23,7 @@ public class ClienteDaoImp implements ClienteDao {
     public List<Cliente> getAll() {
         List<Cliente> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Cliente";
+            String query = "SELECT * FROM cliente";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java
index ac076cf..37d18df 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java
@@ -23,7 +23,7 @@ public class PTGDaoImp implements PTGDao{
     public List<PTG> getAll() {
         List<PTG> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_PTG";
+            String query = "SELECT * FROM ptg";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java
index 3ebc387..943a085 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java
@@ -23,7 +23,7 @@ public class PedidoDaoImp implements PedidoDao {
     public List<Pedido> getAll() {
         List<Pedido> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Pedido";
+            String query = "SELECT * FROM pedido";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java
index 15788d4..f5ca8ef 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java
@@ -23,7 +23,7 @@ public class RegionDaoImp implements RegionDao {
     public List<Region> getAll() {
         List<Region> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Region";
+            String query = "SELECT * FROM region";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java
index 0e491b7..de8ed6c 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java
@@ -23,7 +23,7 @@ public class RutaDaoImp implements RutaDao {
     public List<Ruta> getAll() {
         List<Ruta> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Ruta";
+            String query = "SELECT * FROM ruta";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java
index f2980cf..0248800 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java
@@ -23,7 +23,7 @@ public class TipoAveriaDaoImp implements TipoAveriaDao{
     public List<TipoAveria> getAll() {
         List<TipoAveria> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_TipoAveria";
+            String query = "SELECT * FROM tipoAveria";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
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 0889570..9758a3b 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
@@ -23,7 +23,7 @@ public class TipoCamionDaoImp implements TipoCamionDao{
     public List<TipoCamion> getAll() {
         List<TipoCamion> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_TipoCamion";
+            String query = "SELECT * FROM tipoCamion";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java
index 717dcf2..abd275d 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java
@@ -23,7 +23,7 @@ public class TramoDaoImp implements TramoDao{
     public List<Tramo> getAll() {
         List<Tramo> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Tramo";
+            String query = "SELECT * FROM tramo";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java
index 1808c61..7f5f7dd 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java
@@ -23,7 +23,7 @@ public class TramoRutaDaoImp implements TramoRutaDao {
     public List<TramoRuta> getAll() {
         List<TramoRuta> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_TramoRuta";
+            String query = "SELECT * FROM tramoRuta";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java
index c0e6ef1..9ed2f86 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java
@@ -23,7 +23,7 @@ public class UsuarioDaoImp implements UsuarioDao{
     public List<Usuario> getAll() {
         List<Usuario> resultado = null;
         try{
-            String query = "SELECT * FROM ODP_Usuario";
+            String query = "SELECT * FROM usuario";
             resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
-- 
cgit v1.2.3


From 5ec150126e38f592aeeaf49731eb45cced4f308c Mon Sep 17 00:00:00 2001
From: Mitsuo Tokumori <rtokumori@pucp.edu.pe>
Date: Tue, 31 May 2022 23:07:51 -0500
Subject: Adjust models to fit DataBase

Remove prefix ODP_
Fix id field names
Add some missing attributes here and there
---
 .../pe/edu/pucp/odiparback/models/Almacen.java     | 18 +++++++++---------
 .../java/pe/edu/pucp/odiparback/models/Averia.java | 10 +++++-----
 .../java/pe/edu/pucp/odiparback/models/Camion.java |  8 ++++----
 .../pe/edu/pucp/odiparback/models/Cliente.java     |  8 ++++----
 .../java/pe/edu/pucp/odiparback/models/PTG.java    | 21 ++++++++++-----------
 .../java/pe/edu/pucp/odiparback/models/Pedido.java | 22 +++++++++++-----------
 .../java/pe/edu/pucp/odiparback/models/Region.java |  4 ++--
 .../java/pe/edu/pucp/odiparback/models/Rol.java    |  4 ++--
 .../java/pe/edu/pucp/odiparback/models/Ruta.java   | 22 +++++++++-------------
 .../pe/edu/pucp/odiparback/models/TipoAveria.java  |  6 +++---
 .../pe/edu/pucp/odiparback/models/TipoCamion.java  |  8 ++++----
 .../java/pe/edu/pucp/odiparback/models/Tramo.java  | 10 +++++-----
 .../pe/edu/pucp/odiparback/models/TramoRuta.java   | 14 ++++++++------
 .../pe/edu/pucp/odiparback/models/Usuario.java     | 10 +++++++---
 14 files changed, 83 insertions(+), 82 deletions(-)

(limited to 'back/odiparback/src/main')

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java
index ab8e989..dd5a815 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java
@@ -28,22 +28,22 @@ import lombok.Setter;
 public class Almacen {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idAlmacen", updatable = false, nullable = false)
-    private int idAlmacen;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
-    @Column(name = "cuidad")
-    private String cuidad; //nombre del almacen = nombre cuidad
+    @Column(name = "ciudad")
+    private String ciudad; //nombre del almacen = nombre cuidad
 
-    @Column(name = "posicionX")
-    private int posicionX;
+    @Column(name = "latitud")
+    private double latitud;
 
-    @Column(name = "posicionY")
-    private int posicionY;
+    @Column(name = "longitud")
+    private double longitud;
 
     @Column(name = "esPrincipal")
     private boolean esPrincipal;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idRegion")
+    @JoinColumn(name = "region_fk")
     private Region region;
 }
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Averia.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Averia.java
index 69d69c3..dae9a24 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Averia.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Averia.java
@@ -30,20 +30,20 @@ import lombok.Setter;
 public class Averia {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idAveria", updatable = false, nullable = false)
-    private int idAveria;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "descripcion")
-    private String nombre;
+    private String descripcion;
     
     @Column(name = "fechaRegistro")
     private Date fechaRegistro;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idCamion")
+    @JoinColumn(name = "camion_fk")
     private Camion camion;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idTipoAveria")
+    @JoinColumn(name = "tipoAveria_fk")
     private TipoAveria tipoAveria;
 }
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 123ce79..834e2d1 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
@@ -28,20 +28,20 @@ import lombok.Setter;
 public class Camion {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idCamion", updatable = false, nullable = false)
-    private int idCamion;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "placa")
     private String placa;
 
     @Column(name = "kilometraje")
-    private Double kilometraje;
+    private double kilometraje;
 
     @Column(name = "estado")
     private int estado = 0; //0:
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idTipoCamion")
+    @JoinColumn(name = "tipoCamion_fk")
     private TipoCamion tipoCamion;
 
 }
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Cliente.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Cliente.java
index bea5d13..acb4213 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Cliente.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Cliente.java
@@ -25,14 +25,14 @@ import lombok.Setter;
 public class Cliente {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idCliente", updatable = false, nullable = false)
-    private int idCliente;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "nombreCompleto")
-    private String nombreCompleto;
+    private String nombreCompleto;      // Razon Social
 
     @Column(name = "dni")
-    private int dni;
+    private int dni;            // RUC
 
     @Column(name = "correo")
     private String correo;
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/PTG.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/PTG.java
index 2a21379..edc4194 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/PTG.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/PTG.java
@@ -2,12 +2,7 @@ package pe.edu.pucp.odiparback.models;
 
 import java.util.Date;
 
-import javax.persistence.Column;
-import javax.persistence.Entity;
-import javax.persistence.GeneratedValue;
-import javax.persistence.GenerationType;
-import javax.persistence.Id;
-import javax.persistence.Table;
+import javax.persistence.*;
 
 import org.hibernate.annotations.SQLDelete;
 import org.hibernate.annotations.Where;
@@ -19,7 +14,7 @@ import lombok.Setter;
 
 @Entity
 @Table(name = "ptg")
-@SQLDelete(sql = "UPDATE ptg SET activo = 0 WHERE id = ?")
+@SQLDelete(sql = "UPDATE PTG SET activo = 0 WHERE id = ?")
 @Where(clause = "activo = 1")
 @NoArgsConstructor
 @AllArgsConstructor
@@ -29,12 +24,16 @@ public class PTG {
     //Plan de transporte Generado
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idPTG", updatable = false, nullable = false)
+    @Column(name = "id", updatable = false, nullable = false)
     private int idPTG;
 
-    @Column(name = "fechaGenerada")
-    private Date fechaGenerada;
+    @Column(name = "fechaGenerado")
+    private Date fechaGenerado;
 
     @Column(name = "esSimulacion")
-    private boolean esSimulacion;   
+    private boolean esSimulacion;
+
+    @ManyToOne(fetch = FetchType.EAGER)
+    @JoinColumn(name = "usuario_fk")
+    private Usuario usuario_fk;    // Usuario que genera
 }
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java
index 616aea4..38cd5a7 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java
@@ -34,33 +34,33 @@ import lombok.Setter;
 public class Pedido {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idPedido", updatable = false, nullable = false)
-    private int idPedido;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "cantidad")
     private int cantidad;
 
     @Column(name = "estado")
-    private int estado; //0: pendiente
+    private int estado;         //0: pendiente
 
-    @Column(name = "codigo")
-    private int codigo;
+    @Column(name = "codigoPedido")
+    private int codigoPedido;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idAlmacen")
+    @JoinColumn(name = "almacen_fk")
     private Almacen almacen;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idCliente")
+    @JoinColumn(name = "cliente_fk")
     private Cliente cliente;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idUsuario")
-    private Usuario usuarioRegistro; //Usuario que registra
+    @JoinColumn(name = "usuario_fk")
+    private Usuario usuarioRegistro;    //Usuario que registra
 
     @Temporal(TemporalType.TIMESTAMP)
     @Column(columnDefinition = "DATETIME", nullable = false)
-    protected Date fechaRegistro = new Date();
+    protected Date fechaPedido = new Date();
 
     @Temporal(TemporalType.TIMESTAMP)
     @Column(columnDefinition = "DATETIME", nullable = false)
@@ -73,7 +73,7 @@ public class Pedido {
 
     @PrePersist
     private void onCreate(){
-        fechaRegistro=fechaModificacion=addHoursToJavaUtilDate(new Date(), -5);
+        fechaPedido=fechaPedido=addHoursToJavaUtilDate(new Date(), -5);
     }
     
     public Date addHoursToJavaUtilDate(Date date, int hours) {
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Region.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Region.java
index 1341317..b0d4625 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Region.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Region.java
@@ -25,8 +25,8 @@ import lombok.Setter;
 public class Region {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idRegion", updatable = false, nullable = false)
-    private int idRegion;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "nombre")
     private String nombre;
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Rol.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Rol.java
index a3bc5b5..0be1521 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Rol.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Rol.java
@@ -25,8 +25,8 @@ import lombok.Setter;
 public class Rol {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idRol", updatable = false, nullable = false)
-    private int idRol;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "nombre")
     private String nombre;
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Ruta.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Ruta.java
index b1a9368..2bc8ce0 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Ruta.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Ruta.java
@@ -33,28 +33,24 @@ import lombok.Setter;
 public class Ruta {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idRuta", updatable = false, nullable = false)
-    private int idRuta;
-
-    @Column(name = "nombre")
-    private String nombre;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "fechaInicio")
     private Date fechaInicio;
 
-    @Column(name = "fechaFinEst")
-    private Date fechaFinEst;
-
-    
-    @Column(name = "fechaFinReal")
-    private Date fechaFinReal;
+    @Column(name = "fechaFin")
+    private Date fechaFin;
 
     @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
-    @JoinColumn(name = "idTramoRuta")
+    @JoinColumn(name = "id")
     private List<TramoRuta> tramoRutas;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idCamion")
+    @JoinColumn(name = "camion_fk")
     private Camion camion;
 
+    @ManyToOne(fetch = FetchType.EAGER)
+    @JoinColumn(name = "PTG_fk")
+    private PTG ptg;
 }
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoAveria.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoAveria.java
index 92156fd..84488eb 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoAveria.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoAveria.java
@@ -27,12 +27,12 @@ import lombok.Setter;
 public class TipoAveria {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idTipoAveria", updatable = false, nullable = false)
-    private int idTipoAveria;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "nombre")
     private String nombre;
 
     @Column(name = "duracion")
-    private Date duracion;
+    private int duracion;
 }
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoCamion.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoCamion.java
index 608a089..f8aab31 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoCamion.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TipoCamion.java
@@ -25,13 +25,13 @@ import lombok.Setter;
 public class TipoCamion {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idTipoCamion", updatable = false, nullable = false)
-    private int idTipoCamion;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "nombre")
     private String nombre; //Tipo A, B o C
 
-    @Column(name = "velocidad")
-    private Double velocidad;
+    @Column(name = "capacidad")
+    private int capacidad;
 
 }
\ No newline at end of file
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Tramo.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Tramo.java
index 1a615d0..4f1ea69 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Tramo.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Tramo.java
@@ -29,20 +29,20 @@ public class Tramo {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
     @Column(name = "idTramo", updatable = false, nullable = false)
-    private int idTramo;
+    private int id;
 
     @Column(name = "distancia")
     private double distancia;
 
-    @Column(name = "estado")
-    private boolean estado;
+    @Column(name = "estaBloqueado")
+    private boolean estaBloqueado;             // estado
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idAlmacen")
+    @JoinColumn(name = "almacen1_fk")
     private Almacen origen;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idAlmacen")
+    @JoinColumn(name = "almacen2_fk")
     private Almacen destino;
 
 }
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TramoRuta.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TramoRuta.java
index 7c55588..a2d9241 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TramoRuta.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/TramoRuta.java
@@ -21,8 +21,8 @@ import lombok.NoArgsConstructor;
 import lombok.Setter;
 
 @Entity
-@Table(name = "tramoRuta")
-@SQLDelete(sql = "UPDATE tramoRuta SET activo = 0 WHERE id = ?")
+@Table(name = "tramo_ruta")
+@SQLDelete(sql = "UPDATE tramo_ruta SET activo = 0 WHERE id = ?")
 @Where(clause = "activo = 1")
 @NoArgsConstructor
 @AllArgsConstructor
@@ -30,11 +30,11 @@ import lombok.Setter;
 public class TramoRuta {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idTramoRuta", updatable = false, nullable = false)
-    private int idTramoRuta;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
 
     @Column(name = "orden")
-    private int orden; // idk
+    private int orden;      // idk -> Rpta: # de orden en la ruta
     
     @Column(name = "paquetesEntregar")
     private int paquetesEntregar;
@@ -52,6 +52,8 @@ public class TramoRuta {
     private Date horaLlegadaReal;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idTramo")
+    @JoinColumn(name = "tramo_fk")
     private Tramo tramo;
+
+    // ruta_fk
 }
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Usuario.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Usuario.java
index b7902ba..9920c12 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Usuario.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Usuario.java
@@ -28,8 +28,8 @@ import lombok.Setter;
 public class Usuario {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "idUsuario", updatable = false, nullable = false)
-    private int idUsuario;
+    @Column(name = "id", updatable = false, nullable = false)
+    private int id;
     
     @Column(name = "usuario")
     private String usuario;
@@ -50,6 +50,10 @@ public class Usuario {
     private String correo;
 
     @ManyToOne(fetch = FetchType.EAGER)
-    @JoinColumn(name = "idRol")
+    @JoinColumn(name = "creador_fk")
+    private Usuario creador;
+
+    @ManyToOne(fetch = FetchType.EAGER)
+    @JoinColumn(name = "rol_fk")
     private Rol rol;
 }
-- 
cgit v1.2.3


From bb4aaab339b0cbc15af38e6218c9e594d8b7804e Mon Sep 17 00:00:00 2001
From: Mitsuo Tokumori <rtokumori@pucp.edu.pe>
Date: Wed, 1 Jun 2022 00:49:43 -0500
Subject: Small changes to models.  Add sql view and dump

---
 .../src/main/java/pe/edu/pucp/odiparback/models/Almacen.java   | 10 ++++++++--
 .../src/main/java/pe/edu/pucp/odiparback/models/Pedido.java    |  2 +-
 2 files changed, 9 insertions(+), 3 deletions(-)

(limited to 'back/odiparback/src/main')

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java
index dd5a815..121b711 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Almacen.java
@@ -31,8 +31,14 @@ public class Almacen {
     @Column(name = "id", updatable = false, nullable = false)
     private int id;
 
-    @Column(name = "ciudad")
-    private String ciudad; //nombre del almacen = nombre cuidad
+    @Column(name = "ubigeo")
+    private String ubigeo;
+
+    @Column(name = "departamento")
+    private String departamento;
+
+    @Column(name = "provincia")
+    private String provincia;
 
     @Column(name = "latitud")
     private double latitud;
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java
index 38cd5a7..4df158b 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/models/Pedido.java
@@ -44,7 +44,7 @@ public class Pedido {
     private int estado;         //0: pendiente
 
     @Column(name = "codigoPedido")
-    private int codigoPedido;
+    private String codigoPedido;    // URL
 
     @ManyToOne(fetch = FetchType.EAGER)
     @JoinColumn(name = "almacen_fk")
-- 
cgit v1.2.3


From e9cb09907f8dbc9a4a64549a3ea4d1d8313e7c25 Mon Sep 17 00:00:00 2001
From: Mitsuo Tokumori <rtokumori@pucp.edu.pe>
Date: Wed, 1 Jun 2022 13:06:34 -0500
Subject: Fix application.settings,  try with different...

AlmacenDaoImp.getAll
---
 .../main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java  | 6 ++++--
 back/odiparback/src/main/resources/application.properties        | 9 ++++++---
 2 files changed, 10 insertions(+), 5 deletions(-)

(limited to 'back/odiparback/src/main')

diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
index c1967b5..7a17ded 100644
--- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
+++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java
@@ -23,8 +23,10 @@ public class AlmacenDaoImp implements AlmacenDao {
     public List<Almacen> getAll() {
         List<Almacen> resultado = null;
         try{
-            String query = "SELECT * FROM almacen";
-            resultado =  entityManager.createQuery(query).getResultList();
+            String hql = "FROM almacen ";
+            resultado = entityManager.createQuery(hql).getResultList();
+//            String query = "SELECT * FROM almacen";
+//            resultado =  entityManager.createQuery(query).getResultList();
         }
         catch(Exception ex){ 
             System.out.print(ex.getMessage()); 
diff --git a/back/odiparback/src/main/resources/application.properties b/back/odiparback/src/main/resources/application.properties
index bdbd503..6c4feb8 100644
--- a/back/odiparback/src/main/resources/application.properties
+++ b/back/odiparback/src/main/resources/application.properties
@@ -1,4 +1,7 @@
-spring.datasource.url=jdbc:mysql://tokumori.xyz:3306/
-spring.datasource.dbname=odiparback
+# MySQL
+spring.datasource.url=jdbc:mysql://tokumori.xyz:3306/odiparback
 spring.datasource.username=gabs
-spring.datasource.password=odiparfront
+spring.datasource.password=odiparfront123odiparfront123odiparfront123
+spring.datasource.driver-class-name=com.mysql.jdbc.Driver
+spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
+# com.mysql.cj.jdbc.Driver   (new driver)
\ No newline at end of file
-- 
cgit v1.2.3