asset_actions.php

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

				echo "<li>" . $query_data["Manufacturer"] . " " . $query_data["Product"];
				if ($query_data["CountLicenses"] != "1") echo " (" . $query_data["CountLicenses"] . ")"; 
				if (($print_screen == false) && ($is_editable)) echo " <a href='" . $PHP_SELF . "?action=assetview&key=" . $key . "&removelicense=" . $query_data["LicenseOwners_ID"] . "'>(remove)</a>";
				echo "</td>";
				if (($license_cnt % 2) == 0) echo "</tr>";
				$license_cnt++;

			}
			echo "</table>";
		} else {
			echo "<li><font class='text12bold'>There are no licenses assigned to this asset.</font>";
		}
		
		// show the add license form
		if (($print_screen == false) && ($is_editable)) {
			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='assetview'>";
			echo "<input type='hidden' name='key' value='" . $key . "'>";
			echo "<select name='addlicense' class='boxtext13'>";
			echo "<option value='' SELECTED>(Select A Product)</option>";
			$sql = "SELECT manufacturer, product FROM Licenses GROUP BY product ORDER BY product";
			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 "<br><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 "</td></tr></table>";

		// make changes to ips
		if ($is_editable) {
			if ($addip != "") doSql("INSERT INTO IP (employeeid,assetid,ip) VALUES (" . $emp_owner . "," . $key . ",'" . $addip . "')");
			if ($removeip != "") doSql("DELETE FROM IP WHERE id=" . $removeip);
		}
		
		// show current ips
		echo "<p><font class='text12bold'>IP</font><br><hr size=0 color='" . $hrcolor . "'>";
		echo "<table bgcolor='#ffffee' cellpadding=5 class='assetborder' width=100%><tr><td>";
		$ip_cnt = 1;
		$sql = "SELECT id, ip FROM IP WHERE assetid=" . $key;
		if (($result = doSql($sql)) && (mysql_num_rows($result))) {
			echo "<table width=100%>";
			while ($query_data = mysql_fetch_array($result)) {
				if (($ip_cnt % 2) == 1) echo "<tr>";
				echo "<td class='text12bold'>";
				echo $query_data["ip"];
				if ($print_screen == false) echo " <a href='" . $PHP_SELF . "?action=assetview&key=" . $key . "&removeip=" . $query_data["id"] . "'>(remove)</a>";
				echo "</td>";
				if (($ip_cnt % 2) == 0) echo "</tr>";
				$ip_cnt++;
			}
			if (($ip_cnt % 2) == 0) echo "<td>&nbsp;</td></tr>";
			echo "</table>";
		} else {
			echo "<table width=100%>";
			echo "<tr>";
			echo "<td class='text12bold'><li>No IPs are assigned to this asset";
			echo "</td>";
			echo "</tr>";
			echo "</table>";
		}

		// show the add ip form
		if (($print_screen == false) && ($is_editable)) {
			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='assetview'>";
			echo "<input type='hidden' name='key' value='" . $key . "'>";
			echo "<input type='text' name='addip' class='boxtext13' size=30><br><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 "</td></tr></table>";

		if (strcmp($notes,"") != 0) {
			echo "<p><font class='text11'><b>Notes</b></font><br><hr size=0 color='" . $hrcolor . "'>";
			echo "<table bgcolor='#ffffee' cellpadding=5 class='assetborder' width=100%><tr><td class='text13'>";
			echo $notes;
			echo "</td></tr></table>";
		}
		echo "<p><br>";

	} else {
		echo "<font class='text12'>The requested asset cannot be found.</font>";
	}
}

function asset_menu_header($domain, $section, $title, $key) {
	global $print_screen;
	global $hrcolor;

	$PHP_SELF = $_SERVER['PHP_SELF'];
	// domain
	if ($print_screen == false) { 
		if ($domain == true) {
			if ($empid == "-1") $top = "<a href='" . $PHP_SELF . "?action=surplus' class='text10bold'>Surplus</a>";
			elseif ($empid == "-2") $top = "<a href='" . $PHP_SELF . "?action=retired' class='text10bold'>Retired</a>";
			else $top = "<a href='" . $PHP_SELF . "?action=assets' class='text10bold'>Assets</a>";
		} else {
			$top = "";
		}
	}


	// key lookup
	if (strlen($key) > 0) {
		$sql = "SELECT Assignments.EmployeeId, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel FROM Assignments LEFT JOIN Assets ON Assignments.AssetId = Assets.Id WHERE Assets.Id=" . $key;
		if (($result = doSql($sql)) && ($query_data = mysql_fetch_array($result))) {
			$empid = $query_data["EmployeeId"];
			if (($empid != "-1") && ($empid != "-2")) $top = $top . ": <a href='" . $PHP_SELF . "?action=assets&key=" . html($query_data["AssetType"]) . "' class='text10bold'>" . $query_data["AssetType"] . "</a>: <a href='" . $PHP_SELF . "?action=assetview&key=" . $key . "' class='text10bold'>" . $query_data["AssetSupplier"] . " " . $query_data["AssetModel"] . "</a>";
			else $top = $top . ": <a href='" . $PHP_SELF . "?action=assetview&key=" . $key . "' class='text10bold'>" . $query_data["AssetSupplier"] . " " . $query_data["AssetModel"] . "</a>";
		}
	}

	// section
	if ($section != "") $top = $top . ": <font class='text10bold'>" . $section . "</font>";

	// icon
	if ($empid == "-1") $icon = "surplus.jpg";
	elseif ($empid == "-2") $icon = "retired.jpg";
	else $icon = "assets.jpg";

	menu_header($top,$title,$icon);
}


