EVOLUTION-NINJA

Edit File: edit_multilevel_budget_old.php

<?php $this->load->view('includes/header'); ?>
    
    
    <div class="content-wrapper">   
      <section class="content-header">
          <?php $id = $this->session->userdata('id');?>    
      </section>
      <section class="content">
        <form  class="add_form" enctype="multipart/form-data" style="padding-top:1%; !important;">
        <div class="container">
          <div class="row" style="padding-top:1%;">
            <div class="col-sm-2">
              <div class="form-group"  style="text-align: right;">
              <label for="name">Select Type:</label>

</div>
            </div>
            <div class="col-sm-4">
              <div class="form-group">
              <select class="form-control selection_data" id="selection_data" >
                <option value="">Select</option>
                <option value="Type of work">Type of work</option>
                <option value="Annexure">Annexure</option>
              </select>
             </div>
            </div>
            <div class="col-sm-4">
              <div class="form-group">
              <button type="button" class="btn  btn-primary add_new_item">Add</button>
             </div>
            </div>
          </div>
        </div>

<div class="row" style="padding-top:1%;">
            <div class="col-sm-2">
              <div class="form-group"  style="text-align: right;">
              <label for="name">Heading of table:</label>

</div>
            </div>
            <div class="col-sm-4">
              <div class="form-group">
              <input type="text" class="form-control heading_table" name="heading_table" required="required">
             </div>
            </div>
            
          </div>

<div class="append_div">
          <div class="table-responsive">
          <table class="table table-bordered tab_space">
          <thead>
          <tr>
          <th>Add / Remove</th>
          <th>SELECT TYPE OF WORK</th>
          <th>WORK NAME</th>
          <th>Material</th>
          <th>L</th>
          <th>B</th>
          <th>D</th>
          <th>No</th>
          <th>TOTAL</th>
          <th>Unit/TOTAL</th>
          <th>RATIO/UNIT</th>
          <th>R.F</th>
          <th>QTY</th>
          <th>UNIT/QTY</th>
          <th>RATE/UNIT</th>
          <th>TAMT</th>
          <th>GST</th>
          <th>GST AMT</th>
          <th>FINAL AMOUNT</th>
          <th>LABOUR CHARGES WITOUT GST</th>
          <th>LABOUR CHARGES 40% WITOUT GST</th>
          
          </tr>
          </thead>
          <tbody>
          </tbody>
          </table>  
          </div>
          <div class="append_submit"></div>
          
        </div>
        </form>
      </section> 
    </div> 
    
      <script>
