.-.-.-.-.-

<?php

/*
 * Squelette : plugins/auto/zpip/inclure/documents.html
 * Date :      Tue, 29 Mar 2011 12:00:06 GMT
 * Compile :   Sat, 20 Dec 2014 21:50:20 GMT
 * Boucles :   _documents_portfolio, _documents_joints
 */

/* BOUCLE documents  */

function BOUCLE_documents_portfoliohtml_d5118570b76b1c00ff0175ca79ef597c(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $connect = '';
	$in = array();
	if (!(is_array($a = ($Pile[0]['id_article']))))
		$in[]= $a;
	else $in = array_merge($in, $a);
	$in1 = array();
	if (!(is_array($a = ($Pile[0]['id_rubrique']))))
		$in1[]= $a;
	else $in1 = array_merge($in1, $a);
	$in2 = array();
	$in2[]= 'png';
	$in2[]= 'jpg';
	$in2[]= 'gif';
	static $table = 'documents';
	static $id = '_documents_portfolio';
	static $from = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_documents_liens','L3' => 'spip_types_documents');
	static $type = array();
	static $groupby = array("documents.id_document");
	static $select = array("0+documents.titre AS num",
		"documents.date",
		"documents.id_document",
		"L3.mime_type",
		"documents.titre",
		"documents.fichier");
	static $orderby = array('num', 'documents.date');
	$where = 
			array('((documents.statut = "publie"))', 
			array('<', 'documents.date_publication', sql_quote(quete_date_postdates())), 
			array('(documents.taille > 0 OR documents.distant=\'oui\')'), (!$Pile[0]['id_article'] ? '' : ((is_array($Pile[0]['id_article'])) ? sql_in('L1.id_objet',sql_quote($in)) : 
			array('=', 'L1.id_objet', sql_quote($Pile[0]['id_article'])))), (!$Pile[0]['id_article'] ? '' : 
			array('=', 'L1.objet', sql_quote('article'))), (!$Pile[0]['id_rubrique'] ? '' : ((is_array($Pile[0]['id_rubrique'])) ? sql_in('L2.id_objet',sql_quote($in1)) : 
			array('=', 'L2.id_objet', sql_quote($Pile[0]['id_rubrique'])))), (!$Pile[0]['id_rubrique'] ? '' : 
			array('=', 'L2.objet', sql_quote('rubrique'))), 
			array('=', 'documents.mode', "'document'"), sql_in('documents.extension',sql_quote($in2)), 
			array('=', 'L1.vu', "'non'"));
	static $join = array('L1' => array('documents','id_document'), 'L2' => array('documents','id_document'), 'L3' => array('documents','extension'));
	static $limit = '';
	static $having = 
			array();
	$t0 = "";
	// REQUETE
	$result = calculer_select($select, $from, $type, $where, $join, $groupby, $orderby, $limit, $having, $table, $id, $connect,
		 array('plugins/auto/zpip/inclure/documents.html','html_d5118570b76b1c00ff0175ca79ef597c','_documents_portfolio',2,$GLOBALS['spip_lang']));
	if ($result) {
	$SP++;
	// RESULTATS
	while ($Pile[$SP] = @sql_fetch($result)) {

$t0 .= (($t1 = strval(vider_url(urlencode_1738(generer_url_entite($Pile[$SP]['id_document'], 'document', '', '', true)))))!=='' ?
		('
	<a href="' . $t1 . (	'"
		 type="' .
	interdire_scripts($Pile[$SP]['mime_type']) .
	'"
		 rel="documents_portfolio' .
	(($t2 = strval(@$Pile[0]['id_article']))!=='' ?
			('-a' . $t2) :
			'') .
	(($t2 = strval(@$Pile[0]['id_rubrique']))!=='' ?
			('-r' . $t2) :
			'') .
	'"
	' .
	(($t2 = strval(interdire_scripts(couper(attribut_html(typo(supprimer_numero($Pile[$SP]['titre']),"TYPO",$connect)),'80'))))!=='' ?
			(' title="' . $t2 . '"') :
			'') .
	'>' .
	interdire_scripts(inserer_attribut(inserer_attribut(filtrer('image_graver', filtrer('image_reduire',get_spip_doc($Pile[$SP]['fichier']),'0','100')),'class','spip_logos'),'alt',interdire_scripts(couper(attribut_html(typo(supprimer_numero($Pile[$SP]['titre']),"TYPO",$connect)),'80')))) .
	'</a>
	')) :
		'');
	}
	@sql_free($result);
	}
	return $t0;
}

/* BOUCLE documents  */

function BOUCLE_documents_jointshtml_d5118570b76b1c00ff0175ca79ef597c(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $connect = '';
	$in = array();
	if (!(is_array($a = ($Pile[0]['id_article']))))
		$in[]= $a;
	else $in = array_merge($in, $a);
	$in1 = array();
	if (!(is_array($a = ($Pile[0]['id_rubrique']))))
		$in1[]= $a;
	else $in1 = array_merge($in1, $a);
	$in2 = array();
	$in2[]= 'gif';
	$in2[]= 'jpg';
	$in2[]= 'png';
	static $table = 'documents';
	static $id = '_documents_joints';
	static $from = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_documents_liens','L3' => 'spip_types_documents');
	static $type = array();
	static $groupby = array("documents.id_document");
	static $select = array("0+documents.titre AS num",
		"documents.date",
		"documents.id_document",
		"L3.mime_type",
		"documents.titre",
		"L3.titre AS type_document",
		"documents.taille",
		"documents.descriptif");
	static $orderby = array('num', 'documents.date');
	$where = 
			array('((documents.statut = "publie"))', 
			array('<', 'documents.date_publication', sql_quote(quete_date_postdates())), 
			array('IN', 'documents.mode', '(\'image\',\'document\')'), 
			array('(documents.taille > 0 OR documents.distant=\'oui\')'), (!$Pile[0]['id_article'] ? '' : ((is_array($Pile[0]['id_article'])) ? sql_in('L1.id_objet',sql_quote($in)) : 
			array('=', 'L1.id_objet', sql_quote($Pile[0]['id_article'])))), (!$Pile[0]['id_article'] ? '' : 
			array('=', 'L1.objet', sql_quote('article'))), (!$Pile[0]['id_rubrique'] ? '' : ((is_array($Pile[0]['id_rubrique'])) ? sql_in('L2.id_objet',sql_quote($in1)) : 
			array('=', 'L2.id_objet', sql_quote($Pile[0]['id_rubrique'])))), (!$Pile[0]['id_rubrique'] ? '' : 
			array('=', 'L2.objet', sql_quote('rubrique'))), sql_in('documents.extension',sql_quote($in2),'NOT'), 
			array('=', 'L1.vu', "'non'"));
	static $join = array('L1' => array('documents','id_document'), 'L2' => array('documents','id_document'), 'L3' => array('documents','extension'));
	static $limit = '';
	static $having = 
			array();
	$t0 = "";
	// REQUETE
	$result = calculer_select($select, $from, $type, $where, $join, $groupby, $orderby, $limit, $having, $table, $id, $connect,
		 array('plugins/auto/zpip/inclure/documents.html','html_d5118570b76b1c00ff0175ca79ef597c','_documents_joints',21,$GLOBALS['spip_lang']));
	if ($result) {
	
	$l1 = _T('public/spip/ecrire:bouton_telecharger');
	$l2 = _T('public/spip/ecrire:info_document');$SP++;
	// RESULTATS
	while ($Pile[$SP] = @sql_fetch($result)) {

$t0 .= (
(($t1 = strval(vider_url(urlencode_1738(generer_url_entite($Pile[$SP]['id_document'], 'document', '', '', true)))))!=='' ?
		('
		<li class="item">
			<strong><a href="' . $t1 . (	'" title="' .
	$l1 .
	'" type="' .
	interdire_scripts($Pile[$SP]['mime_type']) .
	'">' .
	interdire_scripts(((($a = typo(supprimer_numero($Pile[$SP]['titre']),"TYPO",$connect)) OR (!is_array($a) AND strlen($a))) ? $a : $l2)) .
	'</a></strong>
			<span class="small">(<span>' .
	interdire_scripts($Pile[$SP]['type_document']) .
	(($t2 = strval(interdire_scripts(taille_en_octets($Pile[$SP]['taille']))))!=='' ?
			(' &ndash; ' . $t2) :
			'') .
	'</span>)</span>
			' .
	interdire_scripts(propre($Pile[$SP]['descriptif'], $connect)) .
	'
		')) :
		'') .
'</li>
		');
	}
	@sql_free($result);
	}
	return $t0;
}

//
// Fonction principale du squelette plugins/auto/zpip/inclure/documents.html
// Temps de compilation total: 25.151 ms
//

function html_d5118570b76b1c00ff0175ca79ef597c($Cache, $Pile, $doublons=array(), $Numrows=array(), $SP=0) {

if (isset($Pile[0]["doublons"]) AND is_array($Pile[0]["doublons"]))
		$doublons = nettoyer_env_doublons($Pile[0]["doublons"]);

$connect = '';
	$page = (
'
' .
(($t1 = BOUCLE_documents_portfoliohtml_d5118570b76b1c00ff0175ca79ef597c($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
		((	'
<div class="documents documents_portfolio">
	<h2 class="h2">' .
		_T('public/spip/ecrire:info_portfolio') .
		'</h2>
	') . $t1 . '
</div>
') :
		'') .
'

' .
(($t1 = BOUCLE_documents_jointshtml_d5118570b76b1c00ff0175ca79ef597c($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
		((	'
	<div class="liste documents documents_joints">
	<h2 class="h2">' .
		_T('public/spip/ecrire:titre_documents_joints') .
		'</h2>
	<ul class="liste-items">
		') . $t1 . '
	</ul>
	</div>
') :
		'') .
'
');

return analyse_resultat_skel('html_d5118570b76b1c00ff0175ca79ef597c', $Cache, $page, 'plugins/auto/zpip/inclure/documents.html');
}
?>

/home/etiennec/www/oldsite/../oldsite/tmp/cache/skel/html_d5118570b76b1c00ff0175ca79ef597c.php