";
echo "| ← | ";
echo "$displayMonth $year | ";
echo "→ | ";
echo "
| Su | M | Tu | W | Th | F | Sa |
";
for( $blankDay = 1; $blankDay <= $firstDay; $blankDay++ ) {
echo "| | ";
}
for( $i = 0; $i < $days; $i++ ) {
if( ($blankDay + ($day - 1)) % 7 == 0 && $day != 0 ) {
$cellNum = 1;
echo "
";
}
$day++;
echo "";
echo "";
if( $dSort=="purchaseDate" ) { // purchase date
$SQL = "SELECT Count(*) FROM invoice WHERE affiliateID=".$affiliateID." AND purchaseDate LIKE '".$year."-".$month."-".sprintf("%02d",$day)."%'";
$num = intval( $g_oNDB->getField(0, $SQL, 0) );
if( $num > 0 ) {
$style = "color: ".$linkcolor."; font-style: none; font-weight: normal";
} else {
$style = "color: ".$inactivetext."; font-style: italic;";
}
} elseif( $dSort=="s_InstallDate" ) { // installation date: method 1 = ~3.6s
$SQL = "SELECT Count(*) FROM invoice LEFT JOIN checkout ON invoice.checkoutID=checkout.ID WHERE invoice.affiliateID=".$affiliateID." AND s_InstallDate LIKE '".sprintf("%02d",$day)." ".$displayMonth."%' AND s_InstallYear='$year'"; // echo $SQL."
";
$num = intval( $g_oNDB->getField(0, $SQL, 0) );
if( $num > 0 ) {
$style = "color: ".$linkcolor."; font-style: none; font-weight: normal";
} else {
$style = "color: ".$inactivetext."; font-style: italic;";
}
} elseif( $dSort=="s_InstallDateX2" ) { // installation date: method 2 = ~2.7s
/* disabled until î can find a faster method */
$IDs = $g_oNDB->getColumn("select ID from checkout WHERE s_InstallYear='$year' AND s_InstallDate LIKE '".sprintf("%02d",$day)." ".$displayMonth."%'");
if( count($IDs)>0 ) {
$SQL = "SELECT Count(*) FROM invoice WHERE invoice.affiliateID=".$affiliateID." AND invoice.checkoutID IN (".implode(",",$IDs).")"; // echo $SQL."
";
$num = intval( $g_oNDB->getField(0, $SQL, 0) );
} else {
$num = 0;
}
if( $num > 0 ) {
$style = "color: ".$linkcolor."; font-style: none; font-weight: normal";
} else {
$style = "color: ".$inactivetext."; font-style: italic;";
}
} else { // otherwise
$style = "color: ".$linkcolor.";";
}
echo "".$day." | ";
$cellNum++;
}
while( $cellNum++ <= 7 ) echo " | ";
echo "
";
echo "".sprintf("%.3f", microtime_float()-$timeStart) . " seconds
";
} // makeCal()
///-------------------------------------------------------------------------
function days_in_month( $month, $leap ) {
switch( $month ) {
case 2: return $leap ? 29 : 28;
case 4: case 6: case 9: case 11: return 30;
default: return 31;
}
} // days_in_month()
//-------------------------------------------------------------------------
// is_leap_year: Just returns true if the specified year is a leap year.
//-------------------------------------------------------------------------
function is_leap_year( $year ) {
return ($year % 4 == 0) ? 1 : 0;
} // is_leap_year()
//-------------------------------------------------------------------------
// first_day_of_month: returns the numeric day of the week, "0" (Sunday) to "6" (Saturday)
//-------------------------------------------------------------------------
function first_day_of_month( $month, $year ) {
$firstDay = date("w" ,mktime(0,0,0,$month,1,$year));
return $firstDay;
} // first_day_of_month()
//-------------------------------------------------------------------------
// microtime_float: Simple function to replicate PHP 5 behaviour.
//-------------------------------------------------------------------------
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
} // microtime_float()
?>