ecshop 支付宝自动发货接口

一、在数据库order_info中添加trade_no字段

SQL语句:ALTER TABLE `ec_order_info` ADD COLUMN `trade_no`varchar(100) NOT NULL DEFAULT ” AFTER `pay_name`;二、修改includes/modules/payment/alipay.php文件查找:$order_sn = trim($order_sn);代码之下添加:$trade_no = trim($_GET[‘trade_no’]);//获取支付宝交易号查找:if ($_GET[‘trade_status’] == ‘WAIT_SELLER_SEND_GOODS’) { /*改变订单状态 */ order_paid($order_sn, 2);修改:if ($_GET[‘trade_status’] == ‘WAIT_SELLER_SEND_GOODS’) { /*改变订单状态 */ order_paid($order_sn, 2,”,$trade_no);三、修改includes/lib_payment.php文件原文件118行开始/***修改订单的支付状态** @accesspublic* @param string$log_id支付编号* @param integer $pay_status状态* @param string$note备注* @param string$trade_no支付宝交易号* @returnvoid*/function order_paid($log_id, $pay_status = PS_PAYED, $note = ”,$trade_no = ”){ /*取得支付编号 */ $log_id = intval($log_id); if ($log_id > 0) { /*取得要修改的支付记录信息 */ $sql = "SELECT * FROM " . $GLOBALS[‘ecs’]->table(‘pay_log’) . " WHERE log_id = ‘$log_id’"; $pay_log = $GLOBALS[‘db’]->getRow($sql); if ($pay_log && $pay_log[‘is_paid’] == 0) { /*修改此次支付操作的状态为已付款 */ $sql = ‘UPDATE ‘ . $GLOBALS[‘ecs’]->table(‘pay_log’) . " SET is_paid = ‘1’ WHERE log_id = ‘$log_id’"; $GLOBALS[‘db’]->query($sql); /*根据记录类型做相应处理 */ if ($pay_log[‘order_type’] == PAY_ORDER) { /*取得订单信息 */ $sql = ‘SELECT order_id, user_id, order_sn, trade_no,consignee, address, tel, shipping_id, extension_code, extension_id, goods_amount ‘ . ‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘order_info’) . " WHERE order_id = ‘$pay_log[order_id]’"; $order = $GLOBALS[‘db’]->getRow($sql); $order_id = $order[‘order_id’]; $order_sn = $order[‘order_sn’]; /*解决订单修改后多次付款发货确认*/ $trade = $order[‘trade_no’]; if (!empty($trade)) { $trade_no = $trade.",".$trade_no; } /*修改订单状态为已付款 */ $sql = ‘UPDATE ‘ . $GLOBALS[‘ecs’]->table(‘order_info’) . " SET order_status = ‘" . OS_CONFIRMED . "’, " . " confirm_time = ‘" . gmtime() . "’, " . " pay_status = ‘$pay_status’, " . " pay_time = ‘".gmtime()."’, " . " money_paid = order_amount," ." trade_no = ‘$trade_no’,".//更新支付宝交易号 " order_amount = 0 ". "WHERE order_id = ‘$order_id’"; $GLOBALS[‘db’]->query($sql);四、修改admin/order.php文件查找: $smarty->assign(‘action_list’, $act_list); /* 模板赋值 */ $smarty->assign(‘delivery_order’, $delivery_order); $smarty->assign(‘goods_list’, $goods_list);$smarty->assign(‘delivery_id’, $delivery_id); //发货单id代码之上添加: /*判断支付方式是否支付宝*/ $alipay = false; $order = order_info($delivery_order[‘order_id’]);//根据订单ID查询订单信息,返回数组$order $payment = payment_info($order[‘pay_id’]); //取得支付方式信息 if($payment[‘pay_code’] == "alipay" && $delivery_order[‘status’] == 2 && !empty($order[‘trade_no’])) { $alipay = true; } $smarty->assign(‘alipay’, $alipay);五、修改admin\templates\delivery_info.htm文件查找: <form action="order.php" method="post" name="theForm">替换:<form {if $alipay}onSubmit="this.target=’_blank’;this.action=’alipay_delivery.php’;this.submit();this.target=’_self’;this.action=’order.php’"{else}action="order.php"{/if} method="post" name="theForm">六、上传alipay_delivery.php文件到admin目录下

alipay_delivery.php文件见附件

人的一生要疯狂一次,无论是为一个人,一段情,一段旅途,或一个梦想。

ecshop 支付宝自动发货接口

相关文章:

你感兴趣的文章:

标签云: