supports

--301667768

select count("Id") from "BillingRegister"."BillingRegisters" br
where "MonthId" = 4;

select * from "BillingRegister"."SalesRegisterDumps" srd;

select br."Id", br."EntryDate",
brd."Id" as brdet_id, brd."FileName", brt."Name" as type,
brd."StatusId"
from "BillingRegister"."BillingRegisters" br
join "BillingRegister"."Branches" b
	on b."Id" = br."BranchId"
join "BillingRegister"."BillingRegisterDetails" brd
	on brd."BillingRegisterId" = br."Id"
join "BillingRegister"."BillingRegisterTypes" brt
	on brd."BillingRegisterTypeId" = brt."Id"
where b."PAN" = :pan;

delete from "BillingRegister"."BillingRegisters"
where "Id" = :brdetid;


select * from "BillingRegister"."BillingRegisters" br
join "BillingRegister"."Branches" b
	on b."Id" = br."BranchId"
where b."PAN" = '303102975'

select * from "BillingRegister"."BillingRegisters" br
join "BillingRegister"."Branches" b
	on b."Id" = br."BranchId"
where b."PAN" = '300057896'
--'601178395'

select * from "BillingRegister"."BillingRegisters" br

delete from "BillingRegister"."SalesRegisters"
where "BRDetId" in (1216, 1215, 1516, 1517, 2005);

' 2078.04.01 '

delete from "BillingRegister"."BillingRegisters"
where "Id" = :brdetid;

select * from "BillingRegister"."SalesRegisters" sr
where "BRDetId" is null;


select * from "BillingRegister"."BillingRegisterDetails" brd
where "BillingRegisterTypeId" = 1 and "StatusId" = 4
and "Id" not in (select "BRDetId")

select * from "BillingRegister"."SalesRegisters" sr
where "BRDetId" = 4782

select count("Id") from "BillingRegister"."BillingRegisters" br
where "MonthId" = 4;



CREATE UNIQUE INDEX "IX_PurchaseRegisters_SellerPAN_FiscalYearId_InvoiceNo"
ON "BillingRegister"."PurchaseRegisters" ("SellerPAN", "FiscalYearId", "InvoiceNo");


select * from "BillingRegister"."PurchaseRegisters" pr
where "SellerPAN" = '609687677' and "InvoiceNo" = '78-79/000416';


select * from "BillingRegister"."BillingRegisterDetails" brd
where "Id" in ()



select * from "BillingRegister"."BillingRegisters" br where "BusinessPanNo" = '500166088'

select * from "BillingRegister"."BillingRegisterDetails" brd where "BillingRegisterId" = 4761;


select * from "BillingRegister"."BillingRegisterDetails" brd where "BillingRegisterId" = 1627;

select * from "BillingRegister"."SalesRegisterDumps" srd where "BillingRegisterDetailId" = 2555;

select * from "BillingRegister"."BillingRegisterDetails" brd where "Id" = 700

select * from "BillingRegister"."PurchaseRegisters" pr where "BRDetId" = 5952;

select * from "BillingRegister"."SalesRegisters" pr where "BRDetId" = 5951;

select * from "BillingRegister"."PurchaseRegisterDumps" prd where "BillingRegisterDetailId" = 5172;

select * from "BillingRegister"."SalesRegisterDumps" prd where "BillingRegisterDetailId" = 4074;

select "EntryDate" from "BillingRegister"."BillingRegisters" br
order by "EntryDate" desc limit 10;



select * from "BillingRegister"."SalesRegisters" sr where b


select * from "BillingRegister"."SalesRegisters" sr
where "BranchId" = 1;

select count(*) from "BillingRegister"."BillingRegisters" br
where "EntryDate"::varchar(10) = now()::varchar(10)


delete  from "BillingRegister"."BillingRegisters" where "Id" = 872;



select count(*)
from "BillingRegister"."BillingRegisterDetails" brd
where "BillingRegisterTypeId" = 1
and "StatusId" = 4
and "Id" not in (select "BRDetId" from "BillingRegister"."SalesRegisters" sr)


select * from "BillingRegister"."PurchaseRegisterDumps" prd