CREATE OR ALTER PROCEDURE GETALLCustomerDetails
AS
BEGIN
	SELECT  'BIPL' as Client,
			'Quality Management' AS Vertical,
			EB.EmployeeName,
			AG.TechnicoId,
			Convert(Date, AG.ScheduleDate) as ScheduleDate, 
			Count(CE.ID) As 'InspectionCount',
			GETDATE() AS CurrentDateTime
	FROM [bipl.pro-inspector.net_2024].dbo.PI_ChecklistExecution CE
	INNER JOIN [bipl.pro-inspector.net_2024].dbo.CH_tblAgendamentor AG ON AG.AgendamentorId = CE.AgendamentorId_CH_tblAgendamentor
	INNER JOIN [bipl.pro-inspector.net_2024].dbo.CH_tblProjectBasics PB ON PB.ProjectId = AG.ProjectId 
	INNER JOIN [bipl.pro-inspector.net_2024].dbo.CH_tblEmployeeBasics EB ON EB.EmployeeId = AG.TechnicoId
	INNER JOIN [bipl.pro-inspector.net_2024].dbo.CH_tblClientBasic CB ON CB.ClientID = PB.ClientId
	GROUP BY PB.ClientId, ClientCode, Convert(Date, AG.ScheduleDate), AG.TechnicoId, EB.EmployeeName
END