function QPInsertUpdate($tableName, $valuesArray, $whereArray)
{
$sql = BuildSQL($tableName, $whereArray);
if ($this->query($sql)) {
//$this->SelectRows($tableName, $whereArray);
if ($this->numRows() > 0) {
return $this->UpdateRows($tableName, $valuesArray, $whereArray);
} else {
return $this->InsertRow($tableName, $valuesArray);
}
}
}
$IncludePage = 'forms/ReportsPageUpdate.html';
} else {
// return to the criterai screen
$Title = RPT_CRITERIA;
$IncludePage = 'forms/ReportsFilter.html';
}
break;
case RPT_BTN_EXPCSV:
case RPT_BTN_EXPPDF:
$Prefs = ReadPostData($ReportID, $Prefs);
// include the necessary files to build report
require $PathPrefix . 'includes/tcpdf/tcpdf.php';
// TCPDF class to generate reports
require 'WriteReport.inc';
$ReportData = '';
$success = BuildSQL($Prefs);
if ($success['level'] == 'success') {
// Generate the output data array
$sql = $success['data'];
$Prefs['filterdesc'] = $success['filterdesc'];
// fetch the filter message
$ReportData = BuildDataArray($ReportID, $sql, $Prefs);
// Check for the report returning with data
if (!$ReportData) {
$usrMsg[] = array('message' => RPT_NODATA . ' The failing sql=' . $sql, 'level' => 'warn');
}
} else {
// Houston, we have a problem, sql build failed
$usrMsg[] = array('message' => $success['message'], 'level' => $success['level']);
}
if ($usrMsg) {
// we're done
}
if ($error) {
break;
}
// if we are here, the user wants to generate output
switch ($report->reporttype) {
case 'frm':
$output = BuildForm($report, $delivery_method);
if ($output === true) {
$error = true;
}
break;
case 'rpt':
$ReportData = '';
$success = BuildSQL($report);
if ($success['level'] == 'success') {
// Generate the output data array
$sql = $success['data'];
$report->page->filter->text = $success['description'];
// fetch the filter message
if (!($ReportData = BuildDataArray($sql, $report))) {
$messageStack->add(PHREEFORM_NODATA . ' The sql was: ' . $sql, 'caution');
$error = true;
break;
}
// Check for the report returning with data
if (!$ReportData) {
$messageStack->add(PHREEFORM_NODATA . ' The failing sql= ' . $sql, 'caution');
$error = true;
} else {
