201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
|
protected function export(array $list = null)
{
$db = DB::getInstance();
$champs = Config::getInstance()->get('champs_membres')->getKeys();
$champs = array_map([$db, 'quoteIdentifier'], $champs);
$champs_sql = 'm.' . implode(', m.', $champs);
$where = $list ? 'WHERE ' . $db->where('m.id', $list) : '';
$res = $db->iterate('SELECT ' . $champs_sql . ', c.nom AS "Catégorie membre" FROM membres AS m
INNER JOIN membres_categories AS c ON m.id_categorie = c.id
' . $where . '
ORDER BY c.id;');
return [
array_keys((array) $res->current()),
$res,
sprintf('Export membres - %s - %s', Config::getInstance()->get('nom_asso'), date('Y-m-d')),
];
}
|
|
>
>
>
>
>
>
|
|
>
|
|
|
>
|
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
|
protected function export(array $list = null)
{
$db = DB::getInstance();
$champs = Config::getInstance()->get('champs_membres')->getKeys();
$champs = array_map([$db, 'quoteIdentifier'], $champs);
$fields = 'm.' . implode(', m.', $champs);
if ($list) {
$list = array_map('intval', $list);
$where = sprintf('WHERE m.%s', $db->where('id', $list));
}
else {
$where = '';
}
$sql = sprintf('SELECT %s, c.nom AS "Catégorie membre" FROM membres AS m
INNER JOIN membres_categories AS c ON m.id_categorie = c.id
%s ORDER BY c.id;', $fields, $where);
$res = $db->iterate($sql);
return [
array_keys((array) $res->current()),
$res,
sprintf('Export membres - %s - %s', Config::getInstance()->get('nom_asso'), date('Y-m-d')),
];
}
|