Output triple sorted

  • Sofian777

    (@sofian777)


    11 years, 1 month ago

    Hello, I am on the search for a solution to a tricky task (at least for me) and your elaborated plugin might make it possible.

    I have a form that offers to submit an event description with country, city and starting hour, and I need then to output a list sorted by countries (alphabetical order), in which is sorted by city, in which the event descriptions are then listed sorted by their starting time. We expect many submissions because it is a free service for a special international day, so any automation will save a lot of manual work.

    Could your plugin output such a sorted list?

    Thanks in advance
    Sofian

    https://ww.wp.xz.cn/plugins/contact-form-7-to-database-extension/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Sofian777

    (@sofian777)

    11 years, 1 month ago

    To make it clearer, since the mere listing can simply be done with orderby, I would like to output a list like this:

    <h2>Great Britain</h2>
    <h3>London</h3>
    08:00 Event Description…
    10:00 Another event …

    <h2>Spain</h2>
    …

    So actually it is about a very customized output including HTML structure and for sure some loops.

    It might be possible with an own custom shortcode. If it is possible but difficult, are you also accepting paid jobs like this?

    Thread Starter Sofian777

    (@sofian777)

    11 years, 1 month ago

    The tricky thing is that the country and city should always be displayed just once, and only inside of a city the full DB entries of an event are displayed. I don’t know if IF would even be enough here to somehow check IF it is the first entry and only show it then.

    But it is late already, and maybe tomorrow I get closer to a solution, or find an answer from you already showing possible directions.

    Plugin Author Michael Simpson

    (@msimpson)

    11 years, 1 month ago

    You would probably need to first sort using a transform.

    Next you would have to aggregate the data. That is, for each city, group all the events under it. I think the best way to do that is to code a custom short code. That short code would loop through the results and output what you want. You would put the “trans” for sorting into it.

    If you want me to code it for you for a fee, contact me at [email protected]

    Thread Starter Sofian777

    (@sofian777)

    11 years, 1 month ago

    Thanks. I will do whatever I can by myself and then come back to your offer. Maybe we renounce from our favorite solution, I am already quite far with a nice output. I will let you know the result but it might take some more time.

    Thread Starter Sofian777

    (@sofian777)

    11 years, 1 month ago

    I wrote you a mail now, thanks for the offer.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Output triple sorted’ is closed to new replies.

Tags