EVOLUTION-NINJA

Edit File: request_letter2.php

<button class="btn btn-success btn-lg" onclick="goods_details()" type="button" id="" style="
   
    padding-top: 2px;
    padding-bottom: 3px;
    padding-left: 15px;
    padding-right: 15px;
    background: rgb(72,91,127);
    color: white;
	border: initial !important;
    font-size: 22px;">Submit </button>
	
<button class="btn btn-success btn-lg" type="button" id="booking_print" style="
   
   
    padding-top: 2px;
    padding-bottom: 3px;
    padding-left: 15px;
    padding-right: 15px;
    background: rgb(72,91,127);
    color: white;
	border: initial !important;
    font-size: 22px;">Print </button>

<span class="close-right" ><a href="<?php echo base_url('packing_list/paking_list_details?prop_id=1');?>" style="font-size: 22px;border: 1px solid;padding-left: 15px;padding-right: 15px;background: rgb(72,91,127);color: white;padding-bottom: 7px;text-decoration:none;">Back</a></span></div>

<div style="width:800px;" id="print_report">
		<div class="row invoice_table">
			
			<div style="text-align: center;">
			    
			    <img src="<?php echo base_url('assets/img/logo2.png');?>"  class="img-responsive center-block">
			
			</div>
			<h4 style="text-align:center; padding-top:1%;">REQUEST LETTER FOR EXPORT BILL FOR COLLECTION</h4>	
			<table class="table" border="" style="width:100%;">				
				<tr>
					<td colspan="8" style="border-right: transparent;border-bottom: transparent;">To <br> The Branch Manager, <br> Kotak Mahindra Bank Ltd., <br> LAVELLE ROAD Branch <br> BANGALORE-560 001</td>
					<td colspan="2" style="border-left: transparent;border-bottom: transparent;"><b><?php echo date('d-m-Y'); ?></b></td>
				</tr>
				<tr>
					<td colspan="10" style="border-top: transparent;border-bottom: transparent;">Dear Sir/Madam, <br> 
					Sub. : 1.Export Documents for Purchase/Negotiation/Discounting/Collection/Rupee Advance <br> 
				           2.LC/BD with/without recourse<br> 
				           3.Purchase/Dicounting/Negotiation under Confirmed LC.<br>
					We enclose herewith the following export documents: <br>
					Bill amount –  <b><?php  if($fetch->total_value == 0) {  
					    echo  $fetch_invoice_cureency->currency . ' ' . number_format((float) ($fetch_sum_amt_invoice->values_es+$fetch->other_charges), 2, '.', ''); ?> 
					<?php } 
					        else if($fetch->discount == 0 && $fetch->other_charges_des == 0) {  echo $fetch_invoice_cureency->currency . ' ' . number_format((float) ($fetch_sum_amt_invoice->values_es+$fetch->other_charges), 2, '.', ''); ?>
					<?php } 
					        else {  	
					            $v=$fetch->discount;
					 $s=number_format((float) $fetch->total_value, 2, '.', '');
				//	$d=  $s - $v; 
				$d=  $s; 
				    echo $fetch_invoice_cureency->currency;?> <?php echo  number_format((float)$fetch->total_value, 2, '.', '');
					//echo $fetch_invoice_cureency->currency . ' ' . number_format((float) ($d+$fetch->other_charges), 2, '.', '');
					?> 
					<?php } ?></b> -	  
			 	( Our Invoice No. <b> <?php echo $fetch->invoice_num; ?> </b> dt <b> <?php echo $fetch->invoice_date; ?> </b> )  <br> 
		
	                   Consignee: <b><?php  if(!empty($fetch)) { echo $fetch->consignee; } else { echo '-'; } ?></b> <br> 
	                   Buyer if other than consignee: <b><?php  if(!empty($fetch)) { echo $fetch->buyer_consignee_preview; } else { echo '-'; } ?></b> <br> 
		
					Tenor: <b><?php echo $fetch->delivery_payment_preview; ?></b> CRN:59674014 <br> 
					I.E. Code No. 0794003885 Home Branch Code: 0000422</td>
				</tr>
				<tr>
					<td style="width:10%;"><b>Documents</b></td>
					<td style="width:10%;"><b>Drafts</b></td>
					<td style="width:10%;"><b>Invoice</b></td>
					<td style="width:20%;"><b>Transport Doc. B/L/ AWB /LR</b></td>
					<td style="width:10%;"><b>Pkg.List</b></td>
					<td style="width:10%;"><b>Insu.Policy</b></td>
					<td style="width:10%;"><b>Cert.Of Origin</b></td>
					<td style="width:10%;"><b>Test Cert</b></td>
					<td style="width:5%;"><b>Others</b></td>
					<td style="width:5%;"><b>GR</b></td>
				</tr>
			
				<tr>
					<td>Original</td>
					<td>NIL</td>
					<td>2</td>
					<td>COPY OF B/L</td>
					<td>2</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>1</td>
				</tr>
					<tr>
					<td>Duplicate</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
				</tr>
				<tr>
					<td colspan="10"><b>No. of documents to be sent to Beni/foreign bank / as per L/C</b></td>
				</tr>
				<tr>
					<td>Original</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
				</tr>
				<tr>
					<td>Duplicate</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
					<td>NIL</td>
				</tr>
				<tr>
					<td colspan="10" style="border-bottom: transparent;">Other documents enclosed… <br> Original L/C No. <input type="text" name="org_lc_no" id="org_lc_no" value="<?php echo $fetch->org_lc_no; ?>"> dated <input type="text" name="org_lc_dt" id="org_lc_dt" value="<?php echo $fetch->org_lc_dt; ?>"> of <input type="text" name="org_lc_of" id="org_lc_of" value="<?php echo $fetch->org_lc_of; ?>"> along with all
