WaybillTable.joinLeft(TradeTable).on({ (w, t) =>
          w.aid.take(44) === t.aid.take(44) && w.buyerUid === t.buyerUid &&
            t.status.inSet(List(OrderStatus.waitSellerSendGoods.toString,
              OrderStatus.sellerConsignedPart.toString))
        }).joinLeft(TradeTable).on({
          case ((w, _), t) =>
            w.tid === t.tid
        }).groupBy(_._1._1.id).map({
          case (id, g) =>
            val wb = g.map(_._1._1)
            val t1 = g.map(_._1._2)
            val t2 = g.map(_._2)
            val pt = Case
              .If(t1.map(_.map(_.tid).isDefined).exists(identity)) // this line can't compile 
              .Then(t1.flatMap(_.map(_.payTime)).min) // this line can't compile too
              .Else(t2.flatMap(_.payTime).min.getOrElse(None)) // this line can't compile too

            (wb, pt)
        }).sortBy(_._2.desc)
          .drop((pi.page - 1) * pi.pageSize).take(pi.pageSize).result