EVOLUTION-NINJA
Edit File: inward_preview.php
<?php $this->load->view('includes/header.php')?> <!--<link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/main.css');?>"/>--> <!--<link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/bootstrap.min.css');?>"/>--> <!--<link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/font-awesome.min.css');?>"/>--> <link rel='shortcut icon' type='image/x-icon' href='images/fave-icon.png' /> <link href="https://fonts.googleapis.com/css?family=Montserrat:500,600,700&display=swap" rel="stylesheet"> <script type="text/javascript" src="<?php echo base_url('assets/js/jquery-3.4.1.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/bootstrap.min.js');?>"></script> <div class="content-wrapper"> <div class="row"> <div class="col-sm-2"></div> <div class="col-sm-8"> <div class="print_cancle"> <input type="button" id="printbtn" class="btn btn-primary pull-right" onclick="window.print();" value="Print" > <input type="button" id="printbtn" class="btn cancel" value="Close" style="margin-right: 15px; background: #eeeeee;" /> </div> </div> <div class="col-sm-2"></div> </div> <!--row--> <br> <div class="row" style=" padding: 30px;"> <table style="width:100%;border-collapse: collapse;border: 1px solid #555;"> <tr> <td colspan="7" style="text-align:center;padding:8px;border-bottom:1px solid #000;"> <h5 style="margin:0;">Supply Inward Voucher</h5> <h3 style="margin:0;font-weight:bold;">MMG CONSTRUCTION LLP</h3> <p style="margin:0;">#617,1st Floor,New Kantharaj Urs Road,Kuvempunagar, Chamaraja Mohalla, Mysuru-570023</p> </td> </tr> <tr> <td colspan="2" style="padding:8px;height: 150px;vertical-align:top;border-right: 1px solid #000;"> <p style="margin:0;"><strong><i>Supplier Details:</i></strong></p> <p><?php if(empty($vendor_data)) { } else { echo $vendor_data->vendor . "<br/>" .$vendor_data->address . "<br/>". $vendor_data->city . "<br/>". $vendor_data->country . "-". $vendor_data->pincode; } ?></p> </td> <td colspan="2" style="padding:8px;vertical-align:top;"> <p style="margin:0;">No.</p> <p style="margin:0;">Dated</p> </td> <td colspan="3" style="padding:8px;vertical-align:top;"> <p style="margin:0;">: <?php echo $po->po_no; ?></p> <p style="margin:0;">: <?php echo $po->po_date; ?></p> </td> </tr> <tr> <td style="padding:8px;font-weight:bold;border:1px solid #000000;">S.N.</td> <td style="padding:8px;font-weight:bold;border:1px solid #000000;">Description of Goods</td> <td style="padding:8px;font-weight:bold;border:1px solid #000000;">HSN/SAC Code</td> <td style="padding:8px;font-weight:bold;border:1px solid #000000;text-align:right;">Qty.</td> <td style="padding:8px;font-weight:bold;border:1px solid #000000;">Unit</td> <td style="padding:8px;font-weight:bold;border:1px solid #000000;text-align:right;">Price</td> <td style="padding:8px;font-weight:bold;border:1px solid #000000;text-align:right;">Amount(₹)</td> </tr> <!-- <tr> <td style="padding:8px;font-weight:bold;border-right:1px solid #000000;"></td> <td style="padding:8px;font-weight:bold;border-right:1px solid #000000;text-align:right;">b/d</td> <td style="padding:8px;font-weight:bold;border-right:1px solid #000000;"></td> <td style="padding:8px;font-weight:bold;border-right:1px solid #000000;text-align:right;">811.00</td> <td style="padding:8px;font-weight:bold;border-right:1px solid #000000;">Units</td> <td style="padding:8px;font-weight:bold;border-right:1px solid #000000;"></td> <td style="padding:8px;font-weight:bold;text-align:right;">25,609.00</td> </tr>--> <?php $i=1; $ttl_amt=0; $ttl_amtt=0;$t_val8=0; $total=0; $qunatity=0;?> <?php if(isset($po_data)) { foreach($po_data as $po_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 = $po_data->cgst; $t_val2 = $po_data->sgst; $t_val22 = $po_data->igst; $t_val3 = $po_data->inr_value; $t = $t_val1+$t_val2+$t_val22; $t_val4 = $t_val3 * $t/100; $totalvalue = $t_val4 + $t_val5; $t_val6 = $po_data->total_value; $t_amt = $totalvalue+$t_val6; $ttl_amt += $t_amt; $t_val7=$po_data->total_value; $t_amtt=$t_amt - $totalvalue ; $ttl_amtt+=$po_data->total_value; $t_val8+=$po_data->total_value; $total =($po_data->received_goods * $po_data->unit_price) + $total; $qunatity+= $po_data->received_goods; ?> <tr> <td style="padding:8px;border-right:1px solid #000000;"><?php echo $i; ?></td> <td style="padding:8px;border-right:1px solid #000000;"><?php echo $po_data->product_name; ?></td> <td style="padding:8px;border-right:1px solid #000000;text-align:right;"><?php echo $po_data->hsn_code; ?></td> <td style="padding:8px;border-right:1px solid #000000;text-align:right;"><?php echo $po_data->quantity_no; ?></td> <td style="padding:8px;border-right:1px solid #000000;"><?php echo $po_data->unit_name; ?></td> <td style="padding:8px;border-right:1px solid #000000;text-align:right;"><?php echo $po_data->unit_price ; ?></td> <td style="padding:8px;text-align:right;"><?php echo $po_data->inr_value; ?></td> </tr> <?php $i++; } } ?> <tr> <td colspan="6" style="padding:3px;border-right:1px solid #000000;border-top:1px solid #000000;text-align:right;">Total</td> <td style="padding:3px;text-align:right;border-top:1px solid #000000;"><?php echo $po_data->total_amt;?></td> </tr> <!-- <tr> <td colspan="4" style="padding:3px;text-align:center;font-style:italic;">Less : Discount</td> <td colspan="2"></td> <td style="padding:3px;text-align:right;border-left:1px solid #000000;"><?php echo $po_data->discount_amount; ?></td> </tr> --> <!-- <tr> <td colspan="6" style="padding:3px;border-right:1px solid #000000;text-align:right;">Total</td> <td style="padding:3px;text-align:right;"><?php echo $total-$po_data->discount_amount; ?></td> </tr> --> <tr> <td colspan="4" style="padding:3px;text-align:center;font-style:italic;">Add : CGST</td> <td colspan="2">@ 9.00 %</td> <td style="padding:3px;text-align:right;border-left:1px solid #000000;"><?php echo $cgst_total=$po_data->total_amt * $po_data->cgst/100; ?></td> </tr> <!-- <tr> <td colspan="6" style="padding:3px;border-right:1px solid #000000;text-align:right;">Total</td> <td style="padding:3px;text-align:right;"><?php echo $cgst_final_total=$po_data->total_amt+$cgst_total; ?></td> </tr>--> <tr> <td colspan="4" style="padding:3px;text-align:center;font-style:italic;">Add : SGST</td> <td colspan="2">@ 9.00 %</td> <td style="padding:3px;text-align:right;border-left:1px solid #000000;"><?php echo $sgst_total=$po_data->total_amt * $po_data->sgst/100; ?></td> </tr> <!-- <tr> <td colspan="6" style="padding:3px;border-right:1px solid #000000;text-align:right;">Total</td> <td style="padding:3px;text-align:right;"><?php echo $sgst_final_total=$cgst_final_total+$sgst_total; ?></td> </tr>--> <!-- <tr> <td colspan="4" style="padding:3px;text-align:center;font-style:italic;">Add : Rounded Off (+)</td> <td colspan="2"></td> <td style="padding:3px;text-align:right;border-left:1px solid #000000;">0.10</td> </tr>--> <tr> <td colspan="3" style="padding:8px;font-weight:bold;text-align:right;border-top:1px solid #000000;">Grand Total <!-- <td style="padding:3px;text-align:right;"><?php echo $final_grand_total=$cgst_final_total+$sgst_final_total; ?></td> --> <td style="padding:8px;font-weight:bold;text-align:right;border-top:1px solid #000000;"><?php echo $qunatity;?></td> <td style="padding:8px;font-weight:bold;border-top:1px solid #000000;">Units</td> <td style="padding:8px;font-weight:bold;text-align:right;border-top:1px solid #000000;">₹</td> <td style="padding:8px;font-weight:bold;text-align:right;border:1px solid #000000;"><?php echo $final_grand_total=$cgst_total + $sgst_total +$po_data->total_amt ;?> </td> </tr> <tr> <td colspan="7" style="padding:8px;font-weight:bold;border-bottom:1px solid #000000;"><?php echo "(". convert_number_to_words(round($final_grand_total)) . "₹/-" .")"; ?></td> </tr> <tr> <td colspan="7" style="padding:8px;font-weight:bold;text-align:right;height:90px;vertical-align:bottom;">For MMG CONSTRUCTIONS 20-21</td> </tr> <tr> <td colspan="7" style="padding:8px;font-weight:bold;text-align:right;height:70px;vertical-align:bottom;">Authorised Signatory</td> </tr> </table> </div> </div> <!--class="content-wrapper"--> <?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) { $counter = count($str); $hundred = ($counter == 1 && $str[0]) ? 'And ' : null; $str [] = ($number < 21) ? $words[$number] . " " . $digits[$counter] . " " . $hundred : $words[floor($number / 10) * 10] . " " . $words[$number % 10] . " " . $digits[$counter] . " " . $hundred; } /*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 ; } ?> <script type="text/javascript"> $('.cancel').click(function(){ window.location = '<?php echo site_url("inward-purchases")?>'; }); </script> <style type="text/css"> @media print { #printbtn { display : none; } } .print_cancle{ float: right !important; margin-top: 30px; } </style> <?php $this->load->view('includes/footer.php')?>