EVOLUTION-NINJA

Edit File: Ledger.php

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

<

<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">&times;</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> 
                           
                            <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>

<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>

<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>

<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> 
                          </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-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">&times;</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>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>

});

$("#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'); ?>