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); } }