amendments (No of amendments <input type="text" name="org_lc_along" id="org_lc_along" value="<?php echo $fetch->org_lc_along; ?>"> and advising letters duly stamped with revenue stamp on the reverse.</td>
				</tr>
				<tr>
				    <td colspan="3">Shipping Bill/EDF No</td>
					<td colspan="2">SB Date</td>
					<td colspan="3">SB Cur & amt</td>
					<td colspan="2">Port Code</td>
				</tr>
				<tr>
				    
					
					<td colspan="3" height="40"> <input type="text" name="gr_from_no" readonly id="gr_from_no" value="<?php echo $fetch->shipping_bill_num; ?>"></td>
					<td colspan="2" height="40"><input type="text" name="sb_date" readonly id="sb_date" value="<?php echo $fetch->shipping_bill_date; ?>"></td>
					
					<td colspan="3" height="40"><input type="text" name="sb_amt" readonly id="sb_amt" value="<?php echo $fetch_invoice_cureency->currency;?> <?php echo  number_format((float)$fetch->total_value , 2, '.', ''); ?>"></td>
				
					<td colspan="2" height="40"><input type="text" name="port_code" readonly id="port_code" value="<?php echo $fetch->shipping_port_code; ?>"></td>
				</tr>
				<tr>
					<td colspan="10" style="border-top: transparent;">Other AD Bank Code No & Name <input type="text" name="ad_bank" id="ad_bank" value="<?php echo $fetch->ad_bank; ?>">(This is applicable/mandotory in case SB is registered with AD other than KMBL)</td>
				</tr>
				<tr>
					<td colspan="10" style="border-top: transparent;">KIndly note our following instructions: (mark X wherever applicable)</td>
				</tr>
				<tr>
					<td colspan="">1</td>
					<td colspan="6">Documents to be delivered against PAYMENT / ACCEPTANCE **</td>
					<td colspan="3">
						<select name="pay_accept" id="pay_accept">
						
							<option value="<?php echo 'ACCEPTANCE'; ?>" <?php if($fetch->pay_accept == 'ACCEPTANCE') {echo "selected";}?>><?php echo 'ACCEPTANCE'; ?></option>
							<option value="<?php echo 'PAYMENT'; ?>" <?php if($fetch->pay_accept == 'PAYMENT') {echo "selected";}?>><?php echo 'PAYMENT'; ?></option>
						</select>
					</td>
				</tr>
				<tr>
					<td colspan="">2</td>
					<td colspan="6">All banking charges outside India are for our / their (drawee) A/C</td>
					<td colspan="3">
					DRAWEE
					</td>
				</tr>
			
				<input type="hidden" id="refer_id" value="<?php echo $fetch->id; ?>" 
				<tr>
					<td colspan="">3</td>
					<td colspan="6">Debit all charges including charges in connection with item 4) & 5) to our Account No. 4011255190 With yourselves.</td>
					<td colspan="3">X</td>
				</tr>
				<tr>
					<td colspan="">4</td>
					<td colspan="6">Please forward the documents in one lot by COURIER / REDG. AIR
