EVOLUTION-NINJA

Edit File: edit_tax_invoice_form.php

<?php echo view('includes/header');?>

<link rel="stylesheet" href="<?php echo base_url('public/assets/jquery.sumoselect-master/sumoselect.css');?>">
<script src="<?php echo base_url('public/assets/jquery.sumoselect-master/jquery.sumoselect.min.js');?>"></script>
	<section class="content-header">
				<h1>Tax Invoice Update Form</h1>				
			</section> 
<?php  //print_r($invoice); ?>
			<section class="content">

<section class="content">				
				<div class="col-sm-12 col-md-12">
				<form id="land_owner" class="form-inline invoice_form" method="post">
						<?php foreach($invoice as $invoice_details) { ?>
					<input type="hidden" class="form-control col-sm-8 invoice_id_pk" name="id" value="<?php echo $invoice_details['id'];?>" required="required">
					<input type="hidden" class="form-control col-sm-8 invoice_number"  name="invoice_number" value="<?php echo $invoice_details['invoice_number'];?>" required="required">
						<div class="row land_owner_a">
						
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Project</label>
								<select class="form-control col-sm-8 projects_list" onchange="change_project();" name="project_name" required="required">
								<option value="<?php echo $invoice_details['project_id'];?>"><?php echo $invoice_details['project_name'];?></option>
								  <?php  foreach($project_names as $project_name){?>
								  <option value="<?php echo $project_name->project_id;?>"><?php echo $project_name->project_name;?></option>
								  <?php } ?>
								</select>
								
							</div>
						<?php } ?>	
						</div> 
					<div class="row">
						<div id = "jaytab3" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid" >
							<div class="grid_div"></div>
							<table id="list3"></table>
			  					<div id="pager3"></div>
		     					<div id="dialogSelectRow3" title="Warning" style="display:none">
								 <p>Please select row</p>
		  						</div>
		  						<div class="row land_owner_a">
									<div class="col-sm-4 col-md-4"></div>
									<div class="col-sm-4 col-md-4" style="margin-top:2%;">
										<button type="button" class="btn btn-primary center-block get_site_grid"  onclick="getSelectedRow();" >Submit</button>
									</div>
									<div class="col-sm-4 col-md-4"></div>													
								</div> 	
						</div>
					</div>
					
						<div class="row">
						<div id = "jaytab2" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid2">
							<div class="grid_div"></div>
							<table id="list2"></table>
			  					<div id="pager2"></div>
		     					<div id="dialogSelectRow" title="Warning" style="display:none">
								 <p>Please select row</p>
		  						</div>
		  						<div class="row land_owner_a">
									<div class="col-sm-4 col-md-4"></div>
									<div class="col-sm-4 col-md-4" style="margin-top:2%;">
										<button type="button" class="btn btn-primary center-block get_site_grid"  onclick="getSelectedRow1();" >Submit</button>
									</div>
									<div class="col-sm-4 col-md-4"></div>													
								</div> 	
						</div>
					</div>

<div class="row show-remaining" style="display:none;">
						<?php foreach($invoice as $invoice_details){ 
						//foreach($invoice_details as $val){?>  
							<div class="row land_owner_a">
							
								<div class="form-group col-sm-12 col-md-6">
									<label class="col-sm-4">Invoice Number</label>
									 <input type="text" class="form-control col-sm-8" name="invoice_number" value="<?php echo $invoice_details['invoice_number'];?>" required="required" readonly>
								</div>

</div> 
						
							<div class="row land_owner_a">
								<input type="hidden" class="form-control col-sm-8 site_list" name="site_list" required="required">
								<input type="hidden" class="form-control col-sm-8 site_number" name="site_number"  required="required">
								<div class="form-group col-sm-12 col-md-6">
									<label class="col-sm-4">Invoice Type</label>
									<select class="form-control col-sm-8" id="it" name="invoice_type" onchange="invoice_type(this);" required="required">
									<option value="<?php echo $invoice_details['invoice_type'];?>"><?php echo $invoice_details['invoice_type'];?></option>
									<option value="Tax Invoice">Tax Invoice</option>
									<option value="Proforma Invoice">Proforma Invoice</option>
									</select> 
							</div>

<div class="form-group col-sm-12 col-md-6">
										<label class="col-sm-4">To</label>
										<input type="text" class="form-control col-sm-8" name="invoice_to" required="required" value="<?php echo $invoice_details['invoice_to'];?>">
									</div>
						</div> 
						
						<div class="row land_owner_a">
								<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Date</label>							
								<input type="text" class="form-control col-sm-8 dob date_picker" value="<?php echo $invoice_details['created_at'];?>" name="day" max="">
							</div>
							
							<div class="form-group col-sm-12 col-md-6">	&nbsp; </div>
							
									
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4 col-md-4">Bank Holder Name</label>
								<select class="form-control col-sm-8" name="bank_holder_name" id="sel1">
									<option value="<?php echo $invoice_details['bank_name'];?>"><?php echo $invoice_details['bank_name'];?></option>
									<?php 
									foreach($bank_name as $val)
									{
									?>
										<option value="<?php echo $val->holder_name;?>"><?php echo $val->holder_name;?></option>
									<?php
									}
									?>
								</select>
							</div>
							
						</div>
								
							
						<div class="row land_owner_a">

<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Total SQFT</label>
								 <input type="text" class="form-control col-sm-8 total_sqft" name="total_sqft" value="<?php echo $invoice_details['total_sqft'];?>" required="required">
								 
							</div>
							
							
							
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4 col-md-4">Rate/SQFT</label>
								 <input  type="text" class="col-sm-8 rate_per_sqft"  name="rate_per_sqft" value="<?php echo $invoice_details['rate_per_sqft'];?>" required="required">
							</div>	
							
						</div> 
						<div class="row land_owner_a">

<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Basic Amount</label>
								 <input type="text" class="form-control col-sm-8 total_amt"  name="total_amt" value="<?php echo $invoice_details['without_gst_total_amt'];?>" required="required">
								 
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">SGST</label>
								 <input type="text" class="form-control col-sm-8 sgst"  name="sgst" value="<?php echo $invoice_details['sgst'];?>" required="required">
								 
							</div>
							
						</div> 
						<div class="row land_owner_a">

<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">CGST</label>
								 <input type="text" class="form-control col-sm-8 cgst"  name="cgst" value="<?php echo $invoice_details['cgst'];?>" required="required">
								 
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Total amount</label>
								 <input type="text" class="form-control col-sm-8 total_withgst_amt" onfocusout="myFunction()" value="<?php echo $invoice_details['with_gst_total_amt'];?>"  name="total_withgst_amt" required="required">
								 
							</div>
							
						</div> 
						<?php } ?>
						
						
						<div class="row land_owner_a">
							<div class="form-group col-sm-4 col-md-4"></div>
							<div class="col-sm-4 col-md-4">
								<button type="submit" class="btn btn-primary center-block submit">Update</button>
							</div>
							<div class="col-sm-4 col-md-4"></div>													
						</div> 	
						</div>
					</form>
					
				</div>
			</section>

