EVOLUTION-NINJA
Edit File: tax_category.php
<?php $this->load->view('includes/header.php')?> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/grid_style.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap-ui.css'); ?>" /> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <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="add_assets" class="form_submit"> --> <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> <!-- Modal --> <!-------------------------------------------------- edit Tax Category-----------------------------------------> <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">×</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> <script type="text/javascript"> 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'); ?> <style type="text/css"> .regis-block{ padding: 15px; background: #fff; } .regist-button{ text-align: center; padding-top: 20px; } .form_submit label{ padding-top: 20px; } .midd{ background: gray; margin-bottom: 20px; } .midd p{ padding-top: 10px; padding-bottom: 10px; text-align: center !important; color: white; } </style>