Joywork/admin/complaints.php

<?php
    error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
    require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
// закрываем доступ на выполнение запросов
    if(!$_SESSION['superadmin']) {header("location:/index.php"); die("Доступ запрещён!");}
    if($_GET['st'])
    {
        $sql="UPDATE complaints SET status=1 WHERE id=$_GET[st]";
        mysql_query($sql);
    }
    if($_GET['to_black'])
    {
        $sql="UPDATE objects SET black = '1', is_main = 0 WHERE id=$_GET[to_black]";
        mysql_query($sql);
        $sql="UPDATE complaints SET status=1 WHERE id_obj=$_GET[to_black]";
        mysql_query($sql);
    }
    if($_GET['to_arch'])
    {
        $r = to_archive($_GET['to_arch'],1);
        $sql="UPDATE complaints SET status=1 WHERE id_obj=$_GET[to_arch]";
        mysql_query($sql);
        if($r!==true) echo "<script>location.replace('complaints.php');</script>";
    }
    // if($_GET['del'])
    // {
    //     del_object($_GET['del']);
    //     echo "<script>location.replace('complaints.php');</script>";
    // }
    require_once($_SERVER['DOCUMENT_ROOT']."/templates/header-admin.php"); 
?>
    <div class="main-title">
        <h1>Жалобы</h1>
    </div>
    <div class="switch__filter button-row" style="margin: 20px 0;">
        <a href="?status=0" class="selector-button button-left <?php if($_GET['status']==0) echo 'selected'; ?>">
            <span>Новые</span>
            <i class="filter_counter" style="display: block;" id="favorite"><?php echo mysql_result(mysql_query("SELECT COUNT(*) FROM complaints WHERE status=0"),0); ?></i>
        </a>
        <a href="?status=1" class="selector-button button-right <?php if($_GET['status']==1) echo 'selected'; ?>">
            <span>Просмотренные</span>  
            <i class="filter_counter" style="display: block;" id="favorite"><?php echo mysql_result(mysql_query("SELECT COUNT(*) FROM complaints WHERE status=1"),0); ?></i>  
        </a>
        <div class="clear"></div>
    </div> 

    <div class="users">

    <?php 
        if($_GET['status'])
        {
            $status = $_GET['status']; 
        } else 
        {
            $status = 0;
        }
        $sql="SELECT * FROM complaints WHERE status = $status ORDER BY ID DESC";
        $rez=mysql_query($sql);
        if(mysql_num_rows($rez))
            {
                $comps = array();
                while($comp = mysql_fetch_array($rez))
                {
                    $comps[] = $comp;
                }
                foreach ($comps as $comp) 
                {
                    if($comp['id_user'])
                    {
                        $sql1 = "SELECT * FROM users WHERE id=$comp[id_user]";
                        $rez1 = mysql_query($sql1);
                        $user1 = mysql_fetch_assoc($rez1);
                    }
                    echo "<div class='user'>
                    <div class='top'>
                        <div class='date-status'>
                            <span>$comp[date_add]</span>
                            <span>Добавил $user1[fio]</span>
                        </div>
                        <h2>Жалоба $comp[id] на объект <a href='/object.php?id=$comp[id_obj]' target='_blank'>$comp[id_obj]</a></h2>
                    </div>
                    <div class='center'>
                        <div class='user_row row_line'>
                            <div class='col'>
                                <p class='small'>Причина</p>
                                <p><b class='big'>".$COMPLAINT_REASONS["$comp[reason]"]."</b></p>
                            </div>  
                            <div class='col'>
                                <p class='small'>Описание</p>
                                <p><b class='big'>$comp[txt]</b></p>
                            </div>
                            <div class='clear'></div>    
                        </div>
                    </div>
                    <div class='bottom'>
                        <span><a class='fr-btn edit-btn steel i-btn very-small' href='?to_arch=$comp[id_obj]'>В архив</a></span>
                        <span><a class='fr-btn edit-btn steel i-btn very-small' href='?to_black=$comp[id_obj]'>В бан</a></span>

                        <span><a class='fr-btn edit-btn steel i-btn very-small' href='?st=$comp[id]'>Увидел</a></span>
                    </div>
                    </div>";
                }
            } else echo "<div class='empty-block'><h1><i class='ti-na'></i></h1><h2>Жалоб на объекты нет</h2></div>";

    ?>

    </div>

<?php 
    require_once($_SERVER['DOCUMENT_ROOT']."/templates/footer-admin.php"); 
?>