| Server IP : 108.163.255.210 / Your IP : 3.133.143.118 Web Server : Apache System : Linux blossom.urlnameserver.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64 User : ( 1172) PHP Version : 7.2.34 Disable Function : eval,escapeshellarg,proc_close,proc_get_status,proc_nice,proc_open,symlink,system,pcntl_exec,getrusage,chown,chgp,closelog,openlog,syslog,define_syslog_variables,php_ini_loaded_file,getservbyname,getservbyport,posix_getgid,posix_getgrgid,proc_terminate,pfsockopen,apache_child_terminate,posix_mkfifo,posix_setpgid,posix_setuid,hypot,pg_host,pos,posix_access,posix_getcwd,posix_getservbyname,myshellexec,getpid,posix_getsid,posix_isatty,posix_kill,posix_mknod,posix_setgid,posix_setsid,posix_setuid,posix_times,posix_uname,ps_fill,posix_getpwuid,global,ini_restore,zip_open,zip_read,rar_open,bzopen,bzread,bzwrite,apache_get_modules,apache_get_version,phpversionphpinfo,php_ini_scanned_files,get_current_user,disk_total_space,diskfreespace,leak,imap_list,hypo,filedump,safe_mode,getmygid,apache_getenv,apache_setenv,bzread,bzwrite,bzopen,phpini,higlight_file,dos_conv,get_cwd,er_log,cmd,e_name,vdir,get_dir,only_read,ftok,ftpexec,posix_getpwnam,mysql_list_dbs,disk_free_space,session_save_path,confirm_phpdoc_compiled,zip_entry_rea,php_u,psockopen,crack_opendict,crack_getlastmessage,crack_closedict,crack_check,fpassthru,posix_get_last_error,posix_getlogin,posix_getgroups,posix_strerror,posix_getrlimit,posix_getpgrp,posix_getgrnam,pos,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/unilinki/www/Intellilead/leads/ |
Upload File : |
<?php
require "../includes/authenticate.php";
if(isset($_REQUEST['submit']) && $_REQUEST['submit']=='submit')
{
//print_r(key($_POST)); die;
$source = $_POST["source"];
$lead_code = $_POST["lead_code"];
$name = $_POST["name"];
$email = $_POST["email"];
$mobile = $_POST["mobile"];
$phone = $_POST["phone"];
$city = $_POST["city"];
$country = $_POST["country"];
$status = $_POST["status"];
$code = $_POST["tol"];
$tol = $_POST["tsr"];
$msg = $_POST["msg"];
$plan_to_buy = $_POST["plan_to_buy"];
$contacted_by = $_POST["contacted_by"];
$msg_date = $_POST["msg_date"];
$interested = $_POST["interested"];
$budget = $_POST["budget"];
$high_lead = $_POST["high_lead"];
$pref_loc = $_POST["pref_loc"];
$look_for = $_POST["look_for"];
$subject = $_POST["subject"];
$other_detail = $_POST["other_detail"];
$role = getRoleIdByUserId($_SESSION['user_id']);
if($role=='2'||$role=='3'||$role=='4'){
$assign_by = $_SESSION['user_id'];
$assign_to = $_SESSION['user_id'];
$assign_tc = $_SESSION['user_id'];
$sales_by = '';
$sales_to = '';
$sales_tc = '';
}else if($role=='5'){
$assign_by = $_SESSION['user_id'];
$assign_to = $_SESSION['rep_head'];
$assign_tc = $_SESSION['user_id'];
$sales_by = '';
$sales_to = '';
$sales_tc = '';
}else if($role=='6'||$role=='7'){
$assign_by = $_SESSION['user_id'];
$assign_to = '';
$assign_tc = '';
$sales_by = $_SESSION['user_id'];
$sales_to = $_SESSION['user_id'];
$sales_tc = $_SESSION['user_id'];
}else if($role=='8'){
$assign_by = $_SESSION['user_id'];
$assign_to = '';
$assign_tc = '';
$sales_by = $_SESSION['user_id'];
$sales_to = $_SESSION['rep_head'];
$sales_tc = $_SESSION['user_id'];
}
$sql="select lead_code from mstr_leads where lead_code='$lead_code' and company_id = '".$_SESSION['company_id']."'";
$res= getSingleResult($sql);
if($res != ""){
$_SESSION['sess_msg'] = "THIS Lead ALREADY EXISTS. PLEASE INSERT ANOTHER ONE.";
header('Location: user_leads.php');
exit;
} else{
$sql="INSERT INTO mstr_leads (lead_code,source,name,email,mobile,phone,city,country,project_name,status,tol,tsr,msg,plan_to_buy,contacted_by,msg_date,interested,budget,high_lead,pref_loc,look_for,subject,other_detail,assign_by,assign_to,assign_tc,sales_by,sales_to,sales_tc,lead_status,company_id,user_id,upload_date,del_id)
values('".$_POST['lead_code']."','".$_POST['source']."','".$_POST['name']."','".$_POST['email']."','".$_POST['mobile']."','".$_POST['phone']."','".$_POST['city']."','".$_POST['country']."','".$_POST['project_name']."','".$_POST['status']."','".$_POST['tol']."','".$_POST['tsr']."','".$_POST['msg']."','".$_POST['plan_to_buy']."','".$_POST['contacted_by']."','".$_POST['msg_date']."','".$_POST['interested']."','".$_POST['budget']."','".$_POST['high_lead']."','".$_POST['pref_loc']."','".$_POST['look_for']."','".$_POST['subject']."','".$_POST['other_detail']."','$assign_by','$assign_to','$assign_tc','$sales_by','$sales_to','$sales_tc','14
','".$_SESSION['company_id']."','".$_SESSION['user_id']."',NOW(),'0')";
executeQuery($sql);
$leadid=mysql_insert_id();
$sql2="INSERT INTO mstr_history (lead_id,lead_status,assign_by,assign_tc,company_id,user_id,datetime) values('$leadid','14','".$_SESSION['user_id']."','".$_SESSION['user_id']."','".$_SESSION['company_id']."','".$_SESSION['user_id']."','".$DateTime."')";
executeQuery($sql2);
$_SESSION['sess_msg'] = "Lead ( ".$lead_code." ) ADDED SUCCESSFULLY";
//die;
header('Location: user_leads.php');
exit();
}
}
include('../template/header.php');
function next_value_LeadCode($current) {
$letter = substr($current,0,2);
$number = (int) substr($current, 2);
if ($number == 9999) {
$letter++;
$number = 1;
}else {
$number++;
}
return date("ym").$letter.str_pad($number, 4, '0', STR_PAD_LEFT);
}
$leadid = getSingleResult("SELECT MAX(lead_code) FROM `mstr_leads` where company_id ='".$_SESSION['company_id']."'");
$lead_code = substr($leadid,4,6);
?>
<style>
.lms{display:inline-block; width:31%;}
.dtp > .dtp-content{max-width:400px !important;}
</style>
<!-- page heading start-->
<div class="panel box-shadow-none content-header">
<div class="panel-body">
<div class="col-md-12">
<h3 class="animated fadeInLeft">Add Lead</h3>
<p class="animated fadeInDown">
Leads <span class="fa-angle-right fa"></span>Add Lead
</p>
</div>
</div>
</div>
<!-- page heading end-->
<!--body wrapper start-->
<div class="col-md-12">
<?php include('../template/response.php');?>
<div class="col-md-12 panel">
<div class="col-md-12 panel-heading">
<h4></h4>
</div>
<form id="commentForm" method="post" enctype="multipart/form-data" action="user_leads.php">
<div class="col-md-12 panel-body">
<div class="col-md-12">
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="source" class="form-text mask-date" required>
<span class="bar"></span>
<label>Source</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="name" class="form-text mask-time" required>
<span class="bar"></span>
<label>Name</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="email" class="form-text mask-date_time" required>
<span class="bar"></span>
<label>Email</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="mobile" class="form-text mask-cep" title="Please Enter 10 Digit Mobile number" maxlength="10" required>
<span class="bar"></span>
<label>Mob No.</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="phone" class="form-text mask-cep_with_callback" title="Please Enter Phone number" required>
<span class="bar"></span>
<label>Phone No.</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="city" class="form-text mask-crazy_cep" required>
<span class="bar"></span>
<label>City</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="country" class="form-text mask-money" >
<span class="bar"></span>
<label>Country</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="status" class="form-text " placeholder="" >
<span class="bar"></span>
<label>Status</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="project_name" class="form-text " placeholder="" required >
<span class="bar"></span>
<label>Project Name</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="tol" class="form-text mask-phone" >
<span class="bar"></span>
<label>Type of Lead</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="tsr" class="form-text mask-phone_with_ddd" >
<span class="bar"></span>
<label>Sale/Rent</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="msg" class="form-text mask-phone_us" >
<span class="bar"></span>
<label>Message Details</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="plan_to_buy" class="form-text mask-sp_celphones" >
<span class="bar"></span>
<label>Plan to Buy</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="contacted_by" class="form-text mask-mixed" required>
<span class="bar"></span>
<label>Contacted By</label>
</div>
<div class="form-group form-animate-text lms">
<input type="text" name="msg_date" class="form-text dateAnimate" >
<span class="bar"></span>
<label><span class="fa fa-calendar"></span> Message Date</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="interested" class="form-text mask-ip_address" required>
<span class="bar"></span>
<label>Intrested In</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="budget" class="form-text mask-clear-if-not-match" required>
<span class="bar"></span>
<label>Budget</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="high_lead" class="form-text mask-fallback" >
<span class="bar"></span>
<label>High Quality Lead</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="pref_loc" class="form-text mask-selectonfocus" required>
<span class="bar"></span>
<label>Location</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="look_for" class="form-text mask-selectonfocus" required>
<span class="bar"></span>
<label>Looking For</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="subject" class="form-text mask-selectonfocus" >
<span class="bar"></span>
<label>Subject</label>
</div>
<div class="form-group form-animate-text lms" style="margin-top:40px !important;">
<input type="text" name="other_detail" class="form-text mask-selectonfocus" >
<span class="bar"></span>
<label>Any Other Detail</label>
</div>
<input type="hidden" name="lead_code" value="<?php echo next_value_LeadCode($lead_code); ?>">
<div class="form-group">
<div class="col-lg-offset-2 col-lg-10">
<button class="btn btn-primary" type="submit" name="submit" value="submit">Add Lead</button>
</div>
</div>
</div>
</div>
</form>
</div>
<!--body wrapper end-->
<?php include('../template/footer.php');?>