EVOLUTION-NINJA

Edit File: google_customer.php

<?php $this->load->view('includes/header'); ?>

<div class="content-wrapper">
       
       <div class="content-header">
      <div class="container-fluid">
      <div class="row mb-2">
        <div class="col-sm-6">
        </div>
        <div class="col-sm-6">
        <ol class="breadcrumb float-sm-right">
          <li class="breadcrumb-item"><a href="#">Customer</a></li>
          <li class="breadcrumb-item"> Google Customer </li>
        </ol>
        </div> 
      </div> 
      </div>
    </div>

<div id="todays_list">
          <div id ="todaysjaytab" style="margin-top:3%" class="grid ">
          <table id="list2"></table>
          <div id="pager2"></div>
          <div id="dialogSelectRow" title="Warning" style="display:none">
            <p>Please select row</p>
          </div>
          </div>
        </div>

</div>
      </div>
    </div>
  </div>

</div>
<script type="text/javascript">

$.ajax({
    type : 'post',
    url  : "<?php echo site_url('get-total-customer-count');?>", 
    success:function(response) {
      response=jQuery.parseJSON(response);
      console.log(response);
      if(response.result==1)
      {
      
        $('.todays_entry').html(response.message);
      }  
      else
      {
        $('.todays_entry').html('0');
      }

}
  });

$.ajax({
    type : 'post',
    url  : "<?php echo site_url('get-duplicate-customer-count');?>", 
    success:function(response) {
      response=jQuery.parseJSON(response);
      console.log(response);
      if(response.result==1)
      {
      
        $('.duplicate_entry').html(response.message);
      }  
      else
      {
        $('.duplicate_entry').html('0');
      }

}
  });

$(document).ready(function() {
  $("#phone_no_search" ).autocomplete({   
  source: '<?php echo site_url("auto-complete-phone-based-customer"); ?>',
  });
});

$(document).ready(function() {
  $("#phone_no_search_duplicate" ).autocomplete({   
  source: '<?php echo site_url("auto-complete-phone-based-duplicate-customer"); ?>',
  });
});

$('#phone_no_search').change(function()
{
    $('#todays_list').hide(); 
    $('#date_list').show();
    $('#month_list').hide();
    $('#year_list').hide();
    $('#all_list').hide();
    $('#duplicate_list').hide();
    //$('.duplicate_for_hide').hide();
    $('.show_duplicate_search').hide();
    $('#search_duplicate_list').hide();
    $('#phone_search_grid').show();

$('.submit_button').hide();
    $('.update_button').show();

var phone_no_search = $('#phone_no_search').val();
  $.ajax({
    
    type:'post',
    url:'<?php echo site_url('get-customer-details-based-phoneno');?>',
    data:{'phone_no_search':phone_no_search},
    success:function(response){
    response=jQuery.parseJSON(response)

if(response.result==1)
        {
         
          $('.customer_idss').val(response.message.id);
          $('.a_customer_name').val(response.message.name);
          $('.a_phone').val(response.message.phone);
          $('.a_email').val(response.message.email);
          $('.a_remarks').val(response.message.remarks);
          $('.a_ref_type').val(response.message.ref_type);
          $('.a_nri_no').val(response.message.nri_no);
          $('.a_dept_id').val(response.message.department_id);
          $('.a_dept_name').val(response.message.dept_name);
          $('.a_emp_name').val(response.message.employee_id);
          $('.site_idss').val(response.message.ref_site_number);
          $('.ref_person').val(response.message.ref_person);
          $('.enquiry_layout').val(response.message.enquiry_layout);
          $('.customer_id_for_update').val(response.message.id);
          $('.employee_name').val(response.message.ref_person);
        var con='';
        if (response.message.reference_type == 'Old Customer') 
        {
          con += '<label class="col-sm-4">Layout Name<span style="color:red"  ></span></label>';
          con += '<div class="col-sm-8 yes_form">';
          con += '<select type="text" class="form-control layout_list" name="layout_id">';
          con += '<option value="">Select</option>';
          $.each( response.layouts, function( key, value ) {
            if(value.id == response.message.ref_layout_id)
            {
              con+='<option value="'+value.id+'" selected>'+value.layout_name+'</option>';
            }
            else
            {
              con+='<option value="'+value.id+'" >'+value.layout_name+'</option>';
            }
          
            });
          con += '</select> ';  
          con += '</div> ';
         
          $('#leaves').empty();
          $('#leaves').append(con);

$.ajax({
                        
              type:'post',
              url:'<?php echo site_url('get-site-based-on-layout');?>',
              data:{'layout_id':response.message.ref_layout_id},
              success:function(response){
              response=jQuery.parseJSON(response)

if(response.result==1)
                  {
                      var site_idss = $('.site_idss').val();
                      var con1 = '';
                      con1 += '<label class="col-sm-4">Site No<span style="color:red"  ></span></label>';
                      con1 += '<div class="col-sm-8 yes_form">';
                      con1 += '<select type="text" class="form-control layout_list" name="site_id">';
                      con1 += '<option value="">Select</option>';
                      $.each( response.sites, function( key, value2 ) {
                        if(value2.id == site_idss)
                        {
                          con1+='<option value="'+value2.id+'" selected>'+value2.site_no+'</option>';
                        }
                        else
                        {
                          con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                        }
                      
                        });
                      con1 += '</select> ';  
                      con1 += '</div> ';
                     
                      $('#leaves1').empty();
                      $('#leaves1').append(con1);
                  }
                  else
                  {
                    $('#leaves1').empty();
                    toastr["error"](response.message);      
                  }
                }
            });

$.ajax({
      
              type:'post',
              url:'<?php echo site_url('get-customer-based-on-layout-site');?>',
              data:{'site_id':response.message.ref_site_number,'layout_id':response.message.ref_layout_id},
              success:function(response){
              response=jQuery.parseJSON(response)

if(response.result==1)
                  {
                    var ref_person = $('.ref_person').val();
                    var con2 = '';
                    con2 += '<label class="col-sm-4">Layout Name<span style="color:red"  ></span></label>';
                    con2 += '<div class="col-sm-8 yes_form">';
                    con2 += '<select type="text" class="form-control customer_id" name="customer_id">';
                    con2 += '<option value="">Select</option>';
                    $.each( response.customer, function( key, value3 ) {
                      if(value3.customer_id == ref_person)
                      {
                        con2+='<option value="'+value3.customer_id+'" selected>'+value3.name+'</option>';
                      }
                      else
                      {
                        con2+='<option value="'+value3.customer_id+'" >'+value3.name+'</option>';
                      }
                      
                      });
                    con2 += '</select> ';  
                    con2 += '</div> ';

$('#leaves2').empty();
                    $('#leaves2').append(con2);
                   
                  }
                  else
                  {
                    $('#leaves2').empty();
                    toastr["error"](response.message);      
                  }
              }
            });
        }
         
        }
        else
        {
           $('#edit_ref_person').empty();
          toastr["error"](response.message);      
        }
    }
  });

load_date_grid21();
      function load_date_grid21()
      {
         var phone_no_search = $('#phone_no_search').val();
          $("#list20").setGridParam(
          {
             url:"<?php echo site_url('get-customer-details-based-phoneno-list')?>/"+phone_no_search,  
            page:1
          }).trigger("reloadGrid");//Reload grid trigger
          $("#list20").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
      }

$("#list20").jqGrid({
      url:"<?php echo site_url('get-customer-details-based-phoneno-list')?>/"+phone_no_search,  
      mtype : "get",
      datatype: "json",
    colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time','Action','Duplicate Customer'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},
      /*  {name:'phone',index:'phone', width:100, hidden:false,editable:false},
        {name:'email',index:'email', width:200, hidden:false,editable:false},*/
        //{name:'nri_no',index:'nri_no',editable:false, width:200},
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
          {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = '  <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>   <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
            return retVal;
          }},
          {name:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = ' <button><a href="javascript:void(0);" onclick="duplicate_customer('+rowObject.id+');" class="" id="btn">Duplicate</button></a>';
            return retVal;
          }},
               ],
      rowNum:20,
      rowTotal: 2000,
      rowList : [20,30],
      rownumbers: true,
      //rownumWidth: 60,
      pager:"#pager20", 
      sortname:'id', 
      viewrecords: true,
      gridview: true,
      autowidth: true,
      sortorder:"asc",
      shrinkToFit: true,
      loadonce:true,
      autoencode: true,
      caption:"Customer List",
      //Subgrid1...
      subGrid: false,
    });
      $("#list20").jqGrid("setLabel", "rn", "SL");
      $("#list20").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
      $("#list20").jqGrid('navGrid','#pager20',
        {edit:false,add:false,del:false,search:true,refreshstate:"current"},
        { },
        { },
        { }, 
        {
        sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
        closeOnEscape: true, 
        multipleSearch: true, 
        closeAfterSearch: true,
        closeAfterDelete:true,
        closeAfterEdit:true
        },
      );
});

