PaymentTerms.php

<?php
include ('includes/session.php');

$Title = _('Payment Terms Maintenance');

include ('includes/header.php');

echo '<p class="page_title_text" >
		<img src="', $RootPath, '/css/', $_SESSION['Theme'], '/images/money_add.png" title="', _('Payment Terms'), '" alt="" />', ' ', $Title, '
	</p>';

if (isset($_GET['SelectedTerms'])) {
	$SelectedTerms = $_GET['SelectedTerms'];
} elseif (isset($_POST['SelectedTerms'])) {
	$SelectedTerms = $_POST['SelectedTerms'];
}

if (isset($_POST['submit'])) {

	//initialise no input errors assumed initially before we test
	$InputError = 0;

	/* actions to take once the user has clicked the submit button
	 ie the page has called itself with some user input */
	$i = 1;

	//first off validate inputs are sensible
	if (mb_strlen($_POST['TermsIndicator']) < 1) {
		$InputError = 1;
		prnMsg(_('The payment terms name must exist'), 'error');
	}
	if (mb_strlen(stripslashes($_POST['TermsIndicator'])) > 2) {
		$InputError = 1;
		prnMsg(_('The payment terms name must be two characters or less long'), 'error');
	}
	if (empty($_POST['DayNumber']) or !is_numeric(filter_number_format($_POST['DayNumber'])) or filter_number_format($_POST['DayNumber']) <= 0) {
		$InputError = 1;
		prnMsg(_('The number of days or the day in the following month must be numeric'), 'error');
	}
	if (empty($_POST['Terms']) or mb_strlen($_POST['Terms']) > 40) {
		$InputError = 1;
		prnMsg(_('The terms description must be forty characters or less long'), 'error');
	}
	if ($_POST['DayNumber'] > 360 and !empty($_POST['DaysOrFoll'])) {
		$InputError = 1;
		prnMsg(_('When the check box is checked to indicate that the term expects a number of days after which accounts are due') . ', ' . _('the number entered should be less than 361 days'), 'error');
	}

	if (isset($SelectedTerms) and $InputError != 1) {

		/*SelectedTerms could also exist if submit had not been clicked this code would not run in this case cos submit is false of course  see the delete code below*/

		if (isset($_POST['DaysOrFoll']) and $_POST['DaysOrFoll'] == 'on') {
			$SQL = "UPDATE paymentterms SET
							terms='" . $_POST['Terms'] . "',
							dayinfollowingmonth=0,
							daysbeforedue='" . filter_number_format($_POST['DayNumber']) . "'
					WHERE termsindicator = '" . stripslashes($SelectedTerms) . "'";
		} else {
			$SQL = "UPDATE paymentterms SET
							terms='" . $_POST['Terms'] . "',
							dayinfollowingmonth='" . filter_number_format($_POST['DayNumber']) . "',
							daysbeforedue=0
						WHERE termsindicator = '" . stripslashes($SelectedTerms) . "'";
		}

		$Msg = _('The payment terms definition record has been updated') . '.';
	} else if ($InputError != 1) {

		/*Selected terms is null cos no item selected on first time round so must be adding a record must be submitting new entries in the new payment terms form */

		if (isset($_POST['DaysOrFoll']) and $_POST['DaysOrFoll'] == 'on') {
			$SQL = "INSERT INTO paymentterms (termsindicator,
								terms,
								daysbeforedue,
								dayinfollowingmonth)
						VALUES (
							'" . $_POST['TermsIndicator'] . "',
							'" . $_POST['Terms'] . "',
							'" . filter_number_format($_POST['DayNumber']) . "',
							0
						)";
		} else {
			$SQL = "INSERT INTO paymentterms (termsindicator,
								terms,
								daysbeforedue,
								dayinfollowingmonth)
						VALUES (
							'" . $_POST['TermsIndicator'] . "',
							'" . $_POST['Terms'] . "',
							0,
							'" . filter_number_format($_POST['DayNumber']) . "'
							)";
		}

		$Msg = _('The payment terms definition record has been added') . '.';
	}
	if ($InputError != 1) {
		//run the SQL from either of the above possibilites
		$Result = DB_query($SQL);
		prnMsg($Msg, 'success');
		unset($SelectedTerms);
		unset($_POST['DaysOrFoll']);
		unset($_POST['TermsIndicator']);
		unset($_POST['Terms']);
		unset($_POST['DayNumber']);
	}

} elseif (isset($_GET['delete'])) {
	//the link to delete a selected record was clicked instead of the submit button
	// PREVENT DELETES IF DEPENDENT RECORDS IN DebtorsMaster
	$SQL = "SELECT COUNT(*) FROM debtorsmaster WHERE debtorsmaster.paymentterms = '" . $SelectedTerms . "'";
	$Result = DB_query($SQL);
	$MyRow = DB_fetch_row($Result);
	if ($MyRow[0] > 0) {
		prnMsg(_('Cannot delete this payment term because customer accounts have been created referring to this term'), 'warn');
		echo '<br /> ' . _('There are') . ' ' . $MyRow[0] . ' ' . _('customer accounts that refer to this payment term');
	} else {
		$SQL = "SELECT COUNT(*) FROM suppliers WHERE suppliers.paymentterms = '" . $SelectedTerms . "'";
		$Result = DB_query($SQL);
		$MyRow = DB_fetch_row($Result);
		if ($MyRow[0] > 0) {
			prnMsg(_('Cannot delete this payment term because supplier accounts have been created referring to this term'), 'warn');
			echo '<br /> ' . _('There are') . ' ' . $MyRow[0] . ' ' . _('supplier accounts that refer to this payment term');
		} else {
			//only delete if used in neither customer or supplier accounts
			$SQL = "DELETE FROM paymentterms WHERE termsindicator='" . $SelectedTerms . "'";
			$Result = DB_query($SQL);
			prnMsg(_('The payment term definition record has been deleted') . '!', 'success');
		}
	}
	//end if payment terms used in customer or supplier accounts
	
}

