EVOLUTION-NINJA

Edit File: edit_budget_page.php

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

<div class="container">
	<div class="row" style="border-bottom: 1px solid black; padding-top: 20px;">
		<div>
			<h3 style="padding-left: 15px;">Edit Budget List</h3>
		</div>
	</div>						
	<form class="forms-sample edit_budget_list">
		<input type="hidden" class="form-control budget_id"  value="<?php echo $budget->id ;?>"name="budget_id" required="required">
		<div class="row">
			<div class="col-sm-3">
				<div class="form-group">
					<label>Type Of Work</label> 
				   	<select name="type_of_work" class="form-control type_of_work" id="type_of_work" required >
                    	<option value="">Select</option>
                   		<?php foreach($type_of_works as $value){?>
						<option value="<?php echo $value->id; ?>" <?php if($value->id==$budget->type_of_work) {echo 'selected';} ?>><?php echo $value->type_of_work; ?></option>
						<?php } ?>
                  	</select> 
				</div>
			</div>
			<div class="col-sm-3">
				<div class="form-group">
					<label>Material</label>
					<select name="material" class="form-control material" id="material" required onchange="change_material();" >
	                    <option value="">Select</option>
	                   	<?php foreach($materials as $value){?>
						<option value="<?php echo $value->id; ?>" <?php if($value->id==$budget->material) {echo 'selected';} ?>><?php echo $value->material; ?></option>
						<?php } ?>
	                </select> 
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Unit / Quantity</label>
					<input type="text" name="unit_quantity" class="form-control unit_quantity" value="<?php echo $budget->unit_quantity ;?>" readonly >
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Rate / Unit</label>
					<input type="text" name="rate_unit" class="form-control rate_unit" value="<?php echo $budget->rate_unit ;?>" readonly>
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>GST</label>
					<input type="text" name="gst" class="form-control gst" value="<?php echo $budget->gst ;?>" readonly>
				</div>
			</div>
		</div>

<div class="row">
			<div class="col-sm-2">
				<div class="form-group">
					<label>Length</label>
					<input type="text" name="length" class="form-control length" value="<?php echo $budget->length ;?>" required>
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Breadth</label>
					<input type="text" name="breadth" class="form-control breadth" value="<?php echo $budget->breadth ;?>" required >
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Depth</label>
					<input type="text" name="dimension" class="form-control dimension" value="<?php echo $budget->dimention ;?>" required >
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>No</label>
					<input type="text" name="no" class="form-control number" value="<?php echo $budget->number ;?>" required >
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Unit / Total</label>
					<select class="form-control unit_names" name="unit_total" required >
	                    <option value="">Select</option>
	                   	<?php foreach($units as $value){?>
						<option value="<?php echo $value->id; ?>" <?php if($value->id==$budget->unit_total) {echo 'selected';} ?>><?php echo $value->unit_name; ?></option>
						<?php } ?>
	                </select> 
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Total</label>
					<input type="text" name="total" class="form-control total" value="<?php echo $budget->total ;?>" readonly >
				</div>
			</div>	
		</div>

<div class="row">
			<div class="col-sm-2">
				<div class="form-group">
					<label>Ratio / Unit</label>
					<input type="text" name="radio_unit" class="form-control radio_unit" value="<?php echo $budget->radio_unit ;?>" required>
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>R.F</label>
					<input type="text" name="rf" class="form-control rf" value="<?php echo $budget->rf ;?>" required >
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Quantity</label>
					<input type="text" name="quantity" class="form-control quantity" value="<?php echo $budget->Quantity ;?>" readonly>
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Total Amount</label>
					<input type="text" name="total_amount" class="form-control total_amount" value="<?php echo $budget->total_amount ;?>" readonly>
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>GST Amount</label>
					<input type="text" name="gst_amount" class="form-control gst_amount" value="<?php echo $budget->gst_amount ;?>" readonly>
				</div>
			</div>
			<div class="col-sm-2">
				<div class="form-group">
					<label>Final Amount</label>
					<input type="text" name="final_amount" class="form-control final_amount" value="<?php echo $budget->final_amount ;?>" readonly>
				</div>
			</div>
		</div>

