public static function create($username, $total)
{
$sql = 'INSERT INTO orders ' . '(username, total) ' . 'VALUES (:username, :total)';
$params = array('username' => $username, 'total' => $total);
$id = Database::update($sql, $params);
return new Order($username, $total, $id, Database::now());
}
public static function create($username, $password, $address)
{
if (static::exist($username)) {
throw new \Lib\Exceptions\DuplicateException();
}
$salt = Security::generate_salt();
$hashed_password = self::generate_hash($password, $salt);
$sql = 'INSERT INTO users ' . '(username, password, salt, address) ' . 'VALUES(:username, :password, :salt, :address)';
$params = array('username' => $username, 'password' => $hashed_password, 'salt' => $salt, 'address' => $address);
Database::update($sql, $params);
return new User($username, $address);
}
public static function decrease_quantity($id, $quantity)
{
$sql = 'UPDATE products SET quantity=quantity - :quantity WHERE id=:id';
$params = array('id' => $id, 'quantity' => $quantity);
return Database::update($sql, $params);
}
