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);
}
// récupérer les bannettes cochées
if (!$liste_bannette) {
$liste_bannette = array();
}
for ($iba = 0; $iba < sizeof($liste_bannette); $iba++) {
$bannette = new bannette($liste_bannette[$iba]);
switch ($suite) {
case "vider":
$action_diff_aff .= $msg['dsi_dif_vidage'] . ": " . $bannette->nom_bannette . "<br />";
$bannette->vider();
break;
case "remplir":
$action_diff_aff .= $msg['dsi_dif_remplissage'] . ": " . $bannette->nom_bannette;
$action_diff_aff .= $bannette->remplir();
$bannette->purger();
break;
case "diffuser":
$action_diff_aff .= "<strong>" . $msg['dsi_dif_diffusion'] . ": " . $bannette->nom_bannette . "</strong><br />";
$action_diff_aff .= $bannette->diffuser();
break;
case "visualiser":
$action_diff_aff .= "<h3>" . $msg['dsi_dif_ban_contenu'] . ": " . $bannette->nom_bannette . "</h3>";
$action_diff_aff .= $bannette->aff_contenu_bannette("./dsi.php?categ=diffuser&sub=auto", 0);
break;
case "full_auto":
$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;
function diffuseBannetteFullAuto($id_bannette)
{
global $msg, $dsi_auto, $PMBusername, $pmb_bdd_version;
if (SESSrights & DSI_AUTH) {
if (!$dsi_auto) {
$action_diff_aff .= "DSI Auto pas activée sur base {$database} (user={$PMBusername}) Version noyau: {$pmb_bdd_version} ";
// throw new Exception("DSI Auto pas activée sur base $database (user=$PMBusername) Version noyau: $pmb_bdd_version ");
return $action_diff_aff;
}
if (!$id_bannette) {
$action_diff_aff .= "Missing parameter: id_bannette";
// throw new Exception("Missing parameter: id_bannette");
return $action_diff_aff;
}
$bannette = new bannette($id_bannette);
$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();
return $action_diff_aff;
} else {
return sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
}
}
