function htmlUserBar()
{
global $adminConfig, $Translation;
if (!defined('PREPEND_PATH')) {
define('PREPEND_PATH', '');
}
ob_start();
$home_page = basename($_SERVER['PHP_SELF']) == 'index.php' ? true : false;
?>
<nav class="navbar navbar-default navbar-fixed-top hidden-print" role="navigation">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<!-- application title is obtained from the name besides the yellow database icon in AppGini, use underscores for spaces -->
<a class="navbar-brand" href="<?php
echo PREPEND_PATH;
?>
index.php"><i class="glyphicon glyphicon-home"></i> FWLDBA</a>
</div>
<div class="collapse navbar-collapse">
<ul class="nav navbar-nav">
<?php
if (!$home_page) {
?>
<?php
echo NavMenus();
?>
<?php
}
?>
</ul>
<?php
if (getLoggedAdmin()) {
?>
<ul class="nav navbar-nav">
<a href="<?php
echo PREPEND_PATH;
?>
admin/pageHome.php" class="btn btn-danger navbar-btn hidden-xs"><i class="glyphicon glyphicon-cog"></i> <?php
echo $Translation['admin area'];
?>
</a>
<a href="<?php
echo PREPEND_PATH;
?>
admin/pageHome.php" class="btn btn-danger navbar-btn visible-xs btn-lg"><i class="glyphicon glyphicon-cog"></i> <?php
echo $Translation['admin area'];
?>
</a>
</ul>
<?php
}
?>
<?php
if (!$_GET['signIn'] && !$_GET['loginFailed']) {
?>
<?php
if (getLoggedMemberID() == $adminConfig['anonymousMember']) {
?>
<a href="<?php
echo PREPEND_PATH;
?>
index.php?signIn=1" class="btn btn-success navbar-btn navbar-right"><?php
echo $Translation['sign in'];
?>
</a>
<p class="navbar-text navbar-right">
<?php
echo $Translation['not signed in'];
?>
</p>
<?php
} else {
?>
<ul class="nav navbar-nav navbar-right hidden-xs" style="min-width: 330px;">
<a class="btn navbar-btn btn-default" href="<?php
echo PREPEND_PATH;
?>
index.php?signOut=1"><i class="glyphicon glyphicon-log-out"></i> <?php
echo $Translation['sign out'];
?>
</a>
<p class="navbar-text">
<?php
echo $Translation['signed as'];
?>
<strong><a href="<?php
echo PREPEND_PATH;
?>
membership_profile.php" class="navbar-link"><?php
echo getLoggedMemberID();
?>
</a></strong>
</p>
</ul>
<ul class="nav navbar-nav visible-xs">
<a class="btn navbar-btn btn-default btn-lg visible-xs" href="<?php
echo PREPEND_PATH;
?>
index.php?signOut=1"><i class="glyphicon glyphicon-log-out"></i> <?php
echo $Translation['sign out'];
?>
</a>
<p class="navbar-text text-center">
<?php
echo $Translation['signed as'];
?>
<strong><a href="<?php
echo PREPEND_PATH;
?>
membership_profile.php" class="navbar-link"><?php
echo getLoggedMemberID();
?>
</a></strong>
</p>
</ul>
<?php
}
?>
<?php
}
?>
</div>
</nav>
<?php
$html = ob_get_contents();
ob_end_clean();
return $html;
}
function Render()
{
// get post and get variables
global $Translation;
$FiltersPerGroup = 4;
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
$SortField = $_GET["SortField"];
$SortDirection = $_GET["SortDirection"];
$FirstRecord = $_GET["FirstRecord"];
$ScrollUp_y = $_GET["ScrollUp_y"];
$ScrollDn_y = $_GET["ScrollDn_y"];
$Previous_x = $_GET["Previous_x"];
$Next_x = $_GET["Next_x"];
$Filter_x = $_GET["Filter_x"];
$SaveFilter_x = $_GET["SaveFilter_x"];
$NoFilter_x = $_GET["NoFilter_x"];
$CancelFilter = $_GET["CancelFilter"];
$ApplyFilter = $_GET["ApplyFilter"];
$Search_x = $_GET["Search_x"];
$SearchString = get_magic_quotes_gpc() ? stripslashes($_GET['SearchString']) : $_GET['SearchString'];
$CSV_x = $_GET["CSV_x"];
$FilterAnd = $_GET["FilterAnd"];
$FilterField = $_GET["FilterField"];
$FilterOperator = $_GET["FilterOperator"];
if (is_array($_GET['FilterValue'])) {
foreach ($_GET['FilterValue'] as $fvi => $fv) {
$FilterValue[$fvi] = get_magic_quotes_gpc() ? stripslashes($fv) : $fv;
}
}
$Print_x = $_GET["Print_x"];
$SelectedID = get_magic_quotes_gpc() ? stripslashes($_GET['SelectedID']) : $_GET['SelectedID'];
$insert_x = $_GET["insert_x"];
$update_x = $_GET["update_x"];
$delete_x = $_GET["delete_x"];
$SkipChecks = $_GET['confirmed'];
$deselect_x = $_GET["deselect_x"];
$addNew_x = $_GET["addNew_x"];
$dvprint_x = $_GET['dvprint_x'];
} else {
$SortField = $_POST["SortField"];
$SortDirection = $_POST["SortDirection"];
$FirstRecord = $_POST["FirstRecord"];
$ScrollUp_y = $_POST["ScrollUp_y"];
$ScrollDn_y = $_POST["ScrollDn_y"];
$Previous_x = $_POST["Previous_x"];
$Next_x = $_POST["Next_x"];
$Filter_x = $_POST["Filter_x"];
$SaveFilter_x = $_POST["SaveFilter_x"];
$NoFilter_x = $_POST["NoFilter_x"];
$CancelFilter = $_POST["CancelFilter"];
$ApplyFilter = $_POST["ApplyFilter"];
$Search_x = $_POST["Search_x"];
$SearchString = get_magic_quotes_gpc() ? stripslashes($_POST['SearchString']) : $_POST['SearchString'];
$CSV_x = $_POST["CSV_x"];
$FilterAnd = $_POST['FilterAnd'];
$FilterField = $_POST['FilterField'];
$FilterOperator = $_POST['FilterOperator'];
if (is_array($_POST['FilterValue'])) {
foreach ($_POST['FilterValue'] as $fvi => $fv) {
$FilterValue[$fvi] = get_magic_quotes_gpc() ? stripslashes($fv) : $fv;
}
}
$Print_x = $_POST['Print_x'];
$PrintTV = $_POST['PrintTV'];
$PrintDV = $_POST['PrintDV'];
$SelectedID = get_magic_quotes_gpc() ? stripslashes($_POST['SelectedID']) : $_POST['SelectedID'];
$insert_x = $_POST['insert_x'];
$update_x = $_POST['update_x'];
$delete_x = $_POST['delete_x'];
$SkipChecks = $_POST['confirmed'];
$deselect_x = $_POST['deselect_x'];
$addNew_x = $_POST['addNew_x'];
$dvprint_x = $_POST['dvprint_x'];
}
// insure authenticity of user inputs:
if (!$this->AllowDelete) {
$delete_x = "";
}
if (!$this->AllowDeleteOfParents) {
$SkipChecks = "";
}
if (!$this->AllowInsert) {
$insert_x = "";
$addNew_x = "";
}
if (!$this->AllowUpdate) {
$update_x = "";
}
if (!$this->AllowFilters) {
$Filter_x = "";
}
if (!$this->AllowPrinting) {
$Print_x = '';
$PrintDV = '';
$PrintTV = '';
}
if (!$this->AllowPrintingMultiSelection) {
$PrintDV = '';
$PrintTV = '';
}
if (!$this->QuickSearch) {
$SearchString = "";
}
if (!$this->AllowCSV) {
$CSV_x = "";
}
// enforce record selection if user has edit/delete permissions on the current table
$AllowPrintDV = 1;
$this->Permissions = getTablePermissions($this->TableName);
if ($this->Permissions[3] || $this->Permissions[4]) {
// current user can edit or delete?
$this->AllowSelection = 1;
} elseif (!$this->AllowSelection) {
$SelectedID = '';
$AllowPrintDV = 0;
$PrintDV = '';
}
if (!$this->AllowSelection || !$SelectedID) {
$dvprint_x = '';
}
$this->QueryFieldsIndexed = reIndex($this->QueryFieldsFilters);
$this->HTML .= '<form method="post" name="myform" action="' . $this->ScriptFileName . '">';
$this->HTML .= '<input type="submit" style="position: absolute; left: 0px; top: -100px;" onclick="return false;">';
$this->ContentType = 'tableview';
// default content type
// handle user commands ...
if ($PrintTV != '') {
$Print_x = 1;
$_POST['Print_x'] = 1;
}
if ($deselect_x != '') {
$SelectedID = '';
$this->showTV();
} elseif ($insert_x != '') {
$SelectedID = call_user_func($this->TableName . '_insert');
// redirect to a safe url to avoid refreshing and thus
// insertion of duplicate records.
// compose filters and sorting
for ($i = 1; $i <= 20 * $FiltersPerGroup; $i++) {
// Number of filters allowed
if ($FilterField[$i] != "" && $FilterOperator[$i] != "" && ($FilterValue[$i] != "" || strstr($FilterOperator[$i], 'Empty'))) {
$filtersGET .= "&FilterAnd[{$i}]={$FilterAnd[$i]}&FilterField[{$i}]={$FilterField[$i]}&FilterOperator[{$i}]={$FilterOperator[$i]}&FilterValue[{$i}]=" . urlencode($FilterValue[$i]);
}
}
$filtersGET .= "&SortField={$SortField}&SortDirection={$SortDirection}&FirstRecord={$FirstRecord}";
$filtersGET = substr($filtersGET, 1);
// remove initial &
if ($this->RedirectAfterInsert != "") {
if (strpos($this->RedirectAfterInsert, '?')) {
$this->RedirectAfterInsert .= '&record-added-ok=' . rand();
} else {
$this->RedirectAfterInsert .= '?record-added-ok=' . rand();
}
if (strpos($this->RedirectAfterInsert, $this->ScriptFileName) !== false) {
$this->RedirectAfterInsert .= '&' . $filtersGET;
}
$this->HTML .= "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0;url=" . str_replace("#ID#", urlencode($SelectedID), $this->RedirectAfterInsert) . "\">";
return;
} else {
$this->HTML .= '<META HTTP-EQUIV="Refresh" CONTENT="0;url=' . $this->ScriptFileName . '?SelectedID=' . urlencode($SelectedID) . '&' . $filtersGET . '">';
return;
}
} elseif ($delete_x != "") {
$d = call_user_func($this->TableName . '_delete', $SelectedID, $this->AllowDeleteOfParents, $SkipChecks);
if ($d) {
$this->HTML .= "<div class=Error>" . $Translation['error:'] . " {$d}</div>";
} else {
$SelectedID = "";
$this->showTV();
}
} elseif ($update_x != "") {
call_user_func($this->TableName . '_update', $SelectedID);
// compose filters and sorting
for ($i = 1; $i <= 20 * $FiltersPerGroup; $i++) {
// Number of filters allowed
if ($FilterField[$i] != "" && $FilterOperator[$i] != "" && ($FilterValue[$i] != "" || strstr($FilterOperator[$i], 'Empty'))) {
$filtersGET .= "&FilterAnd[{$i}]={$FilterAnd[$i]}&FilterField[{$i}]={$FilterField[$i]}&FilterOperator[{$i}]={$FilterOperator[$i]}&FilterValue[{$i}]=" . urlencode($FilterValue[$i]);
}
}
$filtersGET .= "&SortField={$SortField}&SortDirection={$SortDirection}&FirstRecord={$FirstRecord}";
$filtersGET = substr($filtersGET, 1);
// remove initial &
$this->HTML .= '<META HTTP-EQUIV="Refresh" CONTENT="0;url=' . $this->ScriptFileName . '?SelectedID=' . urlencode($SelectedID) . '&' . $filtersGET . '&record-updated-ok=' . rand() . '">';
return;
} elseif ($addNew_x != "") {
$SelectedID = '';
$this->hideTV();
} elseif ($Print_x != "") {
// print code here ....
$this->AllowNavigation = 0;
$this->AllowSelection = 0;
} elseif ($SaveFilter_x != "" && $this->AllowSavingFilters) {
$this->HTML .= "<table width=550 border=0 align=center><tr><td class=TableTitle>" . $Translation["saved filters title"] . "</td></tr>";
$this->HTML .= "\n\t<tr><td class=TableHeader>" . $Translation["saved filters instructions"] . "</td></tr>";
$this->HTML .= "\n\t<tr><td class=TableHeader><textarea cols=60 rows=12 wrap=off>";
$SourceCode = "<html><body>\n";
$SourceCode .= '<form method="post" action="' . $_SERVER['HTTP_REFERER'] . '">' . "\n";
for ($i = 1; $i <= 20 * $FiltersPerGroup; $i++) {
// Number of filters allowed
if ($i % $FiltersPerGroup == 1 && $i != 1 && $FilterAnd[$i] != "") {
$SourceCode .= "\t<input name=FilterAnd[{$i}] value='{$FilterAnd[$i]}' type=hidden>\n";
}
if ($FilterField[$i] != "" && $FilterOperator[$i] != "" && ($FilterValue[$i] != "" || strstr($FilterOperator[$i], 'Empty'))) {
if (!strstr($SourceCode, "\t<input name=FilterAnd[{$i}] value=")) {
$SourceCode .= "\t<input name=FilterAnd[{$i}] value='{$FilterAnd[$i]}' type=hidden>\n";
}
$SourceCode .= "\t<input name=FilterField[{$i}] value='{$FilterField[$i]}' type=hidden>\n";
$SourceCode .= "\t<input name=FilterOperator[{$i}] value='{$FilterOperator[$i]}' type=hidden>\n";
$SourceCode .= "\t<input name=FilterValue[{$i}] value='" . htmlspecialchars($FilterValue[$i], ENT_QUOTES) . "' type=hidden>\n\n";
}
}
$SourceCode .= "\n\t<input type=submit value=\"Show Filtered Data\">\n";
$SourceCode .= "</form>\n</body></html>";
$this->HTML .= $SourceCode;
$this->HTML .= "</textarea>";
$this->HTML .= "<br /><input type=submit value=\"" . $Translation["hide code"] . "\">";
$this->HTML .= "\n\t</table>\n\n";
} elseif ($Filter_x != "") {
if ($this->FilterPage != "") {
ob_start();
@(include $this->FilterPage);
$out = ob_get_contents();
ob_end_clean();
$this->HTML .= $out;
} else {
// filter page code here .....
$this->HTML .= '<table border="0" align="center"><tr><td colspan="4" class="TableTitle">' . $this->TableTitle . " " . $Translation['filters'] . "</td></tr>";
$this->HTML .= "\n\t<tr><td class=\"TableHeader\"></td><td class=\"TableHeader\">" . $Translation['filtered field'] . '</td><td class="TableHeader">' . $Translation['comparison operator'] . '</td><td class="TableHeader">' . $Translation['comparison value'] . '</td></tr>';
$this->HTML .= "\n\t<tr><td colspan=\"4\" class=\"TableHeader\"></td></tr>";
for ($i = 1; $i <= 3 * $FiltersPerGroup; $i++) {
// Number of filters allowed
$fields = "";
$operators = "";
if ($i % $FiltersPerGroup == 1 && $i != 1) {
$this->HTML .= "\n\t<tr><td colspan=4 class=TableHeader></td></tr>";
$this->HTML .= "\n\t<tr><td colspan=4 align=center>";
$seland = new Combo();
$seland->ListItem = array($Translation["or"], $Translation["and"]);
$seland->ListData = array("or", "and");
$seland->SelectName = "FilterAnd[{$i}]";
$seland->SelectedData = $FilterAnd[$i];
$seland->Render();
$this->HTML .= $seland->HTML . "</td></tr>";
$this->HTML .= "\n\t<tr><td colspan=4 class=TableHeader></td></tr>";
}
$this->HTML .= "\n\t<tr><td class=TableHeader style='text-align:left;'> " . $Translation["filter"] . sprintf("%02d", $i) . " ";
// And, Or select
if ($i % $FiltersPerGroup != 1) {
$seland = new Combo();
$seland->ListItem = array($Translation["and"], $Translation["or"]);
$seland->ListData = array("and", "or");
$seland->SelectName = "FilterAnd[{$i}]";
$seland->SelectedData = $FilterAnd[$i];
$seland->Render();
$this->HTML .= $seland->HTML . "</td>";
} else {
$this->HTML .= "</td>";
}
// Fields list
$selfields = new Combo();
$selfields->SelectName = "FilterField[{$i}]";
$selfields->SelectedData = $FilterField[$i];
$selfields->ListItem = array_values($this->QueryFieldsFilters);
$selfields->ListData = array_keys($this->QueryFieldsIndexed);
$selfields->Render();
$this->HTML .= "\n\t\t<td>{$selfields->HTML}</td>";
// Operators list
$selop = new Combo();
$selop->ListItem = array($Translation["equal to"], $Translation["not equal to"], $Translation["greater than"], $Translation["greater than or equal to"], $Translation["less than"], $Translation["less than or equal to"], $Translation["like"], $Translation["not like"], $Translation["is empty"], $Translation["is not empty"]);
$selop->ListData = array("<=>", "!=", ">", ">=", "<", "<=", "like", "not like", "isEmpty", "isNotEmpty");
$selop->SelectName = "FilterOperator[{$i}]";
$selop->SelectedData = $FilterOperator[$i];
$selop->Render();
$this->HTML .= "\n\t\t<td>{$selop->HTML}</td>";
// Comparison expression
$this->HTML .= "\n\t\t<td><input size=25 type=text name=FilterValue[{$i}] value=\"" . htmlspecialchars($FilterValue[$i], ENT_QUOTES) . "\" class=TextBox></td></tr>";
if (!$i % $FiltersPerGroup) {
$this->HTML .= "\n\t<tr><td colspan=4 class=TableHeader></td></tr>";
}
}
$this->HTML .= "\n\t<tr><td colspan=4 class=TableHeader></td></tr>";
$this->HTML .= "\n\t<tr><td colspan=4 align=right><input type=image src=applyFilters.gif alt='" . $Translation["apply filters"] . "'>" . ($this->AllowSavingFilters ? " <input type=image src=save_search.gif alt='" . $Translation["save filters"] . "' name=SaveFilter>" : "") . "</td></tr>";
$this->HTML .= "\n</table>";
}
// hidden variables ....
$this->HTML .= "<input name=SortField value='" . (is_numeric($SortField) ? $SortField : $SortFieldNumeric) . "' type=hidden>";
$this->HTML .= "<input name=SortDirection type=hidden value='{$SortDirection}'>";
$this->HTML .= "<input name=FirstRecord type=hidden value='1'>";
$this->ContentType = 'filters';
return;
} elseif ($NoFilter_x != "") {
// clear all filters ...
for ($i = 1; $i <= 20 * $FiltersPerGroup; $i++) {
// Number of filters allowed
$FilterField[$i] = "";
$FilterOperator[$i] = "";
$FilterValue[$i] = "";
}
$SearchString = "";
} elseif ($SelectedID) {
$this->hideTV();
}
if ($SearchString != '') {
if ($Search_x != '') {
$FirstRecord = 1;
}
if ($this->QueryWhere == '') {
$this->QueryWhere = "where ";
} else {
$this->QueryWhere .= " and ";
}
foreach ($this->QueryFieldsQS as $fName => $fCaption) {
if (strpos($fName, '<img') === False) {
$this->QuerySearchableFields[$fName] = $fCaption;
}
}
$this->QueryWhere .= '(' . implode(" LIKE '%" . makeSafe($SearchString) . "%' or ", array_keys($this->QuerySearchableFields)) . " LIKE '%" . makeSafe($SearchString) . "%')";
}
// set query filters
$QueryHasWhere = 0;
if (strpos($this->QueryWhere, 'where ') !== FALSE) {
$QueryHasWhere = 1;
}
$WhereNeedsClosing = 0;
for ($i = 1; $i <= 20 * $FiltersPerGroup; $i += $FiltersPerGroup) {
// Number of filters allowed
// test current filter group
$GroupHasFilters = 0;
for ($j = 0; $j < $FiltersPerGroup; $j++) {
if ($FilterField[$i + $j] != "" && $FilterOperator[$i + $j] != "" && ($FilterValue[$i + $j] != "" || strstr($FilterOperator[$i + $j], 'Empty'))) {
$GroupHasFilters = 1;
break;
}
}
if ($GroupHasFilters) {
if (!stristr($this->QueryWhere, "where ")) {
$this->QueryWhere = "where (";
} elseif ($QueryHasWhere) {
$this->QueryWhere .= " and (";
$QueryHasWhere = 0;
}
$this->QueryWhere .= " <FilterGroup> " . $FilterAnd[$i] . " (";
for ($j = 0; $j < $FiltersPerGroup; $j++) {
if ($FilterField[$i + $j] != "" && $FilterOperator[$i + $j] != "" && ($FilterValue[$i + $j] != "" || strstr($FilterOperator[$i + $j], 'Empty'))) {
if ($FilterAnd[$i + $j] == '') {
$FilterAnd[$i + $j] = 'and';
}
// test for date/time fields
$tries = 0;
$isDateTime = FALSE;
$isDate = FALSE;
$fieldName = str_replace('`', '', $this->QueryFieldsIndexed[$FilterField[$i + $j]]);
list($tn, $fn) = explode('.', $fieldName);
while (!($res = sql("show columns from `{$tn}` like '{$fn}'")) && $tries < 2) {
$tn = substr($tn, 0, -1);
$tries++;
}
if ($row = @mysql_fetch_array($res)) {
if ($row['Type'] == 'date' || $row['Type'] == 'time') {
$isDateTime = TRUE;
if ($row['Type'] == 'date') {
$isDate = True;
}
}
}
// end of test
if ($FilterOperator[$i + $j] == 'isEmpty' && !$isDateTime) {
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " (" . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . "='' or " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . " is NULL) </FilterItem>";
} elseif ($FilterOperator[$i + $j] == 'isNotEmpty' && !$isDateTime) {
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . "!='' </FilterItem>";
} elseif ($FilterOperator[$i + $j] == 'isEmpty' && $isDateTime) {
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " (" . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . "=0 or " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . " is NULL) </FilterItem>";
} elseif ($FilterOperator[$i + $j] == 'isNotEmpty' && $isDateTime) {
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . "!=0 </FilterItem>";
} elseif ($FilterOperator[$i + $j] == 'like' && !strstr($FilterValue[$i + $j], "%") && !strstr($FilterValue[$i + $j], "_")) {
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . " " . $FilterOperator[$i + $j] . " '%" . makeSafe($FilterValue[$i + $j]) . "%' </FilterItem>";
} elseif ($FilterOperator[$i + $j] == 'not like' && !strstr($FilterValue[$i + $j], "%") && !strstr($FilterValue[$i + $j], "_")) {
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . " " . $FilterOperator[$i + $j] . " '%" . makeSafe($FilterValue[$i + $j]) . "%' </FilterItem>";
} elseif ($isDate) {
$dateValue = toMySQLDate($FilterValue[$i + $j]);
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . " " . $FilterOperator[$i + $j] . " '{$dateValue}' </FilterItem>";
} else {
$this->QueryWhere .= " <FilterItem> " . $FilterAnd[$i + $j] . " " . $this->QueryFieldsIndexed[$FilterField[$i + $j]] . " " . $FilterOperator[$i + $j] . " '" . makeSafe($FilterValue[$i + $j]) . "' </FilterItem>";
}
}
}
$this->QueryWhere .= ") </FilterGroup>";
$WhereNeedsClosing = 1;
}
}
if ($WhereNeedsClosing) {
$this->QueryWhere .= ")";
}
// set query sort
if (!stristr($this->QueryOrder, "order by ") && $SortField != "" && $this->AllowSorting) {
$this->QueryOrder = "order by {$SortField} {$SortDirection}";
}
// clean up query
$this->QueryWhere = str_replace("( <FilterGroup> and ", "( ", $this->QueryWhere);
$this->QueryWhere = str_replace("( <FilterGroup> or ", "( ", $this->QueryWhere);
$this->QueryWhere = str_replace("( <FilterItem> and ", "( ", $this->QueryWhere);
$this->QueryWhere = str_replace("( <FilterItem> or ", "( ", $this->QueryWhere);
$this->QueryWhere = str_replace("<FilterGroup>", "", $this->QueryWhere);
$this->QueryWhere = str_replace("</FilterGroup>", "", $this->QueryWhere);
$this->QueryWhere = str_replace("<FilterItem>", "", $this->QueryWhere);
$this->QueryWhere = str_replace("</FilterItem>", "", $this->QueryWhere);
// if no 'order by' clause found, apply default sorting if specified
if ($this->DefaultSortField != "" && $this->QueryOrder == '') {
$this->QueryOrder = "order by " . $this->DefaultSortField . " " . $this->DefaultSortDirection;
}
// get count of matching records ...
$TempQuery = 'SELECT count(1) from ' . $this->QueryFrom . ' ' . $this->QueryWhere;
$RecordCount = sqlValue($TempQuery);
$FieldCountTV = count($this->QueryFieldsTV);
$FieldCountCSV = count($this->QueryFieldsCSV);
$FieldCountFilters = count($this->QueryFieldsFilters);
if (!$RecordCount) {
$FirstRecord = 1;
}
// disable multi-selection if too many records to avoid browser performance issues
if ($RecordCount > 1000) {
$this->AllowPrintingMultiSelection = 0;
}
// Output CSV on request
if ($CSV_x != '') {
$this->HTML = '';
// execute query for CSV output
$fieldList = '';
foreach ($this->QueryFieldsCSV as $fn => $fc) {
$fieldList .= "{$fn} as `{$fc}`, ";
}
$fieldList = substr($fieldList, 0, -2);
$csvQuery = 'SELECT ' . $fieldList . ' from ' . $this->QueryFrom . ' ' . $this->QueryWhere . ' ' . $this->QueryOrder;
// hook: table_csv
if (function_exists($this->TableName . '_csv')) {
$args = array();
$mq = call_user_func($this->TableName . '_csv', $csvQuery, getMemberInfo(), $args);
$csvQuery = $mq ? $mq : $csvQuery;
}
$result = sql($csvQuery);
// output CSV field names
for ($i = 0; $i < $FieldCountCSV; $i++) {
$this->HTML .= "\"" . mysql_field_name($result, $i) . "\"" . $this->CSVSeparator;
}
$this->HTML .= "\n\n";
// output CSV data
while ($row = mysql_fetch_row($result)) {
for ($i = 0; $i < $FieldCountCSV; $i++) {
$this->HTML .= "\"" . str_replace(array("\r\n", "\r", "\n", '"'), array(' ', ' ', ' ', '""'), $row[$i]) . "\"" . $this->CSVSeparator;
}
$this->HTML .= "\n\n";
}
$this->HTML = str_replace($this->CSVSeparator . "\n\n", "\n", $this->HTML);
$this->HTML = substr($this->HTML, 0, strlen($this->HTML) - 1);
// clean any output buffers
while (@ob_end_clean()) {
}
// output CSV HTTP headers ...
header('HTTP/1.1 200 OK');
header('Date: ' . @date("D M j G:i:s T Y"));
header('Last-Modified: ' . @date("D M j G:i:s T Y"));
header("Content-Type: application/force-download");
header("Content-Lenght: " . (string) strlen($this->HTML));
header("Content-Transfer-Encoding: Binary");
header("Content-Disposition: attachment; filename={$this->TableName}.csv");
// send output and quit script
echo $this->HTML;
exit;
}
$t = time();
// just a random number for any purpose ...
//$this->HTML .= "<font face=garamond>".$this->Query."</font>"; // uncomment this line for debugging
// should SelectedID be reset on clicking TV buttons?
$resetSelection = $this->SeparateDV ? "document.myform.SelectedID.value=''; " : '';
// begin table and display table title
$this->HTML .= "<table align=center cellspacing=1 cellpadding=0 border=0><tr>\n";
$this->HTML .= "<td colspan=" . ($FieldCountTV + 2) . ">";
$sum_width = 0;
for ($i = 0; $i < count($this->ColWidth); $i++) {
$sum_width += $this->ColWidth[$i];
}
$this->HTML .= "<table" . ($this->HideTableView ? "" : " width=100%") . " cellspacing=0 cellpadding=0 border=0>" . ($dvprint_x && $this->AllowSelection && $SelectedID ? '' : "<tr><td align=left colspan=2><div class=TableTitle>{$this->TableTitle}</div><br /></td></tr>");
if (!$this->HideTableView && !($dvprint_x && $this->AllowSelection && $SelectedID) && !$PrintDV) {
$this->HTML .= "<tr>";
// display tables navigator menu
if ($Print_x == '') {
$this->HTML .= "<td align=left>" . NavMenus() . "</td>";
} else {
$this->HTML .= "\n<style type=\"text/css\">@media print{.displayOnly {display: none;}}</style>\n";
if ($this->AllowPrintingMultiSelection) {
$withSelected = '' . '<input class="print-button" type="button" id="selectAll" value="' . $Translation['Select all records'] . '" onClick="$(\'toggleAll\').checked=!$(\'toggleAll\').checked; toggleAllRecords();">' . '<span id="withSelected">' . '<input class="print-button" type="submit" name="PrintTV" value="' . $Translation['Print Preview Table View'] . '">' . ($AllowPrintDV ? '<input id="PrintDV" class="print-button" type="submit" name="PrintDV" value="' . $Translation['Print Preview Detail View'] . '">' : '') . '<input class="print-button" type="submit" name="Print_x" value="' . $Translation['Cancel Selection'] . '">' . ' </span>' . '<script>' . 'var countSelected=0; ' . 'document.observe(\'dom:loaded\', function(){ ' . 'setInterval("' . '$(\'withSelected\').style.display=(countSelected ? \'inline\' : \'none\');' . '", 500); ' . '});' . '</script>';
}
$this->HTML .= "\n" . '<td colspan="2" class="displayOnly" style="min-width: 65em;"><div>' . '<input class="print-button" type="submit" value="' . $Translation['Cancel Printing'] . '">' . '<input class="print-button" type="button" id="sendToPrinter" value="' . $Translation['Print'] . '" onClick="window.print();">' . $withSelected . '</div></td>' . "\n";
}
// display quick search box
if ($this->QuickSearch > 0 && $this->QuickSearch < 4 && $Print_x == '') {
if ($this->QuickSearch == 1 || $this->QuickSearch == 2) {
$this->HTML .= '</tr><tr>';
}
$this->HTML .= "<td><div class=TableBodySelected style='text-align:" . ($this->QuickSearch == 1 ? "left" : ($this->QuickSearch == 2 ? "center" : "right")) . ";'>";
$this->HTML .= "<nobr><b>" . $this->QuickSearchText . "</b> <input type=text name=SearchString value='" . htmlspecialchars($SearchString, ENT_QUOTES) . "' size=15 class=TextBox>";
$this->HTML .= "<input onClick=\"{$resetSelection} document.myform.NoDV.value=1;\" align=top border=0 name=Search type=image vspace=2 hspace=2 src=qsearch.gif alt='" . $this->QuickSearchText . "'>";
$this->HTML .= "</nobr></div></td>";
}
$this->HTML .= "</tr>";
$this->HTML .= "<tr><td colspan=2><div class=\"TableBody\" style=\"text-align:center;\"><nobr>";
// display 'Add New' icon
if ($this->Permissions[1] && $this->SeparateDV && $Print_x == '') {
$this->HTML .= " <input type=image src=addNew.gif name=addNew alt='" . $Translation['add new record'] . "'>";
}
// display Print icon
if ($this->AllowPrinting && $Print_x == '') {
$this->HTML .= " <input onClick=\"document.myform.NoDV.value=1;\" type=image src=print.gif name=Print alt='" . $Translation["printer friendly view"] . "'>";
}
// display CSV icon
if ($this->AllowCSV && $Print_x == '') {
$this->HTML .= " <input onClick=\"document.myform.NoDV.value=1;\" type=image src=csv.gif name=CSV alt='" . $Translation["save as csv"] . "'>";
}
// display Filter icons
if ($this->AllowFilters && $Print_x == '') {
$this->HTML .= " <input onClick=\"document.myform.NoDV.value=1;\" type=image src=search.gif name=Filter alt='" . $Translation["edit filters"] . "'> <input onClick=\"{$resetSelection} document.myform.NoDV.value=1;\" type=image src=cancel_search.gif name=NoFilter alt='" . $Translation["clear filters"] . "'> ";
}
$this->HTML .= "</nobr></div></td></tr>";
$this->HTML .= "<!--</td></tr>--></table></td></tr>";
$this->HTML .= "<tr><td class=TableHeader>" . ($this->AllowSelection ? " " : "") . "</td>";
if ($this->AllowPrintingMultiSelection && $Print_x != '') {
$this->HTML .= '<td class="TableHeader displayOnly" align="left"><input type="checkbox" title="' . $Translation['Select all records'] . '" id="toggleAll" onclick="toggleAllRecords();"></td>';
}
// Templates
if ($this->Template != '') {
$rowTemplate = @implode('', @file('./' . $this->Template));
if (!$rowTemplate) {
$rowTemplate = '';
$selrowTemplate = '';
} else {
if ($this->SelectedTemplate != '') {
$selrowTemplate = @implode('', @file('./' . $this->SelectedTemplate));
if (!$selrowTemplate) {
$selrowTemplate = '';
}
} else {
$selrowTemplate = '';
}
}
} else {
$rowTemplate = '';
$selrowTemplate = '';
}
// process translations
if ($rowTemplate) {
foreach ($Translation as $symbol => $trans) {
$rowTemplate = str_replace("<%%TRANSLATION({$symbol})%%>", $trans, $rowTemplate);
}
}
if ($selrowTemplate) {
foreach ($Translation as $symbol => $trans) {
$selrowTemplate = str_replace("<%%TRANSLATION({$symbol})%%>", $trans, $selrowTemplate);
}
}
// End of templates
// display table headers
global $SortFieldNumeric;
if ($rowTemplate == '' || $this->ShowTableHeader == 1) {
for ($i = 0; $i < count($this->ColCaption); $i++) {
if ($this->AllowSorting == 1) {
$sort1 = "<a href=\"{$this->ScriptFileName}?SortDirection=asc&SortField=" . $this->ColNumber[$i] . "\" onClick=\"{$resetSelection} document.myform.NoDV.value=1; document.myform.SortDirection.value='asc'; document.myform.SortField.value = '" . $this->ColNumber[$i] . "'; document.myform.submit(); return false;\" class=\"TableHeader\">";
$sort2 = "</a>";
if ($this->ColNumber[$i] == $SortField || $this->ColNumber[$i] == $SortFieldNumeric) {
$SortDirection = $SortDirection == "asc" ? "desc" : "asc";
$sort1 = "<a href=\"{$this->ScriptFileName}?SortDirection={$SortDirection}&SortField=" . $this->ColNumber[$i] . "\" onClick=\"{$resetSelection} document.myform.NoDV.value=1; document.myform.SortDirection.value='{$SortDirection}'; document.myform.SortField.value = " . $this->ColNumber[$i] . "; document.myform.submit(); return false;\" class=\"TableHeader\"><img src=\"{$SortDirection}.gif\" border=\"0\" hspace=\"3\">";
$SortDirection = $SortDirection == "asc" ? "desc" : "asc";
}
} else {
$sort1 = '';
$sort2 = '';
}
$this->HTML .= "\t<td valign=top nowrap width='" . ($this->ColWidth[$i] ? $this->ColWidth[$i] : 100) . "' class=TableHeader><div class=TableHeader>{$sort1}" . $this->ColCaption[$i] . "{$sort2}</div></td>\n";
}
} else {
// Display a Sort by drop down
$this->HTML .= "\t<td valign=top class=TableHeader colspan=" . ($FieldCountTV + 1) . "><div class=TableHeader>";
if ($this->AllowSorting == 1) {
$sortCombo = new Combo();
//$sortCombo->ListItem[] = "";
//$sortCombo->ListData[] = "";
for ($i = 0; $i < count($this->ColCaption); $i++) {
$sortCombo->ListItem[] = $this->ColCaption[$i];
$sortCombo->ListData[] = $this->ColNumber[$i];
}
$sortCombo->SelectName = "FieldsList";
$sortCombo->SelectedData = is_numeric($SortField) ? $SortField : $SortFieldNumeric;
$sortCombo->Class = 'TableBody';
$sortCombo->SelectedClass = 'TableBodySelected';
$sortCombo->Render();
$d = $sortCombo->HTML;
$d = str_replace('<select ', "<select onChange=\"document.myform.SortDirection.value='{$SortDirection}'; document.myform.SortField.value=document.myform.FieldsList.value; document.myform.NoDV.value=1; document.myform.submit();\" ", $d);
if ($SortField) {
$SortDirection = $SortDirection == "desc" ? "asc" : "desc";
$sort = "<a href=\"javascript: document.myform.NoDV.value=1; document.myform.SortDirection.value='{$SortDirection}'; document.myform.SortField.value='{$SortField}'; document.myform.submit();\" class=TableHeader><img src={$SortDirection}.gif border=0 width=11 height=11 hspace=3></a>";
$SortDirection = $SortDirection == "desc" ? "asc" : "desc";
} else {
$sort = '';
}
$this->HTML .= $Translation['order by'] . " {$d} {$sort}";
}
$this->HTML .= "</div></td>\n";
}
// table view navigation code ...
if ($RecordCount && $this->AllowNavigation && $RecordCount > $this->RecordsPerPage) {
while ($FirstRecord > $RecordCount) {
$FirstRecord -= $this->RecordsPerPage;
}
if ($FirstRecord == "" || $FirstRecord < 1) {
$FirstRecord = 1;
}
if ($Previous_x != "") {
$FirstRecord -= $this->RecordsPerPage;
if ($FirstRecord <= 0) {
$FirstRecord = 1;
}
} elseif ($Next_x != "") {
$FirstRecord += $this->RecordsPerPage;
if ($FirstRecord > $RecordCount) {
$FirstRecord = $RecordCount - $RecordCount % $this->RecordsPerPage + 1;
}
if ($FirstRecord > $RecordCount) {
$FirstRecord = $RecordCount - $this->RecordsPerPage + 1;
}
if ($FirstRecord <= 0) {
$FirstRecord = 1;
}
} else {
// no scrolling action took place :)
}
} elseif ($RecordCount) {
$FirstRecord = 1;
$this->RecordsPerPage = $RecordCount;
}
// end of table view navigation code
$this->HTML .= "\n\t</tr>\n";
$this->HTML = "<script>\n\t\t\t\t\tfunction colorize(item, color){\n\t\t\t\t\t\tvar n=item.childNodes.length;\n\t\t\t\t\t\tfor(var i=0; i<n; i++){\n\t\t\t\t\t\t\tif(item.childNodes[i].nodeName=='TD'){\n\t\t\t\t\t\t\t\titem.childNodes[i].style.backgroundColor=color;\n\t\t\t\t\t\t\t\tif(item.childNodes[i].childNodes.length>0){\n\t\t\t\t\t\t\t\t\tif(item.childNodes[i].childNodes[0].nodeName=='A'){\n\t\t\t\t\t\t\t\t\t\titem.childNodes[i].childNodes[0].style.backgroundColor=color;\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t</script>" . $this->HTML . '<!-- tv data below -->';
$i = 0;
$hc = new HtmlFilter();
$hc->encoding = 'iso-8859-1';
$hc->defaultProtocol = '';
if ($RecordCount) {
$i = $FirstRecord;
// execute query for table view
$fieldList = '';
foreach ($this->QueryFieldsTV as $fn => $fc) {
$fieldList .= "{$fn} as `{$fc}`, ";
}
$fieldList = substr($fieldList, 0, -2);
if ($this->PrimaryKey) {
$fieldList .= ", {$this->PrimaryKey} as '" . str_replace('`', '', $this->PrimaryKey) . "'";
}
$tvQuery = 'SELECT ' . $fieldList . ' from ' . $this->QueryFrom . ' ' . $this->QueryWhere . ' ' . $this->QueryOrder;
$result = sql($tvQuery . " limit " . ($i - 1) . ",{$this->RecordsPerPage}");
while (($row = mysql_fetch_array($result)) && $i < $FirstRecord + $this->RecordsPerPage) {
$alt = ($i - $FirstRecord) % 2;
if ($PrintTV && $_POST["select_{$row[$FieldCountTV]}"] != 1) {
continue;
}
$class = "TableBody" . ($alt ? "Selected" : "") . ($fNumeric ? "Numeric" : "");
$this->HTML .= "\t<tr onMouseOver=\"colorize(this, '" . $this->HighlightColor . "');\" onMouseOut=\"colorize(this, '');\">";
$this->HTML .= "<td class={$class} valign=top align=right width=12>" . ($SelectedID == $row[$FieldCountTV] ? "<font color=red>⇒</font>" : " ") . "</td>";
if ($this->AllowPrintingMultiSelection && $Print_x != '') {
$this->HTML .= "<td class=\"{$class} displayOnly\" valign=\"top\" align=\"left\" width=\"12\"><input type=\"checkbox\" id=\"select_{$row[$FieldCountTV]}\" name=\"select_{$row[$FieldCountTV]}\" value=\"1\" onclick=\"if(\$('select_{$row[$FieldCountTV]}').checked) countSelected++; else countSelected--;\"></td>";
$toggleAllScript .= "\$('select_{$row[$FieldCountTV]}').checked=s;";
}
// templates
if ($rowTemplate != '') {
if ($this->AllowSelection == 1 && $SelectedID == $row[$FieldCountTV] && $selrowTemplate != "") {
$rowTemp = $selrowTemplate;
} else {
$rowTemp = $rowTemplate;
}
if ($this->AllowSelection == 1 && $SelectedID != $row[$FieldCountTV]) {
$rowTemp = str_replace('<%%SELECT%%>', "<a onclick=\"document.myform.SelectedField.value=this.parentNode.cellIndex; document.myform.SelectedID.value='" . addslashes($row[$FieldCountTV]) . "'; document.myform.submit(); return false;\" href=\"{$this->ScriptFileName}?SelectedID=" . htmlspecialchars($row[$FieldCountTV], ENT_QUOTES) . "\" class=\"{$class}\" style=\"display: block; padding:0px;\">", $rowTemp);
$rowTemp = str_replace('<%%ENDSELECT%%>', '</a>', $rowTemp);
} else {
$rowTemp = str_replace('<%%SELECT%%>', "", $rowTemp);
$rowTemp = str_replace('<%%ENDSELECT%%>', '', $rowTemp);
}
for ($j = 0; $j < $FieldCountTV; $j++) {
$fieldTVCaption = current(array_slice($this->QueryFieldsTV, $j, 1));
$fd = $hc->clean($row[$j]);
/*
the TV template could contain field placeholders in the format
<%%FIELD_n%%> or <%%VALUE(Field Caption)%%>
*/
$rowTemp = str_replace("<%%FIELD_{$j}%%>", thisOr($fd), $rowTemp);
$rowTemp = str_replace("<%%VALUE({$fieldTVCaption})%%>", thisOr($fd), $rowTemp);
if (thisOr($fd) == ' ' && preg_match('/<a href=".*? .*?<\\/a>/i', $rowTemp, $m)) {
$rowTemp = str_replace($m[0], '', $rowTemp);
}
}
if ($alt && $SelectedID != $row[$FieldCountTV]) {
$rowTemp = str_replace("TableBody", "TableBodySelected", $rowTemp);
$rowTemp = str_replace("TableBodyNumeric", "TableBodySelectedNumeric", $rowTemp);
$rowTemp = str_replace("SelectedSelected", "Selected", $rowTemp);
}
if ($SearchString != '') {
$rowTemp = highlight($SearchString, $rowTemp);
}
$this->HTML .= $rowTemp;
$rowTemp = '';
} else {
// end of templates
for ($j = 0; $j < $FieldCountTV; $j++) {
$fType = mysql_field_type($result, $j);
$fNumeric = stristr($fType, 'int') || stristr($fType, 'float') || stristr($fType, 'decimal') || stristr($fType, 'numeric') || stristr($fType, 'real') || stristr($fType, 'double') ? true : false;
if ($this->AllowSelection == 1) {
$sel1 = "<a href=\"{$this->ScriptFileName}?SelectedID=" . htmlspecialchars($row[$FieldCountTV], ENT_QUOTES) . "\" onclick=\"document.myform.SelectedID.value='" . addslashes($row[$FieldCountTV]) . "'; document.myform.submit(); return false;\" class=\"{$class}\" style=\"padding:0px;\">";
$sel2 = "</a>";
} else {
$sel1 = "";
$sel2 = "";
}
$this->HTML .= "<td valign=top class={$class}><div class={$class}> {$sel1}" . $row[$j] . "{$sel2} </div></td>";
}
}
$this->HTML .= "</tr>\n";
$i++;
}
$i--;
}
$this->HTML = preg_replace("/<a href=\"(mailto:)? [^\n]*title=\" \"><\\/a>/", ' ', $this->HTML);
$this->HTML = preg_replace("/<a [^>]*>( )*<\\/a>/", ' ', $this->HTML);
$this->HTML = preg_replace("/<%%.*%%>/U", ' ', $this->HTML);
if ($this->ShowRecordSlots) {
for ($j = $i + 1; $j < $FirstRecord + $this->RecordsPerPage; $j++) {
$this->HTML .= "\n\t<tr><td colspan=" . ($FieldCountTV + 1) . "><div class=TableBody> </div></td></tr>";
}
}
// end of data
$this->HTML .= '<!-- tv data above -->';
if ($Print_x == "") {
$pagesMenu = '';
if ($RecordCount > $this->RecordsPerPage) {
$pagesMenu = "<td align=center><div class=TableFooter>" . $Translation['go to page'] . " <select onChange=\"{$resetSelection} document.myform.NoDV.value=1; document.myform.FirstRecord.value=(this.value*" . $this->RecordsPerPage . "+1); document.myform.submit();\">";
for ($page = 0; $page < ceil($RecordCount / $this->RecordsPerPage); $page++) {
$pagesMenu .= "<option value=\"{$page}\" " . ($FirstRecord == $page * $this->RecordsPerPage + 1 ? 'selected' : '') . ">" . ($page + 1) . "</option>";
}
$pagesMenu .= '</select></div></td>';
}
$totalWidth = array_sum($this->ColWidth);
$totalWidth = $totalWidth > 750 ? 750 : '100%';
$this->HTML .= "\n\t<tr><td colspan=" . ($FieldCountTV + 1) . "><table width=100%><tr class=TableFooter><td align=left><input onClick=\"{$resetSelection} document.myform.NoDV.value=1;\" type=image name=Previous src=previousPage.gif></td><td align=center><div class=TableFooter>" . $Translation["records x to y of z"] . "</div></td>{$pagesMenu}<td align=right><input onClick=\"{$resetSelection} document.myform.NoDV.value=1;\" type=image name=Next src=nextPage.gif></td></tr></table></td></tr>";
} else {
$this->HTML .= "\n\t<tr><td colspan=" . ($FieldCountTV + 1) . "><nobr><div class=TableFooter>" . $Translation["records x to y of z"] . "</div></nobr></td></tr>";
}
$this->HTML = str_replace("<FirstRecord>", $FirstRecord, $this->HTML);
$this->HTML = str_replace("<LastRecord>", $i, $this->HTML);
$this->HTML = str_replace("<RecordCount>", $RecordCount, $this->HTML);
$tvShown = true;
}
// hidden variables ....
$this->HTML .= "<input name=SortField value='{$SortField}' type=hidden>";
$this->HTML .= "<input name=SelectedID value=\"{$SelectedID}\" type=hidden>";
$this->HTML .= "<input name=SelectedField value=\"\" type=hidden>";
$this->HTML .= "<input name=SortDirection type=hidden value='{$SortDirection}'>";
$this->HTML .= "<input name=FirstRecord type=hidden value='{$FirstRecord}'>";
$this->HTML .= "<input name=NoDV type=hidden value=''>";
if ($this->QuickSearch && !strpos($this->HTML, 'SearchString')) {
$this->HTML .= '<input name="SearchString" type="hidden" value="' . htmlspecialchars($SearchString, ENT_QUOTES) . '">';
}
// hidden variables: filters ...
$FiltersCode = '';
for ($i = 1; $i <= 20 * $FiltersPerGroup; $i++) {
// Number of filters allowed
if ($i % $FiltersPerGroup == 1 && $i != 1 && $FilterAnd[$i] != "") {
$FiltersCode .= "<input name=\"FilterAnd[{$i}]\" value=\"{$FilterAnd[$i]}\" type=\"hidden\">\n";
}
if ($FilterField[$i] != '' && $FilterOperator[$i] != '' && ($FilterValue[$i] != '' || strstr($FilterOperator[$i], 'Empty'))) {
if (!strstr($FiltersCode, "<input name=\"FilterAnd[{$i}]\" value=")) {
$FiltersCode .= "<input name=\"FilterAnd[{$i}]\" value=\"{$FilterAnd[$i]}\" type=\"hidden\">\n";
}
$FiltersCode .= "<input name=\"FilterField[{$i}]\" value=\"{$FilterField[$i]}\" type=\"hidden\">\n";
$FiltersCode .= "<input name=\"FilterOperator[{$i}]\" value=\"{$FilterOperator[$i]}\" type=\"hidden\">\n";
$FiltersCode .= "<input name=\"FilterValue[{$i}]\" value=\"" . htmlspecialchars($FilterValue[$i], ENT_QUOTES) . "\" type=\"hidden\">\n";
}
}
$this->HTML .= $FiltersCode;
// display details form ...
if (($this->AllowSelection || $this->AllowInsert || $this->AllowUpdate || $this->AllowDelete) && $Print_x == '' && !$PrintDV) {
if ($this->SeparateDV && $this->HideTableView || !$this->SeparateDV) {
$dvCode = call_user_func($this->TableName . '_form', $SelectedID, $this->AllowUpdate, $this->HideTableView && $SelectedID ? 0 : $this->AllowInsert, $this->AllowDelete, $this->SeparateDV);
$this->HTML .= "\n\t<tr><td colspan=" . ($FieldCountTV + 2) . ">{$dvCode}</td></tr>";
$this->HTML .= $this->SeparateDV ? "<input name=SearchString value='" . htmlspecialchars($SearchString, ENT_QUOTES) . "' type=hidden>" : "";
if ($dvCode) {
$this->ContentType = 'detailview';
$dvShown = true;
}
}
}
// display multiple printable detail views
if ($PrintDV) {
$dvCode = '';
$_POST['dvprint_x'] = 1;
// hidden vars
$this->HTML .= '<input type="hidden" name="Print_x" value="1">' . "\n";
$this->HTML .= '<input type="hidden" name="PrintTV" value="1">' . "\n";
// count selected records
$selectedRecords = 0;
foreach ($_POST as $n => $v) {
if (strpos($n, 'select_') === 0) {
$id = str_replace('select_', '', $n);
$selectedRecords++;
$this->HTML .= '<input type="hidden" name="select_' . $id . '" value="1">' . "\n";
}
}
if ($selectedRecords <= 100) {
// if records selected > 100 don't show DV preview to avoid db performance issues.
foreach ($_POST as $n => $v) {
if (strpos($n, 'select_') === 0) {
$id = str_replace('select_', '', $n);
$dvCode .= call_user_func($this->TableName . '_form', $id, 0, 0, 0, 1);
}
}
if ($dvCode != '') {
$dvCode = preg_replace('/<input .*?type="?image"?.*?>/', '', $dvCode);
$this->HTML .= "\n" . '<div class="TableBodySelected displayOnly">' . '<input class="print-button" type="submit" value="' . $Translation['Cancel Printing'] . '">' . '<input class="print-button" type="button" id="sendToPrinter" value="' . $Translation['Print'] . '" onClick="window.print();">' . '</div>' . "\n";
$this->HTML .= $dvCode;
}
} else {
$this->HTML .= '<div class="Error">' . $Translation['Maximum records allowed to enable this feature is'] . ' 100.</div>';
$this->HTML .= '<input type="submit" class="print-button" value="' . $Translation['Print Preview Table View'] . '">';
}
}
$this->HTML .= "</table>\n";
if ($this->AllowPrintingMultiSelection && $Print_x != '') {
$this->HTML .= "<script>function toggleAllRecords(){ var s=\$('toggleAll').checked; {$toggleAllScript} if(s) countSelected={$RecordCount}; else countSelected=0; }</script>\n";
}
$this->HTML .= "</form></center>";
if ($dvShown && $tvShown) {
$this->ContentType = 'tableview+detailview';
}
if ($dvprint_x != '') {
$this->ContentType = 'print-detailview';
}
if ($Print_x != '') {
$this->ContentType = 'print-tableview';
}
//mysql_close();
// Das ist Alles!
}
