employee_actions.php

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

			echo "<font class='text12bold'>" . $my_text . " Licenses</font><br><hr size=0 color='" . $hrcolor . "'>";
			echo "<table width=100%>";
			echo "<tr>";
			echo "<td class='text12bold'>";
			echo "No licenses are assigned.";
			echo "</td>";
			echo "</tr>";
			echo "</table>";
		}

		// show the add license form
		if (($print_screen == false) && ($is_editable)) {
			echo "<center>";
			echo "<p><table cellspacing=0 cellpadding=0 border=0><tr><td><form action='" . $PHP_SELF . "' method='get'></td></tr></table>";
			echo "<input type='hidden' name='action' value='employeeview'>";
			echo "<input type='hidden' name='key' value='" . $key . "'>";
			echo "<font class='text13bold'>New: </font>";
			echo "<select name='addlicense' class='boxtext13'>";
			$sql = "SELECT manufacturer, product FROM Licenses GROUP BY product ORDER BY product";
			echo "<option value='' SELECTED>(Select A Product)</option>";
			if (($result = doSql($sql)) && (mysql_num_rows($result))) {
				while ($query_data = mysql_fetch_array($result)) {
					echo "<option value='" . $query_data["product"] . "' class='text12'>" . $query_data["manufacturer"] . " " . $query_data["product"] . "</option>";
				}
			}
			echo "</select>";
			echo "<font class='text13'>&nbsp;</font>";
			echo "<select name='useasset' class='boxtext13'>";
			echo "<option value='' SELECTED>(Select An Asset)</option>";
			$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 AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) AND Assignments.Completed=0 ORDER BY Assignments.StartDate;";
			if (($result = doSql($sql)) && (mysql_num_rows($result))) {
				while ($query_data = mysql_fetch_array($result)) {
					echo "<option value='" . $query_data["Assets_ID"] . "'>is licensed to " . strtolower($my_text) . " " . $query_data["AssetType"] . " (" . $query_data["AssetSupplier"] . ") " . $query_data["AssetModel"] . "</option>";
				}
			}
			echo "</select>";
			echo "<input type='image' src='images/add.jpg' border=0 width=88 height=27>";
			echo "<table cellspacing=0 cellpadding=0 border=0><tr><td></form></td></tr></table>";
			echo "</center>";
		}

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



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

		// show current ips
		$sql = "SELECT IP.id as IP_ID, Assets.id as Assets_ID, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel, IP.ip, IP.assetid FROM IP LEFT JOIN Assets ON IP.assetid = Assets.Id WHERE employeeid=" . $key;
		if (($result = doSql($sql)) && (mysql_num_rows($result))) {
			echo "<font class='text12bold'>" . $my_text . " IPs</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["ip"];
				echo "</td><td class='text12bold' width=40%>";
				if (strcmp($query_data["assetid"], "0") == 0) echo "<font class='text12'> [Unused IP]</font>";
				else echo "<font class='text12'> [" . $query_data["AssetType"] . " - " . $query_data["AssetSupplier"] . " " . $query_data["AssetModel"] . "]</font>";
				echo "</td><td class='text12bold' width=30% align='right'>";
				if ($print_screen == false) echo " <a href='" . $PHP_SELF . "?action=employeeview&key=" . $key . "&removeip=" . $query_data["IP_ID"] . "'>(remove)</a>";
				echo "</td></tr>";
			}
			echo "</table><p>";
		} else {
			echo "<font class='text12bold'>" . $my_text . " IPs</font><br><hr size=0 color='" . $hrcolor . "'>";
			echo "<table width=100%>";
			echo "<tr>";
			echo "<td class='text12bold'>";
			echo "No IPs are assigned.";
			echo "</td>";
			echo "</tr>";
			echo "</table>";
		}



		// show the add ip form
		if (($print_screen == false) && (($my_access_level > 1) || ($my_emp_id == $key))) {
			echo "<center>";
			echo "<table cellspacing=0 cellpadding=0 border=0><tr><td><form action='" . $PHP_SELF . "' method='get'></td></tr></table>";
			echo "<input type='hidden' name='action' value='employeeview'>";
			echo "<input type='hidden' name='key' value='" . $key . "'>";
			echo "<font class='text13bold'>New: </font>";
			echo "<input type='text' name='addip' class='boxtext13' size=15>";
			echo "<font class='text13'>&nbsp;</font>";
			echo "<select name='useasset' class='boxtext13'>";
			echo "<option value='0'>is an unused IP Address</option>";
			$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 AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) AND Assignments.Completed=0 ORDER BY Assignments.StartDate;";
			if (($result = doSql($sql)) && (mysql_num_rows($result))) {
				while ($query_data = mysql_fetch_array($result)) {
					echo "<option value='" . $query_data["Assets_ID"] . "'>is assigned to " . strtolower($my_text) . " " . $query_data["AssetType"] . " (" . $query_data["AssetSupplier"] . ") " . $query_data["AssetModel"] . "</option>";
				}
			}
			echo "</select>";
			echo "<font class='text13'>&nbsp;</font>";
			echo "<input type='image' src='images/add.jpg' border=0 width=88 height=27>";
			echo "<table cellspacing=0 cellpadding=0 border=0><tr><td></form></td></tr></table>";
			echo "</center>";
		}

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

	}
	echo "<p><br>";
}

