 |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
订阅该问题
悬赏分：20 - 2007年08月13日
[PHP]
<?
$dbname = array("BAP_M","BAP_S","CAP_0","CAP_1","CAP_2","CAP_3","CAP_4","CAP_5","CAP_6","CAP_7","CAP_8","CAP_9");
$str = implode("",file("0413-2/PT0413.CPXX"));
$str = explode("END TEXT JOB 1829",$str);
$firstTime = false;
foreach ($str as $val)
{
$str_c1 = explode("------------------------+---+---+---+---+---+---+---+---+---+---+---+---",$val) ;
preg_match("/DATE : ([0-9]{2}-[0-9]{2}-[0-9]{2})/",$str_c1[0],$regs);
$data = $regs[1];
preg_match("/BEGIN OF INTEGRATION : ([0-9]{2}:[0-9]{2})/",$str_c1[0],$regs);
$time = $regs[1];
unset($str_c1[0]);
$str_c1[1] = preg_replace("/[[:space:]]+/"," ",$str_c1[1]);
preg_match_all("/CARRIED TRAFFIC ([^a-zA-Z]*) TOTAL INTENSITY ([^a-zA-Z]*)/",$str_c1[1],$regs);
unset($regs[0]);
$countRegs=count($regs[1]);
for ($i=0;$i<$countRegs;$i++)
{
if (!$firstTime)
{
$firstTime = true;
$time = $time . ":00";
}
else $time = mtime($time);
$carriedTraffic = explode(" ",trim($regs[1][$i]));
$totalIntensity = explode(" ",trim($regs[2][$i]));
$total = count($carriedTraffic);
for ($n=0;$n<$total;$n++)
{
echo "insert into ".$dbname[$n]." (`data`,`time`,`CARRIED_TRAFFIC`,`TOTAL_INTENSITY`) values ('$data','$time','$carriedTraffic[$n]','$totalIntensity[$n]');
" ;
}
}
}
function mtime($timeStr){
$timeStr = explode(":",$timeStr);
$timeStr[1] += 3;
if ($timeStr[1] >= 60){
$timeStr[1] = $timeStr[1] -60;
$timeStr[0] += 1;
}
$timeStr[0] = str_pad($timeStr[0], 2, "0", STR_PAD_LEFT);
$timeStr[1] = str_pad($timeStr[1], 2, "0", STR_PAD_LEFT);
return $timeStr[0].":".$timeStr[1].":00";
}
?>[/PHP]