function diff_all_bannettes_full_auto()
{
global $dbh;
global $status_diffusion;
$status_diffusion = array();
$requete = "SELECT id_bannette, proprio_bannette FROM bannettes WHERE (DATE_ADD(date_last_envoi, INTERVAL periodicite DAY) <= sysdate()) and bannette_auto=1 ";
$res = pmb_mysql_query($requete, $dbh);
print "<table>";
while ($bann = pmb_mysql_fetch_object($res)) {
$bannette = new bannette($bann->id_bannette);
if (!$bannette->limite_type) {
$bannette->vider();
}
$bannette->remplir();
$bannette->purger();
print "<tr>";
print "<td>" . $bannette->nom_bannette . "</td>";
print "<td>" . $bannette->aff_date_last_envoi . "</td>";
print "<td>" . $bannette->diffuser() . "</td>";
print "</tr>";
}
print "</table>";
}
require_once "./dsi/func_clas.inc.php";
require_once "./dsi/func_equ.inc.php";
require_once "./dsi/func_diff.inc.php";
require_once "./dsi/func_rss.inc.php";
$action_diff_aff = "<h1>" . $msg[dsi_dif_auto_titre] . "</h1>";
// récupérer les bannettes à diffuser
$requete = "SELECT id_bannette, proprio_bannette FROM bannettes ";
$requete .= " WHERE (DATE_ADD(date_last_envoi, INTERVAL periodicite DAY) <= sysdate()) and bannette_auto=1 ";
$res = pmb_mysql_query($requete, $dbh);
while ($bann = pmb_mysql_fetch_object($res)) {
$liste_bannette[] = $bann->id_bannette;
}
pmb_mysql_free_result($res);
if (!$liste_bannette) {
$liste_bannette = array();
}
for ($i = 0; $i < sizeof($liste_bannette); $i++) {
$bannette = new bannette($liste_bannette[$i]);
$action_diff_aff .= $msg['dsi_dif_vidage'] . ": " . $bannette->nom_bannette . "<br />";
if (!$bannette->limite_type) {
$action_diff_aff .= $bannette->vider();
}
$action_diff_aff .= $msg['dsi_dif_remplissage'] . ": " . $bannette->nom_bannette;
$action_diff_aff .= $bannette->remplir();
$action_diff_aff .= $bannette->purger();
$action_diff_aff .= "<strong>" . $msg['dsi_dif_diffusion'] . ": " . $bannette->nom_bannette . "</strong><br />";
$action_diff_aff .= $bannette->diffuser();
}
print $action_diff_aff;
// deconnection MYSql
pmb_mysql_close($dbh);
mysql_query($rqt_bannette);
$id_bannette = mysql_insert_id();
$rqt_bannette_equation = "INSERT INTO bannette_equation (num_bannette, num_equation) VALUES ({$id_bannette}, {$id_equation})";
mysql_query($rqt_bannette_equation);
$rqt_bannette_abon = "INSERT INTO bannette_abon (num_bannette, num_empr, actif) VALUES ({$id_bannette}, {$id_empr}, 0)";
mysql_query($rqt_bannette_abon);
// bannette créée, on supprime le bouton des rech multicritères
$_SESSION['abon_cree_bannette_priv'] = 0;
print "<br />";
print pmb_bidi(str_replace("!!nom_bannette!!", stripslashes($nom_bannette), $msg['dsi_bannette_creer_resultat']));
print "<br /><br />";
// pour construction correcte du mail de diffusion
$liens_opac = array();
$bannette = new bannette($id_bannette);
$bannette->vider();
print pmb_bidi($bannette->remplir());
$bannette->diffuser($equ_human);
} else {
$s = new search();
$equ_human = $s->make_serialized_human_query($equation);
if ($opac_allow_bannette_export) {
$exp = start_export::get_exports();
$liste_exports = "<tr>\n\t\t\t\t\t\t<td align=right>" . $msg['dsi_ban_typeexport'] . "</td>\n\t\t\t\t\t\t<td><select name='typeexport'>";
$liste_exports .= "<option value='' selected>" . $msg[dsi_ban_noexport] . "</option>";
for ($i = 0; $i < count($exp); $i++) {
$liste_exports .= "<option value='" . $exp[$i]["PATH"] . "' >" . $exp[$i]["NAME"] . "</option>";
}
$liste_exports .= "</select></td>\n\t\t\t\t\t\t</tr>";
} else {
$liste_exports = "";
}
function fillBannette($id_bannette)
{
global $msg, $PMBusername;
if (SESSrights & DSI_AUTH) {
if (!$id_bannette) {
throw new Exception("Missing parameter: id_bannette");
}
$bannette = new bannette($id_bannette);
$action_diff_aff .= $msg['dsi_dif_remplissage'] . ": " . $bannette->nom_bannette;
$action_diff_aff .= $bannette->remplir();
return $action_diff_aff;
} else {
return sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
}
}
