I want to make a chart for report feature that can visualize email sending event. The event type are recipient, delivery, open, click, complaint, and bounces, which are in the table "email_sending_event". And the number_of_recipient, number_of_delivery, number_of_open, number_of_click, number_of_complaint, and number_of_bounces which are in the table "email".
EmailController.php:
data.php:
report.php:
table "email":
table "email_sending_status":
My question is, how to show event type, number_of_recipient, number_of_delivery, number_of_open, number_of_click, number_of_complaint, and number_of_bounces in the chart, using different tables?
Thankyou
I want to make a chart for report feature that can visualize email sending event. The event type are recipient, delivery, open, click, complaint, and bounces, which are in the table "email_sending_event". And the number_of_recipient, number_of_delivery, number_of_open, number_of_click, number_of_complaint, and number_of_bounces which are in the table "email".
EmailController.php:
data.php:
report.php:
table "email":
table "email_sending_status":
My question is, how to show event type, number_of_recipient, number_of_delivery, number_of_open, number_of_click, number_of_complaint, and number_of_bounces in the chart, using different tables? Thankyou