Changeset 98

Timestamp:

10/24/06 22:21:07 (2 years ago)

Author:

moensch

Message:

add some files

Files:

• branches/com_mls_seatmap/eventTimes/images (deleted)
• branches/com_mls_seatmap/eventTimes/lang (deleted)
• branches/com_mls_seatmap/eventTimes/mls_seatmap.class.php (modified) (2 diffs)
• branches/com_mls_seatmap/eventTimes/mls_seatmap.html.php (modified) (5 diffs)
• branches/com_mls_seatmap/eventTimes/mls_seatmap.php (modified) (13 diffs)
• branches/com_mls_seatmap/eventTimes/mls_seatmap.xml (modified) (1 diff)

branches/com_mls_seatmap/eventTimes/mls_seatmap.class.php

@@ -193 +193 @@
-        }
-        
+        function getStatusTime($seatid = 0) {
+                global $database, $mosConfig_offset, $my;
+                if($this) {
+                        $seatid = @$this->id ? $this->id : $seatid;
+                }
+                $database->setQuery( "SELECT * FROM `#__mls_seatmap_room_elements_users` WHERE `seatid`='".$seatid."'" );
+                $rows = $database->loadObjectList();
+                foreach($rows as $row) {
+                        if($row->userid == $my->id && $row->status == 1) {
+                                //I am on this seat
+                                $return = 1;
+                                break;
+                        } elseif($row->userid != $my->id && $row->status == 1) {
+                                echo "hihi";
+                        }
+                }
+        }
+        
+        /**
+         * This function simply checks, whether I can occupy a seat or not
+         * I can occupy a seat, if I havent already occupied it or somebody occupied it for the whole event
+         */
+        function canioccupy($seatid = 0) {
+                global $database, $mosConfig_offset, $my;
+                if($this) {
+                        $seatid = @$this->id ? $this->id : $seatid;
+                }
+                $database->setQuery( "SELECT `id`"
+                                                ."\n FROM `#__mls_seatmap_room_elements_users`"
+                                                ."\n WHERE"
+                                                ."\n `seatid`='".$seatid."'"
+                                                ."\n AND ((`userid`='".$my->id."' AND `status`='1')"
+                                                ."\n OR (`whole_event`='1' AND `status`='1'))" );
+                $database->query();
+                
+                if($database->getnumrows()) {
+                        return 0;
+                } else {
+                        return 1;
+                }
+        }
+        
+        /**
+         * This function simply checks, whether I can release a seat or not
+         * I can release a seat, when I occupy it or if it has been reserved for me
+         */
+        function canirelease($seatid = 0) {
+                global $database, $mosConfig_offset, $my;
+                if($this) {
+                        $seatid = @$this->id ? $this->id : $seatid;
+                }
+                $now = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
+                $database->setQuery( "SELECT `id`"
+                                                ."\n FROM `#__mls_seatmap_room_elements_users`"
+                                                ."\n WHERE"
+                                                ."\n `seatid`='".$seatid."'"
+                                                ."\n AND ((`userid`='".$my->id."' AND `status`='1')"
+                                                ."\n OR (`res_userid`='".$my->id."' AND `status`='2'))" );
+                $database->query();
+                
+                if($database->getnumrows()) {
+                        return 1;
+                } else {
+                        return 0;
+                }
+        }
+        
+        
-        function getStatus($seatid = 0) {
-                global $database, $mosConfig_offset, $my;
-
+
+
+
-                $database->setQuery( "SELECT * FROM `#__mls_seatmap_room_elements` WHERE `id`='".$seatid."'" );
-                $seat = $database->loadObjectList();
@@ -224 +294 @@
-                return $return;
-        }
+        
+        function getOccupiedTimes() {
+                global $database;
+                $database->setQuery( "SELECT people.*, time.name AS `timename`, u.name, u.username, u.email,"
+                                                ."\n IF(people.whole_event = 1,event.start,time.start) AS `start`,"
+                                                ."\n IF(people.whole_event = 1,event.end,time.end) AS `end`"
+                                                ."\n FROM `#__mls_seatmap_room_elements_users` AS `people`"
+                                                ."\n INNER JOIN `#__users` AS `u` ON u.id=people.userid"
+                                                ."\n INNER JOIN `#__mls_seatmap_room_elements` AS `seat` ON seat.id=people.seatid"
+                                                ."\n INNER JOIN `#__mls_seatmap_rooms` AS `room` ON room.id=seat.roomid"
+                                                ."\n INNER JOIN `#__mls_events` AS `event` ON event.id=room.eventid"
+                                                ."\n LEFT JOIN `#__mls_events_times` AS `time` ON time.id=people.timeid"
+                                                ."\n WHERE people.seatid='".$this->id."' AND people.status='1'" );
+                
+                $rows = $database->loadObjectList();
+                
+                return $rows;
+        }
+        
+        function getReservedTimes() {
+                global $database, $mosConfig_offset;
+                $now = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
+                $database->setQuery( "SELECT people.*, time.name AS `timename`, u.name, u.username, u.email,people.res_userid,"
+                                                ."\n IF(people.whole_event = 1,event.start,time.start) AS `start`,"
+                                                ."\n IF(people.whole_event = 1,event.end,time.end) AS `end`"
+                                                ."\n FROM `#__mls_seatmap_room_elements_users` AS `people`"
+                                                ."\n INNER JOIN `#__users` AS `u` ON u.id=people.userid"
+                                                ."\n INNER JOIN `#__mls_seatmap_room_elements` AS `seat` ON seat.id=people.seatid"
+                                                ."\n INNER JOIN `#__mls_seatmap_rooms` AS `room` ON room.id=seat.roomid"
+                                                ."\n INNER JOIN `#__mls_events` AS `event` ON event.id=room.eventid"
+                                                ."\n LEFT JOIN `#__mls_events_times` AS `time` ON time.id=people.timeid"
+                                                ."\n WHERE people.seatid='".$this->id."' AND people.status='2' AND people.res_end_time > '".$now."'" );
+                
+                $rows = $database->loadObjectList();
+                
+                return $rows;
+        }
+        
+        /**
+         * Checks, at which times a seat is free and return them in an array of objects
+         * if the second argument $userid is given, reserved times for the given userid will be treated as 'free' times
+         */
+        function getFreeTimes($occupied = 0, $userid = 0) {
+                global $database, $mosConfig_offset;
+                //if we do not already know which times are occupied, fetch them now
+                if(!$occupied) {
+                        $occupied = $this->getOccupiedTimes();
+                        $reserved = $this->getReservedTimes();
+                        foreach($reserved as $res) {
+                                if($userid && $res->res_userid != $userid) {
+                                        array_push($occupied, $res);
+                                }
+                        }
+                }
+                
+                //now, get the times available
+                $database->setQuery( "SELECT time.id,time.name,"
+                                                ."\n IF(time.id IS NULL,event.start,time.start) AS `start`,"
+                                                ."\n IF(time.id IS NULL,event.end,time.end) AS `end`"
+                                                ."\n FROM `#__mls_seatmap_room_elements` AS `seat`"
+                                                ."\n INNER JOIN `#__mls_seatmap_rooms` AS `room` ON room.id=seat.roomid"
+                                                ."\n INNER JOIN `#__mls_events` AS `event` ON event.id=room.eventid"
+                                                ."\n LEFT JOIN `#__mls_events_times` AS `time` ON time.eventid=room.eventid"
+                                                ."\n WHERE seat.id='".$this->id."'" );
+                
+                $rows = $database->loadObjectList();
+                $freetimes = array();
+                
+                //and here comes the buggy stuff. Match them agains each other
+                foreach($rows as $row) {
+                        $free = 1;
+                        foreach($occupied as $occ) {
+                                if(($occ->start < $row->start) && ($occ->end > $row->start && $occ->end < $row->end)) {
+                                        //starts before, ends in the middle
+                                        $free = 0;
+                                } elseif(($occ->start > $row->start && $occ->start < $row->end) && ($occ->end > $row->end)) {
+                                        //starts in the middle, ends after
+                                        $free = 0;
+                                } elseif(($occ->start > $row->start && $occ->start < $row->end) && ($occ->end > $row->start && $occ->end < $row->end)) {
+                                        //starts in the middle, ends in the middle
+                                        $free = 0;
+                                } elseif($occ->start < $row->start && $occ->end > $row->end) {
+                                        //starts before, ends after
+                                        $free = 0;
+                                } elseif($occ->start == $row->start && ($occ->end > $row->start && $occ->end < $row->end)) {
+                                        //starts same time, ends in the middle
+                                        $free = 0;
+                                } elseif(($occ->start > $row->start && $occ->start < $row->end) && $occ->end == $row->end) {
+                                        //starts in the middle, ends same time
+                                        $free = 0;
+                                } elseif($occ->start < $row->start && $occ->end == $row->end) {
+                                        //starts before, ends same time
+                                        $free = 0;
+                                } elseif($occ->start == $row->start && $occ->end > $row->end) {
+                                        //starts same time, ends after
+                                        $free = 0;
+                                } elseif($occ->start == $row->start && $occ->end == $row->end) {
+                                        //starts same time, ends same time
+                                        $free = 0;
+                                }
+                        }
+                        if($free) {
+                                $freetimes[] = $row;
+                        }
+                }
+                
+                return $freetimes;
+        }
-};
-
+/**
+* MLS Seatmap Seat-User table class
+*/
+class mosMLS_seatmap_seat_user extends mosDBTable {
+        /** @var int Primary key */
+        var $id=null;
+        /** @var int */
+        var $seatid=null;
+        /** @var int */
+        var $userid=null;
+        /** @var int */
+        var $res_userid=null;
+        /** @var int */
+        var $status=null;
+        /** @var date */
+        var $res_start_time=null;
+        /** @var date */
+        var $res_end_time=null;
+        /** @var int */
+        var $timeid=null;
+        
+        /**
+        * @param database A database connector object
+        */
+        function mosMLS_seatmap_seat_user( &$db ) {
+                $this->mosDBTable( '#__mls_seatmap_room_elements_users', 'id', $db );
+        }
+};
-?>

