$smarty->assign('service', $service_list);
// 服务记录
$smarty->assign('return', $return_list);
// 退货记录
$smarty->assign('user_friends', $user_friends);
$smarty->assign('contact_list', $contact_list);
$smarty->assign('addr_list', $addr_list);
$smarty->assign('role_id', $_SESSION['role_id'] ? $_SESSION['role_id'] : 0);
// 营销方式优选
//$smarty->assign('marketing_list', marketing_list());
// 顾客喜欢的联系方式
//$smarty->assign('marketing_checked_list', marketing_checked_list($user_id, 'marketing_name'));
$healthy_lifestyle = $smarty->fetch('healthy_file_part.htm');
$smarty->assign('healthy_lifestyle', $healthy_lifestyle);
$smarty->assign('service_time', date('Y-m-d H:i'));
$smarty->assign('deal_method', get_deal_method());
$smarty->assign('level_list', get_user_level());
$res['info'] = $smarty->fetch('users_detail.htm');
die($json->encode($res));
} elseif ($_REQUEST['act'] == 'add_users') {
/* 检查权限 */
$user = array('rank_points' => $_CFG['register_points'], 'pay_points' => $_CFG['register_points'], 'sex' => 0, 'credit_line' => 0);
// 取出注册扩展字段
$sql = 'SELECT * FROM ' . $ecs->table('reg_fields') . ' WHERE type<2 AND display=1 AND id<>6 ORDER BY dis_order, id';
$extend_info_list = $db->getAll($sql);
//是否是添加家庭成员
if (isset($_REQUEST['family_id'])) {
$family_id = intval($_REQUEST['family_id']);
$user_id = intval($_REQUEST['user_id']);
if ($family_id == 0) {
$sql_insert = 'INSERT INTO ' . $GLOBALS['ecs']->table('user_family_member') . '(user_id,family_id,add_time)VALUES(' . "{$user_id},{$user_id}," . time() . ')';
function deal_order_report()
{
$filter_type = intval($_REQUEST['fileter_type']);
$start_time = strtotime($_REQUEST['start_time']);
$end_time = strtotime($_REQUEST['end_time']);
if (!$start_time && !$end_time) {
$start_time = strtotime(date('Y-m-01 00:00:00'));
$end_time = strtotime(date('Y-m-t 23:59:59'));
}
$where = " AND o.add_time BETWEEN {$start_time} AND {$end_time}";
if (!$filter_type) {
$sql = "SELECT SUM(o.final_amount) final_amount,COUNT(*) order_num,o.admin_id,o.admin_name,o.deal_method,a.role_id,r.role_code FROM " . $GLOBALS['ecs']->table('order_info') . ' o LEFT JOIN ' . $GLOBALS['ecs']->table('admin_user') . ' a ON o.admin_id=a.user_id LEFT JOIN ' . $GLOBALS['ecs']->table('role') . ' r ON a.role_id=r.role_id ' . " WHERE o.order_type IN(4,5,6) AND o.order_status IN(5,1) AND o.shipping_status<>3 AND a.status=1 {$where} GROUP BY o.admin_id,o.deal_method ORDER BY final_amount DESC";
} else {
if ($_REQUEST['role_id']) {
$role_id = intval($_REQUEST['role_id']);
$where .= " AND o.platform={$role_id} ";
}
$sql = "SELECT SUM(o.final_amount) final_amount,COUNT(*) order_num,o.deal_method,r.role_name,r.depart_id FROM " . $GLOBALS['ecs']->table('order_info') . ' o LEFT JOIN ' . $GLOBALS['ecs']->table('role') . ' r ON o.platform=r.role_id WHERE o.order_type IN(4,5,6) AND o.order_status IN(5,1) AND o.shipping_status<>3' . " {$where} GROUP BY o.platform,o.deal_method ORDER BY final_amount DESC";
}
$res = $GLOBALS['db']->getAll($sql);
if ($res) {
$total = array('name' => '总计');
$list = array();
if (!$filter_type) {
foreach ($res as $v) {
$list[$v['admin_id']]['role_id'] = $v['role_id'];
$list[$v['admin_id']]['role_code'] = $v['role_code'];
$list[$v['admin_id']]['name'] = $v['admin_name'];
$list[$v['admin_id']]['list'][$v['deal_method']] = $v;
$total['list'][$v['deal_method']]['final_amount'] += $v['final_amount'];
$total['list'][$v['deal_method']]['order_num'] += $v['order_num'];
$total['list'][$v['deal_method']]['deal_method'] = $v['deal_method'];
$total['final_amount'] += $v['final_amount'];
}
} else {
//部门，小组
}
$res = $list;
}
array_push($res, $total);
unset($v);
$deal_method = get_deal_method();
array_push($deal_method, array('method_id' => 0, 'method_name' => '以前'));
foreach ($res as &$v) {
foreach ($v['list'] as $k => &$l) {
$l['amount_percent'] = bcdiv($l['final_amount'], $total['final_amount'], 2) * 100;
foreach ($deal_method as $m) {
if ($v['list'][$m['method_id']]) {
continue;
} else {
$v['list'][$m['method_id']] = array('order_num' => 0, 'deal_method' => $m['method_id'], 'final_amount' => 0, 'amount_percent' => 0);
}
}
}
ksort($v['list']);
}
return $res;
}
