Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once("../resources/php/connection.php");
- $park = $_POST["park"];
- $lecturestyle_id = $_POST["lecturestyle"];
- $group_size = $_POST["groupsize"];
- $roomstructure_id = $_POST["roomstructure"];
- $array = explode(",", $_POST["facilities"]);
- // change Mon here
- echo '<td class="gridSide">
- Mon
- ';
- // build facilities search
- for($i = 0; $i < count($array); $i++){
- if ($array[$i]!=0) {
- $fac .= ' AND facilities_id='.$array[$i].'';
- }
- else
- $fac .= '';
- }
- echo '</td>';
- for ($i = 1; $i <= 9; $i++)
- {
- // change mon here
- echo '<td class="box" id="mon'.$i.'">';
- // dynamically build sql query
- $sql =
- "
- SELECT DISTINCT COUNT(*) FROM ts_room rm
- LEFT JOIN ts_roomfacilities rf
- ON rm.id = rf.room_id
- LEFT join ts_facilities f
- ON f.id = rf.facilities_id
- LEFT JOIN ts_building b
- ON rm.building_id=b.id
- WHERE capacity>=:group_size";
- $sql .= $fac;
- if($park!="Any") {
- $sql .= " AND b.park_id=:park";
- $searchArray[':park'] = $park;
- }
- if($lecturestyle_id!="Any") {
- $sql .= " AND lecturestyle_id=:lecturestyle_id";
- $searchArray[':lecturestyle_id'] = $lecturestyle_id;
- }
- if($roomstructure_id!="Any") {
- $sql .= " AND roomstructure_id=:roomstructure_id";
- $searchArray[':roomstructure_id'] = $roomstructure_id;
- }
- $sql .= " AND rm.id NOT IN
- (SELECT COUNT(*)
- FROM ts_request rq
- LEFT JOIN ts_allocation a ON a.request_id = rq.id
- WHERE
- day_id=1 AND period_id=:period
- OR a.status IS NOT NULL
- AND a.status IN ('Pending','Declined','Failed'))";
- $stm = $pdo->prepare( $sql );
- $stm->execute( array( $searchArray, ':period' => $i));
- $rows = $stm->fetchColumn();
- echo $rows.'<br>free</td>';
- echo '</td>';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement