employee_actions.php

来自「这是一个用于资产管理的源码工具包」· PHP 代码 · 共 608 行 · 第 1/3 页

function employee_summary() {
	global $inactive;
	global $print_screen;
	global $hrcolor;
	global $emp_db;

	$PHP_SELF = $_SERVER['PHP_SELF'];
	employee_menu_header(false,"","Employees","");

	// tabs to show active or inactive employees
	echo "<p><table cellspacing=0 cellpadding=0 border=0><tr>";

	if ($inactive == "1") {
		$active = "0";
		if ($print_screen == false) echo "<td><a href='?action=employees' class='text11special'>Active</a></td>";
		else echo "<td><a href='?action=employees' class='text11special'><font color='#ffffff'>Active</font></a></td>";
		echo "<td><font class='text11specialactive' color='#000000'>Inactive</font></font></td>";
		$altcolor = false;
	} else {
		$active = "1";
		echo "<td><font class='text11specialactive' color='#000000'>Active</font></td>";
		if ($print_screen == false) echo "<td><a href='?action=employees&inactive=1' class='text11special'>Inactive</a></font></td>";
		$altcolor = true;
	}
	echo "</tr></table>";
	echo "<table width=100% bgcolor='#ffdddd'><tr><td>\n";
	echo "</td></tr></table>\n";
	


	echo "<table cellspacing=0 cellpadding=0 border=0 width=100% class='employeeborder' bgcolor='#ffeeee'><tr><td>";
	// display first row as General Assets for the active screen
	if ($active == 1) {
		echo "<table width=100% bgcolor='#ffeeee'><tr><td>\n";
		echo "<table width=100%><tr><td>\n";
		if ($print_screen == false) echo "<a href='" . $PHP_SELF . "?action=employeeview&key=0' class='text13bold'>General Assets</a><br>\n";
		else echo "<font class='text13bold'>General Assets<br>\n";
		echo "</td></tr></table>\n";
		echo "</td></tr></table>\n";	
	}
	
	// get all employees
	$color = "#ffffff";
	$sql = "SELECT LastName, FirstName, LoginName, Tel, Organization, Dept, Building, Floor, Workstation, EMail, Active, Id AS Employees_ID FROM " . $emp_db . "Employees WHERE Active=" . $active ." ORDER BY LastName;";
	if (($result = doSql($sql)) && (mysql_num_rows($result))) {
		while ($query_data = mysql_fetch_array($result)) {
			// employee listing			
			employee_format($query_data, $color, "#dddddd", "employeeborder");
			if ($color == "#ffffff") $color = "#ffeeee";
			else $color = "#ffffff";
		}
	}

	if (mysql_num_rows($result) != "0") echo "</td></tr></table><p><font class='text12'>" . mysql_num_rows($result) . " employee(s) listed.</font>";
	else echo "<br><blockquote><font class='text12'>There are no employees entered.</font></blockquote></td></tr></table>";

}



