🎯 LEAD MANAGEMENT SYSTEM
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
REC. ID REGION NAME NON-FLEET FLEET ACTIVE LEADS FRESH POTENTIAL REQ.DEMO APPROVAL SOLD LOST
".$row['id']."".$row['region_name'].""; $countNonFleetCustomer = mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `cust_region`='".$row['region_name']."' AND `status`='1'"),0); echo number_format($countNonFleetCustomer,0,'',','); echo""; $countFleetCustomer = mysql_result(mysql_query("SELECT COUNT('bid') FROM `businesses_names` WHERE `business_region`='".$row['region_name']."' AND `status`='1' AND `comp_owner_id`='$compID'"),0); echo number_format($countFleetCustomer,0,'',','); echo""; $countActiveLeads = mysql_query("SELECT * FROM `sales_prospecting` WHERE `status`='open' AND `comp_id`='$compID'"); while ($ac=mysql_fetch_array($countActiveLeads)){ $custID = $ac['cust_id']; $isFleet = $ac['is_fleet']; if($isFleet === 'Yes'){ //FLEET PROSPECT $getAccountRegion = mysql_result(mysql_query("SELECT `cust_region` FROM `vts_customers` WHERE `c_id`='$custID'"),0); $getAccountRegion = mysql_result(mysql_query("SELECT `business_region` FROM `businesses_names` WHERE `bid`='$custID'"),0); if($getAccountRegion === $curRegion){ $leadByRegionF = $leadByRegionF + 1; if($ac['hot_date']=='' AND $ac['warm_date']=='' AND $ac['sales_approval']=='' AND $ac['sales_approval']==''){ $fresh = $fresh + 1; } if($ac['hot_date']=='' && $ac['warm_date']!='' && $ac['sales_approval']==''){ $warm = $warm + 1; } if($ac['sales_approval']=='' && $ac['hot_date']!='' && $ac['win_date']==''){ $hot = $hot + 1; } if($ac['win_date']=='' && $ac['sales_approval']!='' && $ac['lost_date']==''){ $approval= $approval + 1; } } } if($isFleet === 'No'){ //FLEET PROSPECT $getAccountRegion = mysql_result(mysql_query("SELECT `cust_region` FROM `vts_customers` WHERE `c_id`='$custID'"),0); $getAccountRegionN = mysql_result(mysql_query("SELECT `cust_region` FROM `vts_customers` WHERE `c_id`='$custID'"),0); if($getAccountRegionN === $curRegion){ $leadByRegionN = $leadByRegionN + 1; if($ac['hot_date']=='' AND $ac['warm_date']=='' AND $ac['sales_approval']=='' AND $ac['sales_approval']==''){ $fresh = $fresh + 1; } if($ac['hot_date']=='' && $ac['warm_date']!='' && $ac['sales_approval']==''){ $warm = $warm + 1; } if($ac['sales_approval']=='' && $ac['hot_date']!='' && $ac['win_date']==''){ $hot = $hot + 1; } if($ac['win_date']=='' && $ac['sales_approval']!='' && $ac['lost_date']==''){ $approval= $approval + 1; } } } } $LCCount = $leadByRegionF + $leadByRegionN; echo $LCCount; echo""; echo number_format($fresh,0,'',','); echo""; echo number_format($warm,0,'',','); echo""; echo number_format($hot,0,'',','); echo""; echo number_format($approval,0,'',','); echo""; $countActiveLeadC = mysql_query("SELECT * FROM `sales_prospecting` WHERE `status`='closed' AND `comp_id`='$compID'"); while ($lc=mysql_fetch_array($countActiveLeadC)){ $custID = $lc['cust_id']; $isFleet = $lc['is_fleet']; if($isFleet === 'Yes'){ $getAccountRegion = mysql_result(mysql_query("SELECT `business_region` FROM `businesses_names` WHERE `bid`='$custID'"),0); if($getAccountRegion === $curRegion){ $getAccountRegion = mysql_result(mysql_query("SELECT `business_region` FROM `businesses_names` WHERE `bid`='$custID'"),0); if($getAccountRegion === $curRegion){ if($lc['lost_date']!='' && $lc['status'] =='closed'){ $lost= $lost + 1; } if($lc['win_date']!='' && $lc['status'] =='closed'){ $win= $win + 1; } } } } if($isFleet === 'No'){ $getAccountRegionN = mysql_result(mysql_query("SELECT `cust_region` FROM `vts_customers` WHERE `c_id`='$custID'"),0); if($getAccountRegionN === $curRegion){ $leadByRegionN = $leadByRegionN + 1; $getAccountRegion = mysql_result(mysql_query("SELECT `business_region` FROM `businesses_names` WHERE `bid`='$custID'"),0); if($getAccountRegion === $curRegion){ } } } } echo number_format($win,0,'',','); echo""; echo number_format($lost,0,'',','); echo"

PROSPECT SUMMARY

".$pRow['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; } ?>
REC ID CUSTOMER NAME CUST. TYPE SALES GROUP GROUP HEAD DATE ASSIGNED POTENTIAL REQ.DEMO APPROVAL
".$pRow['prospect_name'].""; if($pRow['is_fleet']==='Yes'){ echo "Fleet Account"; }else{ echo "Non-Fleet Account"; } echo""; $gID = $pRow['group_id']; $gName = mysql_result(mysql_query("SELECT `group_name` FROM `db_sales_group` WHERE `gid`='$gID'"),0); echo $gName; echo ""; $gID = $pRow['group_id']; $gHead = mysql_result(mysql_query("SELECT `group_head` FROM `db_sales_group` WHERE `gid`='$gID'"),0); $gHeadFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $gHeadLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); echo $gHeadLName.', '.$gHeadFName; echo "".$pRow['date_added']."".$pRow['warm_date']."".$pRow['hot_date']."".$pRow['sales_approval']."View Activities