header('Content-Type: text/html; charset=tis-620');
include('../db_config.php');
$sql="select *,count(*) as nsc from sk1_std59 a,sk1_sch b 
	where a.scode=b.scode and b.scgrp != 'prv' and 
	(a.a1m+a.a2m+a.p1m+a.p2m+a.p3m+a.p4m+a.p5m+a.p6m+	a.m1m+a.m2m+a.m3m+a.m4m+a.m5m+a.m6m+a.a1f+a.a2f+a.p1f+a.p2f+
	a.p3f+a.p4f+a.p5f+p6f+a.m1f+a.m2f+a.m3f+a.m4f+a.m5f+a.m6f) <= 300 
	group by b.scgrp order by b.sampur";
$result=mysql_query($sql);
echo "
	
	| ที่ | 
	กลุ่มโรงเรียน | 
	รร. ทั้งหมด | 
	รายงาน แล้ว | 
	ร้อยละ | 
	
";
$rw=1; $gsc=0;
while ($db=mysql_fetch_array($result)) {
	$sql2="select * from sk1_sch where scgrp='$db[scgrp]' ";
	$result2=mysql_query($sql2);
	while ($db2=mysql_fetch_array($result2)) {
		if ($db2[ipst_name] !='' ) { $gsc++; } 
	}
	if ($gsc > 0 ) { $gg=$gsc; } else { $gg='-';}
	$perc=number_format($gsc*100/$db[nsc],2,'.','');
	echo "
		| $rw | 
		$db[sgrp] | 
		$db[nsc] | 
		$gg | 
		$perc | 
		
";
	$rw++; $tgsc+=$gsc; $gsc=0; $tnsc+=$db[nsc];
}
$tperc=number_format($tgsc*100/$tnsc,2,'.','');
echo "
	| รวม | 
	$tnsc | 
	$tgsc | 
	$tperc | 
	
	
	
	";
?>