当前位置：文档之家› 2_ECSHOP后台为订单增加备注功能

2_ECSHOP后台为订单增加备注功能

ECSHOP后台为订单增加备注功能

1. 添加表:ecs_order_note;

CREATE TABLE IF NOT EXISTS `ecs_order_note` (

`note_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

`order_id` mediumint(8) unsigned NOT NULL,

`note_value` text 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); //echo "订单备注已保存!";

}

在以下代码下加入

/* 取得能执行的操作列表 */

$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);

5.修改admin\templates\order_info.htm文件，

{$bel_action_note}

在上面代码后面加入以下代码：

{$bel_order_note}

<p>onblur="saveOrderNote({$smarty.request.order_id},this)">{$order_note}

在本文件admin\templates\order_info.htm的JS代码中加入下面内容

/**

* 保存订单备注

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);

}

删除订单时删除关联的订单备注admin/order.php

找到下面代码：

/* 删除订单 */

$db->query("DELETE FROM ".$ecs->table('order_info'). " WHERE order_id =

'$order_id'");

$db->query("DELETE FROM ".$ecs->table('order_goods'). " WHERE order_id =

'$order_id'");

$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'");

批量删除，找到以下代码：约3000行后面

/* 删除订单 */

$db->query("DELETE FROM ".$ecs->table('order_info'). " WHERE order_id =

'$order[order_id]'");

$db->query("DELETE FROM ".$ecs->table('order_goods'). " WHERE order_id =

'$order[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]'");

在以下代码

$GLOBALS['db']->query("DELETE FROM ".$GLOBALS['ecs']->table('order_info'). " WHERE

order_id = '$order_id'");

$GLOBALS['db']->query("DELETE FROM ".$GLOBALS['ecs']->table('order_goods'). " WHERE

order_id = '$order_id'");

$GLOBALS['db']->query("DELETE FROM ".$GLOBALS['ecs']->table('order_action'). " WHERE

order_id = '$order_id'");

后面加入以下代码 /*根据订单编号，删除对应订单备注*/

$GLOBALS['db']->query("DELETE FROM ".$GLOBALS['ecs']->table('order_note'). " WHERE

order_id = '$order_id'");

增加邮件模板

ecs_mail_templates

插入一条记录：

\languages\zh_cn\admin\mail_template.php

$_LANG['recomment'] = '用户评论回复模板';

在此后面加入以下内容

$_LANG['agent_bonus'] = '代理商支付费用模板';

INSERT INTO `sumjunet`.`ecs_admin_action` (`action_id`, `parent_id`,

`action_code`, `relevance`) VALUES (NULL, '0', 'agents_manage', '');