if (!isset($SelectedTerms)) {

	/* It could still be the second time the page has been run and a record has been selected for modification - SelectedTerms will exist because it was sent with the new call. If its the first time the page has been displayed with no parameters
	then none of the above are true and the list of payment termss will be displayed with
	links to delete or edit each. These will call the same page again and allow update/input
	or deletion of the records*/

	$SQL = "SELECT termsindicator, terms, daysbeforedue, dayinfollowingmonth FROM paymentterms";
	$Result = DB_query($SQL);

	echo '<table>
			<thead>';
	echo '<tr>
			<th colspan="6"><h3>', _('Payment Terms.'), '</h3></th>
		</tr>';
	echo '<tr>
			<th class="SortedColumn">', _('Term Code'), '</th>
			<th class="SortedColumn">', _('Description'), '</th>
			<th>', _('Following Month On'), '</th>
			<th>', _('Due After (Days)'), '</th>
			<th colspan="2"></th>
		</tr>
	</thead>';

	echo '<tbody>';
	while ($MyRow = DB_fetch_array($Result)) {

		if ($MyRow['dayinfollowingmonth'] == 0) {
			$FollMthText = _('N/A');
		} else {
			$FollMthText = $MyRow['dayinfollowingmonth'] . _('th');
		}

		if ($MyRow['daysbeforedue'] == 0) {
			$DueAfterText = _('N/A');
		} else {
			$DueAfterText = $MyRow['daysbeforedue'] . ' ' . _('days');
		}

		echo '<tr class="striped_row">
				<td>', $MyRow['termsindicator'], '</td>
				<td>', $MyRow['terms'], '</td>
				<td>', $FollMthText, '</td>
				<td>', $DueAfterText, '</td>
				<td><a href="', htmlspecialchars(basename(__FILE__), ENT_QUOTES, 'UTF-8'), '?SelectedTerms=', urlencode($MyRow[0]), '">', _('Edit'), '</a></td>
				<td><a href="', htmlspecialchars(basename(__FILE__), ENT_QUOTES, 'UTF-8'), '?SelectedTerms=', urlencode($MyRow[0]), '&amp;delete=yes" onclick="return MakeConfirm(\'', _('Are you sure you wish to delete this payment term?'), '\', \'Confirm Delete\', this);">', _('Delete'), '</a></td>
			</tr>';

	} //END WHILE LIST LOOP
	echo '</tbody>
		</table>';
} //end of ifs and buts!
if (isset($SelectedTerms)) {
	echo '<div class="centre">
			<a href="', htmlspecialchars(basename(__FILE__), ENT_QUOTES, 'UTF-8'), '">', _('Show all Payment Terms Definitions'), '</a>
		</div>';
}

