/**
* OrderTranAct::act_get_tracknum_tran_info()
* 获取订单系统某个几天内跟踪号列表
* @param int $days 几天内
* @param int $carrierId 运输方式ID
* @return array
*/
public static function act_get_tracknum_tran_info()
{
$days = isset($_REQUEST["days"]) ? intval($_REQUEST["days"]) : 0;
$carrierId = isset($_REQUEST["carrierId"]) ? intval($_REQUEST["carrierId"]) : 0;
if (empty($days)) {
self::$errCode = 10000;
self::$errMsg = "时间参数有误";
return false;
}
// if (empty($carrierId)) {
// self::$errCode = 10001;
// self::$errMsg = "运输方式ID参数有误";
// return false;
// }
$times = strtotime("-{$days} day" . " 00:00:01");
$res = OrderTranModel::get_tracknum_tran_info($times, $carrierId);
self::$errCode = OrderTranModel::$errCode;
self::$errMsg = OrderTranModel::$errMsg;
return $res;
}
/**
* OrderTranModel::get_tracknum_tran_info()
* 获取订单系统某个几天内跟踪号列表
* @param int $days 时间
* @param int $carrierId 运输方式ID
* @return array
*/
public static function get_tracknum_tran_info($days, $carrierId)
{
self::initDB();
$condition = "";
if (!empty($carrierId)) {
$condition .= " AND b.transportId = {$carrierId}";
}
$track_tab = in_array($carrierId, array(46, 47)) ? "ow_order_tracknumber" : "om_order_tracknumber";
$sql = "SELECT \n\t\t\t\t\t\ta.omOrderId as ebay_id,a.actualWeight as orderweight,a.actualShipping as ordershipfee,weighTime as scantime,\n\t\t\t\t\t\tb.accountId,b.recordNumber,b.transportId as ebay_carrier,b.channelId,b.orderStatus as ebay_status,\n\t\t\t\t\t\tc.countryName as ebay_countryname,c.countrySn as ebay_couny,\n\t\t\t\t\t\td.tracknumber as ebay_tracknumber,\n\t\t\t\t\t\te.account as ebay_account,\n\t\t\t\t\t\tf.platform as PlatForm\n\t\t\t\t\t\tFROM om_shipped_order_warehouse AS a \n\t\t\t\t\t\tLEFT JOIN om_shipped_order AS b ON a.omOrderId = b.id\n\t\t\t\t\t\tLEFT JOIN om_shipped_order_userInfo AS c ON a.omOrderId = c.omOrderId\n\t\t\t\t\t\tLEFT JOIN {$track_tab} AS d ON a.omOrderId = d.omOrderId\n\t\t\t\t\t\tLEFT JOIN om_account AS e ON b.accountId = e.id\n\t\t\t\t\t\tLEFT JOIN om_platform AS f ON b.platformId = f.id\n\t\t\t\t\t\tWHERE a.weighTime >= {$days} {$condition}\n\t\t\t\t\t\t";
//echo $sql;
$query = self::$dbConn->query($sql);
if ($query) {
$res = self::$dbConn->fetch_array_all($query);
return $res;
} else {
self::$errCode = 10000;
self::$errMsg = "获取数据失败";
return false;
}
}
