Method get_project_list

class/projectModel/javaModel.py:3517–3618

@name 取项目列表 @author lkq<2021-08-27> @param domain 域名 @return string

(self, get)

        return ret
    
    def get_project_list(self, get):
        '''
        @name 取项目列表
        @author lkq<2021-08-27>
        @param  domain 域名
        @return string
        ''&#x27;
        if not 'p' in get:  get.p = 1
        if not 'limit' in get: get.limit = 20
        if not 'callback' in get: get.callback = ''
        if not 'order' in get: get.order = 'id desc'
        type_id = None
        if "type_id" in get:
            try:
                type_id = int(get.type_id)
            except:
                type_id = None
        
        if 'search' in get:
            get.project_name = get.search.strip()
            search = "%{}%".format(get.project_name)
            if type_id is None:
                count = public.M('sites').where(
                    'project_type=? AND (name LIKE ? OR ps LIKE ?)',
                    ('Java', search, search)
                    ).count()
                data = public.get_page(count, int(get.p), int(get.limit), get.callback)
                data['data'] = public.M('sites').where(
                    'project_type=? AND (name LIKE ? OR ps LIKE ?)',
                    ('Java', search, search)
                    ).limit(
                    data['shift'] + ',' + data['row']
                ).order(get.order).select()
            else:
                count = public.M('sites').where(
                    'project_type=? AND (name LIKE ? OR ps LIKE ?) AND type_id = ?',
                    ('Java', search, search, type_id)
                    ).count()
                data = public.get_page(count, int(get.p), int(get.limit), get.callback)
                data['data'] = public.M('sites').where(
                    'project_type=? AND (name LIKE ? OR ps LIKE ?) AND type_id = ?',
                    ('Java', search, search, type_id)
                    ).limit(
                    data['shift'] + ',' + data['row']
                ).order(get.order).select()
        
        else:
            if type_id is None:
                count = public.M('sites').where('project_type=?', 'Java').count()
                data = public.get_page(count, int(get.p), int(get.limit), get.callback)
                data['data'] = public.M('sites').where('project_type=?', 'Java').limit(
                    data['shift'] + ',' + data['row']
                ).order(get.order).select()
            else:
                count = public.M('sites').where('project_type=? AND type_id = ?', ('Java', type_id)).count()
                data = public.get_page(count, int(get.p), int(get.limit), get.callback)
                data['data'] = public.M('sites').where('project_type=? AND type_id = ?', ('Java', type_id)).limit(
                    data['shift'] + ',' + data['row']