public static function get_list($_FORM)
{
$filter = reminder::get_list_filter($_FORM);
if (is_array($filter) && count($filter)) {
$f = " WHERE " . implode(" AND ", $filter);
}
$db = new db_alloc();
$q = "SELECT reminder.*,reminderRecipient.*,token.*,tokenAction.*, reminder.reminderID as rID\n FROM reminder\n LEFT JOIN reminderRecipient ON reminder.reminderID = reminderRecipient.reminderID\n LEFT JOIN token ON reminder.reminderHash = token.tokenHash\n LEFT JOIN tokenAction ON token.tokenActionID = tokenAction.tokenActionID\n " . $f . "\n GROUP BY reminder.reminderID\n ORDER BY reminderTime,reminderType";
$db->query($q);
while ($row = $db->row()) {
$reminder = new reminder();
$reminder->read_db_record($db);
$rows[$row['reminderID']] = $row;
}
return $rows;
}
