EVOLUTION-NINJA

Edit File: edit_revised_design.php

<?php $this->load->view('includes/header'); ?>
    
    
      <script src="https://cdnjs.cloudflare.com/ajax/libs/colresizable/1.6.0/colResizable-1.6.min.js" integrity="sha512-pMZ2rgWRGMywzbRAVwGk+auTREN0ldKKjACUSB4cneTgD3kn/6pu//Lxi4l8xSRkY83HENr1vztTnGDySWs0Mg==" crossorigin="anonymous"></script> 
    <div class="" style="padding-left: 30px; padding-right: 30px;">   
      <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;">

<input type="hidden" name="count_id" class="form-control from-group" value="<?php echo $this->uri->segment(3);?>">
          <input type="hidden" name="revised_id" class="form-control from-group" value="<?php echo $this->uri->segment(2);?>">
           <input type="hidden" name="edit" value="edit">
           
        <div class="container">
          <div class="row">
               <div class="col-sm-1">
                 
               </div>
               <div class="col-sm-2" style="text-align: center;">
                
               </div>
               
             
              <div class="col-sm-2">
               <div class="form-group"  style="text-align: right; padding-top: 13px;">
                <label for="name">Design Name:</label>

</div>
              </div>
              <div class="col-sm-3">
                <div class="form-group">
                <select name="table_heading" class="form-control heading_table" readonly>
                  <option value="">Select</option>
                  <?php foreach($details as $key => $value) { ?> 
                    <option value="<?php echo $value->insertion_count; ?>"><?php echo $value->table_heading;?></option>
                  <?php } ?>
                </select> 
               </div>
              </div>
            
           
               <div class="col-sm-1">
                
              
               </div>
               <div class="col-sm-2">
                 <a href="<?php echo site_url('add-design-for-revised');?>/<?php echo $this->uri->segment(2);?>"><button type="button" class="btn btn-sm btn-primary">Select Design</button></a>
              
               </div>
               <div class="col-sm-1">
                 <a href="<?php echo site_url('revised-budget');?>"><button type="button" class="btn btn-sm btn-primary">Back</button></a>
               </div>
             </div>

</div>

<br/>
     
        <div class="append_div">
          <div class="table-responsive">
          <table id="normal">
          <thead>
          <tr>
         
          <th style="border: 1px solid black;font-size: 13px;"></th>  
          <th style="border: 1px solid black;font-size: 13px;">Add / Removezdcsdf</th>
          <th style="border: 1px solid black;font-size: 13px;">TYPE</th>
          <th style="border: 1px solid black;font-size: 13px;">WORK NAME</th>
          <th style="border: 1px solid black;font-size: 13px;">LEVEL</th>
          <th style="border: 1px solid black;font-size: 13px;">PRODUCT TYPE</th>
          <th style="border: 1px solid black;font-size: 13px;">PRODUCTS</th>
          <th style="border: 1px solid black;font-size: 13px;width:100%;">L</th>
          <th style="border: 1px solid black;font-size: 13px;width:100%;">B</th>
          <th style="border: 1px solid black;font-size: 13px;width:100%;">D</th>
          <th style="border: 1px solid black;font-size: 13px;width:100%;">No</th>
          <th style="border: 1px solid black;font-size: 13px;width:100%;">TOTAL</th>
          <th style="border: 1px solid black;font-size: 13px;width:50px">UNIT/TOTAL</th>
          <th style="border: 1px solid black;font-size: 13px;">RATIO/UNIT</th>
          <th style="border: 1px solid black;font-size: 13px;width: 100px;">R.F</th>
          <th style="border: 1px solid black;font-size: 13px;width: 100px;">QTY</th>
          <th style="border: 1px solid black;font-size: 13px;">UNIT/QTY</th>
          <th style="border: 1px solid black;font-size: 13px;">RATE/UNIT</th>
          <th style="border: 1px solid black;font-size: 13px;">TAMT</th>
          <th style="border: 1px solid black;font-size: 13px;width: 100px;">GST</th>
          <th style="border: 1px solid black;font-size: 13px;width: 100px;">GST AMT</th>
          <th style="border: 1px solid black;font-size: 13px;">FINAL AMOUNT</th>
          
          
          </tr>
          </thead>
          <tbody>
          </tbody>
          </table>  
          </div>
          <div class="append_submit"></div>
          
        </div>
     
        </form>
      </section> 
    </div> 
    
      <script>

$("#normal").colResizable({
      liveDrag:true, 
      gripInnerHtml:"<div class='grip'></div>", 
      draggingClass:"dragging", 
            resizeMode:'fit'
        });

$(document).keypress(
  function(event){
  if (event.which == '13') {
  event.preventDefault();
  }
  });

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;
var click_count = 0;

