| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/aakashsolution.in/public_html/invoice/ |
Upload File : |
<?php
session_start();
include('../action/class.php');
if(isset($_SESSION['user'])){
$role=$_SESSION['role'];
$user=$_SESSION['user'];
$shop=$_SESSION['shop'];
$inv_id=$_GET['inv_id'];
$pre=$_GET['page'];
}
else{
header("Location:index.php");
}
include('notowords.php');
$obj=new database();
$words=new notowords;
$invoice=$obj->get_details("`invoice`","*","`id`='$inv_id' and `shop`='$shop'");
$sales=$obj->get_rows("`sales`","*","`invoice_id`='$inv_id' and `shop`='$shop'");
$shop_details=$obj->get_details("`shop`","*","`id`='$shop'");
$checkigst=$obj->get_details("`sales`","sum(`ivalue`) as `ivalue`,sum(`sgst`+`cgst`+`igst`) as `gst`","`invoice_id`='$inv_id'");
//echo $checkigst['gst'];
$rspan="rowspan='";
if($checkigst['gst']==0){$rspan="";}elseif($checkigst['ivalue']==0) {$rspan.="4'";}else{$rspan.="3'";}
$address=explode(', ',$invoice['add_from']);
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css"
integrity="sha512-iBBXm8fW90+nuLcSKlbmrPcLa0OT92xO1BIsZ+ywDWZCvqsWgccV3gFoRBv0z+8dLJgyAHIhR35VZc2oM/gI1w=="
crossorigin="anonymous" referrerpolicy="no-referrer" />
<meta charset="UTF-8">
<title>Edit Invoice</title>
<style type="text/css" media="print">
@page {
margin-left: 70px;
/*size:8.27in 11.69in ;
/*height:3508 px;
width:2480 px;
/*size: auto; auto is the initial value */
/*margin:0; this affects the margin in the printer settings
-webkit-print-color-adjust:exact;*/
}
/*@media print{*/
/* table {page-break-inside: avoid;}*/
/* #buttons{*/
/* display:none;*/
/* }*/
/* #invoice{*/
/* margin-top:20px;*/
/* }*/
/*}*/
</style>
</head>
<body>
<div id="invoice" style="width:1000px;"><br>
<center>
<font size="+1" style="border:1px solid #000000; padding:5px;"><?php if($invoice['billing_mode']=='retail'){echo "Retail Invoice";} elseif($invoice['billing_mode']=='tax'){echo "Tax Invoice";} ?></font><br /><br>
<font size="+3" style="letter-spacing:2px"><?php echo strtoupper($shop_details['name']); ?><br /></font>
<font size="+1"><?php echo $address[0].", ".$address[1]; ?><br />
<?php echo "Lower Chutia, Ranchi-834001 " ?><br />
Ph : <?php echo $shop_details['phone']; ?><br />
<p style="border:2px solid #000000;" />
<?php if($shop_details['gst']!=''){echo "GSTIN - ".$shop_details['gst']; }?>
</font><br />
</center>
<table align="center" width="95%">
<tr>
<th align="left" width="18%">Invoice No</th>
<td align="left" width="34%"><?php echo $invoice['prefix'].$invoice['invoice_no']; ?></td>
<td align="left" width="13%"></td>
<th align="left" width="18%">Date</th>
<td align="left" width="17%"><?php echo date('d-m-Y',strtotime($invoice['date'])); ?></td>
</tr>
<tr>
<th align="left">Name</th>
<td align="left"><?php echo $invoice['customer_name']; ?></td>
<td align="left"></td>
<th align="left">Phone</th>
<td align="left"><?php echo $invoice['customer_mobile']; ?></td>
</tr>
<tr>
<th align="left">Address</th>
<td align="left" colspan="2" style="font-size:15px; padding-right:10px;"><?php echo $invoice['add_to']."<br />State : ".strtoupper($invoice['state'])." State Code : ".$invoice['code'].""; ?></td>
<th align="left">GSTIN</th>
<td align="left"><?php echo $invoice['gst']; ?></td>
</tr>
<tr>
<th align="left">Reverse Charge</th>
<td align="left"><?php echo ucfirst($invoice['reverse']); ?></td>
<td></td>
<th align="left">Transport Mode</th>
<td align="left"><?php echo ucfirst($invoice['transport_mode']); ?></td>
</tr>
<tr>
<th align="left">Payment Mode</th>
<td align="left"><?php echo ucfirst($invoice['payment_mode']); ?></td>
<td align="left"></td>
<th align="left">Paid Amount</th>
<td align="left"><?php echo toDecimal($invoice['paid']); ?></td>
</tr>
<?php if($invoice['dues']!=0){?>
<tr>
<th align="left">Dues Amount</th>
<td align="left"><?php echo toDecimal($invoice['dues']); ?></td>
<td align="left"></td>
<th align="left">Next Payment</th>
<td align="left"><?php echo date('d-m-Y',strtotime($invoice['next_payment'])); ?></td>
</tr>
<?php } ?>
</table>
<br>
<table align="center" width="95%" height="800" border="1" cellpadding="0" cellspacing="0" id="table" >
<tr height="30">
<th align="center" width="5%" rowspan="2">S.No.</th>
<th align="center" rowspan="2">Description</th>
<th align="center" rowspan="2">HSN</th>
<th align="center" rowspan="2">MRP</th>
<!-- <th align="center" width="5%" rowspan="2">UOM</th> -->
<th align="center" rowspan="2">Qty.</th>
<th align="center" rowspan="2">Rate</th>
<!-- <th align="center" rowspan="2">Charity</th> -->
<!-- <th align="center" rowspan="2">Disc.<br />Amt.</th> -->
<th align="center" rowspan="2">CD %</th>
<th align="center" rowspan="2">Taxable<br />Amount</th>
<?php
if($checkigst['gst']!=0){
if($checkigst['ivalue']==0){
?>
<th align="center" colspan="2">CGST</th>
<th align="center" colspan="2">SGST</th>
<?php }else{ ?>
<th align="center" colspan="2">IGST</th>
<?php
}
}
?>
<th align="center" rowspan="2">Total</th>
</tr>
<tr height="30">
<?php if($checkigst['gst']!=0){ ?>
<th align="center" width="5%">Rate</th>
<th align="center" width="7%">Tax</th>
<?php if($checkigst['ivalue']==0){ ?>
<th align="center" width="5%">Rate</th>
<th align="center" width="7%">Tax</th>
<?php } } ?>
</tr>
<?php
if(is_array($sales)){
$i=0;$quantity=0; $amount=0; $discount=0; $taxable=0;
$cgst=0; $sgst=0; $igst=0; $charity=0;
foreach($sales as $product){
$comp=$obj->get_details("`company`","`name`","`id`='".$product['company_id']."'");
?>
<tr height="30">
<td align="center"><?php echo ++$i; ?></td>
<td style="padding:0px 5px;">
<?php $cat=$obj->get_details("`category`","`name`","`id`='".$product['category']."'"); echo $cat['name']."<br />".$comp['name']."-".$product['model'];
if($product['slno']!=''){echo "<br>Sl.no. : ".$product['slno']; }
?>
</td>
<td align="center"><?php echo $product['hsn']; ?></td>
<td align="center"><?php echo toDecimal($product['mrp']); ?></td>
<!-- <td align="center"><?php echo $product['uom']; ?></td> -->
<td align="center"><?php echo $product['quantity']; ?></td>
<td align="center"><?php echo toDecimal($product['price']); ?></td>
<!-- <td align="center"><?php echo toDecimal($product['charity']); ?></td> -->
<!-- <td align="center"><?php echo $product['discount']; ?></td> -->
<td align="center"><?php echo $product['custdiscount']; ?></td>
<td align="center"><?php echo toDecimal($product['taxable']); ?></td>
<?php
if($checkigst['gst']!=0){
if($checkigst['ivalue']==0){ ?>
<td align="center"><?php echo $product['cgst']."%"; ?></td>
<td align="center"><?php echo toDecimal($product['cvalue']); ?></td>
<td align="center"><?php echo $product['sgst']."%"; ?></td>
<td align="center"><?php echo toDecimal($product['svalue']); ?></td>
<?php } else{ ?>
<td align="center"><?php echo $product['igst']."%"; ?></td>
<td align="center"><?php echo toDecimal($product['ivalue']); ?></td>
<?php
}
}
?>
<td align="center"><?php echo toDecimal($product['amount']); ?></td> <td><i class="fa fa-edit"></i></td>
</tr>
<?php
// $charity+=$product['charity'];
$quantity+=$product['quantity'];
// $discount+=$product['discount'];
$taxable+=$product['taxable'];
$cgst+=$product['cvalue'];
$sgst+=$product['svalue'];
$igst+=$product['ivalue'];
}
}
?>
<tr id="blank">
<td></td><td></td><!-- <td></td> --><td></td><td></td><!-- <td></td>
<td></td> --><td></td><td></td><td></td><td></td><td></td>
<?php if($checkigst['gst']!=0){ echo "<td></td><td></td>";if($checkigst['ivalue']==0){ echo "<td></td><td></td>";}}?>
</tr>
<?php if($invoice['roundoff']!=0){ ?>
<tr height="30">
<td></td>
<td align="center">Round Off</td>
<!-- <td></td> --><td></td><td></td>
<?php if($checkigst['gst']!=0){ echo "";if($checkigst['ivalue']==0){ echo "<td></td><td></td>";}}?>
<td></td><td></td><td></td><td></td><td></td><td></td>
<td align="center"><?php echo twoDigits($invoice['roundoff']); ?></td>
</tr>
<?php } ?>
<?php if($invoice['transport']!=0){ ?>
<tr height="30">
<td></td>
<td align="center">Add Transport</td>
<!-- <td></td> --><td></td><td></td>
<?php if($checkigst['gst']!=0){ echo "";if($checkigst['ivalue']==0){ echo "<td></td><td></td>";}}?>
<td></td><td></td><td></td><td></td><td></td><td></td>
<td align="center"><?php echo toDecimal($invoice['transport']); ?></td>
</tr>
<?php } ?>
<tr height="30">
<td></td>
<th align="center">Total</th><td></td>
<!-- <td></td> --><td></td><td align="center"><?php echo $quantity; ?></td><!-- <td></td> <td align="center"><?php echo $charity; ?></td> -->
<td align="center"><!-- <?php echo $discount; ?> --></td>
<td></td>
<td align="center"><?php echo toDecimal($taxable); ?></td>
<?php
if($checkigst['gst']!=0){if($checkigst['ivalue']==0){ ?>
<td></td><td align="center"><?php echo toDecimal($cgst); ?></td><td></td><td align="center"><?php echo toDecimal($sgst); ?></td>
<?php }else{ ?>
<td></td><td align="center"><?php echo toDecimal($igst); ?></td>
<?php }} ?>
<th align="center"><?php echo toDecimal($invoice['total_amount']); ?></th>
</tr>
<tr height="30">
<th style="text-align:center;" colspan="<?php if($checkigst['gst']!=0){echo 6;}else {echo 12;} ?>">Total Invoice Amount in Words</th>
<?php
if($checkigst['gst']!=0){
?>
<th style="padding-left:10px;" <?php if($checkigst['ivalue']==0){ echo "colspan='6'"; }else{ echo "colspan='4'"; } ?>>Total Amount before Tax</th>
<td align="center"><?php echo toDecimal($taxable); ?></td>
<?php } ?>
</tr>
<tr height="30">
<td colspan="<?php if($checkigst['gst']!=0){echo 6;}else {echo 12;} ?>" style="padding:20px;"
<?php echo $rspan; ?>>
<font size="+1"><?php echo $words->to_words($invoice['total_amount'])." Only";?></font>
</td>
<?php if($checkigst['gst']!=0){
if($checkigst['ivalue']==0){ ?>
<th style="padding-left:10px;" colspan="6">Add CGST</th>
<td align="center"><?php echo toDecimal($cgst); ?></td>
<?php }else{ ?>
<th style="padding-left:10px;" colspan="4">Add IGST</th>
<td align="center"><?php echo toDecimal($igst); ?></td>
<?php }} ?>
</tr>
<?php if($checkigst['gst']!=0){
if($checkigst['ivalue']==0){ ?>
<tr height="30">
<th style="padding-left:10px;" colspan="6">Add SGST</th>
<td align="center"><?php echo toDecimal($sgst); ?></td>
</tr><?php } ?>
<tr height="30">
<th style="padding-left:10px;" <?php if($checkigst['ivalue']==0){ echo "colspan='6'"; }else{ echo "colspan='4'"; } ?>>Total Tax</th>
<td align="center"><?php if($checkigst['ivalue']==0){ echo toDecimal($cgst + $sgst); }else{ echo toDecimal($igst);} ?></td>
</tr>
<tr height="30">
<th style="padding-left:10px;" <?php if($checkigst['ivalue']==0){ echo "colspan='6'"; }else{ echo "colspan='4'"; } ?>>Total Amount after Tax</th>
<td align="center"><?php echo toDecimal($invoice['total_amount']-$invoice['transport']); ?></td>
</tr>
<?php } ?>
<tr height="40">
<td style="text-align:center;" colspan="6"><font size="+2">Total Payable Amount </font></td>
<td align="right" colspan="7"><font size="+2" style="margin-right:20px;"><?php echo "Rs. ".toDecimal($invoice['total_amount']); ?></font></td>
</tr>
<tr height="30">
<td colspan="13">
<?php
$conn = mysqli_connect("localhost","aakadxly_jkumar","jkumar1234","aakadxly_aakash_solution");
$sql=("SELECT * FROM `sales` WHERE invoice_id = '$inv_id' AND cgst=9 ");
$result = $conn->query($sql);
$cval=0;
while($row=mysqli_fetch_array($result)){
$cval += $row['cvalue'];
}
$sql2=("SELECT * FROM `sales` WHERE invoice_id = '$inv_id' AND cgst=6 ");
$result2 = $conn->query($sql2);
$cval2=0;
while($row2=mysqli_fetch_array($result2)){
$cval2 += $row2['cvalue'];
}
$sql3=("SELECT * FROM `sales` WHERE invoice_id = '$inv_id' AND cgst=2.5 ");
$result3 = $conn->query($sql3);
$cval3=0;
while($row3=mysqli_fetch_array($result3)){
$cval3 += $row3['cvalue'];
}
?>
GST 18% = <?php echo toDecimal($cval*2); ?> , GST 12% = <?php echo toDecimal($cval2*2); ?> , GST 5% = <?php echo toDecimal($cval3*2); ?>
</td>
</tr>
</table>
<table align="center" width="95%">
<?php
if($shop_details['account']!='' && $shop_details['ifsc']!=''){
?>
<tr>
<th align="left">Bank Details</th>
<td></td>
</tr>
<tr>
<td>
Bank : <?php echo $shop_details['bank']; ?>
Bank A/C : <?php echo $shop_details['account']; ?>
Bank IFSC : <?php echo $shop_details['ifsc']; ?> <br />
Issue Cheque in the favour of AAKASH SOLUTION
</td>
<td></td>
</tr><?php } ?>
<tr>
<td rowspan="3">
Terms & Conditions:
<ol style="width:350px; font-weight:300; font-size:13px;">
<li>All Disputes are subject to Ranchi Jurisdiction only.</li>
<li>Goods once sold will not be exchanged or returned.</li>
<li>Damaged Goods to be returned within 30 Days.</li>
<li>Any kind of goods returned 10% will be deducted.</li>
<li>Our responsibility ceases once the consignment is dispatched from the shop.</li>
</ol>
</td>
<td align="center" valign="top"><?php echo "For ".strtoupper($shop_details['name']); ?></td>
</tr>
<tr height="10">
<td align="center">Authorised Signature</td>
</tr>
<tr height="10">
<td align="center">Thank You!</td>
</tr>
</table>
<div id="buttons">
<center>
<!-- <button type="button" class="btn btn-danger" onclick="window.print();" -->
<!-- style="background-color:#F70004; height:30px; width:70px; border-radius:5px; color:#FFFFFF; font-size:14px;" >Print</button>-->
<!--<button type="button" onclick="closeThis('<?php echo $pre; ?>');" class="btn btn-default"-->
<!-- style="background-color:#F70004; height:30px; width:70px; border-radius:5px; color:#FFFFFF; font-size:14px;">Close</button>-->
</center>
</div>
</div>
<hr>
<center><p style="font-size: 12px;">Tripledots Software Services Pvt. Ltd. Ratu Road, Ranchi.<br>
<svg width="1em" height="1em" viewBox="0 0 16 16" class="bi bi-telephone-fill" fill="currentColor" xmlns="http://www.w3.org/2000/svg">
<path fill-rule="evenodd" d="M2.267.98a1.636 1.636 0 0 1 2.448.152l1.681 2.162c.309.396.418.913.296 1.4l-.513 2.053a.636.636 0 0 0 .167.604L8.65 9.654a.636.636 0 0 0 .604.167l2.052-.513a1.636 1.636 0 0 1 1.401.296l2.162 1.681c.777.604.849 1.753.153 2.448l-.97.97c-.693.693-1.73.998-2.697.658a17.47 17.47 0 0 1-6.571-4.144A17.47 17.47 0 0 1 .639 4.646c-.34-.967-.035-2.004.658-2.698l.97-.969z"/>
</svg> / <img height="15px" width="15px" src="data:image/svg+xml;base64,PHN2ZyBlbmFibGUtYmFja2dyb3VuZD0ibmV3IDAgMCAyNCAyNCIgaGVpZ2h0PSI1MTIiIHZpZXdCb3g9IjAgMCAyNCAyNCIgd2lkdGg9IjUxMiIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48cGF0aCBkPSJtMjAuNTIgMy40NDljLTIuMjgtMi4yMDQtNS4yOC0zLjQ0OS04LjQ3NS0zLjQ0OS05LjE3IDAtMTQuOTI4IDkuOTM1LTEwLjM0OSAxNy44MzhsLTEuNjk2IDYuMTYyIDYuMzM1LTEuNjUyYzIuNzYgMS40OTEgNS4wMjEgMS4zNTkgNS43MTYgMS40NDcgMTAuNjMzIDAgMTUuOTI2LTEyLjg2NCA4LjQ1NC0yMC4zMDd6IiBmaWxsPSIjZWNlZmYxIi8+PHBhdGggZD0ibTEyLjA2NyAyMS43NTEtLjAwNi0uMDAxaC0uMDE2Yy0zLjE4MiAwLTUuMjE1LTEuNTA3LTUuNDE1LTEuNTk0bC0zLjc1Ljk3NSAxLjAwNS0zLjY0NS0uMjM5LS4zNzVjLS45OS0xLjU3Ni0xLjUxNi0zLjM5MS0xLjUxNi01LjI2IDAtOC43OTMgMTAuNzQ1LTEzLjE5IDE2Ljk2My02Ljk3NSA2LjIwMyA2LjE1IDEuODQ4IDE2Ljg3NS03LjAyNiAxNi44NzV6IiBmaWxsPSIjNGNhZjUwIi8+PHBhdGggZD0ibTE3LjUwNyAxNC4zMDctLjAwOS4wNzVjLS4zMDEtLjE1LTEuNzY3LS44NjctMi4wNC0uOTY2LS42MTMtLjIyNy0uNDQtLjAzNi0xLjYxNyAxLjMxMi0uMTc1LjE5NS0uMzQ5LjIxLS42NDYuMDc1LS4zLS4xNS0xLjI2My0uNDY1LTIuNDAzLTEuNDg1LS44ODgtLjc5NS0xLjQ4NC0xLjc3LTEuNjYtMi4wNy0uMjkzLS41MDYuMzItLjU3OC44NzgtMS42MzQuMS0uMjEuMDQ5LS4zNzUtLjAyNS0uNTI0LS4wNzUtLjE1LS42NzItMS42Mi0uOTIyLTIuMjA2LS4yNC0uNTg0LS40ODctLjUxLS42NzItLjUxLS41NzYtLjA1LS45OTctLjA0Mi0xLjM2OC4zNDQtMS42MTQgMS43NzQtMS4yMDcgMy42MDQuMTc0IDUuNTUgMi43MTQgMy41NTIgNC4xNiA0LjIwNiA2LjgwNCA1LjExNC43MTQuMjI3IDEuMzY1LjE5NSAxLjg4LjEyMS41NzQtLjA5MSAxLjc2Ny0uNzIxIDIuMDE2LTEuNDI2LjI1NS0uNzA1LjI1NS0xLjI5LjE4LTEuNDI1LS4wNzQtLjEzNS0uMjctLjIxLS41Ny0uMzQ1eiIgZmlsbD0iI2ZhZmFmYSIvPjwvc3ZnPg==" /> +91-620 351 1518</p></center>
<script language="javascript">
function closeThis(str){
var page=str;
if(page=='report'){
window.location="../reports?pagename=report";
}
else{
window.location="../invoice?pagename=invoice";
}
}
</script>
</body>
</html>