IF (EXISTS(Select * from sys.systable where LCase(table_name) = LCase('v_RoomingListRestaurantArriving')))
THEN Drop view v_RoomingListRestaurantArriving
END IF

GO

create view
  DBA.v_RoomingListRestaurantArriving
  as select RestDate=GuestBoardPlans.PlanDate,
    --Maria
    --RoomNum=RP.RoomNo,
    RoomNum=R.RoomName,
    --Maria
    GuestName=Guests.Name,
    Elderly=if Guests.AdultType = 0 then 1 else 0 endif,
    Children=if Guests.AdultType > 0 then 1 else 0 endif,
    ArriveDate=(if RP.FromDateDt is null then Reserve.DateReserveDt else RP.FromDateDt endif),
    LeaveDate=(if RP.FromDateDt is null then Days(ArriveDate,Reserve.Days) else Days(ArriveDate,RP.NumDays) endif),
    BB=(if GuestBoardPlans.BoardPlan in( 4,5,6,7,8,9) then 1 else 0 endif),
    L=(if GuestBoardPlans.BoardPlan in( 2,3,6,7,8,9) then 1 else 0 endif),
    D=(if GuestBoardPlans.BoardPlan in( 1,3,5,6,7,9) then 1 else 0 endif),
    HB=(if GuestBoardPlans.BoardPlan in( 5,6) then BoardPlan.BoardPlanName else null endif),
    Board=BoardPlan.BoardPlanName,
    ReserveName=Reserve.Name,GStatus='Очакв.',
    TourOperator=(select FullName from dba.Contracts where ContractNo = Guests.Contract) from
	(((DBA.GuestBoardPlans join DBA.Guests on GuestBoardPlans.Guest = Guests.GuestNum)
	join DBA.BoardPlan on GuestBoardPlans.BoardPlan = BoardPlan.N)
	join Reserve on Guests.Reservation = Reserve.ReserveNo)
	left outer join (DBA.Rooms as R join DBA.ReservePlan as RP on RP.RoomNo = R.RoomNum) on  
	Guests.ReservePlanNo = RP.N
	where
    Reserve.Status = 1 and
    Guests.Reservation <> 0 and 
	Guests.Status = 0 and
    Reserve.DateReserveDt >= "Date"(Now(*)) 
--[v 01.01.02]
--[v 04.06.2003] Jorko    AdultType>0
--[v 15.08.2008] gnikolov - view-то е коригирано с join-ове