/var/www/hkosl.com/imusiccircle/webadmin/public_holiday_index.php


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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php
    
//not specific setting
    
$page_settings = array(
        
'formid'     => 'Approval'// for permission
        
'section'    => 'Master'// parent/page title
        
'subsection' => 'Public Holiday'// page title
        
'domain'     => 'public_holiday'// table/model name
        
'access'     => 'GNr'// for permission
    
);
    require_once 
"check_login.php";

    
$sql           "select * from public_holiday where deleted = ? order by `date` DESC";
    
$rows bind_pdo($sql, array(0), "selectall");

?>
<!DOCTYPE html>
<html>
<head>
    <?php require_once "_html_head.php"?>
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
    <?php require_once "_header.php"?>
    <?php require_once "_menu.php"?>

    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <h1>
                <?= _lang($page_settings['subsection']) ?>
                <small>
                    <?= _lang("Index"?>
                </small>
            </h1>
            <ol class="breadcrumb">
                <li>
                    <?= _lang("Home"?>
                </li>
                <li class="active"><a href="<?= $page_settings['domain'?>_index.php"><i class="fa"></i>
                        <?= _lang($page_settings['subsection']) ?>
                    </a></li>
            </ol>
        </section>

        <!-- Main content -->
        <section class="content">

            <!-- Your Page Content Here -->

            <!-- main table -->
            <div class="row">
                <div class="col-xs-12">
                    <div class="box">

                        <div class="box-body">

                            <div class="scroll_left_right_container">
                                <div class="scroll_left_right"><img src="../img/scroll_left_right.png"></div>
                            </div>

                            <div class="table-responsive">
                                <table id="example2" class="table table-bordered table-hover datatable-with-filter">
                                    <thead>
                                    <tr>
                                        <th class="no-filter"><?= lang("Date"?></th>
                                        <th style="min-width: 150px;width: 150px;" class="no-filter"><?= lang("Remark"?></th>
                                        <th style="min-width: 125px; width: 125px;" class="no-filter">
                                            <a href="<?= $page_settings['domain'?>_form.php" class="btn btn-sm btn-primary pull-right">
                                                <?= _lang("Create"?>                                                </a>
                                        </th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    <?php foreach ($rows as $row) { ?>
                                        <tr>
                                            <td>
                                                <?= $row["date"?>
                                            </td>

                                            <td>
                                                <?= $row["remark"?>
                                            </td>

                                            <td class="tr">
                                                <div class="btn-group">
                                                    <a href="<?= $page_settings['domain'?>_form.php?id=<?= $row['id'?>" class="btn btn-sm btn-primary">
                                                        <i class="fa fa-pencil" aria-hidden="true"></i> </a>
                                                    <a href="<?= $page_settings['domain'?>_process.php?action=DELETE&id=<?= $row['id'?>" class="btn btn-sm btn-danger confirm-delete">
                                                        <i class="fa fa-trash" aria-hidden="true"></i> </a>
                                                </div>

                                            </td>

                                        </tr>
                                    <?php ?>
                                    </tbody>

                                </table>
                            </div>

                        </div>
                        <!-- /.box-body -->
                    </div>
                    <!-- /.box -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->

            <!-- End of Your Page Content Here -->

        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->

    <?php require_once "_footer.php"?>
    <?php require_once "_aside.php"?>
</div>
<!-- ./wrapper -->

<!-- REQUIRED JS SCRIPTS -->
<?php require_once "_html_script.php"?>
</body>
</html>