EVOLUTION-NINJA

Edit File: edit_civil_work_order.php

<?php echo view('includes/header');?>
<div class="page-content-wrapper">
	<div class="page-content">	
		<h3 class="page-title"> Edit Civil Work Order</h3>	
		
<script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" />

<form method="post" class="work_po_form">
			
			<table class="inner" border="1">
				<tr>
					<th style="width:18%;">WO #</th> 
					<td><input type="text" name="po_no" id="po_no" pattern="[0-9]+" style="width:45%;border: transparent;" value="<?php if(!empty($po_details)){echo '0000';echo $po_details->po_no; }?>" readonly>
				<select style="width:52%;" name="project_name" id="project_name" style="width:100%;border: transparent;" required>
						
							<option value="<?php if(!empty($po_details)){echo $po_details->project_name; }?>"><?php echo $po_details->project_name; ?> </option>	
					
						<?php
						foreach($owners as $value)
						{
							?>
							
								<option value="<?php echo $value->project_name;?>"><?php echo $value->project_name;?></option>

<?php
						}
						?>
					</select>
				</td>
				<td style="width:60%" rowspan="8">
					<textarea rows="5" id="address" name="address" style="width: 100%; border: transparent;" placeholder="Address :" required readonly><?php if(!empty($po_details)){echo $po_details->vendor_address; }?></textarea>
				</td>
				</tr>
				<tr>
					<th>Vendor</th>
					<td contenteditable="true" ><input type="text" id="vendor_name" name="vendor_name"  onfocusout="vendor_myFunction(this.value)" value="<?php if(!empty($po_details)){echo $po_details->vendor; }?>" style="width: 100%;border: transparent;" readonly required> </td>
				</tr>
				<tr>
					<th>Date</th>
					<td style="width:109px;"><input type="text"  name="g_date" id="g_date"  style="width: 100%;border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->date; }?>" readonly="readonly" required></td>
				</tr>
				<tr >
					<th>Currency</th>
					<td>
						<select name="currency" id="currency" style="width: 100%;border: transparent;" required>
							<option value="INR" <?php if(!empty($po_details) && ($po_details->currency=='INR')){echo "selected"; }?>>INR</option>
							<option value="CHF" <?php if(!empty($po_details) && ($po_details->currency=='CHF')){echo "selected"; }?>>CHF</option>
							<option value="EUR" <?php if(!empty($po_details) && ($po_details->currency=='EUR')){echo "selected"; }?>>EUR</option>
							<option value="GBP" <?php if(!empty($po_details) && ($po_details->currency=='GBP')){echo "selected"; }?>>GBP</option>
							<option value="USD" <?php if(!empty($po_details) && ($po_details->currency=='USD')){echo "selected"; }?>>USD</option>
						</select>
					</td>
				</tr>
				<tr>
					<th>Contact Person</th>
					<td style="width:109px;"><input type="text" pattern="[a-zA-Z\s]+" id="contact_person" name="contact_person" style="width: 100%;border: transparent;" required value="<?php if(!empty($po_details)){echo $po_details->contact_person; }?>"> </td>
				</tr>
				<tr>
					<th>Contact Number</th>
					<td style="width:109px;"><input type="text" pattern="^\d{10}"  name="contact_number" id="contact_number"  style="width: 100%;border: transparent;" required value="<?php if(!empty($po_details)){echo $po_details->contact_number; }?>"></td>
				</tr>
				<tr>
					<th>E-mail ID</th>
					<td style="width:109px;"><input type="email" id="email" name="email" style="width: 100%;border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->email; }?>"> </td>
				<tr>
					<th>From Address</th>
					<td style="width:109px;"><?php if($master_data){ echo $master_data->sname; } ?> </td>
				</tr>

