IF (EXISTS(Select * from sys.sysprocedure where LCase(proc_name) = LCase('SelectRoomByPBXNumber')))
THEN Drop procedure SelectRoomByPBXNumber
END IF

GO

create function DBA.SelectRoomByPBXNumber(in @PBXNumber integer)
--Maria
returns integer
//returns varchar(5)
--Maria
// Wrushta nomer na staia po zadaden nomer na telefon
begin
--Maria
  declare @RoomNo integer;
  //declare @RoomName varchar(5);
  select RoomNum into @RoomNo from Rooms where PBXNumber like string('%,',@PBXNumber,',%');
  //select RoomName into @RoomName from Rooms where PBXNumber like string('%,',@PBXNumber,',%');
  if @RoomNo is null then set @RoomNo=0
  //if @RoomName is null then set @RoomName=''
 --Maria
  end if;
--Maria 
  return @RoomNo
  //return @RoomName
 --Maria
end
//[v 00.05.28]
//[19.08.2008] - Maria - premahnati sa promenite, svurzani s RoomName

GO

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

GO

create view DBA.v_NotRegisterCalls
  as select cl.CallDate,cl.CallTime,cl.ExtLine,cl.IntLine,cl.DialNumber,cl.Duration,
    cl.Note,
    cl.N,
    cl.PulseCount,
    cl.CallPrice,
    cl.Account,
    cl.Notes,
    DBA.SelectRoomByPBXNumber(cl.IntLine) as RoomN,
    sc.PBXLogN as PBXLogN_ from dba.PBXCallsLog as cl left outer join
    dba.ServiceCredits as sc on sc.PBXLogn = cl.N where
    (PBXLogN_ is null) and(cl.CallDate between bvrData1 and bvrData2)
    
//[19.08.2008] - Maria - rezultatat na SelectRoomByPBXNumber da e RoomN, a ne RoomNum
    
GO

--справка "Нерегистрирани телефонни разговори"
IF (EXISTS(Select * from sys.systable where LCase(table_name) = LCase('v_TelTalksNotRegistered')))
THEN Drop view v_TelTalksNotRegistered
END IF

GO

create view
  DBA.v_TelTalksNotRegistered
  as select CallDate,CallTime,IntLine,ExtLine,DialNumber,Duration,PulseCount,CallPrice,RoomN,RoomNum=R.RoomName from
    dba.v_NotRegisterCalls left outer join Rooms R on v_NotRegisterCalls.RoomN=R.RoomNum where
--Maria
    RoomN <> 0 //Za da ne pokazva slujebnite
	//RoomNum <> '' //Za da ne pokazva slujebnite
--Maria
//[v 01.06.15]
//[v 10.10.2002]
//[v 19.08.2008] - poleto RoomNum e promeneno na RoomN (nomera na staiata) i e dobaveno pole RoomNum (imeto na staiata)