Could not include SQL library functions. Aborting EOM; exit(); } $operators=array( '=','<', '>', '<=', '>=', 'regexp', 'like' ); if ($config[sql_type] == 'pg'){ $operators=array( '=','<', '>', '<=', '>=', '~', 'like', '~*', '~~*', '<<=' ); } $link = @da_sql_pconnect ($config) or die('cannot connect to sql databse'); $fields = @da_sql_list_fields($config[sql_accounting_table],$link,$config); $no_fields = @da_sql_num_fields($fields,$config); unset($items); for($i=0;$i<$no_fields;$i++){ $key = strtolower(@da_sql_field_name($fields,$i,$config)); $val = $sql_attrs[$key][desc]; if ($val == '') continue; $show = $sql_attrs[$key][show]; $selected[$key] = ($show == 'yes') ? 'selected' : ''; $items[$key] = "$val"; } asort($items); class Qi { var $name; var $item; var $_item; var $operator; var $type; var $typestr; var $value; function Qi($name,$item,$operator) { $this->name=$name; $this->item=$item; $this->operator=$operator; } function show() { global $operators; global $items; $nam = $this->item; echo << $items[$nam] EOM; } function get($designator) { global ${"item_of_$designator"}; global ${"value_of_$designator"}; global ${"operator_of_$designator"}; if(${"item_of_$designator"}){ $this->value= ${"value_of_$designator"}; $this->operator=${"operator_of_$designator"}; $this->item=${"item_of_$designator"}; } } function query(){ global $operators; global $items; return $items[$this->item]." $this->operator '$this->value'"; } } ?> Accounting Report Generator
Show the following attributes:
EOM; foreach($items as $key => $val) if ($val == 'username') echo <<$val EOM; else echo <<$val EOM; echo <<

Max results returned:
 EOM; $number=1; $offset=0; while (${"item_of_w$number"}) { if(${"delete_w$number"}==1) {$offset=1;$number++;} else { $designator=$number-$offset; ${"w$designator"} = new Qi("w$designator","",""); ${"w$designator"}->get("w$number"); ${"w$designator"}->show(); $number++; } } if($add==1) { ${"w$number"} = new Qi("w$number","$item_name","$operators[0]"); ${"w$number"}->show(); } echo <<
Selection criteria:

EOM; } if ($queryflag == 1){ $i = 1; while (${"item_of_w$i"}){ $op_found = 0; foreach ($operators as $operator){ if (${"operator_of_w$i"} == $operator){ $op_found = 1; break; } } if (!$op_found) die("Operator passed is not valid. Exiting abnormaly."); ${"item_of_w$i"} = preg_replace('/\s/','',${"item_of_w$i"}); ${"value_of_w$i"} = da_sql_escape_string(${"value_of_w$i"}); $where .= ($i == 1) ? ' WHERE ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" : ' AND ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" ; $i++; } $order = ($order_by != '') ? "$order_by" : 'username'; if (preg_match("/[\s;]/",$order)) die("ORDER BY pattern is illegal. Exiting abnornally."); if (!is_numeric($maxresults)) die("Max Results is not in numeric form. Exiting abnormally."); unset($query_view); foreach ($accounting_show_attrs as $val) $query_view .= $val . ','; $query_view = ereg_replace(',$','',$query_view); unset($sql_extra_query); if ($config[sql_accounting_extra_query] != '') $sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); $sql_extra_query = da_sql_escape_string($sql_extra_query); $query="SELECT " . da_sql_limit($maxresults,0,$config) . " $query_view FROM $config[sql_accounting_table] $where $sql_extra_query " . da_sql_limit($maxresults,1,$config) . " ORDER BY $order " . da_sql_limit($maxresults,2,$config) . ";"; echo <<
Accounting Report Generator 

EOM; foreach($accounting_show_attrs as $val){ $desc = $sql_attrs[$val][desc]; echo "\n"; } echo "\n"; $search = @da_sql_query($link,$config,$query); if ($search){ while( $row = @da_sql_fetch_array($search,$config) ){ $num++; echo "\n"; foreach($accounting_show_attrs as $val){ $info = $row[$val]; if ($info == '') $info = '-'; $info = $sql_attrs[$val][func]($info); if ($val == 'username'){ $Info = urlencode($info); $info = "$info"; } echo <<$info EOM; } echo "\n"; } } else echo "Database query failed: " . da_sql_error($link,$config) . "
\n"; echo <<
$desc

EOM; } ?>