Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $date = array();
- $nDays = 24 * 60 * 60;
- $tanggal_aktive = isset($_GET['tgl']) ? $_GET['tgl'] : date("Y-m-d");
- // oktober
- $n = date("w");
- if ($n == 0)
- {
- for ($i = 7; $i > 0; $i--)
- {
- $date[] = date("Y-m-d", strtotime("-{$i} days"));
- }
- }
- else
- {
- $j = 7 + $n;
- for ($i = $j; $i > 0; $i--)
- {
- $date[] = date("Y-m-d", strtotime("-{$i} days"));
- }
- }
- // november
- $date_nov1 = '2018-11-01';
- $date_des1 = '2018-12-01';
- /*
- for($i=strtotime($date_nov1);$i<strtotime($date_des1);$i+=$nDays){
- $date[]=date("Y-m-d",$i);
- }
- */
- echo "<br />$i $n";
- while ($i !== FALSE)
- {
- $date[] = date("Y-m-d", strtotime("+{$i} days"));
- $n = date("w", strtotime("+{$i} days"));
- echo "<br />$i $n";
- $i++;
- if ($i > 8 && $n == 6) $i = FALSE;
- }
- // die('<pre>'.print_r($date,1));
- $j = count($date) % 7;
- while ($j != 0)
- {
- $date[] = date("Y-m-d", $i);
- $i+= $nDays;
- $j = count($date) % 7;
- }
- // echo '<pre>'.print_r($date,1).$j;
- if (!isset($_SESSION["user"]))
- {
- echo "<script>alert('Kamu Harus Login Dulu, Terima Kasih')</script>";
- header("location: login.php");
- }
- include "header.php";
- include "navbar.php";
- ?>
- <html>
- <body>
- <div class="container">
- <div class="row">
- <div class="col-md-8">
- <label>Tempat</label><br />
- <label><a href="dataBooking.php">Gedung Tarbiayah A</a></label><br />
- <label><a href="dataBooking2.php">Gedung Tarbiayah B</a></label><br />
- <label><a href="dataBooking3.php">Gedung Tarbiayah C</a></label>
- </div>
- <div class="col-md-4">
- <div class="container">
- <div class="row">
- <div class="span12">
- <table class="table-condensed table-bordered table-striped">
- <thead>
- <tr>
- <th colspan="7">
- <span class="btn-group">
- <a class="btn"><i class="icon-chevron-left"></i></a>
- <a class="btn active"><?php echo date("Y"); ?></a>
- <a class="btn"><i class="icon-chevron-right"></i></a>
- </span>
- </th>
- </tr>
- <tr>
- <th>Su</th>
- <th>Mo</th>
- <th>Tu</th>
- <th>We</th>
- <th>Th</th>
- <th>Fr</th>
- <th>Sa</th>
- </tr>
- </thead>
- <tbody>
- <?php
- foreach($date as $n => $dt)
- {
- if ($n % 7 == 0)
- {
- ?><tr><?php
- }
- $tgl = date("d/m", strtotime($dt));
- $class = '';
- $muted = 0;
- if ($dt < date("Y-m-d"))
- {
- $class = 'class="muted"';
- $muted = 1;
- }
- if ($dt == $tanggal_aktive)
- {
- $class = 'class="btn-primary"';
- }
- ?><td <?php echo $class; ?> ><a <?php echo $muted ? 'lnk' : 'href'; ?>='?tgl=<?php echo $dt; ?>'><?php echo $tgl; ?></a></td><?php
- if ($n % 7 == 6)
- {
- ?></tr><?php
- }
- }
- ?>
- <!--
- <tr>
- <td class="muted">29</td>
- <td class="muted">30</td>
- <td class="muted">31</td>
- <td>1</td>
- <td>2</td>
- <td>3</td>
- <td>4</td>
- </tr>
- <tr>
- <td>5</td>
- <td>6</td>
- <td>7</td>
- <td>8</td>
- <td>9</td>
- <td>10</td>
- <td>11</td>
- </tr>
- <tr>
- <td>12</td>
- <td>13</td>
- <td>14</td>
- <td>15</td>
- <td>16</td>
- <td>17</td>
- <td>18</td>
- </tr>
- <tr>
- <td>19</td>
- <td class="btn-primary"><strong>20</strong></td>
- <td>21</td>
- <td>22</td>
- <td>23</td>
- <td>24</td>
- <td>25</td>
- </tr>
- <tr>
- <td>26</td>
- <td>27</td>
- <td>28</td>
- <td>29</td>
- <td class="muted">1</td>
- <td class="muted">2</td>
- <td class="muted">3</td>
- </tr>
- --->
- </tbody>
- </table>
- </div>
- </div>
- </div>
- </div>
- </div>
- <hr>
- <div class="row">
- <div class="col-md-12">
- <table class="table table-bordered" id="myTable" border="1" style="border-collapse: collapse;" cellpadding="8">
- <thead>
- <tr style="background-color : #74b9ff">
- <th scope="col">Periode</th>
- <?php
- include "koneksi.php";
- /*$query="SELECT jadwal.id_jadwal, jadwal.jam, ruang.id_ruang, ruang.nama_ruang FROM jadwal, ruang WHERE jadwal.id_jadwal=ruang.id_ruang ";
- */
- $query = "SELECT ruang.id_ruang, ruang.nama_ruang FROM ruang ";
- $sql = mysqli_query($db, $query);
- $ruang = array();
- while ($data = mysqli_fetch_array($sql))
- {
- echo "<th scope='col'>" . $data['nama_ruang'] . "</th> ";
- $ruang[] = $data['id_ruang'];
- }
- ?>
- </tr>
- </thead>
- <tbody>
- <?php
- include "koneksi.php";
- /*
- $query="SELECT jadwal.id_jadwal, jadwal.jam, ruang.id_ruang, ruang.nama_ruang FROM jadwal, ruang WHERE jadwal.id_jadwal=ruang.id_ruang ";
- */
- $query = "SELECT jadwal.id_jadwal, jadwal.jam FROM jadwal
- order by id_jadwal asc ";
- $sql = mysqli_query($db, $query);
- while ($data = mysqli_fetch_array($sql))
- {
- echo "<tr>";
- echo "<th style='background-color : #74b9ff'>" . $data['jam'] . " </th>";
- foreach($ruang as $n => $ruang_id)
- {
- $open = status_ruang_jadwal($ruang_id, $data['id_jadwal'], $tanggal_aktive);
- $atr_link = $open ? 'href' : 'lnk';
- $status = $open ? 'Open' : 'Close';
- $class_btn = $open ? 'class="btn btn-primary"' : ' ';
- echo "<td><a {$class_btn} {$atr_link}='isiData.php?jam={$data['id_jadwal']}&ruang={$ruang_id}&tgl={$tanggal_aktive}'> {$status} <a/></td>";
- }
- /*
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- echo "<td><a href='isiData.php'><button>Open</button><a/></td>";
- */
- }
- ?>
- </tbody>
- </table>
- </div>
- </div>
- </div>
- </body>
- </html>
- <?php
- function status_ruang_jadwal($ruang_id, $jadwal_id, $tanggal_aktive)
- {
- include "koneksi.php";
- $query = "SELECT count(*) c FROM pemesanan p
- left join pemesanan_jadwal pd on p.id=pd.pemesanan_id
- where
- p.ruang_id={$ruang_id} and
- pd.jadwal_id={$jadwal_id} and
- p.tanggal='{$tanggal_aktive}' and
- status like 'yes' ";
- $sql = mysqli_query($db, $query);
- $ruang = array();
- $data = mysqli_fetch_array($sql);
- if ($data['c'] == 0) return TRUE;
- return FALSE;
- print_r($data);
- die;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement