Samuele E. Locatelli
138 lines
4.1 KiB
Transact-SQL
138 lines
4.1 KiB
Transact-SQL
-- 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
|
|
|