/**
* @设备绑定页面
* @param DeviceService $deviceService
* @param ShakeAroundClient $shakeAroundClient
* @param string $sn
* @return string
*/
public function bindPage(DeviceService $deviceService, ShakeAroundClient $shakeAroundClient, $sn = '')
{
if (!$sn) {
return RestHelp::parametersIllegal("sn is required");
}
$device = Device::where("sn", $sn)->first();
if (!$device) {
return RestHelp::encodeResult(24001, sprintf("sn %s not found", $sn));
}
$requestData = json_decode($this->inputData, true);
$pageIds = $requestData['page_ids'];
if (!$pageIds or !is_array($requestData['page_ids'])) {
return RestHelp::encodeResult(24002, 'page_ids must be arrary');
}
foreach ($pageIds as $pid) {
if (!WeixinPage::find($pid)) {
return RestHelp::encodeResult(23001, sprintf("page id :%s not found", $pid));
}
}
$validator = Validator::make($requestData, ['page_ids' => 'required', 'bind' => 'required|boolean', 'append' => 'required|boolean']);
if ($validator->fails()) {
return RestHelp::parametersIllegal($validator->messages()->first());
}
try {
$deviceService->bindPage($shakeAroundClient, WeixinDevice::find($device->wx_device_id), $requestData['page_ids'], $requestData['bind'], $requestData['append']);
} catch (\Exception $e) {
return RestHelp::encodeResult($e->getCode(), $e->getMessage());
}
return RestHelp::success();
}
/** 基于页面的数据统计
* @param ShakeAroundClient $shakeAroundClient
* @param $pageId
* @param $beginDate
* @param $endDate
* @param null $appid
* @param null $appsecret
* @return mixed
* @throws \Exception
* @author zhengqian@dajiayao.cc
*/
public function pageStatistic($pageId, $beginDate, $endDate, $appid = null, $appsecret = null)
{
$wxPage = WeixinPage::find($pageId);
if (!$wxPage) {
throw new \Exception(sprintf("page id : %s not found in db", $pageId), 23001);
}
$token = $this->getWeixinToken($appid, $appsecret);
$ret = $this->sharkroundClient->statisticsPage($wxPage->page_id, intval($beginDate), intval($endDate), $token);
if ($ret->errcode != 0) {
throw new \Exception('weixin error:' . $ret->errmsg, $ret->errcode);
}
return $ret->data;
}
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);
}
/**
* 将微信返回的ticket，取得数据，然后本地解析
* @param ShakeAroundClient $shakeAroundClient
* @param $ticket
* @param int $needPoi
* @return string
* @throws \Exception
*/
public function parseRetInfo(ShakeAroundClient $shakeAroundClient, $ticket, $needPoi, $appid = null, $appsecret = null)
{
$accessToken = $this->getWeixinToken($appid, $appsecret);
$ret = $shakeAroundClient->getShakeInfo($ticket, $needPoi, $accessToken);
if ($ret->errcode != 0) {
throw new \Exception("weixin error:" . $ret->errmsg, 90000);
}
$wxPageId = $ret->data->page_id;
$page = WeixinPage::where('page_id', $wxPageId)->first();
if (!$page) {
throw new \Exception(sprintf("page_id %s not found", $wxPageId), 23001);
}
$objRet = new \stdClass();
$objRet->page_id = $page->id;
$objRet->wx_page_id = $wxPageId;
$objRet->title = $page->title;
$objRet->description = $page->description;
$objRet->icon_url = $page->icon_url;
$objRet->url = $page->url;
$objRet->comment = $page->comment;
if ($needPoi == 1) {
$objRet->poi_id = $ret->data->poi_id;
} else {
$objRet->poi_id = 0;
}
$deviceUuid = $ret->data->beacon_info->uuid;
$deviceMajor = $ret->data->beacon_info->major;
$deviceMinor = $ret->data->beacon_info->minor;
$device = WeixinDevice::where('uuid', $deviceUuid)->where('major', $deviceMajor)->where('minor', $deviceMinor)->first();
if (!$device) {
throw new \Exception(sprintf("device Uuid: %s not found", $deviceUuid), 24001);
}
$objRet->wx_device_id = $device->device_id;
$objRet->device_id = $device->id;
$objRet->major = $ret->data->beacon_info->major;
$objRet->minor = $ret->data->beacon_info->minor;
$objRet->uuid = $ret->data->beacon_info->uuid;
$objRet->openid = $ret->data->openid;
$objRet->distance = $ret->data->beacon_info->distance;
$this->openid = $objRet->openid;
return json_encode($objRet);
}
/**
* 所有中间处理逻辑，生产本地ticket
* @param $pageId //页面id号
* @param ShakeAroundClient $shakeAroundClient
* @param SharkService $sharkService
* @throws Exception
*/
public function redirectCallback(ShakeAroundClient $shakeAroundClient, SharkService $sharkService)
{
$requestData = $this->input;
if (!array_key_exists('ticket', $requestData)) {
throw new Exception("param miss ticket");
}
if (!array_key_exists('guid', $requestData)) {
throw new Exception("param miss guid");
}
$objPage = WeixinPage::where('guid', $requestData['guid'])->first();
if (!$objPage) {
return RestHelp::encodeResult(23001, sprintf(" guid %s not found", $requestData['guid']));
}
$uuid = Uuid::v4(false);
//set into redis
try {
$sharkService->setInfoInRedis($shakeAroundClient, $uuid, $requestData['ticket'], 0, $objPage->mp->appid, $objPage->mp->appsecret);
} catch (Exception $e) {
echo $e->getMessage() . $e->getCode();
exit;
}
try {
$ret = $sharkService->setInfoInDB($shakeAroundClient, $requestData['ticket'], 0, $objPage->mp->appid, $objPage->mp->appsecret);
} catch (Exception $e) {
echo $e->getMessage() . $e->getCode();
exit;
}
$appid = $objPage->mp->appid;
$appsecret = $objPage->mp->appsecret;
$sharkService->saveUserInfo(new WeixinUserService(), $ret->openid, $appid, $appsecret, $objPage->mp->mp_id, $objPage->mp->id);
//判断该设备有没有设置重定向，如果设置了，直接跳转
$wxDevice = WeixinDevice::where('uuid', $ret->uuid)->where('major', $ret->major)->where('minor', $ret->minor)->first();
if (!$wxDevice) {
return "device not found";
exit;
}
$url = $wxDevice->redirect_url ? $wxDevice->redirect_url : $objPage->url;
$url = preg_match("/\\?/", $url) ? $url . "&ticket=" . $uuid : $url . "?ticket=" . $uuid;
//redirect
return redirect($url);
}
/**
* 绑定页面POST
* @author Hanxiang
* @param PageService $pageService
* @param ShakeAroundClient $shakeAroundClient
* @return json
*/
public function bindPost(PageService $pageService, ShakeAroundClient $shakeAroundClient)
{
$input = Input::all();
$validator = Validator::make($input, ['id' => 'required', 'wx_device_ids' => 'required']);
if ($validator->fails()) {
return response()->json(['result' => 0, 'msg' => '参数错误']);
}
if (!is_array($input['wx_device_ids'])) {
return response()->json(['result' => 0, 'msg' => '参数错误']);
}
$wxpage = WeixinPage::find($input['id']);
if (!$wxpage) {
return response()->json(['result' => 0, 'msg' => '微信页面不存在']);
}
$wxMp = WeixinMp::find($wxpage->wx_mp_id);
$appid = $wxMp->appid;
$appsecret = $wxMp->appsecret;
try {
$pageService->bindDevice($shakeAroundClient, $wxpage, $input['wx_device_ids'], 1, 1, $appid, $appsecret);
} catch (\Exception $e) {
return response()->json(['result' => 0, 'msg' => $e->getMessage()]);
}
Session::flash('result', true);
Session::flash('msg', "操作成功");
return response()->json(['result' => 1, 'msg' => '操作成功']);
}
/**
* 绑定页面
* @param DeviceService $deviceService
* @param $wxDeviceId
* @param $pageIds
* @param int $flage
* @author zhengqian@dajiayao.cc
*/
public function bindPages(ShakeAroundClient $shakeAroundClient, DeviceService $deviceService)
{
$inputData = Input::all();
$wxDeviceId = $inputData['device_id'];
$objDev = WeixinDevice::find($wxDeviceId);
if (!$objDev) {
return redirect(route('adminGetBindPage', [$wxDeviceId]))->with('result', false)->with('msg', "设备id 不存在");
}
$pageIds = isset($inputData['page_id']) ? $inputData['page_id'] : [];
foreach ($pageIds as $id) {
$objPage = WeixinPage::find($id);
if (!$objPage) {
return redirect(route('adminGetBindPage', [$wxDeviceId]))->with('result', false)->with('msg', sprintf("页面id：%s 不存在", $id));
}
}
//如果空page_ids，则解绑所有页面
if (empty($pageIds)) {
$dp = DB::table('device_page')->where('wx_device_id', $wxDeviceId)->lists('wx_page_id');
try {
$deviceService->bindPage($shakeAroundClient, $objDev, $dp, 0, 0, $objDev->mp->appid, $objDev->mp->appsecret);
} catch (\Exception $e) {
echo $e->getMessage();
exit;
}
return redirect(route('adminGetBindPage', [$wxDeviceId]))->with('result', true)->with('msg', "操作成功");
}
try {
$deviceService->bindPage($shakeAroundClient, $objDev, $pageIds, 1, 0, $objDev->mp->appid, $objDev->mp->appsecret);
} catch (\Exception $e) {
echo $e->getMessage();
exit;
}
return redirect(route('adminGetBindPage', [$wxDeviceId]))->with('result', true)->with('msg', "操作成功");
}
/**
* 页面具体信息
* @param $pageId
* @return string
* @author zhengqian@dajiayao.cc
*/
public function getInfo($pageId)
{
if (!$pageId) {
return RestHelp::parametersIllegal("page id is required");
}
$objPage = WeixinPage::find($pageId);
if (!$objPage) {
return RestHelp::encodeResult(23001, sprintf("page id is %s not found", $pageId));
}
$retPage = ['title' => $objPage->title, 'description' => $objPage->description, 'icon_url' => $objPage->icon_url, 'url' => $objPage->url, 'comment' => $objPage->comment];
$retDevice = array();
$devicePage = DevicePage::where('wx_page_id', $pageId)->get();
foreach ($devicePage as $dp) {
$device = $dp->device->weixinDevice;
foreach ($device as $d) {
array_push($retDevice, ['sn' => $d->sn, 'device_id' => $d->wx_device_id, 'comment' => $d->comment, 'status' => $d->status]);
}
}
return RestHelp::success(['page' => $retPage, 'device' => $retDevice]);
}
/**
*
* @author zhengqian@dajiayao.cc
*/
public function sync($appid, $appsecret)
{
$mp_id = WeixinMp::where('appid', $appid)->where('appsecret', $appsecret)->first()->id;
$bid = 0;
$countPage = 0;
//定义缓存数组
$cacheArrayPage = [];
while (true) {
$ret = $this->syncPage($appid, $appsecret, $bid, 20);
$pages = $ret->pages;
$bid = $bid + count($pages);
if (!$pages) {
break;
}
//开始同步页面
foreach ($pages as $page) {
$objPage = WeixinPage::where('page_id', $page->page_id)->first();
if (!$objPage) {
$objPage = new WeixinPage();
$objPage->guid = Uuid::v4(false);
$objPage->title = $page->title;
$objPage->description = $page->description;
$objPage->icon_url = $page->icon_url;
$objPage->url = $page->page_url;
$objPage->comment = $page->comment;
$objPage->page_id = $page->page_id;
$objPage->wx_mp_id = $mp_id;
$objPage->save();
$countPage++;
}
//生产缓存数组
if (!array_key_exists($page->page_id, $cacheArrayPage)) {
$cacheArrayPage[$page->page_id] = $objPage->id;
}
}
}
unset($ret);
$countDevice = 0;
$bid = 0;
while (True) {
$ret = $this->syncDevice($appid, $appsecret, $bid);
$devices = $ret->devices;
$bid = $bid + count($devices);
if (!$devices) {
break;
}
//开始同步设备
foreach ($devices as $device) {
$objWxDevice = WeixinDevice::where('device_id', $device->device_id)->first();
if (!$objWxDevice) {
$objWxDevice = new WeixinDevice();
$objWxDevice->uuid = $device->uuid;
$objWxDevice->major = $device->major;
$objWxDevice->minor = $device->minor;
$objWxDevice->comment = $device->comment;
$objWxDevice->poi_id = $device->poi_id;
$objWxDevice->wx_mp_id = $mp_id;
$objWxDevice->device_id = $device->device_id;
$objWxDevice->apply_id = $device->device_id;
$countDevice++;
}
$objWxDevice->status = $device->status;
$objWxDevice->save();
//处理页面-设备关系
if (!empty($device->page_ids)) {
$arrPageIds = explode(',', $device->page_ids);
foreach ($arrPageIds as $pageId) {
$devicePage = DevicePage::where('wx_device_id', $objWxDevice->id)->where('wx_page_id', $cacheArrayPage[$pageId])->first();
if (!$devicePage) {
$devicePage = new DevicePage();
$devicePage->wx_device_id = $objWxDevice->id;
$devicePage->wx_page_id = $cacheArrayPage[$pageId];
$devicePage->save();
}
}
}
}
}
return ['count_page' => $countPage, 'count_device' => $countDevice];
}
/**
* @param ShakeAroundClient $shakeAroundClient
* @param array $ids,本地主键id
* @throws \Exception
*/
public function deletePageOnline(ShakeAroundClient $shakeAroundClient, array $ids, $appid = null, $appsecret = null)
{
foreach ($ids as $v) {
if (!WeixinPage::find($v)) {
throw new \Exception(sprintf('page id %s not found', $v), 23001);
}
}
$accessToken = $this->getWeixinToken($appid, $appsecret);
if ($accessToken == NULL) {
throw new \Exception("weixin get token error", 90000);
}
foreach ($ids as $k => &$v) {
$ids[$k] = WeixinPage::find($v)->page_id;
}
$ret = $shakeAroundClient->deletePageByIds(['page_ids' => $ids], $accessToken);
if ($ret->errcode != 0) {
throw new \Exception('weixin error' . $ret->errmsg, 90000);
}
}
/**
* @param ShakeAroundClient $shakeAroundClient
* @param Device $device ,自己构建实体
* @param array $page_ids ，要绑定的页面id,主键id
* @param int $bind
* @param int $append
* @throws \Exception
*/
public function bindPage(ShakeAroundClient $shakeAroundClient, WeixinDevice $device, array $page_ids, $bind = 1, $append = 1, $appid = null, $appsecret = null)
{
//TODO 检查 wx_mp_id 是否设备-页面一一致
$token = $this->getWeixinToken($appid, $appsecret);
if ($token == NULL) {
throw new \Exception("weixin get token error", 90000);
}
//page_ids转变为wx_page_ids
foreach ($page_ids as $k => &$v) {
$wx_page_ids[$k] = WeixinPage::find($v)->page_id;
}
$ret = $shakeAroundClient->bindPage(new DeviceIdentifier($device->device_id, $device->uuid, $device->major, $device->minor), $wx_page_ids, (int) $bind, (int) $append, $token);
if ($ret->errcode != 0) {
throw new \Exception('weixin error:' . $ret->errmsg, 90000);
}
//本地数据库记录
if ($append == 0) {
DevicePage::where('wx_device_id', $device->id)->delete();
}
foreach ($page_ids as $id) {
if ($bind == 1) {
$devicePage = new DevicePage();
$devicePage->wx_device_id = $device->id;
$devicePage->wx_page_id = $id;
$devicePage->save();
} elseif ($bind == 0) {
DevicePage::where('wx_device_id', $device->id)->where('wx_page_id', $id)->delete();
}
}
}
