if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTarifasFleMay]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[paQryTarifasFleMay]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTarifasFleMay]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[paInsTarifasFleMay]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpTarifasFleMay]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[paUpTarifasFleMay]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTarifasFleMayLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[paQryTarifasFleMayLta]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTarifasFleMayLta] @pmIdAgencia VARCHAR(16)
 AS 
 SELECT A.IdClie AS NitClie,T.RazonSocial AS NomCliente,F.IdAgencia AS CdAgencia,Agencia,TipoTarifa,Numero
,F.TipoVehic AS CdTipoVeh,TV.TipoVehic AS TipoVeh,F.CapacMax AS CapMaxima,VrTarifa,TipoLiquida,F.Inactivo AS Inactvo
,NitEmpresa,E.RazonSocial AS NomEmpresa,TV.CapacMin AS Cap_Minimo,TV.CapacMax AS Cap_Maximo,FechaCrea,F.IdUsuario AS CdUsuario,Usuario
FROM TarifasFleMay AS F INNER JOIN adm_Usuarios AS U ON F.IdUsuario=U.IdUsuario INNER JOIN Agencias AS A ON F.IdAgencia=A.IdAgencia
INNER JOIN Terceros AS T ON A.IdClie=T.IdTercero LEFT JOIN TiposVehFletes AS TV ON F.TipoVehic=TV.Item 
LEFT JOIN Terceros AS E ON F.NitEmpresa=E.IdTercero
WHERE F.IdAgencia LIKE ISNULL(@pmIdAgencia,'%')



GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paInsTarifasFleMay] @pmIdAgencia VARCHAR(16),@pmTipoTarifa VARCHAR(10),@pmNumero INT,@pmNitEmpresa VARCHAR(16)
,@pmCapacMin DECIMAL(14,4),@pmCapacMax DECIMAL(14,4),@pmVrTarifa DECIMAL(14,4),@pmTipoLiquida VARCHAR(10),@pmDescTipoVeh VARCHAR(50)
,@pmInactivo BIT,@pmTipoVehic INT,@pmFechaCrea SMALLDATETIME,@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO TarifasFleMay (IdAgencia,TipoTarifa,Numero,TipoVehic,NitEmpresa,CapacMin,CapacMax,VrTarifa,TipoLiquida,DescTipoVeh,Inactivo,FechaCrea,IdUsuario)
 VALUES (@pmIdAgencia,@pmTipoTarifa,@pmNumero,@pmTipoVehic,@pmNitEmpresa,@pmCapacMin,@pmCapacMax,@pmVrTarifa,@pmTipoLiquida,@pmDescTipoVeh,@pmInactivo,@pmFechaCrea,@pmIdUsuario)


GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[paUpTarifasFleMay] @pmIdAgencia VARCHAR(16),@pmTipoTarifa VARCHAR(10),@pmNumero INT,@pmNitEmpresa VARCHAR(16),@pmCapacMin DECIMAL(14,4),@pmCapacMax DECIMAL(14,4),@pmVrTarifa DECIMAL(14,4)
,@pmTipoLiquida VARCHAR(10),@pmDescTipoVeh VARCHAR(50),@pmInactivo BIT,@pmTipoVehic INT
 AS 
 UPDATE TarifasFleMay SET NitEmpresa=@pmNitEmpresa,CapacMin=@pmCapacMin,CapacMax=@pmCapacMax,VrTarifa=@pmVrTarifa,TipoLiquida=@pmTipoLiquida,DescTipoVeh=@pmDescTipoVeh,Inactivo=@pmInactivo,TipoVehic=@pmTipoVehic
 WHERE IdAgencia=@pmIdAgencia AND TipoTarifa=@pmTipoTarifa AND Numero=@pmNumero



GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paQryTarifasFleMay] @pmIdAgencia VARCHAR(16),@pmTipoTarifa VARCHAR(10),@pmNumero INT
 AS 
 SELECT IdAgencia,TipoTarifa,Numero,TipoVehic,NitEmpresa,CapacMin,CapacMax,VrTarifa,TipoLiquida,DescTipoVeh,Inactivo,FechaCrea,IdUsuario
 FROM TarifasFleMay
 WHERE IdAgencia=@pmIdAgencia AND TipoTarifa=@pmTipoTarifa AND Numero=@pmNumero