asset_actions.php

这是一个用于资产管理的源码工具包

					if ($print_screen == false) echo "<font class='text11bold'><a href='" . $PHP_SELF . "?action=employeeview&key=" . $query_data2["Employees_ID"] . "'><b>Retired</b></a></font>\n";
					else echo "<font class='text11bold'><b>Retired</b></font>\n";
					break;
				default:
					if ($print_screen == false) echo "<font class='text11bold'><a href='" . $PHP_SELF . "?action=employeeview&key=" . $query_data2["Employees_ID"] . "'><b>" . $query_data2["LastName"] . ", " . $query_data2["FirstName"] . "</b></a></font>";
					else echo "<font class='text11bold'><b>" . $query_data2["LastName"] . ", " . $query_data2["FirstName"] . "</b></font>\n";
					if (($query_data2["Building"] != "") || ($query_data2["Floor"] != "")) echo "<font class='text11'>  - " . $query_data2["Building"] . " " . $query_data2["Floor"] . "</font>";
					if ($query_data2["Workstation"] != "") echo "<font class='text11'>-" . $query_data2["Workstation"] . "</font>\n";

					break;
			}

			$day_now = date("d",time());
			$month_now = date("m",time());
			$year_now = date ("Y",time());
			$new_time = mktime(0,0,0,$month_now,$day_now,$year_now);

			if ($query_data2["Temp"] == "0") {
				if ($is_report == true) {
				} else {
					if ($query_data2["StartDate"] > $new_time) echo "<font class='text11bold'><br>(Upcoming Owner)</font>\n";
					elseif (($query_data2["EndDate"] < $new_time) && ($query_data2["EndDate"] != 0)) echo "<font class='text11bold'><br>(Previous Owner)</font>\n";
					else echo "<font class='text11bold'><br>(Current Owner)</font>\n";
				}
			}
		}
	}
	
	echo "</td></tr>\n";
	echo "</table>";
}

// generates a listing of all valid entries and the number of occurrences in one area
function asset_summary($field, $name) {
	global $action;

	$PHP_SELF = $_SERVER['PHP_SELF'];
	// set whether to show active or inactive employees
	echo "<p>";
	echo "<table cellspacing=0 cellpadding=0 border=0><tr>";
	// types
	if (strcmp($action,"assets") == 0) echo "<td><font class='text11special2active' color='#000000'>Types</font></td>";
	else echo "<td><a href='" . $PHP_SELF . "?action=assets' class='text11special2'>Types</a></td>";
	// suppliers
	if (strcmp($action,"assetsupplier") == 0) echo "<td><font class='text11special2active' color='#000000'>Suppliers</font></td>";
	else echo "<td><a href='" . $PHP_SELF . "?action=assetsupplier' class='text11special2'>Suppliers</a></td>";
	// operating systems
	if (strcmp($action,"assetos") == 0) echo "<td><font class='text11special2active' color='#000000'>Operating Systems</font></td>";
	else echo "<td><a href='" . $PHP_SELF . "?action=assetos' class='text11special2'>Operating Systems</a></td>";
	echo "</tr></table>";
	echo "<table width=100% bgcolor='#ffeecc'><tr><td>\n";
	echo "</td></tr></table>\n";

	// do the summary
	$sql = "SELECT count(DISTINCT Assets.id) AS InvCount, Assets." . $field . " as InvField FROM Assets INNER JOIN Assignments ON Assets.Id = Assignments.AssetId WHERE Assignments.EmployeeId > -1 AND Assignments.Temp=0 AND Assignments.Approve=0 AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) GROUP BY Assets." . $field . " ORDER BY InvCount DESC";
	if (($result = doSql($sql)) && (mysql_num_rows($result))) {
		$num_results = mysql_num_rows($result);
		$color = "#ffffee";
		while ($query_data = mysql_fetch_array($result)) {
			// if there is more than one of a certain type and the type is not blank, print it out
			if (($query_data["InvCount"] != "0") && (strlen($query_data["InvField"]) > 0)) {
			
				echo "<table width=100% bgcolor='" . $color . "' class='assetborder' cellpadding=5>";
				echo "<tr><td>";
				echo "<a href='" . $PHP_SELF . "?action=" . $action . "&key=" . html($query_data["InvField"]) . "' class='text11bold'>" . $query_data["InvField"] . " (" . $query_data["InvCount"] . ")</a>";
				echo "</td></tr>";
				echo "</table>";
				if ($color == "#ffffee") $color = "#ffffff";
				else $color = "#ffffee";

			}
			else $num_results--;
		}
		echo "<p><br><font class='text12'>" . $num_results . " " . $name . "(s) found.</font>";
	} else {
		echo "<table width=100% class='assetborder' bgcolor='#ffffee'><tr><td>";
		echo "<br><blockquote><font class='text12'>There are no " . $name. "s entered.</font></blockquote>";
		echo "</td></tr></table>\n";
	}
	
}

