Subversion Repositories ALCASAR

Rev

Rev 486 | Rev 1831 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 486 Rev 1805
Line 23... Line 23...
23 
EOM;
 23 
EOM;
24 
	exit();
 24 
	exit();
25 
}
 25 
}
26 
 
 26 
 
27 
$operators=array( '=','<', '>', '<=', '>=', 'regexp', 'like' );
 27 
$operators=array( '=','<', '>', '<=', '>=', 'regexp', 'like' );
28 
if ($config[sql_type] == 'pg'){
 28 
if ($config['sql_type'] == 'pg'){
29 
	$operators=array( '=','<', '>', '<=', '>=', '~', 'like', '~*', '~~*', '<<=' );
 29 
	$operators=array( '=','<', '>', '<=', '>=', '~', 'like', '~*', '~~*', '<<=' );
30 
}
 30 
}
31 
 
 31 
 
32 
$link = @da_sql_pconnect ($config) or die('cannot connect to sql databse');
 32 
$link = da_sql_pconnect ($config) or die('cannot connect to sql databse');
33 
$fields = @da_sql_list_fields($config[sql_accounting_table],$link,$config);
 33 
$fields = da_sql_list_fields($config[sql_accounting_table],$link,$config);
34 
$no_fields = @da_sql_num_fields($fields,$config);
 34 
$no_fields = da_sql_num_fields($fields,$config);
35 
 
 35 
 
36 
unset($items);
 36 
unset($items);
37 
 
 37 
 
38 
for($i=0;$i<$no_fields;$i++){
 38 
for($i=0;$i<$no_fields;$i++){
39 
	$key = strtolower(@da_sql_field_name($fields,$i,$config));
 39 
	$key = strtolower(da_sql_field_name($fields,$i,$config));
40 
	$val = $sql_attrs[$key][desc];
 40 
	$val = $sql_attrs[$key]['desc'];
41 
	if ($val == '')
 41 
	if ($val == '')
42 
		continue;
 42 
		continue;
43 
	$show = $sql_attrs[$key][show];
 43 
	$show = $sql_attrs[$key]['show'];
44 
	$selected[$key] = ($show == 'yes') ? 'selected' : '';
 44 
	$selected[$key] = ($show == 'yes') ? 'selected' : '';
45 
	$items[$key] = "$val";
 45 
	$items[$key] = "$val";
46 
}
 46 
}
47 
asort($items);
 47 
asort($items);
48 
 
 48 
 
Line 261... Line 261...
261 
	$desc = $sql_attrs[$val][desc];
 261 
	$desc = $sql_attrs[$val][desc];
262 
	echo "<th>$desc</th>\n";
 262 
	echo "<th>$desc</th>\n";
263 
}
 263 
}
264 
echo "</tr>\n";
 264 
echo "</tr>\n";
265 
 
 265 
 
266 
	$search = @da_sql_query($link,$config,$query);
 266 
	$search = da_sql_query($link,$config,$query);
267 
	if ($search){
 267 
	if ($search){
268 
		while( $row = @da_sql_fetch_array($search,$config) ){
 268 
		while( $row = da_sql_fetch_array($search,$config) ){
269 
			$num++;
 269 
			$num++;
270 
			echo "<tr align=center>\n";
 270 
			echo "<tr align=center>\n";
271 
			foreach($accounting_show_attrs as $val){
 271 
			foreach($accounting_show_attrs as $val){
272 
				$info = $row[$val];
 272 
				$info = $row[$val];
273 
				if ($info == '')
 273 
				if ($info == '')