"; $base_link = 'stats?Action=Step4&View=SubscriberStats&ListID=' . $ListID . '&' . $urldata; if($Pages > 1) { $report .= '
| '; if($DisplayPage > 0) { $report .= ' «« |'; } if($DisplayPage > 0){ $report.=' Prev |'; } $sPos = $DisplayPage - 10; if($sPos < 0) $sPos = 0; $ePos = $DisplayPage + 10; if($ePos > $Pages) $ePos = $Pages; for($i = $sPos; $i < $ePos; $i++) { if($DisplayPage != $i) $report .= ' ' . ($i+1) . ' |'; else $report .= ' ' . ($i+1) . ' |'; $lastOffset = ($i*$PerPage); } if($DisplayPage < $Pages-1){ $report.=' Next |'; } if($Pages > 1) { $report .= ' »»'; } $report .= ' | |||||
|
Email Address
|
Date Subscribed
|
Status | Confirmed | Action | |
|
|
' . $member["Email"] . ' | ' . DisplayDate($member["SubscribeDate"]) . ' | '; if($member["Status"] == 1) $report .= 'Active'; else $report .= 'Inactive'; $report .= ' | '; if($member["Confirmed"] == 1) $report .= 'Yes'; else $report .= 'No'; $report .= ' | '; $link = "stats?Action=Step4&View=ViewSubscriber&MemberID=" . $memberid . "&PerPage=$PerPage&DisplayPage=$DisplayPage&ListID=$ListID" . "&" . $urldata; $report .= MakeLink($link, "View") . " "; $report .= ' |
| Subscriber Details | |
| Email: | ' . $member['Email'] .' |
| Subscribed As: | ' . $member_format . ' recipient |
| Date Subscribed: | ' . DisplayDate($member['SubscribeDate']) . ' |
| Visited Links | |
| Link: | ' . $clicked_link['URL'] . ' |
| Newsletter | ' . $clicked_link['EmailName'] . ' |
| Date Clicked: | ' . $clicked . ' |
| Link: | Hasn\'t opened any links |
| Newsletter: | n/a |
| Date Clicked: | n/a |
| Opened Newsletters | Date Opened |
| ' . $emailname . ' | ' . DisplayDate($opened_email['TimeStamp']) . ' |
| Hasn\'t opened any newsletters. | n/a |
| Link | Number of Clicks |
| ' . $row['URL'] . ' | '; $link_count_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "link_clicks WHERE LinkID='" . addslashes($row['LinkID']) . "' AND LinkType='send' AND ListID='" . addslashes($ListID) . "' AND ComposedID='" . addslashes($ComposedID) . "'"; $link_count_check = mysql_result(mysql_query($link_count_query), 0, 0); $report .= '' . number_format($link_count_check, 0) . ' |
| Newsletter | Date Sent | Total Recipients | HTML Recipients | Number of Opens | Action | |
 | ' . stripslashes($newsletter_name) . ' | ' . DisplayDate($row['DateStarted']) . ' | ' . number_format($row['TotalRecipients'], 0) . ' | ' . number_format($row['HTMLRecipients'], 0) . ' | ' . number_format($num_opens, 0) . ' (' . $percent . ' %) | ' . $view_link . ' |
| Newsletter | Number of Links | Number of Clicks | Action | |
| ' . $row['EmailName'] . ' | ' . number_format($num_links, 0) . ' | ' . number_format($num_clicks, 0) . ' | ' . $view_link . ' |
| Mailing List Details | |
| Total Subscribers: | ' . number_format($total_subscribers, 0) . ' |
| Text Subscribers: | ' . number_format($text_subscribers, 0) . ' |
| HTML Subscribers: | ' . number_format($html_subscribers, 0) . ' |
| Active Subscribers: | ' . number_format($active_subscribers, 0) . ' |
| Inactive Subscribers: | ' . number_format($inactive_subscribers, 0) . ' |
| Confirmed Subscribers: | ' . number_format($confirmed_subscribers, 0) . ' |
| Unconfirmed Subscribers: | ' . number_format($unconfirmed_subscribers, 0) . ' |
| Month | Number of Subscribers | Action | |
 | '; $report .= $date; $report .= ' | '; $report .= ''; $report .= number_format($this_month, 0); $report .= ' | '; if ($this_month > 0) { $report .= 'View'; } else { $report .= 'View'; } $report .= ' |
