function getUser()
{
$userID = "";
$userID = getPost('userID');
if (empty($userID)) {
$userID = getQString('u');
if (empty($userID)) {
$userID = getQString('');
}
echo "<p class='debug'>User By Query: {$userID}</p>";
} else {
echo "<p class='debug'>User By Post: {$userID}</p>";
}
if (strlen($userID) > 3) {
$userID = null;
}
return $userID;
}
$MainPathSteps = getPost('MainPathSteps');
$AlternatePathSteps = getPost('AlternatePathSteps');
$SuccessCriteria = getPost('SuccessCriteria');
$PotentialFailures = getPost('PotentialFailures');
$FrequencyOfUse = getPost('FrequencyOfUse');
$OwnerUserID = getPost('OwnerUserID');
$PriorityID = getPost('PriorityID');
$CaseStatusID = getPost('CaseStatusID');
$fields = "UseCaseTitle, UseCaseDescription, PrimaryActor, AlternateActors, PreRequisits, PostConditions, MainPathSteps, AlternatePathSteps, SuccessCriteria, PotentialFailures, FrequencyOfUse, OwnerUserID, PriorityID, CaseStatusID";
$qString = $action = $value = $id = $filterBy = $orderBy = "";
$qString = $_SERVER['QUERY_STRING'];
if ($qString != "") {
$action = getQString('action');
//list, select, sort, add, edit, delete, filter, like
$value = getQString('v');
$id = getQString('i');
}
if (empty($UseCaseID) and !empty($id)) {
$UseCaseID = $id;
}
function addUseCaseItem($UseCaseTitle, $UseCaseDescription, $PrimaryActor, $AlternateActors, $PreRequisits, $PostConditions, $MainPathSteps, $AlternatePathSteps, $SuccessCriteria, $PotentialFailures, $FrequencyOfUse, $OwnerUserID, $PriorityID, $CaseStatusID)
{
try {
include_once './panels/dbConnect.php';
$dbh = OpenConn();
$stmt = $dbh->prepare("INSERT INTO tUseCase (UseCaseTitle, UseCaseDescription, PrimaryActor, AlternateActors, PreRequisits, PostConditions, MainPathSteps, AlternatePathSteps, SuccessCriteria, PotentialFailures, FrequencyOfUse, OwnerUserID, PriorityID, CaseStatusID) VALUES (:UseCaseTitle, :UseCaseDescription, :PrimaryActor, :AlternateActors, :PreRequisits, :PostConditions, :MainPathSteps, :AlternatePathSteps, :SuccessCriteria, :PotentialFailures, :FrequencyOfUse, :OwnerUserID, :PriorityID, :CaseStatusID)");
$stmt->bindParam(':UseCaseTitle', $UseCaseTitle);
$stmt->bindParam(':UseCaseDescription', $UseCaseDescription);
$stmt->bindParam(':PrimaryActor', $PrimaryActor);
$stmt->bindParam(':AlternateActors', $AlternateActors);
$stmt->bindParam(':PreRequisits', $PreRequisits);
$inventoryCondition = getPost('inventoryCondition');
$picture1 = getPost('picture1Path');
$picture2 = getPost('picture2Path');
$action = getPost('action');
$upc = getPost('upc');
$filterBy = getPost('orderBy');
$sortBy = getPost('sortBy');
$customID = getPost('customID');
$qString = $_SERVER['QUERY_STRING'];
if ($qString != "") {
$userID = getQString('u');
$action = getQString('action');
//list, select, sort, add, edit, delete, filter, like
$value = getQString('v');
$id = getQString('i');
$customID = getQString('c');
}
include_once 'dbConnect.php';
include_once './panels/getDropdown.php';
$inventoryQuery = "SELECT InventoryID, \tInventoryDescription, InventoryTypeID,\tPurchasePrice,\tPurchaseLocation,\tInventoryLocationID,\tInventoryOwnerID, Picture1Location, Picture2Location,\tDateSold, InventoryConditionID, UPC, CustomID from tInventory";
switch ($action) {
case "list":
break;
case "sort":
$listQuery = $listQuery . " ORDER BY {$value}";
break;
case "filter":
$listQuery = $listQuery . " WHERE {$columnName} = {$value}";
break;
case "like":
$listQuery = $listQuery . " WHERE {$columnName} like '%" . $value . "%'";
