function addressShowCards(&$session, $message = null)
{
$session->trace(TC_Gui1, 'addressShowBook:');
guiStandardHeader($session, 'Anzeigen von Adressen', Th_AddressHeader, Th_AddressBodyStart);
if ($message != null) {
guiParagraph($session, $message, false);
}
guiStartForm($session);
guiHeadline($session, 2, 'Suchkriterien:');
$books = dbColumnList($session, Tab_Book, 'name', '1');
if (!isset($_POST['show_book'])) {
$_POST['show_book'] = $books[0];
}
echo 'Adressbuch: ';
guiComboBox('show_book', $books, null, null);
$fields = array('Name', 'Vorname', 'Spitzname', 'EMail', 'PLZ', 'Ort', 'Funktion', 'Notiz');
echo ' Auswahlkriterium: ';
guiComboBox('show_choice', $fields, null, null);
echo ' Suchmuster: ';
outTextField($session, 'show_pattern', null, 16);
echo ' ';
outButton($session, 'show_search', 'Suchen');
guiHeadline($session, 2, 'Ausgabefelder:');
outCheckBox($session, 'show_withname', 'Name');
echo ' ';
outCheckBox($session, 'show_withprivate', 'Privat');
echo ' ';
outCheckBox($session, 'show_withoffice', 'Geschäftlich');
echo ' ';
outCheckBox($session, 'show_withphone', 'Telefon');
echo ' ';
outCheckBox($session, 'show_withemail', 'EMail');
echo ' ';
outCheckBox($session, 'show_withaddress', 'Postadresse');
echo ' ';
outCheckBox($session, 'show_withfunction', 'Funktion');
echo ' ';
outCheckBox($session, 'show_withnote', 'Notiz');
echo ' ';
outCheckBox($session, 'show_withdate', 'Datum');
guiFinishForm($session, $session);
if (isset($_POST['show_pattern'])) {
$pattern = $_POST['show_pattern'];
if (empty($pattern)) {
$condidtion = '1';
} else {
$pattern = '%' . $pattern . '%';
switch ($_POST['show_choice']) {
case 'Name':
$condition = 'lastname like ' . dbSqlString($session, $pattern);
break;
case 'Vorname':
$condition = 'firstname like ' . dbSqlString($session, $pattern);
break;
case 'Spitzname':
$condition = 'nickname like ' . dbSqlString($session, $pattern);
break;
case 'EMail':
$condition = 'emailprivate like ' . dbSqlString($session, $pattern) . ' or emailprivate2 like ' . dbSqlString($session, $pattern) . ' or emailoffice like ' . dbSqlString($session, $pattern) . ' or emailoffice2 like ' . dbSqlString($session, $pattern);
break;
case 'PLZ':
$condition = 'zip like ' . dbSqlString($session, $pattern);
break;
case 'Ort':
$condition = 'city like ' . dbSqlString($session, $pattern);
break;
case 'Funktion':
$condition = 'function like ' . dbSqlString($session, $pattern);
break;
case 'Notiz':
$condition = 'note like ' . dbSqlString($session, $pattern);
break;
default:
$condition = '1';
break;
}
$what = 'lastname,firstname,country,zip,city,street,' . 'emailprivate,emailprivate2,phoneprivate,phoneprivate2,mobileprivate,faxprivate,' . 'emailoffice,emailoffice2,phoneoffice,phoneoffice2,mobileoffice,faxoffice,' . 'functions,notes,nickname,id,changedat,createdat';
addressPrintTable($session, "select {$what} from " . dbTable($session, Tab_Card) . " where {$condition}", 30);
}
}
guiStandardBodyEnd($session, Th_AddressBodyEnd);
}
function outTableCheckBox(&$session, $prefix, $name, $text, $selected = null, $halignment = AL_None)
{
if ($prefix != null) {
outTableCell($prefix);
}
outTableDelim($halignment);
outCheckBox($session, $name, $text, $selected);
echo TAG_TABLE_DELIM_END;
}
function admRename(&$session, $message)
{
$session->trace(TC_Gui1, 'admRename');
admStandardHeader($session, 'Umbenennen einer Seite');
if (!empty($message)) {
guiParagraph($session, $message, false);
}
guiStartForm($session);
outTableAndRecord();
outTableTextField($session, 'Bisheriger Name:', 'rename_oldname', null, 64, 64);
outTableRecordDelim();
outTableTextField($session, 'Neuer Name:', 'rename_newname', null, 64, 64);
outTableRecordDelim();
outTableCell(' ');
outTableDelim();
outButton($session, 'rename_info', 'Info');
if (!empty($_POST['rename_oldname']) && !empty($_POST['rename_newname'])) {
echo ' | ';
outButton($session, 'rename_rename', 'Umbenennen');
outNewline();
outCheckBox($session, 'rename_backlinks', 'Alle Verweise umbenennen', null);
}
outTableDelimAndRecordEnd();
outTableEnd();
guiFinishForm($session);
if (!empty($_POST['rename_oldname']) && dbPageId($session, $_POST['rename_oldname']) > 0) {
$row = dbFirstRecord($session, 'select page,text,createdby,createdat from ' . dbTable($session, T_Text) . ' where replacedby is null and text like ' . dbSqlString($session, '%' . $_POST['rename_oldname'] . '%'));
if (!$row) {
guiParagraph($session, '+++ keine Verweise gefunden', false);
} else {
outTableAndRecord(1);
outTableCellStrong('Seite');
outTableCellStrong('Typ');
outTableCellStrong('von');
outTableCellStrong('Letzte Änderung');
outTableCellStrong('Fundstelle');
outTableCellStrong('Seite');
outTableRecordEnd();
while ($row) {
$pagerecord = dbGetRecordById($session, T_Page, $row[0], 'name,type');
$text = findTextInLine($row[1], $_POST['rename_oldname'], 10, true);
if (!empty($text)) {
outTableRecord();
outTableInternLink($session, null, encodeWikiName($session, $pagerecord[0]), $pagerecord[0], M_Base);
outTableCell($pagerecord[1]);
outTableCell($row[2]);
outTableCell(htmlentities($row[3]));
outTableCell($text);
outTableRecordEnd();
}
$row = dbNextRecord($session);
}
outTableEnd();
}
}
admFinishBody($session);
}
