public function actionIndex()
{
$p = intval($this->get("p", 1));
if (!$p) {
$p = 1;
}
$data = [];
$pagesize = 20;
$query = RichMedia::find()->where(['status' => [0, 1]]);
$total_count = $query->count();
$offset = ($p - 1) * $pagesize;
$rich_list = $query->orderBy("id desc")->offset($offset)->limit($pagesize)->all();
$page_info = DataHelper::ipagination(["total_count" => $total_count, "page_size" => $pagesize, "page" => $p, "display" => 10]);
if ($rich_list) {
$idx = 1;
$domains = Yii::$app->params['domains'];
foreach ($rich_list as $_rich_info) {
$tmp_small_pic_url = GlobalUrlService::buildPic1Static($_rich_info['src_url'], ['h' => 100]);
$tmp_big_pic_url = GlobalUrlService::buildPic1Static($_rich_info['src_url'], ['w' => 600]);
$data[] = ['idx' => $idx, 'id' => $_rich_info['id'], 'small_src_url' => $tmp_small_pic_url, 'big_src_url' => $tmp_big_pic_url, 'src_url' => $tmp_small_pic_url, 'thumb_url' => $_rich_info['thumb_url'] ? $_rich_info['thumb_url'] : $domains['static'] . "/wx/video_cover.jpg", 'type' => $_rich_info['type'], 'address' => $_rich_info['address'], 'status' => $_rich_info['status'], 'status_info' => $this->status_desc[$_rich_info['status']], 'created' => $_rich_info['created_time']];
$idx++;
}
}
return $this->render("index", ["data" => $data, "page_info" => $page_info]);
}
private function search($params = [])
{
$p = isset($params['p']) ? $params['p'] : 1;
$offset = ($p - 1) * $this->page_size;
$query = RichMedia::find()->where(['status' => 1, 'type' => 'image']);
$rich_media_list = $query->orderBy("id desc")->offset($offset)->limit($this->page_size)->all();
$data = [];
if ($rich_media_list) {
foreach ($rich_media_list as $_rich_info) {
$data[] = ['id' => $_rich_info['id'], 'type' => $_rich_info['type'], 'src_url' => GlobalUrlService::buildPic1Static($_rich_info['src_url']), 'address' => $_rich_info['address'], 'switch' => \Yii::$app->params['switch']['cdn']['pic1']];
}
}
return $data;
}
public function actionMedia()
{
$p = intval($this->get("p", 1));
$offset = ($p - 1) * $this->page_size;
$query = RichMedia::find()->where(['status' => 1, 'type' => 'image']);
$rich_media_list = $query->orderBy("id desc")->offset($offset)->limit($this->page_size)->all();
$data = [];
if ($rich_media_list) {
foreach ($rich_media_list as $_rich_info) {
$data[] = ['image_url' => GlobalUrlService::buildPic1Static($_rich_info['src_url']), 'title' => $_rich_info['address'] ? $_rich_info['address'] : ':('];
}
}
return $this->renderJSON(['list' => $data]);
}
public function actionAddress()
{
$rich_media_list = RichMedia::find()->orderBy("id asc")->all();
if (!$rich_media_list) {
return;
}
foreach ($rich_media_list as $_item) {
if (!$_item['gps']) {
continue;
}
$gps_info = @json_decode(strtolower($_item['gps']), true);
if (!$gps_info) {
continue;
}
$lat = $gps_info['latitude'];
$lng = $gps_info['longitude'];
$address = GeoService::baidugeocoding($lat, $lng);
if (!$address) {
continue;
}
$_item->address = $address;
$_item->update(0);
}
}
