0) $clause.= " and num_classement='$id_classement' " ;
$requete = "SELECT COUNT(1) FROM bannettes $clause ";
$res = pmb_mysql_query($requete, $dbh);
$nbr_lignes = pmb_mysql_result($res, 0, 0);
if($nbr_lignes) {
$requete = "SELECT id_bannette, nom_bannette, date_last_remplissage, date_last_envoi, proprio_bannette, bannette_auto, nb_notices_diff FROM bannettes $clause ORDER BY nom_bannette, id_bannette ";
$res = pmb_mysql_query($requete, $dbh);
while ($row = pmb_mysql_fetch_assoc($res)) {
$result[] = array(
"id_bannette" => $row["id_bannette"],
"nom_bannette" => utf8_normalize($row["nom_bannette"]),
"date_last_remplissage" => $row["date_last_remplissage"],
"date_last_envoi" => $row["date_last_envoi"],
"proprio_bannette" => $row["proprio_bannette"],
"bannette_auto" => $row["bannette_auto"],
"nb_notices_diff" => $row["nb_notices_diff"],
);
}
}
return $result;
} else {
return array();
}
}
public function diffuseBannettesFullAuto($lst_bannettes) {
global $msg,$dsi_auto,$PMBusername, $pmb_bdd_version;
if (SESSrights & DSI_AUTH) {
if (!$dsi_auto)
throw new Exception("DSI Auto pas activée sur base $database (user=$PMBusername) Version noyau: $pmb_bdd_version ");
if (!$lst_bannettes)
throw new Exception("Missing parameter: lst_bannettes");
if (!$lst_bannettes) $lst_bannettes = array() ;
$action_diff_aff="";
$nb_bannettes = count($lst_bannettes);
for ($iba = 0; $iba < $nb_bannettes; $iba++) {
$bannette = new bannette($lst_bannettes[$iba]) ;
$action_diff_aff .= $msg['dsi_dif_vidage'].": ".$bannette->nom_bannette."
" ;
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 .= "".$msg['dsi_dif_diffusion'].": ".$bannette->nom_bannette."
" ;
$action_diff_aff .= $bannette->diffuser();
}
return $action_diff_aff;
} else {
return sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
}
}
public function diffuseBannetteFullAuto($id_bannette) {
global $msg,$dsi_auto,$PMBusername, $pmb_bdd_version;
if (SESSrights & DSI_AUTH) {
$action_diff_aff="";
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."
" ;
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 .= "".$msg['dsi_dif_diffusion'].": ".$bannette->nom_bannette."
" ;
$action_diff_aff .= $bannette->diffuser();
return $action_diff_aff;
} else {
return sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
}
}
public function flushBannette($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_vidage'].": ".$bannette->nom_bannette."
" ;
$action_diff_aff .= $bannette->vider();
return $action_diff_aff;
} else {
return sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
}
}
public 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);
}
}
public function diffuseBannette($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_diffusion'].": ".$bannette->nom_bannette."
" ;
$action_diff_aff .= $bannette->diffuser();
return $action_diff_aff;
} else {
return sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
}
}
public function exportBannette($id_bannette) {
global $msg, $PMBusername;
global $ourPDF;
if (SESSrights & DSI_AUTH) {
if (!$id_bannette)
throw new Exception("Missing parameter: id_bannette");
$bannette = new bannette($id_bannette) ;
$resultat_html = $bannette->get_display_export();
$ourPDF = new PDF_HTML();
$ourPDF->AddPage();
$ourPDF->SetFont('Arial');
$ourPDF->WriteHTML($resultat_html);
return $ourPDF;
} else {
return sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername);
}
}
}
?>