Файловый менеджер

Файловый менеджер - Редактировать - /var/www/jonas-eriksen.dk/result/user/Class.user.php

Назад
<?php class user { private $db; function __construct($DB_con) { $this->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 <?php echo $userId ?><br> Se venligst <a href="/user/new.php">opretelse af ny bruger</a>. <?php return false; } } public function updateSubcription($userId, $sub) { $stmt = $this->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) { ?> <table class="table-bordered" style="float: right"> <thead> <th>SKV nummer</th> <th>Acceptdato</th> <th>Udløbsdato</th> </thead> <tbody> <?php foreach ($skvRow as $row) { ?> <tr> <td><?php echo $row[2] ?></td> <td><?php echo date_format(new DateTime($row[3]), 'd-m-Y'); ?></td> <td><?php $date = new DateTime($row[3]); date_add($date, date_interval_create_from_date_string('5 years')); echo date_format($date, 'd-m-Y'); ?></td> </tr> <?php } ?> </tbody> </table> <?php } } else { return $skvRow; } } public function getSKVOnId($skvId) { try { $stmt = $this->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(); } } }

| ver. 1.4 | Github | . | PHP 7.4.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка