--- a/admin/exportAll.csv.php +++ b/admin/exportAll.csv.php @@ -1,1 +1,63 @@ +get_db('disclosr-agencies'); +$headers = Array(); + try { + $rows = $db->get_view("app", "fieldNames?group=true", null, true)->rows; + + $dataValues = Array(); + foreach ($rows as $row) { + $headers[] = $row->key; + } +} catch (SetteeRestClientException $e) { + setteErrorHandler($e); +} + +$fp = fopen('php://output', 'w'); +if ($fp && $db) { + header('Content-Type: text/csv; charset=utf-8'); + header('Content-Disposition: attachment; filename="export.' . date("c") . '.csv"'); + header('Pragma: no-cache'); + header('Expires: 0'); + fputcsv($fp, $headers); + try { + $agencies = $db->get_view("app", "byCanonicalName", null, true)->rows; + //print_r($rows); + foreach ($agencies as $agency) { + // print_r($agency); + + if ( !isset($agency->value->status)) { + $row = Array(); + $agencyArray = object_to_array($agency->value); + foreach ($headers as $fieldName) { + if (isset($agencyArray[$fieldName])) { + if (is_array($agencyArray[$fieldName])) { + $row[] = implode(";",$agencyArray[$fieldName]); + } else { + $row[] = $agencyArray[$fieldName]; + } + } else { + $row[] = ""; + } + } + + fputcsv($fp, array_values($row)); + + + } + } + } catch (SetteeRestClientException $e) { + setteErrorHandler($e); + } + + die; +} +?> +