function planningtypes(str)
{       
   if(str=="today_list")
    {  
      $('#todays_list').show(); 
      $('#date_list').hide();
      $('#month_list').hide();
      $('#year_list').hide();
      $('#all_list').hide();
      $('#duplicate_list').hide();
      $('.duplicate_for_hide').show();
      $('.show_duplicate_search').hide();
      $('#search_duplicate_list').hide();
      $('#phone_search_grid').hide();

}
   else if(str=="dates_list")
    {
      $("#datelist1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      $('#todays_list').hide(); 
      $('#date_list').show();
      $('#month_list').hide();
      $('#year_list').hide();
      $('#all_list').hide();
      $('#duplicate_list').hide();
      $('.duplicate_for_hide').show();
      $('.show_duplicate_search').hide();
      $('#search_duplicate_list').hide();
      $('#phone_search_grid').hide();
    }
     else if(str=="months_list")
    {
      $("#monthlist2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
       $('#todays_list').hide(); 
      $('#date_list').hide();
      $('#month_list').show();
      $('#year_list').hide();
      $('#all_list').hide();
      $('#duplicate_list').hide();
      $('.duplicate_for_hide').show();
      $('.show_duplicate_search').hide();
      $('#search_duplicate_list').hide();
      $('#phone_search_grid').hide();
    }
     else if(str=="years_list")
    {
      $("#yearlist3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
       $('#todays_list').hide(); 
      $('#date_list').hide();
      $('#month_list').hide();
      $('#year_list').show();
      $('#all_list').hide();
      $('#duplicate_list').hide();
      $('.duplicate_for_hide').show();
      $('.show_duplicate_search').hide();
      $('#search_duplicate_list').hide();
      $('#phone_search_grid').hide();
    }
    else if(str=="alls_list")
    {
      $("#list0").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
       $('#todays_list').hide(); 
      $('#date_list').hide();
      $('#month_list').hide();
      $('#year_list').hide();
      $('#all_list').show();
      $('#duplicate_list').hide();
      $('.duplicate_for_hide').show();
      $('.show_duplicate_search').hide();
      $('#search_duplicate_list').hide();
      $('#phone_search_grid').hide();
    }
    else if(str=="duplicate_customer")
    {
      $("#duplicatelist3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
       $('#todays_list').hide(); 
      $('#date_list').hide();
      $('#month_list').hide();
      $('#year_list').hide();
      $('#all_list').hide();
      $('#duplicate_list').show();
      $('.duplicate_for_hide').show();
      $('.show_duplicate_search').hide();
       $('#search_duplicate_list').hide();
       $('#phone_search_grid').hide();
    }
    else if(str=="search_duplicate_customer")
    {
      
        $("#list8").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
        $('#todays_list').hide(); 
        $('#date_list').hide();
        $('#month_list').hide();
        $('#year_list').hide();
        $('#all_list').hide();
        $('#duplicate_list').hide();
        $('#search_duplicate_list').show();
        $('.duplicate_for_hide').hide();
        $('.show_duplicate_search').show();
        $('#phone_search_grid').hide();
        
    }
  }
  CallGrid();

function CallGrid()
{
  $('#all_list').hide();
  jQuery("#list2").jqGrid({

url:"<?php echo site_url('get-customer-today-list')?>",  
    mtype : "get",   
    datatype: "json", 
    colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created_time','Action'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},
      /*  {name:'phone',index:'phone', width:100, hidden:false,editable:false},
        {name:'email',index:'email', width:200, hidden:false,editable:false},*/
        //{name:'nri_no',index:'nri_no',editable:false, width:200},
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
        {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
                    var retVal = "";
                      var retVal = '  <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>   <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
                      return retVal;
              }},
             
           ],

rowNum:20,
          rowTotal: 2000,
          rowList : [20,30,100,200,500,1000],
          rownumbers: true,
          //rownumWidth: 60,
          pager:"#pager2", 
          sortname:'id', 
          viewrecords: true,
          gridview: true,
          autowidth: true,
          sortorder:"asc",
          shrinkToFit: true,
          loadonce:true,
          autoencode: true,
         caption:"Google Customer List",
      //Subgrid1...
        subGrid: false,

});

$("#list2").jqGrid("setLabel", "rn", "SL");
    $("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list2").jqGrid('navGrid','#pager2',
      {edit:false,add:false,del:false,search:false,refreshstate:"current"},
      { },
          { },
          { }, 
      {
          sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
            closeOnEscape: true, 
              multipleSearch: true, 
              closeAfterSearch: true,
              closeAfterDelete:true,
              closeAfterEdit:true
               },

);
}

$('input[name=optradio]').change(function()
  {
    var value = $(this).val();

$('.from_to_date').empty();
    $('.months').empty();
    $('.years').empty();
    $('.filter_submit').empty();

if(value == 'date')
    {

$('.from_to_date').empty();
      var content = '';
      content += '<div class="row" style="padding-top: 30px;">';
      content += '<div class="col-sm-2">';
      content += '<div class="form-group">';
      content += '<center><label>From Date</label> </center>';            
      content += '</div>';
      content += '</div>';
      content += '<div class="col-sm-4">';
      content += '<div class="form-group">';
      content += '<input type="text" name="from_date" class="form-control from_date from_datepicker">';
      content += '</div> ';
      content += '</div>';

content += '<div class="col-sm-2">';
      content += '<div class="form-group">';
      content += '<center><label >To Date</label></center>';
      content += '</div> ';
      content += '</div>';
      content += '<div class="col-sm-4">';
      content += '<div class="form-group">';
      content += '<input type="text" name="to_date" class="form-control to_date from_datepicker">';
      content += '</div>';
      content += '</div> ';
      content += '</div>';
      $('.from_to_date').append(content);
   var content1 = '';
    content1 += '<div class="form-group">';
    content1 += '<div class="col-sm-6">';
    content1 += '<button type="submit" id="btn" class="btn btn-primary  center-block">Submit</button>';
    content1 += '</div>';
    content1 += '</div>';

$('.filter_submit').append(content1);

$(function(){
      $(".from_datepicker").datepicker({
          dateFormat: 'dd-mm-yy',
        }).on('changeDate', function(ev){
          $('.to_datepicker').datepicker('hide');
        });
      });

$('.from_datepicker').on('change', function(){
          var date = $(this).val();
          $('.to_datepicker').datepicker({
            dateFormat: 'dd-mm-yy',
            minDate: date,
          });  
      });
    }
    else if(value == 'month')
    {
      $('.months').empty();
      var content = '';

content += '<div class="row" style="padding-top: 30px;">';
      content += '<div class="col-sm-2">';
      content += '<center><label>Months</label></center>';
      content += '</div>';
      content += '<div class="col-sm-4">';
      content += '<div class="form-group">';
      content += '<select class="form-control col-sm-8 month" id="months" name="months">';
      content += '<option value="">Select</option>';
      content += '<option value="01">January</option>';
      content += '<option value="02">Febraury</option>';
      content += '<option value="03">March</option>';
      content += '<option value="04">April</option>';
      content += '<option value="05">May</option>';
      content += '<option value="06">June</option>';
      content += '<option value="07">July</option>';
      content += '<option value="08">August</option>';
      content += '<option value="09">September</option>';
      content += '<option value="10">October</option>';
      content += '<option value="11">November</option>';
      content += '<option value="12">December</option>';
      content += '</select>';
      content += '</div>';
      content += '</div>';
      content += '</div>';

var content1 = '';
    content1 += '<div class="form-group">';
    content1 += '<div class="col-sm-6">';
    content1 += '<button type="submit" id="btn" class="btn btn-primary  center-block">Submit</button>';
    content1 += '</div>';
    content1 += '</div>';

$('.filter_submit').append(content1);
      $('.months').append(content);
    }
    else if(value == 'year')
    {
      $('.years').empty();
      var content = '';
      content += '<div class="row" style="padding-top: 30px;">';
      content += '<div class="col-sm-2">';
      content += '<center><label>Year</label></center>';
      content += '</div>';
      content += '<div class="col-sm-4">';
      content += '<div class="form-group">';
      content += '<input type="text" name="year" class="form-control year" id="datetimepicker1" >';
      content += '</div>';
      content += '</div>';
      content += '</div>';
      $('.years').append(content);
    var content1 = '';
    content1 += '<div class="form-group">';
    content1 += '<div class="col-sm-6">';
    content1 += '<button type="submit" id="btn" class="btn btn-primary  center-block">Submit</button>';
    content1 += '</div>';
    content1 += '</div>';
    $('.filter_submit').append(content1);
      $('#datetimepicker1').datetimepicker({
        format      :   "YYYY",
        //viewMode    :   "years", 
      });
      
    }
/*
    var content = '';
    content += '<div class="form-group">';
    content += '<div class="col-sm-6">';
    content += '<button type="submit" id="btn" class="btn btn-primary  center-block">Submit</button>';
    content += '</div>';
    content += '</div>';

$('.filter_submit').append(content);*/

});

$('.filter_choice_submit').submit(function(e)
  {
     e.preventDefault();
    var type = $('input[name=optradio]:checked').val();
    
    
    if(type == 'date')
    {
      load_date_grid();
      function load_date_grid()
      {
          var from_date = $(".from_date").val();
          var to_date = $(".to_date").val();
          $("#datelist1").setGridParam(
          {
            url:"<?php echo site_url('get-datewise-customer-list')?>?from_date="+from_date+"&&to_date="+to_date,
            page:1
          }).trigger("reloadGrid");//Reload grid trigger
          $("#datelist1").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
      }
      var from_date = $(".from_date").val();
      var to_date = $(".to_date").val();
      $("#datelist1").jqGrid({
        url:"<?php echo site_url('get-datewise-customer-list')?>?from_date="+from_date+"&to_date="+to_date,  
        mtype : "get",   
        datatype: "json", 
        colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created Time','Created By'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},
      /*  {name:'phone',index:'phone', width:100, hidden:false,editable:false},
        {name:'email',index:'email', width:200, hidden:false,editable:false},*/
        //{name:'nri_no',index:'nri_no',editable:false, width:200},
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
         /* {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = '<a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
            return retVal;
          }},*/
       ],

rowNum:20,
        rowTotal: 2000,
        rowList : [20,30,100,200,500,1000],
        rownumbers: true,
        //rownumWidth: 60,
        pager:"#datepager1", 
        sortname:'id', 
        viewrecords: true,
        gridview: true,
        autowidth: true,
        sortorder:"asc",
        shrinkToFit: true,
        loadonce:true,
        autoencode: true,
        caption:"Customer List",
        //Subgrid1...
        subGrid: false,

});

$("#list2").jqGrid("setLabel", "rn", "SL");
      $("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list2").jqGrid('navGrid','#pager2',
        {edit:false,add:false,del:false,search:false,refreshstate:"current"},
        { },
            { },
            { }, 
        {
            sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
              closeOnEscape: true, 
                multipleSearch: true, 
                closeAfterSearch: true,
                closeAfterDelete:true,
                closeAfterEdit:true
                 },

);

}
    else if(type == 'month')
    {
      load_month_grid();
      function load_month_grid()
      {
          var month = $(".month").val();
          $("#monthlist2").setGridParam(
          {
           url:"<?php echo site_url('get-monthwise-customer-list')?>?month="+month,
            page:1
          }).trigger("reloadGrid");//Reload grid trigger
          $("#monthlist2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
      }
      var month = $(".month").val();
      $("#monthlist2").jqGrid({
        url:"<?php echo site_url('get-monthwise-customer-list')?>?month="+month,
        mtype : "get",   
        datatype: "json", 
        colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created Time','Created By'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},
      /*  {name:'phone',index:'phone', width:100, hidden:false,editable:false},
        {name:'email',index:'email', width:200, hidden:false,editable:false},*/
        //{name:'nri_no',index:'nri_no',editable:false, width:200},
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
          /*{name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = '  <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>   <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
            return retVal;
          }},*/
       ],

rowNum:20,
        rowTotal: 2000,
        rowList : [20,30],
        rownumbers: true,
        //rownumWidth: 60,
        pager:"#monthpager2", 
        sortname:'id', 
        viewrecords: true,
        gridview: true,
        autowidth: true,
        sortorder:"asc",
        shrinkToFit: true,
        loadonce:true,
        autoencode: true,
        caption:"Customer List",
        //Subgrid1...
        subGrid: false,

});
       $("#list2").jqGrid("setLabel", "rn", "SL");
      $("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list2").jqGrid('navGrid','#pager2',
        {edit:false,add:false,del:false,search:false,refreshstate:"current"},
        { },
            { },
            { }, 
        {
            sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
              closeOnEscape: true, 
                multipleSearch: true, 
                closeAfterSearch: true,
                closeAfterDelete:true,
                closeAfterEdit:true
                 },

);
    }
    else 
    {
      load_year_grid();
      function load_year_grid()
      {
          var year = $(".year").val();
          $("#yearlist3").setGridParam(
          {
           url:"<?php echo site_url('get-yearwise-customer-list')?>?year="+year,
            page:1
          }).trigger("reloadGrid");//Reload grid trigger
          $("#yearlist3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
      }
      var year = $(".year").val();
      $("#yearlist3").jqGrid({
        url:"<?php echo site_url('get-yearwise-customer-list')?>?year="+year,
        mtype : "get",   
        datatype: "json", 
        colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created Time','Created By'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},
      /*  {name:'phone',index:'phone', width:100, hidden:false,editable:false},
        {name:'email',index:'email', width:200, hidden:false,editable:false},*/
       // {name:'nri_no',index:'nri_no',editable:false, width:200},
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
         {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
         /* {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = '  <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>   <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
            return retVal;
          }},*/
       ],

rowNum:20,
        rowTotal: 2000,
        rowList : [20,30,100,200,500,1000],
        rownumbers: true,
        //rownumWidth: 60,
        pager:"#yearpager2", 
        sortname:'id', 
        viewrecords: true,
        gridview: true,
        autowidth: true,
        sortorder:"asc",
        shrinkToFit: true,
        loadonce:true,
        autoencode: true,
        caption:"Customer List",
        //Subgrid1...
        subGrid: false,

});
        $("#list0").jqGrid("setLabel", "rn", "SL");
      $("#list0").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list0").jqGrid('navGrid','#pager2',
        {edit:false,add:false,del:false,search:false,refreshstate:"current"},
        { },
        { },
        { }, 
        {
        sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
        closeOnEscape: true, 
        multipleSearch: true, 
        closeAfterSearch: true,
        closeAfterDelete:true,
        closeAfterEdit:true
        },
      );

}
    
});
$("#list0").jqGrid({
    url:"<?php echo site_url('get-customer-list')?>",   
    mtype : "get",   
    datatype: "json", 
    colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time','Action','Duplicate Customer'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},
      /*  {name:'phone',index:'phone', width:100, hidden:false,editable:false},
        {name:'email',index:'email', width:200, hidden:false,editable:false},*/
        //{name:'nri_no',index:'nri_no',editable:false, width:200},
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
          {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = '  <a onclick="edit_customer('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>   <a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
            return retVal;
          }},
          {name:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = ' <button><a href="javascript:void(0);" onclick="duplicate_customer('+rowObject.id+');" class="" id="btn">Duplicate</button></a>';
            return retVal;
          }},
       ],
    rowNum:50,
    rowTotal: 2000,
    rowList : [20,30,100,200,500,1000],
    rownumbers: true,
    //rownumWidth: 60,
    pager:"#pager0", 
    sortname:'id', 
    viewrecords: true,
    gridview: true,
    autowidth: true,
    sortorder:"asc",
    shrinkToFit: true,
    loadonce:true,
    autoencode: true,
    caption:"Customer List",
    //Subgrid1...
    subGrid: false,
  });

