<?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'];
$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>Receipt: <?php echo $orid; ?></p>
        <p>Pay Type: <?php echo $pay_option; ?></p>
        <p>Date: <?php echo $create_at; ?></p>
        <p>Cashier: <?php echo $userinfo['fullname']; ?></p>
        <hr>
        <table>
            <thead>
                <tr><th colspan='4'><span style="text-align: center; font-size:16px;">Item Name</span></th></tr>
                <tr>
                    
                    <th><span style="text-align: center; font-size:16px;">Price</span></th>
                    <th><span style="text-align: center; font-size:16px;">Quantity</span></th>
                    <th><span style="text-align: center; font-size:16px;">Dis</span></th>
                    <th colspan="2" style="text-align: center; font-size:16px;"><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;
				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 = number_format((float)$row["pro_price"], 2);
						// $pro_qty = $row["pro_qty"];
						// $pro_discount=number_format((float)$row["pro_discount"], 2);
						// $product_price = number_format((float)$pro_price * $pro_qty, 2);
						// $total_amount += $product_price;
                        //$pro_price = number_format((float)$row["pro_price"], 2);
                        $pro_price = $row["pro_price"];
                        $pro_qty = $row["pro_qty"];
                        $pro_discount = $row["pro_discount"];
                       
                        if($row['discount_type']==1){
                         //  $pdis =  ($pro_price * $pro_qty)/100*$pro_discount;

                           $pdis =  ($pro_price/100*$pro_discount)*$pro_qty;
                           // $product_price = number_format((float)($pro_price * $pro_qty)-$pdis, 2);
                           $product_price = ($pro_price * $pro_qty)-$pdis;
                            $distot +=  $pdis;
                        }else{
                            
                           // $product_price = number_format((float)($pro_price * $pro_qty)-$pro_discount,2);
                           
                            $product_price = ($pro_price * $pro_qty)-($pro_discount*$pro_qty);
                            $distot += $pro_discount* $pro_qty;
                            
                        }
                       
                        $total_amount += $product_price;
                        $pro_price = number_format((float)$row["pro_price"], 2);
                        $product_price = number_format((float)$product_price, 2);
                        echo "<tr><td colspan='4'>$proname</td></tr>";
						echo "<tr>";
						echo "<td>$pro_price</td>";
						echo "<td>$pro_qty</td>";
						echo "<td>".$pro_discount.$dismark."</td>";
						echo "<td colspan='2'  style='text-align: center;'>$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;
               // }
            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+$discounted_amount;
				?>
            </tbody>
            <tfoot>
                <tr>
                    <td colspan="5">
                        <hr>
                    </td>       
                </tr>
                <tr>
                    <td colspan="4">Total Item:</td>
                    <td><?php echo $rowCount; ?></td>
                </tr>
                <tr>
                    <td colspan="5">
                        <hr>
                    </td>
                </tr>
                <tr>
                    <td colspan="3" style="font-size: 19px;">Total Amount:</td>
                    <td style="font-size: 19px;">Rs</td>
                    <td style="font-size: 19px;"><?php echo number_format((float)$t, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="3">Discount:</td>
                    <td></td>
                    <td><?php echo number_format((float)$discount, 2); ?>%</td>
                </tr>
                <tr>
                    <td colspan="3">Discounted Amount:</td>
                    <td>Rs</td>
                    <td><?php echo number_format((float)$distot, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="3">Bill Amount:</td>
                    <td>Rs</td>
                    <td><?php echo number_format((float)$bill_amount, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="3">Paid Amount:</td>
                    <td>Rs</td>
                    <td><?php echo number_format((float)$paid_amount, 2); ?></td>
                </tr>
                <tr>
                    <td colspan="3">Balance Amount:</td>
                    <td>Rs</td>
                    <td><?php echo number_format((float)$balance_amount, 2); ?></td>
                </tr>
            </tfoot>
        </table>

        <center>
            <br>
            <hr>
            <p>Thank You Come Again!</p>
            <p>Developed By Seopro Designer</p>
        </center>
    </div>
    <!-- JavaScript to trigger print functionality -->
    <script>
    window.onload = function() {
        window.print();
    };
    </script>
</body>

</html>

<?php
$conn->close();
?>
<script>
function redirectToPosPanel() {
    window.location.href = "/pos-panel.php";
}

window.onafterprint = redirectToPosPanel;
window.onload = function() {
    window.print();
    setTimeout(redirectToPosPanel, 2000);
};
</script>