public function setUp() { $this->db = DB::getInstance(); $this->curl = new CURL(self::URL); $this->db->query(' DELETE FROM owner; ALTER SEQUENCE owner_id_seq RESTART 1; '); }
public function delete($categoryId) { $conn = DB::connect(); $deleteCategorySql = 'UPDATE categories SET isDeleted = 1 WHERE id="' . $categoryId . '"'; if ($conn->query($deleteCategorySql)) { View::$viewBag['successMessage'] = "Category successfully deleted"; } else { View::$viewBag['errors'][] = "Database error"; } }
public function __construct($class) { $this->db = DB::getInstance(); $this->class = $class; $reflectionClass = new ReflectionClass($class); $docComment = $reflectionClass->getDocComment(); $docComment = str_replace(' ', '', $docComment); if (preg_match('/@Entity/', $docComment)) { preg_match('/@Table\\(name="([a-z]+)"\\)/', $docComment, $matches); $this->table = $matches[1]; foreach ($reflectionClass->getProperties() as $reflectionProperty) { $field = new stdClass(); $field->name = $reflectionProperty->getName(); $docComment = $reflectionProperty->getDocComment(); $docComment = str_replace(' ', '', $docComment); if (!preg_match('/@Transient/', $docComment)) { if (preg_match('/@Id/', $docComment)) { $this->id = $field->name; } preg_match('/@Column\\(name="([a-z_]+)"\\)/', $docComment, $matches); $field->column = $matches[1]; if (preg_match('/@NotNull/', $docComment)) { $field->notnull = true; } preg_match('/@Type([a-z]+)/', $docComment, $matches); $field->type = $matches[1]; if (preg_match('/@Size\\(max=\\"([a-z]+)\\"\\)/', $docComment, $matches)) { $field->size = $matches[1]; } // if(preg_match('/@Default(value=\"([a-z]+)\"\)/',$docComment,$matches)) // { // $field->default = $matches[1]; // } $this->fields[$field->name] = $field; } } } }
public function checkout() { $db = DB::connect(); $products = $_SESSION['cart']['products']; $productsId = []; $productsPrice = 0; foreach ($products as $id => $product) { $productsId[] = $id; $getProductPriceSql = 'SELECT price FROM products WHERE id="' . $id . '"'; $productsPrice += $db->query($getProductPriceSql)->fetch()["price"] * $product["quantity"]; } $userInfoSql = 'SELECT id, cash FROM users WHERE username="******"'; $userInfo = $db->query($userInfoSql)->fetch(); if ($productsPrice > $userInfo["cash"]) { View::$viewBag['errors'][] = "You don't have enough money"; } else { $removeUserCashSql = 'UPDATE users SET cash = cash - "' . $productsPrice . '" WHERE id="' . $userInfo['id'] . '"'; $db->query($removeUserCashSql); foreach ($products as $id => $product) { $productExistsSql = 'SELECT product_id FROM product_user WHERE product_id = "' . $id . '" AND user_id = "' . $userInfo['id'] . '"'; if ($db->query($productExistsSql)->rowCount() == 0) { $buyProductSql = 'INSERT INTO product_user(product_id, user_id, quantity) VALUES("' . $id . '", "' . $userInfo['id'] . '", "' . $product["quantity"] . '")'; } else { $buyProductSql = 'UPDATE product_user SET quantity = quantity + "' . $product["quantity"] . '" WHERE product_id = "' . $id . '" AND user_id = "' . $userInfo['id'] . '"'; } $db->query($buyProductSql); $removeQuantitySql = 'UPDATE products SET quantity = quantity - "' . $product["quantity"] . '" WHERE id="' . $id . '"'; $db->query($removeQuantitySql); unset($_SESSION['cart']['products'][$id]); } header("Location: " . __MAIN_URL__ . "Users/Products"); exit; } }
public function addProductToUser($username, $productId, $quantity) { $errors = []; if ($quantity <= 0) { $errors[] = "Invalid quantity"; } $db = DB::connect(); $getUserId = 'SELECT id FROM users WHERE username = "******"'; $userId = $db->query($getUserId); if ($userId->rowCount() > 0) { $userId = $userId->fetch()["id"]; } else { $errors[] = "Invalid username"; } $checkProductSql = 'SELECT id FROM products WHERE id = "' . $productId . '"'; if ($db->query($checkProductSql)->rowCount() == 0) { $errors[] = "Invalid product"; } if (count($errors) == 0) { $productExistsSql = 'SELECT product_id FROM product_user WHERE product_id = "' . $productId . '" AND user_id = "' . $userId . '"'; if ($db->query($productExistsSql)->rowCount() == 0) { $addProductSql = 'INSERT INTO product_user(product_id, user_id, quantity) VALUES("' . $productId . '", "' . $userId . '", "' . $quantity . '")'; } else { $addProductSql = 'UPDATE product_user SET quantity = quantity + "' . $quantity . '" WHERE product_id = "' . $productId . '" AND user_id = "' . $userId . '"'; } $db->query($addProductSql); View::$viewBag['successMessage'] = "Product added"; } else { View::$viewBag['errors'] = $errors; } }
public function setUp() { $this->db = DB::getInstance(); $this->dao = new OwnerDAO(); }
public function setUp() { $this->db = DB::getInstance(); $this->service = new AccountService(); $this->db->query("INSERT INTO owner VALUES (1, 'temp','temp');"); }
public function editUser($username, $email, $role, $cash, $userId) { $errors = []; if (strlen($username) == 0) { $errors[] = "Invalid username"; } if (strlen($email) == 0) { $errors[] = "Invalid email"; } if ($cash < 0) { $errors[] = "Invalid cash"; } if (count($errors) == 0) { $db = DB::connect(); $editUserSql = 'UPDATE users SET username = "******", email = "' . $email . '", role = "' . $role . '", cash = "' . $cash . '" WHERE id = "' . $userId . '"'; $db->query($editUserSql); View::$viewBag['successMessage'] = "User edited"; } else { View::$viewBag['errors'] = $errors; } }
public function setUp() { $this->db = DB::getInstance(); $this->service = new OwnerService(); }