php(niushop框架)查询本日,本月,本年日期数据
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
$endToday=mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;
if ($beginToday<=$array['a']&&$array['a']<=$endToday) {
$list1[data] =Db::view('nfx_promoter','uid,promoter_id,promoter_shop_name')->view('nfx_commission_distribution','promoter_id,order_id,goods_money,commission_rate,commission_money,is_issue,create_time','nfx_promoter.promoter_id=nfx_commission_distribution.promoter_id')->view('ns_order','order_no,finish_time,order_status,buyer_id,order_money,order_id','ns_order.order_id=nfx_commission_distribution.order_id')->view('ns_member','uid,member_name','ns_order.buyer_id=ns_member.uid')->where('nfx_promoter.uid',$uid)->where('order_status',4)->where('nfx_commission_distribution.is_issue',1)->where('create_time','between',[$beginToday,$endToday])->select();
foreach ($list1 as $key => $value) {
$point = array_sum(array_column($value,'commission_money'));
$point= Number_format($point, 2, '.','');
}
}
$startDate = mktime(0,0,0,date("m"),1,date("Y"));
$endDate = mktime(23,59,59,date('m'),date('t'),date('Y'))-1;
if ($startDate<=$array['a']&&$array['a']<=$endDate) {
$list1[data] =Db::view('nfx_promoter','uid,promoter_id,promoter_shop_name')->view('nfx_commission_distribution','promoter_id,order_id,goods_money,commission_rate,commission_money,is_issue,create_time','nfx_promoter.promoter_id=nfx_commission_distribution.promoter_id')->view('ns_order','order_no,finish_time,order_status,buyer_id,order_money,order_id','ns_order.order_id=nfx_commission_distribution.order_id')->view('ns_member','uid,member_name','ns_order.buyer_id=ns_member.uid')->where('nfx_promoter.uid',$uid)->where('order_status',4)->where('nfx_commission_distribution.is_issue',1)->where('create_time','between',[$startDate,$endDate])->select();
foreach ($list1 as $key => $value) {
$point = array_sum(array_column($value,'commission_money'));
$point= Number_format($point, 2, '.','');
}
}