您现在的位置是:首页 > cms教程 > ecshop商城教程ecshop商城教程
ecshop数据库订单状态判断
安蕾2023-12-21 22:01:59ecshop商城教程已有19人查阅
导读order_info 表 刚下完订单 order_status 0 shipping_status 0 pay_status 0 取消 order_status 2
ecshop数据库订单状态判断
order_info 表 刚下完订单 order_status 0 shipping_status 0 pay_status 0 取消 order_status 2 shipping_status 0 pay_status 0 确认 order_status 1 shipping_status 0 pay_status 0 已付款 order_status 1 shipping_status 0 pay_status 2 配货中 order_status 1 shipping_status 3 pay_status 2 已发货 order_status 5 shipping_status 1 pay_status 2 已收货 order_status 5 shipping_status 2 pay_status 2 退货 order_status 4 shipping_status 0 pay_status 0 /* 订单状态 */ define(‘OS_UNCONFIRMED’, 0); // 未确认 define(‘OS_CONFIRMED’, 1); // 已确认 define(‘OS_CANCELED’, 2); // 已取消 define(‘OS_INVALID’, 3); // 无效 define(‘OS_RETURNED’, 4); // 退货 /* 支付类型 */ define(‘PAY_ORDER’, 0); // 订单支付 define(‘PAY_SURPLUS’, 1); // 会员预付款 /* 配送状态 */ define(‘SS_UNSHIPPED’, 0); // 未发货 define(‘SS_SHIPPED’, 1); // 已发货 define(‘SS_RECEIVED’, 2); // 已收货 define(‘SS_PREPARING’, 3); // 备货中 /* 支付状态 */ define(‘PS_UNPAYED’, 0); // 未付款 define(‘PS_PAYING’, 1); // 付款中 define(‘PS_PAYED’, 2); // 已付款 $_LANG['os'][OS_UNCONFIRMED] = ‘未确认’;0 $_LANG['os'][OS_CONFIRMED] = ‘已确认’;1 $_LANG['os'][OS_CANCELED] = ‘ 取消‘;2 $_LANG['os'][OS_INVALID] = ‘无效‘;3 $_LANG['os'][OS_RETURNED] = ‘退货‘;4 $_LANG['ss'][SS_UNSHIPPED] = ‘未发货’; $_LANG['ss'][SS_PREPARING] = ‘配货中’; $_LANG['ss'][SS_SHIPPED] = ‘已发货’; $_LANG['ss'][SS_RECEIVED] = ‘收货确认’; $_LANG['ps'][PS_UNPAYED] = ‘未付款’; $_LANG['ps'][PS_PAYING] = ‘付款中’; $_LANG['ps'][PS_PAYED] = ‘已付款’; 订单的处理判断 while ($row = $GLOBALS['db']->fetchRow($res)) { // if ($row['order_status'] == OS_UNCONFIRMED) { $row['handler'] = "<a href=\"user.php?act=cancel_order&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_cancel']."')) return false;\">".$GLOBALS['_LANG']['cancel']."</a>"; } else if ($row['order_status'] == OS_CONFIRMED) { /* 对配送状态的处理 */ if ($row['shipping_status'] == SS_SHIPPED) { @$row['handler'] = "<a href=\"user.php?act=affirm_received&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_received']."')) return false;\">".$GLOBALS['_LANG']['received']."</a>"; } elseif ($row['shipping_status'] == SS_RECEIVED) { @$row['handler'] = '<span style="color:red">'.$GLOBALS['_LANG']['ss_received'] .'</span>'; } else { if ($row['pay_status'] == PS_UNPAYED) { @$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. '">' .$GLOBALS['_LANG']['pay_money']. '</a>'; } else { @$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. '">' .$GLOBALS['_LANG']['view_order']. '</a>'; } } } else { $row['handler'] = '<span style="color:red">'.$GLOBALS['_LANG']['os'][$row['order_status']] .'</span>'; }
order_info 表 刚下完订单 order_status 0 shipping_status 0 pay_status 0 取消 order_status 2 shipping_status 0 pay_status 0 确认 order_status 1 shipping_status 0 pay_status 0 已付款 order_status 1 shipping_status 0 pay_status 2 配货中 order_status 1 shipping_status 3 pay_status 2 已发货 order_status 5 shipping_status 1 pay_status 2 已收货 order_status 5 shipping_status 2 pay_status 2 退货 order_status 4 shipping_status 0 pay_status 0 /* 订单状态 */ define(‘OS_UNCONFIRMED’, 0); // 未确认 define(‘OS_CONFIRMED’, 1); // 已确认 define(‘OS_CANCELED’, 2); // 已取消 define(‘OS_INVALID’, 3); // 无效 define(‘OS_RETURNED’, 4); // 退货 /* 支付类型 */ define(‘PAY_ORDER’, 0); // 订单支付 define(‘PAY_SURPLUS’, 1); // 会员预付款 /* 配送状态 */ define(‘SS_UNSHIPPED’, 0); // 未发货 define(‘SS_SHIPPED’, 1); // 已发货 define(‘SS_RECEIVED’, 2); // 已收货 define(‘SS_PREPARING’, 3); // 备货中 /* 支付状态 */ define(‘PS_UNPAYED’, 0); // 未付款 define(‘PS_PAYING’, 1); // 付款中 define(‘PS_PAYED’, 2); // 已付款 $_LANG['os'][OS_UNCONFIRMED] = ‘未确认’;0 $_LANG['os'][OS_CONFIRMED] = ‘已确认’;1 $_LANG['os'][OS_CANCELED] = ‘ 取消‘;2 $_LANG['os'][OS_INVALID] = ‘无效‘;3 $_LANG['os'][OS_RETURNED] = ‘退货‘;4 $_LANG['ss'][SS_UNSHIPPED] = ‘未发货’; $_LANG['ss'][SS_PREPARING] = ‘配货中’; $_LANG['ss'][SS_SHIPPED] = ‘已发货’; $_LANG['ss'][SS_RECEIVED] = ‘收货确认’; $_LANG['ps'][PS_UNPAYED] = ‘未付款’; $_LANG['ps'][PS_PAYING] = ‘付款中’; $_LANG['ps'][PS_PAYED] = ‘已付款’; 订单的处理判断 while ($row = $GLOBALS['db']->fetchRow($res)) { // if ($row['order_status'] == OS_UNCONFIRMED) { $row['handler'] = "<a href=\"user.php?act=cancel_order&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_cancel']."')) return false;\">".$GLOBALS['_LANG']['cancel']."</a>"; } else if ($row['order_status'] == OS_CONFIRMED) { /* 对配送状态的处理 */ if ($row['shipping_status'] == SS_SHIPPED) { @$row['handler'] = "<a href=\"user.php?act=affirm_received&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_received']."')) return false;\">".$GLOBALS['_LANG']['received']."</a>"; } elseif ($row['shipping_status'] == SS_RECEIVED) { @$row['handler'] = '<span style="color:red">'.$GLOBALS['_LANG']['ss_received'] .'</span>'; } else { if ($row['pay_status'] == PS_UNPAYED) { @$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. '">' .$GLOBALS['_LANG']['pay_money']. '</a>'; } else { @$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. '">' .$GLOBALS['_LANG']['view_order']. '</a>'; } } } else { $row['handler'] = '<span style="color:red">'.$GLOBALS['_LANG']['os'][$row['order_status']] .'</span>'; }
本文标签:
很赞哦! (2)
暂无内容 |
暂无内容 |
相关文章
暂无内容 |
暂无内容 |
随机图文
ecshop商品分类页怎么增加显示商品货号SN
ECSHOP商品列表页如何增加货号即SN。默认情况下在商品列表页也就是category.php以及search.php页面是不显示货号的,但是有时候为了便于区别ecshop删除Powered by ecshop版权实例
去掉头部TITLE部分的ECSHOP演示站 Powered by ecshop 前者在后台商店设置 - 商店标题修改 后者打开includes/lib_main.phpecshop实现用户名或Email都能登陆的修改方法
相信很多使用ECSHOP的朋友都想要这个功能,网上也有很多类似的修改教程。下面说一下我的方法,也比较简单,已在ECSHOP2.7.2版测试通过。ecshop支持QQ支付宝微博快捷登录插件
亲自测试可以使用,分享给大家。(承接各种EcShop改版,二次开发等相关项目) 安装的时候按照里面说明。安装即可。
留言与评论 (共有 0 条评论) |