/**
* Compares a time reported from QuickBooks to a mysql datetime field
* Ex: QB Time: 2009-01-23T08:33:56-05:00
* SQL Time: 2009-01-23 08:31:11
*
* @deprecated This needs to be moved to a driver class!
*
* Returns -1 if QB Time is Smaller
* Returns 0 if Times are Equal
* Returns 1 if QB Time is Greater
* Returns FALSE on Error
*/
public static function compareQBTimeToSQLTime($QBTime, $SQLTime)
{
$SQLTime = QuickBooks_Utilities::mysqlTZToPHPTZ($SQLTime);
$tempTime = explode(" ", $SQLTime);
$mysqlTime = explode(":", $tempTime[1]);
$tempTime = explode("-", $tempTime[0]);
$mysql_t = mktime($mysqlTime[0], $mysqlTime[1], $mysqlTime[2], $tempTime[1], $tempTime[2], $tempTime[0], 0);
$QBTime = strtotime($QBTime);
//mail("*****@*****.**","QBTime","QBTime: ".($QBTime)."\n\n\nSQLTime: ".$mysql_t."\n\n\n".$SQLTime."\n\n\nDaylight Savings?: ".date('I'));
if ($QBTime < $mysql_t) {
return -1;
} elseif ($QBTime > $mysql_t) {
return 1;
} else {
return 0;
}
}
