private function processTextfileDataToDatabase($dir, $spatialfile, $sheetname, $bexcel)
{
$conn = $this->get('database_connection');
$runResult = null;
if ($bexcel === true) {
$field_names = SpatialFileMethods::excelToDatabase($conn, $dir, $spatialfile, $sheetname);
if ($field_names !== null && count($field_names) > 0) {
SpatialFileMethods::updateTableGeommetry($this->params, $conn, 'spatial_' . str_replace('-', '_', $spatialfile->getId()));
} else {
$runResult = "uploaded excel file:" . $spatialfile->getFileName() . " no field name found!";
}
} else {
$field_names = SpatialFileMethods::textToDatabase($conn, $dir, $spatialfile);
if ($field_names !== null && count($field_names) > 0) {
SpatialFileMethods::updateTableGeommetry($this->params, $conn, 'spatial_' . str_replace('-', '_', $spatialfile->getId()));
} else {
$runResult = "uploaded text file:" . $spatialfile->getFileName() . " no field name found!";
}
}
return $runResult;
}
public static function checkTextDataFields($textData)
{
$i = 0;
$field_names = array();
foreach ($textData as $data) {
if ($i == 0) {
$field_names = SpatialFileMethods::checkTextDataFieldNames($data);
} else {
$field_names = SpatialFileMethods::checkTextDataEachRowType($data, $field_names);
}
$i = $i + 1;
}
return $field_names;
}
