";
// affichage du tableau des statuts
$requete = "SELECT idstatut, statut_libelle, allow_loan, allow_loan_hist, allow_book, allow_opac, allow_dsi, allow_dsi_priv, allow_sugg, allow_dema, allow_prol, allow_avis, allow_tag , allow_pwd, allow_liste_lecture, allow_self_checkout, allow_self_checkin, allow_serialcirc FROM empr_statut ORDER BY statut_libelle ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity=1;
for($i=0;$i<$nbr;$i++) {
$row=mysql_fetch_object($res);
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./admin.php?categ=empr&sub=statut&action=modif&id=$row->idstatut';\" ";
if ($row->idstatut>2) print "| $row->statut_libelle | ";
else print "
| $row->statut_libelle | ";
if($row->allow_loan) print "X | ";
else print " | ";
if($row->allow_loan_hist) print "X | ";
else print " | ";
if($row->allow_book) print "X | ";
else print " | ";
if($row->allow_opac) print "X | ";
else print " | ";
if($row->allow_dsi) print "X | ";
else print " | ";
if($row->allow_dsi_priv) print "X | ";
else print " | ";
if($row->allow_sugg) print "X | ";
else print " | ";
if($row->allow_liste_lecture) print "X | ";
else print " | ";
if($row->allow_dema) print "X | ";
else print " | ";
if($row->allow_prol) print "X | ";
else print " | ";
if($row->allow_avis) print "X | ";
else print " | ";
if($row->allow_tag) print "X | ";
else print " | ";
if($row->allow_pwd) print "X | ";
else print " | ";
if($row->allow_self_checkout) print "X | ";
else print " | ";
if($row->allow_self_checkin) print "X | ";
else print " | ";
if($row->allow_serialcirc) print "X | ";
else print " | ";
print "
";
}
print "
";
}
function statut_form($statut_libelle="", $allow_loan=1, $allow_loan_hist=0, $allow_book=1, $allow_opac=1, $allow_dsi=1, $allow_dsi_priv=1, $allow_sugg=1, $allow_liste_lecture=1, $allow_dema=1, $allow_prol=1, $allow_avis=1, $allow_tag=1, $allow_pwd=1, $allow_self_checkout=0, $allow_self_checkin=0, $allow_serialcirc=0, $id=0) {
global $msg;
global $admin_empr_statut_form;
global $charset;
$admin_empr_statut_form = str_replace('!!id!!', $id, $admin_empr_statut_form);
if(!$id) $admin_empr_statut_form = str_replace('!!form_title!!', $msg[empr_statut_create], $admin_empr_statut_form);
else $admin_empr_statut_form = str_replace('!!form_title!!', $msg[empr_statut_modif], $admin_empr_statut_form);
$admin_empr_statut_form = str_replace('!!libelle!!', htmlentities($statut_libelle,ENT_QUOTES, $charset), $admin_empr_statut_form);
$admin_empr_statut_form = str_replace('!!libelle_suppr!!', addslashes($statut_libelle), $admin_empr_statut_form);
if ($allow_loan) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_loan!!', $checkbox, $admin_empr_statut_form);
if ($allow_loan_hist) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_loan_hist!!', $checkbox, $admin_empr_statut_form);
if ($allow_book) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_book!!', $checkbox, $admin_empr_statut_form);
if ($allow_opac) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_opac!!', $checkbox, $admin_empr_statut_form);
if ($allow_dsi) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_dsi!!', $checkbox, $admin_empr_statut_form);
if ($allow_dsi_priv) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_dsi_priv!!', $checkbox, $admin_empr_statut_form);
if ($allow_sugg) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_sugg!!', $checkbox, $admin_empr_statut_form);
if($allow_liste_lecture) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_liste_lecture!!', $checkbox, $admin_empr_statut_form);
if ($allow_dema) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_dema!!', $checkbox, $admin_empr_statut_form);
if ($allow_prol) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_prol!!', $checkbox, $admin_empr_statut_form);
if ($allow_avis) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_avis!!', $checkbox, $admin_empr_statut_form);
if ($allow_tag) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_tag!!', $checkbox, $admin_empr_statut_form);
if ($allow_pwd) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!checkbox_pwd!!', $checkbox, $admin_empr_statut_form);
if ($allow_self_checkout) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!allow_self_checkout!!', $checkbox, $admin_empr_statut_form);
if ($allow_self_checkin) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!allow_self_checkin!!', $checkbox, $admin_empr_statut_form);
if ($allow_serialcirc) $checkbox="checked"; else $checkbox="";
$admin_empr_statut_form = str_replace('!!allow_serialcirc!!', $checkbox, $admin_empr_statut_form);
print confirmation_delete("./admin.php?categ=empr&sub=statut&action=del&id=");
print $admin_empr_statut_form;
}
switch($action) {
case 'update':
// vérification validité des données fournies.
$requete = " SELECT count(1) FROM empr_statut WHERE (statut_libelle='$statut_libelle' AND idstatut!='$id' ) ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_result($res, 0, 0);
if ($nbr > 0) {
error_form_message($statut_libelle.$msg["empr_statut_label_already_used"]);
} else {
// O.K., now if item already exists UPDATE else INSERT
if($id) {
$requete = "UPDATE empr_statut SET statut_libelle='$statut_libelle', allow_loan='$allow_loan', allow_loan_hist='$allow_loan_hist', allow_book='$allow_book', allow_opac='$allow_opac', allow_dsi='$allow_dsi', allow_dsi_priv='$allow_dsi_priv', allow_sugg='$allow_sugg', allow_dema='$allow_dema', allow_prol='$allow_prol', allow_avis='$allow_avis', allow_tag='$allow_tag', allow_pwd='$allow_pwd', allow_liste_lecture='$allow_liste_lecture', allow_self_checkout='$allow_self_checkout', allow_self_checkin='$allow_self_checkin', allow_serialcirc='$allow_serialcirc' WHERE idstatut=$id ";
$res = mysql_query($requete, $dbh);
}else {
$requete = "INSERT INTO empr_statut set idstatut=0, statut_libelle='$statut_libelle', allow_loan='$allow_loan', allow_loan_hist='$allow_loan_hist', allow_book='$allow_book', allow_opac='$allow_opac', allow_dsi='$allow_dsi', allow_dsi_priv='$allow_dsi_priv', allow_sugg='$allow_sugg', allow_dema='$allow_dema', allow_prol='$allow_prol', allow_avis='$allow_avis', allow_tag='$allow_tag', allow_pwd='$allow_pwd', allow_liste_lecture='$allow_liste_lecture', allow_self_checkout='$allow_self_checkout', allow_self_checkin='$allow_self_checkin', allow_serialcirc='$allow_serialcirc' ";
$res = mysql_query($requete, $dbh);
}
}
show_statut($dbh);
break;
case 'add':
if (empty($form_libelle)) statut_form();
else show_statut($dbh);
break;
case 'modif':
if ($id){
$requete = "SELECT idstatut, statut_libelle, allow_loan, allow_loan_hist, allow_book, allow_opac, allow_dsi, allow_dsi_priv, allow_sugg, allow_liste_lecture, allow_dema, allow_prol, allow_avis, allow_tag, allow_pwd, allow_self_checkout, allow_self_checkin, allow_serialcirc FROM empr_statut WHERE idstatut=$id ";
$res = mysql_query($requete, $dbh);
if(mysql_num_rows($res)) {
$row=mysql_fetch_object($res);
statut_form($row->statut_libelle, $row->allow_loan, $row->allow_loan_hist, $row->allow_book, $row->allow_opac, $row->allow_dsi, $row->allow_dsi_priv, $row->allow_sugg, $row->allow_liste_lecture, $row->allow_dema, $row->allow_prol, $row->allow_avis, $row->allow_tag, $row->allow_pwd, $row->allow_self_checkout, $row->allow_self_checkin, $row->allow_serialcirc, $id);
} else {
show_statut($dbh);
}
} else {
show_statut($dbh);
}
break;
case 'del':
if ($id>2) {
$total = 0;
$total = mysql_result(mysql_query("select count(1) from empr where empr_statut ='".$id."' ", $dbh), 0, 0);
if ($total==0) {
$requete = "DELETE FROM empr_statut WHERE idstatut=$id ";
$res = mysql_query($requete, $dbh);
show_statut($dbh);
} else {
error_message( "", $msg['empr_statut_del_impossible'], 1, 'admin.php?categ=empr&sub=statut&action=');
}
} else {
error_message( "", $msg['empr_statut_del_1_2_impossible'], 1, 'admin.php?categ=empr&sub=statut&action=');
}
break;
default:
show_statut($dbh);
break;
}