该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
include("include/islogin.php");
?>
查看本月订单 查看未出齐订单 查看上月订单 查看全部订单
if(isset($_GET['type']))
{
$type=$_GET[type];//对输入进行验证;
if(isset($_GET['page'])){$page=$_GET['page'];}//验证
else{$page=1;}
$limit=30;
switch($type)
{
case benyue:
date_default_timezone_set('PRC');//设置时间东八区
$nianyue=date('Y m',time());
$tongjileixing='本月'.$nianyue.'月';
//echo $nianyue;
//print_r(gettype($nianyue));
$sqlstr='select SQL_CALC_FOUND_ROWS `id`,`customer_id`,`xiadandate`,`jiedanren`,`yaoqiu`,`dingjin`,`jiaoqi`,`huokuan`,`shouqi`,`zhekou`,`chuqi`,`zhifu_way`,`record` from `wm_order_info` where DATE_FORMAT(`xiadandate`,'."'%Y %m')='".$nianyue."' limit ".($page-1)*$limit.','.$limit;
$ulr='view_order_info.php?type=benyue&';
break;
case weiqi:
$tongjileixing='未齐';
$sqlstr="select SQL_CALC_FOUND_ROWS `id`,`customer_id`,`xiadandate`,`jiedanren`,`yaoqiu`,`dingjin`,`jiaoqi`,`huokuan`,`shouqi`,`zhekou`,`chuqi`,`zhifu_way`,`record` from `wm_order_info` where `chuqi`='0' limit ".($page-1)*$limit.','.$limit;
$ulr='view_order_info.php?type=weiqi&';
break;
case shangyue:
date_default_timezone_set('PRC');//设置时间东八区
$time=time();
$bennian=date('Y',$time);
$benyue=date('m',$time);
if($benyue=='1'){$benyue='12';$bennian=$bennian-1;}
$shangyue=$bennian.' '.$benyue;
$tongjileixing='上月'.$shangyue.'订单';
//echo $bennian.$shangyue;
//print_r(gettype($nianyue));
$sqlstr='select SQL_CALC_FOUND_ROWS `id`,`customer_id`,`xiadandate`,`jiedanren`,`yaoqiu`,`dingjin`,`jiaoqi`,`huokuan`,`shouqi`,`zhekou`,`chuqi`,`zhifu_way`,`record` from `wm_order_info` where DATE_FORMAT(`xiadandate`,'."'%Y %m')='".$shangyue."' limit ".($page-1)*$limit.','.$limit;
$ulr='view_order_info.php?type=shangyue&';
//$shangyue=
break;
case all:
$tongjileixing='全部';
$sqlstr='select SQL_CALC_FOUND_ROWS `id`,`customer_id`,`xiadandate`,`jiedanren`,`yaoqiu`,`dingjin`,`jiaoqi`,`huokuan`,`shouqi`,`zhekou`,`chuqi`,`zhifu_way`,`record` from `wm_order_info` limit '.($page-1)*$limit.','.$limit;
$ulr='view_order_info.php?type=all&';
break;
default:
die('输入错误');
}
echo'
'.$tongjileixing.'订单统计 | |||||||||||||
订单编号 | 客户ID | 下单日期 | 接单人 | 要求 | 定金 | 交期 | 货款 | 收齐1未收齐0 | 折扣 | 出齐(0未齐1已齐) | 付款方式 | 其它 |
$view_order_path='view_order.php?id=';
include('include/connconfig.php');
include('include/fenye.php');
//echo$sqlstr;
$total=view_data_tb($sqlstr,$view_order_path);
fanye($limit,$page,$total,$ulr);
}
?>