all_users.php - master - 0Art/Baev_course

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

$potok = 3;
if(isset($_GET['potok'])) {
    $potok = (int) $_GET['potok'];
}


$token = "";
if(isset($_GET['token'])) $token = $_GET['token'];
if($token != "0b7k0b106") {
	header("location:index.php");	
}



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


$homeworks = [];
$sql2 = "SELECT * FROM `homeworks` WHERE lesson_id IN (SELECT id FROM lessons WHERE course=7 AND potok='$potok') AND (status!=0 OR status2!=0)";
$result2 = mysqli_query($db, $sql2);
while( $myrow1 = mysqli_fetch_array($result2) ) {
    $email = $myrow1['email'];
    $homeworks[$email][0][] = $myrow1['status'];
    $homeworks[$email][1][] = $myrow1['status2'];
}


?>
<!DOCTYPE html>
<html style="margin-top:0 !important;">
<head>
	<title>Adminka | Максим Баев</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 rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css">

    <link href="./css/slick.css" rel="stylesheet" type="text/css">
	<link href="style.css?v=2.3" 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: 1284px;
        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: 49%;
        font-size: 16px;
    }
    h4.text-background {
        display: inline-block;
    }
    .iframe {
        width: 100%;
        height: auto;
        overflow: visible;

    }
    .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 !important;
    }
    table tr td[data=card],
    table tr th[data=card] {
        width: 100px !important;
    }
    table tr td[data=payed],
    table tr th[data=payed] {
        width: 80px !important;
	}
	table#student2 tr:hover td {
		background-color: rgba(0,0,0,.2);
	}
	table tr.active td {
		background-color: rgba(0,0,0,.14);
	}
    .small-costs {
        font-size: 12px;
        display: flex;
        margin: 5px 0 0 0;
        flex-wrap: wrap;
        word-break: break-word;
    } 
    .small-costs > div {
        width: 100%;
    }
    .small-costs > div + div {
        margin-top: 2px;
    }
    .form-element:not(.type) label{
        width: 160px;
        display: inline-block;
    }
    .form-element {
        padding: 3px 0px;
    }
    .small-costs strong {
        display: block;
        margin-bottom: 3px;
        margin-top: 10px;
    }
    .small-costs p {
        padding: 0;
        margin: 2px 0;
        text-align: left;
    }
    input[type=radio] {
        display: inline-flex;
        padding: 6px;
        margin-right: 6px;
        margin-bottom: -2px;
        height: auto;
    }
    label + input[type=radio] {
        margin-left: 30px;
    }
    input[type=radio]:checked {
        background-color: green;
    }

    @media (max-width: 600px) {
        .container {
            min-width: 200px;
            padding: 15px;
        }
        .container .flex {
            flex-wrap: wrap;
            padding-top: 20px;
        }
        .container .flex > div {
            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;
        }
    }

    table.potok3 {
        width: 200%;
        max-width: 200%;
    }

    .users.potok3 {
        overflow-x: scroll;
    }
    table.potok3 tr td[data=homework],
    table.potok3 tr th[data=homework] {
        width: 30px;
	}

</style>
</head>