var row_id='<?php echo $this->uri->segment(2);?>';
var insertion_count='<?php echo $this->uri->segment(3);?>';
get_edit_data();
var inc_num=1;
function get_edit_data()
{
  $.ajax({
                  type   : 'post',
                  url    : '<?php echo site_url("get-edit-data")?>',
                  data   : {'id':row_id,'insertion_count':insertion_count},
                 
                                            
                    success:function(response){
                    response=jQuery.parseJSON(response);
                    console.log(response);

if(response.result==1)
                      {
                         var con='';
                         $('.heading_table').val(response.message[0].table_heading);
                        $.each(response.message,function(key,val){

if(val.type_of_work=='Type of work')
                          {

con+='<tr>';
                            con+='<td style="text-align: center"><input type="hidden" name="insertion_count[]" class="insertion_count" value="'+val.insertion_count+'"><input type="hidden" name="row_id[]" class="row_id" value="'+val.id+'"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+inc_num+',1);" class="fa fa-plus-circle add-officer-row'+inc_num+'" aria-hidden="true" style="color:#C90000"></i></a>&nbsp;&nbsp;<a><i onclick="remove_row('+inc_num+');" class="fa fa-minus-circle remove-officer-button'+inc_num+'" aria-hidden="true" style="color:purple"></i></a></td>';
                            con+='<td> <select name="select_type[]" class=" selection_data" id="selection_data" ><option value="" disabled>Select</option><option value="Type of work" selected>Type of work</option><option value="Annexure" disabled>Annexure</option></select></td>';
                             con+='<td><input type="text" class="" value="'+val.type_of_work_name+'" name="type_of_work_name[]"></td>';
                            con+='<td><input type="text" class="" value="'+val.material+'" name="meterial[]"></td>';
                            con+='<td><input type="text" class="l_name'+inc_num+'" value="'+val.l_data+'" onkeyup="total_calculate('+inc_num+')" name="l_name[]"></td>';
                            con+='<td><input type="text" class="b_name'+inc_num+'" value="'+val.b_data+'" onkeyup="total_calculate('+inc_num+')" name="b_name[]"></td>';
                            con+='<td><input type="text" class="" value="'+val.d_data+'"  name="d_name[]"></td>';
                            con+='<td><input type="text" class="no_name'+inc_num+'" value="'+val.number+'" onkeyup="total_calculate('+inc_num+')" name="no_name[]"></td>';
                            con+='<td><input type="text" class="total_name'+inc_num+'" value="'+val.total+'"  name="total_name[]"></td>';
                            con+='<td><input type="text" class="" value="'+val.unit_total+'" name="unit_name[]"></td>';
                            con+='<td><input type="text" class="" value="'+val.ratio_unit+'"  name="ratio_name[]"></td>';
                            con+='<td><input type="text" class="" value="'+val.rf_data+'"  name="rf_name[]"></td>';
                            con+='<td><input type="text" class="qty_name'+inc_num+'" value="'+val.quantity+'"  name="qty_name[]"></td>';
                            con+='<td><input type="text" class="unit_qty_name'+inc_num+'" value="'+val.unit_quantity+'"   name="unit_qty_name[]"></td>';
                            con+='<td><input type="text" class="rate_unit_name'+inc_num+'" value="'+val.rate_unit+'" onkeyup="total_calculate('+inc_num+')"  name="rate_unit_name[]"></td>';
                            con+='<td><input type="text" class="tamt_name'+inc_num+'" value="'+val.total_amount+'"  name="tamt_name[]"></td>';
                            con+='<td><input type="text" class="gst_name'+inc_num+'" value="'+val.gst+'" onkeyup="total_calculate('+inc_num+')" value="18" name="gst_name[]">%</td>';
                            con+='<td><input type="text" class="gst_amt_name'+inc_num+'" value="'+val.gst_amount+'"  name="gst_amt_name[]"></td>';
                            con+='<td><input type="text" class="final_amount_name'+inc_num+'" value="'+val.final_amount+'"  name="final_amount_name[]"></td>';
                            con+='<td><input type="text" class="l_c_without_gst_name'+inc_num+'" value="'+val.labour_charge_without_gst+'"  name="l_c_without_gst_name[]"></td>';
                            con+='<td><input type="text" class="" value="'+val.labour_charge_fourty_without_gst+'"  name="l_c_fourty_without_gst_name[]"></td>';

con +='</tr>';

}else if(val.type_of_work=='Annexure')
                          {
                            con+=' <tr>';
                            con +='<td style="text-align: center"><input type="hidden" name="insertion_count[]" class="insertion_count" value="'+val.insertion_count+'"><input type="hidden" name="row_id[]" class="row_id" value="'+val.id+'"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+inc_num+',2);" class="fa fa-plus-circle add-officer-row'+inc_num+'" aria-hidden="true" style="color:#C90000"></i></a>&nbsp;&nbsp;<a><i onclick="remove_row('+inc_num+');" class="fa fa-minus-circle remove-officer-button'+inc_num+'" aria-hidden="true" style="color:purple"></i></a></td>';
                            con +='<td><select name="select_type[]" class=" selection_data" id="selection_data" ><option value="" disabled>Select</option><option value="Type of work" disabled>Type of work</option><option value="Annexure" selected>Annexure</option></select></td>';
                             con+='<td><input type="text" class="" value="'+val.type_of_work_name+'" name="type_of_work_name[]"></td>';
                            con +='<td colspan="17"><textarea class="form-control" name="meterial[]">'+val.material+'</textarea>';
                            
                            con+='<input type="hidden" class=""  name="l_name[]"><input type="hidden" class=""  name="b_name[]"><input type="hidden" class=""  name="d_name[]"><input type="hidden" class=""  name="no_name[]"><input type="hidden" class=""  name="total_name[]"><input type="hidden" class=""  name="unit_name[]"><input type="hidden" class=""  name="ratio_name[]"><input type="hidden" class=""  name="rf_name[]"><input type="hidden" class=""  name="qty_name[]"><input type="hidden" class=""  name="unit_qty_name[]"><input type="hidden"  name="rate_unit_name[]"><input type="hidden" class=""  name="tamt_name[]"><input type="hidden" class=""  name="gst_name[]"><input type="hidden" class=""  name="gst_amt_name[]"><input type="hidden" class=""  name="final_amount_name[]"><input type="hidden" class=""  name="l_c_without_gst_name[]"><input type="hidden" class=""  name="l_c_fourty_without_gst_name[]">';
                            con+='</td>';
                            con +='</tr>';

}

inc_num++;
                        });

$('table tbody').append(con);
                          $('.append_submit').empty();
                          $('.append_submit').append('<button type="submit" class="btn  btn-primary add_new_item col-sm-4 offset-sm-4">Submit</button>');        
                      }
                      
                      else 
                      {
                        toastr["error"](response.message);                       
                                       
                      }
                     
                  }
                  
           });
}
        $('.add_new_item').click(function(){
        var seleted_data= $('.selection_data option:selected').val();
        if(seleted_data!='')
        {
             
          var con='';
          if(seleted_data=='Type of work')
          {

con+='<tr>';
            con+='<td style="text-align: center"><input type="hidden" name="insertion_count[]" class="insertion_count"><input type="hidden" name="row_id[]" class="row_id" value="0"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+inc_num+',1);" class="fa fa-plus-circle add-officer-row'+inc_num+'" aria-hidden="true" style="color:#C90000"></i></a>&nbsp;&nbsp;<a><i onclick="remove_row('+inc_num+');" class="fa fa-minus-circle remove-officer-button'+inc_num+'" aria-hidden="true" style="color:purple"></i></a></td>';
            con+='<td> <select name="select_type[]" class=" selection_data" id="selection_data" ><option value="" disabled>Select</option><option value="Type of work" selected>Type of work</option><option value="Annexure" disabled>Annexure</option></select></td>';
             con+='<td><input type="text" class=""  name="type_of_work_name[]"></td>';
            con+='<td><input type="text" class="" value="Architect" name="meterial[]"></td>';
            con+='<td><input type="text" class="l_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="l_name[]"></td>';
            con+='<td><input type="text" class="b_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="b_name[]"></td>';
            con+='<td><input type="text" class=""  name="d_name[]"></td>';
            con+='<td><input type="text" class="no_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="no_name[]"></td>';
            con+='<td><input type="text" class="total_name'+inc_num+'"  name="total_name[]"></td>';
            con+='<td><input type="text" class="" name="unit_name[]"></td>';
            con+='<td><input type="text" class=""   name="ratio_name[]"></td>';
            con+='<td><input type="text" class=""  name="rf_name[]"></td>';
            con+='<td><input type="text" class="qty_name'+inc_num+'"  name="qty_name[]"></td>';
            con+='<td><input type="text" class="unit_qty_name'+inc_num+'"   name="unit_qty_name[]"></td>';
            con+='<td><input type="text" class="rate_unit_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')"  name="rate_unit_name[]"></td>';
            con+='<td><input type="text" class="tamt_name'+inc_num+'"  name="tamt_name[]"></td>';
            con+='<td><input type="text" class="gst_name'+inc_num+'"  onkeyup="total_calculate('+inc_num+')" value="18" name="gst_name[]">%</td>';
            con+='<td><input type="text" class="gst_amt_name'+inc_num+'"  name="gst_amt_name[]"></td>';
            con+='<td><input type="text" class="final_amount_name'+inc_num+'"  name="final_amount_name[]"></td>';
            con+='<td><input type="text" class="l_c_without_gst_name'+inc_num+'"   name="l_c_without_gst_name[]"></td>';
            con+='<td><input type="text" class=""  name="l_c_fourty_without_gst_name[]"></td>';

con +='</tr>';
              
          }
          else
          {
            con+=' <tr>';
            con +='<td style="text-align: center"><input type="hidden" name="insertion_count[]" class="insertion_count"><input type="hidden" name="row_id[]" class="row_id" value="0"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+inc_num+',2);" class="fa fa-plus-circle add-officer-row'+inc_num+'" aria-hidden="true" style="color:#C90000"></i></a>&nbsp;&nbsp;<a><i onclick="remove_row('+inc_num+');" class="fa fa-minus-circle remove-officer-button'+inc_num+'" aria-hidden="true" style="color:purple"></i></a></td>';
            con +='<td><select name="select_type[]" class=" selection_data" id="selection_data" ><option value="" disabled>Select</option><option value="Type of work" disabled>Type of work</option><option value="Annexure" selected>Annexure</option></select></td>';
             con+='<td><input type="text" class=""  name="type_of_work_name[]"></td>';
            con +='<td colspan="17"><textarea class="form-control" name="meterial[]">texting all the text</textarea>';
             
            con+='<input type="hidden" class=""  name="l_name[]"><input type="hidden" class=""  name="b_name[]"><input type="hidden" class=""  name="d_name[]"><input type="hidden" class=""  name="no_name[]"><input type="hidden" class=""  name="total_name[]"><input type="hidden" class=""  name="unit_name[]"><input type="hidden" class=""  name="ratio_name[]"><input type="hidden" class=""  name="rf_name[]"><input type="hidden" class=""  name="qty_name[]"><input type="hidden" class=""  name="unit_qty_name[]"><input type="hidden"  name="rate_unit_name[]"><input type="hidden" class=""  name="tamt_name[]"><input type="hidden" class=""  name="gst_name[]"><input type="hidden" class=""  name="gst_amt_name[]"><input type="hidden" class=""  name="final_amount_name[]"><input type="hidden" class=""  name="l_c_without_gst_name[]"><input type="hidden" class=""  name="l_c_fourty_without_gst_name[]">';
            con+='</td>';
            con +='</tr>';

}
          $('table tbody').append(con);
          $('.append_submit').empty();
          $('.append_submit').append('<button type="submit" class="btn  btn-primary add_new_item col-sm-4 offset-sm-4">Submit</button>');
          inc_num++;
            var inputs = $(".row_count");
            for(var i = 0; i < inputs.length; i++)
            {

$(inputs[i]).val('');
                var f_index=i+1;
                var id = $(inputs[i]).val(f_index); 
            }
        }
        else
        {
          alert('Please select any  option');
        }

});

