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

ECSHOP后台为订单增加备注功能 添加表:ecs_order_note; CREATE TABLE IF NOT EXISTS `ecs_order_note` ( `note_id` int(10) NOT NULL AUTO_INCREMENT, `order_id` varchar(20) CHARACTER SET gbk NOT NULL, `note_value` text CHARACTER SET gbk NOT NULL, PRIMARY KEY (`note_id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk 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 订单备注已保存!; } 4. 在以下代码下加入 /* 取得能执行的操作列表 */ $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文件， tr tddiv align=rightstrong{$lang.label_action_note}/strong/div/td td colspan=5textarea name=action_note cols=80 rows=3/textarea/td /tr tr 在上面代码后面加入以下代码： tr tddiv align=rightstrong{$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 在本文件admin\templates\order_info.htm的JS代码中加入下面内容 /** * 保存订单备注 */ functi