MAIL** risk and responsibility to (name & address of BUYER/BANK) <br> <b><input type="text" style="width: 100%;font-weight: bold;" name="buyer_bank" id="buyer_bank" value="<?php if($fetch->buyer_bank == '') {  echo 'PLEASE DO NOT SEND THE DOCUMENTS'; } else {  echo $fetch->buyer_bank; } ?>"></b></td>
					<td colspan="3">X</td>
				</tr>
				<tr>
					<td colspan="">5</td>
					<td colspan="6">Kindly forward the Documents under LC No.___________dated__________<br>
					                . On Approval basis(under UCPDC ICC Publication no 600)<br>
					                . With through Scrutiny(under UCPDC ICC Publication no 600)</td>
					<td colspan="3"></td>
				</tr>
				<tr>
					<td colspan="">6</td>
					<td colspan="6">Undertaking: <br><br>
					"We agree that this collection will be subject to Uniform Rules for Collection,
					International Chamber of Commerce(Publication No.:522).We understand that the
					collecting bank has the right to refuse to follow our instructions regarding
					protesting and/or storing and insuring goods in case of non acceptance/non-payment".<br>
					The goods exported/being exported by us not coveredunder negative list of
					imports as mentioned In Export Import   policy 2015-2020 and amendments there
					to till date.We are elligible to export the above mentioned goods under the current
					Export and Import Policy in place.The said good exported/being exported by us
					are not restricted for export through specific licensing under the above mentioned
					policy and amendments.</td>
					<td colspan="3"></td>
				</tr>
				
				<tr>
					<td colspan="10">(** Please strike out which is not applicable)</td>
				</tr>
				<tr>
					<td colspan="">7</td>
					<td colspan="6">PROCEEDS DISPOSAL INSTRUCTIONS. (mark X wherever applicable )</td>
					<td colspan="3"></td>
				</tr>
				<tr>
					<td colspan=""></td>
				
					
						<td colspan="6">Please credit proceeds (Amount ) –  <b><?php  if($fetch->total_value == 0) {  echo  $fetch_invoice_cureency->currency . ' ' . number_format((float) ($fetch_sum_amt_invoice->values_es+$fetch->other_charges), 2, '.', ''); ?> 
					<?php } else if($fetch->discount == 0 && $fetch->other_charges_des == 0) {  echo $fetch_invoice_cureency->currency . ' ' . number_format((float) ($fetch_sum_amt_invoice->values_es+$fetch->other_charges), 2, '.', ''); ?>
					<?php } else {  	$v=$fetch->discount;
					 $s=number_format((float) $fetch->total_value, 2, '.', '');
					$d=$s - $v; 
					echo $fetch_invoice_cureency->currency . ' ' . number_format((float) ($s+$fetch->other_charges), 2, '.', ''); ?> 
					<?php } ?></b>	 - Operative account No.4011255190 with you.</td>
					
					
					<td colspan="3">X</td>
				</tr>
			
				<tr>
					<td colspan=""></td>
					<td colspan="6">(only in case of Confirmed I.C) <br>
					Please credit (Amount) <input type="text" name="cre_amt" id="cre_amt" value="<?php echo $fetch->cre_amt; ?>"> to<br>
					<input type="hidden" name="cre_amt_of" id="cre_amt_of" value="<?php echo $fetch->cre_amt_of; ?>">  
					EEFC A/C No. <input type="text" name="cre_amt_to" id="cre_amt_to" value="<?php echo $fetch->cre_amt_to; ?>"> with you OR <br>
					<input type="text" name="cre_amt_or" id="cre_amt_or" value="<?php echo $fetch->cre_amt_or; ?>">
					( Name of the bank and branch with detailed instructions)</td>
					<td colspan="3"></td>
				</tr>
				<tr>
					<td colspan="">8</td>
					<td colspan="6">Please remit proceeds in INR by P.O. or remit through T.T. as per instructions enclosed.</td>
					<td colspan="3"></td>
				</tr>
					<tr>
					<td colspan="">9</td>
					<td colspan="6">Reason for not submitting the documents to AD bank within 21 days from the shipment date is ________________</td>
					<td colspan="3"></td>
				</tr>
				</tr>
					<tr>
					<td colspan="">10</td>
					<td colspan="6">We hereby declare that there is no outstanding pre-shipment creditwith any other bank against the shipment for thr which documents have been submitted now to you.
					<td colspan="3"></td>
				</tr>
				<tr>
					<td colspan="">11</td>
					<td colspan="6">Please use the forward contract (s), as given below…..</td>
					<td colspan="3"></td>
				</tr>
				<tr>
					<td colspan="1">Forward Contract No. & Date</td>
					<td colspan="3">Forward Contract Amount</td>
					<td colspan="3">Amount to be Utilized for this remittance</td>
					<td colspan="3">Due Date of the Contract</td>
				</tr>
				
				<tr height="50">
					<td colspan="1"></td>
					<td colspan="3"></td>
					<td colspan="3"></td>
					<td colspan="3"></td>
				</tr>
				<tr height="50">
					<td colspan="1"></td>
					<td colspan="3"></td>
					<td colspan="3"></td>
					<td colspan="3"></td>
				</tr>
				<tr>
					<td colspan="10"><br>
					<b><u>DECLARATION – CUM – UNDERTAKING under Section 10(5) of FEMA 1999</u></b><br> <br>
					I/We hereby declare that the transaction the details of which are specifically
					mentioned in this request letter does not involve, and is not designed for the purpose
					of any contravention or evasion of the provisions of the aforesaid Act or of any rules,
					regulation, notification, direction or order made thereunder. I /We also hereby agree
					and undertake to give such information/documents as will reasonably satisfy you about
					this transaction in terms of the above declaration. I/We also understand that if I/We
					refuse to comply with any such requirement or make only unsatisfactory compliance
					therewith, the bank shall refuse in writing to undertake the transaction and shall if it
					has reason to believe that any contravention/evasion is contemplated by me/us report
					the matter to Reserve Bank of India.. I/We further declare that the undersigned has/
					have the authority to give this declaration and undertaking on behalf of the company.<br>
					Yours faithfully,<br><br>
					For DECO TEXTIL <br><br><br>
					AUTHORISED SIGNATORY</td>
				</tr>
			</table>
						
		</div>
	</div>