</table>
					
			
			<table style="width:100%; table-layout:fixed; "  border="1">
				<thead class="thead-default">
					<tr>
						<th  width="5%">Sl. No.</th>
						<th  width="19%">Product Name</th>
						<th  width="13%">Indent</th>
						<th  width="13%" >Number</th>
						<th  width="7%" class="inr_val" id="inr_val" name="inr_val">Value</th>
						<th  width="7%" class="chf_val" id="chf_val" name="chf_val" style="display: none;">CHF Value</th>
						<th  width="7%" style="display: none;" class="eur_val" id="eur_val" name="eur_val">EUR Value</th>
						<th  width="7%" style="display: none;" class="gbp_val" id="gbp_val" name="gbp_val">GBP Value</th>
						<th  width="7%" style="display: none;" class="usd_val" id="usd_val" name="usd_val">USD Value</th>
						<th  width="9%">SGST</th>
						<th width="9%">CGST</th>
						<th width="9%">IGST</th>
						<th  width="9%">Total Value</th>
						<th  width="9%">Remarks</th>
					</tr>
				</thead>
				<tbody>
					<?php $c=1;$key=1; foreach($fetch_details as $po_details){?>
					<tr>
						<td scope="row"><?php echo $c;?></td>
						<input type="hidden" id="edit_id<?php echo $key;?>" name="edit_id[]" value="<?php if(!empty($po_details)){echo $po_details->id; }?>" style="width: 100%;border: transparent;" required>
						<td>
							<input type="text" class="p_name<?php echo $key;?>" name="p_name[]" id="p_name<?php echo $key;?>"  value="<?php if(!empty($po_details)){echo $po_details->product_name; }?>" style="border: transparent;text-transform: uppercase !important;" readonly="readonly" required>
						<input type="hidden"  style="width:100%; border:transparent;" class="product_id<?php echo $key;?>" name="product_id[]" id="product_id"  style="border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->product_id; }?>" required>
						</td>
						<td>
							<input type="text"  class="i_no" name="i_no[]" id="i_no<?php echo $key;?>"  value="<?php if(!empty($po_details)){echo $po_details->indent; }?>" style="width:100%; border: transparent;" required>
						</td>
						<td>
							<input type="text" class="purpose"  name="purpose[]" id="purpose"  value="<?php if(!empty($po_details)){echo $po_details->purpose_no; }?>" style="width:100%;border: transparent;text-transform: uppercase !important;" required >
						</td>
						<td>
							<input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo round($po_details->inr_value); }?>" class="inrval inrvalue<?php echo $key;?>" id="inrvalue<?php echo $key;?>" name="inrvalue[]" style="width: 100%;border: transparent; "pattern="[0-9]+" required>
						</td>
						<td>
							<input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->sgst; }?>" class="osgst<?php echo $key;?>" id="sgst<?php echo $key;?>" name="sgst[]" onkeyup="gstvalue1(this.value,<?php echo $key;?>)" style="width: 83%;border: transparent;" pattern="[0-9]+" required> <span>%</span>
						</td>
						<td>
							<input type="text"  pattern="^\d*(\.\d{0,2})?$" class="ocgst<?php echo $key;?>" id="cgst<?php echo $key;?>" name="cgst[]" onkeyup="gstvalue2(this.value,<?php echo $key;?>)" value="<?php if(!empty($po_details)){echo $po_details->cgst; }?>" style="width: 83%;border: transparent;" pattern="[0-9]+" required> <span>%</span>
						</td>
						<td>
							<input type="text"  pattern="^\d*(\.\d{0,2})?$" class="oigst<?php echo $key;?>" id="igst<?php echo $key;?>" name="igst[]" onkeyup="gstvalue3(this.value,<?php echo $key;?>)" value="<?php if(!empty($po_details)){echo $po_details->igst; }?>" style="width: 83%;border: transparent;" pattern="[0-9]+" required> <span>%</span>
						</td>						
						<td>
							<input type="text"  pattern="^\d*(\.\d{0,2})?$" class="totalvalue<?php echo $key;?> tot_val" id="totalvalue<?php echo $key;?>" value="<?php if(!empty($po_details)){echo round((float)$po_details->total_value); }?>" name="totalvalue[]"  style="width: 100%;border: transparent;" required readonly>
						</td>
						<td>
							<input type="text"  style="width:100%; border:transparent;text-transform: uppercase !important;" class="remarks" name="remarks[]" id="remarks" value="<?php if(!empty($po_details)){echo $po_details->remarks; }?>"  >
						</td>			
						
					</tr>
						<?php $c++; $key++; }?>
					<tr>
						<td></td>
						<td colspan="3">
							<input type="text" placeholder="OTHER CHARGES :" name="ot_charges" id="ot_charges" style="width: 100%;border: transparent;text-transform: uppercase !important;"  value="<?php if(!empty($po_details)){echo $po_details->ot_charges; }?>">
						</td>
			     <td>
				    <input type="text" pattern="^\d*(\.\d{0,2})?$" value="<?php if (!empty($po_details)) { echo round((float)$po_details->ot_inr_value); } ?>"  class="inr_value_val" id="inr_value_val" name="inr_value_val"   style="width: 100%;border: transparent;" pattern="[0-9]+" >
                </td>

