timetable/lecturer_payment.php at main · Flexsidee/timetable · 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
104
105
106
107
108
<?php include'header.php'; ?>
<div class="pcoded-content">
<div class="pcoded-inner-content">

<div class="main-body">
<div class="page-wrapper">

<div class="row">

<div class="col-lg-12 col-xl-12">
    <div id="forTable" class="dt-responsive table-responsive">
        <table id="basic-btn" class="table table-striped table-hover table-bordered nowrap" style="font-size: 100%; font-weight:bold;">
            <thead>
                <th>#</th>
                <th>Surname</th>
                <th>Bank Name</th>
                <th>Account Number</th>
                <th>Telephone</th>
                <th>Class</th>
            </thead>
            <tbody >
                <?php
                    $sn =0;
                    $query= mysqli_query($db, "select * from vw_lecture_schedule_full order by lecturer_id asc");
                    while($lecture = $query -> fetch_assoc()){
                        $lects= explode(',', $lecture['combined_list']);
                        $sn++;
                ?>
                <tr>
                    <td><?php echo $sn; ?></td>
                    <td><?php echo $lecture['surname']; ?></td>
                    <td><?php
                            if(empty($lecture['bank_name'])){
                                echo "N/A";
                            }else{
                                echo $lecture['bank_name'];
                            }
                        ?></td>
                    <td><?php
                            if(empty($lecture['acct_number'])){
                                echo "N/A";
                            }else{
                                echo $lecture['acct_number'];
                            }
                        ?></td>
                    <td><?php
                        if(empty($lecture['tel'])){
                            echo "N/A";
                        }else{
                            echo $lecture['tel'];
                        }
                    ?></td>
                    <td>
                        <?php
                            $view= " ";
                            foreach($lects as $val){
                                $course=mysqli_fetch_assoc(mysqli_query($db, "select * from vw_full_course where course_id=(select course_id from lecture where lecture_id=".$val.")"));
                                $dept=mysqli_fetch_assoc(mysqli_query($db, "select * from vw_full_course where department_id=".$course['department_id']));
                                $level=mysqli_fetch_assoc(mysqli_query($db, "select * from vw_full_course where level_id=".$course['level_id']));
                                $view.=$course['course_code'].'('.$dept['dept_code'].'), ';
                            }
                                echo substr($view, 0, -2);
                        ?>
                    </td>
                </tr>
                <?php } ?>
                <tfoot>
                    <th>#</th>
                    <th>Surname</th>
                    <th>Bank Name</th>
                    <th>Account Number</th>
                    <th>Telephone</th>
                    <th>Class</th>
                </tfoot>
            </tbody>
        </table>
    </div>

</div>

</div>

</div>
</div>


</div>
</div>
</div>
</div>
</div>
</div>
<?php include'footer_view.php' ?>

<script>
    <?php include'show_days.php'; ?>
    lects=[];
    depts=[]
    i = elem => {
        return document.getElementById(elem);
    }
    $('#viewTimetable').click(function(){
        var  lecturerID=$("#class").val();
        i("class").value=lecturerID;
        $('#printLink').attr('href', 'print_tt_lecturer.php?lecturerId=' + lecturerID);
    })
    </script>