Method GetSql

class/projectModel/proxyModel.py:2011–2129

(self, get, result='1,2,3,4,5,8')

        return data

    def GetSql(self, get, result='1,2,3,4,5,8'):
        try:
            # 判断前端是否传入参数
            order = 'id desc'
            if hasattr(get, 'order'):
                # 验证参数格式
                if re.match(r"^[\w\s\-\.]+$", get.order):
                    order = get.order

            search_key = 'get_list'
            limit = 20
            if hasattr(get, 'limit'):
                limit = int(get.limit)
                if limit < 1: limit = 20

            if hasattr(get, 'result'):
                # 验证参数格式
                if re.match(r"^[\d\,]+$", get.result):
                    result = get.result
            import db
            SQL = db.Sql()
            data = {}
            # 取查询条件
            where = ''
            search = ''
            param = ()
            if hasattr(get, 'search'):
                search = get.search
                if sys.version_info[0] == 2: get.search = get.search.encode('utf-8')
                where, param = self.GetWhere(get.table, get.search)
                if get.table == 'sites' and get.search:
                    conditions = ''
                    if '_' in get.search:
                        cs = ''
                        for i in get.search:
                            if i == '_':
                                cs += '/_'
                            else:
                                cs += i
                        get.search = cs
                        conditions = " escape '/'"
                    pid = SQL.table('domain').where("name LIKE ?{}".format(conditions),
                                                    ("%{}%".format(get.search),)).getField('pid')
                    if pid:
                        if where:
                            where += " or id=" + str(pid)
                        else:
                            where += "id=" + str(pid)
            if get.table == 'sites':
                search_key = 'proxy'
                if where:
                    where = "({}) AND project_type='proxy'".format(where)
                else:
                    where = "project_type='proxy'"

                if hasattr(get, 'type'):
                    try:
                        type_id = int(get.type)