$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++; } //跟踪目的地国家信息