//司机wait单总数
public int waitNumOfDriver( long driver_id ) {
String in = "select A.order_id from t_driver_order as A where driver_id = "+driver_id+" and status = 6";
SqlExpressionGroup e1 = Cnd.exps( "driver_id" , "=", driver_id).
or( "order_id" , "in", in );
return dao.count( DriverOrder.class , Cnd.where( "status" , "=", 2).
and( e1 ).groupBy( "order_id" ) );
}
添加回复
请先登陆