$("#list0").jqGrid("setLabel", "rn", "SL");
    $("#list0").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list0").jqGrid('navGrid','#pager2',
      {edit:false,add:false,del:false,search:false,refreshstate:"current"},
      { },
      { },
      { }, 
      {
      sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
      closeOnEscape: true, 
      multipleSearch: true, 
      closeAfterSearch: true,
      closeAfterDelete:true,
      closeAfterEdit:true
      },
    );

<?php $role_id   =$this->session->userdata('role_id'); if($role_id == 1){?>

$("#duplicatelist3").jqGrid({
    url:"<?php echo site_url('get-duplicate-customer-list')?>",   
    mtype : "get",   
    datatype: "json", 
    colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time','Action'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},    
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
          {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = '<a onclick="delete_customer('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
            return retVal;
          }},
       ],
    rowNum:50,
    rowTotal: 2000,
    rowList : [20,30,100,200,500,1000],
    rownumbers: true,
    //rownumWidth: 60,
    pager:"#duplicatepager3", 
    sortname:'id', 
    viewrecords: true,
    gridview: true,
    autowidth: true,
    sortorder:"asc",
    shrinkToFit: true,
    loadonce:true,
    autoencode: true,
    caption:"Duplicate Customer List",
    //Subgrid1...
    subGrid: false,
  });

