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); }
/** * 设备列表 * 设备列表 * @param DeviceService $deviceService * @return $this * @author zhengqian@dajiayao.cc */ public function index(Request $request, DeviceService $deviceService) { $inputData = $request->all(); $arrMp = $this->mp; $wxDevices = WeixinDevice::whereIn('wx_mp_id', $arrMp); //过滤微信号 if (isset($inputData['wx_mp_id']) && $inputData['wx_mp_id'] != 0) { $wxDevices = $wxDevices->where('wx_mp_id', $inputData['wx_mp_id']); } //过滤绑定条件 if (isset($inputData['bind']) && $inputData['bind'] == 1) { $wxDevices = $wxDevices->whereIn('id', DB::table('device_page')->lists('wx_device_id')); } elseif (isset($inputData['bind']) && $inputData['bind'] == '-1') { $wxDevices = $wxDevices->whereNotIn('id', DB::table('device_page')->lists('wx_device_id')); } // //过滤sn // if(isset($inputData['sn']) && $inputData['sn'] != ''){ // $sn = DB::table('devices')->where('sn','like',"%".$inputData['sn']."%")->lists('wx_device_id'); // $wxDevices = $wxDevices->whereIn('id',$sn); // } // // //过滤minor // if(isset($inputData['minor']) && $inputData['minor'] != ''){ // $wxDevices = $wxDevices->where('minor',$inputData['minor']); // } if (isset($inputData['kw']) && $inputData['kw'] != '') { $kw = $inputData['kw']; $ids = DB::table('devices')->where('sn', 'like', "%" . $kw . "%")->lists('wx_device_id'); $wxDevices = $wxDevices->where(function ($query) use($kw, $ids) { $query->where('uuid', 'like', "%" . $kw . "%")->orwhere('device_id', 'like', "%" . $kw . "%")->orwhere('major', 'like', "%" . $kw . "%")->orwhere('minor', 'like', "%" . $kw . "%")->orwhere('comment', 'like', "%" . $kw . "%")->orwhereIn('id', $ids); }); } $wxDevices = $wxDevices->paginate(20); //取得是否烧号?烧号后显示出sn foreach ($wxDevices as $d) { $d->sn = Device::where('wx_device_id', $d->id)->get(); $d->devPage = DevicePage::where('wx_device_id', $d->id)->get()->toArray(); } return view('admin.wx_device.index')->with('wx_devices', $wxDevices)->with('wx_mp_id', isset($inputData['wx_mp_id']) ? $inputData['wx_mp_id'] : 0)->with('bind', isset($inputData['bind']) ? $inputData['bind'] : 0)->with('kw', isset($inputData['kw']) ? $inputData['kw'] : '')->with('mps', $arrMp); }
/** * 解除绑定 * @param array $ids * @return mixed * @author zhengqian@dajiayao.cc */ public function unsetRedirect(array $ids) { return WeixinDevice::whereIn('id', $ids)->update(['redirect_name' => '', 'redirect_url' => '']); }