getNumByTime($where); if ($data) { foreach ($data as $k => $v) { if ($v['num'] > 0) { $w['mid'] = $v['mid']; $w['month'] = $where['start']; $info = Dever::db('bill/sell_stat')->find($w); $w['new_num'] = $v['num']; $where['mid'] = $v['mid']; unset($where['start']); $total = Dever::db('bill/sell')->getNumByTimeOne($where); if ($total) { $w['num'] = $total['num']; } if ($info) { $w['where_id'] = $info['id']; Dever::db('bill/sell_stat')->update($w); } else { Dever::db('bill/sell_stat')->insert($w); } } } } return 'ok'; } # 区域分润 /* 区域毛利 = 区域内所有门店的采购商品的零售价总额 x 30% 城市分润 = 区域毛利 x 1% 区县分润 = 区域毛利 x 3% 街道分润 = 区域毛利 x 5% */ public function area_api() { # 获取所有代理商 $where['status'] = 2; $member = Dever::db('agent/member')->select($where); if ($member) { foreach ($member as $k => $v) { # 获取区域内门店的利润 $role = Dever::db('setting/role')->find($v['role']); $profit = $role['profit']; if (!$profit) { continue; } $temp = explode(',', $v['area']); if ($role['type'] == 2) { $area = ''; if ($role['area'] == 1 && isset($temp[1])) { # 城市 $area = $temp[0] . ',' . $temp[1]; } elseif ($role['area'] == 2 && isset($temp[2])) { # 区县 $area = $temp[0] . ',' . $temp[1] . ',' . $temp[2]; } elseif ($role['area'] == 3 && isset($temp[3])) { # 街道 $area = $temp[0] . ',' . $temp[1] . ',' . $temp[2] . ',' . $temp[3]; } if ($area) { } } } } } # 权益使用情况统计:类型、商品名、总发放数量、总使用数量 # 营业额报表:日期,订单数,确认订单数,确认订单额度,新增代理商数量 # 代理商统计:日期,新增代理商,城市代理商,区县代理商,街道代理商,创客,消客 # 资金账户统计:日期,总收入,代理费,软件服务费,赠送商品价值,直推佣金,市场培训费 }