IF (Exists(select Table_name from SysTable where LCase(Table_name)=LCase('v_RegBaseServicesPeriod'))) THEN
  Drop view v_RegBaseServicesPeriod
END IF

GO

CREATE VIEW v_RegBaseServicesPeriod
(
  RegDate,
  GuestName,
  Account,
  RoomNo,
  Service,
  ServicesNum,
  ServiceSngPrice,
  AllSum,
  Dogovor,
  Plateni
)

AS SELECT
  RegDate=DateRegDt,
  GuestName=Guests."Name",
  Account=BK.Guest,
  RoomNo=BK.Room,
  Service='Нощувка и застраховка',
  ServicesNum=DateIntersection(bvrData1,bvrData2,DateRegDt,Days(DateRegDt,NumLodgings)),
  ServiceSngPrice=Currencies.ExchangeRate*BK.Price,
  AllSum=ServicesNum*ServiceSngPrice,
  Dogovor=Contracts.ShortName,
  // Plateni=null
  Plateni=BK.PayedLodgings * BK.Price
FROM "DBA".Book as BK,"dba".Guests,"DBA".Currencies,"DBA".Contracts
WHERE Guests.GuestNum=BK.Guest and Guests.Contract=Contracts.ContractNo
  and Contracts.GroupNo=any(select ShowType from "dba".GrContracts where GrNo=-1)
  and BK.KodCurrency=Currencies.KodCurrency
  and Guests.Status<>0 and ServicesNum<>0

// 04.August.2006 - Yanko - променено Plateni, за да се показва в Регистрирани услуги