Subversion Repositories Applications.papyrus

Rev

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

Rev 2076 Rev 2080
Line 129... Line 129...
129 
    $requete =  'SELECT * '.
 129 
    $requete =  'SELECT * '.
130 
                'FROM gen_site, gen_site_relation '.
 130 
                'FROM gen_site, gen_site_relation '.
131 
                'WHERE gs_code_alpha = "'.$code_alpha.'" '.
 131 
                'WHERE gs_code_alpha = "'.$code_alpha.'" '.
132 
                'AND gs_id_site = gsr_id_site_01 '.
 132 
                'AND gs_id_site = gsr_id_site_01 '.
133 
                'AND gsr_id_site_01 = gsr_id_site_02 '.
 133 
                'AND gsr_id_site_01 = gsr_id_site_02 '.
134 
                'AND gsr_id_valeur = 102 '; // 102 = site "principal"
 134 
                'AND gsr_id_valeur = 102 '. // 102 = site "principal"
- 
 
 135 
    			'AND gs_id_site NOT IN ('.// Nous tenons pas compte des sites traduits!
- 
 
 136 
    			'	SELECT gsr_id_site_02 '.
- 
 
 137 
    			'	FROM gen_site_relation '.
- 
 
 138 
    			'	WHERE gsr_id_site_01 != gsr_id_site_02 '.
- 
 
 139 
    			'		AND gsr_id_valeur = 1 )';
Line 135... Line 140...
135
140
136 
    $resultat = $objet_pear_db->query($requete);
 141 
    $resultat = $objet_pear_db->query($requete);
Line 137... Line 142...
137 
    (DB::isError($resultat)) ? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat->getMessage(), $requete)) : '';
 142 
    (DB::isError($resultat)) ? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat->getMessage(), $requete)) : '';