| เกรดรถบรรทุก ประจำเดือน
ประเภทรถ
|
| ทะเบียนรถ
|
ประเภทรถ
|
เกรด เอ
|
เกรด บี
|
รวม
|
สังกัด
|
";
while ($row=odbc_fetch_array($query)) {
/* if ($row->DLDATE== date("Ymd")) { */
//echo $row->DQTRK2;
//echo $row->CFVHC;
//echo $row->DQGRAD;
//echo $xtrk;
//echo "$xvhc
";
//$trk=$row->DQTRK2;
//echo "$row->DLTRK2.
";
//echo "$truck.$xtruck.
";
if ($typecar==$row['CFVHC']){
if ($row['DQTRK2']<>$xtrk and $xtrk<>"") {
echo ""; echo "
".$xtrk;
echo "
| ";
echo "";
echo $xvhc;
echo "
| ";
echo "";
echo $SumA;
echo "
| ";
echo "";
echo $SumB;
echo "
| ";
echo "";
echo $SumC;
echo "
| ";
echo "";
echo "
".$xcde."
"
.$xnam;
echo "
| ";
echo "
";
$SumA=0;
$SumB=0;
$SumC=0;
$count+=1;
}
//$xtrk=$trk;
if ($row['DQGRAD']=='A')
{$SumA+=1;}
if ($row['DQGRAD']=='B')
{$SumB+=1;}
$SumC=$SumA+$SumB;
$xtrk=$row['DQTRK2'];
$xvhc=$row['CFVHC'];
// $xcde=(string)$row->CFCDE;
$xcde=strval($row['CFCDE']);
$xnam=$row['CDNAME'];
if ($xcde=="1"){$xcde="01";}
elseif ($xcde=="2"){$xcde="02";}
}
if ($typecar==""){
if ($row['DQTRK2']<>$xtrk and $xtrk<>"") {
echo ""; echo "
".$xtrk;
echo "
| ";
echo "";
echo $xvhc;
echo "
| ";
echo "";
echo $SumA;
echo "
| ";
echo "";
echo $SumB;
echo "
| ";
echo "";
echo $SumC;
echo "
| ";
echo "";
echo "
".$xcde."
"
.$xnam;
echo "
| ";
echo "
";
$SumA=0;
$SumB=0;
$SumC=0;
$count+=1;
}
//$xtrk=$trk;
if ($row['DQGRAD']=='A')
{$SumA+=1;}
if ($row['DQGRAD']=='B')
{$SumB+=1;}
$SumC=$SumA+$SumB;
$xtrk=$row['DQTRK2'];
$xvhc=$row['CFVHC'];
// $xcde=(string)$row->CFCDE;
$xcde=strval($row['CFCDE']);
$xnam=$row['CDNAME'];
if ($xcde=="1"){$xcde="01";}
elseif ($xcde=="2"){$xcde="02";}
}
}
echo ""; echo "
".$xtrk;
echo "
| ";
echo "";
echo $xvhc;
echo "
| ";
echo "";
echo $SumA;
echo "
| ";
echo "";
echo $SumB;
echo "
| ";
echo "";
echo $SumC;
echo "
| ";
echo "";
echo "
".$xcde."
"
.$xnam;
echo "
| ";
echo "
";
$count+=1;
odbc_close($odbc_conn);
}
//echo $count;
?>