function drawStaffRow($r, $searchterms = false) { global $isAdmin, $locale; if ($searchterms) { global $fields; foreach ($fields as $f) { if (isset($r[$f])) { $r[$f] = format_hilite($r[$f], $searchterms); } } } $return = '<tr height="38">'; $return .= '<td class="image"><a href="/staff/view.php?id=' . $r["userID"] . '">' . drawImg($r["userID"]) . '</a></td>'; $return .= '<td><nobr><a href="view.php?id=' . $r["userID"] . '">' . $r["lastname"] . ', ' . $r["firstname"] . '</a>'; //if (!$r["isMain"]) $return .= "<br>" . $r["office"]; $return .= '</nobr></td><td>'; if ($r["title"]) { $return .= $r["title"] . '<br>'; } if ($r["departmentName"]) { $return .= '<i>' . $r["departmentName"] . '</i><br>'; } if ($r["corporationName"]) { $return .= '<a href="/staff/organizations.php?id=' . $r["corporationID"] . '">' . $r["corporationName"] . '</a>'; } $return .= '</td> <td class="r"><nobr>' . format_phone($r["phone"]) . '</nobr></td> '; if ($isAdmin) { $return .= '<td class="delete"><a href="javascript:promptRedirect(\'' . url_query_add(array("action" => "delete", "staffID" => $r["userID"]), false) . '\', \'Delete this staff member?\');"><i class="glyphicon glyphicon-remove"></i></a></td>'; } return $return . '</tr>'; }
<table class="left" cellspacing="1"> <?php echo drawHeaderRow("Goings", 4); ?> <tr> <th width="47"></th> <th width="25%" align="left">Name</th> <th width="50%" align="left">Title, Department</th> <th width="20%" align="right">Last Day</th> </tr> <?php while ($r = db_fetch($result)) { ?> <tr bgcolor="#FFFFFF" class="helptext" valign="top" height="38"> <td><?php echo drawImg($r['userID']); ?> </td> <td><a href="/staff/view.php?id=<?php echo $r["userID"]; ?> "><?php echo $r["first"]; ?> <?php echo $r["last"]; ?> </a></td> <td><?php echo $r["title"]; ?>
function drawName($userID, $name, $date = false, $withtime = false, $separator = "<br>") { global $_josh, $locale; $date = $date ? format_date_time($date, "", $separator) : false; return ' <div class="user"> <a href="http://' . $_josh["request"]["host"] . '/staff/view.php?id=' . $userID . '">' . drawImg($userID) . format_string($name, 20) . '</a>' . $date . ' </div>'; }
<?php include '../include.php'; drawTop(); ?> <table class="left" cellspacing="1"> <?php echo drawHeaderRow("Former Staff", 5); ?> <?php $staff = db_query("SELECT \n\t\t\t\t\t\t\tu.userID, \n\t\t\t\t\t\t\tu.lastname,\n\t\t\t\t\t\t\tISNULL(u.nickname, u.firstname) firstname, \n\t\t\t\t\t\t\tu.bio, \n\t\t\t\t\t\t\tu.phone, \n\t\t\t\t\t\t\tf.name office, \n\t\t\t\t\t\t\tu.title, \n\t\t\t\t\t\t\td.departmentName\n\t\t\t\t\t\tFROM intranet_users u\n\t\t\t\t\t\tLEFT JOIN intranet_departments d ON d.departmentID = u.departmentID \n\t\t\t\t\t\tLEFT JOIN intranet_offices f ON f.id = u.officeID\n\t\t\t\t\t\tWHERE u.isactive = 0\n\t\t\t\t\t\tORDER BY u.lastname, ISNULL(u.nickname, u.firstname)"); while ($s = db_fetch($staff)) { ?> <tr height="38"> <td><?php echo drawImg($staff['userID']); ?> </td> <td><nobr><a href="view.php?id=<?php echo $s["userID"]; ?> "><?php echo $s["lastname"]; ?> , <?php echo $s["firstname"]; ?> </a></nobr></td> <td><?php echo $s["title"]; ?>
<th align="left">Phone</th> <?php if ($isAdmin) { ?> <th></th> <?php } ?> </tr> <?php $result = db_query("SELECT \n\t\t\t\t\t\t\tu.userID, \n\t\t\t\t\t\t\tu.lastname,\n\t\t\t\t\t\t\tISNULL(u.nickname, u.firstname) firstname, \n\t\t\t\t\t\t\tu.bio, \n\t\t\t\t\t\t\tu.phone, \n\t\t\t\t\t\t\tf.name office, \n\t\t\t\t\t\t\tu.title, \n\t\t\t\t\t\t\td.departmentName,\n\t\t\t\t\t\t\tr.isPayroll\n\t\t\t\t\t\tFROM intranet_users u\n\t\t\t\t\t\tJOIN intranet_ranks r ON u.rankID = r.id\n\t\t\t\t\t\tLEFT JOIN intranet_departments d ON d.departmentID = u.departmentID \n\t\t\t\t\t\tLEFT JOIN intranet_offices f ON f.id = u.officeID\n\t\t\t\t\t\tLEFT JOIN intranet_images m ON u.imageID = m.imageID\n\t\t\t\t\t\tWHERE u.isActive = 1 AND r.isPayroll = 0\n\t\t\t\t\t\tORDER BY u.lastname, ISNULL(u.nickname, u.firstname)"); while ($r = db_fetch($result)) { ?> <tr height="38"> <td><?php echo drawImg($r['imageID']); ?> </td> <td><nobr><a href="view.php?id=<?php echo $r["userID"]; ?> "><?php echo $r["lastname"]; ?> , <?php echo $r["firstname"]; ?> </a></nobr></td> <td><?php echo $r["title"]; ?>
<td width="99%" class="big"><?php echo $r["firstname"]; ?> <?php if ($r["nickname"]) { ?> (<?php echo $r["nickname"]; ?> ) <?php } echo $r["lastname"]; ?> </td> <td rowspan="8" class="profile_image"><?php echo drawImg($_GET['id']); ?> </td> </tr> <tr> <td class="left">Organization</td> <td><?php echo $r["corporationName"]; ?> </td> </tr> <tr> <td class="left">Title</td> <td><?php echo $r["title"]; ?>