function pagination($limit) { global $p; $curpage = $p; $next_page_num = 0; $prev_page_num = 0; $total_campaigns = totals($_GET['i']); $total_pages = @ceil($total_campaigns / $limit); if ($total_campaigns > $limit) { if ($curpage >= 2) { $next_page_num = $curpage + 1; $prev_page_num = $curpage - 1; } else { $next_page_num = 2; } echo '<div class="btn-group" id="pagination">'; //Prev btn if ($curpage >= 2) { if ($prev_page_num == 1) { echo '<button class="btn" onclick="window.location=\'' . get_app_info('path') . '/templates?i=' . get_app_info('app') . '\'"><span class="icon icon icon-arrow-left"></span></button>'; } else { echo '<button class="btn" onclick="window.location=\'' . get_app_info('path') . '/templates?i=' . get_app_info('app') . '&p=' . $prev_page_num . '\'"><span class="icon icon icon-arrow-left"></span></button>'; } } else { echo '<button class="btn disabled"><span class="icon icon icon-arrow-left"></span></button>'; } //Next btn if ($curpage == $total_pages) { echo '<button class="btn disabled"><span class="icon icon icon-arrow-right"></span></button>'; } else { echo '<button class="btn" onclick="window.location=\'' . get_app_info('path') . '/templates?i=' . get_app_info('app') . '&p=' . $next_page_num . '\'"><span class="icon icon icon-arrow-right"></span></button>'; } echo '</div>'; } }
function report_csv($module, $name, $values) { $report = get_report($module, $name); if ($report === NULL) { die; } $reportRun = $report->run($values); ob_clean(); $output = fopen("php://output", "rb+"); if (!$report->isGrouping()) { fputcsv($output, array("Pastèque", ""), ";"); $line = $report->getHeaders(); fputcsv($output, $line, ";"); while ($line = $reportRun->fetch()) { $data = array(); foreach ($report->getFields() as $field) { $data = init_data($report, $data, $line, $field); } fputcsv($output, $data, ";"); } } else { while ($line = $reportRun->fetch()) { $data = array(); if ($reportRun->isGroupEnd()) { if ($report->hasSubtotals()) { write_subtotals($output, $report, $reportRun); } fputcsv($output, array(), ";"); } if ($reportRun->isGroupStart()) { fputcsv($output, array($reportRun->getCurrentGroup()), ";"); fputcsv($output, $report->getHeaders(), ";"); } foreach ($report->getFields() as $field) { $data = init_data($report, $data, $line, $field); } fputcsv($output, $data, ";"); unset($data); } if ($report->hasSubtotals()) { write_subtotals($output, $report, $reportRun); fputcsv($output, array(), ";"); } } if ($report->hasTotals()) { fputcsv($output, array(\i18n("Total")), ";"); fputcsv($output, totalHeader($report, $reportRun), ";"); fputcsv($output, totals($report, $reportRun), ";"); } }
</th> <th><?php echo _('Unsubscribe'); ?> </th> <th><?php echo _('Delete'); ?> </th> </tr> </thead> <tbody> <?php $limit = 20; $total_subs = totals($lid); $total_pages = ceil($total_subs / $limit); if ($p != null) { $offset = ($p - 1) * $limit; } else { $offset = 0; } if ($s == '') { if ($a == '' && $c == '' && $u == '' && $b == '' && $cp == '') { $q = 'SELECT * FROM subscribers WHERE list = ' . mysqli_real_escape_string($mysqli, $lid) . ' ORDER BY timestamp DESC LIMIT ' . $offset . ',' . $limit; } else { if ($a != '') { $q = 'SELECT * FROM subscribers WHERE list = ' . mysqli_real_escape_string($mysqli, $lid) . ' AND confirmed = 1 AND unsubscribed = 0 AND bounced = 0 AND complaint = 0 ORDER BY timestamp DESC LIMIT ' . $offset . ',' . $limit; } else { if ($c != '') { $q = 'SELECT * FROM subscribers WHERE list = ' . mysqli_real_escape_string($mysqli, $lid) . ' AND confirmed = ' . $c . ' ORDER BY timestamp DESC LIMIT ' . $offset . ',' . $limit;
</th> <th><?php echo _('Duplicate'); ?> </th> <th><?php echo _('Delete'); ?> </th> </tr> </thead> <tbody> <?php $limit = 10; $total_subs = totals($_GET['i']); $total_pages = ceil($total_subs / $limit); $p = isset($_GET['p']) ? $_GET['p'] : null; $offset = $p != null ? ($p - 1) * $limit : 0; $q = 'SELECT * FROM campaigns WHERE userID = ' . get_app_info('main_userID') . ' AND app=' . get_app_info('app') . ' ORDER BY id DESC LIMIT ' . $offset . ',' . $limit; $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { while ($row = mysqli_fetch_array($r)) { $id = stripslashes($row['id']); $timezone = stripslashes($row['timezone']); if ($timezone == '' || $timezone == 0) { date_default_timezone_set(get_app_info('timezone')); } else { date_default_timezone_set($timezone); } $title = stripslashes(htmlentities($row['title'], ENT_QUOTES, "UTF-8"));
</th> <th><?php echo _('Unique Clicks'); ?> </th> <th><?php echo _('Delete'); ?> </th> </tr> </thead> <tbody> <?php $limit = 10; $total_subs = totals($_GET['i'], 'reports'); $total_pages = ceil($total_subs / $limit); $p = isset($_GET['p']) ? $_GET['p'] : null; $offset = $p != null ? ($p - 1) * $limit : 0; $q = 'SELECT * FROM campaigns WHERE userID = ' . get_app_info('main_userID') . ' AND app=' . get_app_info('app') . ' AND sent != "" ORDER BY id DESC LIMIT ' . $offset . ',' . $limit; $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { while ($row = mysqli_fetch_array($r)) { $id = stripslashes($row['id']); $title = stripslashes(htmlentities($row['title'], ENT_QUOTES, "UTF-8")); $campaign_title = $row['label'] == '' ? $title : stripslashes(htmlentities($row['label'], ENT_QUOTES, "UTF-8")); $recipients = stripslashes($row['recipients']); $sent = stripslashes($row['sent']); $opens = stripslashes($row['opens']); $from_email = stripslashes($row['from_email']); $error_stack = stripslashes($row['errors']);
</th> <th><?php echo _('Unsubscribe'); ?> </th> <th><?php echo _('Delete'); ?> </th> </tr> </thead> <tbody> <?php $limit = 20; $total_subs = totals($_GET['l']); $total_pages = ceil($total_subs / $limit); if ($p != null) { $offset = ($p - 1) * $limit; } else { $offset = 0; } if ($s == '') { if ($a == '' && $c == '' && $u == '' && $b == '' && $cp == '') { $q = 'SELECT * FROM subscribers WHERE list = ' . mysqli_real_escape_string($mysqli, $_GET['l']) . ' ORDER BY timestamp DESC LIMIT ' . $offset . ',' . $limit; } else { if ($a != '') { $q = 'SELECT * FROM subscribers WHERE list = ' . mysqli_real_escape_string($mysqli, $_GET['l']) . ' AND confirmed = 1 AND unsubscribed = 0 AND bounced = 0 AND complaint = 0 ORDER BY timestamp DESC LIMIT ' . $offset . ',' . $limit; } else { if ($c != '') { $q = 'SELECT * FROM subscribers WHERE list = ' . mysqli_real_escape_string($mysqli, $_GET['l']) . ' AND confirmed = ' . $c . ' ORDER BY timestamp DESC LIMIT ' . $offset . ',' . $limit;
function pagination($limit) { global $s; global $c; global $p; global $a; global $u; global $b; global $cp; $curpage = $p; $next_page_num = 0; $prev_page_num = 0; $total_subs = totals($_GET['l']); $total_pages = @ceil($total_subs / $limit); if ($s != '') { $s_more = '&s=' . $s; } else { $s_more = ''; } $more = ''; if ($a != '') { $more = '&a=' . $a; } else { if ($c != '') { $more = '&c=' . $c; } else { if ($u != '') { $more = '&u=' . $u; } else { if ($b != '') { $more = '&b=' . $b; } else { if ($cp != '') { $more = '&cp=' . $cp; } } } } } if ($total_subs > $limit) { if ($curpage >= 2) { $next_page_num = $curpage + 1; $prev_page_num = $curpage - 1; } else { $next_page_num = 2; } echo '<div class="btn-group" id="pagination">'; //Prev btn if ($curpage >= 2) { if ($prev_page_num == 1) { echo '<button class="btn" onclick="window.location=\'' . get_app_info('path') . '/subscribers?i=' . get_app_info('app') . '&l=' . $_GET['l'] . $s_more . $more . '\'"><span class="icon icon icon-arrow-left"></span></button>'; } else { echo '<button class="btn" onclick="window.location=\'' . get_app_info('path') . '/subscribers?i=' . get_app_info('app') . '&l=' . $_GET['l'] . $s_more . $more . '&p=' . $prev_page_num . '\'"><span class="icon icon icon-arrow-left"></span></button>'; } } else { echo '<button class="btn disabled"><span class="icon icon icon-arrow-left"></span></button>'; } //Next btn if ($curpage == $total_pages) { echo '<button class="btn disabled"><span class="icon icon icon-arrow-right"></span></button>'; } else { echo '<button class="btn" onclick="window.location=\'' . get_app_info('path') . '/subscribers?i=' . get_app_info('app') . '&l=' . $_GET['l'] . $s_more . $more . '&p=' . $next_page_num . '\'"><span class="icon icon icon-arrow-right"></span></button>'; } echo '</div>'; } }