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; }