reporting_functions.php

php网页设计

<?
# Reporting functions

function get_reports()
	{
	# Returns all reports in a result array.
	return sql_query("select * from report order by name");
	}

function do_report($ref,$from_y,$from_m,$from_d,$to_y,$to_m,$to_d)
	{
	# Run report with id $ref for the date range specified. Returns a result array.
	$report=sql_query("select * from report where ref='$ref'");$report=$report[0];

	$filename=str_replace(array(" ","(",")","-","/"),"_",$report["name"]) . "_" . $from_y . "_" . $from_m . "_" . $from_d . "_to_" . $to_y . "_" . $to_m . "_" . $to_d . ".csv";
	header("Content-type: text/csv");
	header("Content-disposition: attachment; filename=" . $filename . "");

	
	$sql=$report["query"];
	$sql=str_replace("[from-y]",$from_y,$sql);
	$sql=str_replace("[from-m]",$from_m,$sql);
	$sql=str_replace("[from-d]",$from_d,$sql);
	$sql=str_replace("[to-y]",$to_y,$sql);
	$sql=str_replace("[to-m]",$to_m,$sql);
	$sql=str_replace("[to-d]",$to_d,$sql);
	
	$results=sql_query($sql);
	#echo "\"Number of results: " . count($results) . "\"\n";
	for ($n=0;$n<count($results);$n++)
		{
		$result=$results[$n];
		if ($n==0)
			{
			$f=0;
			foreach ($result as $key => $value)
				{
				$f++;
				if ($f>1) {echo ",";}
				echo "\"" . $key . "\"";
				}
			echo "\n";
			}
		$f=0;
		foreach ($result as $key => $value)
			{
			$f++;
			if ($f>1) {echo ",";}
			echo "\"" . $value . "\"";
			}
		echo "\n";
		}
	exit();
	}
	
	
	
?>