/**
* TrackWarnStatModel::getInternalTime()
* 返回某个运输方式某渠道国内处理时效
* @param integer $carrierId 运输方式ID
* @param integer $channelId 渠道ID
* @param integer $countryId 国家ID
* @param string $condition 条件
* @return array
*/
public static function getInternalTime($carrierId, $channelId, $condition, $nodeId = "", $countryId)
{
self::initDB();
if (!empty($countryId)) {
$sql = "SELECT AVG(internalTime),AVG(weight),AVG(cost) FROM " . self::$prefix . self::$tab_track_num . " WHERE {$condition} AND carrierId = {$carrierId} AND channelId = {$channelId} AND countryId = {$countryId} AND internalTime > 0";
} else {
$sql = "SELECT AVG(internalTime),AVG(weight),AVG(cost) FROM " . self::$prefix . self::$tab_track_num . " WHERE {$condition} AND carrierId = {$carrierId} AND channelId = {$channelId} AND internalTime > 0";
}
$query = self::$dbConn->query($sql);
if ($query) {
$data = self::$dbConn->fetch_row($query);
return array(round(intval($data[0]) / 86400, 2), round(floatval($data[1]), 4), round(floatval($data[2]), 4));
} else {
self::$errCode = 10000;
self::$errMsg = "获取数据失败";
return 0;
}
}
