frontend-admin / Daocheng-Yading

<?php
declare(strict_types=1);

namespace app\controller\api;

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

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

        $list = [];
        foreach ($rows as $r) {
            $list[] = [
                'id'       => (int) $r['id'],
                'url'      => $r['image_url'],
                'title'    => $r['title'],
                'subtitle' => $r['subtitle'],
            ];
        }

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