} } } 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 />'; } } } elseif ($_POST['method'] == 'next_location') {