protected function setUp() { $this->dttOne = new QDateTime(); $this->dttTwo = new QDateTime(); $this->arrTimes = array(QDateTime::FromTimeOnly('00:00:00'), QDateTime::FromTimeOnly('06:35:00'), QDateTime::FromTimeOnly('23:59:59')); $this->arrDates = array(new QDateTime('1980-06-13'), new QDateTime('today')); $this->arrDatetimes = array(new QDateTime('1980-06-13 04:34'), new QDateTime(QDateTime::Now)); }
public function GetColumn($strColumnName, $strColumnType = null) { if (array_key_exists($strColumnName, $this->strColumnArray)) { if (is_null($this->strColumnArray[$strColumnName])) { return null; } switch ($strColumnType) { case QDatabaseFieldType::Bit: return $this->strColumnArray[$strColumnName] ? true : false; case QDatabaseFieldType::Blob: case QDatabaseFieldType::Char: case QDatabaseFieldType::VarChar: return QType::Cast($this->strColumnArray[$strColumnName], QType::String); case QDatabaseFieldType::Date: case QDatabaseFieldType::DateTime: return new QDateTime($this->strColumnArray[$strColumnName]); case QDatabaseFieldType::Time: return QDateTime::FromTimeOnly($this->strColumnArray[$strColumnName]); case QDatabaseFieldType::Float: return QType::Cast($this->strColumnArray[$strColumnName], QType::Float); case QDatabaseFieldType::Integer: return QType::Cast($this->strColumnArray[$strColumnName], QType::Integer); default: return $this->strColumnArray[$strColumnName]; } } else { return null; } }
public function GetColumn($strColumnName, $strColumnType = null) { if (array_key_exists($strColumnName, $this->strColumnArray)) { if (is_null($this->strColumnArray[$strColumnName])) { return null; } switch ($strColumnType) { case QDatabaseFieldType::Bit: // Account for single bit value $chrBit = $this->strColumnArray[$strColumnName]; if (strlen($chrBit) == 1 && ord($chrBit) == 0) { return false; } // Otherwise, use PHP conditional to determine true or false return $this->strColumnArray[$strColumnName] ? true : false; case QDatabaseFieldType::Blob: case QDatabaseFieldType::Char: case QDatabaseFieldType::VarChar: return QType::Cast($this->strColumnArray[$strColumnName], QType::String); case QDatabaseFieldType::Date: case QDatabaseFieldType::DateTime: return new QDateTime($this->strColumnArray[$strColumnName]); case QDatabaseFieldType::Time: return QDateTime::FromTimeOnly($this->strColumnArray[$strColumnName]); case QDatabaseFieldType::Float: return QType::Cast($this->strColumnArray[$strColumnName], QType::Float); case QDatabaseFieldType::Integer: return QType::Cast($this->strColumnArray[$strColumnName], QType::Integer); default: return $this->strColumnArray[$strColumnName]; } } else { return null; } }