$("#duplicatelist3").jqGrid("setLabel", "rn", "SL");
    $("#duplicatelist3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#duplicatelist3").jqGrid('navGrid','#duplicatepager3',
      {edit:false,add:false,del:false,search:false,refreshstate:"current"},
      { },
      { },
      { }, 
      {
      sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
      closeOnEscape: true, 
      multipleSearch: true, 
      closeAfterSearch: true,
      closeAfterDelete:true,
      closeAfterEdit:true
      },
    );
  <?php } else { ?>

$("#duplicatelist3").jqGrid({
    url:"<?php echo site_url('get-duplicate-customer-list')?>",   
    mtype : "get",   
    datatype: "json", 
    colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time'],
    colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},    
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
         
       ],
    rowNum:50,
    rowTotal: 2000,
    rowList : [20,30,100,200,500,1000],
    rownumbers: true,
    //rownumWidth: 60,
    pager:"#duplicatepager3", 
    sortname:'id', 
    viewrecords: true,
    gridview: true,
    autowidth: true,
    sortorder:"asc",
    shrinkToFit: true,
    loadonce:true,
    autoencode: true,
    caption:"Duplicate Customer List",
    //Subgrid1...
    subGrid: false,
  });

$("#duplicatelist3").jqGrid("setLabel", "rn", "SL");
    $("#duplicatelist3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$('#phone_no_search_duplicate').change(function()
{
   
      load_date_grid_search();
      function load_date_grid_search()
      {
         var phone_no_search2 = $('#phone_no_search_duplicate').val();
          $("#searchlist").setGridParam(
          {
             url:"<?php echo site_url('get-phone-based-duplicate-customer')?>/"+phone_no_search2,  
            page:1
          }).trigger("reloadGrid");//Reload grid trigger
          $("#searchlist").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
      }

<?php $role_id   =$this->session->userdata('role_id'); if($role_id == 1){?>

$("#list8").jqGrid("setLabel", "rn", "SL");
      $("#list8").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list8").jqGrid('navGrid','#pager3',
        {edit:false,add:false,del:false,search:false,refreshstate:"current"},
        { },
        { },
        { }, 
        {
        sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
        closeOnEscape: true, 
        multipleSearch: true, 
        closeAfterSearch: true,
        closeAfterDelete:true,
        closeAfterEdit:true
        },
      );
    <?php } else { ?>

var phone_no_search2 = $('#phone_no_search_duplicate').val();
      $("#list8").jqGrid({
       url:"<?php echo site_url('get-phone-based-duplicate-customer')?>/"+phone_no_search2,  
      mtype : "get",   
      datatype: "json", 
      colNames:['id','Name','Reference Type','Referred By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Employee Name','Department Name','Created At','Created By','Created Time'],
      colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},    
        {name:'reference_type',index:'reference_type',editable:false, width:100},
        {name:'ref_person',index:'ref_person',editable:false, width:100},
        {name:'ref_layout',index:'ref_layout',editable:false, width:75},
        {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
        {name:'remarks',index:'remarks',editable:false, width:100},
        {name:'first_name',index:'first_name',editable:false, width:100},
        {name:'dept_name',index:'dept_name',editable:false, width:100},
        {name:'created',index:'created',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
        {name:'created_by',index:'created_by',editable:false, width:100},
        {name:'created_time',index:'created_time',editable:false, width:100},
         
           
         ],
      rowNum:50,
      rowTotal: 2000,
      rowList : [20,30,100,200,500,1000],
      rownumbers: true,
      //rownumWidth: 60,
      pager:"#pager3", 
      sortname:'id', 
      viewrecords: true,
      gridview: true,
      autowidth: true,
      sortorder:"asc",
      shrinkToFit: true,
      loadonce:true,
      autoencode: true,
      caption:"Duplicate Customer List",
      //Subgrid1...
      subGrid: false,
    });

$("#list8").jqGrid("setLabel", "rn", "SL");
      $("#list8").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

});

