public function testPrepareDecryptFields()
{
$key = KeyHandlerOld::readKey();
$fields[] = 'emp_ssn_num';
$fields[] = 'ebsal_basic_salary';
$fields[] = 'hs_hr_emp_language';
$expected[] = "AES_DECRYPT(`emp_ssn_num`, '{$key}')";
$expected[] = "AES_DECRYPT(`ebsal_basic_salary`, '{$key}')";
$expected[] = "hs_hr_emp_language";
mysql_connect($this->confObj->dbhost . ':' . $this->confObj->dbport, $this->confObj->dbuser, $this->confObj->dbpass);
mysql_select_db($this->confObj->dbname);
$result = CryptoQuery::prepareDecryptFields($fields);
$this->assertEquals($expected, $result);
}
/**
* @todo Implement testPrepareEncFields().
*/
public function testPrepareDecryptFields()
{
$key = KeyHandler::readKey();
$fields[] = 'emp_ssn_num';
$fields[] = 'ebsal_basic_salary';
$fields[] = 'hs_hr_emp_language';
$expected[] = "AES_DECRYPT(`emp_ssn_num`, '{$key}')";
$expected[] = "AES_DECRYPT(`ebsal_basic_salary`, '{$key}')";
$expected[] = "hs_hr_emp_language";
mysql_connect('localhost', 'root', MYSQL_ROOT_PASSWORD);
mysql_select_db('orangehrm');
$result = CryptoQuery::prepareDecryptFields($fields);
$this->assertEquals($expected, $result);
}
function simpleSelect($selectTable, $selectFields, $selectConditions = null, $selectOrderBy = null, $selectOrder = null, $selectLimit = null)
{
/* For Encryption : Begins */
$encOn = KeyHandler::KeyExists();
if ($encOn && CryptoQuery::isEncTable($this->table_name)) {
$selectFields = CryptoQuery::prepareDecryptFields($selectFields);
}
/* For Encryption : Ends */
$query = $this->_buildSelect($selectFields) . " FROM {$selectTable} ";
if (isset($selectConditions)) {
$query .= $this->_buildWhere($selectConditions);
}
if (isset($selectOrderBy)) {
$query .= " ORDER BY {$selectOrderBy} {$selectOrder}";
}
if (isset($selectLimit)) {
$query .= " LIMIT {$selectLimit}";
}
return $query;
}
