/ -- 在线客服聊天 --> 认证失败，重新设置聊天系统的用户密码
// 聊天窗口右侧默认展示最近订单，如果想要展示商品、订单、店铺则需要在当前页面中设置隐藏域，name必须为 chat_goods_id,
// chat_order_id, chat_supp_id
/* ------------------------------------------------------ */
function action_authfail ()
{
$user_id = $_SESSION['user_id'];
$sql = "
select user_name, password, email from "
. $GLOBALS['ecs']->table('users')
. " where user_id = '$user_id'";
$row = $db->getRow($sql);
$success = create_of_user($user_id, $row['password'], $row['user_name'], $row['email'], 10, - 1);
if($success)
{
$result = array(
'
error' => 1,'message' => '可能由于网络原因，发生错误！请点击 <a href="chat
.php?act=chat"><strong>重试</strong></a> ，重新连接
...','content' => ''
);
}
else
{
$result = array(
'
error' => 1,'message' => '由于网络原因，发生错误！请点击 <a href="chat
.php?act=chat"><strong>重试</strong></a> ，重新连接
...','content' => ''
);
}
$result = json_encode($result);
exit($result);
}
/**
* 用户离线
*/
function action_off_line()
{
// 用户超过5分钟未发言则视为自动离线，更新客服状态
}
function is_telephone ($phone)
{
$chars = "/^13[0-9]{1}[0-9]{8}$|15[0-9]{1}[0-9]{8}$|18[0-9]{1}[0-9]{8}$/";
if(preg_match($chars, $phone))
{
return true;
}
}
/**
* 获取db对象
*
* @return unk
nown
*/
function get_database ()
{
return $GLOBALS['db'];
}
/**
* 获取smarty对象
*
* @return unk
nown
*/
function get_smarty ()
{
return $GLOBALS[smarty];
}
/**
* 获取ecs对象
*
* @return unk
nown
*/
function get_ecs ()
{
return $GLOBALS['ecs'];
}
/*
* 获取商品所对应店铺的店铺基本信息
* @param int $suppid 店铺id
* @param int $suppinfo 入驻商的信息
*/
function get_dianpu_baseinfo ($suppid = 0)
{
if(intval($suppid) <= 0)
{
return;
}
$sql_supplier = "
SELECT s
.supplier_id,s
.supplier_name,s
.add_time,sr
.rank_name FROM "
. $GLOBALS['ecs']->table("supplier")
. " as s left join "
. $GLOBALS['ecs']->table("supplier_rank")
. " as sr ON s
.rank_id=sr
.rank_id WHERE s
.supplier_id="
. $suppid
. " AND s
.status=1";
$supp_info = $GLOBALS['db']->getRow($sql_supplier);
$sql = "
SELECT * FROM "
. $GLOBALS['ecs']->table('supplier_shop_config')
. " WHERE supplier_id = "
. $suppid;
$shopinfo = $GLOBALS['db']->getAll($sql);
$config = array();
foreach($shopinfo as $value)
{
$config[$value['code']] = $value['value'];
}
$shop_info = array();
$shop_info['ghs_css_path'] = 'themes/'
. $config['template']
. '/images/ghs/css/ghs_style
.css'; // 入驻商所选模板样式路径
$shoplogo = empty($config['shop_logo']) ? 'themes/'
. $config['template']
. '/images/dianpu
.jpg'
: $config['shop_logo'];
$shop_info['shoplogo'] = $shoplogo; // 商家logo
$shop_info['shopname'] = htmlspecialchars($config['shop_name']); // 店铺名称
$shop_info['suppid'] = $suppid; // 商家名称
$shop_info['suppliername'] = htmlspecialchars($supp_info['supplier_name']); // 商家名称
$shop_info['userrank'] = htmlspecialchars($supp_info['rank_name']); // 商家等级
$shop_info['region'] = get_province_city($config['shop_province'], $config['shop_city']);
$shop_info['address'] = $config['shop_address'];
$shop_info['serviceqq'] = $config['qq'];
$shop_info['serviceww'] = $config['ww'];
$shop_info['serviceemail'] = $config['service_email'];
$shop_info['servicephone'] = $config['service_phone'];
$shop_info['createtime'] = gmdate('Y-m-d', $config['add_time']); // 商家创建时间
$suppid = (intval($suppid) > 0) ? intval($suppid)
: intval($_GET['suppId']);
return $shop_info;
} 构建多商户人工客服系统
本文探讨了在使用Oracle 11g数据库时，由于优化器版本问题导致的SQL语句执行错误，包括错误信息分析、原因解释以及解决方案，特别强调了修改优化器版本的方法。
扫一扫
3124
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
