public function getWhere($Where = false, $OrderFields = '', $OrderDirection = 'asc', $Offset = false, $Limit = false)
{
if ($Offset < 0) {
$Offset = 0;
}
if (isset($Where['Operation'])) {
Gdn::sql()->whereIn('Operation', (array) $Where['Operation']);
unset($Where['Operation']);
}
$Result = Gdn::sql()->select('l.*')->select('ru.Name as RecordName, iu.Name as InsertName')->from('Log l')->join('User ru', 'l.RecordUserID = ru.UserID', 'left')->join('User iu', 'l.InsertUserID = iu.UserID', 'left')->where($Where)->limit($Limit, $Offset)->orderBy($OrderFields, $OrderDirection)->get()->resultArray();
// Deserialize the data.
foreach ($Result as &$Row) {
$Row['Data'] = dbdecode($Row['Data']);
if (!$Row['Data']) {
$Row['Data'] = [];
}
}
return $Result;
}