function remove_row(id)
        {
          
          var whichtr = $('.remove-officer-button'+id).closest("tr");
          whichtr.remove(); 
          var inputs = $(".row_count");
          
          for(var i = 0; i < inputs.length; i++)
          {

$(inputs[i]).val('');
            var f_index=i+1;
            var id = $(inputs[i]).val(f_index); 
          }
       
        }
         function add_row(id,type)
        {
            var con='';
           
            if(type==1)
            {

con+='<tr>';
              con+='<td style="text-align: center"><input type="hidden" name="insertion_count[]" class="insertion_count"><input type="hidden" name="row_id[]" class="row_id" value="0"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+inc_num+',1);" class="fa fa-plus-circle add-officer-row'+inc_num+'" aria-hidden="true" style="color:#C90000"></i></a>&nbsp;&nbsp;<a><i onclick="remove_row('+inc_num+');" class="fa fa-minus-circle remove-officer-button'+inc_num+'" aria-hidden="true" style="color:purple"></i></a></td>';
              con+='<td> <select name="select_type[]" class=" selection_data" id="selection_data" ><option value="" disabled>Select</option><option value="Type of work" selected>Type of work</option><option value="Annexure" disabled>Annexure</option></select></td>';
               con+='<td><input type="text" class=""  name="type_of_work_name[]"></td>';
              con+='<td><input type="text" class="" value="Architect" name="meterial[]"></td>';
              con+='<td><input type="text" class="l_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="l_name[]"></td>';
              con+='<td><input type="text" class="b_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="b_name[]"></td>';
              con+='<td><input type="text" class=""  name="d_name[]"></td>';
              con+='<td><input type="text" class="no_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="no_name[]"></td>';
              con+='<td><input type="text" class="total_name'+inc_num+'"  name="total_name[]"></td>';
              con+='<td><input type="text" class=""  name="unit_name[]"></td>';
              con+='<td><input type="text" class=""  name="ratio_name[]"></td>';
              con+='<td><input type="text" class=""  name="rf_name[]"></td>';
              con+='<td><input type="text" class="qty_name'+inc_num+'"   name="qty_name[]"></td>';
              con+='<td><input type="text" class=""   name="unit_qty_name[]"></td>';
              con+='<td><input type="text" class="rate_unit_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')"  name="rate_unit_name[]"></td>';
              con+='<td><input type="text" class="tamt_name'+inc_num+'"  name="tamt_name[]"></td>';
              con+='<td><input type="text" class="gst_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" value="18"  name="gst_name[]">%</td>';
              con+='<td><input type="text" class="gst_amt_name'+inc_num+'"  name="gst_amt_name[]"></td>';
              con+='<td><input type="text" class="final_amount_name'+inc_num+'"  name="final_amount_name[]"></td>';
              con+='<td><input type="text" class="l_c_without_gst_name'+inc_num+'"   name="l_c_without_gst_name[]"></td>';
              con+='<td><input type="text" class=""  name="l_c_fourty_without_gst_name[]"></td>';

