| | |
| | | package cn.exrick.xboot.your.mapper; |
| | | |
| | | import cn.exrick.xboot.your.entity.AddOil; |
| | | import cn.exrick.xboot.your.entity.OrderStatusCount; |
| | | import cn.exrick.xboot.your.entity.Suggest; |
| | | import cn.exrick.xboot.your.vo.Month; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | |
| | | * 订单表数据处理层 |
| | | * @author whj |
| | | */ |
| | | //@Repository |
| | | public interface OrderTaskMapper extends BaseMapper<OrderTask> { |
| | | |
| | | @Select("SELECT sum(num) FROM t_order_task where area_id=#{arg0} and DATE_FORMAT(send_date,'%Y-%m-%d')=#{arg1}") |
| | |
| | | |
| | | @Select("SELECT o.*,c.name as customerName FROM t_order_task o LEFT JOIN t_customer c ON o.customer_id=c.id") |
| | | IPage<OrderTask> page2(Page initMpPage); |
| | | |
| | | @Select("SELECT o.*,c.name as customerName FROM t_order_task o LEFT JOIN t_customer c ON o.customer_id=c.id ${ew.customSqlSegment}") |
| | | IPage<OrderTask> page3(Page initMpPage,@Param(Constants.WRAPPER) QueryWrapper<OrderTask> wrapper); |
| | | |
| | | List<OrderStatusCount> countStatus( OrderStatusCount orderStatusCount); |
| | | } |