Server : Apache System : Linux webd348.cluster026.gra.hosting.ovh.net 5.15.148-ovh-vps-grsec-zfs-classid #1 SMP Thu Feb 8 09:41:04 UTC 2024 x86_64 User : hednacluml ( 122243) PHP Version : 8.3.9 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Directory : /home/hednacluml/jobs/tmp/cache/skel/ |
<?php /* * Squelette : plugins/auto/escal/inclusions/inc-portfolio.html * Date : Thu, 27 Jun 2024 20:36:58 GMT * Compile : Fri, 28 Jun 2024 00:47:10 GMT * Boucles : _doc_joints, _doc_joints1, _doc_joints2 */ function BOUCLE_doc_jointshtml_4858d426df668b0c5a323e9aa127bb16(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'documents'; $command['id'] = '_doc_joints'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("count(*)"); $command['orderby'] = array(); $command['join'] = array('L1' => array('documents','id_document')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), quete_condition_postdates('documents.date_publication',''), array('IN', 'documents.mode', '(\'image\',\'document\')'), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article')), array('=', 'L1.vu', "'non'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-portfolio.html','html_4858d426df668b0c5a323e9aa127bb16','_doc_joints',9,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_doc_joints']['command'] = $command; $Numrows['_doc_joints']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat(' ', $Numrows['_doc_joints']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_doc_joints @ plugins/auto/escal/inclusions/inc-portfolio.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_doc_joints1html_4858d426df668b0c5a323e9aa127bb16(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'documents'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'documents'; $command['id'] = '_doc_joints1'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_types_documents'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("0+documents.titre AS num", "CASE ( 0+documents.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "documents.titre", "documents.fichier", "documents.id_document", "documents.descriptif", "documents.taille", "L2.titre AS type_document"); $command['orderby'] = array('sinum, num', 'documents.titre', 'documents.fichier'); $command['join'] = array('L1' => array('documents','id_document'), 'L2' => array('documents','extension')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), quete_condition_postdates('documents.date_publication',''), array('IN', 'documents.mode', '(\'image\',\'document\')'), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article')), array('=', 'documents.media', "'image'"), array('=', 'L1.vu', "'non'"), array(sql_in('documents.id_document', $doublons[$doublons_index[]= ('documents')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-portfolio.html','html_4858d426df668b0c5a323e9aa127bb16','_doc_joints1',17,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_document']; // doublons $t1 = ( ' <div class="texte-doc" > <div class="vignette"> ' . (!(version_compare(spip_version(),'2.1','>=')) ? (' ' . ( ' <a href="' . vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_document'], 'document', '', '', true))) . '">' . (($doublons["documents"] .= ",". $Pile[$SP]['id_document']) ? quete_logo_document(quete_document($Pile[$SP]['id_document'], ''), '', '', '', 0, 0, '') : '') . '</a> ')) : '') . ' ' . ((version_compare(spip_version(),'2.1','>=')) ? (' ' . ( ' ' . (($doublons["documents"] .= ",". $Pile[$SP]['id_document']) ? quete_logo_document(quete_document($Pile[$SP]['id_document'], ''), vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_document'], 'document', '', '', true))), '', '', 0, 0, '') : ''))) : '') . ' </div> <div class="description"> <span class="titre-doc">' . interdire_scripts(((($a = traiter_doublons_documents($doublons, supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))) OR (is_string($a) AND strlen($a))) ? $a : interdire_scripts(basename(get_spip_doc($Pile[$SP]['fichier']))))) . '</span> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/descriptifdoc',null,false):'') == 'oui')) ?' ' :''))))!=='' ? ($t1 . ( ' ' . (($t2 = strval(interdire_scripts(couper(traiter_doublons_documents($doublons, propre($Pile[$SP]['descriptif'], $connect, $Pile[0])),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/descriptifdoccouper','300',false):''))))))!=='' ? ('<span class="descriptif-doc">' . $t2 . '</span>') : '') . ' ')) : '') . ' <span class="taille-doc">' . interdire_scripts(taille_en_octets($Pile[$SP]['taille'])) . ' / ' . interdire_scripts($Pile[$SP]['type_document']) . '</span> </div> </div><!-- fin texte-doc --> '); $t0 .= ((strlen($t1) && strlen($t0)) ? '<hr>' : '') . $t1; } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_doc_joints1 @ plugins/auto/escal/inclusions/inc-portfolio.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_doc_joints2html_4858d426df668b0c5a323e9aa127bb16(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'documents'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'documents'; $command['id'] = '_doc_joints2'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_types_documents'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("0+documents.titre AS num", "CASE ( 0+documents.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "documents.titre", "documents.fichier", "documents.id_document", "documents.descriptif", "documents.taille", "L2.titre AS type_document"); $command['orderby'] = array('sinum, num', 'documents.titre', 'documents.fichier'); $command['join'] = array('L1' => array('documents','id_document'), 'L2' => array('documents','extension')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), quete_condition_postdates('documents.date_publication',''), array('IN', 'documents.mode', '(\'image\',\'document\')'), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article')), array('=', 'L1.vu', "'non'"), array(sql_in('documents.id_document', $doublons[$doublons_index[]= ('documents')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-portfolio.html','html_4858d426df668b0c5a323e9aa127bb16','_doc_joints2',43,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_document']; // doublons $t1 = ( ' <div class="texte-doc" > <div class="vignette"> ' . (!(version_compare(spip_version(),'2.1','>=')) ? (' ' . ( ' <a href="' . vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_document'], 'document', '', '', true))) . '">' . (($doublons["documents"] .= ",". $Pile[$SP]['id_document']) ? quete_logo_document(quete_document($Pile[$SP]['id_document'], ''), '', '', '', 0, 0, '') : '') . '</a> ')) : '') . ' ' . ((version_compare(spip_version(),'2.1','>=')) ? (' ' . ( ' ' . (($doublons["documents"] .= ",". $Pile[$SP]['id_document']) ? quete_logo_document(quete_document($Pile[$SP]['id_document'], ''), vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_document'], 'document', '', '', true))), '', '', 0, 0, '') : ''))) : '') . ' </div> <div class="description"> <span class="titre-doc">' . interdire_scripts(((($a = traiter_doublons_documents($doublons, supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))) OR (is_string($a) AND strlen($a))) ? $a : interdire_scripts(basename(get_spip_doc($Pile[$SP]['fichier']))))) . '</span> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/descriptifdoc',null,false):'') == 'oui')) ?' ' :''))))!=='' ? ($t1 . ( ' ' . (($t2 = strval(interdire_scripts(couper(traiter_doublons_documents($doublons, propre($Pile[$SP]['descriptif'], $connect, $Pile[0])),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/descriptifdoccouper','300',false):''))))))!=='' ? ('<span class="descriptif-doc">' . $t2 . '</span>') : '') . ' ')) : '') . ' <span class="taille-doc">' . interdire_scripts(taille_en_octets($Pile[$SP]['taille'])) . ' / ' . interdire_scripts($Pile[$SP]['type_document']) . '</span> </div> </div><!-- fin texte-doc --> '); $t0 .= ((strlen($t1) && strlen($t0)) ? '<hr>' : '') . $t1; } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_doc_joints2 @ plugins/auto/escal/inclusions/inc-portfolio.html","profiler"._LOG_AVERTISSEMENT); return $t0; } // // Fonction principale du squelette plugins/auto/escal/inclusions/inc-portfolio.html // Temps de compilation total: 6.620 ms // function html_4858d426df668b0c5a323e9aa127bb16($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 = ( '<!-- documents à telécharger --> ' . (($t1 = BOUCLE_doc_jointshtml_4858d426df668b0c5a323e9aa127bb16($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? (( ' <aside id="documents_portfolio"> <div class="titre_portfolio"> <img src="' . find_in_path((string)'images/download.svg') . '" width="16" height="16" alt="' . _T('escal:alt_telechargements') . '" /> ' . (((($Numrows['_doc_joints']['total'] ?? 0) > '01')) ? (' ' . ( ' ' . _T('escal:telechargements'))) : '') . ' ' . (!((($Numrows['_doc_joints']['total'] ?? 0) > '01')) ? (' ' . ( ' ' . _T('escal:telechargement'))) : '') . ' </div> ') . $t1 . ( ' ' . (($t3 = BOUCLE_doc_joints1html_4858d426df668b0c5a323e9aa127bb16($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? (' <div class="illustrations"> Images </div> <div class="portfolio"> ' . $t3) : '') . ' </div> ' . (($t3 = BOUCLE_doc_joints2html_4858d426df668b0c5a323e9aa127bb16($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? (' <div class="illustrations"> Documents </div> <div class="portfolio"> ' . $t3) : '') . ' </div> </aside><!-- Fin cadre-telechargements --> ')) : '')); return analyse_resultat_skel('html_4858d426df668b0c5a323e9aa127bb16', $Cache, $page, 'plugins/auto/escal/inclusions/inc-portfolio.html'); }