Hugging Face's logo

Spaces:
flzta
/
yingyin
Paused

App Files Community
yingyin
File size: 2,596 Bytes 
a4a352b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
 
<?php

namespace app\api\controller;

use think\Db;
use think\Request;

class Link extends Base
{
    use PublicApi;
    public function __construct()
    {
        parent::__construct();
        $this->check_config();

    }

    public function index()
    {

    }

    /**
     *  获取列表
     *
     * @param Request $request
     * @return \think\response\Json
     */
    public function get_list(Request $request)
    {
        // 参数校验
        $param = $request->param();
        $validate = validate($request->controller());
        if (!$validate->scene($request->action())->check($param)) {
            return json([
                'code' => 1001,
                'msg'  => '参数错误: ' . $validate->getError(),
            ]);
        }
        // 查询条件组装
        $where = [];

        $offset = isset($param['offset']) ? (int)$param['offset'] : 0;
        $limit = isset($param['limit']) ? (int)$param['limit'] : 20;

        if (isset($param['id'])) {
            $where['link_id'] = (int)$param['id'];
        }

        if (isset($param['type'])) {
            $where['link_type'] = (int)$param['type'];
        }

        if (isset($param['sort'])) {
            $where['link_sort'] = (int)$param['sort'];
        }

        if (isset($param['name']) && strlen($param['name']) > 0) {
            $where['link_name'] = ['like', '%' . format_sql_string($param['name']) . '%'];
        }

        if (isset($param['time_end']) && isset($param['time_start'])) {
            $where['link_time'] = ['between', [(int)$param['time_start'], (int)$param['time_end']]];
        }elseif (isset($param['time_end'])) {
            $where['link_time'] = ['<=', (int)$param['time_end']];
        }elseif (isset($param['time_start'])) {
            $where['link_time'] = ['>=', (int)$param['time_start']];
        }

        // 数据获取
        $total = model('Link')->getCountByCond($where);
        $list = [];
        if ($total > 0) {
            // 排序
            $order = "link_time DESC";
            $field = '*';
            if (strlen($param['orderby']) > 0) {
                $order = 'link_' . $param['orderby'] . " DESC";
            }
            $list = model('Link')->getListByCond($offset, $limit, $where, $order, $field, []);
        }
        // 返回
        return json([
            'code' => 1,
            'msg'  => '获取成功',
            'info' => [
                'offset' => $offset,
                'limit'  => $limit,
                'total'  => $total,
                'rows'   => $list,
            ],
        ]);
    }
}