$table .= '<table border="1" cellpadding="0" cellspacing="0" width="791"><tr><td height="25px"><b>运输方式</b></td><td><b>跟踪号总数</b></td><td><b>已用数量</b></td><td><b>剩余数量</b></td></tr>';
$table .= '<tr><td height="20px">' . $res['carrierNameCn'] . '</td><td>' . $total . '</td><td>' . $used . '</td><td>' . $last . '</td></tr>';
$flag = false;
foreach ($chArr as $v) {
$total_ch = TrackNumberModel::modListCount("carrierId = '{$carrierId}' AND channelId = '{$v['id']}'");
$used_ch = TrackNumberModel::modListCount("carrierId = '{$carrierId}' AND channelId = '{$v['id']}' AND orderId > 0");
$last_ch = TrackNumberModel::modListCount("carrierId = '{$carrierId}' AND channelId = '{$v['id']}' AND orderId = 0");
if ($carrierId == 88) {
$total_cur = TrackNumberModel::modListCount("carrierId = '{$carrierId}' AND countrys = 'Switzerland'");
$used_cur = TrackNumberModel::modListCount("carrierId = '{$carrierId}' AND countrys = 'Switzerland' AND orderId > 0");
$last_cur = TrackNumberModel::modListCount("carrierId = '{$carrierId}' AND countrys = 'Switzerland' AND orderId = 0");
$table .= '<tr><td height="20px">' . $res['carrierNameCn'] . '->非瑞士国家</td><td>' . ($total - $total_cur) . '</td><td>' . ($used - $used_cur) . '</td><td>' . ($last - $last_cur) . '</td></tr>';
$table .= '<tr><td height="20px">' . $res['carrierNameCn'] . '->瑞士国家</td><td>' . $total_cur . '</td><td>' . $used_cur . '</td><td>' . $last_cur . '</td></tr>';
}
if ($last_ch <= $warnNum) {
$flag = true;
}
if ($carrierId == 2) {
$table .= '<tr><td height="20px">' . $res['carrierNameCn'] . "->" . $v['channelName'] . '渠道</td><td>' . $total_ch . '</td><td>' . $used_ch . '</td><td>' . $last_ch . '</td></tr>';
}
}
$table .= '</table>';
$table .= '<p style="' . $css_height . '">详情请登录：<a href="' . $system_url . '" target="_blank">' . $system_name . '</a><br/></br>' . date('Y-m-d') . '<br/>' . $system_name . '</p>';
echo $table, "\n";
//跟踪号可用数低于多少发预警邮件
if ($flag || $last <= $warnNum) {
$message = TransOpenApiModel::sendMessage("{$type}", "{$from}", "{$to}", $table, "{$title}");
echo $message, "\n";
}
echo "\n\n完成时间" . date('Y-m-d H:i:s') . "\n";
exit;
// $trackName = $trackNames['trackName'];
// $res_country = track_number_detail_country($trackName);
}
$res_detail = TransOpenApiModel::addTrackNumberDetail($v['carrierId'], $sql_data);
//详细数据插入
$res_number = TransOpenApiModel::updateTrackNumber($trackNumber, $data);
//更新跟踪号摘要信息
$res_warn = TransOpenApiModel::autoWarnInfo($detailInfo);
//自动预警
echo $res_detail, "=====", $res_number, "=====", $res_warn, "=====", $res_country, "=====", date('Y-m-d H:i:s'), "\n";
$errnum = 1;
} else {
if (isset($detailInfo['errCode'])) {
if ($errnum >= $errMaxNum) {
echo date('Y-m-d H:i:s'), "===数据连续抓取失败{$errMaxNum},即将退出数据抓取\n";
$message = TransOpenApiModel::sendMessage("{$type}", "{$from}", "{$to}", '物流系统服务器(121.40.69.217)报错,' . $detailInfo['ReturnValue'] . '-cid:' . $carrierId . ',请及时处理下！', '物流系统服务器报错' . $detailInfo['errCode']);
echo date('Y-m-d H:i:s'), "===信息发送状态:", $message, "\n";
break;
}
$errnum++;
} else {
$res = TransOpenApiModel::updateTrackNumber($trackNumber, array("trackTime" => time()));
check_cancel_order();
$errnum = 1;
}
}
}
echo "第{$row}/{$total}条记录处理完毕!\n";
$row++;
}
//跟踪目的地国家信息
