<?php
    $GLOBALS['highlight'] = 'approvals';

    require_once('include/functions/pages.php');
    
    $_page = isset($_GET['p']) ? intval($_GET['p']) : 1;

    include('include/parts/header.php');

    $count_entries = mysqli_fetch_array(mysqli_query_logged("SELECT COUNT(*) AS num FROM tiles WHERE quilt_id IN (SELECT quilt_id FROM quilts_permissions WHERE user_id = '" . $GLOBALS['auth']['id'] . "') AND visibility = '-1'"));
    $count_page = ceil($count_entries['num'] / 1);
    $pages = '<span class="pages">Page: ' . pages('?s=tiles_completed', $_page, $count_page) . '</span><br />';
?>

<div class="header">Approve Tiles<?php echo $count_entries['num'] ? '<br />' . $pages : '' ?></div>

<div class="content">
<?php
    $tiles = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id IN (SELECT quilt_id FROM quilts_permissions WHERE user_id = '" . $GLOBALS['auth']['id'] . "') AND visibility = '-1' ORDER BY tile_id DESC LIMIT " . (($_page - 1) * 1) . ", 1");
    if (mysqli_num_rows($tiles))
    {
        while ($tiles_row = mysqli_fetch_array($tiles))
        {
            echo '<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td>';
             $quilts = mysqli_query_logged("SELECT * FROM quilts WHERE id = '" . $tiles_row['quilt_id'] . "'");
            if ($quilts_row = mysqli_fetch_array($quilts))
            {
                echo '<img src="?g=tile_sides&i=' . $tiles_row['quilt_id'] . '&x=' . $tiles_row['matrix_x'] . '&y=' . $tiles_row['matrix_y'] . '" width="' . ($quilts_row['tile_width'] + $quilts_row['side_pixels'] * 2) . '" height="' . ($quilts_row['tile_height'] + $quilts_row['side_pixels'] * 2) . '" border="0">' . "\r\n";
            }
            echo '</td></tr></table>';
            echo '</div>';
            echo '<div style="padding: 5px 0px 0px 0px;"></div>';  
            echo '<div class="header">Reasoning</div>';
            echo '<div style="padding: 5px 0px 0px 0px;"></div>';  
            echo '<div class="content">';
            echo '<form action="?a=approvals&i=' . $tiles_row['tile_id'] . '" method="post" class="form">';
            echo '<table width="100%" border="0">';
            echo '<tr><td width="150" style="text-align: right;">Todo:</td><td><input name="todo" type="radio" value="1"> Approve <input name="todo" type="radio" value="0"> Deny</td></tr>';
            echo '<tr><td width="150" style="text-align: right;">Reason:</td><td><textarea name="reason" style="border: solid 2px black; margin: 0px; padding: 3px; width: 400px; height: 150px;"></textarea></td></tr>';
            echo '<tr><td width="150" style="text-align: right;"></td><td><input type="submit" value="Confirm" style="border: solid 1px green; background: black; color: green;"></td></tr>';
            echo '</table>';
               echo '</form>';
        }
    }
    else
    {
        echo 'You do not have any tiles to approve.';
    }
?>
</div>

<?php
    if ($count_entries['num'])
    {
        echo '<div class="header">' . $pages . '</div>';
    }

    include('include/parts/footer.php');
?>