EVOLUTION-NINJA

Edit File: customer_site_visiting.php

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

<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"> Customer Customized Follow-Up </li>
        </ol>
        </div> 
      </div> 
      </div>
    </div>

<div class="row">
                <div class="col-sm-4">
            <div class="form-check-inline">
                <label class="form-check-label">
                  <input type="radio" checked="checked" class="form-check-input" id="todays" name="optradio" value="todays" onclick="planningtypes('All')">All
                </label>
              </div>
             
              <div class="form-check-inline">
                <label class="form-check-label">
                  <input type="radio" class="form-check-input" id="date" name="optradio" value="date" onclick="planningtypes('Expiry')">Expiry Customer
                </label>
              </div>
               <div class="form-check-inline">
                <label class="form-check-label">
                  <input type="radio" class="form-check-input" id="date" name="optradio" value="date" onclick="planningtypes('duplicate_customer')">Duplicate Customer </span>
                </label>
              </div>
            </div>
           <?php $department_id   =$this->session->userdata('dept_name'); if($department_id != "Channel Partner"){?>
            <div class="col-sm-4">
               <div class="form-check-inline">
              <form class="filter_choice_submit" style="display: flex;">
               
                  
                  <div class="form-group">
                    <select name="employee" class="form-control employee_name"  required>
                      <option value="">Select Employee</option>
                      <?php foreach($employee_type as $key => $value) { ?> 
                      <option value="<?php echo $value->emp_id; ?>"><?php echo $value->full_name;?> </option>
                      <?php } ?> 
                    </select> 
                  </div>
                  <div class="form-group">
                    <div class="col-sm-6">
                      <button type="submit" id="btn" class="btn btn-primary  center-block">Submit</button>    
                    </div>
                  </div>
              </form>
              </div>
            </div>
          <?php } ?>
            <div class="col-sm-4">
            </div>
              </div>
              <div class="col-sm-9" style="text-align: right;margin-left: 380px;">
              <input type="text" placeholder="Search.." name="search2" id="phone_no_search">
              <button type="submit" id="search"><i class="fa fa-search"></i></button>
             
            </div>

<div id="All">
              <div id ="jaytab1" style="margin-top:3%" class="grid table-responsive">
              <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 id="Expiry" style="display:none">
              <div id ="jaytab2" style="margin-top:3%" class="grid table-responsive">
              <table id="list5"></table>
              <div id="pager5"></div>
              <div id="dialogSelectRow" title="Warning" style="display:none">
              <p>Please select row</p>
              </div>
              </div>
            </div>
            <div id="phone_det" style="display:none">
              <div id ="jaytab6" style="margin-top:3%" class="grid table-responsive">
              <table id="list8"></table>
              <div id="pager8"></div>
              <div id="dialogSelectRow" title="Warning" style="display:none">
              <p>Please select row</p>
              </div>
              </div>
            </div>
            <div id="all_progress" style="display:none">
              <div id ="jaytab7" style="margin-top:3%" class="grid table-responsive">
              <table id="progress"></table>
              <div id="progresspage1"></div>
              <div id="dialogSelectRow" title="Warning" style="display:none">
              <p>Please select row</p>
              </div>
              </div>
            </div>
             <div id="duplicate_customer" style="display:none">
              <div id ="jaytab8" style="margin-top:3%" class="grid table-responsive">
              <table id="list11"></table>
              <div id="pager7"></div>
              <div id="dialogSelectRow" title="Warning" style="display:none">
              <p>Please select row</p>
              </div>
              </div>
            </div>

</div>

<div class="myModal modal fade"  tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true" id="MymodalPreventScript">

<div class="modal-content ">
          <div class="modal-header">
             <h3 class="modal-title pull-right">Follow up</h3>
            <button type="button" class="close" data-dismiss="modal">&times;</button>
           
          </div>
          <form method="post" class="add_forms">
          <div class="modal-body">
           
            <p><b>Customer : </b><b id="customer_name"></b>
              <span style="padding-left: 175px;">
                <b>Contact No : </b>
                <b id="contact_no"></b>
              </span>
              <span style="float: right;">
                <b>Email ID : </b>
                <b id="email"></b>
              </span>
            </p>

