/**
* 获取评价列表 参数 userid 用户ID
*
* <p>返回值 true or false
*/
public void getPjList() {
Map<String, Object> resultMap = new HashMap<String, Object>();
String uid = this.getPara("uid");
String roleId = this.getPara("roleId");
if (StringUtil.isNull(uid) || StringUtil.isNull(roleId)) {
formatInvalidParamResponse(resultMap);
} else {
StringBuffer sb = new StringBuffer("select * from (select ");
sb.append(" aa.id,aa.user_id,aa.mer_id,aa.order_id, aa.qdr_id, aa.datetime, ");
sb.append(" aa.type,aa.content, aa.dync_mah, aa.dync_ser, aa.dync_spd, ");
sb.append(" aa.dync_val, aa.private AS privates,");
sb.append(" su.mc, am.mc mmc, ao.sn, aai.img_url from ");
if (CommonStaticData.USER_TYPE_MERCHANT.equals(roleId)) { // 商家
sb.append("(select * from ab_appraise where mer_id = '" + uid + "') aa ");
} else if (CommonStaticData.USER_TYPE_SERVICE.equals(roleId)) { // 司机
sb.append("(select * from ab_appraise where qdr_id = '" + uid + "') aa ");
} else { // 用户
sb.append("(select * from ab_appraise where user_id = '" + uid + "') aa ");
}
sb.append("left join sys_user su on aa.user_id = su.id ");
sb.append("left join ab_merchant am on aa.mer_id = am.id ");
sb.append("left join ab_order ao on aa.order_id = ao.id ");
sb.append("LEFT JOIN ab_appraise_img aai ON aai.app_id = ao.id ");
sb.append(") t where 1=1 ");
List<Record> apps = Db.find(sb.toString());
resultMap.put("plList", apps);
resultMap.put("result", RESULT_SUCCESS);
resultMap.put("msg", "评价列表获取成功");
}
renderJson(resultMap);
}
/*用户，商户增加补充证据*/
public void addcomplement() {
Map<String, Object> resultMap = new HashMap<String, Object>();
String userid = this.getPara("uid");
String orderId = this.getPara("orderid");
if (StringUtil.isNull(userid) || StringUtil.isNull(orderId)) {
formatInvalidParamResponse(resultMap);
} else {
String cbid = this.getPara("cbid");
String content = this.getPara("content");
String img_url = this.getPara("apyimg");
// 验证验证码
// 验证content
SysUser abuser = SysUser.dao.findById(userid);
AbOrderChargebackItem aoci = new AbOrderChargebackItem();
aoci.set(AbOrderChargebackItem.ID, StringUtil.getUuid32());
aoci.set(AbOrderChargebackItem.CBID, cbid);
aoci.set(AbOrderChargebackItem.UID, userid);
if (CommonStaticData.USER_TYPE_MEMBER.equals(abuser.get(SysUser.ROLE_ID))) {
aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_MEMBER);
} else if (CommonStaticData.USER_TYPE_MERCHANT.equals(abuser.get(SysUser.ROLE_ID))) {
aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_MERCHANT);
} else if (CommonStaticData.USER_TYPE_SERVICE.equals(abuser.get(SysUser.ROLE_ID))) {
aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_SERVICE);
}
aoci.set(AbOrderChargebackItem.CONTENT, content);
aoci.set(AbOrderChargebackItem.DATETIME, DateUtil.getCurrentDate());
if (img_url != null) {
FileInputStream file = null;
try {
file = new FileInputStream(PathKit.getWebRootPath() + "\\upload\\" + img_url);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
aoci.set(AbOrderChargebackItem.IMG_URL, img_url);
aoci.set(AbOrderChargebackItem.IMAGE, file);
}
aoci.save();
resultMap.put("result", RESULT_SUCCESS);
resultMap.put("msg", "维权成功,请耐心等待调解结果");
}
renderJson(resultMap);
}
/** 申请退单 */
public void addchargeback() {
SysUser abuser = this.getSessionAttr("abuser");
if (abuser == null || abuser.get("id") == null) {
redirect("/ab/login");
} else {
String inputRandomCode = this.getPara("backCaptchaCode");
String orderId = this.getPara("orderid");
String content = this.getPara("applyBackContent");
String img_url = this.getPara("apyimg");
Object objMd5RandomCode = this.getSessionAttr(CaptchaRender.DEFAULT_CAPTCHA_MD5_CODE_KEY);
// 验证验证码
if (!CaptchaRender.validate(objMd5RandomCode.toString(), inputRandomCode)) {
this.renderJson("1");
}
// 验证content
else if (StringUtil.isNull(content) || content.length() > 100) {
this.renderJson("2");
}
// 判断是否已经申请退单
else if (AbOrderChargeback.dao.findFirst(
"select * from ab_order_chargeback where order_id = '" + orderId + "'")
!= null) {
this.renderJson("3");
}
// 插入退单记录
else {
abuser = SysUser.dao.findById(abuser.get("id"));
AbOrder order = AbOrder.dao.findById(orderId);
AbOrderChargeback cb = new AbOrderChargeback();
cb.set(AbOrderChargeback.ID, StringUtil.getUuid32());
cb.set(AbOrderChargeback.MER_ID, order.getStr(AbOrder.MID));
cb.set(AbOrderChargeback.XDR_ID, order.getStr(AbOrder.XDRID));
cb.set(AbOrderChargeback.QDR_ID, order.getStr(AbOrder.QDRID));
cb.set(AbOrderChargeback.ORDER_ID, orderId);
cb.set(AbOrderChargeback.APPLY_ID, abuser.get(SysUser.ID));
cb.set(AbOrderChargeback.APPLY_DESC, content);
cb.set(AbOrderChargeback.APPLY_TIME, DateUtil.getCurrentDate());
cb.set(AbOrderChargeback.STATUS, CommonStaticData.CB_STATUS1);
// 申请人类型 1 用户 2商户 3业务员
if (CommonStaticData.USER_TYPE_MEMBER.equals(abuser.get(SysUser.ROLE_ID))) {
cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE1);
cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_MEMBER);
} else if (CommonStaticData.USER_TYPE_MERCHANT.equals(abuser.get(SysUser.ROLE_ID))) {
cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE2);
cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_MERCHANT);
} else if (CommonStaticData.USER_TYPE_SERVICE.equals(abuser.get(SysUser.ROLE_ID))) {
cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE8);
cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_SERVICE);
}
if (!StringUtil.isNull(img_url)) {
FileInputStream file = null;
try {
file = new FileInputStream(PathKit.getWebRootPath() + "\\upload\\" + img_url);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
cb.set(AbOrderChargeback.APPLY_IMG_URL, img_url);
cb.set(AbOrderChargeback.APPLY_IMG, file);
}
cb.save();
String sn = order.getStr("sn");
String userid = abuser.getStr("id");
String roleid = abuser.getStr("role_id");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String str_date = df.format(new Date());
Record record = new Record();
record.set("id", StringUtil.getUuid32());
record.set("user_id", userid);
record.set("role_id", roleid);
record.set("mes_title", "退单消息");
record.set("mes_type", "0");
record.set("isread", "0");
record.set("text", "申请退单成功！订单号：" + sn);
record.set("send_date", str_date);
Db.save("message", record);
this.renderJson("0");
}
}
}
/**
* 用户申请退单 参数 userid 用户ID orderid 订单ID content 描述 apyimg 图片路径
*
* <p>返回值 true or false
*/
public void addchargeback() {
Map<String, Object> resultMap = new HashMap<String, Object>();
String userid = this.getPara("uid");
String orderId = this.getPara("orderid");
String content = this.getPara("content");
String img_url = this.getPara("apyimg");
if (StringUtil.isNull(userid) || StringUtil.isNull(orderId) || StringUtil.isNull(content)) {
formatInvalidParamResponse(resultMap);
} else {
// 插入退单记录
SysUser abuser = SysUser.dao.findById(userid);
AbOrder order = AbOrder.dao.findFirst("SELECT * FROM ab_order WHERE sn='" + orderId + "' ");
if (order == null) {
order = AbOrder.dao.findFirst("SELECT * FROM ab_order WHERE id='" + orderId + "' ");
}
if (null == abuser || null == order) {
resultMap.put("result", RESULT_FAIL);
resultMap.put("msg", "数据异常,请稍后重试!");
} else {
AbOrderChargeback cb = null;
cb =
AbOrderChargeback.dao.findFirst(
"select * from ab_order_chargeback where order_id = '" + orderId + "'");
boolean flag = false;
if (cb == null) {
cb = new AbOrderChargeback();
cb.set(AbOrderChargeback.ID, StringUtil.getUuid32());
flag = true;
}
cb.set(AbOrderChargeback.ID, StringUtil.getUuid32());
cb.set(AbOrderChargeback.MER_ID, order.getStr(AbOrder.MID));
cb.set(AbOrderChargeback.XDR_ID, order.getStr(AbOrder.XDRID));
cb.set(AbOrderChargeback.QDR_ID, order.getStr(AbOrder.QDRID));
cb.set(AbOrderChargeback.ORDER_ID, orderId);
cb.set(AbOrderChargeback.APPLY_ID, abuser.get(SysUser.ID));
cb.set(AbOrderChargeback.APPLY_DESC, content);
cb.set(AbOrderChargeback.APPLY_TIME, DateUtil.getCurrentDate());
cb.set(AbOrderChargeback.STATUS, CommonStaticData.CB_STATUS1);
// 申请人类型 1 用户 2商户 3业务员
if (CommonStaticData.USER_TYPE_MEMBER.equals(abuser.get(SysUser.ROLE_ID))) {
cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE1);
cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_MEMBER);
} else if (CommonStaticData.USER_TYPE_MERCHANT.equals(abuser.get(SysUser.ROLE_ID))) {
cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE2);
cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_MERCHANT);
} else if (CommonStaticData.USER_TYPE_SERVICE.equals(abuser.get(SysUser.ROLE_ID))) {
cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE8);
cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_SERVICE);
}
if (!StringUtil.isNull(img_url)) {
FileInputStream file = null;
try {
file = new FileInputStream(PathKit.getWebRootPath() + "\\upload\\" + img_url);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
cb.set(AbOrderChargeback.APPLY_IMG_URL, img_url);
cb.set(AbOrderChargeback.APPLY_IMG, file);
}
if (flag) {
cb.update();
} else {
cb.save();
}
resultMap.put("result", RESULT_SUCCESS);
resultMap.put("msg", "维权成功,请耐心等待调解结果");
}
}
renderJson(resultMap);
}
/*用户，商户增加补充证据*/
public void addcomplement() {
SysUser abuser = this.getSessionAttr("abuser");
if (abuser == null || abuser.get("id") == null) {
redirect("/ab/login");
} else {
String cbid = this.getPara("cbid");
String inputRandomCode = this.getPara("comCaptchaCode");
String content = this.getPara("comContent");
String img_url = this.getPara("apyimg");
Object objMd5RandomCode = this.getSessionAttr(CaptchaRender.DEFAULT_CAPTCHA_MD5_CODE_KEY);
// 验证验证码
if (!CaptchaRender.validate(objMd5RandomCode.toString(), inputRandomCode)) {
this.renderJson("1");
}
// 验证content
else if (StringUtil.isNull(content) || content.length() > 100) {
this.renderJson("2");
} // 插入退单补充记录
else {
abuser = SysUser.dao.findById(abuser.get("id"));
AbOrderChargebackItem aoci = new AbOrderChargebackItem();
aoci.set(AbOrderChargebackItem.ID, StringUtil.getUuid32());
aoci.set(AbOrderChargebackItem.CBID, cbid);
aoci.set(AbOrderChargebackItem.UID, abuser.getStr(SysUser.ID));
if (CommonStaticData.USER_TYPE_MEMBER.equals(abuser.get(SysUser.ROLE_ID))) {
aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_MEMBER);
} else if (CommonStaticData.USER_TYPE_MERCHANT.equals(abuser.get(SysUser.ROLE_ID))) {
aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_MERCHANT);
} else if (CommonStaticData.USER_TYPE_SERVICE.equals(abuser.get(SysUser.ROLE_ID))) {
aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_SERVICE);
}
aoci.set(AbOrderChargebackItem.CONTENT, content);
aoci.set(AbOrderChargebackItem.DATETIME, DateUtil.getCurrentDate());
if (img_url != null) {
FileInputStream file = null;
try {
file = new FileInputStream(PathKit.getWebRootPath() + "\\upload\\" + img_url);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
aoci.set(AbOrderChargebackItem.IMG_URL, img_url);
aoci.set(AbOrderChargebackItem.IMAGE, file);
}
aoci.save();
String userid = abuser.getStr("id");
String roleid = abuser.getStr("role_id");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String str_date = df.format(new Date());
Record record = new Record();
record.set("id", StringUtil.getUuid32());
record.set("user_id", userid);
record.set("role_id", roleid);
record.set("mes_title", "退单消息");
record.set("mes_type", "0");
record.set("isread", "0");
record.set("text", "证据已补充！");
record.set("send_date", str_date);
Db.save("message", record);
this.renderJson("0");
}
}
}
