<?php

include "php/header.php";
if(isset($_GET['dt'])){
$dtAry = explode("/", $_GET['dt']);
$srchDt = $dtAry[2] . '-' . $dtAry[1] . '-' . $dtAry[0];
}
?>
<div class="contents">
    <div class="custom-container">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <ol class="breadcrumb">
                    <li><a href="<?= $siteUrlMain; ?>">Home</a></li>
                    <li>Archives</li>
                </ol>
            </div>
            <div class="col-lg-9 col-md-12 col-sm-12 col-xs-12 equalcol conentsection">
                <div class="sections">
                    <h2 class="heading">Newspaper Archives</h2>
                    <div class="clearfix"></div>
                    <div class="sections">
                        <form class="form-inline" action="" method="get">
                            <div class="form-group">
                                <select class="form-control" name="y">
                                    <option value="">Select Year</option>
                                    <?php
                                    $sqlYr = mysqli_query($conn, "SELECT YEAR(issueDate) AS yr FROM product_mapping_cate GROUP BY YEAR(issueDate) ORDER BY YEAR(issueDate) ASC");
                                    while ($rowsYr = mysqli_fetch_array($sqlYr)) {
                                        echo '<option value="' . $rowsYr['yr'] . '" ' . (($_GET['y'] == $rowsYr['yr']) ? 'selected="selected"' : '') . ' >' . $rowsYr['yr'] . '</option>';
                                    }
                                    ?>
                                </select>
                            </div>
                            <div class="form-group">
                                <select class="form-control" name="m">
                                    <option value="">Select Month</option>
                                    <?php
                                    $sqlYr = mysqli_query($conn, "SELECT MONTH(issueDate) AS mth FROM product_mapping_cate GROUP BY MONTH(issueDate) ORDER BY MONTH(issueDate) ASC");
                                    while ($rowsYr = mysqli_fetch_array($sqlYr)) {
                                        echo '<option value="' . $rowsYr['mth'] . '" ' . (($_GET['m'] == $rowsYr['mth']) ? 'selected="selected"' : '') . ' >' . monthName($rowsYr['mth']) . '</option>';
                                    }
                                    ?>
                                </select>
                            </div>
                            <div class="form-group">
                                <select class="form-control" name="it">
                                    <option value="">Select Issue Type</option>
                                    <?php
                                    $sqlIT = mysqli_query($conn, "SELECT * FROM issue_type ORDER BY id ASC");
                                    while ($rowsIT = mysqli_fetch_array($sqlIT)) {
                                        echo '<option value="' . $rowsIT['id'] . '" ' . (($_GET['it'] == $rowsIT['id']) ? 'selected="selected"' : '') . ' >' . $rowsIT['issueType'] . '</option>';
                                    }
                                    ?>
                                </select>
                            </div>
                            <button type="submit" name="q" value="s" class="btn btn-primary backcolor">Search</button>
                        </form><br />&nbsp;
                    </div>

                    <div class="table-responsive">
                        <table class="table table-hover table-striped">
                            <thead>
                                <tr>
                                    <th width="10%">SNo</th>
                                    <th width="15%">Year</th>
                                    <th width="30%">Month</th>
                                    <th width="25%">Issue Type</th>
                                    <th width="20%" style="text-align:center">View</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php

                                $page_name = $siteUrlMain . "archives";
                                if (!isset($_REQUEST["start"])) {
                                    $start = 0;
                                } else
                                    $start = $_REQUEST["start"];

                                $eu = ($start - 0);
                                $limit = 6;
                                $this1 = $eu + $limit;
                                $back = $eu - $limit;
                                $next = $eu + $limit;
                                $sql = mysqli_query($conn, "limit $eu, $limit");

                                $sqlCndtm = "";
                                if (isset($_GET['q']) && $_GET['q'] == "s") {
                                    if ($_GET['y'] != "") {
                                        $sqlCndtm .= " AND YEAR(issueDate)='" . $_GET['y'] . "' ";
                                    }
                                    if ($_GET['m'] != "") {
                                        $sqlCndtm .= " AND MONTH(issueDate)='" . $_GET['m'] . "' ";
                                    }
                                    if ($_GET['it'] != "") {
                                        $sqlCndtm .= " AND issueTypeID='" . $_GET['it'] . "' ";
                                    }
                                }
                                $sqlSeller = "select id,cateName,issueTypeID,noOfPages,issueDate,MONTH(issueDate) AS mth,YEAR(issueDate) AS yr from product_mapping_cate where cateName<>'' " . $sqlCndtm . " order by issueDate desc limit $eu, $limit";
                                $sqltot = "select id from product_mapping_cate where cateName<>'' " . $sqlCndtm . " order by issueDate desc";

                                $isDataInTable = "";
                                $resultSeller = mysqli_query($conn, $sqlSeller);
                                $resulttot = mysqli_query($conn, $sqltot);
                                $nume = mysqli_num_rows($resulttot);
                                if (@mysqli_num_rows($resultSeller) != 0) {
                                    $sno = 0;
                                    while ($rows = mysqli_fetch_array($resultSeller)) {
                                        $sno++;
                                        echo '<tr>
<td>' . $sno . '</td>
<td>' . $rows['yr'] . '</td>
<td>' . $rows['cateName'] . '</td>
<td>' . issueTypeNm($rows['issueTypeID']) . '</td>
<td align="center"><a href="' . magazineUrl($rows['id']) . '" >View</a></td>
</tr>';
                                    }
                                    echo '<tr>
<td colspan="6" align="center">';
                                    if ($back >= 0) {
                                        print '<a href="' . $page_name . '?start=' . $back . '" aria-label="previous"><span aria-hidden="true">previous</span></a> &nbsp; &nbsp; ';
                                    }
                                    if ($this1 < $nume) {
                                        print ' &nbsp; &nbsp; <a href="' . $page_name . '?start=' . $next . '" aria-label="Next"><span aria-hidden="true">next</span></a>';
                                    }
                                    echo '</td>
</tr>';
                                } else {
                                    echo '<tr>
<td colspan="6" align="center"><br /> No data Found. <br /></td>
</tr>';
                                }
                                ?>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="clearfix"></div>
            </div>
            <?php include "php/sideBar.php"; ?>
        </div>
    </div>
</div>
<?php include "php/footer.php"; ?>