EVOLUTION-NINJA

Edit File: customer_records.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">
              <div class="form-group">
                <label>Select : </label>
              </div>
            </div>
            <div class="col-sm-2">
              <div class="form-group">
                <select name="" class="form-control select_type">
                  <option value="">Select</option>
                  <option value="layout">Layout</option>
                  <option value="customer">Customer</option>
                </select>
              </div>
            </div>
           
            <div class="col-sm-1 layout_div" style="display: none;">
              <div class="form-group">
                <label>Layout Name : </label>
              </div>
            </div>
            <div class="col-sm-2 layout_div" style="display: none;">
              <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" style="display: none;">
              <div class="form-group">
                <label>Site : </label>
              </div>
            </div>
            <div class="col-sm-2 layout_div" style="display: none;">
              <select class="form-control site_number site" name="site" id="site" onchange="change_site();">
              </select>
            </div>
            
           
              <div class="col-sm-1 customer_div" style="display: none;">
                <div class="form-group">
                  <label>Customer : </label>
                </div>
              </div>
              <div class="col-sm-2 customer_div" style="display: none;">
                <select class="form-control customer" name="customer" id="customer" onchange="change_customer();">
                </select>
              </div>
           </div>
           <div class="row" >
            <div class="col-sm-">
              <button type="submit" class="btn btn-primary">Submit</button>
              <button type="reset" class="btn btn-secondary">Cancel</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>
 
<div class="modal fade" id="impcustomer" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true">
      <div class="modal-dialog modal-md" role="document">
          <div class="modal-content">

<div class="modal-header">
              <h5 class="modal-title" id="ModalLabel">Upload Customer Document</h5>
              <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
              </button>
            </div>
            
            <form class="forms-sample import_data" enctype="multipart/form-data">
              
              <div class="modal-body">
                <div class="form-group">
                  <label>Upload Document</label>
                  <input type="file" name="customer_document" class="form-control">
                  <input type="hidden" name="id" class="form-control id">
                </div>
                <div class="form-group">
                  <label>Uploaded Document</label>
                  <p class="uploaded_doc"></p>
                </div>
              </div>

<div class="modal-footer">
                <button type="submit" class="btn btn-primary submit1">Upload</button>
                <button type="button" class="btn btn-light" data-dismiss="modal">Close</button>
              </div>

</form>

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

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

$.ajax({

url:"<?php echo site_url("get-customer-for-records")?>",
              type:"POST",
              data:{site_id:"",layout_id:""},
              success:function(response)
              {
                  response=jQuery.parseJSON(response);
                  console.log(response);
                  if(response.result == 1) 
                  {
                    $('.customer_div').show();
                    var con1 = '';                               
                    con1 += '<option value="">Select</option>';
                    $.each( response.message, function( key, value2 ) 
                    {
                      con1+='<option value="'+value2.id+'" >'+value2.name+'</option>';
                    });
                 
                    $('.customer').empty();
                    $('.customer').append(con1);

}
                  else 
                  {
                    toastr["error"](response.message);
                  
                    $(".update").attr("disabled", true);
                  }
              }
          });
  }
  
});

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-for-records');?>',
            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);      
                      }
                  }
          });
                
  }

function change_site()
    {
      var id = $('#site option:selected').val();

$.ajax({

url:"<?php echo site_url("get-site-based-on-layout-enquiry")?>",
            type:"POST",
            data:{id:id},
            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 
                {
                  toastr["error"](response.message);
                
                  $(".update").attr("disabled", true);
                }
            }
        });
    }

function change_site()
    {
     
        var layout_id = $('#layout_name option:selected').val();
        var id = $('#site option:selected').val();

$.ajax({

url:"<?php echo site_url("get-customer-for-records")?>",
              type:"POST",
              data:{site_id:id,layout_id:layout_id},
              success:function(response)
              {
                  response=jQuery.parseJSON(response);
                  console.log(response);
                  if(response.result == 1) 
                  {
                    $('.customer_div').show();
                    var con1 = '';                               
                    con1 += '<option value="">Select</option>';
                    $.each( response.message, function( key, value2 ) 
                    {
                      con1+='<option value="'+value2.id+'" >'+value2.name+'</option>';
                    });
                 
                    $('.customer').empty();
                    $('.customer').append(con1);

}
                  else 
                  {
                    toastr["error"](response.message);
                  
                    $(".update").attr("disabled", true);
                  }
              }
          });
      }

