| Server IP : 108.163.255.210 / Your IP : 52.14.148.63 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 include('../template/header.php');
$order_by= $_GET['order_by'];
$order_by2= $_GET['order_by2'];
if($order_by=='')
{
$order_by='lead_id';
}
if($order_by2==""){
$order_by2='ASC';
}
$_SESSION['order_by2']=$order_by2;
$_SESSION['sess_order_by']=$order_by;
//==================================select data================
//pagination
include('../includes/newPagers.php');
$Num_Records_Page = 25;
$PGobj = new PagerClass();
if($_REQUEST['page']==""){ $cp=1; }
else{ $cp=intval($_REQUEST['page']); }
$PGobj->setCurrentPage($cp);
$PGobj->SetCurpage($_SERVER['PHP_SELF']);
$columns="SELECT * ";
if($_SESSION['role_id']=='66'){
$listingsql=" FROM mstr_leads WHERE 1=1 and del_id !='1' and company_id ='".$_SESSION['company_id']."' and lead_status IN (1,4,5,7,8,9,12,13,14) and sales_tc = '".$_SESSION['user_id']."' and sales_by = '".$_SESSION['user_id']."'";
}else if($_SESSION['role_id']=='77'){
$listingsql=" FROM mstr_leads WHERE 1=1 and del_id !='1' and company_id ='".$_SESSION['company_id']."' and lead_status IN (1,4,5,7,8,9,12,13,14) and sales_tc = '".$_SESSION['user_id']."' and sales_to = '".$_SESSION['user_id']."'";
}else {
$listingsql=" FROM mstr_leads WHERE 1=1 and del_id !='1' and company_id ='".$_SESSION['company_id']."' and lead_status IN (1,4,5,7,8,9,12,13,14) and sales_tc = '".$_SESSION['user_id']."'";
}
//$listingsql=" FROM mstr_leads WHERE 1=1";
$reccnt = getSingleResult("SELECT COUNT(*) ".$listingsql);
$limit = $PGobj->MyPaging($reccnt,$Num_Records_Page);
$sql= $columns.$listingsql." order by $order_by $order_by2 ".$limit;
$result= executeQuery($sql);
$ModelRes= executeQuery($sql);
$ModelRes1= executeQuery($sql);
$ModelRes2= executeQuery($sql);
$ModelRes3= executeQuery($sql);
$ModelRes4= executeQuery($sql);
$ModelRes5= executeQuery($sql);
$no= mysql_num_rows($result);
?>
<script language="JavaScript">
function isValid(formRef)
{
for(var i=0;i<formRef.elements.length;i++)
{
if(formRef.elements[i].type == "checkbox")
{
formRef.elements[i].checked = formRef.cb1.checked
}
}
}
function doExportExcel()
{
form=document.getElementById('idOfForm');
//form.target='_blank';
var checkedVals = $('.chk:checkbox:checked').map(function() {
return this.value;
}).get();
var ids=checkedVals.join(",");
if(ids){
form.action='export.php';
form.submit();
}else{
alert("Please select atleast one lead");
}
}
</script>
<!-- page heading start-->
<div class="panel box-shadow-none content-header">
<div class="panel-body">
<div class="col-md-12">
<h3 class="animated fadeInLeft">Assigned Leads</h3>
<p class="animated fadeInDown">
Leads <span class="fa-angle-right fa"></span>Assigned Leads
</p>
</div>
</div>
</div>
<!-- page heading end-->
<!--body wrapper start-->
<?php include('../template/response.php');?>
<div class="col-md-12 top-20 padding-0">
<div class="col-md-12">
<div class="panel">
<div class="panel-heading"><h3> Leads List (<?php echo $reccnt;?>)</h3></div>
<?php //if(in_array("1", $action_menu)){ ?>
<div class="btn-group" style="margin:10px 0 0 8px;">
<button type="submit" id="export" name="export" class="btn btn-success" onclick="doExportExcel();">
Download Excel File <i class="fa fa-file-excel-o"></i>
</button>
</div>
<?php // } ?>
<div class="panel-body">
<div class="table-responsive">
<form method="post" action="assign_leads.php" name="form_frm" id="idOfForm">
<table id="dataTbl2" class="table table-striped table-bordered" width="100%" cellspacing="0">
<thead class="cf">
<tr>
<!--th class="sorting_disabled">
<div class="form-group form-animate-checkbox">
<input type="checkbox" class="checkbox" id="selectall" onClick="selectAll(this)">
</div>
</th-->
<th class="sorting_disabled">
<div class="form-group form-animate-checkbox">
<input type="checkbox" class="checkbox" name="cb1" onClick="isValid(this.form)">
</div>
</th>
<th>Sr no.</th>
<th>Lead Code</th>
<th>Project Name</th>
<!--th>User Role</th-->
<th>Name</th>
<th>Email</th>
<th>Mobile</th>
<th>Phone</th>
<th>Interested In</th>
<th>Budget</th>
<th>Lead Category</th>
<th>Lead Status</th>
<th>Action</th>
<th>History</th>
<?php if(in_array("400", $action_menu)){ ?><th>Status</th><?php } ?>
<?php if(in_array("20", $action_menu) || in_array("30", $action_menu)){ ?><th>Action</th><?php } ?>
</tr>
</thead>
<tbody>
<?php if($no>0){
$c=($cp*$Num_Records_Page)-$Num_Records_Page+1;
while($line=mysql_fetch_array($result)) {
?>
<tr <?php if(substr($line['follow_time'],0,10)!=date("d-m-Y") && $line['lead_status']=='4'){ echo 'class="hidden"'; } ?>>
<!--td>
<div class="form-group form-animate-checkbox">
<input name="l_ids[]" type="checkbox" value="< ?php echo $line['lead_id']?>" class="checkbox">
</div>
</td-->
<td>
<div class="form-group form-animate-checkbox">
<input type="checkbox" class="chk checkbox" name="u_ids[]" value="<?php echo $line['lead_id']?>">
</div>
</td>
<td><?php echo $c; ?></td>
<td><?php echo $line['lead_code']?></td>
<td><?php echo $line['project_name']?></td>
<!--td><?php /**
if($_SESSION['role_id']=='4'){
echo getUserName2($line['assign_to']); ?> - <b><?php echo getRoleByUser($line['assign_to']);
}else{
echo getUserName2($line['assign_tc']); ?> - <b><?php echo getRoleByUser($line['assign_tc']);
} **/
?></b></td-->
<td><?php echo $line['name']?></td>
<td><?php echo $line['email']?></td>
<td><?php echo $line['mobile']?></td>
<td><?php echo $line['phone']?></td>
<td><?php echo $line['interested']?></td>
<td><?php echo $line['budget']?></td>
<td> <div class="input-group-btn">
<button id="status<?php echo $line['lead_id']?>" type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> <?php if(!empty($line['lead_cat'])){ echo $line['lead_cat']; }else{ echo "Select"; }?> <span class="caret"></span></button>
<ul class="dropdown-menu" style="position:relative;min-width:auto;">
<li><a href="javascript:void(0)" onClick="changestatus('<?php echo 'h'; ?>',<?php echo $line['lead_id']?>)">HOT</a></li>
<li><a href="javascript:void(0)" onClick="changestatus('<?php echo 'w'; ?>',<?php echo $line['lead_id']?>)">WARM</a></li>
<li><a href="javascript:void(0)" onClick="changestatus('<?php echo 'c'; ?>',<?php echo $line['lead_id']?>)">COLD</a></li>
</ul>
</div><!-- /btn-group -->
</td>
<td><a class="btn <?php echo getLeadBtnStatus($line['lead_status']); ?>"><?php echo getLeadStatus($line['lead_status']); ?></a></td>
<td>
<div class="input-group-btn">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action <span class="caret"></span></button>
<ul class="dropdown-menu" style="position:relative;min-width:auto;">
<li><a href="#" data-toggle="modal" data-target="#my1Modal<?php echo $line['lead_id']; ?>">Meeting Scheduled</a></li>
<li><a href="#" data-toggle="modal" data-target="#my2Modal<?php echo $line['lead_id']; ?>">Follow Up</a></li>
<li><a href="#" data-toggle="modal" data-target="#my3Modal<?php echo $line['lead_id']; ?>">No Response</a></li>
<li><a href="#" data-toggle="modal" data-target="#my4Modal<?php echo $line['lead_id']; ?>">Not Reachable</a></li>
<li><a href="#" data-toggle="modal" data-target="#my5Modal<?php echo $line['lead_id']; ?>">Not Converted</a></li>
<li><a href="#" data-toggle="modal" data-target="#my6Modal<?php echo $line['lead_id']; ?>">Converted</a></li>
</ul>
</div><!-- /btn-group -->
</td>
<td>
<ul class="nav nav-tabs">
<li><a href="leads_history.php?id=<?php echo $line['lead_id']?>" class="tooltips edit-btn" data-placement="top" data-toggle="tooltip" data-original-title="History"><i class="fa fa-history"></i> </a></li>
</ul>
</td>
<?php if(in_array("200", $action_menu) || in_array("300", $action_menu)){ ?><td>
<ul class="action-links">
<?php if(in_array("20", $action_menu)){ ?><li><a href="edit_leads_form.php?id=<?php echo $line['lead_id']?>" class="tooltips edit-btn" data-placement="top" data-toggle="tooltip" data-original-title="Edit"><i class="fa fa-edit"></i> Edit</a></li><?php } ?>
<?php if(in_array("30", $action_menu)){ ?><li><a href="#" class="tooltips delete-btn" data-placement="top" data-toggle="tooltip" data-original-title="Delete" onClick="want_to_Delete_qt('<?php echo $line['lead_id']; ?>');"><i class="fa fa-trash-o"></i> Delete</a></li><?php } ?>
</ul></td>
<?php } ?>
</tr>
<?php $c++; } }else {?>
<tr>
<td colspan="12" style="margin:0px auto; text-align:center; color:#282828; font-size:14px; font-variant:small-caps; font-weight:bold;">
Your Leads List is Empty.</td>
</tr>
</p>
<?php }?>
</tbody>
</table>
<div class="col-md-6" style="padding-top:20px;">
<span><?php echo $PGobj->showEntries($no); ?></span>
</div>
<div class="col-md-6">
<?php echo $PGobj->showPagerContent(); ?>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<?php
while($model1=mysql_fetch_array($ModelRes1)) {
?>
<!-- Modal -->
<div class="modal fade" id="my1Modal<?php echo $model1['lead_id']?>" role="dialog">
<div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Meeting Scheduled </h4>
</div>
<div class="modal-body">
<form class="cmxform" id="signupForm" method="post" action="edit_assign_leads.php">
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<h4>Tentative Meeting Location</h4>
<select class="form-control" name="tml">
<option value="1">Client’s Office</option>
<option value="2">Client’s Residence</option>
<option value="3">Own Office</option>
<option value="4">Own residence</option>
<option value="5">On Site</option>
<option value="6">Common Location</option>
</select>
</div>
<div class="form-group form-animate-text">
<input type="text" class="form-text" name="met_loc" required>
<span class="bar"></span>
<label><span class="fa fa-map"></span> Meeting Location</label>
</div>
<div class="form-group form-animate-text">
<input type="text" class="form-text datetime" name="datetime" required>
<span class="bar"></span>
<label><span class="fa fa-calendar"></span> Date Time Picker</label>
</div>
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<textarea class="form-text" name="remarks" required></textarea>
<span class="bar"></span>
<label>Remarks *</label>
</div>
<input type="hidden" value="<?php echo $model1['lead_id']?>" name="leadid">
<input type="hidden" value="7" name="lead_status">
<input type="hidden" value="0" name="product">
<input type="hidden" value="<?php echo $cp; ?>" name="cpage">
<input type="hidden" value="<?php echo $model1['assign_by']?>" name="assign_by">
<input type="hidden" value="<?php echo $model1['assign_to']?>" name="assign_to">
<input type="hidden" value="<?php echo $model1['assign_tc']?>" name="assign_tc">
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-success" name="meeting">Submit</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<!--body wrapper end-->
<?php } ?>
<?php
while($model2=mysql_fetch_array($ModelRes2)) {
?>
<!-- Modal -->
<div class="modal fade" id="my2Modal<?php echo $model2['lead_id']?>" role="dialog">
<div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Lead Follow Up</h4>
</div>
<div class="modal-body">
<form class="cmxform" id="signupForm" method="post" action="edit_assign_leads.php">
<div class="form-group form-animate-text">
<input type="text" class="form-text datetime" name="datetime" required>
<span class="bar"></span>
<label><span class="fa fa-calendar"></span> Date Time Picker</label>
</div>
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<textarea class="form-text" name="remarks" required></textarea>
<span class="bar"></span>
<label>Remarks *</label>
</div>
<input type="hidden" value="<?php echo $model2['lead_id']?>" name="leadid">
<input type="hidden" value="4" name="lead_status">
<input type="hidden" value="<?php echo $cp; ?>" name="cpage">
<input type="hidden" value="<?php echo $model2['assign_by']?>" name="assign_by">
<input type="hidden" value="<?php echo $model2['assign_to']?>" name="assign_to">
<input type="hidden" value="<?php echo $model2['assign_tc']?>" name="assign_tc">
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-success" name="follow_up">Submit</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<!--body wrapper end-->
<?php } ?>
<?php
while($model3=mysql_fetch_array($ModelRes3)) {
?>
<!-- Modal -->
<div class="modal fade" id="my3Modal<?php echo $model3['lead_id']?>" role="dialog">
<div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">No Response </h4>
</div>
<div class="modal-body">
<form class="cmxform" id="signupForm" method="post" action="edit_assign_leads.php">
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<textarea class="form-text" name="remarks" required></textarea>
<span class="bar"></span>
<label>Remarks *</label>
</div>
<input type="hidden" value="<?php echo $model3['lead_id']?>" name="leadid">
<input type="hidden" value="8" name="lead_status">
<input type="hidden" value="0" name="product">
<input type="hidden" value="0" name="datetime">
<input type="hidden" value="<?php echo $cp; ?>" name="cpage">
<input type="hidden" value="<?php echo $model3['assign_by']?>" name="assign_by">
<input type="hidden" value="<?php echo $model3['assign_to']?>" name="assign_to">
<input type="hidden" value="<?php echo $model3['assign_tc']?>" name="assign_tc">
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-success" name="not_interested">Submit</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<?php } ?>
<?php
while($model4=mysql_fetch_array($ModelRes4)) {
?>
<!-- Modal -->
<div class="modal fade" id="my4Modal<?php echo $model4['lead_id']?>" role="dialog">
<div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Not Reachable </h4>
</div>
<div class="modal-body">
<form class="cmxform" id="signupForm" method="post" action="edit_assign_leads.php">
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<textarea class="form-text" name="remarks" required></textarea>
<span class="bar"></span>
<label>Remarks *</label>
</div>
<input type="hidden" value="<?php echo $model4['lead_id']?>" name="leadid">
<input type="hidden" value="9" name="lead_status">
<input type="hidden" value="0" name="product">
<input type="hidden" value="0" name="datetime">
<input type="hidden" value="<?php echo $cp; ?>" name="cpage">
<input type="hidden" value="<?php echo $model4['assign_by']?>" name="assign_by">
<input type="hidden" value="<?php echo $model4['assign_to']?>" name="assign_to">
<input type="hidden" value="<?php echo $model4['assign_tc']?>" name="assign_tc">
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-success" name="not_interested">Submit</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<!--body wrapper end-->
<?php } ?>
<?php
while($model5=mysql_fetch_array($ModelRes5)) {
?>
<!-- Modal -->
<div class="modal fade" id="my5Modal<?php echo $model5['lead_id']?>" role="dialog">
<div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Lead Not Converted </h4>
</div>
<div class="modal-body">
<form class="cmxform" id="signupForm" method="post" action="edit_assign_leads.php">
<input type="hidden" value="<?php echo $model5['lead_id']?>" name="leadid">
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<textarea class="form-text" name="remarks" required></textarea>
<span class="bar"></span>
<label>Remarks *</label>
</div>
<input type="hidden" value="10" name="lead_status">
<input type="hidden" value="0" name="datetime">
<input type="hidden" value="<?php echo $cp; ?>" name="cpage">
<input type="hidden" value="<?php echo $model5['assign_by']?>" name="assign_by">
<input type="hidden" value="<?php echo $model5['assign_to']?>" name="assign_to">
<input type="hidden" value="<?php echo $model5['assign_tc']?>" name="assign_tc">
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-success" name="interested">Submit</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<!--body wrapper end-->
<?php } ?>
<?php
while($model=mysql_fetch_array($ModelRes)) {
?>
<!-- Modal -->
<div class="modal fade" id="my6Modal<?php echo $model['lead_id']?>" role="dialog">
<div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Lead Converted </h4>
</div>
<div class="modal-body">
<form class="cmxform" id="signupForm" method="post" action="edit_assign_leads.php">
<input type="hidden" value="<?php echo $model['lead_id']?>" name="leadid">
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<select class="form-control" name="product">
<?php
$productRes= executeQuery("SELECT prod_id,prod_name FROM mstr_product where status='Active' and company_id ='".$_SESSION['company_id']."'");
while($row=mysql_fetch_array($productRes)) { ?>
<option value="<?php echo $row['prod_id']?>"><?php echo $row['prod_name']?></option>
<?php } ?>
</select>
</div>
<div class="form-group form-animate-text" style="margin-top:40px !important;">
<textarea class="form-text" name="remarks" required></textarea>
<span class="bar"></span>
<label>Remarks *</label>
</div>
<input type="hidden" value="11" name="lead_status">
<input type="hidden" value="0" name="datetime">
<input type="hidden" value="<?php echo $cp; ?>" name="cpage">
<input type="hidden" value="<?php echo $model['assign_by']?>" name="assign_by">
<input type="hidden" value="<?php echo $model['assign_to']?>" name="assign_to">
<input type="hidden" value="<?php echo $model['assign_tc']?>" name="assign_tc">
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-success" name="interested">Submit</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<!--body wrapper end-->
<?php } ?>
<?php include('../template/footer.php');?>
<script type="text/javascript">
function changestatus(status,leadid) {
var p_url= "postAjaxData.php";
jQuery.ajax({
type: "GET",
url: p_url,
//data: "status=" + status,
data: {id:leadid,status:status},
success: function(data) {
if(data == 'h'){
$('#status'+leadid).html('<a href="#" onClick="changestatus(\'h\')">Hot</a><span class="caret"></span>');
} else if(data == 'w'){
$('#status'+leadid).html('<a href="#" onClick="changestatus(\'w\')">Warm</a><span class="caret"></span>');
}else if(data == 'c'){
$('#status'+leadid).html('<a href="#" onClick="changestatus(\'c\')">Cold</a><span class="caret"></span>');
}
}
});
}
</script>