misc.php

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

		echo "<p><font class=text18bold>Login Successful</font><hr size=0 color='" . $hrcolor . "'>";
		echo "<p><blockquote><font class='text12'>You have been logged in.  Click next below to begin browsing.</blockquote></font>";
		echo "<p><center><a href='" . $PHP_SELF . "'><img src='images/next.jpg' width=88 height=27 border=0></a></center>\n";
	} else {
		loginbox($key);
	}
}

// centralized function used to display the title headers
function menu_header($top,$title,$icon) {
	global $print_screen;
	global $hrcolor;
	global $key, $action;
	global $my_access_level;
	
	$PHP_SELF = $_SERVER['PHP_SELF'];
	echo "<p><table cellspacing=0 cellpadding=0 border=0 width=100%><tr>";
	echo "<td valign='bottom'>";

	echo "<table cellspacing=0 cellpadding=0 border=0><tr>";
	echo "<td valign='bottom'><img src='images/" . $icon . "' width=32 height=32 align=left hspace=5></td>";
	echo "<td valign='bottom'>";
	if ($print_screen == false) echo "<font class='text10bold'><a href='" . $PHP_SELF . "' class='text10bold'>Home</a> &raquo; ";
	echo $top . "</font><br>";
	echo "<font class=text18bold>" . $title . "</font></td></tr></table>";

	echo "</td>";

	if ($print_screen == false) {
		echo "<td valign='bottom' align='right'>";
		if ($my_access_level > 1) {
			echo "<a href='" . $PHP_SELF . "?action=import' class='text10bold'>import</a> ";
			echo "<font class='text10bold'>&middot;</font> ";
		}
		echo "<a href='" . $PHP_SELF . "?action=help' class='text10bold'>help</a> ";
		echo "<font class='text10bold'>&middot;</font> ";
		echo "<a href='javascript:openwin()' class='text10bold'>print</a>";
		echo "<font class='text10bold'>&middot;</font> ";
		if ($my_access_level > 0) echo "<a href='" . $PHP_SELF . "?action=login&lastaction=" . $action . "&lastkey=" . html($key) . "&loginout=2' class='text10bold'>logout</a>";
		else echo "<a href='" . $PHP_SELF . "?action=login&lastaction=" . $action . "&lastkey=" . html($key) . "' class='text10bold'>login</a>";
		echo "</td>";
	}
	echo "</tr></table>";
	echo "<hr size=2 color='" . $hrcolor . "'>\n";
}

function import() {
	menu_header("","Import","setup.jpg");
	echo "<blockquote><font class='text12'>";
	echo "<p><font class='text12bold'>Step 1:</font> <a href='" . $PHP_SELF . "?action=employeeimport' class='text12bold'>Import Employees</a>";
	echo "<br>Import employees from a spreadsheet or database";
	echo "<p><font class='text12bold'>Step 2:</font> <a href='" . $PHP_SELF . "?action=assetimport' class='text12bold'>Import Assets</a>";
	echo "<br>Import assets from a spreadsheet or database";
	echo "</font></blockquote>";
}

// generates a yahoo style list of links and sublinks for one section in the centre menu
function doStylise($field, $name, $link) {
	$sql = "SELECT " . $field . " 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 " . $field;
	echo "<table cellspacing=0 cellpadding=0 border=0><tr><td><a href='?action=" . $link . "' class=text18bold><img src='images/". $link .".jpg' width=32 height=32 align=left border=0></a></td><td valign='bottom'><a href='?action=" . $link . "' class=text18bold>" . $name . "</a></td></tr></table>\n";
	if (($result = doSql($sql)) && (mysql_num_rows($result))) {
		$commatrack = false;
		while ($query_data = mysql_fetch_array($result)) {
			if ($commatrack == true) echo ", ";
			else $commatrack = true;
			if (strlen($query_data[0]) > 1) echo "<a href='" . $PHP_SELF . "?action=" . $link . "&key=" . html($query_data[0]) . "'>" . $query_data[0] . "</a>";
			else $commatrack = false;
		}
	}
	echo "<p>\n";
}

// generates a dropdown box for dates
function dateDropdown($ext,$month,$day,$year,$month_now_offset,$default_day,$begend, $useunknown) {
	if ($month != "") $month_now = $month;
	else $month_now = date("m",time());

	if ($day != "") $day_now = $day;
	else $day_now = date("d",time());
	
	if ($year != "") $year_now = $year;
	else $year_now = date ("Y",time());

	$months = Array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

	$month_now = $month_now + $month_now_offset;
	while ($month_now > 12) {
		$month_now = $month_now - 12;
		$year_now++;
	}

	while ($month_now < 1) {
		$month_now = $month_now + 12;
		$year_now--;
	}

	if ($default_day != "0") $day_now = $default_day;

	// year
	echo "<select name='year_" . $ext . "' size='1' class='boxtext13'>";
	if ($useunknown == true) echo "<option value='' SELECTED></option>";
	else echo "<option value=''></option>";
	for ($i=1970;$i<(date ("Y",time())+10);$i++) {
		if (($year_now == $i) && ($useunknown == false)) echo "<option value='" . $i . "' selected>" . $i . "</option>\n";
		else echo "<option value='" . $i . "'>" . $i . "</option>\n";
	}
	echo "</select>";

	// month
	echo "<select name='month_" . $ext . "' size='1' class='boxtext13'>";
	if ($useunknown == true) echo "<option value='' SELECTED></option>";
	else echo "<option value=''></option>";
	for ($i=1;$i<13;$i++) {
		if (($month_now == $i) && ($useunknown == false)) echo "<option value='" . $i . "' selected>" . $months[$i-1] . "</option>\n";
		else echo "<option value='" . $i . "'>" . $months[$i-1] . "</option>\n";
	}
	echo "</select>";

	// day
	echo "<select name='day_" . $ext . "' size='1' class='boxtext13'>";
	if ($useunknown == true) echo "<option value='' SELECTED></option>";
	else echo "<option value=''></option>";
	for ($i=1;$i<32;$i++) {
		if (($day_now == $i) && ($useunknown == false)) echo "<option value='" . $i . "' selected>" . $i . "</option>\n";
		else echo "<option value='" . $i . "'>" . $i . "</option>\n";
	}
	echo "</select>";
	if ($begend == true) return mktime(0,0,0,$month_now,$day_now,$year_now);
	else return mktime(23,59,59,$month_now,$day_now,$year_now);
}

