EVOLUTION-NINJA

Edit File: edit_purchase_order_po.php

<?php echo view('includes/header');?>
<div class="page-content-wrapper">
	<div class="page-content">	
		<h3 class="page-title">Edit Generated PO</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>
		<tr>
			<td style="width:15%;"><b>PO #</b></td>
			<td style="width:15%;"><input type="text" name="po_no" id="po_no"  style="width: 100%;border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->po_no; }?>"></td>
			<td rowspan="7" style="width:70%">
				<textarea rows="5" id="address" name="address" style="width: 100%; border: transparent;" placeholder="Address :" required><?php if(!empty($po_details)){echo $po_details->vendor_address; }?></textarea>
			</td>
		</tr>
		<input type="hidden" id="edit_id" name="edit_id" value="<?php if(!empty($po_details)){echo $po_details->id; }?>" style="width: 100%;border: transparent;" required>
		<tr>
			<td><b>Vendor</b></td>
			<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;" required> </td>

</tr>
		<tr>
			<td><b>Date</b></td>
			<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>
			<td><b>Currency</b></td>
			<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>
			<td><b>Contact Person</b></td>
			<td style="width:109px;"><input type="text" 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>
			<td><b>Contact Number</b></td>
			<td style="width:109px;"><input type="text"  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>
			<td><b>E-mail ID</b></td>
			<td style="width:109px;"><input type="text" id="email" name="email" style="width: 100%;border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->email; }?>"> </td>
		</tr>
	</table>
			
			<table style="width:100%; table-layout:fixed;">
				<thead class="thead-default">
					<tr>
						<th  width="3%">Sl. No.</th>
						
						<th  width="18%">Product Name</th>
						<th  width="12%">Description</th>
						<th  width="12%">Indent</th>
						<th  width="12%">Project</th>
						<th  width="10%" >Purpose</th>
						<th width="8%">Quantity</th>
						<th  width="6%">Unit Price</th>
						<th  width="6%" class="inr_val" id="inr_val" name="inr_val">Value</th>
						<th  width="6%" class="chf_val" id="chf_val" name="chf_val" style="display: none;">CHF Value</th>
						<th  width="6%" style="display: none;" class="eur_val" id="eur_val" name="eur_val">EUR Value</th>
						<th  width="6%" style="display: none;" class="gbp_val" id="gbp_val" name="gbp_val">GBP Value</th>
						<th  width="6%" style="display: none;" class="usd_val" id="usd_val" name="usd_val">USD Value</th>
						<th  width="6%">SGST</th>
						<th width="6%">CGST</th>
						<th width="6%">IGST</th>
						<th  width="6%">Total Value</th>
					</tr>
				</thead>
				<tbody>
				<?php $c=1;$key=1; foreach($fetch_details as $po_details){?>
				<tr>
						<td  width="8%" 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 width="8%"><input type="text" class="p_name" name="p_name[]" id="p_name"  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" name="product_id[]" id="product_id"  style="border: transparent;" value="<?php if(!empty($po_details)){echo $po_details->product_id; }?>" required>
						</td>
						<td width="8%"><input type="text"  style="width:100%; border:transparent;text-transform: uppercase !important;" class="description" name="description[]" id="description" value="<?php if(!empty($po_details)){echo $po_details->description; }?>"  ></td>
						<td width="10%"><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 width="8%">
						<select class="form-control" class="project_name<?php echo $key;?>" name="project_name[]"  id="project_name<?php echo $key;?>" 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 width="8%"  ><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 width="8%" style="width: 10%;padding: 1px;"><input type="text" id="quantityy<?php echo $key;?>" class="quantityy<?php echo $key;?>" name="quantityy[]" value="<?php if(!empty($po_details)){echo $po_details->quentity; }?>" style="width: 100%;border: transparent;" required></td>
						<td width="8%" style="width: 10%;padding: 1px;"><input type="text" id="unit<?php echo $key;?>" name="unit[]" onkeyup="unit_valuefirst(this.value,<?php echo $key;?>)" value="<?php if(!empty($po_details)){echo $po_details->unit_price; }?>" class="unit<?php echo $key;?>"  style="width: 100%;border: transparent;" required></td>
						
						<td width="8%" style="width: 10%;padding: 1px;"><input type="text" value="<?php if(!empty($po_details)){echo round($po_details->inr_value); }?>" class="inrvalue<?php echo $key;?> inrval" id="inrvalue<?php echo $key;?>" name="inrvalue[]"  style="width: 100%;border: transparent;" required readonly></td>
						<td width="8%" style="width: 10%;padding: 1px;"><input type="text" 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: 42%;border: transparent;margin-left: 1px;"  required> <span>%</span></td>
						<td width="8%" style="width: 10%;padding: 1px;"><input type="text" 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: 42%;border: transparent;margin-left: 1px;"  required> <span>%</span></td>
						<td width="8%" style="width: 10%;padding: 1px;"><input type="text" 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: 42%;border: transparent;margin-left: 1px;"  required> <span>%</span></td>
						<td width="8%" style="width: 10%;padding: 1px;"><input type="text" class="totalvalue<?php echo $key;?> tot_val" id="totalvalue<?php echo $key;?>" value="<?php if(!empty($po_details)){echo round($po_details->total_value); }?>" name="totalvalue[]"  style="width: 100%;border: transparent;" required></td>
						
						<?php $c++;$key++; }?>
					</tr>
				<tr>
					<th width="3%" scope="row"></th>
					<td colspan="5"width="60%" ><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 width="6%" style="width: 10%;padding: 1px;"><input type="text" value="<?php if(!empty($po_details)){echo $po_details->ot_quantity; }?>" id="quantity_val" name="quantity_val"  style="width: 100%;border: transparent;" ></td>
					<td width="6%" style="width: 10%;padding: 1px;"><input type="text" value="<?php if(!empty($po_details)){echo $po_details->ot_unit; }?>" id="unit1" name="unit1" onfocusout="unitvalue1(this.value)" style="width: 100%;border: transparent;" ></td>
				<td width="6%" style="width: 10%;padding: 1px;"> <input type="text"  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;"  readonly>
                  </td>

