neokoenig / roombooking Goto Github PK

I followed the steps on readme and hit the problem when I started program after installing check is all green.Mail says:No matching function [ADDSHORTCODE] found
stack trance is
string
Message
string No matching function [ADDSHORTCODE]
found
StackTrace
string No matching function [ADDSHORTCODE]
found
at
lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:768):768
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:742):742
at
lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1590):1590
at
events.onapplicationstart_cfm$cf.call(/root/lucee/webapps/ROOT/events/onapplicationstart.cfm:39):39
at
lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951
at
lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:855):855
at
wheels.global.cfml_cfm$cf.udfCall1(/root/lucee/webapps/ROOT/wheels/global/cfml.cfm:111):111
at
wheels.global.cfml_cfm$cf.udfCall(/root/lucee/webapps/ROOT/wheels/global/cfml.cfm):-1
at
lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at
lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at
lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at
lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:773):773
at
lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1600):1600
at
wheels.events.onapplicationstart_cfm$cf.udfCall(/root/lucee/webapps/ROOT/wheels/events/onapplicationstart.cfm:395):395
at
lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at
lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at
lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at
lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at
lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at
lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at
lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:405):405
at
lucee.runtime.listener.ModernAppListener.onApplicationStart(ModernAppListener.java:283):283
at
lucee.runtime.PageContextImpl.initApplicationContext(PageContextImpl.java:2842):2842
at
lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:118):118
at
lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:35):35
at
lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2262):2262
at
lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2225):2225
at
lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
at
lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:725):725
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219):219
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501):501
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610):610
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537):537
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085):1085
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658):658
at
org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222):222
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556):1556
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513):1513
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
at
java.lang.Thread.run(Thread.java:745):745

TagContext Array

please help!! :)

Remove all hard coding for role names, leaving current roles as default, but then user editable

Hi Tom,
How do I turn off the application debug info in the footer. It displays the following info:

Application:
Framework: CFWheels 1.4.1
Active Environment: Design
Host Name:
CFML Engine: Adobe ColdFusion
Default Data Source:
Database Adapter:
URL Rewriting: off
URL Obfuscation: Off
Plugins: shortcodes
flashwrapper
Route: Home
Controller: Bookings
Action: Index
Key(s):
Parameters: None

Annoying issue with CF8 not returning boolean values with the checkPermissions function: this means it's currently unusable on CF8 unless I can find a solution to that.

First of all, thank you for your work!
When you press the edit event, the lost time of the event.
Also, there is no check on the availability of resources.
Thank you!

Add createdby in bookings so we can restrict editing/deletion of events to specific users

Ability to set room layouts to specific rooms or limit what layouts are allowed for any specific room.

Example:
Room 101 - can only be a lab
Redwood - can me Boardroom or Lecture
Conference Room C - can be all

I think if you add some functionality, it will appeal to many users, and make your system more flexible. If you are interested:

1. added to the amount of resources. For example, you have 3 identical notebook. Now you need to add in their 3 times. It is impractical.
2. As I write this, it would be good to ban reservation if events overlap.Now simply displays a pop-up message
3. Setting the SMTP server (for example, Google) through the admin panel. Actually I have not found where you can affect the email, only the address for the notifications and a copy by email.
4. Create a printable version with a full description of the event (It may be by email)
5. Create an event on behalf of any user of the system (only available to the administrator)

Many thanks.
PS. If you need help with translation into Russian, I can help

Subscribing to the calendar system works without a glitch using outlook 2007 and the meetings are displayed correctly but when I do a send/receive I get a bunch of errors:

Task 'Internet Calendar Subscription' reported error (0x00040015): 'The VEVENT, "Meeting Name", defined near line 7, contains a property that references an undeclared time zone with a TZID of "Eastern Time". The property is being treated as a floating time zone. Double-click to open this item.'

Task 'Internet Calendar Subscription' reported error (0x00040023): 'The VEVENT, "Meeting Name", defined near line 7, contains a floating DTSTART. Outlook supports floating time got all-day events only. Double-click to open this item.'

