0) $clause.= " and num_classement='$id_classement' " ; if(!$nbr_lignes) { $requete = "SELECT COUNT(1) FROM bannettes $clause "; $res = mysql_query($requete, $dbh); $nbr_lignes = @mysql_result($res, 0, 0); } if (!$page) $page=1; $debut = ($page-1)*$nb_per_page; if($nbr_lignes) { // on lance la vraie requête $requete = "SELECT id_bannette, nom_bannette, comment_gestion FROM bannettes $clause ORDER BY nom_bannette, id_bannette LIMIT $debut,$nb_per_page "; $res = @mysql_query($requete, $dbh); $parity = 0; $ban_trouvees = mysql_num_rows($res) ; while(($bann=mysql_fetch_object($res))) { if ($parity % 2) $pair_impair = "even"; else $pair_impair = "odd"; $td_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./dsi.php?categ=bannettes&sub=pro&id_bannette=$bann->id_bannette&suite=acces&id_classement=$id_classement';\" "; $bann_list .= ""; $bann_list .= " ".htmlentities($bann->nom_bannette,ENT_QUOTES, $charset)."
(".htmlentities($bann->comment_gestion,ENT_QUOTES, $charset).") "; $bann_list .= " $msg[dsi_ban_affect_equation]
$msg[dsi_ban_affect_lecteurs] "; $bann_list .= ""; $parity += 1; } mysql_free_result($res); // affichage de la barre de navig $url_base = "$PHP_SELF?categ=bannettes&sub=pro&form_cb=".rawurlencode($form_cb)."&id_classement=$id_classement" ; $nav_bar = aff_pagination ($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true) ; $dsi_list_tmpl = str_replace("!!cle!!", $form_cb, $dsi_list_tmpl); $dsi_list_tmpl = str_replace("!!list!!", $bann_list, $dsi_list_tmpl); $dsi_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $dsi_list_tmpl); $dsi_list_tmpl = str_replace("!!message_trouve!!", $msg['dsi_ban_trouvees'], $dsi_list_tmpl); return $dsi_list_tmpl; } else return $msg['dsi_no_ban_found'] ; } function bannette_equation ($nom="", $id_bannette=0) { global $dsi_bannette_equation_assoce, $msg, $dbh, $id_classement ; global $charset ; if (!$id_classement) $id_classement=0; $url_base = "./dsi.php?categ=bannettes&sub=pro&id_bannette=$id_bannette&suite=affect_equation"; $url_modif = "./dsi.php?categ=bannettes&sub=pro&id_bannette=$id_bannette&suite=acces"; // $detail_bannette = "

$nom  

"; if ($id_classement>0) $requete = "select distinct id_equation, num_classement, nom_equation, comment_equation, proprio_equation from equations left join bannette_equation on num_equation=id_equation where proprio_equation=0 and num_classement='$id_classement' order by nom_equation " ; elseif ($id_classement==0) $requete = "select distinct id_equation, num_classement, nom_equation, comment_equation, proprio_equation from equations left join bannette_equation on num_equation=id_equation where proprio_equation=0 order by nom_equation " ; elseif ($id_classement==-1) $requete = "select distinct id_equation, num_classement, nom_equation, comment_equation, proprio_equation from equations, bannette_equation where num_bannette=$id_bannette and num_equation=id_equation and proprio_equation=0 order by nom_equation " ; $res = mysql_query($requete, $dbh) or die ($requete) ; $parity = 0; $equ_trouvees = mysql_num_rows($res) ; while ($equa=mysql_fetch_object($res)) { $equations .= "0) $requete = "select id_empr, empr_cb, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_mail from empr,empr_groupe where id_empr=empr_id and groupe_id='$id_groupe' and empr_nom like '$lect_query' $restrict_loc $restrict_mail order by nom_prenom, empr_cb $limit_nb" ; elseif ($id_groupe==0) $requete = "select id_empr, empr_cb, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_mail from empr where empr_nom like '$lect_query' $restrict_loc $restrict_mail order by nom_prenom, empr_cb $limit_nb " ; elseif ($id_groupe==-1) $requete = "select id_empr, empr_cb, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_mail from empr, bannette_abon where num_bannette='$id_bannette' and id_empr=num_empr and empr_nom like '$lect_query' $restrict_loc $restrict_mail order by nom_prenom, empr_cb $limit_nb" ; $res = mysql_query($requete, $dbh) or die ($requete) ; } else { if (!$id_categorie) $id_categorie = 0; $id_groupe=0; if ($id_categorie>0) $requete = "select id_empr, empr_cb, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_mail from empr where empr_categ='$id_categorie' and empr_nom like '$lect_query' $restrict_loc $restrict_mail order by nom_prenom, empr_cb $limit_nb" ; elseif ($id_categorie==0) $requete = "select id_empr, empr_cb, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_mail from empr where empr_nom like '$lect_query' $restrict_loc $restrict_mail order by nom_prenom, empr_cb $limit_nb " ; elseif ($id_categorie==-1) $requete = "select id_empr, empr_cb, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_mail from empr, bannette_abon where num_bannette='$id_bannette' and id_empr=num_empr and empr_nom like '$lect_query' $restrict_loc $restrict_mail order by nom_prenom, empr_cb $limit_nb" ; $res = mysql_query($requete, $dbh) or die ($requete) ; } $parity = 0; $lec_trouvees = mysql_num_rows($res) ; $lecteurs=""; if($lec_trouvees){ $lecteurs=""; while ($lec=mysql_fetch_object($res)) { $requete_affect = "SELECT * FROM bannette_abon where num_empr='$lec->id_empr' and num_bannette='$id_bannette' "; $res_affect = mysql_query($requete_affect, $dbh); $checked= ""; if (mysql_num_rows($res_affect)){ $abon=mysql_fetch_object($res_affect); $checked= "checked"; } $sel_mail=""; if ($lec->empr_mail){ $destinataires = explode(";",$lec->empr_mail) ; if(count($destinataires)>1){ $sel_mail=""; } } $lecteurs.=" "; } $lecteurs.="
".htmlentities($lec->nom_prenom,ENT_QUOTES, $charset)." ".htmlentities($lec->empr_mail,ENT_QUOTES, $charset)." ".$sel_mail."
"; } $dsi_bannette_lecteurs_assoce = str_replace("!!form_action!!", $url_base."&faire=enregistrer", $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!nom_bannette!!", $nom, $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!selected!!", $quoi, $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!lecteurs!!", $lecteurs, $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!id_bannette!!", $id_bannette, $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!lect_restrict!!", $lect_restrict, $dsi_bannette_lecteurs_assoce); if ($limit_nb) $dsi_bannette_lecteurs_assoce = str_replace("!!limitation!!", str_replace('!!nbres!!',$nb_limit,$msg[dsi_ban_abo_limit_abon]), $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!limitation!!", $msg[dsi_ban_abo_nolimit_abon], $dsi_bannette_lecteurs_assoce); $liste_localisations=gen_liste ("select 0 as idlocation, '".$msg['all_location']."' as libelle UNION select idlocation, location_libelle as libelle from docs_location order by libelle", "idlocation", "libelle", "empr_location_id", "this.form.faire.value=''; this.form.submit();", $empr_location_id, "", "","","",0); //if ($pmb_lecteurs_localises) $dsi_bannette_lecteurs_assoce = str_replace("!!restrict_location!!", docs_location::gen_combo_box_empr($empr_location_id), $dsi_bannette_lecteurs_assoce); if ($pmb_lecteurs_localises) $dsi_bannette_lecteurs_assoce = str_replace("!!restrict_location!!", $liste_localisations, $dsi_bannette_lecteurs_assoce); else $dsi_bannette_lecteurs_assoce = str_replace("!!restrict_location!!", "", $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!classement!!", gen_liste ("select 0 as id_categorie, '".addslashes($msg['dsi_all_categories'])."' as libelle UNION select id_categ_empr as id_categorie, libelle from empr_categ order by libelle", "id_categorie", "libelle", "id_categorie", "this.form.faire.value=''; this.form.quoi.value='categories'; this.form.submit();", $id_categorie, "", "",-1,$msg['dsi_ban_lecteurs_affectes'],0) , $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!groupe!!", gen_liste ("select 0 as id_groupe, '".addslashes($msg['dsi_all_groups'])."' as libelle_groupe UNION select groupe_id as id_groupe, libelle_groupe from empr_groupe, groupe where groupe_id=id_groupe order by libelle_groupe", "id_groupe", "libelle_groupe", "id_groupe", "this.form.faire.value=''; this.form.quoi.value='groups'; this.form.submit();", $id_groupe, "", "",-1,$msg['dsi_ban_lecteurs_affectes'],0) , $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace("!!mail_abon_checked!!", $mail_abon_checked, $dsi_bannette_lecteurs_assoce); // afin de revenir où on était : $form_cb, le critère de recherche global $form_cb ; $dsi_bannette_lecteurs_assoce = str_replace('!!form_cb!!', urlencode($form_cb), $dsi_bannette_lecteurs_assoce); $dsi_bannette_lecteurs_assoce = str_replace('!!form_cb_hidden!!', htmlentities($form_cb,ENT_QUOTES, $charset), $dsi_bannette_lecteurs_assoce); $detail_lecteurs .= $dsi_bannette_lecteurs_assoce ; return $detail_lecteurs ; } function dsi_list_bannettes_info($form_cb="", $id_bannette=0, $id_classement="") { global $dbh, $msg, $charset; global $page, $nbr_lignes; global $dsi_list_tmpl; // nombre de références par pages $nb_per_page = 10; if ($form_cb) { $form_cb_save = $form_cb ; $form_cb = str_replace("*", "%", $form_cb) ; $clause = "WHERE nom_bannette like '$form_cb%' and proprio_bannette=0 " ; } else { $form_cb_save = "*" ; $clause = "WHERE proprio_bannette=0 " ; } if ($id_classement===0) $clause.= " and num_classement=0 "; elseif ($id_classement>0) $clause.= " and num_classement='$id_classement' " ; if(!$nbr_lignes) { $requete = "SELECT COUNT(1) FROM bannettes $clause "; $res = mysql_query($requete, $dbh); $nbr_lignes = @mysql_result($res, 0, 0); } if (!$page) $page=1; $debut = ($page-1)*$nb_per_page; if($nbr_lignes) { // on lance la vraie requête $requete = "SELECT id_bannette FROM bannettes $clause ORDER BY nom_bannette, id_bannette LIMIT $debut,$nb_per_page "; $res = @mysql_query($requete, $dbh); $bann_list .= ""; $bann_list .= " ".htmlentities($msg[dsi_ban_form_nom],ENT_QUOTES, $charset)." (".htmlentities($msg[dsi_classement],ENT_QUOTES, $charset).")"; $bann_list .= " ".htmlentities($msg[dsi_ban_list_equ],ENT_QUOTES, $charset)." "; $bann_list .= " ".htmlentities($msg[dsi_ban_nb_notices],ENT_QUOTES, $charset)." "; $bann_list .= " ".htmlentities($msg[dsi_ban_nb_abonnes],ENT_QUOTES, $charset)." "; $bann_list .= " ".htmlentities($msg[dsi_ban_date_last_envoi],ENT_QUOTES, $charset)."
(".htmlentities($msg[dsi_ban_date_last_remp],ENT_QUOTES, $charset).") "; $bann_list .= ""; $parity = 0; $ban_trouvees = mysql_num_rows($res) ; while(($ban=mysql_fetch_object($res))) { $bann = new bannette($ban->id_bannette) ; if ($parity % 2) $pair_impair = "even"; else $pair_impair = "odd"; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" "; $bann_list .= ""; $td_javascript=" onmousedown=\"document.location='./dsi.php?categ=bannettes&sub=pro&id_bannette=$bann->id_bannette"; $td_javascript.="&suite=acces&id_classement=$id_classement"; $td_javascript.="&form_cb=".urlencode($form_cb_save); $td_javascript.="';\" "; $bann_list .= " ".htmlentities($bann->nom_bannette,ENT_QUOTES, $charset)." (".htmlentities($bann->nom_classement,ENT_QUOTES, $charset).")"; $requete = "select id_equation, num_classement, nom_equation, comment_equation, proprio_equation, num_bannette from equations, bannette_equation where num_equation=id_equation and proprio_equation=0 and num_bannette='$bann->id_bannette' order by nom_equation " ; $resequ = mysql_query($requete, $dbh) or die ($requete) ; $equ_trouvees = mysql_num_rows($resequ) ; $equations = "" ; while ($equa=mysql_fetch_object($resequ)) { $equations .= "
  • $equa->nom_equation
    • "; } $td_javascript=" onmousedown=\"document.location='./dsi.php?categ=bannettes&sub=pro&id_bannette=$bann->id_bannette&suite=affect_equation&id_classement=$id_classement&form_cb=".urlencode($form_cb_save)."';\" "; if($equ_trouvees == 0) $bann_list .= ""; else $bann_list .= ""; $bann_list .= "$bann->nb_notices"; $td_javascript=" onmousedown=\"document.location='./dsi.php?categ=bannettes&sub=pro&id_bannette=$bann->id_bannette&suite=affect_lecteurs&id_classement=$id_classement&form_cb=".urlencode($form_cb_save)."';\" "; if ($bann->num_panier) $aff_bann_fills_basket = "  "; else $aff_bann_fills_basket = ""; $bann_list .= "".$bann->nb_abonnes.$aff_bann_fills_basket.""; $td_javascript=" onmousedown=\"document.location='./dsi.php?categ=diffuser&sub=auto&id_bannette=$bann->id_bannette&id_classement=$id_classement&form_cb=".urlencode($form_cb_save)."';\" "; $bann_list .= " ".htmlentities($bann->aff_date_last_envoi,ENT_QUOTES, $charset).""; if ($bann->alert_diff) $bann_list .= "
    (".htmlentities($bann->aff_date_last_remplissage,ENT_QUOTES, $charset).")"; else $bann_list .= "
    (".htmlentities($bann->aff_date_last_remplissage,ENT_QUOTES, $charset).")" ; $bann_list .= ""; $bann_list .= ""; $parity += 1; } mysql_free_result($res); // affichage de la barre de navig $url_base = "$PHP_SELF?categ=bannettes&sub=pro&suite=search&form_cb=".rawurlencode($form_cb)."&id_classement=$id_classement" ; $nav_bar = aff_pagination ($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true) ; if ($nbr_lignes>0) $dsi_list_tmpl = str_replace("", "(".$nbr_lignes.")", $dsi_list_tmpl); $dsi_list_tmpl = str_replace("!!cle!!", $form_cb, $dsi_list_tmpl); $dsi_list_tmpl = str_replace("!!list!!", $bann_list, $dsi_list_tmpl); $dsi_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $dsi_list_tmpl); $dsi_list_tmpl = str_replace("!!message_trouve!!", $msg['dsi_ban_trouvees'], $dsi_list_tmpl); return $dsi_list_tmpl; } else return $msg['dsi_no_ban_found'] ; }