/**
* 名称: act_getOrderTracknumberBydate
* 功能: 获取订单的跟踪号信息
* @para $startTime int
* @para $endTime int
* return Array
*/
public function act_getOrderTracknumberBydate()
{
$startTime = $_REQUEST['startTime'];
$endTime = $_REQUEST['endTime'];
$truckNumberData = OrderTracknumberModel::getTracknumberInfoByDate($startTime, $endTime);
if (!$truckNumberData) {
self::$errCode = OrderTracknumberModel::$errCode;
self::$errMsg = OrderTracknumberModel::$errMsg;
return false;
}
return $truckNumberData;
}
<?php
error_reporting(-1);
header("Content-type: text/html; charset=utf-8");
date_default_timezone_set('Asia/Shanghai');
require "/data/web/order.valsun.cn/framework.php";
Core::getInstance();
/*
require_once WEB_PATH . 'lib/rabbitmq/vendor/autoload.php';
use PhpAmqpLib\Connection\AMQPConnection;
use PhpAmqpLib\Message\AMQPMessage;
$connection = new AMQPConnection('112.124.41.121', 5672, 'valsun_warehouse','warehouse%123','valsun_warehouse');*/
$startTime = strtotime("-3 days", time());
$endTime = time();
$url = 'http://api.wh.valsun.cn/json.php?mod=orderTracknumber&act=getOrderTracknumber&jsonp=1&startTime=' . $startTime . '&endTime=' . $endTime;
$data = file_get_contents($url);
$data = json_decode($data, true);
$ret = OrderTracknumberModel::updateOrderTracknumber($data['data']);
if (!$ret) {
echo '更新失败!, 原因: errCode' . OrderTracknumberModel::$errCode . ', errMsg: ' . OrderTracknumberModel::$errMsg;
exit;
}
echo '更新成功!';
exit;
/**
* 名称: getTracknumberInfoByDate
* 功能: 根据开始时间与结束时间获取跟踪号信息
* @para $startTime int
* @para $endTime int
* return Array
*/
public function getTracknumberInfoByDate($startTime, $endTime)
{
self::initDB();
if (preg_match('/^\\d+$/', $startTime) < 1 || preg_match('/^\\d+$/', $endTime) < 1) {
self::$errCode = '3302';
self::$errMsg = '开始时间或结束时间输入不正确, 请重试! ';
return false;
}
$sql = 'SELECT os.`id`,os.`originOrderId`,os.`recordNumber`,os.`shipOrderId`,os.`storeId`,ot.`tracknumber`
FROM wh_shipping_order_relation AS os
LEFT JOIN wh_order_tracknumber AS ot ON os.`shipOrderId` = ot.`shipOrderId`
WHERE ot.createdTime >= ' . $startTime . ' AND ot.createdTime <= ' . $endTime;
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
$data = array();
if (!empty($ret)) {
$tempData = array();
foreach ($ret as $k => $v) {
$tempData[] = $v['originOrderId'];
}
$tempData = array_flip(array_flip($tempData));
//清除多余的订单号
foreach ($ret as $k => $v) {
if (in_array($v['originOrderId'], $tempData)) {
$data[] = array('orderId' => $v['originOrderId'], 'tracknumber' => $v['tracknumber']);
}
}
}
return $data;
//成功， 返回列表数据
}
