EVOLUTION-NINJA

Edit File: Assets_creation.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="#">Accounts</a></li>
          <li class="breadcrumb-item"><a href="#">Masters</a></li>
          <li class="breadcrumb-item"><a href="#">HR</a></li>
          <li class="breadcrumb-item"> Add assets </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">

<form id="add_assets" class="form_submit">
            <div class="col-xs-12">
              
                <div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;">
                  <div class="col-sm-12 col-md-3">
                    <span style="font-size:25px;">Add Assets</span>
                  </div>
                  <div class="col-sm-6"></div>
                  
                </div>
                
                <div class="row">
                  <div class=" col-sm-12 col-xs-12 col-md-6">
                    <label class="col-sm-4">Category <span style="color:red">*</span></label>
                    <div class="col-sm-8 yes_form">
                      <input type="text" name="category" class="form-control" required>
                    </div>                      
                  </div>
                </div>
                
                <br>
                
                <div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;">
                  <div class="col-sm-12 col-md-2">
                    
                  </div>
                  <div class="col-sm-7"></div>
                  <div class="col-sm-3">
                    <button type="submit" class="btn btn-primary">Save</button>
                    <button type="reset" class="btn btn-secondary">Cancel</button>
                  </div>
                </div>
            </div>
          </form>

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

<div id="myModal" class="modal fade" role="dialog">
  <div class="modal-dialog modal-md" role="document">

<div class="modal-content">
     <div class="modal-header">
        <h5 class="modal-title" id="ModalLabel">Add Sub-Category</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
         <form class="forms-sample add_subcategory">
          <input type="hidden" class="form-control category_id" name="category_id"/>
          <div class="row">
            <div class="col-sm-4">
              <div class="form-group" >
                  <label for="exampleInputUsername1">Sub-Category</label>
                  <input type="text" class="form-control sub_category" name="sub_category" required>
              </div>
            </div>
          </div>
          <div class="modal-footer">
            <button type="submit" class="btn btn-primary sub_submit">Submit</button>
            <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
          </div>
         </form>
      </div>
     
    </div>

</div>
</div>

<div class="modal fade" id="edit_modal" 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">Edit assets</h5>
              <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
              </button>
            </div>
              <div class="modal-body">
               <form class="forms-sample update_form">
                <input type="hidden" class="form-control id" name="id"/>

<div class="row">
                  <div class="col-sm-6">
                    <div class="form-group" >
                        <label for="exampleInputUsername1">Category</label>
                        <input type="text" class="form-control category" name="category" required>
                    </div>
                  </div>
                </div>
                <div class="modal-footer">
                  <button type="submit" class="btn btn-primary submit">Submit</button>
                  <button type="button" class="btn btn-light" data-dismiss="modal">Close</button>
                </div>

</form>

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

<div class="modal fade" id="edit_subcat_modal" 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">Edit Sub Category</h5>
              <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
              </button>
            </div>
              <div class="modal-body">
               <form class="forms-sample update_submodal">
                <input type="hidden" class="form-control id" name="id"/>

<div class="row">
                  <div class="col-sm-6">
                    <div class="form-group" >
                        <label for="exampleInputUsername1">Sub Category</label>
                        <input type="text" class="form-control sub_category" name="sub_category" required>
                    </div>
                  </div>
                </div>
                <div class="modal-footer">
                  <button type="submit" class="btn btn-primary submit">Submit</button>
                  <button type="button" class="btn btn-light" data-dismiss="modal">Close</button>
                </div>
              </form>
              </div>
    </div>
  </div> 
</div>

CallGrid();

