-- Update x nuovi permessi (pagine About e UpdMan)
INSERT INTO [dbo].[Permessi]([COD_PERMESSO],[URL],[GRUPPO],[NUMERO],[NOME],[DESCRIZIONE])
VALUES ('Settings_UpdMan','UpdMan',4,5,'UpdMan','UpdManIcon')
INSERT INTO [dbo].[Permessi]([COD_PERMESSO],[URL],[GRUPPO],[NUMERO],[NOME],[DESCRIZIONE])
VALUES ('Settings_About','About',4,6,'About','AboutIcon')

INSERT INTO [dbo].[Permessi2Funzione] ([COD_PERMESSO],[COD_FUNZIONE],[READWRITE])
VALUES ('Settings_UpdMan','SuperAdmin','S')
INSERT INTO [dbo].[Permessi2Funzione] ([COD_PERMESSO],[COD_FUNZIONE],[READWRITE])
VALUES ('Settings_About','SuperAdmin','S')

-- vocabolario...
exec voc.stp_insNewLemma 'UpdMan','Update Manager'
exec voc.stp_insNewLemma 'About','About CMS-SC'

-- 2018.03.05 aggiunta nuovi step da vers 4233+
exec voc.stp_insNewLemma 'EnableDelDoss','Abilita Cancellazione'
exec voc.stp_insNewLemma 'EnableIfCompiled','(in presenza di record misure)'


-- 2018.03.05 aggiunta nuovi step da vers 4236+
exec voc.stp_insNewLemma 'FiltroSearchMatr','Filtro Ricerca Matricola (elenco)'

-- 2018.03.19 - update getDossier
/****** Object:  StoredProcedure [dbo].[stp_rep_getDossier]    Script Date: 19/03/2018 10:48:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Steamware
-- Create date: 2015.06.18
-- Description:	elenco records x dossier
-- =============================================
ALTER PROCEDURE [dbo].[stp_rep_getDossier]
(
     @IdxDossier	INT
    ,@Fase			NVARCHAR(50)
    ,@Rev			INT				= 0
    ,@Lingua		NVARCHAR(3)		= 'IT'
    ,@CodVisib		NVARCHAR(50)	='F'	
)
AS

SELECT	mi.IdxDossier, 
		mi.CodSchedaVersNum, 
		dbo.f_getStringLang(sc.Descrizione, @Lingua,0) AS DescrizioneScheda,
		mi.CodScheda, 
		mi.Vers, 
		mi.NumScheda, 
		mi.CodMisura, 
		mi.Fase, 
		mi.Rev, 
		mi.Operatore, 
		mi.DataOra, 
		mi.ValorePar, 
		mi.ValoreMis, 
		mi.OkValMis, 
		mi.CodDeroga, 
		dbo.f_getStringLang(mi.NomeMisura, @Lingua,0) AS NomeMisura,
		mi.TipoValMisura, 
		dbo.f_getStringLang(mi.NomePar, @Lingua,0) AS NomePar,
		mi.MinPar, 
		mi.MaxPar, 
		mi.LIVal, 
		mi.LSVal, 
		mi.CodVisib, 
		mi.Ordinale, 
		fa.Descrizione AS DescFase, 
		em.Cliente, 
		em.Matricola AS MatrMacchina, 
		em.Descrizione AS DescMacchina
FROM    v_Misure			AS mi INNER JOIN
        AnagFasi			AS fa ON mi.Fase = fa.Fase INNER JOIN
        ElencoDossier		AS do ON mi.IdxDossier = do.IdxDossier INNER JOIN
        ElencoMacchineCN	AS em ON do.Matricola = em.Matricola INNER JOIN
        AnagSchede			AS sc ON mi.CodScheda = sc.CodScheda AND mi.Vers = sc.Vers
WHERE	( mi.IdxDossier	= @IdxDossier	OR @IdxDossier = 0 )            -- mettere ISNULL su variabile x estrarre anche con NULL?
	AND ( mi.Fase		= @Fase			OR @Fase = '' )
	AND ( mi.Rev		= @Rev)
	AND ( mi.CodVisib	LIKE '%'+@CodVisib+'%' )
ORDER BY CodScheda, Vers, NumScheda, CodMisura, NomeMisura

/*
SELECT *
FROM dbo.v_Misure
WHERE   IdxDossier  = CASE WHEN @IdxDossier <> 0 THEN @IdxDossier ELSE IdxDossier END  -- così non estrae ev. IdxDossier nulli
    AND Fase        = CASE WHEN @Fase <> '' THEN @Fase ELSE Fase  END
ORDER BY	CodScheda, Vers, NumScheda, CodMisura, NomeMisura
*/
RETURN
GO



-- 2018.03.26 Aggiunta stored x setVisib

/****** Object:  StoredProcedure [dbo].[stp_Mis_SetVisib]    Script Date: 26/03/2018 15:38:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author:		S.E. Locatelli
-- Create date: 2018.03.26
-- Description:	Imposta lo stato visibile/non visibile (tipicamente FCS / X)
-- =============================================
CREATE PROCEDURE [dbo].[stp_Mis_SetVisib]
(
     @Original_IdxDossier	INT
	,@Original_CodScheda	NVARCHAR(50)
	,@Original_Vers			INT
	,@Original_NumScheda	INT
	,@Original_CodMisura	NVARCHAR(50)
	,@Original_Fase			NVARCHAR(50)
	,@Original_Rev			INT
	,@CodVisib				NVARCHAR(50)
)
AS


UPDATE	  Misure
SET		  CodVisib		= @CodVisib
WHERE	  IdxDossier	= @Original_IdxDossier
	AND	  CodScheda		= @Original_CodScheda
	AND	  Vers			= @Original_Vers
	AND	  NumScheda		= @Original_NumScheda
	AND	  CodMisura		= @Original_CodMisura
	AND	  Fase			= @Original_Fase
	AND	  Rev			= @Original_Rev

RETURN
GO