<td>
							<input type="text" pattern="^\d*(\.\d{0,2})?$"  value="<?php if(!empty($po_details)){echo $po_details->ot_sgst; }?>" class="oosgst ot_sgst" id="ot_sgst" name="ot_sgst" onfocusout="sgstvalue1(this.value)"  style="width: 42%;border: transparent;margin-left: 17px;" pattern="[0-9]+" > <span>%</span>
						</td>
						<td>
							<input type="text"  pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->ot_cgst; }?>" class="oocgst ot_cgst" id="ot_cgst" name="ot_cgst" onfocusout="sgstvalue2(this.value)" style="width: 42%;border: transparent;margin-left: 17px;" pattern="[0-9]+" > <span>%</span>
						</td>
						<td>
							<input type="text"  pattern="^\d*(\.\d{0,2})?$" value="<?php if(!empty($po_details)){echo $po_details->ot_igst; }?>" class="ooigst ot_igst" id="ot_igst" name="ot_igst" onfocusout="sgstvalue3(this.value)" style="width: 42%;border: transparent;margin-left: 17px;"  pattern="[0-9]+"> <span>%</span>
						</td>
						<td>
							<input type="text"  pattern="^\d*(\.\d{0,2})?$" value="<?php if (!empty($po_details)) {echo round(floatval($po_details->ot_total_value), 2);} ?>" class="total_value_val to_val" id="total_value_val" name="total_value_val"  style="width: 100%;border: transparent;" readonly>
						</td>
						<td>
							<input type="text" value="<?php if(!empty($po_details)){echo $po_details->otc_remarks; }?>" style="width: 100%;border: transparent;text-transform: uppercase !important;" class="otc_remarks" name="otc_remarks" id="remarks"  style="width: 100%;border: transparent;">
						</td>
					</tr>
					<tr>
						<td rowspan="4" colspan="7">
							<textarea rows="3" id="note" name="note" style="width: 100%; border: transparent; margin-top: -15px;text-transform: uppercase !important;" placeholder="NOTE : " > <?php if(!empty($po_details)){echo $po_details->note; }?></textarea>
						</td>
						<td colspan="2">TOTAL AMOUNT</td>
					<td> 
					<input type="text" class="total_amt" id="total_amt" value="<?php if (!empty($po_details)) { echo round((float)$po_details->total_amt); } ?>"   name="total_amt" style="width: 100%; border: transparent;"  readonly="readonly" required onfocusin="amount_total1()">
                   </td>
						
					</tr>
					<tr>
						<td colspan="2">DISCOUNT %</td>
						<td>
							<input type="text"  pattern="^\d*(\.\d{0,2})?$" class="discount" id="discount" name="discount" value="<?php if(!empty($po_details)){echo $po_details->discount; }?>" onkeyup="discountvalue(this.value)"  style="width: 74%;border: transparent;" pattern="[0-9]+" required> <span>%</span>
						</td>
					</tr>
					<tr>
						<td colspan="2">TDS %</td>
						<td>
							<input type="text" pattern="^\d*(\.\d{0,2})?$" class="tds" id="tds" name="tds" value="<?php if(!empty($po_details)){echo $po_details->tds; }?>" onkeyup="tdsvalue(this.value)" pattern="[0-9]+"  style="width: 74%;border: transparent;" > <span>%</span>
						</td>
					</tr>
					<tr>
						<td colspan="2">GRAND TOTAL</td>
						<td>
							<input type="text" class="g_total" id="g_total" name="g_total"  style="width: 100%;border: transparent;"  readonly="readonly" required>
						</td>
					</tr>
					<tr>
						<td colspan="10">
								Terms and Conditions:	<br/>