function CallGrid()
{
  jQuery("#list2").jqGrid({
    url:"<?php echo site_url('get-assets-list')?>",  
  mtype : "get",   
  datatype: "json", 
    colNames:['ID','Category','','Action'],
  colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false},
        {name:'category',index:'category', width:150, hidden:false,editable:false},
        {name:'',index:'',search:false, 
                  width:60, editable:false,formatter: function (cellvalue, options, rowObject) {
                      var retVal = "";
                        var retVal = ' <button class="button" class="add_subcat"  onclick="add_subcat('+rowObject.id+')">Add sub category</button>';
                        return retVal;

}},
        {name:'',index:'',search:false, 
                  width:60, editable:false,formatter: function (cellvalue, options, rowObject) {
                      var retVal = "";
                        var retVal = ' <a data-toggle="tooltip" title="Edit" class="" href="javascript:void(0);"><span class="fa fa-pencil" onclick="fun_edit($(this))"  style="color:blue;"></span></a>     <a data-toggle="tooltip" title="Delete" onclick="fun_delete($(this))"; href="javascript:void(0);"><span class="fa fa-trash" style="color:red;"></span></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:"Assets List",
                subGrid: true,
                subGridRowExpanded: function(subgrid_id, row_id) {
                var subgrid_table_id;
                swan_id=row_id;
                subgrid_table_id = subgrid_id+"_t";
                jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
                jQuery("#"+subgrid_table_id).jqGrid({

url:"<?php echo site_url('get-subcategory');?>?id="+swan_id,

type : "GET", 
                        datatype: "json", 
                        colNames:['ID','Sub Category','Action'],
                        colModel:[
                        {name:'id',index:'id',hidden:true,key:true, width:100, editable:false},

{name:'sub_category',index:'sub_category', width:150, hidden:false,editable:false},                         {name:'',index:'',search:false, 
                        width:60, editable:false,formatter: function (cellvalue, options, rowObject) {
                      var retVal = "";
                        var retVal = ' <a data-toggle="tooltip" title="Edit" class="" href="javascript:void(0);"><span class="fa fa-pencil" onclick="edit_sub($(this))"  style="color:blue;"></span></a>     <a data-toggle="tooltip" title="Delete" onclick="delete_sub($(this))"; href="javascript:void(0);"><span class="fa fa-trash" style="color:red;"></span></a>';
                        return retVal;
                      }},
                        
                    ],

height: 'auto',
                        width: 'auto',
                        autowidth: false,
                        shrinkToFit: true,
                        rowNum:20,
                        sortname: 'num',
                        sortorder: "asc",
                        pager:subgrid_table_id,
                        loadonce: true,
                        footerrow: true,
                        userDataOnFooter: true,

});
                  }

});

$("#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
               },

);
}

function add_subcat(category_id)
  {
    $(".add_subcat").attr('disabled','disabled');
    $(".add_subcat").text("Loading...");

var id = category_id;

$('.category_id').val(id);
    
    $("#myModal").modal("show");
      
  }

function fun_edit(rowId)
  {
    var id = rowId.closest('tr').attr('id');
      $.ajax({

url:"<?php echo site_url("edit-assets-list")?>",
            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);
                  $(".category").val(response.message.category);
               }
                else 
                {
                  toastr["error"](response.message);
                
                  $(".update").attr("disabled", true);
                }
            }
        });
  }

function fun_delete(rowId)
{
  var id = rowId.closest('tr').attr('id');
  var id = id;
 
   swal({

title: "Are you sure?",
      text: "You will not be able to recover this 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({
          
          url:"<?php echo site_url("delete-assets-list")?>",
          type:"POST",
          data:{id:id},
          success:function(response) {
            response=jQuery.parseJSON(response);
                console.log(response);

if(response.result == 1) 
              {
                  toastr["success"]("Deleted successfully");
                  $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                    
              }
            }

});  
        
         } 
        else {

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

});
}

$('.update_form').submit(function(e){  
        e.preventDefault();
         formdata = new FormData($(this)[0]);
            $(".update").text("Updating...");
            $(".update").attr("disabled", true);
            $.ajax({

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

if(response.result==1)
                    {

swal({

title: "Are you sure?",
                                text: "Updated Succesfully",
                                type: "warning",   showCancelButton: true,
                                confirmButtonColor: "#DD6B55",
                                confirmButtonText: "Yes, Upadte it!",
                                closeOnConfirm: true,
                                closeOnCancel: false 
                                },
                                 function(isConfirm)
                                 {

if (isConfirm) 
                                  {

$(".sweet-alert").hide();
                                    $(".sweet-overlay").hide(); 
                                    $('.update').removeAttr("disabled");
                                    $(".update").text("Update");    
                                    $("#edit_modal").modal("hide");
                                    location.reload();
                                  } 
                                  else 
                                  {
                                    $(".sweet-alert").hide();
                                    $(".sweet-overlay").hide();
                                  }
                              });  
                      
                    }
                    else 
                    {
                        $('.update').removeAttr("disabled");
                        $(".update").text("Update");  
                                      
                    }
                }
           });
  }); 
 
