Map.php 1.02 KB
<?php
declare(strict_types=1);

namespace app\controller\api;

use app\BaseController;
use think\facade\Db;

class Map extends BaseController
{
    public function spots()
    {
        $rows = Db::name('map_spot')
            ->where('status', 1)
            ->order('sort', 'asc')
            ->order('id', 'asc')
            ->select()
            ->toArray();

        $list = [];
        foreach ($rows as $r) {
            $list[] = [
                'id'           => (int) $r['id'],
                'name'         => $r['name'],
                'lat'          => (float) $r['lat'],
                'lng'          => (float) $r['lng'],
                'photos'       => (int) $r['photos_count'],
                'thumbnail'    => $r['thumbnail'],
                'description'  => $r['description'],
                'pinLeftPct'   => (float) $r['pin_left_pct'],
                'pinTopPct'    => (float) $r['pin_top_pct'],
            ];
        }

        return json(['code' => 0, 'msg' => 'ok', 'data' => ['list' => $list]]);
    }
}