public function addSelectionFormVariablesToTable($v) { $t1 = nuRunQuery("SELECT * FROM {$this->TT}"); $fieldArray = tableFieldNamesToArray($t1); $s = "SELECT NOW() as timestamp "; while (list($key, $value) = each($v)) { // if($key!=''){ if ($key != '' and !in_array($key, $fieldArray) and $key != 'timestamp') { //--stop duplicate field names $value = str_replace('\\"', '"', $value); $s = $s . ' , "' . $value . '" AS ' . $key . ' '; } } $t = nuRunQuery("SELECT COUNT(*) FROM {$this->TT}"); $r = db_fetch_row($t); if ($r[0] == 0) { nuRunQuery("DROP TABLE {$this->TT}"); nuRunQuery("CREATE TABLE {$this->TT} {$s}"); $this->noData = true; } else { nuRunQuery("CREATE TABLE a{$this->TT} {$s}, {$this->TT}.* FROM {$this->TT}"); nuRunQuery("DROP TABLE {$this->TT}"); nuRunQuery("CREATE TABLE {$this->TT} SELECT * FROM a{$this->TT}"); nuRunQuery("DROP TABLE a{$this->TT}"); } }
$arrayOfHashVariables = joinHashArrays($sysVariables, $sesVariables); //--join the arrays together $newFormArray = arrayToHashArray($formValue); $arrayOfHashVariables = joinHashArrays($arrayOfHashVariables, $newFormArray); //--join the arrays together eval(replaceHashVariablesWithValues($arrayOfHashVariables, $A->sat_export_data_code)); //eval($A->sat_export_data_code); $ascii = $A->sat_export_delimiter; if ($A->sat_export_use_quotes == '0') { $dq = ''; } else { $dq = '"'; } $t = nuRunQuery("SELECT * FROM {$dataTable}"); $Field = array(); $Field = tableFieldNamesToArray($t); if ($A->sat_export_header != '0') { for ($i = 0; $i < count($Field); $i++) { if ($i > 0) { print chr($ascii); } print $Field[$i]; } print "\r\n"; } $t = nuRunQuery("SELECT * FROM {$dataTable}"); while ($r = db_fetch_array($t)) { for ($f = 0; $f < count($Field); $f++) { if ($f > 0) { print chr($ascii); }
function addVariablesToTT($TT, $v) { //--join variables to the temp table and return true if the temp table had no data $t1 = nuRunQuery("SELECT * FrOM {$TT}"); $fieldArray = tableFieldNamesToArray($t1); $s = "SELECT NOW() as timestamp "; while (list($key, $value) = each($v)) { if ($key != '' and !in_array($key, $fieldArray) and $key != '') { //--stop duplicate field names $value = str_replace('\\"', '"', $value); $s .= ' , "' . $value . '" AS ' . $key . ' '; } } $t = nuRunQuery("SELECT COUNT(*) FROM {$TT}"); $r = db_fetch_row($t); if ($r[0] == 0) { nuRunQuery("DROp TABLE {$TT}"); nuRunQuery("CREATE TABLE {$TT} {$s}"); $noData = true; } else { nuRunQuery("CREATE TABLE a{$TT} {$s}, {$TT}.* FROM {$TT}"); nuRunQuery("DRoP TABLE {$TT}"); nuRunQuery("CREATE TABLE {$TT} SELECT * FROM a{$TT}"); nuRunQuery("DrOP TABLE a{$TT}"); $noData = false; } return $noData; }
$SQL->setWhere(" {$SQL->where} AND ({$object->sob_lookup_id_field} = '{$rID}')"); } $SQL->removeAllFields(); $SQL->addField($object->sob_lookup_id_field); $fieldNames[] = $object->sob_all_name; $SQL->addField($object->sob_lookup_code_field); $fieldNames[] = 'code' . $object->sob_all_name; $SQL->addField($object->sob_lookup_description_field); $fieldNames[] = 'description' . $object->sob_all_name; $t = nuRunQuery("SELECT * FROM zzsys_lookup WHERE slo_zzsys_object_id = '{$object->zzsys_object_id}'"); while ($r = db_fetch_object($t)) { $SQL->addField($r->zzsys_slo_table_field_name); $fieldNames[] = $r->zzsys_slo_page_field_name; } $t = nuRunQuery($SQL->SQL); $fieldArray = tableFieldNamesToArray($t); $T = nuRunQuery($SQL->SQL); $R = db_fetch_row($T); for ($i = 0; $i < count($fieldArray); $i++) { tofile("UPDATE zzsys_small_form_value SET sfv_value = '" . $R[$i] . "' WHERE sfv_form_record = '{$f}{$fr}{$ses}' AND sfv_name = '" . $fieldNames[$i] . "'"); nuRunQuery("UPDATE zzsys_small_form_value SET sfv_value = '" . $R[$i] . "' WHERE sfv_form_record = '{$f}{$fr}{$ses}' AND sfv_name = '" . $fieldNames[$i] . "'"); } $url = "formsmall.php?x=11&f={$f}&fr={$fr}&r={$rID}&dir={$dir}&ses={$ses}"; print "<html>\n<body onload=\"document.forms.lookup.submit()\">\n"; print "<form name='lookup' method='POST' action='{$url}'>\n</form>\n"; print "</body>\n</html>\n"; return; ?>
public function addSelectionFormVariablesToTable($v) { $t1 = nuRunQuery("SELECT * FROM {$this->TT}"); $fieldArray = tableFieldNamesToArray($t1); $s = "SELECT NOW() as timestamp "; $columnCount = 0; while (list($key, $value) = each($v)) { $columnCount = $columnCount + 1; if ($key != '' and !in_array($key, $fieldArray) and $key != '') { //--stop duplicate field names //changed by SG 29/Jan/2009 //$value = str_replace('\"', '"', $value); //$s = $s . ' , "' . $value . '" AS ' . $key . ' '; $value = addslashes($value); $s = "{$s} , '{$value}' AS `{$key}` "; } if ($columnCount > 200) { break; } } $t = nuRunQuery("SELECT COUNT(*) FROM {$this->TT}"); $r = db_fetch_row($t); if ($r[0] == 0) { nuRunQuery("DROP TABLE {$this->TT}"); nuRunQuery("CREATE TABLE {$this->TT} {$s}"); $this->noData = true; } else { nuRunQuery("CREATE TABLE a{$this->TT} {$s}, {$this->TT}.* FROM {$this->TT}"); nuRunQuery("DROP TABLE {$this->TT}"); nuRunQuery("CREATE TABLE {$this->TT} SELECT * FROM a{$this->TT}"); nuRunQuery("DROP TABLE a{$this->TT}"); } }
function __construct($parameters, $ACTIVITY) { $this->resize = 0.0679; $this->reportID = $ACTIVITY->zzsys_activity_id; $this->report = new Reporting(); $this->hasReportHeader = $this->validSection($this->reportHeader); $this->hasReportFooter = $this->validSection($this->reportFooter); $this->hasPageHeader = $this->validSection($this->pageHeader); $this->hasPageFooter = $this->validSection($this->pageFooter); $this->fixControlNames(); $this->buildBreakOnArray(); $this->headerNumbers = array(5, 7, 9, 11, 13, 15, 17, 19, 21, 23, 25, 27, 29, 31); $this->footerNumbers = array(6, 8, 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30, 32); $this->alignment = array('left', 'left', 'center', 'right'); $this->selectionFormVariables = getSelectionFormVariables($parameters); $this->tablesUsed = getSelectionFormTempTableNames($parameters, $this->selectionFormVariables); $this->TT = TT(); $this->sumTT = TT(); $this->tablesUsed[] = $this->TT; $dataTable = $this->TT; $formValue = $this->selectionFormVariables; eval($ACTIVITY->sat_report_data_code); $this->TT = $dataTable; // BuildTable($this->selectionFormVariables, $this->TT); $this->addSelectionFormVariablesToTable($this->selectionFormVariables); $t = nuRunQuery("SELECT * FROM {$this->TT} LIMIT 0 , 1"); $this->fields = tableFieldNamesToArray($t); if ($_GET['tt'] != '') { //--- create a temp table to debug nuRunQuery("CREATE TABLE " . $_GET['tt'] . " SELECT * FROM {$this->TT}"); } $this->sumTotals(); $this->orderBy = $this->orderByClause(); $this->styleSheet = $this->buildStyleSheet(); }