EVOLUTION-NINJA

Edit File: Customer_report.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="#">Report</a></li>
          <li class="breadcrumb-item"> Marketting Report </li>
         
        </ol>
        </div> 
      </div> 
      </div>
    </div>
   <div class="row">
    <div class="col-md-12 grid-margin stretch-card">
      <div class="card">
        <div class="card-body">
          <div class="row">
            <form class="filter_choice_submit" style="display: flex;">
             
            <div class="col-sm-5">              
                  <div class="form-group">
                    <label>Staff</label>
                    <select name="employee" class="form-control">
                      <option value="">All</option>
                      <?php foreach($employee_type as $key => $value) { if($value->department_id == 19) { ?> 
                      <option value="<?php echo $value->emp_id; ?>"><?php echo $value->full_name;?> </option>
                      <?php } }?> 
                    </select> 
                  </div>
                </div>
                <div class="col-sm-5">
                  <div class="form-group">
                    <label>From Date</label>
                      <input type="text" class="form-control" name="from_date" id="from_date">
                  </div>
                </div>
                <div class="col-sm-5">
                  <div class="form-group">
                    <label>To Date</label>
                      <input type="text" class="form-control" name="to_date" id="to_date">
                  </div>
                </div>
                <div class="col-sm-2">
                   <div class="form-group">
                    <button type="submit" id="btn" class="btn btn-primary  center-block" style="margin-top: 31px;padding: 14px;padding-right: 25px;padding-left: 25px;">Submit</button>    
                  </div>
                </div>
              </div>
             </form>
                <br/>
              <div class="row">
               
                <div class="form-check-inline">
                <label class="form-check-label">
                     <input type="radio"  class="form-check-input" name="opt" onclick="planningtypes('followup_customer')" >Enquiry Customer : <span class="customer_follow_up_count "></span><input type="hidden" class="emp_id" name="to_date" id="to_date" required=""><input type="hidden" class="from_date" name="to_date" id="to_date" required=""><input type="hidden" class="to_date" name="to_date" id="to_date" required="">
                      </label>
                </div>
                    
                <div class="form-check-inline">
                  <label class="form-check-label">
                    <input type="radio"  class="form-check-input" name="opt" onclick="planningtypes('site_visit_customer')" >Customer Finalized Follow-Up : <span class="customer_site_visit_count "></span><input type="hidden" class="emp_id" name="to_date" id="to_date" required=""><input type="hidden" class="from_date" name="to_date" id="to_date" required=""><input type="hidden" class="to_date" name="to_date" id="to_date" required="">
                  </label>
                </div>
             
                <div class="form-check-inline">
                  <label class="form-check-label">
                     <input type="radio" class="form-check-input" name="opt" onclick="planningtypes('booking_customer')" >Booking Customer : <span class="customer_booking_count "></span><input type="hidden" class="emp_id" name="to_date" id="to_date" required=""><input type="hidden" class="from_date" name="to_date" id="to_date" required=""><input type="hidden" class="to_date" name="to_date" id="to_date" required="">   
                     </label>
                    </div>                
                 
                 <div class="form-check-inline">
                  <label class="form-check-label">
                    <input type="radio"  class="form-check-input" name="opt"  onclick="planningtypes('sales_customer')">Sales Customer : <span class="customer_sales_count "></span><input type="hidden" class="emp_id" name="to_date" id="to_date" required=""><input type="hidden" class="from_date" name="to_date" id="to_date" required=""><input type="hidden" class="to_date" name="to_date" id="to_date" required="">
                    </label>
                  </div>
                 
                 <div class="form-check-inline">
                  <label class="form-check-label">
                    <input type="radio"  class="form-check-input" name="opt"  onclick="planningtypes('expiry_customer')">Expiry Customer : <span class="expiry_customer "></span><input type="hidden" class="emp_id" name="to_date" id="to_date" required=""><input type="hidden" class="from_date" name="to_date" id="to_date" required=""><input type="hidden" class="to_date" name="to_date" id="to_date" required="">
                    </label>
                  </div>
                  </div>
               
              
              <div id="followup_customer" 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="site_visit_customer" style="display:none">
                <div id ="jaytab3" style="margin-top:3%" class="grid table-responsive">
                <table id="list4"></table>
                <div id="pager4"></div>
                <div id="dialogSelectRow" title="Warning" style="display:none">
                <p>Please select row</p>
                </div>
                </div>
              </div>
              <div id="booking_customer" style="display:none">
                <div id ="jaytab3" style="margin-top:3%" class="grid table-responsive">
                <table id="list3"></table>
                <div id="pager3"></div>
                <div id="dialogSelectRow" title="Warning" style="display:none">
                <p>Please select row</p>
                </div>
                </div>
              </div>
              <div id="sales_customer" style="display:none">
                <div id ="jaytab3" 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_customer" style="display:none">
                <div id ="jaytab6" style="margin-top:3%" class="grid table-responsive">
                <table id="list6"></table>
                <div id="pager6"></div>
                <div id="dialogSelectRow" title="Warning" style="display:none">
                <p>Please select row</p>
                </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      
<div id="myModal" class="modal fade" role="dialog">
  <div class="modal-dialog model-md">
    <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: 70px;">
            <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="list1"></table>
          <div id="pager1"></div>
          <div id="dialogSelectRow3" title="Warning" style="display:none">
            <p>Please select row</p>
          </div>
        </div>
      </div>  
    </div>
  </div>
</div>
<script type="text/javascript">
  function planningtypes(str)
  {       
    if(str=="followup_customer")
    {  
      var emp_id = $('.emp_id').val();
      var from_date = $('.from_date').val();
      var to_date = $('.to_date').val();
     
      $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      $('#followup_customer').show();
      $('#site_visit_customer').hide();
      $('#booking_customer').hide();
      $('#sales_customer').hide();
      $('#expiry_customer').hide();
       load_date_grid4();
      function load_date_grid4()
      {
         
          $("#list5").setGridParam(
          {           
            url:"<?php echo site_url('get-employee-under-followup-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id, 
            page:1            
          }).trigger("reloadGrid");//Reload grid trigger
          $("#list5").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
        }
      $("#list5").jqGrid({
      /*url:"<?php //echo site_url('get-employee-under-followup-customer')?>/"+from_date+"/"+to_date+"/"+emp_id,*/  
      url:"<?php echo site_url('get-employee-under-followup-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id, 
      mtype : "get",
      datatype: "json",
      colNames:['id','Name','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Followup Date','Progress','Description','Created At','Created By','Created Time','Followup'],
      colModel:[
            {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},       
            {name:'name',index:'name', 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_date',index:'follow_date',editable:false, width:120,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
            {name:'enquiry_status',index:'enquiry_status',editable:false, width:120},
            {name:'description',index:'description',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:'',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;
            }},
            ],
            rowNum:20,
            rowTotal: 2000,
            rowList : [20,30,100,500,1000,2000],
            rownumbers: true,
            //rownumWidth: 60,
            pager:"#pager5", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            shrinkToFit: true,
            loadonce:true,
            autoencode: true,
            caption:"Customer Follow-Up 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
            },
            ); 
    }
    else if(str=="site_visit_customer")
    {
      var emp_id = $('.emp_id').val();
      var from_date = $('.from_date').val();
      var to_date = $('.to_date').val();
     
      $("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      $('#followup_customer').hide();
      $('#site_visit_customer').show();
      $('#booking_customer').hide();
      $('#sales_customer').hide();
      $('#expiry_customer').hide();
       load_date_grid3();
      function load_date_grid3()
      {
         
          $("#list4").setGridParam(
          {           
            url:"<?php echo site_url('get-employee-under-sitevisit-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id,
            page:1            
          }).trigger("reloadGrid");//Reload grid trigger
          $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
        }
      $("#list4").jqGrid({
     /* url:"<?php //echo site_url('get-employee-under-sitevisit-customer')?>/"+from_date+"/"+to_date+"/"+emp_id, */ 
     url:"<?php echo site_url('get-employee-under-sitevisit-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id, 
      mtype : "get",
      datatype: "json",
      colNames:['id','Name','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Followup Date','Progress','Description','Created At','Created By','Created Time','Followup'],
      colModel:[
            {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},       
            {name:'name',index:'name', 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_date',index:'follow_date',editable:false, width:120,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
            {name:'enquiry_status',index:'enquiry_status',editable:false, width:120},
            {name:'description',index:'description',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:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = ' <a href="javascript:void(0);" onclick="follow_up_sitevisit('+rowObject.id+');" class="btn btn-default" id="btn"><i class="fa fa-mobile fa-2x" aria-hidden="true"></i></a>';
            return retVal;
            }},
            ],
            rowNum:20,
            rowTotal: 2000,
            rowList : [20,30,100,500,1000,2000],
            rownumbers: true,
            //rownumWidth: 60,
            pager:"#pager4", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            shrinkToFit: true,
            loadonce:true,
            autoencode: true,
            caption:"Customer Site-Visit List",
            //Subgrid1...
            subGrid: false,
            });
            $("#list4").jqGrid("setLabel", "rn", "SL");
            $("#list4").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not list4
            $("#list5").jqGrid('navGrid','#pager4',
            {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(str=="booking_customer")
    {
      var emp_id = $('.emp_id').val();
      var from_date = $('.from_date').val();
      var to_date = $('.to_date').val();
     
      $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      $('#followup_customer').hide();
      $('#site_visit_customer').hide();
      $('#booking_customer').show();
      $('#sales_customer').hide();
      $('#expiry_customer').hide();
       load_date_grid21();
      function load_date_grid21()
      {
         
          $("#list3").setGridParam(
          {
           
              url:"<?php echo site_url('get-employee-under-booking-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_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('get-employee-under-booking-customer')?>/"+from_date+"/"+to_date+"/"+emp_id, */ 
      url:"<?php echo site_url('get-employee-under-booking-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id, 
      mtype : "get",
      datatype: "json",
      colNames:['id','Name','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Followup Date','Progress','Description','Created At','Created By','Created Time','Followup'],
      colModel:[
            {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},       
            {name:'name',index:'name', 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_date',index:'follow_date',editable:false, width:120,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
            {name:'enquiry_status',index:'enquiry_status',editable:false, width:120},
            {name:'description',index:'description',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:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = ' <a href="javascript:void(0);" onclick="follow_up_booking('+rowObject.id+');" class="btn btn-default" id="btn"><i class="fa fa-mobile fa-2x" aria-hidden="true"></i></a>';
            return retVal;
            }},
            ],
            rowNum:20,
            rowTotal: 2000,
            rowList : [20,30,100,500,1000,2000],
            rownumbers: true,
            //rownumWidth: 60,
            pager:"#pager3", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            shrinkToFit: true,
            loadonce:true,
            autoencode: true,
            caption:"Customer Booking List",
            //Subgrid1...
            subGrid: false,
            });
            $("#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
            },
            ); 
    }
    else if(str=="sales_customer")
    {
      var emp_id = $('.emp_id').val();
      var from_date = $('.from_date').val();
      var to_date = $('.to_date').val();
     
      $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      $('#followup_customer').hide();
      $('#site_visit_customer').hide();
      $('#booking_customer').hide();
      $('#sales_customer').show();
      $('#expiry_customer').hide();
      load_date_grid2();
      function load_date_grid2()
      {
         
          $("#list2").setGridParam(
          {
             url:"<?php echo site_url('get-employee-under-sales-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id,
            page:1
            
          }).trigger("reloadGrid");//Reload grid trigger
          $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
        }
      $("#list2").jqGrid({
     /* url:"<?php //echo site_url('get-employee-under-sales-customer')?>/"+from_date+"/"+to_date+"/"+emp_id,*/  
     url:"<?php echo site_url('get-employee-under-sales-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id, 
      mtype : "get",
      datatype: "json",
      colNames:['id','Name','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Followup Date','Progress','Description','Created At','Created By','Created Time','Followup'],
      colModel:[
            {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},       
            {name:'name',index:'name', 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_date',index:'follow_date',editable:false, width:120,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }}, 
            {name:'enquiry_status',index:'enquiry_status',editable:false, width:120},
            {name:'description',index:'description',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:'',index:'',width:120, search:false,editable:false,formatter: function (cellvalue, options, rowObject) {
            var retVal = "";
            var retVal = ' <a href="javascript:void(0);" onclick="follow_up_sales('+rowObject.id+');" class="btn btn-default" id="btn"><i class="fa fa-mobile fa-2x" aria-hidden="true"></i></a>';
            return retVal;
            }},
            ],
            rowNum:20,
            rowTotal: 2000,
            rowList : [20,30,100,500,1000,2000],
            rownumbers: true,
            //rownumWidth: 60,
            pager:"#pager2", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            shrinkToFit: true,
            loadonce:true,
            autoencode: true,
            caption:"Customer Sales 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(str=='expiry_customer')
    {
      var emp_id = $('.emp_id').val();
      var from_date = $('.from_date').val();
      var to_date = $('.to_date').val();
     
      $("#list6").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
      $('#followup_customer').hide();
      $('#site_visit_customer').hide();
      $('#booking_customer').hide();
      $('#sales_customer').hide();
      $('#expiry_customer').show();
       load_date_grid();
      function load_date_grid()
      {
         
          $("#list6").setGridParam(
          {
           url:"<?php echo site_url('get-employee-under-expiry-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id, 
            page:1
            
          }).trigger("reloadGrid");//Reload grid trigger
          $("#list6").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
        }

$("#list6").jqGrid({
   
     url:"<?php echo site_url('get-employee-under-expiry-customer')?>?from_date="+from_date+"&to_date="+to_date+"&emp_id="+emp_id, 
     
      mtype : "get",
      datatype: "json",
     colNames:['id','Name','Reference Type','Refered By','Ref Person\'s Layout','Ref Person\'s Site','Remarks','Status','Created At','Created By','Created Time'],
      colModel:[
          {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},       
          {name:'name',index:'name', 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_from',index:'ref_from',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:75},
          {name:'remarks',index:'remarks',editable:false, width:100},
          {name:'enquiry_status',index:'enquiry_status',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: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" id="btn"><i class="fa fa-mobile fa-2x" aria-hidden="true"></i></a>';
            return retVal;
          }},*/
          ],
            rowNum:20,
            rowTotal: 2000,
            rowList : [20,30,100,500,1000,2000],
            rownumbers: true,
            //rownumWidth: 60,
            pager:"#pager6", 
            sortname:'id', 
            viewrecords: true,
            gridview: true,
            autowidth: true,
            sortorder:"asc",
            shrinkToFit: true,
            loadonce:true,
            autoencode: true,
            caption:"Customer Expiry List",
            //Subgrid1...
            subGrid: false,
            });
            $("#list6").jqGrid("setLabel", "rn", "SL");
            $("#list6").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
            $("#list6").jqGrid('navGrid','#pager6',
            {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 follow_up(id)
{
  load_grid(id);
  $('.followuser_id').val(id);
  $("#myModal").modal('show');
  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);
        $('.customer_ids').val(response.customer.id);
        $('#contact_no').text(response.customer.phone);
        $('#email').text(response.customer.email);
       
       }
       else
       {
          $('#customer_name').empty();
          toastr["error"](response.message);  
       }
      }
    });

}

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

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

$("#list1").jqGrid({
    url:"<?php echo site_url('customers-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:100, hidden:false,editable:false},
              {name:'employee_assigned',index:'employee_assigned', width:100, hidden:false,editable:false},
              {name:'depart_assigned',index:'depart_assigned', width:100, 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,100,500,1000,2000],
    rownumbers: true,
    //rownumWidth: 60,
    pager:"#pager1", 
    sortname:'id', 
    viewrecords: true,
    gridview: true,
    // autowidth: true,
    sortorder:"asc",
    shrinkToFit: true,
    loadonce:true,
    autoencode: true,
    caption:"Customer Enquiry List",
  });

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

$("#list1").jqGrid('navGrid','#pager1',
      {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 follow_up_sitevisit(id)
{
  load_grid_sitevisit(id);
  $('.followuser_id').val(id);
  $("#myModal").modal('show');
  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);

}

function load_grid_sitevisit(id)
{
    $("#list1").setGridParam(
    {

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

$("#list1").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,100,500,1000,2000],
        rownumbers: true,
        //rownumWidth: 60,
        pager:"#pager1", 
        sortname:'id', 
        viewrecords: true,
        gridview: true,
        // autowidth: true,
        sortorder:"asc",
        shrinkToFit: true,
        loadonce:true,
        autoencode: true,
        caption:"Site visiting Follow-Up List",
      });

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

$("#list1").jqGrid('navGrid','#pager1',
          {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 follow_up_booking(id)
{
  load_grid_booking(id);
  $('.followuser_id').val(id);
  $("#myModal").modal('show');
  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);

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

$("#list1").jqGrid({
    url:"<?php echo site_url('Booking-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,100,500,1000,2000],
    rownumbers: true,
    //rownumWidth: 60,
    pager:"#pager1", 
    sortname:'id', 
    viewrecords: true,
    gridview: true,
    // autowidth: true,
    sortorder:"asc",
    shrinkToFit: true,
    loadonce:true,
    autoencode: true,
    caption:"Customer Booking Follow-Up List",
  });

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

function follow_up_sales(id)
{
  load_grid_sales(id);
  $('.followuser_id').val(id);
  $("#myModal").modal('show');
  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);

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

$("#list1").jqGrid({
    url:"<?php echo site_url('sales-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},
             ],

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

$(document).ready(function() {
     $(function() {
            $('#from_date').datepicker( {
            changeMonth: true,
            changeYear: true,
           // showButtonPanel: true,
            dateFormat: 'd-m-yy',
           
            });
        });
     $(function() {
            $('#to_date').datepicker( {
            changeMonth: true,
            changeYear: true,
            //showButtonPanel: true,
            dateFormat: 'd-m-yy',
           
            });
        });
});

$('.filter_choice_submit').submit(function(e)
{  
    e.preventDefault();
    formdata = new FormData($(this)[0]);
    $(".submit").text("Submitting...");
    $(".submit").attr("disabled", true);
    $.ajax({
        
          type   : 'post',
          url    : '<?php echo site_url("get-employee-under-customers")?>',
          data   : formdata,
          contentType: false,
          processData: false,
                                  
          success:function(response)
          {
            response=jQuery.parseJSON(response);
            console.log(response);
  
              if(response.result==1)
              {                 
                $('.customer_follow_up_count').text(response.message.customer_followup);
                $('.customer_site_visit_count').text(response.message.site_visit);
                $('.customer_booking_count').text(response.message.booking);
                $('.customer_sales_count').text(response.message.sales);
                $('.expiry_customer').text(response.message.expiry);
                $('.emp_id').val(response.message.emp_id);
                $('.from_date').val(response.message.from_date);
                $('.to_date').val(response.message.to_date);
                
              }
              else 
              {
                  toastr["error"](response.message);
                  $('.submit').removeAttr("disabled");
                  $(".submit").text("Submit");
              }
          }            
            
        });
    });

function fun_delete(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-godown');?>",
              data : {'sub_group_id':id},
              success:function(response) {
                response=jQuery.parseJSON(response);
                console.log(response);
                if(response.result==1)
                {

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

}
        });

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

function fun_edit(id)
{
  $.ajax({

url:"<?php echo site_url("edit-godown")?>",
    type:"POST",
    data:{id:id},
    success:function(response)
    {
        response=jQuery.parseJSON(response);
        console.log(response);
        if(response.result == 1) 
        {
          $("#edit_modal").modal("show");
          $(".id").val(response.message.id);
          $('.layout_id').val(response.message.layout);
          $('.godown_name').val(response.message.godown_name);                     
        }
        else 
        {
          toastr["error"](response.message);
        
          $(".update").attr("disabled", true);
        }
      }
  });
}

$('.update_godown').submit(function(e)
{  
    e.preventDefault();
    formdata = new FormData($(this)[0]);
    $(".update").text("Submitting...");
    $(".update").attr("disabled", true);
    $.ajax({
        
          type   : 'post',
          url    : '<?php echo site_url("update-godown")?>',
          data   : formdata,
          contentType: false,
          processData: false,
                                  
          success:function(response)
          {
            response=jQuery.parseJSON(response);
            console.log(response);
  
              if(response.result==1)
              {  
                
                toastr["success"](response.message);
                $('.update').removeAttr("disabled");
                $(".update").text("Update");
              
                $("#list0").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                $('#edit_modal').modal('hide');
              }
              else 
              {
                  toastr["error"](response.message);
                  $('.update').removeAttr("disabled");
                  $(".update").text("Update");
              }
          }            
            
        });
    });

</script>
 
<style type="text/css">

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

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

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

}
.modal-content{
  width: 150%;
  background: aliceblue;
}
</style>
      
<?php $this->load->view('includes/footer'); ?>