<?php

/*******************************************************************************

*

* filename : CartView.php

* website : http://www.churchdb.org

*

* Copyright 2001-2003 Phillip Hullquist, Deane Barker, Chris Gebhardt

*

* Additional Contributors:

* 2006 Ed Davis

*

*

* Copyright 2006 Contributors

*

* 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.

*

* This file best viewed in a text editor with tabs stops set to 4 characters

*

******************************************************************************/

function ExportCartToCSV()

}

// Include the function library

require "Include/Config.php";

require "Include/Functions.php";

require "Include/LabelFunctions.php";

if (isset($_POST["rmEmail"]))

{

rmEmail();

}

if (isset($_POST["cartcsv"]))

{

// If user does not have CSV Export permission, redirect to the menu.

if (!$bExportCSV)

{

Redirect("Menu.php");

exit;

}

ExportCartToCSV();

exit;

}

// Set the page title and include HTML header

$sPageTitle = gettext("View Your Cart");

require "Include/Header.php";

// Confirmation message that people where added to Event from Cart

if (count($_SESSION['aPeopleCart']) == 0) {

if (!$_GET["Message"])

{

echo "<p align=\"center\" class=\"LargeText\">" . gettext("You have no items in your cart.") . "</p>";

} else {

switch ($_GET["Message"])

{

case "aMessage":

echo '<p align="center" class="LargeText">'.$_GET["iCount"].' '.($_GET["iCount"] == 1 ? "Record":"Records").' Emptied into Event ID:'.$_GET["iEID"].'</p>'."\n";

break;

}

}

echo '<p align="center"><input type="button" name="Exit" class="icButton" value="'.gettext("Back to Menu").'" '."onclick=\"javascript:document.location='Menu.php';\"></p>\n";

} else {

// Create array with Classification Information (lst_ID = 1)

$sClassSQL = "SELECT * FROM list_lst WHERE lst_ID=1 ORDER BY lst_OptionSequence";

$rsClassification = RunQuery($sClassSQL);

unset($aClassificationName);

$aClassificationName[0] = "Unassigned";

while ($aRow = mysql_fetch_array($rsClassification))

{

extract($aRow);

$aClassificationName[intval($lst_OptionID)]=$lst_OptionName;

}

// Create array with Family Role Information (lst_ID = 2)

$sFamRoleSQL = "SELECT * FROM list_lst WHERE lst_ID=2 ORDER BY lst_OptionSequence";

$rsFamilyRole = RunQuery($sFamRoleSQL);

unset($aFamilyRoleName);

$aFamilyRoleName[0] = "Unassigned";

while ($aRow = mysql_fetch_array($rsFamilyRole))

{

extract($aRow);

$aFamilyRoleName[intval($lst_OptionID)]=$lst_OptionName;

}

$sSQL = "SELECT * FROM person_per LEFT JOIN family_fam ON person_per.per_fam_ID = family_fam.fam_ID WHERE per_ID IN (" . ConvertCartToString($_SESSION['aPeopleCart']) . ") ORDER BY per_LastName";

$rsCartItems = RunQuery($sSQL);

$iNumPersons = mysql_num_rows($rsCartItems);

$sSQL = "SELECT distinct per_fam_ID FROM person_per LEFT JOIN family_fam ON person_per.per_fam_ID = family_fam.fam_ID WHERE per_ID IN (" . ConvertCartToString($_SESSION['aPeopleCart']) . ") ORDER BY per_fam_ID";

$iNumFamilies = mysql_num_rows(RunQuery($sSQL));

if ($iNumPersons > 16)

{

?>

<center>

<form method="get" action="CartView.php#GenerateLabels">

<input type="submit" class="icButton" name="gotolabels"

value="<?php echo gettext("Go To Labels");?>">

</form></center>

<?php

}

echo '<p align="center">' . gettext("Your cart contains") . ' ' . $iNumPersons . ' ' . gettext("persons from") . ' ' . $iNumFamilies . ' ' . gettext("families.") . '</p>';

echo '<table align="center" width="70%" cellpadding="4" cellspacing="0">';

echo '<tr class="TableHeader">';

echo '<td><b>' . gettext("Name") . '</b></td>';

echo '<td align="center"><b>' . gettext("Address?") . '</b></td>';

echo '<td align="center"><b>' . gettext("Email?") . '</b></td>';

echo '<td><b>' . gettext("Remove") . '</b></td>';

echo '<td align="center"><b>' . gettext("Classification") . '</b></td>';

echo '<td align="center"><b>' . gettext("Family Role") . '</b></td>';

$sEmailLink = "";

$iEmailNum = 0;

while ($aRow = mysql_fetch_array($rsCartItems))

{

$sRowClass = AlternateRowStyle($sRowClass);

extract($aRow);

$sEmail = SelectWhichInfo($per_Email, $fam_Email, False);

if (strlen($sEmail))

{

$sValidEmail = gettext("Yes");

if (!stristr($sEmailLink, $sEmail))

{

$email_array[] = $sEmail;

if ($iEmailNum == 0)

{ // Comma is not needed before first email address

$sEmailLink .= $sEmail;

$iEmailNum++;

}

else

$sEmailLink .= $sMailtoDelimiter . $sEmail;

}

}

else

{

$sValidEmail = gettext("No");

}

$sAddress1 = SelectWhichInfo($per_Address1, $fam_Address1, False);

$sAddress2 = SelectWhichInfo($per_Address2, $fam_Address2, False);

if (strlen($sAddress1) > 0 || strlen($sAddress2) > 0)

$sValidAddy = gettext("Yes");

else

$sValidAddy = gettext("No");

echo '<tr class="' . $sRowClass . '">';

echo '<td><a href="PersonView.php?PersonID=' . $per_ID . '">' . FormatFullName($per_Title, $per_FirstName, $per_MiddleName, $per_LastName, $per_Suffix, 1) . '</a></td>';

echo '<td align="center">' . $sValidAddy . '</td>';

echo '<td align="center">' . $sValidEmail . '</td>';

echo '<td><a onclick="saveScrollCoordinates()"

href="CartView.php?RemoveFromPeopleCart=' .

$per_ID . '">' . gettext("Remove") . '</a></td>';

echo '<td align="center">' . $aClassificationName[$per_cls_ID] . '</td>';

echo '<td align="center">' . $aFamilyRoleName[$per_fmr_ID] . '</td>';

echo "</tr>";

}

echo "</table>";

}