</style>
	   
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	    
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" />
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" />
						
		<script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script>			
<script type="text/javascript">

var ids=<?php echo $details->id ?>;
var inv = <?php echo json_encode($details->invoice_number ?? ''); ?>; // Ensure it's a valid JS value

$("#list2").jqGrid('navGrid','#pager2',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		);
}

$(document).ready(function (){

grid_load();
	
});

$('#jaytab2').hide();
	 $('#jaytab3').show();
	//$('.get_site_grid').show();
	 $("#list3").jqGrid("setLabel", "rn", "SL");

$("#list3").jqGrid('navGrid','#pager3',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		);
		// Example: Button has data-id="123"

}

$('.date_picker').datepicker({

changeMonth:true,
		changeYear:true,
	    yearRange: "1940:c",
	   // dateFormat: 'yy-mm-dd' 
	    dateFormat: 'dd-mm-yy'

});

$('.invoice_form').submit(function(e){    
        e.preventDefault();
		
		var id = $('.invoice_id_pk').val();
		//alert(id);
         formdata = new FormData($(this)[0]);

$(".submit_button").attr('disabled', 'disabled');
            $(".submit_button").text("Updating...");

$.ajax({

type   : 'post',
                url    : '<?php echo site_url("update-invoice-details")?>',
                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(){ window.location.href = "<?php echo site_url('tax-invoice-form');?>?id="+response.message }, 1500); 
	                             
                    }
                    else if(response.result == 2)
                    {
	                    toastr["error"](response.message);                       
		                $(".submit_button").text("Submit"); 
		                $(".submit_button").removeAttr('disabled');                      
                    }
                    else 
                    {
	                    toastr["error"](response.message);                       
		                $(".submit_button").text("Submit"); 
		                $(".submit_button").removeAttr('disabled');                      
                    }
                   
                }
                
         });
             
     });

