public function __construct($username_or_id)
{
parent::__construct('Counters\\SickleaveStat');
if (is_int($username_or_id)) {
$this->username = \Models\User::Find($username_or_id, 'user')->getUsername();
} else {
$this->username = $username_or_id;
}
// Count
$pdo = \DB::Instance()->pdo;
if ($pdo instanceof \PDO) {
$stmt = $pdo->prepare("SELECT count " . "FROM MonthlyIndividual " . "WHERE username = :username AND `year` = year(localtime());");
$stmt->bindParam(':username', $this->username);
$stmt->execute();
$rows = $stmt->fetchAll();
if (sizeof($rows) == 0) {
$this->used = 0;
} else {
$row = $rows[0];
$this->used = $row['count'];
}
}
}
<?php
/*
* Copyright (C) 2015 alinatoc
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
if (!isset($_REQUEST['id'])) {
header('location: ' . BASE_URL . 'admin');
die;
}
$user = \Models\User::Find($_REQUEST['id'], 'user');
$username = $user->getUsername();
