EVOLUTION-NINJA

Edit File: customer_conversation_report.php

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

<div class="row">
    <div class="col-md-12 grid-margin stretch-card">
      <div class="card">
        <div class="card-body">
          <form class="filter_choice_submit">
          <div class="row">
            
           
            <div class="col-sm-1 layout_div">
              <div class="form-group">
                <label>Layout Name : </label>
              </div>
            </div>
            <div class="col-sm-2 layout_div">
              <div class="form-group">
                <select name="layout_name" class="form-control layout" id="layout_name" onchange="change_layout_site();" >
                  <option value="">Select</option>
                  <?php foreach($layouts as $layout){?>
                    <option value="<?php echo $layout->id; ?>"><?php echo $layout->layout_name; ?></option>
                  <?php } ?>
                </select>
              </div>
            </div>
            <div class="col-sm-1 layout_div">
              <div class="form-group">
                <label>Site : </label>
              </div>
            </div>
            <div class="col-sm-2 layout_div">
              <select class="form-control site_number site" name="site" id="site">
              </select>
            </div>
            
           <div class="col-sm-3">
              <button type="submit" class="btn btn-primary">Submit</button>
            </div>
              
           </div>
        
            
         
          </form>
          <br/>
        </div>
         <div id="todays_list">
          <div id ="todaysjaytab" style="margin-top:3%" class="grid ">
          <table id="list0"></table>
          <div id="pager2"></div>
          <div id="dialogSelectRow" title="Warning" style="display:none">
            <p>Please select row</p>
          </div>
          </div>
        </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</form>
</div>

.first{
    padding-top: 2%;
    padding-bottom:3%;
  }
  
</style>

function change_layout_site()
  {
    var layout_name = $('#layout_name option:selected').val();

$.ajax({
            type:'post',
            url:'<?php echo site_url('get-site-based-on-layout-booking');?>',
            data:{"layout_id":layout_name},
              success:function(response){
                  response=jQuery.parseJSON(response);
                  console.log(response);
                      if(response.result==1)
                      {
                          var con1 = '';                               
                          con1 += '<option value="">Select</option>';
                          $.each( response.sites, function( key, value2 ) 
                          {
                            con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                          });
                         
                            $('.site_number').empty();
                            $('.site_number').append(con1);
                      }
                      else
                      {
                       $('.site_number').empty();
                        toastr["error"](response.message);      
                      }
                  }
          });
                
  }

$('.filter_choice_submit').submit(function(e)
  {
      e.preventDefault();
      var layout = $(".layout").val();
      if(layout  !="" && layout != null)
      {
        var layout = $(".layout").val();
      }
      else
      {
        var layout = "0";
      }
      var site = $(".site").val();
      if(site !="" && site != null)
      {
        var site = $(".site").val();
      }
      else
      {
       var site = "0";
      }
     
      load_date_grid();
      function load_date_grid()
      {
         
          $("#list0").setGridParam(
          {
            
            url:"<?php echo site_url('get-customer-conversation-list')?>/"+layout+"/"+site,
            page:1
            
          }).trigger("reloadGrid");//Reload grid trigger
          $("#list0").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
          return false
        }

$("#list0").jqGrid({
    url:"<?php echo site_url('get-customer-conversation-list')?>/"+layout+"/"+site,
    mtype : "get",   
    datatype: "json", 
    colNames:['id','Progress','Description','Created By','Created At','Created Time'],
    colModel:[
              {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
              {name:'progress',index:'progress', width:100, hidden:false,editable:false},
              {name:'description',index:'description', 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},
              {name:'created_time',index:'created_time', width:100, hidden:false,editable:false},

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

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

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

</script>

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