<div id ="jaytab" style="margin-top:3%" class="grid table-responsive">
              <table id="list3"></table>
              <div id="pager3"></div>
              <div id="dialogSelectRow3" title="Warning" style="display:none">
                <p>Please select row</p>
              </div>
            </div>
            
          
            <hr>

<h5>Add followup</h5>
            <div class="row">
              <div class="col-sm-6">
                <label for="name">Progress</label>
                <div class="form-group">
                  
                    <select type="text" name="progress" class="form-control progress_type" required="">  
                      <option value="">Select</option>
                      <option value="Booking finalization">Booking finalization</option>
                      <option value="Sales Final Costing">Sales Final Costing</option>
                      <option value="Loan Followup ">Sale agreement</option>
                      <option value="Registration">Registration</option>
                      <option value="Records">Records</option>
                      <option value="Architecture ">Architecture </option>
                      <option value="Building Agreement">Revised Budget </option>
                      <option value="Execution">Execution</option>
                      <option value="House Service ">House Service</option>
                      <option value="Layout Service">Layout Service</option>
                      <option value="Customer Visit">Customer Visit</option>
                      <option value="Finalized Reject">Finalized Reject</option>
                      <option value="Collection">Collection</option>
                      <option value="Billing">Billing</option>
                      <option value="Selections">Selections</option>
                    </select>
                  </div>
              </div>
              <div class="col-sm-6">
                <label for="name">Layout Name</label>
                <div class="form-group">
                  
                    <select type="text" name="layout_id" class="form-control layout_id" required="" id="layout_id">  
                      <option value="">Select</option>
                        <?php foreach($result_layout as $key => $value) { ?> 
                      <option value="<?php echo $value->id; ?>"><?php echo $value->layout_name;?></option>
                        <?php } ?>
                    </select>
                  </div>
              </div>
              
              <div class="col-sm-6 followup_date">
                <div class="form-group">
                  <label for="name">Follow Date :</label>
                  <input type="text" name="follow_date" class="date form-control date-picker readonly"  autocomplete="off"  required>
                  <input type="hidden" name="followuser_id" class="followuser_id form-control" >
                  <input type="hidden" name="" class="site_idss form-control" >
                </div>
              </div>
              <div class="col-sm-6">
                  
                  <div class="form-group" id="leaves1">
                </div>
              </div>
              </div>
              <div class="row">
               
                
                <div class="col-sm-6">
                  <label for="name">Assign Employee</label>
                  <div class="form-group">
                    <select name="employee" class="form-control employee_name"  required>
                      <option value="">Select</option>
                      <?php foreach($employee_type as $key => $value) { ?> 
                      <option value="<?php echo $value->emp_id; ?>"><?php echo $value->full_name;?> </option>
                      <?php } ?> 
                    </select> 
                  </div>
                </div>

<div class="col-sm-6">
                <div class="form-group">
                   <label for="name">Department</label>
                   <input type="text" class="form-control" name="department" id="department_name" readonly="" required="">
                    <input type="hidden" name="department_id" id="department_id">
                </div>
              </div>
              <div class="col-sm-12">
                  <div class="form-group">
                    <label for="name">Description :</label>
                      <textarea name="description" name="description" class="date form-control" id="modal_input" required="required"></textarea>
                  </div>
                </div>

</div>
            <div class="row">
           <div class="col-sm-6">
              
              <div class="form-group">
                <label for="name">File Attachment Name</label>
                <select name="file_name" class="form-control file_name"  >
                  <option value="">Select</option>
                  <?php foreach($file_names as $key => $value) { ?> 
                  <option value="<?php echo $value->id; ?>"><?php echo $value->name;?></option>
                  <?php } ?> 
                </select> 
              </div>
            </div>
            <div class="col-sm-6">
            <div class="form-group">
               <label for="name">File Attachment</label>
               <input type="file" class="form-control file" name="file" id="file"  >
               
            </div>
          </div>

</div>

