|
Therese Miller
|
August 13, 2013 at 7:21 pm
Hi,
I have imported a seating chart created using the .csv template supplied. It has Row Numbers A to S (seat numbers vary accross rows) all listed sequentially from A to S. When the chart is displayed (front end) Row order is as follows: A, J, H, G, F, E, D, C, B, K. Is there any reason for this? In the ‘Manage Seating Chart – Seats’ section of the admin system the seats are listed in order, however ‘view chart’ also shows the wrong order. Additionally, ‘Section Alignment’ will not save the Sort Order as ‘Right to Left’.
|
|
Dean
|
August 13, 2013 at 11:12 pm
Hi Therese,
Is it possible to get a copy of the csv file? It’s easier to find the problem if we can see the structure of the plan.
|
|
Therese Miller
|
August 14, 2013 at 4:37 pm
Hi Dean,
Thanks for your reply. The file is located here:
http://www.tickets.paperbarks.com.au/wp-content/uploads/espresso/albany-town-hall-theatre.csv. You can view the seating plan here: http://www.tickets.paperbarks.com.au/?page_id=6&ee=2 – Section 2 is the problematic one, all other sections seem fine.
Cheers,
Therese
|
|
Dean
|
August 15, 2013 at 12:55 am
Hi,
Thanks for that, it allowed me to do some testing. I concur that the problem exists and I think what is happening is a bug. It seems that when using letters for rows, after the tenth row is added, it messes up the formatting (not sure how or why).
If numbers are used there is no issue.
I thought it might be because the letter “i” is missing in you list but that seems irrelevant.
I have raised a developer ticket on this to look into it.
-
This reply was modified 10 years, 8 months ago by
 Dean. Reason: spelling edit
|
|
Therese Miller
|
August 15, 2013 at 3:51 pm
Hi Dean,
Thanks for that. I thought it was weird Row I is missing too, but that’s how it is on their plan (?).
Cheers,
Therese
|
|
Sidney Harrell
|
August 15, 2013 at 9:18 pm
To fix, you’ll have to change line 582 of plugins/espresso-seating/lib/class/seating_chart.class.php from:
if ( false === ($rows = get_transient($transient))) {
to:
if ( true ) {
temporarily, in order to reset the saved row list. Then change line 590 (same file) from:
$rs = $wpdb->get_results("select distinct row from " . EVENTS_SEATING_CHART_SEAT_TABLE . " where seating_chart_id = {$seating_chart_id} and level = '{$level->level}' and section = '{$section->section}' order by row+0 ");
to:
$rs = $wpdb->get_results("select distinct row from " . EVENTS_SEATING_CHART_SEAT_TABLE . " where seating_chart_id = {$seating_chart_id} and level = '{$level->level}' and section = '{$section->section}' order by row");
After you have loaded the corrected seating chart view, you can change line 582 back.
|
|
Therese Miller
|
August 25, 2013 at 6:30 pm
Hi Sidney,
Sorry for the late reply, just got back to this…
Thanks for that, the row order is now as it should be. However, ‘Section Alignment’ still doesn’t work: when I change either ‘Alignment’ or ‘Sort Order’ to right and click ‘Save’ it just reverts back to left and no changes are reflected in the seating plan.
|
