/**
* Get the last absent days
* If the user is not absent since joining then.Joining date is last absent date
*/
public function lastAbsent($employeeID, $type = 'days')
{
$absent = Attendance::where('status', '=', 'absent')->where('employeeID', '=', $employeeID)->where(function ($query) {
$query->where('application_status', '=', 'approved')->orWhere('application_status', '=', null);
})->orderBy('date', 'desc')->first();
$joiningDate = Employee::select('joiningDate')->where('employeeID', '=', $employeeID)->first();
$lastDate = date('Y-m-d');
$old_date = isset($absent->date) ? $absent->date : $joiningDate->joiningDate;
$diff = date_diff(date_create($old_date), date_create($lastDate));
$difference = $diff->format('%R%a') . ' day ago';
if ($type == 'days') {
return $difference;
} elseif ($type == 'date') {
return date_create($old_date)->format('d-M-Y');
}
}
require 'includes/functions.php';
include 'templates/header.php';
include 'templates/navbar.php';
$header = "accounts";
$page = "view";
include 'templates/sidebar.php';
?>
<div class="row" style="margin-right: 0">
<div class="col-md-6 col-md-offset-3 page-wrapper">
<h2>My Account Details</h2>
<hr>
<?php
$user = User::select(array('id' => $_SESSION['user_id']));
?>
<?php
$emp = Employee::select(array('user_id' => $_SESSION['user_id']));
?>
<table class="table lead">
<tr>
<th>Name:</th>
<td><?php
echo $user->full_name();
?>
</td>
</tr>
<tr>
<th>Username:</th>
<td><?php
echo $user->username;
?>
</td>
// ADD THE COST TO TOTAL COST
$total_cost = $value * $menu_item->cost;
} else {
$alertArray['error'] = 'The items could not be ordered!';
}
} else {
//echo "<script>alert('update')</script>";
if ($order->insert()) {
$alertArray['success'] = 'The items have been added to your orders';
$total_cost = $value * $menu_item->cost;
} else {
$alertArray['error'] = 'The items could not be ordered!';
}
}
if ($total_cost != 0) {
$user = Employee::select(array('user_id' => $session->user_id));
$user->balance += $total_cost;
$user->update('user_id');
}
}
}
}
}
include 'templates/navbar.php';
$header = "menu";
include 'templates/sidebar.php';
?>
<div class="row" style="margin-right: 0">
<div class="col-md-6 col-md-offset-3 page-wrapper">
require 'templates/sidebar.php';
$alert_array = array();
if (isset($_POST['submit'])) {
$employee = new Employee();
$employee->user_id = $_GET['id'];
$employee->validity = $_POST['validity'];
if ($employee->update('user_id')) {
$alert_array['success'] = 'The account was successfully updated!';
} else {
$alert_array['error'] = 'The account was not updated!';
}
}
if (isset($_GET['id']) && is_int(intval($_GET['id']))) {
$id = intval($_GET['id']);
$user = User::select(array('id' => $id));
$employee = Employee::select(array('user_id' => $id));
if (!$user || !$employee) {
redirect_to('account.view.php');
}
if (isset($_GET['clearBalance']) && $_GET['clearBalance'] == 'Continue') {
if (isset($_GET['deleteOrders']) && $_GET['deleteOrders'] == 'on') {
$orders = Order::select(array('user_id' => $user->id));
if (is_object($orders)) {
$orders = array($orders);
}
if (!$orders) {
$alert_array['error'] = "The balance is already zero! ";
} else {
foreach ($orders as $order) {
$order->delete();
}
if ($session->permission == 'manager') {
redirect_to('admin/');
} elseif ($session->permission == 'staff') {
redirect_to('staff/');
} elseif ($session->permission == 'employee') {
redirect_to('account.view.php');
}
}
if (isset($_POST['submit'])) {
$_POST['password'] = md5($_POST['password']);
// if the username/password combination is in the database
if ($user = User::select($_POST)) {
// SET SESSION VARIABLE
// ====
if (strtolower($user->permission) == "employee") {
$emp = Employee::select(array('user_id' => $user->id));
if ($emp->valid_days() > 0) {
$session->login($user);
redirect_to("account.view.php");
} else {
$alertArray['error'] = "<b>Sorry!</b> Your account has been expired with a balance of Rs " . $emp->balance;
}
} elseif (strtolower($user->permission) == "staff") {
$session->login($user);
redirect_to("staff/");
} elseif (strtolower($user->permission) == "manager") {
$session->login($user);
redirect_to("admin/");
}
} else {
$alertArray['error'] = "<b>Sorry!</b> The username/password combination is incorrect.";
