/** * 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; } }