File manager

File manager - Edit - /home/autoph/public_html/voc/home/add_new_prospect_data.php

Back
<?php $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','root','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); error_reporting(1); //if submit/ save to databasevar if(isset($_POST['done'])){ $custID = mysql_escape_string($_POST['custID']); $salesEmpID = mysql_escape_string($_POST['salesEmpID']); $addBy = mysql_escape_string($_POST['svUserID']); $addDate = mysql_escape_string($_POST['svDate']); $addTime = mysql_escape_string($_POST['svTime']); $sCompID = mysql_escape_string($_POST['sCompID']); $sDealID = mysql_escape_string($_POST['sDealID']); $clickAccountType = mysql_escape_string($_POST['clickAccountType']); if($clickAccountType==='No'){ }else { } if($clickAccountType ==='fleet'){ $acType='Yes';//Fleet Account $prospectName = mysql_result(mysql_query("SELECT `business_name` FROM `businesses_names` WHERE `bid`='$custID'"),0); $clientsName = $prospectName; $activeeMail = mysql_result(mysql_query("SELECT `contact_number` FRM `businesses_names` WHERE `c_id`='getCustID'"),0); $activeMobile = mysql_result(mysql_query("SELECT `emaail` FRM `businesses_names` WHERE `c_id`='getCustID'"),0); } else { $acType='No';//Non-Fleet Account $prospectFName = mysql_result(mysql_query("SELECT `cust_fname` FROM `vts_customers` WHERE `c_id`='$custID'"),0); $prospectLName = mysql_result(mysql_query("SELECT `cust_lname` FROM `vts_customers` WHERE `c_id`='$custID'"),0); $clientsName = $prospectLName. ", ". $prospectFName; $activeeMail = mysql_result(mysql_query("SELECT `cust_mobile` FRM `vts_customers` WHERE `c_id`='getCustID'"),0); $activeMobile = mysql_result(mysql_query("SELECT `cust_email` FRM `vts_customers` WHERE `c_id`='getCustID'"),0); } $empGroupID = mysql_result(mysql_query("SELECT `sales_group` FROM `vts_users` WHERE `employee_id`='$salesEmpID'"),0); $checkIfAssigned=mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `cust_id`= '$custID' AND `status`='open' AND `is_fleet`='$acType'"),0); if($checkIfAssigned > 0){ echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:20px;padding-right:20px;margin:2px'>Error: Other agent is handling this account.</p>"; }else{ mysql_query("INSERT INTO sales_prospecting (prospect_name, is_fleet, cust_id, group_id, sales_id, comp_id, deal_id, date_added,time_added,encoded_by, active_mobile, active_email) VALUES('{$clientsName}','{$acType}','{$custID}', '{$empGroupID}','{$salesEmpID}','{$sCompID}','{$sDealID}','{$addDate}','{$addTime}','{$addBy}','{$activeMobile}','{$activeeMail}')"); if($clickAccountType==='fleet'){ //UPDATE CUSTOMER DATBASE AND PUT TAG AS ASSIGNED AND ASSIGNED SALES ID mysql_query("UPDATE `businesses_names` SET `data_assigned_to`='{$salesEmpID}', `last_update_date`='{$addDate}', `last_update_time`='{$addTime}' WHERE `bid`='{$custID}'"); echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:30px;padding-right:30px;margin:2px'>New Record has been saved.</p>"; }else{ //UPDATE CUSTOMER DATBASE AND PUT TAG AS ASSIGNED AND ASSIGNED SALES ID mysql_query("UPDATE `vts_customers` SET `data_assigned_to`='{$salesEmpID}', `last_update_date`='{$addDate}', `last_update_time`='{$addTime}' WHERE `c_id`='{$custID}'"); echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:30px;padding-right:30px;margin:2px'>New Record has been saved.</p>"; } } exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings