function getLocation($status, $data)
{
$DB = new conn();
$DB->connect();
$location = "";
if ($status == 1) {
// Get Office Location
$sql = "select storagelocation_name from storagelocations where storagelocation_id = " . $data;
$location = $DB->query_scalar($sql) . "<br /><br />";
}
if ($status == 2) {
// Get Employee Address
$sql = "select Username from users where user_id = " . $data;
$location = $DB->query_scalar($sql) . "<br /><br />";
}
if ($status == 3) {
$location = "Transferred<br/>";
}
if ($status == 4 || $status == 5) {
// Get customer address
$sql = "select contacts.* from orders join contacts on orders.contact_id = contacts.contact_id where orders.order_id = " . $data;
$result = $DB->query($sql);
if ($result) {
$row = mysql_fetch_assoc($result);
$location = $row["contact_address"] . "<br />" . $row["contact_city"] . " " . $row["contact_state"] . ", " . $row["contact_zipcode"];
}
}
return $location;
}
public function LoadData()
{
$DB = new conn();
$DB->connect();
$sql = "SELECT * FROM finance_options";
$result = $DB->query($sql);
while ($row = mysql_fetch_assoc($result)) {
$financeDetails[] = $row;
}
$DB->close();
return $financeDetails;
}
<?php
include "./findconfig.php";
include $_SERVER['DOCUMENT_ROOT'] . "/" . $ROOTPATH . "/Includes/Top.php";
$DB = new conn();
$DB->connect();
$sql = "Select * from StorageLocations";
$result = $DB->query($sql);
if ($result) {
?>
<TABLE class="data">
<th>id</th>
<th>Location Name</th>
<th>Commands</th>
<?php
while ($row = mysql_fetch_assoc($result)) {
?>
<TR><TD><?php
echo $row["storagelocation_id"];
?>
</TD>
<TD><?php
echo $row["storagelocation_name"];
?>
</TD>
<TD><a href="#">Edit</a></TD>
</TR>
<?php
}
?>
</TABLE> <?php
<?php
include "./findconfig.php";
include $_SERVER['DOCUMENT_ROOT'] . "/" . $ROOTPATH . "/Includes/Top.php";
$F = new FormElements();
$db = new conn();
$firephp->log($_REQUEST);
if ($_REQUEST["report"]) {
// Inventory Report
if ($_REQUEST["report"] == "inventory") {
if ($_REQUEST["StartDate"] && $_REQUEST["EndDate"]) {
$db->connect();
$startDate = $db->Sanitize($_REQUEST["StartDate"]);
$endDate = $db->Sanitize($_REQUEST["EndDate"]);
$productType = $db->Sanitize($_REQUEST["ProductType"]);
$db->close();
header("Location: NexusReport_Inventory.php?startDate=" . $startDate . "&endDate=" . $endDate . "&productType=" . $productType);
}
}
$firephp->log($_REQUEST["report"]);
$firephp->log($_REQUEST["generalSalesStartDate"]);
$firephp->log($_REQUEST["generalSalesEndDate"]);
// Individual Sale
if ($_REQUEST["report"] == "IndividualOrder") {
if ($_REQUEST["OrderID"]) {
$db->connect();
$order_id = $DB->sanitize($_REQUEST["OrderID"]);
$db->close();
header("Location: NexusReport_IndividualOrder.php?OrderID=" . $order_id);
}
}
public function delete($where, $tabela)
{
/**
*@param deleta registro no banco de dados
*@return retorna 1 caso não ocorra erro
*@throws $e
*/
try {
$con = new conn();
$con->connect();
return $con->mysqli->query("DELETE FROM " . $tabela . " WHERE " . $where . "");
} catch (mysqli_sql_exception $e) {
return $this->errors($e, "delete");
}
}
function ddlTeams($selected = "", $css = "")
{
?>
<li class="validated" style="<?php
echo $css;
?>
" id="tbTeams_li">
<label for="r_tbTeams">Team:</label>
<div id="tbTeams_img"></div>
<select class="validated" name="Teams" id="ddlTeams" >
<?php
$DB = new conn();
$DB->connect();
$perms = $DB->getTeams();
$DB->close();
foreach ($perms as $perm) {
?>
<OPTION value="<?php
echo $perm["team_id"];
?>
"><?php
echo $perm["team_name"];
?>
(<?php
echo $perm["LastName"];
?>
)</OPTION><?php
}
?>
</SELECT>
<div id="tbTeams_msg"></div>
</li>
<?php
if ($selected) {
?>
<SCRIPT type="text/javascript">
$('#ddl<?php
echo $id;
?>
').val("<?php
echo $selected;
?>
");
</SCRIPT>
<?php
}
?>
<?php
}
