<?php
$result = db_query('SELECT n.nid, n.title, t.utmx, t.utmy, t.ref_karto FROM node n LEFT JOIN toponimo t ON n.nid = t.nid LEFT JOIN `topo_label` l ON n.nid = l.nid WHERE n.type = "toponimo" ORDER BY n.title');
$rows = array();
$headers = array('NID', 'Toponimoa', 'UTMX', 'UTMY', 'Erref.Kart.');
switch(arg(2)){
case 'csv':
while($row = db_fetch_array($result)){
$rows[] = $row;
}
$output = '"'. join($headers, '"; "') . '"' . "\n";
foreach($rows as $row){
$output .= '"'. join($row, '"; "') . '"' . "\n";
}
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"bergarako_toponimia_GFA.csv\"");
print $output;
exit;
default:
while($row = db_fetch_array($result)){
$row['utmx'] = array('data' => number_format($row['utmx'], 1, '.', ''), 'class' => 'esk');
$row['utmy'] = array('data' => number_format($row['utmy'], 1, '.', ''), 'class' => 'esk');
$rows[] = $row;
}
$output = '';
$output .= '<div class="links">'. l('CSV formatuan jaso', "{$_GET['q']}/csv") .'</div>';
$output .= theme('table', $headers, $rows);
print $output;
}
?>