Task 'Internet Calendar Subscription' reported error (0x00040020): 'The VEVENT, "Meeting Name", defined near line 7, contains a floating DTEND. Outlook supports floating time got all-day events only. Double-click to open this item.'

The most annoying thing about this outlook error is that it shows up in the down-right corner as a send/receive error making you think that there is something wrong with the email system.

Cheers,
Cristian.

Would be nice to really sort timezones, as at the moment everything is just in UTC.

onApplicationStart stuff causing infinite redirect.
Temp fix, uncomment all onapplicationstart when installing, run the DBMigrate script, then recomment in, and reload application.

ColdFusion 10 , MYSQL , Installation was successful

Always getting this warning : Warnings: The FlashWrapper plugin may be incompatible with this version of Wheels, please look for a compatible version of the plugin

and Constant Alert Error : There was an Error while fetching events .

Hi,
when i add email address while booking it returns following error.

"Error!

Sorry, that caused an unexpected error.
Please try again later. "

And can i add multiple attendees in meeting and share calendar event to them?
Please reply me.

Thanks in advance.

I am getting "The FlashWrapper plugin may be incompatible with this version of Wheels, please look for a compatible version of the plugin" error on every page. I tried https://github.com/gregstallings/cfwheels-flash-wrapper but get a 404 error. Looking at cfweels there is a 1.3.x for flashMessages.

When i install roombooking then got error

Failed
A simple query failed: please check roombooking exists and that you've run roombooking.sql against it.

i have already restore database

Oops.
http://roombooking.oxalto.co.uk/index.cfm?filterActive=1&controller=Bookings&action=list&datefrom=01%2F07%2F2015&dateto=08%2F08%2F2015&q=&status=

Uses american style dates.

on events/add, check for a startdate

Error:
can't cast [] to date value

Location:
Line 16 in models/Event.cfc
Line 37 in controllers/Bookings.cfc

key [currentUser] doesn't exist (existing keys:cfid,timecreated,sessionid,urltoken,lastvisit,cftoken)

If creating an event with repeat 'x' times, future events are always creating pending, irrespective of admin auto approve privs.

Might be nifty to be able to tag users in events bookings, so they get approval notifications.

Add 'easy to print' pdf style downloads for a month/week in agenda style.