function duplicate_customer(id)
    {

$.ajax({
        type : 'post',
        url  : "<?php echo site_url('insert-duplicate-customer');?>",
        data : {'customer_id':id},
        success:function(response) {
          response=jQuery.parseJSON(response);
          console.log(response);
        if(response.result==1)
          {
            toastr["success"](response.message);      
            location.reload();
           }
           else{
             toastr["error"](response.message);       
           }
        }
      });   
    }

$('#add_customer').submit(function(e){  
  e.preventDefault();
      formdata = new FormData($(this)[0]);
      swal({

title: "Are you sure?",
        text: "You want to Save this?",
        type: "warning",   showCancelButton: true,
        confirmButtonColor: "#DD6B55",
        confirmButtonText: "Yes!",
        cancelButtonText: "No, cancel plz!",
        closeOnConfirm: false,
        closeOnCancel: false 
        },
      function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
        $(".sweet-overlay").hide();
      
            $.ajax({
                type : 'post',
                url  : "<?php echo site_url('insert-customer');?>",
                data : formdata,
                contentType: false,
                processData: false,
                success:function(response) {
                  response=jQuery.parseJSON(response);
                  console.log(response);
                  if(response.result==1)
                  {
                    toastr["success"](response.message);
                    setTimeout(1000);
                    location.reload();
                  } 
                  else
                  {
                    toastr["error"](response.message);
                  }

}
            });
        } 
        else 
        {
          $(".sweet-alert").hide();
          $(".sweet-overlay").hide();
        }
      });
});