1. Material Delivery :<input type="text" class="comment" id="comment" value="<?php if(!empty($po_details)){echo $po_details->material_delivery; }?>" name="comment"  style="width: 70%;border: transparent; text-transform: uppercase !important;" > <br/>
2. GST No. :<input type="text" class="gst_no" id="gst_no" name="gst_no"  style="width: 70%;border: transparent; text-transform: uppercase !important;" value="<?php if(!empty($po_details)){echo $po_details->gst_no; }?>" ><br/>
3. Terms of payment :<input type="text" class="terms_payment" id="terms_payment" name="terms_payment"  style="width: 70%;border: transparent; text-transform: uppercase !important;" value="<?php if(!empty($po_details)){echo $po_details->terms_of_payment; }?>" ><br/>

4. BANK DETAILS :<input type="text" class="bank_details" id="bank_details" name="bank_details"  style="width: 70%;border: transparent; text-transform: uppercase !important;" value="<?php if(!empty($po_details)){echo $po_details->bank_details; }?>" readonly>
						</td>
					</tr>
				</tbody>
			</table>
			<br/><br/>
			<button  type="submit" class="btn center-block" style="float: left;margin-left: 39%;width: 100px;">Submit</button>
			<a href="<?php echo site_url('civil-work-order-list'); ?>" class="btn default" style=" width:8%;color: #876174; background:#dddddd !important;margin-left: 20px;">Cancel</a>
			 
		</form>
			
	</div> 
</div>
<?php echo view('includes/footer');?>

if(obj.result == 1) 
            {
                   
				document.getElementById('address').value=obj.message.vendor_name+"\n";	  
				document.getElementById('address').value+=obj.message.company_name+"\n";	
				document.getElementById('address').value+=obj.message.company_address+"\n";	
				document.getElementById('bank_details').value=' '+'A/c No. '+obj.message.account_no+"\n";
				document.getElementById('bank_details').value+=','+obj.message.bank_name+"\n";
				document.getElementById('bank_details').value+=','+obj.message.bank_address+"\n";
				document.getElementById('bank_details').value+=','+obj.message.ifsc_code+"\n";
             }
            }
        });
}

function inr_value(str,i)
    {
		
        var inr_val = str;
		
        $('.inrvalue'+i).val(inr_val);
        var cgst =$('.ocgst'+i).val();
        var sgst =$('.osgst'+i).val();
		 var igst =$('.oigst'+i).val();
        var tax=parseFloat(cgst) + parseFloat(sgst)+ parseFloat(igst);
        var total_val =(inr_val * tax)/100 ;
        var total=parseFloat(total_val) + parseFloat(inr_val);

$('.totalvalue'+i).val(total);

amount_total1();
	}