// 
function loctionreload() {

toastr["success"]('No data Found for this project');
	 setTimeout(function(){ location.reload(); }, 1500); 
	
}
function getSelectedRow() {
	
        
	 var id; 
	 id = jQuery("#list3").jqGrid('getGridParam','selarrrow');

var row = $("#list3").jqGrid('getGridParam','selrow'); 
	if(row != null ) 
			{	 
	 var $grid = $("#list3"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n,
	
    cellValues1 = [];
    cellValues2 = [];
	for (i = 0, n = selIds.length; i < n; i++) {
    cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id"));
     cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number"));
     var project_id=cellValues1.join(",");
     var site_id=cellValues2.join(",");
	// alert(site_id);
	
     
	}
      $.ajax({          
                        type   : 'post',
                        url    : '<?php echo site_url("get_sites_sqft")?>',
                        data   : {'project_id':cellValues1,'site_id':cellValues2},

success:function(response) {
                        //response=jQuery.parseJSON(response);
								console.log(response);

if(response.result == 1) 
                            {
                           		$('.total_sqft').val(response.message);
                               $('.site_list').val(response.site_id);
                               $('.site_number').val(response.site_number);
							  
                              // $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
                            }
                        }
                    });
      //$('#list3').attr('checked', true);
      $('#list3').addClass( "ui-state-highlight" );
      $('.show-remaining').show();
  }

else $( "#dialogSelectRow3" ).dialog();
      
 }
 
 function getSelectedRow1() {
	
        
	 var id; 
	 id = jQuery("#list2").jqGrid('getGridParam','selarrrow');

var row = $("#list2").jqGrid('getGridParam','selrow'); 
	if(row != null ) 
			{	 
	 var $grid = $("#list2"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n,
	
    cellValues1 = [];
    cellValues2 = [];
	for (i = 0, n = selIds.length; i < n; i++) {
    cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id"));
     cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number"));
     var project_id=cellValues1.join(",");
     var site_id=cellValues2.join(",");
	 //alert(site_id);
	
     
	}
      $.ajax({          
                        type   : 'post',
                        url    : '<?php echo site_url("get_sites_sqft")?>',
                        data   : {'project_id':cellValues1,'site_id':cellValues2},

success:function(response) {
                       // response=jQuery.parseJSON(response);
								console.log(response);

if(response.result == 1) 
                            {
                           		$('.total_sqft').val(response.message);
                               $('.site_list').val(response.site_id);
                               $('.site_number').val(response.site_number);
							  
                               $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
                            }
                        }
                    });
      //$('#list2').attr('checked', true);
      $('#list2').addClass( "ui-state-highlight" );
      $('.show-remaining').show();
  }

else $( "#dialogSelectRow" ).dialog();
      
 }
 
$(".rate_per_sqft").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var rate_per_sqft=$('.rate_per_sqft').val();
	var amount=parseFloat(total_sqft) * parseFloat(rate_per_sqft);
	$('.total_amt').val(amount.toFixed()); 
    
});

$(".total_amt").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var total_amt=$('.total_amt').val();
	var amount=parseFloat(total_amt) / parseFloat(total_sqft);
	$('.rate_per_sqft').val(amount.toFixed()); 
    
});

$(".sgst").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var rate_per_sqft=$('.rate_per_sqft').val();
	var amount=parseFloat(total_sqft) * parseFloat(rate_per_sqft);
	var sgst=$('.sgst').val();
	var cgst=$('.cgst').val();
		var total_sgst=(parseFloat(amount) * parseFloat(sgst))/100;
		var total_cgst=(parseFloat(amount) * parseFloat(cgst))/100;
	if(total_cgst > 0)
	{
	var tot_amount=parseFloat(amount) + parseFloat(total_sgst) + parseFloat(total_cgst);
	}
	else
	{
		var tot_amount=parseFloat(amount) + parseFloat(total_sgst);
	}
	$('.total_withgst_amt').val(tot_amount.toFixed()); 
    
});
$(".cgst").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var rate_per_sqft=$('.rate_per_sqft').val();
	var amount=parseFloat(total_sqft) * parseFloat(rate_per_sqft);
	var sgst=$('.sgst').val();
	var cgst=$('.cgst').val();
		var total_sgst=(parseFloat(amount) * parseFloat(sgst))/100;
		var total_cgst=(parseFloat(amount) * parseFloat(cgst))/100;
	if(total_sgst>0)
	{
	var tot_amount=parseFloat(amount) + parseFloat(total_sgst) + parseFloat(total_cgst);
	}
	else
	{
		var tot_amount=parseFloat(amount) + parseFloat(total_cgst);
	}
	$('.total_withgst_amt').val(tot_amount.toFixed()); 
    
});

function myFunction()
{

var total_withgst_amt=$('.total_withgst_amt').val();
	//alert(total_withgst_amt);
	
	var total_sqft=$('.total_sqft').val();
	
	var sgst=$('.sgst').val();
	
	
	var cgst=$('.cgst').val();
	
	
	var total_gst = parseFloat(sgst)+parseFloat(cgst);
	
	
	var amount = (parseFloat(total_withgst_amt)-(parseFloat(total_withgst_amt)*(100/(100+parseFloat(total_gst)))));

var amount1 = parseFloat(total_withgst_amt)- parseFloat(amount);
	
	var rate_per_sqft = parseFloat(amount1)/parseFloat(total_sqft);
	
	$('.total_amt').val(amount1.toFixed()); 	
	
	$('.rate_per_sqft').val(rate_per_sqft.toFixed()); 
}

function get_row_details(ids) {
    console.log("Fetching data for ID:", ids); // Debugging log to ensure IDs are passed correctly

$.ajax({
        type: 'post',
        url: '<?php echo site_url("get-row-details")?>',
        data: { 'id': ids },
        success: function(response) {
            console.log("Response:", response); // Debugging log to check response data
            if (response.result === 1) {
                // Assuming you're processing and populating the form fields here:
                const sites = JSON.parse(response.message.site_numbers); // Ensure it's parsed correctly
                // Populate your table or fields with the data
                $('#someField').val(response.message.someField); // Example field population
            } else {
                toastr["error"](response.message);
            }
        },
        error: function(xhr, status, error) {
            console.error("AJAX Error:", status, error);
            toastr["error"]("Failed to retrieve data");
        }
    });
}

</script>

<?php echo view('includes/footer');?>