<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include_once $_SERVER['DOCUMENT_ROOT'] . "/controller/authcontroller.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/services/database.php";
$authId = $_SESSION['auth_id'];
$admin = $_SESSION['admin'];
$pageTitle = "Inbox";



?>

<!doctype html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <title>Dashboard </title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- <meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
    <meta content="Themesbrand" name="author" /> -->
    <!-- App favicon -->
    <link rel="shortcut icon" href="assets/images/favicon.ico">
    <!-- DataTables -->
    <link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
    <link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

    <!-- Responsive datatable examples -->
    <link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />
    <!-- Bootstrap Css -->
    <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

    <!-- Icons Css -->
    <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
    <!-- App Css-->
    <link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />


</head>


<body data-sidebar="dark">

    <!-- Loader -->
    <div id="preloader">
        <div id="status">
            <div class="spinner"></div>
        </div>
    </div>

    <!-- Begin page -->
    <div id="layout-wrapper">
        <?php

        include_once "includes/header.php";
        ?>


        <!-- ========== Left Sidebar Start ========== -->
        <?php

        include_once "includes/sidebar.php";
        ?>
        <!-- Left Sidebar End -->

        <!-- ============================================================== -->
        <!-- Start right Content here -->
        <!-- ============================================================== -->
        <div class="main-content">
            <div class="page-content">


                <div class="container-fluid">
                    <?php
                    if ($admin) {
                    ?>


                        <div class="row">
                            <div class="col-md-6 col-xl-4">
                                <div class="card text-center">
                                    <div class="mb-2 card-body text-muted">
                                        <h3 class="text-info mt-2">
                                            <?php
                                            $query = "select count(*) as count from ppl_dlvy_log where year(datestamp)=year(current_date)
                                        ";
                                            $result = mysqli_query($db->connection, $query);
                                            $resultArr = mysqli_fetch_all($result, MYSQLI_ASSOC);
                                            echo $resultArr[0]['count'];
                                            ?>
                                        </h3> Current Year

                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6 col-xl-4">
                                <div class="card text-center">
                                    <div class="mb-2 card-body text-muted">
                                        <h3 class="text-purple mt-2">
                                            <?php
                                            $query = "select count(*) as count from ppl_dlvy_log where month(datestamp)=month(current_date - interval 1 month) and year(datestamp)=year(current_date - interval 1 month)
                                        ";
                                            $result = mysqli_query($db->connection, $query);
                                            $resultArr = mysqli_fetch_all($result, MYSQLI_ASSOC);
                                            echo $resultArr[0]['count'];
                                            ?>
                                        </h3> Previous Month


                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6 col-xl-4">
                                <div class="card text-center">
                                    <div class="mb-2 card-body text-muted">
                                        <h3 class="text-primary mt-2">
                                            <?php
                                            $query = "select count(*) as count from ppl_dlvy_log where month(datestamp)=month(current_date) and year(datestamp)=year(current_date)
                                        ";
                                            $result = mysqli_query($db->connection, $query);
                                            $resultArr = mysqli_fetch_all($result, MYSQLI_ASSOC);
                                            echo $resultArr[0]['count'];
                                            ?>
                                        </h3> Current Month


                                    </div>
                                </div>
                            </div>

                        </div>
                    <?php
                    }
                    ?>
                    <!-- end row -->

                    <div class="row">

                        <div class="col-sm-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="card-title mb-4">Peppol Inbox</h4>

                                    <div class="table-responsive">
                                        <table id="inbox-table" class="table  table-bordered dt-responsive nowrap dataTable no-footer dtr-inline" style="border-collapse: collapse; border-spacing: 0px; width: 100%;" role="grid" aria-describedby="datatable_info">
                                            <thead>
                                                <tr role="row">
                                                    <th class="sorting_desc">Tx Date</th>
                                                    <th class=" " tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" style="width: 112px;">From</th>
                                                    <th class=" " tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" style="width: 54px;">Document </th>
                                                    <th class=" " tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" style="width: 109px;" aria-label="Start date: activate to sort column ascending">Reference</th>
                                                    <!-- <th class="" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" style="width: 95px;" aria-label="Salary: activate to sort column ascending">Amount</th> -->
                                                    <th class="text-center" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" style="width: 50px;" aria-label="Salary: activate to sort column ascending">Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                if ($admin) {
                                                    $query = "SELECT * FROM `ppl_dlvy_log` ORDER BY `datestamp` DESC ;";
                                                } else {
                                                    $query = "SELECT * FROM `ppl_dlvy_log` WHERE `receiver`='$authId' ORDER BY `datestamp` DESC ";
                                                }
                                                $result = mysqli_query($db->connection, $query);
                                                $transactionArr = mysqli_fetch_all($result, MYSQLI_ASSOC);
                                                // print_r($transactionArr);
                                                if (count($transactionArr) == 0) {
                                                ?>
                                                    <tr>
                                                        <td colspan="7">No records found</td>
                                                    </tr>
                                                <?php
                                                }
                                                $i = 1;
                                                foreach ($transactionArr as $key => $value) {
                                                ?>
                                                    <tr role="row" class="odd">
                                                        <td class=""><?php
                                                                        echo substr($value['datestamp'], 0, 10);
                                                                        ?></td>
                                                        <td class="_1 dtr-control "><?php echo $value['sender_name']  ?></td>
                                                        <td class=""><?php echo $value['doc_type']  ?></td>
                                                        <td class="_1 dtr-control "><?php echo $value['doc_id']  ?></td>
                                                        <!-- <td> -->
                                                        <?php
                                                        // echo  date('M', strtotime($date));
                                                        ?>
                                                        <!-- </td> -->
                                                        <td class="text-center justify-content-center d-flex">
                                                            <div class="btn-group btn-group-sm mt-2 text-center" role="group" aria-label="Basic example">
                                                                <!-- <a target="_blank" href="https://filestore.billbay.io/dlvy/<?php
                                                                                                                                //  echo $value['filename']; 
                                                                                                                                ?>" class="btn text-center btn-secondary" style="background-color: #3ab49b;border:none">xml</a> -->
                                                                <a onclick="loadXml('<?php
                                                                                        echo $value['filename'];
                                                                                        ?>')" href="javascript:void(0)" class="btn text-center btn-secondary" style="background-color: #3ab49b;border:none">xml</a>
                                                            </div>
                                                            <!-- </td> -->

                                                        </td>
                                                    </tr>
                                                <?php
                                                }
                                                ?>


                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>

                        </div>

                    </div>
                    <!-- end row -->


                    <!-- end row -->

                </div>
                <!-- container-fluid -->
            </div>
            <!-- End Page-content -->

            <?php
            include_once "includes/footer.php";

            ?>
        </div>
        <!-- end main content-->

    </div>
    <div class="modal fade" id="xmlModal" tabindex="-1" aria-labelledby="xmlModalLabel" aria-hidden="true" style="display: none;">
        <div class="modal-dialog modal-xl">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title mt-0" id="xmlModalLabel"></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close">
                    </button>
                </div>
                <div class="modal-body">
                    <pre id="modal-content"></pre>

                    <!-- <div id="modal-content"></div> -->
                </div>
            </div>
            <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
    </div>

    <!-- END layout-wrapper -->

    <!-- Right Sidebar -->

    <!-- /Right-bar -->

    <!-- Right bar overlay-->
    <div class="rightbar-overlay"></div>

    <!-- JAVASCRIPT -->
    <script src="assets/libs/jquery/jquery.min.js"></script>
    <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
    <script src="assets/libs/metismenu/metisMenu.min.js"></script>
    <script src="assets/libs/simplebar/simplebar.min.js"></script>
    <script src="assets/libs/node-waves/waves.min.js"></script>

    <!-- Required datatable js -->
    <script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
    <script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

    <!--Morris Chart-->
    <script src="assets/libs/morris.js/morris.min.js"></script>
    <script src="assets/libs/raphael/raphael.min.js"></script>

    <script src="assets/js/pages/dashboard.init.js"></script>
    <!-- Datatable init js -->
    <script src="assets/js/pages/datatables.init.js"></script>
    <script src="assets/js/app.js"></script>
    <script>
        function loadXml(file) {
            var settings = {
                "url": "http://files.billbay.io/getFile/dlvy/" + file,
                "method": "GET",
                "timeout": 0,
                "headers": {
                    "Authorization": "Bearer <?php echo $_SESSION['token']; ?>"
                },
            };

            $.ajax(settings).done(function(response) {
                console.log(response);
                $('#xmlModal').modal('show');
                $("#modal-content").text(response)
                $("#xmlModalLabel").text(file)

            });

        }
    </script>

</body>

</html>