EVOLUTION-NINJA

Edit File: po_generate.php

<?php echo view('includes/header');?>
<div class="page-content-wrapper">
	<div class="page-content">	
		<h3 class="page-title">Generate WO</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><b>WO#</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" id="vendor_name" name="vendor_name" pattern="[a-zA-Z\s]+" 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  width="3%">Sl. No.</th>
				<th  width="18%">Product Name</th>
				<th  width="12%">Description</th>
				<th  width="12%">Indent</th>
				<th  width="10%" >Project</th>
				<th  width="12%">Purpose</th>
				
				<th  width="6%" class="inr_val" id="inr_val" name="inr_val">INR 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 $i=1; ?>
		<?php  if(isset($product_list)) { foreach($product_list as  $key=>$productlist) {  ?>
		<tr>
						<td  width="8%" scope="row"><?php echo $i; ?></td>
						<td width="8%"><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 width="8%"><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 width="10%"><input type="text"  class="i_no" name="i_no[]" id="i_no<?php echo $key;?>"  value="" style="width:100%; border: transparent;">

</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>
									
									<?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<?php echo $key;?>"  name="purpose[]" id="purpose<?php echo $key;?>"  value="" style="width:100%;border: transparent;" required ></td>

<td width="8%" style="width: 10%;padding: 1px;"><input type="text" class="inrvalue<?php echo $key;?> inrval" id="inrvalue<?php echo $key;?>" name="inrvalue[]"  style="width: 100%;border: transparent;" required ></td>
						<td width="8%"  style="width: 10%;padding: 1px;"><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 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="0" style="width: 42%;border: transparent;margin-left: 17px;" 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="0" style="width: 42%;border: transparent;margin-left: 17px;" 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;?>" name="totalvalue[]"  style="width: 100%;border: transparent;" required></td>
						
					</tr>		
				<?php $i++;} } ?>	
				<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;" ></td>
						<td width="6%" style="width: 10%;padding: 1px;"><input type="text" class="inr_value_val" id="inr_value_val" name="inr_value_val" value="0" style="width: 100%;border: transparent;"  ></td>
						<td width="6%" style="width: 10%;padding: 1px;"><input type="text" class="oosgst ot_sgst" id="ot_sgst" name="ot_sgst" onfocusout="sgstvalue1(this.value)" value="0" style="width: 42%;border: transparent;margin-left: 17px;" > <span>%</span></td>
						<td width="6%" style="width: 10%;padding: 1px;"><input type="text" class="oocgst ot_cgst" id="ot_cgst" name="ot_cgst" onfocusout="sgstvalue2(this.value)" value="0"  style="width: 42%;border: transparent;margin-left: 17px;" > <span>%</span></td>
						<td width="6%" style="width: 10%;padding: 1px;"><input type="text" class="ooigst ot_igst" id="ot_igst" name="ot_igst" onfocusout="sgstvalue3(this.value)" value="0" style="width: 42%;border: transparent;margin-left: 17px;" > <span>%</span></td>
						<td width="6%" style="width: 10%;padding: 1px;"><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="2">TOTAL AMOUNT</td>
					<td><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="2">DISCOUNT %</td>
					<td><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="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="11" 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. TDS @ : <input type="text" class="tds" id="tds" name="tds" onkeyup="tdsvalue(this.value);" style="width: 5%;" > % On Total Value.<br/>
5. 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%;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;
        $('.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>	
<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) + 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 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);
		var g_total = Math.round(total_dis_tds);
		$('.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_wo_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('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_email()
{
	 
	 var po_no = $("#po_no").val();
	
	 $.ajax({

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

</script>