<?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);
$tltdiscount=0;
$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"];
		$tltdiscount = $row["discount"];
        $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: 210mm;
            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;
        }
		thead {
  border-top: 1px solid black;   
  border-bottom: 1px solid black; 
}
		th,td {
			padding-top:10px;
			padding-bottom:10px;
		}
		tfoot{
			border-top: 1px solid #ccc;
		}
    </style>
</head>

<body>
    <div class="container">
        <div style="width:49%; float:left;margin-top:15px;margin-bottom:25px;">
            <div style="text-align: left; display:flex;">
					<div>
					<p style="font-size:24px;"><img style="background: #000;margin-right: 20px;" src="images/poslogo.png" alt="#" width="180px"></p>
                    <p style="font-size:24px;">Payroll</p>
                    <p style="font-size:14px;">Pasyala Road,Mirigama</p>
					<p style="margin: 0;font-size:18px;">Tel : 071 513 2796</p>
					<p style="margin: 0;font-size:18px;">Email : seopro60@gmail.com
</p>
				</div>
            </div>
        </div>
		<div style="width:49%;float:right; text-align:right; margin-top:15px;margin-bottom:25px;"> 
			<p style="font-size:18px;margin-top:5px;">Order No</p>
			 <p style="font-size:18px;margin-top:5px;"><?php echo $orid; ?></p>
			<p style="font-size:18px;margin-top:5px;">Date/Time</p>
			<p style="font-size:18px;margin-top:5px;"><?php echo $create_at; ?></p>
		</div>
        
       <div style="width:100%;clear:both; border-top:1px solid #ccc;padding: 15px 0px;">
		   
		<p style="margin-bottom:8px;">TO</p>
        <p style="font-size:18px;font-weight:600;"><?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'];
													echo $userinfo4['cphone'];
                                                }
                                                ?>

        </p>
		</div>

        <table>
            <thead>
                <tr>
                    <th colspan='6'><span style="text-align: center; font-size:18px;">Item Name</span></th>
                </tr>
                <tr>
                    <th colspan="2"><span style="text-align: center; font-size:18px;">Price</span></th>
                    <th colspan="2"><span style="text-align: center; font-size:18px;">Qty</span></th>
                    <th><span style="text-align: center; font-size:18px;">Dis</span></th>
                    <th colspan="2" style="text-align: right; font-size:18px;"><span style="text-align: right; font-size:18px;">Amount</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;
                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_qty) - $pro_discount;
                                    $distot += $pro_discount;
                                    $pamount = $pro_price * $pro_qty;
                                }
                                
                            }
                        }

                        $product_price =  $product_price;

                        $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-$pro_discount, 2);
                        
                        echo "<tr style='font-size:18px;'><td colspan='6' style='font-size:18px;'><strong>$proname</strong></td></tr>";
                        echo "<tr>";
                        echo "<td colspan='2' style='font-size:17px;'>$pro_price</td>";
                        echo "<td colspan='2' style='font-size:17px;'>$pro_qty</td>";
                        echo "<td style='font-size:17px;'>" . $pro_discount . $dismark . "</td>";
                        echo "<td colspan='2' style='text-align: right; font-size:17px;'>$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;
 
                 }


                $tot4 =  $t - $dis2;

                ?>
            </tbody>
            <tfoot>

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


                    <tr>
                        <td colspan="4" style='font-size:18px;'>Credit Balance:</td>
                        <td style='font-size:18px;'>Rs.</td>
                        <td style='font-size:18px; 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 And 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();
?>