function delete_customer(id)
{
    swal({

title: "Are you sure?",
    text: "You will not be able to recover this customer data !",
    type: "warning",   showCancelButton: true,
    confirmButtonColor: "#DD6B55",
    confirmButtonText: "Yes, delete it!",
    cancelButtonText: "No, cancel plz!",
    closeOnConfirm: false,
    closeOnCancel: false 
    },
    function(isConfirm){

if (isConfirm) 
        { 
            $(".sweet-alert").hide();
            $(".sweet-overlay").hide();
            $.ajax({
        type : 'post',
        url  : "<?php echo site_url('delete-customer-details');?>",
        data : {'customer_id':id},
        success:function(response) {
          response=jQuery.parseJSON(response);
          console.log(response);
          if(response.result==1)
          {

toastr["success"](response.message);
            $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
            location.reload();
          }

}
        });

} 
        else 
        {
      $(".sweet-alert").hide();
            $(".sweet-overlay").hide();
        }
  });
       
}

$('.import_data').submit(function(e){
    e.preventDefault();

$(".submit1").attr('disabled', 'disabled');
    $(".submit1").text("Uploading...");

formdata = new FormData($(this)[0]);
      $.ajax({
          type   : 'post',
          url    : '<?php echo site_url('Customer-Info-Import');?>',
          data   : formdata,
          contentType: false,
          processData: false,                          
            success:function(response){
            response=jQuery.parseJSON(response);
            console.log(response);
            if(response.result==1)
              {
                //alert();
                $('.import_data')[0].reset();
                $(".submit1").text("Upload");
                $("#impcustomer").modal("hide");
                toastr["success"](response.message);
                  setTimeout(function wait(){
                    window.location = '<?php echo site_url("add-customer")?>';
                  }, 1000);
              }                     
              else 
              {
                $('.import_data')[0].reset();
                 toastr["error"](response.message);      
                $(".submit1").text("Upload"); 
                $(".submit1").removeAttr('disabled');                      
              }
          }    
      });

});

function change_reference()
{

var select = $('.ref_type option:selected').text();
  if(select == "Old Customer")
  {
    $('.emp_dep_div').hide(); 
    $.ajax({
      type:'post',
      url:'<?php echo site_url('get-all-layout');?>',
      data:{'customer_id':select},
      success:function(response){
      response=jQuery.parseJSON(response);

if(response.result==1)
                {  
                  $('#edit_layout_id').show();
                  var con='';
                  if (select == 'Old Customer') 
                  {
                    
                   
                    con += '<label class="col-sm-4">Layout Name<span style="color:red"  ></span></label>';
                    con += '<div class="col-sm-8 yes_form">';
                  
                    con += '<select type="text" class="form-control layout_list" name="layout_id">';
                    con += '<option value="">Select</option>';
                    $.each( response.message, function( key, value ) {
                                con+='<option value="'+value.id+'" >'+value.layout_name+'</option>';
                                  });
                    con += '</select> ';  
                    con += '</div> ';
                  
                  $('#leaves').empty();
                  $('#leaves').append(con);
                  $('#edit_layout_id').empty();
                  $('#edit_layout_id').append(con);
                  $('.layout_list').change(function()
                  {
                      var id = $(this).val();
                      $('#layout_id').val(id);
                    
                      $.ajax({
                        
                        type:'post',
                        url:'<?php echo site_url('get-site-based-on-layout');?>',
                        data:{'layout_id':id},
                        success:function(response){
                        response=jQuery.parseJSON(response)

if(response.result==1)
                            {
                              
                              var con1 = '';
                                con1 += '<label class="col-sm-4">Site No<span style="color:red"  ></span></label>';
                                con1 += '<div class="col-sm-8">';
                              
                                con1 += '<select type="text" class="form-control site_list" name="site_id">';
                                con1 += '<option value="">Select</option>';
                                $.each( response.sites, function( key, value2 ) {
                                 
                                  con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                                  });
                                con1 += '</select> ';  
                                con1 += '</div> ';

$('#leaves1').empty();
                                $('#leaves1').append(con1);
                                $('#edit_site_id').empty();
                                $('#edit_site_id').append(con1);
                            }
                            else
                            {
                              $('#leaves1').empty();
                               $('#edit_site_id').empty();
                              toastr["error"](response.message);      
                            }
                      }
                      });
                     
                    });
                }
                else
                {
                   $('#leaves').empty();
                    $('#leaves1').empty();
                    $('#leaves2').empty();
                    $('#edit_layout_id').empty();
                    $('#edit_site_id').empty();
                    $('#edit_ref_person').empty();
                }

}
                
            }
    });
  }
  else if(select == "Staff")
  {
    $('.emp_dep_div').show(); 
     $('#leaves').empty();
     $('#leaves1').empty();
    $('#leaves2').empty()
  
  }
  else if(select == "Channel Partner")
  {
     $('.emp_dep_div').hide(); 
    $('#leaves1').empty();
    $('#leaves2').empty();
     $.ajax({
      
      type:'post',
      url:'<?php echo site_url('get-channel-partners-employee');?>',
      data:{'channel_partner':select},
      success:function(response){
      response=jQuery.parseJSON(response)

if(response.result==1)
          {
           
            var con = '';
              con += '<label class="col-sm-4">Refered Employee Name<span style="color:red"  ></span></label>';
              con += '<div class="col-sm-8">';

con += '<select type="text" class="form-control" name="refered_employee_id">';
              con += '<option value="">Select</option>';
               $.each( response.message, function( key, value2 ) 
              {              
                con+='<option value="'+value2.emp_id+'" >'+value2.first_name+'  '+value2.last_name+'</option>';           
              });
              con += '</select> ';  
              con += '</div> ';
                   
              $('#leaves').empty();
              $('#leaves1').empty();
              $('#leaves2').empty();
              $('#leaves').append(con);
           
          }
          else
          {
            $('#leaves1').empty();
            $('#leaves2').empty();
            $('#leaves').empty();
            toastr["error"](response.message);      
          }
      }
    });
  }

}

