Changeset 1191501
- Timestamp:
- 07/02/2015 09:33:55 PM (11 years ago)
- Location:
- simple-newsletter-br/trunk
- Files:
-
- 2 edited
-
class_newsletter.php (modified) (1 diff)
-
views/admin_grid.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
simple-newsletter-br/trunk/class_newsletter.php
r1142125 r1191501 9 9 'CHECK_EMAIL' => 'SELECT email FROM simplenewsletter_subscriptions WHERE email = \'%s\'', 10 10 'CONFIRM' => 'UPDATE simplenewsletter_subscriptions SET confirmed = 1 where hash = \'%s\'', 11 'COUNT' => 'SELECT (SELECT COUNT(*) from simplenewsletter_subscriptions WHERE confirmed = 1 ) as qty_confirmed, (SELECT COUNT(*) from simplenewsletter_subscriptions WHERE confirmed = 0) as qty_unconfirmed '11 'COUNT' => 'SELECT (SELECT COUNT(*) from simplenewsletter_subscriptions WHERE confirmed = 1 ) as qty_confirmed, (SELECT COUNT(*) from simplenewsletter_subscriptions WHERE confirmed = 0) as qty_unconfirmed, (SELECT COUNT(*) from simplenewsletter_subscriptions WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) = created ) as yesterday, (SELECT COUNT(*) from simplenewsletter_subscriptions WHERE DATE_SUB(CURDATE(),INTERVAL 0 DAY) <= created ) as today, (SELECT COUNT(*) from simplenewsletter_subscriptions WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= created ) as last_week' 12 12 ); 13 13 private $data = array(); -
simple-newsletter-br/trunk/views/admin_grid.php
r1191479 r1191501 71 71 <div class="meta-box-sortables"> 72 72 <div class="postbox"> 73 <h3 ><span><?php echo __("Status", 'simple-newsletter-br'); ?></span></h3>73 <h3 class='hndle ui-sortable-handle'><span><?php echo __("Status", 'simple-newsletter-br'); ?></span></h3> 74 74 <div class="inside"> 75 75 <div> 76 76 <?php $total = $emailList->count();?> 77 <p><b><?php echo __("Confirmed", 'simple-newsletter-br'); ?>: </b><?php echo $total[0]['qty_confirmed']; ?></p>78 <p><b><?php echo __("Not confirmed", 'simple-newsletter-br'); ?>: </b><?php echo $total[0]['qty_unconfirmed']; ?></p>77 <p><b><?php echo __("Confirmed", 'simple-newsletter-br'); ?>: </b><?php echo number_format($total[0]['qty_confirmed'], 0, '', '.'); ?></p> 78 <p><b><?php echo __("Not confirmed", 'simple-newsletter-br'); ?>: </b><?php echo number_format($total[0]['qty_unconfirmed'], 0, '', '.'); ?></p> 79 79 <hr/> 80 <p><b><?php echo __("Yesterday", 'simple-newsletter-br'); ?>: </b><?php echo $total[0]['yesterday']; ?></p> 81 <p><b><?php echo __("Last Week", 'simple-newsletter-br'); ?>: </b><?php echo $total[0]['last_week']; ?></p> 82 <p><b><?php echo __("All Time", 'simple-newsletter-br'); ?>: </b><?php echo ($total[0]['qty_confirmed']+$total[0]['qty_unconfirmed']); ?></p> 80 <p><b><?php echo __("Today", 'simple-newsletter-br'); ?>: </b><?php echo number_format($total[0]['today'], 0, '', '.'); ?></p> 81 <p><b><?php echo __("Yesterday", 'simple-newsletter-br'); ?>: </b><?php echo number_format($total[0]['yesterday'], 0, '', '.'); ?></p> 82 <p><b><?php echo __("Last Week", 'simple-newsletter-br'); ?>: </b><?php echo number_format($total[0]['last_week'], 0, '', '.'); ?></p> 83 <p><b><?php echo __("All Time", 'simple-newsletter-br'); ?>: </b><?php echo number_format(($total[0]['qty_confirmed']+$total[0]['qty_unconfirmed']), 0, '', '.'); ?></p> 83 84 </div> 84 85 </div> <!-- .inside -->
Note: See TracChangeset
for help on using the changeset viewer.