<div class="row">
			<div class="col-sm-3">
				<div class="form-group">
					<label>Labour Charges Without GST</label>
					<input type="text" name="labour_without_gst" class="form-control labour_without_gst" value="<?php echo $budget->labour_charges_without_gst ;?>" readonly >
				</div>
			</div>
			<div class="col-sm-3">
				<div class="form-group">
					<label>Labour Charges 40% without GST</label>
					<input type="text" name="labour_without_gst1" class="form-control labour_without_gst1" value="<?php echo $budget->labour_charges_fourty_without_gst ;?>" required >
				</div>
			</div>
		</div>

<div class="modal-footer">
            <button type="submit" class="btn btn-primary submit">Update</button>
            <button type="reset" class="btn btn-primary cancel">Cancel</button>
        </div>
	</form>
</div>

$('.cancel').click(function(){
      window.location = '<?php echo site_url("budget-list")?>';
    });

$('.edit_budget_list').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-budget-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 wait(){
                     window.location = '<?php echo site_url("budget-list")?>';
                      }, 1000);
                  } 
                  else
                  {
                    toastr["error"](response.message);
                  }

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

});

function change_material()
	{
		
		var material_id = $('.material option:selected').val();
		//alert(material_id);
		$.ajax({
	    		type:'post',
	    		url:'<?php echo site_url('fetch-material-id');?>',
	    		data:{"material_id":material_id},
	    		  success:function(response){
	              response=jQuery.parseJSON(response);
	              console.log(response);
	                if(response.result==1)
	                {  
                       // alert(response.message.unit);
						$('.unit_quantity').empty();
						$('.unit_quantity').val(response.message.unit);

$('.rate_unit').empty();
						$('.rate_unit').val(response.message.amount);
						
						var rate_unit = $(".rate_unit").val();
                	  	var tot_rate_unit = rate_unit.replace(/[_\W]+/g, "");
                	  	//alert(rate_unit);

var quantity = $(".quantity").val();
                	  	var tot_quantity = quantity.replace(/[_\W]+/g, "");
                	  	//alert(quantity);
                
                	  	var total_amount=(parseFloat(quantity)* parseFloat(rate_unit));
                	  	$(".total_amount").val(total_amount);
                
                	  	var labour_without_gst=(parseFloat(quantity)* parseFloat(rate_unit));
                	  	$(".labour_without_gst").val(labour_without_gst);

$('.gst').empty();
						$('.gst').val(response.message.material_type);
						var total_amount = $(".total_amount").val();
                	  	var tot_rate_unit = total_amount.replace(/[_\W]+/g, "");

//alert(total_amount);
                
                	  	var gst = $(".gst").val();
                	  	var tot_gst = gst.replace(/[_\W]+/g, "");
                	    // var total = gst.toFixed(2);
                 	  	// alert(total);
                
                	  	var gst_amount=(parseFloat(total_amount)* parseFloat(gst)/100);
                	  	$(".gst_amount").val(gst_amount);
                
                	  	var final_amount=(parseFloat(gst_amount)+ parseFloat(total_amount));
                	  	$(".final_amount").val(final_amount);
						
	                }
	                else 
	                {
	                    toastr["error"](response.message);                
	                }
	            }

});

}

