Subversion Repositories Applications.papyrus

Rev

Rev 2103 | Rev 2108 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2103 Rev 2105
Line 70... Line 70...
70 
              FROM spip_articles WHERE statut = "publie"
 70 
              FROM spip_articles WHERE statut = "publie"
Line 71... Line 71...
71 
 
 71 
 
72 
#	sql_attr_uint		= id_article
 72 
#	sql_attr_uint		= id_article
73 
	sql_attr_timestamp	= date
 73 
	sql_attr_timestamp	= date
74 
	sql_attr_string		= lang
 74 
	sql_attr_string		= lang
75 
	sql_attr_string		= group_id
 75 
	sql_field_string	= group_id      # sql field pour permettre du filtrage @group_id != spip par exemple
Line 76... Line 76...
76 
	sql_attr_string		= main_id
 76 
	sql_attr_string		= main_id
Line 77... Line 77...
77 
 
 77 
 
Line 121... Line 121...
121 
               LEFT JOIN gen_menu_contenu mc  ON mc.gmc_ce_menu      = m.gm_id_menu \
 121 
               LEFT JOIN gen_menu_contenu mc  ON mc.gmc_ce_menu      = m.gm_id_menu \
122 
                                              AND mc.gmc_bool_dernier = 1 \
 122 
                                              AND mc.gmc_bool_dernier = 1 \
123 
               WHERE m.gm_date_fin_validite = '0000-00-00 00:00:00' OR LOWER(m.gm_date_fin_validite) < now()
 123 
               WHERE m.gm_date_fin_validite = '0000-00-00 00:00:00' OR LOWER(m.gm_date_fin_validite) < now()
Line 124... Line 124...
124 
 
 124 
 
125 
	sql_attr_timestamp	= gm_date_creation
 125 
	sql_attr_timestamp	= gm_date_creation
126 
	sql_attr_string		= group_id
 126 
	sql_field_string	= group_id
127 
	sql_attr_string		= main_id
 127 
	sql_attr_string		= main_id
Line 128... Line 128...
128 
}
 128 
}
129 
 
 129 
 
Line 152... Line 152...
152 
               "projet" AS group_id,    \
 152 
               "projet" AS group_id,    \
153 
               CONCAT("projet-", p_id) as main_id \
 153 
               CONCAT("projet-", p_id) as main_id \
154 
        FROM projet
 154 
        FROM projet
Line 155... Line 155...
155 
 
 155 
 
156 
	sql_attr_timestamp	= p_date_creation
 156 
	sql_attr_timestamp	= p_date_creation
157 
	sql_attr_string		= group_id
 157 
	sql_field_string	= group_id
158 
	sql_attr_string		= main_id
 158 
	sql_attr_string		= main_id
Line 159... Line 159...
159 
}
 159 
}
160 
 
 160 
 
Line 174... Line 174...
174 
        SELECT bf_id_fiche, bf_description AS texte, bf_titre AS titre, bf_date_debut_evenement, "bazar" AS group_id, \
 174 
        SELECT bf_id_fiche, bf_description AS texte, bf_titre AS titre, bf_date_debut_evenement, "bazar" AS group_id, \
175 
        CONCAT("bazar-", bf_id_fiche) as main_id \
 175 
        CONCAT("bazar-", bf_id_fiche) as main_id \
176 
        FROM bazar_fiche
 176 
        FROM bazar_fiche
Line 177... Line 177...
177 
 
 177 
 
178 
	sql_attr_timestamp	= bf_date_debut_evenement
 178 
	sql_attr_timestamp	= bf_date_debut_evenement
179 
	sql_attr_string		= group_id
 179 
	sql_field_string	= group_id
180 
	sql_attr_string		= main_id
 180 
	sql_attr_string		= main_id