con +='</tr>';
            }
            else
            {
              con+=' <tr>';
              con +='<td style="text-align: center"><input type="hidden" name="insertion_count[]" class="insertion_count"><input type="hidden" name="row_id[]" class="row_id" value="0"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+inc_num+',2);" class="fa fa-plus-circle add-officer-row'+inc_num+'" aria-hidden="true" style="color:#C90000"></i></a>&nbsp;&nbsp;<a><i onclick="remove_row('+inc_num+');" class="fa fa-minus-circle remove-officer-button'+inc_num+'" aria-hidden="true" style="color:purple"></i></a></td>';
              con +='<td><select name="select_type[]" class=" selection_data" id="selection_data" ><option value="" disabled>Select</option><option value="Type of work" disabled>Type of work</option><option value="Annexure" selected>Annexure</option></select></td>';
               con+='<td><input type="text" class=""  name="type_of_work_name[]"></td>';
              con +='<td colspan="17"><textarea class="form-control" name="meterial[]">texting all the text</textarea> ';
              
                con+='<input type="hidden" class=""  name="l_name[]"><input type="hidden" class=""  name="b_name[]"><input type="hidden" class=""  name="d_name[]"><input type="hidden" class=""  name="no_name[]"><input type="hidden" class=""  name="total_name[]"><input type="hidden" class=""  name="unit_name[]"><input type="hidden" class=""  name="ratio_name[]"><input type="hidden" class=""  name="rf_name[]"><input type="hidden" class=""  name="qty_name[]"><input type="hidden" class=""  name="unit_qty_name[]"><input type="hidden"  name="rate_unit_name[]"><input type="hidden" class=""  name="tamt_name[]"><input type="hidden" class=""  name="gst_name[]"><input type="hidden" class=""  name="gst_amt_name[]"><input type="hidden" class=""  name="final_amount_name[]"><input type="hidden" class=""  name="l_c_without_gst_name[]"><input type="hidden" class=""  name="l_c_fourty_without_gst_name[]">';
               con+='</td>';
              con +='</tr>';
            }

