Date Range Filter ajax datatable in php
/// ajaxfile.php
<?php
include 'database/admin_confi.php';
## Read value
$draw = $_POST['draw'];
$row = $_POST['start'];
$rowperpage = $_POST['length']; // Rows display per page
$columnIndex = $_POST['order'][0]['column']; // Column index
$columnName = $_POST['columns'][$columnIndex]['data']; // Column name
$columnSortOrder = $_POST['order'][0]['dir']; // asc or desc
$searchValue = mysqli_real_escape_string($conn,$_POST['search']['value']); // Search value
## Date search value
$searchByFromdate = mysqli_real_escape_string($conn,$_POST['searchByFromdate']);
$searchByTodate = mysqli_real_escape_string($conn,$_POST['searchByTodate']);
## Search
$searchQuery = " ";
if($searchValue != ''){
$searchQuery = " and (c_name like '%".$searchValue."%' or c_mobile like '%".$searchValue."%' or product_name like'%".$searchValue."%' ) ";
}
$userid=$_POST['userid'];
$leads_type=$_POST['leads_type'];
if($userid!='' && $leads_type!='' ){
$searchQuery = "AND bd_id='$userid' AND lead_type='$leads_type'";
}elseif($userid=='' && $leads_type!=''){
$searchQuery = "AND lead_type='$leads_type'";
}elseif($userid!='' && $leads_type==''){
$searchQuery = "AND bd_id='$userid'";
}
//if($leads_type!=''){
//}
// Date filter
if($searchByFromdate != '' && $searchByTodate != ''){
$searchQuery .= " and (update_data between '".$searchByFromdate."' and '".$searchByTodate."' ) ";
}
## Total number of records without filtering
$sel = mysqli_query($conn,"select count(*) as allcount from tbl_bd_leads");
$records = mysqli_fetch_assoc($sel);
$totalRecords = $records['allcount'];
## Total number of records with filtering
$sel = mysqli_query($conn,"select count(*) as allcount from tbl_bd_leads WHERE 1 ".$searchQuery);
$records = mysqli_fetch_assoc($sel);
$totalRecordwithFilter = $records['allcount'];
## Fetch records
$empQuery = "select * from tbl_bd_leads WHERE 1 ".$searchQuery." order by id DESC limit ".$row.",".$rowperpage;
$empRecords = mysqli_query($conn, $empQuery);
$data = array();
while ($row = mysqli_fetch_assoc($empRecords)) {
$lead_type=$row['lead_type'];
$bd_id1=mysqli_query($conn,"SELECT*FROM tbl_lead_type WHERE id='$lead_type'");
$fetch_leads=mysqli_fetch_array($bd_id1);
$leads_name=$fetch_leads['lead_name'];
$bd_ida=$row['bd_id'];
$bd_id_sql=mysqli_query($conn,"SELECT*FROM tbl_bd_users WHERE id='$bd_ida'");
$fetch_bd=mysqli_fetch_array($bd_id_sql);
$leadname= $fetch_bd['full_name'];
$lead_type=$row['lead_type'];
$url="<a href='view_leads.php?id=".$row['id']."'><button class='btn btn-primary'>Edit</button></a>";
$data[] = array(
"id"=>$row['id'],
"bd_id"=>$leadname,
"c_name"=>$row['c_name'],
"c_mobile"=>$row['c_mobile'],
"product_name"=>$row['product_name'],
"requirement"=>$row['requirement'],
"c_city"=>$row['c_city'],
"source_website"=>$row['source_website'],
"leads_souece_date"=>$row['leads_souece_date'],
"lead_type"=>$leads_name,
"url"=>$url,
);
}
## Response
$response = array(
"draw" => intval($draw),
"iTotalRecords" => $totalRecords,
"iTotalDisplayRecords" => $totalRecordwithFilter,
"aaData" => $data
);
echo json_encode($response);
die;
<?php
//session_start();
session_start();
error_reporting(1);
if(empty($_SESSION['email'])){
header('Location:login.php');
}
include("database/admin_confi.php");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Welcome Admin </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
<meta content="Coderthemes" name="author" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- App favicon -->
<link rel="shortcut icon" href="https://coderthemes.com/ubold/layouts/assets/images/favicon.ico">
<!-- Bootstrap Tables css -->
<!-- plugin css -->
<link href="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.css" rel="stylesheet" type="text/css" />
<!-- App css -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" id="bs-default-stylesheet" />
<link href="assets/css/app.min.css" rel="stylesheet" type="text/css" id="app-default-stylesheet" />
<link href="assets/css/bootstrap-dark.min.css" rel="stylesheet" type="text/css" id="bs-dark-stylesheet" />
<link href="assets/css/app-dark.min.css" rel="stylesheet" type="text/css" id="app-dark-stylesheet" />
<!-- icons -->
<link href='//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css' rel='stylesheet' type='text/css'>
<!-- jQuery UI CSS -->
<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.css">
<!-- jQuery Library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<!-- jQuery UI JS -->
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
<!-- Datatable JS -->
<script src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<style>
.col-search-input {
margin-top: 10px;
display: block;
width: 100%;
}
.datatable-container
{
padding: 20px;
width:80%;
margin: 0 auto;
}
tfoot {
display: table-header-group;
}
table.dataTable tfoot th, table.dataTable tfoot td {
padding: 10px 5px 6px 10px;
}
.dataTables_wrapper .dataTables_paginate .paginate_button {
color: #0099cc !important;
padding: 0.4em 0.8em;
border: #eaeaea 1px solid;;
}
.dataTables_wrapper .dataTables_paginate .paginate_button:hover {
color: #0099cc !important;
border-color: #eaeaea !important;
background-color: #eaeaea !important;
background:unset;
}
.dataTables_wrapper .dataTables_paginate .paginate_button.current, .dataTables_wrapper .dataTables_paginate .paginate_button.current:hover {
color: #fff !important;
background: unset !important;
border: #0099cc 1px solid !important;
background-color: #0099cc !important;
cursor: default;
}
table.dataTable.row-border tbody th, table.dataTable.row-border tbody td, table.dataTable.display tbody th, table.dataTable.display tbody td {
border: 1px solid #ddd;
border-left: none;
border-top: none;
}
table.dataTable.stripe tbody tr.odd, table.dataTable.display tbody tr.odd {
background-color: #fff;
}
table.dataTable.display tbody tr.even>.sorting_1, table.dataTable.order-column.stripe tbody tr.even>.sorting_1 {
background-color: #f3f3f3;
}
table.dataTable.display tbody tr.odd>.sorting_1, table.dataTable.order-column.stripe tbody tr.odd>.sorting_1 {
background-color: #fff;
}
table.dataTable thead th, table.dataTable thead td {
border: 1px solid #ddd;
border-left: none;
}
table.dataTable.stripe tbody tr.even, table.dataTable.display tbody tr.even {
background-color: #f3f3f3;
}
.datatables_length{
padding-bottom: 15px;
}
table.dataTable{
border-left:1px solid #ddd;
}
.dataTables_wrapper select,.dataTables_wrapper input
{
border:1px solid #ddd;
padding:0.4em;
}
#tbl-contact_filter {
margin-bottom: 20px;
}
table.dataTable tfoot th, table.dataTable tfoot td {
border-top: none;
border-right: #e0e0e0 1px solid;
border-bottom: #e0e0e0 1px solid;
}
.table .thead-light th {
/* color: #fff; */
color: #ffffff;
background-color: #db2424;
}
</style>
<title>Column Search in DataTables using Server-side Processing</title>
</head>
<meta charset="utf-8" />
<title>Welcome Admin </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- App favicon -->
<!-- Bootstrap Tables css -->
<link href="assets/libs/bootstrap-table/bootstrap-table.min.css" rel="stylesheet" type="text/css" />
<!-- plugin css -->
<!-- App css -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" id="bs-default-stylesheet" />
<link href="assets/css/app.min.css" rel="stylesheet" type="text/css" id="app-default-stylesheet" />
<link href="assets/css/bootstrap-dark.min.css" rel="stylesheet" type="text/css" id="bs-dark-stylesheet" />
<!-- icons -->
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
</head>
<body class="loading" data-layout-mode="horizontal" data-layout='{"mode": "light", "width": "fluid", "menuPosition": "fixed", "topbar": {"color": "dark"}, "showRightSidebarOnPageLoad": true}'>
<!-- Begin page -->
<div id="wrapper">
<!-- Topbar Start -->
<?php include('header.php');?>
<?php include('menu.php');?>
<!-- ============================================================== -->
<!-- Start Page Content here -->
<!-- ============================================================== -->
<div class="content-page">
<div class="content">
<!-- Start Content-->
<div class="container-fluid">
<!-- start page title -->
<div class="row">
<div class="col-12">
<div class="page-title-box">
<div class="page-title-right">
</div>
<h4 class="page-title">All Leads</h4>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-sm-12">
<div class="card-box" style="background:#fff;">
<?php
// $pp= "https://mapi.indiamart.com/wservce/enquiry/listing/GLUSR_MOBILE/7042445112/GLUSR_MOBILE_KEY/keynumber/Start_Time/12-JUL-2020/End_Time/18-JUL-2020/"
// print_r($pp);
//$homepage = file_get_contents('https://mapi.indiamart.com/wservce/enquiry/listing/GLUSR_MOBILE/7889028274/GLUSR_MOBILE_KEY/keynumber/Start_Time/31-JUL-2021/End_Time/2-SEP-2021/');
//echo $homepage;
//$myObject=json_decode($homepage);
// $myObjectMap = $myObject->MRData->RaceTable->Races;
//print_r($myObject);
//foreach ($data as $stand) {
//
//$myObject=json_decode($homepage);
//print_r($myObject);
//$myObjectMap = $myObject->MRData->RaceTable->Races;
?>
<?php// foreach($myObject as $item): ?>
<tr>
<td><?PHP// echo $item['name']; ?></td>
<td><?PHP //echo $item->email_id; ?></td>
<td><?PHP //echo $item->store_location; ?></td>
</tr>
<?php //endforeach; ?>
<?php// }
?>
<?php
// $connect = mysqli_connect("localhost", "root", "", "test"); //Connect PHP to MySQL Database
$users=mysqli_query($conn,"SELECT id FROM tbl_bd_users WHERE status=1");
while($fetch_users=mysqli_fetch_assoc($users)){
$users_data[]=$fetch_users;
}
$user_number=count($users_data);
//print_r($users_data);
date_default_timezone_set("Asia/Kolkata");
$datee1=date( 'd-m-Y');
$min=1;
$max=7;
$today_date=date('j-M-Y');
$your_date = date('j-M-Y', strtotime('-7 days'));
$today_date1=date('Y-m-d');
$your_date1 = date('Y-m-d', strtotime('-7 days'));
$userid= rand($min,$max);
$incoming_time = date('Y-m-d h:i a');
$query = '';
$table_data = '';
// $filename = "employee_data.json";
// $data1 = file_get_contents('https://mapi.indiamart.com/wservce/enquiry/listing/GLUSR_MOBILE/9216767741/GLUSR_MOBILE_KEY/keynumber/'); //Read the JSON file in PHP
$data_leads = file_get_contents('https://ad.scotbeauty.com/leadsaction.php'); //Read the JSON file in PHP
$array144 = json_decode($data_leads, true); //Convert JSON String into PHP Array
// print_r($array144);
foreach($array144 as $row144) //Extract the Array Values by using Foreach Loop
{
$emailid1= $row144["mobile"];
$msgg= $row144["message"];
$requirements= addslashes($msgg);
$reqiure=mysqli_escape_string($conn,$requirements);
$sqlww="SELECT c_mobile FROM tbl_bd_leads WHERE c_mobile='$emailid1' LIMIT 1";
$check_query1=mysqli_query($conn,$sqlww);
$count_email1=mysqli_num_rows($check_query1);
if($count_email1>0)
{
} else{
echo $queryff .= "INSERT INTO tbl_bd_leads(c_name, c_email, c_mobile,company_type,c_full_address,c_city,c_state,requirement,product_name,from_date,incoming_time,bd_id,company_id,source_website,leads_souece_date) VALUES ('".$row144["name"]."', '', '".$row144["mobile"]."','','','".$row144["city"]."','','$reqiure','','$datee1','$incoming_time','5','4','scotbeauty leads','".$row1["DATE_TIME_RE"]."'); "; // Make Multiple Insert Query
}
// $table_data .= '
// <tr>
// <td>'.$row["SENDERNAME"].'</td>
// <td>'.$row["SENDEREMAIL"].'</td>
// <td>'.$row["MOB"].'</td>
// </tr>
// '; //Data for display on Web page
// }
}
if(mysqli_multi_query($conn, $queryff)) //Run Mutliple Insert Query
{
$lastid= mysqli_insert_id($conn);
$url='<a href="view_leads.php?id='.$lastid.'" class="btn btn-primary">Edit</a>';
$update=mysqli_query($conn,"UPDATE tbl_bd_leads SET url='$url' WHERE id='$lastid'");
// echo '<h3>Imported JSON Data</h3><br />';
// echo '
// <table class="table table-bordered">
// <tr>
// <th width="45%">Name</th>
// <th width="10%">Gender</th>
// <th width="45%">Designation</th>
// </tr>
// ';
//echo $table_data;
// echo '</table>';
}
// $today_date1=date('Y-m-d');
// $your_date1 = date('Y-m-d', strtotime('-7 days'));
//$userid= rand($min,$max);
// $incoming_time = date('Y-m-d h:i a');
$data1ss = file_get_contents('https://www.tradeindia.com/utils/my_buy_leads.html?userid=5793812&profile_id=7751003&key=keynumber&from_date='.$your_date1.'&to_date='.$today_date1.'&limit=50&page_no=1'); //Read the JSON file in PHP
$array1ssss = json_decode($data1ss, true); //Convert JSON String into PHP Array
// echo "<pre>";
// print_r($array1ssss);
//echo "</pre>";
// die;
// $i=0;
$i=0;
foreach($array1ssss as $key => $row12) //Extract the Array Values by using Foreach Loop
{
$i++;
if($i==$user_number){
$i=0;
}
$userid= $users_data[$i]['id'];
$city= $row12['contact_details']['city'];
$address= $row12['contact_details']['address'];
$user_name= $row12['contact_details']['user_name'];
$pincode= $row12['contact_details']['pincode'];
$contact_number= $row12['contact_details']['contact_number'];
$state= $row12['contact_details']['state'];
$originalDate= $row12["posted_on"];
$datee = date("d-m-Y", strtotime($originalDate));
//$contact_number= $row12['contact_details']['contact_number'];
// $contact_number= $row12['contact_details']['contact_number'];
// for ($row = 0; $row < 20; $row++) {
// $i++;
// $frrr=$row12['contact_details'];
//echo $country_code= $array1ssss[$row];
// echo $city= $array1ssss[$row]["user_name"]."<br>";
// echo $user_name= $array1ssss[$row]["contact_number"]."<br>";
//echo $city= $array1ssss[1]["city"]."<br>";
/// $country_code= $array1ssss[0]["user_name"];
// $country_code= $array1ssss[0]["pincode"];
// echo $contact_number= $array1ssss[0]["country_code"]."<br>";
//$frrr=$row12['contact_details'];
// $myarray = array_shift($frrr);
// echo $myarray['country_code'];
// echo $frrr[0]['country_code'];
//print_r(array_column($frrr, 'country_code'));
//print_r($frrr);
// echo $frrr[0]['country_code'];
//echo $frrr[0]['pincode'];
// foreach ($frrr as $key => $value) {
// print_r($value);
// echo "<h4>$key => $value</h4>";
//}
//}
$emailid1= $row12["userid"];
$msgg= $row12["product_name"];
$description1=$row12["description"];
$description = str_replace( array( '\'', '"',
',' , ';', '<', '>' ), ' ', $description1);
$reqiure = str_replace( array( '\'', '"',
',' , ';', '<', '>' ), ' ', $msgg);
// $reqiure = preg_replace(array('/^\[/','/\]$/'), ' ',$msgg);
// die;
// $requirements= addslashes($msgg);
// $reqiure=mysqli_escape_string($conn,$requirements);
$sql="SELECT c_mobile FROM tbl_bd_leads WHERE c_mobile='$contact_number' LIMIT 1";
$check_query1=mysqli_query($conn,$sql);
$count_email1=mysqli_num_rows($check_query1);
if($count_email1>0)
{
} else{
$queryqqqq .= "INSERT INTO tbl_bd_leads(c_name, c_email, c_mobile,company_type,c_full_address,c_city,c_state,requirement,product_name,from_date,incoming_time,bd_id,company_id,source_website,leads_souece_date,user_id,QUERY_ID) VALUES ('$user_name', '', '$contact_number','".$row12["co_name"]."','$address','$city','$state','$reqiure','$description','$datee','$incoming_time','$userid','4','Tradeindia leads','".$row12["posted_on"]."','$emailid1','".$row12["lead_id"]."'); "; //lead_id Make Multiple Insert Query
}
// $table_data .= '
// <tr>
// <td>'.$row["SENDERNAME"].'</td>
// <td>'.$row["SENDEREMAIL"].'</td>
// <td>'.$row["MOB"].'</td>
// </tr>
// '; //Data for display on Web page
// }
//}
}
if(mysqli_multi_query($conn, $queryqqqq)) //Run Mutliple Insert Query
{
$lastid= mysqli_insert_id($conn);
$url='<a href="view_leads.php?id='.$lastid.'" class="btn btn-primary">Edit</a>';
$update=mysqli_query($conn,"UPDATE tbl_bd_leads SET url='$url' WHERE id='$lastid'");
// echo '<h3>Imported JSON Data</h3><br />';
// echo '
// <table class="table table-bordered">
// <tr>
// <th width="45%">Name</th>
// <th width="10%">Gender</th>
// <th width="45%">Designation</th>
// </tr>
// ';
//echo $table_data;
// echo '</table>';
}
///indiamart
$data1 = file_get_contents('https://mapi.indiamart.com/wservce/enquiry/listing/GLUSR_MOBILE/9216767741/GLUSR_MOBILE_KEY/Key/Start_Time/'.$your_date.'/End_Time/'.$today_date.'/'); //Read the JSON file in PHP
$array1 = json_decode($data1, true); //Convert JSON String into PHP Array
// print_r($array1);
$i=0;
foreach($array1 as $row1) //Extract the Array Values by using Foreach Loop
{
$i++;
if($i==$user_number){
$i=0;
}
$userid= $users_data[$i]['id'];
$originalDate= $row1["DATE_TIME_RE"] ;
$datee = date("d-m-Y", strtotime($originalDate));
$emailid1= $row1["SENDEREMAIL"];
$msgg= $row1["ENQ_MESSAGE"];
$requirements= addslashes($msgg);
$reqiure=mysqli_escape_string($conn,$requirements);
$sql="SELECT c_email FROM tbl_bd_leads WHERE c_email='$emailid1' LIMIT 1";
$check_query1=mysqli_query($conn,$sql);
$count_email1=mysqli_num_rows($check_query1);
if($count_email1>0)
{
} else{
$query .= "INSERT INTO tbl_bd_leads(c_name, c_email, c_mobile,company_type,c_full_address,c_city,c_state,requirement,product_name,from_date,incoming_time,bd_id,company_id,source_website,leads_souece_date,QUERY_ID) VALUES ('".$row1["SENDERNAME"]."', '".$row1["SENDEREMAIL"]."', '".$row1["MOB"]."','".$row1["GLUSR_USR_COMPANYNAME"]."','".$row1["ENQ_ADDRESS"]."','".$row1["ENQ_CITY"]."','".$row1["ENQ_STATE"]."','$reqiure','".$row1["PRODUCT_NAME"]."','$datee','$incoming_time','$userid','4','Pharmadrugs indiamart','".$row1["DATE_TIME_RE"]."','".$row1["QUERY_ID"]."'); "; // QUERY_ID Make Multiple Insert Query
}
// $table_data .= '
// <tr>
// <td>'.$row["SENDERNAME"].'</td>
// <td>'.$row["SENDEREMAIL"].'</td>
// <td>'.$row["MOB"].'</td>
// </tr>
// '; //Data for display on Web page
// }
}
if(mysqli_multi_query($conn, $query)) //Run Mutliple Insert Query
{
$lastid= mysqli_insert_id($conn);
$url='<a href="view_leads.php?id='.$lastid.'" class="btn btn-primary">Edit</a>';
$update=mysqli_query($conn,"UPDATE tbl_bd_leads SET url='$url' WHERE id='$lastid'");
// echo '<h3>Imported JSON Data</h3><br />';
// echo '
// <table class="table table-bordered">
// <tr>
// <th width="45%">Name</th>
// <th width="10%">Gender</th>
// <th width="45%">Designation</th>
// </tr>
// ';
//echo $table_data;
// echo '</table>';
}
$data = file_get_contents('https://mapi.indiamart.com/wservce/enquiry/listing/GLUSR_MOBILE/7889028274/GLUSR_MOBILE_KEY/keynumber/Start_Time/'.$your_date.'/End_Time/'.$today_date.'/'); //Read the JSON file in PHP
// $data = file_get_contents('https://mapi.indiamart.com/wservce/enquiry/listing/GLUSR_MOBILE/7889028274/GLUSR_MOBILE_KEY/keynumber/'); //Read the JSON file in PHP
$array = json_decode($data, true); //Convert JSON String into PHP Array
//print_r($array);
$i=0;
foreach($array as $row) //Extract the Array Values by using Foreach Loop
{
$i++;
if($i==$user_number){
$i=0;
}
$userid= $users_data[$i]['id'];
$emailid= $row["SENDEREMAIL"];
$msgg= $row["ENQ_MESSAGE"];
$originalDate= $row["DATE_TIME_RE"] ;
$datee = date("d-m-Y", strtotime($originalDate));
$requirements= addslashes($msgg);
$reqiure=mysqli_escape_string($conn,$requirements);
$sql="SELECT c_email FROM tbl_bd_leads WHERE c_email='$emailid' LIMIT 1";
$check_query=mysqli_query($conn,$sql);
$count_email=mysqli_num_rows($check_query);
if($count_email>0)
{
} else{
// if($uiddd==1){
$query1 .= "INSERT INTO tbl_bd_leads(c_name, c_email, c_mobile,company_type,c_full_address,c_city,c_state,requirement,product_name,from_date,incoming_time,bd_id,company_id,source_website,leads_souece_date,QUERY_ID) VALUES ('".$row["SENDERNAME"]."', '".$row["SENDEREMAIL"]."', '".$row["MOB"]."','".$row["GLUSR_USR_COMPANYNAME"]."','".$row["ENQ_ADDRESS"]."','".$row["ENQ_CITY"]."','".$row["ENQ_STATE"]."','$reqiure','".$row["PRODUCT_NAME"]."','$datee','$incoming_time','$userid','3','Scotbeauty indiamart','".$row["DATE_TIME_RE"]."','".$row["QUERY_ID"]."'); "; // Make QUERY_ID Multiple Insert Query
// }elseif($uiddd==2){
//
// }
}
// $table_data .= '
// <tr>
// <td>'.$row["SENDERNAME"].'</td>
// <td>'.$row["SENDEREMAIL"].'</td>
// <td>'.$row["MOB"].'</td>
// </tr>
// '; //Data for display on Web page
// }
}
if(mysqli_multi_query($conn, $query1)) //Run Mutliple Insert Query
{
$lastid= mysqli_insert_id($conn);
$url='<a href="view_leads.php?id='.$lastid.'" class="btn btn-primary">Edit</a>';
$update=mysqli_query($conn,"UPDATE tbl_bd_leads SET url='$url' WHERE id='$lastid'");
// echo '<h3>Imported JSON Data</h3><br />';
// echo '
// <table class="table table-bordered">
// <tr>
// <th width="45%">Name</th>
// <th width="10%">Gender</th>
// <th width="45%">Designation</th>
// </tr>
// ';
//echo $table_data;
// echo '</table>';
}
//echo $today_date=date('j-M-Y');
//echo $your_date = date('j-M-Y', strtotime('-7 days'));
//echo $datediff = $now - $your_date;
//echo $userid= rand($min,$max);
//echo round($datediff / (60 * 60 * 24));
?>
</tbody>
</table>
<?php
if(isset($_POST["submit"]) && $_POST["submit"]!="") {
$usersCount = count($_POST["manager"]);
for($i=0;$i<$usersCount;$i++) {
if(trim($_POST["manager"][$i] != ''))
{
$bdm_sal="UPDATE tbl_bd_leads set bd_id='" . $_POST["manager"][$i] . "' WHERE id='" . $_POST["customer_id"][$i] . "'";
mysqli_query($conn,$bdm_sal);
}
}
echo '<div class="alert alert-success alert-dismissible">
<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
<strong>Success!</strong> All Leads Updated.
</div>';
}
?>
<div >
<!-- Date Filter -->
<table>
<tr>
<td>
<input type='text' readonly id='search_fromdate' class="datepicker" placeholder='From date' style="padding: 2px!important;">
</td>
<td>
<input type='text' readonly id='search_todate' class="datepicker" placeholder='To date' style="padding: 2px!important;">
</td>
<td>
<select style="padding: 4px!important;" id="leads_type">
<option value="">--Select Leads Type--</option>
<?php
$sql_leads_type=mysqli_query($conn,"SELECT*FROM tbl_lead_type");
while($fetch_leads=mysqli_fetch_array($sql_leads_type)){
?>
<option value="<?=$fetch_leads['id'];?>"><?=$fetch_leads['lead_name'];?></option>
<?php } ?>
</select>
</td>
<td>
<select style="padding: 4px!important;" id="userid">
<option value="">--Select Users Type--</option>
<?php
$sql_users=mysqli_query($conn,"SELECT*FROM tbl_bd_users WHERE status='1'");
while($fetch_users=mysqli_fetch_array($sql_users)){
?>
<option value="<?=$fetch_users['id'];?>"><?=$fetch_users['full_name'];?></option>
<?php } ?>
</select>
</td>
<td>
<input type='button' id="btn_search" value="Search">
</td>
</tr>
</table>
<!-- Table -->
<table id='empTable' class='display dataTable' >
<thead class="thead-light" style="background: #d43837;
color: #fff;">
<tr>
<th> Sr. No</th>
<th> BD Name</th>
<th> Name</th>
<th>Mobile</th>
<th>City</th>
<th>source website</th>
<th>leads date</th>
<th>lead Type </th>
<th>Edit/Update </th>
</tr>
</thead>
</table>
</div>
</div> <!-- end card-box-->
</div> <!-- end col-->
</div>
<!-- end row -->
<!-- end row -->
<!-- end row -->
</div> <!-- container -->
</div> <!-- content -->
<!-- Footer Start -->
<?php include('footer.php');?>
<!-- end Footer -->
</div>
<!-- ============================================================== -->
<!-- End Page content -->
<!-- ============================================================== -->
</div>
<!-- END wrapper -->
<!-- Right Sidebar -->
<!-- /Right-bar -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<!-- Vendor js -->
<!-- Plugins js-->
<script src="assets/libs/jquery-sparkline/jquery.sparkline.min.js"></script>
<script src="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="assets/libs/admin-resources/jquery.vectormap/maps/jquery-jvectormap-world-mill-en.js"></script>
<!-- Init js -->
<!-- Dashboard 2 init -->
<script src="assets/js/pages/dashboard-2.init.js"></script>
<!-- App js -->
<script src="assets/js/app.min.js"></script>
<script>
$(document).ready(function(){
// Datapicker
$( ".datepicker" ).datepicker({
"dateFormat": "yy-mm-dd",
changeYear: true
});
// DataTable
var dataTable = $('#empTable').DataTable({
"processing": true,
"serverSide": true,
'serverMethod': 'post',
'searching': true, // Set false to Remove default Search Control
'ajax': {
'url':'ajaxfile.php',
'data': function(data){
// Read values
var from_date = $('#search_fromdate').val();
var to_date = $('#search_todate').val();
var leads_type=$('#leads_type').val();
var userid=$('#userid').val();
// Append to data
data.searchByFromdate = from_date;
data.searchByTodate = to_date;
data.leads_type=leads_type;
data.userid=userid;
}
},
'columns': [
{ data: 'id' },
{ data: 'bd_id' },
{ data: 'c_name' },
{ data: 'c_mobile' },
{ data: 'c_city' },
{ data: 'source_website' },
{ data: 'leads_souece_date' },
{ data: 'lead_type' },
{ data: 'url' },
]
});
// Search button
$('#btn_search').click(function(){
dataTable.draw();
});
});
</script>
</body>
<!-- Mirrored from coderthemes.com/ubold/layouts/default/layouts-horizontal.html by HTTrack Website Copier/3.x [XR&CO'2014], Wed, 25 Nov 2020 07:11:02 GMT -->
</html>
Comments
Post a Comment