Overview
Comment: | Export des membres en CSV |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
4de55bfb00d88290bfe99f6ef8c52da2 |
User & Date: | bohwaz on 2012-12-23 04:12:26 |
Other Links: | manifest | tags |
Context
2012-12-23
| ||
04:14 | Version 0.4.5 check-in: bfc7ed2ec9 user: bohwaz tags: trunk | |
04:12 | Export des membres en CSV check-in: 4de55bfb00 user: bohwaz tags: trunk | |
03:37 | Refonte de la recherche de membre check-in: 9959a6561e user: bohwaz tags: trunk | |
Changes
Modified include/class.membres.php from [2b67cfeb4e] to [f6100e7e8c].
︙ | ︙ | |||
599 600 601 602 603 604 605 606 607 608 609 610 611 | $sujet = '['.$config->get('nom_asso').'] '.$sujet; while ($row = $res->fetchArray(SQLITE3_ASSOC)) { utils::mail($row['email'], $sujet, $message, $headers); } return true; } } ?> | > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 | $sujet = '['.$config->get('nom_asso').'] '.$sujet; while ($row = $res->fetchArray(SQLITE3_ASSOC)) { utils::mail($row['email'], $sujet, $message, $headers); } return true; } public function toCSV() { $db = DB::getInstance(); $res = $db->prepare('SELECT m.id, c.nom AS "categorie", m.* FROM membres AS m LEFT JOIN membres_categories AS c ON m.id_categorie = c.id ORDER BY c.id;')->execute(); $fp = fopen('php://output', 'w'); $header = false; while ($row = $res->fetchArray(SQLITE3_ASSOC)) { unset($row['passe']); if (!$header) { fputcsv($fp, array_keys($row)); $header = true; } fputcsv($fp, $row); } fclose($fp); return true; } } ?> |
Added www/admin/membres/export.php version [2bafc715db].
> > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <?php namespace Garradin; require_once __DIR__ . '/../_inc.php'; if ($user['droits']['membres'] < Membres::DROIT_ADMIN) { throw new UserException("Vous n'avez pas le droit d'accéder à cette page."); } header('Content-type: application/csv'); header('Content-Disposition: attachment; filename="Export comptabilité - ' . $config->get('nom_asso') . ' - ' . date('Y-m-d') . '.csv"'); $membres->toCSV(); exit; ?> |