<th></th>
</tr>
<?php
while ($r = db_fetch($result)) {
?>
<tr>
<td><a href="view.php?id=<?php
echo $r["userid"];
?>
"><?php
echo $r["lastname"];
?>
, <?php
echo $r["firstname"];
?>
</a></td>
<td class="r"><?php
echo format_date_time($r["createdOn"]);
?>
</td>
<?php
echo deleteColumn("Delete user?", $r["userid"]);
?>
</tr>
<?php
}
} else {
echo drawEmptyResult("No pending requests!");
}
echo drawTableEnd();
drawBottom();
?>
'>
<td class='reorder'><i class='glyphicon glyphicon-menu-hamburger'></i></td>
<td><a href="<?php
echo url_query_add(array('id' => $l['id']), false);
?>
"><?php
echo $l['name'];
?>
</a></td>
<td><?php
echo nl2br($l['address']);
?>
</td>
<?php
echo deleteColumn('Are you sure?', $l['id']);
?>
</tr>
<?php
}
} else {
echo drawEmptyResult('No intranet_offices entered in the system yet!', 4);
}
?>
</tbody>
</table>
<a name='bottom'></a>
<?php
$form = new intranet_form();
$form->addRow('hidden', '', 'precedence', $max + 1);
echo $r["id"];
?>
"><?php
echo $r["title"];
?>
</a></td>
<td><?php
echo $r["office"];
?>
</td>
<td align="right"><?php
echo format_date($r["updatedOn"]);
?>
</td>
<?php
echo deleteColumn("Delete this position?", $r["id"]);
?>
</tr>
<?php
}
?>
</table>
<a name="bottom"></a>
<?php
if ($isAdmin && !$printing) {
$form = new intranet_form();
if ($isAdmin) {
$form->addUser("createdBy", "Posted By", $user["id"], false, true);
}
(SELECT COUNT(*) FROM users_to_skills u2s
JOIN intranet_users u ON u2s.user_id = u.userID
WHERE u2s.skill_id = s.id AND u.isActive = 1) as count
FROM skills s
WHERE s.isActive = 1
ORDER BY s.group, s.title');
?>
<tr>
<th>Title</th>
<th class="r">Count</th>
<?php
if ($isAdmin) {
?>
<th></th><?php
}
?>
</tr>
<?php
foreach ($skills as $skill) {
if ($lastGroup != $skill['group']) {
echo '<tr class="group"><td colspan="' . $colspan . '">' . $skill['group'] . '</td></tr>';
$lastGroup = $skill['group'];
}
echo '<tr>
<td><a href="skill.php?id=' . $skill['id'] . '">' . $skill['title'] . '</a></td>
<td class="r">' . number_format($skill['count']) . '</td>
' . deleteColumn('Are You Sure?', $skill['id'], 'delete_skill', true) . '
</tr>';
}
echo drawTableEnd();
echo drawBottom();
<td><a href="member.php?id=<?php
echo $r["id"];
?>
"><?php
echo $r["lastname"];
?>
, <?php
echo $r["firstname"];
?>
</a></td>
<td><nobr><?php
echo $r["positionOnBoard"];
?>
</nobr></td>
<?php
echo deleteColumn("Are you sure you want to delete this board member?", $r["id"]);
?>
</tr>
<?php
}
?>
</table>
<a name="bottom"></a><br>
<?php
if ($isAdmin) {
$form = new intranet_form();
$form->addRow("itext", "First Name", "firstname", "", "", true, 255);
$form->addRow("itext", "Last Name", "lastname", "", "", true, 255);
$form->addRow("select", "Organization", "corporationID", "SELECT id, description FROM organizations ORDER BY description", "", true);
case "delete":
deleteReport();
case "formSave":
formSave();
case "getColumns":
getColumns();
//....................................
//....................................
case "selectReportColumns":
selectReportColumns();
case "addReportColumn":
addReportColumn();
case "ChangeColumnOrder":
ChangeColumnOrder();
case "deleteColumn":
deleteColumn();
}
function saveReport()
{
$summaryNames = array("sum" => "مجموع", "count" => "تعداد", "avg" => "میانگین", "max" => "ماکزیمم", "min" => "مینیمم");
//-------------------- Add or Edit report header ---------------------------
$rptobj = new rp_reports();
$rptobj->report_title = $_POST["report_title"];
$rptobj->conditions = stripslashes($_POST["conditions"]);
$rptobj->refer_page = $_POST["refer_page"];
if (empty($_POST["report_id"])) {
$result = $rptobj->Add();
$rptobj->report_id = rp_reports::LastID();
} else {
$rptobj->report_id = $_POST["report_id"];
$result = $rptobj->Edit();
echo $r["userID"];
?>
"><?php
echo $r["lastname"];
?>
, <?php
echo $r["firstname"];
?>
</a></nobr></td>
<td><?php
echo $r["title"];
?>
</td>
<td><?php
echo $r["office"];
?>
</td>
<td align="right"><nobr><?php
echo format_phone($r["phone"]);
?>
</nobr></td>
<?php
echo deleteColumn("Delete this staff member?", $r["userID"]);
?>
</tr>
<?php
}
?>
</table>
<?php
drawBottom();