if (!isset($_GET['delete'])) {

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

	if (isset($SelectedTerms)) {
		//editing an existing payment terms
		$SQL = "SELECT termsindicator,
						terms,
						daysbeforedue,
						dayinfollowingmonth
					FROM paymentterms
					WHERE termsindicator='" . $SelectedTerms . "'";

		$Result = DB_query($SQL);
		$MyRow = DB_fetch_array($Result);

		$_POST['TermsIndicator'] = $MyRow['termsindicator'];
		$_POST['Terms'] = $MyRow['terms'];
		$DaysBeforeDue = $MyRow['daysbeforedue'];
		$DayInFollowingMonth = $MyRow['dayinfollowingmonth'];

		echo '<input type="hidden" name="SelectedTerms" value="', $SelectedTerms, '" />';
		echo '<input type="hidden" name="TermsIndicator" value="', $_POST['TermsIndicator'], '" />';
		echo '<fieldset>
				<legend>', _('Edit Payment Terms'), '</legend>
				<field>
					<label for="TermsIndicator">', _('Term Code'), ':</label>
					<div class="fieldtext">', $_POST['TermsIndicator'], '</fieldtext>
				</field>';

	} else { //end of if $SelectedTerms only do the else when a new record is being entered
		if (!isset($_POST['TermsIndicator'])) $_POST['TermsIndicator'] = '';
		if (!isset($DaysBeforeDue)) {
			$DaysBeforeDue = 0;
		}
		//if (!isset($DayInFollowingMonth)) $DayInFollowingMonth=0;
		unset($DayInFollowingMonth); // Rather unset for a new record
		if (!isset($_POST['Terms'])) {
			$_POST['Terms'] = '';
		}

		echo '<fieldset>
				<legend>', _('New Payment Terms'), '</legend>
				<field>
					<label for="TermsIndicator">', _('Term Code'), ':</label>
					<input type="text" name="TermsIndicator" value="', $_POST['TermsIndicator'], '" size="3" autofocus="autofocus" required="required" maxlength="2" />
					<fieldhelp>', _('Enter the two character code for this payment terms definition'), '</fieldhelp>
				</field>';
	}

	echo '<field>
			<label for="Terms">', _('Terms Description'), ':</label>
			<input type="text" name="Terms" autofocus="autofocus" value="', $_POST['Terms'], '" size="35" required="required" maxlength="40" />
			<fieldhelp>', _('Enter a description by which this payment terms definition will be known.'), '</fieldhelp>
		</field>';

	echo '<field>
			<label for="DaysOrFoll">', _('Due After A Given No. Of Days'), ':</label>';
	if (isset($DayInFollowingMonth) and !$DayInFollowingMonth) {
		echo '<input type="checkbox" name="DaysOrFoll" checked=="checked  />';
	} else {
		echo '<input type="checkbox" name="DaysOrFoll"  />';
	}

	echo '<fieldhelp>', _('If payment is to be due after a certain number of days then tick this box.'), '</fieldhelp>
		</field>';

	echo '<field>
			<label for="DayNumber">', _('Days (Or Day In Following Month)'), ':</label>';;
	if ($DaysBeforeDue != 0) {
		echo '<input type="text" name="DayNumber" maxvalue="30" class="number" size="3" maxlength="3" value="', locale_number_format($DaysBeforeDue, 0), '" />';
	} else {
		if (isset($DayInFollowingMonth)) {
			echo '<input type="text" name="DayNumber" maxvalue="30" class="number" size="3" maxlength="3" value="', locale_number_format($DayInFollowingMonth, 0), '" />';
		} else {
			echo '<input type="text" name="DayNumber" maxvalue="30" class="number" size="3" maxlength="3" value="0" />';
		}
	}
	echo '<fieldhelp>', _('The number of days credit, or the day of the appropriate month when payment is due.'), '</fieldhelp>
		</field>';

	echo '</fieldset>';
	echo '<div class="centre">
			<input type="submit" name="submit" value="', _('Enter Information'), '" />
		</div>';
	echo '</form>';
} //end if record deleted no point displaying form to add record
include ('includes/footer.php');
?>