广州传奇网络

地址:广州市天河区东圃大马路富华楼C座

电话:13808825895

邮箱:gz020wbs@163.com

QQ:1564443073

网址:http://www.020wbs.com/

首页 > 二次开发Ecshop二次开发 > ecshop后台订单留言的一个bug

二次开发Ecshop二次开发

二次开发Ecshop二次开发

ecshop后台订单留言的一个bug

 ECSHOP后台订单[发送/查看留言],管理员的“mailto”链接为空。原因是后台发送留言时,管理员email没有插入feedback表。

管理员的“mailto”链接为空

解决办法:编辑/admin/user_msg.php插入和查询留言的SQL语句

/*------------------------------------------------------ */
//-- 发送留言
/*------------------------------------------------------ */
if ($_REQUEST['act'] == 'add')
{
$user_id = empty($_GET['user_id']) ? 0 : intval($_GET['user_id']);
$order_id = empty($_GET['order_id']) ? 0 : intval($_GET['order_id']);
$order_sn = $db->getOne("SELECT order_sn FROM " . $ecs->table('order_info') . " WHERE order_id = '$order_id'");

/* 获取关于订单所有信息 */
$sql = "SELECT msg_id, user_name, user_email, msg_title, msg_type, msg_time, msg_content".
" FROM " . $ecs->table('feedback').
" WHERE user_id ='$user_id' AND order_id = '$order_id'";

$msg_list = $db->getAll($sql);
foreach($msg_list as $key=>$val)
{
$msg_list[$key]['msg_time'] = local_date($GLOBALS['_CFG']['time_format'], $val['msg_time']);
}

assign_query_info();
$smarty->assign('ur_here', sprintf($_LANG['msg_for_order'], $order_sn));
$smarty->assign('action_link', array('text'=>$_LANG['order_detail'], 'href'=>'order.php?act=info&order_id=' . $order_id));
$smarty->assign('msg_list', $msg_list);
$smarty->assign('order_id', $_GET['order_id']);
$smarty->assign('user_id', $_GET['user_id']);
$smarty->display('msg_add.htm');
}

if ($_REQUEST['act'] == 'insert')
{
$admin_email = $db->GetOne('SELECT email FROM ' . $ecs->table('admin_user') . " WHERE user_id = '" . $_SESSION['admin_id'] . "'");

$sql = "INSERT INTO " . $ecs->table('feedback') . "(parent_id, user_id, user_name, user_email, msg_title, msg_type, msg_content, msg_time, message_img, order_id)" .
" VALUES (0, '$_POST[user_id]', '$_SESSION[admin_name]', '$admin_email', ".
" '$_POST[msg_title]', 5, '$_POST[msg_content]', '" . gmtime() . "', '', '$_POST[order_id]')";

$db->query($sql);

ecs_header("Location: user_msg.php?act=add&order_id=$_POST[order_id]&user_id=$_POST[user_id]\n");
exit;
}