GP > Documentation > Passage de la version 10.02 à 10.03
Passage de la version 10.02 à 10.03
vendredi 23 mars 2012, par
update gp_cods set num_ord=num_ord+1 where num_ord> 5 and codpar='TLOGT';
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('TLOGT','T6','','T6','O',6,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));Il s’agit ensuite de créer une colonne dans le GP_HLOCA permettant de distinguer les logements individuels des logements collectifs.
ALTER TABLE GP_HLOCA ADD C_TYPLOGT VARCHAR2(8);Puis, pour les lignes déjà existantes, il faut renseigner la nouvelle colonne
update GP_HLOCA set C_TYPLOGT='MIX';
update GP_HLOCA set C_TYPLOGT='IND' where exists( select * from RA_OPER where RA_OPER.num_oper=GP_HLOCA.num_oper and RA_OPER.C_TYPLOGT='IND');
update GP_HLOCA set C_TYPLOGT='COL' where exists( select * from RA_OPER where RA_OPER.num_oper=GP_HLOCA.num_oper and RA_OPER.C_TYPLOGT='COL');De nouveaux boutons sont été ajoutés, il faut définir leur droit d’accès dans la table GP_HABIL
alter table GP_HABIL modify (nom_champ VARCHAR2(25));
commit();
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ ='BT_AJOUTE');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ ='BT_SUPPRIME');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ ='BT_TOTHLOCA');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ like 'SU_%');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ like 'SH_%');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ like 'SA_%');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ = 'BEGUINAGE');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat(nom_champ,'_IND'),c_statut,attrib,sysdate,'GLESCAUTM' from GP_HABIL where nom_champ = 'MNT_LOYMAX');
INSERT INTO GP_HABIL (c_profil,c_fenet,nom_champ,c_statut,attrib,dat_maj,qui_maj) (select c_profil,c_fenet,concat('TAB_HLOCA.',nom_champ),c_statut,concat(substr(attrib,0,2),'6HLOCA'),sysdate,'GLESCAUTM' from GP_HABIL where nom_champ like 'HLC_%');
UPDATE GP_HABIL set nom_champ = concat('TAB_HLOCA_IND.',nom_champ),dat_maj=sysdate,qui_maj='GLESCAUTM' where nom_champ like 'HLC_%';
delete from gp_habil where nom_champ = 'NB_LOG';Enfin, il faut ajouter l’export du tableau TAB_HLOCA_IND dans le classeur Excel
ALTER TABLE GP_BD_EX ADD ONGLET VARCHAR2(20);
update GP_BD_EX set onglet='GP IMPORT';
update GP_BD_EX set onglet='GP IMPORTLocColl' where type='I' and nom_champ='TAB_HLOCA';
INSERT INTO GP_BD_EX(ONGLET,NOM_CHAMP,LIEN_LIGEX,LIEN_COLEX,DAT_MAJ,QUI_MAJ,TYPE) VALUES ('GP IMPORT','TAB_HLOCA_IND',272,2,sysdate,'GLESCAUTM','I');
update GP_BD_EX set nom_champ ='TN_TOT' where nom_champ like 'NB_LOG';