$sql = "SELECT seqnum FROM " . DBRptFields . " WHERE reportid = " . $ReportID . " AND entrytype = '" . $EntryType . "';";
$Result = DB_query($sql, $db, '', '', false, true);
if ($SeqNum < DB_num_rows($Result)) {
$success = ChangeSequence($_POST['SeqNum'], $EntryType, 'down');
}
} elseif (isset($_POST['ed_x'])) {
// the sequence edit button was pushed
$OverrideDefaults = true;
// pre fill form with the field to edit and change button name
$sql = "SELECT * FROM " . DBRptFields . "\n\t\t\t\t\tWHERE reportid = " . $ReportID . " AND entrytype = '" . $EntryType . "' AND seqnum=" . $SeqNum . ";";
$Result = DB_query($sql, $db, '', '', false, true);
$NewDefaults['defaults'] = DB_fetch_array($Result);
$NewDefaults['defaults']['buttonvalue'] = RPT_BTN_CHANGE;
} elseif (isset($_POST['rm_x'])) {
// the sequence remove button was pushed
$success = DeleteSequence($_POST['SeqNum'], $EntryType);
}
$reportname = $_POST['ReportName'];
$FormParams = PrepStep('6');
} else {
switch ($_POST['todo']) {
case RPT_BTN_BACK:
$reportname = $_POST['ReportName'];
$FormParams = PrepStep('5');
break;
case RPT_BTN_ADDNEW:
case RPT_BTN_CHANGE:
$EntryType = $_POST['EntryType'];
//fetch the entry type
// error check input
$IsValidField = ValidateField($ReportID, $_POST['FieldName'], $_POST['DisplayDesc']);
break;
case 'edit':
$OverrideDefaults = true;
// pre fill form with the field to edit and change button name
$sql = "select * from " . TABLE_REPORT_FIELDS . " \r\n\t\t\t\t\twhere reportid = " . $ReportID . " and entrytype = '" . $EntryType . "' and seqnum = " . $rowSeq;
$result = $db->Execute($sql);
$NewDefaults['defaults'] = $result->fields;
$NewDefaults['defaults']['params'] = unserialize($result->fields['params']);
// $NewDefaults['defaults']['params'] = $temp_params[0];
// $NewDefaults['defaults']['minvalue'] = $temp_params[2];
// $NewDefaults['defaults']['maxvalue'] = $temp_params[3];
$NewDefaults['defaults']['buttonvalue'] = TEXT_CHANGE;
$FormParams = PrepStep('6');
break;
case 'delete':
$success = DeleteSequence($rowSeq, $EntryType);
$FormParams = PrepStep('6');
break;
case 'back':
$FormParams = PrepStep('5');
break;
case 'add':
case 'change':
// error check input
$IsValidField = ValidateField($ReportID, $_POST['FieldName'], $_POST['DisplayDesc']);
if (!$IsValidField) {
// then user entered a bad fieldname or description, error and reload
$messageStack->add(RW_RPT_BADFLD, 'error');
// reload form with bad data entered as field defaults, ready to be editted
$OverrideDefaults = true;
switch ($EntryType) {
