";
$requete = "SELECT idsection, section_libelle, sdoc_codage_import, sdoc_owner, lender_libelle, section_visible_opac FROM docs_section left join lenders on sdoc_owner=idlender ORDER BY section_libelle";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity=1;
for($i=0;$i<$nbr;$i++) {
$row=mysql_fetch_object($res);
$rqtloc = "select location_libelle from docsloc_section, docs_location where num_section='$row->idsection' and idlocation=num_location order by location_libelle " ;
$resloc = mysql_query($rqtloc, $dbh);
$localisations=array();
while ($loc=mysql_fetch_object($resloc)) $localisations[]=$loc->location_libelle ;
$locaff = implode("
",$localisations) ;
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=docs&sub=section&action=modif&id=$row->idsection';\" ";
if ($row->sdoc_owner) print pmb_bidi("| $row->section_libelle | ");
else print pmb_bidi("
| $row->section_libelle | ");
if ($row->section_visible_opac) $visible="X" ;
else $visible=" " ;
print "$visible | " ;
print "$locaff | " ;
print pmb_bidi("$row->lender_libelle | ") ;
print pmb_bidi("$row->sdoc_codage_import |
");
}
print "
";
}
function section_form($libelle="", $sdoc_codage_import="", $sdoc_owner=0, $id=0, $section_pic="", $section_visible_opac=1, $num_locations=array()) {
global $msg;
global $admin_section_form;
global $charset;
$admin_section_form = str_replace('!!id!!', $id, $admin_section_form);
if(!$id) $admin_section_form = str_replace('!!form_title!!', $msg[110], $admin_section_form);
else $admin_section_form = str_replace('!!form_title!!', $msg[111], $admin_section_form);
$admin_section_form = str_replace('!!libelle!!', htmlentities($libelle,ENT_QUOTES, $charset), $admin_section_form);
$admin_section_form = str_replace('!!libelle_suppr!!', addslashes($libelle), $admin_section_form);
$admin_section_form = str_replace('!!section_pic!!', htmlentities($section_pic,ENT_QUOTES, $charset), $admin_section_form);
if($section_visible_opac) $checkbox="checked"; else $checkbox="";
$admin_section_form = str_replace('!!checkbox!!', $checkbox, $admin_section_form);
$admin_section_form = str_replace('!!sdoc_codage_import!!', $sdoc_codage_import, $admin_section_form);
$combo_lender= gen_liste ("select idlender, lender_libelle from lenders order by lender_libelle ", "idlender", "lender_libelle", "form_sdoc_owner", "", $sdoc_owner, 0, $msg[556],0,$msg["proprio_generique_biblio"]) ;
$admin_section_form = str_replace('!!lender!!', $combo_lender, $admin_section_form);
$localisations="";
$requete = "SELECT idlocation, location_libelle FROM docs_location ORDER BY location_libelle";
$res = mysql_query($requete) ;
if (!$num_locations) $num_locations=array();
while ($obj=mysql_fetch_object($res)) {
$as=array_search($obj->idlocation,$num_locations);
if (($as!==null)&&($as!==false)) $localisations.="
";
else $localisations.="
";
}
$admin_section_form = str_replace('!!num_locations!!', $localisations, $admin_section_form);
print confirmation_delete("./admin.php?categ=docs&sub=section&action=del&id=");
print $admin_section_form;
}
switch($action) {
case 'update':
// vérification validité des données fournies.
$requete = " SELECT count(1) FROM docs_section WHERE (section_libelle='$form_libelle' AND idsection!='$id' ) LIMIT 1 ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_result($res, 0, 0);
if ($nbr > 0) {
error_form_message($form_libelle.$msg["docs_label_already_used"]);
}else{
// O.K. if item already exists UPDATE else INSERT
if ($id) {
$requete = "UPDATE docs_section SET section_libelle='$form_libelle', sdoc_codage_import='$form_sdoc_codage_import', sdoc_owner='$form_sdoc_owner', section_pic='$form_section_pic', section_visible_opac='$form_section_visible_opac' WHERE idsection=$id ";
$res = mysql_query($requete, $dbh);
}else{
$requete = "INSERT INTO docs_section (idsection,section_libelle,sdoc_codage_import,sdoc_owner,section_pic, section_visible_opac) VALUES ('', '$form_libelle','$form_sdoc_codage_import','$form_sdoc_owner', '$form_section_pic', '$form_section_visible_opac') ";
$res = mysql_query($requete, $dbh);
$id = mysql_insert_id();
}
if (!$num_locations) $num_locations=array();
$requete="SELECT num_location FROM docsloc_section WHERE num_section='".$id."'";
$res=mysql_query($requete, $dbh);
if(mysql_num_rows($res)){
while ($ligne=mysql_fetch_object($res)) {
if(array_search($ligne->num_location,$num_locations) !== false){
//Si l'ancienne loc est toujours dans les nouvelles je n'y touche pas
unset($num_locations[array_search($ligne->num_location,$num_locations)]);
}else{
//Si l'ancienne n'est pas dans les nouvelles loc je la supprime
$requete = "delete from docsloc_section where num_section='$id' and num_location='".$ligne->num_location."' ";
mysql_query($requete, $dbh);
}
}
}
//Si il y a des nouvelles loc pour la section je les créer
foreach ( $num_locations as $value ) {
$requete = "INSERT INTO docsloc_section (num_section,num_location) VALUES ('$id', '".$value."') ";
mysql_query($requete, $dbh);
}
/*avant
$requete = "delete from docsloc_section where num_section='$id' ";
$res = mysql_query($requete, $dbh);
for ($i=0 ; $i < count($num_locations); $i++) {
$requete = "INSERT INTO docsloc_section (num_section,num_location) VALUES ('$id', '".$num_locations[$i]."') ";
$res = mysql_query($requete, $dbh);
}*/
}
show_section($dbh);
break;
case 'add':
if(empty($form_libelle) && empty($form_pret)) section_form();
else show_section($dbh);
break;
case 'modif':
if($id){
$requete = "SELECT section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac FROM docs_section WHERE idsection=$id LIMIT 1 ";
$res = mysql_query($requete, $dbh);
if(mysql_num_rows($res)) {
$row=mysql_fetch_object($res);
$rqtloc = "select num_location from docsloc_section where num_section='$id' " ;
$resloc = mysql_query($rqtloc, $dbh);
while ($loc=mysql_fetch_object($resloc)) $num_locations[]=$loc->num_location ;
section_form($row->section_libelle, $row->sdoc_codage_import, $row->sdoc_owner, $id, $row->section_pic, $row->section_visible_opac, $num_locations );
} else {
show_section($dbh);
}
} else {
show_section($dbh);
}
break;
case 'del':
if($id) {
$total=0;
$total = mysql_result(mysql_query("select count(1) from exemplaires where expl_section ='".$id."' ", $dbh), 0, 0);
if ($total==0) {
$compt=mysql_num_rows(mysql_query("select userid from users where deflt_docs_section='$id'"));
if ($compt==0) {
$total = mysql_result(mysql_query("select count(1) from abts_abts where section_id ='".$id."' ", $dbh), 0, 0);
if ($total==0) {
$requete = "DELETE FROM docs_section WHERE idsection=$id ";
$res = mysql_query($requete, $dbh);
$requete = "delete from docsloc_section where num_section='$id' ";
$res = mysql_query($requete, $dbh);
show_section($dbh);
}else {
error_message( $msg[294], $msg["section_used_abts"], 1, 'admin.php?categ=docs&sub=section&action=');
}
} else {
error_message( $msg[294], $msg[section_used_users], 1, 'admin.php?categ=docs&sub=section&action=');
}
} else {
error_message( $msg[294], $msg[1702], 1, 'admin.php?categ=docs&sub=section&action=');
}
} else show_section($dbh);
break;
default:
show_section($dbh);
break;
}