File: /home/awaldron/www/archive/demo/functions/_gui.php
<?php
function alpha($color,$alpha=5) {
$alpha = (100-$alpha)/100;
$dec1 = hexdec(substr($color,0,2));
$dec2 = hexdec(substr($color,2,2));
$dec3 = hexdec(substr($color,4,2));
$a5dec1 = floor($alpha*(255-$dec1)+$dec1);
$a5dec2 = floor($alpha*(255-$dec2)+$dec2);
$a5dec3 = floor($alpha*(255-$dec3)+$dec3);
return strToUpper(dechex($a5dec1).dechex($a5dec2).dechex($a5dec3));
}
function boxhead($title,$right=0) {
echo "<table width=100% border=0 cellspacing=0 cellpadding=0>\n";
if ($right === "xxx") {
echo "<tr><td colspan=3 id=\"boxhead\" align=\"center\">".$title."</td></tr>\n";
} else if ($right === 0) {
echo "<tr><td colspan=3 id=\"boxhead\"> ".$title."</td></tr>\n";
} else {
echo "<tr><td colspan=3 id=\"boxhead\">\n";
echo "<table border=0 cellspacing=0 cellpadding=0 width=100%><tr>\n";
echo "<td id=\"boxheadtext\"> ".$title."</td><td align=\"right\">".$right." </td></tr></table>\n";
echo "</td></tr>\n";
}
echo "<tr><td width=2 class=\"tbar\"><img src=\"/gui/clear.gif\" width=2 height=2></td>\n";
echo "<td width=\"100%\" class=\"bg\">\n";
}
function boxfoot() {
echo "</div></td><td width=2 class=\"tbar\"><img src=\"/gui/clear.gif\" width=2 height=2></td></tr>\n";
echo "<tr><td colspan=3 class=\"tbar\"><img src=\"/gui/clear.gif\" width=2 height=2></td></tr>\n";
echo "<tr><td colspan=3><img src=\"/gui/clear.gif\" width=2 height=8></td></tr>\n";
echo "</table>\n";
}
function error($mesg) {
return "<table border=0><tr><td><img src=\"/gui/icons/error.gif\"> </td><td valign=\"middle\" class=\"error\"><span style=\"font-size:12px;\">ERROR: ".$mesg."</span></td></tr></table>\n";
}
function error2($mesg,$add=FALSE) {
return "<table border=0 cellspacing=0 cellpadding=0><tr><!--td><img src=\"/gui/icons/error.gif\"> </td--><td valign=\"middle\" class=\"error\"><span style=\"font-size:11px;\">X: ".$mesg."</span></td>".($add?"<td>".$add."</td>":"")."</tr></table>\n";
}
function feat_emp_update() {
// FIND NEW FEATURED EMPLOYEE
$ctr = 0;
$sql = "SELECT username FROM tbl_employees WHERE my_job <> '' AND is_employee=1 AND eotw=0 AND emp_type_id < 4 AND (my_career <> '' OR my_family <> '' OR my_interests <> '') ORDER BY lname ASC";
$res = mysql_query($sql);
for ($i=0; $i < mysql_num_rows($res); $i++) {
$u = mysql_fetch_array($res);
$has_photo = TRUE;
$photo = "gui/photos/".$u["username"].".jpg";
if (!file_exists($photo)) $has_photo = FALSE;
if ($has_photo) {
$users[$ctr] = $u["username"];
$ctr++;
}
}
if ($ctr == 0) $ctr = 1;
srand(time());
$random = (rand()%$ctr);
$feat_emp = $users[$random];
if (quickSQL("SELECT eid FROM tbl_employees WHERE username='".$feat_emp."'") !== FALSE) {
quickUPDATE("UPDATE tbl_variables SET var_value='".$feat_emp."' WHERE var_name='feat_emp'");
quickUPDATE("UPDATE tbl_employees SET eotw=1 WHERE username='".$feat_emp."'");
// SET NEXT FEATURED EMPLOYEE UPDATE TIME
$feu = FEAT_EMP_UPD;
$freq = (int)$feu;
$now = time();
if ($freq == 1) $next = $now + 604800;
else if ($freq == 2) $next = $now + 302400;
else if ($freq == 3) $next = $now + 86400;
$now = getdate($now);
$next = getdate($next);
$next = $next["year"].($next["mon"]<10?"0".$next["mon"]:$next["mon"]).($next["mday"]<10?"0".$next["mday"]:$next["mday"]);
if (($freq == 2) && ($now["wday"]==0)) $next .= "120001";
else $next .= "000001";
quickUPDATE("UPDATE tbl_variables SET var_value='".$next."' WHERE var_name='feat_emp_nxt'");
update_constants();
}
}
function get_layout($pid,$col) {
$page_cols = quickSQL("SELECT page_cols FROM tbl_pages WHERE page_id=".$pid);
if (($page_cols == 1) && ($col != 2)) return array();
else if (($page_cols == 2) && ($col == 3)) return array();
else {
if ($col == 2) {
// If looking for a noticeboard in the center of page
$sql = "SELECT ntid, ntid_display FROM tbl_layout WHERE page_id=".$pid." AND lo_side=2 AND mod_id=13 ORDER BY lo_rank ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
mod_noticeboard($row["ntid"],$row["ntid_display"]);
}
}
}
// If looking for a module that is not a noticeboard
$count = quickSQL("SELECT COUNT(loid) FROM tbl_layout WHERE page_id=".$pid." AND lo_side=".$col);
$sql = "SELECT A.mod_name FROM tbl_modules AS A, tbl_layout AS B WHERE B.mod_id <> 13 AND B.page_id=".($count==0?DEF_LAYOUT:$pid)." AND B.lo_side=".$col." AND B.mod_id=A.mod_id ORDER BY B.lo_rank ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
for ($j=0; $j < mysql_num_rows($res); $j++) {
$row = mysql_fetch_array($res);
$modules[$j] = $row["mod_name"];
}
//if ($col == 1) $modules[count($modules)] = "addpage";
//if ($col == 1) $modules[count($modules)] = "actions";
return $modules;
} else {
//echo $sql;
return array();
}
}
}
function group_manage($parent,$base,$gid) {
$sql = "SELECT * FROM tbl_groups WHERE group_parent=".$parent." ORDER BY group_name ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
if ($row["group_parent"]==0) $top = TRUE;
else $top = FALSE;
echo "<tr bgcolor=\"".($top?"#".COLOR_BG:"#FFFFFF")."\"><td".($top?" style=\"font-weight:bold\"":"").">";
for ($j=0; $j < ($base*5); $j++) echo " ";
echo "<img src=\"/gui/bullet.gif\"> ".$row["group_name"]." [".$row["group_short"]."] </td>";
echo "<td align=\"center\"> <a href=\"employee_list.php?gid=".$row["group_id"]."&tab=all\">".quickSQL("SELECT COUNT(tbl_group_user.group_id) FROM tbl_group_user, tbl_employees WHERE tbl_group_user.group_id=".$row["group_id"]." AND tbl_employees.username=tbl_group_user.username AND tbl_employees.is_employee=1")."</a> </td>\n";
echo "<td align=\"center\">";
if ($row["group_id"] != DEF_GROUP) echo " <a href=\"#\" onClick=\"openWindow('quick_change.php?a=addsubgrp&id=".$row["group_id"]."','','resizable=yes,width=350,height=235')\">Add Sub-Group</a> | <a href=\"#\" onClick=\"openWindow('quick_change.php?a=renamegrp&id=".$row["group_id"]."','','resizable=yes,width=500,height=235')\">Rename</a> | <a href=\"#\" onClick=\"openWindow('quick_change.php?a=movegrp&id=".$row["group_id"]."','','resizable=yes,width=500,height=235')\">Move</a> | <a href=\"#\" onClick=\"openWindow('quick_change.php?a=delgrp&id=".$row["group_id"]."','','resizable=yes,width=500,height=235')\">Delete</a> </td>\n";
echo "</tr>";
group_manage($row["group_id"],($base+1),$gid);
}
}
}
function local_url($url) {
$docs = array(".doc",".dot",".pdf",".xls",".xlt",".ppt",".txt");
for ($i=0; $i < count($docs); $i++)
if (strstr(substr($url,-5),$docs[$i])) return FALSE;
if (substr($url,0,1) == "/") return TRUE;
else if (strstr($url,DOMAIN)) return TRUE;
else return FALSE;
}
function mboxhead($title,$right=0) {
echo "<table width=100% border=0 cellspacing=0 cellpadding=0>\n";
if ($right === 0) {
echo "<tr><td colspan=3 id=\"boxhead\"> ".$title."</td></tr>\n";
} else {
echo "<tr><td colspan=3 id=\"boxhead\">\n";
echo "<table border=0 cellspacing=0 cellpadding=0 width=100%><tr>\n";
echo "<td id=\"boxheadtext\"> ".$title."</td><td align=\"right\">".$right." </td></tr></table>\n";
echo "</td></tr>\n";
}
echo "<tr><td width=2 class=\"tbar\"><img src=\"/gui/clear.gif\" width=2 height=2></td>\n";
echo "<td width=\"100%\" class=\"bg\">\n";
echo "<div style=\"margin:12px;font-size:12px;line-height:18px;\">\n";
}
function notice($mesg) {
return "<table border=0><tr><td><img src=\"/gui/icons/notice2.gif\"> </td><td valign=\"middle\" class=\"error\"><span style=\"color:#009900;font-size:12px;\">NOTICE: ".$mesg."</span></td></tr></table>\n";
}
function pagination($ntid,$page) {
$count = quickSQL("SELECT COUNT(notice_id) FROM tbl_notices WHERE notice_type_id=".$ntid." AND notice_active=1");
$pages = ceil($count / PAG_LENGTH);
if ($pages == 1) return "";
else {
$pag = "<b>";
$low = (($page-3)>1?($page-3):1);
$high = ($pages<($page+3)?$pages:($page+3));
if (($low > ($pages-7)) && (($pages-7) > 1)) $low = $pages-6;
if (($high < 7) && ($pages > 7)) $high = 7;
if ($low > 1) $pag .= " <a href=\"/noticeboard.php?ntid=".$ntid.(isset($_GET["sf"])?"&sf=1":"")."\"><<</a> ";
else $pag .= " << ";
for ($i=$low; $i <= $high; $i++) {
if ($page == $i) $pag .= " <span style=\"color:#".COLOR_HOVER."\">".$i."</span> ";
else $pag .= " <a href=\"/noticeboard.php?ntid=".$ntid."&pag=".$i.(isset($_GET["sf"])?"&sf=1":"")."\">".$i."</a> ";
}
if (($pages-$page) > 3) $pag .= " <a href=\"/noticeboard.php?ntid=".$ntid."&pag=".$pages.(isset($_GET["sf"])?"&sf=1":"")."\">>></a> ";
else $pag .= " >> ";
$pag .= "</b>\n";
return $pag;
}
}
function pgroup_display($pgarray) {
$display = "";
for ($i=0; $i < count($pgarray); $i++) {
if ($i != 0) echo ", ";
$display .= "<a href=\"/profile.php?u=".$pgarray[$i]."\" target=\"profile\">".$pgarray[$i]."</a>";
}
return $display;
}
function section_title($title) {
echo "<table border=0 cellspacing=0 cellpadding=0 width=100% height=27>\n";
echo "<tr>\n";
echo " <td width=25><img src=\"/gui/titletail.gif\" width=25 height=27></td>\n";
echo " <td align=\"right\" valign=\"middle\" width=\"*\" style=\"background:url(/gui/titlebg.gif) repeat-y bottom right\"><span style=\"font-family:Arial Black;font-size:18px;font-style:italic;color:#003366\">".$title." </span></td>\n";
echo "</tr></table><br>\n";
}
function showthread() {
$sql = "SELECT tbl_threads.*, tbl_employees.fname, tbl_employees.lname FROM tbl_threads, tbl_employees WHERE tbl_threads.thread_active=1 AND tbl_threads.notice_id=".$_GET["nid"]." AND tbl_employees.username=tbl_threads.username ORDER BY tbl_threads.thread_date ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) echo "<P><div id=\"heading\">Comments to this Notice</div>\n";
for ($i=0; $row = mysql_fetch_array($res); $i++) {
$bg = ($i%2==0?"#F6F6F6":"#FFFFFF");
echo "<table width=100% border=0 cellspacing=0 cellpadding=5 style=\"border:solid 1px #CCCCCC;\">\n";
echo "<tr><td width=50 valign=\"top\" rowspan=2 bgcolor=".$bg.">";
if (file_exists("gui/photos/".$row["username"]."2.jpg")) echo "<img src=\"/gui/photos/".$row["username"]."2.jpg\" border=0>";
else echo "<img src=\"/image.php?u=".$row["username"]."&s=2&w=1\" border=0>";
echo "</td>\n";
echo "<td height=20 valign=\"top\" bgcolor=".$bg."><span style=\"font-size:12px\"><a href=\"/profile.php?u=".$row["username"]."\">".$row["fname"]." ".$row["lname"]."</a> : <b>".$row["thread_headline"]."</b></span></td>\n";
echo "<td height=20 valign=\"top\" align=\"right\" bgcolor=".$bg."><table border=0 cellspacing=0 cellpadding=0><tr><td valign=\"middle\">".date("F j, Y h:i a",$row["thread_date"])." </td>".(authorize($row["username"])?"<td> <a href=\"/thread_edit.php?tid=".$row["thread_id"].(isset($_GET["sf"])?"&sf=1":"")."\"><img src=\"/gui/edit2.gif\" border=0></a> </td>":"")."<td> <a href=\"/thread_add.php?nid=".$_GET["nid"]."&q=".$row["thread_id"].(isset($_GET["sf"])?"&sf=1":"")."\"><img src=\"/gui/quote.gif\" border=0></a></td></tr></table></td>\n";
echo "</tr>\n";
echo "<tr><td valign=\"top\" colspan=2 bgcolor=".$bg.">".format_body($row["thread_body"],0)."</td></tr>\n";
echo "</table>\n";
}
//if (mysql_num_rows($res) > 0) echo "<P><div id=\"heading\">Comments to this Notice</div>\n";
//for ($i=0; $row = mysql_fetch_array($res); $i++) {
// echo "<div style=\"background:".($i%2==0?"#F6F6F6":"#FFFFFF").";border:solid 1px #CCCCCC;height:75px;\">";
// echo "<div style=\"float:left;width:55px;margin:5px;\">\n";
// if (file_exists("gui/photos/".$row["username"]."2.jpg")) echo "<img src=\"/gui/photos/".$row["username"]."2.jpg\" border=0>";
// else echo "<img src=\"/image.php?u=".$row["username"]."&s=2&w=1\" border=0>";
// echo "</div>\n";
// echo "<div style=\"float:right;padding:5px;\">\n";
// echo "<div style=\"float:right\"><table border=0 cellspacing=0 cellpadding=0><tr><td valign=\"middle\">".date("F j, Y h:i a",$row["thread_date"])." </td>".(authorize($row["username"])?"<td> <a href=\"/thread_edit.php?tid=".$row["thread_id"].(isset($_GET["sf"])?"&sf=1":"")."\"><img src=\"/gui/edit2.gif\" border=0></a> </td>":"")."<td> <a href=\"/thread_add.php?nid=".$_GET["nid"]."&q=".$row["thread_id"].(isset($_GET["sf"])?"&sf=1":"")."\"><img src=\"/gui/quote.gif\" border=0></a></td></tr></table></div><span style=\"font-size:12px\"><a href=\"/profile.php?u=".$row["username"]."\">".$row["fname"]." ".$row["lname"]."</a> : <b>".$row["thread_headline"]."</b></span>\n";
// echo "<P>".format_body($row["thread_body"],0);
// echo "</div>\n";
// echo "</div>\n";
//}
echo "<br><a href=\"/thread_add.php?nid=".$_GET["nid"].(isset($_GET["sf"])?"&sf=1":"")."\"><img src=\"/gui/post_reply.gif\" border=0></a>\n";
}
function thankyou($mesg) {
return "<table border=0><tr><td><img src=\"/gui/smiles/icon_biggrin.gif\"> </td><td valign=\"middle\" class=\"error\"><span style=\"color:#009900;font-size:12px;\">".$mesg."</span></td></tr></table>\n";
}
?>