Changeset 20284 for extensions/Piwecard/admin/admin_management.php

Timestamp:

Jan 20, 2013, 3:17:42 PM (11 years ago)

Author:

julien1311

Message:

[piwecard] add email improvements and stats in admin_management.php

File:

• extensions/Piwecard/admin/admin_management.php (modified) (1 diff)

extensions/Piwecard/admin/admin_management.php

@@ -134 +134 @@
 }
 
-$nb_ecard_valid_total = str_replace(array('%nb_valid%', '%nb_total%'), array($piwecard->get_nb_valid_ecard(), $piwecard->get_nb_ecard()), l10n('piwecard_nb_ecard_valid_total'));
+$nb_ecards_valid_total = str_replace(array('%nb_valid%', '%nb_total%'), array($piwecard->get_nb_valid_ecard(), $piwecard->get_nb_ecard()), l10n('piwecard_nb_ecard_valid_total'));
 
-$template->assign('nb_ecard_valid_total', $nb_ecard_valid_total);
+$query = 'SELECT COUNT(DISTINCT sender_email) AS nb_senders, COUNT(DISTINCT recipient_email) AS nb_recipients FROM '.PIWECARD_TABLE.' ORDER BY date_creation;';
+$result = pwg_db_fetch_assoc(pwg_query($query));
+$nb_distinct_senders_total = (empty($result['nb_senders']) ? 0 : $result['nb_senders']);
+$nb_distinct_recipients_total = (empty($result['nb_recipients']) ? 0 : $result['nb_recipients']);
+
+$nb_distinct_senders_recipients_total = str_replace(array('%nb_senders%', '%nb_recipients%'), array($nb_distinct_senders_total, $nb_distinct_senders_total), l10n('piwecard_nb_sender_recipient_total'));
+
+$template->assign('nb_ecards_valid_total', $nb_ecards_valid_total);
+$template->assign('nb_distinct_senders_recipients_total', $nb_distinct_senders_recipients_total);
 $template->assign('ecard_nb_ecard_page', $piwecard->config['nb_ecard_page']);
 $template->assign('navbar', $ecard_navbar);