<?php
session_start();
include("dbConfig.php");

if (isset($_SESSION['username']) && isset($_SESSION['name'])) {
    $username = $_SESSION['username'];
    $name = $_SESSION['name'];
} else {
    echo '<META http-equiv="refresh" content="0;logout.php">';
}


?>
<!DOCTYPE html>
<html>

<head>
    <title>Daily Transactions</title>
    <meta charset="UTF-8">
    <link href="assets/img/favicon.png" rel="icon">
    <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">
    <script src='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js'></script>
    <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js'></script>
    <link href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.0.3/css/font-awesome.css'>
    <link href='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css'>
    <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,700,700i|Raleway:300,400,500,700,800|Montserrat:300,400,700" rel="stylesheet">
    <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
    <style type="text/css">
        .nav-menu a {
            padding: 3px 3px;
        }

        .hide {
            display: none;
        }

        h4 {
            padding-top: 5px;
            padding-bottom: 0px;
            color: #1abfbf;
            font-weight: bold;
        }

        hr {
            background-color: #1abfbf;
        }

        .footer {
            position: fixed;
            left: 0;
            bottom: 0;
            width: 100%;
            background-color: #efe8e8;
            color: black;
            text-align: center;
            padding: 4px;
            font-size: 12px;
        }

        .footer a {
            font-weight: bold;
            color: #0c0c67;
        }
    </style>
    <style>
        /* Styles for the summary section */
        .summary-table {
            border-collapse: collapse;
            width: 100%;
            margin-top: 20px;
        }

        .summary-table th,
        .summary-table td {
            border: 1px solid #ddd;
            padding: 8px;
            text-align: left;
        }

        .summary-table th {
            background-color: #f2f2f2;
            font-weight: bold;
        }

        .summary-row {
            background-color: #e7f3fe;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.2);
        }

        .summary-title {
            font-weight: bold;
            color: #004085;
            /* Dark blue */
        }

        .summary-value {
            font-weight: bold;
            color: #155724;
            /* Dark green */
        }
    </style>
</head>

