<?php
 include("chcekuser.php");
 include("sunland_config.php");
 $action=$_REQUEST["action"];
 $soname1=$_REQUEST["soname1"];
 $soname2=$_REQUEST["soname2"];
 $starttime=$_REQUEST["starttime"];
 $endtime=$_REQUEST["endtime"];
 $kechengzhonglei=$_REQUEST["kechengzhonglei"];
 $kechengxiaolei=$_REQUEST["kechengxiaolei"]; $Connect = @mysql_connect($servname, $sqlservname, $sqlservpws)
 or die("Couldn't connect.");
 $Db = @mysql_select_db($sqlname, $Connect)
 or die("Couldn't select database.");
 mysql_query("set names gb2312");
 $file_type = "vnd.ms-excel";
 $file_ending = "xls";
 header("Content-Type: application/$file_type");
 header("Content-Disposition: attachment; filename=$DB_TBLName.$file_ending");
 header("Pragma: no-cache");
 header("Expires: 0");
 date_default_timezone_set("Etc/GMT-8");
 $now_date = date('Y-m-d H:i');
 //$title = "数据库名:$sqlname,数据表:$DB_TBLName,备份日期:$now_date";
     if ($starttime=="" and $endtime==""){
      $starttime=date("Y-m-d", strtotime("-30 days", time()));
      $endtime=date("Y-m-d");
     }
     if ($soname2!=""){
      $s1=" and $soname1='$soname2'";
     }else{
      $s1="";
     }
     if ($kechengzhonglei!=""){
      $s2=" and kechengzhonglei=$kechengzhonglei";
     }else{
      $s2="";
     }
     if ($kechengxiaolei!=""){
      $s3=" and kechengxiaolei=$kechengxiaolei";
     }else{
      $s3="";
     }
 $sql = "Select * from sell where DATE_FORMAT(zixunshijian, '%Y-%m-%d') >= '$starttime' and DATE_FORMAT(zixunshijian, '%Y-%m-%d') <= '$endtime' ".$s1." ".$s2." ".$s3." order by aid desc";
 $ALT_Db = @mysql_select_db($sqlname, $Connect)
 or die("Couldn't select database");
 $result = @mysql_query($sql,$Connect)
 or die(mysql_error());
 echo("$title\n");
 $sep = "\t";
 for ($i = 0; $i < mysql_num_fields($result); $i++) {
 echo mysql_field_name($result,$i) . "\t";
 }
 print("\n");
 $i = 0;
 while($row = mysql_fetch_row($result))
 {
 $schema_insert = "";
 for($j=0; $j<mysql_num_fields($result);$j++)
 {
 if(!isset($row[$j]))
 $schema_insert .= "NULL".$sep;
 elseif ($row[$j] != "")
 $schema_insert .= "$row[$j]".$sep;
 else
 $schema_insert .= "".$sep;
 }
 $schema_insert = str_replace($sep."$", "", $schema_insert);
 $schema_insert .= "\t";
 print(trim($schema_insert));
 print "\n";
 $i++;
 }
 return (true);
 ?>