var product = [];
function get_Edit_data()
{
  var design_id = $('.design_id').val();
  $.ajax({
      type   : 'post',
      url    : '<?php echo site_url("get-edit-revised-design-data")?>',
      data   : {'id':row_id},
     
                                
        success:function(response){
        response=jQuery.parseJSON(response);
        console.log(response);

if(response.result==1)
        {
          var con='';
          $('.heading_table').val(response.message[0].table_heading);
          $('.gf_builtup').val(response.message[0].gf_builtup);
          $('.gf_balcony').val(response.message[0].gf_balcony);
          $('.gf_days').val(response.message[0].gf_days);
          $('.mf_builtup').val(response.message[0].mf_builtup);
          $('.mf_balcony').val(response.message[0].mf_balcony);
          $('.mf_days').val(response.message[0].mf_days);

$.each(response.message,function(key,val){
          if(val.type_of_work=='Type of work')
          {

product.push(val.product_type_id);
              //$('.level_id').val(val.level_id);
              con+='<tr>';

con+='<td style="text-align: center;border: 1px solid black;white-space: nowrap;"><a style="padding-right:10px;" class="second_add_new_item aaa'+click_count+' bbb" style="padding-right:10px;" nums='+click_count+'><label class="texttype">A</label></a><a class="second_add_new_item aaa'+click_count+' bbb" nums='+click_count+'><label class="texttype">T</a></td>';

/* 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('+click_count+',1);" class="fa fa-plus-circle add-officer-row'+inc_num+' append_officer_row_first'+click_count+'" 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 style="text-align: center;border: 1px solid black;"><input type="hidden" name="insertion_count" class="insertion_count" value="'+val.insertion_count+'"><input type="hidden" name="edit_id[]" class="" value="'+val.id+'"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a class="add_officer_row append_officer_row'+click_count+'" add_nums='+click_count+' type="type_of_work"><label class="texttype" style="padding-right: 10px;margin-bottom:0; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button-first  remove_officer_row_first'+click_count+'" add_nums='+click_count+' type="type_of_work"><label class="texttype" style="margin-bottom:0;font-size: 25px;">-</label></a></td>';

con+='<td style="border: 1px solid black;"><input type="text" class="first_type_of_work_name'+click_count+'"  value="'+val.type_of_work_name+'" name="type_of_work_name[]"  style="width:65px;background-color:white !important;height:30px;" add_nums='+click_count+'></td>';

con+='<td style="border: 1px solid black;"><select name="level_id[]" style="width:120px;" class="first_level_id'+click_count+'" add_nums='+click_count+'>';
              con+= '<option value="">Select</option>';

$.each(response.level,function(index,ind)
              {
                if(val.level_id == ind.id)
                {
                   con+= '<option value="'+ind.id+'" selected>'+ind.level_name+'</option>';
                }
                else
                {
                   con+= '<option value="'+ind.id+'">'+ind.level_name+'</option>';
                }
               
              });
              con+='</td>';

con+='<td style="border: 1px solid black;"> <select name="product_group_id[]" class="product_group_id'+click_count+'" style="width: 180px;" number='+click_count+'>';
              con+= '<option value="">Select</option>';

$.each(response.products,function(index,p_t)
              {

if(val.product_type_id == p_t.product_group_id)
                {
                  con+= '<option value="'+p_t.product_group_id+'" selected>'+p_t.product_group_name+'</option>';
                }
                else
                {
                  con+= '<option value="'+p_t.product_group_id+'">'+p_t.product_group_name+'</option>';
                }

});
              con+='</td>';

if(val.product_type_id != "0")
             {

$.ajax({
                      url:"<?php echo site_url('Get-products-based-product-group')?>",
                      type:"POST",
                      data:{'product_group_id':val.product_type_id},
                      async:false,
                      success:function(response)
                      {
                        response=jQuery.parseJSON(response);
                        console.log(response);
                        if(response.result == 1)
                        {
                         
                        
                          con+='<td style="border: 1px solid black;"> <select name="product_id[]" class="product_id'+click_count+'" style="width: 180px;" number='+click_count+'>';
             
                          con += '<option>Select</option>';
                          $.each(response.message,function(idx,vx)
                          {
                            if(val.product_id == vx.product_id)
                            {
                              con += '<option value="'+vx.product_id+'" selected>'+vx.product_name+'</option>';
                            }
                            else
                            {
                              con += '<option value="'+vx.product_id+'">'+vx.product_name+'</option>';
                            }
                            
                          });
                          con += '</select>';
                          con += '</td>';
                         
                          $('.product_id'+click_count).empty();
                          $('.product_id'+click_count).append(con);
                        }
                        else
                        {
                           $('.product_id'+click_count).empty();
                           toastr['error']('No Products Added');
                          
                        }
                      }
                  });
             }
             else
             {
                 con+='<td style="border: 1px solid black;"><select name="product_id[]" class="product_id'+click_count+'" style="width: 180px;" number='+click_count+'></select></td>';
             }

con+='<td style="border: 1px solid black;"><input type="text" class="l_name'+inc_num+'" value="'+val.l_data+'" onkeyup="total_calculate('+inc_num+')" name="l_name[]" style="width:100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="b_name'+inc_num+'" value="'+val.b_data+'" onkeyup="total_calculate('+inc_num+')" name="b_name[]" style="width:100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text"class="d_name'+inc_num+'" value="'+val.d_data+'"  name="d_name[]" onkeyup="total_calculate('+inc_num+')" style="width:100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="no_name'+inc_num+'" value="'+val.number+'" onkeyup="total_calculate('+inc_num+')" name="no_name[]" style="width: 100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="total_name'+inc_num+'" value="'+val.total+'"  name="total_name[]" style="width:100%;height:30px;" readonly></td>';
                //con+='<td style="width: 80px; border: initial;"><input type="text"  class="first_unit_ids_'+click_count+' unit_name'+inc_num+'" number='+click_count+' name="unit_id[]" value="'+val.unit_total+'" style="width: 100%; border: initial;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;">';
                con+='<select name="unit_id[]" style="width:50px;" >';
                con+= '<option value="">Select</option>';
                if(val.unit_total == "CFT")
                {
                con+= '<option value="CFT" selected>CFT</option>';
                }
                else
                {
                con+= '<option value="CFT">CFT</option>';
                }
                
                if(val.unit_total == "SFT")
                {
                con+= '<option value="SFT" selected>SFT</option>';
                }
                else
                {
                con+= '<option value="SFT">SFT</option>';
                }
                if(val.unit_total == "RFT")
                {
                con+= '<option value="RFT" selected>RFT</option>';
                }
                else
                {
                con+= '<option value="RFT">RFT</option>';
                }
                if(val.unit_total == "NOS")
                {
                con+= '<option value="NOS" selected>NOS</option>';
                }
                else
                {
                con+= '<option value="NOS">NOS</option>';
                }
                con+='</select>';
                con+='</td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="ratio_unit'+inc_num+'" value="'+val.ratio_unit+'"  name="ratio_name[]" onkeyup="total_calculate('+inc_num+')" style="width: 100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="rf'+inc_num+'" value="'+val.rf_data+'"  name="rf_name[]" onkeyup="total_calculate('+inc_num+')"style="width: 100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="qty_name'+inc_num+'" value="'+val.quantity+'"  name="qty_name[]"style="width: 100%;height:30px;" readonly></td>';
                /*con+='<td style="border: 1px solid black;"><select name="unit_qty_name[]" style="width:120px;">';
                con+= '<option value="">Select</option>';
                
                $.each(response.unit_master,function(index,val_unit)
                {
                if(val.unit_quantity == val_unit.unit_name)
                {
                con+= '<option value="'+val_unit.unit_name+'" selected>'+val_unit.unit_name+'</option>';
                }
                else
                {
                con+= '<option value="'+val_unit.unit_name+'">'+val_unit.unit_name+'</option>';
                }
                
                });
                con+='</td>';*/
                con+='<td style="border: 1px solid black;"><input type="text" class="first_unit_ids_'+click_count+'" value="'+val.unit_quantity+'"   name="unit_qty_name[]" style="width: 100%;background-color:white !important;height:30px;" readonly></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="rate_unit_name'+inc_num+' unit_rate'+click_count+'" value="'+val.rate_unit+'" onkeyup="total_calculate('+inc_num+')"  name="rate_unit_name[]"style="width: 100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="tamt_name'+inc_num+'" value="'+val.total_amount+'"  name="tamt_name[]"style="width: 100%;height:30px;" readonly></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  style="display:flex; border-bottom: none !important; border-left: none !important; border-right: none !important;border: 1px solid black;"><input type="text" class="gst_name'+inc_num+' gst'+click_count+'"  onkeyup="total_calculate('+inc_num+')"  name="gst_name[]" value="'+val.gst+'" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="GST" style="width: 100%;background-color:white !important;height:30px;">%</td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="gst_amt_name'+inc_num+'" value="'+val.gst_amount+'"  name="gst_amt_name[]" style="width: 100%;height:30px;" readonly></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="final_amount_name'+inc_num+'" value="'+val.final_amount+'"  name="final_amount_name[]" style="width: 100%;height:30px;" readonly><input type="hidden" class=""  name="meterial[]"></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>';

$(document).on('change','.product_group_id'+click_count,function(e)
              {
           
                 var number          = $(this).attr('number');
                 
                  var product_group_id = $(this).val();
                  $.ajax({
                      url:"<?php echo site_url('Get-products-based-product-group')?>",
                      type:"POST",
                      data:{'product_group_id':product_group_id},
                      async:false,
                      success:function(response)
                      {
                        response=jQuery.parseJSON(response);
                        console.log(response);
                        if(response.result == 1)
                        {
                         
                          var content = '';
                     
                          content += '<option>Select</option>';
                          $.each(response.message,function(idx,vx)
                          {
                            content += '<option value="'+vx.product_id+'">'+vx.product_name+'</option>';
                          });
                          //content += '</select>';
                          $('.product_id'+number).empty();
                          $('.product_id'+number).append(content);
                        }
                        else
                        {
                           $('.product_id'+number).empty();
                           toastr['error']('No Products Added');
                          
                        }
                      }
                  });
              });

$(document).on('change','.product_id'+click_count,function(e)
              {
                var number          = $(this).attr('number');
                var product_id = $(this).val();
                $.ajax({
                    url:"<?php echo site_url('Get-product-based-units')?>",
                    type:"POST",
                    data:{'product_id':product_id},
                    async:false,
                    success:function(response)
                    {
                      response=jQuery.parseJSON(response);
                      console.log(response);
                      if(response.result == 1)
                      {

var unit_price = [];
                        $.each(response.message,function(idx,vx)
                        {
                            var cgst = vx.cgst;
                            var sgst = vx.sgst;
                            var igst = vx.igst;
                            var total_gst = parseFloat(cgst)+parseFloat(sgst)+parseFloat(igst);
                            $('.gst'+number).empty();
                            $('.gst'+number).val(total_gst);

var unit_name = vx.unit_name;
                        
                            $('.first_unit_ids_'+number).empty();
                            $('.first_unit_ids_'+number).val(unit_name);
                            unit_price.push(vx.vendor_unit_price);
                           
                        });
                       
                        var higthest_unit_price= Math.max.apply(Math,unit_price);
                        $('.unit_rate'+number).empty();
                        $('.unit_rate'+number).val(higthest_unit_price);

}
                      else
                      {
                        $('.gst'+number).empty();
                        $('.unit_rate'+number).empty();
                        $('.first_unit_ids_'+number).empty();
                        $('.first_unit_ids_'+number).empty();
                        toastr['error']('No Units Added');
                      }
                    }
                });
              });

}
          else if(val.type_of_work=='Annexure')
          {
            con+=' <tr>';
          
            con+='<td style="text-align: center;border: 1px solid black;"><a class="second_add_new_item aaa'+click_count+'" style="padding-right:10px;" nums='+click_count+'><label class="texttype">A</label></a><a class="second_add_new_item '+click_count+'" nums='+click_count+'><label class="texttype">T</a></td>';

con+='<td style="text-align: center;border: 1px solid black;"><input type="hidden" name="insertion_count" class="insertion_count" value="'+val.insertion_count+'"><input type="hidden" name="edit_id[]" class="" value="'+val.id+'"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a class="add_officer_row append_officer_row'+click_count+'" add_nums='+click_count+' type="0"><label class="texttype" style="padding-right: 10px;margin-bottom:0; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button-first  remove_officer_row_first'+click_count+'" add_nums='+click_count+' type="0"><label class="texttype" style="margin-bottom:0;font-size: 25px;">-</label></a></td>';

con +='<td style="border: 1px solid black;"><select  style="width:45px;" 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 style="border: 1px solid black;"><input type="text" class="first_anexture_name'+click_count+'"  value="'+val.type_of_work_name+'" name="type_of_work_name[]" style="width:65px;background-color:white!important;height:30px;" add_nums='+click_count+'></td>';

con +='<td colspan="17" style="border: 1px solid black;"><textarea class="form-control"style="background-color:white!important;height:50px;" 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_id[]"><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[]"><input type="hidden" class=""  name="product_id[]"><input type="hidden" class=""  name="product_group_id[]"><input type="hidden" class=""  name="level_id[]">';
            con+='</td>';
             con+='<td></td>';
            con +='</tr>';
          }
          click_count++;
          inc_num++;
            });
               var con2 ='';
              con2 +='<div class="row">';
              con2 +='<div class="col-sm-12" style="text-align:center; margin-top:20px;">';
              con2 +='<button type="submit" class="btn  btn-primary add_new_item">Submit</button>';
              con2 +='</div>';
              con2 +='</div>';
              $('.append_submit').append(con2);
            $('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>'); 
          
            $(document).on('click','.remove-officer-button-first',function(e)
            {
                
              var number          = $(this).attr('add_nums');
              var whichtr = $('.remove_officer_row_first'+number).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); 
              }

});       
        }
        else 
        {
          toastr["error"](response.message);                       
                         
        }
      }
  });

