public function addAudit($type, $data)
{
$audit = new Audit();
$audit->user = $this->user->id;
$audit->ip = $_SERVER['REMOTE_ADDR'];
$audit->time = date("Y-m-d H:i:s");
$audit->time = gmdate('Y-m-d H:i:s', strtotime($audit->time));
$audit->type = $type;
$audit->details = $data;
$currentEmpId = $this->getCurrentProfileId();
if (!empty($currentEmpId)) {
$employee = $this->baseService->getElement('Employee', $this->getCurrentProfileId(), null, true);
$audit->employee = $employee->first_name . " " . $employee->last_name . " [EmpId = " . $employee->employee_id . "]";
}
$ok = $audit->Save();
if (!$ok) {
LogManager::getInstance()->info("Error adding audit:" . $audit->ErrorMsg());
}
}
unset($objNewAuditScan);
}
}
}
}
}
if ($objAuditScanArray) {
try {
// Get an instance of the database
$objDatabase = QApplication::$Database[1];
// Begin a MySQL Transaction to be either committed or rolled back
$objDatabase->TransactionBegin();
$objAudit = new Audit();
$objAudit->EntityQtypeId = 2;
// Inventory
$objAudit->Save();
foreach ($objAuditScanArray as $objAuditScan) {
$objAuditScan->AuditId = $objAudit->AuditId;
$objAuditScan->Save();
}
$objDatabase->TransactionCommit();
$strWarning .= "Your transaction has successfully completed<br /><a href='index.php'>Main Menu</a> | <a href='inventory_menu.php'>Inventory Menu</a><br />";
//Remove that flag when transaction is compelete or exists some errors
unset($_SESSION['intUserAccountId']);
$blnTransactionComplete = true;
} catch (QExtendedOptimisticLockingException $objExc) {
// Rollback the database
$objDatabase->TransactionRollback();
}
} else {
$strWarning = 'No locations have been added. You must click Apply after each location audit.<br />';