|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_vc/report/sar/ |
Upload File : |
<?
require("../../inc/conndb_nonsession.inc.php");
header("Content-Type: Text/xml");
echo '<?xml version=\'1.0\' encoding=\'windows-874\' ?>';
echo '<xml>';
$mm_1 = $_GET[mm]-3;
$mm_2 = $_GET[mm]-6;
$sql = "select * from kpi_total_score where siteid='$_GET[siteid]' and (mm='$mm_1') and yy='$_GET[yy]' ";
$rs = mysql_query($sql);
$ar = mysql_fetch_assoc($rs);
echo "<node mm='$mm_1' total='".number_format($ar[total],4)."' d1='".number_format($ar[d1],4)."' d2='".number_format($ar[d2],4)."' d3='".number_format($ar[d3],4)."' d4='".number_format($ar[d4],4)."' />";
$sql = "select * from kpi_total_score where siteid='$_GET[siteid]' and (mm='$mm_2') and yy='$_GET[yy]' ";
$rs = mysql_query($sql);
$ar = mysql_fetch_assoc($rs);
echo "<node mm='$mm_2' total='".number_format($ar[total],4)."' d1='".number_format($ar[d1],4)."' d2='".number_format($ar[d2],4)."' d3='".number_format($ar[d3],4)."' d4='".number_format($ar[d4],4)."' />";
echo '</xml>';
?>