phpScheduleIt
June 20, 2013, 06:04:19 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: phpScheduleIt 2.4.2 has been released!
 
   Home   Help Login Register  
phpScheduleIt > Help and Support > New Features and Suggestions > Reservation quota repris
Pages: [1]
« previous next »
  Print  
Author Topic: Reservation quota repris  (Read 1872 times)
chaplib
Newbie
*

Karma: 0
Posts: 22
« on: July 17, 2008, 06:11:23 PM »
I know that quotas will be coming soon. My circulation staff would like to limit future reservations to one per user. Lookin at the schema, it seems that it should be doable by:
1. Look at reservation_users for memberid
2. If memberid is found take the resid and query reservations; else allow reservation
3. If reservations::start_date > today then deny reservation; else allow reservation

Would this work, or am I off base?  Huh

Dan H
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5506


WWW
« Reply #1 on: July 17, 2008, 09:52:57 PM »
Should work perfectly.
Logged
RobbieThompson73
Newbie
*

Karma: 0
Posts: 18
« Reply #2 on: September 17, 2008, 11:00:21 AM »
hi chaplib,
I am looking to make a similar change to my installation. Did you have any success? If so could you possibly post your solution?

Thanks

Robbie
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!