function GetFileMimeType($Table, $ID)
{
#-------------------------------------------------------------------------------
$Path = GetFilePath($Table, $ID);
#-------------------------------------------------------------------------------
if (File_Exists($Path['FilePath'])) {
#-------------------------------------------------------------------------------
$Mime = FInfo_File(FInfo_Open(FILEINFO_MIME_TYPE), $Path['FilePath']);
Debug(SPrintF('[system/libs/Upload]: get file type: %s (%s)', $Path['FilePath'], $Mime));
#-------------------------------------------------------------------------------
//return Mime_Content_Type($Path['FilePath']);
return $Mime;
#-------------------------------------------------------------------------------
}
#-------------------------------------------------------------------------------
return 'application/octetstream';
#-------------------------------------------------------------------------------
}
function db_GetValuesCSV($siteCode, $variableCode, $beginTime, $endTime, $methods)
{
$validMethods = array();
//for every method, query the values
$retVal = "\"time\",\"value\",\"method\"\n";
foreach ($methods as $method) {
//values shown in output
$valuesShownForMethod = 0;
//locate the file
$methodCode = $method["MethodID"];
$methodDescription = $method["MethodDescription"];
//locate start row
$methodInfo = db_getMethodInfo($methodDescription);
$beginRow = 0;
if (isset($beginTime) && $beginTime != "") {
$queryBeginYear = substr($beginTime, 0, 4);
$queryBeginMonth = substr($beginTime, 5, 2);
$beginRow = ($queryBeginYear - $methodInfo["beginYear"]) * 12 + ($queryBeginMonth - $methodInfo["beginMonth"]);
$queryBeginDay = substr($beginTime, 8, 2);
if ($queryBeginDay > 14) {
$beginRow = $beginRow + 1;
}
}
//locate end row
$endRow = 12 * 300;
if (isset($endTime) && $endTime != "") {
$queryEndYear = substr($endTime, 0, 4);
$queryEndMonth = substr($endTime, 5, 2);
$endRow = ($queryEndYear - $methodInfo["beginYear"]) * 12 + ($queryEndMonth - $methodInfo["beginMonth"]);
//check for day (db times are for 14th of the month)
$queryEndDay = substr($endTime, 8, 2);
if ($queryEndDay < 14) {
$endRow = $endRow - 1;
}
}
//this needs to be changed on the server!
$filepath = GetFilePath() . $siteCode . '/' . $siteCode . '-' . $methodDescription . '.csv';
if (file_exists($filepath)) {
$txt_file = file_get_contents($filepath);
$rows = explode("\n", $txt_file);
$rownum = 0;
foreach ($rows as $row) {
if ($rownum >= $beginRow && $rownum <= $endRow) {
$row_data = explode(',', $row);
if (count($row_data) > 1) {
$datetime = substr($row_data[0], 0, -1);
$dv = substr($row_data[1], 0, -1);
$retVal .= "\"" . $datetime . "\",";
$retVal .= $dv . ",";
$retVal .= "\"" . $methodDescription . "\"\n";
}
}
$rownum++;
}
}
}
return $retVal;
}
