EVOLUTION-NINJA
Edit File: pending_purchase.php
<?php //include("menu.php"); error_reporting(E_ALL); ?> <link rel="stylesheet" type="text/css" href="<?php echo base_url(); ?>assets/css/avinash.min.css" > <link rel="stylesheet" type="text/css" href="<?php echo base_url(); ?>assets/css/skin-blue.min.css" > <link rel='shortcut icon' type='image/x-icon' href="<?php echo base_url(); ?>assets/images/samll-big.png"/> <div class="page-content-wrapper"> <div class="page-content"> <div class="row" style=" text-align: right;"> <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> <?php if($indent_p == 'indent_preview') { ?> <span class="close-right" ><a href="<?php echo base_url(); ?>vendor/purchase_order_List?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> <?php } else if($indent_p == 'today_preview') { ?> <span class="close-right" ><a href="<?php echo base_url(); ?>vendor/purchase_order_List?prop_id=2" 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> <?php } else if($indent_p == 'monthly_preview') { ?> <span class="close-right" ><a href="<?php echo base_url(); ?>vendor/purchase_order_List?prop_id=3" 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> <?php } else if($indent_p == 'year_preview') { ?> <span class="close-right" ><a href="<?php echo base_url(); ?>vendor/purchase_order_List?prop_id=4" 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> <?php } ?></div> <div class="content-wrapper print" id="print_report" style="padding:10px;"> <table style="width:900px;border-spacing:0;"> <tr> <td colspan="11"></td> <td style="text-align:right;">E-mail : sales@swansilk.com</td> </tr> <tr> <td colspan="11"></td> <td style="text-align:right;">Phone : 080-41888298</td> </tr> <tr> <td colspan="12" style="text-align:center;font-weight:900;font-size:20px;font-style:Akashi;">Deco-Textil</td> </tr> <tr> <td colspan="12" style="text-align:center;">"SWAN HOUSE" No:40, 4th Cross, Residency Road, Banglore - 560025. INDIA</td> </tr> <tr> <td colspan="12" style="text-align:center;">GSTN: 29AACFD0446K1ZG</td> </tr> <tr> <td colspan="12" style="text-align:center;font-weight:600;text-decoration: underline;">PURCHASE ORDER</td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;"> </td> </tr> <tr> <td colspan="10"><?php if(empty($fetch_address)) { } else { echo $fetch_address->name . "<br/>" .$fetch_address->address . "<br/>". $fetch_address->city . "<br/>". $fetch_address->country . "-". $fetch_address->pincode; } ?></td> <td colspan="2" style="text-align:right;">Unapproved PO# : <?php echo $fetch->po_no; ?></td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;">Date : <?php echo $fetch->created_date; ?></td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;">Currency : <?php echo $fetch->currency; ?></td> </tr> <tr> <td colspan="2" style="padding-top: 1%;">Sir / Madam,</td> <!--<td colspan="2" style="padding-top: 1%;">INDENT NO.114 DT. 23.05.17</td>--> <td colspan="8"></td> </tr> <tr> <td colspan="12"> <p style="padding-left:5%;padding-top: 1%;">We request you to supply the following materials as per the terms mentioned here below. kindly mention our P.O No in your invoice.</p> </td> </tr> </table> <table border="1" style="width:900px;border-spacing:0;margin-top: 1%;" cellpadding="5px"> <thead> <tr> <th>SL No.</th> <th>PARTICULARS</th> <th>DESCRIPTION</th> <th>QTY</th> <?php if($fetch->currency == 'INR') { ?> <th>RATE IN INR</th> <th>VALUE IN INR</th> <?php } else if($fetch->currency == 'CHF') { ?> <th>RATE IN CHF</th> <th>VALUE IN CHF</th> <?php } else if($fetch->currency == 'EUR') { ?> <th>RATE IN EUR</th> <th>VALUE IN EUR</th> <?php } else if($fetch->currency == 'GBP') { ?> <th>RATE IN GBP</th> <th>VALUE IN GBP</th> <?php } else if($fetch->currency == 'USD') { ?> <th>RATE IN USD</th> <th>VALUE IN USD</th> <?php } ?> <th>CGST</th> <th>SGST</th> <th>IGST</th> <th>TAX Amount</th> <th>TOT VALUE IN INR</th> <!--<th></th> <th></th>--> </tr> </thead> <tbody> <?php $i=1; $ttl_amt=0; $ttl_amtt=0;$t_val8=0;?> <?php if(isset($fetch_data)) { foreach($fetch_data as $fetch_data){ ?> <?php $t=0;$t_val1=0; $t_val2=0; $t_val3=0;$t_val4=0;$t_val5=0;$t_val6=0;$totalvalue=0;$t_amt=0;$totalvalue1=0;$t_val7=0; $t_amtt=0; $t_val1=$fetch_data->cgst; $t_val2=$fetch_data->sgst; $t_val22=$fetch_data->igst; $t_val3=$fetch_data->inrvalue; $t= $t_val1+$t_val2+$t_val22; $t_val4=$t_val3 * $t/100; $totalvalue=$t_val4 + $t_val5; $t_val6=$fetch_data->totalvalue; $t_amt=$totalvalue+$t_val6; $ttl_amt+=$t_amt; $t_val7=$fetch_data->totalvalue; $t_amtt=$t_amt - $totalvalue ; $ttl_amtt+=$fetch_data->totalvalue; $t_val8+=$fetch_data->totalvalue; ?> <tr > <td><?php echo $i; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->product_name; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->description; ?></td> <td><?php echo $fetch_data->quantity . " " . $fetch_data->indent_unit; ?></td> <td><?php echo $fetch_data->unit ; ?></td> <td><?php echo $fetch_data->inrvalue; ?></td> <td><?php echo $fetch_data->cgst; ?></td> <td><?php echo $fetch_data->sgst; ?></td> <td><?php echo $fetch_data->igst; ?></td> <td><?php echo $t_val4; ?></td> <td><?php echo $fetch_data->totalvalue; ?></td> </tr> <?php $i++; } } ?> <tr> <td colspan="6" style="border-bottom:1px solid transparent !important;"> <textarea rows="1" id="note" name="note" style="width: 100%; border: transparent; " placeholder="NOTE : "><?php echo $fetch_data->note; ?></textarea> </td> <?php if($fetch->currency == 'INR') { ?> <td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in ₹</td> <?php } else if($fetch->currency == 'CHF') { ?> <td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in CHF</td> <?php } else if($fetch->currency == 'EUR') { ?> <td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in €</td> <?php } else if($fetch->currency == 'GBP') { ?> <td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in £</td> <?php } else if($fetch->currency == 'USD') { ?> <td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in $</td> <?php } ?> <td colspan="3" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:right;"><?php echo $ttl_amtt; ?></td> </tr> <!--<tr> <td colspan="5" style="border-top:1px solid transparent !important;"></td> <td colspan="3" style="border-top:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in Rs</td> <td colspan="3" style="border-top:1px solid transparent !important;border-left:1px solid transparent !important;text-align:right;"><?php echo $ttl_amt; ?></td> </tr>--> <tr> <td colspan="6" style="border-top:1px solid transparent !important;"></td> <?php if($fetch->currency == 'INR') { ?> <td colspan="5" style="border-top:1px solid transparent !important;"><b><?php echo "(". convert_number_to_words(round($ttl_amtt)) . "₹/-" .")"; ?></b></td> <?php } else if($fetch->currency == 'CHF') { ?> <td colspan="5" style="border-top:1px solid transparent !important;"><b><?php echo "(". convert_number_to_words(round($ttl_amtt)) . "CHF/-" .")"; ?></b></td> <?php } else if($fetch->currency == 'EUR') { ?> <td colspan="5" style="border-top:1px solid transparent !important;"><b><?php echo "(". convert_number_to_words(round($ttl_amtt)) . "€/-" .")"; ?></b></td> <?php } else if($fetch->currency == 'GBP') { ?> <td colspan="5" style="border-top:1px solid transparent !important;"><b><?php echo "(". convert_number_to_words(round($ttl_amtt)) . "£/-" .")"; ?></b></td> <?php } else if($fetch->currency == 'USD') { ?> <td colspan="5" style="border-top:1px solid transparent !important;"><b><?php echo "(". convert_number_to_words(round($ttl_amtt)) . "$/-" .")"; ?></b></td> <?php } ?> </tr> </tbody> </table> <br> <p><b>Terms and Conditions:<br> <span class="bold" style="font-size:15px">Quantity : We accept </span>only +/- 10%.Any excess Qty will be returned back to the vendor.</b></p> <table style="width:900px;margin-top:10px;"> <tr> <td>  1. Material Delivery : <?php echo $fetch_data->comment; ?></td> </tr> <tr> <td>  2. GST No. : <?php echo $fetch_data->gst_no; ?></td> </tr> <tr> <td>  3. Terms of payment : <?php echo $fetch_data->terms_payment; ?></td> </tr> <tr> <td >  4. Bank Details : <?php echo $fetch_data->bank_details; ?></td> </tr> </table> <table style="width:100%;margin-top:20px;"> <tr> <td>FOR DECO-TEXTIL</td> <td style="text-align:right;">FOR DECO-TEXTIL</td> </tr> <tr > <td style="padding-top:7%;">EXECUTIVE - PURCHASE</td> <td style="text-align:right;padding-top:7%;">DIRECTOR</td> </tr> <tr> <td colspan="2" style="text-align:center; padding-top:5%;">IT IS A COMPUTER GENERATED FORMAT. SIGNATURE IS NOT REQUIRED</td> </tr> </table> </div> <!--- content-wrapper ----> <!------------- content-wrapper END -----------------------------------------------------------------------------------------------------> <?php function convert_number_to_words($no) { //$no = round($number); //alert(); $hundred = null; $digits_1 = strlen($no); $i = 0; $str = array(); $words = array('0' => '', '1' => 'One', '2' => 'Two', '3' => 'Three', '4' => 'Four', '5' => 'Five', '6' => 'Six', '7' => 'Seven', '8' => 'Eight', '9' => 'Nine', '10' => 'Ten', '11' => 'Eleven', '12' => 'Twelve', '13' => 'Thirteen', '14' => 'Fourteen', '15' => 'Fifteen', '16' => 'Sixteen', '17' => 'Seventeen', '18' => 'Eighteen', '19' =>'Nineteen', '20' => 'Twenty', '30' => 'Thirty', '40' => 'Forty', '50' => 'Fifty', '60' => 'Sixty', '70' => 'Seventy', '80' => 'Eighty', '90' => 'Ninety'); $digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore'); while ($i < $digits_1) { $divider = ($i == 2) ? 10 : 100; $number = floor($no % $divider); $no = floor($no / $divider); $i += ($divider == 10) ? 1 : 2; if ($number) { $plural = (($counter = count($str)) && $number > 9) ? 's' : null; $hundred = ($counter == 1 && $str[0]) ? ' And ' : null; $str [] = ($number < 21) ? $words[$number] . " " . $digits[$counter] . $plural . " " . $hundred : $words[floor($number / 10) * 10] . " " . $words[$number % 10] . " " . $digits[$counter] . $plural . " " . $hundred; } else $str[] = null; } $str = array_reverse($str); $result = implode('', $str); return $result ; } ?> </div> <!----- wrapper -----> </div> <script> $(document).ready(function(){ $("#booking_print").click(function(){ var divToPrint=document.getElementById("print_report"); newWin= window.open(""); newWin.document.write(divToPrint.outerHTML); newWin.print(); newWin.close(); }); }); </script> <!--<script> var divContents = $(".print").html(); newWin= window.open(""); newWin.document.write(divContents); newWin.print(); newWin.close(); </script>--> <style> @media only screen and (min-width:320px) and (min-height:640px){ #print_report{ <!--width:900px !important; overflow:auto !important; overflow-x: scroll !important;--> } .content-wrapper { overflow-x: scroll !important; } } </style>