Extention of Locations feature

deflektor · Joined: 19 May 2006 Posts: 2

Hi there,

first of all, you did a great job on Thyme and the software is really worth the prize. Thank You!

I want to use Thyme as a administration and publishing tool for public events and concerts for different locations and different bands, but for this job the functionality of the location's part and its fields look improvable to me.

Before I try on my own, I tell you my requirements:

1) prize field in events db
2) area/city field in events db, ability of filtering in published cal and using a sidebar module (area is not equal to location's city!)
3) extension of locations:
a) separation of city and postcode field - in some countries you can use the postcode-number for searching locations near to you
b) URL field for location (event URL is needed too)
c) Best would be a separate related table "thyme_locations" and an own administration section to be able to re-use the location in other events by choosing from a drop-down. Locations could be over-all or limited to single calendars.

1, 2 and 3a to b should be no prob using some hints from this forum but I think implementing a new table is a harder job to do. Should be considered more as a feature request.

If anybody has hints to do these hacks or has done that before, you're welcome!

Thanks

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi deflektor,

Thanks Smile

Here's what you would do for 3:

* Add location_id to thyme's events table

alter table thyme_Events add column location_id bigint unsigned;

* Create thyme_locations table with a unique ID number as it's primary key.

create table thyme_locations (
id bigint not null unsigned auto_increment primary key,
name varchar(128),
url varchar(128),
state varchar(32),
etc...
);

* Create thyme_location_calendars which will contain location per calendar info:

create table thyme_location_calendars (lid bigint unsigned not null, cid bigint unsigned not null);

* Create an administration module in Thyme that will allow you to enter / edit location information. The admin part of the RSS feeds module would be a good template to use for this.

Each location would also include a calendars tab. This is where you can add calendars to thyme_location_calendars. You can insert or remove a location / calendar pair using the location's id (lid) and the calendar's id (cid). Have the option to include it in all calendars by specifying cid as 0.

* In the event edit form, create your own location tab. Optionally you can just have 1 field in the general section. This would grab all the location ids from thyme_location_calendars where the cid is equal to the current calendar's id or cid is equal to 0. This can be used to grab the location id and name to populate a select box.

The select box would be named location_id. This would automatically populate the location_id field of the events table when the event is saved.

* In the event view template you can pull up the correct location information based on the event's location_id field.

Lots of stuff to tackle here. I know my instructions are not very detailed, so let me know which one you want to get to first and we'll go from there.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Please private message me your e-mail address. I'll send you the locations module that will be included in 2.0. It should integrate with 1.3 with little to no modifications and save you a lot of time.

deflektor · Joined: 19 May 2006 Posts: 2

Thanks a lot for the help, I will try this out, but it will take me some time to do so...

smeallum · Joined: 17 May 2006 Posts: 177

Hi Ian...i read this post, and would like to see how this, and the upcoming locations module in version 2.0 relates to my current requirements, to see if i should start modding from scratch, or from the future version of locations module.

I basically want that each user with add/modify events access(that is taken care already thanks to new access level mod) would get the Add event form in this manner:

1) In the locations tab, i want a combo box that displays only the location/locations that user has been previously been assigned to by an administrator(not the latest from the events table). I think 2 extra tables would be needed for this: A locations data table, and a userid -> location id pairs table.
When he selects one location from the combo box, the address, town, zip, and phone, would be filled for him.
No option for adding a location, nor changing a location name. This would have to be done by the administration through an administrator module. However he should be able to modify

2) Should a user with add & modify access go to modify an event(his own), he could do either of this(appart from changing any other event data) :

a) He could go and change one location from another in his list and then press save. I would need the new selected location to be updated in the events table and of course the "updated" field in that table, with the new modification date(remember the SQL procedure i'll do to check for not updated events? Wink

)

b) He could go only to modify the data(address,town,zip, phone) of the already selected location for that event and then press save. In this case i would need the events table "updated" field to be modified, as well as the location data in the separate locations table.

So what would be the best way of doing this?

Thanks a million for any light,
NiCo

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

I don't know that all of this will be included in 2.0. Some of it is specific to your needs. The best way to get this done is to go off the locations module included in the first post of this forum and modify it to suit your needs. This is very custom and you may end up with a choice come 2.0; start over with the locations mod provided in 2.0 or stay at 1.x.