| | |
|---|
| | | wrapper.selectAll(Orders.class) |
|---|
| | | .select("s1.name", Orders::getDepositShopName) |
|---|
| | | .select("s1.address", Orders::getDepositShopAddress) |
|---|
| | | .select("s1.telephone", Orders::getDepositShopLinkPhone) |
|---|
| | | .select("s1.link_phone", Orders::getDepositShopLinkPhone) |
|---|
| | | .select("s2.name", Orders::getTakeShopName) |
|---|
| | | .select("s2.address", Orders::getTakeShopAddress) |
|---|
| | | .select("s2.telephone", Orders::getTakeShopLinkPhone) |
|---|
| | | .select("s2.link_phone", Orders::getTakeShopLinkPhone) |
|---|
| | | .select("c1.other_field as c2OtherField") |
|---|
| | | .select("c1.name as goodTypeName") |
|---|
| | | .select("IF(EXISTS(SELECT 1 FROM orders_detail od JOIN category c3 ON c3.id = od.LUGGAGE_ID AND c3.TYPE = 4 AND c3.OTHER_FIELD = '1' WHERE od.ORDER_ID = t.ID AND od.DELETED = 0), 1, 0) as hasOversized") |
|---|
