Add New Prospect

🎾 Search Record: (Lastname, Firstname)

Sales Group Setup:

Type Group Name

Group Head

"; echo ""; echo "ID"; echo "Group Name"; echo "Group Head"; echo "Members"; echo "Assigend Database"; echo ""; while($row=mysql_fetch_array($getSalesGroup)){ $gHead = $row['group_head']; $gID= $row['gid']; $gFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $gLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0); ?>".$row['gid'].""; echo "".$row['group_name'].""; echo "".$gLname. ", ".$gFname.""; echo "".number_format($getMember,0,'.',',').""; echo ""; $countAssignDB = mysql_result(mysql_query("SELECT COUNT(`c_id`) FROM `vts_customers` WHERE `lead_tag`='$gID'"),0); echo $countAssignDB; echo ""; echo ""; } echo ""; ?>

☵ DATABASE COUNT

📝 Stored Database

Fleet

Non-Fleet

🗊 LMS Management

📋 Prospects By Type

Fleet: 🏥

Non-Fleet:👮

📝 Prospects By Group

".$data['group_name']." 👪

".$grpProspect."

"; } ?>

🏳 Prospect By Status ()

Cold 📞

Active 🙋

Demo 🎶

Approval 📌

Win🏅

Lost 🔂