50 "),0);
$activeA = mysql_result(mysql_query("SELECT COUNT('c_id') FROM "),0);
$scanAges = mysql_query("SELECT * FROM `vts_customers` WHERE `status`= 1 AND `cust_comp_id`='$compID'");
while($row=mysql_fetch_array($scanAges)){
$lastUpdatDate = $row['last_update_date'];
$CustBday = $row['cust_bday'];
$currentDateIs = date("Y/m/d");
$timeStart = strtotime($lastUpdatDate);
$timeEnd = strtotime($currentDateIs);
$birthDate = strtotime($CustBday);
$bdayMonths = 1 + (date("Y",$timeEnd)-date("Y",$birthDate));
$bdayMonths += date("m",$timeEnd)-date("m",$birthDate);
if($bdayMonths < 30){
$custCountA = $custCountA + 1;
}else if($bdayMonths > 29 && $bdayMonths < 51){
$custCountB = $custCountB + 1;
}else {
$custCountC = $custCountC + 1;
}
//echo "My Age is ".$bdayMonths;
// Adding current month + all months in each passed year
$numMonths = 1 + (date("Y",$timeEnd)-date("Y",$timeStart))*12;
$numMonths += date("m",$timeEnd)-date("m",$timeStart);
if($lastUpdatDate =''){
$NoActivity = $NoActivity + 1;
}else{
$numMonths = 1 + (date("Y",$timeEnd)-date("Y",$timeStart))*12;
$numMonths += date("m",$timeEnd)-date("m",$timeStart);
if($numMonths < 6){
$lessSix = $lessSix + 1;
}else if($numMonths > 6 && $numMonths < 12){
$lessYear = $lessYear + 1;
}else {
$inActive = $inActive + 1;
}
}
}
?>
Loading..