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;"); }