/**
* 名称: 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;
//成功， 返回列表数据
}
