allusers.php - master - 0Art/Baev_course

allusers.php
276 строк9 KB
0Art
upload files
18 дек 2024, 18:49
18 дек 2024, 18:49150210e
<?php
// Админка
ini_set('display_errors','On');
require_once("header.php");




$sql = "SELECT * FROM `course7`,users WHERE course7.`potok_number` = 4 AND course7.email = users.email ORDER BY`pay_time` DESC";
$result = mysqli_query($db, $sql);

$sql2 = "SELECT * FROM `anketa` WHERE course_id = 7 AND email IN (SELECT email FROM course7 WHERE potok_number=4) ORDER BY `anketa`.`id` DESC";
$result2 = mysqli_query($db, $sql2);

$allanketas = [];
while($row=mysqli_fetch_array($result2)) {
    $email = $row['email'];
    $allanketas[$email] = [
        "source" => $row['source'],
        "source3" => $row['source3'],
        "source5" => $row['source5'],
        "sourse7" => $row['sourse7'],
        "sourse8" => $row['sourse8'],
        "country" => $row['country'],
        "city" => $row['city'],
        "years" => $row['years'],
        "site" => $row['site'],
        "why" => $row['why'],
        "friendname" => $row["friendname"],
        "tg" => $row["tg"],
        "hobby" => $row["hobby"]
    ];
}


?>
<!DOCTYPE html>
<html style="margin-top:0 !important;">
<head>
	<title>Админка | Максим Баев</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    
    <link href="font/stylesheet.css" rel="stylesheet">
    
    <link href="./css/slick.css" rel="stylesheet" type="text/css">
	<link href="style.css" rel="stylesheet" type="text/css">
	<script src="https://widget.cloudpayments.ru/bundles/cloudpayments"></script>
	
	<link href="https://fonts.googleapis.com/css?family=Open+Sans:400,700" rel="stylesheet">

<style>
    .container {
        margin: 30px auto;
        min-width: 600px;
        max-width: 1024px;
        height: auto;
        display: block;
        position: relative;
        padding: 40px;
    }
    .container .flex {
        display: flex;
        justify-content: space-between;
        padding-top: 50px;
    }
    .container .flex > div {
        word-break: break-all;
        overflow-wrap: break-word;
        width: 29%;
        font-size: 16px;
    }
    .container .flex > div:nth-child(2) {
        width: 66%;

    }
    h4.text-background {
        display: inline-block;
    }
    .iframe {
        width: 100%;
        height: 300px;
        overflow: scroll;

    }
    .users + .users  {
        background-color: white;
        margin-top: 40px;
        padding: 20px;
        color: #000;
    }
    table {
        min-width: 100%;
    }
    table tr td,
    table tr th {
        width: 140px;
    }
    table tr th {
        display: none;
        font-size: 13px;
    }
    table tr td {
        display: none;
		font-size: 13px;
		padding: 3px 0px;
    }
    table tr td.active,
    table tr th.active  {
        display: table-cell;
        text-align: left;
        word-break: break-all;
        overflow-wrap: break-word;
        padding-right: 5.5px;
    }
    table tr td[data=email],
    table tr th[data=email] {
        width: 230px;
    }
    table tr td[data=card],
    table tr th[data=card] {
        width: 100px;
	}
	table tr:hover td {
		background-color: rgba(0,0,0,.2);
	}
	table tr.active td {
		background-color: rgba(0,0,0,.14);
    }
    table.tablecost tbody tr td {
        display: table-cell;
        vertical-align: top;
        word-break: break-word;
    }
    table.tablecost tbody tr > td:first-child {
        padding-right: 10px;
        width: 80%;
    }
    .small-costs div+div {
        margin-top: 20px;
    }
    @media (max-width: 600px) {
        
        .container {
            min-width: 200px;
            padding: 15px;
        }
        .container .flex {
            flex-wrap: wrap;
            padding-top: 20px;
        }
        .container .flex > div,
        .container .flex > div:nth-child(1),
        .container .flex > div:nth-child(2) {
            width: 100%;
        }
        .container .flex > div + div {
            padding-top: 20px;
        }
        table tr > td:nth-child(4),
        table tr > td:nth-child(5),
        table tr > td:nth-child(6),
        table tr > td:nth-child(7),
        table tr > td:nth-child(8),
        table tr > td:nth-child(9),
        table tr > td:nth-child(10),
        table tr > th:nth-child(4),
        table tr > th:nth-child(5),
        table tr > th:nth-child(6),
        table tr > th:nth-child(7),
        table tr > th:nth-child(8),
        table tr > th:nth-child(9),
        table tr > th:nth-child(10) {
            display: none;
        }
    }

</style>
</head>

<body>



                    <table cellspacing="0" cellpadding="0" id="student">
                        <tbody>
                            <?php
                                while($row = mysqli_fetch_array($result)) {
                                    $email1 = $row["email"];
                                    ?>
                                    <tr data-id="<?php echo $row['id'];?>">
                                        <td class="active"><?php echo $row['email'];?></td>
                                        <td class="active"><?php echo $row['name'];?></td>
                                        <td class="active"><?php echo $row['number2'];?></td>
                                        <td class="active"><?php echo $row['instagram'];?></td>
                                        <td class="active"><?php echo $row['tarif'];?></td>
                                        <td class="active"><?php echo $row['payed'];?></td>
                                        <td class="active"><?php echo $row['pay_time'];?></td>
                                        <td class="active"><?php echo $row['pay_token'];?></td>
                                        <td class="active"><?php echo $row['card_first_six'];?></td>
                                        <td class="active"><?php echo $row['card_last_four'];?></td>
                                        <td class="active"><?php echo $row['smartid'];?></td>

                                        <?php if(isset($allanketas[$email1])) {

                                            echo "<td class='active'>" . $allanketas[$email1]['source'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['source3'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['source5'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['sourse7'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['sourse8'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['country'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['city'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['years'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['site'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]['why'] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]["friendname"] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]["tg"] . "</td>";
                                            echo "<td class='active'>" . $allanketas[$email1]["hobby"] . "</td>";
                                            

                                        } 
                                        else {
                                            ?>
                                
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>
                                                <td class="active">-</td>

                                            <?php
                                        }
                                        
                                        
                                        ?> 
                                    </tr>
                                    <?php

                                }

                            ?>
                        </tbody>
                    </table> 
      







<script
        src="https://code.jquery.com/jquery-3.5.1.min.js"
        integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0="
        crossorigin="anonymous"></script>




<script>
    $(document).ready(function() {
	
    });
</script>


</body>
</html>