| | |
| | | import com.kidgrow.common.service.impl.SuperServiceImpl; |
| | | import com.kidgrow.common.utils.EncryptUtils; |
| | | import com.kidgrow.oprationcenter.mapper.PartnerDockingInfoMapper; |
| | | import com.kidgrow.oprationcenter.model.PartnerDockingInfo; |
| | | import com.kidgrow.oprationcenter.model.PartnerInfo; |
| | | import com.kidgrow.oprationcenter.model.ProductOrder; |
| | | import com.kidgrow.oprationcenter.model.ProductOrderRecord; |
| | | import com.kidgrow.oprationcenter.model.*; |
| | | import com.kidgrow.oprationcenter.service.IPartnerDockingInfoService; |
| | | import com.kidgrow.oprationcenter.service.IPartnerInfoService; |
| | | import com.kidgrow.oprationcenter.service.IProductOrderRecordService; |
| | | import com.kidgrow.oprationcenter.service.IProductOrderDetailService; |
| | | import com.kidgrow.oprationcenter.service.IProductOrderService; |
| | | import com.kidgrow.usercenter.feign.SysDepartmentService; |
| | | import com.kidgrow.usercenter.feign.SysDoctorService; |
| | |
| | | IProductOrderService productOrderService; |
| | | |
| | | @Autowired |
| | | IProductOrderRecordService productOrderRecordService; |
| | | IProductOrderDetailService productOrderDetailService; |
| | | |
| | | /** |
| | | * 列表 |
| | |
| | | orderMap.put("order_id", productOrder.getId()); |
| | | orderMap.put("enabled", 1); |
| | | orderMap.put("is_del", 0); |
| | | List<ProductOrderRecord> productOrderRecordList = productOrderRecordService.listByMap(orderMap); |
| | | List<ProductOrderDetail> productOrderDetailList = productOrderDetailService.listByMap(orderMap); |
| | | |
| | | if ((productOrderRecordList != null) && (productOrderRecordList.size() > 0)) { |
| | | if ((productOrderDetailList != null) && (productOrderDetailList.size() > 0)) { |
| | | |
| | | for (i = 0; i < productOrderRecordList.size(); i++) { |
| | | ProductOrderRecord productOrderRecord = productOrderRecordList.get(i); |
| | | createTime = "'" + dateTimeFormat.format(productOrderRecord.getCreateTime()) + "'"; |
| | | updateTime = (productOrderRecord.getUpdateTime() == null) ? "NULL" : "'" + dateTimeFormat.format(productOrderRecord.getUpdateTime()) + "'"; |
| | | for (int j = 0; j < productOrderDetailList.size(); j++) { |
| | | ProductOrderDetail productOrderDetail = productOrderDetailList.get(j); |
| | | createTime = "'" + dateTimeFormat.format(productOrderDetail.getCreateTime()) + "'"; |
| | | updateTime = (productOrderDetail.getUpdateTime() == null) ? "NULL" : "'" + dateTimeFormat.format(productOrderDetail.getUpdateTime()) + "'"; |
| | | serviceSQL += "INSERT INTO order_detail VALUES( " + |
| | | productOrderRecord.getId() + ", " + |
| | | productOrderRecord.getOrderId() + ", " + |
| | | productOrderRecord.getProId() + ", " + |
| | | productOrderRecord.getProType() + ", " + |
| | | "'" + productOrderRecord.getProName() + "', " + |
| | | productOrderRecord.getAilightCount() + ", " + |
| | | productOrderRecord.getRecordCount() + ", " + |
| | | "'" + dateFormat.format(productOrderRecord.getProBegintime()) + "', " + |
| | | "'" + dateFormat.format(productOrderRecord.getProEndtime()) + "', " + |
| | | productOrderRecord.getIsShare() + ", " + |
| | | productOrderDetail.getId() + ", " + |
| | | productOrderDetail.getOrderId() + ", " + |
| | | productOrderDetail.getProId() + ", " + |
| | | productOrderDetail.getProType() + ", " + |
| | | "'" + productOrderDetail.getProName() + "', " + |
| | | productOrderDetail.getAilightCount() + ", " + |
| | | productOrderDetail.getRecordCount() + ", " + |
| | | "'" + dateFormat.format(productOrderDetail.getProBegintime()) + "', " + |
| | | "'" + dateFormat.format(productOrderDetail.getProEndtime()) + "', " + |
| | | productOrderDetail.getIsShare() + ", " + |
| | | "0, 0, " + |
| | | // 服务验证字符串【合作商ID、医院ID、科室ID、产品ID、开始日期、结束日期、读片数量、报告数量、已使用读片数量、已使用报告数量】 |
| | | "'" + EncryptUtils.encryptAES((partnerDockingInfo.getPartnerId().toString() + "|" + |
| | | partnerDockingInfo.getHospitalId().toString() + "|" + |
| | | partnerDockingInfo.getDepartmentId().toString() + "|" + |
| | | productOrderRecord.getProId().toString() + "|" + |
| | | dateFormat.format(productOrderRecord.getProBegintime()) + "|" + |
| | | dateFormat.format(productOrderRecord.getProEndtime()) + "|" + |
| | | productOrderRecord.getAilightCount().toString() + "|" + |
| | | productOrderRecord.getRecordCount() + "|" + |
| | | productOrderDetail.getProId().toString() + "|" + |
| | | dateFormat.format(productOrderDetail.getProBegintime()) + "|" + |
| | | dateFormat.format(productOrderDetail.getProEndtime()) + "|" + |
| | | productOrderDetail.getAilightCount().toString() + "|" + |
| | | productOrderDetail.getRecordCount() + "|" + |
| | | "0|0"), SecurityConstants.AES_KEY) + "', " + |
| | | productOrderRecord.getIsDel() + ", " + |
| | | productOrderRecord.getEnabled() + ", " + |
| | | productOrderDetail.getIsDel() + ", " + |
| | | productOrderDetail.getEnabled() + ", " + |
| | | createTime + ", " + |
| | | productOrderRecord.getCreateUserId() + ", " + |
| | | "'" + productOrderRecord.getCreateUserName() + "', " + |
| | | productOrderDetail.getCreateUserId() + ", " + |
| | | "'" + productOrderDetail.getCreateUserName() + "', " + |
| | | updateTime + ", " + |
| | | productOrderRecord.getUpdateUserId() + ", " + |
| | | "'" + productOrderRecord.getUpdateUserName() + "' " + |
| | | productOrderDetail.getUpdateUserId() + ", " + |
| | | "'" + productOrderDetail.getUpdateUserName() + "' " + |
| | | ");\n\r"; |
| | | } |
| | | } else { |
| | |
| | | return dbSql; |
| | | } |
| | | |
| | | ; |
| | | } |