Example #1
0
                 }
             }
         }
         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') {