=== Door count ===
Total doors: 0

=== access_doors table structure ===
id (int(10) unsigned)
name (varchar(255))
class (varchar(255))
cm_type (varchar(255))
floor (smallint(6))
status (smallint(6))
created_at (timestamp)
updated_at (timestamp)

=== access_doors data ===

=== accesses table (door groups) ===

=== AccessControllController::openDoor source ===
<?php

namespace App\Http\Controllers\Manage\Access;

use Illuminate\Http\Request;

use App\Http\Requests;
use App\Http\Controllers\Controller;

use App\AccessControllLog;
use App\Access;
use App\Access_location;
use App\Access_class;
use App\Access_setting;
use App\AccessDoor;
use App\AccessDoorCardmachine;
use App\AccessStaff;
use App\AccessStaffCard;
use App\AccessStaffToDoor;
use App\Access_admin;
use App\AccessAction;
use App\pccs_floor;
use App\pccs_building;
use Log;
use App\User;
use App\Card;
use DB;
use PDF;
use Carbon\Carbon;

use Cartalyst\Sentinel\Native\Facades\Sentinel;

use App\Subtitle;

#Service
use Acom\Services\AccessService;

class AccessController extends Controller
{
    protected $accessService;
    public function __construct(AccessService $accessService){
        $this->accessService = $accessService;
    }

    public function index()
    {
        $access = Access::join('access_classes','accesses.class_id','=','access_classes.id')
                        ->join('access_locations','accesses.location','=','access_locations.id')
                        ->select('accesses.*','access_locations.name AS lname','access_classes.name AS cname')
                        ->where('accesses.status','!=',1)
                        ->get();
        $subtitle = Subtitle::where('status','!=',1)->get();
        $location = Access_location::where('status','!=',1)->get();
        $setting = Access_setting::where('status','!=',1)->get();
        $class = Access_class::where('status','!=',1)->get();
        return view('manage.access.index',['access' => $access,'location'=>$location,'class'=>$class,'subtitle'=>$subtitle,'settings'=>$setting]);
    }

    public function location()
    {
        #20180315修改 棟別樓別關聯PCCS連動
        // $access = Access_location::where('status','!=',1)->get();
        $access = Access_location::where('access_locations.status','!=',1)
                ->join('pccs_buildings','access_locations.building','=','pccs_buildings.id')
                ->select('access_locations.*','pccs_buildings.name AS b_name')
                ->get();
        $building = pccs_building::where('status','0')->select('id','name')->get();
        return view('manage.access.location',['access' => $access,'building'=>$building]);
    }

    public function Aclass()
    {
        $access = Access_class::where('status','!=',1)->get();
        return view('manage.access.class',['access' => $access]);
    }

    public function setting()
    {
        $access = Access_setting::get();
        return view('manage.access.setting',['access' => $access]);
    }
    public function brand()
    {
        $access = Access_admin::get();

        $accessDoor = AccessDoor::get();
        $accessStaff = AccessStaff::get();
        return view('manage.access.brand',['access' => $access,'accessDoor'=>$accessDoor,'accessStaff'=>$accessStaff]);
    }
    public function report(Request $request)
    {
        if(isset($request->send_from) && isset($request->send_to)){
            if($request->type == "action"){
                $notice = AccessControllLog::join("accesses","accesses.cardmachine_number","=","access_controll_log.cardmachine_number")->join("cards","cards.card_no","=","access_controll_log.user_card_number")->join("users","users.id","=","cards.user_id")->where('access_controll_log.type_mode',"notice")->select("accesses.name","access_controll_log.*","users.username","users.groupid","users.name AS user_name")->orderBy("created_at","DESC")->limit(100)->get();
                $action = AccessAction::join("accesses","accesses.cardmachine_number","=","access_actions.cardmachine_number")->select("accesses.name","access_actions.*")->whereBetween("access_actions.updated_at",array($request->send_from,$request->send_to))->orderBy("created_at","DESC")->get();
            }else{
                $data = AccessControllLog::join("accesses","accesses.cardmachine_number","=","access_controll_log.cardmachine_number")->join("cards","cards.card_no","=","access_controll_log.user_card_number")->join("users","users.id","=","cards.user_id")->where('access_controll_log.type_mode',"notice")->select("accesses.name","access_controll_log.*","users.username","users.groupid","users.name AS user_name")->whereBetween("access_controll_log.updated_at",array($request->send_from,$request->send_to))->orderBy("created_at","DESC")->get();
                $action = AccessAction::join("accesses","accesses.cardmachine_number","=","access_actions.cardmachine_number")->select("accesses.name","access_actions.*")->orderBy("created_at","DESC")->limit(100)->get();
            }
        }else{
            $notice = AccessControllLog::join("accesses","accesses.cardmachine_number","=","access_controll_log.cardmachine_number")
            ->join("cards","cards.card_no","=","access_controll_log.user_card_number")
            ->join("users","users.id","=","cards.user_id")
            ->where('access_controll_log.type_mode',"notice")
            ->whereBe