PHP Employee::select方法代码示例

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