// clave ssh para interactuar con el hosting
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC/qPuCtZ5QNvk6i1Mntpedd66nQ6EfneAO+2qtUm8ivO33dy7hFguUaC1nfQtjy5whVHP9HfDXGPG6MmdMPUY6YE4oiSEq1xplYlSD9Tbs97PcRc0rg/8UMs2o0kr7JssHosJhvPrCOU1QguW3C6H81DDnGNCmiW3UHHzKc1lcUJWzJxZ5g3bbHRbo6171YXOvRl9p+SfiIf9gYL+lPOK2d3oVGHFO8+4VGZxuKmsgLoYUliiIh09LPNGEugoyYnHzDV2XsSg+y2XK7KNZbJIjZuV8E4MA41c6F3YlycpIFuFMkd9fOR9USAFIxS/WKnXWYksebbIgUJXM7Yk0n/KH u787854464@nl-srv-web153.main-hosting.eu

// crear repositorios
// repositorios de aplicacion:


appdoctor.grupohpsalud.com	/home/u787854464/domains/grupohpsalud.com/public_html/appdoctor	
appadministrativo.grupohpsalud.com	/home/u787854464/domains/grupohpsalud.com/public_html/appadministrativo	



// aca estaran las consultas de los 6 reportes

-- reporte de citas de la fecha con estado = 'atendido'
SELECT 
	c."Appointment" as fecha,
	c."Condition" as Estado,
	c."Type" as tipo,
	CONCAT_WS(' ', ad."Name", ad."LastName") as trabajador,
	CONCAT_WS(' ', cli."Name", cli."LastName") as cliente,
	CONCAT_WS(' ', doc."Name", doc."LastName") as doctor,
	es."Name" as especialidad,
	ho."Day" as dia,
	ho."Cupo" as cupo,
	h."Turn" as turno,
	CONCAT_WS(' - ', h."Start", h."End") as lapzo
	FROM public."Cita" as c
	inner join public."Clientes" as cli on c."ClienteId" = cli.id
	inner join public."Admins" as ad on c."AdminId" = ad.id
	inner join public."Horarios" as ho on c."HorarioId" = ho.id
	inner join public."Horas" as h on ho."HoraId" = h.id
	inner join public."Especialista" as esp on ho."EspecialistaId" = esp.id
	inner join public."Doctors" as doc on esp."DoctorId" = doc.id
	inner join public."Especialidads" as es on esp."EspecialidadId" = es.id
	where c."Appointment" between '${fechaInicio}'::DATE and '${fechaFin}'::DATE
	and c."Condition" = 'atendido'
	order by c."Appointment";
-- reporte de citas de la fecha con estado = 'no vino'
SELECT 
	c."Appointment" as fecha,
	c."Condition" as Estado,
	c."Type" as tipo,
	CONCAT_WS(' ', ad."Name", ad."LastName") as trabajador,
	CONCAT_WS(' ', cli."Name", cli."LastName") as cliente,
	CONCAT_WS(' ', doc."Name", doc."LastName") as doctor,
	es."Name" as especialidad,
	ho."Day" as dia,
	ho."Cupo" as cupo,
	h."Turn" as turno,
	CONCAT_WS(' - ', h."Start", h."End") as doctor
	FROM public."Cita" as c
	inner join public."Clientes" as cli on c."ClienteId" = cli.id
	inner join public."Admins" as ad on c."AdminId" = ad.id
	inner join public."Horarios" as ho on c."HorarioId" = ho.id
	inner join public."Horas" as h on ho."HoraId" = h.id
	inner join public."Especialista" as esp on ho."EspecialistaId" = esp.id
	inner join public."Doctors" as doc on esp."DoctorId" = doc.id
	inner join public."Especialidads" as es on esp."EspecialidadId" = es.id
	where c."Appointment" between '${fechaInicio}'::DATE and '${fechaFin}'::DATE
	and c."Condition" = 'no vino'
	order by c."Appointment";
-- reporte de citas de la fecha con estado = 'reservado'
SELECT 
	c."Appointment" as fecha,
	c."Condition" as Estado,
	c."Type" as tipo,
	CONCAT_WS(' ', ad."Name", ad."LastName") as trabajador,
	CONCAT_WS(' ', cli."Name", cli."LastName") as cliente,
	CONCAT_WS(' ', doc."Name", doc."LastName") as doctor,
	es."Name" as especialidad,
	ho."Day" as dia,
	h."Turn" as turno,
		CONCAT_WS(' - ', h."Start", h."End") as doctor
	FROM public."Cita" as c
	inner join public."Clientes" as cli on c."ClienteId" = cli.id
	inner join public."Admins" as ad on c."AdminId" = ad.id
	inner join public."Horarios" as ho on c."HorarioId" = ho.id
	inner join public."Horas" as h on ho."HoraId" = h.id
	inner join public."Especialista" as esp on ho."EspecialistaId" = esp.id
	inner join public."Doctors" as doc on esp."DoctorId" = doc.id
	inner join public."Especialidads" as es on esp."EspecialidadId" = es.id
	where c."updatedAt" between '${fechaInicio}'::DATE and '${fechaFin}'::DATE
	and c."Condition" = 'reservado'
	order by c."Appointment";
-- reporte de citas de la fecha con estado = 'postergado'
SELECT 
	c."Appointment" as fecha,
	c."Condition" as Estado,
	c."Type" as tipo,
	CONCAT_WS(' ', ad."Name", ad."LastName") as trabajador,
	CONCAT_WS(' ', cli."Name", cli."LastName") as cliente,
	CONCAT_WS(' ', doc."Name", doc."LastName") as doctor,
	es."Name" as especialidad,
	ho."Day" as dia,
	h."Turn" as turno,
		CONCAT_WS(' - ', h."Start", h."End") as doctor
	FROM public."Cita" as c
	inner join public."Clientes" as cli on c."ClienteId" = cli.id
	inner join public."Admins" as ad on c."AdminId" = ad.id
	inner join public."Horarios" as ho on c."HorarioId" = ho.id
	inner join public."Horas" as h on ho."HoraId" = h.id
	inner join public."Especialista" as esp on ho."EspecialistaId" = esp.id
	inner join public."Doctors" as doc on esp."DoctorId" = doc.id
	inner join public."Especialidads" as es on esp."EspecialidadId" = es.id
	where c."updatedAt" between '${fechaInicio}'::DATE and '${fechaFin}'::DATE
	and c."Condition" = 'postergado'
	order by c."Appointment";