def query_sms_send_info(start_time=None, end_time=None, phone=None, restaurant_id=None, card_num_tail=None, status=None): with walis_session() as session: query = session.query(NoticeRecord) if phone: query = query.filter(NoticeRecord.phone == phone) if restaurant_id: query = query.filter(NoticeRecord.restaurant_id == restaurant_id) if card_num_tail: query = query.filter(NoticeRecord.card_num_tail == card_num_tail) if status: query = query.filter(NoticeRecord.status == status) if not start_time: start_time = get_today_begin_time() if not end_time: end_time = get_today_end_time() query = query.filter(NoticeRecord.created_at > start_time).\ filter(NoticeRecord.created_at < end_time) return query.all()
def get_olpay_records(self, restaurant_id, type, begin_date, end_date): admin_id = self._get_admin_id(restaurant_id) if begin_date is None: begin_date = get_today_begin_time(return_timestamp=True) else: begin_date = self._get_hour0_timestamp(begin_date) if end_date is None: end_date = get_today_end_time(return_timestamp=True) else: end_date = self._get_hour24_timestamp(end_date) return self.restaurant_base.get_olpay_records( admin_id, begin_date, end_date, type)
def get_olpay_records(self, restaurant_id, type, begin_date, end_date): admin_id = self._get_admin_id(restaurant_id) if begin_date is None: begin_date = get_today_begin_time(return_timestamp=True) else: begin_date = self._get_hour0_timestamp(begin_date) if end_date is None: end_date = get_today_end_time(return_timestamp=True) else: end_date = self._get_hour24_timestamp(end_date) return self.restaurant_base.get_olpay_records(admin_id, begin_date, end_date, type)
def query_sms_send_count(start_time=None, end_time=None, status=None): with walis_session() as session: if not start_time: start_time = get_today_begin_time() if not end_time: end_time = get_today_end_time() query = session.query(func.count(NoticeRecord.record_id)).\ filter(NoticeRecord.created_at > start_time).\ filter(NoticeRecord.created_at < end_time) if status is not None: query = query.filter(NoticeRecord.status == status) return query.scalar()