* copyright : Copyright 2014
*
* ChurchInfo is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
******************************************************************************/
require 'Include/Config.php';
require 'Include/Functions.php';
require 'Include/MailchimpFunctions.php';
$mailchimp = new ChurchInfoMailchimp();
//Set the page title
$sPageTitle = gettext('MailChimp Menu');
require 'Include/Header.php';
if (!$mailchimp->isActive()) {
echo "Mailchimp is not active";
}
// Get all the groups
$sSQL = "SELECT per_FirstName, per_LastName, per_Email, per_id FROM `stgeorge_churchinfo`.`person_per` where per_Email != '' order by per_DateLastEdited desc";
$rsPeopleWithEmail = RunQuery($sSQL);
?>
<script src="http://mottie.github.io/tablesorter/js/jquery.tablesorter.js"></script>
<script src="http://mottie.github.io/tablesorter/js/jquery.tablesorter.widgets.js"></script>
<h3>People not in Mailchimp</h3>
<table id="people_with_email" width="100%" data-toggle="table" class="table table-striped table-bordered tablesorter">
<thead>
<tr>
<td>Name</td>
<td>Email</td>
echo $sHomePhone;
?>
</span></li>
<?php
}
if ($sEmail != "") {
?>
<li><i class="fa-li fa fa-envelope"></i><?php
echo gettext("Email:");
?>
<span><?php
echo "<a href=\"mailto:" . $sUnformattedEmail . "\">" . $sEmail . "</a>";
?>
</span></li>
<?php
if ($mailchimp->isActive()) {
?>
<li><i class="fa-li glyphicon glyphicon-send"></i>MailChimp: <span><?php
echo $mailchimp->isEmailInMailChimp($sEmail);
?>
</span></li>
<?php
}
}
if ($sWorkPhone) {
?>
<li><i class="fa-li fa fa-phone"></i><?php
echo gettext("Work Phone:");
?>
<span><?php
echo $sWorkPhone;
