function getAllData()
{
$dataHandle = new DataHandle();
$result = $dataHandle->getAllData();
$dataHandle->closeDB();
return $result;
}
function getFileAndSave($dataFile, $prodName, $version, $ts)
{
$dataHandle = new DataHandle();
if (file_exists($dataFile)) {
$handle = fopen($dataFile, "r");
$line = fgets($handle);
$sumEadPvNum = 0;
$sumEadBidNum = 0;
$sumEadImprNum = 0;
$sumExchangePvNum = 0;
$sumExchangeBidNum = 0;
$sumExchangeImprNum = 0;
while ($line != "") {
//将数据存入数据库
$line = str_replace(";", ",", $line);
$lineArray = explode(",", $line);
$time = $lineArray[0];
$platform = $lineArray[1];
$type = $lineArray[2];
$pvNum = $lineArray[3];
$bidNum = $lineArray[4];
$imprNum = $lineArray[5];
$id = $dataHandle->insertDataInfo($time, $platform, $type, $pvNum, $bidNum, $imprNum, $prodName, $version, $ts);
echo "insert dataInfo: " . $id;
if ($type == "ead") {
$sumEadPvNum += $pvNum;
$sumEadBidNum += $bidNum;
$sumEadImprNum += $imprNum;
} else {
//exchange
$sumExchangePvNum += $pvNum;
$sumExchangeBidNum += $bidNum;
$sumExchangeImprNum += $imprNum;
}
$line = fgets($handle);
}
$id1 = $dataHandle->insertSumData($time, "ead", $sumEadPvNum, $sumEadBidNum, $sumEadImprNum, $prodName, $version, $ts);
echo "insert ead sumData: " . $id1;
$id2 = $dataHandle->insertSumData($time, "exchange", $sumExchangePvNum, $sumExchangeBidNum, $sumExchangeImprNum, $prodName, $version, $ts);
echo "insert exchange sumData: " . $id1;
echo "insert done.<br/>";
$dataHandle->closeDB();
fclose($handle);
}
return 0;
}
