ECSHOP后台增加订单备注功能
日期:2018-07-20
1、登录ECSHOP后台,SQL查询提交以下语句,添加表:ecs_order_note;
CREATE TABLE IF NOT EXISTS `ecs_order_note` ( `note_id` int(10) NNULLTO_INCREMENT, `order_id` varchar(20) CHARACTER SET utf8 NOT NULL, `note_value` text CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`note_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;2、添加语言代码,打开languages\zh_cn\admin\order.php文件,加入如下代码
$_LANG['label_order_note'] = '管理员订单备注:';3、修改admin/order.php文件第103行,添加代码:
/* 保存订单备注 */
elseif ($_REQUEST['act'] == 'save_ordernote')
{
$oid = $_REQUEST['oid'];
$oval = $_REQUEST['noteVal'];
$sql = "SELECT count(note_value) FROM " . $ecs->table('order_note') .
" WHERE order_id = $oid";
$note_count = $db->getOne($sql);
if ($note_count == 0)
{
$sql = "insert into " . $ecs->table('order_note') .
"(order_id,note_value) values(" . $oid . ",'" . $oval . "')";
}
else
{
$sql = "UPDATE " . $ecs->table('order_note') . " SET note_value = '" . $oval .
"' WHERE order_id = " . $oid;
}
$db->query($sql);
}
继续找到以下代码:
/* 取得能执行的操作列表 */
$operable_list = operable_list($order);
$smarty->assign('operable_list', $operable_list);
以上代码下面加入以下代码:
$sql = "SELECT note_value FROM " . $ecs->table('order_note') .
" WHERE order_id = '$order[order_id]'";
$order_note = $db->getOne($sql);
$smarty->assign('order_note', $order_note);
4、打开admin\templates\order_info.htm文件,找到如下代码:
<tr>
<td><div align="right"><strong>{$lang.label_action_note}</strong></div></td>
<td colspan="5"><textarea name="action_note" cols="80" rows="3"></textarea></td>
</tr>
<tr>
在上面代码下面加入以下代码:
<tr>
<td><div align="right"><strong>{$lang.label_order_note}</strong></div></td>
<td colspan="5">
<textarea name="order_note" cols="80" rows="3" onblur="saveOrderNote({$smarty.request.order_id},this)">{$order_note}</textarea>
</td>
</tr>
继续找到如下代码:
</script>
{/literal}
在上面代码上面加入以下代码:
function saveOrderNote(oid,parm)
{
var noteVal = parm.value;
Ajax.call('order.php?is_ajax=1&act=save_ordernote&oid='+oid+'¬eVal='+noteVal,'', saveOrderResponse, 'POST', '');
}
function saveOrderResponse(result)
{
//alert(result);
}
5、打开admin\order.php文件,找到如下代码:
$db->query("DELETE FROM ".$ecs->table('order_action'). " WHERE order_id = '$order_id'");
在上面代码下面加入以下代码:
$db->query("DELETE FROM " .$ecs->table('order_note') . " WHERE order_id = '$order_id'");
继续找到如下代码:
$db->query("DELETE FROM ".$ecs->table('order_action'). " WHERE order_id = '$order[order_id]'");
在上面代码下面加入以下代码:
$db->query("DELETE FROM " .$ecs->table('order_note') . " WHERE order_id = '$order[order_id]'");本文原创地址:https://ecshopok.com/article-395.html
版权所有 © 转载时必须以链接形式注明出处!
觉得本文对您有用,想收藏下来!方法很简单:请点击-〉
我们一直坚持白天工作、晚上熬夜更新资源,付出了巨大的精力和时间,其中的辛酸难以言述。




暂无评论,来发表一个吧