Changeset:
        82397e6891f3
        
https://sourceforge.net/p/mrbs/hg-code/ci/82397e6891f346e70873f64f09fb678525da8d8f
Author:
        Campbell Morrison <[email protected]>
Date:
        Mon Mar 13 15:44:20 2017 +0000
Log message:

Fixed a bug with the display of entries starting at 0000 in the month view.
See SF Support Requests #1186.

diffstat:

 web/mrbs_sql.inc |  4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diffs (21 lines):

diff -r 6bfad1d8c4d2 -r 82397e6891f3 web/mrbs_sql.inc
--- a/web/mrbs_sql.inc  Sat Mar 11 18:37:03 2017 +0000
+++ b/web/mrbs_sql.inc  Mon Mar 13 15:44:20 2017 +0000
@@ -469,7 +469,7 @@
            WHERE E.room_id = R.id
              AND R.area_id = ?
              AND R.disabled = 0
-             AND start_time <= ? AND end_time > ?
+             AND start_time < ? AND end_time > ?
         ORDER BY start_time";   // necessary so that multiple bookings appear 
in the right order
 
   $res = db()->query($sql, array($area_id, $interval_end, $interval_start));
@@ -490,7 +490,7 @@
   $sql = "SELECT *
             FROM $tbl_entry
            WHERE room_id = ?
-             AND start_time <= ? AND end_time > ?
+             AND start_time < ? AND end_time > ?
         ORDER BY start_time";   // necessary so that multiple bookings appear 
in the right order
         
   $res = db()->query($sql, array($room_id, $interval_end,  $interval_start));

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits

Reply via email to