要求：過期(分為庫(kù)存為0和超出有效時(shí)間)的商品排在下面，在售狀態(tài)的商品排在上面。之后再分別按照發(fā)布時(shí)間排序。
        Sql語(yǔ)句如下:
        select deadline, total_count, c_time  from (
            select *, 0 as ord from sale_goods where goods_type = 'sale-goods' and delete = false and total_count > 0 and deadline > now()
            union
            select *, 1 as ord from sale_goods where goods_type = 'sale-goods' and delete = false and (total_count <= 0 or deadline <= now())
        ) sale_goods_mall order by ord asc, c_time desc;
        :return:

        # 分頁(yè)
        pages = get_arg('pages', u'頁(yè)碼', default=1, parm_type=int)
        limit = get_arg('limit', u'條數(shù)', default=30, parm_type=int)
        
        # 總的數(shù)據(jù)sql
        sql_str = "select * from (" \
                  "select *, 0 as ord from sale_goods where goods_type = 'sale-goods' and delete = false and total_count > 0 and deadline > now()" \
                  "union " \
                  "select *, 1 as ord from sale_goods where goods_type = 'sale-goods' and delete = false and (total_count <= 0 or deadline <= now())" \
                  ") sale_goods_mall order by ord asc, c_time desc limit %d offset %d;" % (limit, limit * (pages - 1))

        # 在售的數(shù)據(jù)sql
        in_sale_sql = "select *, 0 as ord from sale_goods where goods_type = 'sale-goods' and delete = false and total_count > 0 and deadline > now();"
      
        # sqlalchemy執(zhí)行sql
        data_query = db.session.execute(sql_str)
        in_sale_query = db.session.execute(in_sale_sql)
        
        # 獲取查詢到的數(shù)據(jù)條數(shù)
        total = data_query.rowcount
        sale_total = in_sale_query.rowcount
        
        # fetchall()遍歷到所有數(shù)據(jù)
        data = {
            'total': total,
            'sale_total': sale_total,
            'sale_goods': [{
                'deadline': time_to_str(sale_goods['deadline'], only_date=True) or '',
                'id_no': sale_goods['id_no'] or '',
                'c_time': time_to_str(sale_goods['c_time'], only_date=True),
                'deadline_invalid': True if float(time.mktime(sale_goods['deadline'].timetuple())) < float(time.time()) else False
            }for goods in data_query.fetchall()]
        }