function edit_change_reference()
{

var select = $('.edit_ref_type option:selected').text();
  if(select == "Old Customer")
  {
    $('.employee_div').hide(); 
    $.ajax({
      type:'post',
      url:'<?php echo site_url('get-all-layout');?>',
      data:{'customer_id':select},
      success:function(response){
      response=jQuery.parseJSON(response);

if(response.result==1)
                {  
                  $('#edit_layout_id').show();
                  var con='';
                  if (select == 'Old Customer') 
                  {
                    
                   
                    con += '<label>Layout Name<span style="color:red"  ></span></label>';
                    con += '<select type="text" class="form-control layout_list" name="layout_id">';
                    con += '<option value="">Select</option>';
                    $.each( response.message, function( key, value ) {
                                con+='<option value="'+value.id+'" >'+value.layout_name+'</option>';
                                  });
                    con += '</select> ';  
                    con += '</div> ';
                  
                       
                
                  $('#edit_layout_id').empty();
                  $('#edit_layout_id').append(con);
                  $('.layout_list').change(function()
                  {
                      var id = $(this).val();
                      $('#layout_id').val(id);
                    
                      $.ajax({
                        
                        type:'post',
                        url:'<?php echo site_url('get-site-based-on-layout');?>',
                        data:{'layout_id':id},
                        success:function(response){
                        response=jQuery.parseJSON(response)

if(response.result==1)
                            {
                              
                              var con1 = '';
                                con1 += '<label>Site No<span style="color:red"  ></span></label>';                            
                                con1 += '<select type="text" class="form-control site_list" name="site_id">';
                                con1 += '<option value="">Select</option>';
                                $.each( response.sites, function( key, value2 ) {
                                 
                                  con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                                  });
                                con1 += '</select> ';  
                               
                                $('#edit_site_id').empty();
                                $('#edit_site_id').append(con1);
                            }
                            else
                            {
                             
                               $('#edit_site_id').empty();
                              toastr["error"](response.message);      
                            }
                      }
                      });
                     
                    });
                }
                else
                {
                   
                    $('#edit_layout_id').empty();
                    $('#edit_site_id').empty();
                    $('#edit_ref_person').empty();
                }

}
                
            }
        });
  }
  else if(select == "Staff")
  {
    $('.employee_div').show(); 
    $('#edit_layout_id').empty();
    $('#edit_site_id').empty();
    $('#edit_ref_person').empty();  
  }
  else if(select == "Channel Partner")
  {
      $('.employee_div').hide(); 
      $('#edit_layout_id').empty();
      $('#edit_site_id').empty();
      $('#edit_ref_person').empty();

$.ajax({      
      type:'post',
      url:'<?php echo site_url('get-channel-partners-employee');?>',
      data:{'channel_partner':select},
      success:function(response){
      response=jQuery.parseJSON(response)

if(response.result==1)
          {
           
            var con = '';
              con += '<label>Refered Employee Name</label>';

con += '<select type="text" class="form-control" name="refered_employee_id">';
              con += '<option value="">Select</option>';
               $.each( response.message, function( key, value2 ) 
              {              
                con+='<option value="'+value2.emp_id+'" >'+value2.first_name+'  '+value2.last_name+'</option>';           
              });
              con += '</select> ';  
                   
              $('#leaves').empty();
              $('#leaves1').empty();
              $('#leaves2').empty();
              $('#edit_layout_id').append(con);
           
          }
          else
          {
            $('#leaves1').empty();
            $('#leaves2').empty();
            $('#edit_layout_id').empty();
            toastr["error"](response.message);      
          }
      }
    });
  }

}

$(document).on('change','.site_list',function()
{
    var select = $('.ref_type option:selected').text();

var id = $(this).val();
    var layout_id = $('#layout_id').val();
  
    $.ajax({
      
      type:'post',
      url:'<?php echo site_url('get-customer-based-on-layout-site');?>',
      data:{'site_id':id,'layout_id':layout_id},
      success:function(response){
      response=jQuery.parseJSON(response)

if(response.result==1)
          {
           
            var con = '';

con += '<label class="col-sm-4">Customer Name<span style="color:red"  ></span></label>';
              con += '<div class="col-sm-8">';

con += '<select type="text" class="form-control customer_id" name="customer_id">';
              con += '<option value="">Select</option>';
               $.each( response.customer, function( key, value2 )
              {              
               con+='<option value="'+value2.customer_id+'" >'+value2.name+'</option>';   
              });
              con += '</select> ';  
              con += '</div> ';
              $('#leaves2').empty();
              $('#leaves2').append(con);
           
          }
          else
          {
             $('#leaves2').empty();
            toastr["error"](response.message);      
          }
      }
    });

});

