EVOLUTION-NINJA
Edit File: request_letter2.php
<div class="row" style="text-align: right;"> <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"> <!-- <img src="img/swanlogo1.png" class="img-responsive"> --> <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> - <!--- OF <b><?php echo $fetch->customer_name; ?></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" id="gr_from_no" value="<?php echo $fetch->gr_from_no; ?>"></td> <td colspan="2" height="40"><input type="text" name="sb_date" id="sb_date" value="<?php echo $fetch->sb_date; ?>"></td> <td colspan="3" height="40"><input type="text" name="sb_amt" id="sb_amt" value="<?php echo $fetch->sb_amt; ?>"></td> <td colspan="2" height="40"><input type="text" name="port_code" id="port_code" value="<?php echo $fetch->port_code; ?>"></td>--> <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 - (float)$fetch->discount , 2, '.', ''); ?>"></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> <!-- <tr> <td colspan="">3</td> <td colspan="6">PROTEST / DONOT PROTEST** for non-payment / non acceptance</td> <td colspan="3"> <select name="pro_dono" id="pro_dono" > <option value="<?php echo 'PROTEST'; ?>" <?php if($fetch->pro_dono == 'PROTEST') {echo "selected";}?>><?php echo 'PROTEST'; ?></option> <option value="<?php echo 'DONOT PROTEST'; ?>" <?php if($fetch->pro_dono == 'DONOT PROTEST') {echo "selected";}?>><?php echo 'DONOT PROTEST'; ?></option> </select> </td> </tr> <input type="hidden" id="refer_id" value="<?php echo $fetch->id; ?>" > <tr> <td colspan="">4</td> <td colspan="6">If unpaid / unaccepted, store and insure goods</td> <td colspan="3">N A</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, 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, 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) $d, 2, '.', ''); ?> <?php } ?></b> - Operative account No.4011255190 with you.</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">Please credit (Amount) <input type="text" name="cre_amt" id="cre_amt" value="<?php echo $fetch->cre_amt; ?>"> <br> <input type="text" name="cre_amt_of" id="cre_amt_of" value="<?php echo $fetch->cre_amt_of; ?>"> to <br> 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=""></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> <td colspan="1">NOT APPLICABLE</td> <td colspan="3">N A</td> <td colspan="3">NA</td> <td colspan="3">NA</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> <script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script> <link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" > <script> $( document ).ready(function() { $('#byer_consignee_duplicate').hide(); }); </script> <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>