Support

Home Forums Seating Chart Add-on (EE3) Seating Chart Displays in Incorrect Row Order

Seating Chart Displays in Incorrect Row Order

Posted: August 13, 2013 at 7:21 pm

Viewing 6 reply threads


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 11 years, 1 month 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.

Viewing 6 reply threads

The support post ‘Seating Chart Displays in Incorrect Row Order’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso