コード例 #1
0
function getAvailDates()
{
    global $link, $limit, $offset;
    $dates = array();
    $fullDates = array();
    $tweetTotals = array();
    $result = mysql_query("SELECT updatedTime FROM newswire_tb ORDER BY updatedTime DESC");
    while ($row = mysql_fetch_assoc($result)) {
        if (_checkDate($row['updatedTime'], $dates) == 0) {
            $dates[] = _parseDate($row['updatedTime']);
            $fullDates[] = $row['updatedTime'];
        }
    }
    //mysql_free_result($result);
    //mysql_close($link);
    //echo 'working on it';
    getTotals($fullDates);
}
コード例 #2
0
function getAvailDates()
{
    global $link;
    $dates = array();
    $fullDates = array();
    $result = mysql_query("SELECT updatedTime FROM newswire_tb ORDER BY updatedTime DESC");
    while ($row = mysql_fetch_assoc($result)) {
        if (_checkDate($row['updatedTime'], $dates) == 0) {
            $dates[] = _parseDate($row['updatedTime']);
            $fullDates[] = $row['updatedTime'];
            //$dates[] = $row['updatedTime'];
        }
        //echo "date: "._parseDate( $row['updatedTime'] )."<br>";
    }
    for ($i = 0; $i < count($dates); $i++) {
        //echo 'selected date: '.$dates[$i]."<br>";
    }
    mysql_free_result($result);
    mysql_close($link);
    outputXML($fullDates);
}
コード例 #3
0
     $data['Date_IQ_Test'] = $candrow['WASI_date'];
 } else {
     $data['Date_IQ_Test'] = $candrow['DAS_date'];
 }
 // test the DB date
 if (empty($data['Date_IQ_Test']) || empty($data['Date_visit'])) {
     // if any of the dates is empty
     $data['DB_Window'] = "MI";
 } else {
     // split the dates to test them
     $dateArray = explode('-', $data['Date_visit']);
     $dateOfVisit = array('Y' => $dateArray[0], 'M' => $dateArray[1], 'd' => $dateArray[2]);
     $dateArray = explode('-', $data['Date_IQ_Test']);
     $dateOfIQTest = array('Y' => $dateArray[0], 'M' => $dateArray[1], 'd' => $dateArray[2]);
     unset($dateArray);
     if (_checkDate($dateOfIQTest) == false || _checkDate($dateOfVisit) === false) {
         $data['DB_Window'] = "Date Error";
     } else {
         // test the DB window - not applicable for V1
         if (strtolower($data['Visit']) == 'v1') {
             $data['DB_Window'] = "";
         } else {
             // compute the dates in months
             $data['DB_Window'] = abs($dateOfVisit['Y'] * 12 + $dateOfVisit['M'] - ($dateOfIQTest['Y'] * 12 + $dateOfIQTest['M']));
         }
     }
     unset($dateOfIQTest);
     unset($dateOfVisit);
 }
 /*
  ** FEEDBACK status info