</div>
          <div class="modal-footer">
            <button type="submit" class="btn btn-primary submit">Submit</button>
            <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
          </div>
        </form>
        </div>

</div>
    </div>

<div class="modal-content ">
          <div class="modal-header">
             <h3 class="modal-title pull-right">Follow up</h3>
            <button type="button" class="close" data-dismiss="modal">&times;</button>
           
          </div>
          <form method="post" class="add_forms">
          <div class="modal-body">
           
            <p><b>Customer : </b><b id="customer_names"></b>
              <span style="padding-left: 175px;">
                <b>Contact No : </b>
                <b id="contact_nos"></b>
              </span>
              <span style="float: right;">
                <b>Email ID : </b>
                <b id="emails"></b>
              </span>
            </p>

<div id ="jaytab" style="margin-top:3%" class="grid table-responsive">
              <table id="list10"></table>
              <div id="pager10"></div>
              <div id="dialogSelectRow3" title="Warning" style="display:none">
                <p>Please select row</p>
              </div>
            </div>
            
          </div>
         
        </form>
        </div>

</div>
    </div>

pre {

background-color: transparent;

border: 1px solid transparent;

line-height: 1.6;

text-align: justify;

}

.form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus {

border-color: #FF0000;

box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6);

}

</style>

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

$('.progress_type').change(function()
    {
       var type = $(this).val();
      if(type == "Finalized Reject")
      {
       
        $('.date-picker').removeAttr('required');
        $('.followup_date').hide();
      }
      else
      {
         $('.date-picker').prop('required',true);
        $('.followup_date').show();
      }
    });

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

if(response.result==1)
              {
                
                  var con1 = '';
                  con1 += '<label for="name">Site No</label>';
                  con1 += '<select type="text" class="form-control site_list" name="site_id" required>';
                  con1 += '<option value="">Select</option>';
                  $.each( response.sites, function( key, value2 ) {

con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                  });
                  con1 += '</select> ';

$('#leaves1').empty();
                  $('#leaves1').append(con1);
              }
              else
              {
                $('#leaves1').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);
            
                
           }
           else
           {
              $('#department_id').empty();
              toastr["error"](response.message);  
           }
          }
        });
    });
    $(document).ready(function()
    {

$(".assign_department").hide();
        $(".assign_employee").hide();
             
    });

