/**
* @param string $date
* @param int $value
* @return bool
*/
public function setValue($date, $value)
{
$stmt = Database::get()->prepare('INSERT INTO luckyNumbers (date, value) VALUES (:date, :value) ON DUPLICATE KEY UPDATE value=:value');
$stmt->bindParam(':date', $date, PDO::PARAM_STR);
$stmt->bindParam(':value', $value, PDO::PARAM_INT);
return $stmt->execute();
}
/**
* Updates bells
* @param array $value
* @return bool
*/
public function set($value)
{
$stmt = Database::get()->prepare('UPDATE bells SET value=:value LIMIT 1');
$stmt->bindValue(':value', json_encode($value));
$stmt->execute();
return $stmt->rowCount() > 0;
}
public function delete($class)
{
$stmt = Database::get()->prepare('DELETE FROM timetables WHERE class=:class');
$stmt->bindParam(':class', $class);
$stmt->execute();
return $stmt->rowCount() > 0;
}
/**
* @param string $name
* @param string $value
* @return bool True if success
*/
public function setValue($name, $value)
{
$stmt = Database::get()->prepare('INSERT INTO settings (name, value) VALUES (:name, :value)
ON DUPLICATE KEY UPDATE value=:value');
$stmt->bindParam(':name', $name, PDO::PARAM_STR);
$stmt->bindParam(':value', $value, PDO::PARAM_STR);
return $stmt->execute();
}
/**
* @param int $pageId
* @param int $limit
* @return array
*/
public static function getStatistics($pageId, $limit)
{
$stmt = Database::get()->prepare('SELECT date, version, count(*) AS uniqueVisits, sum(count) AS visits FROM statistics WHERE pageId=:pageId
GROUP BY date, version
ORDER BY date DESC, version DESC LIMIT :limit');
$stmt->bindParam(':pageId', $pageId, \PDO::PARAM_INT);
$stmt->bindParam(':limit', $limit, \PDO::PARAM_INT);
$stmt->execute();
return $stmt->fetchAll(PDO::FETCH_CLASS, 'pjanczyk\\lo1olkusz\\Model\\Statistic');
}
/**
* @param string $class
* @param string $date
* @param int $value
* @return bool
*/
public function setValue($class, $date, $value)
{
$stmt = Database::get()->prepare('INSERT INTO replacements (class, date, value) VALUES (:class, :date, :value)
ON DUPLICATE KEY UPDATE value=:value');
$stmt->bindParam(':class', $class, PDO::PARAM_STR);
$stmt->bindParam(':date', $date, PDO::PARAM_STR);
$stmt->bindValue(':value', json_encode($value), PDO::PARAM_STR);
return $stmt->execute();
}
