get_main_menu("sitesupervisor");
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_site_to_site_req = "\r\nSELECT person.first_name,\r\n person.last_name,\r\n site.name as site_name,\r\n site_to_site_req.id,\r\n\t site_to_site_req.req_no,\r\n site_to_site_req.site_id,\r\n site_to_site_req.created_date\r\n FROM ( ( birus.user user\r\n INNER JOIN\r\n birus.person person\r\n ON (user.person_id = person.id))\r\n INNER JOIN\r\n birus.site_to_site_req site_to_site_req\r\n ON (site_to_site_req.hoc_approved_by = user.id))\r\n INNER JOIN\r\n birus.site site\r\n ON (site_to_site_req.site_id = site.id)\r\n\t where site_to_site_req.site_to_id=" . $_SESSION['site_id'] . "\r\n\t AND\r\n\t site_to_site_req.recieved_date != '0000-00-00 00:00:00'\r\n\t AND\r\n\t site_to_site_req.recieved = 'true'\r\n\t AND\r\n\t site_to_site_req.approved_receipt = 'true'\r\n";
$get_site_to_site_req = mysql_query($query_get_site_to_site_req, $birus_conn) or die(mysql_error());
$row_get_site_to_site_req = mysql_fetch_assoc($get_site_to_site_req);
$totalRows_get_site_to_site_req = mysql_num_rows($get_site_to_site_req);
?>
<?php
if (isset($_REQUEST['site_to_site_issue_approve']) && $_REQUEST['site_to_site_issue_approve'] == true) {
$approve_update = "UPDATE birus.site_to_site_req SET approved_issue_date = '" . date("y-m-d") . "', approved_issue_by = '" . $loggedin_id . "', approved_issue='approved' WHERE site_to_site_req.id ='" . $_REQUEST['id'] . "';";
echo $approve_update;
mysql_query($approve_update, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("site_to_site_issue_approve_view", "2");
}
}
?>
<?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 to Site Approve Requsition</div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Req No</th>
<th>Site Name</th>
if (isset($_GET['id'])) {
$colname_get_unit_of_measure_by_id = $_GET['id'];
}
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_unit_of_measure_by_id = sprintf("SELECT * FROM unit_of_measure WHERE id = %s", GetSQLValueString($colname_get_unit_of_measure_by_id, "int"));
$get_unit_of_measure_by_id = mysql_query($query_get_unit_of_measure_by_id, $birus_conn) or die(mysql_error());
$row_get_unit_of_measure_by_id = mysql_fetch_assoc($get_unit_of_measure_by_id);
$totalRows_get_unit_of_measure_by_id = mysql_num_rows($get_unit_of_measure_by_id);
?>
<?php
if (isset($_REQUEST['update'])) {
$unit_of_measure_update_query = "UPDATE unit_of_measure SET name='" . $_REQUEST['unit_name'] . "', qty_in_kg='" . $_REQUEST['qty_in_kg'] . "' WHERE id='" . $_REQUEST['unit_of_measure_id'] . "'";
$update_unit_of_measure_results = mysql_query($unit_of_measure_update_query, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("unit_of_measure_view", "2");
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="unit_form" id="unit_form">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">Unit Name:</td>
<td><input type="text" name="unit_name" value="<?php
echo $row_get_unit_of_measure_by_id["name"];
?>
" size="32" /></td>
<?php
echo $_REQUEST["action"];
?>
site Request Item<?php
echo $row_get_branch_by_id['name'];
?>
</div>
<div class="box">
<?php
if (isset($_POST["MM_insert"]) && $_POST["MM_insert"] == "site_req_item_form" && isset($_POST["save"])) {
$insertSQL = sprintf("INSERT INTO site_req_item (item_id, qty_required, site_req_id, unit_of_measure_id, created_by, created_date, record_status) VALUES (%s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['item_id'], "int"), GetSQLValueString($_POST['qty_required'], "double"), GetSQLValueString($_POST['pr_id'], "int"), GetSQLValueString($_POST['unit_of_measure_id'], "int"), GetSQLValueString($loggedin_id, "int"), GetSQLValueString(date("y-m-d"), "date"), GetSQLValueString($_POST['record_status'], "text"));
mysql_select_db($database_birus_conn, $birus_conn);
$Result1 = mysql_query($insertSQL, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn)) {
redirect_birus("site_req_item_view= true&site_req_id=" . $_REQUEST['pr_id'] . "", "2");
}
}
mysql_select_db($database_birus_conn, $birus_conn);
$query_item = "SELECT * FROM item";
$item = mysql_query($query_item, $birus_conn) or die(mysql_error());
$row_item = mysql_fetch_assoc($item);
$totalRows_item = mysql_num_rows($item);
mysql_select_db($database_birus_conn, $birus_conn);
$query_unit = "SELECT * FROM unit_of_measure";
$unit = mysql_query($query_unit, $birus_conn) or die(mysql_error());
$row_unit = mysql_fetch_assoc($unit);
$totalRows_unit = mysql_num_rows($unit);
$colname_site_req_item_by_id = "-1";
if (isset($_GET['id'])) {
$colname_site_req_item_by_id = $_GET['id'];
<?php
echo $_REQUEST["action"];
?>
Site Receive <?php
echo $row_get_branch_by_id['name'];
?>
</div>
<div class="box">
<?php
if (isset($_POST["MM_insert"]) && $_POST["MM_insert"] == "site_req_form") {
$insertSQL = sprintf("INSERT INTO site_req (site_id, req_no, created_by, created_date, record_status) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_SESSION['site_id'], "text"), GetSQLValueString($_POST['req_no'], "text"), GetSQLValueString($loggedin_id, "int"), GetSQLValueString(date("y-m-d"), "date"), GetSQLValueString($_POST['record_status'], "text"));
mysql_select_db($database_birus_conn, $birus_conn);
$Result1 = mysql_query($insertSQL, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn)) {
redirect_birus("site_req_view", "2");
}
}
mysql_select_db($database_birus_conn, $birus_conn);
$query_site_req_last_insert = "SELECT * FROM site_req ORDER BY id DESC LIMIT 0 ,1";
$site_req_last_insert = mysql_query($query_site_req_last_insert, $birus_conn) or die(mysql_error());
$row_site_req_last_insert = mysql_fetch_assoc($site_req_last_insert);
$totalRows_site_req_last_insert = mysql_num_rows($site_req_last_insert);
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_site = "SELECT id, name FROM site";
$get_site = mysql_query($query_get_site, $birus_conn) or die(mysql_error());
$row_get_site = mysql_fetch_assoc($get_site);
$totalRows_get_site = mysql_num_rows($get_site);
?>
<form action="<?php
echo $editFormAction;
$insertSQL = sprintf("INSERT INTO person (first_name, last_name, gender, created_by, created_date, record_status) VALUES (%s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['first_name'], "text"), GetSQLValueString($_POST['last_name'], "text"), GetSQLValueString($_POST['gender'], "text"), GetSQLValueString($loggedin_id, "int"), GetSQLValueString(date("y-m-d"), "date"), GetSQLValueString($_POST['record_status'], "text"));
mysql_select_db($database_birus_conn, $birus_conn);
$Result1 = mysql_query($insertSQL, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_person_last_insert = "SELECT id FROM person order by `id` desc LIMIT 1";
$get_person_last_insert = mysql_query($query_get_person_last_insert, $birus_conn) or die(mysql_error());
$row_get_person_last_insert = mysql_fetch_assoc($get_person_last_insert);
$query_supplier_add = sprintf("INSERT INTO supplier(additional_info,location_id,person_id, name, created_by, created_date, record_status) value(%s,%s,%s,%s,%s,%s,%s)", GetSQLValueString($row_get_location_last_insert['additional_info'], "text"), GetSQLValueString($row_get_location_last_insert['id'], "int"), GetSQLValueString($row_get_person_last_insert['id'], "int"), GetSQLValueString($_REQUEST['name'], "text"), GetSQLValueString($loggedin_id, "int"), GetSQLValueString(date("y-m-d"), "date"), GetSQLValueString($_POST['record_status'], "text"));
mysql_query($query_supplier_add, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
if (mysql_affected_rows($birus_conn) > 0) {
$query_contact_add = sprintf("INSERT INTO contact(person_id, email, phone_no, created_by, created_date, record_status) value(%s,%s,%s,%s,%s,%s)", GetSQLValueString($row_get_person_last_insert['id'], "int"), GetSQLValueString($_REQUEST['email'], "text"), GetSQLValueString($_REQUEST['phone_no'], "text"), GetSQLValueString($loggedin_id, "int"), GetSQLValueString(date("y-m-d"), "date"), GetSQLValueString($_POST['record_status'], "text"));
mysql_query($query_contact_add, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("supplier_view", "2");
}
}
}
}
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="form1" id="form1">
<table align="left">
<tr valign="baseline">
$totalRows_get_issued_by_id = mysql_num_rows($get_issued_by_id);
?>
<div class="page_title_bar">
<div class="page_title"><?php
echo $_REQUEST['action'];
?>
Site Item Issue</div>
</div>
<?php
if (isset($_REQUEST['update'])) {
$item_update_query = "UPDATE site_item_issue SET item_id='" . $_REQUEST['item_id'] . "', qty_issued='" . $_REQUEST['qty_issued'] . "' WHERE id='" . $_REQUEST['id'] . "'";
$update_item_results = mysql_query($item_update_query, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("site_item_issue_view", "2");
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="site_item_issue_form" id="site_item_issue_form">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">Item:</td>
<td><select name="item_id">
<?php
<?php
echo $_REQUEST["action"];
?>
site To Site Request Item<?php
echo $row_get_branch_by_id['name'];
?>
</div>
<div class="box">
<?php
if (isset($_POST["MM_insert"]) && $_POST["MM_insert"] == "site_to_site_req_item_form" && isset($_POST["save"])) {
$insertSQL = sprintf("INSERT INTO site_to_site_req_item (item_id, qty_required, site_to_site_req_id, unit_of_measure_id, created_by, created_date, record_status) VALUES (%s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_REQUEST['item_id'], "int"), GetSQLValueString($_REQUEST['qty_required'], "double"), GetSQLValueString($_REQUEST['site_to_site_req_id'], "int"), GetSQLValueString($_REQUEST['unit_of_measure_id'], "int"), GetSQLValueString($loggedin_id, "int"), GetSQLValueString(date("y-m-d"), "date"), GetSQLValueString($_REQUEST['record_status'], "text"));
mysql_select_db($database_birus_conn, $birus_conn);
$Result1 = mysql_query($insertSQL, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn)) {
redirect_birus("site_to_site_req_item_view= true&site_to_site_req_id=" . $_REQUEST['site_to_site_req_id'] . "&back_page=" . $_REQUEST['back_page'] . "", "2");
}
}
mysql_select_db($database_birus_conn, $birus_conn);
$query_item = "SELECT * FROM item";
$item = mysql_query($query_item, $birus_conn) or die(mysql_error());
$row_item = mysql_fetch_assoc($item);
$totalRows_item = mysql_num_rows($item);
mysql_select_db($database_birus_conn, $birus_conn);
$query_unit = "SELECT * FROM unit_of_measure";
$unit = mysql_query($query_unit, $birus_conn) or die(mysql_error());
$row_unit = mysql_fetch_assoc($unit);
$totalRows_unit = mysql_num_rows($unit);
$colname_site_to_site_req_item_by_id = "-1";
if (isset($_GET['id'])) {
$colname_site_to_site_req_item_by_id = $_GET['id'];
include "includes/notifications/headofconstruction.php";
get_main_menu("headofconstruction", $notification);
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_site_to_site_req = "\r\nSELECT person.first_name,\r\n person.last_name,\r\n site.name as site_name,\r\n site_to_site_req.id,\r\n\t site_to_site_req.req_no,\r\n site_to_site_req.site_id,\r\n site_to_site_req.created_date\r\n FROM ( ( birus.user user\r\n INNER JOIN\r\n birus.person person\r\n ON (user.person_id = person.id))\r\n INNER JOIN\r\n birus.site_to_site_req site_to_site_req\r\n ON (site_to_site_req.approved_by = user.id))\r\n INNER JOIN\r\n birus.site site\r\n ON (site_to_site_req.site_id = site.id)\r\n\t WHERE site_to_site_req.hoc_approved_date != '0000-00-00 00:00:00'\r\n";
$get_site_to_site_req = mysql_query($query_get_site_to_site_req, $birus_conn) or die(mysql_error());
$row_get_site_to_site_req = mysql_fetch_assoc($get_site_to_site_req);
$totalRows_get_site_to_site_req = mysql_num_rows($get_site_to_site_req);
?>
<?php
if (isset($_REQUEST['site_to_site_req_hoc_approve']) && $_REQUEST['site_to_site_req_hoc_approve'] == true) {
$approve_update = "UPDATE birus.site_to_site_req SET hoc_approved_date = '" . date("y-m-d") . "', hoc_approved_by = '" . $loggedin_id . "', hoc_approved='approved' WHERE site_to_site_req.id ='" . $_REQUEST['id'] . "';";
mysql_query($approve_update, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("site_to_site_req_hoc_approve_view", "2");
}
}
?>
<?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 to Site Approved Requsition</div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Req No</th>
<th>Site Name</th>
include "includes/notifications/storekeeper.php";
get_main_menu("storekeeper", $notification_store_keeper);
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_purchase_req = "SELECT person.first_name, person.last_name, person.id, purchase_req.id , purchase_req.req_no, purchase_req.created_date FROM ( birus.user user INNER JOIN birus.person person ON (user.person_id = person.id)) INNER JOIN birus.purchase_req purchase_req ON (purchase_req.created_by = user.id)\r\nwhere recieve_date='0000-00-00 00:00:00'\r\nAND approved_date!='0000-00-00 00:00:00'\r\n";
$get_purchase_req = mysql_query($query_get_purchase_req, $birus_conn) or die(mysql_error());
$row_get_purchase_req = mysql_fetch_assoc($get_purchase_req);
$totalRows_get_purchase_req = mysql_num_rows($get_purchase_req);
?>
<?php
if (isset($_REQUEST['purchase_req_recieve'])) {
$approve_update = "UPDATE birus.purchase_req SET recieve_date = '" . date("y-m-d") . "', recieved_by = '" . $loggedin_id . "' WHERE purchase_req.id ='" . $_REQUEST['id'] . "';";
mysql_query($approve_update, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("purchase_req_recieve_view", "2");
}
}
include "includes/table_settings.php";
?>
<div><a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a></div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Req No</th>
<th>Created By</th>
<th>Created Date</th>
<th></th>
<th></th>
</tr>
$Result1 = mysql_query($insertSQL, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn)) {
redirect_birus("role_view", "2");
}
}
?>
<div class="page_title">
<?php
if (isset($_REQUEST["update"])) {
if (isset($_REQUEST["id"])) {
mysql_select_db($database_birus_conn, $birus_conn);
$query_update_user = "******" . $_REQUEST['name'] . "' WHERE role.id='" . $_REQUEST["id"] . "'";
$results_user = mysql_query($query_update_user, $birus_conn) or die(mysql_error());
redirect_birus("role_view", "2");
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="Role" id="role_form">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">Name:</td>
<td><input type="text" name="name" value="<?php
echo $row_role_by_id['name'];
?>
" size="32" /></td>
</tr>
<?php
get_main_menu("sitestorekeeper");
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_site_to_site_req = "\r\n\tSELECT person.first_name,\r\n person.last_name,\r\n site.name as site_name,\r\n site_to_site_req.id,\r\n\t site_to_site_req.req_no,\r\n site_to_site_req.site_id,\r\n site_to_site_req.created_date,\r\n\t site_to_site_req.approved_date\r\n FROM ( ( birus.user user\r\n INNER JOIN\r\n birus.person person\r\n ON (user.person_id = person.id))\r\n INNER JOIN\r\n birus.site_to_site_req site_to_site_req\r\n ON (site_to_site_req.approved_issue_by = user.id))\r\n INNER JOIN\r\n birus.site site\r\n ON (site_to_site_req.site_id = site.id)\r\n\t \t Where site_to_site_req.issued='false'\r\n\t\t AND site_to_site_req.approved_issue_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.issued_date='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.approved_issue_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.hoc_approved_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.approved_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.site_to_id='" . $_SESSION['site_id'] . "'\r\n";
$get_site_to_site_req = mysql_query($query_get_site_to_site_req, $birus_conn) or die(mysql_error());
$row_get_site_to_site_req = mysql_fetch_assoc($get_site_to_site_req);
$totalRows_get_site_to_site_req = mysql_num_rows($get_site_to_site_req);
?>
<?php
if (isset($_REQUEST['site_to_site_req_issued'])) {
$approve_update = "UPDATE birus.site_to_site_req SET issued_date = '" . date("y-m-d") . "', issued_by = '" . $loggedin_id . "',issued = 'true' WHERE site_to_site_req.id ='" . $_REQUEST['id'] . "';";
mysql_query($approve_update, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("site_to_site_req_issue_view", "2");
}
}
?>
<?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 To Site Issue</div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Construction Site</th>
<th>Req No</th>
<?php
get_main_menu("sitesupervisor");
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_site_req = "\r\nSELECT person.first_name,\r\n person.last_name,\r\n site.name as site_name,\r\n site_req.id,\r\n\t site_req.req_no,\r\n site_req.site_id,\r\n site_req.created_date\r\n FROM ( ( birus.user user\r\n INNER JOIN\r\n birus.person person\r\n ON (user.person_id = person.id))\r\n INNER JOIN\r\n birus.site_req site_req\r\n ON (site_req.created_by = user.id))\r\n INNER JOIN\r\n birus.site site\r\n ON (site_req.site_id = site.id)\r\n\t where site_req.site_id=" . $_SESSION['site_id'] . "\r\n";
$get_site_req = mysql_query($query_get_site_req, $birus_conn) or die(mysql_error());
$row_get_site_req = mysql_fetch_assoc($get_site_req);
$totalRows_get_site_req = mysql_num_rows($get_site_req);
?>
<?php
if (isset($_REQUEST['site_req_approve'])) {
$approve_update = "UPDATE birus.site_req SET approved_date = '" . date("y-m-d") . "', approved_by = '" . $loggedin_id . "' WHERE site_req.id ='" . $_REQUEST['id'] . "';";
mysql_query($approve_update, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("site_req_approve_view", "2");
}
}
?>
<?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">Approve Requsition</div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Req No</th>
<th>Site Name</th>
?>
Site Activity<?php
echo $row_get_branch_by_id['name'];
?>
</div>
<div class="box">
<?php
if (isset($_REQUEST['save_activity'])) {
$site_id = $_REQUEST['site_id'];
if (isset($_POST['activity_ids'])) {
$optionArray = $_REQUEST['activity_ids'];
for ($i = 0; $i < count($optionArray); $i++) {
$activity_data = $optionArray[$i];
$spd_insert = mysql_query("INSERT INTO site_activity(site_id, activity_id,created_by, created_date, record_status) \r\n\t\t VALUES('{$site_id}','{$activity_data}','" . $loggedin_id . "','" . date("y-m-d") . "','" . $_POST['record_status'] . "')", $birus_conn) or die(mysql_query());
}
redirect_birus("site_activity_view&site_id=7", "2");
}
} else {
}
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_activity = "SELECT * FROM activity";
$get_activity = mysql_query($query_get_activity, $birus_conn) or die(mysql_error());
$row_get_activity = mysql_fetch_assoc($get_activity);
$totalRows_get_activity = mysql_num_rows($get_activity);
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="site_activity_form" id="site_activity_form">
<input name="site_id" type="hidden" value="<?php
echo $_REQUEST['site_id'];
include "includes/notifications/storekeeper.php";
get_main_menu("storekeeper", $notification_store_keeper);
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_purchase_req = "SELECT person.first_name, person.last_name, person.id, purchase_req.id , purchase_req.req_no, purchase_req.created_date FROM ( birus.user user INNER JOIN birus.person person ON (user.person_id = person.id)) INNER JOIN birus.purchase_req purchase_req ON (purchase_req.created_by = user.id)\r\nwhere recieve_date!='0000-00-00 00:00:00'\r\n";
$get_purchase_req = mysql_query($query_get_purchase_req, $birus_conn) or die(mysql_error());
$row_get_purchase_req = mysql_fetch_assoc($get_purchase_req);
$totalRows_get_purchase_req = mysql_num_rows($get_purchase_req);
?>
<?php
if (isset($_REQUEST['purchase_req_approve'])) {
$approve_update = "UPDATE birus.purchase_req SET approved_date = '" . date("y-m-d") . "', approved_by = '" . $loggedin_id . "' WHERE purchase_req.id ='" . $_REQUEST['id'] . "';";
mysql_query($approve_update, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("purchase_req_approve_view", "2");
}
}
include "includes/table_settings.php";
?>
<div><a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a></div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Req No</th>
<th>Created By</th>
<th>Created Date</th>
<th></th>
</tr>
</thead>
if (count($row_get_last_record_per_item) > 1) {
$previous_id = "'" . $row_get_last_record_per_item["id"] . "',";
$previous_id_place_holder = "previous_id,";
} else {
$previous_id = "";
$previous_id_place_holder = "";
}
$balace = $row_get_last_record_per_item["balance"] + $_REQUEST['qty_recieved'];
$query_insert_to_main_store = "INSERT INTO birus.main_store({$previous_id_place_holder} item_id , pr_item_id, balance, created_by, created_date, record_status)\r\nVALUES ({$previous_id}'" . $_REQUEST["item_id"] . "','" . $_REQUEST['pr_item_id'] . "','{$balace}','{$loggedin_id}','" . date("y-m-d") . "','" . $_REQUEST["record_status"] . "');";
$insert_record = mysql_query($query_insert_to_main_store, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0 && count($row_get_last_record_per_item) > 1) {
//Update The previous record with same Item.
$query_update_next_id = "UPDATE birus.main_store SET next_id = '' WHERE main_store.id ='" . $row_get_last_record_per_item['id'] . "'";
mysql_query($query_update_next_id, $birus_conn);
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("pr_item_recieve_view= true&purchase_req_id=" . $_REQUEST['pr_id'] . "", "2");
}
}
}
} else {
alert_redirect_birus("pr_item_recieve_view= true&purchase_req_id=" . $_REQUEST['pr_id'] . "", "2", "Already marked Received");
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="pr_item_form" id="pr_item_form">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">Item:</td>
if (count($row_get_last_record_per_item) > 1) {
$previous_id = "'" . $row_get_last_record_per_item["id"] . "',";
$previous_id_place_holder = "previous_id,";
} else {
$previous_id = "";
$previous_id_place_holder = "";
}
$balace = $row_get_last_record_per_item["balance"] + $_REQUEST['qty_recieved'];
$query_insert_to_site_store = "INSERT INTO birus.site_store(site_id, {$previous_id_place_holder} item_id , site_to_site_req_item_in_id, balance, created_by, created_date, record_status)\r\nVALUES ('" . $_SESSION["site_id"] . "',{$previous_id}'" . $_REQUEST["item_id"] . "','" . $_REQUEST['site_to_site_req_item_id'] . "','{$balace}','{$loggedin_id}','" . date("y-m-d") . "','" . $_REQUEST["record_status"] . "');";
$insert_record = mysql_query($query_insert_to_site_store, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0 && count($row_get_last_record_per_item) > 1) {
//Update The previous record with same Item.
$query_update_next_id = "UPDATE birus.site_store SET next_id = '' WHERE site_store.id ='" . $row_get_last_record_per_item['id'] . "'";
mysql_query($query_update_next_id, $birus_conn);
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("", "");
}
}
}
} else {
$message = "Already marked Received";
echo $message;
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="site_to_site_req_item_form" id="site_to_site_req_item_form">
<table align="left">
<tr valign="baseline">
} else {
$previous_id = "";
$previous_id_place_holder = "";
}
$balace = $row_get_last_record_per_item["balance"] + $_REQUEST['qty_recieved'];
$query_insert_to_site_store = "INSERT INTO birus.site_store(site_id,{$previous_id_place_holder} item_id , site_req_item_id, balance, created_by, created_date, record_status)\r\nVALUES ('" . $_REQUEST["site_id"] . "', {$previous_id}'" . $_REQUEST["item_id"] . "','" . $_REQUEST['site_req_item_id'] . "','{$balace}','{$loggedin_id}','" . date("y-m-d") . "','" . $_REQUEST["record_status"] . "');";
$insert_record = mysql_query($query_insert_to_site_store, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0 && count($row_get_last_record_per_item) > 1) {
//Update The previous record with same Item.
$query_update_next_id = "UPDATE birus.site_store SET next_id = '3' WHERE site_store.id ='" . $row_get_last_record_per_item['id'] . "'";
mysql_query($query_update_next_id, $birus_conn);
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("", "");
}
} else {
redirect_birus(".", "2");
}
}
} else {
$message = "Already marked Received";
echo $message;
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="site_req_item_form" id="site_req_item_form">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">Item:</td>
<?php
get_main_menu("sitestorekeeper");
mysql_select_db($database_birus_conn, $birus_conn);
$query_get_site_to_site_req = "SELECT site_to_site_req.req_no,\r\n site.name,\r\n person.first_name,\r\n person.last_name,\r\n site_to_site_req.issued_date,\r\n site_to_site_req.id,\r\n\t site_to_site_req.site_id\r\n FROM ( ( birus.site_to_site_req site_to_site_req\r\n INNER JOIN\r\n birus.site site\r\n ON (site_to_site_req.site_id = site.id))\r\n INNER JOIN\r\n birus.user user\r\n ON (site_to_site_req.issued_by = user.id))\r\n INNER JOIN\r\n birus.person person\r\n ON (user.person_id = person.id)\r\n\t where site_to_site_req.site_id=" . $_SESSION['site_id'] . "\r\n\t \t AND site_to_site_req.approved_issue_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.issued_date !='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.approved_issue_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.hoc_approved_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.approved_date!='0000-00-00 00:00:00'\r\n\t\t AND site_to_site_req.issued='true'\r\n\t\t AND site_to_site_req.recieved !='true'\r\n\t ";
$get_site_to_site_req = mysql_query($query_get_site_to_site_req, $birus_conn) or die(mysql_error());
$row_get_site_to_site_req = mysql_fetch_assoc($get_site_to_site_req);
$totalRows_get_site_to_site_req = mysql_num_rows($get_site_to_site_req);
include "includes/table_settings.php";
if (isset($_REQUEST['site_to_site_req_recieved'])) {
$approve_update = "UPDATE birus.site_to_site_req SET recieved_date = '" . date("y-m-d") . "', recieved_by = '" . $loggedin_id . "',recieved = 'true' WHERE site_to_site_req.id ='" . $_REQUEST['id'] . "';";
mysql_query($approve_update, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn) > 0) {
redirect_birus("site_to_site_req_recieve_view", "2");
}
}
?>
<div><a href="."><img src="images/back-button.png" width="30" height="30" title="Back" /></a></div>
<div class="module_title">Site To Site Receive</div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<th>Id</th>
<th>Req No</th>
<th>Issued By</th>
<th>Issue Date</th>
<th></th>
<th></th>
</tr>
</thead>
<tbody>
if (isset($_REQUEST["id"])) {
mysql_select_db($database_birus_conn, $birus_conn);
$query_update_user = "******" . $_REQUEST['username'] . "',\r\n\t\t\trole_id='" . $_REQUEST['role_id'] . "',site_id='" . $_REQUEST['site_id'] . "' WHERE user.id='" . $_REQUEST["id"] . "'";
$results_user = mysql_query($query_update_user, $birus_conn) or die(mysql_error());
}
if (isset($_REQUEST["person_id"])) {
mysql_select_db($database_birus_conn, $birus_conn);
$query_update_person = "update person set first_name='" . $_REQUEST['first_name'] . "', \r\n\t\t\tgender='" . $_REQUEST['gender'] . "' WHERE person.id='" . $_REQUEST["person_id"] . "'";
$results_person = mysql_query($query_update_person, $birus_conn) or die(mysql_error());
}
if (isset($_REQUEST["contact_id"])) {
mysql_select_db($database_birus_conn, $birus_conn);
$query_update_contact = "UPDATE contact set phone_no='" . $_REQUEST['phone_no'] . "', \r\n\t\t\temail='" . $_REQUEST['email'] . "' WHERE contact.id='" . $_REQUEST["contact_id"] . "'";
$results_contacts = mysql_query($query_update_contact, $birus_conn) or die(mysql_error());
}
redirect_birus("user_view", "2");
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="form1" id="form1">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">First Name:</td>
<td><span id="sprytextfield1">
<input type="text" name="first_name" value="<?php
echo $row_user_by_id['first_name'];
?>
" size="32" />
<span class="textfieldRequiredMsg">Enter First Name.</span></span></td>
mysql_select_db($database_birus_conn, $birus_conn);
$Result1 = mysql_query($insertSQL, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn)) {
redirect_birus("activity_view", "2");
}
}
?>
<div class="page_title">
<?php
if (isset($_REQUEST["update"])) {
if (isset($_REQUEST["id"])) {
mysql_select_db($database_birus_conn, $birus_conn);
$query_update_user = "******" . $_REQUEST['name'] . "' WHERE activity.id='" . $_REQUEST["id"] . "'";
$results_user = mysql_query($query_update_user, $birus_conn) or die(mysql_error());
redirect_birus("activity_view", "2");
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="Role" id="activity_form">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">Activity Name:</td>
<td><input type="text" name="name" value="<?php
echo $row_activity_by_id['name'];
?>
" size="32" /></td>
</tr>
$insertSQL = sprintf("INSERT INTO `item` (name, restock_level, created_by, created_date, record_status) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_POST['name'], "text"), GetSQLValueString($_POST['restock_level'], "int"), GetSQLValueString($loggedin_id, "int"), GetSQLValueString(date("y-m-d"), "date"), GetSQLValueString($_POST['record_status'], "text"));
mysql_select_db($database_birus_conn, $birus_conn);
$Result1 = mysql_query($insertSQL, $birus_conn) or die(mysql_error());
if (mysql_affected_rows($birus_conn)) {
redirect_birus("item_view", "2");
}
}
?>
<?php
if (isset($_REQUEST["update"])) {
if (isset($_REQUEST["id"])) {
mysql_select_db($database_birus_conn, $birus_conn);
$query_update_user = "******" . $_REQUEST['name'] . "',restock_level='" . $_REQUEST['restock_level'] . "' WHERE item.id='" . $_REQUEST["id"] . "'";
$results_user = mysql_query($query_update_user, $birus_conn) or die(mysql_error());
redirect_birus("item_view", "2");
}
}
?>
<form action="<?php
echo $editFormAction;
?>
" method="post" name="Role" id="item_form">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="left">Item Name:</td>
<td><input type="text" name="name" value="<?php
echo $row_item_by_id['name'];
?>
" size="32" /></td>
</tr>
