<?php

\session_start();
\ob_start();
include './common.php';
use Ministra\Lib\Admin;
use Ministra\Lib\AdminAccess;
use Ministra\Lib\w13ec15f0067ea75861e61e27c990e4ba\d3507c2999d38573a0a0c91771d70af2;
$error = '';
\Ministra\Lib\Admin::checkAuth();
\Ministra\Lib\Admin::checkAccess(\Ministra\Lib\AdminAccess::ACCESS_VIEW);
echo '<pre>';
echo '</pre>';
$search = @$_GET['search'];
$letter = @$_GET['letter'];
?>
    <html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <style type="text/css">

            body {
                font-family: Arial, Helvetica, sans-serif;
                font-weight: bold;
            }

            td {
                font-family: Arial, Helvetica, sans-serif;
                font-size: 14px;
                text-decoration: none;
                color: #000000;
            }

            .list {
                border-width: 1px;
                border-style: solid;
                border-color: #E5E5E5;
            }

            a {
                color: #0000FF;
                font-weight: bold;
                text-decoration: none;
            }

            a:link, a:visited {
                color: #5588FF;
                font-weight: bold;
            }

            a:hover {
                color: #0000FF;
                font-weight: bold;
                text-decoration: underline;
            }
        </style>
        <title><?php 
echo \_('Video views statistics per month');
?></title>
    </head>
<body>
<table align="center" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="center" valign="middle" width="100%" bgcolor="#88BBFF">
            <font size="5px" color="White"><b>&nbsp;<?php 
echo \_('Video views statistics per month');
?>
                    &nbsp;</b></font>
        </td>
    </tr>
    <tr>
        <td width="100%" align="left" valign="bottom">
            <a href="index.php"><< <?php 
echo \_('Back');
?></a> | <a
                    href="stat_daily_video.php"> <?php 
echo \_('By days');
?></a> | <a
                    href="stat_video_genres.php"> <?php 
echo \_('By genres');
?></a>
        </td>
    </tr>
    <tr>
        <td align="center">
            <font color="Red">
                <strong>
                    <?php 
echo $error;
?>
                </strong>
            </font>
            <br>
            <br>
        </td>
    </tr>
    <tr>
    <td>
<?php 
$page = @$_REQUEST['page'] + 0;
$MAX_PAGE_ITEMS = 30;
$where = 'where accessed=1';
if ($search) {
    $where .= ' and name like "%' . $search . '%"';
}
$total_items = \Ministra\Lib\w13ec15f0067ea75861e61e27c990e4ba\d3507c2999d38573a0a0c91771d70af2::getInstance()->query("select * from video {$where}")->count();
$page_offset = $page * $MAX_PAGE_ITEMS;
$total_pages = (int) ($total_items / $MAX_PAGE_ITEMS + 0.999999);
if (@$_GET['sort_by'] == 'total_counter') {
    $order = 'order by count desc';
} else {
    $order = 'order by counter desc';
}
$query = 'select id, name, count, (count_second_0_5+count_first_0_5) as counter, last_played from video ' . "{$where} {$order} LIMIT {$page_offset}, {$MAX_PAGE_ITEMS}";
$video = \Ministra\Lib\w13ec15f0067ea75861e61e27c990e4ba\d3507c2999d38573a0a0c91771d70af2::getInstance()->query($query);
?>
    <table border="0" align="center" width="620">
        <tr>
            <td>
                <form action="" method="GET">
                    <input type="text" name="search" value="<?php 
echo $search;
?>">
                    <input type="submit"
                           value="<?php 
echo \htmlspecialchars(\_('Search'), \ENT_QUOTES);
?>">
                    &nbsp;
                    <font color="Gray"><?php 
echo \_('search by movie title');
?></font>
                </form>
            </td>
        </tr>
    </table>
    <table>
        <tr>
            <td>
                <script>
                function sort_page() {
                  opt_sort = document.getElementById('sort_by');
                  url = 'stat_video.php?sort_by=' + opt_sort.options[opt_sort.selectedIndex].value +
                    <?php 
echo '\'&search=' . @$_GET['search'] . '&page=' . @$_GET['page'] . '\';';
?>;
                  document.location = url;
                }
                </script>
                <?php 
echo \_('Sort by');
?>
                <select id="sort_by" onchange="sort_page()">
                    <option value="counter"><?php 
echo \_('Views');
?></option>
                    <option value="total_counter" <?php 
if (@$_GET['sort_by'] == 'total_counter') {
    echo 'selected';
}
?>><?php 
echo \_('Total views');
?></option>
                </select>
            </td>
        </tr>
    </table>
<?php 
echo "<center><table class='list' cellpadding='3' cellspacing='0'>\n";
echo '<tr>';
echo "<td class='list'><b>id</b></td>\n";
echo "<td class='list'><b>" . \_('Title') . "</b></td>\n";
echo "<td class='list'><b>" . \_('Views') . "</b></td>\n";
echo "<td class='list'><b>" . \_('Total views') . "</b></td>\n";
echo "<td class='list'><b>" . \_('Last views') . "</b></td>\n";
echo "<td class='list'><b>" . \_('How many storages') . "</b></td>\n";
echo "</tr>\n";
while ($arr = $video->next()) {
    echo '<tr>';
    echo "<td class='list'>" . $arr['id'] . "</td>\n";
    echo "<td class='list' style='color:" . \Ministra\OldAdmin\get_status_color($arr['id']) . "'>" . $arr['name'] . "</td>\n";
    echo "<td class='list'>" . $arr['counter'] . "</td>\n";
    echo "<td class='list'>" . $arr['count'] . "</td>\n";
    echo "<td class='list'>" . $arr['last_played'] . "</td>\n";
    echo "<td class='list'>" . \Ministra\OldAdmin\count_storages($arr['id']) . "</td>\n";
    echo "</tr>\n";
}
echo "</table>\n";
echo "<table width='700' align='center' border=0>\n";
echo "<tr>\n";
echo "<td width='100%' align='center'>\n";
echo \Ministra\OldAdmin\page_bar($MAX_PAGE_ITEMS, $page, $total_pages);
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</center>\n";
