Warning: Cannot modify header information - headers already sent by (output started at /var/www/jonas-eriksen.dk/pic/private/index.php:1) in /var/www/jonas-eriksen.dk/pic/private/index.php on line 215
db = $DB_con;
}
public function getAllUsers($show)
{
try {
if ($show == 0) {
$stmt = $this->db->prepare("SELECT id, cpr, shooterId, fullname, adress, birthday, phone, email, allowPicture, newShooter, subscriptionPaid FROM result_users WHERE isDeleted = 0 ORDER BY fullname ASC");
} elseif ($show == 1) {
$stmt = $this->db->prepare("SELECT id, cpr, shooterId, fullname, adress, birthday, phone, email, allowPicture, newShooter, subscriptionPaid, isDeleted FROM result_users ORDER BY fullname ASC");
}
$stmt->execute();
$users = $stmt->fetchAll();
return $users;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function register($shooterId, $cpr, $fullname, $adress, $birthday, $email, $allowPicture, $phone, $ownWeapon, $class, $memberDate)
{
try {
$stmt = $this->db->prepare("INSERT INTO result_users(shooterId, cpr, fullname, adress, birthday, email, allowPicture, phone, ownWeapon, class, memberDate) VALUES (:shooterId, :cpr, :fullname, :adress, :birthday, :email, :allowPicture, :phone, :ownWeapon, :class, :memberDate)");
$stmt->execute(array(":shooterId" => $shooterId, ":cpr" => $cpr, ":fullname" => $fullname, ":adress" => $adress, ":birthday" => $birthday, ":email" => $email, ":allowPicture" => $allowPicture, ":phone" => $phone, ":ownWeapon" => $ownWeapon, ":class" => $class, ":memberDate" => $memberDate));
return $stmt;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function update($id, $shooterId, $cpr, $fullname, $adress, $birthday, $email, $allowPicture, $phone, $isDeleted, $ownWeapon, $class, $new, $memberDate)
{
try {
$stmt = $this->db->prepare("UPDATE result_users SET shooterId = :shootId, cpr = :cpr, fullname = :fullname, adress = :adress, birthday = :birthday, email = :email, allowPicture = :allowpiture, phone = :phone, isDeleted = :isDeleted, ownWeapon = :ownWeapon, class = :class, newShooter = :new, memberDate = :memberDate WHERE id = :id");
$stmt->execute(array(":id" => $id, ":shootId" => $shooterId, ":cpr" => $cpr, ":fullname" => $fullname, ":adress" => $adress, ":birthday" => $birthday, ":email" => $email, ":allowpiture" => $allowPicture, ":phone" => $phone, ":isDeleted" => $isDeleted, ":ownWeapon" => $ownWeapon, ":class" => $class, ":new" => $new, ":memberDate" => $memberDate));
return $stmt;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function getUser($userId)
{
$stmt = $this->db->prepare("SELECT * FROM result_users JOIN result_class ON result_users.class = result_class.id WHERE result_users.id = :userId");
$stmt->execute(array(':userId' => $userId));
$userRow = $stmt->fetch(PDO::FETCH_BOTH);
if ($stmt->rowCount() == 1) {
return $userRow;
} else {
?>
Ingen bruger med id
Se venligst opretelse af ny bruger.
db->prepare("SELECT * FROM result_users WHERE id = :userId");
$stmt->execute(array(':userId' => $userId));
$userRow = $stmt->fetch(PDO::FETCH_BOTH);
if ($stmt->rowCount() == 1) {
$query = $this->db->prepare("UPDATE result_users SET subscriptionPaid = :sub WHERE id = :userId");
$query->execute(array(':sub' => $sub, ':userId' => $userId));
}
}
public function getSKV($userId, $report = null)
{
$stmt = $this->db->prepare("SELECT * FROM result_skv WHERE shooterId = :userId");
$stmt->execute(array(':userId' => $userId));
$skvRow = $stmt->fetchAll();
if ($report == null) {
if ($skvRow) {
?>
| SKV nummer |
Acceptdato |
Udløbsdato |
|
|
|
db->prepare("SELECT id, `skv-id` FROM result_skv WHERE id = :id");
$stmt->execute(array(':id' => $skvId));
$skv = $stmt->fetch(PDO::FETCH_BOTH);
return $skv;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function changeEventNumber($userId, $amount)
{
$stmt = $this->db->prepare("SELECT eventsLeft FROM result_users WHERE id = :userId");
$stmt->execute(array(":userId" => $userId));
$eventsLeft = $stmt->fetch(PDO::FETCH_BOTH);
$currentEventsLeft = $eventsLeft[0];
$newAmount = $currentEventsLeft + $amount;
$stmt = $this->db->prepare("UPDATE result_users SET eventsLeft = :newAmount WHERE id = :userId");
$stmt->execute(array(":userId" => $userId, ":newAmount" => $newAmount));
}
public function newSKV($userId, $skvNumber, $date, $skvId)
{
try {
$stmt = $this->db->prepare("INSERT INTO result_skv (shooterId, skvNumber, date, `skv-id`) VALUES (:userId, :skvNumber, :date, :skvId)");
$stmt->execute(array(":userId" => $userId, ":skvNumber" => $skvNumber, ":date" => $date, ":skvId" => $skvId));
return $stmt;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function updateSKV($id, $skvNumber, $date, $skvId)
{
try {
$stmt = $this->db->prepare("UPDATE result_skv SET skvNumber = :skvNumber, date = :date, `skv-id` = :skvId WHERE id = :id");
$stmt->execute(array(":id" => $id, ":skvNumber" => $skvNumber, ":date" => $date, ":skvId" => $skvId));
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function deleteSKV($id)
{
try {
$stmt = $this->db->prepare("DELETE FROM result_skv WHERE id = :id");
$stmt->execute(array(":id" => $id));
header("location: /admin/skv.php");
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function getAllSKV()
{
try {
$stmt = $this->db->prepare("SELECT result_users.id, result_users.shooterId, result_users.fullname, result_skv.`skv-id`, result_skv.skvNumber, result_skv.date, result_skv.id FROM result_skv JOIN result_users ON result_users.id = result_skv.shooterId ORDER BY result_skv.date");
$stmt->execute();
return $stmt;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function getUserSKV($id)
{
try {
$stmt = $this->db->prepare("SELECT result_users.fullname, result_skv.skvNumber, result_skv.date, result_skv.`skv-id` FROM result_skv JOIN result_users ON result_users.id = result_skv.shooterId WHERE result_skv.id = :id");
$stmt->execute(array(':id' => $id));
$skvRow = $stmt->fetch(PDO::FETCH_BOTH);
return $skvRow;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function getLatestUser()
{
try {
$stmt = $this->db->prepare("Select id FROM result_users ORDER BY id DESC LIMIT 1");
$stmt->execute();
$id = $stmt->fetch();
return $id[0];
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function getUserForConsentForm($userId)
{
try {
$stmt = $this->db->prepare("SELECT fullname, adress, email, phone FROM result_users WHERE id = :userId");
$stmt->execute(array(":userId" => $userId));
$user = $stmt->fetch(PDO::FETCH_BOTH);
return $user;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function getUserAnniversary()
{
try {
$stmt = $this->db->prepare("SELECT id, fullname, memberDate FROM result_users WHERE isDeleted = 0 ORDER BY fullname ASC;");
$stmt->execute();
$users = $stmt->fetchAll();
$anniversaries = [20, 30, 40, 50, 60, 70, 80, 90, 100];
$anniversary_combined_array = [];
foreach($users AS $a)
{
if(in_array(date_diff(date_create($a[2]."-01-01"), date_create('today'))->y,$anniversaries))
{
array_push($anniversary_combined_array,$a);
}
}
return $anniversary_combined_array;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
}