<?php
session_start();
include 'db_connection.php';
//$user_id = $_SESSION["user_id"];
$receiptno = $_GET['receiptno'];
$orderinfo = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM mobileorders WHERE order_id='$receiptno'"));
$userid = $orderinfo['user_id'];
$customer = $orderinfo['customer'];
$pay_option = $orderinfo['pay_option'];

$userinfo = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM mobileusers WHERE user_id='$userid'"));
$sql = "SELECT * FROM mobileorders WHERE order_id = '$receiptno'";

$result = $conn->query($sql);
$discount = 0;
$dis_type = 0;
$paid_amount = 0;
if ($result->num_rows > 0) {

    while ($row = $result->fetch_assoc()) {
        $paid_amount = $row["paid_amount"];
        $orid = $row["orid"];
        $create_at = $row["create_at"];
        $pay_option = $row["pay_option"];
        $amount = $row["amount"];
        $discount = $row["discount"];
        $dis_type = $row["dis_type"];
    }
}

$sql = "SELECT * FROM mobiletemporarycart WHERE orderid = '$receiptno'";
$result = $conn->query($sql);

?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Invoice</title>
    <style>
        @page {
            size: 10.4cm 10cm landscape;
            font-size: 15px;
        }

        body {
            font-family: Arial, sans-serif;
            margin: 0;
            padding: 0;
        }

        .container {
            width: 88mm;
            margin: 0 auto;
            padding: 10px;
            box-sizing: border-box;
        }

        table {
            width: 100%;
            border-collapse: collapse;
        }

        tbody {
            td {
                font-size: 15px;
            }
        }

        tfoot {
            td {
                font-size: 15px;
            }
        }

        th,
        td {
            padding: 5px;
            text-align: left;
            font-size: 10px;

        }

        img {
            width: 80px;
            height: auto;
            margin-right: 10px;
        }

        p {
            font-size: 12px;
            margin: 0;
        }

        .center {
            text-align: center;
        }
    </style>
</head>

