/** * 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.";