EmailCustStatements.php

<?php
/* $Id: EmailCustTrans.php 6310 2013-08-29 10:42:50Z daintree $*/

include ('includes/session.php');
include ('includes/SQL_CommonFunctions.php');
if (!isset($_GET['FromCust'])) {
	$_GET['FromCust'] = $_SESSION['CustomerID'];
}
$Title = _('Email Customer Statement For Customer No.') . ' ' . $_GET['FromCust'];

if (isset($_POST['DoIt']) and IsEmailAddress($_POST['EmailAddr'])) {
	echo '<meta http-equiv="Refresh" content="0; url=' . $RootPath . '/PrintCustStatements.php?FromCust=' . $_SESSION['CustomerID'] . '&ToCust=' . $_SESSION['CustomerID'] . '&PrintPDF=Yes&Email=' . $_POST['EmailAddr'] . '">';
	prnMsg(_('The customer statement should have been emailed off') . '. ' . _('If this does not happen') . ' (' . _('if the browser does not support META Refresh') . ')' . '<a href="' . $RootPath . '/PrintCustStatements.php?FromCust=' . $_SESSION['CustomerID'] . '&PrintPDF=Yes&Email=' . $_POST['EmailAddr'] . '">' . _('click here') . '</a> ' . _('to email the customer statement'), 'success');
	exit;
} elseif (isset($_POST['DoIt'])) {
	prnMsg(_('The email address does not appear to be a valid email address. The statement was not emailed'), 'warn');
}
include ('includes/header.php');

echo '<form action="' . htmlspecialchars(basename(__FILE__), ENT_QUOTES, 'UTF-8') . '" method="post">';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';

$SQL = "SELECT custbranch.email
		FROM custbranch
		INNER JOIN debtorsmaster
			ON custbranch.debtorno= debtorsmaster.debtorno
		WHERE debtorsmaster.debtorno='" . $_SESSION['CustomerID'] . "' LIMIT 1";

$ErrMsg = _('There was a problem retrieving the contact details for the customer');
$ContactResult = DB_query($SQL, $ErrMsg);

if (DB_num_rows($ContactResult) > 0) {
	$EmailAddrRow = DB_fetch_row($ContactResult);
	$EmailAddress = $EmailAddrRow[0];
} else {
	$EmailAddress = '';
}

echo '<table>
		<tr>
			<td>' . _('Email to') . ':</td>
			<td><input type="email" name="EmailAddr" autofocus="autofocus" maxlength="60" size="60" value="' . $EmailAddress . '" /></td>
		</tr>
	</table>';

echo '<div class="centre">
		<input type="submit" name="DoIt" value="' . _('OK') . '" />
	</div>';
echo '</form>';
include ('includes/footer.php');
?>