php(niushop框架)查询本日，本月，本年日期数据

最新推荐文章于 2024-05-08 00:38:30 发布

码农挚友

最新推荐文章于 2024-05-08 00:38:30 发布

阅读量173

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/weixin_42012939/article/details/114016504

版权

PHP 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

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, '.','');
		}
		
	}