< ?php
/*
ini_set("error_reporting",E_ALL);
ini_set("display_startup_errors",1);
ini_set("display_errors",1);
*/
function escapeCSV($str){
  $str = str_replace(array(',','"',"\n\r"),array('','""',''),$str);
  if($str == ""){
    $str = '""';
  }
  return $str;
}
 
function iconvstr($str){
	return iconv('utf-8','gb2312',escapeCSV($str));
}
 
$intent = in_array($_GET['intent'],array('y','n')) ? $_GET['intent'] : '';
 
if($intent != ''){
	$query_cond = " WHERE `intent` ='$intent' ";
}else{
	$query_cond = '';
}
 
$result = mysql_query("SELECT * FROM `{$db_fix}report` $query_cond ORDER BY `id` DESC");
 
$filename = date('YmdHis').'.csv';
 
$data = "\"ID\",Username,Company,Email,Mobile,Day,Time,Attendance"."\n";
 
while($r = mysql_fetch_array($result)) {
	$daytime1 = date('Y-m-d',$r['daytime']);
	$daytime2 = date('H:i:s',$r['daytime']);
 
	//$daytime = intval($daytime);
	$intent = ($r['intent'] == 'y') ? 'Yes' : 'No';
	$data .= $r['id'].','.iconvstr($r['username']).','.iconvstr($r['company']).','.$r['email'].','.$r['mob'].','.$daytime1.','.$daytime2.','.$intent."\n";
}
 
header("Content-type: text/csv");
header ("Content-Disposition: attachment; filename=" . $filename);
header('Cache-Control:   must-revalidate,   post-check=0,   pre-check=0');
header('Expires:   0');
header('Pragma:   public');
echo $data;
?>

// 基本语法
 
< ?php echo object_select_tag($article, 'getAuthorId') ?>
 
// 通过方法AuthorPeer::doSelect(new Criteria())
 
 
 
// 修改peer类
 
< ?php echo object_select_tag($article, 'getAuthorId', 'related_class=Foobar') ?>
 
// 通过方法FoobarPeer::doSelect(new Criteria())
 
 
 
// 修改Peer方法
 
< ?php echo object_select_tag($article, 'getAuthorId','peer_method=getMostFamousAuthors') ?>
 
// 通过方法AuthorPeer::getMostFamousAuthors(new Criteria())
 
 
 
// 在列表顶部添加 <option value="">&nbsp;</option> 
 
< ?php echo object_select_tag($article, 'getAuthorId', 'include_blank=true') ?>
 
 
 
//在列表顶部添加<option value="">Choose an author</option> 
 
< ?php echo object_select_tag($article, 'getAuthorId', 'include_custom=Choose an author') ?>

    /**
     * 向浏览器发送文件内容
     *
     * @param string $serverPath 文件在服务器上的路径（绝对或者相对路径）
     * @param string $filename 发送给浏览器的文件名（尽可能不要使用中文）
     * @param string $mimeType 指示文件类型
     */
    function sendFile($serverPath, $filename, $mimeType = 'application/octet-stream')
    {
        header("Content-Type: {$mimeType}");
        $filename = '"' . htmlspecialchars($filename) . '"';
        $filesize = filesize($serverPath);
        $charset = FLEA::getAppInf('responseCharset');
        header("Content-Disposition: attachment; filename={$filename}; charset={$charset}");
        header('Pragma: cache');
        header('Cache-Control: public, must-revalidate, max-age=0');
        header("Content-Length: {$filesize}");
        readfile($serverPath);
        exit;
    }