var clicks = 0;
  $(document).on('click','.second_add_new_item',function(e)
  {
   
    e.preventDefault();
    var seleted_data = $(this).find('.texttype').text();
   
    var nums          = $(this).attr('nums');
    var number          = $(this).attr('number');
    
    clicks++;
    if(seleted_data!='')
    {
         
      var con='';
      if(seleted_data=='T')
      { 
         $.ajax({
            type   : 'post',
            url    : '<?php echo site_url("get-level")?>',
           
            success:function(response)
            {
              response=jQuery.parseJSON(response);
              console.log(response);
              if(response.result==1)
              {

$('.first_div').hide();
                con+='<tr>';
                con+='<td style="text-align: center;border: 1px solid black;white-space: nowrap;"><a class="second_add_new_item bbb'+clicks+'" style="padding-right:10px;" number='+clicks+'><label class="texttype">A</label></a><a class="second_add_new_item bbb'+clicks+'" number='+clicks+'><label class="texttype">T</a></td>';

/*con+='<td style="text-align: center"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+clicks+',1);" class="fa fa-plus-circle add-officer-row'+inc_num+' append_officer_row'+clicks+'" 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 style="text-align: center"><input type="hidden" name="row_count[]" class="row_count" value="'+officer_click+'"><a class="add_officer_row append_officer_row'+clicks+'" number='+clicks+'><label class="texttype" style="padding-top: 10px; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button  remove_officer_row'+clicks+'" number='+clicks+'><label class="texttype" style="padding-top: 10px; font-size: 25px;">-</label></a></td>';*/

con+='<td style="text-align: center;border: 1px solid black;"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a class="add_officer_row append_officer_row_second'+clicks+'" second_nums='+clicks+' type="type_of_work"><label class="texttype" style="padding-right: 10px;margin-bottom:0; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button-second  remove_officer_row_second'+clicks+'" second_nums='+clicks+' type="type_of_work"><label class="texttype" style="margin-bottom:0;font-size: 25px;">-</label></a></td>';

con+='<td style="border: 1px solid black;"> <select style="width:45px;" name="select_type[]" class="selection_data'+clicks+'" 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 style="border: 1px solid black;"><input type="text" class="second_type_of_work_name'+clicks+'"  name="type_of_work_name[]" placeholder="Work Name" style="width:65px;background-color:white!important;height:30px;" second_nums='+clicks+'> </td>';

con+='<td style="border: 1px solid black;"><select name="level_id[]" style="width:120px;" class="second_level_id'+clicks+'" second_nums='+clicks+'>';
                con+= '<option value="">Select</option>';
               
                $.each(response.message,function(index,val)
                {

con+= '<option value="'+val.id+'">'+val.level_name+'</option>';
                });
                con+='</td>';
                con+='<td style="border: 1px solid black;"> <select name="product_group_id[]" class="product_group_ids'+clicks+'" number='+clicks+' style="width: 180px;">';
                con+= '<option value="">Select</option>';
               
                $.each(response.products,function(index,val)
                {
                    
                    con+= '<option value="'+val.product_group_id+'">'+val.product_group_name+'</option>';
                });
                con+='</td>';
                 con+='<td style="width: 80px; border: 1px solid black;" class="product_ids_'+clicks+'" number='+clicks+'></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="l_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="l_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Length" style="width: 100%;"></td>';
                  con+='<td style="border: 1px solid black;"><input type="text" class="b_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="b_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Breadth" style="width: 100%;"></td>';
                  con+='<td style="border: 1px solid black;"><input type="text" class="d_name'+inc_num+'"  name="d_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Depth" onkeyup="total_calculate('+inc_num+')" style="width: 100%;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="no_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="no_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Number" style="width: 100%;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="total_name'+inc_num+'"  name="total_name[]" style="width: 100%; border: initial;height:30px;" readonly></td>';
              
                //con+='<td style="width: 80px; border: initial;" ><input type="text"  class="second_unit_ids_'+clicks+' unit_name'+inc_num+'" number='+clicks+' name="unit_id[]" placeholder="Unit/Total" style="width: 100%;background-color:white !important;height:30px;"></td>';
                con+='<td style="border: 1px solid black;">';
                      con+='<select name="unit_id[]" style="width:50px;">';
                      con+= '<option value="">Select</option>';
                      con+= '<option value="CFT">CFT</option>';
                      con+= '<option value="SFT">SFT</option>';
                      con+= '<option value="RFT">RFT</option>';
                      con+= '<option value="NOS">NOS</option>';
                      con+='</select>';
                      con+='</td>';
               //con+='<td><input type="text" class="" name="unit_n[]" style="width: 100%; border: initial;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="ratio_unit'+inc_num+'"   name="ratio_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Ratioo/Unit" onkeyup="total_calculate('+inc_num+')" style="width: 100%;"></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="rf'+inc_num+'"  name="rf_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="R.F" onkeyup="total_calculate('+inc_num+')" </td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="qty_name'+inc_num+'"  name="qty_name[]" style="width: 80px; border: initial;height:30px;" placeholder="QTY" readonly></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="second_unit_ids_'+clicks+'"   name="unit_qty_name[]" style="width:100%; border: initial;height:30px;background-color:white !important;" readonly></td>';
               /* con+='<td style="border: 1px solid black;"><select name="unit_qty_name[]" style="width:120px;" >';
                con+= '<option value="">Select</option>';
               
                $.each(response.unit,function(index,val_unit)
                {

con+= '<option value="'+val_unit.unit_name+'">'+val_unit.unit_name+'</option>';
                });
                con+='</td>';*/

con+='<td style="border: 1px solid black;"><input type="text" class="rate_unit_name'+inc_num+' second_unit_rate'+clicks+'" onkeyup="total_calculate('+inc_num+')"  name="rate_unit_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Rate/Unit" ></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="tamt_name'+inc_num+'"  name="tamt_name[]" style="width: 100%; border: initial;height:30px;" placeholder="TAMT" ></td>';
               con+='<td  style="display:flex; border-bottom: none !important; border-left: none !important; border-right: none !important;border: 1px solid black;"><input type="text" class="gst_name'+inc_num+'  second_gst'+clicks+'"  onkeyup="total_calculate('+inc_num+')"  name="gst_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="GST">%</td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="gst_amt_name'+inc_num+'"  name="gst_amt_name[]" style="width: 100%; border: initial;height:30px;" placeholder="GST AMT" readonly></td>';
                con+='<td style="border: 1px solid black;"><input type="text" class="final_amount_name'+inc_num+'"  name="final_amount_name[]" style="width: 100%; border: initial;height:30px;"  placeholder="Final AMT" readonly><input type="hidden" class=""  name="meterial[]"></td>';

con +='</tr>';
                /*$(document).ready(function() {
                  $("#product_name" ).autocomplete({   
                  source: '<?php echo site_url("auto-complete-product-name"); ?>',
                  });
                });*/
                //$('table tbody').append(con);
               $('.aaa'+nums).closest('tr').after(con);
                $('.bbb'+number).closest('tr').after(con);
                
                // $('.aaa').closest('tr').after(con);
                $('.product_group_ids'+clicks).on('change',function()
                {
                   var number          = $(this).attr('number');
                  
                    var product_group_id = $(this).val();
                    $.ajax({
                        url:"<?php echo site_url('Get-products-based-product-group')?>",
                        type:"POST",
                        data:{'product_group_id':product_group_id},
                        async:false,
                        success:function(response)
                        {
                          response=jQuery.parseJSON(response);
                          console.log(response);
                          if(response.result == 1)
                          {
                           
                            var content1 = '';
                            content1 += '<select class="second_product'+number+'"  style="width:180px;" number='+number+' name="product_id[]">';
                            content1 += '<option>Select</option>';
                            $.each(response.message,function(idx,vx1)
                            {
                            content1 += '<option value="'+vx1.product_id+'">'+vx1.product_name+'</option>';
                            });
                            content1 += '</select>';
                           
                          
                            $('.product_ids_'+number).empty();
                            $('.product_ids_'+number).append(content1);
                           
                           
                          }
                          else
                          {
                            $('.product_ids_'+number).empty();
                             toastr['error']('No Products Added');
                          }
                        }
                    });
                  });

$(document).on('change','.second_product'+clicks,function(e)
                {
                  var number          = $(this).attr('number');
                  var product_id = $(this).val();
                  $.ajax({
                      url:"<?php echo site_url('Get-product-based-units')?>",
                      type:"POST",
                      data:{'product_id':product_id},
                      async:false,
                      success:function(response)
                      {
                        response=jQuery.parseJSON(response);
                        console.log(response);
                        if(response.result == 1)
                        {
                         
                         var unit_price = [];
                        $.each(response.message,function(idx,vx)
                        {
                            var cgst = vx.cgst;
                            var sgst = vx.sgst;
                            var igst = vx.igst;
                            var total_gst = parseFloat(cgst)+parseFloat(sgst)+parseFloat(igst);
                            $('.second_gst'+number).empty();
                            $('.second_gst'+number).val(total_gst);

}
                        else
                        {
                            $('.second_gst'+number).empty();
                            $('.second_unit_rate'+number).empty();
                            $('.second_unit_ids_'+number).empty();
                            toastr['error']('No Units Added');
                        }
                      }
                  });
                });
            }
             
            }

});
          
      }
      else
      {
        con+=' <tr>';
        con+='<td style="text-align: center;border: 1px solid black;"><a class="second_add_new_item bbb'+clicks+'" style="padding-right:10px;" number='+clicks+'><label class="texttype">A</label></a><a class="second_add_new_item bbb'+clicks+'" number='+clicks+'><label class="texttype">T</a></td>';

con+='<td style="text-align: center;border: 1px solid black;"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a class="add_officer_row append_officer_row_second'+clicks+'" second_nums='+clicks+' type="0"><label class="texttype" style="padding-right: 10px;margin-bottom:0; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button-second  remove_officer_row_second'+clicks+'" second_nums='+clicks+' type="0"><label class="texttype" style="margin-bottom:0;font-size: 25px;">-</label></a></td>';

/* con+='<td style="text-align: center"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+clicks+',0);" class="fa fa-plus-circle add-officer-row'+inc_num+' append_officer_row'+clicks+'" 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 style="text-align: center"><input type="hidden" name="row_count[]" class="row_count" value="'+officer_click+'"><a class="remove-officer-button  remove_officer_row'+clicks+'" number='+clicks+'><label class="texttype" style="padding-top: 10px; font-size: 25px;">-</label></a></td>';*/

con+='<td style="border: 1px solid black;"><input type="text" class="second_anexture_name'+clicks+'"  name="type_of_work_name[]" style="width:65px;background-color:white!important;height:30px;" second_nums='+clicks+'></td>';

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_id[]"><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[]"><input type="hidden" class=""  name="product_id[]"><input type="hidden" class=""  name="product_group_id[]"><input type="hidden" class=""  name="level_id[]">';
        con+='</td>';
        con+='<td></td>';
        con +='</tr>';

}
     // $('table tbody').append(con);
      $('.aaa'+nums).closest('tr').after(con);
      $('.bbb'+number).closest('tr').after(con);
      $('.append_submit').empty();
     
        var con2 ='';
        con2 +='<div class="row">';
        con2 +='<div class="col-sm-12" style="text-align:center; margin-top:20px;">';
        con2 +='<button type="submit" class="btn  btn-primary add_new_item">Submit</button>';
        con2 +='</div>';
        con2 +='</div>';
        $('.append_submit').append(con2);
        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');
    } 
    $(document).on('click','.remove-officer-button-second',function(e)
    {
   
      var number          = $(this).attr('second_nums');
      var whichtr = $('.remove_officer_row_second'+number).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 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 officer_click = 0;
$(document).on('click','.add_officer_row',function(e)
{

e.preventDefault();
  var seleted_data = $(this).find('.texttype').text();
  var number          = $(this).attr('add_nums');
  var second_nums          = $(this).attr('second_nums');
  var third_nums          = $(this).attr('third_nums');

var type          = $(this).attr('type');
  officer_click++;
  var con='';

if(number != undefined && second_nums == undefined && third_nums == undefined)
  {
    var levels = $('.first_level_id'+number).val();
    var type_of_work_name = $('.first_type_of_work_name'+number).val();
    var anexture_name = $('.first_anexture_name'+number).val();
 
  }
  else if(number == undefined && second_nums != undefined && third_nums == undefined)
  {
    
    var levels = $('.second_level_id'+second_nums).val();
    var type_of_work_name = $('.second_type_of_work_name'+second_nums).val();
    var anexture_name = $('.second_anexture_name'+second_nums).val();
   
  }
  else if(number == undefined && second_nums == undefined && third_nums != undefined)
  {
    var levels = $('.third_level_id'+third_nums).val();
    var type_of_work_name = $('.third_type_of_work_name'+third_nums).val();
    var anexture_name = $('.third_anexture_name'+third_nums).val();
   
  }

if(type== "type_of_work")
  {

$.ajax({
    type   : 'post',
    url    : '<?php echo site_url("get-level")?>',
   
    success:function(response)
    {
      response=jQuery.parseJSON(response);
      console.log(response);
      if(response.result==1)
      {
        var id = $('.click_ids').val();
       
        con+='<tr>';
        con+='<td style="text-align: center;border: 1px solid black;"><a class="officer_second_add_new_item second_rows'+officer_click+'" style="padding-right:10px;" number='+officer_click+'><label class="texttype">A</label></a><a class="officer_second_add_new_item second_rows'+officer_click+'" number='+officer_click+'><label class="texttype">T</a></td>';

con+='<td style="text-align: center;border: 1px solid black;"><input type="hidden" name="row_count[]" class="row_count" value="'+officer_click+'"><a class="remove-officer-button  remove_officer_row'+officer_click+'" number='+officer_click+'><label class="texttype" style="padding-right: 10px;margin-bottom:0; font-size: 20px;">-</label></a></td>';

con+='<td style="border: 1px solid black;"> <select name="select_type[]" class=" selection_data" id="selection_data" style="width:45px;"><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 style="border: 1px solid black;"><input type="text" class="type_of_work_name'+officer_click+'"  name="type_of_work_name[]" style="width:65px;background-color:white!important;height:30px;" value="'+type_of_work_name+'"></td>';
        con+='<td style="border: 1px solid black;"><select name="level_id[]" style="width:120px;" class="level_id'+officer_click+'" number='+officer_click+'>';
        con+= '<option value="">Select</option>';

$.each(response.message,function(index,val)
        {
          if(levels == val.id)
          {
            con+= '<option value="'+val.id+'" selected>'+val.level_name+'</option>';
          }
          else
          {
            con+= '<option value="'+val.id+'">'+val.level_name+'</option>';
          }
        
        });
        con+='</td>';

con+='<td style="border: 1px solid black;"> <select name="product_group_id[]" class="product_gp_ids'+officer_click+'" number='+officer_click+' style="width: 180px;">';
        con+= '<option value="">Select</option>';

$.each(response.products,function(index,val)
        {
          con+= '<option value="'+val.product_group_id+'">'+val.product_group_name+'</option>';
        });
        con+='</td>';
        con+='<td style="width: 80px; border: initial;" class="officer_product_ids_'+officer_click+'" number='+officer_click+'></td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="l_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="l_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Length"></td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="b_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="b_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Breadth"></td>';
       con+='<td style="border: 1px solid black;"><input type="text" class="d_name'+inc_num+'"  name="d_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Depth" onkeyup="total_calculate('+inc_num+')"></td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="no_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="no_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Number"></td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="total_name'+inc_num+'"  name="total_name[]" style="width: 100%; border: initial;height:30px;" placeholder="Total" readonly></td>';
        //con+='<td style="width: 80px; border: initial;" ><input type="text" class="unit_ids_'+officer_click+' unit_name'+inc_num+'" number='+officer_click+' name="unit_id[]" placeholder="Unit/Total" style="width: 100%; border: initial;background-color:white !important;height:30px;" ></td>';
        con+='<td style="border: 1px solid black;">';
        con+='<select name="unit_id[]" style="width:50px;">';
        con+= '<option value="">Select</option>';
        con+= '<option value="CFT">CFT</option>';
        con+= '<option value="SFT">SFT</option>';
        con+= '<option value="RFT">RFT</option>';
        con+= '<option value="NOS">NOS</option>';
        con+='</select>';
        con+='</td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="ratio_unit'+inc_num+'"  name="ratio_name[]" placeholder="Ratioo/Unit" style="width: 100%; border: initial;background-color:white !important;height:30px;" onkeyup="total_calculate('+inc_num+')"></td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="rf'+inc_num+'" name="rf_name[]" placeholder="R.F" style="width: 100%; border: initial;background-color:white !important;height:30px;" onkeyup="total_calculate('+inc_num+')"></td>';

con+='<td style="border: 1px solid black;"><input type="text" class="qty_name'+inc_num+'"   name="qty_name[]" placeholder="QTY" style="width: 100%; border: initial;height:30px;" readonly></td>';
         con+='<td style="border: 1px solid black;"><input type="text" class="unit_ids_'+officer_click+'"   name="unit_qty_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" readonly></td>';
        /*con+='<td style="border: 1px solid black;"><select name="unit_qty_name[]" style="width:120px;">';
        con+= '<option value="">Select</option>';
       
        $.each(response.unit,function(index,val_unit)
        {

con+= '<option value="'+val_unit.unit_name+'">'+val_unit.unit_name+'</option>';
        });
        con+='</td>';*/
        con+='<td style="border: 1px solid black;"><input type="text" class="rate_unit_name'+inc_num+' rate_unit_ids_'+officer_click+'" onkeyup="total_calculate('+inc_num+')"  name="rate_unit_name[]" placeholder="Rate/Unit" style="width: 100%; border: initial;background-color:white !important;height:30px;" ></td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="tamt_name'+inc_num+'"  name="tamt_name[]" placeholder="TAMT" style="width: 100%; border: initial;height:30px;" readonly></td>';
       con+='<td  style="display:flex; border-bottom: none !important; border-left: none !important; border-right: none !important;border: 1px solid black;"><input type="text" class="gst_name'+inc_num+'  third_gst'+officer_click+'"  onkeyup="total_calculate('+inc_num+')"  name="gst_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;"  placeholder="GST">%</td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="gst_amt_name'+inc_num+'"  name="gst_amt_name[]" placeholder="GST AMT" style="width: 100%; border: initial;height:30px;" readonly></td>';
        con+='<td style="border: 1px solid black;"><input type="text" class="final_amount_name'+inc_num+'"  name="final_amount_name[]" placeholder="Final AMT" style="width: 100%; border: initial;height:30px;" readonly><input type="hidden" class=""  name="meterial[]"></td>';
        con +='</tr>';
        
      }
      
      var id = $('.click_ids').val();
      
      $('.append_officer_row'+number).closest('tr').after(con);
      $('.append_officer_row_second'+second_nums).closest('tr').after(con);
      $('.append_officer_row_third'+third_nums).closest('tr').after(con);

$('.product_gp_ids'+officer_click).on('change',function()
      {
        var number          = $(this).attr('number');
        var product_group_id = $(this).val();
        $.ajax({
            url:"<?php echo site_url('Get-products-based-product-group')?>",
            type:"POST",
            data:{'product_group_id':product_group_id},
            async:false,
            success:function(response)
            {
              response=jQuery.parseJSON(response);
              console.log(response);
              if(response.result == 1)
              {
               
                var content1 = '';
                content1 += '<select class="officer_product'+number+'"  style="width:180px;" number='+number+' name="product_id[]">';
                content1 += '<option>Select</option>';
                $.each(response.message,function(idx,vx1)
                {
                content1 += '<option value="'+vx1.product_id+'">'+vx1.product_name+'</option>';
                });
                content1 += '</select>';
               
              
                $('.officer_product_ids_'+number).empty();
                $('.officer_product_ids_'+number).append(content1);
               
               
              }
              else
              {
                $('.officer_product_ids_'+number).empty();
                 toastr['error']('No Products Added');
              }
            }
        });
      });

$(document).on('change','.officer_product'+officer_click,function(e)
      {
        var number          = $(this).attr('number');
        var product_id = $(this).val();
        $.ajax({
            url:"<?php echo site_url('Get-product-based-units')?>",
            type:"POST",
            data:{'product_id':product_id},
            async:false,
            success:function(response)
            {
              response=jQuery.parseJSON(response);
              console.log(response);
              if(response.result == 1)
              {
                var unit_price = [];
                $.each(response.message,function(idx,vx)
                {
                    var cgst = vx.cgst;
                    var sgst = vx.sgst;
                    var igst = vx.igst;
                    var total_gst = parseFloat(cgst)+parseFloat(sgst)+parseFloat(igst);
                    $('.third_gst'+number).empty();
                    $('.third_gst'+number).val(total_gst);

var unit_name = vx.unit_name;
                
                    $('.unit_ids_'+number).empty();
                    $('.unit_ids_'+number).val(unit_name);
                    unit_price.push(vx.vendor_unit_price);
                   
                });
               
                var higthest_unit_price= Math.max.apply(Math,unit_price);
                $('.rate_unit_ids_'+number).empty();
                $('.rate_unit_ids_'+number).val(higthest_unit_price);
              }
              else
              {
                $('.third_gst'+number).empty();
                $('.rate_unit_ids_'+number).empty();
                $('.unit_ids_'+number).empty();
                 toastr['error']('No Units Added');
              }
            }
        });
      });
    }

});
    
  }
  else
  {
   
    var type_of_work_name= $('.type_of_work_name'+number).val()
    con+=' <tr>';
    con+='<td style="text-align: center;border: 1px solid black;"><a class="officer_second_add_new_item second_rows'+officer_click+'" style="padding-right:10px;" number='+officer_click+'><label class="texttype">A</label></a><a class="officer_second_add_new_item second_rows'+officer_click+'" number='+officer_click+'><label class="texttype">T</a></td>';

con+='<td style="border: 1px solid black;"><input type="text" class="anexture_name'+officer_click+'"  name="type_of_work_name[]" style="width:65px;background-color:white!important;height:30px;" number='+officer_click+' value="'+anexture_name+'"></td>';

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_id[]"><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[]"><input type="hidden" class=""  name="product_id[]"><input type="hidden" class=""  name="product_group_id[]"><input type="hidden" class=""  name="level_id[]">';
    con+='</td>';
     con+='<td></td>';
    con +='</tr>';
  }

$('.append_officer_row'+number).closest('tr').after(con);
$('.append_officer_row_second'+second_nums).closest('tr').after(con);
 $('.append_officer_row_third'+third_nums).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); 
}
});

$(document).on('click','.officer_second_add_new_item',function(e)
{

e.preventDefault();
  var seleted_data = $(this).find('.texttype').text();
  var number          = $(this).attr('number');
  officer_click++;
  if(seleted_data!='')
  {
       
    var con='';
    if(seleted_data=='T')
    { 
       $.ajax({
          type   : 'post',
          url    : '<?php echo site_url("get-level")?>',
         
          success:function(response)
          {
            response=jQuery.parseJSON(response);
            console.log(response);
            if(response.result==1)
            {

//$('.first_div').hide();
              con+='<tr>';
              con+='<td style="text-align: center;border: 1px solid black;"><a class="officer_second_add_new_item third_row'+officer_click+'" style="padding-right:10px;" number='+officer_click+'><label class="texttype">A</label></a><a class="officer_second_add_new_item third_row'+officer_click+'" number='+officer_click+'><label class="texttype">T</a></td>';

/*con+='<td style="text-align: center"><input type="hidden" name="row_count[]" class="row_count" value="'+officer_click+'"><a class="add_officer_row append_officer_row'+officer_click+'" number='+officer_click+'><label class="texttype" style="padding-top: 10px; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button  remove_officer_row'+officer_click+'" number='+officer_click+'><label class="texttype" style="padding-top: 10px; font-size: 25px;">-</label></a></td>';*/

/*con+='<td style="text-align: center"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+officer_click+',1);" class="fa fa-plus-circle add-officer-row'+inc_num+' append_officer_row_third'+officer_click+'" 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 style="text-align: center;border: 1px solid black;"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a class="add_officer_row append_officer_row_third'+officer_click+'" third_nums='+officer_click+' type="type_of_work"><label class="texttype" style="padding-right: 10px;margin-bottom:0; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button-third  remove_officer_row_third'+officer_click+'" third_nums='+officer_click+' type="type_of_work"><label class="texttype" style="margin-bottom:0;font-size: 25px;">-</label></a></td>';

con+='<td style="border: 1px solid black;"> <select style="width:45px;" 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 style="border: 1px solid black;"><input type="text" class="third_type_of_work_name'+officer_click+'"  name="type_of_work_name[]" style="width:65px;background-color:white!important;height:30px;" third_nums='+officer_click+'></td>';

con+='<td style="border: 1px solid black;"><select name="level_id[]" style="width:120px;" class="third_level_id'+officer_click+'" third_nums='+officer_click+'>';
              con+= '<option value="">Select</option>';
             
              $.each(response.message,function(index,val)
              {

con+= '<option value="'+val.id+'">'+val.level_name+'</option>';
              });
              con+='</td>';
              con+='<td style="border: 1px solid black;"> <select name="product_group_id[]" class="product_group_ids'+officer_click+'" number='+officer_click+' style="width: 180px;">';
              con+= '<option value="">Select</option>';
             
              $.each(response.products,function(index,val)
              {
                  
                  con+= '<option value="'+val.product_group_id+'">'+val.product_group_name+'</option>';
              });
            con+='</td>';
            con+='<td style="width: 80px;border: 1px solid black;" class="product_ids_'+officer_click+'" number='+officer_click+'></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="l_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="l_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Length"></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="b_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="b_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Breadth"></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="d_name'+inc_num+'"  name="d_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Depth" onkeyup="total_calculate('+inc_num+')"></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="no_name'+inc_num+'" onkeyup="total_calculate('+inc_num+')" name="no_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Number"></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="total_name'+inc_num+'"  name="total_name[]" style="width: 100%; border: initial;height:30px;" placeholder="Total" readonly></td>';
            //con+='<td style="width: 80px; border: initial;"><input type="text" name="unit_id[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" class="second_unit_ids_'+officer_click+' unit_name'+inc_num+'" number='+officer_click+' placeholder="Unit/Total"></td>';
            con+='<td style="border: 1px solid black;">';
            con+='<select name="unit_id[]" style="width:50px;">';
            con+= '<option value="">Select</option>';
            con+= '<option value="CFT">CFT</option>';
            con+= '<option value="SFT">SFT</option>';
            con+= '<option value="RFT">RFT</option>';
            con+= '<option value="NOS">NOS</option>';
            con+='</select>';
            con+='</td>';
            //con+='<td><input type="text" class="" name="unit_name[]" style="width: 100%; border: initial;"></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="ratio_unit'+inc_num+'"   name="ratio_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Ratioo/Unit" onkeyup="total_calculate('+inc_num+')"></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="rf'+inc_num+'"  name="rf_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="R.F" onkeyup="total_calculate('+inc_num+')"></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="qty_name'+inc_num+'"  name="qty_name[]" style="width: 80px; border: initial;height:30px;" placeholder="QTY" readonly></td>';
            con+='<td style="border: 1px solid black;"><input type="text" class="second_unit_ids_'+officer_click+'"   name="unit_qty_name[]" style="width: 100%; border: initial;background-color:white !important; height:30px;" readonly></td>';

/*con+='<td style="border: 1px solid black;"><select name="unit_qty_name[]" style="width:120px;">';
              con+= '<option value="">Select</option>';
             
              $.each(response.unit,function(index,val)
              {

con+= '<option value="'+val.unit_name+'">'+val.unit_name+'</option>';
              });
              con+='</td>';*/
              con+='<td style="border: 1px solid black;"><input type="text" class="rate_unit_name'+inc_num+' second_unit_rates_'+officer_click+'" onkeyup="total_calculate('+inc_num+')"  name="rate_unit_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="Rate/Unit"></td>';
              con+='<td style="border: 1px solid black;"><input type="text" class="tamt_name'+inc_num+'"  name="tamt_name[]" style="width: 100%; border: initial;height:30px;" placeholder="TAMT" readonly></td>';
               con+='<td  style="display:flex; border-bottom: none !important; border-left: none !important; border-right: none !important;border: 1px solid black;"><input type="text" class="gst_name'+inc_num+'  fourth_gst'+officer_click+'"  onkeyup="total_calculate('+inc_num+')"  name="gst_name[]" style="width: 100%; border: initial;background-color:white !important;height:30px;" placeholder="GST">%</td>';
              con+='<td style="border: 1px solid black;"><input type="text" class="gst_amt_name'+inc_num+'"  name="gst_amt_name[]" style="width: 100%; border: initial;;height:30px;" placeholder="GST AMT" readonly></td>';
              con+='<td style="border: 1px solid black;"><input type="text" class="final_amount_name'+inc_num+'"  name="final_amount_name[]" style="width: 100%; border: initial;height:30px;" placeholder="Final AMT" readonly><input type="hidden" class=""  name="meterial[]"></td>';

con +='</tr>';
              /*$(document).ready(function() {
                $("#product_name" ).autocomplete({   
                source: '<?php echo site_url("auto-complete-product-name"); ?>',
                });
              });*/
              //$('table tbody').append(con);
              $('.third_row'+number).closest('tr').after(con);
              $('.second_rows'+number).closest('tr').after(con);
              
              $('.product_group_ids'+officer_click).on('change',function()
              {
                 var number          = $(this).attr('number');
                
                  var product_group_id = $(this).val();
                  $.ajax({
                      url:"<?php echo site_url('Get-products-based-product-group')?>",
                      type:"POST",
                      data:{'product_group_id':product_group_id},
                      async:false,
                      success:function(response)
                      {
                        response=jQuery.parseJSON(response);
                        console.log(response);
                        if(response.result == 1)
                        {
                         
                          var content1 = '';
                          content1 += '<select class="second_product'+number+'"  style="width:180px;" number='+number+' name="product_id[]">';
                          content1 += '<option>Select</option>';
                          $.each(response.message,function(idx,vx1)
                          {
                          content1 += '<option value="'+vx1.product_id+'">'+vx1.product_name+'</option>';
                          });
                          content1 += '</select>';
                         
                        
                          $('.product_ids_'+number).empty();
                          $('.product_ids_'+number).append(content1);
                         
                         
                        }
                        else
                        {
                          $('.product_ids_'+number).empty();
                           toastr['error']('No Products Added');
                        }
                      }
                  });
                });

$(document).on('change','.second_product'+officer_click,function(e)
              {
                var number          = $(this).attr('number');
                var product_id = $(this).val();
                $.ajax({
                    url:"<?php echo site_url('Get-product-based-units')?>",
                    type:"POST",
                    data:{'product_id':product_id},
                    async:false,
                    success:function(response)
                    {
                      response=jQuery.parseJSON(response);
                      console.log(response);
                      if(response.result == 1)
                      {
                       
                       
                        var unit_price = [];
                        $.each(response.message,function(idx,vx)
                        {
                            var cgst = vx.cgst;
                            var sgst = vx.sgst;
                            var igst = vx.igst;
                            var total_gst = parseFloat(cgst)+parseFloat(sgst)+parseFloat(igst);
                            $('.fourth_gst'+number).empty();
                            $('.fourth_gst'+number).val(total_gst);

var unit_name = vx.unit_name;
                        
                            $('.second_unit_ids_'+number).empty();
                            $('.second_unit_ids_'+number).val(unit_name);
                            unit_price.push(vx.vendor_unit_price);
                           
                        });
                       
                        var higthest_unit_price= Math.max.apply(Math,unit_price);
                        $('.second_unit_rates_'+number).empty();
                        $('.second_unit_rates_'+number).val(higthest_unit_price);
                      }
                      else
                      {
                        $('.fourth_gst'+number).empty();
                        $('.second_unit_rates_'+number).empty();
                        $('.second_unit_ids_'+number).empty();
                         toastr['error']('No Units Added');
                      }
                    }
                });
              });
          }
           
          }

});
        
    }
    else
    {
      con+=' <tr>';
       con+='<td style="text-align: center;border: 1px solid black;"><a class="officer_second_add_new_item third_row'+officer_click+'" style="padding-right:10px;" number='+officer_click+'><label class="texttype">A</label></a><a class="officer_second_add_new_item third_row'+officer_click+'" number='+officer_click+'><label class="texttype">T</a></td>';
       
    con+='<td style="text-align: center;border: 1px solid black;"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a class="add_officer_row append_officer_row_third'+officer_click+'" third_nums='+officer_click+' type="0"><label class="texttype" style="padding-right: 10px;margin-bottom:0; font-size: 20px;">+</label></a>&nbsp;&nbsp;<a class="remove-officer-button-third  remove_officer_row_third'+officer_click+'" third_nums='+officer_click+' type="0"><label class="texttype" style="margin-bottom:0;font-size: 25px;">-</label></a></td>';
    /*con+='<td style="text-align: center"><input type="hidden" name="row_count[]" class="row_count" value="'+inc_num+'"><a><i onclick="add_row('+officer_click+',0);" class="fa fa-plus-circle add-officer-row'+inc_num+' append_officer_row_third'+officer_click+'" 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 style="border: 1px solid black;"><select  style="width:45px;" 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 style="border: 1px solid black;"><input type="text" class="third_anexture_name'+officer_click+'"  name="type_of_work_name[]" style="width:65px;background-color:white!important;height:30px;" third_nums='+officer_click+'></td>';
      con +='<td colspan="17" style="border: 1px solid black;"><textarea class="form-control" name="meterial[]" style="background-color:white!important;height:50px;" placeholder="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_id[]"><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[]"><input type="hidden" class=""  name="product_id[]"><input type="hidden" class=""  name="product_group_id[]"><input type="hidden" class=""  name="level_id[]">';
      con+='</td>';
       con+='<td></td>';
      con +='</tr>';

}
   // $('table tbody').append(con);
    $('.third_row'+number).closest('tr').after(con);
    $('.second_rows'+number).closest('tr').after(con);
    $('.append_submit').empty();
   
      var con2 ='';
      con2 +='<div class="row">';
      con2 +='<div class="col-sm-12" style="text-align:center; margin-top:20px;">';
      con2 +='<button type="submit" class="btn  btn-primary add_new_item">Submit</button>';
      con2 +='</div>';
      con2 +='</div>';
      $('.append_submit').append(con2);
      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');
  } 
  $(document).on('click','.remove-officer-button-third',function(e)
    {
   
      var number          = $(this).attr('third_nums');
      var whichtr = $('.remove_officer_row_third'+number).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); 
      }

});   
});

$(document).on('click','.remove-officer-button',function(e)
{
  
  var number          = $(this).attr('number');
  var whichtr = $('.remove_officer_row'+number).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); 
  }

});

$('.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-revised-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("revised-budget")?>';
                    }, 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 d_name=parseFloat($('.d_name'+id).val());
  var no_name=parseFloat($('.no_name'+id).val());
  var unit=$('.unit_name'+id).val();
  var ratio_unit=$('.ratio_unit'+id).val();
  var rf=$('.rf'+id).val();

var rate_unit=$('.rate_unit_name'+id).val();
  if(rate_unit==''||(isNaN(rate_unit)))
  {
    var rate_unit=0;
  }

var f_qty=parseFloat(quantity)*parseFloat(rate_unit);
  $('.tamt_name'+id).val(f_qty);

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

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

var final_amount=parseFloat(f_qty)+parseFloat(gst_amt);
  $('.final_amount_name'+id).val(final_amount.toFixed(2));

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

$(document).ready(function() {
  $(document).on('click','.selected_idss',function(e)
    {
       
            var colors = [];
            $.each($("input[name='selected_ids']:checked"), function() {
                colors.push($(this).val());
            });
            $('.ids').val(colors);
        });
    });

$('table').keydown(function(e){
    var $table = $(this);
    var $active = $('input:focus,select:focus',$table);
    var $next = null;
    var focusableQuery = 'input:visible,select:visible,textarea:visible';
    var position = parseInt( $active.closest('td').index()) + 1;
    console.log('position :',position);
    switch(e.keyCode){
        case 37: // <Left>
            $next = $active.parent('td').prev().find(focusableQuery);   
            break;
        case 38: // <Up>                    
            $next = $active
                .closest('tr')
                .prev()                
                .find('td:nth-child(' + position + ')')
                .find(focusableQuery)
            ;
            
            break;
        case 39: // <Right>
            $next = $active.closest('td').next().find(focusableQuery);            
            break;
        case 40: // <Down>
            $next = $active
                .closest('tr')
                .next()                
                .find('td:nth-child(' + position + ')')
                .find(focusableQuery)
            ;
            break;
    }       
    if($next && $next.length)
    {        
        $next.focus();
    }
});

</script> 
  <style type="text/css">
    .table th, .jsgrid .jsgrid-table th, .table td, .jsgrid .jsgrid-table td {
      padding: 5px !important;
      vertical-align: top;
      border-top: 1px solid #f3f3f3;
      font-size: 11px !important;
  }
  .append_div table input{
  background: none !important;
  border: initial;
}
.append_div table select{
  background: none !important;
  border: initial;
}
.append_div table textarea{
  background: none !important;
  border: initial;
}
.our-scroll {
  height: 300px;
  overflow-y: scroll;
}
.scroll{
    overflow:scroll;
    max-width:100%;
    position:relative;
    }
    #normal thead tr th{
        font-size: 14px;
        font-weight: 400;
    }
    #normal tbody tr td{
        font-size: 14px;
        font-weight: 400;
    }
    .append_div_resp{
        padding-left: 30px;
        padding-right: 30px;
    }
  </style>
<?php $this->load->view('includes/footer'); ?>