Delete from Relations where RelationTable='Registered Services'

GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', '__OPTIONS__', 'Регистрирани услуги', '__OPTIONS__', 'Registered Services', '__OPTIONS__', 1, GetFreeNInRelations('Registered Services',null,null,5), '__OPTIONS__', '', '', 0, 0, '', '', '', '', 1, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'bvrData1', 'Регистрирани услуги', 'От дата', 'Registered Services', 'From Date', 2, GetFreeNInRelations('Registered Services',null,null,5), 'bvrData1', '', '', 0, 0, '1', '1', '', 'select bvrData1', 72, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'bvrData2', 'Регистрирани услуги', 'До дата', 'Registered Services', 'To Date', 2, GetFreeNInRelations('Registered Services',null,null,5), 'bvrData2', '', '', 0, 0, '1', '1', '', 'select bvrData2', 72, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'RegDate', 'Регистрирани услуги', 'Дата', 'Registered Services', 'Date', 2, GetFreeNInRelations('Registered Services',null,null,5), 'RegDate', '', '', 0, 1, '', '', '', '', 72, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'RealDateTime', 'Регистрирани услуги', 'Реални дата и час', 'Registered Services', 'RealDateTime', 0, GetFreeNInRelations('Registered Services',null,null,5), 'RealDateTime', '', '', 0, 1, '', '', '', '', 72, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('//v_RegAllServicesPeriod', 'Dogovor', 'Регистрирани услуги', 'Договор', 'Registered Services', 'Contract', 2, GetFreeNInRelations('Registered Services',null,null,5), 'Dogovor', '', '', 0, 0, '', '', 'SELECT ShortName FROM Contracts', '', 104, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'Account', 'Регистрирани услуги', 'Кл.номер', 'Registered Services', 'Client Number', 0, GetFreeNInRelations('Registered Services',null,null,5), 'Account', '', '', 0, 1, '', '', '', '', 60, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'GuestName', 'Регистрирани услуги', 'Име гост', 'Registered Services', 'Guest Name', 2, GetFreeNInRelations('Registered Services',null,null,5), 'GuestName', '', '', 0, 0, '', '', 'SELECT "Name" FROM Guests GROUP BY "Name"', '', 150, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'RoomNo', 'Регистрирани услуги', 'Стая No', 'Registered Services', 'Room #', 2, GetFreeNInRelations('Registered Services',null,null,5), 'RoomNo', '', '', 0, 0, '', '', 'select RoomName from Rooms where Status <> 1 and Status <> 3', '', 48, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'Service', 'Регистрирани услуги', 'Услуга', 'Registered Services', 'Service', 2, GetFreeNInRelations('Registered Services',null,null,5), 'Service', '', '', 0, 0, '', '', 'select ServiceName from Services union (select ''Нощувка и застраховка'')', '', 168, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'ServicesNum', 'Регистрирани услуги', 'Кол.', 'Registered Services', 'Quant.', 0, GetFreeNInRelations('Registered Services',null,null,5), 'SUM(ServicesNum)', 'Sum(qrData.Кол.)', '# ### ##0.####', 1, 0, '', '', '', '', 56, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'ServiceSngPrice', 'Регистрирани услуги', 'Ед.цена', 'Registered Services', 'Sng. Price', 0, GetFreeNInRelations('Registered Services',null,null,5), 'ServiceSngPrice', '', '# ### ##0.00', 1, 0, '', '', '', '', 72, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'AllSum', 'Регистрирани услуги', 'Сума', 'Registered Services', 'Total', 2, GetFreeNInRelations('Registered Services',null,null,5), 'Sum(AllSum)', 'Sum(qrData.Сума)', '# ### ##0.00', 1, 0, '', '', '', '', 72, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'Plateni', 'Регистрирани услуги', 'Платени', 'Registered Services', 'Paid', 2, GetFreeNInRelations('Registered Services',null,null,5), 'Sum(Plateni)', 'Sum(qrData.Платени)', '# ### ##0.00', 1, 0, '', '', '', '', 72, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'PayTypeStr', 'Регистрирани услуги', 'Начин на плащане', 'Registered Services', 'PayTypeStr', 2, GetFreeNInRelations('Registered Services',null,null,5), 'PayTypeStr', '', '', 1, 0, '', '', '', '', 90, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'Admin', 'Регистрирани услуги', 'Админ', 'Registered Services', 'Admin', 0, GetFreeNInRelations('Registered Services',null,null,5), 'Admin', '', '', 1, 0, '', '', 'SELECT ShortName FROM Admin', '', 80, '', 0, 0, 1, today())
 
GO
 
INSERT INTO Relations(TableName, ColName, BGTableName, BGColName, RelationTable, RelationCol, SelectCol, N, Function, Suma, Mask, Align, Sortirane, Zadaljitelna, Promenliva, FilterList, DftFilter, Shirina, Opisanie, DftLike, AutoStretch, Spravka, PoslData)
 VALUES('v_RegAllServicesPeriod', 'ServiceName', 'Регистрирани услуги', 'Име услуга', 'Registered Services', 'ServiceName', 0, GetFreeNInRelations('Registered Services',null,null,5), 'ServiceName', '', '', 0, 0, '', '', 'select ServiceName from Services', '', 100, '', 0, 0, 1, today())
  
GO

Call InsertPravaSpravki('Registered Services');

GO

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

GO

create view DBA.v_RegAllServicesPeriod
  as select v_RegServicesPeriod.RegDate,
    /*Maria +, 1728*/
    v_RegServicesPeriod.RealDateTime,
    /*Maria -*/
    v_RegServicesPeriod.GuestName,
    v_RegServicesPeriod.Account,
    v_RegServicesPeriod.RoomNo,
    v_RegServicesPeriod.Service,
    S.ServiceName,
    v_RegServicesPeriod.ServicesNum,
    ServiceSngPrice,
    v_RegServicesPeriod.AllSum,
    v_RegServicesPeriod.Plateni,
    Dogovor,
    v_RegServicesPeriod.Admin,
	v_RegServicesPeriod.PayTypeStr
    from DBA.v_RegServicesPeriod,DBA.Services as S
    where v_RegServicesPeriod.ServiceNo = S.ServiceNo
//[v 00.07.12]
//[v1 21.12.2007, Maria] - dobavena kolona, vzimat se realnata data i chas