Mor Partial data
[contractdashboard.git] / exportData.csv.php
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
<?php
 
include_once("./lib/common.inc.php");
setlocale(LC_CTYPE, 'C');
// source: http://stackoverflow.com/questions/81934/easy-way-to-export-a-sql-table-without-access-to-the-server-or-phpmyadmin#81951
$result = mysql_query('
SELECT CNID,contractnotice.agencyName,agency.abn as agencyABN,DATE(publishDate),contractStart,contractEnd,value,description,procurementMethod,category,categoryUNSPSC
,supplierABN,supplierName,supplierCity,supplierPostcode,supplierCountry,contactPostcode,
(
 case when "supplierABN" != 0 THEN "supplierABN"::text ELSE "supplierName" END) as supplierID
 
concat("https://www.tenders.gov.au/?event=public.advancedsearch.keyword&keyword=CN",CNID) as sourceURL 
FROM `contractnotice` join agency on contractnotice.agencyName=agency.agencyName where childCN = 0');
if (!$result) die('Couldn\'t fetch records');
$num_fields = mysql_num_fields($result);
$headers = array();
for ($i = 0; $i < $num_fields; $i++) {
    $headers[] = mysql_field_name($result , $i);
}
$fp = fopen('php://output', 'w');
if ($fp && $result) {
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="export.'.date("c").'.csv"');
    header('Pragma: no-cache');
    header('Expires: 0');
    fputcsv($fp, $headers);
    while ($row = mysql_fetch_assoc($result)) {
        foreach ($row as &$colvalue) {
                        $colvalue =  preg_replace( '/[^[:print:]]/', '',
                         utf8_encode($colvalue));
                }
        fputcsv($fp, array_values($row));
    }
    die;
}
?>