<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: print_docnum.inc.php,v 1.11 2019/04/03 13:34:40 ngantier Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) die("no access");

//gestion des droits
require_once($class_path."/acces.class.php");
require_once($class_path."/notice_affichage.class.php");
require_once($include_path."/etagere_func.inc.php");
require_once($class_path."/liste_lecture.class.php");

switch($sub){
	case 'get_list':	
		if($number && $select_noti){
			$id_notices = explode(",",$select_noti);
		} elseif(!empty($id_etagere)) {
			$id_notices = array_keys(get_etagere_notices($id_etagere));
		} elseif (!empty($id_liste)) {
		    $liste = new liste_lecture($id_liste*1);
		    $id_notices = $liste->notices;
		} else $id_notices=$_SESSION["cart"];
		ajax_http_send_response( doc_num_get_list($id_notices) );
		break;
}
function doc_num_get_list($id_notices){
	global $msg,$dbh, $gestion_acces_active,$gestion_acces_empr_notice,$gestion_acces_empr_docnum;
	$cpt_doc_num=0;
	foreach($id_notices as $notice_id){
		
		$query = "SELECT explnum_id from explnum where explnum_notice=$notice_id and explnum_mimetype IN ('application/pdf','application/x-pdf') ";
		$query .= " union ";
		$query .= " select explnum_id from explnum ,bulletins where explnum_bulletin=bulletin_id and num_notice=$notice_id and explnum_mimetype IN ('application/pdf','application/x-pdf')";
		$result = pmb_mysql_query($query,$dbh);
		$nb_result = pmb_mysql_num_rows($result) ;
		if (!$nb_result)	continue;		
		// pour tout les pdf de la notice
		while($row = pmb_mysql_fetch_object($result)){
			$explnum_id=$row->explnum_id;
			
			$res = pmb_mysql_query("SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_data, length(explnum_data) as taille,explnum_path, concat(repertoire_path,explnum_path,explnum_nomfichier) as path, repertoire_id FROM explnum left join upload_repertoire on repertoire_id=explnum_repertoire WHERE explnum_id = '$explnum_id' ", $dbh);
			$ligne = pmb_mysql_fetch_object($res);
					
			$id_for_rigths = $ligne->explnum_notice;
			if($ligne->explnum_bulletin != 0){
				//si bulletin, les droits sont rattachés à la notice du bulletin, à défaut du pério...
				$req = "select bulletin_notice,num_notice from bulletins where bulletin_id =".$ligne->explnum_bulletin;
				$res = pmb_mysql_query($req,$dbh);
				if(pmb_mysql_num_rows($res)){
					$r = pmb_mysql_fetch_object($res);
					$id_for_rigths = $r->num_notice;
					if(!$id_for_rigths){
						$id_for_rigths = $r->bulletin_notice;
					}
				}
			}
						
			//droits d'acces emprunteur/notice
			if ($gestion_acces_active==1 && $gestion_acces_empr_notice==1) {
				$ac= new acces();
				$dom_2= $ac->setDomain(2);
				$rights= $dom_2->getRights($_SESSION['id_empr_session'],$id_for_rigths);
			}
						
			//Accessibilité des documents numériques aux abonnés en opac
			$req_restriction_abo = "SELECT explnum_visible_opac, explnum_visible_opac_abon ,notice_id FROM notice_statut, explnum, notices WHERE explnum_notice=notice_id AND statut=id_notice_statut  AND explnum_id='$explnum_id' ";
			$res_restriction_abo=pmb_mysql_query($req_restriction_abo,$dbh);
			if(! pmb_mysql_num_rows($res_restriction_abo) ){// bulletin
				$req_restriction_abo="SELECT explnum_visible_opac, explnum_visible_opac_abon,notice_id
					FROM notice_statut, explnum, bulletins, notices
					WHERE explnum_bulletin = bulletin_id
					AND num_notice = notice_id
					AND statut = id_notice_statut
					AND explnum_id='$explnum_id' ";
				$res_restriction_abo=pmb_mysql_query($req_restriction_abo,$dbh);
			}			
			$expl_num=pmb_mysql_fetch_array($res_restriction_abo);
			
			//droits d'acces emprunteur/document numérique
			if ($gestion_acces_active==1 && $gestion_acces_empr_docnum==1) {
				$ac= new acces();
				$dom_3= $ac->setDomain(3);
				$docnum_rights= $dom_3->getRights($_SESSION['id_empr_session'],$explnum_id);
			}
			
			//Accessibilité (Consultation/Téléchargement) sur le document numérique aux abonnés en opac
			$req_restriction_docnum_abo = "SELECT explnum_download_opac, explnum_download_opac_abon FROM explnum,explnum_statut WHERE explnum_id='".$explnum_id."' AND explnum_docnum_statut=id_explnum_statut ";
			
			$result_docnum=pmb_mysql_query($req_restriction_docnum_abo);
			$docnum_expl_num=pmb_mysql_fetch_array($result_docnum,PMB_MYSQL_ASSOC);
			
			if( ($rights & 16 || (is_null($dom_2) && $expl_num["explnum_visible_opac"] && (!$expl_num["explnum_visible_opac_abon"] || ($expl_num["explnum_visible_opac_abon"] && $_SESSION["user_code"]))))
			&& ($docnum_rights & 8 || (is_null($dom_3) && $docnum_expl_num["explnum_download_opac"] && (!$docnum_expl_num["explnum_download_opac_abon"] || ($docnum_expl_num["explnum_download_opac_abon"] && $_SESSION["user_code"]))))){
				if (($ligne->explnum_data)||($ligne->explnum_path)) {
					$notice = new notice_affichage($expl_num["notice_id"], $liens_opac) ;
					$notice->do_header_without_html();
					$tpl.="<input id='doc_num_list_".$explnum_id."' type='checkbox' name='doc_num_list[]' value='".$explnum_id."'> ".$notice->notice_header_without_html." : ".$ligne->explnum_nom."<br />";
					$cpt_doc_num++;
				}
			}	
		}
	}
	if($cpt_doc_num){
		$tpl=" 		
		<br /><b>".$msg["print_output_docnum_list"]."</b>
		<input type='button' id='list_lecture_cart_checked_all' class='bouton' value=\"".$msg["list_docnum_checked_all"]."\" title=\"".$msg["list_docnum_checked_all"]."\" onClick=\"setCheckboxes('print_options', 'doc_num_list', true); return false;\" />		
		<input type='button' id='list_lecture_cart_checked_all' class='bouton' value=\"".$msg["list_docnum_unchecked_all"]."\" title=\"".$msg["list_docnum_unchecked_all"]."\" onClick=\"setCheckboxes('print_options', 'doc_num_list', false); return false;\" />
		<br />". $tpl;
	}else {
		$tpl="<b>".$msg["print_output_docnum_list_no_file"]."<br /></b>";
	}	
	return $tpl;
}