Example #1
0
$runActivity = false;
if ($f == 'run') {
    //---run a report, procedure or export
    $ttt = nuRunQuery("SELECT sat_all_zzsys_form_id, sat_all_description FROM zzsys_activity WHERE zzsys_activity_id = '{$r}'");
    $rrr = db_fetch_row($ttt);
    $f = $rrr[0];
    $runActivity = true;
}
$tempObjectTable = TT();
nuRunQuery("CREATE TABLE {$tempObjectTable} SELECT * FROM zzsys_object WHERE sob_zzsys_form_id = '{$f}'");
nuRunQuery("ALTER TABLE {$tempObjectTable} ADD INDEX (sob_all_column_number)");
nuRunQuery("ALTER TABLE {$tempObjectTable} ADD INDEX (sob_all_order_number)");
nuRunQuery("ALTER TABLE {$tempObjectTable} ADD INDEX (sob_all_tab_number)");
nuRunQuery("ALTER TABLE {$tempObjectTable} ADD INDEX (sob_all_tab_title)");
$nuForm = new Form();
$nuForm->loadAfterConstruct($f, $r, $c, $delete, $runActivity, $dir, $ses, $tempObjectTable, $session);
function addJSFunction($pCode)
{
    global $nuForm;
    $nuForm->appendJSFunction($pCode);
}
//---get form tab details FROM zzsys_object
$t = nuRunQuery("SELECT sob_all_tab_title FROM zzsys_object WHERE sob_zzsys_form_id = '" . $nuForm->form->zzsys_form_id . "' {$inString} GROUP BY sob_all_tab_title ORDER BY sob_all_tab_number");
while ($r = db_fetch_row($t)) {
    $nuForm->formTabs[] = $r[0];
    $nuForm->formTabNames[$r[0]] = count($nuForm->formTabs);
}
$nuForm->access_level = $session->sss_access_level;
$nuForm->session_id = $session->sss_session_id;
$nuForm->zzsys_user_id = $session->sss_zzsys_user_id;
$nuForm->zzsys_user_group_name = $session->sss_zzsys_user_group_name;