# (* for all)
#...............................
GRACE_TABLE_ASSOCIATED = {
- 'artere': 'fourreau,sous_tubage,cable',
+ #'artere': 'fourreau,sous_tubage,cable',
+ #'noeud': 'chambre,local_technique,sites_emission,element_branchement_passif',
+ 'artere': 'fourreau',
'noeud': 'chambre,local_technique,sites_emission,element_branchement_passif'
}
+
+#GRACE_TABLE_SUB_ASSOCIATED = {
+# 'fourreau' : 'sous_tubage,cable',
+# 'sous_tubage' : 'cable'
+#}
+GRACE_TABLE_SUB_ASSOCIATED = {
+ 'fourreau' : {
+ 'list': 'sous_tubage,cable',
+ 'id_parent': 'id_four'
+ },
+ 'sous_tubage' : {
+ 'list': 'cable',
+ 'id_parent': 'id_st'
+ }
+}
+
# fields editable must befollowed by: *
# fields of type DATE must befollowed by: #DATE
GRACE_TABLE_INFOS = {
'select_col': 'id_cable,type_cable*,etat_cable*,long_cable*,diam_ext_cable*,diam_int_cable*,num_cable*,coul_cable*,techno_cable*,nbr_fibre_cable*,nbr_fibre_util_cable*,date_instal_cable,id_prop_cable*,id_gestion_cable*,id_util_cable*,prop_md_cable,qlte_geoloc_cable,source_geoloc_cable,date_maj_cable,source_maj_cable,id_four,id_st,id_ep_a,id_ep_b,commentaire_cable',
'date_maj_col' : 'date_maj_cable',
'source_maj_col' : 'source_maj_cable',
- 'label':'Câble'
+ 'label':'Câble'
},
'sous_tubage': {
'id_col': 'id_st',
'select_col': 'id_st,type_st*,etat_st*,num_st*,diam_ext_st*,diam_int_st*,coul_st*,occp_st*,date_instal_st,id_prop_st*,id_gestion_st*,id_util_st*,prop_md_st,qlte_geoloc_st,source_geoloc_st,date_maj_st,source_maj_st,commentaire_st,id_artere,id_four',
'date_maj_col' : 'date_maj_st',
'source_maj_col' : 'source_maj_st',
- 'label':'Sous tubage'
+ 'label':'Sous tubage'
},
'l49': {
'id_col': 'id_work',