<?php
get_main_menu("sitestorekeeper");
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_site_item_issue = "\r\n\tSELECT site_item_issue.qty_issued,\r\n site_item_issue.created_date,\r\n\t site_item_issue.id,\r\n item.name item_name,\r\n person.first_name,\r\n person.last_name,\r\n\t site_item_issue.approve_date\r\n \tFROM ( ( ( birus.site_item_issue site_item_issue\r\n INNER JOIN\r\n birus.user user\r\n ON (site_item_issue.created_by = user.id))\r\n INNER JOIN\r\n birus.item item\r\n ON (site_item_issue.item_id = item.id))\r\n INNER JOIN\r\n birus.site site\r\n ON (site_item_issue.site_id = site.id))\r\n INNER JOIN\r\n birus.person person\r\n ON (user.person_id = person.id)\r\n\t where site_item_issue.site_id='" . $_SESSION["site_id"] . "' AND site_item_issue.record_status='active'\r\n\t ";
$get_site_item_issue = mysql_query($query_get_site_item_issue, $birus_conn) or die(mysql_error());
$row_get_site_item_issue = mysql_fetch_assoc($get_site_item_issue);
$totalRows_get_site_item_issue = mysql_num_rows($get_site_item_issue);
?>
<?php
if ($_REQUEST['site_item_issue_delete'] == true && $_REQUEST['id'] != "") {
$query_remove_record = "update site_item_issue set record_status='deactivated', deleted_by='" . $loggedin_id . "', deleted_date='" . date("y-m-d") . "' where site_item_issue.id='" . $_REQUEST["id"] . "'";
mysql_query($query_remove_record, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_delete("site_item_issue_view", "2", $_REQUEST["id"]);
}
}
?>
<?php
include "includes/table_settings.php";
?>
<div><a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a></div>
<div class="module_title">Site Item Issue</div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Item</th>
<th>Qty Issued</th>
$combination_update_query = "UPDATE `combination_selection`.`user` SET `username` = '" . $_REQUEST['username'] . "'" . $password . ",f_name='" . $_REQUEST['f_name'] . "',l_name='" . $_REQUEST['l_name'] . "',role_id='" . $_REQUEST['role_id'] . "',gender='" . $_REQUEST['gender'] . "' WHERE `user`.`id` ='" . $_REQUEST['user_id'] . "'";
$update_combination_results = mysql_query($combination_update_query, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_combination_sel("user="******"2");
}
}
?>
<?php
if ($_REQUEST['user_delete'] == true && $_REQUEST['id'] != "") {
$query_remove_record = "update user set record_status='deactivated', deleted_by='" . $loggedin_id . "', delete_date='" . date("y-m-d") . "' where user.id='" . $_REQUEST["id"] . "'";
mysql_query($query_remove_record, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_delete("user_view", "2", $_REQUEST["id"]);
}
}
?>
<div>
<a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a><a href=".?user_add&action=Add">
<img src="images/add-button.jpg" width="30" height="30" title="Add <?php
echo $object_name;
?>
" /></a></div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>UserName</th>
get_main_menu("admin");
mysql_select_db($database_birus_conn, $birus_conn);
echo $REQUEST['site_id'];
$query_get_site_activity = "SELECT activity.name,site_activity.id,site.name as site_name\r\n FROM ( birus.site_activity site_activity\r\n INNER JOIN\r\n birus.site site\r\n ON (site_activity.site_id = site.id))\r\n INNER JOIN\r\n birus.activity activity\r\n ON (site_activity.activity_id = activity.id)\r\n WHERE site_activity.site_id ='" . $_REQUEST['site_id'] . "'\r\n AND site_activity.record_status='active'\r\n ";
$get_site_activity = mysql_query($query_get_site_activity, $birus_conn) or die(mysql_error());
$row_get_site_activity = mysql_fetch_assoc($get_site_activity);
$totalRows_get_site_activity = mysql_num_rows($get_site_activity);
?>
<?php
if ($_REQUEST['site_activity_delete'] == true && $_REQUEST['id'] != "") {
$query_remove_record = "update site_activity set record_status='deactivated', deleted_by='" . $loggedin_id . "', delete_date='" . date("y-m-d") . "' where site_activity.id='" . $_REQUEST["id"] . "'";
mysql_query($query_remove_record, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_delete("site_activity_view&site_id=" . $_REQUEST['site_id'] . "", "2", $_REQUEST["id"]);
}
}
?>
<?php
include "includes/table_settings.php";
?>
<a href=".?<?php
echo $_REQUEST['back_page'];
?>
"><img src="images/back-button.png" width="30" height="30" title="Back" /></a><a href=".?site_activity_add&site_id=<?php
echo $_REQUEST['site_id'];
?>
$colname_get_role_by_id = $_GET['role_id'];
}
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_role_by_id = sprintf("SELECT * FROM role WHERE id = %s", GetSQLValueString($colname_get_role_by_id, "int"));
$get_role_by_id = mysql_query($query_get_role_by_id, $birus_conn) or die(mysql_error());
$row_get_role_by_id = mysql_fetch_assoc($get_role_by_id);
$totalRows_get_role_by_id = mysql_num_rows($get_role_by_id);
include "includes/table_settings.php";
?>
<?php
if ($_REQUEST['role_delete'] == true && $_REQUEST['id'] != "") {
$query_remove_record = "update role set record_status='deactivated', deleted_by='" . $loggedin_id . "', deleted_date='" . date("y-m-d") . "' where role.id='" . $_REQUEST["id"] . "'";
mysql_query($query_remove_record, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_delete("role_view", "2", $_REQUEST["id"]);
}
}
?>
<div>
<a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a><a href=".?role_add&action=Add">
<img src="images/add-button.jpg" width="30" height="30" title="Add <?php
echo $object_name;
?>
" /></a></div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Institute Name</th>
$get_unit_of_measure = mysql_query($query_get_unit_of_measure, $birus_conn) or die(mysql_error());
$row_get_unit_of_measure = mysql_fetch_assoc($get_unit_of_measure);
$totalRows_get_unit_of_measure = mysql_num_rows($get_unit_of_measure);
$colname_get_unit_of_measure_by_id = "-1";
if (isset($_GET['unit_of_measure_id'])) {
$colname_get_unit_of_measure_by_id = $_GET['unit_of_measure_id'];
}
include "includes/table_settings.php";
?>
<?php
if ($_REQUEST['unit_of_measure_delete'] == true && $_REQUEST['id'] != "") {
$query_remove_record = "update unit_of_measure set record_status='deactivated', deleted_by='" . $loggedin_id . "', delete_date='" . date("y-m-d") . "' where unit_of_measure.id='" . $_REQUEST["id"] . "'";
mysql_query($query_remove_record, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_delete("unit_of_measure_view", "2", $_REQUEST["id"]);
}
}
?>
<a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a><a href=".?unit_of_measure_add&action=Add">
<img src="images/add-button.jpg" width="30" height="30" title="Add <?php
echo $object_name;
?>
" /></a></div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Unit Name</th>
$query_get_activity_by_id = sprintf("SELECT * FROM activity WHERE id = %s", GetSQLValueString($colname_get_activity_by_id, "int"));
$get_activity_by_id = mysql_query($query_get_activity_by_id, $birus_conn) or die(mysql_error());
$row_get_activity_by_id = mysql_fetch_assoc($get_activity_by_id);
$totalRows_get_activity_by_id = mysql_num_rows($get_activity_by_id);
?>
<?php
include "includes/table_settings.php";
?>
<?php
if ($_REQUEST['activity_delete'] == true && $_REQUEST['id'] != "") {
$query_remove_record = "update activity set record_status='deactivated', deleted_by='" . $loggedin_id . "', deleted_date='" . date("y-m-d") . "' where activity.id='" . $_REQUEST["id"] . "'";
mysql_query($query_remove_record, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_delete("activity_view", "2", $_REQUEST["id"]);
}
}
?>
<a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a><a href=".?activity_add&action=Add">
<img src="images/add-button.jpg" width="30" height="30" title="Add <?php
echo $object_name;
?>
" /></a></div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Activity Name</th>
<th></th>
