function dropDatabase() { global $config; $pdo = PDOBuilder::getPdo(); if ($config['db_type'] == "mysql") { $sqls = array("DROP TABLE APPLICATIONS;", "DROP TABLE ROLES;", "DROP TABLE ORDERS;", "DROP TABLE ORDERLINES", "DROP TABLE TARIFFAREAS", "DROP TABLE PEOPLE;", "DROP TABLE RESOURCES;", "DROP TABLE PROVIDERS;", "DROP TABLE DISCOUNTPROFILES;", "DROP TABLE TAXCUSTCATEGORIES;", "DROP TABLE CUSTOMERS;", "DROP TABLE CATEGORIES;", "DROP TABLE TAXCATEGORIES;", "DROP TABLE TAXES;", "DROP TABLE ATTRIBUTE;", "DROP TABLE ATTRIBUTEVALUE;", "DROP TABLE ATTRIBUTESET;", "DROP TABLE ATTRIBUTEUSE;", "DROP TABLE ATTRIBUTESETINSTANCE;", "DROP TABLE ATTRIBUTEINSTANCE;", "DROP TABLE PRODUCTS;", "DROP TABLE PRODUCTS_CAT;", "DROP TABLE PRODUCTS_COM;", "DROP TABLE SUBGROUPS;", "DROP TABLE SUBGROUPS_PROD;", "DROP TABLE TARIFFAREAS;", "DROP TABLE TARIFFAREAS_PROD;", "DROP TABLE LOCATIONS;", "DROP TABLE STOCKDIARY;", "DROP TABLE STOCKLEVEL;", "DROP TABLE STOCKCURRENT;", "DROP TABLE STOCK_INVENTORY;", "DROP TABLE STOCK_INVENTORYITEM;", "DROP TABLE CASHREGISTERS;", "DROP TABLE CURRENCIES;", "DROP TABLE CLOSEDCASH;", "DROP TABLE PAYMENTMODES;", "DROP TABLE PAYMENTMODES_RETURNS;", "DROP TABLE PAYMENTMODES_VALUES;", "DROP TABLE RECEIPTS;", "DROP TABLE TICKETS;", "DROP TABLE TICKETLINES;", "DROP TABLE PAYMENTS;", "DROP TABLE TAXLINES;", "DROP TABLE FLOORS;", "DROP TABLE PLACES;", "DROP TABLE RESERVATIONS;", "DROP TABLE RESERVATION_CUSTOMERS;", "DROP TABLE THIRDPARTIES;", "DROP TABLE SHAREDTICKETS;", "DROP TABLE SHAREDTICKETLINES;"); } else { if ($config['db_type'] == "postgresql") { $sqls = array("DROP TABLE APPLICATIONS;", "DROP TABLE ROLES;", "DROP TABLE ORDERS;", "DROP TABLE ORDERLINES", "DROP TABLE TARIFFAREAS", "DROP TABLE PEOPLE;", "DROP TABLE RESOURCES;", "DROP TABLE PROVIDERS;", "DROP SEQUENCE DISCOUNTPROFILES_ID_SEQ CASCADE;", "DROP TABLE DISCOUNTPROFILES;", "DROP TABLE TAXCUSTCATEGORIES;", "DROP TABLE CUSTOMERS;", "DROP TABLE CATEGORIES;", "DROP TABLE TAXCATEGORIES;", "DROP TABLE TAXES;", "DROP TABLE ATTRIBUTE;", "DROP TABLE ATTRIBUTEVALUE;", "DROP TABLE ATTRIBUTESET;", "DROP TABLE ATTRIBUTEUSE;", "DROP TABLE ATTRIBUTESETINSTANCE;", "DROP TABLE ATTRIBUTEINSTANCE;", "DROP TABLE PRODUCTS;", "DROP TABLE PRODUCTS_CAT;", "DROP TABLE PRODUCTS_COM;", "DROP SEQUENCE SUBGROUPS_ID_SEQ", "DROP TABLE SUBGROUPS;", "DROP TABLE SUBGROUPS_PROD;", "DROP SEQUENCE TARIFFAREAS_ID_SEQ CASCADE;", "DROP TABLE TARIFFAREAS;", "DROP TABLE TARIFFAREAS_PROD;", "DROP TABLE LOCATIONS;", "DROP TABLE STOCKDIARY;", "DROP TABLE STOCKLEVEL;", "DROP TABLE STOCKCURRENT;", "DROP SEQUENCE STOCK_INVENTORY_ID_SEQ CASCADE;", "DROP SEQUENCE STOCK_INVENTORYITEM_ID_SEQ;", "DROP TABLE STOCK_INVENTORY;", "DROP TABLE STOCK_INVENTORYITEM;", "DROP SEQUENCE CASHREGISTERS_ID_SEQ CASCADE", "DROP TABLE CASHREGISTERS;", "DROP SEQUENCE CURRENCIES_ID_SEQ CASCADE;", "DROP TABLE CURRENCIES;", "DROP TABLE CLOSEDCASH;", "DROP SEQUENCE PAYMENTMODES_ID_SEQ CASCADE;", "DROP TABLE PAYMENTMODES;", "DROP TABLE PAYMENTMODES_RETURNS;", "DROP TABLE PAYMENTMODES_VALUES;", "DROP TABLE RECEIPTS;", "DROP TABLE TICKETS;", "DROP TABLE TICKETLINES;", "DROP TABLE PAYMENTS;", "DROP TABLE TAXLINES;", "DROP TABLE FLOORS;", "DROP TABLE PLACES;", "DROP TABLE RESERVATIONS;", "DROP TABLE RESERVATION_CUSTOMERS;", "DROP TABLE THIRDPARTIES;", "DROP TABLE SHAREDTICKETS;", "DROP TABLE SHAREDTICKETLINES;"); } } for ($i = count($sqls) - 1; $i >= 0; $i--) { if ($pdo->exec($sqls[$i]) === false) { echo "[ERROR] Could not execute " . $sqls[$i] . "\n"; } } }
public function delete($id) { $pdo = PDOBuilder::getPdo(); $newTransaction = !$pdo->inTransaction(); if ($newTransaction) { $pdo->beginTransaction(); } // Delete rules $stmt = $pdo->prepare("DELETE FROM PAYMENTMODES_RETURNS " . "WHERE PAYMENTMODE_ID = :id;"); $stmt->bindValue(":id", $id); if ($stmt->execute() === false) { if ($newTransaction) { $pdo->rollback(); } return false; } // Delete values $stmtVal = $pdo->prepare("DELETE FROM PAYMENTMODES_VALUES " . "WHERE PAYMENTMODE_ID = :id;"); $stmtVal->bindValue(":id", $id); if ($stmtVal->execute() === false) { if ($newTransaction) { $pdo->rollback(); } return false; } // Delete mode $del = parent::delete($id); if ($del === false) { if ($newTransaction) { $pdo->rollback(); } return false; } else { if ($newTransaction) { $pdo->commit(); } return $del; } }
public function toggle($id) { $pdo = PDOBuilder::getPdo(); $newTransaction = !$pdo->inTransaction(); if ($newTransaction) { $pdo->beginTransaction(); } $stmt = $pdo->prepare("UPDATE PAYMENTMODES SET ACTIVE=NOT(ACTIVE) WHERE ID = :id;"); $stmt->bindValue(":id", $id); if ($stmt->execute() === false) { if ($newTransaction) { $pdo->rollback(); } return false; } if ($newTransaction) { $pdo->commit(); } return true; }