| | |
|---|
| | | @Select("SELECT sum(num) FROM t_order_task where area_id=#{arg0} and DATE_FORMAT(send_date,'%Y-%m-%d')=#{arg1}") |
|---|
| | | Integer sum(String areaId, String format); |
|---|
| | | |
|---|
| | | @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)}) |
|---|
| | | @Select("SELECT a.*,b.name as temp,b.linker as temp2 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), |
|---|
| | | @Result(column="temp2", property="code", jdbcType = JdbcType.VARCHAR)}) |
|---|
| | | List<OrderTask> list2(@Param(Constants.WRAPPER) QueryWrapper<OrderTask> wrapper2); |
|---|
| | | |
|---|
| | | @Select("SELECT sum(num) FROM t_order_task") |
|---|
| | |
|---|
| | | @Select("SELECT count(id) FROM t_order_task where likes=1") |
|---|
| | | int countLike(); |
|---|
| | | |
|---|
| | | @Select("select b.car_no as carNo1,c.name as name1,d.name as name2,count(a.area_section_id) as num1,sum(case when a.status=0 then 1 else 0 end) as num2 ,sum(case when a.status=1 then 1 else 0 end) as num3 from t_order_task a LEFT JOIN t_car b on a.car_id=b.id LEFT JOIN t_area c on a.area_id=c.id LEFT JOIN t_area_ection d on a.area_section_id=d.id where DATE_FORMAT(a.send_date,'%Y-%m-%d')=#{date} GROUP BY a.area_section_id,b.car_no,c.name,d.name") |
|---|
| | | @Select("select b.car_no as carNo1,c.name as name1,d.name as name2,count(a.area_section_id) as num1,sum(case when a.status=0 then 1 else 0 end) as num2 ,sum(case when a.status=1 then 1 else 0 end) as num3 from t_order_task a LEFT JOIN t_car b on a.car_id=b.id LEFT JOIN t_area c on a.area_id=c.id LEFT JOIN t_area_ection d on a.area_section_id=d.id where DATE_FORMAT(a.send_date,'%Y-%m-%d')=#{date} GROUP BY a.area_section_id,b.car_no,c.name,d.name order by c.name asc") |
|---|
| | | @Results({@Result(column="carNo1", property="carNo", jdbcType = JdbcType.VARCHAR), |
|---|
| | | @Result(column="name1", property="areaName", jdbcType = JdbcType.VARCHAR), |
|---|
| | | @Result(column="name2", property="areaSectionName", jdbcType = JdbcType.VARCHAR), |
|---|
