| | |
|---|
| | | @Select("SELECT a.*,b.name as temp FROM t_order_task a LEFT JOIN t_customer b ON a.customer_id=b.id ${ew.customSqlSegment} ") |
|---|
| | | @Results({@Result(column="temp", property="customerName", jdbcType = JdbcType.VARCHAR)}) |
|---|
| | | List<OrderTask> list2(@Param(Constants.WRAPPER) QueryWrapper<OrderTask> wrapper2); |
|---|
| | | |
|---|
| | | @Select("SELECT sum(num) FROM t_order_task") |
|---|
| | | int sumNum(); |
|---|
| | | |
|---|
| | | @Select("SELECT count(id) FROM t_order_task where status=#{arg0}") |
|---|
| | | int sumStatus(int type); |
|---|
| | | |
|---|
| | | @Select("SELECT count(id) FROM t_order_task where likes=1") |
|---|
| | | int countLike(); |
|---|
| | | } |
|---|
