function toggle_all_procedures($procedures, $status)
{
foreach (array_keys($procedures) as $name) {
$procedures[$name]['status'] = $status;
if ($status == 'open' && empty($procedures[$name]['source'])) {
$procedures[$name]['source'] = get_procedure_source($name);
list($in, $out) = get_procedure_parameters($name);
$procedures[$name]['in'] = $in;
$procedures[$name]['out'] = $out;
}
}
return $procedures;
}
list($in, $out) = get_procedure_parameters($pname);
$s_procedures[$pname]['in'] = $in;
$s_procedures[$pname]['out'] = $out;
}
$s_proceduredefs = array('name' => $pname, 'source' => procedure_modify_source($s_procedures[$pname]));
$proc_mod_flag = TRUE;
}
// modify the procedure
if (isset($_POST['acc_proc_mod_doit'])) {
$s_proceduredefs['source'] = get_request_data('def_proc_source');
if (create_procedure($s_proceduredefs) == TRUE) {
$pname = $s_proceduredefs['name'];
list($in, $out) = get_procedure_parameters($pname);
$s_procedures[$pname]['in'] = $in;
$s_procedures[$pname]['out'] = $out;
$s_procedures[$pname]['source'] = get_procedure_source($pname);
$s_proceduredefs = array();
$s_procedures_valid = FALSE;
} else {
$proc_mod_flag = TRUE;
}
}
// creating or modifying a procedure was canceled
if (isset($_POST['acc_proc_create_cancel']) || isset($_POST['acc_proc_mod_cancel'])) {
$s_proceduredefs = array();
}
// the Drop button on the procedures panel was pushed
if (isset($_POST['acc_proc_del']) && $_POST['acc_proc_del_name'] != '') {
$pname = $_POST['acc_proc_del_name'];
$deps = get_dependencies(OT_PROCEDURE, $pname);
if (count($deps) > 0) {
function detail_view($type, $name, $title)
{
$url = fold_detail_url($type, 'open', $name, $title);
$comment_url = "javascript:requestCommentArea('" . $type . "', '" . $name . "');";
$comment_div = detail_div_prefix($type) . 'c_' . $name;
switch ($type) {
case 'table':
if ($GLOBALS['s_tables_def'] == TRUE) {
$GLOBALS['s_fields'] = get_table_defaults_sources($name, $GLOBALS['s_fields']);
}
$html = get_opened_table($name, $title, $url, $comment_url, $comment_div);
$GLOBALS['s_tables'][$name]['status'] = 'open';
break;
case 'view':
include '../inc/views.inc.php';
$html = get_opened_view($name, $title, $url);
$GLOBALS['s_tables'][$name]['status'] = 'open';
break;
case 'trigger':
include '../inc/triggers.inc.php';
if (empty($GLOBALS['s_triggers'][$name]['source'])) {
$GLOBALS['s_triggers'][$name]['source'] = get_trigger_source($name);
}
$html = get_opened_trigger($name, $GLOBALS['s_triggers'][$name], $url);
$GLOBALS['s_triggers'][$name]['display'] = 'open';
break;
case 'procedure':
include '../inc/procedures.inc.php';
include '../inc/firebird.inc.php';
if (empty($GLOBALS['s_procedures'][$name]['source'])) {
$GLOBALS['s_procedures'][$name]['source'] = get_procedure_source($name);
list($in, $out) = get_procedure_parameters($name);
$GLOBALS['s_procedures'][$name]['in'] = $in;
$GLOBALS['s_procedures'][$name]['out'] = $out;
}
$html = get_opened_procedure($name, $GLOBALS['s_procedures'][$name], $url);
$GLOBALS['s_procedures'][$name]['status'] = 'open';
break;
}
header('Content-Type: text/html;charset=' . $GLOBALS['charset']);
echo $html;
}
