public function run() { $id = intval($this->getDataItem('id', 0)); if (0 < $id) { $this->activity = Activity::query()->columns(['activity_id id', 'city_id city', 'activity_type type', 'activity_title as title', 'activity_intro as intro', '0 beauty_parlors'])->where('activity_id=:id:')->bind(['id' => $id])->execute()->getFirst(); if ($this->activity) { $parlor = ActivityBeautyParlor::query()->columns(['bp_id as id', 'bp_name as name', 'bp_cover as cover', 'bp_address as address', '0 as tags', 'bp_medal as medal'])->leftJoin('Apps\\Common\\Models\\BeautyParlor', 'Apps\\Common\\Models\\ActivityBeautyParlor.beauty_parlor_id=bp.bp_id', 'bp')->where('bp.bp_state > 0 and activity_id = :id:')->bind(['id' => $id])->execute()->toArray(); $this->activity->beauty_parlors = $parlor; } } $this->activity = $this->activity ? $this->activity : null; if ($this->activity) { //$this->activity->cover = PicUrl::ActivityCover($this->activity->cover, $this->getDi()); for ($i = 0; $i < count($this->activity->beauty_parlors); $i++) { $this->activity->beauty_parlors[$i]['cover'] = PicUrl::BeautyParlorCover($this->activity->beauty_parlors[$i]['cover'], $this->getDi()); $medal = $this->activity->beauty_parlors[$i]['medal']; unset($this->activity->beauty_parlors[$i]['medal']); $this->activity->beauty_parlors[$i]['medal_refund'] = \Apps\Common\Libs\BeautyParlor::getMedalRefund($medal); $this->activity->beauty_parlors[$i]['medal_verify'] = \Apps\Common\Libs\BeautyParlor::getMedalVerify($medal); $this->activity->beauty_parlors[$i]['tags'] = \Apps\Common\Libs\BeautyParlor::getTags($this->activity->beauty_parlors[$i]['id']); } $this->activity->intro = \Apps\Common\Libs\BeautyParlor::formatServiceIntro($this->activity->intro, $this->getDi(), true); } $this->setResult($this->activity); }
public function sync($id) { $config = $this->di->get('appConfig')->amap->lbs_cloud; $key = $config->key; $signKey = $config->sign_key; $tableId = $config->table_id; $syncLogTableName = 'beauty_parlor_amap_sync_log'; $lbsColud = new LBSCloud($key, $signKey, $tableId, $syncLogTableName); // 获取店铺信息 $shop = BeautyParlor::query()->columns(['bp_id', 'bp_name', 'bp_address', 'bp_cover', 'bp_tel', 'bp_medal', 'X(bp_coordinate) x', 'Y(bp_coordinate) y'])->where('bp_id=:id:', ['id' => $id])->execute()->getFirst(); if (!$shop) { return false; } $name = $shop->bp_name; $location = $shop->x . ',' . $shop->y; $address = $shop->bp_address; $customData = ['bp_id' => $shop->bp_id, 'bp_cover' => PicUrl::BeautyParlorCover($shop->bp_cover, $this->di), 'tel' => $shop->bp_tel, 'bp_tags' => implode(',', \Apps\Common\Libs\BeautyParlor::getTags($id)), 'medal_refund' => \Apps\Common\Libs\BeautyParlor::getMedalRefund($shop->bp_medal), 'medal_verify' => \Apps\Common\Libs\BeautyParlor::getMedalVerify($shop->bp_medal)]; // 获取已经同步的数据 $aMapData = BeautyParlorAmap::findFirst("source_id={$id}"); if ($aMapData) { // 更新 $result = $lbsColud->update($id, $aMapData->amap_data_id, $name, $location, $address, $customData, CoordType::AUTONAVI); if ($result->status) { // 记录更新时间 $aMapData->sync_time = new RawValue('NOW()'); if ($aMapData->save() == false) { $this->logDatabaseError($aMapData); } } } else { // 新添加 $result = $lbsColud->create($id, $name, $location, $address, $customData, CoordType::AUTONAVI); if ($result->status) { // 记录关系数据 $aMapData = new BeautyParlorAmap(); $aMapData->source_id = $id; $aMapData->amap_data_id = $result->id; $aMapData->sync_time = new RawValue('NOW()'); if ($aMapData->save() == false) { $this->logDatabaseError($aMapData); } } } return $result->status; }
private function syncBP($id) { $info = \Apps\Common\Models\BeautyParlor::findFirst('bp_id = ' . $id); if (!$info) { return false; } // 删除数据 if ($info->bp_state <= 0) { $this->delete(SearchDataType::BeautyParlors, $info->bp_id); return true; } // 同步数据 $bpTags = \Apps\Common\Libs\BeautyParlor::getTags($id); // 标题中包含的内容 $titleArr = [$info->bp_name, implode(',', $bpTags), $info->bp_address]; $title = implode(',', $titleArr); $searchContent = $info->bp_intro; $tagInt = \Apps\Common\Libs\SysArea::districtToOpenCityId($info->bp_district); $tagStr = strval($info->bp_tel); $showData = json_encode(['id' => $info->bp_id, 'name' => $info->bp_name, 'cover' => $info->bp_cover, 'address' => $info->bp_address, 'medal_refund' => \Apps\Common\Libs\BeautyParlor::getMedalRefund($info->bp_medal), 'medal_verify' => \Apps\Common\Libs\BeautyParlor::getMedalRefund($info->bp_medal), 'tags' => $bpTags]); $this->save(SearchDataType::BeautyParlors, $id, $showData, $title, $searchContent, $tagInt, $tagStr); return true; }
/** * 活动 */ public function activityAction() { $id = $this->request->getQuery('id'); if (empty($id)) { echo '活动不存在!'; $this->view->disable(); return; } $activity = Activity::query()->columns(['activity_id id', 'city_id city', 'activity_type type', 'activity_title as title', 'activity_intro as intro', '0 beauty_parlors'])->where('activity_id=:id:')->bind(['id' => $id])->execute()->getFirst(); if (!$activity) { echo '活动不存在!'; $this->view->disable(); return; } $this->view->setVar('activity', $activity); $this->tag->setTitle($activity->title); $parlors = ActivityBeautyParlor::query()->columns(['bp_id as id', 'bp_name as name', 'bp_cover as cover', 'bp_address as address', '0 as tags', 'bp_medal as medal'])->leftJoin('Apps\\Common\\Models\\BeautyParlor', 'Apps\\Common\\Models\\ActivityBeautyParlor.beauty_parlor_id=bp.bp_id', 'bp')->where('bp.bp_state > 0 and activity_id = :id:')->bind(['id' => $id])->execute()->toArray(); for ($i = 0; $i < count($parlors); $i++) { $parlors[$i]['cover'] = PicUrl::BeautyParlorCover($parlors[$i]['cover'], $this->getDi()); $medal = $parlors[$i]['medal']; unset($parlors[$i]['medal']); $parlors[$i]['medal_refund'] = \Apps\Common\Libs\BeautyParlor::getMedalRefund($medal); $parlors[$i]['medal_verify'] = \Apps\Common\Libs\BeautyParlor::getMedalVerify($medal); $parlors[$i]['tags'] = \Apps\Common\Libs\BeautyParlor::getTags($parlors[$i]['id']); } $this->view->setVar('parlors', $parlors); }