function import_record($filename, $added_row_count, $last_time, $duplicated_time_count)
{
if (!isset($filename)) {
header('Location: xls_importer.php');
}
$file = fopen($filename, "r") or exit("Unable to open file " . $filename);
echo "<table border='1' cellspacing='0'>";
$count = 0;
while (!feof($file)) {
$line = fgets($file);
$count++;
if ($count <= $added_row_count) {
continue;
}
if ($count - $added_row_count > 200) {
$count--;
break;
}
echo "<tr>";
$cells = parse_line_to_array($line);
if ($cells) {
$category = CCategoryManager::GetCategoryByName($cells[1]);
$category_id = $category->GetId();
$detail = $cells[3];
$time = $cells[0];
if ($time == $last_time) {
$duplicated_time_count++;
$time += $duplicated_time_count * 60 * 60;
} else {
$last_time = $time;
$duplicated_time_count = 0;
}
$amount = $cells[2];
$record = new CRecord(0, $category_id, $detail, $time, $amount, null);
CRecordManager::AddRecord($record);
echo "<td>{$category_id}</td>";
echo "<td>" . $category->GetName() . "</td>";
echo "<td>{$detail} </td>";
echo "<td>" . date("d-m-Y H:i:s", $time) . "</td>";
echo "<td>{$amount}</td>";
}
echo "</tr>";
}
fclose($file);
echo "</table>";
$result = array();
$result[0] = $count;
$result[1] = $last_time;
$result[2] = $duplicated_time_count;
return $result;
}
