package com.ruoyi.vehicle.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ruoyi.vehicle.pojo.VehicleCost;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
import java.util.List;
|
import java.util.Map;
|
|
@Mapper
|
public interface VehicleCostMapper extends BaseMapper<VehicleCost> {
|
|
@Select("SELECT DATE_FORMAT(cost_date, '%Y-%m') as month, cost_type as costType, sum(amount) as totalAmount " +
|
"FROM p_vehicle_cost WHERE del_flag = '0' GROUP BY DATE_FORMAT(cost_date, '%Y-%m'), cost_type")
|
List<Map<String, Object>> summaryByMonth();
|
|
@Select("SELECT v.plate_number as plateNumber, c.cost_type as costType, sum(c.amount) as totalAmount " +
|
"FROM p_vehicle_cost c LEFT JOIN p_vehicle_info v ON c.vehicle_id = v.id " +
|
"WHERE c.del_flag = '0' GROUP BY v.plate_number, c.cost_type")
|
List<Map<String, Object>> summaryByVehicle();
|
}
|