$('.employee_name').change(function()
{
  var employee_name = $(this).val();
  $.ajax({
      type:'post',
      url:'<?php echo site_url('get-department-based-on-employee');?>',
      data:{'employee_name':employee_name},
      success:function(response){
      response=jQuery.parseJSON(response);

if(response.result==1)
      {

$('#department_name').empty();
        $('#department_id').empty();
        $('#department_name').val(response.message.dept_name);
        $('#department_id').val(response.message.id);
        $('.department_name').val(response.message.dept_name);
        $('.department_id').val(response.message.id);
            
       }
       else
       {
         $('#department_name').empty();
         $('.department_name').empty();
          toastr["error"](response.message);  
       }
      }
    });
});

function edit_customer(id)
{
    $.ajax({
    type : 'post',
    url  : "<?php echo site_url('edit-customer-details');?>",
    data : {'customer_id':id},
    success:function(response) {
      response=jQuery.parseJSON(response);
      console.log(response);
      if(response.result==1)
      {
        
        $('#edit_modal1').modal('show');
        $('#edit_layout_id').empty();
        $('#edit_site_id').empty();
        $('#edit_ref_person').empty();
        $('.customer_idss').val(response.message.id);
        $('.customer_name').val(response.message.name);
        $('.customer_phone').val(response.message.phone);
        $('.customer_email').val(response.message.email);
        $('.remarks').val(response.message.remarks);
        $('.edit_ref_type').val(response.message.ref_type);
        $('.nri_no').val(response.message.nri_no);
        $('.department_id').val(response.message.department_id);
        $('.department_name').val(response.message.dept_name);
        $('.employee_name').val(response.message.ref_person);
        $('.site_idss').val(response.message.ref_site_number);
        $('.ref_person').val(response.message.ref_person);
        $('.enquiry_layout_id').val(response.message.enquiry_layout);

if(response.result==1)
                  {
                      var site_idss = $('.site_idss').val();
                      var con1 = '';
                      con1 += '<label for="exampleInputUsername1">Site No</label>';
                      con1 += '<select type="text" class="form-control layout_list" name="site_id">';
                      con1 += '<option value="">Select</option>';
                      $.each( response.sites, function( key, value2 ) {
                        if(value2.id == site_idss)
                        {
                          con1+='<option value="'+value2.id+'" selected>'+value2.site_no+'</option>';
                        }
                        else
                        {
                          con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                        }
                      
                        });
                      con1 += '</select> ';  
                    
                     
                      $('#edit_site_id').empty();
                      $('#edit_site_id').append(con1);
                  }
                  else
                  {
                    $('#edit_site_id').empty();
                    toastr["error"](response.message);      
                  }
                }
            });

if(response.result==1)
                  {
                    var ref_person = $('.ref_person').val();
                    var con2 = '';
                    con2 += '<label for="exampleInputUsername1">Referred Person</label>';
                    con2 += '<select type="text" class="form-control customer_id" name="customer_id">';
                    con2 += '<option value="">Select</option>';
                    $.each( response.customer, function( key, value3 ) {
                      if(value3.customer_id == ref_person)
                      {
                        con2+='<option value="'+value3.customer_id+'" selected>'+value3.name+'</option>';
                      }
                      else
                      {
                        con2+='<option value="'+value3.customer_id+'" >'+value3.name+'</option>';
                      }
                      
                      });
                    con2 += '</select> ';

$('#edit_ref_person').empty();
                    $('#edit_ref_person').append(con2);
                   
                  }
                  else
                  {
                    $('#edit_ref_person').empty();
                    toastr["error"](response.message);      
                  }
              }
            });
        }
        else if (response.message.reference_type == 'Staff') 
        {
          $('.employee_div').show();
        }
      }

}
  });
  
}

$('.update_form').submit(function(e)
  {    
        e.preventDefault();

$("#loading").show();

formdata = new FormData($(this)[0]);

$(".update").attr('disabled', 'disabled');
        $(".update").text("Updating...");

$.ajax({

type   : 'post',
            url    : '<?php echo site_url("update-customer-details")?>',
            data   : formdata,
            contentType: false,
            processData: false,
                                      
              success:function(response){
              response=jQuery.parseJSON(response);
              console.log(response);

if(response.result==1)
                {
                  $("#edit_modal1").modal("hide");
                  toastr["success"](response.message);
                  $('.update_form')[0].reset();
                  $(".update").text("Submit");    
                  $(".update").removeAttr('disabled');   
                  location.reload();      
                }
                else if(response.result == 2)
                {
                  toastr["error"](response.message);                       
                  $(".update").text("Submit"); 
                  $(".update").removeAttr('disabled');                      
                }
                else 
                {
                  toastr["error"](response.message);                       
                  $(".update").text("Submit"); 
                  $(".update").removeAttr('disabled');                      
                }
               
            }
            
      });
             
    });

function delete_customer(id)
{
    swal({

toastr["success"](response.message);
            //$("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
            $("#list0").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                        $("#datelist1").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                        $("#monthlist2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                        $("#yearlist3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');

}
          else
          {
            toastr["error"](response.message);  
          }

}
        });

} 
        else 
        {
      $(".sweet-alert").hide();
            $(".sweet-overlay").hide();
        }
  });
       
}

</script>

.content-wrapper {
    max-width: 1460px !important;
}
.row-form {
  width:100%;
}
.form_submit label{
  padding-top: 20px;
}
 #ui-id-1{
  margin-left: 1128px;
  width: 190.859px;
  margin-top: 218px;

}
 #search{
  margin-right: 30px;
 }
</style>
      
<?php $this->load->view('includes/footer'); ?>