if (count($_SESSION['aPeopleCart']) != 0)

{

echo "<br><table align=\"center\" cellpadding=\"15\"><tr><td valign=\"top\">";

echo "<p align=\"center\" class=\"MediumText\">";

echo "<b>" . gettext("Cart Functions") . "</b><br>";

echo "<br>";

echo "<a href=\"CartView.php?Action=EmptyCart\">" . gettext("Empty Cart") . "</a>";

if ($_SESSION['bManageGroups']) {

echo "<br>";

echo "<a href=\"CartToGroup.php\">" . gettext("Empty Cart to Group") . "</a>";

}

if ($_SESSION['bAddRecords']) {

echo "<br>";

echo "<a href=\"CartToFamily.php\">" . gettext("Empty Cart to Family") . "</a>";

}

echo "<br>";

echo "<a href=\"CartToEvent.php\">" . gettext("Empty Cart to Event") . "</a>";

// Only show CSV export link if user is allowed to CSV export.

if ($bExportCSV)

{

/* Link to CSV export */

echo "<br>";

echo "<a href=\"CSVExport.php?Source=cart\">" . gettext("CSV Export") . "</a>";

}

if ($iEmailNum > 0) {

// Add default email if default email has been set and is not already in string

if ($sToEmailAddress != "" && $sToEmailAddress != "myReceiveEmailAddress" && !stristr($sEmailLink, $sToEmailAddress))

$sEmailLink .= $sMailtoDelimiter . $sToEmailAddress;

$sEmailLink = urlencode($sEmailLink); // Mailto should comply with RFC 2368

if ($bEmailMailto) { // Does user have permission to email groups with mailto

echo "<br><a href=\"mailto:" . $sEmailLink ."\">". gettext("Email Cart") . "</a>";

echo "<br><a href=\"mailto:?bcc=".$sEmailLink."\">".gettext("Email (BCC)")."</a>";

}

}

echo "<br><a href=\"MapUsingGoogle.php?GroupID=0\">" . gettext("Map Cart") . "</a>";

echo "</p></td>";

?>

<td>

<a name="GenerateLabels"></a>

<script language="JavaScript" type="text/javascript"><!--

function codename()

{

if(document.labelform.bulkmailpresort.checked)

{

document.labelform.bulkmailquiet.disabled=false;

}

else

{

document.labelform.bulkmailquiet.disabled=true;

document.labelform.bulkmailquiet.checked=false;

}

}

//-->

</SCRIPT>

<form method="get" action="Reports/PDFLabel.php" name="labelform">

<table cellpadding="4" align="center">

<?php

LabelGroupSelect("groupbymode");

echo ' <tr><td class="LabelColumn">' . gettext("Bulk Mail Presort") . '</td>';

echo ' <td class="TextColumn">';

echo ' <input name="bulkmailpresort" type="checkbox" onclick="codename()"';

echo ' id="BulkMailPresort" value="1" ';

if ($_COOKIE["bulkmailpresort"])

echo "checked";

echo ' ><br></td></tr>';

echo ' <tr><td class="LabelColumn">' . gettext("Quiet Presort") . '</td>';

echo ' <td class="TextColumn">';

echo ' <input ';

if (!$_COOKIE["bulkmailpresort"])

echo 'disabled '; // This would be better with $_SESSION variable

// instead of cookie ... (save $_SESSION in MySQL)

echo 'name="bulkmailquiet" type="checkbox" onclick="codename()"';

echo ' id="QuietBulkMail" value="1" ';

if ($_COOKIE["bulkmailquiet"] && $_COOKIE["bulkmailpresort"])

echo "checked";

echo ' ><br></td></tr>';

ToParentsOfCheckBox("toparents");

LabelSelect("labeltype");

FontSelect("labelfont");

FontSizeSelect("labelfontsize");

StartRowStartColumn();

IgnoreIncompleteAddresses();

LabelFileType();

?>

<tr>

<td></td>

<td><input type="submit" class="icButton" value="<?php echo gettext("Generate Labels");?>" name="Submit"></td>

</tr>

</table></form></td></tr></table>

<?php

// Only show CSV export link if user is allowed to CSV export.

if ($bExportCSV)

{

?>

<div align="center">

<form method="post" action="CartView.php">

<?php echo "<br><h2>" . gettext("Export Cart to CSV File") . "</h2>"; ?>

<input type="submit" class="icButton" name="cartcsv"

value="<?php echo gettext("Create CSV File");?>">

</form>

</div>

<?php

}

// Only show create directory link if user is allowed to create directories

if ($bCreateDirectory)

{

?>

<div align="center"><form method="get" action="DirectoryReports.php">

<?php echo "<br><h2>" . gettext("Create Directory From Cart") . "</h2>"; ?>

<input type="submit" class="icButton" name="cartdir"

value="<?php echo gettext("Cart Directory");?>">

</form></div>

<?php

}

if (($bEmailSend) && ($bSendPHPMail))

{

if (isset($email_array)) {

$bcc_list = "";

foreach ($email_array as $email_address) {

// Add all address except the default

// avoid sending to this address twice

if ($email_address != $sToEmailAddress) {

$bcc_list .= $email_address . ", ";

}

}

if ($sToEmailAddress) {

// append $sToEmailAddress

$bcc_list .= $sToEmailAddress;

} else {

// remove the last ", "

$bcc_list = substr($bcc_list, 0, strlen($bcc_list) - 2 );

}

}

$sEmailForm = ""; // Initialize to empty

?><div align="center"><table><tr><td align="center"><?php

echo "<br><h2>" . gettext("Send Email To People in Cart") . "</h2>";

// Check if there are pending emails that have not been delivered

// A user cannot send a new email until the previous email has been sent

$sSQL = "SELECT COUNT(emp_usr_id) as countjobs "

. "FROM email_message_pending_emp "

. "WHERE emp_usr_id='".$_SESSION['iUserID']."'";

$rsPendingEmail = RunQuery($sSQL);

$aRow = mysql_fetch_array($rsPendingEmail);

extract($aRow);

$sSQL = "SELECT COUNT(erp_usr_id) as countrecipients "

. "FROM email_recipient_pending_erp "

. "WHERE erp_usr_id='".$_SESSION['iUserID']."'";

$rsCountRecipients = RunQuery($sSQL);

$aRow = mysql_fetch_array($rsCountRecipients);

extract($aRow);

if ($countjobs) {

// There is already a message composed in MySQL

// Let's check and make sure it has not been sent.

$sSQL = "SELECT * FROM email_message_pending_emp "

. "WHERE emp_usr_id='".$_SESSION['iUserID']."'";

$rsPendingEmail = RunQuery($sSQL);

$aRow = mysql_fetch_array($rsPendingEmail);

extract($aRow);

if ($emp_to_send==0 && $countrecipients==0) {

// if both are zero the email job has not started. In this

// case the user may edit the email and/or change the distribution

// This user has no email messages stored MySQL

$sEmailSubject = stripslashes($_POST['emailsubject']);

$sEmailMessage = stripslashes($_POST['emailmessage']);

if (strlen($sEmailSubject.$sEmailMessage)) {

// User has edited a message. Update MySQL.

$sSQLu = "UPDATE email_message_pending_emp ".

"SET emp_subject='".mysql_real_escape_string($sEmailSubject)."',".

" emp_message='".mysql_real_escape_string($sEmailMessage)."' ".

"WHERE emp_usr_id='".$_SESSION['iUserID']."'";

RunQuery($sSQLu);

} else {

// Retrieve subject and message from MySQL

$rsPendingEmail = RunQuery($sSQL);

$aRow = mysql_fetch_array($rsPendingEmail);

extract($aRow);

$sEmailSubject = $emp_subject;

$sEmailMessage = $emp_message;

}

$sEmailForm = "sendoredit";

} else {

// This job has already started. The user may not change the message

// or the distribution once emails have actually been sent.

$sEmailForm = 'resumeorabort';

}

} elseif (isset($email_array)) {

// This user has no email messages stored MySQL

$sEmailSubject = stripslashes($_POST['emailsubject']);

$sEmailMessage = stripslashes($_POST['emailmessage']);

if (strlen($sEmailSubject.$sEmailMessage)) {

// User has written a message. Store it in MySQL.

// Since this is the first time use INSERT instead of UPDATE

$sSQL = "INSERT INTO email_message_pending_emp ".

"SET " .

"emp_usr_id='" .$_SESSION['iUserID']. "',".

"emp_to_send='0'," .

"emp_subject='" . mysql_real_escape_string($sEmailSubject). "',".

"emp_message='" . mysql_real_escape_string($sEmailMessage). "'";

RunQuery($sSQL);

$sEmailForm = 'sendoredit';

} else {

// There is no pending message. User may compose a new message.

$sEmailForm = 'compose';

}

}

if ($sEmailForm == 'compose') {

echo '<form method="post" action="EmailEditor.php">'."\n";

foreach ($email_array as $email_address) {

// Add all address except the default

// avoid sending to this address twice

if ($email_address != $sToEmailAddress) {

echo '<input type="hidden" name="emaillist[]" value="' .

$email_address . '">';

}

}

if ($sToEmailAddress) { // The default address gets the last email

echo '<input type="hidden" name="emaillist[]" value="'.$sToEmailAddress.'">'."\n";

}

echo '<input type="submit" class="icButton" name="submit" '.

'value ="'.gettext("Compose Email").'">'."\n</form>";

} elseif ($sEmailForm == 'sendoredit') {

//Print the From, To, and Email List with the Subject and Message

echo "\n</td></tr></table></div>\n";

echo "<hr>\r\n";

echo '<p class="MediumText"><b>'.gettext("From:").'</b> "'.$sFromName.'"';

echo ' &lt;'.$sFromEmailAddress.'&gt;<br>'."\n";

echo '<b>'.gettext("To (blind):").'</b> '.$bcc_list.'<br>'."\n";

echo '<b>'.gettext("Subject:").'</b> '.htmlspecialchars($sEmailSubject).'<br>';

echo '</p><hr><textarea cols="72" rows="20" readonly class="MediumText" ';

echo 'style="border:0px;">'. htmlspecialchars($sEmailMessage) . '</textarea><br>';

echo "<hr>\n";

// Create button to edit this message.

echo '<div align="center"><table><tr><td>'."\n";

echo '<form method="post" action="EmailEditor.php">'."\n";

foreach ($email_array as $email_address) {

// Add all address except the default

// avoid sending to this address twice

if ($email_address != $sToEmailAddress) {

echo '<input type="hidden" name="emaillist[]" value="' .

$email_address . '">';

}

}

if ($sToEmailAddress) { // The default address gets the last email

echo '<input type="hidden" name="emaillist[]" value="'.$sToEmailAddress.'">'."\n";

}

echo '<input type="hidden" name="mysql" value="true">'."\n";

echo '<input type="submit" class="icButton" name="submit" '.

'value ="'.gettext("Edit Email").'">'."\n</form>";

// Create button to send this message

echo "</td>\n<td>";

echo '<form method="post" action="EmailSend.php">'."\n";

foreach ($email_array as $email_address) {

// Add all address except the default

// avoid sending to this address twice

if ($email_address != $sToEmailAddress) {

echo '<input type="hidden" name="emaillist[]" value="' .

$email_address . '">';

}

}

if ($sToEmailAddress) { // The default address gets the last email

echo '<input type="hidden" name="emaillist[]" value="'.$sToEmailAddress.'">'."\n";

}

echo '<input type="hidden" name="mysql" value="true">'."\n";

echo '<input type="submit" class="icButton" name="submit" '.

'value ="'.gettext("Send Email").'">'."\n</form>";

// Create button to Delete this message

echo "</td>\n<td>";

echo '<form method="post" action="CartView.php">'."\n";

echo '<input type="hidden" name="rmEmail" value="true">'."\n";

echo '&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" class="icTinyButton" name="rmEail" '.

'value ="'.gettext("Delete Email").'">'."\n</form>";

} elseif ($sEmailForm == 'resumeorabort') {

// The user has two choices

echo "<table>\n<tr><td>";

echo 'The previous email did not succesfully complete. You may';

echo "</td></tr>\n<tr><td>";

echo '1 Resume at point of failure (no duplicates will be sent)';

echo "</td></tr>\n<tr><td>";

echo '2 Abort (discard everything)';

echo "</td></tr>\n<tr><td>";

echo '3 View Log';

echo "</td></tr>\n</table>";

// Create button to resume this job.

echo '<div align="center"><table><tr><td>'."\n";

echo '<form method="post" action="EmailSend.php">'."\n";

echo '<input type="hidden" name="resume" value="true">'."\n";

echo '<input type="submit" class="icButton" name="submit" '.

'value ="'.gettext("Resume").'">'."\n</form>";

// Create button to abort

echo "</td>\n<td>";

echo '<form method="post" action="EmailSend.php">'."\n";

// The default address gets the last email

echo '<input type="hidden" name="abort" value="true">'."\n";

echo '<input type="submit" class="icButton" name="submit" '.

'value ="'.gettext("Abort").'">'."\n</form>";

// Create button to view log

echo "</td>\n<td>";

echo '<form method="post" action="EmailSend.php">'."\n";

// The default address gets the last email

echo '<input type="hidden" name="viewlog" value="true">'."\n";

echo '<input type="submit" class="icButton" name="submit" '.

'value ="'.gettext("View Log").'">'."\n</form>";

} else { // ($sEmailForm == 'viewjobstatus')

//echo '<br>job status form goes here<br>';

echo "<br><br>";

echo "It has been $tTimeSinceLastAttempt seconds since the last email ";

echo "was attempted<br>\n";

echo "$iWaitTime seconds must elapse before sending another email.<br>\n";

$iComeBack = $iWaitTime - $tTimeSinceLastAttempt;

echo "Refresh this page in $iComeBack seconds.<br>\n";

$sSQL = 'SELECT * FROM email_job_log_'.$_SESSION['iUserID'].' '.

'ORDER BY ejl_id';

$rsEJL = RunQuery($sSQL, FALSE); // FALSE means do not stop on error

$sError = mysql_error();

if ($sError) {

echo '<br>'.$sError;

echo '<br>'.$sSQL;

} else {

$sHTMLLog = '<br><br><div align="center"><table>';

while ($aRow = mysql_fetch_array($rsEJL)) {

extract($aRow);

$sTime = date('i:s', intval($ejl_time)).'.';

$sTime .= substr($ejl_usec,0,3);

$sMsg = stripslashes($ejl_text);

$sHTMLLog .= '<tr><td>'.$sTime.'</td><td>'.$sMsg.'</td></tr>'."\n";

}

$sHTMLLog .= '</table></div>';

echo $sHTMLLog;

}

}

echo '<a name="email"></a>'; // anchor used by EmailEditor.php

echo "</td></tr></table></div>\n";

}

}

require "Include/Footer.php";

function rmEmail()

}

?>