OAndac/manageYearBook.php at master · barisdoga2/OAndac · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
<?php

if(isset($_GET["approve"])){
    $conn->query("UPDATE yearbook_apps_enrolls SET status='".YEARBOOK_ENROLL_APPROVED."' WHERE yearbook_app_id='".$_GET["yearBookId"]."' AND creator_id='".$_GET["approve"]."'")
    ?>
    <div class="card card-register mx-auto breadcrumb"><font color='green'>Başarıyla Onaylandı!</font></div>
    <?php
}else if(isset($_GET["reject"])){
    $conn->query("UPDATE yearbook_apps_enrolls SET status='".YEARBOOK_ENROLL_REJECTED."' WHERE yearbook_app_id='".$_GET["yearBookId"]."' AND creator_id='".$_GET["reject"]."'")
    ?>
    <div class="card card-register mx-auto breadcrumb"><font color='red'>Başarıyla Reddedildi!</font></div>
    <?php
}

if(isset($_GET["finalize"])){
    $conn->query("UPDATE yearbooks SET end_date='".date("Y-m-d H:i:s")."' WHERE id='".$_GET["yearBookId"]."'");
    echo $conn->error;
    ?>
    <div class="card card-register mx-auto breadcrumb"><font color='green'>Yıllık Başarıyla Bitirildi!</font></div>
    <?php
}

$enrolledUsers = $conn->query("SELECT * FROM yearbook_apps_enrolls WHERE yearbook_app_id='".$_GET["yearBookId"]."'");

if(isset($_GET["userId"])){
    if($_GET["userId"] == $_SESSION["id"])
        echo "Its me!";
    else
        echo "Its another person";
}


?>

<div class="container-fluid">
    <div class="card mb-12">
        <div class="card-header">
            <i class="fa fa-table"></i> Yıllığa Kayıtlı Başvurular Listeleniyor!</div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                    <tr>
                        <th>Isim - Soyisim</th>
                        <th>Email</th>
                        <th>Onayla / Reddet</th>
                    </tr>
                    </thead>
                    <tfoot>
                    <tr>
                        <th>Isim - Soyisim</th>
                        <th>Email</th>
                        <th>Onayla / Reddet</th>
                    </tr>
                    </tfoot>
                    <tbody>

                    <?php

                    while($row = $enrolledUsers->fetch_assoc()){
                        $enrolledUser = $conn->query("SELECT * FROM users WHERE id='".$row["creator_id"]."'")->fetch_assoc();
                        ?>
                        <tr>
                            <td><?php echo $enrolledUser["namee"]." ".$enrolledUser["surname"]; ?></td>
                            <td><?php echo $enrolledUser["email"]; ?></td>
                            <td>
                                <?php
                                if($row["status"] == YEARBOOK_ENROLL_WAITING){
                                    $yearBook = $conn->query("SELECT * FROM yearbooks WHERE id='".$_GET["yearBookId"]."' LIMIT 1")->fetch_assoc();
                                    if($yearBook["end_date"] == null)
                                        echo "<a href='index.php?task=yearBooks&subTask=manageYearBook&yearBookId=".$_GET["yearBookId"]."&approve=".$enrolledUser["id"]."'>Onayla</a> / <a href='index.php?task=yearBooks&subTask=manageYearBook&yearBookId=".$_GET["yearBookId"]."&reject=".$enrolledUser["id"]."'>Reddet</a>";
                                    else
                                        echo "Bu Yıllık Bitirildi!";
                                }else
                                    if($row["status"] == YEARBOOK_ENROLL_APPROVED)
                                        echo "<font color='green'>Onaylandı!</font>";
                                    else
                                        echo "<font color='red'>Reddedildi!</font>";
                                ?>
                            </td>

                        </tr>
                        <?php
                    }

                    ?>

                    </tbody>
                </table>
            </div>
        </div>
        <?php
        $yearBook = $conn->query("SELECT * FROM yearbooks WHERE id='".$_GET["yearBookId"]."' LIMIT 1")->fetch_assoc();
            if($yearBook["end_date"] == null){
                ?>
                <font color="red">Dikkat: Bu işlem gerçekleştirildiği zaman, yıllık kullanıcıları profilleri okuyabilecek ve artık yeni kullanıcı eklenemeyecek. <b>Bu İşlem Geri Alınamaz!</b></font>
                <a name="update" class="btn btn-primary btn-block" href="index.php?task=yearBooks&subTask=manageYearBook&yearBookId=<?php echo $_GET["yearBookId"]; ?>&finalize">Yıllığı Bitir!</a>
                <?php
            }
        ?>
    </div>
</div>