public static function getRoles()
 {
     $db = Database::getInstance(DatabaseConfig::DB_INSTANCE);
     $result = $db->prepare("\n            SELECT * FROM roles\n        ");
     $result->execute();
     $roles = [];
     if ($result->rowCount() > 0) {
         $roles = $result->fetchAll(\PDO::FETCH_KEY_PAIR);
     }
     return array_flip($roles);
 }
 public function checkoutCart($userId, $cartId)
 {
     $products = $this->getProductsInCart($cartId);
     $promoRepo = new PromotionsRepository();
     $this->db->beginTransaction();
     $price = 0;
     foreach ($products as $product) {
         if ($product['quantity'] > $product['product_max_quantity']) {
             $this->db->rollBack();
             throw new \Exception("Product quantity");
         }
         $discount = $promoRepo->getTheBiggestPromotion($userId, $product['id'], $product['category_id']);
         $price += $product['price'] * $product['quantity'] - $product['price'] * $product['quantity'] * $discount / 100;
         $statement = $this->db->prepare("\n                UPDATE products\n                SET quantity = quantity - ?\n                WHERE id = ?\n            ");
         $statement->execute([$product['quantity'], $product['id']]);
     }
     $statement = $this->db->prepare("\n            SELECT cash FROM users WHERE id = ?\n        ");
     $statement->execute([$userId]);
     $userCash = $statement->fetch();
     if ($price > $userCash) {
         $this->db->rollBack();
         return false;
     }
     $statement = $this->db->prepare("\n            UPDATE users\n            SET cash = cash - ?\n            WHERE id = ?\n        ");
     $statement->execute([$price, $userId]);
     if ($statement->rowCount() <= 0) {
         $this->db->rollBack();
         return false;
     }
     $statement = $this->db->prepare("\n            DELETE FROM cart_products\n            WHERE cart_id = ?\n        ");
     $statement->execute([$cartId]);
     if ($statement->rowCount() < 0) {
         $this->db->rollBack();
         return false;
     }
     foreach ($products as $product) {
         $statement = $this->db->prepare("\n                INSERT INTO user_products (user_id, name, quantity, details, price)\n                VALUES (?, ?, ?, ?, ?)\n            ");
         $statement->execute([$userId, $product['name'], $product['quantity'], $product['details'], $product['price']]);
         if ($statement->rowCount() < 0) {
             $this->db->rollBack();
             return false;
         }
     }
     $this->db->commit();
     return true;
 }
 public function __construct()
 {
     $this->db = Database::getInstance(DatabaseConfig::DB_INSTANCE);
 }
Exemplo n.º 4
0
 private function registerDatabaseConfiguration()
 {
     \DF\Core\Database::setInstance(\DF\Config\DatabaseConfig::DB_INSTANCE, \DF\Config\DatabaseConfig::DB_DRIVER, \DF\Config\DatabaseConfig::DB_USER, \DF\Config\DatabaseConfig::DB_PASSWORD, \DF\Config\DatabaseConfig::DB_NAME, \DF\Config\DatabaseConfig::DB_HOST);
 }
 private function isBannedByIP()
 {
     $db = Database::getInstance(DatabaseConfig::DB_INSTANCE);
     $statement = $db->prepare("\n            SELECT ip_address FROM blacklist\n        ");
     $statement->execute();
     $blacklist = $statement->fetchAll();
     if (in_array($_SERVER['REMOTE_ADDR'], $blacklist)) {
         header("location: http://www.google.com/");
         exit;
     }
 }