/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
if (Session::has('visitordata')) {
$session_visitor = session('visitordata');
} else {
$session_visitor = '';
}
//print_r(session());die;
//Session::put('visitordata', '');
$card_no = str_random(4) . date_timestamp_get(date_create());
$arival_date = date('d-m-Y');
$arival_time = date('H:i');
$user_role = Auth::user()->role_id;
$user_locationid = Auth::user()->location_id;
$visitorlocationid = Auth::user()->location_id;
$visitorlocation = Location::where('id', '=', $visitorlocationid)->pluck('name');
if ($user_role == 1) {
$visitors = DB::table('visitors')->join('locations', 'visitors.location', '=', 'locations.id')->join('visitor_role', 'visitors.id', '=', 'visitor_role.visitor_id')->join('visitor_types', 'visitor_role.role_id', '=', 'visitor_types.id')->join('users', 'users.id', '=', 'visitors.host_name')->get(['visitors.*', 'locations.name', 'visitor_types.name as visitor_type', 'users.name as visitor_host']);
} else {
$visitors = DB::table('visitors')->where('location', '=', $user_locationid)->where('arival_date', '=', $arival_date)->join('locations', 'visitors.location', '=', 'locations.id')->join('visitor_role', 'visitors.id', '=', 'visitor_role.visitor_id')->join('visitor_types', 'visitor_role.role_id', '=', 'visitor_types.id')->join('users', 'users.id', '=', 'visitors.host_name')->get(['visitors.*', 'locations.name', 'visitor_types.name as visitor_type', 'users.name as visitor_host']);
}
//echo "<pre>"; print_r($visitors);die;
$visitortypes = VisitorType::all()->toArray();
$current_visitors = DB::table('visitor_role')->join('visitors', 'visitors.id', '=', 'visitor_role.visitor_id')->where('visitors.status', '=', 1)->where('visitors.arival_date', '=', $arival_date)->get(['visitor_role.role_id']);
$visitor_counts = array();
foreach ($visitortypes as $key => $visitortype) {
$count = 0;
$visitor_counts[$key]['visitortype'] = $visitortype['name'];
foreach ($current_visitors as $current_visitor) {
if ($visitortype['id'] == $current_visitor->role_id) {
$count++;
}
}
$visitor_counts[$key]['count'] = $count;
}
/*echo "<pre>"; print_r($visitor_counts);die;*/
$employees = Employee::where('role_id', '=', 5)->get();
return Response::json(array('visitors' => $visitors, 'visitortypes' => $visitortypes, 'hostnames' => $employees, 'location' => $visitorlocation, 'location_id' => $visitorlocationid, 'card_no' => $card_no, 'arival_date' => $arival_date, 'arival_time' => $arival_time, 'visitor_counts' => $visitor_counts, 'session_visitor' => $session_visitor));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
VisitorType::destroy($id);
return Response::json(array('success' => 'Visitor type has been deleted!'));
}
public function handleDeleteVisitortype()
{
// Handle the delete confirmation.
$id = Input::get('visitortype');
$visitortype = VisitorType::findOrFail($id);
$visitortype->delete();
return Redirect::action('CommonController@visitortypes');
}
