USE [RGDB]
GO

/****** Object:  StoredProcedure [dbo].[Proc_GetYYQK0]    Script Date: 01/10/2026 10:21:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[Proc_GetYYQK0]
	-- Add the parameters for the stored procedure here
	@sid nvarchar(20),
	@NowDate date
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	
	--@returnCode -1：日缴款书没有提交；-2：测试
	
	SET NOCOUNT ON;
    declare
      @Store_Type int,          --当前门店模式
      @myvalue int,
      @returnCode int,          --返回状态码
      @returnStr nvarchar(50);  --返回状态说明
      
    
    set @returnCode=1;
    set @returnStr='成功';
    set @myvalue=0;
    set @Store_Type=0;
    
    Select @myvalue=COUNT(*) from SC_RA_Orders where sid=@sid and report_date=DATEADD(day,-1,@NowDate); --检测前一天是否有数据
    if @myvalue>0  --前一日存在数据
    begin
		Select @myvalue=COUNT(*) from SC_RA_Orders where sid=@sid and report_date=@NowDate and ischecked=0; --检测当日数据
		if @myvalue>0
		begin
		  set @returnCode=-1;
		  set @returnStr=CONVERT(nvarchar(20),@NowDate,23)+'日有'+CONVERT(nvarchar(20),@myvalue)+'条记录，账单未审核';
		end;
		Select @myvalue=COUNT(*) from REP_RJKS where rjks_sid=@sid and rjks_rq=DATEADD(day,-1,@NowDate);  --检测前一日缴款书是否存在
		if @myvalue=0
		begin
		  set @returnCode=-2;
		  set @returnStr=CONVERT(nvarchar(20),DATEADD(day,-1,@NowDate),23)+'日缴款书未生成';
		end else
		begin
		  Select @Store_Type=Store_Type from Base_StoreInfoEX where Store_ID=@sid  
		  and Store_Year=YEAR(@NowDate) and Store_Month=MONTH(@NowDate)
		  if @Store_Type=1
		  begin
			  Select @myvalue=rjks_czlc from REP_RJKS where rjks_sid=@sid and rjks_rq=DATEADD(day,-1,@NowDate)
			  if @myvalue=-1
			  begin
				set @returnCode=-2;
				set @returnStr=CONVERT(nvarchar(20),DATEADD(day,-1,@NowDate),23)+'日缴款书未提交';
			  end;
		  end else
		  begin
			  Select @myvalue=rjks_flag from REP_RJKS where rjks_sid=@sid and rjks_rq=DATEADD(day,-1,@NowDate)
			  if @myvalue=-1
			  begin
				set @returnCode=-2;
				set @returnStr=CONVERT(nvarchar(20),DATEADD(day,-1,@NowDate),23)+'日缴款书未提交';
			  end;
		  end;
		end;
    end else
    begin
		Select @myvalue=COUNT(*) from SC_RA_Orders where sid=@sid and report_date=@NowDate and ischecked=0; --检测当日数据
		if @myvalue>0
		begin
		  set @returnCode=-1;
		  set @returnStr=CONVERT(nvarchar(20),@NowDate,23)+'日有'+CONVERT(nvarchar(20),@myvalue)+'条记录，账单未审核';
		end;
    end;
    
    
    
		
    
		
	
	Select @myvalue=COUNT(*) from (                                                                               
	Select Store_ID from View_Base_DDJData a                                                                  
	left join (select * from REP_DPHD where dphd_pjlxindex=1) b on a.Table_Index=b.dphd_fpindex               
	where a.Store_ID=@sid and CONVERT(date,a.invoiceDate) between DATEADD(day,-1,@NowDate) and DATEADD(day,-1,@NowDate) and b.Table_Index is null 
	union all                                                                                                 
	select fplr_sid from View_REP_FPLR a                                                                      
	left join (select * from REP_DPHD where dphd_pjlxindex=2) b on a.Table_Index=b.dphd_fpindex               
	where a.fplr_sid=@sid and a.fplr_fprq between DATEADD(day,-1,@NowDate) and DATEADD(day,-1,@NowDate) and b.Table_Index is null) t1
	if @myvalue>0 
	begin
	  set @returnCode=-3;
      set @returnStr=CONVERT(nvarchar(20),@NowDate,23)+'日有'+CONVERT(nvarchar(20),@myvalue)+'条记录，“电票核对”未处理';
	end;
	
	Select @myvalue=COUNT(*) from SC_Base_Table a                                     
	left join(select * from Base_Table where table_year=YEAR(@NowDate) and table_month=MONTH(@NowDate)) 
	b on a.sid=b.table_sid and a.table_name=b.table_name                              
	where a.visible=1 and a.sid=@sid and a.table_name in (select table_name from SC_RA_Orders where sid=@sid and report_date=@NowDate) 
	and b.Table_Index is null
	if @myvalue>0 
	begin
	  set @returnCode=-4;
      set @returnStr=CONVERT(nvarchar(20),@NowDate,23)+'日有'+CONVERT(nvarchar(20),@myvalue)+'个桌台，未设定达成率';
	end;
	
	Select @myvalue=COUNT(*) from SC_RA_Orders where sid=@sid and report_date=@NowDate and isyx=0 and ztlx='空'
	if @myvalue>0 
	begin
	  set @returnCode=-5;
      set @returnStr=CONVERT(nvarchar(20),@NowDate,23)+'日有'+CONVERT(nvarchar(20),@myvalue)+'条记录，桌台类型未维护';
	end;
	
	Select @myvalue=COUNT(*) from SC_RA_Orders where sid=@sid and report_date=@NowDate and canb_name=''
	if @myvalue>0 
	begin
	  set @returnCode=-6;
      set @returnStr=CONVERT(nvarchar(20),@NowDate,23)+'日有'+CONVERT(nvarchar(20),@myvalue)+'条记录，餐别为空';
	end;
	
	Select @myvalue=COUNT(*) from REP_JYYS where JYYS_StoreID=@sid and JYYS_Date=@NowDate
	if @myvalue=0 
	begin
	  set @returnCode=-7;
      set @returnStr=CONVERT(nvarchar(20),@NowDate,23)+'日经营预算未设定';
	end;
	
	Select @myvalue=COUNT(*) from REP_YJYYS where JYYS_StoreID=@sid and JYYS_Year=YEAR(@NowDate) and JYYS_Month=MONTH(@NowDate)
	if @myvalue=0 
	begin
	  set @returnCode=-8;
      set @returnStr=CONVERT(nvarchar(20),month(@NowDate))+'月经营预算未设定';
	end;
	
	Select @myvalue=COUNT(*) from REP_NJYYS where JYYS_StoreID=@sid and JYYS_Year=YEAR(@NowDate)
	if @myvalue=0 
	begin
	  set @returnCode=-9;
      set @returnStr=CONVERT(nvarchar(20),year(@NowDate))+'年经营预算未设定';
	end;
	
	Select @myvalue=COUNT(*) from REP_YPKYS where YPKYS_StoreID=@sid and YPKYS_Year=YEAR(@NowDate) and YPKYS_Month=MONTH(@NowDate)
	if @myvalue=0 
	begin
	  set @returnCode=-10;
      set @returnStr=CONVERT(nvarchar(20),month(@NowDate))+'月绩效预算未设定';
	end;
	
	
	select @returnCode returnCode,@returnStr returnStr
	
END

GO