header('Content-Type: text/html; charset=tis-620');
echo "";
include('db_config.php');
mysql_query("TRUNCATE TABLE tmpkap1");
mysql_query("insert into tmpkap1 (SELECT * FROM $_data
group by kd_sch,kd_code,g,s,b)");
$sql="select *,sum(g) as g,sum(s) as s,sum(b) as b
from tmpkap1,$_act where kp_id=kd_code group by kp_cd order by kp_cd,kp_grp";
$result=mysql_query($sql);
echo "
";
$rw=1;
while ($db=mysql_fetch_array($result)) {
$sql1="select * from $_data,$_act where kp_id=kd_code and kp_cd='$db[kp_cd]' group by kp_cd,kd_code";
$result1=mysql_query($sql1);
$all=mysql_num_rows($result1);
$sql2="select * from $_data,$_act where kp_id=kd_code and kp_cd='$db[kp_cd]' and (g>0 or s>0 or b>0)
group by kp_cd,kd_code";
$result2=mysql_query($sql2);
$rep=mysql_num_rows($result2);
$pc=number_format($rep*100/$all,2,".",",");
if ($rep>0) { $rp=$rep; $ppc=$pc; } else { $rp='-'; $ppc='-'; }
echo "