<th></th>
</tr>
<?php
while ($r = db_fetch($result)) {
?>
<tr>
<td><a href="view.php?id=<?php
echo $r["id"];
?>
"><?php
echo $r["lastname"];
?>
, <?php
echo $r["firstname"];
?>
</a></td>
<td class="r"><?php
echo format_date($r["created_date"]);
?>
</td>
<?php
echo drawdrawColumnDelete("Delete user?", $r["id"]);
?>
</tr>
<?php
}
} else {
echo drawEmptyResult("All users have logged in.");
}
echo drawTableEnd();
echo drawBottom();
echo $r["id"];
?>
"><?php
echo $r["title"];
?>
</a></td>
<td><?php
echo $r["office"];
?>
</td>
<td class="r"><?php
echo format_date($r["updated_date"]);
?>
</td>
<?php
echo drawdrawColumnDelete("Delete this position?", $r["id"]);
?>
</tr>
<?php
}
?>
</table>
<a name="bottom"></a>
<?php
if ($page['is_admin']) {
$form = new intranet_form();
$form->addRow("itext", "Title", "title", "", "", true);
$form->addRow("select", "Organization", "corporationID", "SELECT id, title from organizations ORDER BY title", "", true);
$form->addRow("select", "Location", "officeID", "SELECT id, name FROM offices ORDER BY precedence", "", true);
<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["board_position"];
?>
</nobr></td>
<?php
echo drawdrawColumnDelete("Are you sure you want to delete this board member?", $r["id"]);
?>
</tr>
<?php
}
} else {
echo drawEmptyResult("No board members added yet", $colspan);
}
echo drawTableEnd();
?>
<a name="bottom"></a>
<?php
if ($page['is_admin']) {
$form = new intranet_form();
echo $r["id"];
?>
"><?php
echo $r["headline"];
?>
</a></td>
<td><nobr><?php
echo $r["corporationName"];
?>
</nobr></td>
<td align="right"><nobr><?php
echo format_date($r["releaseDate"], "n/a", "M d, Y", false);
?>
</nobr></td>
<?php
echo drawdrawColumnDelete("Delete this press release?", $r["id"]);
?>
</tr>
<?php
}
?>
</table>
<a name="bottom"></a>
<?php
if ($page['is_admin']) {
$form = new intranet_form();
if ($page['is_admin']) {
$form->addUser("created_user", "Posted By", $_SESSION["user_id"], false, "EEDDCC");
}
?>
"><?php
echo $r["programDesc"];
?>
</td>
<td align="right"><?php
echo $r["awardCount"];
?>
</td>
<td align="right"><?php
echo $r["funderCount"];
?>
</td>
<?php
if ($r["awardCount"] == 0 && $r["funderCount"] == 0) {
echo drawdrawColumnDelete("Delete this program?", $r["programID"]);
} else {
?>
<td width="16"><img src="<?php
echo DIRECTORY_WRITE;
?>
/images/icons/delete-disabled.gif" width="16" height="16" border="0"></td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
<?php
echo $r["name"];
?>
</a></td>
<td><?php
echo $r["first"];
?>
<?php
echo $r["last"];
?>
</td>
<td align="right">$<?php
echo number_Format($r["awardAmt"]);
?>
</td>
<?php
echo drawdrawColumnDelete("Delete this funder?", $r["funderID"]);
?>
</tr>
<?php
}
?>
<tr class="total">
<td colspan="2">Total: </td>
<td>$<?php
echo number_format($awards_amt);
?>
</td>
<?php
if ($page['is_admin']) {
?>
<td></td><?php
$link = "./?id=" . $d["id"];
?>
<tr>
<td width="16"><?php
echo draw_img(DIRECTORY_WRITE . $d["icon"], $link);
?>
</td>
<td><a href="<?php
echo $link;
?>
"><?php
echo $d["name"];
?>
</a></td>
<td class="r"><?php
echo format_date($d["updated_date"]);
?>
</td>
<?php
echo drawdrawColumnDelete("Delete document?", $d["id"]);
?>
</tr>
<?php
}
} else {
echo drawEmptyResult("No docs added to this category yet!");
}
?>
</table>
<?php
echo drawBottom();
echo $r["user_id"];
?>
"><?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 drawdrawColumnDelete("Delete this staff member?", $r["user_id"]);
?>
</tr>
<?php
}
?>
</table>
<?php
echo drawBottom();
}
?>
<br><?php
echo $r["description"];
?>
</td>
<td align="center"><?php
echo number_format($r["downloads"]);
?>
</td>
<td align="center"><nobr><?php
echo number_format($r["num_columns"]);
?>
/ <?php
echo number_format($r["num_rows"]);
?>
</nobr></td>
<td align="right"><nobr><?php
echo format_date($r["updated_date"]);
?>
</nobr></td>
<?php
echo drawdrawColumnDelete("Delete this database query?", $r["id"]);
?>
</tr>
<?php
}
?>
</table>
<?php
echo drawBottom();
echo $r["id"];
?>
"><?php
echo format_string($r["headline"], 40);
?>
</a></td>
<td><?php
echo $r["outlet"];
?>
</td>
<td><?php
echo $r["organization"];
?>
</td>
<td class="r"><?php
echo format_date($r["pubdate"], "n/a", "M d, Y", false);
?>
</td>
<?php
echo drawdrawColumnDelete("Delete news clip?", $r["id"]);
?>
</tr>
<?php
}
} else {
echo drawEmptyResult("No stories in the system yet");
}
echo drawTableEnd();
include "edit.php";
}
echo drawBottom();
