function get_total_money_by_user_id($user_id, $is_separate)
{
$up_uid = "'{$user_id}'";
$all_uid = '';
for ($i = 1; $i <= 3; $i++) {
if ($up_uid) {
$sql = "SELECT user_id FROM " . $GLOBALS['ecs']->table('users') . " WHERE parent_id IN({$up_uid})";
$query = $GLOBALS['db']->query($sql);
$up_uid = '';
while ($rt = $GLOBALS['db']->fetch_array($query)) {
$up_uid .= $up_uid ? ",{$rt['user_id']}" : "{$rt['user_id']}";
}
if ($up_uid) {
$all_uid .= $up_uid . ",";
}
}
}
$uids = rtrim($all_uid, ',');
if (!empty($uids)) {
//$sql = "select order_id,user_id,total_money from (select a.order_id,a.user_id,sum(split_money*goods_number) as total_money from " . $GLOBALS['ecs']->table('order_info') . " as a ," . $GLOBALS['ecs']->table('order_goods') . " as b where a.order_id = b.order_id and a.user_id in($uids) and is_separate = '$is_separate' group by a.order_id ) as ab where total_money > 0";
$sql = "select a.order_id,a.user_id,sum(split_money*goods_number) as total_money from " . $GLOBALS['ecs']->table('order_info') . " as a ," . $GLOBALS['ecs']->table('order_goods') . " as b where a.order_id = b.order_id and a.user_id in({$uids}) and is_separate = '{$is_separate}' group by a.order_id";
$order_ids = $GLOBALS['db']->getAll($sql);
if (!empty($order_ids)) {
$total_money = 0;
$affiliate = unserialize($GLOBALS['_CFG']['affiliate']);
for ($j = 0; $j < count($order_ids); $j++) {
$split_money = $order_ids[$j]['total_money'];
if ($split_money > 0) {
$level = get_level_user($user_id, $order_ids[$j]['user_id']);
$num = count($affiliate['item']);
for ($k = 0; $k < $num; $k++) {
if ($level == $k + 1) {
$a = (double) $affiliate['item'][$k]['level_money'];
if ($affiliate['config']['level_money_all'] == 100) {
$total_money += $split_money;
} else {
if ($a) {
$a /= 100;
}
$total_money += round($split_money * $a, 2);
}
}
}
}
}
}
}
if ($total_money > 0) {
return $total_money;
} else {
return 0;
}
}
if ($is_distribor != 1) {
show_message('您还不是分销商！', '去首页', 'index.php');
exit;
}
if (!$smarty->is_cached('v_user_huiyuan_list.dwt', $cache_id)) {
assign_template();
$position = assign_ur_here();
$smarty->assign('page_title', $position['title']);
// 页面标题
$smarty->assign('ur_here', $position['ur_here']);
// 当前位置
/* meta information */
$smarty->assign('keywords', htmlspecialchars($_CFG['shop_keywords']));
$smarty->assign('description', htmlspecialchars($_CFG['shop_desc']));
$user_id = intval($_REQUEST['user_id']);
$level = get_level_user($_SESSION['user_id'], $user_id);
if ($level == 0) {
show_message('您没有权限查看此会员分成订单信息');
}
$user_info = get_user_info_by_user_id($user_id);
//用户信息，包括昵称和头像
$smarty->assign('user_info', $user_info);
/* 初始化分页信息 */
$page = isset($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
$size = isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0 ? intval($_REQUEST['page_size']) : 10;
$count = get_affiliate_count_by_user_id($user_id);
$max_page = $count > 0 ? ceil($count / $size) : 1;
if ($page > $max_page) {
$page = $max_page;
}
$smarty->assign('order_list', get_affiliate_info_by_user_id($user_id, $page, $size));
