1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
|
<?php
require_once("../utils/__config.php");
require_once('../utils/class.connect.php');
function string2url($chaine) {
$chaine = trim($chaine);
$chaine = strtr($chaine,
"ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ",
"aaaaaaaaaaaaooooooooooooeeeeeeeecciiiiiiiiuuuuuuuuynn");
$chaine = strtr($chaine,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","abcdefghijklmnopqrstuvwxyz");
$chaine = preg_replace('#([^.a-z0-9]+)#i', '-', $chaine);
$chaine = preg_replace('#-{2,}#','-',$chaine);
$chaine = preg_replace('#-$#','',$chaine);
$chaine = preg_replace('#^-#','',$chaine);
return $chaine;
}
include '../utils/class.excel.php';
function Somme_Total_UO($liste_entite,$position){
$contenu = "=SOMME(";
foreach($liste_entite as $entite)
{
$contenu .= "'".$entite . "'!".$position.";";
}
$contenu = substr($contenu, 0, -1); // supprime le dernier "+"
$contenu .= ")";
return $contenu ;
}
$nb_onglet =0;
$DB4 = DB::getInstance();
foreach ($DB4->query("SELECT `id`,`libelle` FROM `entites` WHERE `depend_de` =33" ) as $row4)
{
$bop = $row4['id'];
$libelle = string2url($row4['libelle']);
$liste_entite[] = $libelle;
if ($nb_onglet == 0)
{
$workbook = new MaitrePylosExcel();
${'sheet'.$nb_onglet} = $workbook->getActiveSheet();
${'sheet'.$nb_onglet}->setTitle($libelle);
${'sheet'.$nb_onglet}->setCellValue('A1',10);
}
else
{
${'sheet'.$nb_onglet} = $workbook->createSheet($nb_onglet);
$workbook->setActiveSheetIndex($nb_onglet);
${'sheet'.$nb_onglet} = $workbook->getActiveSheet($nb_onglet);
${'sheet'.$nb_onglet} ->setTitle($libelle);
${'sheet'.$nb_onglet}->setCellValue('A1',3);
}
$nb_onglet ++;
}
${'sheet'.$nb_onglet} = $workbook->createSheet($nb_onglet);
$workbook->setActiveSheetIndex($nb_onglet);
${'sheet'.$nb_onglet} = $workbook->getActiveSheet($nb_onglet);
${'sheet'.$nb_onglet} ->setTitle("UO");
${'sheet'.$nb_onglet}->setCellValue('A1',Somme_Total_UO($liste_entite,"A1"));
$date = date('d-m-Y');
$workbook->affiche('Excel5','TEST_Export_du_'.$date);
?> |
Partager