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' => '']);
}
