/** * Constructor * @param adminDb $db * @param bool $showTypeID */ public function __construct(adminDb $db, $showTypeID = false) { $this->db = $db; $this->servKey = $db->getServKey(); $query = "SELECT a.*,d.id_doc,d.basename,d.dirname,t.nom type FROM acces a\n\t\t\t LEFT JOIN documents d USING(id_doc)\n\t\t\t LEFT JOIN types t USING (id_type)"; if ($showTypeID !== false) { $query .= " WHERE t.id_type = {$showTypeID}"; } $query .= " ORDER BY a.id_type, a.name"; $stmt = $db->query($query); $stmt->setFetchMode(PDO::FETCH_CLASS, 'AdminDocumentAccess', array($this->servKey, $db)); $this->access = $stmt->fetchAll(); unset($stmt); }
/** * Constructor * @param adminDb $db * @param bool $showTypeID */ public function __construct(adminDb $db, $showTypeID = false) { $this->db = $db; $this->servKey = $db->getServKey(); $query = "\n SELECT\n aa.*,\n a.*,\n t.nom type\n FROM archives_acces aa\n LEFT JOIN archives a USING (id_archive)\n LEFT JOIN types t USING (id_type)"; if ($showTypeID !== false) { $query .= " WHERE t.id_type = {$showTypeID}"; } $query .= " ORDER BY aa.id_type, aa.rank"; $stmt = $db->query($query); $stmt->setFetchMode(PDO::FETCH_CLASS, 'AdminArchiveAccess', array($this->servKey, $db)); $this->access = $stmt->fetchAll(); unset($stmt); }
require 'classes/adminDb.class.php'; require 'classes/AdminImageAccessList.class.php'; require 'classes/AdminImageAccess.class.php'; $id_avion = $_GET['id_avion']; // Supprimer tous les fichiers zip présent dans le répertoire en premier lieu foreach (glob('*.zip') as $filename) { unlink($filename); } try { $db = new adminDb(DSN, USER, PASSW); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); } catch (PDOException $e) { die("Erreur PDO : <br />" . $e->getMessage() . "<br />Trace : " . $e->getTraceAsString()); } $avion = $db->query(sprintf('SELECT nom FROM produits WHERE id_avion=%d', $id_avion))->fetchColumn(); // Images activées $allMediasAccess = new AdminImageAccessList($db, $id_avion); $filename = $avion . '_' . date('mdY') . '.zip'; $zip = new ZipArchive(); if (file_exists($filename)) { unlink($filename); } $open = $zip->open($filename, ZipArchive::CREATE); // Création d'une nouvelle archive if ($open) { foreach ($allMediasAccess as $mediaAccess) { $zip->addFile($mediaAccess->srcname, $mediaAccess->basename); } $zip->close(); header('Content-Disposition: attachment; filename="' . $filename . '"');
$title_line = 3; $thead_line = 5; $first = true; $current_type = 'new'; $current_cat = 'new'; $current_product = 'new'; $i = 1; $sheet_cnt = 0; $workbook = new PHPExcel(); /* -------------------------------------------------------------------- */ /* -------------------------------------------------------------------- */ /* ----------------------------- Brochures ---------------------------- */ /* -------------------------------------------------------------------- */ /* -------------------------------------------------------------------- */ $query = "\n\t SELECT a.*,d.id_doc,d.basename,d.dirname,t.nom type, c.nom categorie, c.id_categorie,p.id_avion, p.nom avion\n\t FROM acces a\n\t JOIN documents d USING(id_doc)\n\t JOIN types t USING (id_type)\n\t JOIN acces_avion aa USING(id_doc)\n\t JOIN produits p USING (id_avion)\n\t JOIN categories c ON c.id_categorie=t.id_categorie\n\t ORDER BY p.menu ASC,c.id_categorie, a.id_type, a.name\n"; $stmt = $db->query($query); $sheet_indexes = array(); // Lister toutes les brochures while ($docAccess = $stmt->fetchObject('AdminDocumentAccess', array($servKey, $db))) { $new_type = $docAccess->getTypeId() != $current_type; $new_cat = $docAccess->getCatId() != $current_cat; $new_product = $docAccess->id_avion != $current_product; // Nouveau produit if ($new_product) { if ($sheet_cnt == 0) { $sheet = $workbook->getActiveSheet(); } else { $sheet = $workbook->createSheet(); } $sheet->getDefaultStyle()->applyFromArray($default_style); $sheet->getColumnDimension('A')->setAutoSize(true);
require 'classes/AdminArchiveAccess.class.php'; require 'classes/image.class.php'; require 'classes/httpQueryStr.class.php'; require 'classes/locale.class.php'; try { $db = new adminDb(DSN, USER, PASSW); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); } catch (PDOException $e) { die("Erreur PDO : <br />" . $e->getMessage() . "<br />Trace : " . $e->getTraceAsString()); } $httpQuery = new httpQueryStr(); $httpQuery->setIndexDefVal('p', 'inactiveDocs'); //$httpQuery->setIndexDefVal('productID', $db->query('SELECT id_avion FROM produits ORDER BY menu LIMIT 1')->fetchColumn()); try { // Contrôleur require_once 'adminCtrl/' . $httpQuery->p . '.php'; if (!$httpQuery->has('productID')) { $httpQuery->productID = $db->query('SELECT id_avion FROM produits ORDER BY menu LIMIT 1')->fetchColumn(); } } catch (PDOException $e) { $db->rollback(); die($e->getMessage() . "<br />Détail :<br />" . $e->getTraceAsString()); $error = $e->getMessage() . "<br />Détail :<br />" . $e->getTraceAsString(); } catch (Exception $e) { die($e->getMessage() . "<br />Détail :<br />" . $e->getTraceAsString()); $error = $e->getMessage() . "<br />Détail :<br />" . $e->getTraceAsString(); } include_once 'adminHtml/header.php'; include_once 'adminHtml/' . $httpQuery->p . '.php'; include_once 'adminHtml/footer.htm';
// $sheet->getColumnDimension('B')->setWidth(60); // $sheet->getColumnDimension('C')->setWidth(64); // $sheet->getColumnDimension('D')->setWidth(8); // DATE $sheet->setCellValue('A1', 'Generated : ' . date('D,M dS Y')); $sheet->mergeCells('A1:' . numToLetter($theads_cnt) . '1'); // TITRE FEUILLE $sheet->setTitle("Marketingfalcon Users"); $sheet->setCellValue('A' . $title_line, "Marketingfalcon Users"); $sheet->duplicateStyleArray($style_titre, 'A' . $title_line . ':' . numToLetter($theads_cnt) . $title_line); $sheet->mergeCells('A' . $title_line . ':' . numToLetter($theads_cnt) . $title_line); // EN TETES foreach ($theads as $i => $val) { $sheet->setCellValue(numToLetter($i + 1) . $thead_line, $val); } $stmt = $db->query("\n\t SELECT *\n\t FROM utilisateurs\n\t ORDER BY login ASC\n"); // Lister tous les utilisateurs while ($user = $stmt->fetch(PDO::FETCH_ASSOC)) { // Ligne utilisateur $sheet->setCellValue('A' . $row_cnt, $user['id']); // ID $sheet->setCellValue('B' . $row_cnt, $user['login']); // Document Name $sheet->setCellValue('C' . $row_cnt, $user['description']); // Link $sheet->duplicateStyleArray($style_user_line, 'A' . $row_cnt . ':' . numToLetter($theads_cnt) . $row_cnt); $row_cnt++; } $stmt = NULL; unset($stmt); $workbook->setActiveSheetIndex(0);