// List all assets for a specific employee
function employee_view($key) {
	global $action;
	global $hrcolor;
	global $addip;
	global $removeip;
	global $my_emp_id;
	global $my_access_level;
	global $print_screen;
	global $history;
	global $verify;
	global $useasset;
	global $addlicense;
	global $removelicense;
	global $emp_db;

	$PHP_SELF = $_SERVER['PHP_SELF'];
	// header, tabs, employee info
	if ($history != "1") $header_text = "Details";
	else $header_text = "History";

	$is_editable = (($my_access_level > 1) || ($my_emp_id == $key));

	// make changes to licenses
	if ($is_editable) {
		if ((strlen($addlicense) > 0) && ($useasset != "") && ($useasset != "0")) {
			$sql = "INSERT INTO LicenseOwners (AssetId, LicenseId) VALUES (" . $useasset . ",'" . $addlicense . "')";
			$result = doSql($sql);
		}
		if (strlen($removelicense) > 0) {
			$sql = "DELETE FROM LicenseOwners WHERE Id=" . $removelicense;
			$result = doSql($sql);
		}
	}


	// make changes to ips
	if ($is_editable) {
		if ($useasset == "") $useasset = "0";
		if ($addip != "") doSql("INSERT INTO IP (employeeid,assetid,ip) VALUES (" . $key . "," . $useasset . ",'" . $addip . "')");
		if ($removeip != "") doSql("DELETE FROM IP WHERE id=" . $removeip);
	}

	// update verified date, if a verification date took place
	if (($verify == 1) && ($my_emp_id == $key)) $result2 = doSql("UPDATE " . $emp_db . "Employees SET Verified=" . time() . " WHERE id=" . $key);
	$sql = "SELECT " . $emp_db . "Employees.LastName, " . $emp_db . "Employees.FirstName, " . $emp_db . "Employees.LoginName, " . $emp_db . "Employees.Tel, " . $emp_db . "Employees.Organization, " . $emp_db . "Employees.Dept, " . $emp_db . "Employees.Building, " . $emp_db . "Employees.Floor, " . $emp_db . "Employees.Workstation, " . $emp_db . "Employees.Active, " . $emp_db . "Employees.EMail, " . $emp_db . "Employees.Id AS Employees_ID, " . $emp_db . "Employees.Verified FROM " . $emp_db . "Employees WHERE " . $emp_db . "Employees.ID=" . $key . ";";

	if (($result = doSql($sql)) && ($query_data = mysql_fetch_array($result))) {
		employee_menu_header(true,"", $header_text, $key);
		employee_tabs($key);
		employee_format($query_data,"#ffeeee","#ffdddd", "employeeborder");

		// last verified box
		echo "<table width=100% bgcolor='#ffdddd'><tr>";
		if ($query_data["Verified"] == "0") $date_text = "Not Verified";
		else $date_text = date("F d, Y", $query_data["Verified"]) . " at " . date("h:i a", $query_data["Verified"]);
		echo "<td><font class='text11bold'>&nbsp;Last Verified:</font> <font class='text11'>" . $date_text . "</font></td>";
		if (($key == $my_emp_id) && ($print_screen == false)) echo "<td align='right'><font class='text11bold'>If the asset listing below is accurate, <a href='" . $PHP_SELF . "?action=employeeview&key=" . $key . "&verify=1' class='text11bold'>Verify Now</a>&nbsp;</font></td>";
		echo "</tr></table>\n";

	} else {
		if ($key == "-1") menu_header("","Surplus","surplus.jpg");
		elseif ($key == "-2") menu_header("","Retired","retired.jpg");
		else employee_menu_header(true,"", $header_text, $key);
	}

	// restrict content to dates on or after today for non-History view
	if ($history != "1") $dates_sql = " AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) AND Assignments.Completed=0";
	else $dates_sql = "";

	// add the word 'My' if we are the user is looking at their own assets	
	if ($my_emp_id == $key) $my_text = "My ";
	else $my_text = "";
	
	// seek transfers
	if (($key > -1) && ($print_screen == false)) echo "<p><table width=100%><tr>";
	$sql = "SELECT Assets.AssetTag, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel, Assets.AssetSerial, Assets.AssetPrice, Assets.os, Assets.Id AS Assets_ID, Assignments.EmployeeId AS Employees_ID, Assignments.StartDate, Assignments.EndDate, Assignments.Completed, Assignments.Id As Assignments_ID FROM Assignments LEFT JOIN Assets ON Assets.Id = Assignments.AssetId WHERE Assignments.EmployeeId=" . $key . " AND Assignments.Temp=0 AND Assignments.Approve=0 AND Assignments.Temp=0" . $dates_sql ." ORDER BY Assignments.StartDate;";
	if (($result = doSql($sql)) && (mysql_num_rows($result))) {
		if (($key > -1) && ($print_screen == false)) echo "<td valign='top'>";
		echo "<p><font class='text11'><b>" . $my_text . "Assets</b></font><br><hr size=0 color='" . $hrcolor . "'>";
		while ($query_data = mysql_fetch_array($result)) {
			$sql2 = "SELECT " . $emp_db . "Employees.LastName, " . $emp_db . "Employees.FirstName, " . $emp_db . "Employees.Tel, " . $emp_db . "Employees.Organization, " . $emp_db . "Employees.Dept, " . $emp_db . "Employees.Building, " . $emp_db . "Employees.Floor, " . $emp_db . "Employees.Workstation, Assignments.StartDate, Assignments.EndDate, Assignments.Completed, Assignments.Temp, Assignments.EmployeeID AS Employees_ID FROM Assignments LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeID = " . $emp_db . "Employees.Id WHERE Assignments.id=" . $query_data["Assignments_ID"];
			if (($result2 = doSql($sql2)) && (mysql_num_rows($result2))) $query_data2 = mysql_fetch_array($result2);
			asset_format($query_data,$query_data2,"#ffeeee","employeeborder",false);
			if ($print_screen == true) echo "<p>";
		}
		if ($print_screen == false) echo "<br><a href='" . $PHP_SELF . "?action=assetinsert' class='text11'><b>&raquo; New Asset...</b></a>";
		if ($print_screen == false) echo "<br><a href='" . $PHP_SELF . "?action=assets' class='text11'><b>&raquo; Find Asset...</b></a>";
		if (($print_screen == false) && ($my_access_level > 1)) echo "<br><a href='" . $PHP_SELF . "?action=reportsindividual&key=" . $key . "' class='text11'><b>&raquo; Download Report...</b></a>";
		if (($key > -1) && ($print_screen == false)) echo "</td>";
		$found_employee = true;
	} else {
		if (strcmp($key,"0") == 0) echo "<font class='text12'><blockquote>There are no general assets.</blockquote></font>";		
		elseif (strcmp($key,"-1") == 0) echo "<font class='text12'><blockquote>There are no assets assigned to surplus.</blockquote></font>";
		elseif (strcmp($key,"-2") == 0) echo "<font class='text12'><blockquote>There are no assets which are retired.</blockquote></font>";		
		else echo "<font class='text12'><blockquote>There are no assets assigned to this employee.</blockquote></font>";
		if ($print_screen == false) echo "<a href='" . $PHP_SELF . "?action=assetinsert' class='text11'><b>&raquo; New Asset...</b></a>";
		if ($print_screen == false) echo "<br><a href='" . $PHP_SELF . "?action=assets' class='text11'><b>&raquo; Find Asset...</b></a>";
		if (($print_screen == false) && ($my_access_level > 1)) echo "<br><a href='" . $PHP_SELF . "?action=reportsindividual&key=" . $key . "' class='text11'><b>&raquo; Download Report...</b></a>";
	}
	
	// seek signed out assets
	$sql = "SELECT Assets.AssetTag, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel, Assets.AssetSerial, Assets.AssetPrice, Assets.os, Assets.Id AS Assets_ID, Assignments.EmployeeId AS Employees_ID, Assignments.StartDate, Assignments.Completed, Assignments.EndDate, Assignments.Temp, " . $emp_db . "Employees.LastName, " . $emp_db . "Employees.FirstName, Assignments.Id AS Assignments_ID FROM ((Assignments LEFT JOIN Assets ON Assets.Id = Assignments.AssetId) LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeId = " . $emp_db . "Employees.Id) WHERE Assignments.EmployeeId=" . $key . " AND Assignments.Approve=0 AND Assignments.Temp=1" . $dates_sql . " ORDER BY Assignments.StartDate;";
	if (($key > 0) && ($result = doSql($sql)) && (mysql_num_rows($result))) {
		if (($found_employee == true) && ($key > -1) && ($print_screen == false)) echo "<td width=10>&nbsp;</td>";
		if (($key > -1) && ($print_screen == false)) echo "<td valign='top'>";
		echo "<p><font class='text11'><b>" . $my_text . "Sign Outs</b></font><br><hr size=0 color='" . $hrcolor . "'>";
		while ($query_data = mysql_fetch_array($result)) {
			$sql2 = "SELECT " . $emp_db . "Employees.LastName, " . $emp_db . "Employees.FirstName, " . $emp_db . "Employees.Tel, " . $emp_db . "Employees.Organization, " . $emp_db . "Employees.Dept, " . $emp_db . "Employees.Building, " . $emp_db . "Employees.Floor, " . $emp_db . "Employees.Workstation, Assignments.StartDate, Assignments.EndDate, Assignments.Completed, Assignments.Temp, Assignments.EmployeeID AS Employees_ID FROM Assignments LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeID = " . $emp_db . "Employees.Id WHERE Assignments.Id=" . $query_data["Assignments_ID"] . " ORDER BY Assignments.StartDate;";
			if (($result2 = doSql($sql2)) && (mysql_num_rows($result2))) $query_data2 = mysql_fetch_array($result2);
			asset_format($query_data,$query_data2,"#ffeeee","employeeborder",false);
			if ($print_screen == true) echo "<p>";
		}
		if (($key > -1) && ($print_screen == false)) echo "</td>";
	}
	if (($key > -1) && ($print_screen == false)) echo "</tr></table>";
	


	if ($history != "1") {


	// seek out licenses
		echo "<p><br>";
		echo "<table bgcolor='#ffeeee' cellpadding=5 class='employeeborder' width=100%><tr><td>";

		
		$sql = "SELECT Assets.AssetTag, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel, Assets.AssetSerial, Assets.AssetPrice, Assets.os, Assets.Id AS Assets_ID, Assignments.EmployeeId AS Employees_ID, Assignments.StartDate, Assignments.EndDate, Assignments.Completed, Assignments.Id As Assignments_ID, COUNT(DISTINCT LicenseOwners.Id) AS CountLicenses, LicenseOwners.licenseid, LicenseOwners.Id AS LicenseOwners_ID FROM (Assignments INNER JOIN Assets ON Assets.Id = Assignments.AssetId) INNER JOIN LicenseOwners ON LicenseOwners.assetid = Assets.Id WHERE Assignments.EmployeeId=" . $key . " AND Assignments.Temp=0 AND Assignments.Approve=0 AND Assignments.Temp=0 AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) AND Assignments.Completed=0 GROUP BY LicenseOwners.licenseid, Assets.Id ORDER BY LicenseOwners.licenseid";
		if (($result = doSql($sql)) && (mysql_num_rows($result))) {
			echo "<font class='text12bold'>" . $my_text . " Licenses</font><br><hr size=0 color='" . $hrcolor . "'>";
			echo "<table width=100% class='employeeborder'>";
			while ($query_data = mysql_fetch_array($result)) {
				echo "<tr><td class='text12bold' width=30%>";
				echo $query_data["licenseid"];
				if ($query_data["CountLicenses"] != "1") echo " (" . $query_data["CountLicenses"] . ")"; 
				echo "</td><td class='text12bold' width=40%>";
				echo "[" . $query_data["AssetType"] . " - " . $query_data["AssetModel"] . " " . $query_data["AssetSupplier"] . "]";
				echo "</td><td class='text12bold' width=30% align='right'>";
				if (($print_screen == false) && ($is_editable)) echo " <a href='" . $PHP_SELF . "?action=employeeview&key=" . $key . "&removelicense=" . $query_data["LicenseOwners_ID"] . "'>(remove)</a>";
				echo "</td></tr>";
			}
			echo "</table><p>";
		} else {