/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$desks = Desk::select('users.*', 'desks.*', 'departmants.job', 'departmants.dep')->leftJoin('users', 'users_id', '=', 'u_id')->join('departmants', 'departmants.id', '=', 'departmant_id')->get()->toArray();
$ret = [];
foreach ($desks as $k => $d) {
$d['bg_name'] = mb_convert_encoding($d['bg_name'], 'UTF-8', 'cp1251');
$ret[$k] = $d;
}
return response()->json($ret);
}
/**
* Retunrs a list of users for all desks currently marked for special purposes
*
* @return type
*/
protected function getSpecialUsers()
{
$desks = Desk::select("*")->where("users_id", "<", "0")->get()->toArray();
$users = [];
$count = 0;
foreach ($desks as $desk) {
$key = 'spec_' + $count++;
// Busy Desk
if ($desk['users_id'] == -1) {
$users[$key] = ['u_id' => $desk['users_id'], 'u_name' => "Special Purpose", 'desk' => $desk['id'], 'job' => "The desk is currently used for a special, classified purpose."];
}
// Ready Desk
if ($desk['users_id'] == -2) {
$users[$key] = ['u_id' => $desk['users_id'], 'u_name' => "Ready Desk", 'desk' => $desk['id'], 'job' => "The desk is set up and ready for use."];
}
}
return $users;
}
