GO
/****** Object:  StoredProcedure [dbo].[sp_CustomerReceiptReport]    Script Date: 12-04-2025 11:44:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_CustomerReceiptReport]        
@FromDate datetime,        
@ToDate DATETIME,  
@CustomerCode VARCHAR(100),  
@PayMode VARCHAR(50), 
@attended VARCHAR(100) ,
@Flag VARCHAR(10)  ,
@BranchCode VARCHAR(100) 
AS   
begin        
IF @Flag ='F' 
SELECT distinct CustomerReceipt.VoucherNo,CustomerReceipt.PaidDate,CustomerReceipt.Narration,CustomerReceipt.PayMode,dbo.CustomerReceipt.ChequeNo,
dbo.CustomerReceipt.ChequeDate,CustomerReceipt.TotAmount AS TotAmount,CustomerReceipt.CustomerCode,CustomerReceipt.CustomerName,ISNULL(invoice.attended,'') as Salesman     
FROM  CustomerReceipt LEFT JOIN CustomerReceiptDetail ON CustomerReceipt.VoucherNo = CustomerReceiptDetail.VoucherNo left join invoice on invoice.invno=CustomerReceiptDetail.invoiceno 
and invoice.sr='sales' where CustomerReceipt.PaidDate between  @FromDate AND @ToDate AND ISNULL(CustomerReceipt.CustomerCode,'')=ISNULL(@CustomerCode,ISNULL(CustomerReceipt.CustomerCode,''))
and isnull(CustomerReceipt.deleted,'N')='N' and ISNULL(CustomerReceipt.PayMode,'')=ISNULL(@PayMode,ISNULL(CustomerReceipt.PayMode,''))  
AND (@BranchCode IS NULL OR @BranchCode = '' OR @BranchCode = '1' OR ISNULL(CustomerReceipt.BranchCode, '') = @BranchCode)
AND ISNULL(invoice.attended,'')=ISNULL(@attended,ISNULL(invoice.attended,''))
AND CustomerReceipt.TotAmount<>0
order by CustomerReceipt.voucherno 
ELSE IF @Flag ='T' 
SELECT distinct CustomerReceipt.VoucherNo,CustomerReceipt.PaidDate,CustomerReceipt.Narration,CustomerReceipt.PayMode,dbo.CustomerReceipt.ChequeNo,
dbo.CustomerReceipt.ChequeDate,CustomerReceipt.TotAmount AS TotAmount,CustomerReceipt.CustomerCode,CustomerReceipt.CustomerName,ISNULL(invoice.attended,'') as Salesman     
FROM  CustomerReceipt LEFT JOIN CustomerReceiptDetail ON CustomerReceipt.VoucherNo = CustomerReceiptDetail.VoucherNo left join invoice on invoice.invno=CustomerReceiptDetail.invoiceno 
and invoice.sr='sales' where CustomerReceipt.PaidDate between  @FromDate AND @ToDate  AND (@CustomerCode IS NULL OR @CustomerCode = '' OR ISNULL(CustomerReceipt.CustomerCode, '') = @CustomerCode)
 and isnull(CustomerReceipt.deleted,'N')='N' AND (@PayMode IS NULL OR @PayMode = '' OR @paymode = '5' OR ISNULL(CustomerReceipt.PayMode, '') = @PayMode)
AND (@attended IS NULL OR @attended = '' OR ISNULL(invoice.attended, '') = @attended)
AND (@BranchCode IS NULL OR @BranchCode = '' OR @BranchCode = '1' OR ISNULL(CustomerReceipt.BranchCode, '') = @BranchCode)
AND CustomerReceipt.TotAmount<>0
order by CustomerReceipt.voucherno 
select InvoiceNo as InvNo,PaidDate,InvoiceAmount,ReceivedAmount,VoucherNo from CustomerReceiptDetail where PaidDate between  @FromDate AND   @ToDate 
and isnull(deleted,'N')='N' order by voucherno
--SELECT distinct CustomerReceipt.VoucherNo,CustomerReceipt.PaidDate,CustomerReceipt.Narration,CustomerReceipt.PayMode,dbo.CustomerReceipt.ChequeNo,
--dbo.CustomerReceipt.ChequeDate,CustomerReceipt.TotAmount,CustomerReceipt.CustomerCode,CustomerReceipt.CustomerName     
--FROM  CustomerReceipt  AND (@attended IS NULL OR @attended = '' OR ISNULL(invoice.attended, '') = @attended)
--LEFT JOIN CustomerReceiptDetail ON CustomerReceipt.VoucherNo = CustomerReceiptDetail.VoucherNo                 
--where CustomerReceipt.PaidDate between  @FromDate AND   @ToDate   
--AND ISNULL(CustomerReceipt.CustomerCode,'')=ISNULL(@CustomerCode,CustomerReceipt.CustomerCode)
-- and isnull(CustomerReceipt.deleted,'N')='N'
--and ISNULL(CustomerReceipt.PayMode,'')=ISNULL(@PayMode,CustomerReceipt.PayMode)   
end