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($name, $price, $quantity, $image_url)
{
$sql = 'INSERT INTO products ' . '(name, price, quantity, image_url) ' . 'VALUES (:name, :price, :quantity, :image_url)';
$params = array('name' => $name, 'price' => $price, 'quantity' => $quantity, 'image_url' => $image_url);
$id = Database::update($sql, $params);
return new Product($name, $price, $quantity, $id, $image_url, Database::now());
}
public static function retrieve($username = null, $token = null)
{
$params = array();
$sql = 'SELECT username, address, password, salt, is_admin, ' . 'token, token_expiration ' . 'FROM users';
if (!is_null($username)) {
$sql .= ' WHERE username=:username';
$params['username'] = $username;
} else {
if (!is_null($token)) {
$sql .= ' WHERE token=:token AND token_expiration>=:now';
$params['token'] = $token;
$params['now'] = Database::now();
}
}
$result = Database::select($sql, $params);
$users = array();
foreach ($result as $r) {
$is_admin = $r['is_admin'] === '1' ? true : false;
$users[] = new User($r['username'], $r['address'], $r['password'], $r['salt'], $is_admin, $r['token'], $r['token_expiration']);
}
if (!is_null($username)) {
if (empty($users)) {
throw new \Lib\Exceptions\NotFoundException();
}
return $users[0];
}
if (!is_null($token)) {
if (empty($users)) {
throw new \Lib\Exceptions\UnauthorizedException();
}
return $users[0];
}
return $users;
}
