Employees.php

<?php

/* Defines the employees that require timesheets */

include('includes/session.php');
$Title = _('Employee Maintenance');// Screen identification.
$ViewTopic = 'Labour';// Filename's id in ManualContents.php's TOC.
$BookMark = 'Employees';// Anchor's id in the manual's html document.

include('includes/header.php');

echo '<p class="page_title_text"><img alt="" src="', $RootPath, '/css/', $Theme,
	'/images/user.png" title="',// Icon image.
	_('Employee'), '" /> ',// Icon title.
	_('Employee Maintenance'), '</p>';// Page title.

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

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

	if(trim($_POST['Surname']) == '') {
		$InputError = 1;
		prnMsg(_('The employee\'s surname must not be empty'), 'error');
	}
	if($_POST['FirstName'] =='') {
		$InputError = 1;
		prnMsg(_('The employee\'s first name must not be empty'), 'error');
	}
	//end of checking the input

	if(isset($SelectedEmployee) AND $InputError !=1) {


		$SQL = "UPDATE employees SET surname='" . $_POST['Surname'] . "',
									firstname='" . $_POST['FirstName'] . "',
									stockid='" . $_POST['StockID'] . "',
									manager='" . $_POST['Manager'] . "',
									normalhours='" . $_POST['NormalHours'] . "',
									userid='" . $_POST['UserID'] . "',
									email='" . $_POST['Email'] . "'
						WHERE id = '" . $SelectedEmployee . "'";

		$ErrMsg = _('An error occurred updating the') . ' ' . $SelectedEmployee . ' ' . _('employee record because');
		$DbgMsg = _('The SQL used to update the employee record was');

		$Result = DB_query($SQL,$ErrMsg,$DbgMsg);

		prnMsg(_('The employee record has been updated'),'success');

	} elseif($InputError !=1) {

		/*SelectedEmployee is null cos no employee selected on first time round so must be adding a	record must be submitting a new employee form */

		$SQL = "INSERT INTO employees (	surname,
										firstname,
										stockid,
										manager,
										normalhours,
										userid,
										email )
						VALUES ('" . $_POST['Surname'] . "',
								'" . $_POST['FirstName'] . "',
								'" . $_POST['StockID'] . "',
								'" . $_POST['Manager'] . "',
								'" . $_POST['NormalHours'] . "',
								'" . $_POST['UserID'] . "',
								'" . $_POST['Email'] . "')";

		$ErrMsg = _('An error occurred inserting the new employee record because');
		$DbgMsg = _('The SQL used to insert the employee record was');
		$Result = DB_query($SQL,$ErrMsg,$DbgMsg);

		prnMsg(_('The new employee record has been added'),'success');

	}

	unset($_POST['Surname']);
	unset($_POST['FirstName']);
	unset($_POST['StockID']);
	unset($_POST['Manager']);
	unset($_POST['NormalHours']);
	unset($_POST['UserID']);
	unset($_POST['Email']);
	unset($SelectedEmployee);

} elseif(isset($_GET['delete'])) {
//the link to delete a selected record was clicked instead of the submit button

	$CancelDelete = 0;

// PREVENT DELETES IF DEPENDENT RECORDS
/* once timesheets are defined
	$SQL= "SELECT COUNT(*) FROM timesheets WHERE employeeid='". $SelectedEmployee . "'";
	$Result = DB_query($SQL);
	$MyRow = DB_fetch_row($Result);
	if($MyRow[0]>0) {
		$CancelDelete = 1;
		prnMsg(_('Cannot delete this employee because timesheets have been created for this person'),'warn');
		echo _('There are') . ' ' . $MyRow[0] . ' ' . _('timesheet records for this person');
	}
*/
	if(! $CancelDelete) {
		$Result = DB_query("DELETE FROM employees WHERE id='" . $SelectedEmployee . "'");

		prnMsg(_('Employee') . ' ' . $SelectedEmployee . ' ' . _('has been deleted') . '!', 'success');
		unset ($SelectedEmployee);
	}//end if Delete Location
	unset($SelectedEmployee);
	unset($_GET['delete']);
}
/*
echo '<br /> Selected employee = ' . $SelectedEmployee;
if (isset($SelectedEmployee)) {
	echo '<br /> Selected employee is actually set!!!!';
}
*/