The current day view is pretty buggy, and not well coded on the backend (it's sllooooow). Will be removing the link from the navigation in 1.2, so it will be there, but should be considered deprecated in it's present form.

Railo 4.2.1.008 Error (expression)
Message invalid component definition, can't find component [roombooking.plugins.flashwrapper.flashwrapper]
Stacktrace The Error Occurred in
/opt/railo/tomcat/webapps/roombooking/wheels/Plugins.cfc: line 125
123: <cfset loc.wheelsVersion = SpanExcluding(variables.$class.wheelsVersion, " ")>
124:
125: <cfset loc.plugin = createobject("component", $componentPathToPlugin(loc.iPlugins)).init()>
126: <cfif not StructKeyExists(loc.plugin, "version") OR ListFind(loc.plugin.version, loc.wheelsVersion) OR variables.$class.loadIncompatiblePlugins>
127: <cfset variables.$class.plugins[loc.iPlugins] = loc.plugin>

called from /opt/railo/tomcat/webapps/roombooking/wheels/Plugins.cfc: line 30
called from /opt/railo/tomcat/webapps/roombooking/root.cfm: line 1
called from /opt/railo/tomcat/webapps/roombooking/wheels/global/internal.cfm: line 561
called from /opt/railo/tomcat/webapps/roombooking/wheels/global/internal.cfm: line 968
called from /opt/railo/tomcat/webapps/roombooking/wheels/events/onapplicationstart.cfm: line 376

i.e http://roombooking.oxalto.co.uk/bookings/add/?d=2013-09-29, whilst populates the wheels model, gets overwritten by the datepicker to now() when clicked

There are a few, will be patching soon. Hold fire if you're on CF10.

bug: the editing locations form requires Additional CSS class to be populated.
bug: the colour specified for a location is actually the colour specified for the "additional CSS class". This is not clear. It means that the CSS class name specifies the colour based on one of the locations that uses that class. So you can set different locations with different colours but the same class and only one colour is used. It isn't clear which location definition is being used to define the class colour.

Hi,

I have created an event which is approved but it is not showing up on the calendar.
If I use the list view, the following message is returned:
Sorry!, No events returned for that date range.

However I know there are approved events. I have checked the logs (from Settings menu) and it says the event was successfully created. I check the database, and the event has status of 'approved'.

Could you please provide some guidance. Thanks.

I think that this enhancement would be appreciated.
Create multiple sites.
One site can have multiple locations.
Each site can have propers administrators, users, guest, etc.

Thanks

domelan

Add ability to add custom fields to any model.
i.e, so you can store additional information alongside any event/location/etc.
In progress for 1.2

Is it possible to choose multiple rooms/locations per booking? And event an option to choose all locations?

Hello. Would like to use your service for booking equipment, but lacks the option "Advanced". For example, when you order a piece of equipment, it still need to add accessories. It may be possible to extend the use of your service by adding the option "more", where you can choose something else?

This would be a big change, but considering the requests for single bookings which span multiple locations, and improved repeating events, we could make it so that events can reference a master 'parent event'.

This means hypothetically you could have 'ghost events' in the events table which reference their parent event: so a child or ghost event could either be a instance of the event repeating, or an instance of the event in a secondary location. This means they could still be attached to the parent event, and updating the details could, then, be done on the master event once, rather than having 10+ or so separate events.

Would also have the advantage that you could list the child events/ related events in any of the instances: i.e, 'Related events' or something.

For our use of this program we would like the users to create booking for meeting rooms themselves. It should be possible for users to alter and/or delete their own created bookings but not of the ones created by other users.
I know this requires some changes to the database as mentioned in an email by you on my question:
"At the moment there's no database field to record who the event was booked by (as in a user-id or something) so that would need to be added."

Hi,

I would love to see a feature for searching for room.
Would be good also to put rooms in the buliding/floor structure.

Searching for room should be possible by attributes:

• multimedia (e.g. projector=yes)
• capacity (e.g. 4 persons)
• avaliablity (e.g. from: 8:00 to: 9:00 for tomorrow)

It is essential when dooing bookings.

booking rooms for nights a-la b&b/hotel/motel etc. ie. the booking is from midday to midday, rather than midnight to midnight.

I just realized rooms can be over-booked. Is there a setting to change this? Resources can not be over-booked if Unique is checked but rooms can.

I am getting:
Error!
Sorry, that caused an unexpected error.
Please try again later.

When clicking Day in the Events drop down.
Links to [domain]/index.cfm/bookings/day

Reported bug I need to check.

Add a new permission for moderating events, so that they can be created by role 'x' and approved by role 'y'.
Build a view for outstanding moderation requests & email notifications etc

Include the ability to search for an Event. A whole new search functionality/page could be created, but looking at the Listing w/ Filter (/index.cfm/bookings/list) the Filter could be expanded to include a textbox that would search the list and filter the results.

With this, changing/adding the functionality to include multiple months or just all months.

Would be nice to translate the whole thing. Not a small amount of work though. Shall see if I can at least get it in place for 1.3

Hi,

I am trying to get your application working with MS SQL Server but am running into a few minor issues.

I have converted the mysql query script for new installation to t-sql (ms sql server 2008), but am running into the following issues because they are reserve words:

• 'user' column in the permissions table.
• 'end' column in the events table

My question are:

• if I change the column 'user' to say, 'userRole' in the sql script, where else in the code do I need to change?
• If change the column 'end' to 'endDate' in the sql script, what do I need to update in the code. I have try a find and replace, but it seems like I am still missing something as I am still getting the error: there was an error fetching the events! when i click on the main page.

When I click on Settings > Users, I get the following error:
Column 'users.email' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
Location:
Line 83 in controllers\Users.cfc

What do I need to update to resolve?

Appreciate your help.
Yieng