case "gen_document":
$action_diff_aff .= "<script>openPopUp('./print_doc_dsi.php?id_bannette={$bannette->id_bannette}', 'Document DSI : {$bannette->id_bannette} ', 800, 600, -2, -2, 'toolbar=yes, dependent=yes, resizable=yes')</script>";
break;
}
}
switch ($suite) {
case "search":
case "vider":
case "remplir":
case "diffuser":
case "full_auto":
case "exporter":
case "gen_document":
print get_bannette_pro($msg[dsi_ban_search], $msg[dsi_ban_search_nom], './dsi.php?categ=diffuser&sub=manu', stripslashes($form_cb));
if ($action_diff_aff) {
print "<h1>" . $msg['dsi_dif_action_effectuee'] . " : </h1>" . $action_diff_aff;
}
print pmb_bidi(dif_list_bannettes($form_cb, $id_bannette, $id_classement, 0, "./dsi.php?categ=diffuser&sub=manu"));
break;
case "visualiser":
print get_bannette_pro($msg[dsi_ban_search], $msg[dsi_ban_search_nom], './dsi.php?categ=diffuser&sub=manu', stripslashes($form_cb));
if ($action_diff_aff) {
print $action_diff_aff;
}
break;
default:
echo window_title($database_window_title . $msg[dsi_dif_auto]);
print get_bannette_pro($msg[dsi_ban_search], $msg[dsi_ban_search_nom], './dsi.php?categ=diffuser&sub=manu', stripslashes($form_cb));
print pmb_bidi(dif_list_bannettes($form_cb, $id_bannette, $id_classement, 0, "./dsi.php?categ=diffuser&sub=manu"));
break;
}
$equ = "select id_empr, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_cb from empr where empr_categ='{$id_categorie}' {$restrict_loc} " . $lect_query;
}
if ($id_categorie == 0) {
$equ = "select id_empr, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_cb from empr where 1 {$restrict_loc} " . $lect_query;
}
if ($id_categorie == -1) {
$equ = "select id_empr, concat(empr_nom, ' ', empr_prenom) as nom_prenom, empr_cb from empr, bannette_abon where num_bannette='{$id_bannette}' and num_empr=id_empr {$restrict_loc} " . $lect_query;
}
}
$res = pmb_mysql_query($equ, $dbh) or die(pmb_mysql_error() . " {$equ} ");
if (!$bannette_abon) {
$bannette_abon = array();
}
while ($empr = pmb_mysql_fetch_object($res)) {
pmb_mysql_query("delete from bannette_abon where num_empr='{$empr->id_empr}' and num_bannette='{$id_bannette}'", $dbh);
$as = array_search($empr->id_empr, $bannette_abon);
$sel_mail = "sel_mail_" . $empr->id_empr;
if ($as !== false && $as !== null) {
pmb_mysql_query("insert into bannette_abon set num_empr='{$empr->id_empr}', num_bannette='{$id_bannette}', \n\t\t\t\t\t\tbannette_mail='" . ${$sel_mail} . "'", $dbh);
}
}
}
$bannette = new bannette($id_bannette);
print bannette_lecteur($bannette->nom_bannette, $id_bannette);
break;
default:
echo window_title($database_window_title . $msg[dsi_menu_title]);
print get_bannette_pro($msg[dsi_ban_search], $msg[dsi_ban_search_nom], './dsi.php?categ=bannettes&sub=pro', stripslashes($form_cb));
print pmb_bidi(dsi_list_bannettes_info($form_cb, $id_bannette, $id_classement));
break;
}