other|钱海物流接口上传运单号开发

最新推荐文章于 2024-09-20 12:00:00 发布

lolgigeo

最新推荐文章于 2024-09-20 12:00:00 发布

阅读量528

点赞数

分类专栏： other 文章标签：钱海支付物流上传

本文链接：https://blog.csdn.net/lolgigeo/article/details/88865554

版权

other 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

当使用钱海支付通道进行支付成功之后，如果订单发货后则变更为completed，这个时候需要把对应订单的物流单号及平台上传到钱海后台，这样才能允许该笔订单资金的提取。没有这个运单号或者失败，则无法代表发货了或者客户收到货，在处理争议以及处理提现的时候都会出现问题。

而上传物流单号则是通过物流的api上传的，经过研究得出一下示例代码，具体如下：

<?php
/*
    表sales_flat_order新加状态字段logitstatu,默认是0
ALTER TABLE `sales_flat_order` ADD COLUMN `logitstatu` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'oc_shipping';

*/
set_time_limit(0);
$dir = dirname(dirname(__FILE__));
require_once($dir .'/app/Mage.php');
//require_once($dir .'/vendor/autoload.php');

umask(0);
Mage::app();

define("ACCOUNT", "****");
define("TERMINAL", "****");
define("SECURE_CODE", "****");
define("BILL_API", "https://query.oceanpayment.com/service/check/normal");
define("OC_API", "https://query.oceanpayment.com/service/uploadTrackingNo");


$read =Mage::getSingleton("core/resource")->getConnection('core_read');
$write=Mage::getSingleton("core/resource")->getConnection('core_write');
$datetimes=date('Y-m-d',strtotime("-30 day"));
$datetimes="2018-12-25 00:00:00";

$sql="SELECT a.entity_id,a.increment_id,a.logitstatu,b.parent_id,b.method FROM `sales_flat_order` as a LEFT JOIN `sales_flat_order_payment` as b ON a.entity_id=b.parent_id WHERE a.logitstatu=0 AND a.created_at>'{$datetimes}' AND a.status='complete' AND b.method='oceanpayment_creditcard' ORDER BY a.entity_id ASC;";
$result=$read->fetchAll($sql);
foreach($result as $k=>$v){
    $singValue=ACCOUNT.TERMINAL.$v['increment_id'].SECURE_CODE;
    $singValue=hash("sha256", $singValue);

    $ordata=array(
        "account" =>ACCOUNT,
        "terminal" =>TERMINAL,
        "signValue" => $singValue,
        "order_number" =>$v['increment_id']
    );
     $arr = curl_post($ordata,BILL_API);
     if($arr["paymentInfo"]["payment_id"]){
            //根据订单号查询物流单号
            $pid=$read->fetchAll("SELECT track_number FROM `sales_flat_shipment_track` WHERE `order_id`=".$v['entity_id']);
            //$order=get_object_vars($pid);
            $tracknumber=$pid['0']['track_number'];

            if($tracknumber){
                //获取唯一支付ID
                $payment_id=$arr["paymentInfo"]["payment_id"];
                if(strlen($tracknumber)==12){
                    $tracking_site="http://www.sf-express.com/us/en/dynamic_function/waybill/#search/bill-number/";
                }else{
                    $tracking_site="https://www.17track.net/en#nums";
                }

                $tracking_handle="cherry";

                $values=ACCOUNT.TERMINAL.$payment_id.$tracknumber.$tracking_site.$tracking_handle.SECURE_CODE;
                $singValue=hash("sha256", $values);
                $data=array(
                    "account" => ACCOUNT,
                    "terminal" => TERMINAL,
                    "signValue" => $singValue,
                    "payment_id" => $payment_id,
                    "tracking_number" => $tracknumber,
                    "tracking_site" => $tracking_site,
                    "tracking_handler" => $tracking_handle
                );
                $arr = curl_post($data,OC_API);

                $tracking_results=$arr["tracking_results"];
                if ($tracking_results != 1) {
                    file_put_contents("oc_shipping_log.txt",date("Y-m-d H:i:s")."  order:{$v['increment_id']}  "."fail"."\r\n",FILE_APPEND);
                }else{
                    //上传成功更改状态
                    $sql="update sales_flat_order set logitstatu=1 where entity_id=".$v['entity_id'];
                    $write->query($sql);
                    file_put_contents("oc_shipping_log.txt",date("Y-m-d H:i:s")." order:{$v['increment_id']}  "."success"."\r\n",FILE_APPEND);
                    echo "OK:".$v['increment_id']."\r\n";
                }
            }


        }
     sleep(3);
}

function curl_post($ordata,$url){
    //调用curl方法
    $ch = curl_init();
    //设置抓取的url
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // 跳过证书检查
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, true); // 从证书中检查SSL加密算法是否存在
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($ordata));
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_TIMEOUT, 30);
    $response = curl_exec($ch);
    curl_close($ch);
    if (curl_errno($ch)) {
        $txt = date("Y-m-d H:i:s").'Curl Error:'.curl_error($ch);//捕抓异常
        //异常数据写入日志
        file_put_contents("curl_error.txt",date("Y-m-d H:i:s")."\n捕抓异常".$txt,FILE_APPEND);
        exit;
    }else{

        $apiobj=simplexml_load_string($response);
        $response=json_encode($apiobj);
        $response=json_decode($response,true);
        //file_put_contents("curl_error.txt",date("Y-m-d H:i:s")."\n".json_encode($response['paymentInfo']),FILE_APPEND);
        return $response;
    }
}
?>

说明：***是钱海给的账户号及秘钥。该文件基于magento1.9开发，使用方式为防止在网站目录下的shell文件夹下，然后启动定时任务执行即可。成功后会给该笔订单增加标记，方便下一次查询的时候不再执行。其他系统的原理类似，只要更换里面的部分写法即可。