public function deleteBox($barcode)
{
$this->connection->query("begin;");
$query = "\n\t\tSELECT COUNT(a_barcode)\n\t\tFROM assets\n\t\tWHERE a_box = {$barcode};";
$this->connection->query($query);
$row = $this->connection->fetch_row();
if ($row[0] != 0) {
echo "Cannot delete an Assest Type that is currently being used by assets<br><br>";
} else {
$query = "DELETE FROM boxes WHERE b_barcode = {$barcode};";
$this->connection->query($query);
//log away
$user = new User();
$logEntry = new LogEntry($this->connection);
$logEntry->setBarcode($barcode);
$logEntry->setPerson($user->get_Username());
$logEntry->setType("Box Deleted");
$logEntry->insert();
}
$this->connection->query("commit;");
}
public function deleteAsset($barcode)
{
$this->connection->query("begin;");
//log this sad event
$user = new User();
$logEntry = new LogEntry($this->connection);
$logEntry->setBarcode($barcode);
$logEntry->setPerson($user->get_Username());
$logEntry->setType("Asset Deleted");
$logEntry->insert();
$query = "DELETE FROM assets WHERE a_barcode = '{$barcode}'";
$this->connection->query($query);
$this->connection->query("commit;");
}