<body>
    <div style="text-align: center">
        <img src="assets/img/logo.png" width="100px" height="100px">
    </div>

    <header id="header">
        <div class="container">
            <nav id="nav-menu-container">
                <ul class="nav-menu">
                    <li class="menu-active">
                        <a class="nav-link" style="padding:2;font-size:14px" href="index.php">Home</a>
                    </li>
                    <li class="menu-has-children">
                        <a class="nav-link" style="padding:2;font-size:14px" href="#">IPD Patients</a>
                        <ul>
                            <li><a href="AddPatient.php">IPD Patient Registration</a></li>
                            <li><a href="AddAdvance.php">IPD add Advance</a></li>
                            <li><a href="UpdateWard.php">Update Ward</a></li>
                            <li><a href="IPDPatients.php">View IPD Patients</a></li>

                        </ul>
                    </li>
                    <li class="menu-has-children">
                        <a class="nav-link" style="padding:2;font-size:14px" href="#">OPD Patients</a>
                        <ul>
                            <li><a href="OPDRegistration.php">OPD Patient Registration</a></li>
                            <li><a href="OPDPatients.php">View OPD Patients</a></li>
                        </ul>
                    </li>
                    <li class="menu-has-children">
                        <a class="nav-link" style="padding:2;font-size:14px" href="#">Staff</a>
                        <ul>
                            <li><a href="AddStaff.php">Add Staff</a></li>
                            <li><a href="StaffList.php">Staff List</a></li>
                        </ul>
                    </li>
                    <li class="menu-has-children">
                        <a class="nav-link" style="padding:2;font-size:14px" href="#">Billing</a>
                        <ul>
                            <li><a href="billingId.php">Generate Consolidate Bill</a></li>
                            <li><a href="InvestigationId.php">Generate Investigation Bill</a></li>
                            <li><a href="FinaleBillId.php">Generate Discharge Bill</a></li>
                            <li><a href="SearchBill.php">Search Bill</a></li>
                        </ul>
                    </li>
                    <li class="menu-has-children">
                        <a class="nav-link" style="padding:2;font-size:14px" href="#">Particular</a>
                        <ul>
                            <li><a href="AddParticulars.php">Add Particulars</a></li>
                            <li><a href="ViewParticulars.php">View Particulars</a></li>
                        </ul>
                    </li>
                    <li class="menu-has-children">
                        <a class="nav-link" style="padding:2;font-size:14px" href="#">Report</a>
                        <ul>
                            <li><a href="UploadReport.php">Upload Patient Report</a></li>
                            <li><a href="DailyTrans.php">Transactions</a></li>
                            <li><a href="userTrans.php">User Transactions</a></li>
                            <li><a href="ViewReport.php">View Patient Reports</a></li>
                        </ul>
                    </li>
                    <li class="menu-has-children">
                        <a class="nav-link" style="padding:2;font-size:14px" href="#" style="font-size:15px"><?php echo $name ?></a>
                        <ul>
                            <li><a href="logout.php">Logout</a></li>
                            <li><a href="ResetPassword.php">Reset Password</a></li>
                        </ul>
                    </li>
                </ul>
            </nav><!-- #nav-menu-container -->
        </div>
    </header>

    <section>
        <div class="row">
            <div class="col-md-1"></div>
            <div class="col-md-10">
                <div class="shadow p-3 mb-5 bg-light rounded">
                    <h2 style="text-align: center;font-weight: bold;color:#fff;background-color: #279480;padding:10px;">List of Bills</h2><br>
                    <form method="POST" action="trans.php">
                        <div class="row">
                            <div class="form-group col">
                                <label for="datefrom">From</label>
                                <input class="form-control" type="date" name="datefrom" id="datefrom" value="<?php echo $_POST['datefrom'] ?? ''; ?>" required>
                            </div>
                            <div class="form-group col">
                                <label for="dateto">To</label>
                                <input class="form-control" type="date" name="dateto" id="dateto" value="<?php echo $_POST['dateto'] ?? ''; ?>" required>
                            </div>
                            <div class="col">
                                <button type="submit" class="btn btn-primary" id="viewbtn">View</button>
                            </div>
                        </div>
                    </form>
                    


                    <br>
                    <button type="button" class="btn btn-danger" onclick="history.back()">Back</button><br><br>
                </div>
            </div>
            <div class="col-md-1"></div>
        </div>
    </section>

    <script>
        function exportTableToCSV(tableID, fromDate, toDate) {
            var table = document.getElementById(tableID);
            var rows = table.querySelectorAll('tr');
            var csvContent = [];

            rows.forEach((row, index) => {
                var cols = row.querySelectorAll('td, th');
                var csvRow = [];
                cols.forEach(col => {
                    var cellText = col.innerText.trim();

                    cellText = cellText.replace(/\n/g, " ");

                    cellText = `"${cellText.replace(/"/g, '""')}"`;


                    if (row.parentElement.tagName === 'THEAD' || index === 0) {
                        cellText = `"**${cellText}**"`;
                    }
                    csvRow.push(cellText);
                });
                csvContent.push(csvRow.join(","));
            });


            var filename = `${fromDate}_${toDate}_dailytransactions.csv`;


            var csvFile = new Blob([csvContent.join("\n")], {
                type: 'text/csv'
            });
            var downloadLink = document.createElement("a");
            downloadLink.href = URL.createObjectURL(csvFile);
            downloadLink.download = filename;


            document.body.appendChild(downloadLink);
            downloadLink.click();
            document.body.removeChild(downloadLink);
        }
    </script>

    <div class="footer">
        &copy; Copyright 2024 All Rights Reserved <strong>Vidyaranya Hospital PVt LTD.</strong>. | Designed by <a href="http://www.vatsinsoft.in/">Vatsin Soft</a>
    </div>

    <script src='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js'></script>
    <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js'></script>
    <script src="assets/vendor/jquery/jquery.min.js"></script>
    <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
    <script src="assets/js/main.js"></script>
</body>

</html>