| '; $report .= date('F', $thismonth) . ', ' . $Year; $report .= ' | '; $report .= '|||||||||||||||||||||||||||||||||||||||||||||
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
| '; $per_week_report .= ' | '; } $col = $fill; $numdays = date('t', $thismonth); for ($day = 1; $day <= $numdays; $day++) { $col++; $report .= ' | '; $thisday = mktime(0,0,0, $Month, $day, $Year); $report .= date('jS', $thisday); $num = (isset($per_month_result[$day])) ? $per_month_result[$day] : 0; $per_week_report .= ' | '; if ($num > 0) { $per_week_report .= ' ' . number_format($num, 0) . ' '; } else { $per_week_report .= number_format($num, 0); } $per_week_report .= ' | '; $report .= ''; if ($col % 7 == 0) { $report .= '|||
| '; $per_week_report .= ' | '; } $report .= ' | |||||
| '; } $report .= ' |
| Date | '; $info .= 'Emails Sent | '; $info .= 'Mailing List | '; $info .= 'Status | '; $info .= 'Send Details | '; $info .= '
| ' . DisplayDate($stats['TimeStamp']) . ' | '; $info .= '' . number_format($stats['EmailsSent'], 0) . ' | '; $info .= '' . $MailingList . ' | '; $info .= ''; if ($stats['Completed'] == 1) { $info .= 'Completed'; } elseif ($stats['Completed'] == '-1') { $info .= 'Cancelled'; } else { $info .= 'Currently in progress'; } $info .= ' | '; $info .= 'View | '; $info .= '
| Month | '; $info .= 'Emails Sent | '; $info .= 'Action | '; $info .= '
| '; $info .= 'User has not sent any newsletters.'; $info .= ' | ||
| ' . date('M Y', $row['ThisMonth']) . ' | '; $info .= '' . number_format($row['EmailsSent'], 0) . ' | '; $info .= 'View | '; $info .= '
| Newsletter Send Statistics | ||
| Date Sent: | '; $results .= '' . DisplayDate($info['DateStarted']) . ' | '; $results .= '|
| Date Finished Sending: | '; if ($info['Completed'] == 1 || $info['Completed'] == '-1') { $results .= '' . DisplayDate($info['DateEnded']) . ' | '; } else { $results .= 'Not finished | '; } $results .= '
| '; $results .= ' | Newsletter was cancelled sending | '; $results .= '|
| Recipients: | '; $results .= '' . number_format($info['TextRecipients'], 0) . ' text recipients, ' . number_format($info['HTMLRecipients'], 0) . ' HTML recipients' . (($info['Completed']) ? '' : ' so far') . ' | '; $results .= '|
| Opened By | '; $results .= '' . $openText . ' | '; $results .= '|
| '; $name = current(array_keys($details)); if (is_array($details[$name])) { if (isset($details[$name]['type'])) { if (isset($details[$name]['dd']) && isset($details[$name]['mm']) && isset($details[$name]['yy'])) { $field_details = ucwords($details[$name]['type']) . ' ' . $details[$name]['dd'] . '/' . $details[$name]['mm'] . '/' . $details[$name]['yy'] . ' (Format is dd/mm/yyyy)'; } else { $field_details = ' (not used)'; } } else { $field_details = '(Short Values Only) ' . strtoupper(implode(', ', $details[$name])); } } else { $field_details = $details[$name]; } $results .= ucwords($name); $results .= ' | '; $results .= '' . $field_details . ' | '; $results .= '|
| Newsletter errors:'; if ($info['Completed'] == 0) $results .= ' (so far)'; $results .= ' | '; $results .= 'View Report | '; $results .= '|
| Autoresponder Statistics | |
| Opened By: | '; $results .= '' . $openText . ' | '; $results .= '
| '; if (is_array($details[$name])) { if (isset($details[$name]['type'])) { $field_details = ucwords($details[$name]['type']) . ' ' . $details[$name]['dd'] . '/' . $details[$name]['mm'] . '/' . $details[$name]['yy'] . ' (Format is dd/mm/yyyy)'; } else { $field_details = '(Short Values Only) ' . strtoupper(implode(', ', $details[$name])); } } else { $field_details = $details[$name]; } $results .= ucwords($name); $results .= ' | '; $results .= '' . $field_details . ' | '; $results .= '
| ' . $goback . ' | ' . $paging . ' | |
| Subscriber Email Address | Opened When | |
| ';
$info .= '' . stripslashes($row['Email']) . ' | '; $info .= '' . DisplayDate(stripslashes($row['TimeStamp'])) . ' | '; $info .= '
| Year | Number of Subscribers | Action | |
| ';
$info .= '' . $row['Year'] . ' | '; $info .= '' . number_format($row['YrCount'], 0) . ' | '; $info .= 'View'; $info .= ' |
| Filter by Custom Fields | ||||||||||||||||||||||||
';
}
foreach($custom_fields as $pos => $f) {
switch($f['FieldType']){
case 'shorttext':
list($size,$min,$max)=explode(',',$f['AllValues']);
$FORM_ITEMS[$FORM_NOT_REQUIRED_ITEM . "Search ".$f['FieldName']]='textfield|Fields['.$f['FieldID'].']:'.$max.':44';
break;
case 'longtext':
list($Width,$Height)=explode(',',$f['AllValues']);
$FORM_ITEMS[$FORM_NOT_REQUIRED_ITEM . 'Search '.$f['FieldName']]='textfield|Fields['.$f['FieldID'].']:500:44';
break;
case 'checkbox':
$FORM_ITEMS[$FORM_NOT_REQUIRED_ITEM . $f['FieldName']]='select|Fields['.$f['FieldID'].']:1:y->Yes;n->No;all->All:all';
break;
case 'multicheckbox':
$FORM_ITEMS[$FORM_NOT_REQUIRED_ITEM . $f['FieldName']]='checkboxes|Fields['.$f['FieldID'].']:' . $f['AllValues'] . ':';
break;
case 'datebox':
$FORM_ITEMS[$FORM_NOT_REQUIRED_ITEM . $f['FieldName']]='dateboxsearch|Fields['.$f['FieldID'].']:' . $f['AllValues'] . ':';
break;
case 'dropdown':
$FORM_ITEMS[$FORM_NOT_REQUIRED_ITEM . $f['FieldName']]='select|Fields['.$f['FieldID'].']:1:->All Values;'.$f['AllValues'].':';
break;
}
}
$FORM_ITEMS['-1']='submit|Search:1-stats';
$FORM=new AdminForm;
$FORM->title="SearchMembers";
$FORM->items=$FORM_ITEMS;
$FORM->action=MakeAdminLink("stats?Action=Step4&View=SubscriberStats&ListID=$ListID");
$FORM->MakeForm("Filter Subscriber Details");
$MO=$FORM->output;
$MO = "Complete the form below to filter subscribers for this report (optional)." . $MO;
$return = $MO . '
';
return $return;
}
function SendStatistics($ListID=0) {
global $TABLEPREFIX, $ROOTURL;
$sends=mysql_query("SELECT * FROM " . $TABLEPREFIX . "sends WHERE ListID='".addslashes($ListID)."' AND DateStarted != '' ORDER BY DateStarted DESC");
$newsletter_list = array();
if(mysql_num_rows($sends) > 0)
{
$SO = '
'; } return $SO; } function ViewAutoresponderStats($ListID=0) { global $TABLEPREFIX, $ROOTURL; $responders = mysql_query("SELECT * FROM " . $TABLEPREFIX . "autoresponders WHERE ListID='".addslashes($ListID)."' ORDER BY DateCreated DESC"); if(mysql_num_rows($responders) > 0) { $SO = '
No autoresponders have been set up. Please click on the button below to view another report. '; } return $SO; } ?> | ||||||||||||||||||||||||