"; $date_debut = ""; $date_fin = ""; $bulletins .= " "; if ($pmb_collstate_advanced) { $bulletins .= ""; } $bulletins .= " "; if ($pmb_collstate_advanced) { $bulletins .= ""; } $bulletins .=" "; $bulletins_to_check=array(); // ici : affichage par page des bulletinages associés // on lance la vraie requette $clause = ($location?"and (expl_bulletin=bulletin_id and expl_location='$location') ":"")." ".($serial_id ? "and bulletin_notice='$serial_id'" : "")." ".$clause; $myQuery = pmb_mysql_query("SELECT distinct bulletin_id FROM bulletins ".($location?",exemplaires ":"").(trim($clause) ? " WHERE 1 ".$clause : "")." $filter_date ORDER BY date_date DESC, bulletin_numero*1 DESC, bulletin_id DESC LIMIT $debut,$nb_per_page_a_search", $dbh); if((pmb_mysql_num_rows($myQuery))) { $parity=1; while(($bul = pmb_mysql_fetch_object($myQuery))) { $collstates = array(); if ($pmb_collstate_advanced) { $query = "SELECT collstate_bulletins_num_collstate, state_collections FROM collstate_bulletins JOIN collections_state ON collections_state.collstate_id = collstate_bulletins.collstate_bulletins_num_collstate WHERE collstate_bulletins_num_bulletin = '".$bul->bulletin_id."'"; $result = pmb_mysql_query($query); if (pmb_mysql_num_rows($result)) { while ($row = pmb_mysql_fetch_object($result)) { $collstates[$row->collstate_bulletins_num_collstate] = $row->state_collections; } } } $bulletin = new bulletinage($bul->bulletin_id,0,'',$location,false); if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $href_start=""; $tr_surbrillance = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" "; $bulletins .= ""; if ($pmb_collstate_advanced) { $bulletins .= ""; } $bulletins .= ""; $bulletins_to_check[]=$bulletin->bulletin_id; } $bulletins .= "

	".$msg[4025]."	".$msg[4026]."	".$msg['bulletin_mention_periode']."	".$msg['bulletin_mention_titre_court']."	".$msg['bul_articles']."	".$msg['bul_docnum']."	".$msg['bul_exemplaires']."	".$msg['bul_collstate']."
		".$msg["search_bull_start"]." ".$date_debut." ".$msg["search_bull_end"]." ".$date_fin."
"; $bulletins .= ""; global $base_path; $drag="bulletin_id."\" dragicon=\"".$base_path."/images/icone_drag_notice.png\" dragtext=\"".htmlentities($bulletin->bulletin_numero,ENT_QUOTES, $charset)."\" draggable=\"yes\" dragtype=\"notice\" callback_before=\"show_carts\" callback_after=\"\" style=\"padding-left:7px\">"; $bulletins .= "$drag	".$href_start; $bulletins .= $bulletin->bulletin_numero; $bulletins .= "	".$href_start; $bulletins .= $bulletin->aff_date_date; $bulletins .= "	".$href_start; $bulletins .= htmlentities($bulletin->mention_date, ENT_QUOTES, $charset); $bulletins .= "	".$href_start; $bulletins .= htmlentities($bulletin->bulletin_titre, ENT_QUOTES, $charset); $bulletins .= "	" ; if ($bulletin->nb_analysis) { $bulletins .= $bulletin->nb_analysis." bulletin_id."&what=DEP', 'cart', 600, 700, -2, -2, 'toolbar=no, dependent=yes, resizable=yes, scrollbars=yes')\">"; } else { $bulletins .= " "; } $bulletins .= "	".$href_start.""; if (sizeof($bulletin->nbexplnum)) { $bulletins .= $bulletin->nbexplnum; }else { $bulletins .= " "; } $bulletins .= "	".$href_start.""; if (sizeof($bulletin->expl)) { $bulletins .= sizeof($bulletin->expl); } else { $bulletins .= " "; } $bulletins .= "	"; $collstate_list = ""; foreach($collstates as $id => $collstate) { if($collstate_list) { $collstate_list.= " "; } $collstate_list .="".$collstate.""; } $bulletins .= $collstate_list."

"; } else { $bulletins .= "
"; if ($aff_bulletins_restrict_periode || $aff_bulletins_restrict_date || $aff_bulletins_restrict_numero) $bulletins .= $msg[perio_restrict_no_bulletin]; else $bulletins .= $msg[4024] ; } $bulletins .= ""; $bulletins = str_replace('!!bulletins_to_check!!', implode(',',$bulletins_to_check), $bulletins); // barre de navigation par page $pages_display = aff_pagination ($base_url."&location=$location&bull_date_start=$bull_date_start&bull_date_end=$bull_date_end", $nbr_lignes, $nb_per_page_a_search, $page, 10, false, true); ?>