</div>
<script type="text/javascript" src="<?php echo base_url('assets/js/jquery-3.2.1.min.js');?>"></script>
		<script src="<?php echo base_url('assets/js/bootstrap.min.js');?>"></script>

function buyer_drop_down()
{
	alert();
	
	var v=$('#export_buyer').val();
	alert(v);
	$('#byer_duplicate').val(v);
	$('#byer_consignee_duplicate').val(v);
	
}

$(document).ready(function(){
	$("#booking_print").click(function(){
		$("textarea").css({"resize": "none"});
		$("textarea").css({"border": "none"});
		$('#export_buyer').css({"display": "none"});
		$('#byer_consignee_duplicate').show();
                $('.format_declaration').css({"page-break-inside": "avoid"});

var divToPrint=document.getElementById("print_report");
				newWin= window.open("");
				newWin.document.write(divToPrint.outerHTML);
				newWin.print();
				newWin.close();	
				});

});

function goods_details()
	{
	    
	    var org_lc_no=$('#org_lc_no').val();
		var org_lc_of=$('#org_lc_of').val();
		var org_lc_along=$('#org_lc_along').val();
		var gr_from_no=$('#gr_from_no').val();
		var refer_id=$('#refer_id').val();
		
		var pay_accept=$('#pay_accept').val();
			var org_lc_dt=$('#org_lc_dt').val();
		//var pro_dono=$('#pro_dono').val();
		var buyer_bank=$('#buyer_bank').val();
		var cre_amt=$('#cre_amt').val();
		var cre_amt_of=$('#cre_amt_of').val();
		var cre_amt_to=$('#cre_amt_to').val();
		var cre_amt_or=$('#cre_amt_or').val();
		
		var sb_date=$('#sb_date').val();
		var sb_amt=$('#sb_amt').val();
		var port_code=$('#port_code').val();
		var ad_bank=$('#ad_bank').val();

$.ajax({
           // url:"<?php //echo base_url('packing_list/add_export_data');?>",
url:"<?php echo base_url('packing_list/add_new_export_data');?>",
		         type:"POST",
           
				data:{'org_lc_dt':org_lc_dt,'org_lc_no':org_lc_no,'org_lc_of':org_lc_of,'org_lc_along':org_lc_along,'gr_from_no':gr_from_no,'pay_accept':pay_accept,'refer_id':refer_id,'buyer_bank':buyer_bank,'cre_amt':cre_amt,'cre_amt_of':cre_amt_of,'cre_amt_to':cre_amt_to,'cre_amt_or':cre_amt_or,'sb_date':sb_date,'sb_amt':sb_amt,'port_code':port_code,'ad_bank':ad_bank},

async:false,

success:function(data)
				 {
					swal({
						 title: "Added Sucessfully",
						  text: "",
						 
						});
				 }
			});
	}

</script>