-- =============================================

-- Author:		<Author,,Name>

-- Create date: <Create Date,,>

-- Description:	<Description,,>

-- =============================================

CREATE PROCEDURE [QuickTeam].[usp_GetWeeklyWorkSheetsByProjectId] 

	@ProjectId nvarchar(50),

	@Monday nvarchar(50),

	@Sunday nvarchar(50)

AS

BEGIN



	DECLARE @dt datetime,@qstartday datetime,@qendday datetime

SET @dt=convert(datetime,@Monday)

--2．指定日期所在季度的第一天或最后一天

SELECT @qstartday=DATEADD(qq, DATEDIFF(qq, 0, @dt), 0) ,

@qendday=DATEADD(Day,-1,

    CONVERT(char(8),

        DATEADD(Month,

            1+DATEPART(Quarter,@dt)*3-Month(@dt),

            @dt),

        120)+'1')



  select 

	   ws.[WorkSheetId]

	  ,ws.WorkSheetCode

      ,ws.[ProjectId]

      ,ws.[ProjectName]

      ,ws.[StartTime]

      ,ws.[EndTime]

	  ,ws.Finished

	  ,ws.[Status]

	  from [QuickTeam].[QuickTeam].[WorkSheet] ws 

  where projectid=@ProjectId AND DeleteFlag<>1 and isReclaimed=0

  and ((StartTime between @qstartday and @qendday) or (EndTime between @qstartday and @qendday))

  order by Finished ,WorkSheetId



END