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">&times;</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

Popular posts from this blog

how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php

How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php

How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python