admin_all.php - master - 0Art/Baev_course

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


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

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

$course7 = [];
$sql0="SELECT email FROM course7";
$result0 = mysqli_query($db,$sql0);
while( $myrow0 = mysqli_fetch_array($result0) ) {
    $course7[] = $myrow0['email'];
}


$sql = "SELECT course7.id,course7.refund,users.email,users.name,users.number,users.number2,course7.promocode,course7.tarif,course7.card_last_four,course7.show_baev,course7.payed,course7.pay_time,course7.promocode FROM `course".$course."`, users WHERE `course".$course."`.`email` = `users`.`email` AND `course".$course."`.`potok_number` = '{$potok}' ORDER BY `course".$course."`.`pay_time` DESC";
$result = mysqli_query($db, $sql);

$all_users = [];
$all_data = [
    "all_pay" => 0,
    "all_users" => 0,
    "returns" => 0,
    "returns_summ" => 0,
    "tarif_0_pay" => 0,
    "tarif_0_users" => 0,
    "tarif_1_pay" => 0,
    "tarif_1_users" => 0,
	"tarif_2_users" => 0,
	"tarif_2_pay" => 0,
    "tarif_3_users" => 0,
    "tarif_3_pay" => 0
];

while( $myrow3 = mysqli_fetch_array($result) ) {
    if($myrow3['promocode']!=58) {
        $id = $myrow3["id"];
        $tarif = $myrow3["tarif"];
        $payed = $myrow3['payed'];
        $all_users[$id]["name"] = $myrow3['name'];
        $number = $myrow3['number'];
        if($number=="") $number = $myrow3['number2'];
        $all_users[$id]["number"] = $number;

        $refund = $myrow3['refund'];
        $all_users[$id]["refund"] = $refund;
        if($payed==$refund) {
            $all_data["returns"]++;
            $all_data["returns_summ"] = $all_data["returns_summ"] + $refund;
        }
        

        $all_data["all_pay"] = $all_data["all_pay"] + $payed;
        $all_data["all_users"]++;
        if($payed==3000 || $payed==2500)$tarif=3;

        $payed = $payed-$refund;


        if($tarif==0) $all_users[$id]["tarif_text"] = "лайт";
        if($tarif==1) $all_users[$id]["tarif_text"] = "медиум";
        if($tarif==2) $all_users[$id]["tarif_text"] = "хард";
        if($tarif==3) $all_users[$id]["tarif_text"] = "бронь";

        if($payed==0) $all_users[$id]["tarif_text"] = $all_users[$id]["tarif_text"] . " (возврат)";
       
        $all_users[$id]["id"] = $myrow3["id"];
        $all_users[$id]["email"] = $myrow3["email"];
        $all_users[$id]["tarif"] = $tarif;
        $all_users[$id]["card"] = "**".$myrow3['card_last_four'];
        if($myrow3['card_last_four'] == "0") $all_users[$id]["card"] = "paypal";
        if($myrow3['card_last_four'] == "3333") $all_users[$id]["card"] = "рассрочка";

        $all_users[$id]["payed"] = $payed;
        $all_users[$id]["pay_time"] = $myrow3['pay_time'];


        $all_users[$id]["show"] = $myrow3["show_baev"];

        if($tarif==0) {
            $all_data["tarif_0_pay"] = $all_data["tarif_0_pay"] + $payed;
            $all_data["tarif_0_users"]++;
        }
        if($tarif==1) {
            $all_data["tarif_1_pay"] = $all_data["tarif_1_pay"] + $payed;
            $all_data["tarif_1_users"]++;
        }
        if($tarif==2) {
            $all_data["tarif_2_pay"] = $all_data["tarif_2_pay"] + $payed;
            $all_data["tarif_2_users"]++;
        }
        if($tarif==3) {
            $all_data["tarif_3_pay"] = $all_data["tarif_3_pay"] + $payed;
            $all_data["tarif_3_users"]++;
        }
    }

}

