<?php
if(isset($_GET['date']) and !empty($_GET['date'])){
$expl=explode("-", $_GET['date']);
$month=intval($expl[0],10);
$year=intval($expl[1],10);
if($month>0 and $year>2011){
$numdays = cal_days_in_month(CAL_GREGORIAN, $month, $year);
?>
<div>
<table border="2" style="width: 100%">
<tr align="center"><td colspan="32"><?=$month.' '.$year?></td></tr>
<tr align="center">
<td>Status</td>
<?php
for($i=1; $i<=$numdays; $i++){
?>
<td>
<?=$i?><br>
</td>

<?php
}
?>
</tr>
<?php
include 'koneksi.php';
$s_stat="select * from inquirystatus";
$q_stat=mysql_query($s_stat);
while($d_stat=mysql_fetch_array($q_stat)){
?>
<tr>
<td><?=$d_stat['inquirystatusname']?></td>
<?php
for($i=1; $i<=$numdays; $i++){ $fill="-";
if($i<10){ $j='0'.$i; }else{ $j=$i; }
$datestat=date("Y-m-d",strtotime($year."-".$month."-".$j));

if($datestat <= date("Y-m-d")){
switch ($d_stat['inquirystatusoid']) {
case '0':
$s_inquiry="select count(bookingoid) from ((select bookingoid, bookingdate from bookingmst left join bookinglog using(bookingoid) where date(bookingdate)<='$datestat' and inquirystatusoid='0' and grandtotal>0 and bookinglog.bookingoid is null) union (select bookingoid, max(`datetime`) from bookinglog inner join bookingmst using(bookingoid) where date(`datetime`)<='$datestat' and statusto='0' and inquirystatusoid='0' and grandtotal>0 group by bookingoid)) tbtemp";
$q_inquiry=mysql_query($s_inquiry) or die("Error!");
$d_inquiry=mysql_fetch_array($q_inquiry);

$fill = $d_inquiry[0];
break;
case '1':
$s_inquiry="select count(bookingoid) from (select bookingoid, max(`datetime`) as `datetime` from bookinglog inner join bookingmst using(bookingoid) where date(`datetime`)<='$datestat' and statusto='1' and inquirystatusoid='1' and grandtotal>0 group by bookingoid) tbtemp";
$q_inquiry=mysql_query($s_inquiry) or die("Error!");
$d_inquiry=mysql_fetch_array($q_inquiry);

$fill = $d_inquiry[0];
break;
case '2':
$s_inquiry="select count(bookingoid) from (select bookingoid, max(`datetime`) as `datetime` from bookinglog inner join bookingmst using(bookingoid) where date(`datetime`)<='$datestat' and statusto='2' and inquirystatusoid='2' and grandtotal>0 group by bookingoid) tbtemp";
$q_inquiry=mysql_query($s_inquiry) or die("Error!");
$d_inquiry=mysql_fetch_array($q_inquiry);

$fill = $d_inquiry[0];
break;
case '3':
$s_inquiry="select count(bookingoid) from (select bookingoid, max(`datetime`) as `datetime` from bookinglog inner join bookingmst using(bookingoid) where date(`datetime`)='$datestat' and statusto='3' and inquirystatusoid='3' and grandtotal>0 group by bookingoid) tbtemp";
$q_inquiry=mysql_query($s_inquiry) or die("Error!");
$d_inquiry=mysql_fetch_array($q_inquiry);

$fill = $d_inquiry[0];
break;
case '4':
$s_inquiry="select count(bookingoid) from (select bookingoid, max(`datetime`) as `datetime` from bookinglog inner join bookingmst using(bookingoid) where date(`datetime`)='$datestat' and statusto='4' and inquirystatusoid='4' and grandtotal>0 group by bookingoid) tbtemp";
$q_inquiry=mysql_query($s_inquiry) or die("Error!");
$d_inquiry=mysql_fetch_array($q_inquiry);

$fill = $d_inquiry[0];
break;
case '5':
$s_inquiry="select count(bookingoid) from (select bookingoid, max(`datetime`) as `datetime` from bookinglog inner join bookingmst using(bookingoid) where date(`datetime`)<='$datestat' and statusto='5' and inquirystatusoid='5' and grandtotal>0 group by bookingoid) tbtemp";
$q_inquiry=mysql_query($s_inquiry) or die("Error!");
$d_inquiry=mysql_fetch_array($q_inquiry);

$fill = $d_inquiry[0];
break;
case '6':
$s_inquiry="select count(bookingoid) from (select bookingoid, max(`datetime`) as `datetime` from bookinglog inner join bookingmst using(bookingoid) where date(`datetime`)='$datestat' and statusto='6' and inquirystatusoid='6' and grandtotal>0 group by bookingoid) tbtemp";
$q_inquiry=mysql_query($s_inquiry) or die("Error!");
$d_inquiry=mysql_fetch_array($q_inquiry);

$fill = $d_inquiry[0];
break;
}
}
?>
<td align="center">
<?=$fill?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
</div>
<?php
}
}
?>