if(!isset($SelectedEmployee)) {

/* It could still be the second time the page has been run and a record has been selected for modification - SelectedEmployee 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 employees 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 employees.id,
					employees.surname,
					employees.firstname,
					employees.stockid,
					employees.manager,
					employees2.firstname as managerfirstname,
					employees2.surname as managersurname,
					employees.normalhours,
					employees.email,
					employees.userid
			FROM employees LEFT JOIN employees AS employees2
			ON employees.manager=employees2.id";

	$Result = DB_query($SQL);
	if (DB_num_rows($Result) > 0) {
		echo '<table class="selection">
			<thead>
			<tr>
				<th class="SortedColumn">', _('ID'), '</th>
				<th class="SortedColumn">', _('First name'), '</th>
				<th class="SortedColumn">', _('Surname'), '</th>
				<th class="SortedColumn">', _('Type'), '</th>
				<th class="SortedColumn">', _('Manager'), '</th>
				<th class="SortedColumn">', _('Email'), '</th>
				<th class="noPrint" colspan="2">&nbsp;</th>
				</tr>
			</thead>
			<tbody>';

	while ($MyRow = DB_fetch_array($Result)) {

		echo '<tr class="striped_row">
				<td>', $MyRow['id'], '</td>
				<td>', $MyRow['firstname'], '</td>
				<td>', $MyRow['surname'], '</td>
				<td>', $MyRow['stockid'], '</td>
				<td>', $MyRow['managerfirstname'] . ' ' . $MyRow['managersurname'], '</td>
				<td><a href="mailto:', $MyRow['email'], '">', $MyRow['email'], '</a></td>
				<td class="noPrint"><a href="', htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?SelectedEmployee=', $MyRow['id'], '">' . _('Edit') . '</a></td>
				<td class="noPrint"><a href="', htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?SelectedEmployee=', $MyRow['id'], '&amp;delete=1" onclick="return confirm(\'' . _('Are you sure you wish to remove this employee?') . '\');">' . _('Delete') . '</a></td>
			</tr>';
		}
		//END WHILE LIST LOOP
		echo '</tbody></table>';
	} else {
		prnMsg(_('No employees have been set up yet'),'info');
	}
}

//end of ifs and buts!

echo '<br />';
if(isset($SelectedEmployee)) {
	echo '<a href="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '">' . _('Review Employees') . '</a>';
}
echo '<br />';



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

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

	if(isset($SelectedEmployee)) {
		//editing an existing Location

		$SQL = "SELECT id,
						surname,
						firstname,
						stockid,
						manager,
						normalhours,
						userid,
						email
				FROM employees
				WHERE employees.id='" . $SelectedEmployee . "'";

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

		$_POST['Surname'] = $MyRow['surname'];
		$_POST['FirstName'] = $MyRow['firstname'];
		$_POST['StockID'] = $MyRow['stockid'];
		$_POST['NormalHours'] = $MyRow['normalhours'];
		$_POST['Manager'] = $MyRow['manager'];
		$_POST['UserID'] = $MyRow['userid'];
		$_POST['Email'] = $MyRow['email'];

		echo '<input type="hidden" name="SelectedEmployee" value="' . $SelectedEmployee . '" />';

		echo '<fieldset>';
		echo '<legend>' . _('Amend Employee details') . '</legend>';
		echo '<field>
				<label for="SelectedEmployee">' . _('Employee Code') . ':</label>
				<fieldtext>' . $SelectedEmployee . '</fieldtext>
			</field>';
	} else {//end of if $SelectedEmployee only do the else when a new record is being entered
		if(!isset($_POST['LocCode'])) {
			$_POST['SelectedEmployee'] = '';
		}
		echo '<fieldset>
				<legend>' . _('New Employee details') . '</legend>';
	}
	if(!isset($_POST['Surname'])) {
		$_POST['Surname'] = '';
	}
	if(!isset($_POST['FirstName'])) {
		$_POST['FirstName'] = '';
	}
	if(!isset($_POST['StockID'])) {
		$_POST['StockID'] = ' ';
	}
	if(!isset($_POST['NormalHours'])) {
		$_POST['NormalHours'] = '40';
	}
	if(!isset($_POST['Manager'])) {
		$_POST['Manager'] = '';
	}
	if(!isset($_POST['UserID'])) {
		$_POST['UserID'] = '';
	}
	if(!isset($_POST['Email'])) {
		$_POST['Email'] = '';
	}

	echo '<field>
			<label for="FirstName">' . _('First Name') . ':' . '</label>
			<input type="text" name="FirstName" required="required" value="' . $_POST['FirstName'] . '" title="" size="21" maxlength="20" />
			<fieldhelp>' . _('Enter the employee\'s first name') . '</fieldhelp>
		</field>
		<field>
			<label for="Surname">' . _('Surname') . ':' . '</label>
			<input type="text" name="Surname" required="required" value="'. $_POST['Surname'] . '" title="" namesize="21" maxlength="20" />
			<fieldhelp>' . _('Enter the employee\'s surname') . '</fieldhelp>
		</field>

		<field>
			<label for="StockID">' . _('Labour Type') . ':</label>
			<select name="StockID" />';

	$LabourTypeItemsResult = DB_query("SELECT stockid, description FROM
										stockmaster INNER JOIN stockcategory
											ON stockmaster.categoryid = stockcategory.categoryid
										WHERE stockcategory.stocktype='L'
										ORDER BY stockid");
	while ($MyRow=DB_fetch_array($LabourTypeItemsResult)) {
		if($_POST['StockID']==$MyRow['stockid']) {
			echo '<option selected="selected" value="' , $MyRow['stockid'] , '">' , $MyRow['description'] , '</option>';
		} else {
			echo '<option value="' , $MyRow['stockid'] . '">' , $MyRow['description'] , '</option>';
		}
	}

	echo '</select>
		</field>
		<field>
			<label for="Email">', _('Email'), ':</label>
			<input id="Email" maxlength="55" name="Email" size="31" type="email" value="', $_POST['Email'], '" />
			<fieldhelp>', _('The email address should be an email format such as adm@weberp.org'), '</fieldhelp>
		</field>
		<field>
			<label for="NormalHours">' . _('Normal Weekly Hours') . ':' . '</label>
			<input class="number" type="text" name="NormalHours" value="' , $_POST['NormalHours'] , '" title="" size="3" maxlength="2" />
			<fieldhelp>' , _('Enter the employee\'s normal hours per week') , '</fieldhelp>
		</field>
		<field>
			<label for="Manager">' , _('Manager') , ':' , '</label>
			<select name="Manager" />';

	$ManagersResult = DB_query("SELECT id, CONCAT(firstname, ' ', surname) AS managername
								FROM employees
								WHERE id != '" . $SelectedEmployee . "'
								ORDER BY surname");
	if($_POST['Manager']==''){
		echo '<option selected="selected" value="0">' , _('Not Managed') , '</option>';
	} else {
		echo '<option value="0">' , _('Not Managed') , '</option>';
	}
	while ($MyRow=DB_fetch_array($ManagersResult)) {
		if($_POST['Manager']==$MyRow['id']) {
			echo '<option selected="selected" value="' , $MyRow['id'] , '">' , $MyRow['managername'] , '</option>';
		} else {
			echo '<option value="' , $MyRow['id'] , '">' , $MyRow['managername'] , '</option>';
		}
	}

	echo '</select>
		</field>';

	echo '<field>
			<label for="UserID">' , _('webERP User') , ':' , '</label>
			<select name="UserID" title=""/>';
	if($_POST['UserID']==''){
		echo '<option selected="selected" value="">' , _('Not a webERP User') , '</option>';
	} else {
		echo '<option value="">' , _('Not a webERP User') , '</option>';
	}
	$UsersResult = DB_query("SELECT userid, realname FROM www_users");
	while ($MyRow=DB_fetch_array($UsersResult)) {
		if($_POST['UserID']==$MyRow['userid']) {
			echo '<option selected="selected" value="' . $MyRow['userid'] . '">' . $MyRow['realname'] . '</option>';
		} else {
			echo '<option value="' . $MyRow['userid'] . '">' . $MyRow['realname'] . '</option>';
		}
	}
	echo '</select>
		<fieldhelp>' , _('Select the employee\'s system user account so when the user logs in to enter a time sheet the system knows the employee record to use') , '</fieldhelp>
	</field>';

	echo '</fieldset>
		<div class="centre">
			<input type="submit" name="submit" value="' , _('Enter Information') , '" />
		</div>
		</form>';

}//end if record deleted no point displaying form to add record

include('includes/footer.php');
?>