hashplan / calendar

Apache License 2.0
0 stars 0 forks source link

admin event and venue location #42

Open hashplan opened 9 years ago

hashplan commented 9 years ago

Roma, I added the following event to the database as admin: 1) image

Coolray Field is in Atlanta area (state is Georgia). It seems like the event city is based on where the venue is (when I go to look at it in event modal after doing the search), even though I picked New York Metro from dropdown as you can see in screenshot. This is actually really good. That way we avoid having venues show up in incorrect metroarea.

The problem is that if I am trying to add an event that is going to take place at a venue that we do not have in the database (it does not show up in the dropdown), since what we have in the database is only what we get from stubhub. How can I create an event at a venue that is not stored in database from stubhub? Could we do an autocomplete form instead of dropdown for the venue?

2) When I go to find the event I just created in the search, the google maps api in event modal returns the location as "Greater Wilmington Business" which is some residential real estate firm in North Carolina (the state) and not the proper location for Coolray field in Atlanta metroarea in the state of Georgia.

In database, in venues table, Coolray field is id 17293, in city Lawrenceville with cityid 14 and state 11. In cities table, cityid 14 maps to Lawrenceville which has state id 11 and metroid 1. In states table, stateid 11 is Georgia. In metroareas table, id 1 is Atlanta with state id 11.

image

romasolot commented 9 years ago

Hi Stas,

1) This is the mistake I did in the code during creating the event editing method. The matter is that the "metroarea" selectbox is just a filter for the "venues" selectbox (filtration of venues by metroarea, so that to be easier to find) and this field (selectbox) is by no means directly related to the event. Fixed it

How can I create an event at a venue that is not stored in database from stubhub? Could we do an autocomplete form instead of dropdown for the venue?

I could add a "New Venue" checkbox below Selectboxes become inactive and a form with a full set of fields for creating a venue is added below during activation. Selection of a city will have the same auxiliaryl filters - state and country - you select a country and there appears a list of cities with an option to filter by states.

2) It's weird, it is the Coolray field where it put a dot on https://www.google.com/maps/preview?ll=34.040562,-83.992117&z=15&t=m&hl=en-US&gl=US&mapclient=embed&cid=4265533371757209880 I noticed on stubhub that venue name is a link and there is a page with its description, think we can additionally parse venue and get exact address

3) I also added an autocomplete to the selectbox for venue selection as I had mentioned before in this issue (it is not on the server yet).

hashplan commented 9 years ago

1) We definitely need ability to add a venue that has not been added by stubhub, since there are a lot of events happening that stubhub does not capture.

2) The link you provided above is correct, however in the event modal it is not. If I do a search on google.com for "coolray field lawrenceville" which is in "{venue name} {city}" format, it returns the right result. Why would the event modal return something different? Is google maps api just not reliable?

Seems like something similar is going on if you do a search for "Grand Ole" in events searchbar and then go to modal for any of the results. Google map in the modal places it in San Francisco Opera House in California, although the correct location is in Nashville, Tennessee.

Aren't we passing venue name and city to the api? Not sure why results are so off. This also seems to be the case for yelp api tab in event modal.