设计了一个分销统计系统列表,按店铺、产品统计每年每月的分销数量,如图:
我写的代码查询出来总是空的,不知道哪里出问题了。
$y = date('Y', $value['add_time']);
if (!empty($y)) {
// 统计每月的销售量
for ($i = 0; $i < 12; $i++) {
$m = $i + 1;
$result = Db::name('fenxiao')
->where(['dpjc' => ['like', '' . $value['dpjc'] . '%'], 'cpid' => $value['cpid']])
->where('YEAR(add_time) = '.$y.'')
->where('yue', intval($i + 1))
->field('sum(week1) as wk1, sum(week2) as wk2, sum(week3) as wk3, sum(week4) as wk4')
->select();
}
}
哪位帮个忙看下,感激不尽!