function analyse($path, $parent, $title, $root, $parseId, $action, $levelCnt)
{
//echoall($path);
$importArray = import::fetch_file_to_array($path);
$delimiter = ";";
// echoarray($importArray);
?>
<style>
table {
border:1px;
padding:0px;
margin:0px;
}
th {
color:black;
border-width:1px;
font-size:10pt;
}
td {
color:black;
border-width:1px;
font-size:10pt;
}
</style>
<?php
if (is_array($importArray)) {
echo "<h2>Analyse {$path}</h2>";
// $levelCnt = 7;
$linePos = 0;
echo "<table border='1' cellpadding='0' cellspacing='0'>";
if ($parseId) {
echo "<th>ID</th>";
}
for ($li = 0; $li < $levelCnt; $li++) {
echo "<th>Level {$li}</th>";
}
echo "<th>Herkunft</th>";
echo "<th>Bemerkung</th>";
foreach ($importArray as $entry) {
if ($linePos != 0 or !$title) {
$lineArray = explode($delimiter, $entry);
$colPos = 0;
if ($parseId) {
$entryid = $lineArray[0];
}
// loop for entries
if ($parseId) {
$start = 1;
} else {
$start = 0;
}
// filter id
for ($i = $start; $i < count($lineArray); $i++) {
$lineEntry = str_replace("\n", '', $lineArray[$i]);
$lineEntry = str_replace("\r", '', $lineEntry);
$source = $lineArray[$li + 1];
$comment = $lineArray[$li + 2];
if ($lineEntry) {
$parentArray[$colPos] = $lineEntry;
// utf8_encode($lineEntry);
// insert into database
if ($action == "insert") {
$parentName = $parentArray[$colPos - 1];
if (!$parentName) {
$parentName = thesaurus::get_name($parent);
}
// no parent name -> use thesaurus
if ($root) {
$source = $root;
}
$newId = import::insert($lineEntry, $parentName, "{$idName}={$entryid};Root={$source};Bemerkung={$comment}");
}
break;
}
$colPos++;
}
// remove unused array items
for ($i = $colPos + 1; $i < 7; $i++) {
$parentArray[$i] = "";
}
// display line
echo "<tr>";
if ($parseId) {
echo "<td>{$entryid}</td>";
} else {
echo "<td> </td>";
}
foreach ($parentArray as $entry) {
echo "<td>" . $entry . "</td>";
}
if ($source) {
echo "<td>{$source}</td>";
} else {
echo "<td> </td>";
}
if ($comment) {
echo "<td>{$comment}</td>";
} else {
echo "<td> </td>";
}
if ($newId) {
echo "<td><i><b>({$newId})</b></i></td>";
}
echo "</tr>";
} else {
// header
$lineArray = explode($delimiter, $entry);
$idName = $lineArray[0];
$sourceName = $lineArray[7];
$commentName = $lineArray[8];
}
$linePos++;
// next line of file
}
echo "</table>";
}
}
