Sorteos

1. Clone the projet
2. mvn clean install

Note: you must have maven

Data base

1. install MySql server
2. create the database "sorteos"

3. import the sql dump file /src/main/resources/META-INF/Sorteos10-04-2023.sql

4. restore

Problems

Database connection

src/main/resources/META-INF/persistence.xml

      <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/sorteos?zeroDateTimeBehavior=CONVERT_TO_NULL"/> <--- update port or configuration
      <property name="javax.persistence.jdbc.user" value="root"/> <--- update for your user name
      <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>
      <property name="javax.persistence.jdbc.password" value="root"/> <--- update for your pass

DatePicker issue

only if you need update the UI you have to use netbeans and add the plugin to check the datepicker check your .m2/repository folder and look for the artiact LGoodDatePicker

1. in your netbeans

SQL error

ERROR: Table 'sorteos.numeros' doesn't exist
Exception in thread "AWT-EventQueue-0" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

work around

1."good luck"

TODO

//TODO boton Algoritmo1 no se usa no se ideo la manera correcta de usar las variables estadisticas
// en cambio se genera combinaciones tomando como base inicial el numero "2"
// que es el que mas sale en la primer posicision
// el boton regresa esa combinacion y las combinaciones resultantes de concurrecias por poscicion

//TODO Algoritmo1 button is not used, the correct way to use the statistical variables was not devised
// instead it is generated by combining taking as initial base the number "2"
// which is the one that comes out the most in the first position
// the button returns that combination and the combinations resulted from matches by position

Instructions

Note Melate has increased the numbers to select in its draws four times:

1. Number 555 date: 31/03/1993
2. Number 1547 date: 02/10/2002
3. Number 1877 date: 30/11/2005
4. Number 2088 date: 09/12/2007

So you can check the coincidences filter by specific dates to avoid merge different samples

checking only with the last changes

and validate if some one win more than one time like the "estrella de la suerte"

The "Buscador Numeros" section

works to validate if the number win a prize in the past

and you can validate the number of incidencies for a sequence number

The "Registro Individual"

you can add manually the specific winner

or download the file csv from the governance page and loaded(The system validate duplicate information in base of the Date)