|
Joël van de Pol
|
July 8, 2013 at 6:31 am
1) Editing existing seating plans would be much easier if there was the option to delete all existing seats when uploading a new csv.
2) In the seat list I miss a checkbox to select all seats.
3) There seems to be a problem with the section alignment. When I uploaded new csv-files, the sections were displayed either in reversed order or in random order. The section alignment menu didn’t help. Somehow I managed to solve the problem by random actions, but I couldn’t tell how to reproduce or how to specifically solve the problem.
4) When trying to delete a seating plan, I’m told that the plan is still associated with an event, yet I checked all events without finding one which is connected to the plan.
|
|
Sidney Harrell
|
July 8, 2013 at 1:45 pm
For #2:
Go into espresso-seating/template/seating_chart_seat_list.php and change line 217 to:
<th class="manage-column column-cb check-column" id="cb" scope="col" style="width:25px;"><input type="checkbox" id="selectAll"></th>
Then go to the end of the file and add:
<script language="JavaScript">
jQuery(document).ready(function() {
jQuery('#selectAll').on('change', function() {
var status = this.checked;
jQuery('.seat_ids').each(function() {
this.checked = status;
});
});
});
</script>
|
|
Sidney Harrell
|
July 8, 2013 at 2:07 pm
For #4:
Go into espresso-seating/template/seating_chart_list.php, and find line 71:
<th><?php _e('Description', 'event_espresso'); ?></th>
And add the following directly after it:
<th><?php _e('Events', 'event_espresso'); ?></th>
Then find what should then be line 77 and change it to read:
<?php foreach($seating_charts as $seating_chart) {
$associated_events = $wpdb->get_col($wpdb->prepare("SELECT event_id FROM ".EVENTS_SEATING_CHART_EVENT_TABLE." WHERE seating_chart_id=%d;", $seating_chart->id));?>
Finally, find what should then be line 96 and change it to read:
<td><?php _e(nl2br($seating_chart->description),'event_espresso'); ?></td>
<td><?php echo implode(", ", $associated_events); ?></td>
That should give you a readout under “My Seating Charts” that will tell you what event, or events, are associated with that seating chart.
|
|
Joël van de Pol
|
July 8, 2013 at 2:26 pm
Thanks for your help. For #4: The chart was still associated with a deleted event. I had to delete it manually in the database.
|
|
Sidney Harrell
|
July 8, 2013 at 4:35 pm
I just tested it, and you’re right. The event is still in the DB, but status “D”, and is still in the relation table between event and chart. I’ll work on getting it to delete the relation table entry when the event status goes to deleted. All these changes have been added to the development branch of the seating chart add-on, so they will be there the next time you update it. Thanks.
|
|
Joël van de Pol
|
July 9, 2013 at 6:18 am
Great, thanks.
|
|
Joël van de Pol
|
July 9, 2013 at 6:20 am
For #3: I’m encountering the same problem again.
Here everything is fine: http://rue-oktoberfest.de/reservierung/?ee=6
But here the sections below are ordered VUXW instead of UVWX: http://rue-oktoberfest.de/reservierung/?ee=12
The only difference in both seating plans are the prices. I don’t know how to fix it, please help me!
|
|
Sidney Harrell
|
July 10, 2013 at 2:31 pm
I’ve done some testing, and as far as I can tell, the section order is determined by the order in the csv file when it is imported. Can you email a copy of your seating chart csv file to support@eventespresso.com?
|
|
Joël van de Pol
|
July 10, 2013 at 3:46 pm
The files have been sent to you. However, the behavior seems to be irrational. Sometimes after importing it works, sometimes it doesn’t.
I also checked the order of the database tables wp_events_seating_chart_level_section_alignment and wp_events_seating_chart_seat which appeared to be right. I also ran the ALTER TABLE … ORDER BY … command, which didn’t help.
Last thing I tried was to change lin 558 of seating_chart.class.php to:
$rs = $wpdb->get_results(“select distinct section from “.EVENTS_SEATING_CHART_SEAT_TABLE.” where seating_chart_id = $seating_chart_id and level = ‘$level->level’ order by ‘level’, ‘section'”);
This also didn’t help.
|
|
Josh
|
October 23, 2013 at 2:56 pm
Sidney has done some additional work based on the suggestions in this thread and we’ve included the work in the latest update (version 1.2-alpha).
|