$('#add_assets').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("add-assets-list")?>',
              data   : formdata,
              contentType: false,
              processData: false,
                                      
              success:function(response)
              {
                response=jQuery.parseJSON(response);
                console.log(response);
                  if(response.result==1)
                  { 
                    swal({

title: "Are you sure?",
                            text: "Added Succesfully",
                            type: "warning",   showCancelButton: true,
                            confirmButtonColor: "#DD6B55",
                            confirmButtonText: "Yes, Add it!",
                            closeOnConfirm: true,
                            closeOnCancel: false 
                            },
                             function(isConfirm)
                             {

if (isConfirm) 
                              { 
                                toastr["success"](response.message);
                                $(".sweet-alert").hide();
                                $(".sweet-overlay").hide(); 
                                $('.submit').removeAttr("disabled");
                                $('#add_assets')[0].reset();
                                $(".submit").text("Submit");
                                location.reload();
                              } 
                              else 
                              {
                                toastr["error"](response.message);
                                $(".sweet-alert").hide();
                                $(".sweet-overlay").hide();
                              }
                          }); 
                  
                  }
                  else 
                  {
                     toastr["error"](response.message);
                  }
              }
            });
      
     
      });
$('.add_subcategory').submit(function(e){  
          e.preventDefault();
          formdata = new FormData($(this)[0]);
            $(".sub_submit").text("Submitting...");
            $(".sub_submit").attr("disabled", true);
            $.ajax({
    
              type   : 'post',
              url    : '<?php echo site_url("add-subcategory")?>',
              data   : formdata,
              contentType: false,
              processData: false,
                                      
              success:function(response)
              {
                response=jQuery.parseJSON(response);
                console.log(response);
                  if(response.result==1)
                  { 
                    swal({

if (isConfirm) 
                              { 
                                toastr["success"](response.message);
                                $(".sweet-alert").hide();
                                $(".sweet-overlay").hide(); 
                                $('.sub_submit').removeAttr("disabled");
                                 $('.add_subcategory')[0].reset();
                                $(".sub_submit").text("Submit");
                                location.reload();
                              } 
                              else 
                              {
                                toastr["error"](response.message);
                                $(".sweet-alert").hide();
                                $(".sweet-overlay").hide();
                              }
                          }); 
                  
                  }
                  else 
                  {
                     toastr["error"](response.message);
                      $(".sweet-alert").hide();
                      $(".sweet-overlay").hide(); 
                      $('.sub_submit').removeAttr("disabled");
                      $('.add_subcategory')[0].reset();
                      $(".sub_submit").text("Submit");              
                  }
              }
            });
      
     
      });
function edit_sub(rowId)
  {
    $("#edit_subcat_modal").modal("show");
    var id = rowId.closest('tr').attr('id');
      $.ajax({

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

function delete_sub(rowId)
{
  var id = rowId.closest('tr').attr('id');
  var id = id;
 
   swal({

if (isConfirm) {

$(".sweet-alert").hide();
          $(".sweet-overlay").hide();

$.ajax({
          
          url:"<?php echo site_url("delete-subcategory")?>",
          type:"POST",
          data:{id:id},
          success:function(response) {
            response=jQuery.parseJSON(response);
                console.log(response);

});  
        
         } 
        else {

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

});
}

$('.update_submodal').submit(function(e){  
        e.preventDefault();
         formdata = new FormData($(this)[0]);
            $(".update").text("Updating...");
            $(".update").attr("disabled", true);
            $.ajax({

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

if(response.result==1)
                    {

swal({

if (isConfirm) 
                                  {

$(".sweet-alert").hide();
                                    $(".sweet-overlay").hide(); 
                                    $('.update').removeAttr("disabled");
                                    $(".update").text("Update");    
                                    $("#edit_submodal").modal("hide");
                                    location.reload();
                                  } 
                                  else 
                                  {
                                    $(".sweet-alert").hide();
                                    $(".sweet-overlay").hide();
                                  }
                              });  
                      
                    }
                    else 
                    {
                       
                        $('.update').removeAttr("disabled");
                        $(".update").text("Update");  
                                      
                    }
                }
           });
  }); 
 
</script>
   
<?php $this->load->view('includes/footer'); ?>

</style>