$('.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";
      }
      var customer = $(".customer").val();
      if(customer !="" && customer != null)
      {
        var customer = $(".customer").val();
      }
      else
      {
       var customer = '0';
      }
      load_date_grid();
      function load_date_grid()
      {
         
          $("#list0").setGridParam(
          {
            /*url:"<?php echo site_url('get-customer-document-list')?>?layout="+layout+"&&site="+site+"&&customer="+customer,
            page:1*/
            url:"<?php echo site_url('get-customer-document-list')?>/"+layout+"/"+site+"/"+customer,
            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-document-list')?>/"+layout+"/"+site+"/"+customer,
    mtype : "get",   
    datatype: "json", 
    colNames:['id','File Name','Created By','Created Date','Created Time','Document','Action'],
    colModel:[
        {name:'d_id',index:'d_id', width:100, hidden:true,editable:false,key:true},
        {name:'name',index:'name', width:100, hidden:false,editable:false},
        {name:'created_by',index:'created_by', width:100, hidden:false,editable:false},
        {name:'created_date',index:'created_date', width:100, hidden:false,editable:false},
        {name:'created_time',index:'created_time', width:100, hidden:false,editable:false},
        {name:'document',index:'document',editable:false,align:'center',editrules:{}, width:150,search:false,
                formatter: function (cellvalue, options, rowObject) 
        {
                        
              if(rowObject.document != "")
              {
                var retVal = '';
                retVal +='<a target="_blank" href="<?php echo base_url('/file_uploads');?>/'+rowObject.document+'"><button>View</button></a>';
                return retVal;
              }
              else
              { 
                  var retVal = '';
                  var retVal = '';
                   return retVal;
              }                                                    
            
          }},
          
          {name:'',index:'',width:50, search:false,editable:false,align:'center',formatter: function (cellvalue, options, rowObject) {
          var retVal = "";
          var retVal = '<a href="javascript:void(0);" onclick="edit_customer_record('+rowObject.d_id+');" class="btn btn-default" id="btn"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a>  <a href="javascript:void(0);" onclick="delete_customer_record('+rowObject.d_id+');" class="btn btn-default" id="btn"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>';
          return retVal;
          }},
     ],
    rowNum:20,
    rowTotal: 2000,
    rowList : [20,30,100,200,500,1000],
    rownumbers: true,
    //rownumWidth: 60,
    pager:"#pager2", 
    sortname:'id', 
    viewrecords: true,
    gridview: true,
    autowidth: true,
    sortorder:"asc",
    shrinkToFit: true,
    loadonce:true,
    autoencode: true,
    caption:"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
      },
    );
});

function edit_customer_record(id)
{
    $.ajax({
    type : 'post',
    url  : "<?php echo site_url('edit-customer-document');?>",
    data : {'id':id},
    success:function(response) {
      response=jQuery.parseJSON(response);
      console.log(response);
      if(response.result==1)
      {
          $('#impcustomer').modal("show");
          $('.id').val(response.message.id);
          if(response.message.document)
          {                  
                var files_image = response.message.document;  
                var files_images = files_image.toString();
                var get_ext = files_images.split('.').pop();

if(get_ext == "pdf" || get_ext == "PDF" || get_ext == "doc" || get_ext == "docx" )
                {            
                
                  var retVal = '';
                  var retVal ='<a target="_blank" href="<?php echo base_url('/file_uploads');?>/'+files_image+'"><img width="50px" height="50px" src="<?php echo base_url('assets/images/pdf_file.png');?>" class="profile-pic"/></a>';
                }
                else
                {
                  var retVal = '';
                  var retVal ='<a target="_blank" href="<?php echo base_url('/file_uploads');?>/'+files_image+'"><img width="50px" height="50px" src="<?php echo base_url('/file_uploads');?>/'+files_image+'" class="profile-pic"/></a>';
                }
                $(".uploaded_doc").html(retVal);                                                  
          }
          else
          {
              var retVal = '';
              var retVal = '<button><a href="<?php echo base_url('assets/images/no_images.jpg');?>" target="_blank">View</a></button> ';
              return retVal;
              $(".uploaded_doc").html(retVal);
          }
      }

}
  });
  
}

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

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

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

});

function delete_customer_record(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-document');?>",
        data : {'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();
        }
  });
       
}

</script>

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