public function index() { $user = Auth::user(); if ($user->role == User::ROLE_ADMIN) { $devicesCount = Device::all()->count(); $wxDevicesCount = WeixinDevice::all()->count(); $appsCount = App::all()->count(); $wxPagesCount = WeixinPage::all()->count(); } else { $apps = App::where('user_id', $user->id)->lists('id'); $devicesCount = DeviceApp::whereIn('app_id', $apps)->count(); $mps = WeixinMp::whereIn('app_id', $apps)->lists('id'); $wxDevicesCount = WeixinDevice::whereIn('wx_mp_id', $mps)->count(); $appsCount = count($apps); $wxPagesCount = WeixinPage::whereIn('wx_mp_id', $mps)->count(); } return view('admin.index')->with('devicesCount', $devicesCount)->with('wxDevicesCount', $wxDevicesCount)->with('appsCount', $appsCount)->with('wxPagesCount', $wxPagesCount); }
/** * 获取微信设备AJAX * @author Hanxiang */ public function wxdevicesAjax() { $input = Input::all(); $sn = $input['sn']; $device = Device::where('sn', $sn)->first(); if (!$device) { return response()->json(['wx_devices' => [], 'first' => new \stdClass()]); } $app_id = DeviceApp::where('device_id', $device->id)->lists('app_id'); $wx_mp_id = WeixinMp::where('app_id', $app_id)->lists('id'); $wxdevices = WeixinDevice::where('wx_mp_id', $wx_mp_id)->get(); if (count($wxdevices) > 0) { foreach ($wxdevices as $wx) { $wx->sn = Device::where("wx_device_id", $wx->id)->get(); } } $firstWxDevice = self::getFirstAvailableWxDevice(); return response()->json(['wx_devices' => $wxdevices->toArray(), 'first' => $firstWxDevice]); }