phpScheduleIt
May 23, 2013, 03:58:51 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  
Pages: [1]
  Print  
Author Topic: Addtion of search criteria.  (Read 955 times)
vipinmaster
Newbie
*

Karma: 0
Posts: 10


« on: March 02, 2011, 10:39:25 PM »

HI Team,

I have created a meeting room booking tool using this software .

On the booking Tab i am getting shedule dropdown according to which i am able to see the other meeting room names .

Now i want that when i select a schedule .i want another start and end time dropdown so that i am able to search only those meeting rooms that are vacant at that point of time.

Basically i want to have two more start and end time dropdowns at the schedule.php page.

Please help me out in this regard.

Vipin
09899703295
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #1 on: March 07, 2011, 01:40:06 PM »

Adding the drop downs should be as simple as copying most of the print_time_info() function from templates\reserve.template.php.

From there, the more tricky part will be using those values to search the database.  Right now most of that functionality is consolidated in lib\db\scheduledb.class.php
Logged
vipinmaster
Newbie
*

Karma: 0
Posts: 10


« Reply #2 on: March 18, 2011, 04:28:37 AM »

HI Nick,

I have added the print_time_info() but then also get_start_date and get_end_date functions are missing.

I am unable to add .

Please guide.
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #3 on: March 21, 2011, 01:40:25 PM »

Hmm, maybe a better suggestion would be to copy lines 112-131 out of templates/admin.template.php
Logged
vipinmaster
Newbie
*

Karma: 0
Posts: 10


« Reply #4 on: March 22, 2011, 12:14:10 AM »

HI ,

Thanks it works now. Smiley

Vipin
Logged
vipinmaster
Newbie
*

Karma: 0
Posts: 10


« Reply #5 on: March 22, 2011, 12:24:33 AM »

HI ,

Now i am stuck with another thing.

This is the first task that i have to add a new dropdown of time .

Second is to integrate that with the schedule dropdown .

So that if some one selects 9 am in the morning and one of the schedule value then it should display those schedules only that vacant at that time slot.

Thanks

Vipin
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #6 on: March 28, 2011, 02:02:26 PM »

You should be able to copy/extend much of what lib/db/resdb.class.php check_res() function.  You'd want to change this a bit to go select all resources which doesn't have a conflict that that time.
Logged
vipinmaster
Newbie
*

Karma: 0
Posts: 10


« Reply #7 on: March 29, 2011, 12:45:19 AM »

HI ,

Thanks Nick .

Can you Please explain the search reservation tab in the tool . As it might help me in doing query.

What xactly is the minimum and the maximum time and date.

Please explain .

Thanks

vipin
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #8 on: April 04, 2011, 01:49:46 PM »

This is the minimum amount of time needed before a reservation can be made.  For example, a reservation must be made at least 1 hour prior to it's desired start time.

The max is the opposite.  This is the furthest out that a reservation can be made.  For example, no more than 4 hours from now.
Logged
Pages: [1]
  Print  
 
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!