<body>
    <div class="container">
        <div style="width:100%;">
            <div style="text-align: center;">
                <b>
					<p style="text-align:center;"><img src="images/poslogo.png" alt="#" width="44px"></p>
                    <p style="font-size:24px;">Payroll</p>
                    <p style="font-size:14px;">Pasyala Road,Mirigama</p>
                </b>
                <p style="margin: 0;">Tel : 071 513 2796</p>
				
            </div>
        </div>
        <hr>
        <p style="font-size:16px;">Receipt: <?php echo $orid; ?></p>
        <p style="font-size:16px;">Date: <?php echo $create_at; ?></p>
        <p style="font-size:16px;">Customer: <?php

                                                if ($orderinfo['customer'] == "0") {
                                                    echo "Walk-in Customer";
                                                } else {

                                                    $userinfo4 = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM mobilecustomers WHERE coid='" . $orderinfo['customer'] . "'"));
                                                    echo $userinfo4['cname'];
                                                }
                                                ?>

        </p>
        <hr>
        <table>
            <thead>
                <tr>
                    <th colspan='4'><span style="text-align: center; font-size:17px;">Item Name</span></th>
                </tr>
                <tr>
                    <th><span style="text-align: center; font-size:17px;">Price</span></th>
                    <th><span style="text-align: center; font-size:17px;">Qty</span></th>
                    <th><span style="text-align: center; font-size:17px;">Dis</span></th>
                    <th><span style="text-align: center; font-size:17px;">Amount</span></th>
                    <th colspan="2" style="text-align: center; font-size:17px;"><span style="text-align: center;">Total</span></th>
                </tr>
            </thead>
            <tbody>
                <?php
                // $total_amount = 0;
                // $dis=0;
                $total_amount = 0;
                $discounted_amount = 0;
                $rowCount = 0;
				$total_discount_amount = 0;
                $dtotl = 0;
                $taxvaltot = 0;
                if ($result->num_rows > 0) {
                    $distot = 0;
                    while ($row = $result->fetch_assoc()) {
                        $rowCount = $rowCount + 1;
                        $sql_products = "SELECT * FROM mobileproducts WHERE prid = " . $row['proid'];
                        $result_products = $conn->query($sql_products);
                        if ($result_products->num_rows > 0) {
                            $product = $result_products->fetch_assoc();
                            if ($row['pro_name'] == null) {
                                $proname = $product["proname"];
                            } else {
                                $proname = $row['pro_name'];
                            }
                        }
                        if ($row['discount_type'] == 1) {
                            $dismark = "%";
                        } else {
                            $dismark = "";
                        }

                        $pro_price = $row["pro_price"];
                        $pro_qty = $row["pro_qty"];
                        $pro_discount = $row["pro_discount"];
                        $pamount = 0;

                        if ($row['discount_type'] == 1) {

                            $pdis =  ($pro_price / 100 * $pro_discount) * $pro_qty;

                            $product_price = ($pro_price * $pro_qty) - $pdis;
                            $distot +=  $pdis;
                            $pamount = $pro_price * $pro_qty;
                        } else {

                            if($product["sellprice"]==$pro_price){

                                $product_price = ($pro_price * $pro_qty) - ($pro_discount * $pro_qty);
                                $distot += $pro_discount * $pro_qty;
                                $pamount = $pro_price * $pro_qty;
                            }else{
                                if($row['proid']==148){
                                    $product_price = ($pro_price * $pro_qty) - ($pro_discount * $pro_qty);
                                    $distot += $pro_discount * $pro_qty;
                                    $pamount = $pro_price * $pro_qty;
                                }else{
                                    $product_price = $pro_price - $pro_discount;
                                    $distot += $pro_discount;
                                    $pamount = $pro_price * $pro_qty;
                                }
                                
                            }
                        }

                        if ($row['tax_type'] == 1) {
                            $taxval1 = ($pamount/100) * $row['tax'];
                            $taxval1 = $taxval1 * $pro_qty;
                        }else{
                            $taxval1 = $row['tax'] * $pro_qty;
                        }
                        $taxx = 0;
                        if($row['tax_type'] == 1){
                            $taxx = $row['tax']."%";
                           
                        }else{
                            $taxx = $row['tax'];
                        }
						
                        $taxvaltot = $taxvaltot + $taxval1;

                        $product_price =  $product_price + $taxval1;

                        $dtotl = $dtotl + $distot;
                        $total_amount += $product_price;
                        $pro_price = number_format((float)$row["pro_price"], 2);
                        $product_price = number_format((float)$product_price, 2);
                        $pamount = number_format((float)$pamount, 2);
                        
                        echo "<tr style='font-size:16px;'><td colspan='4' style='font-size:15px;'><strong>$proname</strong></td></tr>";
                        echo "<tr>";
                        echo "<td style='font-size:15px;'>$pro_price</td>";
                        echo "<td style='font-size:15px;'>$pro_qty</td>";
                        echo "<td style='font-size:15px;'>" . $pro_discount . $dismark . "</td>";
                        echo "<td style='font-size:15px;'>" . $pamount . "</td>";
                        echo "<td colspan='2'  style='text-align: center; font-size:16px;'>$product_price</td>";
                        echo "</tr>";
                        $total_discount_amount += ($pro_discount * $pro_qty);
                    }
                }
                $discounted_amount = $total_discount_amount;

                if ($dis_type == 1) {
                    $discounted_amount = ($paid_amount / 100) * $discount;
                } else {
                    $discounted_amount = $discount;
                }

                $bill_amount = $total_amount - $discounted_amount;
                $balance_amount = $paid_amount - $bill_amount;
                $discount = ($discounted_amount * 100) / $total_amount;
                $t =  $total_amount;

                $dis2 = 0;
                if($orderinfo['discount_type']==0){ 

                     $dis2 =  $orderinfo['all_discount'];
                 }else{
                     $disval = $orderinfo['all_discount'];
                     
                     $dis2 =  ($t/100)*$disval;
 
                 }
                 $taxx = 0;
                 if($orderinfo['tax_type']==0){
                    $taxx =  $orderinfo['tax'];

                    }else{

                    $taxx = ($t /100) * $orderinfo['tax'];

                    }

                    $tot4 =  $t - $dis2;

                  $taxx = $taxx + $taxvaltot;
                  
                    
                ?>
            </tbody>
            <tfoot>
                <tr>
                    <td colspan="6">
                        <hr>
                    </td>
                </tr>
                <tr>
                    <td colspan="5" style='font-size:16px;'>Total Item:</td>
                    <td style='font-size:16px;'><?php echo $rowCount; ?></td>
                </tr>
                <tr>
                    <td colspan="6">
                        <hr>
                    </td>
                </tr>
                <tr>
                    <td colspan="4" style="font-size: 20px;"><strong>Total Amount:</strong></td>
                    <td style="font-size: 20px;"><strong>Rs.</strong></td>
                    <td style="font-size: 20px; text-align:right;"><strong><?php echo number_format((float)$t, 2); ?></strong></td>
                </tr>
                <tr>
                    <td colspan="4" style='font-size:16px;'>Item Discount:</td>
                    <td style='font-size:16px;'>Rs.</td>
                    <td style='font-size:16px; text-align:right;'><?php echo number_format((float)$dtotl, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="4" style='font-size:16px;'>Bill Discount:</td>
                    <td style='font-size:16px;'>Rs.</td>
                    <td style='font-size:16px; text-align:right;'><?php echo number_format((float)$dis2, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="4" style='font-size:16px;'>Bill Amount:</td>
                    <td style='font-size:16px;'>Rs.</td>
                    <td style='font-size:16px; text-align:right;'><?php 
                    $tot4=  $tot4 + $taxx;
                    
                    echo number_format((float)$tot4, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="4" style='font-size:16px;'>Paid Amount:</td>
                    <td style='font-size:16px;'>Rs.</td>
                    <td style='font-size:16px; text-align:right;'><?php echo number_format((float)$paid_amount, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="4" style='font-size:16px;'>Balance Amount:</td>
                    <td style='font-size:16px;'>Rs.</td>
                    <td style='font-size:16px; text-align:right;'><?php 
                    $balance_amount = abs($tot4 - $paid_amount);
                    
                    echo number_format((float)$balance_amount, 2); ?></td>
                </tr>
                <?php if ($pay_option == "credit") { ?>


                    <tr>
                        <td colspan="4" style='font-size:16px;'>Credit Balance:</td>
                        <td style='font-size:16px;'>Rs.</td>
                        <td style='font-size:16px; text-align:right;'><?php
                                                    $userinfo5 = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM mobilecustomers WHERE coid='" . $orderinfo['customer'] . "'"));
                                                    echo number_format((float)$userinfo5['credit_limit'] - $userinfo5['ccredit'], 2); ?></td>
                    </tr>
                <?php } ?>
            </tfoot>
        </table>

        <center>
            <br>
            <hr>
            <p>Thank You Come Again!</p>
            <p>Developed By Seopro Developer</p>
        </center>
    </div>
    <!-- JavaScript to trigger print functionality -->
    <script>
       window.onload = function() {
            window.onafterprint = function() {
                
               window.location.href = '/pos-panel.php';
            };
            window.print();
            setTimeout(function() {
                window.onafterprint = null;
            }, 1000);
        };
    </script>
</body>

</html>

<?php
$conn->close();
?>