$('.rate_unit').focusout(function(e){
	e.preventDefault(); 
	  	
	  	var units=$(this).val();
        $.ajax({
	    		type:'post',
	    		url:'<?php echo site_url('fetch-unit-id');?>',
	    		data:{"units":units},
	    		success:function(response)
				{
					response=jQuery.parseJSON(response);
					console.log(response);
					if(response.result==1)
					{
	                    //alert(response.message.unit_name);
	                    if(response.message.unit_name == "AREA")
						{
							//alert("a");	
							var length = $(".length").val();
							var tot_length = length.replace(/[_\W]+/g, "");
							//alert(tot_length);

var breadth = $(".breadth").val();
							var tot_breadth = breadth.replace(/[_\W]+/g, "");
							//alert(tot_breadth);

var number = $(".number").val();
							var tot_number = number.replace(/[_\W]+/g, "");
							//alert(tot_number);

var total = (parseFloat(length)+parseFloat(breadth)) * parseFloat(number);
							var res = total.toFixed(2);
							$(".total").val(res);

var quantity=(parseFloat(number)* parseFloat(total));
							var quant_res = total.toFixed(2);
							$(".quantity").val(quant_res);

}
						else if(response.message.unit_name == "CFT")
						{
							var number = $(".number").val();
							var tot_number = number.replace(/[_\W]+/g, "");

var dimension = $(".dimension").val();
							var tot_dimension = dimension.replace(/[_\W]+/g, "");

var breadth = $(".breadth").val();
							var tot_breadth = breadth.replace(/[_\W]+/g, "");

var length = $(".length").val();
							var tot_length = length.replace(/[_\W]+/g, "");

}
	                }
				}					
		}); 	
	});
	
	$('.gst').focusout(function(e){
	  	e.preventDefault();

var total_amount = $(".total_amount").val();
	  	var tot_rate_unit = total_amount.replace(/[_\W]+/g, "");
	  	//alert(total_amount);

var gst = $(".gst").val();
	  	var tot_gst = gst.replace(/[_\W]+/g, "");
	  	//alert(gst);

var gst_amount=(parseFloat(total_amount)* parseFloat(gst)/100);
	  	var gst_amt_res = gst_amount.toFixed(1);
	  	$(".gst_amount").val(gst_amt_res);

var final_amount=(parseFloat(gst_amount)+ parseFloat(total_amount));
	  	var final_amt_res = final_amount.toFixed(2);
	  	$(".final_amount").val(final_amt_res);
	});
	
	$('.rf').focusout(function(e){
	  	e.preventDefault(); 
	  	
	  	 var units=$(".unit_names").val();
	  	 
    $.ajax({
	    	type:'post',
	    	url:'<?php echo site_url('fetch-unit-id');?>',
	    	data:{"units":units},
	    	success:function(response){
	        response=jQuery.parseJSON(response);
	        console.log(response);
	            if(response.result==1)
	            {
	               
	                if(response.message.unit_name == "AREA")
		            {
						//alert("a");	
						var length = $(".length").val();
						var tot_length = length.replace(/[_\W]+/g, "");
						//alert(tot_length);

var breadth = $(".breadth").val();
						var tot_breadth = breadth.replace(/[_\W]+/g, "");
						//alert(tot_breadth);

var number = $(".number").val();
						var tot_number = number.replace(/[_\W]+/g, "");
						//alert(tot_number);

var total = (parseFloat(length)+parseFloat(breadth)) * parseFloat(number);
						var res = total.toFixed(2);
						$(".total").val(res);

var quantity=(parseFloat(number)* parseFloat(total));
						var quant_res = total.toFixed(2);
						$(".quantity").val(quant_res);
						
							var rate_unit = $(".rate_unit").val();
	                    	var tot_rate_unit = rate_unit.replace(/[_\W]+/g, "");
                	  	//alert(rate_unit);
                
                	  	var quantity = $(".quantity").val();
                	  	var tot_quantity = quantity.replace(/[_\W]+/g, "");
                	  	//alert(quantity);
                
                	  	var total_amount=(parseFloat(quantity)* parseFloat(rate_unit));
                	  	$(".total_amount").val(total_amount);
                
                	  	var labour_without_gst=(parseFloat(quantity)* parseFloat(rate_unit));
                	  	$(".labour_without_gst").val(labour_without_gst);
                	  	
                	  	var total_amount = $(".total_amount").val();
                	  	var tot_rate_unit = total_amount.replace(/[_\W]+/g, "");
                	  	//alert(total_amount);
                
                	  	var gst = $(".gst").val();
                	  	var tot_gst = gst.replace(/[_\W]+/g, "");
                	  	
                
                	  	var gst_amount=(parseFloat(total_amount)* parseFloat(gst)/100);
                	  	$(".gst_amount").val(gst_amount);
                
                	  	var final_amount=(parseFloat(gst_amount)+ parseFloat(total_amount));
                	  	$(".final_amount").val(final_amount);

}
					else if(response.message.unit_name == "CFT")
					{
						var number = $(".number").val();
						var tot_number = number.replace(/[_\W]+/g, "");

var dimension = $(".dimension").val();
						var tot_dimension = dimension.replace(/[_\W]+/g, "");

var breadth = $(".breadth").val();
						var tot_breadth = breadth.replace(/[_\W]+/g, "");

var length = $(".length").val();
						var tot_length = length.replace(/[_\W]+/g, "");

var total = (parseFloat(number) * parseFloat(dimension)) * parseFloat(breadth) * parseFloat(length);
						$(".total").val(total);
						
						var ratio_unit= $(".ratio_unit").val();
						var rf= $(".rf").val();
						
						var quantity=(parseFloat(total) * parseFloat(ratio_unit)) / parseFloat(rf);
						var quant_res = quantity.toFixed(2);
						$(".quantity").val(quant_res);
						
						var rate_unit = $(".rate_unit").val();
	                    	var tot_rate_unit = rate_unit.replace(/[_\W]+/g, "");
					
						var total_amount=(parseFloat(quant_res) * parseFloat(tot_rate_unit));
						var total_amount_res = total_amount.toFixed(2);
						$(".total_amount").val(total_amount_res);
						
						//var labour_without_gst=(parseFloat(quantity)* parseFloat(rate_unit));
                	  	$(".labour_without_gst").val(0);
                	  	
                	  	var gst = $(".gst").val();
                	  	var tot_gst = gst.replace(/[_\W]+/g, "");
                	  	
                
                	  	var gst_amount=(parseFloat(total_amount_res)* parseFloat(gst)/100);
                	  	$(".gst_amount").val(gst_amount);
                
                	  	var final_amount=(parseFloat(gst_amount)+ parseFloat(total_amount));
                	  	var final_amount_res = final_amount.toFixed(2);
                	  	$(".final_amount").val(final_amount_res);

}
					else
					{
					    	var number = $(".number").val();
						var tot_number = number.replace(/[_\W]+/g, "");

var dimension = $(".dimension").val();
						var tot_dimension = dimension.replace(/[_\W]+/g, "");

var breadth = $(".breadth").val();
						var tot_breadth = breadth.replace(/[_\W]+/g, "");

var length = $(".length").val();
						var tot_length = length.replace(/[_\W]+/g, "");

});    	
	});

$(".unit_names").change(function (e) {
    var units=$(this).val();    
    $.ajax({
	    	type:'post',
	    	url:'<?php echo site_url('fetch-unit-id');?>',
	    	data:{"units":units},
	    	success:function(response){
	        response=jQuery.parseJSON(response);
	        console.log(response);
	            if(response.result==1)
	            {
	                //alert(response.message.unit_name);
	                if(response.message.unit_name == "AREA")
		            {
						//alert("a");	
						var length = $(".length").val();
						var tot_length = length.replace(/[_\W]+/g, "");
						//alert(tot_length);

var breadth = $(".breadth").val();
						var tot_breadth = breadth.replace(/[_\W]+/g, "");
						//alert(tot_breadth);

var number = $(".number").val();
						var tot_number = number.replace(/[_\W]+/g, "");
						//alert(tot_number);

var total = (parseFloat(length)+parseFloat(breadth)) * parseFloat(number);
						var res = total.toFixed(2);
						$(".total").val(res);

var quantity=(parseFloat(number)* parseFloat(total));
						var quant_res = total.toFixed(2);
						$(".quantity").val(quant_res);

}
					else
					{
						var number = $(".number").val();
						var tot_number = number.replace(/[_\W]+/g, "");

var dimension = $(".dimension").val();
						var tot_dimension = dimension.replace(/[_\W]+/g, "");

var breadth = $(".breadth").val();
						var tot_breadth = breadth.replace(/[_\W]+/g, "");

var length = $(".length").val();
						var tot_length = length.replace(/[_\W]+/g, "");

var total = (parseFloat(number) * parseFloat(dimension)) * parseFloat(breadth) * parseFloat(length);
						$(".total").val(total);
					}
	                    
	            }
	            else 
	            {
	                toastr["error"](response.message);                
	            }
	        }

});   
});

$('.length').focusout(function(e){
	  	e.preventDefault();

total();

});

$('.breadth').focusout(function(e){
	  	e.preventDefault();

total();
	  	
	});

$('.dimension').focusout(function(e){
	  	e.preventDefault();

total();

});

$('.number').focusout(function(e){
	  	e.preventDefault();

total();

});

function total()
	{
		var units = $('.unit_names option:selected').val();   
    	$.ajax({
	    	type:'post',
	    	url:'<?php echo site_url('fetch-unit-id');?>',
	    	data:{"units":units},
	    	success:function(response){
	        response=jQuery.parseJSON(response);
	        console.log(response);
	            if(response.result==1)
	            {
	                //alert(response.message.unit_name);
	                if(response.message.unit_name == "AREA")
		            {
						//alert("a");	
						var length = $(".length").val();
						var tot_length = length.replace(/[_\W]+/g, "");
						//alert(tot_length);