branches/com_mls_seatmap/eventTimes/mls_seatmap.html.php

@@ -220 +220 @@
-        }
-        
-
-
+users, $
+, $mosConfig_offset
-                $l->setBlock("rooms");
-                switch($seat->status) {
-                        case "0":
-                                $status = $l->m("status_free");
-                                break;
-                        case "1":
-                                $status = $l->m("status_occupied");
-                                break;
-                        case "2":
-                                $status = $l->m("status_reserved");
-                                break;
-                }
-                
-                ?>
-                <div align="center">
@@ -247 +235 @@
-                <table border="0" cellspacing="1" cellpadding="3" width="100%">
-                        <tr>
-                                <td class="sectiontableheader" align="right" width="150"><?=$l->m("status");?>:</td>
-                                <td class="sectiontableentry2"><?=$status;?></td>
-                        </tr>
-                        <tr>
-                                <td class="sectiontableheader" align="right" width="150"><?=$l->m("name");?>:</td>
-                                <td class="sectiontableentry2"><?=$seat->name;?></td>
@@ -258 +242 @@
-                                <td class="sectiontableentry2"><?=$seat->ip;?></td>
-                        </tr>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-                        //print administrative links
-check == 0
+seat->can_occupy
-                                //seat is free
-                                //I can occupy or reserve
@@ -306 +306 @@
-                        }
-                        
-check == 1 OR $check == 5
+seat->can_release
-                                //I am on this seat or it is reserved for me
-                                //I can release
@@ -313 +313 @@
-                                        <td></td>
-                                        <td class="td_mark"><a href="?option=<?=$option;?>&amp;Itemid=<?=$Itemid;?>&amp;task=release_seat&amp;seatid=<?=$seat->id;?>"><?= $l->m("release"); ?></a></td>
-                                </tr>
-                                <?php
-                        }
-                        if($check == 5) {
-                                //this seat is reserved for me
-                                //I can occupy
-                                ?>
-                                <tr>
-                                        <td></td>
-                                        <td class="td_mark"><a href="?option=<?=$option;?>&amp;Itemid=<?=$Itemid;?>&amp;task=occupy_seat&amp;seatid=<?=$seat->id;?>"><?= $l->m("occupy"); ?></a></td>
-                                </tr>
-                                <?php

branches/com_mls_seatmap/eventTimes/mls_seatmap.php

@@ -14 +14 @@
-//we need the events class
-require_once( $mainframe->getPath( 'class', 'com_mls_events' ) );
+//get config
+require_once( $mosConfig_absolute_path."/components/com_mls_seatmap/mls_seatmap.config.php" );
-
-$Itemid = mosGetParam($_REQUEST,'Itemid');
@@ -25 +27 @@
-                occupySeat( $seatid, $option, $Itemid );
-                break;
+        case "save_occupy_seat":
+                saveOccupySeat( $seatid, $option, $Itemid );
+                break;
-        case "reserve_seat":
-                reserveSeat( $seatid, $option, $Itemid );
@@ -59 +64 @@
-                mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$room->eventid."&mosmsg=".urlencode($l->m("err_not_paid","general")) );
-        }
-
+
+
+
+
+
+
-        if($check == 2) {
-                mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid."&mosmsg=".urlencode($l->m("err_occupied")) );
@@ -65 +75 @@
-        if($check == 3) {
-                mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid."&mosmsg=".urlencode($l->m("err_reserved")) );
-
-
-
-
-
-
+
-        mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid );
-}
@@ -78 +83 @@
-        $l->setBlock("general");
-        
+        /** get some data (seat, room, event) */
-        $row = new mosMLS_seatmap_seat( $database );
-        $row->load( $id );
@@ -87 +93 @@
-        $event->load($room->eventid);
-        
+        /** check, whether the user has paid or not */
-        if(!mosMLS_events_participant::checkPaid($my->id, $room->eventid)) {
-                mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$room->eventid."&mosmsg=".urlencode($l->m("err_not_paid","general")) );
@@ -99 +106 @@
-        }
-        if($check == 0) {
-/show a select list of users which have paid for this event and which don't occupy another seat
+** show a select list of users which have paid for this event and which don't occupy another seat */
-                $now = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
-                $database->setQuery( "SELECT u.id,u.username"
@@ -123 +130 @@
-
-function saveReserveSeat( $option, $Itemid ) {
-
+, $cnf_mls_sm
-        $l->setBlock("general");
-        $row = new mosMLS_seatmap_seat( $database );
@@ -131 +138 @@
-        }
-        $row->res_start_time = $now = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
-3
+$cnf_mls_sm["reservation_time"]
-        $row->status = 2;
-        $row->userid = $my->id;
@@ -148 +155 @@
-
-function occupySeat( $id, $option, $Itemid) {
+        global $database, $my, $l, $mosConfig_offset, $gid;
+        $l->setBlock("general");
+        
+        /** First, load some data */
+        $database->setQuery( "SELECT s.*,e.access, r.eventid"
+                                        ."\n FROM `#__mls_seatmap_room_elements` AS `s`"
+                                        ."\n INNER JOIN `#__mls_seatmap_elements` AS `e` ON e.id=s.elementid"
+                                        ."\n INNER JOIN `#__mls_seatmap_elements_categories` AS `c` ON c.id=e.categoryid"
+                                        ."\n INNER JOIN `#__mls_seatmap_rooms` AS `r` ON r.id=s.roomid"
+                                        ."\n WHERE s.id='".$id."'");
+        $seat = $database->loadObjectList();
+        $seat = $seat[0];
+        $room = new mosMLS_seatmap_room( $database );
+        $room->load($seat->roomid);
+        
+        /** check, whether the person has paid or not */
+        if(!mosMLS_events_participant::checkPaid($my->id, $room->eventid)) {
+                mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid."&mosmsg=".urlencode($l->m("err_not_paid","general")) );
+        }
+        
+        /** check, whether the person already occupies another seat for this event */
+        $database->setQuery( "SELECT COUNT(*) FROM `#__mls_seatmap_room_elements_users` AS `people`"
+                                        ."\n INNER JOIN `#__mls_seatmap_room_elements` AS `seat` ON seat.id=people.seatid"
+                                        ."\n INNER JOIN `#__mls_seatmap_rooms` AS `room` ON room.id=seat.roomid"
+                                        ."\n WHERE room.eventid='".$room->eventid."' AND people.status='1' AND people.userid='".$my->id."'" );
+        if($database->loadResult()) {
+                mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid."&mosmsg=".urlencode($l->m("err_occupy_seat")) );
+        }
+        
+        /** now get the free times */
+        $myseat = new mosMLS_seatmap_seat( $database );
+        $myseat->load($seat->id);
+        $free = $myseat->getFreeTimes(0,$my->id);
+        
+        /** check, which times the user has paid for */
+        $database->setQuery( "SELECT * FROM `#__mls_events_participants` WHERE `userid`='".$my->id."' AND `eventid`='".$room->eventid."'" );
+        $participant = array();
+        $database->loadObject($participant);
+        if($participant->id && $participant->timeid) {
+                /** the user has paid for a specific time. Lets see if this one is free */
+                foreach($free as $time) {
+                        if($time->id == $participant->timeid) {
+                                $valid_time = $time;
+                        }
+                }
+                if(!$valid_time) {
+                        /** the time, the user has paid for is not free anymore */
+                        mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid."&mosmsg=".urlencode($l->m("err_not_free_for_your_time","general")) );
+                } else {
+                        /** the time the user paid for is free, occupy it (but first delete any existing reservations) */
+                        $database->setQuery( "DELETE FROM `#__mls_seatmap_room_elements_users` WHERE `seatid`='".$seat->id."' AND `res_userid`='".$my->id."' AND `status`='2'" );
+                        $database->query();
+                        $database->setQuery( "INSERT INTO `#__mls_seatmap_room_elements_users` (`id`,`seatid`,`userid`,`status`,`timeid`) VALUES ('','".$seat->id."','".$my->id."','1','".$valid_time->id."')" );
+                        $database->query();
+                        mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid."&mosmsg=".urlencode($l->m("msg_seat_occupied")) );
+                }
+        } elseif($participant->id) {
+                /** There is no defined time, therefore user has paid for the whole event */
+                $database->setQuery( "DELETE FROM `#__mls_seatmap_room_elements_users` WHERE `seatid`='".$seat->id."' AND `res_userid`='".$my->id."' AND `status`='2'" );
+                $database->query();
+                $database->setQuery( "INSERT INTO `#__mls_seatmap_room_elements_users` (`id`,`seatid`,`userid`,`status`,`whole_event`) VALUES ('','".$seat->id."','".$my->id."','1','1')" );
+                $database->query();
+                mosRedirect( "index.php?option=$option&Itemid=$Itemid&eventid=".$seat->eventid."&mosmsg=".urlencode($l->m("msg_seat_occupied")) );
+        }
+        HTML_MLS_seatmap_front::occupyForm($row, $event, $room, $user_select, $option, $Itemid);
+}
+
+function occupySeat2( $id, $option, $Itemid) {
-        global $database, $my, $l, $mosConfig_offset, $gid;
-        $l->setBlock("general");
@@ -220 +295 @@
-                $search_result = $database->loadObjectList();
-                $search_result = $search_result[0];
+        } else {
+                $search_result = 0;
-        }
-        
@@ -339 +416 @@
-
-function showSeatDetails( $seatid, $option, $Itemid ) {
-
+, $cnf_mls_sm, $mosConfig_offset
-        
-        $database->setQuery( "SELECT s.*,"
-
-
-
+
-                                        ."\n r.name AS `roomname`"
-                                        ."\n FROM `#__mls_seatmap_room_elements` AS `s`"
-                                        ."\n LEFT JOIN `#__users` AS `u1` ON u1.id=s.userid"
-                                        ."\n LEFT JOIN `#__users` AS `u2` ON u2.id=s.res_userid"
-                                        ."\n INNER JOIN `#__mls_seatmap_rooms` AS `r` ON r.id=s.roomid"
-                                        ."\n INNER JOIN `#__mls_events` AS `e` ON e.id=r.eventid"
@@ -355 +428 @@
-        $seat = $seat[0];
-        
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-}
-?>

branches/com_mls_seatmap/eventTimes/mls_seatmap.xml

@@ -190 +190 @@
-) TYPE=MyISAM;
-</query>
+                        <query>CREATE TABLE `mos_mls_seatmap_room_elements_users` (
+  `id` int(11) NOT NULL auto_increment,
+  `seatid` int(11) NOT NULL default '0',
+  `userid` int(11) NOT NULL default '0',
+  `res_userid` int(11) NOT NULL default '0',
+  `status` tinyint(1) NOT NULL default '0',
+  `res_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `res_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `timeid` int(11) NOT NULL default '0',
+  `whole_event` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;</query>
-                        <query>INSERT INTO `#__mls_seatmap_elements` (`id`, `categoryid`, `name`, `access`, `is_free`, `is_reserved`, `is_occupied`) VALUES (3, 1, 'Seat Free', 1, 1, 0, 0);</query>
-                        <query>INSERT INTO `#__mls_seatmap_elements` (`id`, `categoryid`, `name`, `access`, `is_free`, `is_reserved`, `is_occupied`) VALUES (4, 1, 'Seat Reserved', 1, 0, 1, 0);</query>