You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
49 lines
1.2 KiB
49 lines
1.2 KiB
-- 1/3 : Création de la table temporaire
|
|
DROP TABLE IF EXISTS w_dbsetup
|
|
;
|
|
|
|
CREATE TEMP TABLE w_dbsetup AS
|
|
SELECT
|
|
oid,
|
|
code,
|
|
texte,
|
|
is_cti,
|
|
is_essentiel
|
|
FROM rh.t_rapports
|
|
WHERE is_cti = '1'
|
|
ORDER BY code
|
|
LIMIT 0
|
|
;
|
|
|
|
-- 2/3 : Peuplement de la table temporaire
|
|
INSERT INTO w_dbsetup(
|
|
oid,
|
|
code,
|
|
texte,
|
|
is_cti,
|
|
is_essentiel
|
|
)
|
|
VALUES
|
|
(1, 'CTI_ESS_10', 'RH-Paie', '1', '1'),
|
|
(1, 'CTI_ESS_11', 'Rémunérations', '1', '1'),
|
|
(1, 'CTI_PF_AGG', 'CTI Portfolio', '1', '1'),
|
|
(1, 'CTI_QUA', 'Qualité des données', '1', '0'),
|
|
(1, 'RH1', 'Rapport personnalisé RH', '1', '0')
|
|
;
|
|
|
|
-- 3/3 : Màj de la table iCTI
|
|
UPDATE rh.t_rapports SET
|
|
texte = w_dbsetup.texte,
|
|
is_cti = w_dbsetup.is_cti,
|
|
is_essentiel = w_dbsetup.is_essentiel
|
|
FROM w_dbsetup
|
|
WHERE t_rapports.code = w_dbsetup.code
|
|
;
|
|
|
|
INSERT INTO rh.t_rapports(oid, code, texte, is_cti, is_essentiel)
|
|
SELECT oid, code, texte, is_cti, is_essentiel FROM w_dbsetup WHERE oid = 0 AND oid NOT IN (SELECT oid FROM rh.t_rapports)
|
|
;
|
|
|
|
INSERT INTO rh.t_rapports(code, texte, is_cti, is_essentiel)
|
|
SELECT code, texte, is_cti, is_essentiel FROM w_dbsetup WHERE oid <> 0 AND code NOT IN (SELECT code FROM rh.t_rapports)
|
|
;
|