EVOLUTION-NINJA
Edit File: multiple_site_level_old.php
<?php $this->load->view('includes/header'); ?> <!----------------------------- Left MENU END ---------------------------------------------------> <!-- Content Wrapper. Contains page content --> <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> <!-- /.row --> <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><!------row---> <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> <!-- /.content --> </div> <!-- /.content-wrapper --> <script> var inc_num=1; $('.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="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> <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="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> <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="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> <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="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> <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('add-multilevel-budget');?>", data : formdata, contentType: false, processData: false, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { // alert(); 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(); } }); }); function total_calculate(id) { var l_name=parseFloat($('.l_name'+id).val()); var b_name=parseFloat($('.b_name'+id).val()); var no_name=parseFloat($('.no_name'+id).val()); if(l_name==''||(isNaN(l_name)) ) { var l_name=0; } if(b_name==''||(isNaN(b_name))) { var b_name=0; } if(no_name=='' ||(isNaN(no_name))) { var no_name=0; } var final_total=(parseFloat(l_name)+parseFloat(b_name))*(parseFloat(no_name)); var total=$('.total_name'+id).val(final_total); 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'); ?>