query("SELECT * FROM mobil JOIN jenis USING(id_jenis) where (mobil.jobsite like '%%' || jenis.jobsite like '%%') AND mobil.status='1'"); while ($row = $query->fetch_assoc()):
$rrv = mysql_fetch_array(mysql_query("SELECT * FROM trip where id_mobil='$row[id_mobil]' order by tgl desc"));
if($rrv['id_supir'] == ""){}else{ $connection->query("UPDATE mobil SET id_sopir='$rrv[id_supir]' WHERE id_mobil=$row[id_mobil]"); }
$cek = mysql_query("select * from transaksi where id_mobil='$row[id_mobil]' AND konfirmasi ='0' AND status='0' AND pembatalan='0'");
$jmlbooking= mysql_num_rows($cek);
$cek = mysql_query("select * from transaksi INNER JOIN pelanggan where transaksi.id_pelanggan=pelanggan.id_pelanggan AND transaksi.id_mobil='$row[id_mobil]' AND transaksi.konfirmasi ='1' AND transaksi.status='0' AND transaksi.pembatalan='0' AND transaksi.tgl_kembali='$tgl'");
$jmlkonfir= mysql_num_rows($cek);
$cek = mysql_query("select * from transaksi INNER JOIN pelanggan where transaksi.id_pelanggan=pelanggan.id_pelanggan AND id_mobil='$row[id_mobil]' AND konfirmasi ='1' AND status='0' AND pembatalan='0'");
$jmlkonfir2= mysql_num_rows($cek);
$rr = mysql_fetch_array(mysql_query("SELECT * FROM supir where id_supir='$row[id_sopir]'"));
$tampil=mysql_query("SELECT * from transaksi where id_mobil='$row[id_mobil]' AND konfirmasi ='0' AND status='0' AND pembatalan='0'");
$no = 1;
while ($j=mysql_fetch_array($tampil)){
$jam_masuk = strtotime("$j[tgl_sewa] $j[tgl_ambil]");
$jam_datang = strtotime("$tglll $jamm");
$selisih = $jam_datang - $jam_masuk;
$rrr=floor($selisih / (60*60));
if($rrr >= =){
$connection->query("UPDATE transaksi SET pembatalan='1' WHERE id_transaksi='$j[id_transaksi]'");
}else{
}
}
$jmlsedia=$row[kapasitas]-$jmlkonfir2;
if($jmlbooking >= 1){$blank="blink";}else{$blank="";}
if($jmlkonfir2 >= 1){$blankk="blink";}else{$blankk="";}
if($jmlkonfir2 == 0){$connection->query("UPDATE mobil SET jalan='0' WHERE id_mobil=$row[id_mobil]");}else{ }
?>
![<?php echo $row['judul']?>](assets/img/mobil/<?php echo $row['gambar']?>)
"> ()
">
Kapasitas Org
"> " id_jenis="">
"> " nama="" id_jenis="">
= 1){
?>
|
|
Seat $iz";}
else{$color=""; $tombol="Seat $iz";}
?>
| " bgcolor=""> |
" bgcolor="green"> |
|
Seat $izz";}
else{$color=""; $tombol1="Seat $izz";}
?>
| " bgcolor=""> |
|
Seat $izz";}
else{$color=""; $tombol1="Seat $izz";}
?>
| " bgcolor=""> |
|
Seat $izz";}
else{$color=""; $tombol1="Seat $izz";}
?>
| " bgcolor=""> |
|