// prints out the top tabs
function asset_tabs($assetid) {
	global $action;
	global $my_emp_id;
	global $temp;
	global $my_access_level;
	global $print_screen;
	global $history;
	global $emp_db;
	
	if (($assetid != "") && ($print_screen == false) && ($my_access_level > 0)) {
		echo "<p>";
		
		echo "<table cellpadding=0 cellspacing=0 border=0><tr>";
		// details
		if ((strcmp($action,"assetview") == 0) && ($history != "1")) echo "<td><font class='text11special2active' color='#000000'>Details</font></td>";
		else echo "<td><a href='" . $PHP_SELF . "?action=assetview&key=" . $assetid . "' class='text11special2'>Details</a></td>";

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

		// delete
		if ((in_array($action,Array("assettransfer","assettransfererase","assettransfersignin"))) && ($temp != "1")) echo "<td><font class='text11special2active'>Transfer</font></td>";
		else echo "<td><a href='" . $PHP_SELF . "?action=assettransfer&key=" . $assetid . "' class='text11special2'>Transfer</a></td>";


		// transfer / sign out
		$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.EmployeeID AS Employees_ID FROM Assignments LEFT JOIN " . $emp_db . "Employees ON Assignments.EmployeeID = " . $emp_db . "Employees.Id WHERE Assignments.AssetId=" . $assetid . " 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);
			if (($query_data2["Employees_ID"] == 0) || ($query_data2["Employees_ID"] == -1)) $allow_sign_out = true;
			else $allow_sign_out = false;
		}
		if ($my_access_level < 2) $newowner = "&newowner=" . $my_emp_id;
		else $newowner = "";
		if ($allow_sign_out == true) {
			if ((in_array($action,Array("assettransfer","assettransfererase","assettransfersignin"))) && ($temp == "1")) echo "<td><font class='text11special2active' color='#000000'>Sign Out</font></td>";
			else echo "<td><a href='" . $PHP_SELF . "?action=assettransfer&key=" . $assetid . "" . $newowner . "&temp=1' class='text11special2'>Sign Out</a></td>";
		} else {
			echo "<td><font class='text11special2' color='#cccccc'>Sign Out</font></td>";
		}

		// calendar
		if ((strcmp($action,"assetcalendar") == 0) && ($temp != "1")) echo "<td><font class='text11special2active'>Calendar</font></td>";
		else echo "<td><a href='" . $PHP_SELF . "?action=assetcalendar&key=" . $assetid . "' class='text11special2'>Calendar</a></td>";
		// history
		if ((strcmp($action,"assetview") == 0) && ($history == "1") && ($temp != "1")) echo "<td><font class='text11special2active'>History</font></td>";
		else echo "<td><a href='" . $PHP_SELF . "?action=assetview&key=" . $assetid . "&history=1' class='text11special2'>History</a></td>";

		// dates
		if ($my_access_level > 1) {
			if (strcmp($action,"assetdates") == 0) echo "<td><font class='text11special2active'>Date Mgmt</font></td>";
			else echo "<td><a href='" . $PHP_SELF . "?action=assetdates&key=" . $assetid . "' class='text11special2'>Date Mgmt</a></td>";
		}


		// erase
		if ($my_access_level > 1) {
			if (strcmp($action,"asseterase") == 0) echo "<td><font class='text11special2active'>Erase</font></td>";
			else echo "<td><a href='" . $PHP_SELF . "?action=asseterase&key=" . $assetid . "' class='text11special2'>Erase</a></td>";
		}

		echo "</td></tr></table>";		
		echo "<table width=100% bgcolor='#ffeecc'><tr><td>\n";
		echo "</td></tr></table>\n";
	}
}

// returns the current owner employee id of an asset
function asset_get_empid($key) {
	global $emp_db;
	$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"];
	} else {
		$emp_owner = "0";
	}
	return $emp_owner;
}

// prints out an asset based on a key
function asset_print_info($key) {
	global $emp_db;
	$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.Id=" . $key . ";";
	$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.Completed, 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 (($result = doSql($sql)) && ($query_data = mysql_fetch_array($result))) {
		if (($result2 = doSql($sql2)) && (mysql_num_rows($result2))) $query_data2 = mysql_fetch_array($result2);
		asset_format($query_data,$query_data2,"#ffffee","assetborder",false);
	}
}

?>