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