<?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>