$('.add-officer-row'+id).closest('tr').after(con);
        inc_num++;
         var inputs = $(".row_count");
            for(var i = 0; i < inputs.length; i++)
            {

$(inputs[i]).val('');
              var f_index=i+1;
              var id = $(inputs[i]).val(f_index); 
            
            }
        }

$('.add_form').submit(function(e){

e.preventDefault();

formdata = new FormData($(this)[0]);
    swal({

title: "Are you sure?",
      text: "You want to Save this?",
      type: "warning",   showCancelButton: true,
      confirmButtonColor: "#DD6B55",
      confirmButtonText: "Yes!",
      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('update-multilevel-budget');?>",
              data : formdata,
              contentType: false,
              processData: false,
              success:function(response) {
                response=jQuery.parseJSON(response);
                console.log(response);
                if(response.result == 1)
                {
                  toastr["success"](response.message);
                  setTimeout(function wait(){
                   window.location = '<?php echo site_url("budgets-new")?>';
                    }, 1000);
                } 
                else
                {
                  toastr["error"](response.message);
                }

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

});

var f_qty=parseFloat(final_total)*parseFloat(no_name);
  var Qty=$('.qty_name'+id).val(f_qty);
  //rate unit calculation
  var rate_unit=$('.rate_unit_name'+id).val();
  if(rate_unit==''||(isNaN(rate_unit)))
  {
    var rate_unit=0;
  }
  var total_amount=parseFloat(rate_unit)*f_qty;
  var tamt_name=$('.tamt_name'+id).val(total_amount);

// gst amount calculation
  var gst=$('.gst_name'+id).val();

if(gst=='' ||(isNaN(gst)))
  {
    var gst=0;
  }
  var gst_amt=parseFloat(total_amount)*gst;
  var gst_amt_name=$('.gst_amt_name'+id).val(gst_amt);

// final amount calculation
  var gst=$('.gst_name'+id).val();

if(gst=='' ||(isNaN(gst)))
  {
    var gst=0;
  }
    var final_amount=parseFloat(gst_amt)*total_amount;
  var final_amount=$('.final_amount_name'+id).val(final_amount);

//labour charges
  $('.l_c_without_gst_name'+id).val(total_amount);
}

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