<td width="6%" style="width: 10%;padding: 1px;"><input type="text" 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: 1px;"> <span>%</span></td>
					<td width="6%" style="width: 10%;padding: 1px;"><input type="text" 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: 1px;"> <span>%</span></td>
					<td width="6%" style="width: 10%;padding: 1px;"><input type="text" 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: 1px;"> <span>%</span></td>
					<td width="6%" style="width: 10%;padding: 1px;"><input type="text"   value="<?php if(!empty($po_details)){ echo round((float)$po_details->ot_total_value); } ?>"  class="total_value_val to_val" id="total_value_val" name="total_value_val"  style="width: 100%;border: transparent;" ></td>
				</tr>
				<tr>
					<th colspan="8" rowspan="3">Note
						<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>
					</th>
					<td colspan="3">TOTAL AMOUNT</td>
					<td colspan="2" style="padding-bottom: 10px;"><input type="text" class="total_amt" id="total_amt" value="<?php if(!empty($po_details)){echo round($po_details->total_amt); }?>"  name="total_amt"  style="width: 100%;border: transparent;" readonly="readonly" required onfocusin="amount_total1()"></td>
				</tr>
				<tr>
					<td colspan="3">DISCOUNT %</td>
					<td colspan="2" style="padding-bottom: 10px;"><input type="text" 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;" required> <span>%</span></td>
				</tr>
				<tr>
					<td colspan="3">GRAND TOTAL</td>
					<td colspan="2" style="padding-bottom: 10px;"><input type="text" class="g_total" id="g_total" name="g_total"  value="<?php if(!empty($po_details)){echo round($po_details->grand_total); }?>" style="width: 100%;border: transparent;" readonly="readonly" required></td>
				</tr>
				<tr>					
						<td colspan="13" style="">
						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; }?>" >
						</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('purchase_po_genereted_list_form'); ?>" 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(response.result == 1) 
            {
                   
				document.getElementById('address').value=response.message.vendor_name+"\n";	  
				document.getElementById('address').value+=response.message.company_name+"\n";	
				document.getElementById('address').value+=response.message.company_address+"\n";	
				document.getElementById('bank_details').value=' '+'A/c No. '+response.message.account_no+"\n";
				document.getElementById('bank_details').value+=','+response.message.bank_name+"\n";
				document.getElementById('bank_details').value+=','+response.message.bank_address+"\n";
				document.getElementById('bank_details').value+=','+response.message.ifsc_coce+"\n";
             }
            }
        });
}

function unit_valuefirst(str,i)
    {
		var unit=str;
        var quantity_val =$('.quantityy'+i).val();
		
        var inr_val = str * quantity_val;
		//alert(cgst);
        $('.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();
	}
	var total_vall=0;
	function gstvalue(str,i)
    {
		var n=0;
		var gst=str;
        var inr_val =$('.inr_value'+i).val();
		//alert(inr_val);
		var total_val =(inr_val * gst)/100 ;
	    $('.total_value'+i).val(parseFloat(total_val) + parseInt(inr_val));
		var total_value11 =  $('.total_value'+i).val();
		total_vall= parseFloat(total_vall) + parseFloat(total_value11);
		//$('.total_amt').val(total_vall);
		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 unitvalue1(str)
    {
		
		var unit=str;
        var quantity_val =$('#quantity_val').val();
        var inr_val = str * quantity_val;
        $('.inr_value_val').val(inr_val);
        var cgst =$('.oocgst').val();
        var sgst =$('.oosgst').val();
		var igst =$('.ooigst').val();
        var tax=parseFloat(cgst) + parseFloat(sgst)  + parseFloat(igst);
        var total_val =(inr_val * tax)/100 ;
        var total=parseFloat(total_val) + parseFloat(inr_val);
        $('.total_value_val').val(total);
        amount_total1();
	}

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);
		amount_total1();
		
		
	}

function gstvalue2(str,i)
    {
	   	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 gstvalue3(str,i)
    {
	   	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 cgst =$('.oocgst').val();
		var igst =$('.ooigst').val();
		var sgst =$('.oosgst').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 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));
	}
</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_work_po_data")?>',
                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('purchase_po_genereted_list_form');?>" }, 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>