function getMsg() {
	global $QUERY_STRING;
	global $my_emp_id;
	global $msgread;
	global $key;
	global $action;	
	if ($msgread != "") {
		$sql = "DELETE FROM Msgs WHERE id=" . $msgread;
		$result = doSql($sql);
	}

	$sql = "SELECT Assignments.EndDate, Assignments.Id AS Assignments_ID, Assets.AssetSupplier, Assets.AssetModel FROM Assignments LEFT JOIN Assets ON Assignments.AssetId = Assets.Id WHERE Assignments.EmployeeId=" . $my_emp_id . " AND Assignments.EndDate <= " . time() . " AND Assignments.Temp=1 AND Assignments.Completed=0";
	if (($result = doSql($sql)) && (mysql_num_rows($result)) && ($query_data = mysql_fetch_array($result))) {
		$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);
		$time_diff = ceil((($query_data["EndDate"]) - $new_time) / 86400);
		$time_diff--;
		if ($time_diff == -1) $due_text = "<font color='#ff0033'>1 day overdue!</font>";
		else $due_text = "<font color='#ff0033'>" . abs($time_diff) . " days overdue!</font>";
		$msg = $due_text . ": " . $query_data["AssetSupplier"] . " " . $query_data["AssetModel"] . " [ <a href='" . $PHP_SELF . "?action=assettransfersignin&key=" . $query_data["Assignments_ID"] . "&lastaction=" . $lastaction . "&lastkey=" . $key . "'><font color='#ffcc00' class='text11'>SIGN IN!</font></a> ]";
	} else {
		$sql = "SELECT Msgs.Id AS Msgs_ID, Msgs.EmployeeId, Msgs.AssetId, Msgs.Date, Msgs.MsgCode, Msgs.Msg, Assets.AssetTag, Assets.AssetType, Assets.AssetSupplier, Assets.AssetModel FROM Msgs LEFT JOIN Assets ON Msgs.AssetId = Assets.Id WHERE Msgs.Employeeid=" . $my_emp_id . " ORDER BY Msgs.Date DESC";
		if (($result = doSql($sql)) && (mysql_num_rows($result)) && ($query_data = mysql_fetch_array($result))) {
			switch ($query_data["MsgCode"]) {
				case "1":
					$color= "Aqua";
					break;
				case "2":
					$color = "#ff0033";
					break;
				default:
					$color = "#ffffff";
					break;
			}
			$msg = "<font color='#ffcc00'>new!</font> " . $query_data["date"] . " - " . $query_data["AssetSupplier"] . " " . $query_data["AssetModel"] . " (" . $query_data["AssetType"] . ") - <font color='" . $color . "'>" . $query_data["Msg"] . "</font>&nbsp;&nbsp; [ <a href='" . $PHP_SELF . "?" . $QUERY_STRING . "&msgread=" . $query_data["Msgs_ID"] ."'><font color='#ffcc00' class='text11'>OK</font></a> ]";
		} else {
			$msg = "you have no new messages.";
		}
	}
	return $msg;
}

// replace quote with &quot;
function q_replace($txt) {
	$txt = str_replace("\"","&quot;",$txt);
	$txt = stripslashes($txt);
	return $txt;
}

// replace escape characters with html equivalent;
function html($txt) {
	$txt = str_replace(" ","%20",$txt);
	$txt = str_replace("\"","%22",$txt);
	$txt = str_replace("'","%27",$txt);	
	return $txt;
}

// replace html with original escape characters;
function dehtml($txt) {
	$txt = str_replace("%20"," ",$txt);
	$txt = str_replace("%22","\"",$txt);
	$txt = str_replace("%27","'",$txt);	
	return $txt;
}

// checks if a character is between A-Z or 0-9
function is_alphanum($input) {
	return (("a" <= $input && $input <="z") || ("A" <= $input && $input <="Z") || ("0" <= $input && $input <="9"))?true:false;
}

// checks if a string is between A-Z or 0-9
function is_alphanum_str($input) {
	$alphanum_str = false;
	for ($i=0;$i<strlen($input);$i++) {
		if (is_alphanum(substr($input,$i,1)) == false) $alphanum_str = true;
	}
	return $alphanum_str;
}

// generates a random seed
function make_seed() {
    list($usec, $sec) = explode(' ', microtime());
    return (float) $sec + ((float) $usec * 100000);
}

function cmp_array_startdate($a, $b) {
    if ($a["startdate"] == $b["startdate"]) return 0;
    return ($a["startdate"] < $b["startdate"]) ? -1 : 1;
}





?>