$addsql .= " WHERE ";
} else {
$addsql .= " AND ";
}
$addsql .= " `status`='" . $FORM['cstatus'] . "' ";
}
$sql = "select * from {$table} " . $addsql;
//echo $sql;
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setList(50);
$mit->setGlobalLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "" . $link . "&next=");
$mit->setValue("id", "id");
$mit->setValue("Nachricht an", "user_id");
$mit->setValueOrder(1);
$mit->setFormat("replace_value", $userReplaceValue);
$mit->setValue("Nachricht von", "from_user_id");
$mit->setValueOrder(1);
$mit->setFormat("replace_value", $userReplaceValue);
$mit->setValue("Datum", "stamp");
$mit->setValueOrder(1);
$mit->setFormat("unixToDateTime");
$mit->setValue("Status", "status");
$mit->setValueOrder(1);
$mit->setFormat("replace_value", "0|<span style='color:#cc6666;'>inaktiv</span>|1|<span style='color:#66cc66;'>aktiv</span>");
$mit->setValue("editieren", "");
$mit->setFormat("ifempty", "editieren");
$mit->setLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValue("löschen", "");
$mit->setFormat("ifempty", "löschen");
$mit->setFormat("link", "index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=delete&oid=", "id", "", " onclick=\"return confirm('sicher löschen ?');\"");
$addsql = "";
$link = "";
$ssql = new rex_sql();
$sql = "select * from {$table} order by prior";
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setList(50);
$mit->setGlobalLink("index.php?page=" . $page . "&subpage=" . $subpage . "" . $link . "&next=");
$mit->setValue("prior", "prior");
$mit->setValue("id", "id");
$mit->setValue("Name", "name");
$mit->setValueOrder(1);
$mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValue("Userfield", "userfield");
$mit->setValue("Typ", "type");
$mit->setFormat("replace_value", $rep);
$mit->setValue("In Übersicht", "inlist");
$mit->setFormat("replace_value", "0|nein|1|ja");
$mit->setValue("Editierbar", "editable");
$mit->setFormat("replace_value", "0|nein|1|ja");
$mit->setValue("Pflichtfeld", "mandatory");
$mit->setFormat("replace_value", "0|nein|1|ja");
$mit->setValue("löschen", "");
$mit->setFormat("ifempty", "- löschen");
$mit->setFormat("link", "index.php?page=" . $page . "&subpage=" . $subpage . "&func=delete&oid=", "id", "", " onclick=\"return confirm('sicher löschen ?');\"");
if (isset($FORM["ordername"]) && isset($FORM["ordertype"])) {
$mit->setOrder($FORM["ordername"], $FORM["ordertype"]);
}
echo $mit->showall(@$next);
// **************** bei jedem Aufruf Felder abgleichen
$err_msg = array();
$add_sql = "";
$link = "";
// ADD
echo '<table class="rex-table"><tr><td><a href="index.php?page=' . $page . '&subpage=' . $subpage . '&func=add"><b>+ ' . $bezeichner . ' hinzufügen</b></a></td></tr></table><br />';
$sql = "select * from {$table} " . $add_sql;
//echo $sql;
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setList(50);
$mit->setGlobalLink("index.php?page=" . $page . "&subpage=" . $subpage . "" . $link . "&next=");
$mit->setValue("id", "id");
$mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValue("article_id", "article_id");
$mit->setValueOrder(1);
$mit->setValue("user_id", "user_id");
$mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValueOrder(1);
$mit->setValue("status", "status");
$mit->setValue("editieren", "");
$mit->setFormat("ifempty", "editieren");
$mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValue("löschen", "");
$mit->setFormat("ifempty", "löschen");
$mit->setFormat("link", "index.php?page=" . $page . "&subpage=" . $subpage . "&func=delete&oid=", "id", "", " onclick=\"return confirm('sicher löschen ?');\"");
if (isset($FORM["ordername"]) && isset($FORM["ordertype"])) {
$mit->setOrder($FORM["ordername"], $FORM["ordertype"]);
}
$next = rex_request("next", "int", "0");
echo $mit->showall($next);
echo "<br />";
}
$delsql->debugsql = 0;
$delsql->setQuery($query);
$func = "";
}
//------------------------------> Userliste
if ($func == "") {
echo "<table class=rex cellpadding=5 cellspacing=1>\n\t\t<form action=index.php method=get>\n\t\t<input type=hidden name=page value=newsletter>\n\t\t<input type=hidden name=subpage value=user>\n\t\t<tr>\n\t\t<td width=100><b>Suche:</b></td>\n\t\t<td><input type=text size=30 class=inp100 name=searchtxt value='" . htmlspecialchars($_REQUEST["searchtxt"]) . "'></td>\n\t\t<td width=500><input type=submit value='Suche starten'></td>\n\t\t</tr>\n\t\t</form>\n\t\t</table><br>";
$addsql = "";
if ($_REQUEST["searchtxt"] != "") {
$addsql = "where email LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
$addsql .= "or name LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
$addsql .= "or firstname LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
$addsql .= "or last_nlid LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
}
$sql = "select * from rex_8_newsletter {$addsql} order by name";
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setGlobalLink("index.php?page=" . $mypage . "&subpage=user&searchtxt=" . urlencode($_REQUEST["searchtxt"]) . "&next=");
//$mit->setValue("id","id");
$mit->setValue("E-Mail", "email");
$mit->setLink("index.php?page=" . $mypage . "&func=edit&oid=", "id");
$mit->setValue("Name", "name");
$mit->setLink("index.php?page=" . $mypage . "&func=edit&oid=", "id");
$mit->setValue("Vorname", "firstname");
$mit->setValue("Aktion ID", "last_nlid");
$mit->setValue("Status", "status");
$mit->setFormat("replace_value", "0|<span style='color:#cc6666;'>inaktiv</span>|1|<span style='color:#66cc66;'>aktiv</span>");
$mit->addColumn("löschen", "index.php?page=" . $mypage . "&subpage=user&func=delete&oid=", "id", " onclick=\"return confirm('sicher löschen ?');\"");
echo $mit->showall($next);
echo "<br><br><a href=index.php?page=" . $mypage . "&subpage=user&func=add><b>User anlegen</b></a><br>";
}