$('#phone_no_search').change(function()
    {
          $("#list8").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
          $('#Expiry').hide(); 
          $('#All').hide();  
          $('#phone_det').show();

load_date_grid();
          function load_date_grid()
          {
             var phone_no_search = $('#phone_no_search').val();
              $("#list8").setGridParam(
              {
                 url:"<?php echo site_url('get-customer-sitevisiting-list-basedon-phone')?>/"+phone_no_search,  
                page:1
              }).trigger("reloadGrid");//Reload grid trigger
              $("#list8").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
              return false
          }
          var phone_no_search = $('#phone_no_search').val();
          $("#list8").jqGrid({
          url:"<?php echo site_url('get-customer-sitevisiting-list-basedon-phone')?>/"+phone_no_search,  
          mtype : "get",
          datatype: "json",
          colNames:['id','Name','Enquiry Layout','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Call Back At','Call Back By','Call Back Time','Status','Description','Followup Date','Followup','Duplicate Customer'],
          colModel:[
                 {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},       
                  {name:'name',index:'name', width:120, hidden:false,editable:false},
                   {name:'enquiry_layout',index:'enquiry_layout', width:120, hidden:false,editable:false},
                  //{name:'nri_no',index:'nri_no',editable:false, width:120},
                  {name:'reference_type',index:'reference_type',editable:false, width:120},
                  {name:'ref_from',index:'ref_from',editable:false, width:120},
                  {name:'ref_layout',index:'ref_layout',editable:false, width:120},
                  {name:'ref_site_number',index:'ref_site_number',editable:false, width:120},
                  {name:'remarks',index:'remarks',editable:false, width:120},
                   {name:'follow_created_at',index:'follow_created_at',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},         
                  {name:'created_by',index:'created_by',editable:false, width:120},
                  {name:'created_time',index:'created_time',editable:false, width:120},
                  {name:'enquiry_status',index:'enquiry_status',editable:false, width:120},
                  {name:'description',index:'description',editable:false, width:120},
                 
                   {name:'follow_date',index:'follow_date',editable:false, width:120,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
                  {name:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
                    var retVal = "";
                    var retVal = ' <a href="javascript:void(0);" onclick="follow_up('+rowObject.id+');" class="btn btn-default" id="btn"><i class="fa fa-mobile fa-2x" 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:"#pager8", 
          sortname:'id', 
          viewrecords: true,
          gridview: true,
          autowidth: true,
          sortorder:"asc",
          shrinkToFit: true,
          loadonce:true,
          autoencode: true,
          caption:"Customer Follow-Up List",
          //Subgrid1...
          subGrid: false,
        });
          $("#list8").jqGrid("setLabel", "rn", "SL");
          $("#list8").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
          $("#list8").jqGrid('navGrid','#pager8',
            {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
            },
          );
          
    });

jQuery("#list2").jqGrid({
        url:"<?php echo site_url('get-customer-sitevisiting-list')?>",
    	mtype : "get", 	
    	datatype: "json",
        colNames:['id','Name','Enquiry Layout','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Created By','Created At','Created Time','Status','Description','Followup Date','Site Visit',],
    	colModel:[
              {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
              {name:'name',index:'name', width:150, hidden:false,editable:false},	
              {name:'enquiry_layout',index:'enquiry_layout', width:150, hidden:false,editable:false},	
              //{name:'reference_type',index:'reference_type',editable:false, width:100},
              {name:'reference_type',index:'reference_type',editable:false, width:100},
              {name:'ref_from',index:'ref_from',editable:false, width:100},
              {name:'ref_layout',index:'ref_layout',editable:false, width:200},
              {name:'ref_site_number',index:'ref_site_number',editable:false, width:125},
              {name:'remarks',index:'remarks',editable:false, width:120},
               {name:'created_by',index:'created_by',editable:false, width:120},
               {name:'follow_created_at',index:'follow_created_at',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
             
              {name:'created_time',index:'created_time',editable:false, width:120},
              
              {name:'enquiry_status',index:'enquiry_status',editable:false, width:100},
              {name:'description',index:'description',editable:false, width:100},
              {name:'follow_date',index:'follow_date',editable:false, width:120,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
              {name:'',index:'',width:200, search:false,editable:false,formatter: function (cellvalue, options, rowObject) 
              {
                  var retVal = "";
                  var retVal = ' <a href="javascript:void(0);" onclick="follow_up('+rowObject.id+');" class="btn btn-default"><i class="fa fa-map-marker" aria-hidden="true"></i></a>';
                  return retVal;
              }},

rowNum:20,
    	      	rowTotal: 2000,
    	      	rowList : [20,30],
    	      	rownumbers: true,
    	      	//rownumWidth: 60,
    	      	pager:"#pager2",
    	      	sortname:'id', 
    	      	viewrecords: true,
    	      	gridview: true,
    	      	autowidth: true,
    	      	sortorder:"asc",
    	      	shrinkToFit: true,
    	      	loadonce:true,
    	      	autoencode: true,
    			   caption:"Customer Site Visiting 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
          },
          );

jQuery("#list5").jqGrid({
        url:"<?php echo site_url('get-expired-customer-sitevisiting-list')?>",
        mtype : "get",  
        datatype: "json",
       colNames:['id','Name','Enquiry Layout','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Created By','Created At','Created Time','Status','Description','Followup Date','Site Visit',],
        colModel:[
              {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
              {name:'name',index:'name', width:150, hidden:false,editable:false}, 
               {name:'enquiry_layout',index:'enquiry_layout', width:150, hidden:false,editable:false}, 
              //{name:'reference_type',index:'reference_type',editable:false, width:100},
              {name:'reference_type',index:'reference_type',editable:false, width:100},
              {name:'ref_from',index:'ref_from',editable:false, width:100},
              {name:'ref_layout',index:'ref_layout',editable:false, width:100},
              {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
              {name:'remarks',index:'remarks',editable:false, width:100},
              {name:'created_by',index:'created_by',editable:false, width:100},
               {name:'follow_created_at',index:'follow_created_at',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},         
              
             {name:'created_time',index:'created_time',editable:false, width:80},
              
              {name:'enquiry_status',index:'enquiry_status',editable:false, width:80},
              {name:'description',index:'description',editable:false, width:100},
               {name:'follow_date',index:'follow_date',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
              {name:'',index:'',width:100, search:false,editable:false,formatter: function (cellvalue, options, rowObject) 
              {
                  var retVal = "";
                  var retVal = '<a href="javascript:void(0);" onclick="follow_up('+rowObject.id+');" class="btn btn-default"><i class="fa fa-map-marker" aria-hidden="true"></i></a>';
                  return retVal;
              }},

rowNum:20,
              rowTotal: 2000,
              rowList : [20,30],
              rownumbers: true,
              //rownumWidth: 60,
              pager:"#pager5",
              sortname:'id', 
              viewrecords: true,
              gridview: true,
              autowidth: true,
              sortorder:"asc",
              shrinkToFit: true,
              loadonce:true,
              autoencode: true,
             caption:"Customer Site Visiting List",
          //Subgrid1...
              subGrid: false,
    });
          $("#list5").jqGrid("setLabel", "rn", "SL");
          $("#list5").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
          $("#list5").jqGrid('navGrid','#pager5',
          {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){?>

jQuery("#list11").jqGrid({
          url:"<?php echo site_url('get-duplicate-customer-list')?>",   
        mtype : "get",  
        datatype: "json",
      /* colNames:['id','Name','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Created By','Created At','Created Time','Status','Description','Followup Date','Site Visit',],
        colModel:[
              {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
              {name:'name',index:'name', width:150, hidden:false,editable:false}, 
              //{name:'reference_type',index:'reference_type',editable:false, width:100},
              {name:'reference_type',index:'reference_type',editable:false, width:100},
              {name:'ref_from',index:'ref_from',editable:false, width:100},
              {name:'ref_layout',index:'ref_layout',editable:false, width:100},
              {name:'ref_site_number',index:'ref_site_number',editable:false, width:100},
              {name:'remarks',index:'remarks',editable:false, width:100},
              {name:'created_by',index:'created_by',editable:false, width:100},
               {name:'follow_created_at',index:'follow_created_at',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},         
              
             {name:'created_time',index:'created_time',editable:false, width:80},
              
              {name:'enquiry_status',index:'enquiry_status',editable:false, width:80},
              {name:'description',index:'description',editable:false, width:100},
               {name:'follow_date',index:'follow_date',editable:false, width:100,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
              {name:'',index:'',width:100, search:false,editable:false,formatter: function (cellvalue, options, rowObject) 
              {
                  var retVal = "";
                  var retVal = '<a href="javascript:void(0);" onclick="follow_up('+rowObject.id+');" class="btn btn-default"><i class="fa fa-map-marker" aria-hidden="true"></i></a>';
                  return retVal;
              }}, */

colNames:['id','Name','Enquiry Layout','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:'enquiry_layout',index:'enquiry_layout', 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:20,
              rowTotal: 2000,
              rowList : [20,30],
              rownumbers: true,
              //rownumWidth: 60,
              pager:"#pager7",
              sortname:'id', 
              viewrecords: true,
              gridview: true,
              autowidth: true,
              sortorder:"asc",
              shrinkToFit: true,
              loadonce:true,
              autoencode: true,
             caption:"Customer Site Visiting List",
          //Subgrid1...
              subGrid: false,
    });
          $("#list11").jqGrid("setLabel", "rn", "SL");
          $("#list11").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
          $("#list11").jqGrid('navGrid','#pager7',
          {edit:false,add:false,del:false,search:false,refreshstate:"current"},
          { },
          { },
          { }, 
          {

<?php } else { ?>

colNames:['id','Name','Enquiry Layout','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:'enquiry_layout',index:'enquiry_layout', 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},

<?php } ?>

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();
        }
  });
       
}

function edit_details(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_modal').modal('show');

$('.customer_id').val(response.message.id);

$('.customer_name').val(response.message.name);

$('.customer_phone').val(response.message.phone);

$('.customer_email').val(response.message.email);

$('.address').val(response.message.address);

$('.remarks').val(response.message.remarks);

$('.site_number').val(response.message.ref_site_number);

$('.ref_type').val(response.message.ref_type);

$('.ref_from_id').val(response.ref_from.id);

$('.ref_from_name').val(response.ref_from.name);

$('.progress_type').val(response.message.site_visiting_status);

$('.description').val(response.message.site_visiting_description);

}

});

}

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);       
           }

}

});

}

$('.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-site-visiting")?>',

data   : formdata,

contentType: false,

processData: false,

success:function(response){

response=jQuery.parseJSON(response);

console.log(response);

if(response.result==1)

{

$("#edit_modal").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');

}

});

///////////////////////////////////////////////////////////////////////////////////////////////
    $(".readonly").keydown(function(e){
            e.preventDefault();
        });

$(function() {
                $('.date-picker').datepicker( {
                changeMonth: true,
                changeYear: true,
                showButtonPanel: true,
                dateFormat: 'd-m-yy',
               
                });
            });

function follow_up(id)
    {
      load_grid(id);
      $('.followuser_id').val(id);
      //$("#myModal").modal('show');
          $('.myModal').modal({
            backdrop: 'static',
            keyboard: false
        });
        var followuser_id = $('.followuser_id').val();
      $.ajax({
          type:'post',
          url:'<?php echo site_url('get-customer-name');?>',
          data:{'followuser_id':id},
          success:function(response){
          response=jQuery.parseJSON(response);

if(response.result==1)
          {  
          
            $('#customer_name').empty();
            $('#customer_name').text(response.customer.name);
            $('#contact_no').text(response.customer.phone);
            $('#email').text(response.customer.email);
            $('#layout_id').val(response.finalized.layout_id);
            $('.site_idss').val(response.finalized.site_id);
             $.ajax({
                            
              type:'post',
              url:'<?php echo site_url('get-site-based-on-layout');?>',
              data:{'layout_id':response.finalized.layout_id},
              success:function(response){
              response=jQuery.parseJSON(response)

if(response.result==1)
                  {
                      var site_idss = $('.site_idss').val();

var con1 = '';
                      con1 += '<label for="name">Site No</label>';
                      con1 += '<select type="text" class="form-control site_list" name="site_id" required>';
                      con1 += '<option value="">Select</option>';
                      $.each( response.sites, function( key, value2 ) {
                     
                        if(site_idss == value2.id)
                        {
                          con1+='<option value="'+value2.id+'" selected>'+value2.site_no+'</option>';
                        }
                        else
                        {
                          con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                        }

});
                      con1 += '</select> ';

$('#leaves1').empty();
                      $('#leaves1').append(con1);
                  }
                  else
                  {
                     $('#leaves1').empty();
                    toastr["error"](response.message);      
                  }
            }
            });
                
           }
           else
           {
              $('#customer_name').empty();
              toastr["error"](response.message);  
           }
          }
        });

}

function load_grid(id)
    {
      
        $("#list3").setGridParam(
            {

url:"<?php echo site_url('site-visiting-followup-list/')?>"+id,   
                page:1
            }
            ).trigger("reloadGrid");//Reload grid trigger
            $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
        return false
    }

$("#list3").jqGrid({
        url:"<?php echo site_url('site-visiting-followup-list/0')?>",   
        mtype : "get",   
        datatype: "json", 
        colNames:['id','Description','Follow Date','Progress','Employee','Department','Layout Name','Site No','Created By','Created At','Created Time'],
        colModel:[
                {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
                {name:'description',index:'description', width:300, hidden:false,editable:false},
                {name:'follow_date',index:'follow_date', width:100, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
                {name:'progress',index:'progress', width:250, hidden:false,editable:false},
                {name:'employee',index:'employee', width:250, hidden:false,editable:false},
                {name:'department',index:'department', width:300, hidden:false,editable:false},
                {name:'layout_name',index:'layout_name', width:100, hidden:false,editable:false},
                {name:'site_no',index:'site_no', width:100, hidden:false,editable:false},
                {name:'name',index:'name', width:100, hidden:false,editable:false},
                {name:'created_at',index:'created_at', width:100, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
                {name:'created_time',index:'created_time', width:100, hidden:false,editable:false},
                 ],

rowNum:20,
        rowTotal: 2000,
        rowList : [20,30],
        rownumbers: true,
        //rownumWidth: 60,
        pager:"#pager3", 
        sortname:'id', 
        viewrecords: true,
        gridview: true,
        // autowidth: true,
        sortorder:"asc",
        shrinkToFit: true,
        loadonce:true,
        autoencode: true,
        caption:"Site visiting Follow-Up List",
      });

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

$("#list3").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
          },
        );

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

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

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

$(".submit").attr('disabled', 'disabled');
            $(".submit").text("Submtting...");

$.ajax({

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

if(response.result==1)
                    {
                      
                      $('.myModal').modal('hide');
                      toastr["success"](response.message);
                      $('.add_forms')[0].reset();
                      $(".submit").text("Submit");    
                      $(".submit").removeAttr('disabled'); 
                      $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                      $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                      $("#list5").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                      location.reload();

}
                    else 
                    {
                      toastr["error"](response.message);                       
                      $(".submit").text("Submit"); 
                      $(".submit").removeAttr('disabled');  
                      $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');           
                    }
                   
                }
                
          });
                 
        });
    /*
    function progresstype()
      {
        var progress_type = $('.progress_type').val();
        //var id =$('.customer_id').val();
        //alert(progress_type);
        if(progress_type == 2)
        {
            $(".assign_department").show();
             $(".assign_employee").show();
        }
        else
        {
           $(".assign_department").hide();
            $(".assign_employee").hide();
        }
        
     }  */

$('.filter_choice_submit').submit(function(e)
    {
      $('#All').hide(); 
      $('#Expiry').hide();
      $('#phone_det').hide();
      $("#duplicate_customer").hide();
      $('#all_progress').show(); 
      e.preventDefault();    
      load_all_progress();
      function load_all_progress()
      {
          var employee_name = $(".employee_name").val();
          $("#progress").setGridParam(
          {
          url:"<?php echo site_url('get-all-progress-customer-list/')?>"+employee_name, 
          page:1
          }).trigger("reloadGrid");//Reload grid trigger
          $("#progress").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
      }
      var employee_name = $(".employee_name").val();

$("#progress").jqGrid({
            url:"<?php echo site_url('get-all-progress-customer-list/')?>"+employee_name,  
            mtype : "get",   
            datatype: "json", 
          colNames:['id','','','Customer Name','Layout Name','Site No','Description','Follow Date','Progress','Employee','Department','Created By','Created At','Created Time','Status'],
            colModel:[
                {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
                {name:'follow_cust_id',index:'follow_cust_id', width:100, hidden:true,editable:false,key:true},
                {name:'employee_assigned',index:'employee_assigned', width:100, hidden:true,editable:false,key:true},
                {name:'customer_name',index:'customer_name', width:200, hidden:false,editable:false},
                {name:'layout_name',index:'layout_name', width:200, hidden:false,editable:false},
                {name:'site_no',index:'site_no', width:150, hidden:false,editable:false},
                {name:'description',index:'description', width:200, hidden:false,editable:false},
                {name:'follow_date',index:'follow_date', width:150, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
                {name:'progress',index:'progress', width:150, hidden:false,editable:false},
                {name:'employee',index:'employee', width:150, hidden:false,editable:false,key:true},
                {name:'department',index:'department', width:150, hidden:false,editable:false},
                
                {name:'name',index:'name', width:150, hidden:false,editable:false},
                {name:'created_at',index:'created_at', width:150, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
                {name:'created_time',index:'created_time', width:150, hidden:false,editable:false},
                {name:'',index:'',search:false,width:250,align:'center', editable:false,formatter: function (cellvalue, options, rowObject) 
                {
                  if(rowObject.follow_date <= rowObject.yesterday)
                  {
                      var retVal = "";
                      var retVal = "<center><button style='color:white;background-color:red; width:100px; border:none;' onclick='all_progress("+rowObject.emp_assigned+","+rowObject.follow_cust_id+");' >EXPIRED</button></center>";
                      return retVal;
                  }
                  else
                  {
                      var retVal = "";
                      var retVal = "<center><button style='color:white;background-color:green; width:100px; border:none;' onclick='all_progress("+rowObject.emp_assigned+","+rowObject.follow_cust_id+");'>NOT EXPIRED</button></center>";
                      return retVal;
                  }
                  
                }},
              
                 ],

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

});

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

$("#progress").jqGrid('navGrid','#progresspage1',
        {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
        },
      );
    });

function all_progress(emp_id,cust_id)
    {

load_all_progress2(emp_id,cust_id);
      $("#all_progress_model").modal('show');

$.ajax({
          type:'post',
          url:'<?php echo site_url('get-customer-name');?>',
          data:{'followuser_id':cust_id},
          success:function(response){
          response=jQuery.parseJSON(response);

if(response.result==1)
          {  
            $('#customer_names').empty();
            $('#customer_names').text(response.customer.name);
            $('.customer_idssss').val(response.customer.id);
            $('#contact_nos').text(response.customer.phone);
            $('#emails').text(response.customer.email); 
           }
           else
           {
              $('#customer_names').empty();
              toastr["error"](response.message);  
           }
          }
        });
     }

function load_all_progress2(emp_id,cust_id)
        {
          
          $("#list10").setGridParam(
          {

url:"<?php echo site_url('get-all-status-based-progress/')?>"+emp_id+"/"+cust_id,  
              page:1
          }
          ).trigger("reloadGrid");//Reload grid trigger
          $("#list10").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
        }

$("#list10").jqGrid({
        url:"<?php echo site_url('get-all-status-based-progress/0')?>",   
        mtype : "get",   
        datatype: "json", 
        colNames:['id','Description','Follow Date','Progress','Employee','Department','Layout Name','Site No','Created By','Created At','Created Time'],
        colModel:[
                {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
                {name:'description',index:'description', width:300, hidden:false,editable:false},
                {name:'follow_date',index:'follow_date', width:100, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
                {name:'progress',index:'progress', width:250, hidden:false,editable:false},
                {name:'employee',index:'employee', width:250, hidden:false,editable:false},
                {name:'department',index:'department', width:300, hidden:false,editable:false},
                {name:'layout_name',index:'layout_name', width:100, hidden:false,editable:false},
                {name:'site_no',index:'site_no', width:100, hidden:false,editable:false},
                {name:'name',index:'name', width:100, hidden:false,editable:false},
                {name:'created_at',index:'created_at', width:100, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
                {name:'created_time',index:'created_time', width:100, hidden:false,editable:false},
                 ],

rowNum:20,
        rowTotal: 2000,
        rowList : [20,30],
        rownumbers: true,
        //rownumWidth: 60,
        pager:"#pager10", 
        sortname:'id', 
        viewrecords: true,
        gridview: true,
        // autowidth: true,
        sortorder:"asc",
        shrinkToFit: true,
        //loadonce:true,
        autoencode: true,
        caption:"Site visiting Follow-Up List",
      });

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

$("#list10").jqGrid('navGrid','#pager10',
          {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
          },
        );

</script>

<?php $this->load->view('includes/footer.php')?>

.modal-header{
      padding: 10px 26px !important;
    }
    .modal-body {
        padding: 0px 26px  !important;
    }
    .modal-footer {
        padding: 10px 31px !important;
        justify-content: center !important;
    }

#ui-id-1{
      margin-left: 1128px;
      width: 190.859px;
      margin-top: 218px;

}
     #search{
      margin-right: 30px;
     }
     #ui-id-1{
  height: 250px;
  overflow-y: scroll;
 }
</style>