$str = "select distinct a.merk, b.merk, a.tipekendaraan, c.tipekendaraan, a.jeniskendaraan, d.jeniskendaraan from gl_masterkendaraan as a left join gl_merkkendaraan as b on (a.merk=b.id) left join gl_tipekendaraan as c on (a.tipekendaraan=c.id) inner join gl_jeniskendaraan as d on (a.jeniskendaraan=d.id) ";
//echo $str;
if ($area != '') {
$str .= " where a.area='{$area}'";
}
$str .= " order by a.merk asc ";
//echo $str;
$query = mysql_query($str) or die(mysql_error());
//print_r($str);
$no = 1;
while (list($idmerk, $merk, $idtipe, $tipe, $idjenis, $jenis) = mysql_fetch_array($query)) {
$pdf->SetX(0.25);
/*$pdf->SetWidths(array(1,2,2,2));
$pdf->SetAligns(Array('C','C','C','C'));
$pdf->Row(array("$no", "$merk", "$jenis", "$tipe"));*/
$h = $pdf->GetHeight();
$strsub = "select id, area from gl_area ";
if ($area != '') {
$strsub .= " where id='{$area}' ";
}
$strsub .= "order by area asc ";
$querysub = mysql_query($strsub) or die(mysql_error());
while (list($idarea, $namaarea) = mysql_fetch_array($querysub)) {
//$pdf->SetY($h);
$pdf->SetX(7.25);
$qcb = mysql_query("select id, gudang from gl_gudang where area = '{$idarea}' order by gudang asc") or die(mysql_error());
$jqcb = mysql_num_rows($qcb);
if ($jqcb == '0') {
$pdf->Cell(1, $h, "", 1, 0, 'C');
} else {
while (list($idgudang, $namagudang) = mysql_fetch_array($qcb)) {
