function csv_output($query)
{
global $fields;
$result = full_query($query);
while ($data = mysql_fetch_array($result)) {
foreach ($fields as $field) {
echo csv_clean($data[$field]) . ",";
}
echo "\r\n";
}
}
/**
* Print generic normal Item Cell
*
* @param $type display type (0=HTML, 1=Sylk,2=PDF,3=CSV)
* @param $value value to display
* @param $num column number
* @param $row row number
* @param $extraparam extra parameters for display
*
*@return string to display
**/
static function showItem($type, $value, &$num, $row, $extraparam = '')
{
$out = "";
switch ($type) {
case PDF_OUTPUT_LANDSCAPE:
//pdf
//pdf
case PDF_OUTPUT_PORTRAIT:
global $PDF_ARRAY, $PDF_HEADER;
$value = weblink_extract($value);
$PDF_ARRAY[$row][$num] = decodeFromUtf8(html_clean($value), 'windows-1252');
break;
case SYLK_OUTPUT:
//sylk
global $SYLK_ARRAY, $SYLK_HEADER, $SYLK_SIZE;
$value = weblink_extract($value);
$SYLK_ARRAY[$row][$num] = sylk_clean($value);
$SYLK_SIZE[$num] = max($SYLK_SIZE[$num], utf8_strlen($SYLK_ARRAY[$row][$num]));
break;
case CSV_OUTPUT:
//csv
$value = weblink_extract($value);
$out = "\"" . csv_clean($value) . "\"" . $_SESSION["glpicsv_delimiter"];
break;
default:
//TODO supprimer valign pour mettre class mais conflit avec $extraparam
$out = "<td {$extraparam} valign='top'>";
/* if (!preg_match('/<hr>/',$value)) {
$values = preg_split("/<br>/i",$value);
$line_delimiter = '<br>';
} else {
$values = preg_split("/<hr>/i",$value);
$line_delimiter = '<hr>';
}
$limitto = 20;
if (count($values) > $limitto) {
for ( $i=0 ; $i<$limitto ; $i++) {
$out .= $values[$i].$line_delimiter;
}
$rand=mt_rand();
$out .= "... ";
$out .= showToolTip($value,array('display' => false,
'autoclose' => false));
} else {*/
$out .= $value;
// }
$out .= "</td>\n";
}
$num++;
return $out;
}
