Xailer forum

Código: Seleccionar todo

DELIMITER $$

USE `cerberos`$$

CREATE PROCEDURE `p_registroPresencia`( fechadesde DATETIME, fechahasta DATETIME)
BEGIN
	SELECT a.id   AS id_registro,
	a.fecha       AS Fecha,
	DATE_FORMAT(Fecha,'%d.%m.%Y %H:%i:%s') AS fechac,
	a.num_tarjeta AS Tarjeta,
	CONCAT(b.apellidos,', ',b.nombre) AS Empleado,
	c.nombre      AS Zona,
	d.id          AS id_incidencia,
	d.nombre      AS Incidencia,
	b.id_foto     AS id_foto,
	e.id_empleado AS id_empleado,
	a.id_zona     AS id_zona,
	e.baja        AS tarjeta_baja,
	a.sello       AS sello,
	a.lector      AS lector,
	a.baja        AS baja,
	a.id_turno    AS id_turno,
	f.nombre      AS turno,
	a.id_codigo   AS id_codigo,
	g.nombre      AS codigo,
	g.inicioturno AS inicioturno,
	g.finturno    AS finturno,
	g.no_computar AS no_computar
	FROM cerberos_registro a
	JOIN cerberos_emptarjeta e ON e.num_tarjeta = a.num_tarjeta
	JOIN cerberos_empleado b ON b.id = e.id_empleado
	JOIN cerberos_zona c ON c.id = a.id_zona
	JOIN cerberos_incidencia d ON d.id = a.incidencia
	JOIN cerberos_turno f ON f.id = a.id_turno
	JOIN cerberos_codigo g ON g.id = a.id_codigo
	WHERE e.baja=0 AND sello BETWEEN fechadesde AND fechahasta AND a.id_codigo != 0 
	ORDER BY tarjeta,fecha;
END$$

DELIMITER ;