function amount_total1()
	{
		var a=$(".to_val").val();
		
		var b=$(".tot_val").val();
		var tot_vals=[];
		$('.tot_val').each(function () {
		 tot_vals.push($(this).val());
		});

var sum = 0;

for(var i=0; i < tot_vals.length; i++){

sum += parseFloat(tot_vals[i]);

}

if(a=="")
		{
			$('.total_amt').val(parseFloat(sum).toFixed(2));
		}
		else 
		{
		var amnt=parseFloat(sum) + parseFloat(a);
		
		$('.total_amt').val(amnt.toFixed(2));
		}
	}
	
</script>	
<style type="text/css">
	.thead-default{
		background:#337ab7;
		color:white;
	}
	.table{
		margin-bottom:0 !important;
		//width:auto !important;
	}
	th, td{
		border:1px solid gray;
		padding:6px;
	}
	.inner th{
		border:transparent !important;
	}
	.inner tr{
		border-bottom:1px solid gray;
	}
	table{
		width:100%;
	}
	#ui-id-1
	{
		display: none;
		width: 350px;
		top: 258px;
		overflow-x: hidden !important;
		overflow-y: scroll !important;
		height: 203px !important;
	} 
	
	@media only screen and (min-width:320px) and (max-width:640px) {
		.page-content {
			width:900px;
		}
		.page-content-wrapper {
			overflow-x:scroll !important;
		}
	}
</style>
<script>
	var total_vall=0;
	
</script>
<script>
	
	
	function gstvalue1(str,i)
    {
		var gst=str;
		
		var inr_val =$('.inrvalue'+i).val();
		var cgst =$('.ocgst'+i).val();
		var igst =$('.oigst'+i).val();
		var sgst =$('.osgst'+i).val();
		var total_cgst =(inr_val * cgst)/100 ;
		var total_sgst =(inr_val * sgst)/100 ;
		var total_igst =(inr_val * igst)/100 ;
	    var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst);
		var total_inr = parseFloat(total) + parseFloat(inr_val);
	
	    $('.totalvalue'+i).val(total_inr.toFixed(2));
		amount_total1();
		
		
	}

function gstvalue2(str,i)
    {
		var gst=str;
		
	   	var inr_val =$('.inrvalue'+i).val();
		var cgst =$('.ocgst'+i).val();
		var igst =$('.oigst'+i).val();
		var sgst =$('.osgst'+i).val();
		var total_cgst =(inr_val * cgst)/100 ;
		var total_sgst =(inr_val * sgst)/100 ;
		var total_igst =(inr_val * igst)/100 ;
	    var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst);
		//alert(total);
		var total_inr = parseFloat(total) + parseFloat(inr_val);
	    $('.totalvalue'+i).val(total_inr);
	    amount_total1();
	}
	function gstvalue3(str,i)
    {
		var gst=str;
	   	var inr_val =$('.inrvalue'+i).val();
		var cgst =$('.ocgst'+i).val();
		var igst =$('.oigst'+i).val();
		var sgst =$('.osgst'+i).val();
		var total_cgst =(inr_val * cgst)/100 ;
		var total_sgst =(inr_val * sgst)/100 ;
		var total_igst =(inr_val * igst)/100 ;
	    var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst);
		var total_inr = parseFloat(total)+parseFloat(inr_val);

$('.totalvalue'+i).val(total_inr);
	    amount_total1();
	}

function sgstvalue1(str)
    {
		var gst=str;
		var inr_val =$('.inr_value_val').val();
		 var sgst =$('.oosgst').val();
		 var igst =$('.ooigst').val();
		 var cgst =$('.oocgst').val();
		 var total_cgst =(inr_val * cgst)/100 ;
		 var total_sgst =(inr_val * sgst)/100 ;
		 var total_igst =(inr_val * igst)/100 ;
	    var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst);
		//alert(total);
		var total_inr = parseFloat(total) + parseFloat(inr_val);
		//alert(total_inr);
	    $('.total_value_val'+i).val(total_inr);
		amount_total1();
	    
		
	}