<body>

    <div class="container">
        <div class="header">
            <h1>Свет по Баеву <?=$potok;?>.0</h1>
            <br/><br/>
            Потоки:
            <a href="https://baev.willteach.ru/all_users.php?token=0b7k0b106">3</a>
            <a href="https://baev.willteach.ru/all_users.php?token=0b7k0b106&potok=4">4</a>
            
            <br/><br/><br/>
            <h3>Все пользователи:</h3>

            <div class="users <?php if($potok==3) {echo " potok3 ";} ?> ">

                <div class="iframe">
                    <table cellspacing="0" cellpadding="0" id="student" <?php if($potok==3) {echo " class='potok3' ";} ?>  data-order='[[ 4, "desc" ]]'>
                    <thead>
                        <tr>
                            <th data="email" class="active">Email:</th>
                            <th data="name" class="active">Имя:</th>
                            <th data="number" class="active">Телефон:</th>
                            <th data="payed" class="active">Сумма:</th>
                            <th data="date" data-class-name="priority" class="active">Дата:</th>
                            <th data="tarif" class="active">тариф:</th>
                            <?php if($potok==3) { ?> 
                                <th data="homework" class="active">1Л:</th>
                                <th data="homework" class="active">1С:</th>
                                <th data="homework" class="active">2Л:</th>
                                <th data="homework" class="active">2С:</th>
                                <th data="homework" class="active">3Л:</th>
                                <th data="homework" class="active">3С:</th>
                                <th data="homework" class="active">4Л:</th>
                                <th data="homework" class="active">4С:</th>
                                <th data="homework" class="active">5Л:</th>
                                <th data="homework" class="active">5С:</th>
                                <th data="homework" class="active">6Л:</th>
                                <th data="homework" class="active">6С:</th>
                                <th data="homework" class="active">7Л:</th>
                                <th data="homework" class="active">7С:</th>
                                <th data="homework" class="active">8Л:</th>
                                <th data="homework" class="active">8С:</th>
                            <?php } ?>
                        </tr>
                    </thead>
                        <tbody>
                            <?php
                                    while( $row = mysqli_fetch_array($result) ) {
                                        $email1 = $row['email'];

                                    ?>
                                    <tr class="<?=$trclass;?>"  data-id="<?php echo $row['id'];?>">
                                        <td data="email" class="active"><?php echo $row['email'];?></td>
                                        <td data="name" class="active"><?php echo $row['name'];?></td>
                                        <td data="number" class="active"><?php echo $row['number2'];?></td>
                                        <td data="payed" class="active"><?php echo $row['payed'];?></td>
                                        <td data="date" class="active"><?php echo $row['pay_time'];?></td>
                                        <td data="tarif" class="active"><?php echo $row['tarif'];?></td>
                                        <?php if($potok==3) { ?> 
                                                <?php
                                                    for($k=0; $k<8; $k++) {
                                                            if(isset($homeworks[$email1][0][$k])) {
                                                                $val = $homeworks[$email1][0][$k];
                                                                if($val == 0) $str = "Н";
                                                                if($val == 1) $str = "C";
                                                                if($val == 2) $str = "П";
                                                                echo '<td data="homework" class="active">'.$str.'</td>';
                                                            }
                                                            else {
                                                                echo "<td></td>";
                                                            }

                                                            if(isset($homeworks[$email1][1][$k])) {
                                                                $val = $homeworks[$email1][1][$k];
                                                                if($val == 0) $str = "Н";
                                                                if($val == 1) $str = "C";
                                                                if($val == 2) $str = "П";
                                                                echo '<td data="homework" class="active">'.$str.'</td>';
                                                            }
                                                            else {
                                                                echo "<td></td>";
                                                            }

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

                                }

                            ?>
                        </tbody>
                    </table> 
                </div>
            </div>
            <br/><br/><br/>
        </div>


    </div>






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



 <script type="text/javascript" src="//cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>
<script>
    $(document).ready(function() {
        $('#student').not('.potok3').DataTable({
            "paging":   false,
            "info":     false,
            "search":   false
        });



        $('table#student tbody td[data=mop]').on("click", function() { 
			if($(this).parent('tr').hasClass('active')) {
                data=0;
                $(this).html("");
            }
            else {
                data = 1;
                $(this).html("mop");
            }
            


			$(this).parent('tr').toggleClass('active');
			$.ajax({
				url: 'update_user_mop.php',
				method: 'post',
				dataType: 'html',
				data: {
					"data":data,
					"id":$(this).attr('data-id')
				},
				success: function(data){
					console.log(data);		
				}
			});
        });        
        
        $('table#student tbody textarea').on("input", function() { 
			data = $(this).val();

			$.ajax({
				url: 'update_user_mop_textarea.php',
				method: 'post',
				dataType: 'html',
				data: {
					"data":data,
					"id":$(this).attr('data-id')
				},
				success: function(data){
					console.log(data);		
				}
			});
		});    

     
    });
</script>
</body>
</html>