function closed_panel($idx)
{
//calculate the panel name
$pvar = 's_' . strtolower($GLOBALS['s_page']) . '_panels';
$GLOBALS[$pvar][$idx][2] = 'close';
$icon = get_icon_path(DATAPATH, ICON_SIZE) . 'open.png';
$html = get_closed_panel($GLOBALS[$pvar][$idx][1], $idx, $icon);
set_customize_cookie($GLOBALS['s_cust']);
header('Content-Type: text/html;charset=' . $GLOBALS['charset']);
echo $html;
}
function get_opened_trigger($name, $trigger, $url)
{
global $dbhandle, $acc_strings, $ptitle_strings;
$type_str = implode('<br>', $trigger['type']);
$red_triangle = get_icon_path(DATAPATH, ICON_SIZE) . 'red_triangle.png';
$html = <<<EOT
<nobr>
<a href="{$url}" class="dtitle"><img src="{$red_triangle}" alt="{$ptitle_strings['Close']}" title="{$ptitle_strings['Close']}" border="0" hspace="7"><b>{$name}</b></a>
</nobr>
<nobr>
<table>
<tr>
<td width="26">
</td>
<td>
<table class="table table-bordered">
<tr>
<th>{$acc_strings['Table']}</th>
<th>{$acc_strings['Phase']}</th>
<th>{$acc_strings['Type']}</th>
<th>{$acc_strings['Pos']}</th>
<th>{$acc_strings['Status']}</th>
<th>{$acc_strings['Source']}</th>
</tr>
<tr>
\t <td valign="top">{$trigger['table']}</td>
\t <td valign="top">{$trigger['phase']}</td>
\t <td valign="top">{$type_str}</td>
\t <td valign="top">{$trigger['pos']}</td>
\t <td valign="top">{$trigger['status']}</td>
\t <td valign="top"><pre>{$trigger['source']}</pre></td>
</tr>
</table>
</td>
</tr>
</table>
</nobr>
EOT;
return $html;
}
function get_open_panel_start($title, $nr)
{
global $ptitle_strings;
$fold_url = sprintf("javascript:requestClosedPanel('%d')", $nr);
$close_icon = get_icon_path(DATAPATH, ICON_SIZE) . 'close.png';
return '<table width="100%" class="area">' . "\n" . " <tr class=\"panel\">\n" . ' <td rowspan="2" width="25" align="center" valign="top">' . "\n" . ' ' . sprintf('<a href="%1$s"><img src="%2$s" alt="%3$s" title="%3$s" border="0"></a>' . "\n", $fold_url, $close_icon, $ptitle_strings['Close']) . "\n" . " </td>\n" . ' <td width="100%"><a class="ptitle" href="' . $fold_url . '">' . $title . "</a></td>\n" . " <td>\n" . " </td>\n" . " </tr>\n" . " <tr>\n" . " <td colspan=\"2\">\n";
}
function get_opened_procedure($name, $procedure, $url)
{
global $dbhandle, $tb_strings, $acc_strings, $ptitle_strings;
$in = $out = '';
$in_start = $out_start = $src_start = '';
$rowspan = 1;
if (count($procedure['in']) > 0) {
$in = procedure_parameters($procedure['in']);
$out_start = $src_start = "<tr>\n";
$rowspan++;
}
if (count($procedure['out']) > 0) {
$out = procedure_parameters($procedure['out']);
$src_start = "<tr>\n";
$rowspan++;
}
$red_triangle = get_icon_path(DATAPATH, ICON_SIZE) . 'red_triangle.png';
$html = <<<EOT
<nobr>
<a href="{$url}" class="dtitle"><img src="{$red_triangle}" alt="{$ptitle_strings['Close']}" title="{$ptitle_strings['Close']}" border="0" hspace="7">{$name}</a>
</nobr>
<table>
<tr>
<td width="26" rowspan="{$rowspan}">
</td>
EOT;
if (!empty($in)) {
$html .= <<<EOT
<td>
<table class="table table-bordered">
<tr>
<th align="left">{$acc_strings['Param']}</th>
</tr>
<tr>
\t <td valign="top">{$in}</td>
</tr>
</table>
</td>
</tr>
EOT;
}
if (!empty($out)) {
$html .= <<<EOT
{$out_start}
<td>
<table class="table table-bordered">
<tr>
<th align="left">{$acc_strings['Return']}</th>
</tr>
<tr>
\t <td valign="top">{$out}</td>
</tr>
</table>
</td>
</tr>
EOT;
}
$html .= <<<EOT
{$src_start}
<td>
<table>
<tr>
<th align="left">{$acc_strings['Source']}</th>
</tr>
<tr>
\t <td valign="top"><pre>{$procedure['source']}</pre></td>
</tr>
</table>
</td>
</tr>
</table>
EOT;
return $html;
}
function get_opened_view($name, $title, $url)
{
global $dbhandle, $s_fields, $tb_strings, $acc_strings, $ptitle_strings;
$source = get_view_source($name);
$red_triangle = get_icon_path(DATAPATH, ICON_SIZE) . 'red_triangle.png';
$html = <<<EOT
<nobr>
<a href="{$url}" class="dtitle"><img src="{$red_triangle}" alt="{$ptitle_strings['Close']}" title="{$ptitle_strings['Close']}" border="0" hspace="7">{$title}</a>
</nobr>
<nobr>
<table class="table table-hover">
<tr>
<td width="26">
</td>
<td valign="top">
<table class="table table-bordered">
EOT;
$cols = array('Name', 'Type', 'Length', 'Prec', 'Scale', 'Charset', 'Collate');
$html .= " <tr align=\"left\">\n";
foreach ($cols as $idx) {
$html .= ' <th class="detail"><nobr>' . $tb_strings[$idx] . "</nobr></th>\n";
}
$html .= " </tr>\n";
foreach ($s_fields[$name] as $field) {
$size_str = $field['type'] == 'VARCHAR' || $field['type'] == 'CHARACTER' ? $field['size'] : ' ';
$prec_str = isset($field['prec']) ? $field['prec'] : ' ';
$scale_str = isset($field['scale']) ? $field['scale'] : ' ';
$char_str = isset($field['charset']) ? $field['charset'] : ' ';
$coll_str = isset($field['collate']) ? $field['collate'] : ' ';
$html .= " <tr>\n <td class=\"detail\">{$field['name']}</td>\n\t <td class=\"detail\">{$field['type']}</td>\n\t <td align=\"right\" class=\"detail\">{$size_str}</td>\n\t <td align=\"right\" class=\"detail\">{$prec_str}</td>\n\t <td align=\"right\" class=\"detail\">{$scale_str}</td>\n \t <td class=\"detail\">{$char_str}</td>\n <td class=\"detail\">{$coll_str}</td>\n </tr>\n";
}
$html .= " </table>\n </td>\n";
$html .= " <td> </td>\n" . " <td valign=\"top\">\n" . " <table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">\n" . " <tr align=\"left\">\n" . ' <th class="detail">' . $acc_strings['Source'] . "</th>\n" . " </tr>\n" . " <tr>\n" . ' <td class="detail"><pre>' . $source . "</pre></td>\n" . " </tr>\n" . " </table>\n" . " </tr>\n" . " </td>\n" . " </table>\n" . " </nobr>\n";
return $html;
}
// there may be different instances of the data edit/delete panel,
// which carrying the instance nr in the panel name
if (preg_match('/dt_(edit|delete)([0-9]+)/', $panel[0], $matches)) {
$instance = $matches[2];
if ($matches[1] == 'edit') {
include './panels/dt_edit.php';
} else {
$subject = 'row';
include './panels/confirm.php';
}
} else {
include './panels/' . $panel[0] . '.php';
}
echo get_open_panel_end();
} else {
$open_icon = get_icon_path(DATAPATH, ICON_SIZE) . 'open.png';
echo get_closed_panel($panel[1], $nr, $open_icon);
}
echo "</div>\n";
}
// close the db connection
if (isset($dbhandle) && is_resource($dbhandle)) {
// fbird_close() chrashes the apache-process,
// this was a bug in some revisions of the ibase-module
// fbird_close($dbhandle);
}
if (DEBUG === TRUE) {
echo "<div align=\"left\">\n";
show_time_consumption($start_time, microtime());
// echo 'cookie size: '.strlen($_COOKIE[get_customize_cookie_name()])."<br>\n";
// debug_var($_COOKIE[get_customize_cookie_name()]);
