function Search($num_rec_per_page = 0, $page = 1)
{
$this->MakeSafe();
// This will store all our extended sql
$sqlextend = "";
foreach ($this as $prop => $val) {
if ($val && $val != date("Y-m-d", strtotime(0))) {
extendsql($prop, $val, $sqlextend, true);
}
}
$sqlextend .= " ORDER BY Time DESC";
// Make sure someone didn't do something crazy with the input
$page = intval($page);
$num_rec_per_page = intval($num_rec_per_page);
if ($page && $num_rec_per_page) {
$start_from = ($page - 1) * $num_rec_per_page;
$sqlextend .= " LIMIT {$start_from}, {$num_rec_per_page}";
}
$sql = "SELECT * FROM fac_GenericLog{$sqlextend};";
$events = array();
foreach ($this->query($sql) as $dbRow) {
$events[] = LogActions::RowToObject($dbRow);
}
return $events;
}
function Search($num_rec_per_page = 0, $page = 1)
{
$this->MakeSafe();
// This will store all our extended sql
$sqlextend = "";
function findit($prop, $val, &$sql)
{
if ($sql) {
$sql .= " AND {$prop}=\"{$val}\"";
} else {
$sql .= " WHERE {$prop} LIKE \"%{$val}%\"";
}
}
foreach ($this as $prop => $val) {
if ($val && $val != "1969-12-31") {
findit($prop, $val, $sqlextend);
}
}
$sqlextend .= " ORDER BY Time DESC";
// Make sure someone didn't do something crazy with the input
$page = intval($page);
$num_rec_per_page = intval($num_rec_per_page);
if ($page && $num_rec_per_page) {
$start_from = ($page - 1) * $num_rec_per_page;
$sqlextend .= " LIMIT {$start_from}, {$num_rec_per_page}";
}
$sql = "SELECT * FROM fac_GenericLog{$sqlextend};";
$events = array();
foreach ($this->query($sql) as $dbRow) {
$events[] = LogActions::RowToObject($dbRow);
}
return $events;
}
