require_once("lianjie.php");
require_once('Smarty_config.php');
require_once("header_xls.php");
/**************搜索的字段****************/
function get($name){
return isset($_POST[$name])?$_POST[$name]:(isset($_GET[$name])?$_GET[$name]:"");
}
$start_jf= get('start_jf');
$end_jf= get('end_jf');
/****************************开始搜索*****************************/
if(!empty($start_jf) && !empty($end_jf))
{
$start_jf = addslashes($start_jf);
$end_jf = addslashes($end_jf);
$where .= "and `date` >= '$start_jf' and `date` < '$end_jf' ";
$whe .="and a.check_date >= '$start_jf' and a.check_date < '$end_jf'";
}
$sql ="SELECT order_id AS '订单号', person AS '操作人员', `date` AS '时间', record AS '记录', res AS '备注'
FROM gift_order_record
WHERE 1 $where";
$rs=mysql_query($sql,$connection);
//print_r(mysql_fetch_assoc($rs));
/******************************统计***************************/
$result = mysql_query("SELECT a.gift_id AS '编号', b.`name` AS '名称', count( a.gift_id ) AS '数量'
FROM gift_order AS a
INNER JOIN gift AS b ON a.gift_id = b.gift_id
WHERE a.order_state_id
IN ( 3, 6 ) $whe GROUP BY a.gift_id");
//print_r(mysql_fetch_assoc($result));
$smarty->display("jifen_hl.htm");
mysql_close($connection);
require_once('Smarty_config.php');
require_once("header_xls.php");
/**************搜索的字段****************/
function get($name){
return isset($_POST[$name])?$_POST[$name]:(isset($_GET[$name])?$_GET[$name]:"");
}
$start_jf= get('start_jf');
$end_jf= get('end_jf');
/****************************开始搜索*****************************/
if(!empty($start_jf) && !empty($end_jf))
{
$start_jf = addslashes($start_jf);
$end_jf = addslashes($end_jf);
$where .= "and `date` >= '$start_jf' and `date` < '$end_jf' ";
$whe .="and a.check_date >= '$start_jf' and a.check_date < '$end_jf'";
}
$sql ="SELECT order_id AS '订单号', person AS '操作人员', `date` AS '时间', record AS '记录', res AS '备注'
FROM gift_order_record
WHERE 1 $where";
$rs=mysql_query($sql,$connection);
//print_r(mysql_fetch_assoc($rs));
/******************************统计***************************/
$result = mysql_query("SELECT a.gift_id AS '编号', b.`name` AS '名称', count( a.gift_id ) AS '数量'
FROM gift_order AS a
INNER JOIN gift AS b ON a.gift_id = b.gift_id
WHERE a.order_state_id
IN ( 3, 6 ) $whe GROUP BY a.gift_id");
//print_r(mysql_fetch_assoc($result));
$smarty->display("jifen_hl.htm");
mysql_close($connection);
下面是生成的xls文件的方法
http://apps.hi.baidu.com/share/detail/16729558