// shows the top header bar
function employee_menu_header($domain, $section, $title, $key) {
	global $print_screen;
	global $hrcolor;
	global $emp_db;

	$PHP_SELF = $_SERVER['PHP_SELF'];
	// section
	if ($print_screen == false) {
		if ($domain == true) $top = "<a href='" . $PHP_SELF . "?action=employees' class='text10bold'>Employees</a>";
		else $top = "";

		// look up active employee	
		if (strlen($key) > 0) {
			switch($key) {
				case "0":
					$full_name = "General Assets";
					break;
				case "-1":
					$full_name = "Surplus";
					break;
				case "-2":
					$full_name = "Retired";
					break;
				default:
					$sql = "SELECT id, LastName, FirstName FROM " . $emp_db . "Employees WHERE id=" . $key;
					if ($result = doSql($sql)) {
						$query_data = mysql_fetch_array($result);
						$full_name = $query_data["LastName"] . ", " . $query_data["FirstName"];
					} else {
						$full_name = "";
					}
					break;
			}
			$top = $top . ": <a href='" . $PHP_SELF . "?action=employeeview&key=" . $key . "' class='text10bold'>" . $full_name . "</a>";
		}

		if (strlen($section) > 0) $top = $top . ": " . $section;
	}
	
	menu_header($top,$title,"employees.jpg");
}

// prints out the top tabs
function employee_tabs($empid) {
	global $action;
	global $history;
	global $print_screen;
	global $my_access_level;
	global $my_emp_id;
	global $emp_db;
	
	if (($empid != "") && ($print_screen == false) && ($my_access_level > 0)) {
		echo "<p>";
		
		echo "<table cellspacing=0 cellpadding=0 border=0><tr>";

		// details
		if ((strcmp($action,"employeeview") == 0) && ($history != "1")) echo "<td><font class='text11specialactive' color='#000000'>Details</font></td>";
		else echo "<td><a href='" . $PHP_SELF . "?action=employeeview&key=" . $empid . "' class='text11special'>Details</a></td>";

		// update
		if (($my_access_level > 1) || (($my_access_level > 0) && ($my_emp_id == $empid))) {
			if (strcmp($action,"employeeupdate") == 0) echo "<td><font class='text11specialactive' color='#000000'>Update</font></td>";
			else echo "<td><a href='" . $PHP_SELF . "?action=employeeupdate&key=" . $empid . "' class='text11special'>Update</a></font></td>";
		} else {
			echo "<td><font class='text11special2' color='#cccccc'>Update</font></td>";
		}

		// history		
		if ((strcmp($action,"employeeview") == 0) && ($history == "1")) echo "<td><font class='text11specialactive' color='#000000'>History</font></td>";
		else echo "<td><a href='" . $PHP_SELF . "?action=employeeview&key=" . $empid . "&history=1' class='text11special'>History</a></td>";

		// erase
		if (($my_access_level > 1) && ($empid > 0)) {
			if (strcmp($action,"employeeerase") == 0) echo "<td><font class='text11specialactive' color='#000000'>Erase</font></td>";
			else echo "<td><a href='" . $PHP_SELF . "?action=employeeerase&key=" . $empid . "' class='text11special'>Erase</a></td>";
		}
		echo "</tr></table>";
		
		echo "<table width=100% bgcolor='#ffdddd'><tr><td>\n";
		echo "</td></tr></table>\n";
	}
}

// load the data for one employee
function employee_print_info($key) {
	global $emp_db;
	$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 FROM " . $emp_db . "Employees WHERE " . $emp_db . "Employees.ID=" . $key . ";";
	if (($result = doSql($sql)) && ($query_data = mysql_fetch_array($result))) employee_format($query_data,"#ffeeee","#ffdddd", "employeeborder");
}

?>