";
require_once('db_config.php');
$sql0="select * from ad_reg where reg_id='$reg' ";
$result0=mysql_query($sql0);
$db0=mysql_fetch_array($result0);
$sql="select * from ad_spcode order by sp_id";
$result=mysql_query($sql);
echo "
จำนวนบัตร AD-card ภาค $reg $db0[reg_desc]
[ กลับหน้าหลัก ]
| ที่ |
ชนิดกีฬา |
บัตรนักกีฬา F |
บัตรเจ้าหน้าที่ทีม Fo |
รวม |
| มีรูปภาพ |
ไม่มีรูปภาพ |
รวม |
มีรูปภาพ |
ไม่มีรูปภาพ |
รวม |
มีรูปภาพ |
ไม่มีรูปภาพ |
รวม |
";
$rw=1;
while ($db=mysql_fetch_array($result)) {
$sql1="select * from adc57 where ad_code='F' and ad_reg='$reg' and spcode='$db[sp_id]'
and nopic='' ";
$result1=mysql_query($sql1);
$picf=mysql_num_rows($result1);
$sql2="select * from adc57 where ad_code='F' and ad_reg='$reg' and spcode='$db[sp_id]'
and nopic='1' ";
$result2=mysql_query($sql2);
$nopicf=mysql_num_rows($result2);
$sql3="select * from adc57 where ad_code='Fo' and ad_reg='$reg' and spcode='$db[sp_id]'
and nopic='' ";
$result3=mysql_query($sql3);
$picfo=mysql_num_rows($result3);
$sql4="select * from adc57 where ad_code='Fo' and ad_reg='$reg' and spcode='$db[sp_id]'
and nopic='1' ";
$result4=mysql_query($sql4);
$nopicfo=mysql_num_rows($result4);
$allf=$picf+$nopicf;
$cpicf=number_format($picf,0,'.',',');
$cnopicf=number_format($nopicf,0,'.',',');
$allf=number_format($allf,0,'.',',');
$allfo=$picfo+$nopicfo;
$cpicfo=number_format($picfo,0,'.',',');
$cnopicfo=number_format($nopicfo,0,'.',',');
$allfo=number_format($allfo,0,'.',',');
$regpic=$picf+$picfo;
$regnopic=$nopicf+$nopicfo;
$allreg=$regpic+$regnopic;
if ($nopicf==0) { $cnopicf='-'; }
if ($nopicfo==0) { $cnopicfo='-'; }
if ($regnopic==0) { $regnopic='-'; }
echo "
| $rw |
$db[sp_type] |
$cpicf |
$cnopicf |
$allf |
$cpicfo |
$cnopicfo |
$allfo |
$regpic |
$regnopic |
$allreg |
";
$rw++;
$tpicf+=$picf; $tnopicf+=$nopicf; $tallf+=$allf;
$tpicfo+=$picfo; $tnopicfo+=$nopicfo; $tallfo+=$allfo;
$tregpic+=$regpic; $tregnopic+=$regnopic; $tallreg+=$allreg;
}
$tpicf=number_format($tpicf,0,'.',',');
$tnopicf =number_format($tnopicf,0,'.',',');
$tallf=number_format($tallf,0,'.',',');
$tpicfo=number_format($tpicfo,0,'.',',');
$tnopicfo=number_format($tnopicfo,0,'.',',');
$tallfo=number_format($tallfo,0,'.',',');
$tregpic=number_format($regpic,0,'.',',');
$tregnopic=number_format($regnopic,0,'.',',');
$tallreg=number_format($tallreg,0,'.',',');
echo "
| รวม |
$tpicf |
$tnopicf |
$tallf |
$tpicfo |
$tnopicfo |
$tallfo |
$tregpic |
$tregnopic |
$tallreg |
";
?>