function FetchReportDetails($ReportID)
{
global $db;
$sql = "SELECT reportname, reporttype, groupname, papersize, paperorientation,\n\t\t\tmargintop, marginbottom, marginleft, marginright,\n\t\t\ttable1, table2, table2criteria, table3, table3criteria, table4, table4criteria,\n\t\t\ttable5, table5criteria, table6, table6criteria\n\t\tFROM " . DBReports . " \n\t\tWHERE id = " . $ReportID . ";";
$Result = DB_query($sql, $db, '', '', false, true);
$myrow = DB_fetch_assoc($Result);
foreach ($myrow as $key => $value) {
$Prefs[$key] = $value;
}
// Build drop down menus for selectable criteria
$Temp = RetrieveFields($ReportID, 'dateselect');
$Prefs['DateListings'] = $Temp[0];
// only need the first field
$Prefs['GroupListings'] = RetrieveFields($ReportID, 'grouplist');
$Prefs['CritListings'] = RetrieveFields($ReportID, 'critlist');
return $Prefs;
}
}
// reload fields to display form
$FieldListings = RetrieveFields('fieldlist');
// needed for GO Back (fields) screen
// Below needed to reload criteria form
if (!$DateError) {
$DateListings = RetrieveFields('dateselect');
$DateListings = $DateListings['lists'][0];
// only need the first field
}
$TruncListings = RetrieveFields('trunclong');
$TruncListings = $TruncListings['lists'][0];
// only need the first field
$SortListings = RetrieveFields('sortlist');
$GroupListings = RetrieveFields('grouplist');
$CritListings = RetrieveFields('critlist');
// override defaults used for edit of existing fields.
if ($OverrideDefaults) {
switch ($EntryType) {
case "sortlist":
$SortListings['defaults'] = $NewDefaults['defaults'];
$SortListings['defaults']['buttonvalue'] = $NewDefaults['defaults']['buttonvalue'];
break;
case "grouplist":
$GroupListings['defaults'] = $NewDefaults['defaults'];
$GroupListings['defaults']['buttonvalue'] = $NewDefaults['defaults']['buttonvalue'];
break;
case "critlist":
$CritListings['defaults'] = $NewDefaults['defaults'];
$CritListings['defaults']['buttonvalue'] = $NewDefaults['defaults']['buttonvalue'];
break;
$result = $db->Execute($sql);
if ($result->AffectedRows() == 0) {
// create the field, first see if it is there
$result = $db->Execute("select id from " . TABLE_REPORT_FIELDS . " where reportid = " . $ReportID . " and entrytype = 'security'");
if ($result->RecordCount() == 0) {
$sql = "insert into " . TABLE_REPORT_FIELDS . " set \r\n\t\t\t\t\t\t\treportid = " . $ReportID . ",\r\n\t\t\t\t\t\t\tentrytype = 'security',\r\n\t\t\t\t\t\t\tparams = '" . $params . "'";
$result = $db->Execute($sql);
}
}
// read in fields for next form
if ($todo == 'finish') {
// then finish was pressed
$FormParams = PrepStep('1');
} else {
// update was pressed, return to criteria form
$temp = RetrieveFields('security');
$temp = array_pop($temp['lists']);
$Security = explode(';', $temp['params']);
$presets = array();
foreach ($Security as $value) {
$presets[substr($value, 0, 1)] = explode(':', substr($value, 2));
}
$FormParams = PrepStep('sec');
}
}
break;
// end step 9
// end step 9
default:
die('Bad action number: ' . $action);
}
function FetchReportDetails($ReportID)
{
global $db;
$sql = "SELECT *\tFROM " . DBReports . " WHERE id = '" . $ReportID . "'";
$Result = DB_query($sql, $db, '', '', false, true);
$myrow = DB_fetch_assoc($Result);
foreach ($myrow as $key => $value) {
$Prefs[$key] = $value;
}
// Build drop down menus for selectable criteria; need $ReportID
$Temp = RetrieveFields($ReportID, 'dateselect');
$Prefs['DateListings'] = $Temp[0];
// only need the first field
$Temp = RetrieveFields($ReportID, 'trunclong');
$Prefs['TruncListings'] = $Temp[0];
// only need the first field
$Prefs['SortListings'] = RetrieveFields($ReportID, 'sortlist');
$Prefs['GroupListings'] = RetrieveFields($ReportID, 'grouplist');
$Prefs['CritListings'] = RetrieveFields($ReportID, 'critlist');
$Prefs['FieldListings'] = RetrieveFields($ReportID, 'fieldlist');
return $Prefs;
}
function FetchReportDetails($ReportID)
{
global $db;
$result = $db->Execute("select * from " . TABLE_REPORTS . " where id = " . $ReportID);
$result->fields['description'] = stripslashes($result->fields['description']);
foreach ($result->fields as $key => $value) {
$Prefs[$key] = $value;
}
// load the page fields
$result = $db->Execute("select params from " . TABLE_REPORT_FIELDS . " \r\n\t\twhere reportid = " . $ReportID . " and entrytype = 'pagelist'");
if ($result->RecordCount() > 0) {
$params = unserialize($result->fields['params']);
$params['title1desc'] = stripslashes($params['title1desc']);
$params['title2desc'] = stripslashes($params['title2desc']);
$Prefs = array_merge($Prefs, $params);
}
// Report/Form properties
$Prefs['GroupListings'] = RetrieveFields($ReportID, 'grouplist');
$Prefs['CritListings'] = RetrieveFields($ReportID, 'critlist');
$Prefs['SortListings'] = RetrieveFields($ReportID, 'sortlist');
$Prefs['FieldListings'] = RetrieveFields($ReportID, 'fieldlist');
return $Prefs;
}
function PrepStep($StepNum, $template = '')
{
global $db, $Type, $paperwidth, $paperheight, $paperorientation, $marginleft, $marginright, $ReportID;
$head_type = ($Type == 'frm' ? TEXT_FORM : TEXT_REPORT) . ': ';
// This function sets the titles and include information to prepare for the defined step number
switch ($StepNum) {
case '1':
// closes the popup window and triggers a reload of opener window
// closes the popup window and triggers a reload of opener window
default:
$FormParams['IncludePage'] = false;
break;
case '2':
// id, copy, new report name form
$FormParams['title'] = RW_TITLE_RPRBLDR . RW_TITLE_STEP2;
$FormParams['heading'] = RW_RPT_RPTID;
$FormParams['IncludePage'] = 'template_id.php';
break;
case '3':
// page setup form
$FormParams['title'] = RW_TITLE_RPRBLDR . RW_TITLE_STEP3;
$FormParams['heading'] = $head_type;
$FormParams['IncludePage'] = 'template_page_setup.php';
break;
case '4':
// db setup form
$FormParams['title'] = RW_TITLE_RPRBLDR . RW_TITLE_STEP4;
$FormParams['heading'] = $head_type;
$FormParams['IncludePage'] = 'template_db_setup.php';
break;
case '5':
// field setup form
// Load the javascript values
$PageListings = RetrieveFields('pagelist');
$temp = $PageListings['lists'][0]['params'];
$pageproperties = explode(':', $temp['papersize']);
$paperwidth = $pageproperties[1];
$paperheight = $pageproperties[2];
$paperorientation = $temp['paperorientation'];
$marginleft = $temp['marginleft'];
$marginright = $temp['marginright'];
// Prep the form
$FormParams['title'] = RW_TITLE_RPRBLDR . RW_TITLE_STEP5;
$FormParams['heading'] = $head_type;
$FormParams['IncludePage'] = 'template_field_setup.php';
break;
case 'prop':
// Form field properties form
global $Params;
// we need the form type from the Params variable to load the correct form
$FormParams['title'] = RW_TITLE_RPRBLDR . TEXT_PROPERTIES;
$FormParams['heading'] = $head_type;
$FormParams['IncludePage'] = 'template_TplFrm' . $template . '.php';
break;
case '6':
// criteria setup form
$sql = "select params from " . TABLE_REPORT_FIELDS . " where reportid = " . $ReportID . " and entrytype = 'pagelist'";
$result = $db->Execute($sql);
$FormParams['Prefs'] = unserialize($result->fields['params']);
$FormParams['title'] = RW_TITLE_RPRBLDR . RW_TITLE_STEP6;
$FormParams['heading'] = $head_type;
$FormParams['IncludePage'] = 'template_crit_setup.php';
break;
case 'imp':
// import form
$FormParams['title'] = RW_TITLE_RPRBLDR . RW_RPT_RPTIMPORT;
$FormParams['heading'] = RW_RPT_RPTIMPORT;
$FormParams['IncludePage'] = 'template_import.php';
break;
case 'sec':
// criteria setup form
$FormParams['title'] = RW_TITLE_RPRBLDR . RW_TITLE_SECURITY;
$FormParams['heading'] = $head_type;
$FormParams['IncludePage'] = 'template_security_setup.php';
break;
}
// end switch $StepNum
return $FormParams;
}
