if (mysql_errno() != 0) {
sqlError(mysql_errno(), mysql_error());
}
while ($r = mysql_fetch_assoc($result)) {
$eqID = $r['equipmentid'];
$notes = $r['notes'] . "\n\n {$userid} lost this item on: " . friendlyDateNoTime($return_date);
$updateQuery = "UPDATE equipments SET notes='{$notes}', condID=6 WHERE equipmentID='{$eqID}'";
mysql_query($updateQuery);
if (mysql_errno() != 0) {
sqlError(mysql_errno(), mysql_error());
}
}
// add the broken equipment to the users account
$query = "SELECT notes FROM users WHERE userID='{$userid}' AND deptID=" . $_SESSION['dept'];
$result = mysql_query($query);
if (mysql_errno() != 0) {
sqlError(mysql_errno(), mysql_error());
}
$r = mysql_fetch_assoc($result);
$notes = $r['notes'] . "\n\n User lost the following equipment: {$missingEQ} on: " . friendlyDateNoTime($return_date);
$updateQuery = "UPDATE users SET notes='{$notes}' WHERE userID='{$userid}' AND deptID=" . $_SESSION['dept'];
mysql_query($updateQuery);
if (mysql_errno() != 0) {
sqlError(mysql_errno(), mysql_error());
}
}
$response['status'] = 0;
$response['message'] = $type . " returned.";
echo json_encode($response);
exit(0);
}
echo str_replace("\n", "<br/>", $res['notes']);
?>
</div>
<div class='clear'></div>
</div>
</fieldset>
<br/>
<fieldset>
<legend>Purchase Information</legend>
<div class="pf-element">
<div class='pf-description-float'>
Purchase Date:
</div>
<div class='pf-content-float'>
<?php
echo friendlyDateNoTime($res['purchaseDate']);
?>
</div>
<div class='clear'></div>
</div>
<div class="pf-element">
<div class='pf-description-float'>
Purchase Price:
</div>
<div class='pf-content-float'>
<?php
echo $res['purchasePrice'];
?>
</div>
<div class='clear'></div>
</div>
<table class='loanReport-details-table'>
<tr class='loanReport-header'>
<td class='loanReport-headerElement'>Equipment ID</td>
<td class='loanReport-headerElement'>User ID</td>
<td class='loanReport-headerElement'>Due Date</td>
<td class='loanReport-headerElement'>Return Date</td>
<td class='loanReport-headerElement'>Fine</td>
</tr>
<?php
while ($r = mysql_fetch_assoc($kitsOverdueResult)) {
echo "<tr>";
echo "<td class='loanReport-tableElement'>" . $r['kitid'] . "</td>";
echo "<td class='loanReport-tableElement'>" . $r['userid'] . "</td>";
echo "<td class='loanReport-tableElement'>" . friendlyDateNoTime($r['due_date']) . "</td>";
echo "<td class='loanReport-tableElement'>";
if ($r['return_date'] == 0) {
echo "--";
} else {
echo friendlyDateNoTime($r['return_date']);
}
echo "</td>";
echo "<td class='loanReport-tableElement'>" . $r['fine'] . "</td>";
echo "</tr>";
}
?>
</table>
</div>
</div>
</body>
</html>
