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);
}
