Пример #1
0
 def get_shop_list(shop_type=None,cat=None,price_range=None,trade_mark_style=None,region=None,\
     trade_mark_transfer=None, is_all_red=None, is_no_punishment=None, sort=None, page=1,per_page=5):
     price_ranges=[(0,3),(3,5),(5,10),(10,20),(20,30),(30,50),(50,1000)]
     shop_type_filter=Shop.shop_type==shop_type if shop_type else None
     price_filter=Shop.price.between(price_ranges[price_range][0],price_ranges[price_range][1])\
         if price_range in [0,1,2,3,4,5,6] else  None
     category_filter=Shop.category==cat if cat else  None
     region_filter=Shop.region==region if region else  None
     trade_mark_filter=Trademark.mark_type==trade_mark_style if trade_mark_style else  None
     trade_mark_transfer_filter = Trademark.transfer==trade_mark_transfer if trade_mark_transfer else None
     is_all_red_filter = Shop.is_all_red==True if is_all_red else None
     is_no_punishment_filter = Shop.is_no_punishment==True if is_no_punishment else None
     multi_filter=[]
     for i in [shop_type_filter,category_filter,price_filter,region_filter,trade_mark_filter,\
         trade_mark_transfer_filter,is_all_red_filter,is_no_punishment_filter]:
         if i:
             multi_filter.append(i)
     if multi_filter:
         if trade_mark_filter or trade_mark_transfer_filter:
             query = Shop.select().join(Trademark).where(*multi_filter)
         else:
             query = Shop.select().where(*multi_filter)
     else:
         query =Shop.select()
     # 排序
     if sort == 'time':
         query = query.order_by(Shop.level.desc(), Shop.created_datetime.desc())
     elif sort == 'price':
         query = query.order_by(Shop.price.asc(), Shop.level.desc())
     # 分页
     shops =query.paginate(page=page,paginate_by=per_page)
     return {
         'code': 0,
         'total_count':query.count(),
         'data': [q.get_display_data() for q in shops],
         'message': u'正常'
     }
Пример #2
0
def list_shops(bot: Bot, update: Update) -> None:
    logger.debug("Entering: list_shops")

    chat = update.effective_chat  # type: Chat
    msg = update.effective_message  # type: Message
    usr = update.effective_user  # type: User

    responses = []

    with orm.db_session:
        shops = dbShop.select(lambda s: s).order_by(dbShop.kind,
                                                    dbShop.ownerCastle)
        num = shops.count()
        for page in range(1, ceil(num / config.RESULT_SIZE) + 1):
            response = ''
            for shop in shops.page(page, pagesize=config.RESULT_SIZE):
                response += f'<a href="https://t.me/share/url?url=/ws_{shop.link}">{shop.kind}{shop.name}</a> '
                response += f'<i>{shop.mana}💧</i> by <b>{shop.ownerCastle}{shop.ownerName}</b>'
                response += '\n\n'
            responses.append(response)

    for response in responses:
        msg.reply_text(response, parse_mode='HTML')
Пример #3
0
 def getById(id):
     return Shop.select().where(Shop.id == id)
Пример #4
0
 def find(keyword):
     return Shop.select().where(Shop.name.contains(keyword))
Пример #5
0
 def getAll():
     return Shop.select()