$check = round($all_data["all_pay"]/ $all_data["all_users"],0);
$amount = ($all_data["all_pay"]-$all_data["returns_summ"])*0.878;
$amount = round($amount,0);

/*
$sql2 = 'SELECT * FROM `baev_marketing_users` WHERE `email` != "" OR `name` != "" OR `number` != ""';
$result2 = mysqli_query($db, $sql2);
$alldata = [];
while( $myrow = mysqli_fetch_array($result2) ) {
    $alldata[] = [
        "name" => $myrow['name'],
        "email" => $myrow['email'],
        "number" => $myrow['number']
    ];
}*/

$sql3 = "SELECT * FROM `costs` WHERE `course` = $course AND `potok` = $potok";
$result3 = mysqli_query($db, $sql3);
$costs = [];
$amount_with_costs = $amount;
$all_costs = 0;
while( $myrow4 = mysqli_fetch_array($result3) ) {
    $costs[] = [
        "summ" => $myrow4['value'],
        "description" => $myrow4['description'],
        "id" => $myrow4['id'],
        "type" => $myrow4['type']
    ];
    $amount_with_costs = $amount_with_costs - $myrow4['value'];
    $all_costs = $all_costs + $myrow4['value'];
 
}




?>
<!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;
    }
    table tr td[data=card],
    table tr th[data=card] {
        width: 100px;
    }
    table tr td[data=payed],
    table tr th[data=payed] {
        width: 80px;
	}
	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;
        }
    }

</style>
</head>

