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

    include('include/parts/header.php');
    
    echo '<div class="header">';
    echo '<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td valign="top">';
    echo 'Moderate Quilts';
    echo '</td>';
    if ($GLOBALS['auth']['create_quilt'])
    {
        echo '<td align="right" valign="top" style="color: #cccccc; font-weight: normal;">[ <a href="?s=quilt_create">Create A New Quilt</a> ]</td>';
    }
    echo '</tr></table>';
    echo '</div>';
    
    echo '<div class="content">';
    $quilts_permissions = mysqli_query_logged("SELECT * FROM quilts_permissions WHERE user_id = '" . $GLOBALS['auth']['id'] . "' ORDER BY quilt_id DESC");
    if (mysqli_num_rows($quilts_permissions))
    {
        echo '<table width="100%" border="0" cellpadding="0" cellspacing="0">';
        while ($quilts_permissions_row = mysqli_fetch_array($quilts_permissions))
        {
             $quilts = mysqli_query_logged("SELECT * FROM quilts WHERE id = '" . $quilts_permissions_row['quilt_id'] . "'");
            if ($quilts_row = mysqli_fetch_array($quilts))
            {
                echo '<tr>';
                echo '<td width="300" nowrap><a href="?s=quilt&i=' . $quilts_row['id'] . '">' . $quilts_row['name'] . '</a></td>';
                echo '<td width="80">' . $quilts_row['quilt_width'] . ' x ' . $quilts_row['quilt_height'] . '</td>';
                echo '<td width="80">' . $quilts_row['tile_width'] . ' x ' . $quilts_row['tile_height'] . '</td>';
                echo '<td width="200">' . nice_date($quilts_row['posted_on']) . '</td>';
                echo '<td width="200">' . nice_date($quilts_row['modified_on']) . '</td>';
                echo '<td style="text-align: right;">';
                if ($quilts_permissions_row['active'])
                {
                    echo '[ <a href="?a=quilt_moderator_active&i=' . $quilts_row['id'] . '">Activated</a> ]';
                }
                else
                {
                    echo '[ <a href="?a=quilt_moderator_active&i=' . $quilts_row['id'] . '">Deactivated</a> ]';
                }
                if ($quilts_permissions_row['permission'] == 'root')
                {
                     $tiles = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $quilts_row['id'] . "'");
                    $tiles_pending = mysqli_query_logged("SELECT * FROM tiles_pending WHERE quilt_id = '" . $quilts_row['id'] . "'");
                    if (!mysqli_num_rows($tiles) && !mysqli_num_rows($tiles_pending))
                    {
                        echo ' [ <a href="?a=quilt_delete&i=' . $quilts_row['id'] . '">Delete</a> ]';
                    }
                    echo ' [ <a href="?s=quilt_edit&i=' . $quilts_row['id'] . '">Edit</a> ]';
                    if ($quilts_row['finished'] == 0)
                    {
                        if (!mysqli_num_rows($tiles_pending))
                        {
                            $number = $quilts_row['quilt_width'] * $quilts_row['quilt_height'];
                             $tiles = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $quilts_row['id'] . "' AND deleted = '0'");
                            if ($number == mysqli_num_rows($tiles))
                            {
                                 echo ' [ <a href="?a=quilt_finished&i=' . $quilts_row['id'] . '">Mark Finished</a> ]';
                            }
                            else
                            {
                                echo ' [ Mark Finished ]';
                            }
                        }
                        else
                        {
                            echo ' [ Mark Finished ]';
                        }
                    }
                    else
                    {
                        echo ' [ Mark Finished ]';
                    }
                }
                else
                {
                    echo '[ Moderator Only ]';
                }
                echo '</td>';
                echo '</tr>';
            }
        }
        echo '</table>';
    }
    else
    {
        echo 'You are not moderating any quilts.';
    }
    echo '</div>';

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