package cn.cetc54.platform.zhyl.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import cn.cetc54.platform.zhyl.entity.Order;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 订单数据处理层
|
* @author
|
*/
|
public interface OrderMapper extends BaseMapper<Order> {
|
/**
|
* 获取某个区域的服务项目的个数
|
* @param areaId
|
* @return
|
*/
|
@Select("<script>" +
|
"select detail,count(*) as num " +
|
"from" +
|
"(select detail,person_id " +
|
"from t_yl_order " +
|
"<where>" +
|
" <if test='areaId!= null'>" +
|
"and area_id=#{areaId} " +
|
" </if>" +
|
"</where>" +
|
"GROUP BY detail,person_id) t " +
|
"GROUP BY detail ORDER BY num desc" +
|
"</script>")
|
List<Map<String,Object>> getTypeStatics(@Param("areaId") String areaId);
|
@Select("<script>" +
|
"select count(*) as num " +
|
"from t_yl_order o " +
|
"left join t_yl_fuwu_person p " +
|
"on o.person_id=p.id " +
|
"where p.org_fw_Id=#{orgId}" +
|
"</script>")
|
int getOrderNum(@Param("orgId") String orgId);
|
|
}
|
