| | |
| | | |
| | | public static final String CAR_INOUT_IN = "3306"; |
| | | public static final String CAR_INOUT_OUT = "3307"; |
| | | |
| | | public static final String CAR_TYPE_TEMP = "1003"; |
| | | public static final String CAR_TYPE_MONTH = "1001"; |
| | | private String inoutId; |
| | | private String machineId; |
| | | private String machineCode; |
| | |
| | | private String remark; |
| | | private String state; |
| | | |
| | | private String carType; |
| | | |
| | | public String getInoutId() { |
| | | return inoutId; |
| | |
| | | public void setState(String state) { |
| | | this.state = state; |
| | | } |
| | | |
| | | |
| | | public String getCarType() { |
| | | return carType; |
| | | } |
| | | |
| | | public void setCarType(String carType) { |
| | | this.carType = carType; |
| | | } |
| | | |
| | | } |
| | |
| | | private long hours; |
| | | private long min; |
| | | |
| | | private String carType; |
| | | |
| | | |
| | | private Date createTime; |
| | | |
| | |
| | | public void setPaIds(String[] paIds) { |
| | | this.paIds = paIds; |
| | | } |
| | | |
| | | public String getCarType() { |
| | | return carType; |
| | | } |
| | | |
| | | public void setCarType(String carType) { |
| | | this.carType = carType; |
| | | } |
| | | } |
| | |
| | | **/ |
| | | public class CarInoutDetailPo implements Serializable { |
| | | |
| | | |
| | | |
| | | private String detailId; |
| | | private String inoutId; |
| | | private String communityId; |
| | |
| | | |
| | | private String remark; |
| | | private String state; |
| | | |
| | | private String carType; |
| | | |
| | | public String getDetailId() { |
| | | return detailId; |
| | |
| | | public void setState(String state) { |
| | | this.state = state; |
| | | } |
| | | |
| | | public String getCarType() { |
| | | return carType; |
| | | } |
| | | |
| | | public void setCarType(String carType) { |
| | | this.carType = carType; |
| | | } |
| | | } |
| | |
| | | <!-- 保存车辆进出明细信息 add by wuxw 2018-07-03 --> |
| | | <insert id="saveCarInoutDetailInfo" parameterType="Map"> |
| | | insert into car_inout_detail( |
| | | inout_id,machine_id,machine_code,car_inout,pa_id,detail_id,car_num,community_id,remark,state |
| | | inout_id,machine_id,machine_code,car_inout,pa_id,detail_id,car_num,community_id,remark,state,car_type |
| | | ) values ( |
| | | #{inoutId},#{machineId},#{machineCode},#{carInout},#{paId},#{detailId},#{carNum},#{communityId},#{remark},#{state} |
| | | #{inoutId},#{machineId},#{machineCode},#{carInout},#{paId},#{detailId},#{carNum},#{communityId},#{remark},#{state},#{carType} |
| | | ) |
| | | </insert> |
| | | |
| | |
| | | select t.inout_id,t.inout_id inoutId,t.machine_id,t.machine_id machineId,t.machine_code,t.machine_code |
| | | machineCode,t.car_inout,t.car_inout carInout,t.pa_id,t.pa_id paId,t.detail_id,t.detail_id |
| | | detailId,t.car_num,t.car_num carNum,t.status_cd,t.status_cd statusCd,t.community_id,t.community_id communityId,t.state, |
| | | ci.in_time inTime,ci.out_time outTime,max(cip.real_charge) realCharge,ci.pa_id paId,td.name stateName,t.remark |
| | | ci.in_time inTime,ci.out_time outTime,max(cip.real_charge) realCharge,ci.pa_id paId,td.name stateName,t.remark,t.car_type carType |
| | | from car_inout_detail t |
| | | left join car_inout ci on t.inout_id = ci.inout_id and ci.status_cd = '0' and t.community_id = ci.community_id |
| | | left join car_inout_payment cip on cip.inout_id = ci.inout_id and cip.community_id = ci.community_id |
| | |
| | | </if> |
| | | <if test="carNum !=null and carNum != ''"> |
| | | and t.car_num= #{carNum} |
| | | </if> |
| | | <if test="carType !=null and carType != ''"> |
| | | and t.car_type= #{carType} |
| | | </if> |
| | | <if test="statusCd !=null and statusCd != ''"> |
| | | and t.status_cd= #{statusCd} |
| | |
| | | </if> |
| | | <if test="carNum !=null and carNum != ''"> |
| | | , t.car_num= #{carNum} |
| | | </if> |
| | | <if test="carType !=null and carType != ''"> |
| | | , t.car_type= #{carType} |
| | | </if> |
| | | <if test="communityId !=null and communityId != ''"> |
| | | , t.community_id= #{communityId} |
| | |
| | | <if test="carNum !=null and carNum != ''"> |
| | | and t.car_num= #{carNum} |
| | | </if> |
| | | <if test="carType !=null and carType != ''"> |
| | | and t.car_type= #{carType} |
| | | </if> |
| | | <if test="statusCd !=null and statusCd != ''"> |
| | | and t.status_cd= #{statusCd} |
| | | </if> |
| | |
| | | <select id="getCarInoutInfo" parameterType="Map" resultType="Map"> |
| | | select t.in_time,t.in_time inTime,t.inout_id,t.inout_id inoutId,t.pa_id,t.pa_id paId,t.car_num,t.car_num |
| | | carNum,t.status_cd,t.status_cd statusCd,t.state,t.community_id,t.community_id communityId,t.out_time,t.out_time |
| | | outTime,td.`name` stateName |
| | | outTime,td.`name` stateName,max(cid.car_type) carType |
| | | from car_inout t |
| | | LEFT JOIN car_inout_detail cid on t.inout_id = cid.inout_id and cid.status_cd = '0' and cid.state in ('100300','100400','100600') |
| | | left join t_dict td on t.state = td.status_cd and td.table_columns='state' and td.table_name = 'car_inout' |
| | | where 1 =1 |
| | | <if test="inTime !=null and inTime != ''"> |
| | |
| | | <if test="carNum !=null and carNum != ''"> |
| | | and t.car_num= #{carNum} |
| | | </if> |
| | | <if test="carType !=null and carType != ''"> |
| | | and cid.car_type= #{carType} |
| | | </if> |
| | | <if test="statusCd !=null and statusCd != ''"> |
| | | and t.status_cd= #{statusCd} |
| | | </if> |
| | |
| | | <if test="outTime !=null and outTime != ''"> |
| | | and t.out_time= #{outTime} |
| | | </if> |
| | | group by t.in_time,t.inout_id,t.pa_id,t.car_num,t.status_cd,t.state,t.community_id,t.out_time,td.`name` |
| | | order by t.create_time desc |
| | | <if test="page != -1 and page != null "> |
| | | limit #{page}, #{row} |
| | |
| | | @Java110Cmd(serviceCode = "machineTranslate.machineUploadCarLog") |
| | | public class MachineUploadCarLogCmd extends Cmd { |
| | | |
| | | public static final int CAR_TYPE_MONTH = 0; //月租车 |
| | | public static final int CAR_TYPE_MONTH = 1001; //月租车 |
| | | public static final int CAR_TYPE_SUB = 1; //成员车辆 |
| | | public static final int CAR_TYPE_TEMP = 2; //临时车辆 |
| | | public static final int CAR_TYPE_TEMP = 1003; //临时车辆 |
| | | public static final int CAR_TYPE_NO_DATA = 3; //没有数据 |
| | | |
| | | public static final String TEMP_CAR_OWNER = "临时车车主"; |
| | |
| | | if (OwnerCarDto.CAR_TYPE_TEMP.equals(ownerCarDtos.get(0).getCarTypeCd())) { |
| | | tempCar = CAR_TYPE_TEMP; |
| | | } |
| | | // 月租车过期 后就是临时车 |
| | | if (ownerCarDtos.get(0).getEndTime().before(DateUtil.getCurrentDate())) { |
| | | tempCar = CAR_TYPE_TEMP; |
| | | } |
| | | } |
| | | |
| | | |
| | | //进场处理 |
| | | if (MachineDto.DIRECTION_IN.equals(machineDtos.get(0).getDirection())) { |
| | |
| | | carInoutDetailPo.setPaId(paId); |
| | | carInoutDetailPo.setRemark(reqJson.getString("remark")); |
| | | carInoutDetailPo.setState(state); |
| | | carInoutDetailPo.setCarType(tempCar == CAR_TYPE_NO_DATA ? CAR_TYPE_TEMP + "" : tempCar + ""); |
| | | int flag = carInoutDetailV1InnerServiceSMOImpl.saveCarInoutDetail(carInoutDetailPo); |
| | | if (flag < 1) { |
| | | throw new CmdException("保存出记录明细失败"); |
| | |
| | | carInoutDetailPo.setPaId(carInoutDtos.get(0).getPaId()); |
| | | carInoutDetailPo.setRemark(reqJson.getString("remark")); |
| | | carInoutDetailPo.setState(state); |
| | | carInoutDetailPo.setCarType(tempCar == CAR_TYPE_NO_DATA ? CAR_TYPE_TEMP + "" : tempCar + ""); |
| | | int flag = carInoutDetailV1InnerServiceSMOImpl.saveCarInoutDetail(carInoutDetailPo); |
| | | |
| | | if (flag < 1) { |
| | |
| | | carInoutDetailPo.setPaId(paId); |
| | | carInoutDetailPo.setState(state); |
| | | carInoutDetailPo.setRemark(reqJson.getString("remark")); |
| | | carInoutDetailPo.setCarType(tempCar == CAR_TYPE_NO_DATA ? CAR_TYPE_TEMP + "" : tempCar + ""); |
| | | flag = carInoutDetailV1InnerServiceSMOImpl.saveCarInoutDetail(carInoutDetailPo); |
| | | |
| | | if (flag < 1) { |