服务报价 | 域名主机 | 网络营销 | 软件工具| [加入收藏]
 热线电话: #
当前位置: 主页 > php教程 > ecshop教程 >

ecshop支付宝自动发货接口

时间:2012-09-13 09:35来源:未知 作者:最模板 点击:
一、 在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_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行开始
/**
 * 修改订单的支付状态
 *
 * @access public
 * @param   string $log_id     支付编号
 * @param   integer $pay_status 状态
 * @param   string $note       备注
 * @param   string $trade_no   支付宝交易号
 * @return void
 */
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文件  

 

(责任编辑:最模板)
顶一下
(3)
100%
踩一下
(0)
0%
------分隔线----------------------------