修改方法
1.将orders_id字段改为VARCHAR型,这样order_id可以不仅仅是数字了,将以下sql导入数据库
[sql]
ALTER TABLE `orders` CHANGE `orders_id` `orders_id` VARCHAR( 64 ) NOT NULL ;
ALTER TABLE `orders_products` CHANGE `orders_id` `orders_id` VARCHAR( 64 ) NOT NULL ;
ALTER TABLE `orders_products_attributes` CHANGE `orders_id` `orders_id` VARCHAR( 64 ) NOT NULL ;
ALTER TABLE `orders_products_download` CHANGE `orders_id` `orders_id` VARCHAR( 64 ) NOT NULL ;
ALTER TABLE `orders_status_history` CHANGE `orders_id` `orders_id` VARCHAR( 64 ) NOT NULL ;
ALTER TABLE `orders_total` CHANGE `orders_id` `orders_id` VARCHAR( 64 ) NOT NULL ;
[/sql]
2.打开includes\classes\order.php
查找
function create($zf_ot_modules, $zf_mode = 2) {
global $db;
其下增加
$order_prefix='LN_'; //站群可以作为每个站订单前缀唯一识别符
$order_time=date('YmdHis'); //时间
$order_rand='_'.rand(1000,9000); //随机数
$order_number=$order_prefix.$order_time.$order_rand;
这里时间精确到秒,且加上4位随机数,从而保证订单号绝对不会重复
查找