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

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

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 ;

/* 订单备注*/

$_LANG['label_order_note'] = '客服人员订单备注：';

/*------------------------------------------------------ */

//-- 保存订单备注

/*------------------------------------------------------ */

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

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

删除订单时删除关联的订单备注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', '');

INSERT INTO `sumjunet`.`ecs_admin_action` (`action_id`, `parent_id`, `action_code`, `relevance`) VALUES (NULL, '136', 'agents_list', '');

INSERT INTO `sumjunet`.`ecs_admin_action` (`action_id`, `parent_id`, `action_code`, `relevance`) VALUES (NULL, '136', 'add_agents', '');

INSERT INTO `sumjunet`.`ecs_admin_action` (`action_id`, `parent_id`, `action_code`, `relevance`) VALUES (NULL, '0', 'agent_bonus_manage', '');

INSERT INTO `sumjunet`.`ecs_admin_action` (`action_id`, `parent_id`, `action_code`, `relevance`) VALUES (NULL, '139', 'agent_bonus_seach', '');

INSERT INTO `sumjunet`.`ecs_admin_action` (`action_id`, `parent_id`, `action_code`, `relevance`) VALUES (NULL, '139', 'agent_bonus_set', '');

INSERT INTO `sumjunet`.`ecs_admin_action` (`action_id`, `parent_id`, `action_code`, `relevance`) VALUES (NULL, '139', 'do_agent_bonus', '');

扩展名：

{$lang.goods_name}{$sort_goods_name}

下面增加：

{$lang.goods_name_extends}{$sort_goods_name_extends}

onclick="listTable.edit(this, 'edit_goods_name',

{$goods.goods_id})">{$goods.goods_name|escape:html}

id="goods_extends" onclick="listTable.edit_teshu(this, 'edit_goods_name_extends', {$goods.goods_id})">{$goods.goods_name_extends|escape:html} 

/languages/zh_cn/admin/goods.php

68行

$_LANG['goods_name'] = '商品名称';

下面增加

$_LANG['goods_name_extends'] = '商品名称扩展';

Themes/default/goods.dwt

217行

{$goods.goods_style_name}{$goods.goods_name_extends}