function nuBuildTable($J) { $h = ''; $h .= "<table>"; $h .= "<tr>"; $h .= "<th class='id'>ID</th>"; for ($i = 0; $i < count($J->objects); $i++) { $w = $J->objects[$i]->width . 'px'; $v = $J->objects[$i]->title; $h .= "<th class='s{$i}'>{$v}</th>"; } $h .= "</tr>"; $T = nuRunQuery("SELECT * FROM {$J->records}"); while ($R = db_fetch_row($T)) { $h .= "<tr>"; $h .= "<td class='id'>" . $R[0] . "</td>"; for ($i = 0; $i < count($J->objects); $i++) { $w = $J->objects[$i]->width . 'px'; $v = $R[$i + 1]; $h .= "<td class='s{$i}'>{$v}</td>"; } $h .= "</td>"; $h .= "</tr>"; } $h .= "</table>"; return $h; }
private function nuGetFieldValue($O) { $type = ''; $value = ''; if (strtoupper(substr($O->fieldName, 0, 4)) == 'SUM(') { $type = 's'; $field = substr($O->fieldName, 4, -1); } if (strtoupper(substr($O->fieldName, 0, 8)) == 'AVERAGE(') { $type = 'p'; $fields = explode(',', substr($O->fieldName, 8, -1)); } if ($type == '') { //-- normal value //Add the 'is_array' check by SG 8th May 2015 if (is_array($this->ROW)) { if (array_key_exists($O->fieldName, $this->ROW)) { $v = $this->nuGetFormatting($O); $value = mb_convert_encoding($v['V'], "WINDOWS-1252", "UTF-8"); } } } else { //-- summed value $groups = array(); $where = ''; if ($type == 'p') { $count = 'SUM(nu_sum_' . trim($fields[0]) . ') AS the_sum_a, SUM(nu_sum_' . trim($fields[1]) . ') AS the_sum_b'; } else { $count = 'SUM(nu_sum_' . trim($field) . ') AS the_sum_a'; } for ($i = 3; $i <= $this->group; $i++) { $groups[] = $this->LAY->groups[$i]->sortField . " = '" . str_replace("'", "\\'", $this->ROW[$this->LAY->groups[$i]->sortField]) . "'"; $where = ' WHERE '; } $sql = "SELECT {$count} FROM {$this->TABLE_ID}" . "_nu_summary {$where} " . implode(' AND ', $groups); $t = nuRunQuery($sql); $r = db_fetch_row($t); if ($r[1] == 0 and $type == 'p') { $value = 0; } else { if ($type == 'p') { // $value = ($r[0] / $r[1]) * 100; $value = $r[0] / $r[1]; } else { $value = $r[0]; } } } if ($O->format != '') { //-- format value $format = nuTextFormats(); $datatype = $format[$O->format]->type; if ($datatype == 'date') { if ($value != '0000-00-00' && $value != '') { $value = date($format[$O->format]->phpdate, strtotime($value)); } else { $value = ''; } } if ($datatype == 'number') { $value = number_format($value, $format[$O->format]->format, $format[$O->format]->decimal, $format[$O->format]->separator); } } return $value; }
<?php /* ** File: runCronProcedure_nu2.php ** Author: nuSoftware ** Created: 2007/04/26 ** Last modified: 2009/07/15 ** ** Copyright 2004, 2005, 2006, 2007, 2008, 2009 nuSoftware ** ** This file is part of the nuBuilder source package and is licensed under the ** GPLv3. For support on developing in nuBuilder, please visit the nuBuilder ** wiki and forums. For details on contributing a patch for nuBuilder, please ** visit the `Project Contributions' forum. ** ** Website: http://www.nubuilder.com ** Wiki: http://wiki.nubuilder.com ** Forums: http://forums.nubuilder.com */ set_include_path(get_include_path() . PATH_SEPARATOR . dirname(__FILE__)); $dir = $argv[1]; $report = $argv[2]; include "../{$dir}/database.php"; include 'common.php'; $T = nuRunQuery("SELECT * FROM zzsys_activity WHERE sat_all_code = '{$report}'"); $A = db_fetch_object($T); eval($A->sat_procedure_code);
private function buildHTMLForSubform($CRLF, $TAB, $fieldName, $fieldTitle, $blankRows, $objectID) { if (!$this->displayThisObject) { return ''; } else { $this->parentForm->subformNames[] = $this->objectProperty['sob_all_name']; $this->parentForm->subformTabs[] = $this->parentForm->formTabNames[$this->objectProperty['sob_all_tab_title']]; } $format = textFormatsArray(); if ($this->objectProperty['sob_all_on_change'] != '') { $OnChange = 'onchange="' . $this->objectProperty["sob_all_on_change"] . '" '; } $this->CRLF = $CRLF; $this->TAB = $TAB; $hGap = 3; //gap between fields $vHeight = 23; //row height $vTitleHeight = $this->objectProperty['sob_subform_title_height'] * 16; //row height $vTop = 10; //row height $sfDimensions = array(); $fldDimensions = array(); $t = nuRunQuery("SELECT * FROM zzsys_object WHERE sob_zzsys_form_id = '" . $this->objectProperty['zzsys_object_id'] . "' ORDER BY sob_all_column_number, sob_all_order_number"); while ($r = db_fetch_array($t)) { $objectLength = $r['sob_' . $r['sob_all_type'] . '_length']; // eg. text objects are 'sob_text_length' if ($r['sob_all_type'] == 'lookup') { $objectLength = $r['sob_lookup_code_length']; // code length if ($r['sob_lookup_no_description'] != '1') { $objectLength = $objectLength + 0.5 + $r['sob_lookup_description_length']; // description length } } if ($r['sob_all_type'] == 'text') { if ($format[$r['sob_text_format']]->type == 'date') { $objectLength = $objectLength + 1.5; // date button length } } $fldDimensions[$r['sob_all_name']]->type = $r['sob_all_type']; $fldDimensions[$r['sob_all_name']]->columnAlign = 'left'; if ($r['sob_all_type'] == 'text') { $fldDimensions[$r['sob_all_name']]->columnAlign = $r['sob_text_align']; } if ($r['sob_all_type'] == 'display') { $fldDimensions[$r['sob_all_name']]->columnAlign = $r['sob_display_align']; } $fldDimensions[$r['sob_all_name']]->columnTitle = $r['sob_all_title']; $fldDimensions[$r['sob_all_name']]->column = $r['sob_all_column_number']; $fldDimensions[$r['sob_all_name']]->leftCoordinate = round($sfDimensions[$r['sob_all_column_number']]->columnWidth); $fldDimensions[$r['sob_all_name']]->columnWidth = $objectLength * 16 + $hGap; $sfDimensions[$r['sob_all_column_number']]->columnWidth = round($sfDimensions[$r['sob_all_column_number']]->columnWidth) + $fldDimensions[$r['sob_all_name']]->columnWidth; $colHeight = round($sfDimensions[$r['sob_all_column_number']]->columnHeight); if ($colHeight == 0) { $sfDimensions[$r['sob_all_column_number']]->columnHeight = $vHeight; $colHeight = $sfDimensions[$r['sob_all_column_number']]->columnHeight; } if ($r['sob_all_type'] == 'textarea' and $colHeight < $r['sob_textarea_height'] * 16) { $sfDimensions[$r['sob_all_column_number']]->columnHeight = $r['sob_textarea_height'] * 16; } } $longest = ''; foreach ($sfDimensions as $key => $value) { // get longest row if ($value->columnWidth > $longest) { $longest = $value->columnWidth; } $rowHeight = $rowHeight + $value->columnHeight; } $prntCheckBox = $this->objectProperty['sob_subform_delete_box'] == '1' and $this->objectProperty['sob_subform_read_only'] != '1'; if ($prntCheckBox) { //add room for the delete tick box $longest = $longest + $vHeight; } else { $longest = $longest + 20; } //add scroll bar $sfWidth = $longest + 20; $sfLeft = $this->objectProperty['sob_subform_left']; //add height of subform title + column title(s) to overall height $sfHeight = $this->objectProperty['sob_subform_height'] * 16 - $this->objectProperty['sob_subform_title_height'] * 16 - 100; $sfTop = $this->objectProperty['sob_subform_top']; if ($this->objectProperty['sob_subform_width'] == 0) { $scsfWidth = $sfWidth + 10; } else { $scsfWidth = $this->objectProperty['sob_subform_width']; } $scsfHeight = $sfHeight - 20; $scsfHeight = $sfHeight - 16; //changed from -10 to -16 $s = "<div name='sf_title{$fieldName}' id='sf_title{$fieldName}' class='selected' style='text-align:left;position:absolute;height:20;top:{$sfTop};left:{$sfLeft};width:{$sfWidth};'>{$fieldTitle}</div>{$CRLF}"; $sfTop = $sfTop + 20; $s = $s . "{$TAB}<div name='{$fieldName}' id='{$fieldName}' class='selected' style='position:absolute;overflow:auto;width:{$scsfWidth};height:{$scsfHeight};top:{$sfTop};left:{$sfLeft};'>{$CRLF}"; $s = $s . "{$TAB} <div name='title{$fieldName}' id='title{$fieldName}' style='position:absolute;top:0;left:0;background:#6D7B8D'>{$CRLF}"; // build subform column titles $columnTop = 0; $columnNumber = ''; foreach ($fldDimensions as $key => $value) { if ($columnNumber != $value->column) { if ($columnNumber == '') { $columnNumber = $value->column; } } if ($columnTop == 0) { // only print headings for the first row (sob_subform_column_order) if ($columnNumber == $value->column) { $width = $value->columnWidth; $dbc = ''; if ($this->parentForm->zzsys_user_id == 'globeadmin' and $this->form->sys_setup != '1') { $dbc = " ondblclick=\"openBrowse('object', '{$objectID}', '', '" . $this->parentForm->session . "', '')\""; } $s = $s . "{$TAB} <div {$dbc} class='unselected' style='vertical-align:top;font-size:x-small;font-family:tahoma;font-weight:bold;top:0;left:{$value->leftCoordinate};width:{$width};height:{$vTitleHeight};overflow:hidden;position:absolute;text-align:" . align($value->columnAlign) . ";'>{$CRLF}"; $s = $s . "{$TAB} {$value->columnTitle}{$CRLF}"; $s = $s . "{$TAB} </div>{$CRLF}"; $nextLeft = $value->leftCoordinate + $value->columnWidth; } } } $sfHeight = $sfHeight - $columnTop - $vHeight; // adjusting for scrollng div $this->objectName = $this->objectProperty['sob_all_name']; // set subform name //add room for the delete tick box if ($this->objectProperty['sob_subform_read_only'] != '1') { $s = $s . "{$TAB} <div class='unselected' style='top:0;left:{$nextLeft};width:50;height:{$vTitleHeight};overflow:hidden;position:absolute;align:left;'>{$CRLF}"; //align:left removed if ($prntCheckBox) { $s = $s . "{$TAB} <font style='vertical-align:top;font-size:xx-small;font-family:tahoma;font-weight:bold;'> Delete </font>{$CRLF}"; } $s = $s . "{$TAB} </div>{$CRLF}"; } //end of subform column titles //start scrolling div $sfHeight = $sfHeight - $vTitleHeight; // adjust a bit to see all of scroll bar $columnTop = $columnTop + $vTitleHeight; //added by nick 10-06-09 $grey needs to be defined before it can be used //vvvvv $grey = iif($grey == $this->objectProperty['sob_subform_odd_background_color'], $this->objectProperty['sob_subform_even_background_color'], $this->objectProperty['sob_subform_odd_background_color']); //^^^^^ $subformClass = str_replace('.', '', $this->objectProperty['sob_all_class']); $s = $s . "{$TAB} <div name='scroller{$fieldName}' class='{$subformClass}' id='scroller{$fieldName}' style='border-style:solid;border-width:2;border-color:white;position:absolute;overflow:scroll;width:{$sfWidth};height:{$sfHeight};top:{$columnTop};left:0;background:{$grey};'>{$CRLF}"; //put subform objects in an array $subformObjects = array(); $t = nuRunQuery("SELECT * FROM zzsys_object WHERE sob_zzsys_form_id = '" . $this->objectProperty['zzsys_object_id'] . "' ORDER BY sob_all_column_number, sob_all_order_number"); while ($r = db_fetch_object($t)) { $subformObjects[] = $r; } //get SQL for subform // $subformSQL = replaceVariablesInString($this->TT,$this->objectProperty['sob_subform_sql'], $this->recordID); //get SQL for subform //-- added by sc 4-feb-2009 if (is_array($this->parentForm->recordValues)) { $hVariables = arrayToHashArray($this->parentForm->recordValues); //--session values (access level and user etc. ) } $subformSQL = replaceVariablesInString($this->TT, $this->objectProperty['sob_subform_sql'], $this->recordID); if (is_array($this->parentForm->recordValues)) { $subformSQL = replaceHashVariablesWithValues($hVariables, $subformSQL); } //--------- $subformTable = nuRunQuery($subformSQL); $columnTop = $vHeight * -1 + 5; $nextTop = 0; $columnNumber = ''; //loop through subform records if ($this->parentForm->cloning == '1') { $primaryKey = ''; } else { $primaryKey = $this->objectProperty['sob_subform_primary_key']; } while ($subformRecord = mysql_fetch_array($subformTable)) { $this->recordID = $subformRecord[$this->objectProperty['sob_subform_primary_key']]; $this->nextRowNumber(); //loop through each object for this subform record $newRow = true; $grey = iif($grey == $this->objectProperty['sob_subform_odd_background_color'], $this->objectProperty['sob_subform_even_background_color'], $this->objectProperty['sob_subform_odd_background_color']); $dq = '"'; $s = $s . "{$TAB} <div id='rowdiv_{$this->subformPrefix}' onfocus='SFrowColor(this, {$dq}{$fieldName}{$dq})' style='background:{$grey};height:{$rowHeight}'>{$CRLF}"; $checkBoxDone = false; for ($i = 0; $i < count($subformObjects); $i++) { $subformFieldDiv = $fldDimensions[$subformObjects[$i]->sob_all_name]; if ($columnNumber != $subformFieldDiv->column or $i == 0) { $columnNumber = $subformFieldDiv->column; $columnTop = $nextTop; $nextTop = $columnTop + $sfDimensions[$columnNumber]->columnHeight; } //add room for the delete tick box if ($prntCheckBox and !$checkBoxDone) { $checkBoxDone = true; $s = $s . "{$TAB} <div style='position:absolute;top:{$columnTop};left:{$nextLeft}'>{$CRLF}"; $s = $s . "{$TAB} <input name='row{$this->subformPrefix}' id='row{$this->subformPrefix}' type='checkbox' {$OnChange} tabindex='-1'/>{$CRLF}"; $s = $s . "{$TAB} </div>{$CRLF}"; } $s = $s . "{$TAB} <div name='row{$this->subformPrefix}' id='row{$this->subformPrefix}' style='background:lightgray;position:absolute;top:{$columnTop};left:{$subformFieldDiv->leftCoordinate}'>{$CRLF}"; $fieldWidth = $subformFieldDiv->columnWidth - $hGap; if ($newRow) { $s = $s . "{$TAB} <input name='{$this->subformPrefix}{$primaryKey}' id='{$this->subformPrefix}{$primaryKey}' value='{$this->recordID}' type='hidden'/>{$CRLF}"; $newRow = false; } $s = $s . "{$TAB} " . $this->buildObject($subformObjects[$i], $subformRecord) . "{$CRLF}"; $s = $s . "{$TAB} </div>{$CRLF}"; } $rowNumber = $rowNumber + 1; $newRow = true; $s = $s . "{$TAB} </div>{$CRLF}"; } $sfRowTotal = $rowNumber + $blankRows; $columnNumber = ''; //loop through blank subform records for ($blankRecord = 0; $blankRecord < $blankRows; $blankRecord++) { $this->recordID = '-1'; $this->nextRowNumber(); //loop through each object for this subform record $grey = iif($grey == $this->objectProperty['sob_subform_odd_background_color'], $this->objectProperty['sob_subform_even_background_color'], $this->objectProperty['sob_subform_odd_background_color']); // $grey = iif($grey=='#E0E0E0 ','#F0F0F0','#E0E0E0 '); $s = $s . "{$TAB} <div style='background:{$grey};height:{$rowHeight}'>{$CRLF}"; $checkBoxDone = false; for ($i = 0; $i < count($subformObjects); $i++) { $subformFieldDiv = $fldDimensions[$subformObjects[$i]->sob_all_name]; if ($columnNumber != $subformFieldDiv->column) { $columnNumber = $subformFieldDiv->column; $columnTop = $nextTop; $nextTop = $columnTop + $sfDimensions[$columnNumber]->columnHeight; } //add room for the delete tick box if ($prntCheckBox and !$checkBoxDone) { $checkBoxDone = true; $s = $s . "{$TAB} <div style='position:absolute;top:{$columnTop};left:{$nextLeft}'>{$CRLF}"; $s = $s . "{$TAB} <input name='row{$this->subformPrefix}' id='row{$this->subformPrefix}' type='checkbox' {$OnChange} tabindex='-1' checked='checked'/>{$CRLF}"; $s = $s . "{$TAB} </div>{$CRLF}"; } $s = $s . "{$TAB} <div name='{$this->subformPrefix}' id='{$this->subformPrefix}' style='position:absolute;top:{$columnTop};left:{$subformFieldDiv->leftCoordinate}'>{$CRLF}"; $fieldWidth = $subformFieldDiv->columnWidth - $hGap; $s = $s . "{$TAB} " . $this->buildObject($subformObjects[$i], $subformRecord) . "{$CRLF}"; $s = $s . "{$TAB} </div>{$CRLF}"; } $rowNumber = $rowNumber + 1; $columnNumber = ''; $s = $s . "{$TAB} </div>{$CRLF}"; } $s = $s . "{$TAB} </div>{$CRLF}"; $s = $s . "{$TAB} </div>{$CRLF}"; $s = $s . "{$TAB} </div>{$CRLF}"; $s = $s . "{$TAB} <div style='position:absolute;overflow:hidden;width:0;height:0;top:0;left:10;background:blue;'>{$CRLF}"; $sfColumns = count($fldDimensions); $s = $s . "{$TAB} <input name='subformid{$fieldName}' id='subformid{$fieldName}' value='" . $this->objectProperty['zzsys_object_id'] . "' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='rows{$fieldName}' id='rows{$fieldName}' value='{$sfRowTotal}' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='columns{$fieldName}' id='columns{$fieldName}' value='{$sfColumns}' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='table{$fieldName}' id='table{$fieldName}' value='" . $this->objectProperty['sob_subform_table'] . "' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='foreignkey{$fieldName}' id='foreignkey{$fieldName}' value='" . $this->objectProperty['sob_subform_foreign_key'] . "' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='primarykey{$fieldName}' id='primarykey{$fieldName}' value='" . $this->objectProperty['sob_subform_primary_key'] . "' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='readonly{$fieldName}' id='readonly{$fieldName}' value='" . $this->objectProperty['sob_subform_read_only'] . "' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='deletebox{$fieldName}' id='deletebox{$fieldName}' value='" . $this->objectProperty['sob_subform_delete_box'] . "' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='rowColor_{$fieldName}' id='rowColor_{$fieldName}' value='" . $this->objectProperty['sob_subform_selected_row_color'] . "' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='lastRow_{$fieldName}' id='lastRow_{$fieldName}' value='' type='hidden' />{$CRLF}"; $s = $s . "{$TAB} <input name='lastColor_{$fieldName}' id='lastColor_{$fieldName}' value='' type='hidden' />{$CRLF}"; $cNo = 0; foreach ($fldDimensions as $key => $value) { $s = $s . "{$TAB} <input name='{$fieldName}{$cNo}' id='{$fieldName}{$cNo}' value='{$key}' type='hidden' />{$CRLF}"; $cNo = $cNo + 1; } $s = $s . "{$TAB}</div>{$CRLF}"; return $s; }
<?php require_once 'nucommon.php'; if (isset($_GET['p'])) { $values = array($_GET['p']); $sql = "SELECT zzzsys_php_id, slp_php FROM zzzsys_php WHERE slp_code = ? AND slp_nonsecure = '1' "; $rs = nuRunQuery($sql, $values); $num = db_num_rows($rs); if ($num == 1) { $r = db_fetch_object($rs); $r->slp_php = nuGetSafePHP('slp_php', $r->zzzsys_php_id, $r->slp_php); $e = nuReplaceHashes($r->slp_php, $_GET); eval($e); } else { echo "Request is not allowed"; } } else { echo "Request format is invalid"; }
function hasDeleteBox($pParentID) { $t = nuRunQuery("SELECT * FROM zzsys_object WHERE zzsys_object_id = '{$pParentID}'"); $r = db_fetch_object($t); return $r->sob_subform_delete_box == '1'; }
function mysqlbackup($host, $dbname, $uid, $pwd, $output, $structure_only) { //this function creates a text file (or output to a HTTP connection), that when parsed through MYSQL's telnet client, will re-create the entire database //Parameters: // $host: usually "localhost" but depends on where the MySQL database engine is mounted // $dbname : The MySQL database name // $uid : the database's username (not your account's), leave blank if none is required // $pwd : the database's password // $output : this is the complete filespec for the output text file, or if you want the result SQL to be sent back to the browser, leave blank. // $structure_only : set this to true if you want just the schema of the database (not the actual data) to be output. // ************** // IMPORTANT: If you use this function, for personal or commercial use, AND you feel an overwhelming sense of gratitude that someone actually took the time and wrote it, // immediately go to your paypal account and send me $10 with a small comment of how and how much it helped! Set the payment recipient to woodystanford@yahoo.com . // ************** if (strval($output) != "") { $fptr = fopen($output, "w"); } else { $fptr = false; } //connect to MySQL database $con = mysql_connect($host, $uid, $pwd); $db = mysql_select_db($dbname, $con); //open back-up file ( or no file for browser output) //set up database out($fptr, "create database {$dbname};\n\n"); //enumerate tables $res = mysql_list_tables($dbname); $nt = mysql_num_rows($res); for ($a = 0; $a < $nt; $a++) { $row = mysql_fetch_row($res); $tablename = $row[0]; //start building the table creation query $sql = "create table {$tablename}\n(\n"; $res2 = nuRunQuery("SELECT * FROM {$tablename} "); $nf = mysql_num_fields($res2); $nr = mysql_num_rows($res2); $fl = ""; //parse the field info first for ($b = 0; $b < $nf; $b++) { $fn = mysql_field_name($res2, $b); $ft = mysql_fieldtype($res2, $b); $fs = mysql_field_len($res2, $b); $ff = mysql_field_flags($res2, $b); $sql .= " {$fn} "; $is_numeric = false; switch (strtolower($ft)) { case "int": $sql .= "int"; $is_numeric = true; break; case "blob": $sql .= "text"; $is_numeric = false; break; case "real": $sql .= "real"; $is_numeric = true; break; case "string": $sql .= "char({$fs})"; $is_numeric = false; break; case "unknown": switch (intval($fs)) { case 4: //little weakness here...there is no way (thru the PHP/MySQL interface) to tell the difference between a tinyint and a year field type $sql .= "tinyint"; $is_numeric = true; break; default: //we could get a little more optimzation here! (i.e. check for medium ints, etc.) $sql .= "int"; $is_numeric = true; break; } break; case "timestamp": $sql .= "timestamp"; $is_numeric = true; break; case "date": $sql .= "date"; $is_numeric = false; break; case "datetime": $sql .= "datetime"; $is_numeric = false; break; case "time": $sql .= "time"; $is_numeric = false; break; default: //future support for field types that are not recognized (hopefully this will work without need for future modification) $sql .= $ft; $is_numeric = true; //I'm assuming new field types will follow SQL numeric syntax..this is where this support will breakdown break; } //VERY, VERY IMPORTANT!!! Don't forget to append the flags onto the end of the field creator if (strpos($ff, "unsigned") != false) { //timestamps are a little screwy so we test for them if ($ft != "timestamp") { $sql .= " unsigned"; } } if (strpos($ff, "zerofill") != false) { //timestamps are a little screwy so we test for them if ($ft != "timestamp") { $sql .= " zerofill"; } } if (strpos($ff, "auto_increment") != false) { $sql .= " auto_increment"; } if (strpos($ff, "not_null") != false) { $sql .= " not null"; } if (strpos($ff, "primary_key") != false) { $sql .= " primary key"; } //End of field flags if ($b < $nf - 1) { $sql .= ",\n"; $fl .= $fn . ", "; } else { $sql .= "\n);\n\n"; $fl .= $fn; } //we need some of the info generated in this loop later in the algorythm...save what we need to arrays $fna[$b] = $fn; $ina[$b] = $is_numeric; } out($fptr, $sql); if ($structure_only != true) { //parse out the table's data and generate the SQL INSERT statements in order to replicate the data itself... for ($c = 0; $c < $nr; $c++) { $sql = "insert into {$tablename} ({$fl}) values ("; $row = mysql_fetch_row($res2); for ($d = 0; $d < $nf; $d++) { $data = strval($row[$d]); if ($ina[$d] == true) { $sql .= intval($data); } else { $sql .= "\"" . mysql_escape_string($data) . "\""; } if ($d < $nf - 1) { $sql .= ", "; } } $sql .= ");\n"; out($fptr, $sql); } out($fptr, "\n\n"); } mysql_free_result($res2); } if ($fptr != false) { fclose($fptr); } return 0; }
<?php /* ** File: image.php ** Author: nuSoftware ** Created: 2007/04/26 ** Last modified: 2009/07/15 ** ** Copyright 2004, 2005, 2006, 2007, 2008, 2009 nuSoftware ** ** This file is part of the nuBuilder source package and is licensed under the ** GPLv3. For support on developing in nuBuilder, please visit the nuBuilder ** wiki and forums. For details on contributing a patch for nuBuilder, please ** visit the `Project Contributions' forum. ** ** Website: http://www.nubuilder.com ** Wiki: http://wiki.nubuilder.com ** Forums: http://forums.nubuilder.com */ $dir = $_GET['dir']; $imageID = $_GET['iid']; include "../{$dir}/database.php"; include 'common.php'; $s = "SELECT * FROM zzsys_image WHERE zzsys_image_id = '{$imageID}'"; $t = nuRunQuery($s); $r = db_fetch_object($t); Header("Content-type: image/png"); print $r->sim_blob;
$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; ?>
function db_columns($n) { $a = array(); $d = $_SESSION['DBName']; $s = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '{$d}' AND TABLE_NAME = '{$n}' ORDER BY ORDINAL_POSITION"; $t = nuRunQuery($s); while ($r = db_fetch_object($t)) { $a[] = $r->COLUMN_NAME; } return $a; }
function nuDownloadFile($i, $s = '') { //-- $s can be used to get type, name and blob from another table if ($s == '') { $s = "SELECT sfi_type AS file_type, sfi_name AS file_name, sfi_blob AS file_blob FROM zzzsys_file WHERE zzzsys_file_id = '{$i}'"; } $t = nuRunQuery($s); $r = db_fetch_object($t); header('Content-Type: ' . $r->file_type . ';'); header('Content-Disposition: attachement;filename="' . $r->file_name . '";'); $f = fopen('php://output', 'w'); fwrite($f, $r->file_blob); fclose($f); }
public function buildControls($sectionNumber, $canGrow, $record) { $s = ''; $setup = nuSetup(); $dq = '"'; $sortedControls = $this->sortSectionControlsByTopPositionOrder($sectionNumber, $this->report->Controls); for ($j = 0; $j < count($sortedControls); $j++) { $pSection = $sortedControls[$j]["Section"]; $pName = $sortedControls[$j]["Name"]; $pControlSource = $sortedControls[$j]["Source"]; $i = $this->getDisplayControlIndex($pSection, $pName, $pControlSource); if ($this->report->Controls[$i]->Section == $sectionNumber) { $Name = $this->report->Controls[$i]->Name; $Source = $this->report->Controls[$i]->ControlSource; $ControlType = $this->report->Controls[$i]->ControlType; $Top = $this->toScale($this->report->Controls[$i]->Top); $Width = $this->toScale($this->report->Controls[$i]->Width); $Height = $this->toScale($this->report->Controls[$i]->Height); $Left = $this->toScale($this->report->Controls[$i]->Left); $Section = $this->report->Controls[$i]->Section; $Fontname = $this->report->Controls[$i]->FontName; $Fontsize = $this->report->Controls[$i]->FontSize; $Format = $this->report->Controls[$i]->Format; $Decimal = $this->report->Controls[$i]->DecimalPlaces; $IsHyperlink = $this->report->Controls[$i]->IsHyperlink; $ReportTag = $this->report->Controls[$i]->Tag; $Report = $this->report->Controls[$i]->Report; $Parameters = $this->report->Controls[$i]->Parameters; $LikeClause = $this->report->Controls[$i]->SmartTags; $LikeClause = str_replace("\"", "", $LikeClause); //image if ($this->sectionGrow == 1 && $sectionNumber != 0) { $Top = $Top + $this->sectionGrowStack; } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'page break') { $this->justDidPageBreak = true; $this->hasExplicitPageBreak = true; } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'graph') { $thetag = $this->report->Controls[$i]->ControlSource; $thename = $this->report->Controls[$i]->Graph; $thedir = $_GET['dir']; for ($a = 0; $a < count($this->fields); $a++) { //-----replace any strings, with hashes around them, in the querystring that match //-----fieldnames in the table //-----with values from the table //-----e.g. id=#ID# could become id=007 $thetag = str_replace('#' . $this->fields[$a] . '#', $record[$this->fields[$a]], $thetag); } $addSession = '&ses=' . $_GET['ses']; $s = $s . " <div style='position:absolute;left:{$Left};top:{$Top};height:{$Height}'>\n"; $s = $s . " <img src='graph_report.php?dir={$thedir}{$addSession}&activityID={$this->reportID}&graph_name={$thename}&{$thetag}'>\n"; $s = $s . " </div>\n"; } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'image') { $thetag = $this->report->Controls[$i]->ControlSource; $imageCode = $this->report->Controls[$i]->Graph; //-- the code (sim_code in zzsys_image) $thedir = $_GET['dir']; for ($a = 0; $a < count($this->fields); $a++) { //-----replace any strings, with hashes around them, in the querystring that match //-----fieldnames in the table //-----with values from the table //-----e.g. id=#ID# could become id=007 $thetag = str_replace('#' . $this->fields[$a] . '#', $record[$this->fields[$a]], $thetag); } $imageT = nuRunQuery("SELECT zzsys_image_id FROM zzsys_image WHERE sim_code = '{$imageCode}'"); $imageR = db_fetch_row($imageT); $s = $s . " <div style='position:absolute;left:{$Left};top:{$Top};height:{$Height}'>\n"; $s = $s . " <img src='formimage.php?dir={$thedir}&iid={$imageR['0']}&{$thetag}'>\n"; $s = $s . " </div>\n"; } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'label') { if ($Source == '=Date()' || $Source == '=Now()') { if ($Format == '' || $Format == '20' || $Format == 'Long Date') { $formattedValue = date('d-M-Y H:i'); } else { $formattedValue = date($this->accessDateFormatToPHPDateFormat($Format)); } //$Caption = $formattedValue; $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>{$formattedValue}</div>\n"; } else { if ($Source == '="Page " & [Page] & " of " & [Pages]') { $formattedValue = "Page #thePageNumber# of #totalNumberOfPages#"; $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>{$formattedValue}</div>\n"; //echo $s."<br>"; } else { $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>" . $this->report->Controls[$i]->Caption . "</div>\n"; } } } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'text area') { //--Field $displayValue = $record[$this->report->Controls[$i]->ControlSource]; //Sum $theSource = $this->report->Controls[$i]->ControlSource; $builtInFunction = false; //============numbering pages (using a label)======================================= //---- Page #thePageNumber# of #totalNumberOfPages# eg. Page 6 of 12 //================================================================================== if ($theSource == '="Page " & [Page] & " of " & [Pages]' || $theSource == 'Page #thePageNumber# of #totalNumberOfPages#') { $displayValue = "Page #thePageNumber# of #totalNumberOfPages#"; } if (strtoupper($theSource) == '=NOW()' || strtoupper($theSource) == '=DATE()') { if ($Format == '' || $Format == '20' || $Format == 'Long Date') { $displayValue = date('d-M-Y H:i'); } else { $displayValue = date($this->accessDateFormatToPHPDateFormat($Format)); } } if (strtoupper(substr($theSource, 0, 4)) == 'SUM(') { //--sum for header or footer sections $sumField = substr($theSource, 4, -1); $selectFields = 'SUM(' . trim($sumField) . '_Sum) as answer '; $groupSQL = $this->getGroupBySql($this->sectionLevel($sectionNumber), $selectFields, $record); $t1 = nuRunQuery($groupSQL); $r1 = mysql_fetch_row($t1); $displayValue = $r1[0]; } if (strtoupper(substr($theSource, 0, 6)) == '=SUM([') { //--if the sum function $sumField = substr($theSource, 6, -2); $selectFields = 'SUM(' . trim($sumField) . '_Sum) as answer '; $groupSQL = $this->getGroupBySql($this->sectionLevel($sectionNumber), $selectFields, $record); $t1 = nuRunQuery($groupSQL); $r1 = mysql_fetch_row($t1); $displayValue = $r1[0]; } if (strtoupper(substr($theSource, 0, 8)) == 'PERCENT(') { //--percent of 2 sums $sumField = substr($theSource, 8, -1); $sumFields = array(); $sumFields = explode(',', $sumField); $selectFields = 'SUM(' . trim($sumFields[0]) . '_Sum) as answer1, SUM(' . trim($sumFields[1]) . '_Sum) as answer2 '; $groupSQL = $this->getGroupBySql($this->sectionLevel($sectionNumber), $selectFields, $record); $t1 = nuRunQuery($groupSQL); $r1 = mysql_fetch_row($t1); if ($r1[1] == 0) { $displayValue = 0; //--because nothing can be divided by zero } else { $displayValue = $r1[0] / $r1[1] * 100; } } $displayValue = formatTextValue($displayValue, $Format); if ($this->report->Controls[$i]->CanGrow == 'True' and $canGrow) { $oldValue = $displayValue; $break_variants = array("<br>", "<BR>", "<br />", "<BR />", "<br/>", "<BR/>"); $displayValue = str_replace($break_variants, "\n", $displayValue); if ($this->report->nuBuilder == '1') { $textWidth = str_replace('px', '', $this->report->Controls[$i]->Width) / ($this->report->Controls[$i]->FontSize / 2); $displayValue = wordwrap($displayValue, $textWidth, "<br />"); } else { $displayValue = wordwrap($displayValue, iif($ReportTag == '', 10, $ReportTag), "<br />"); } $displayValue = nl2br($displayValue); $lines = substr_count($displayValue, "<br />") + 1; $linesArray = explode("<br />", $displayValue); if ($lines <= 5) { $Height = $Fontsize * 1.2; } else { if ($lines > 5 && $lines <= 15) { $Height = $Fontsize * 1.3; } else { if ($lines > 15 && $lines <= 25) { $Height = $Fontsize * 1.4; } else { if ($lines > 25) { $Height = $Fontsize * 1.5; } } } } $defaultHeight = $Height; $Height = $Height * $lines; $this->growByHeight = $this->growByHeight + $Height; if ($this->growBy < $Height - $defaultHeight) { $this->growBy = $Height - $defaultHeight; if ($sectionNumber != 0) { $sectionHeight = $this->toScale($this->report->Sections[$sectionNumber]->Height); $growByHeight = $this->growBy; $growString = ""; $pos = count($linesArray) - 1; if ($this->growAddHeight == 0) { $this->growAddHeight = $this->thisPageLength; } if ($this->growAddHeight + $growByHeight > $this->useablePageLength) { for ($k = count($linesArray) - 1; $k >= 0; $k--) { $Height = $defaultHeight * $k; $this->growBy = $Height - $defaultHeight; $growByHeight = $this->growBy + $sectionHeight; if ($this->growAddHeight + $growByHeight < $this->useablePageLength) { $pos = $k; $this->attachGroupHeaderFieldGrowByText($this->report->Controls[$i]); $this->growBySectionNumber = $Section; break; } } for ($k = 0; $k < $pos; $k++) { $growString = $growString . $linesArray[$k] . "<br />"; } $index = 0; for ($k = $pos; $k < count($linesArray); $k++) { $this->nextPageGrowText[$index] = $linesArray[$k]; $index++; } $displayValue = $growString; } else { $this->growAddHeight = $this->growAddHeight + $growByHeight; } $this->growByHeight = $Height; $this->sectionGrowStack = $growByHeight; $this->sectionGrow = 1; } } if ($sectionNumber != 0) { $this->growByTotal = $this->growByTotal + $Height; } $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$this->growByHeight}'>{$displayValue}</div>\n"; } else { //------create drilldown------------------- if ($Report != '') { $reportlink = $Report; $sessionlink = $_GET['ses']; $formsessionlink = $_GET['form_ses']; $dirlink = $_GET['dir']; $displayValue = "<a class='{$Name}' href='runreport.php?x=1&dir={$dir}&ses={$sessionlink}&form_ses={$formsessionlink}&r={$Report}'>{$displayValue}</a>"; } //----------------------------------------- $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>{$displayValue}</div>\n"; } } } } return $s; }
<?php require_once 'nucommon.php'; $s = "SELECT * FROM zzzsys_file WHERE sfi_code = ? "; $t = nuRunQuery($s, array($_GET['i'])); $r = db_fetch_object($t); $f = "'Content-type: {$r->sfi_type}'"; Header($f); print $r->sfi_blob;
} else { $filename = $_FILES['uploadedfile']['tmp_name']; $handle = fopen($filename, "rb"); $contents = fread($handle, filesize($filename)); $contents = addslashes($contents); fclose($handle); $newRecord = false; if ($iid == '-1' or $iid == '') { $iid = uniqid('1'); $newRecord = true; } if ($newRecord) { nuRunQuery("INSERT INTO zzsys_image (zzsys_image_id, sim_blob) VALUES ('{$iid}','{$contents}')"); tofile('new'); } else { nuRunQuery("UPDATE zzsys_image SET sim_blob = '{$contents}' WHERE zzsys_image_id = '{$iid}'"); tofile('old'); } print "<script>\n\n"; print "function closedown(){\n"; //--- set zzsys_image_id on opener page print " window.opener.document.getElementById('recordID').value = '{$iid}';\n\n"; print " if(window.opener.nuAfterUpload){\n"; print " window.opener.nuAfterUpload('recordID');\n"; print " };\n\n"; print " self.close();\n\n"; print "}\n"; print "</script>\n"; print "<body onload=' closedown()'>\n"; } print "</body>";
print "theWeight[2] = 'lighter'\n"; print "\nvar theControl = new Array()\n"; print "theControl[0] = 'Field'\n"; print "theControl[1] = 'Label'\n"; print "theControl[2] = 'Graph'\n"; print "theControl[3] = 'PageBreak'\n"; print "\nvar theGraph = new Array()\n"; $tg = nuRunQuery("SELECT sag_graph_name FROM zzsys_activity_graph WHERE sag_zzsys_activity_id = '{$reportID}'"); $tcount = 1; print "theGraph[0] = ''\n"; while ($rg = db_fetch_row($tg)) { print "theGraph[{$tcount}] = 'graph-{$rg['0']}'\n"; $tcount = $tcount + 1; } //added by nick 15-01-09 $tg = nuRunQuery("SELECT sim_code FROM zzsys_image "); while ($rg = db_fetch_row($tg)) { print "theGraph[{$tcount}] = 'image-{$rg['0']}'\n"; $tcount = $tcount + 1; } print "\n</script>\n"; function sectionNumber($pSection, $pLayout, $pVisible) { $arrayNumberOfSection = -1; for ($i = 0; $i < count($pLayout->Sections); $i++) { if ($pLayout->Sections[$i]->SectionNumber == $pSection) { $arrayNumberOfSection = $i; } } if ($arrayNumberOfSection == -1) { //--not created by Access Report
<?php require_once 'nucommon.php'; $jsonID = $_GET['i']; $t = nuRunQuery("SELECT deb_message AS json FROM zzzsys_debug WHERE zzzsys_debug_id = ? ", array($jsonID)); $r = db_fetch_object($t); $JSON = json_decode($r->json); $DATA = $JSON->slp_php; $ID = $JSON->zzzsys_php_id; $DATA = nuGetSafePHP('slp_php', $ID, $DATA); $TABLE_ID = nuTT(); $hashData = nuBuildHashData($JSON, $TABLE_ID); $php = nuReplaceHashes($DATA, $hashData); eval($php); //-- run php code nuRunQuery("DELETE FROM zzzsys_debug WHERE zzzsys_debug_id = ? ", array($jsonID));
public function buildControls($sectionNumber, $canGrow, $record) { //tofile("Build Controls"); $s = ''; $setup = nuSetup(); $dq = '"'; //tofile("Count Controls ".count($this->report->Controls)); for ($i = 0; $i < count($this->report->Controls); $i++) { if ($this->report->Controls[$i]->Section == $sectionNumber) { //tofile("Get Control"); $Name = $this->report->Controls[$i]->Name; $Source = $this->report->Controls[$i]->ControlSource; $Controltype = $this->report->Controls[$i]->ControlType; //tofile("Control Type: ".$this->report->Controls[$i]->ControlType); $Top = $this->toScale($this->report->Controls[$i]->Top); $Width = $this->toScale($this->report->Controls[$i]->Width); $Height = $this->toScale($this->report->Controls[$i]->Height); $Left = $this->toScale($this->report->Controls[$i]->Left); $Section = $this->report->Controls[$i]->Section; $Fontname = $this->report->Controls[$i]->FontName; $Fontsize = $this->report->Controls[$i]->FontSize; if (intval($Fontsize) >= 12) { $Fontsize = $Fontsize - 4; } else { if (intval($Fontsize) == 11) { $Fontsize = $Fontsize - 3; } else { if (intval($Fontsize) <= 10) { $Fontsize = $Fontsize - 2; } } } $Fontweight = $this->report->Controls[$i]->FontWeight; $Fontname = iif($Fontname == null, 'Arial', $Fontname); $Fontname = iif($Fontname != 'Arial', 'Arial', $Fontname); $Fontweight = iif($Fontweight == 'bold', 'B', ''); $Caption = $this->report->Controls[$i]->Caption; $ln = iif($Caption == '', 2, 0); $TextAlign = $this->report->Controls[$i]->TextAlign; $TextAlign = $this->GetTextAlign($TextAlign); $ForeColor = $this->report->Controls[$i]->ForeColor; $BackColor = $this->report->Controls[$i]->BackColor; $BackStyle = $this->report->Controls[$i]->BackStyle; $BorderWidth = $this->report->Controls[$i]->BorderWidth; $BorderColor = $this->report->Controls[$i]->BorderColor; $Format = $this->report->Controls[$i]->Format; $Decimal = $this->report->Controls[$i]->DecimalPlaces; $IsHyperlink = $this->report->Controls[$i]->IsHyperlink; $ReportTag = $this->report->Controls[$i]->Tag; $LikeClause = $this->report->Controls[$i]->SmartTags; $LikeClause = str_replace("\"", "", $LikeClause); //$ForeColor = $this->html2rgb('#'.$ForeColor); //$BackColor = $this->html2rgb('#'.$BackColor); //$BorderColor = $this->html2rgb('#'.$BorderColor); /*if ($BackColor == '' || $BackColor == strtolower('#FFFFFF') || $BackColor == strtolower('FFFFFF')) { $BackStyle = 0; } else { $BackStyle = 1; }*/ $ForeColor = iif(substr($ForeColor, 0, 1) == '#', $ForeColor, '#' . $ForeColor); $BackColor = iif(substr($BackColor, 0, 1) == '#', $BackColor, '#' . $BackColor); $BorderColor = iif(substr($BorderColor, 0, 1) == '#', $BorderColor, '#' . $BorderColor); $ForeColor = $this->html2rgb($ForeColor); $BackColor = $this->html2rgb($BackColor); $BorderColor = $this->html2rgb($BorderColor); $this->SetTextColor($ForeColor[0], $ForeColor[1], $ForeColor[2]); $this->SetFillColor($BackColor[0], $BackColor[1], $BackColor[2]); $this->SetDrawColor($BorderColor[0], $BorderColor[1], $BorderColor[2]); if ($BorderWidth > 0) { $this->SetLineWidth($BorderWidth / 100); $BorderWidth = 1; } //$BorderWidth = 1; //$Top = (($this->stackheight + $Top)/100) + 0.3; $Left = $Left / 100 + 0.2; //$Width = ($Width / 100) + 0.002; $Width = $Width / 100; $Height = $Height / 100; $Top = ($this->stackheight + $Top * 1.0) / 100 + 0.25; //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'page break') { $this->justDidPageBreak = true; $this->hasExplicitPageBreak = true; continue; } if ($this->controlType($this->report->Controls[$i]->ControlType) == 'image') { $thetag = $this->report->Controls[$i]->ControlSource; $imageCode = $this->report->Controls[$i]->Graph; //-- the code (sim_code in zzsys_image) $thedir = $_GET['dir']; for ($a = 0; $a < count($this->fields); $a++) { //-----replace any strings, with hashes around them, in the querystring that match //-----fieldnames in the table //-----with values from the table //-----e.g. id=#ID# could become id=007 $thetag = str_replace('#' . $this->fields[$a] . '#', $record[$this->fields[$a]], $thetag); } $thetag = str_replace(" ", "%20", $thetag); // Escapes any spaces in the parameters/arguments //tofile("Graph Tag: ".$thetag); $imageT = nuRunQuery("SELECT zzsys_image_id FROM zzsys_image WHERE sim_code = '{$imageCode}'"); $imageR = db_fetch_row($imageT); $s = $s . " <div style='position:absolute;left:{$Left};top:{$Top};height:{$Height}'>\n"; $s = $s . " <img src='formimage.php?dir={$thedir}&iid={$imageR['0']}&{$thetag}'>\n"; $s = $s . " </div>\n"; //tofile("http://dev.nubuilder.com/productionnu2/formimage.php?dir=$thedir&iid=$imageR[0]&$thetag"); $logo = fopen("http://dev.nubuilder.com/productionnu2/formimage.php?dir=" . $thedir . "&iid=" . $imageR[0] . "&" . $thetag, "r"); file_put_contents('temp' . $this->imagecount . '.png', $logo); if (filesize('temp' . $this->imagecount . '.png') > 0) { $im = imagecreatefrompng('temp' . $this->imagecount . '.png'); imageinterlace($im, 0); imagepng($im, 'temp' . $this->imagecount . '.png'); $imageDimensions = getimagesize('temp' . $this->imagecount . '.png'); $imageWidth = $imageDimensions[0] * 0.01; $imageHeight = $imageDimensions[1] * 0.01; $this->Image('temp' . $this->imagecount . '.png', $Left, $Top, $imageWidth, $imageHeight); } unlink('temp' . $this->imagecount . '.png'); $this->imagecount++; $this->Rect($Left, $Top, $imageWidth, $imageHeight, 'D'); continue; } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'graph' || $this->report->Controls[$i]->ControlType == 'Graph') { if ($this->controlType($this->report->Controls[$i]->ControlType) == 'graph') { $thetag = $this->report->Controls[$i]->ControlSource; $thename = $this->report->Controls[$i]->Graph; tofile("lowercase graph: " . $thetag); } else { if ($this->report->Controls[$i]->ControlType == 'Graph') { $thetag = $this->report->Controls[$i]->ControlSource; $thename = $this->report->Controls[$i]->Graph; tofile("uppercase graph: " . $thetag); } } $thedir = $_GET['dir']; for ($a = 0; $a < count($this->fields); $a++) { //-----replace any strings, with hashes around them, in the querystring that match //-----fieldnames in the table //-----with values from the table //-----e.g. id=#ID# could become id=007 $thetag = str_replace('#' . $this->fields[$a] . '#', $record[$this->fields[$a]], $thetag); } $addSession = '&ses=' . $_GET['ses']; $thetag = str_replace(" ", "%20", $thetag); // Escapes any spaces in the parameters/arguments //tofile("Graph Tag: ".$thetag); $logo = fopen("http://www.nubuilder.com/productionnu2/graph_report.php?dir={$thedir}{$addSession}&activityID={$this->reportID}&graph_name={$thename}&{$thetag}", "r"); file_put_contents('temp' . $this->imagecount . '.png', $logo); $imageDimensions = getimagesize('temp' . $this->imagecount . '.png'); $imageWidth = $imageDimensions[0] * 0.01; $imageHeight = $imageDimensions[1] * 0.01; $this->Image('temp' . $this->imagecount . '.png', $Left, $Top, $imageWidth, $imageHeight); unlink('temp' . $this->imagecount . '.png'); $this->imagecount++; $this->Rect($Left, $Top, $imageWidth, $imageHeight, 'D'); } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'label' || $this->report->Controls[$i]->ControlType == 'Label') { if (substr($this->report->Controls[$i]->ControlSource, 0, 4) == '<img') { //tofile("Test Caption ".$this->GetImageLink($ReportClass->Controls[$i]->Caption)); //tofile("Show Header fields ".$Name." ".$Source." ".$Caption." ".$Fontname." P".$PageNumber." ".$Top); $this->SetXY($Left, $Top); $output = $this->parse($this->report->Controls[$i]->ControlSource); $image_properties = $this->GetImageSourceAndDimensions($output); if (substr($image_properties['source'], -4, 4) == '.jpg' || substr($image_properties['source'], -4, 4) == '.png') { $this->Image($image_properties['source'], $Left, $Top, $image_properties['width'], $image_properties['height']); } continue; } if ($this->report->Controls[$i]->Tag != $this->report->Controls[$i]->ControlType) { //tofile("Check Tag ".$this->report->Controls[$i]->Tag); //$s = $s . " <div class='$Name' style='position:absolute;top:$Top;height:$Height'><img src='$setup->seStartingDirectory/reports/".$this->report->Controls[$i]->Tag.".jpg'></div>\n"; $this->SetXY($Left, $Top); //$this->Image($setup->seStartingDirectory."/reports/".$ReportClass->Controls[$i]->Tag.".jpg",$Left,$Top,$Width,$Height); if ($ReportClass->Controls[$i]->Caption != '') { $this->SetFont($Fontname, $Fontweight, $Fontsize); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $Caption, $BorderWidth, $ln, $TextAlign); //tofile("Caption: ".$Caption); } continue; } if ($Source == '="Page " & [Page] & " of " & [Pages]' || $Source == 'Page #thePageNumber# of #totalNumberOfPages#') { $Caption = "Page " . $this->pageNumber . " of " . $GLOBALS['TotalPages']; $this->SetFont($Fontname, $Fontweight, $Fontsize); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $Caption, $BorderWidth, $ln, $TextAlign, $BackStyle); $s = $s . " <div class='{$Name}'>Page #thePageNumber# of #totalNumberOfPages#</div>\n"; continue; } else { if ($Source == '=Date()' || $Source == '=Now()') { if ($Format == '' || $Format == '20' || $Format == 'Long Date') { $formattedValue = date('d-M-Y H:i'); } else { $formattedValue = date($this->accessDateFormatToPHPDateFormat($Format)); } $Caption = $formattedValue; $this->SetFont($Fontname, $Fontweight, $Fontsize); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $Caption, $BorderWidth, $ln, $TextAlign, $BackStyle); $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>{$formattedValue}</div>\n"; continue; } } $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>" . $this->report->Controls[$i]->Caption . "</div>\n"; if (strlen($Caption) == 1 && $BorderWidth >= 1) { $this->SetDrawColor($BorderColor[0], $BorderColor[1], $BorderColor[2]); $this->SetFillColor($BorderColor[0], $BorderColor[1], $BorderColor[2]); $BackStyle = 1; } $this->SetFont($Fontname, $Fontweight, $Fontsize); //tofile("Label: ".$this->report->Controls[$i]->ControlSource); $output = $this->parse($this->report->Controls[$i]->Caption); if ($output[0]['innerhtml'] == null) { //tofile("Label used: ".$this->report->Controls[$i]->Caption); $break_variants = array("<br />", "<BR />", "<br/>", "<BR/>"); $string = str_replace($break_variants, "<br>", $this->report->Controls[$i]->Caption); $lines = explode("<br>", $string); if (sizeof($lines) > 1) { $string = ""; for ($j = 0; $j < sizeof($lines); $j++) { $lines[$j] = trim($lines[$j]); $string = $string . $lines[$j] . "\n"; } } if (sizeof($lines) > 1) { //tofile("more than 1 line"); $Height = $this->CalculateLineHeight($Fontsize); $this->SplitLines($Width, $Height, $string, $BorderWidth, $ln, $TextAlign, $BackColor, $BackStyle, $Left, $Top, 0, $i); } else { //tofile("1 line only"); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $this->report->Controls[$i]->Caption, $BorderWidth, $ln, $TextAlign, $BackStyle); } } else { $this->SetXY($Left, $Top); $this->SetHTMLAttributes($Width, $Height, $output, $BorderWidth, $ln, $TextAlign, $BackColor, $BackStyle, $Left, $Top); } //$this->Cell($Width,$Height,$r[$ReportClass->Controls[$i]->ControlSource],$BorderWidth,$ln,$TextAlign,$BackColor); //$this->SetFont($Fontname,$Fontweight,$Fontsize); //$this->SetXY($Left, $Top); //$this->Cell($Width,$Height,$Caption,$BorderWidth,$ln,$TextAlign,$BackStyle); } //======================================================================================== if ($this->controlType($this->report->Controls[$i]->ControlType) == 'text area' || $this->report->Controls[$i]->ControlType == 'Field') { $formattedValue = $record[$this->report->Controls[$i]->ControlSource]; $formattedValue = str_replace(" ", " ", $formattedValue); $formattedValue = str_replace(" ", " ", $formattedValue); if ($this->report->Controls[$i]->Tag != '') { $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'><img src='{$setup->seStartingDirectory}/reports/" . $this->report->Controls[$i]->Tag . ".jpg'></div>\n"; } //Sum $theSource = $this->report->Controls[$i]->ControlSource; //tofile("Source: ".strtoupper(substr($theSource, 0, 8))); if (substr($theSource, 0, 6) == '=Sum([' or strtoupper(substr($theSource, 0, 10)) == '=PERCENT([' or substr($theSource, 0, 4) == 'sum(' or strtoupper(substr($theSource, 0, 8)) == 'PERCENT(') { $sumIt = substr($theSource, 0, 6) == '=Sum([' || substr($theSource, 0, 4) == 'sum('; //tofile(substr($theSource, 0, 10)." flag ".$sumIt); if ($sumIt) { //--if the sum function $SumOn = str_replace('=Sum([', '', $theSource); $SumOn = str_replace('])', '', $SumOn); $SumOn = str_replace('sum(', '', $SumOn); $SumOn = str_replace(')', '', $SumOn); $selectFields = 'sum(' . $SumOn . '_Sum) as answer '; } else { //--if the Percent function $SumOn = substr($theSource, 8); //tofile("Sum On: ".$SumOn); $SumOn = str_replace(']', '', $SumOn); //-- remove right square brackets $SumOn = str_replace('[', '', $SumOn); //-- remove left square brackets $SumOn = str_replace(')', '', $SumOn); //-- remove only right bracket $SumOn = str_replace(' ', '', $SumOn); //-- remove any spaces $theFields = explode(',', $SumOn); //-- split left and right field $selectFields = 'sum(' . $theFields[0] . '_Sum) as divideIt, sum(' . $theFields[1] . '_Sum) as BYY '; //tofile("Select Fields: ".$selectFields); } $SectionLevel = $this->sectionLevel($sectionNumber); for ($ii = 0; $ii <= $SectionLevel; $ii++) { if ($ii == 0) { if ($this->report->Groups[$ii]->Field != '') { $whereClause = $this->report->Groups[$ii]->Field . " = {$dq}" . $record[$this->report->Groups[$ii]->Field] . "{$dq}"; } } else { if ($this->report->Groups[$ii]->Field != '') { $whereClause = $whereClause . ' AND ' . $this->report->Groups[$ii]->Field . " = {$dq}" . $record[$this->report->Groups[$ii]->Field] . "{$dq}"; } } } $SumOn = trim($SumOn); if (strlen($SectionLevel) == 0) { $whereClause = "SELECT {$selectFields} FROM {$this->sumTT}"; } else { $whereClause = "SELECT {$selectFields} FROM {$this->sumTT} WHERE {$whereClause}"; } $t1 = nuRunQuery($whereClause); $r1 = mysql_fetch_row($t1); $formattedValue = $r1[0]; //tofile("Sum Value: ".$formattedValue); if (!$sumIt) { //---using the 'PERCENT' function if ($r1[1] == 0) { $formattedValue = 0; //--because nothing can be divided by zero } else { $formattedValue = $r1[0] / $r1[1] * 100; } } if ($Format == 'Fixed') { if ($r1[0] != '') { $formattedValue = number_format($r1[0], $Decimal); } } //format of the result of the sum if ($Format == 'Currency') { if ($r1[0] != '') { $formattedValue = "\$" . number_format($r1[0], 2); $formattedValue = str_replace('$-', '-$', $formattedValue); } } $formattedValue = formatTextValue($formattedValue, $Format); $Caption = $formattedValue; $this->SetFont($Fontname, $Fontweight, $Fontsize); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $this->SetStringByWidth($Caption, $Width - 0.1), $BorderWidth, $ln, $TextAlign, $BackStyle); $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>{$formattedValue}</div>\n"; } else { //page display if ($Source == '="Page " & [Page] & " of " & [Pages]' || $Source == 'Page #thePageNumber# of #totalNumberOfPages#') { $Caption = "Page " . $this->pageNumber . " of " . $GLOBALS['TotalPages']; $this->SetFont($Fontname, $Fontweight, $Fontsize); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $Caption, $BorderWidth, $ln, $TextAlign, $BackStyle); $s = $s . " <div class='{$Name}'>Page #thePageNumber# of #totalNumberOfPages#</div>\n"; } else { //date display if ($Source == '=Date()' or $Source == '=Now()') { if ($Format == '' || $Format == '20' || $Format == 'Long Date') { $formattedValue = date('d-M-Y H:i'); } else { $formattedValue = date($this->accessDateFormatToPHPDateFormat($Format)); } //$formattedValue = date($this->accessDateFormatToPHPDateFormat($Format)); $Caption = $formattedValue; $this->SetFont($Fontname, $Fontweight, $Fontsize); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $Caption, $BorderWidth, $ln, $TextAlign, $BackStyle); $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>{$formattedValue}</div>\n"; } else { //format number if ($Format == 'Fixed') { if ($record[$this->report->Controls[$i]->ControlSource] != '') { $formattedValue = number_format($record[$this->report->Controls[$i]->ControlSource], $Decimal); } } //currency number if ($Format == 'Currency') { $formattedValue = "\$" . number_format($record[$this->report->Controls[$i]->ControlSource], 2); $formattedValue = str_replace('$-', '-$', $formattedValue); } //date format (no todate() and now()) if (substr($Format, 0, 2) == 'dd' or substr($Format, 0, 2) == 'mm' or substr($Format, 0, 2) == 'yy' or substr($Format, 0, 2) == 'hh' or substr($Format, 0, 2) == 'nn' or substr($Format, 0, 2) == 'ss') { //for sql format case yyyy-mm-dd if (substr($formattedValue, 4, 1) == '-' and substr($formattedValue, 7, 1) == '-') { $timestamp = mktime(0, 0, 0, substr($formattedValue, 5, 2), substr($formattedValue, 8, 2), substr($formattedValue, 0, 4)); $formattedValue = date($this->accessDateFormatToPHPDateFormat($Format), $timestamp); } } $formattedValue = formatTextValue($formattedValue, $Format); //tofile($formattedValue); if ($this->report->Controls[$i]->CanGrow == 'True' and $canGrow) { //$oldValue = $formattedValue; $lines = $this->SplitAndWordWrapText($formattedValue, $Width); if (sizeof($lines) > 1) { $string = ""; for ($j = 0; $j < sizeof($lines); $j++) { $lines[$j] = trim($lines[$j]); $string = $string . $lines[$j] . "<br>"; } } $this->SetFont($Fontname, $Fontweight, $Fontsize); if (sizeof($lines) > 1) { //tofile("more than 1 line"); $Height = $this->CalculateLineHeight($Fontsize); $this->SplitLines($Width, $Height, $string, $BorderWidth, $ln, $TextAlign, $BackColor, $BackStyle, $Left, $Top, sizeof($lines), $i); } else { //tofile("1 line only"); $this->SetXY($Left, $Top); $this->Cell($Width, $Height, $lines[0], $BorderWidth, $ln, $TextAlign, $BackStyle); } /*$formattedValue = wordwrap($formattedValue, iif(is_numeric($ReportTag) == false,10,$ReportTag), "<br />"); $formattedValue = nl2br($formattedValue); $lines = substr_count($formattedValue, "<br />")+1; $defaultHeight = $Height; //$Height = $Height * iif($lines == 0, 1, $lines); if($this->growBy < $Height - $defaultHeight){ $this->growBy = $Height - $defaultHeight; } $this->SetFont($Fontname,$Fontweight,$Fontsize); $this->SetXY($Left, $Top); $this->Cell($Width,$Height,$this->SetStringByWidth($formattedValue,$Width-0.1),$BorderWidth,$ln,$TextAlign,$BackStyle);*/ } else { $Caption = $formattedValue; $output = $this->parse($Caption); //tofile("Test Caption: ".$Caption); $this->SetFont($Fontname, $Fontweight, $Fontsize); $this->SetXY($Left, $Top); if ($BackColor == '' || $BackColor == strtolower('#FFFFFF') || $BackColor == strtolower('FFFFFF')) { $BackStyle = 0; } else { $BackStyle = 1; } if ($output[0]['innerhtml'] == null) { //tofile($this->GetStringWidth($Caption)." ".$Width." ".$Caption); $this->Cell($Width, $Height, $this->SetStringByWidth($Caption, $Width - 0.1), $BorderWidth, $ln, $TextAlign, $BackStyle); } else { $this->SetHTMLAttributes($Width, $Height, $output, $BorderWidth, $ln, $TextAlign, $BackColor, $BackStyle, $Left, $Top); } //tofile($BorderColor[0]." ".$BorderColor[1]." ".$BorderColor[2]); //tofile("Border Width: ".$BorderWidth); $s = $s . " <div class='{$Name}' style='position:absolute;top:{$Top};height:{$Height}'>{$formattedValue}</div>\n"; } } } } } } } return $s; }
public function addIndexes($groupByList) { $t = nuRunQuery("SELECT * FRoM {$this->sumTT}"); nuRunQuery("ALTER TABLE `{$this->sumTT}` ADD PRIMARY KEY ( {$groupByList} ) "); $a = explode(',', $groupByList); for ($i = 0; $i < count($a); $i++) { nuRunQuery("ALTER TABLE {$this->sumTT} ADD INDEX (`" . $a[$i] . "`)"); } }
print " return '{$id}';\n"; print "}\n"; print "\n"; print "function goBack(){\n"; print " window.open(document.referrer,'_self');"; print "}\n"; print "\n"; print "</script>\n"; if ($stoplogin) { tofile('IN STOPLOGIN'); // 2009/07/15 - Nick changed failed login attempt to use document.referrer to go back to the login page print "<body onload='goBack();'>\n"; } else { $userID = iif($r->ID == '', 'globeadmin', $r->ID); // 2009/06/02 - Michael - added IP logging. nuRunQuery("INSERT INTO zzsys_user_log (zzsys_user_log_id, sul_zzsys_user_id, sul_ip, sul_start) VALUES ('{$id}', '{$userID}', '{$_SERVER['REMOTE_ADDR']}', '{$now}')"); // nuRunQuery("INSERT INTO zzsys_user_log (zzsys_user_log_id, sul_zzsys_user_id, sul_start) VALUES ('$id', '$userID', '$now')"); tofile("small : {$small}"); if ($small == '1') { tofile('IN SMALL = 1'); print "<body onload='document.index.submit();'>\n"; print "<form name='index' method='post' action='formsmall.php?x=1&r=-1&dir={$dir}&ses={$id}&f=index'></form>\n"; } else { tofile('IN SMALL <> 1'); print "<body onload='closeAndOpenForm();'>\n"; } } print "</body></html>\n"; tofile('cookie .. ' . $_COOKIE['security_check']); function security_check() {
$emailSetup = $GLOBALS['nuSetup']; if ($emailSetup->set_smtp_host == "" || $emailSetup->set_smtp_from_address == "" || $emailSetup->set_smtp_from_name == "" || $emailSetup->set_smtp_port == "" || $emailSetup->set_smtp_use_ssl == "") { header("Location: nuemailnoconfig.php"); } if ($_REQUEST['a'] == "") { $form_action = "nuemailsend.php"; } else { //must be a valid PHP Code $form_action = "nucall.php?p=" . $_REQUEST['a']; } $input_style = "style=\"width:250px;\""; $from = $emailSetup->set_smtp_from_address; $sus_login_name = $_REQUEST['uname']; if ($sus_login_name != "globeadmin") { $sqlUser = "******"; $rsUser = nuRunQuery($sqlUser); if (db_num_rows($rsUser) > 0) { $objUser = db_fetch_object($rsUser); $replyto = $objUser->sus_email; $replytoname = $objUser->sus_name; if ($replyto == "" || $replyto == null) { header("Location: nuemailnoconfig.php?m=1"); } } else { header("Location: nuemailnoconfig.php?m=1"); } } else { $replyto = $emailSetup->set_smtp_from_address; $replytoname = "globeadmin"; } ?>
private function buildHTMLForInarray($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue, $PREFIX) { if ($this->displayThisObject) { $inputType = 'text'; } else { $inputType = 'hidden'; $fieldTitle = ''; } if ($this->parentType == 'form') { //--not a subform $titleTableDetail = "{$TAB} <td class='selected' bgcolor='{$this->bgcolor}' style='text-align:right'>{$fieldTitle}</td>{$CRLF}"; $tr1 = "{$TAB}<tr class='selected'>{$CRLF}"; $tr2 = "{$TAB}</tr>{$CRLF}"; $td1 = "{$TAB} <td class='selected' style='text-align:left'>{$CRLF}{$TAB} "; $td2 = "{$TAB} </td>{$CRLF}"; } if ($PREFIX != '') { $untick = "untick('{$PREFIX}');"; } $style = $this->addStyle('width', $this->objectProperty['sob_inarray_length'] * 16); $style = $style . $this->addStyle('text-align', $this->objectProperty['sob_inarray_align']); $s = $titleTableDetail . $td1; $s = $s . "<input "; $s = $s . $this->addProperty('type', $inputType); $s = $s . $this->addProperty('name', $fieldName); $s = $s . $this->addProperty('id', $fieldName); $s = $s . $this->addProperty('value', $fieldValue); $s = $s . $this->addProperty('accesskey', $this->objectProperty['sob_all_access_key']); if ($inputType == 'text') { if ($this->objectProperty['sob_all_class'] == '') { $s = $s . $this->addProperty('class', 'objects'); } else { $s = $s . $this->addProperty('class', $this->objectProperty['sob_all_class']); } $s = $s . $this->addProperty('style', $style); $s = $s . $this->addProperty('onchange', $untick . "uDB(this);" . $fieldName . '_array(this);' . $this->objectProperty['sob_all_onchange']); $s = $s . $this->addProperty('onblur', $this->objectProperty['sob_all_on_blur']); $s = $s . $this->addProperty('onfocus', $this->objectProperty['sob_all_on_focus']); $s = $s . $this->addProperty('onkeypress', $this->objectProperty['sob_all_on_keypress']); $s = $s . $this->addProperty('ondblclick', $this->objectProperty['sob_all_on_doubleclick']); } if ($this->objectProperty['sob_text_read_only'] == '1') { $s = $s . " readonly='readonly' "; } $s = $s . "/>{$CRLF}"; $s = $s . $td2; //---replace any hashes with variables $sql = replaceVariablesInString($this->TT, $this->objectProperty['sob_inarray_sql'], $this->recordID); //---run sql and use the first row and colomn as the value for this field $t = nuRunQuery($sql); $fun = "function {$fieldName}" . "_array(pThis){ {$CRLF}"; $fun = $fun . " var ar = new Array();{$CRLF}"; $fun = $fun . " var found = new Boolean(false);{$CRLF}"; $counter = 0; while ($r = db_fetch_row($t)) { if ($counter == 0) { $first = $r[0]; } $last = $r[0]; $fun = $fun . " ar[{$counter}] = \"{$r['0']}\";{$CRLF}"; $counter = $counter + 1; } $dq = '"'; $fun = $fun . " {$CRLF}"; $fun = $fun . " for (i=0 ; i < ar.length ; i++){ {$CRLF}"; $fun = $fun . " if(ar[i] == pThis.value){ {$CRLF}"; $fun = $fun . " found=true;{$CRLF}"; $fun = $fun . " }{$CRLF}"; $fun = $fun . " }{$CRLF}"; $fun = $fun . " if(found==false){ {$CRLF}"; $fun = $fun . " alert('Must be between {$dq}{$first}{$dq} and {$dq}{$last}{$dq}'){$CRLF}"; $fun = $fun . " pThis.value = '';{$CRLF}"; $fun = $fun . " }{$CRLF}"; $fun = $fun . "}{$CRLF}"; $this->parentForm->appendJSfunction($fun); return $tr1 . $s . $tr2; }
print "<head>\n"; print "<meta http-equiv='Content-Type' content='text/html'/>\n"; print "<title></title>\n"; print "<!-- Form Functions -->\n"; print "<script type='text/javascript'>\n"; print "/* <![CDATA[ */\n"; print "function reload(pthis){// reload form.php\n"; if ($_POST['del_ok'] == '1') { print " parent.window.close();\n"; print " parent.opener.document.focus();\n"; print " parent.opener.document.forms[0].submit();\n"; $theform = formFields($sysformID); nuRunQuery("DELETE FROM {$theform->sfo_table} WHERE {$theform->sfo_primary_key} = '{$recordID}'"); $t = nuRunQuery("SELECT * FROM zzsys_object WHERE sob_zzsys_form_id = '{$sysformID}' and sob_all_type = 'subform'"); while ($r = db_fetch_object($t)) { nuRunQuery("DELETE FROM {$r->sob_subform_table} WHERE {$r->sob_subform_foreign_key} = '{$recordID}'"); } //----------create an array of hash variables that can be used in any "hashString" $arrayOfHashVariables1 = postVariablesToHashArray(); //--values of this record $arrayOfHashVariables1['#id#'] = $theRecordID; //--this record's id $arrayOfHashVariables = recordToHashArray('zzsys_session', 'zzsys_session_id', $ses); //--session values (access level and user etc. ) $arrayOfHashVariables = joinHashArrays($arrayOfHashVariables, $arrayOfHashVariables1); //--join the arrays together $nuHashVariables = $arrayOfHashVariables; //--added by sc 23-07-2009 //----------allow for custom code---------------------------------------------- eval(replaceHashVariablesWithValues($arrayOfHashVariables, $theform->sfo_custom_code_run_after_delete)); } else {
function getLedgerCode($ledgerID) { $RS = nuRunQuery("SELECT led_code FROM ledger WHERE ledger_id = '{$ledgerID}'"); $ledgerObj = mysql_fetch_object($RS); return $ledgerObj->led_code; }
$s = "SELECT * FROM zzsys_activity_graph WHERE sag_zzsys_activity_id = '{$activityID}' AND sag_graph_name = '{$graph_name}'"; $tA = nuRunQuery($s); $graphObject = db_fetch_object($tA); $s = "SELECT * FROM zzsys_graph WHERE zzsys_graph_id = '{$graphObject->sag_graph_zzsys_graph_id}'"; $tB = nuRunQuery($s); $graphType = db_fetch_object($tB); //----------create an array of hash variables that can be used in any "hashString" $arrayOfHashVariables = recordToHashArray('zzsys_session', 'zzsys_session_id', $ses); //--session values (access level and user etc. ) $arrayOfHashVariables['#id#'] = $theRecordID; //--this record's id $arrayOfHashVariables['#clone#'] = $clone; //--if it is a clone $arrayOfHashVariables['#graphTable#'] = $graphTable; //--temp table name foreach ($_GET as $key => $value) { $arrayOfHashVariables["#{$key}#"] = $value; } //-- create a temp table called $graphTable eval(replaceHashVariablesWithValues($arrayOfHashVariables, $graphObject->sag_graph_code)); //--replace hash variables then run code //-- turn $graphTable into this type of graph eval(replaceHashVariablesWithValues($arrayOfHashVariables, $graphType->sgr_graph_code)); //--replace hash variables then run code //-----------custom code end--------------------------------------------------- //-- create a temp table called $graphTable // eval($graphObject->sag_graph_code); //-- turn $graphTable into this type of graph // eval($graphType->sgr_graph_code); nuRunQuery("DROP TABLE {$graphTable}");
function isDuplicate($session, $form, $recordID, $field, $value) { $s = "SELECT count(*) FROM {$form->sfo_table} "; $s = $s . "WHERE {$field} = '{$value}' "; $s = $s . "AND {$form->sfo_primary_key} != '{$recordID}'"; $t = nuRunQuery($s); $r = db_fetch_row($t); if ($r[0] != 0) { return true; } $id = uniqid('1'); $theDate = date('Y-m-d H:i:s'); $s = "INSERT INTO zzsys_duplicate (zzsys_duplicate_id, sdu_session_id, sdu_table_name, sdu_field_name, sdu_value, sdu_date)"; $s = $s . "VALUES ('{$id}', '{$session}', '{$form->sfo_table}', '{$field}', '{$value}', '{$theDate}')"; nuRunQuery($s, false); $s = "SELECT count(*) FROM zzsys_duplicate "; $s = $s . "WHERE sdu_session_id = '{$session}' "; $s = $s . "AND sdu_table_name = '{$form->sfo_table}' "; $s = $s . "AND sdu_field_name = '{$field}' "; $s = $s . "AND sdu_value = '{$value}' "; $t = nuRunQuery($s); $r = db_fetch_row($t); if ($r[0] != 0) { return false; } }
} 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); } // $theFieldValue = str_replace(chr(13).chr(10), "<br/>", $r[$Field[$f]]); // $theFieldValue = str_replace(chr(13), "<br/>", $theFieldValue); // $theFieldValue = str_replace(chr(10), "<br/>", $theFieldValue); $theFieldValue = str_replace('"', '', $r[$Field[$f]]); print $dq . $theFieldValue . $dq; } print "\r\n"; } nuRunQuery("DROP TABLE {$dataTable}");
<?php /* ** File: formhelp.php ** Author: nuSoftware ** Created: 2007/04/26 ** Last modified: 2009/07/15 ** ** Copyright 2004, 2005, 2006, 2007, 2008, 2009 nuSoftware ** ** This file is part of the nuBuilder source package and is licensed under the ** GPLv3. For support on developing in nuBuilder, please visit the nuBuilder ** wiki and forums. For details on contributing a patch for nuBuilder, please ** visit the `Project Contributions' forum. ** ** Website: http://www.nubuilder.com ** Wiki: http://wiki.nubuilder.com ** Forums: http://forums.nubuilder.com */ include '../' . $_GET['dir'] . '/database.php'; include 'common.php'; $f = $_GET['f']; tofile("SELECT * FROM zzsys_form WHERE zzsys_form_id = '{$f}'"); $t = nuRunQuery("SELECT * FROM zzsys_form WHERE zzsys_form_id = '{$f}'"); $r = db_fetch_object($t); print "<html><head><title>Help for {$r->sfo_title} Screen</title></head>"; print "<body bgcolor=#ffffff text=#000000 link=#0000cc vlink=#551a8b alink=#ff0000>"; print $r->sfo_help; print "</body></html>";
<?php require_once 'nucommon.php'; $response = array(); $response['DATA'] = ''; $response['SUCCESS'] = false; $response['ERRORS'] = array(); $GLOBALS['ERRORS'] = array(); $hashData = nuHashData(); $code = $_GET['c']; $sql = "SELECT * FROM zzzsys_php WHERE slp_code = ?"; $t = nuRunQuery($sql, array($code)); $r = db_fetch_object($t); if (nuPHPAccess($r->zzzsys_php_id)) { $r->slp_php = nuGetSafePHP('slp_php', $r->zzzsys_php_id, $r->slp_php); $e = nuReplaceHashes($r->slp_php, $hashData); eval($e); $response['DATA'] = $nuParameters; if ($nuError != '') { $response['ERRORS'][] = $nuError; } } else { $response['ERRORS'][] = "Access denied to PHP - ({$r->slp_code})"; } print json_encode($response);
** ** Copyright 2004, 2005, 2006, 2007, 2008, 2009 nuSoftware ** ** This file is part of the nuBuilder source package and is licensed under the ** GPLv3. For support on developing in nuBuilder, please visit the nuBuilder ** wiki and forums. For details on contributing a patch for nuBuilder, please ** visit the `Project Contributions' forum. ** ** Website: http://www.nubuilder.com ** Wiki: http://wiki.nubuilder.com ** Forums: http://forums.nubuilder.com */ session_start(); $dir = $_GET['dir']; include "../{$dir}/database.php"; include 'common.php'; $T = nuRunQuery("SELECT sat_report_display_code FROM zzsys_activity WHERE sat_all_code = '" . $_GET['r'] . "'"); $A = db_fetch_object($T); eval($A->sat_report_display_code); $report = new Reporting(); $ver = $report->Version; if ($ver == '3') { include 'run_report_html_v3.php'; } else { if ($ver == '2') { include 'run_report_html_v2.php'; } else { include 'run_report_html_v1.php'; } } run_html_report();
public function buildObject($C) { $lineFormat = formatForPDFandHTML($C->text_string[0]); //-- get any formatting stuff from the beginning of the string eg. #BOLD# $can_grow = $C->can_grow == '1'; $temp_name = $this->temp_filename . $this->imagecount; $this->imagecount = $this->imagecount + 1; $draw = 'DF'; $BC = $C->border_color; if (lresize($C->border_width) == 0 or $BC == 'transparent' or strtolower($BC) == 'white' or strtolower($BC) == '#ffffff' or strtolower($BC) == 'ffffff') { $draw = str_replace('D', '', $draw); } $BC = $C->background_color; if ($BC == 'transparent' or strtolower($BC) == 'white' or strtolower($BC) == '#ffffff' or strtolower($BC) == 'ffffff') { $draw = str_replace('F', '', $draw); } if (count($lineFormat['bgcolor']) == 0) { //-- no specific bg color for this object $color = rgbcolor($C->background_color, $this->html); } else { $color = $lineFormat['bgcolor']; if (strpos($draw, 'F') === false) { $draw = $draw . 'F'; } } $this->SetFillColor($color['r'], $color['g'], $color['b']); $color = rgbcolor($C->border_color, $this->html); $this->SetDrawColor($color['r'], $color['g'], $color['b']); if (count($lineFormat['color']) == 0) { //-- no specific color for this object $color = rgbcolor($C->color, $this->html); } else { $color = $lineFormat['color']; } $this->SetTextColor($color['r'], $color['g'], $color['b']); $field_width = hresize($C->width); $this->SetLineWidth(lresize($C->border_width)); if ($C->type != 'Graph') { if ($draw != '') { $this->Rect(hresize($C->left), vresize($C->top) + $this->section_top + 2, $field_width, hresize($C->height) + hresize($C->extra_growth), $draw); } } if (strpos($lineFormat['style'], 'B') === false) { //-- no specific boldness for this object if ($C->font_weight == 'bold') { $weight = 'B'; } else { $weight = ''; } } else { $weight = 'B'; } $this->SetFont($C->font_name, $weight, fresize($C->font_size)); $offset_top = hresize($C->original_height) * 0.2; if ($C->type == 'Graph') { if ($C->format == 'image') { $PT = nuRunQuery("SELECT zzsys_image_id FROM zzsys_image WHERE sim_code = '{$C->graph}'"); $PR = db_fetch_object($PT); $logo = fopen(getPHPurl() . "formimage.php?dir=" . $_GET['dir'] . "&iid={$PR->zzsys_image_id}", "r"); } else { $chop_at = strrpos($C->text_string[0], " width='"); //-- chops off the "width='523' height='246' />" bit of the image $url = substr($C->text_string[0], 10, $chop_at - 11); $url = str_replace(" ", "%20", $url); $logo = fopen(getPHPurl() . $url, "r"); } file_put_contents($temp_name . '.png', $logo); if (filesize($temp_name . '.png') > 0) { $im = imagecreatefrompng($temp_name . '.png'); imageinterlace($im, 0); imagepng($im, $temp_name . '.png'); $this->Image($temp_name . '.png', hresize($C->left), vresize($C->top) + $this->section_top + 2, $field_width, hresize($C->height) + hresize($C->extra_growth)); unlink($temp_name . '.png'); } } else { $string_array = array(); if ($can_grow) { //-- already an array $string_array = $C->text_string; } else { //-- create an array $swap_br = array(chr(13), '<br/>', '<Br />', '<Br/>', '<BR />', '<BR/>'); $the_string = str_replace($swap_br, '<br />', $C->text_string[0]); $string_array = explode("<br />", $the_string); } for ($ts = 0; $ts < count($string_array); $ts++) { $data = ''; if ($ts == 0) { $data = $lineFormat['string']; //-- string with formatting removed } else { $data = $string_array[$ts]; } $data = str_replace('#totalNumberOfPages#', $this->total_pages, $data); $data = str_replace('#thePageNumber#', $this->page_no, $data); $data = str_replace(' ', ' ', $data); $data = str_replace(' ', ' ', $data); if (strtoupper($data) == '=NOW()' or strtoupper($data) == 'NOW()') { $data = $this->timestamp; } $text_width = $this->GetStringWidth($data); $resized_length = fwresize($text_width); $offset_left = 0; if ($C->text_align == 'right') { $offset_left = vresize($C->width - $resized_length); } if ($C->text_align == 'center') { $offset_left = vresize(($C->width - $resized_length) / 2); } if (!$can_grow and count($string_array) > 1) { //-- dont realign top $text_top = vresize($C->top) + fresize($C->font_size) / 2 * (1 * (1 + $ts)) + $this->section_top + 2; } else { $text_top = vresize($C->top) + hresize($C->original_height) * (1 * (1 + $ts)) + $this->section_top + 2; } $left = vresize($C->left); $this->Text(hresize($C->left) + $offset_left, $text_top - $offset_top, $data); } } if ($cHeight != 0) { } }