// List all assets for a specific type based on given assettype, supplier, or os
function asset_query($key, $field, $name) {
	global $action;
	global $hrcolor;
	global $emp_db;
		
	$PHP_SELF = $_SERVER['PHP_SELF'];
	// set whether to show active or inactive employees
	echo "<p>";
	echo "<table cellspacing=0 cellpadding=0 border=0><tr>";
	// types
	if (strcmp($action,"assets") == 0) echo "<td><font class='text11special2active' color='#000000'>Types</font></td>";
	else echo "<td><a href='" . $PHP_SELF . "?action=assets' class='text11special2'>Types</a></td>";
	// suppliers
	if (strcmp($action,"assetsupplier") == 0) echo "<td><font class='text11special2active' color='#000000'>Suppliers</font></td>";
	else echo "<td><a href='" . $PHP_SELF . "?action=assetsupplier' class='text11special2'>Suppliers</a></td>";
	// operating systems
	if (strcmp($action,"assetos") == 0) echo "<td><font class='text11special2active' color='#000000'>Operating Systems</font></td>";
	else echo "<td><a href='" . $PHP_SELF . "?action=assetos' class='text11special2'>Operating Systems</a></td>";
	echo "</tr></table>";
	echo "<table width=100% bgcolor='#ffeecc'><tr><td>\n";
	echo "</td></tr></table>\n";

	$sql = "SELECT Assets.AssetTag, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel, Assets.AssetSerial, Assets.AssetPrice, Assets.os, Assets.Id As Assets_ID FROM Assets WHERE Assets." . $field . "='" . $key . "' ORDER BY Assets.AssetType;";
	$color = "#ffffee";
	if (($result = doSql($sql)) && (mysql_num_rows($result))) {
		$num_results = mysql_num_rows($result);

		while ($query_data = mysql_fetch_array($result)) {
			// prints out assets which are not surplus or retired
			$sql2 = "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 FROM Assignments LEFT JOIN Assets ON Assets.Id = Assignments.AssetId WHERE Assignments.AssetId=" . $query_data["Assets_ID"] . " AND Assignments.Temp=0 AND Assignments.Approve=0 AND Assignments.Temp=0 AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) ORDER BY Assignments.StartDate;";
			if (($result2 = doSql($sql2)) && (mysql_num_rows($result2)) && ($query_data2 = mysql_fetch_array($result2)) && ($query_data2["Employees_ID"] < 0)) {
				$num_results--;
			} else {
				$sql3 = "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.Temp, Assignments.EmployeeID AS Employees_ID FROM Assignments LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeID = " . $emp_db . "Employees.Id WHERE Assignments.AssetId=" . $query_data["Assets_ID"] . " AND Assignments.Temp=0 AND Assignments.Approve=0 AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) ORDER BY Assignments.StartDate;";
				if (($result3 = doSql($sql3)) && (mysql_num_rows($result2))) $query_data3 = mysql_fetch_array($result3);
				asset_format($query_data,$query_data3,$color,"assetborder",false);
				if ($color == "#ffffee") $color = "#ffffff";
				else $color = "#ffffee";
			}
		}
		echo "<br>\n";
		echo "<p><font class='text12'>" . $num_results . " asset(s) listed.</font>";
	} else {
		echo "<font class='text12'><blockquote>There are no assets listed.</blockquote></font>";
	}
}