function sgstvalue2(str)
    {
		var gst=str;
		var inr_val =$('.inr_value_val').val();
		 var sgst =$('.oosgst').val();
		 var igst =$('.ooigst').val();
		 var cgst =$('.oocgst').val();
		 var total_cgst =(inr_val * cgst)/100 ;
		 var total_sgst =(inr_val * sgst)/100 ;
		 var total_igst =(inr_val * igst)/100 ;

var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst);
	       var total_inr = parseFloat(total) + parseFloat(inr_val);
		  // alert(total_inr);
		   
	        $('.total_value_val').val(total_inr);
	        amount_total1();
	}
	function sgstvalue3(str)
    {
	   
		var gst=str;
		var inr_val =$('.inr_value_val').val();
		var sgst =$('.oosgst').val();
		var igst =$('.ooigst').val();
		var cgst =$('.oocgst').val();
		var total_cgst =(inr_val * cgst)/100 ;
		var total_sgst =(inr_val * sgst)/100 ;
		var total_igst =(inr_val * igst)/100 ;
	    var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst); 
		var total_inr = parseFloat(total) + parseFloat(inr_val);
		//alert(total_inr)
	    $('.total_value_val').val(total_inr);
	    amount_total1();
	}

var discount_total_value=0;
	function discountvalue(str)
    {
		
		var discount=str;
		var total_amt = $(".total_amt").val();
		var mul_val =(discount * total_amt)/100;
		var discount_total_value= parseFloat(total_amt) - parseFloat(mul_val);
		$('.g_total').val(discount_total_value.toFixed(2));
	}

var tds_total_value=0;

function tdsvalue(str)
    {
       	var tds = str;
    	var inr_val = $(".inrval").val();
		a= 0;
		$(".inrval").each(function ()
		{
			a += parseInt( $(this).val());
		});
		var inr_value1 = a;
		var inr_val2 =$('.inr_value_val').val();
		var inr_total_value = parseFloat(inr_value1) + parseFloat(inr_val2);
		var ttl_val =$('.total_amt').val();
		var discount=$('.discount').val();
		var discount_val =(discount * ttl_val)/100;
		var dis_val = (discount * inr_total_value)/100;
		var tds_val = parseFloat(inr_total_value) - parseFloat(dis_val);
		var tds_value =(tds_val * tds)/100;
		var total_dis = parseFloat(ttl_val) - parseFloat(discount_val);
		var total_dis_tds = parseFloat(total_dis) - parseFloat(tds_value);
		$('.g_total').val(total_dis_tds.toFixed(2));
    }

$('.g_total').ready(function() {
		
		var inr_val = $(".inrval").val();
		a= 0;
		$(".inrval").each(function ()
		{
			
			a += parseInt( $(this).val());
		});
		var inr_value1 = a;
		var inr_val2 =$('.inr_value_val').val();
		var inr_total_value = parseFloat(inr_value1) + parseFloat(inr_val2);
		var ttl_val =$('.total_amt').val();
		var discount=$('.discount').val();
		var tds=$('.tds').val();
		var discount_val =(discount * ttl_val)/100;
		var dis_val = (discount * inr_total_value)/100;
		var tds_val = parseFloat(inr_total_value) - parseFloat(dis_val);
		var tds_value =(tds_val * tds)/100;
		var total_dis = parseFloat(ttl_val) - parseFloat(discount_val);
		var total_dis_tds = parseFloat(total_dis) - parseFloat(tds_value);
		$('.g_total').val(total_dis_tds.toFixed(2));
		
	});
</script>
<script type="text/javascript">
$('.work_po_form').submit(function(e){    
        e.preventDefault();

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

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

$.ajax({

type   : 'post',
                url    : '<?php echo site_url("update-civil-work-order")?>',
                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('civil-work-order-list');?>" }, 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');                      
                    }
                   
                }
                
         });
             
     });
	</script>