/**
* 获取用户信息数组
*
* @access public
* @param
*
* @return array $user 用户信息数组
*/
function get_user_info($id = 0)
{
if ($id == 0) {
$id = $_SESSION['user_id'];
}
$time = date('d-m-Y');
$sql = 'SELECT u.user_id, u.email, u.user_name, u.user_money, u.pay_points' . ' FROM ' . $GLOBALS['ecs']->table('users') . ' AS u ' . " WHERE u.user_id = '{$id}'";
$user = $GLOBALS['db']->getRow($sql);
$bonus = get_user_bonus($id);
$user['username'] = $user['user_name'];
$user['user_points'] = $user['pay_points'] . $GLOBALS['_CFG']['integral_name'];
$user['user_money'] = price_format($user['user_money'], false);
$user['user_bonus'] = price_format($bonus['bonus_value'], false);
return $user;
}
/**
* 获取用户中心默认页面所需的数据.
*
* @param int $user_id 用户ID
*
* @return array $info 默认页面所需资料数组
*/
function get_user_default($user_id)
{
$user_bonus = get_user_bonus();
$sql = 'SELECT pay_points, user_money, credit_line, last_login, is_validated FROM ' . $GLOBALS['ecs']->table('users') . " WHERE user_id = '{$user_id}'";
$row = $GLOBALS['db']->getRow($sql);
$info = array();
$info['username'] = stripslashes($_SESSION['user_name']);
$info['shop_name'] = $GLOBALS['_CFG']['shop_name'];
$info['integral'] = $row['pay_points'] . $GLOBALS['_CFG']['integral_name'];
/* 增加是否开启会员邮件验证开关 */
$info['is_validate'] = $GLOBALS['_CFG']['member_email_validate'] && !$row['is_validated'] ? 0 : 1;
$info['credit_line'] = $row['credit_line'];
$info['formated_credit_line'] = price_format($info['credit_line'], false);
//如果$_SESSION中时间无效说明用户是第一次登录。取当前登录时间。
$last_time = !isset($_SESSION['last_time']) ? $row['last_login'] : $_SESSION['last_time'];
if ($last_time == 0) {
$_SESSION['last_time'] = $last_time = gmtime();
}
$info['last_time'] = local_date($GLOBALS['_CFG']['time_format'], $last_time);
$info['surplus'] = price_format($row['user_money'], false);
$info['bonus'] = sprintf($GLOBALS['_LANG']['user_bonus_info'], $user_bonus['bonus_count'], price_format($user_bonus['bonus_value'], false));
$sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('order_info') . " WHERE user_id = '" . $user_id . "' AND add_time > '" . local_strtotime('-1 months') . "'";
$info['order_count'] = $GLOBALS['db']->getOne($sql);
include_once ROOT_PATH . 'includes/lib_order.php';
$sql = 'SELECT order_id, order_sn ' . ' FROM ' . $GLOBALS['ecs']->table('order_info') . " WHERE user_id = '" . $user_id . "' AND shipping_time > '" . $last_time . "'" . order_query_sql('shipped');
$info['shipped_order'] = $GLOBALS['db']->getAll($sql);
return $info;
}
/**
* 获取用户中心默认页面所需的数据
*
* @access public
* @param int $user_id 用户ID
*
* @return array $info 默认页面所需资料数组
*/
function get_user_default($user_id)
{
$user_bonus = get_user_bonus();
$paystatus = PS_PAYED;
$sql = "SELECT pay_points, user_money, head_img, credit_line, last_login, is_validated, phonestatus, emailstatus, idcardstatus, bangcardstatus FROM " . $GLOBALS['ecs']->table('users') . " WHERE user_id = '{$user_id}'";
$row = $GLOBALS['db']->getRow($sql);
$info = array();
$info['username'] = stripslashes($_SESSION['user_name']);
$info['shop_name'] = $GLOBALS['_CFG']['shop_name'];
$info['integral'] = $row['pay_points'] . $GLOBALS['_CFG']['integral_name'];
$info['phonestatus'] = $row['phonestatus'];
$info['emailstatus'] = $row['emailstatus'];
$info['idcardstatus'] = $row['idcardstatus'];
$info['bangcardstatus'] = $row['bangcardstatus'];
$info['user_head_img'] = empty($row['head_img']) ? '0' : $row['head_img'];
/* 增加是否开启会员邮件验证开关 */
$info['is_validate'] = $GLOBALS['_CFG']['member_email_validate'] && !$row['is_validated'] ? 0 : 1;
$info['credit_line'] = $row['credit_line'];
$info['formated_credit_line'] = price_format($info['credit_line'], false);
//如果$_SESSION中时间无效说明用户是第一次登录。取当前登录时间。
$last_time = !isset($_SESSION['last_time']) ? $row['last_login'] : $_SESSION['last_time'];
if ($last_time == 0) {
$_SESSION['last_time'] = $last_time = gmtime();
}
$info['last_time'] = local_date($GLOBALS['_CFG']['time_format'], $last_time);
$info['surplus'] = price_format($row['user_money'], false);
$info['frozen'] = price_format($row['frozen_money'], false);
$info['bonus'] = sprintf($GLOBALS['_LANG']['user_bonus_info'], $user_bonus['bonus_count'], price_format($user_bonus['bonus_value'], false));
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_goods') . " WHERE user_id = '" . $user_id . "' AND add_time > '" . local_strtotime('-1 months') . "'";
$info['order_count'] = $GLOBALS['db']->getOne($sql);
/* 理财资产*/
$sqlsum = "SELECT SUM(invest_price) FROM " . $GLOBALS['ecs']->table('order_goods') . " where pay_status =" . $paystatus . " and user_id =" . $user_id;
$info['order_sum'] = $GLOBALS['db']->getOne($sqlsum);
$info['order_sum'] = empty($info['order_sum']) ? '0.00' : $info['order_sum'];
/* 借款负债*/
//$sqlborrow = "SELECT SUM(borrow_num) FROM ".$GLOBALS['ecs']->table('user_borrow')." where borrow_status = 1 and user_id =".$user_id;
//$info['borrow_sum'] = $GLOBALS['db']->getOne($sqlborrow);
//$info['borrow_sum'] = empty($info['borrow_sum'])?'0.00':$info['borrow_sum'];
/* 账户净资产*/
$info['account_sum'] = $info['order_sum'] - $info['borrow_sum'] + $info['surplus'];
$info['account_sum'] = empty($info['account_sum']) ? '0.00' : $info['account_sum'];
include_once ROOT_PATH . 'includes/lib_order.php';
$sql = "SELECT order_id, order_sn " . " FROM " . $GLOBALS['ecs']->table('order_info') . " WHERE user_id = '" . $user_id . "' AND shipping_time > '" . $last_time . "'" . order_query_sql('shipped');
$info['shipped_order'] = $GLOBALS['db']->getAll($sql);
return $info;
}
/**
* 获取用户信息数组
*
* @access public
* @param
*
* @return array $user 用户信息数组
*/
function get_user_info($id = 0)
{
if ($id == 0) {
$id = $_SESSION['user_id'];
}
$time = date('Y-m-d');
$user = M('users')->field(array('user_id', 'email', 'user_name', 'user_money', 'pay_points'))->where(array('user_id' => $id))->find();
$bonus = get_user_bonus($id);
$user['username'] = $user['user_name'];
$user['user_points'] = $user['pay_points'] . $GLOBALS['_CFG']['integral_name'];
$user['user_money'] = price_format($user['user_money'], false);
$user['user_bonus'] = price_format($bonus['bonus_value'], false);
return $user;
}
/**
* 获取用户中心默认页面所需的数据
*
* @access public
* @param int $user_id 用户ID
*
* @return array $info 默认页面所需资料数组
*/
function get_user_default($user_id)
{
$user_bonus = get_user_bonus();
$sql = "SELECT pay_points, user_money, credit_line, last_login, is_validated, mobile_phone FROM " . $GLOBALS['ecs']->table('users') . " WHERE user_id = '{$user_id}'";
$info = $GLOBALS['db']->getRow($sql);
//$info = array();
$info['username'] = stripslashes($_SESSION['user_name']);
$info['shop_name'] = $GLOBALS['_CFG']['shop_name'];
$info['integral'] = $info['pay_points'];
//不显示"积分" by wang
/* 增加是否开启会员邮件验证开关 */
//$info['is_validate'] = ($GLOBALS['_CFG']['member_email_validate'] && !$row['is_validated'])?0:1;
//$info['credit_line'] = $row['credit_line'];
$info['formated_credit_line'] = price_format($info['credit_line'], false);
//如果$_SESSION中时间无效说明用户是第一次登录。取当前登录时间。
$last_time = !isset($_SESSION['last_time']) ? $info['last_login'] : $_SESSION['last_time'];
if ($last_time == 0) {
$_SESSION['last_time'] = $last_time = gmtime();
}
$info['last_time'] = local_date($GLOBALS['_CFG']['time_format'], $last_time);
$info['surplus'] = $info['user_money'];
//不显示价格格式 by wang
$info['bonus'] = $user_bonus['bonus_count'];
//不是红包格式 //by wang
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_info') . " WHERE user_id = {$user_id} AND order_status = " . OS_CONFIRMED . " AND shipping_status != " . SS_RECEIVED;
$info['order_count'] = $GLOBALS['db']->getOne($sql);
/*include_once(ROOT_PATH . 'include/lib_order.php');
$sql = "SELECT order_id, order_sn ".
" FROM " .$GLOBALS['ecs']->table('order_info').
" WHERE user_id = '" .$user_id. "' AND shipping_time > '" .$last_time. "'". order_query_sql('shipped');
$info['shipped_order'] = $GLOBALS['db']->getAll($sql);*/
return $info;
}
