Support

Home Forums Event Espresso Premium Reporting outside WordPress

Reporting outside WordPress

Posted: October 6, 2020 at 8:14 am

Viewing 5 reply threads


motio

October 6, 2020 at 8:14 am

Hi,

because WordPress (or the available plugins) has problems with exporting javascript charts in pdfs, we started using KoolReport as our reporting tool. Now we would like to implement data from event espresso.

My hope was to reuse of the code that I wrote (e.g. in Table View Template Add-on). Is there a way to use the objects and methods of event espresso outside WordPress?


Tony

  • Support Staff

October 6, 2020 at 8:57 am

Hi there,

Is there a way to use the objects and methods of event espresso outside WordPress?

Unless I’m misunderstanding your question, the short answer is no.

Event Espresso is a WordPress plugin, it pulls all of the values from the WP Database and uses a lot of internal WP functions so you can’t load Event Espressos objects/models/etc outside of WordPress.

Depending on the data you are looking to pull, you may be able to use the REST API:

https://github.com/eventespresso/event-espresso-core/tree/master/docs/C–REST-API


motio

October 6, 2020 at 9:28 am

Hi Tony,

do you have examples of sql queries (e.g. to have a list of all events) or give me a hint, where to find the queries that the methods are using?

The connections within the event espresso tables in the database are pretty straight forward, but I don’t understand the connections between the EE and the WP tables fully.


Tony

  • Support Staff

October 7, 2020 at 3:51 am

do you have examples of sql queries (e.g. to have a list of all events) or give me a hint, where to find the queries that the methods are using?

They are created dynamically through our model system which handles all of the joins for you.

You can find details on the model system here:

https://github.com/eventespresso/event-espresso-core/tree/master/docs/G–Model-System

You’ll likely find this section helpful:

https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/model-querying.md#inspecting-generated-queries

Which will output the generated SQL queries for you to view when using the modest o pull in data.

EE events in themselves are a custom post type, but pretty much everything other than what you would expect with a standard post is stored in custom tables and we join wp_posts using the post ID. The relationships between the EE tables are more complex than the one to wp_posts so if you have those down the above should be straight forward.


motio

October 7, 2020 at 9:23 am

Hey Tony,thanks a lot.
Could you tell me where to join the Event to the Message Template?
Maybe I am blind or didn’t find the right spot in the documentation.


Tony

  • Support Staff

October 7, 2020 at 2:54 pm

Using the models you can do something like:

$templates_for_event = EEM_Message_Template_Group::instance()->get_all_custom_templates_by_event(
    $event_id,
    array(
        'MTP_messenger' => 'email',
        'MTP_is_active' => true
    )
);

Obviously set the $event_id variable for the event in question.

If you output that question you’ll see it uses esp_event_message_template and esp_message_template_group

Viewing 5 reply threads

The support post ‘Reporting outside WordPress’ 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