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>