// List all the details of one asset
function asset_view($key) {
	global $hrcolor;
	global $print_screen;
	global $history;
	global $addlicense;
	global $removelicense;
	global $my_emp_id;
	global $my_access_level;
	global $addip;
	global $removeip;
	global $emp_db;
	
	$PHP_SELF = $_SERVER['PHP_SELF'];
	// header, tabs, employee info
	if ($history != "1") $header_text = "Details";
	else $header_text = "History";
	$result_found_flag = false;

	// load the current owner of the asset
	$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.Temp, Assignments.EmployeeID AS Employees_ID FROM Assignments LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeID = " . $emp_db . "Employees.Id WHERE Assignments.AssetId=" . $key . " AND Assignments.Temp=0 AND Assignments.Approve=0 AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) ORDER BY Assignments.StartDate;";
	if (($result2 = doSql($sql2)) && (mysql_num_rows($result2)) && $query_data2 = mysql_fetch_array($result2)) {
		$emp_owner = $query_data2["Employees_ID"];
		$is_editable = (($my_access_level > 1) || ($emp_owner == $my_emp_id));
	} else {
		$emp_owner = "0";
		$is_editable = false;
	}

	if ($is_editable) {
		if (strlen($addlicense) > 0) {
			$sql = "INSERT INTO LicenseOwners (AssetId, LicenseId) VALUES (" . $key . ",'" . $addlicense . "')";
			$result = doSql($sql);
		}
		if (strlen($removelicense) > 0) {
			$sql = "DELETE FROM LicenseOwners WHERE AssetId=" . $key . " AND Id=" . $removelicense;
			$result = doSql($sql);
		}
	}
		
	asset_menu_header(true,"",$header_text,$key);
	
	// select the desired assets
	$sql = "SELECT Assets.AssetTag, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel, Assets.AssetSerial, Assets.AssetPrice, Assets.os, Assets.Id AS Assets_ID, Assets.Notes FROM Assets WHERE Assets.Id=" . $key . ";";
	if (($result = doSql($sql)) && (mysql_num_rows($result)) && ($query_data = mysql_fetch_array($result))) {
	

		asset_tabs($key);
		asset_format($query_data,$query_data2,"#ffffee","assetborder",false);
	
		if ($print_screen == false) echo "<p><table width=100%><tr>";

		if ($history != "1") $dates_sql = " AND (Assignments.EndDate >= " . time() . " OR Assignments.EndDate = 0) AND Assignments.Completed=0";
		else $dates_sql = "";
		$notes = $query_data["Notes"];
		
		// transfers (move to another person)
		$sql2 = "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.EMail, " . $emp_db . "Employees.Active, Assignments.Id AS Assignments_ID, Assignments.Temp, Assignments.StartDate, Assignments.EndDate, Assignments.Completed, Assignments.EmployeeID AS Employees_ID FROM Assignments LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeID = " . $emp_db . "Employees.Id WHERE Assignments.AssetId=" . $query_data["Assets_ID"] . $dates_sql . " AND Assignments.Temp=0 AND Assignments.Approve=0 ORDER BY Assignments.StartDate;";
		if (($result2 = doSql($sql2)) && (mysql_num_rows($result2))) {
			if ($print_screen == false) echo "<td valign='top'>";
			echo "<p><font class='text11'><b>Assignments</b></font><br><hr size=0 color='" . $hrcolor . "'>";
			while ($query_data2 = mysql_fetch_array($result2)) {
				employee_format($query_data2,"#ffffee","#ffffdd","assetborder");
				if ($print_screen == true) echo "<p>";
			}
			if ($print_screen == false) echo "</td>";
			$found_transfer = true;
		}

		// sign outs
		$sql2 = "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, Assignments.Id AS Assignments_ID, Assignments.Temp, Assignments.Completed, Assignments.StartDate, Assignments.EndDate, Assignments.Completed, Assignments.EmployeeID AS Employees_ID FROM Assignments LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeID = " . $emp_db . "Employees.Id WHERE Assignments.AssetId=" . $query_data["Assets_ID"] . $dates_sql . " AND Assignments.Temp=1 AND Assignments.Approve=0 ORDER BY Assignments.StartDate;";
		if (($result2 = doSql($sql2)) && (mysql_num_rows($result2))) {
			if (($print_screen == false) && ($found_transfer == true)) echo "<td width=10>&nbsp;</td>";
			if ($print_screen == false) echo "<td valign='top'>";
			echo "<p><font class='text11'><b>Sign Outs</b></font><br><hr size=0 color='" . $hrcolor . "'>";
			while ($query_data2 = mysql_fetch_array($result2)) {
				employee_format($query_data2,"#ffffee","#ffffdd","assetborder");
				if ($print_screen == true) echo "<p>";
			}
			if ($print_screen == false) echo "</td>";
		}
		if ($print_screen == false) echo "</tr></table>";
		
		echo "<p>";

		// licenses
		echo "<p><font class='text11'><b>Licenses</b></font><br><hr size=0 color='" . $hrcolor . "'>";
		echo "<table bgcolor='#ffffee' cellpadding=5 class='assetborder' width=100%><tr><td>";
		$license_cnt = 1;
		$sql = "SELECT LicenseOwners.Id AS LicenseOwners_ID, Licenses.Manufacturer, Licenses.Product, COUNT(DISTINCT LicenseOwners.Id) AS CountLicenses FROM LicenseOwners LEFT JOIN Licenses ON LicenseOwners.LicenseId = Licenses.Product WHERE LicenseOwners.AssetId = " . $query_data["Assets_ID"] . " GROUP BY Product ORDER BY Product";
		if (($result = doSql($sql)) && (mysql_num_rows($result))) {
			echo "<table width=100%>";
			while ($query_data = mysql_fetch_array($result)) {
				if (($license_cnt % 2) == 1) echo "<tr>";
				echo "<td class='text12bold'>";