EVOLUTION-NINJA

Edit File: tax_category.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="#">Accounts</a></li>
          <li class="breadcrumb-item"> Tax category </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="tax_category" class="form_submit">
                <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;">Tax Category</span>
                    </div>
                    <div class="col-sm-6"></div>
                </div>
                <div class="form-group" >
                  <div class="row" >
                      <div class="col-sm-6">
                        <label class="col-sm-4" style="padding-top: 20px;padding-left: 0px;">Name<span style="color:red">*</span></label>
                        <input type="text" class="form-control col-sm-12 tax_name" name="tax_name" id="datepick" required>
                      </div>
                      <div class="col-sm-6">
                        <label class="col-sm-4" style="padding-top: 20px;padding-left: 0px;">Type<span style="color:red">*</span></label>
                        <select name="tax_type" class="form-control col-sm-12 tax_type" required="required">
                            <option value="">Select</option>
                            <option value="Goods">Goods</option>
                            <option value="Services">Services</option>
                        </select>
                      </div>
                  </div>
                </div>

<div class="row midd d-block">
                    <p>GST Rate Info</p>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax Rate (IGST)</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control tax_rate_igst" name="tax_rate_igst" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(For Inter-State Transactions)</label>
                      </div>
                    </div>
                  </div>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax Rate (CGST)</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control tax_rate_cgst" name="tax_rate_cgst" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(For Local Transactions)</label>
                      </div>
                    </div>
                  </div>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax Rate (SGST)</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control tax_rate_sgst" name="tax_rate_sgst" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(For Local Transactions)</label>
                      </div>
                    </div>
                  </div>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax on MRP</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control tax_mrp" name="tax_mrp" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(Only for Multi-Tax Vouchers)</label>
                      </div>
                    </div>
                  </div>
                </div>

<div class="row">
                  <div class="col-sm-9"></div>
                  <div class="col-sm-3">
                    <button type="submit" class="btn btn-primary">Save</button>
                    <button type="reset" class="btn">Cancel</button>
                  </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 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 Tax 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_form">
                <input type="hidden" class="form-control id" name="id"/>

<div class="form-group" >
                  <div class="row" >
                      <div class="col-sm-6">
                        <label class="col-sm-4" style="padding-top: 20px;padding-left: 0px;">Name<span style="color:red">*</span></label>
                        <input type="text" class="form-control col-sm-12 m_tax_name" name="tax_name" id="datepick" required>
                      </div>
                      <div class="col-sm-6">
                        <label class="col-sm-4" style="padding-top: 20px;padding-left: 0px;">Type<span style="color:red">*</span></label>
                        <select name="tax_type" class="form-control col-sm-12 m_tax_type" required="required">
                            <option value="">Select</option>
                            <option value="Goods">Goods</option>
                            <option value="Services">Services</option>
                        </select>
                      </div>
                  </div>
                </div>

<div class="row midd d-block">
                    <p>GST Rate Info</p>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax Rate (IGST)</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control m_tax_rate_igst" name="tax_rate_igst" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(For Inter-State Transactions)</label>
                      </div>
                    </div>
                  </div>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax Rate (CGST)</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control m_tax_rate_cgst" name="tax_rate_cgst" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(For Local Transactions)</label>
                      </div>
                    </div>
                  </div>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax Rate (SGST)</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control m_tax_rate_sgst" name="tax_rate_sgst" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(For Local Transactions)</label>
                      </div>
                    </div>
                  </div>
                </div>
                <div class="form-group" >
                  <div class="row">
                    <div class="col-sm-2">
                      <div class="form-group">
                        <label>Tax on MRP</label>
                      </div>
                    </div>
                    <div class="col-sm-4">
                      <div class="form-group">
                        <input type="text" class="form-control m_tax_mrp" name="tax_mrp" required>
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label style="color:darkblue;">(Only for Multi-Tax Vouchers)</label>
                      </div>
                    </div>
                  </div>
                </div>

<div class="modal-footer">
                  <button type="submit" class="btn btn-primary submit">Update</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-tax-category-list')?>",  
  mtype : "get",   
  datatype: "json", 
    colNames:['ID','Tax Name','Tax Type','Tax Rate (IGST)','Tax Rate (CGST)','Tax Rate (SGST)','Tax on MRP','Action'],
  colModel:[
        {name:'id',index:'id', width:100, hidden:true,editable:false},
        {name:'tax_name',index:'tax_name', width:150, hidden:false,editable:false},
        {name:'tax_type',index:'tax_type', width:150, hidden:false,editable:false},
        {name:'tax_rate_igst',index:'tax_rate_igst', width:150, hidden:false,editable:false},
        {name:'tax_rate_cgst',index:'tax_rate_cgst', width:150, hidden:false,editable:false},
        {name:'tax_rate_sgst',index:'tax_rate_sgst', width:150, hidden:false,editable:false},
        {name:'tax_mrp',index:'tax_mrp', 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="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:"Item Group",
      //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
               },

);
}

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

url:"<?php echo site_url("Edit-tax-category-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);
                  $(".m_tax_name").val(response.message.tax_name);
                  $(".m_tax_type").val(response.message.tax_type);
                  $(".m_tax_rate_igst").val(response.message.tax_rate_igst);
                  $(".m_tax_rate_cgst").val(response.message.tax_rate_cgst);
                  $(".m_tax_rate_sgst").val(response.message.tax_rate_sgst);
                  $(".m_tax_mrp").val(response.message.tax_mrp);
               }
                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-tax-category-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-tax-category-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, Update it!",
                                closeOnConfirm: true,
                                closeOnCancel: false 
                                },
                                 function(isConfirm)
                                 {

if (isConfirm) 
                                  { 
                                    toastr["success"]("Updated successfully");
                                    $(".sweet-alert").hide();
                                    $(".sweet-overlay").hide(); 
                                    $('.update').removeAttr("disabled");
                                    $(".update").text("Update");    
                                    $("#edit_modal").modal("hide");
                                    $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                                  } 
                                  else 
                                  {
                                    $(".sweet-alert").hide();
                                    $(".sweet-overlay").hide();
                                  }
                              });  
                      
                    }
                    else 
                    {
                       
                        $('.update').removeAttr("disabled");
                        $(".update").text("Update");  
                                      
                    }
                }
           });
  }); 
 
$('#tax_category').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-tax-category")?>',
              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");
                                 $('#tax_category')[0].reset();
                                $(".submit").text("Submit");
                                location.reload();
                                //$("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');

} 
                              else 
                              {

toastr["error"](response.message);
                              }
                          }); 
                  
                  }
                  else 
                  {
                     toastr["error"](response.message);
                                    
                  }
              }
            });
      
     
      });

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

.midd{
    background: gray;
    margin-bottom: 20px;
  }
  .midd p{
    padding-top: 10px;
    padding-bottom: 10px;
    text-align: center !important; 
    color: white;
  }

</style>