예제 #1
0
 function db_GetValues($siteCode, $variableCode, $beginTime, $endTime, $methods)
 {
     $ci =& get_instance();
     $validMethods = array();
     //for every method, query the values
     $retVal = "<values>";
     foreach ($methods as $method) {
         //values shown in output
         $valuesShownForMethod = 0;
         //locate the file
         $methodCode = $method["MethodID"];
         $methodDescription = $method["MethodDescription"];
         //locate start row, end 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;
             }
         }
         $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);
                         $retVal .= '<value censorCode="nc" dateTime="' . $datetime . '"';
                         $retVal .= ' timeOffset="' . '0' . '" dateTimeUTC="' . $datetime . '"';
                         $retVal .= ' methodCode="' . $methodCode . '" ';
                         $retVal .= ' sourceCode="1" qualityControlLevelCode="1" ';
                         $dv = $row_data[1];
                         $retVal .= ">" . $dv . "</value>";
                         $valuesShownForMethod++;
                     }
                 }
                 $rownum++;
             }
         }
         if ($valuesShownForMethod > 0) {
             array_push($validMethods, $method);
         }
     }
     $retVal .= db_GetQualityControlLevelByID(1);
     foreach ($validMethods as $method) {
         $methodID = $method["MethodID"];
         $retVal .= '<method methodID="' . $methodID . '"><methodCode>' . $methodID . "</methodCode>";
         $retVal .= "<methodDescription>" . $method["MethodDescription"] . "</methodDescription>";
         $retVal .= "<methodLink>Unknown</methodLink>";
         $retVal .= "</method>";
     }
     $retVal .= db_GetSourceByID(1);
     $retVal .= "<censorCode><censorCode>nc</censorCode><censorCodeDescription>not censored</censorCodeDescription></censorCode>";
     $retVal .= "</values>";
     return $retVal;
 }
예제 #2
0
 function db_GetValues_MultipleSeries($siteID, $variableID, $arrMethod, $arrSource, $arrQC, $beginTime, $endTime)
 {
     $ci =& get_instance();
     $samples_table = get_table_name('Samples');
     $ci->db->select("d.LocalDateTime, d.UTCOffset, d.DateTimeUTC, d.MethodID, d.SourceID, d.QualityControlLevelID, d.DataValue, s.LabSampleCode");
     $ci->db->join($samples_table . " s", "d.SampleID = s.SampleID", "LEFT");
     $ci->db->where("d.SiteID", $siteID);
     $ci->db->where("d.VariableID", $variableID);
     $ci->db->order_by("d.LocalDateTime");
     if (isset($beginTime) && $beginTime != "" && (isset($endTime) && $endTime != "")) {
         $ci->db->where("d.LocalDateTime >=", $beginTime);
         $ci->db->where("d.LocalDateTime <=", $endTime);
     }
     $result = $ci->db->get(get_table_name('DataValues') . " d");
     if (!$result) {
         die("<p>Error in executing the SQL query " . $ci->db->last_query() . ": " . $ci->db->_error_message() . "</p>");
     }
     $retVal = "<values>";
     //$metadata = 'methodCode="' . $methodID . '" sourceCode="' . $sourceID . '" qualityControlLevelCode="' . $qcID . '"';
     foreach ($result->result_array() as $row) {
         $retVal .= '<value censorCode="nc" dateTime="' . $row["LocalDateTime"] . '"';
         $retVal .= ' timeOffset="' . $row["UTCOffset"] . '" dateTimeUTC="' . $row["DateTimeUTC"] . '"';
         $retVal .= ' methodCode="' . $row["MethodID"] . '" ';
         $retVal .= ' sourceCode="' . $row["SourceID"] . '" ';
         $retVal .= $row['LabSampleCode'] != '' ? 'labSampleCode="' . $row['LabSampleCode'] . '"' : '';
         $retVal .= ' qualityControlLevelCode="' . $row["QualityControlLevelID"] . '" ';
         $retVal .= ">" . $row["DataValue"] . "</value>";
     }
     foreach ($arrQC as $row) {
         $retVal .= db_GetQualityControlLevelByID($row);
     }
     foreach ($arrMethod as $row) {
         $retVal .= db_GetMethodByID($row);
     }
     foreach ($arrSource as $row) {
         $retVal .= db_GetSourceByID($row);
     }
     $retVal .= "<censorCode><censorCode>nc</censorCode><censorCodeDescription>not censored</censorCodeDescription></censorCode>";
     $retVal .= "</values>";
     return $retVal;
 }