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