function do_export()
{
global $vars;
global $db;
if ($vars['date_check'] == "on") {
$dt = get_input_vars();
$start_date = set_date_from_smarty('range_start', $dt);
$end_date = set_date_from_smarty('range_end', $dt);
} else {
$start_date = '0000-00-00';
$end_date = '2099-12-31';
}
$members = array();
if ($vars['send_file']) {
header('Cache-Control: maxage=3600');
header('Pragma: public');
header("Content-type: application/csv");
$dat = date('Ymd');
header("Content-Disposition: attachment; filename=amember-{$dat}.csv");
} else {
header("Content-type: text/plain");
}
define('REC_LIMIT', 1024);
if (count($vars['product_name']) > 0) {
$prod = join(",", $vars['product_name']);
} else {
$prod = '';
}
foreach ($vars['subscr_type'] as $subscr_type) {
switch ($subscr_type) {
case 'any':
if ($subscr_type == 'any') {
$cmpl = 0;
}
case 'completed':
if ($subscr_type == 'completed') {
$cmpl = 1;
}
case 'not_completed':
if ($subscr_type == 'not_completed') {
$cmpl = -1;
}
list($count, $sumx) = $db->get_payments_c($start_date, $end_date, $cmpl, 'add', $prod);
$used_member_id = array();
for ($i = 0; $i < $count; $i += REC_LIMIT) {
$list1 = $db->get_payments($start_date, $end_date, $cmpl, $i, REC_LIMIT, 'add', $prod);
foreach ($list1 as $l) {
if ($vars['multi_type'] == 'discard' && $used_member_id[$l['member_id']]++) {
continue;
}
if (!isset($members[$l['member_id']])) {
$members[$l['member_id']] = $db->get_user($l['member_id']);
}
$members[$l['member_id']]['PAYMENTS'][$l['payment_id']] = $l;
}
print_rows($members);
$members = array();
}
break;
case 'active':
$yesterday = date('Y-m-d', time() - 3600 * 24);
$count = $db->users_find_by_date_c($yesterday, 'date_range', $start_date, $end_date, $prod);
for ($i = 0; $i < $count; $i += REC_LIMIT) {
$members1 = $db->users_find_by_date($yesterday, 'date_range', $i, REC_LIMIT, $start_date, $end_date, $prod);
$dat = date('Y-m-d');
foreach ($members1 as $u) {
$members[$u['member_id']] = $u;
$list = $db->get_user_payments($u['member_id'], 1);
foreach ($list as $l) {
$tmadd = explode(' ', $l['tm_added']);
if ($l['begin_date'] > $dat || $l['expire_date'] < $dat || $tmadd[0] < $start_date || $tmadd[0] > $end_date) {
continue;
}
if (count($vars['product_name']) > 0 && !in_array($l['product_id'], $vars['product_name'])) {
continue;
}
$members[$u['member_id']]['PAYMENTS'][$l['payment_id']] = $l;
}
}
print_rows($members);
$members = array();
}
break;
case 'expired':
$today = date('Y-m-d', time());
$count = $db->users_find_by_date_c($today, 'expire_date_range', $start_date, $end_date, $prod);
for ($i = 0; $i < $count; $i += REC_LIMIT) {
$members1 = $db->users_find_by_date($today, 'expire_date_range', $i, REC_LIMIT, $start_date, $end_date, $prod);
$dat = date('Y-m-d');
foreach ($members1 as $u) {
$members[$u['member_id']] = $u;
$list = $db->get_user_payments($u['member_id'], 1);
foreach ($list as $l) {
$tmadd = explode(' ', $l['tm_added']);
if ($l['begin_date'] > $dat || $l['expire_date'] > $dat || $tmadd[0] < $start_date || $tmadd[0] > $end_date) {
continue;
}
if (count($vars['product_name']) > 0 && !in_array($l['product_id'], $vars['product_name'])) {
continue;
}
$members[$u['member_id']]['PAYMENTS'][$l['payment_id']] = $l;
}
}
print_rows($members);
$members = array();
}
break;
case 'expired_users':
$count = $db->get_users_list_c("%", 2);
for ($i = 0; $i < $count; $i += REC_LIMIT) {
$members1 = $db->get_users_list("%", 2, $i, $REC_LIMIT);
foreach ($members1 as $u) {
$members[$u['member_id']] = $u;
}
print_rows($members);
$members = array();
}
break;
default:
fatal_error("Unknown Subscription Type: Please select one", 0);
}
if ($subscr_type == 'all') {
break;
}
}
}
{
foreach ($rows as $row) {
echo "<tr>";
foreach (array_keys($row) as $key) {
echo "<td class='ed-stats'>" . $row[$key] . "</td>";
}
echo "</tr>";
}
}
echo '<h2>List of Approval Editor Stats</h2>';
echo '<table id="approvalstats" class="tablesorter">';
echo '<thead><tr>';
echo '<th>Editor</th><th>Number of puzzles</th><th>Comments (total)</th><th>Comments (in last week)</th>';
echo '</tr></thead>';
print_rows(getApprovalEditorStats());
echo '</table><br><br>';
echo '<h2>List of Discussion Editor Stats</h2>';
echo '<table id="discussionstats" class="tablesorter">';
echo '<thead><tr>';
echo '<th>Editor</th><th>Number of puzzles</th><th>Comments (total)</th><th>Comments (in last week)</th>';
echo '</tr></thead>';
print_rows(getDiscussionEditorStats());
echo '</table><br><br>';
echo '<h2>List of Author Stats</h2>';
echo '<table id="authorstats" class="tablesorter">';
echo '<thead><tr>';
echo '<th>Author</th><th>Number of puzzles</th><th>Comments (total)</th><th>Comments (in last week)</th>';
echo '</tr></thead>';
print_rows(getAuthorStats());
echo '</table><br><br>';
foot();
print_headers($this_table_obj);
?>
</tr>
</thead>
<tfoot>
<tr>
<?php
print_headers($this_table_obj);
?>
</tr>
</tfoot>
<tbody>
<?php
print_rows($this_table_obj);
?>
</tbody>
</table>
<?php
/**
* {@internal Missing Short Description}}
*
1329 * @since unknown
1330 *
1331 * @param unknown_type $posts
1332 */
function print_rows($this_table_obj)
{
add_filter('the_title', 'esc_html');
