EVOLUTION-NINJA
Edit File: Ledger.php
<?php $this->load->view('includes/header'); ?> <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> <<!-- script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> --> <script src="//geodata.solutions/includes/countrystatecity.js"></script> <!----------------------------- Left MENU END ---------------------------------------------------> <!-- Content Wrapper. Contains page content --> <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="#">Contractor</a></li> <li class="breadcrumb-item"> Ledger </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"> <div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;"> <div class="col-sm-12 col-md-3"> <button type="button" class="btn btn-primary " data-toggle="modal" data-target="#impcustomer">Add Ledger</button> </div> <div class="col-sm-9" style="text-align: right;"> </div> </div> <div id ="alljaytab" style="margin-top:3%;" class="grid table-responsive"> <table id="list0"></table> <div id="pager0"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> <div class="modal fade add_group_model" id="impcustomer" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xl" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="ModalLabel">Add Ledger</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <form class="forms-sample add_ledger" enctype="multipart/form-data"> <div class="modal-body"> <div class="row"> <div class="col-sm-3"> <div class="form-group"> <label>Name</label> <input type="text" name="name" class="form-control" required="" > </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>OPl</label> <input type="text" name="opl" class="form-control" required=""> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Credit/Debit</label> <select type="text" name="credit_debit" class="form-control credit_debit" required> <option value="">Select</option> <option value="Credit">Credit</option> <option value="Debit">Debit</option> </select> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Sub Group</label> <select type="text" name="sub_group_name" class="form-control select_sub_group_id" required> <option value="">Select</option> <?php foreach($result_group as $key => $value) { ?> <option value="<?php echo $value->id; ?>"><?php echo $value->sub_under_group;?></option> <?php } ?> </select> </div> </div> </div> <!--row--> <div class="row"> <div class="col-sm-3"> <div class="form-group"> <label>Group</label> <input type="hidden" name="group_id" class="form-control group_id" required="" > <input type="text" name="" class="form-control group_name" readonly=""> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Sub Group</label> <input type="hidden" name="sub_group_id" class="form-control sub_group_id" required="" > <input type="text" name="" class="form-control sub_group" readonly=""> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Address</label> <input type="text" name="address" class="form-control" required="" > </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Country</label> <input type="text" name="country" class="form-control" required="" value="INDIA"> </div> </div> </div> <!--row--> <div class="row"> <div class="col-sm-3"> <div class="form-group"> <div class="form-group"> <label>State</label> <input type="text" name="state" class="form-control" required="" value="kARNATAKA"> </div> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Type of Dealer</label> <select type="text" name="dealer" class="form-control" required="" > <option value="">Select</option> <option value="Registered">Registered</option> <option value="Unregistered">Un-Registered</option> <option value="Composition">Composition</option> <option value="Govt">Govt.Body</option> <option value="UIN">UIN Holder</option> </select> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Filling freq</label> <select type="text" name="frequently" class="form-control" required="" > <option value="">Select</option> <option value="Not Known">Not Known</option> <option value="Monthly">Monthly</option> <option value="Quartley">Quartley</option> </select> </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>GSTIN/UIN</label> <input type="text" name="gstin" class="form-control" required="" > </div> </div> </div> <!--row--> <div class="row"> <div class="col-sm-3"> <div class="form-group"> <label>Aadhar Number</label> <input type="Number" name="Aadhar" class="form-control" required="" > </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>IT-PAN</label> <input type="text" name="it_pan" class="form-control" required="" > </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>E-mail</label> <input type="email" name="email" class="form-control" required="" > </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Mobile No</label> <input type="Number" name="mobile" class="form-control" required="" > </div> </div> </div> <!--row--> <div class="row"> <div class="col-sm-3"> <div class="form-group"> <label>Tel No</label> <input type="Number" name="Tel" class="form-control" required="" > </div> </div> <div class="col-sm-3"> <div class="form-group"> <label>Contact Person</label> <input type="text" name="Contact" class="form-control" required="" > </div> </div> </div> <!--row--> </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> </div> </div> </div> <div class="modal fade add_group_model" id="edit_modal" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true"> <!-- <div class="modal-dialog modal-md" role="document"> --> <div class="modal-dialog modal-xl" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="ModalLabel">Update Ledger</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <form class="forms-sample update_group" enctype="multipart/form-data"> <input type="hidden" name="id" class="form-control id" > <div class="modal-body"> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label>Name</label> <input type="text" name="name" class="form-control name" required="" > </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>OPl</label> <input type="text" name="opl" class="form-control opl" required=""> </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>Credit/Debit</label> <select type="text" name="credit_debit" class="form-control credit_debit" required> <option value="">Select</option> <option value="Credit">Credit</option> <option value="Debit">Debit</option> </select> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label>Sub Group</label> <select type="text" name="sub_group_name" class="form-control select_sub_group_id" required> <option value="">Select</option> <?php foreach($result_group as $key => $value) { ?> <option value="<?php echo $value->id; ?>"><?php echo $value->sub_under_group;?></option> <?php } ?> </select> </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>Group</label> <input type="hidden" name="group_id" class="form-control group_id" required="" > <input type="text" name="" class="form-control group_name" readonly=""> </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>Sub Group</label> <input type="hidden" name="sub_group_id" class="form-control sub_group_id" required="" > <input type="text" name="" class="form-control sub_group" readonly=""> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label>Address</label> <input type="text" name="address" class="form-control address" required="" > </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>Country</label> <input type="text" name="country" class="form-control countries" required="" value="INDIA"> </div> </div> <div class="col-sm-4"> <div class="form-group"> <div class="form-group"> <label>State</label> <input type="text" name="state" class="form-control states" required="" value="KARNATAKA"> </div> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label>Type of Dealer</label> <select type="text" name="dealer" class="form-control dealer" required="" > <option value="">Select</option> <option value="Registered">Registered</option> <option value="Unregistered">Un-Registered</option> <option value="Composition">Composition</option> <option value="Govt">Govt.Body</option> <option value="UIN">UIN Holder</option> </select> </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>Filling freq</label> <select type="text" name="frequently" class="form-control frequently" required="" > <option value="">Select</option> <option value="Not Known">Not Known</option> <option value="Monthly">Monthly</option> <option value="Quartley">Quartley</option> </select> </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>GSTIN/UIN</label> <input type="text" name="gstin" class="form-control gstin" required="" > </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label>Aadhar Number</label> <input type="Number" name="Aadhar" class="form-control aadhar" required="" > </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>IT-PAN</label> <input type="text" name="it_pan" class="form-control it_pan" required="" > </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>E-mail</label> <input type="email" name="email" class="form-control email" required="" > </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label>Mobile No</label> <input type="Number" name="mobile" class="form-control mobile" required="" > </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>Tel No</label> <input type="Number" name="Tel" class="form-control tel" required="" > </div> </div> <div class="col-sm-4"> <div class="form-group"> <label>Contact Person</label> <input type="text" name="Contact" class="form-control contact" required="" > </div> </div> </div> </div> <div class="modal-footer"> <button type="submit" class="btn btn-primary update">Update</button> <button type="button" class="btn btn-light" data-dismiss="modal">Close</button> </div> </form> </div> </div> </div> <script type="text/javascript"> $(document).ready(function() { }); $("#list0").jqGrid({ url:"<?php echo site_url('get-ledger-list')?>", mtype : "get", datatype: "json", colNames:['id','Group','Sub Group','Name','OPL','Debit','Created by','Created at','Created time','ACTION'], colModel:[ {name:'id',index:'id', width:100, hidden:true,editable:false,key:true}, {name:'group_name',index:'group_name', width:100, hidden:false,editable:false}, {name:'sub_group',index:'sub_group', width:100, hidden:false,editable:false}, {name:'name',index:'name', width:100, hidden:false,editable:false}, {name:'opl',index:'opl', width:100, hidden:false,editable:false}, {name:'credit_debit',index:'credit_debit', width:100, hidden:false,editable:false}, {name:'created_by',index:'created_by', 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}, {name:'',index:'',width:80, search:false,editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; var retVal = ' <a onclick="fun_edit('+rowObject.id+');" href="javascript:void(0);"><i class="fa fa-pencil-square-o" style="color:blue;" aria-hidden="true"></i></a> <a onclick="fun_delete('+rowObject.id+')"; href="javascript:void(0);"><i class="fa fa-trash" style="color:red;" aria-hidden="true"></i></a>'; return retVal; }}, ], 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:"Sub Group 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 }, ); $('.add_ledger').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-ledger")?>', data : formdata, contentType: false, processData: false, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $('.submit').removeAttr("disabled"); $(".submit").text("Submit"); location.reload(); /* $("#list0").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('.add_group_model').modal('hide');*/ } else { toastr["error"](response.message); $('.submit').removeAttr("disabled"); $(".submit").text("Submit"); } } }); }); function fun_delete(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-ledger');?>", data : {'sub_group_id':id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $("#list0").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } function fun_edit(id) { $.ajax({ url:"<?php echo site_url("edit-ledger")?>", 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); $('.select_sub_group_id').val(response.message.sub_under_group_id); $('.name').val(response.message.name); $('.credit_debit').val(response.message.credit_debit); $('.opl').val(response.message.opl); $('.group_name').val(response.message.group_name); $('.group_id').val(response.message.group_id); $('.sub_group_id').val(response.message.sub_group_id); $('.sub_group').val(response.message.sub_group); $(".address").val(response.message.address); $(".aadhar").val(response.message.aadhar); $('.countries').val(response.message.country); $('.states').val(response.message.state); $('.dealer').val(response.message.dealer); $('.frequently').val(response.message.frequently); $('.gstin').val(response.message.gstin); $('.it_pan').val(response.message.it_pan); $('.email').val(response.message.email); $('.mobile').val(response.message.mobile); $('.tel').val(response.message.tel); $('.contact').val(response.message.contact); } else { toastr["error"](response.message); //$(".update").attr("disabled", true); } } }); } $('.update_group').submit(function(e) { e.preventDefault(); formdata = new FormData($(this)[0]); $(".update").text("Submitting..."); $(".update").attr("disabled", true); $.ajax({ type : 'post', url : '<?php echo site_url("update-ledger")?>', data : formdata, contentType: false, processData: false, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $('.update').removeAttr("disabled"); $(".update").text("Update"); $("#list0").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#edit_modal').modal('hide'); } else { toastr["error"](response.message); $('.update').removeAttr("disabled"); $(".update").text("Update"); } } }); }); $('.select_sub_group_id').change(function() { var sub_group_id = $('.select_sub_group_id').val(); $.ajax({ url:"<?php echo site_url("get-group-based-sub-group")?>", type:"POST", data:{sub_group_id:sub_group_id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.group_id').empty(); $('.group_name').empty(); $('.sub_group_id').empty(); $('.sub_group').empty(); $('.group_id').val(response.message.group_id); $('.group_name').val(response.message.group_name); $('.sub_group_id').val(response.message.sub_group_id); $('.sub_group').val(response.message.sub_group); } else { toastr["error"](response.message); //$(".update").attr("disabled", true); } } }); }); </script> <style type="text/css"> .content-wrapper { max-width: 1460px !important; } .row-form { width:100%; } .form_submit label{ padding-top: 20px; } #ui-id-1{ margin-left: 1128px; width: 190.859px; margin-top: 218px; } #search{ margin-right: 30px; } </style> <?php $this->load->view('includes/footer'); ?>