if (mysql_errno() != 0) {
sqlError(mysql_errno(), mysql_error());
}
if (mysql_num_rows($result) == 0) {
// itemID is not an equipment ---> invalid itemID
$response['status'] = 1;
$response['message'] = "This user does not have any loans with this item id";
echo json_encode($response);
exit(0);
} else {
$type = "Equipment";
}
} else {
$type = "Kit";
}
$response = getEquipment($userid, $itemID, $type);
$r = mysql_fetch_assoc($result);
$loan_length = $r['loan_length'];
switch ($r['status']) {
case 7:
$loan_type = "Long Term";
break;
default:
$loan_type = "Short Term";
break;
}
// Build item information html
$loanInformation = "<div class='pf-element'><div class='pf-description-float'>Item Type:</div><div class='pf-content-float'><input type='text' id='item-type' class='readonly' readonly='readonly' value='" . $type . "'/></div><div class='clear'></div></div>";
$loanInformation = $loanInformation . "<div class='pf-element'><div class='pf-description-float'>Loan Type:</div><div class='pf-content-float'><input type='text' id='item-type' class='readonly' readonly='readonly' value='" . $loan_type . "'/></div><div class='clear'></div></div>";
$loanInformation = $loanInformation . "<div class='pf-element'><div class='pf-description-float'>Loan Length:</div><div class='pf-content-float'><input type='text' id='item-type' class='readonly' readonly='readonly' value='" . $loan_length . "'/></div><div class='clear'></div></div>";
$response['loanInformation'] = $loanInformation;
break;
case "Equipment":
$query = $query . " ) AND equipmentid =" . $itemID;
break;
}
$result = mysql_query($query);
if (mysql_errno() != 0) {
sqlError(mysql_errno(), mysql_error());
}
if (mysql_num_rows($result) == 0) {
$response['status'] = 1;
$response['message'] = "User does not have access for this " . strtolower($type);
echo json_encode($response);
exit(0);
}
$response = getEquipment($itemID, $type);
$response['status'] = 0;
echo json_encode($response);
exit(0);
}
function getEquipment($itemID, $type)
{
$query = "";
switch ($type) {
case "Kit":
$query = $query . "SELECT * FROM equipments WHERE kitid = '" . $itemID . "' AND status<>-1";
break;
case "Equipment":
$query = $query . "SELECT * FROM equipments WHERE equipmentid = '" . $itemID . "' AND status<>-1";
break;
}
