search

ViniciusConsultor / controlhoras

Automatically exported from code.google.com/p/controlhoras
1 stars 0 forks source link

Existen casos de horarios de solapamiento de funcionarios y no los marca #87

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Cual es la salida esperada? Que resultado tuve en lugar del esperado?
Cliente: 2030 - Servicio 3
Funcionario: 1746

Provea informacion adicional a continuación:
mysql> select * from escalafonempleado where NroEmpleado=1746;
+-------------+---------------------+--------------+--------------------------+-
---------+-------------
| IdEscalafon | IdEscalafonEmpleado | CodigoPuesto | HsLlamadaAntesHoraInicio | 
ACargoDe | NroEmpleado
+-------------+---------------------+--------------+--------------------------+-
---------+-------------
|     2030003 |                   5 | R-V          |                        2 | 
Cliente  |        1746
|     2063001 |                   3 | R-V          |                        2 | 
Cliente  |        1746
+-------------+---------------------+--------------+--------------------------+-
---------+-------------
2 rows in set (0.00 sec)

mysql> desc horarioescalafon;
+---------------------+-----------------------+------+-----+---------+-------+
| Field               | Type                  | Null | Key | Default | Extra |
+---------------------+-----------------------+------+-----+---------+-------+
| idEscalafon         | int(11) unsigned      | NO   | PRI | NULL    |       |
| idEscalafonEmpleado | int(11) unsigned      | NO   | PRI | NULL    |       |
| dia                 | varchar(10)           | NO   | PRI | NULL    |       |
| horaini             | varchar(10)           | YES  |     | NULL    |       |
| horafin             | varchar(10)           | YES  |     | NULL    |       |
| tipoDia             | tinyint(2) unsigned   | YES  | MUL | NULL    |       |
| Solapa              | tinyint(1)            | NO   |     | 0       |       |
| NroEmpleado         | mediumint(8) unsigned | NO   | MUL | NULL    |       |
+---------------------+-----------------------+------+-----+---------+-------+
8 rows in set (0.01 sec)

mysql> select * from horarioescalafon where NroEmpleado=1746;
+-------------+---------------------+-----------+---------+---------+---------+-
-------+-------------+
| idEscalafon | idEscalafonEmpleado | dia       | horaini | horafin | tipoDia | 
Solapa | NroEmpleado |
+-------------+---------------------+-----------+---------+---------+---------+-
-------+-------------+
|     2030003 |                   5 | Domingo   | 17:00   | 22:30   |       0 | 
     0 |        1746 |
|     2030003 |                   5 | Jueves    | 17:00   | 22:30   |       0 | 
     0 |        1746 |
|     2030003 |                   5 | Lunes     | 17:00   | 22:30   |       0 | 
     0 |        1746 |
|     2030003 |                   5 | Martes    | 17:00   | 22:30   |       0 | 
     0 |        1746 |
|     2030003 |                   5 | Miercoles | 17:00   | 22:30   |       0 | 
     0 |        1746 |
|     2030003 |                   5 | Sabado    | 17:00   | 22:30   |       0 | 
     0 |        1746 |
|     2030003 |                   5 | Viernes   |         |         |       2 | 
     0 |        1746 |
|     2063001 |                   3 | Domingo   |         |         |       1 | 
     0 |        1746 |
|     2063001 |                   3 | Jueves    | 15:00   | 00:00   |       0 | 
     0 |        1746 |
|     2063001 |                   3 | Lunes     |         |         |       1 | 
     0 |        1746 |
|     2063001 |                   3 | Martes    |         |         |       1 | 
     0 |        1746 |
|     2063001 |                   3 | Miercoles |         |         |       1 | 
     0 |        1746 |
|     2063001 |                   3 | Sabado    |         |         |       1 | 
     0 |        1746 |
|     2063001 |                   3 | Viernes   |         |         |       2 | 
     0 |        1746 |
+-------------+---------------------+-----------+---------+---------+---------+-
-------+-------------+
14 rows in set (0.02 sec)

Original issue reported on code.google.com by juanga...@gmail.com on 7 Jul 2011 at 10:29

GoogleCodeExporter commented 8 years ago 
Se modificó el módulo ControladorClienteServicio.cs para solucionar este 
issue.
El problema era que no estaba manejando bien los horarios que atraviesan la 
medianoche.

Costo: 30 min
Aunque esto es un error detectado y no una solicitud nueva.

Original comment by jpco...@gmail.com on 12 Jul 2011 at 3:50