EVOLUTION-NINJA

Edit File: purchase_order_generate_po.php

<?php echo view('includes/header');?>
<div class="page-content-wrapper">
	<div class="page-content">	
		<h3 class="page-title">Generate 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 echo '0000';echo $wo_no->po_no + 1;?>">
							</td>
			<td style="width:70%" rowspan="7">
				<textarea rows="5" id="address" name="address" style="width: 100%; border: transparent;" placeholder="Address :" required></textarea>
			</td>
		</tr>
		<tr>
			<td><b>Vendor</b></td>
			<td contenteditable="true" ><input type="text" pattern="[a-zA-Z\s]+" id="vendor_name" name="vendor_name"  onfocusout="vendor_myFunction(this.value)" 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" onfocusout="date_function(this.value)" style="width: 100%;border: transparent;" value="<?php echo date("d-m-Y"); ?>"  required></td>
		</tr>
		<tr>
			<td><b>Currency</b></td>
			<td>
				<select name="currency" id="currency" style="width: 100%;border: transparent;" required>
					<option value="INR">INR</option>
					<option value="CHF">CHF</option>
					<option value="EUR">EUR</option>
					<option value="GBP">GBP</option>
					<option value="USD">USD</option>
				</select>
			</td>
		</tr>
		<tr>
			<td><b>Contact Person</b></td>
			<td style="width:109px;"><input type="text" pattern="[a-zA-Z\s]+" id="contact_person" name="contact_person" style="width: 100%;border: transparent;" > </td>
		</tr>
		<tr>
			<td><b>Contact Number</b></td>
			<td style="width:109px;"><input type="text" maxlength="10" pattern="^\d{10}"   name="contact_number" id="contact_number"  style="width: 100%;border: transparent;" ></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;" > </td>
		</tr>
	</table>
			
			<table style="width:100%;table-layout:fixed;">
		<thead class="thead-default">
			<tr>
				<th style="width:4%;">Sl. No.</th>
				<th>Product Name</th>
				<th style="width:10%;">Description</th>
				<th>Indent</th>
				<th>Project</th>
				<th>Purpose</th>
				<th>Quantity</th>
				<th>Unit Price</th>
				<th class="inr_val" id="inr_val" name="inr_val">INR Value</th>
				<th class="chf_val" id="chf_val" name="chf_val" style="display: none;">CHF Value</th>
				<th style="display: none;" class="eur_val" id="eur_val" name="eur_val">EUR Value</th>
				<th style="display: none;" class="gbp_val" id="gbp_val" name="gbp_val">GBP Value</th>
				<th style="display: none;" class="usd_val" id="usd_val" name="usd_val">USD Value</th>
				<th>SGST</th>
				<th>CGST</th>
				<th>IGST</th>
				<th>Total Value</th>
			</tr>
		</thead>
		<tbody>
		<?php $i=1; ?>
		<?php  if(isset($product_list)) { foreach($product_list as  $key=>$productlist) {  ?>
				<tr>
					<td scope="row"><?php echo $i; ?></td>
					<td><input type="text" class="p_name" name="p_name[]" id="p_name"  value="<?php   echo $productlist->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 echo $productlist->id; ?>" required>
					</td>
					<td><input type="text"  style="width:100%; border:transparent;text-transform: uppercase !important;" class="description" name="description[]" id="description" value="<?php echo $productlist->description; ?>"  ></td>
					<td><input type="text"  class="i_no" name="i_no[]" id="i_no<?php echo $key;?>"  value="" style="width:100%; border: transparent;">

</td>
					
						
					
					<td>
					<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>								
						<?php
						foreach($owners as $value)
						{
							?>
								<option value="<?php echo $value->project_name;?>" ><?php echo $value->project_name;?></option>

<?php
						}
						?>
					</select>
					
					</td>
					<td><input type="text" class="purpose<?php echo $key;?>"  name="purpose[]" id="purpose<?php echo $key;?>"  value="" style="width:100%;border: transparent;" required ></td>

<td><input type="text" id="quantityy<?php echo $key;?>" class="quantityy<?php echo $key;?>" name="quantityy[]" value="" style="width: 100%;border: transparent;" required></td>
					<td><input type="text" id="unit<?php echo $key;?>" name="unit[]" onkeyup="unit_valuefirst(this.value,<?php echo $key;?>)" class="unit<?php echo $key;?>"  style="width: 100%;border: transparent;" required></td>
					<td><input type="text" class="inrvalue<?php echo $key;?> inrval" id="inrvalue<?php echo $key;?>" name="inrvalue[]"  style="width: 100%;border: transparent;" required readonly></td>
					<td ><input type="text" class="osgst<?php echo $key;?>" id="sgst<?php echo $key;?>" name="sgst[]" onkeyup="gstvalue1(this.value,<?php echo $key;?>)" value="0" style="width: 42%;border: transparent;margin-left: 17px;" required> <span>%</span></td>
					<td><input type="text" class="ocgst<?php echo $key;?>" id="cgst<?php echo $key;?>" name="cgst[]" onkeyup="gstvalue2(this.value,<?php echo $key;?>)" value="0" style="width: 42%;border: transparent;margin-left: 17px;" required> <span>%</span></td>
					<td><input type="text" class="oigst<?php echo $key;?>" id="igst<?php echo $key;?>" name="igst[]" onkeyup="gstvalue3(this.value,<?php echo $key;?>)" value="0" style="width: 42%;border: transparent;margin-left: 17px;" required> <span>%</span></td>
					<td><input type="text" class="totalvalue<?php echo $key;?> tot_val" id="totalvalue<?php echo $key;?>" name="totalvalue[]"  style="width: 100%;border: transparent;" required></td>
					
				</tr>		
			<?php $i++; } } ?>
			<tr>
				<th scope="row"></th>
				<td colspan="5"><input type="text" placeholder="OTHER CHARGES :" name="ot_charges" id="ot_charges" style="width: 100%;border: transparent;text-transform: uppercase !important;" ></td>
				<td ><input type="text" id="quantity_val" name="quantity_val"  style="width: 100%;border: transparent;" ></td>
				<td ><input type="text" id="unit1" name="unit1" onfocusout="unitvalue1(this.value)" style="width: 100%;border: transparent;" ></td>
				<td><input type="text" class="inr_value_val" id="inr_value_val" name="inr_value_val"  style="width: 100%;border: transparent;"  readonly></td>
				<td><input type="text" class="oosgst ot_sgst" id="ot_sgst" name="ot_sgst" onfocusout="sgstvalue1(this.value)"  style="width: 42%;border: transparent;margin-left: 17px;" > <span>%</span></td>
				<td><input type="text" class="oocgst ot_cgst" id="ot_cgst" name="ot_cgst" onfocusout="sgstvalue2(this.value)" style="width: 42%;border: transparent;margin-left: 17px;" > <span>%</span></td>
				<td><input type="text" class="ooigst ot_igst" id="ot_igst" name="ot_igst" onfocusout="sgstvalue3(this.value)" style="width: 42%;border: transparent;margin-left: 17px;" > <span>%</span></td>
				<td><input type="text" 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">
					<textarea rows="3" id="note" name="note" style="width: 100%; border: transparent;text-transform: uppercase !important;" placeholder="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" 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" onkeyup="discountvalue(this.value)"  style="width: 55%;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"  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" 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;" ><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;" ><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;" >
						</td>
					</tr>
		</tbody>
	</table>
			<br/><br/>
			<button  type="submit" class="btn center-block" id="submit_button" style="float: left;margin-left: 39%;width: 100px;">Submit</button>
			<a href="<?php echo base_url(); ?>purchase-order" class="btn default" style=" width:8%; background:rgb(240,240,240) !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;
        $('.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 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>

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) + parseFloat(inr_val); 
	    $('.totalvalue'+i).val(total);
		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)+ parseFloat(inr_val); 
	    $('.totalvalue'+i).val(total);
	    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)+ parseFloat(inr_val);
	    $('.totalvalue'+i).val(total);
	    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)+ parseFloat(inr_val);
	    $('.total_value_val').val(total);
	    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)+ parseFloat(inr_val);
	       
	        $('.total_value_val').val(total);
	        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)+ parseFloat(inr_val); 
	    $('.total_value_val').val(total);
	    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);
		var g_total = Math.round(discount_total_value);
		$('.g_total').val(g_total.toFixed(2));
	}
</script>
<?php

$date  = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$today = $date->format('Y-m-d');

?>
<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("insert_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');?>?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 send_mail()
{
	  //alert();
	 var po_no = $("#po_no").val();
	
	 $.ajax({

type   : 'post',
       url    : '<?php echo site_url("gss/send_mail")?>',
       data   : {'po_no':po_no},
		async:false,
		
		success:function()
		{
			 // alert('success');
		}
		
	 });
	 
}

</script>