*
* filename : MailChimpReprot.php
* last change : 2014-11-29
* website : http://www.churchdb.org
* 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">
*
* http://www.infocentral.org/
* Copyright 2001-2003 Phillip Hullquist, Deane Barker, Chris Gebhardt
*
* InfoCentral 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.
*
******************************************************************************/
// Include the function library
require "Include/Config.php";
require "Include/Functions.php";
require 'Include/PersonFunctions.php';
require 'Include/MailchimpFunctions.php';
$mailchimp = new ChurchInfoMailchimp();
// Get the person ID from the querystring
$iPersonID = FilterInput($_GET["PersonID"], 'int');
$iRemoveVO = 0;
if (array_key_exists("RemoveVO", $_GET)) {
$iRemoveVO = FilterInput($_GET["RemoveVO"], 'int');
}
if (isset($_POST["GroupAssign"]) && $_SESSION['bManageGroups']) {
$iGroupID = FilterInput($_POST["GroupAssignID"], 'int');
AddToGroup($iPersonID, $iGroupID, 0);
}
if (isset($_POST["VolunteerOpportunityAssign"]) && $_SESSION['bEditRecords']) {
$volIDs = $_POST["VolunteerOpportunityIDs"];
if ($volIDs) {
foreach ($volIDs as $volID) {
AddVolunteerOpportunity($iPersonID, $volID);
*
* This program is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* http://www.gnu.org/licenses
*
******************************************************************************/
//Include the function library
require "Include/Config.php";
require "Include/Functions.php";
require "Include/GeoCoder.php";
require 'Include/PersonFunctions.php';
require 'Include/MailchimpFunctions.php';
$mailchimp = new ChurchInfoMailchimp();
//Set the page title
$sPageTitle = gettext("Family View");
function getFamilyPhoto($iFamilyID)
{
$validExtensions = array("jpeg", "jpg", "png");
$hasFile = false;
while (list(, $ext) = each($validExtensions)) {
$photoFile = "Images/Family/thumbnails/" . $iFamilyID . "." . $ext;
if (file_exists($photoFile)) {
$hasFile = true;
break;
}
}
if ($hasFile) {
return $photoFile;
*
* filename : MailChimpReprot.php
* last change : 2014-11-29
* website : http://www.churchdb.org
* 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";
} else {
echo "<h3>Mailchimp Lists</h3>";
$mcLists = $mailchimp->getLists();
foreach ($mcLists as $list) {
echo "<h4><u>" . $list["name"] . "</u></h4>";
?>
<table width="300px">
<?php
echo "<tr><td><b>Members:</b> </td><td>" . $list["stats"]["member_count"] . "</td></tr>";
