"; echo "
"; echo ""; echo ""; while($row=mysql_fetch_array($result)){ $custComp=$row['cust_business_id']; $custCompName = mysql_result(mysql_query("SELECT `business_name` FROM `businesses_names` WHERE `bid`='$custComp'"),0); ?>".$row['c_id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getAgentID=$row['data_assigned_to']; $agentFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `employee_id`='$getAgentID'"),0); $agentLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `employee_id`='$getAgentID'"),0); echo ""; echo ""; echo ""; } echo "
REC. ID CUSTOMER NAME COMPANY/ORGANIZATION MUNICIPATILITY City E-MAIL MOBILE LAST UPDATE AGENT TYPE
".$row['cust_lname'].", ".$row['cust_fname']."".$custCompName."".$row['cust_municipality']."".$row['cust_city']."".$row['cust_email']."".$row['cust_mobile']."".$row['last_update_date']."". $agentLName. ", ".$agentFName."non-fleet
"; echo"
"; echo""; break; //===================================================================================================================================================== //===================================================================================================================================================== case '1': $FleetSearchText = mysql_escape_string($_POST['FleetSearchText']); $sCompID = mysql_escape_string($_POST['sCompID']); $result = mysql_query("SELECT * FROM `businesses_names` WHERE `business_name` LIKE '%$FleetSearchText%' AND `comp_owner_id`='$sCompID' ORDER BY `business_name` ASC"); echo "
"; echo "
"; echo ""; echo ""; while($row=mysql_fetch_array($result)){ $salesID=$row['sales_person']; $SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$salesID'"),0); ?>".$row['bid'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getAgentID=$row['data_assigned_to']; $agentFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `employee_id`='$getAgentID'"),0); $agentLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `employee_id`='$getAgentID'"),0); echo ""; echo ""; echo ""; } echo "
REC. ID CUSTOMER NAME CONTACT PERSON MUNICIPATILITY City E-MAIL MOBILE LAST UPDATE AGENT TYPE
".$row['business_name']."".$SalesPerson."".$row['business_municipality']."".$row['business_city']."".$row['email']."".$row['contact_number']."".$row['last_update_date']."". $agentLName. ", ".$agentFName."fleet
"; echo"
"; echo"
"; break; //===================================================================================================================================================== case '2': //$assigned = mysql_escape_string($_POST['assigned']); $sCompID = mysql_escape_string($_POST['sCompID']); $result = mysql_query("SELECT * FROM `sales_prospecting` WHERE `status` ='open' AND `comp_id`='$sCompID' ORDER BY `sales_id` ASC"); echo "
"; echo "
"; echo ""; echo ""; while($row=mysql_fetch_array($result)){ $salesID=$row['sales_id']; $custID=$row['cust_id']; $isFleet=$row['is_fleet']; $SelCompID=$row['comp_id']; $SelDealID=$row['deal_id']; //$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); if($isFleet ==='No'){ $CustFName = mysql_result(mysql_query("SELECT `cust_fname` FROM `vts_customers` WHERE `c_id`='$custID'"),0); $CustLName = mysql_result(mysql_query("SELECT `cust_lname` FROM `vts_customers` WHERE `c_id`='$custID'"),0); $custFullName = $CustLName.", ".$CustFName; }else{ $CustBName = mysql_result(mysql_query("SELECT `business_name` FROM `businesses_names` WHERE `bid`='$custID'"),0); $custFullName = $CustBName; } ?>".$row['cust_id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
REC. ID Type Customer Name Sales Person Company Dealership Date Created Status
"; if($row['is_fleet']==='No'){ echo "non-fleet"; }else{ echo "fleet"; } echo"".$custFullName."".$salesID."".$selCompName."".$selDealName."".$row['date_added']."".$row['status']."
"; echo"
"; echo"
"; break; } exit(); } ?>