<body>

    <div class="container">
        <div class="header">
            <h1>Свет по Баеву <?=$potok;?>.0</h1>
            <div>Потоки: <a href="admin_all.php?token=<?=$token;?>&potok=3">3</a>, <a href="admin_all.php?token=<?=$token;?>&potok=4">4</a></div>
            <div class="flex">
                <div>
                    <h4 class="text-background">Всего:</h4><br>
                    <span>Всего выручки:</span> <strong><?=$all_data["all_pay"];?> р.</strong>
                    <br/><br>
                    <span>Совершило покупку:</span> <strong><?=$all_data["all_users"];?></strong>
                    <br/><br>
                    <span>Средний чек:</span> <strong><?=$check;?> р.</strong>
                    <br/><br>
                    <span>Возвраты:</span> <strong><?=$all_data["returns_summ"];?> р. (<?=$all_data["returns"];?> шт.)</strong>
                    <br/><br>
                    <span>Минус налоги и возвраты:</span> <strong><?=$amount;?> р.</strong>
                    <br/><br/>
                    <span>Расходы:</span> <strong><?=$all_costs;?> р.</strong>
                    <div class="small-costs">
                        <div>
                            <strong class="small">Разовые расходы <br/>(на создание курса и упаковки)</strong>
                            <?php
                                foreach ($costs as $val) {
                                    if ($val['type'] == 0) {
                                        echo "<p>" . $val['description'] . " —  " . $val['summ'] . " <a class='delete' href='delete_cost.php?id=" . $val['id'] . "'>x</a></p>";
                                    }
                                }
                            ?>
                        </div>
                        <div>
                            <strong class="small">Переменные</strong>
                            <?php
                                foreach ($costs as $val) {
                                    if ($val['type'] == 1) {
                                        echo "<p>" . $val['description'] . " —  " . $val['summ'] . " <a class='delete' href='delete_cost.php?id=" . $val['id'] . "'>x</a></p>";
                                    }
                                }
                            ?>
                        </div>
                    </div>
                    <br/><br/>
                    <span><strong>Чистая прибыль после налогов и расходов:</strong></span><br/> <strong style="font-size: 1.1em;"><?=$amount-$all_costs;?> р.</strong>

                </div>
                <div> 
                    <h4 class="text-background">Лайт:</h4><br>
                    <span>Всего выручки:</span> <strong><?=$all_data["tarif_0_pay"];?></strong>
                    <br/>
                    <span>Совершило покупку:</span> <strong><?=$all_data["tarif_0_users"];?></strong>
                    <br/><br/>
                    <h4 class="text-background">Медиум:</h4><br>
                    <span>Всего выручки:</span> <strong><?=$all_data["tarif_1_pay"];?></strong>
                    <br/>
                    <span>Совершило покупку:</span> <strong><?=$all_data["tarif_1_users"];?></strong>
                    <br/><br/>
                    <h4 class="text-background">Хард:</h4><br>
					<span>Всего выручки:</span> <strong><?=$all_data["tarif_2_pay"];?></strong>
                    <br/>
                    <span>Совершило покупку:</span> <strong><?=$all_data["tarif_2_users"];?></strong>
                    <br/><br/>
					<h4 class="text-background">Бронь:</h4><br>
					<span>Всего выручки:</span> <strong><?=$all_data["tarif_3_pay"];?></strong>
                    <br/>
                    <span>Совершило покупку:</span> <strong><?=$all_data["tarif_3_users"];?></strong>
                    <br/><br/>
                </div>
                
            </div>
            <br/><br/><br/>
            <h3>Добавить расход:</h3>
            <form class="add_cost" action="add_cost.php" method="POST">
                <div class="form-element desc">
                    <label for="desc">Описание:</label>
                    <input type="text" name="desc" id="desc" required="required"/>
                </div>
                <div class="form-element cost">
                    <label for="cost">Сумма расхода:</label>
                    <input type="number" name="cost" id="cost" required="required"/>
                </div>
                <div class="form-element type">
                    <input type="radio" name="type" id="type1" value='0' required="required" checked /><label for="type1">разовый</label>
                    <input type="radio" name="type" id="type2" value='1' required="required"/><label for="type2">переменный</label>
                </div>
                <input type="submit" value="Добавить">
            </form>

            <br/><br/><br/>
            <h3>Кто купил:</h3>

            <div class="users">

                <div class="iframe">
                    <table cellspacing="0" cellpadding="0" id="student">
                    <thead>
                        <tr>
                            <th data="email" class="active">Email:</th>
                            <th data="name" class="active">Имя:</th>
                            <th data="number" class="active">Телефон:</th>
                            <th data="card" class="active">Карта:</th>
                            <th data="payed" class="active">Сумма:</th>
                            <th data="date" class="active">Дата:</th>
                            <th data="tarif" class="active">Тариф:</th>
                        </tr>
                    </thead>
                        <tbody>
                            <?php
                                foreach ($all_users as $row) {
									$trclass="";
									if($row['show']==1) $trclass = "active";
                                    ?>
                                    <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['number'];?></td>
                                        <td data="card" class="active"><?php echo $row['card'];?></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_text'];?></td>
                                    </tr>
                                    <?php

                                }

                            ?>
                        </tbody>
                    </table> 
                </div>
            </div>
            <br/><br/><br/><!--
            <h3>Кто вводил данные в форму:</h3>

            <div class="users">
                <table cellspacing="0" cellpadding="0" id="student2">
                    <thead>
                        <tr>
                            <th data="email" class="active">Email:</th>
                            <th data="card" class="active q1">Имя:</th>
                            <th data="payed" class="active q1">Телефон:</th>

                        </tr>
                    </thead>
                </table>
                <div class="iframe">
                    <table cellspacing="0" cellpadding="0" id="student33">
                        <tbody>
                            <?php
                                foreach ($alldata as $row) {
                                    ?>
                                    <tr>
                                        <td data="email" class="active"><?php echo $row['email'];?></td>
                                        <td data="card" class="active"><?php echo $row['name'];?></td>
                                        <td data="payed" class="active"><?php echo $row['number'];?></td>
                                    </tr>
                                    <?php

                                }

                            ?>
                        </tbody>
                    </table> 
                </div>
            </div>-->
        </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').DataTable({
            "paging":   false,
            "info":     false,
            "search":   false
        });

		$('table#student tbody tr').on("click", function() { 
			if($(this).hasClass('active')) data=0;
			else data = 1;

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




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