";
echo "";
echo "
";
echo "
| No. |
REC. ID |
Tag |
In-Active as of |
Months |
Customer Name |
Sales Agent |
Region |
Dealership |
Date Created |
";
while($row=mysql_fetch_array($result)){
$SelDealID=$row['cust_deal_id'];
$MydateNow = date("Y/m/d");
$getLastUpdateDate = $row['last_update_date'];
if($getLastUpdateDate === ''){
$getLastUpdateDate = '2019/01/01';
}
$date2=date_create($MydateNow);
$date1=date_create($getLastUpdateDate);
$diff=date_diff($date1,$date2);
$dateDiff= $diff->format("%a") / 30;
//echo $dateDiff ."
";
if($dateDiff > 3 && $dateDiff <= 6){
$count=$count + 1;
//$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0);
$selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0);
$selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0);
?>".$count."";
echo "| ".$row['c_id']." | ";
echo "Grp# ".$row['lead_tag']." | ";
echo "".date_format($date1,"m/d/Y")." | ";
echo "".number_format($dateDiff,0,'.',',') ." Mons | ";
echo "".$row['cust_lname'].", ".$row['cust_fname']." | ";
echo "".$row['data_assigned_to']." | ";
echo "".$row['cust_region']." | ";
echo "".$selDealName." | ";
echo "".$row['cust_date_added']." | ";
echo "
";
//PUT 3 integer sa dormant field to identify leads has been processed
mysql_query("UPDATE `vts_customers` SET `dormant` ='3' WHERE `c_id`='".$row['c_id']."'");
}
}
echo "
";
echo"
";
echo "
";
echo "
";
echo "
| No. |
REC. ID |
Tag |
In-Active as of |
Months |
Customer Name |
Sales Agent |
Region |
Dealership |
Date Created |
";
while($row=mysql_fetch_array($result)){
$SelDealID=$row['cust_deal_id'];
$MydateNow = date("Y/m/d");
$getLastUpdateDate =$row['last_update_date'];
$date2=date_create($MydateNow);
$date1=date_create($getLastUpdateDate);
$diff=date_diff($date1,$date2);
$dateDiff= $diff->format("%a") / 30;
//echo $dateDiff ."
";
if($dateDiff > 6 && $dateDiff <= 13){
$count=$count + 1;
//$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0);
$selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0);
$selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0);
?>".$count."";
echo "| ".$row['c_id']." | ";
echo "Grp# ".$row['lead_tag']." | ";
echo "".date_format($date1,"m/d/Y")." | ";
echo "".number_format($dateDiff,0,'.',',') ." Mons | ";
echo "".$row['cust_lname'].", ".$row['cust_fname']." | ";
echo "".$row['data_assigned_to']." | ";
echo "".$row['cust_region']." | ";
echo "".$selDealName." | ";
echo "".$row['cust_date_added']." | ";
echo "
";
//PUT 3 integer sa dormant field to identify leads has been processed
mysql_query("UPDATE `vts_customers` SET `dormant` ='6' WHERE `c_id`='".$row['c_id']."'");
}
}
echo "
";
echo"
";
echo"
";
echo "
";
echo "
";
echo "
| No. |
REC. ID |
Tag |
In-Active as of |
Months |
Customer Name |
Sales Agent |
Region |
Dealership |
Date Created |
";
while($row=mysql_fetch_array($result)){
$SelDealID=$row['cust_deal_id'];
$MydateNow = date("Y/m/d");
$getLastUpdateDate =$row['last_update_date'];
$date2=date_create($MydateNow);
$date1=date_create($getLastUpdateDate);
$diff=date_diff($date1,$date2);
$dateDiff= $diff->format("%a") / 30;
//echo $dateDiff ."
";
if($dateDiff > 12 ){
$count=$count + 1;
//$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0);
$selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0);
$selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0);
?>".$count."";
echo "| ".$row['c_id']." | ";
echo "Grp# ".$row['lead_tag']." | ";
echo "".date_format($date1,"m/d/Y")." | ";
echo "".number_format($dateDiff,0,'.',',') ." Mons | ";
echo "".$row['cust_lname'].", ".$row['cust_fname']." | ";
echo "".$row['data_assigned_to']." | ";
echo "".$row['cust_region']." | ";
echo "".$selDealName." | ";
echo "".$row['cust_date_added']." | ";
echo "
";
//PUT 3 integer sa dormant field to identify leads has been processed
mysql_query("UPDATE `vts_customers` SET `dormant` ='12' WHERE `c_id`='".$row['c_id']."'");
}
}
echo "
";
echo"
";
echo"
";
echo "
";
echo "
";
echo "
| No. |
REC. ID |
Tag |
In-Active as of |
InActive Months |
Customer Name |
Sales Agent |
Region |
Dealership |
Date Created |
";
while($row=mysql_fetch_array($resultFLT)){
$SelDealID=$row['deal_owner_id'];
$MydateNow = date("Y/m/d");
$getLastUpdateDate =$row['last_update_date'];
$date2=date_create($MydateNow);
$date1=date_create($getLastUpdateDate);
$diff=date_diff($date1,$date2);
$dateDiff= $diff->format("%a") / 30;
//echo $dateDiff ."
";
if($dateDiff > 3 && $dateDiff <= 6){
$count=$count + 1;
//$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0);
$selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0);
$selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0);
?>".$count."";
echo "| ".$row['bid']." | ";
echo "Grp# ".$row['lead_tag']." | ";
echo "".date_format($date1,"m/d/Y")." | ";
echo "".number_format($dateDiff,0,'.',',') ." Mons | ";
echo "".$row['business_name']." | ";
echo "".$row['data_assigned_to']." | ";
echo "".$row['cust_region']." | ";
echo "".$selDealName." | ";
echo "".$row['date_time_added']." | ";
echo "
";
//PUT 3 integer sa dormant field to identify leads has been processed
mysql_query("UPDATE `businesses_names` SET `dormant` ='3' WHERE `bid`='".$row['bid']."'");
}
}
echo "
";
echo"
";
echo"
";
echo "
";
echo "
";
echo "
| No. |
REC. ID |
Tag |
In-Active as of |
InActive Months |
Customer Name |
Sales Agent |
Region |
Dealership |
Date Created |
";
while($row=mysql_fetch_array($resultFLT)){
$SelDealID=$row['deal_owner_id'];
$MydateNow = date("Y/m/d");
$getLastUpdateDate =$row['last_update_date'];
$date2=date_create($MydateNow);
$date1=date_create($getLastUpdateDate);
$diff=date_diff($date1,$date2);
$dateDiff= $diff->format("%a") / 30;
//echo $dateDiff ."
";
if($dateDiff > 6 && $dateDiff <= 12){
$count=$count + 1;
//$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0);
$selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0);
$selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0);
?>".$count."";
echo "| ".$row['bid']." | ";
echo "Grp# ".$row['lead_tag']." | ";
echo "".date_format($date1,"m/d/Y")." | ";
echo "".number_format($dateDiff,0,'.',',') ." Mons | ";
echo "".$row['business_name']." | ";
echo "".$row['data_assigned_to']." | ";
echo "".$row['cust_region']." | ";
echo "".$selDealName." | ";
echo "".$row['date_time_added']." | ";
echo "
";
//PUT 3 integer sa dormant field to identify leads has been processed
mysql_query("UPDATE `businesses_names` SET `dormant` ='6' WHERE `bid`='".$row['bid']."'");
}
}
echo "
";
echo"
";
echo"
";
echo "
";
echo "
";
echo "
| No. |
REC. ID |
Tag |
In-Active as of |
InActive Months |
Customer Name |
Sales Agent |
Region |
Dealership |
Date Created |
";
while($row=mysql_fetch_array($resultFLT)){
$SelDealID=$row['deal_owner_id'];
$MydateNow = date("Y/m/d");
$getLastUpdateDate =$row['last_update_date'];
$date2=date_create($MydateNow);
$date1=date_create($getLastUpdateDate);
$diff=date_diff($date1,$date2);
$dateDiff= $diff->format("%a") / 30;
//echo $dateDiff ."
";
if($dateDiff > 12){
$count=$count + 1;
//$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0);
$selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0);
$selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0);
?>".$count."";
echo "| ".$row['bid']." | ";
echo "Grp# ".$row['lead_tag']." | ";
echo "".date_format($date1,"m/d/Y")." | ";
echo "".number_format($dateDiff,0,'.',',') ." Mons | ";
echo "".$row['business_name']." | ";
echo "".$row['data_assigned_to']." | ";
echo "".$row['cust_region']." | ";
echo "".$selDealName." | ";
echo "".$row['date_time_added']." | ";
echo "
";
//PUT 3 integer sa dormant field to identify leads has been processed
mysql_query("UPDATE `businesses_names` SET `dormant` ='12' WHERE `bid`='".$row['bid']."'");
}
}
echo "
";
echo"
";
echo"
(".number_format($updateCount,0,'',','). ") Records has been processed.
";
echo "";
echo"";
echo"";
break;
case '1002': //3 MONTHS TAGGING HAS BEEN SELECTED
$selectedGroup=$_POST['AssignProspectToSalesGroupSixNon'];
$dataLimit=$_POST['AssignProspectToSalesGroupSixLimitNon'];
$tag = mysql_query("SELECT * FROM `vts_customers` WHERE `status`='1' AND `cust_comp_id`='$sCompID' AND `dormant`='6' ORDER BY `cust_lname` ASC LIMIT $dataLimit ");
while($row=mysql_fetch_array($tag)){
$updateCount = $updateCount + 1;
$rowID=$row['c_id'];
mysql_query("UPDATE `vts_customers` SET `lead_tag` ='$selectedGroup' , `dormant`='' WHERE `c_id`='$rowID' ");
}
echo "(".number_format($updateCount,0,'',','). ") Records has been processed.
";
echo "";
echo"";
echo"";
break;
case '1003': //3 MONTHS TAGGING HAS BEEN SELECTED
$selectedGroup=$_POST['AssignProspectToSalesGroupYearNon'];
$dataLimit=$_POST['AssignProspectToSalesGroupYearLimitNon'];
$tag = mysql_query("SELECT * FROM `vts_customers` WHERE `status`='1' AND `cust_comp_id`='$sCompID' AND `dormant`='12' ORDER BY `cust_lname` ASC LIMIT $dataLimit ");
while($row=mysql_fetch_array($tag)){
$updateCount = $updateCount + 1;
$rowID=$row['c_id'];
mysql_query("UPDATE `vts_customers` SET `lead_tag` ='$selectedGroup', `dormant`='' WHERE `c_id`='$rowID'");
}
echo "(".number_format($updateCount,0,'',','). ") Records has been processed.
";
echo "";
echo"";
echo"";
break;
case '2001': //3 MONTHS TAGGING HAS BEEN SELECTED
$selectedGroup=$_POST['AssignProspectToSalesGroupThree'];
$dataLimit=$_POST['AssignProspectToSalesGroupThreeLimit'];
$tag = mysql_query("SELECT * FROM `businesses_names` WHERE `status`='1' AND `comp_owner_id`='$sCompID' AND `dormant`='3' ORDER BY `business_name` ASC LIMIT $dataLimit ");
while($row=mysql_fetch_array($tag)){
$updateCount = $updateCount + 1;
$rowID=$row['bid'];
mysql_query("UPDATE `businesses_names` SET `lead_tag` ='$selectedGroup', `dormant`='' WHERE `bid`='$rowID'");
}
echo "(".number_format($updateCount,0,'',','). ") Records has been processed.
";
echo "";
echo"";
echo"";
break;
case '2002': //3 MONTHS TAGGING HAS BEEN SELECTED
$selectedGroup=$_POST['AssignProspectToSalesGroupSix'];
$dataLimit=$_POST['AssignProspectToSalesGroupSixLimit'];
$tag = mysql_query("SELECT * FROM `businesses_names` WHERE `status`='1' AND `comp_owner_id`='$sCompID' AND `dormant`='6' ORDER BY `business_name` ASC LIMIT $dataLimit ");
while($row=mysql_fetch_array($tag)){
$updateCount = $updateCount + 1;
$rowID=$row['bid'];
mysql_query("UPDATE `businesses_names` SET `lead_tag` ='$selectedGroup', `dormant`='' WHERE `bid`='$rowID'");
}
echo "(".number_format($updateCount,0,'',','). ") Records has been processed.
";
echo "";
echo"";
echo"";
break;
case '2003': //3 MONTHS TAGGING HAS BEEN SELECTED AssignToSalesGroupYearFleet AssignProspectToSalesGroupYearLimit AssignProspectToSalesGroupYearFleet
$selectedGroup = $_POST['AssignProspectToSalesGroupYearFleet'];
$dataLimit = $_POST['AssignProspectToSalesGroupYearLimit'];
$tag = mysql_query("SELECT * FROM `businesses_names` WHERE `status`='1' AND `comp_owner_id`='$sCompID' AND `dormant`='12' ORDER BY `business_name` ASC LIMIT $dataLimit ");
while($row=mysql_fetch_array($tag)){
$updateCount = $updateCount + 1;
$rowID=$row['bid'];
mysql_query("UPDATE `businesses_names` SET `lead_tag` ='$selectedGroup', `dormant`='' WHERE `bid`='$rowID'");
}
echo "(".number_format($updateCount,0,'',','). ") Records has been processed.
";
echo "";
echo"";
echo"";
break;
}
}
?>